Abhi Devgirikar

Client-Facing Business Analyst with over 4 years of experience driving data-driven decisions within the Ecommerce sector through advanced analytics. Proficient in requirement gathering, technical solution design, functional analysis, and stakeholder engagement throughout the project lifecycle. Skilled in Python, MySQL, Excel, Power BI, and statistics. Seeking opportunities in Data Analytics, and I am extremely passionate about exploring and working on opportunities relevant to data analytics.

• Data Analysis
• Data Manipulation
• Data Visualization
• Problem Solving
• Pricing Analysis
• Statistics
• Communication

Cricket

Capturing Moments

Project 1 : Business Performance automated report.

Client Name : Leading Ecommerce for kid’s fashion brand.

Environment/Tools : Python, Pandas, Numpy, MySQL, Jupyter.

Description : Developed an automated emailer for Revenue, Buying, Finance and Marketing Team to track eCommerce business performance across multiple levels. This report includes key metrics related to the Revenue, Margins, Traffic, Inventory and Marketing performance. This enables clients to make informed decision & optimize their business operations.

Project 2 : Revenue MTD Dashboard.
Client Name : Leading Ecommerce for kid’s fashion brand.
Environment/Tools : Python, Pandas, Numpy, MySql, Power Bi, Jupyter.
Description : Developed a dashboard for the Planning and Revenue teams to monitor Month-to-Date (MTD) business KPIs across multiple dimensions, including category, product type, and gender. This tool provides real-time insights, enabling the planning team to assess whether business performance aligns with monthly objectives and strategies.

Project 3 : Customer Retention Dashboard. 

Client Name : Leading Ecommerce for Pharmaceuticals.

Environment/Tools : Python, MySql, Power Bi.
Description : Monitored customer retention for acquired users by creating and analyzing cohorts. This approach enabled tracking of orders and Gross Merchandise Value (GMV) from retained users, providing valuable insights into the effectiveness of customer retention strategies such as promotional codes. It also helped in targeting chronic customers within the right time frame.