 Responsible for providing reporting & analytics for the Finance, Sales, Operations, Supply chain, PDMR divisions. Work cross-functionally to solve critical data and process issues, providing valuable insights and recommendations to the managing director for decision-making. Utilized Toad, Oracle SQL, Python, Power Query, Power BI, Halo, and advanced Excel tools(Cube) for data extraction, cleaning, and visualization. Operate with PBS ERP and SAP FICO for financial accounting, gaining a deep understanding of both tools for root cause analysis and reporting. Data Cleanup Project: Led a project to identify and resolve 38 critical data and process issues during the migration from Navision to PBS, driving significant process transformations and improving visibility and efficiency. Velocity Analysis Project: Conducted a velocity analysis to optimize warehouse inventory management and layout, supporting the consolidation of inventory from seven warehouses and planning for future cross-docking operations. Customer Dashboard Project: Developed Power BI dashboards for major customers, tracking multiple KPIs to improve visibility and accountability, ensuring retention of business.

● Transformed Nike's inventory inbounds process for the holiday season, Performed data extraction and transformation actions using SQL concepts on Power Query, and Analyzed data to identify the pain points, using root cause analysis and visualization through advanced Excel & Power BI tools. ● Developed a framework to standardize container prioritization and recommended long-term upstream and downstream solutions to reduce dead inventory at the DCs by 16.6%. Backed the recommendations with academic concepts and statistical metrics

• Analysed lead times during peak/off-peak hours & level of delayed differentiation to suggest changes in station layout, with an estimated 30% reduction in average lead time

• Earned recognition as a top performer (2%) and received consecutive awards for successfully automating 7 processes using .NET and Excel macros, contributing to 18% of the total annual revenue generated by the team.• Handled end-to-end project lifecycle, working with three cross-functional teams – audit, tech, and governance resulting in an overall 24 FTE (measured based on Time, Cost, Accuracy, and Speed benefit).• Architected a Product Library that automated the development cycle for financial reports and augmented project reusability metrics by 50% in 3 months. Currently, over 40+ projects are utilizing it.• Spearheaded a web app to track employee abilities, expertise, and project details. Internal job transfers were increased by more than 20% by this effort driving the overall onboarding costs by 15%.• Mentored 11 new FTEs with IT Procurement, and streamlined the onboarding process bringing down setup time by 40%.• Performed project management activities like daily team scrum meetings, automation tracking & risk analysis.

• Monitored and managed vendor contracts to identify areas to drive cost savings; negotiated favourable prices, terms, and conditions for existing contracts, delivering $400,000 in savings from a $3M annual budget.• Conducted real-time analysis of requirements of 150+ items for 3 running projects; ensured 99.2% product availability by prioritizing purchases out of a $1.3M procurement budget.• Revitalized company sales pitch, boosting business creation by 16% and margins by 7% in 6 months.• Successfully negotiated a real estate land parcel (30,000 sq yards) deal worth $1.2 M and accomplished cost avoidance of 9%.• Digitized existing process efficiency and reduced lead times by 20%; Analyzed on/off-site operations and finances in real-time.• Improved the social security for the 100+ skilled and unskilled workers by launching insurance, medical and spousal benefits.

• Developed multiple Python-based API and FAAS modules for the ongoing Data Analytics project - 'Medical Chart Dashboard.• Architected a MongoDB data structure to support the dashboard.

● Proficiently analyze supply chain data for construction logistics using advanced Excel features, to derive actionable insights and identify areas for optimization.● Develop and deliver comprehensive reports and dashboards on Power BI, empowering management to make informed decisions and improve overall supply chain performance.● Collaborate with cross-functional teams and IT departments to integrate technology seamlessly into existing supply chain processes, enabling data-driven decision-making across the organization.