Varun Prasad Gangarapu
Hyderabad
Summary
A Data Analyst having a total 9.5 years of experience on Power BI Desktop, Power BI Service, T-SQL, Microsoft Business Intelligence (MSBI) Power BI development having equal competence in Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS). Having a total 6.5 years of experience in working on creating visualizations, Dashboards, reports using Power BI Desktop, Power BI Service, Tableau Desktop and Tableau Server. Have experience in working on Azure SQL Database, Snowflake Database, MS SQL, Oracle SQL Database, Salesforce, Service Now, Application Insights, creating data flows in Azure Data Factory (ADF) in Microsoft Azure and Microsoft Fabric.
Overview
10
10
years of professional experience
Work History
Software Developer
Advance Auto Parts (AIIC)
Hyderabad
12.2022 - Current
- Individual Contributor Responsible for developing New Power BI reports, New Snowflake SQL queries, Oracle SQL Queries, Salesforce reports, conducting Data Research, working with Field Teams, updating interactive dashboards, Apps, migrating reports, optimizing data models and BI reports, data cleaning, data modeling, providing administrative support for Power BI and Maintenance support on existing reports
- Managing strategic projects with multiple stakeholder interaction
- Handling various ad-hoc requests from stakeholders and translating it into data-oriented solutions
- Pro Scorecard - Developed a performance credit ranking system for Customer Account Managers (CAMs) based on regional and territory sales, enabling VPPs, CSMs, and other strategic leaders to make data-driven decisions
- This initiative contributed to a 9% increase in sales in the fiscal year 2024
- CSM/CAM Scorecard - Delivered detailed insights into sales performance across multiple dimensions, including category, programs, customer segments, enrollments, manager-approved discounts, tool & equipment sales, and store-level performance under each Customer Account Manager (CAM)
- These insights empowered leadership with data-driven decision-making to optimize sales strategies
- Customer Summary - Developed a customer tracking system for Customer Account Managers (CAMs) to monitor accounts on a weekly, periodic, and quarterly basis
- This system enabled CAMs to identify underperforming customers with high sales potential, allowing for targeted engagement strategies to drive increased revenue 12%
- CAM Visits - Provides details insight on how many customers CAMs are visited and which Topics they have selected to make the customer do more sales
- This analysis helped CAMs engagement strategies and improve sales performance 9%
- Developed a dashboard that enabled leadership teams to focus on customers segmented by profession who were not actively making sales
- This tool helped identify underperforming customers within their respective industries, allowing for targeted engagement to increase sales and ensure timely, accurate product purchases with expedited delivery
- Built Developed a dashboard that enabled the leadership team to identify and engage customers who had made purchases in previous years but had no sales activity this year
- This strategic insight helped leaders re-engage and retain 19% of these customers, driving increased revenue by 9%
- Built a real-time Co-Pilot data model in Power BI Service, enabling Customer Account Managers (CAMs) to access sales insights using natural language queries anytime, anywhere
- This real-time Power BI model enabling natural language queries, reducing manual reporting efforts by 30 hours per month
Data Analyst
Optum Global Solutions Private Limited
Hyderabad
08.2020 - 12.2022
- Individual Contributor Responsible for developing New Power BI reports, New Tableau Reports, Oracle SQL Queries, Azure SQL Database conducting Data Research, updating interactive dashboards, Apps, migrating reports, optimizing data models and BI reports, data cleaning, data modeling, providing administrative support for Power BI and Maintenance support on existing reports
- Managing strategic projects with multiple stakeholder interaction
- Handling various ad-hoc requests from stakeholders and translating it into data-oriented solutions
- Implemented a tracking system to monitor key incident management metrics, including opened incidents, workload distribution, knowledge usage, reopened cases, First Contact Resolution (FCR), First Level Resolution (FLR), Service Level Objective (SLO) compliance, and Mean Time to Restore (MTTR)
- This system provided actionable insights to enhance service efficiency and incident resolution increased to 23.1%
- Developed a tracking system to monitor trends in products, assignment groups, knowledge issues, resolutions, departments, and articles
- Enabled YOY comparisons, product volume analysis (MTD, QTD, YTD), period-over-period differences, and frequent callers by LOB and product, enhancing decision-making and efficiency
- Built a 3-year historical dashboard for NPS Team to track NPS, CSAT%, survey trends, and customer segments (promoters, passives, defectors)
- Enabled MoM, WoW, QoQ, and YoY comparisons, along with agent and caller tracking for deeper insights
- Designed a real-time live report for Product groups IMT to monitor high-trending products with UCL and LCL
- Products exceeding the upper control limit trigger alerts, displaying percentage changes from the last hour, 4-hour average, 8-hour average, and last week's average, enabling proactive decision-making
BI Developer
Precision Air Private Limited
Hyderabad
01.2019 - 01.2020
- Creating and Optimizing Power BI, Tableau and Excel reports for material storage and daily material acquisition to assist management in making financial and inventory decision
- Conducting Profit and Loss Analysis, Material Procurement Analysis, and Project planning
- Developed and optimized stored procedures in MS SQL to extract, transform, and retrieve data based on stakeholder requirements
- Ensured efficient data pulls for reporting, analysis, and enhancing performance of database queries
- Ability to find the Quantities of Products, High procurement Materials, High Purchase of Materials, and Purchase Control over Materials based on Sales
- Ability to find the High Sales by Year, Quarter, Month, and Weekly, YOY Comparisons over Sales, Agent Sales Record, Total Sales and Anomalies Trends in Sales
Project Design Engineer
Avirbhava Infratech India Private Limited
Hyderabad
10.2017 - 12.2018
- Comprehensive Project Analyses Reports for end-to-end project planning, manpower control, and product buy-out planning in Creating Power bi and Excel reports
- Client Management, Vendor Management, Technical Support, Design Support, Project Budget Control, Design and Approve, Project Coordination, Quality Inspection, Material Procurement, Project completion and Handover
- Optimizing SQL Queries by analysing the execution plan and added the necessary indexes to all the source tables for query optimization which had reduced the runtime of the query down to 40 minutes from 60 minutes
- Optimized Power BI reports and Dashboards to improve Performance of visuals and reduce the Load time of the report page
Project Design Engineer
Integrated Cleanroom Technologies Private Limited
Hyderabad
02.2015 - 09.2017
- HVAC Designing, Documentation DQ, IQ, OQ and PQ, Vendor Management, Technical Assistance, Training and Development Program, Project execution and Project Completion
- Providing Detail ongoing Projects insight through Excel and Power BI
- Providing Weekly, Monthly, Quarterly and Yearly reports to stakeholders and help support Ad-hoc requests from Stakeholders
- Established and supported the Power BI Service environment, enabling report creation, publishing, and sharing in a centralized platform
- This streamlined access for stakeholders, enhancing productivity for managers and engineers by providing real-time insights in one location
- Developed the SSRS reports and created the required Email subscriptions for the clients for their daily reports on Coupon redemption KPI's
- Provided Client with new functionality and approaches for solutions
Education
Bachelor of Technology - Mechanical Engineering
PFEC
12.2014
Skills
- Power BI
- Tableau
- Power Apps
- Salesforce reporting
- DAX
- M Query
- Data modeling
- Predictive analysis
- Trend Analysis
- Microsoft Fabric
- Python
- SQL
- ETL
- Data Integration
- Big Data Processing
- Power BI Service Administration
- Microsoft 365
- Collaboration tools
- Technical documentation
- Standardization
- Executive stakeholder collaboration
- Data Strategy
Websites
Timeline
Software Developer
Advance Auto Parts (AIIC)
12.2022 - Current
Data Analyst
Optum Global Solutions Private Limited
08.2020 - 12.2022
BI Developer
Precision Air Private Limited
01.2019 - 01.2020
Project Design Engineer
Avirbhava Infratech India Private Limited
10.2017 - 12.2018
Project Design Engineer
Integrated Cleanroom Technologies Private Limited
02.2015 - 09.2017
Bachelor of Technology - Mechanical Engineering
PFEC
Similar Profiles
Nizamuddeen HANizamuddeen HA
Human resources officer at AIICHuman resources officer at AIIC
Mohammed Aliuddin AhmedMohammed Aliuddin Ahmed
Senior Financial Analyst at Advance Auto Parts,Inc.(Retailer Automotive Parts)Senior Financial Analyst at Advance Auto Parts,Inc.(Retailer Automotive Parts)
Tyler WrightTyler Wright
NA at Mobile Parts Professional, Advance Auto PartsNA at Mobile Parts Professional, Advance Auto Parts