Boyapati Sivanjaneyulu
Data Analyst
Bangalore, IN.About
A highly analytical and proactive Data Analyst specializing in e-commerce, eager to leverage advanced Excel, SQL, and reporting tools to drive strategic insights in the lifestyle consumer products sector. Adept at designing interactive dashboards, automating MIS reports, and developing robust forecasting models to enhance data-driven decision-making and identify growth opportunities.
Work
Bangalore, Karnataka, India
→
Summary
Currently serving as an MIS Analyst for Indies Technologies Pvt Ltd, supporting Reliance (Ajio) by designing and maintaining critical data analysis and reporting infrastructure to drive strategic and operational decision-making.
Highlights
Designed and currently maintaining interactive dashboards utilizing Pivot Tables, slicers, charts, and conditional formatting to streamline management reporting for a major e-commerce client.
Applied advanced Excel functions, including VLOOKUP, INDEX-MATCH, IFERROR, and nested formulas, for comprehensive data cleaning, reconciliation, and analysis of large datasets.
Developed and implemented monthly business performance trackers, scorecards, and variance reports to actively monitor key KPIs and compare actuals against targets.
Automated MIS reports on sales, inventory, and product performance using Power Query and formula-driven workflows, significantly reducing manual effort and enhancing reporting efficiency.
Extracted and analyzed extensive datasets through SQL queries and Excel to support critical day-to-day business operations and fulfill ad-hoc reporting requirements.
Created and refined forecasting and budgeting models in Excel, providing foundational tools for trend analysis and strategic business planning.
Ensured data accuracy, consistency, and compliance by conducting rigorous data validation, error-checking, and adhering to governance and audit standards.
Collaborated cross-functionally to gather precise reporting requirements and deliver tailored data solutions, fostering informed decision-making across departments.
Education
Languages
English
Telugu
Skills
Data Analysis & Reporting
Advanced Excel (Pivot Tables, VLOOKUP, HLOOKUP, SUMIFS, INDEX-MATCH), MIS Reporting, Excel Dashboards, Power Query, Automation via Macros, Forecasting, Budgeting, Trend Analysis, Business Planning, Data Validation, Error-Checking, KPI Monitoring, Variance Reporting.
Database Management
SQL Server, SSMS, DDL/DML/TCL Operations, Data Mapping, Data Integration, Relational Databases, Data Consistency, Data Integrity, SQL Queries.
Professional Skills
Problem Solving, Quick Learning, Decision Making, Adaptability, Positive Attitude, Cross-functional Collaboration, Communication, Presentation of Insights.