Pavan Ambare
Business Analyst
Based in Bengaluru,Karnataka
About
Business Planning Analyst at HP specializing in automation-driven analytics and business intelligence. I use VBA, SQL, and Python to streamline workflows, analyze large datasets, and uncover insights that drive planning and performance improvements. I build Power BI and Tableau dashboards that enable leadership and cross-functional teams to monitor KPIs and make data-driven decisions. Known for collaborating closely with stakeholders to align analytics initiatives with business goals and convert complex data into actionable strategies.
Skills
Projects
Experience
December 2022- May 2024
Business Analyst at Unnati
Analyzed large datasets using Python and SQL to support demand forecasting and business planning initiatives. Improved forecast accuracy by 15% through data analysis and pattern identification across key business units. Automated recurring reports using Excel VBA and Macros, reducing reporting turnaround time by 40%. Built Power BI dashboards to visualize revenue trends, cost drivers, and regional performance for leadership teams. Delivered data-driven insights that supported ₹25L+ in cost optimization initiatives. Recognized as “Data Champion” (Q1 2024) for delivering high-impact analytical insights.
2024-Present
Business Planning Analyst
Perform enterprise-level data analysis using Python, SQL, and Excel to support planning, forecasting, and operational decision-making. Automate repetitive reporting and data preparation workflows using Excel VBA and Python, reducing manual effort and improving data accuracy. Design and maintain Python- and SQL-based ETL pipelines for weekly and monthly inventory data processing, loading cleaned data into SQL Server tables. Build and maintain interactive Power BI dashboards that track KPIs and performance metrics for leadership and cross-functional teams. Analyze large datasets to identify trends, patterns, and performance gaps, translating insights into actionable business recommendations. Collaborate with stakeholders to gather requirements and align analytics outputs with business o
Education
May 2023-May 2024
Post Graduate Program in Data Science and Business Analytics
The Post Graduate Program in Data Science and Business Analytics (PGP DSBA) is an intensive, comprehensive program designed to equip students with the skills and knowledge required to succeed in the field of data science and business analytics. The program typically covers a wide range of topics, Statistics and Probability ,Data Cleaning and Preparation ,Data Exploration and Visualization, Business Analytics and Decision Making, Case Studies and Projects. Python, SQL, IDE, Tableau, Power BI, Exploratory Data Analysis, Supervised Learning Unsupervised Learning, Natural Language Processing, MS Word, MS Excel
2014-2018
B.E/B.Tech
KLE Dr. M.S.Sheshgiri College of Engineering and Technology,Belgavi,Karnataka