Ramesh Shukla
Data Analyst
New Delhi
Summary
Data Analyst with 9+ YOE in FMCG, Commercial Excellence industries, turning complex data into actionable insights. Skilled in forecasting, planning, and analytics using Advance Excel, SQL, Power BI and Pandas to drive strategic decisions and business growth.
Overview
10
10
years of professional experience
Work History
Business Analyst
Abbott
01.2025 - Current
- Developed strategic account plans by analyzing hospital and physician potential.
- Segment healthcare professionals and accounts, prioritize high-value accounts and physicians based on potential, behavior, and geography, to optimize targeting strategies.
- Monitor primary and secondary sales, and evaluate sales to assess performance trends, identify gaps, and support the achievement of business goals.
- Analyzed sales to calculate quarterly rewards and recognition.
- I built a business review analysis for monthly review meetings by model, therapy, technology, etc. For the monthly review meeting.
- Responsible for creating various analysis models for campaigns conducted when new models are launched.
Data Analyst
Leo Burnett
11.2020 - 01.2025
- Report Oversight: Proficiently manage daily, weekly, monthly, and ad-hoc reports. ensure data accuracy and report hygiene by addressing queries and verifying reports created by the MIS team.
- Performance Evaluation: Conduct regular assessments of Target vs Achievement reports on a weekly basis and Provide valuable feedback to management to drive improvements and meet targets.
- Discrepancy Resolution: Perform monthly Shortfall Analyses to identify and close the gap between current performance levels and expected outcomes.
- Workforce Data Management: Accountable for monitoring Attendance, Productivity, and generating both weekly and monthly analysis reports. Manage and analyze data for the complete workforce across PAN India.
Data Analyst
DS Group
11.2019 - 06.2020
- Conduct an in-depth analysis of pertinent business and competitor data in the market.
- Provide valuable statistical inputs, and facilitate the annual budget preparation process.
- Handle periodic reports to the reporting authority, and the reception, processing, verification, and reconciliation of vendor invoices.
- Undertake responsibility for generating ad-hoc reports, as assigned by the HOD.
- Maintain detailed documentation of invoices and associated documents for future reference.
Data Analyst
Leo Burnett
08.2018 - 11.2019
- Report Oversight: Proficiently manage daily, weekly, monthly, and ad-hoc reports. Ensure data accuracy and report hygiene by addressing queries and verifying reports created by the MIS team.
- Performance Evaluation: Conduct regular assessments of Target vs Achievement reports on a weekly basis
- Provide valuable feedback to management to drive improvements and meet targets.
- Discrepancy Resolution: Perform monthly Shortfall Analyses to identify and close the gap between current performance levels and expected outcomes.
- Workforce Data Management: Accountable for monitoring Attendance, Productivity, and generating both weekly and monthly analysis reports.
- Manage and analyze data for the complete workforce across PAN India.
MIS Executive
Denave India
06.2016 - 08.2018
- Report Oversight: Proficiently manage daily, weekly, monthly, and ad-hoc reports. Ensure data accuracy and report hygiene by addressing queries and verifying reports created by the MIS team.
- Performance Evaluation: Conduct regular assessments of Target vs Achievement reports on a weekly basis
- Provide valuable feedback to management to drive improvements and meet targets.
- Discrepancy Resolution: Perform monthly Shortfall Analyses to identify and close the gap between current performance levels and expected outcomes.
- Workforce Data Management: Accountable for monitoring Attendance, Productivity, and generating both weekly and monthly analysis reports.
- Manage and analyze data for the complete workforce across PAN India.
Education
Bachelor of Arts -
Dr. RML Avadh University
Ayodhya06.2011
Skills
Advanced Excel
SQL
Power BI
Python - Pandas
Power Query
Data Visualization
Analytical and Research Skills
Data Analysis & Business Intelligence
Timeline
Business Analyst
Abbott
01.2025 - Current
Data Analyst
Leo Burnett
11.2020 - 01.2025
Data Analyst
DS Group
11.2019 - 06.2020
Data Analyst
Leo Burnett
08.2018 - 11.2019
MIS Executive
Denave India
06.2016 - 08.2018
Bachelor of Arts -
Dr. RML Avadh University