Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Sachindeo Ram

Data Analyst
Navi Mumbai

Summary

Highly analytical and process-oriented data analyst with extensive experience in big data capture, curation, manipulation, and visualization. Skilled at providing valuable insights, analytics, and business intelligence to drive corporate growth and enhance process improvement. Proficient in utilizing advanced analytical tools and techniques to support data-driven decision-making.

Overview

18
18
years of professional experience
6
6
years of post-secondary education
5
5
Certifications
2
2
Languages

Work History

Deputy Manager - Strategy and Projects

Reliance Retail Netmeds
Navi Mumbai
02.2022 - Current
  • Spearheaded analytics, dashboard creation and automation for B2C, B2B and Netmeds Stores
  • Enhanced sales performance, delivery turnaround time (TAT) and margins through comprehensive data analysis and system upgrades
  • Developed dynamic trackers to monitor inventory levels and logistics processes, optimize stock management, ensure timely deliveries, and enhance overall supply chain efficiency
  • Aggregated unstructured data to build business dashboards, leading to significant improvements in margin and order delivery TAT
  • Collaborated with cross-functional teams to drive business growth and achieve corporate objectives.

Key Projects:

  • Sales Revenue Dashboard: Developed a Power BI dashboard to track and analyze sales revenue.
  • Purchase Rate Correction: Ensured accurate pricing and cost management through rate corrections.
  • Intake Margin Tracker: Monitored and analyzed intake margins for profitability.
  • Gross Margin Tracker: Tracked gross margins to provide financial insights.
  • RFM Analysis: Enhanced customer retention with RFM analysis.
  • Inventory Tracker: Created a Power BI tracker for inventory management.
  • Hyper local Delivery TAT Modelling: Automated delivery turnaround time for efficiency.
  • Logistic Shipment Tracker: Improved supply chain visibility and decision-making.
  • GRN Modelling: Streamlined inventory and procurement with GRN modeling

Assistant Manager, Sales Force Excellence

Cipla Ltd
Mumbai
09.2018 - 02.2022
  • Created analytical reports and dashboards to evaluate salesforce and product performance.
  • Collaborated with leadership for monthly micro-segment tracker reviews.
  • Managed Business Health Card for monthly review and governance meetings.

Key Projects:

  • Sales and Field Efforts Dashboard using Power Query and Excel: Created a dashboard to evaluate sales and field efforts, enhancing performance tracking.
  • Reaching the Last Mile - Emails to TMs: Developed an email campaign to improve communication and reach with Territory Managers (TMs) resulting in Doctor visit by 5%

Business Analyst, Market Research & Forecasting

Cipla Ltd
Mumbai
04.2013 - 08.2018
  • Produced market research reports and recommended strategic actions based on findings.
  • Conducted in-depth reviews of sales data and utilized reference data from agencies like IQVIA resulted in increase of market share trend by 0.5%
  • Engaged in team meetings to share insights, tackle challenges, and develop solutions.
  • Developed high-quality documentation to support training efforts, helping employees fully understand new systems and procedures.

Senior Quality Analyst

Kaizen Global Services
Navi Mumbai
02.2007 - 07.2012
  • Ensured quality and compliance for US sales process resulted in high quality of sales by 5%
  • Conducted training and performance reviews.
  • Designed induction and training programs for internal/external clients.

Education

Bachelor of Commerce - Commerce

Mumbai University
Mumbai
04.2004 - 01.2010

Skills

  • Business Intelligence & Analysis: Market Research, Business Analysis, Critical Thinking

  • Market Research: Proficient in conducting market research and forecasting to support strategic decision-making

  • Cross-functional Collaboration: Experience in working with teams to rectify system issues and enhance business processes

  • Data Analysis & Visualization: Expertise in collecting, cleaning, and analyzing large datasets; creating reports and dashboards using Power BI, Power Query, and Excel

  • Technical Proficiency: MS Office, Co-Pilot AI

  • Additional Skills: Data Interpretation and Reporting, Competitor Analysis, Inventory Control Procedures

Certification

Masterclass - Advance Power BI

Timeline

Power Query
02-2025
Masterclass - Advance Power BI
04-2024
Tableau
04-2024
Basic to Advanced Excel
02-2024

Introduction to generative AI

11-2023

Deputy Manager - Strategy and Projects

Reliance Retail Netmeds
02.2022 - Current

Assistant Manager, Sales Force Excellence

Cipla Ltd
09.2018 - 02.2022

Business Analyst, Market Research & Forecasting

Cipla Ltd
04.2013 - 08.2018

Senior Quality Analyst

Kaizen Global Services
02.2007 - 07.2012

Bachelor of Commerce - Commerce

Mumbai University
04.2004 - 01.2010
Sachindeo RamData Analyst