Sitaram
Ranipool
Summary
Business & Data Analyst | Excel, Power BI, SQL, Dashboard Developer | Turning Data into Decisions | Process Optimization | Analytics Storyteller | SAP S/4HANA | Data Visualization Expert.
Overview
15
15
years of professional experience
Work History
Sr. Executive Production
Sun Pharma Laboratories Ltd.
Ranipool
07.2017 - Current
- Led data visualization initiatives using Excel, Power BI, Google Sheets, and Looker Studio to support production and quality operations.
- Developed dashboards for batch size optimization, reducing waste and improving productivity.
- SME in SAP S/4HANA PP; trained end-users and managed material master data.
- Implemented QMS protocols including change control, deviation, CAPA, and investigations.
- Used Ripik Optimus for production scheduling and process improvement.
- Collaborated with cross-functional teams to launch new products and streamline operations.
- A multi-product limited Pharma Company having 40 (API & finished dose) manufacturing facilities around the India.
Senior Production Officer
Alkem Laboratories Ltd.
Sikkim
03.2015 - 06.2017
- Worked in Compression capsule and Coating section.
Production Officer
Glenmark Pharmaceuticals Ltd.
Sikkim
01.2013 - 02.2015
- Worked in Granulation section.
Production Officer
Hetero Labs Ltd.
Baddi
08.2010 - 12.2012
- Worked in Compression and Granulation section.
Education
Bachelor of pharmecy -
Rameshwaram Institute of Technology
01.2010
Intermediate - Science (Bio Stream)
DAV NIC
01.2004
Skills
- Excel (Advanced functions, Pivot Tables, Power Query)
- Power BI (DAX, Data Modeling, Visualization)
- SQL (Joins, Aggregations, Queries)
- Looker Studio
- Google Sheets
- Dashboard Development
- Data Cleaning & Transformation
- Business Intelligence Tools
- Data Storytelling
- Python (Basics for analytics)
- SAP S/4HANA PP
- Ripik Optimus
- Google form
Accomplishments
- Handling 800+ nos. of product master data in SAP for current organization.
- SAP HANA PP module project implementation at site.
- SAP training for internal member.
- Batch size increase for 10+ nos. of products per year.
- New product launch approx 20 products/year from feasibility to execution.
- Yield improvement for more than 10 products every year.
Audit Faced
- WHO
- UGANDA
- CDSCO
Languages
- English
- Hindi
- English
Hobbies and Interests
- Playing and watching cricket
- Listening to music
Disclaimer
I hereby declare that the all the above-mentioned information are correct up to my knowledge and I bear the responsibility for the correctness of the mentioned particulars.
Addresses
Building No-1A, Room no-406, Sun residential complex, Ranipool, Sikkim, 737135, Vill- Parasiya, Post-Khanuchhapara, Kushinagar, Uttar Pradesh, 274306
Personal Information
- Passport Number: Z6545737
- Father's Name: Khedan
- Date of Birth: 04/05/85
- Gender: Male
- Nationality: Indian
- Marital Status: Married
Timeline
Sr. Executive Production
Sun Pharma Laboratories Ltd.
07.2017 - Current
Senior Production Officer
Alkem Laboratories Ltd.
03.2015 - 06.2017
Production Officer
Glenmark Pharmaceuticals Ltd.
01.2013 - 02.2015
Production Officer
Hetero Labs Ltd.
08.2010 - 12.2012
Bachelor of pharmecy -
Rameshwaram Institute of Technology
Intermediate - Science (Bio Stream)
DAV NIC