- Lead and Develop Analytics Team: Manage, mentor, and develop a team of supply chain analysts, fostering a collaborative and high-performance culture.- Oversee Data Analysis Projects: Supervise and coordinate complex data analysis projects to ensure timely, accurate, and actionable insights.- Develop and Maintain Dashboards: Create and maintain advanced Power BI dashboards and reports to provide real-time visibility into supply chain performance metrics- Monitor Key Performance Indicators (KPIs): Define, track, and report on KPIs to measure and improve supply chain efficiency and effectiveness.- Database Management: Design, manage, and optimize SQL databases to ensure efficient data storage, retrieval, and analysis.- Cross-Functional Collaboration: Work closely with procurement, logistics, operations, and IT teams to develop data-driven solutions that enhance supply chain processes.- Data Integration and Migration: Ensure seamless integration and migration of data between ERP systems, maintaining data consistency and accuracy.* Major Achievements: - Successfully implemented Power BI Reports and Dashboards in Supply Chain Department to automate day to day reporting. Introduced Supplier Scorecard Reporting System and executed automation on Excel. - Migrated/integrated acquired Europe based data center (Interxion) database with Digital Realty database. - Implemented a comprehensive Master Data Management Process that improved data quality and accuracy by 30%

- Lead Data Analysis Projects: Manage and oversee supply chain data analysis projects, ensuring timely and accurate delivery of insights and recommendations.- Develop Dashboards and Reports: Create and maintain advanced Power BI dashboards and reports to provide real-time visibility into supply chain performance.- KPI Monitoring: Define, track, and report on key performance indicators (KPIs) to measure supply chain efficiency and effectiveness.-SQL Database Management: Design and maintain SQL databases to ensure efficient storage, retrieval, and analysis of supply chain data.- Advanced SQL Queries: Utilize advanced SQL queries to extract, manipulate, and analyze large datasets, ensuring data accuracy and integrity.- Automate Data Processes: Develop SQL scripts and procedures to automate data processing tasks, reducing manual efforts and increasing productivity.- Data Integration and Migration: Ensure seamless integration and migration of data between ERP systems, maintaining data consistency and accuracy.

- Conduct in-depth data analysis to identify trends, patterns, and anomalies within supply chain operations, enhancing efficiency and cost-effectiveness.- Develop and maintain Power BI dashboards and reports, providing real-time insights and actionable intelligence to stakeholders.- Utilize advanced SQL queries to extract, manipulate, and analyze large datasets, ensuring data accuracy and integrity.- Leverage MS Excel and VBA Macros to automate data processing tasks, reducing manual efforts and increasing productivity.- Implement predictive analytics and forecasting models to anticipate supply chain disruptions and improve demand planning.- Ensure seamless integration and data migration between ERP systems, enhancing data consistency and accessibility.- Provide actionable insights through data visualization, enabling informed decision-making and strategic planning.

- Prepared operational dashboard on Excel and Power BI and improved TAT of each department, reflecting company’s overall performance. Utilized Google Analytics data to provide real time analytics insights to digital marketing team during campaigns. Escalated root causes and implemented corrective measures.- Prepared financial reports, E2E, SKU induction report, MTD, vendor scorecard, forecasting reports etc., while converting complex data findings into text, tables, graphs, and advanced interactive dashboards.- Analyze existing SQL queries and suggest new ones for performance improvements.- Provide maintenance support to existing Data Warehouse applications and reports.- Act as the first point of contact to answer all business data queries- Develop effective reporting solutions by utilizing engineering best practices and various reporting tools- Participate in continuous improvement of these reporting solutions- Drive and support your designated business unit by converting complex data and findings into understandable tables, graphs, and written reports- Present appropriate analysis and commentary to technical and non-technical audience- Run regular data integrity audits- Devise and evaluate methods for collecting data, such as surveys, questionnaires, and opinion polls- Gather data about consumers, competitors, and market conditions.

- Reviewed daily business dashboard reports and assisted management in quick decision making, while preparing stock & purchase reports and participating in weekly & monthly forecasting meeting with senior management. - Collected & evaluated sales results/workflow to identify steps & increase sales productivity.- Carried out and forecasted complex analysis, prepared monthly purchase plan & inventory aging report for buyers, reviewed MTD sales results, maintained product DBMS, worked with Macros & VBA programming, utilized MS Access and adeptly analyzed power pivot, power query & BI.- Designed database structures, including tables, indexes, and relationships, to ensure efficient data storage and retrieval.- Maintaining documentation of database structures, configurations, and processes is an important aspect of the role. This helps in knowledge sharing and troubleshooting.Major Achievements:- Conducted report automation by using VBA Macro that allows department to create 25 reports by single click, resulting in time saving and optimization of department performance.

Efficaciously worked in risk monitoring department, executed multiple tasks, implemented innovative strategies after tests, and assured standard results, while addressing/resolving customers’ complaints under supervision of senior management. Monitored risk factors of daily financial & non-financial activities, and investigated service requests and quality of delivery, while analyzing risk monitoring unit in interpretation & examination of data for business, and reporting training statistics to company.