Ayush Awasthi

Data Analytics professional with 7+ years of experience delivering financial and operational insights that drive business performance and strategic decision-making. Proven ability to analyze revenue, margins, cash flow, and customer trends to identify risks and opportunities. Experienced in collaborating with stakeholders to translate complex datasets into actionable, executive-level insights.

Strong expertise in SQL, Power BI, and large-scale data environments, with a focus on impactful reporting.

Senior Data Analyst - Chubb & Vipond Fire and Security (acquired by APi Group Corporation) - Mississauga, ON

(2024-11)

• Designed and implemented advanced AR report that provided detailed visibility of outstanding invoices and payment trends. Analyzed receivables trends and payment behavior which contributed to a 40% reduction in AR and improved cash flow visibility for leadership.
• Designed and implemented Power BI reports with built-in validation layers that flagged over $1 million in billing discrepancies. This improved financial transparency and supported accurate client invoicing.
• Developed interactive dashboards to automate tracking and management of semi-annual and annual contract renewals. This resulted in reduction of manual tracking efforts and ensured timely renewals across departments.
• Built complex DAX calculations to streamline reporting and deliver clearer insights for decision-making.
• Created a centralized dashboard to streamline sales commission calculations and disbursements. This helped in improving payout accuracy and reduced administrative overhead for the firm.
• Led the migration of reporting infrastructure during the company's transition from a legacy ERP system to a modern cloud-based platform. Rebuilt Power BI datasets and reports to connect with Azure Synapse Analytics and Azure Data Lake Storage, ensuring seamless access to new data sources, server connections while maintaining data accuracy and continuity post-migration.
• Developed a management dashboard evaluating departmental efficiency by analyzing work order volumes, resolution rates, and billing revenue, enabling management to assess profitability, performance trends, and individual contributor effectiveness.

Senior Data Analyst - Chubb Fire and Security - Mississauga, ON

(2022-07 - 2024-11)

• Led the automation of month-end reporting processes, reducing manual analysis time for the finance team by 70%. Developed interactive Power BI dashboards consolidating key financial data, enabling quicker decision-making and reducing the risk of errors.
• Evaluated inventory movement and demand patterns across regions, enabling data-driven stock optimization decisions and reducing excess inventory by 20%
• Developed a team performance dashboard to track the productivity of technicians and employees across multiple teams. The dashboard provided key metrics on work completion rates, service times, and efficiency, allowing management to identify areas for improvement.
• Implemented a solution that enables users to input, edit, or update the reports by integrating Power Apps with Power BI and automating workflows. This functionality provided a seamless support to end user, allowing them to make real-time adjustments and updates to data without leaving the interface.
• Integrated and automated data from various financial and inventory sources into Power BI, ensuring data quality, real-time data refresh and eliminating manual updates.
• Worked closely with finance stakeholders to analyze revenue, margins, and operational performance, delivering insights used in monthly business reviews and strategic planning discussion.

Business Data Analyst - Chubb Fire and Security - Mississauga, ON

(2020-06 - 2022-07)

• Assisted in the collection, cleansing, and transformation of raw data from various sources (Azure Synapse Analytics and Azure Data Lake Storage via SQL Server, Excel, etc.) and create data operating models for use in Power BI reports.
• Responded to ad-hoc reporting requests from business stakeholders by designing custom Power BI reports to meet specific business needs.
• Assisted in visualizing business KPIs through the creation of charts, graphs, and tables, enhancing the decision-making process.
• Focused on improving the performance of Power BI reports by optimizing queries and report visuals, resulting in faster load times.

Data Analyst - Amcor Rigid Plastics - Mississauga, ON

(2019-05 - 2020-06)

• Provided support to business users, helping them to navigate and interpret Power BI reports and dashboards.
• Work with senior analysts to define, measure, and track important KPIs for various business departments, ensuring alignment with business objectives.
• Assist in aggregating and summarizing large datasets from multiple sources to produce consolidated reports or visualizations for analysis using complex DAX formulas.

Data Analyst - One Mobikwik Systems Ltd - Gurgaon, India

(2016-04 - 2018-06)

• Help clean and format datasets by identifying and resolving data quality issues (e.g. missing values, outliers).
• Work closely with senior data analysts to assist in more advanced data analysis tasks or reporting projects.
• Help maintain documentation for data sources, queries, and reports to ensure consistency and reproducibility in future projects.

Post Graduate Certificate Program - Supply Chain - Humber College (2018-09 - 2019-04)

Masters in Business Administration - Business Analytics - University of Petroleum and Energy Studies (2014-07 - 2016-04)

Bachelors in Commerce - Finance - Chatrapati Shahu Ji Maharaj University (2011-07 - 2014-04)