Codebasics Logo

Powered by
Codebasics DA Bootcamp

Home

About

Projects

Experience

Certificates

Contact
Hello, I am

Kamlesh Shahapure

Data analyst with 2 yrs' experience
Resume
Kamlesh Shahapure

1

Excel
Project

1

PowerBI
Project

1

SQL
Project

About

Me

From Electrical Engineering to Data Insights: A Story of Passion and Discovery

Initially, I pursued a career in electrical engineering, but I soon discovered my true passion lay in data analysis and business intelligence. I'm now a skilled data analyst with expertise in Excel, Power BI, and SQL. My experience has equipped me to drive business growth, improve operational efficiency, and inform strategic decision-making.

Over the past two years, I've worked on numerous projects in the Nielsen India, developing my skills in data analysis and business intelligence. My portfolio showcases my work on various business projects, demonstrating my ability to effectively communicate complex data insights and drive business results. I'm excited to bring my skills and passion for data analysis to a new role and contribute to the success of your organization.

Key

Skills

Power BI

SQL

Data Analytics

Business Analytics

Report Building

Problim Solving

Business Acumen

My

Projects

Expenses P&L Report - AtliQ Hardware
Expenses P&L Report - AtliQ Hardware

Domain/Function: Data Analysis

Expense P&L Report - AtliQ Hardware

Project Overview:
The Expense P&L Report is a critical project that provides a comprehensive and accurate picture of AtliQ Hardware's financial performance, enabling informed business decisions.

See My Work Excel
BI - 360
BI - 360

Domain/Function: Financial Planning and Analysis (FP&A) - AtliQ Hardware

Develop and implement a Financial Planning and Analysis (FP&A) solution using BI 360 to enhance financial planning, budgeting, forecasting, and analysis capabilities.

See My Work PowerBI
Finance Planning and Analytics for AtliQ Hardware using SQL
Finance Planning and Analytics for AtliQ Hardware using SQL

Domain/Function: Financial Planning and Analysis (FP&A) - AtliQ Hardware

Developed a comprehensive SQL-based Finance report with insights on top customers, products, and regions, alongside supply chain analytics to optimize operations and drive data-driven decision-making.

See My Work SQL

My

Experience

Nielsen India, Bengaluru – Modeling Analyst – Marketing Mix Modeling

  • Managed marketing mix modeling projects for ITC India, L'Oréal India, Mondelez Japan, and Rivalea Australia, optimizing marketing budgets and strategies to enhance ROI by up to 20%.
  • Performed ROI analysis on diverse marketing elements, crafting econometric models to quantify the impact of marketing and pricing strategies, leading to a 15% increase in overall marketing efficiency.
  • Engineered pricing models within a price elasticity framework, advising targeted price adjustments that increased revenue by 10% while preserving profit margins.
  • Conducted market basket analysis to refine product offerings, maintaining revenue and profit levels, and achieving a 5% cost reduction without impacting sales.
  • Created customized analytics solutions, including regression models to estimate cannibalization and halo effects, enabling strategic decisions that drove a 12% improvement in cross-product sales.

Awards

& Certificate

Excel: Mother of Business Intelligence

Excel: Mother of Business Intelligence

Power BI Data Analytics for All Levels 2.0

Power BI Data Analytics for All Levels 2.0

Post Graduation Program in Data Analytics

Post Graduation Program in Data Analytics

SQL Beginner to Advanced For Data Professionals

SQL Beginner to Advanced For Data Professionals