Mukesh Amballa

Experience

1. Data Analyst

   LifeCell International Pvt.Ltd

   Dec 2021 — Present · Mumbai, IN

   Automation & Dashboard Development: Spearhead automation initiatives across Sales, Finance, Costing, CN Dashboards, and more, transitioning manual tasks to automated solutions using Excel, Power BI, AWS, Power Automate, SharePoint, and OneDrive. Lead end-to-end dashboard development—from requirement gathering to deployment—including regular updates and stakeholder reporting (e.g, PDF automation via Power Automate)•Business Analysis & Stakeholder Collaboration: Act as a Business Analyst, interfacing with cross-functional teams (Sales, Lab Management, Finance, etc.) to gather requirements, resolve data discrepancies, and deliver insights tailored to business needs.•Data Management & Insights: Manage end-to-end data collection, interpretation, and database maintenance to support business operations. Provide actionable insights to Business Heads, Marketing Managers, and Training Teams to drive strategic decision-making.•Sales & Client Analysis: Conduct deep-dive analysis on key client segments (Active, Inactive, Lost), using cohort analysis to monitor retention patterns, client behavior over time, and performance trends. Track Per Capita Per Month (PCPM), Average Rate Per Test (ARPT), and apply segmentation techniques to optimize targeting and revenue generation.•KPI & Performance Metrics: Design and track Key Performance Indicators (KPIs), sales performance metrics, and incentive evaluation reports (e.g, LAC, RAC, person-wise and product-wise performance) to inform compensation strategies and drive diagnostics team performance.•Sales Trend & Forecasting Analysis: Analyze historical sales data to identify trends, support forecasting models, and contribute to strategic planning.•Reporting & Presentations: Prepare and present data-driven reports and dashboards on sales trends and performance to senior management for strategic decision-making.Tools- •Excel & Power Point•Power BI•Power Automate•Excel Power Query•Google Sheet, Doc, Slides & Form

Education

• Vidyalankar Institute Of Technology

  MMS

  2014 — 2016

• Mumbai University

  Bachelor of Science (BSc)

  2010 — 2013