Aug 2024 – Oct 2024 · 2 mos · Mumbai, Maharashtra, India · On-site

• Analyzed daily Assets under Management (AUM), new customer acquisitions, and fluctuations in key business metrics to identify trends and anomalies, improving early detection of business shifts.
• Gained hands-on experience in Excel-based reporting, including advanced formulas, pivot tables, and data visualization techniques, enhancing report accuracy and turnaround time.
• Supported business development by delivering actionable insights to drive strategic decisions and improve reporting efficiency, contributing to data-driven growth planning.

Jan 2024 – Feb 2024 · 1 mo · Navi Mumbai, Maharashtra, India · On-site

• Conducted in-depth profitability analysis for chemical products and customers using PowerBI leveraging DAX functions for advanced calculations. Helped in managing the project lifecycle from data collection to visualization, employing project management methodologies to ensure timely delivery. Delivered insights into costs, revenue, and product/customer performance, thereby optimizing decision-making and significantly saving time and effort compared to the previous monthly Excel reporting process.
• Automated and streamlined chemical product ageing analysis and raw materials cost analysis in Tableau, adhering to stringent security standards leveraging robust data modeling techniques facilitating real-time updates on finished goods, raw materials, work in progress, and providing branch-specific cost insights. This has resulted in a substantial reduction in reporting time and man-hours.
• Analyzed primary and secondary packaging charges in the Growth and Transformation Department, demonstrating adept technical problem-solving skills while adhering to rigorous documentation standards, deriving actionable insights on cost per unit, identifying high-cost packaging types. Developed an automated dashboard to visualize monthly cost variations, aiding organizational decision-making for cost optimization strategies.

Apr 2023 – Jun 2023 · 2 mos · Navi Mumbai, Maharashtra, India · On-site

• Net Promoter score for performance optimization: Developed and implemented a dynamic Net Promoter Score (NPS)-based Performance Management System. Leveraged Tableau Server and Excel for interactive dashboards, integrating Novanet for real-time updates. Analyzed and visualized employee satisfaction, meeting dynamics, and NPS scores across departments and leadership levels.
• Travel cost Analysis: Led a data integration project merging HR-managed claims with third-party flight data demonstrating an analytical thought process. Employed Tableau Server, Python, and Excel for impactful visualizations in travel expense optimization. Demonstrated advanced proficiency in data integration and HR analytics for strategic data driven decision-making.
• Communication expense analysis: Made a data-driven approach in communication expense management, fostering stakeholder interaction through collaborative insights sharing. Created a robust Tableau dashboard with statistical analysis for strategic decision-making. Processed a complex dataset, highlighting expertise in data cleaning, integration, and actionable insights delivery.
• Learning gap analysis: Led the creation of a dynamic Tableau dashboard, utilizing advanced analytics to demonstrate the strategic value of HR Development Need projects. Transformed a dataset into actionable insights, showcasing adept transition management, talent development, and data-driven decision-making for organizational growth.

Nov 2022 – Dec 2022 · 1 mo · Mumbai · Remote

• 1) Got an opportunity to make an HR Individual performance dashboard & Dhangyan Program Timeline Dashboard
• 2) My Work majorly Comprised Cleaning a large dataset and Merging the different datasets into one single master sheet with the help of python , MS - Excel's Advance Formula's