Amit Singh

• Situation: Time-booking & Nestle operations required accurate Incident, performance & inventory reporting, financial reporting and forecasting for resource planning. Task: Build robust ETL and reporting workflows integrating HR (Time Booking Data), SNOW, Salesforce, CRM (Customer Relationship Management), ERP (Enterprise Resource Planning), and SCM (Supply Chain Management) tools to extract data. Action: Designed automated ETL pipelines and dbt-based data marts with quality preprocessing (identify anomalies, trends, and patterns) and performing testing by following KPI standardization. Result: Reduced reporting errors by 20%, accelerated dashboard refreshes times by 30%, and improved operational efficiency by 15%. • Situation: Business units required deeper insights from both structured and unstructured data to support data-driven strategies. Task: Build a robust Python-based data models pipelines and analyse data for advanced analytics (like fraud and risk detection) Action: Leveraged Python in Jupyter Notebook to collect, clean, and preprocess large datasets, performed exploratory data analysis (EDA), implemented workflows to extract patterns, trends and insights. Result: Delivered accurate and deep insight analysis that enhanced business forecasting, improved marketing decision-making strategies, identifying risk. • Situation: Business leaders needed better visibility into Incidents, Sales performance, and compliance & non-compliance inventory reporting accuracy. Task: Created interactive dashboards and validate data at scale. Action: Delivered Tableau/Power BI/QlikView/Excel dashboards by integrating data from multiple sources using optimized SQL and power queries to analyse data. Result: Increased accuracy of sales reporting and improved data quality and speed of business decision-making. • Situation: Marketing and sales team required deeper insights into performance and lacked standardization across multiple systems. Task: Streamline marketing KPI definitions by analysing sales and performance data and developing BI dashboards and reporting. Action: Delivered scorecards and trend reports aligned to marketing KPI dashboards and data models by standardized scorecard with dbt. transformation pipelines with documentation and testing. Result: Improved reporting consistency and alignment across teams especially Sales/Marketing. • Situation: The organization managed massive datasets from multiple sources, but inefficient query handling slowed reporting process. Task: Improve data extraction ensuring data quality, consistency, efficiency and integrity, develop a scalable data warehouse using Azure cloud services Action: Collected, analysed, transformed and stored 1B+ rows of data using MS SQL Server and other relational databases; developed and optimized queries for faster data extraction; designed, built, and maintained an internal data warehouse Result: Improved operational efficiency by 15%, enabling faster reporting and reliable access to consolidated business data. • Situation: Business leaders and customers needed clearer visibility of marketing trends and fluctuation, requirements were often unclear or fragmented. Task: Bridge the gap between stakeholders’ data needs and actionable analytics to influence strategic decisions, providing forecasting and variance analysis Action: Collaborated with research partners & organisation, cross-functional teams and senior management to gather and document business requirements, captured customer inputs, and translated them into structured data models and actionable insights. Applied Python-based time-series models (ARIMA, regression) and created financial and forecasting dashboards. Result: Delivered data-driven recommendations that directly influenced key business decisions, identified new opportunities, and improved stakeholder confidence in reporting.

• Serve as a bridge between analytics, technical, and business teams to gathered business requirements for new activities from Internal & external stakeholder and documenting by creating SOPs or BRDs for newly migrated or existing processes. • Extracted, cleaned, and analysed financial datasets using Excel and SQL, providing insights into revenue trends and cost control measures, leading to a 10% reduction in operational costs. • Optimized reporting processes based on team feedback, reducing report generation time by 20% through streamlined data workflows. • Created project plans for various tasks within a certain timeframe, with defined stages, budgeting, forecasting, and aligning required resources. • Created Excel-based models and dashboards, track key performance indicators (KPIs), improving forecasting accuracy. • Assisted in the development of KPIs and ETL processes to streamline data integration from diverse systems by building dashboards agents. • Delivered data-driven reports and dashboards for various business units, leading to improved decision-making for internal stakeholders.

• Developed Excel (VBA) macros and scripts to automate process of reporting, build macros to automate repetitive task, proficiency in using excel formulas, functions and building dashboards using pivot charts and tables. • Created & Maintained database (MS Access, SQL) with programmed applications and extracted data from data warehouse for further reporting. • Data mining for variance analysis and customized reporting on basis of Daily/ Weekly/ Monthly/ Quarterly/Semi-Annual/Annual reports. • Automated daily and weekly report generation and delivery using SQL, MS Access saving over 20 hours per month in manual processing for sales and finance teams. • Built scalable SOPs, BRDs and tools for cross-functional teams and develop KPIs to monitor and enhance operational performance