Oct 2024 – Jun 2025 · 8 mos · Mumbai, Maharashtra, India · On-site

• Pharmaceuticals and Life Sciences- 💊 Capsule Manufacturing
• Conducted secondary market research to estimate capsule market growth in the North America region.
• Developed an early warning system to minimize customer churn and enhance retention by identifying key performance indicators (KPIs) signaling a customer’s intent to switch vendors (Hunting vs. Farming strategy).
• Drafted the monthly Balanced Scorecard and Functional Scorecard for all departments within the capsule manufacturing division.
• Designed a strategic initiative tracker to monitor the status of on-track and off-track strategic projects.
• Formulated a strategic roadmap in response to the U.S. Trump Administration’s tariffs on Indian exports.
• Planning of a proactive counter-strategy to defend ACG Capsules’ market share in non-North American regions against aggressive pricing from Chinese manufacturers, who are constrained by high tariffs in North America.
• Assessment of the critical factors for enabling the successful execution of combo deals (capsule and machine contracts) in APAC, Europe, and the Middle East & Africa, mirroring the proven success in LATAM and North America.

Dec 2021 – Sep 2024 · 2 yrs 9 mos · Kolkata, West Bengal, India · On-site

• Project A: As a technology strategist
• Led Functional and Nonfunctional Requirement Gathering for design of Power BI interactive reporting dashboard for FMCG customers.
• Data Migration Business Analyst for migration of FMCG data from legacy customer data-servers to in-house designed Reporting Platform.
• Designed as-is and to-be process flow diagrams using Microsoft Visio, requirements elucidation, integration of third-party systems for reporting data migration and dashboard preparation.
• PwC India certified in Power BI reporting and dashboard generation.
• Project B: As a business analyst
• Conducted requirement gathering sessions for Power BI dashboards.
• Prepared the business requirements document for the stakeholders and the functional specification document with the developer team
• Scheduled daily scrum meetings with the Power BI developer team to implement the functional aspects as per client’s requirements
• After incorporating the final requirements by the client based on the reviews from the sprints, the same was delivered for final production
• Project C: As a Power BI based application developer
• Conducted requirement gathering sessions and prepared the business requirement documents.
• After the requirements were signed off, the project scope was decided with the respective stakeholders and the functional specification documents were prepared.
• Created SQL queries to gather data from different sources
• Started the Power BI dashboard development process once the required data pipelines were defined. Used DAX queries for data preparation and time intelligence DAX functions were used to manipulate the financial quarters.

Sep 2020 – Oct 2021 · 1 yr 1 mo · Dehradun, Uttarakhand, India · On-site

• Course coordinator for MBA General Management at UPES, Dehradun.
• Member of the UPES team in National Assessment and Accreditation Council (NAAC), India.
• Conduct sessions in Energy Analytics, Business Analytics, Industry 4.0, and Digital Business.
• Faculty mentor of Entrepreneurship cell - UPES

Jun 2013 – Jul 2013 · 1 mo · Daejeon, South Korea · On-site