Harsh Kumar Goel

Process Automation, Data Analysis, and Dashboard Development

• Developed a comprehensive SQL database that consolidated critical data streams, enhancing order tracking and enabling real-time decision-making. Optimised database architecture for weekly and monthly reports, improving visibility into order statuses, and response times. Designed an efficient Power BI dashboard for real-time insights into orders, enhancing stakeholder confidence, and business agility.
• Finance Optimization:
  Created an SQL database for managing Accounts Payable and Receivable, integrating financial data streams to improve cash flow management and reduce report generation time by 25%. Automated key financial reporting with a Power BI dashboard, increasing accuracy and reducing manual work by 35%, allowing focus on strategic analysis.
• Shipment and Inventory Analysis:
  Streamlined data processing workflows using SQL to enhance shipment and inventory management, resulting in a 40% increase in operational efficiency. Developed advanced Power BI dashboards for real-time visibility into inventory metrics, improving logistics and resource flow. Built a scalable SQL database capable of handling millions of data points, facilitating advanced analytics, and improving operational visibility. Utilised data modelling to identify resource optimisation opportunities, leading to a 15% increase in production efficiency.
• Logistics Compliance Dashboards:
  Created customized compliance dashboards that enabled the BI team to track critical metrics, reducing reporting time by 20%. Leveraged Excel, SQL, Power BI, and Python to automate data collection, improving accuracy by 30%. Applied fuzzy logic techniques in Python for data integration, enhancing data quality.
• Conducted a detailed analysis of electricity pricing data to identify seasonal patterns, enabling predictive modelling for energy consumption strategies. Utilised Python for Exploratory Data Analysis (EDA), increasing data reliability by 25%. Achieved a 12% reduction in energy costs by advising on optimal consumption periods, and identified additional savings through penalty charge analysis.

Expertise in team management, advanced analytics, and strategic business support across retail and global operations.

Cocoblu Retail Limited

• Led a cross-functional team of five analysts, managing project requirements and automation, to deliver data-driven solutions.
• Conducted sales, inventory, and product analyses using Python, providing actionable insights that supported key business strategies.
• Executed daily and ad hoc analyses for timely reporting to stakeholders, enhancing operational efficiency.
• Developed Power BI dashboards for insightful reporting, presenting data in a user-friendly format for non-technical audiences.
• Innovated processes to secure new projects, contributing to ongoing improvements in business intelligence practices.
• Utilised effective time management to consistently meet tight deadlines for critical analyses and reports.

Copia Global

• Supported leadership with comprehensive reporting and analysis that informed divisional strategies for data-driven decision-making.
• Prioritised customer feedback to implement strategic changes, improving service delivery and customer satisfaction.
• Analysed supply chain, finance, and product performance through daily ad hoc analyses, including cohort and performance analyses, for growth opportunities.
• Conducted financial service analyses that provided insights for budgetary, and strategic planning.
• Collaborated with stakeholders to address areas of concern, enhancing overall company performance.
• Conducted an in-house financial analysis, saving approximately $2 million by benchmarking financial products against competitors, demonstrating the impact of data analysis.

Experienced in project management, data governance, agile methodologies, and advanced analytics across banking, tech, and retail industries.

Citi Bank (Fortune 83 Financial Services Corporation):

• Led a team of three analysts, utilising JIRA and Confluence for effective project management across multiple initiatives within the banking sector.
• Implemented tools for monitoring Data Governance progress, ensuring resource management, and clearly defined roles while mapping comprehensive business processes.
• Developed detailed process flows that enhanced project visibility and documentation, providing stakeholders with a clear understanding of milestones and outcomes, to facilitate informed decision-making.

Microsoft (Fortune 15 Tech Giant):

• Created an Employee Voice Insights tool using Power BI to analyse feedback data through sentiment analysis, enabling data-driven strategies for improving employee engagement.
• Leveraged Python for text cleaning, classification, and topic modelling, identifying recurring themes in employee feedback for proactive management of concerns.
• Highlighted critical employee concerns, leading to targeted measures that enhanced the overall employee experience, and improved organisational culture.

Walmart (Fortune 1 Retailer):

• Designed and developed a Tableau Dashboard for data-driven decision-making across business units.
• Enhanced supply chain efficiency by providing visibility into key metrics using SQL and Alteryx for data analysis, supporting operational efficiency, and strategic planning initiatives.