I am a data-driven professional with over four years of experience specializing in data coordination, vendor analytics, and procurement systems. Skilled in SQL, Excel, VBA, and Power BI, I thrive on optimizing reporting processes, streamlining workflows, and driving operational efficiency across diverse industries including pharmaceutical, banking, and e-procurement. My passion lies in transforming complex data into actionable insights that empower business decisions. I hold diplomas in Artificial Intelligence and Business Analytics, supported by a strong technical foundation in Python and SQL. With hands-on experience in data visualization tools like Power BI and Tableau, I enjoy creating interactive dashboards and automated reports that help cross-functional teams gain real-time performance insights. I am continuously seeking opportunities to leverage my analytical skills and business acumen to contribute to organizational success.

Yash Halani

I am a data-driven professional with over four years of experience specializing in data coordination, vendor analytics, and procurement systems. Skilled in SQL, Excel, VBA, and Power BI, I thrive on optimizing reporting processes, streamlining workflows, and driving operational efficiency across diverse industries including pharmaceutical, banking, and e-procurement. My passion lies in transforming complex data into actionable insights that empower business decisions. I hold diplomas in Artificial Intelligence and Business Analytics, supported by a strong technical foundation in Python and SQL. With hands-on experience in data visualization tools like Power BI and Tableau, I enjoy creating interactive dashboards and automated reports that help cross-functional teams gain real-time performance insights. I am continuously seeking opportunities to leverage my analytical skills and business acumen to contribute to organizational success.

Available to hire

I am a data-driven professional with over four years of experience specializing in data coordination, vendor analytics, and procurement systems. Skilled in SQL, Excel, VBA, and Power BI, I thrive on optimizing reporting processes, streamlining workflows, and driving operational efficiency across diverse industries including pharmaceutical, banking, and e-procurement. My passion lies in transforming complex data into actionable insights that empower business decisions.

I hold diplomas in Artificial Intelligence and Business Analytics, supported by a strong technical foundation in Python and SQL. With hands-on experience in data visualization tools like Power BI and Tableau, I enjoy creating interactive dashboards and automated reports that help cross-functional teams gain real-time performance insights. I am continuously seeking opportunities to leverage my analytical skills and business acumen to contribute to organizational success.

See more

Work Experience

Project Coordinator at Canadian Western Bank
October 1, 2024 - September 2, 2025
Analyzed and maintained vendor data across multiple systems for over 300 active records using advanced Excel functions and SQL. Developed and automated vendor performance and spend reports, reducing manual efforts. Collaborated with procurement and legal teams to review vendor contracts and maintain a centralized repository. Supported vendor onboarding and ensured regulatory compliance. Led data cleaning initiatives reducing duplicates and coordinated timely updates of contract terms and compliance certifications. Created dashboards and summary reports for finance and sourcing teams to provide actionable vendor insights.
Data Coordinator at Fresenius Kabi
October 1, 2024 - Present
Perform advanced data analytics using SQL and advanced Excel functions such as Power Query, pivot tables, and array formulas to support inventory management and operational efficiency. Maintain and analyze Master Batch Records ensuring data accuracy and compliance using Excel VBA macros. Created VBA scripts and macros to automate data processing, reducing manual workload. Developed dynamic Excel dashboards and interactive Power BI dashboards to deliver real-time insights and enhance reporting flexibility. Optimized SQL queries and used data modeling techniques to clean and summarize KPIs. Leveraged cross-functional collaboration to support data-driven decision-making.
Project Coordinator at Canadian Western Bank
October 1, 2024 - August 26, 2025
Analyzed and maintained vendor data for over 300 active vendor records ensuring accuracy and consistency using advanced Excel and SQL. Developed automated reports for vendor performance, contract compliance, and spend metrics reducing manual reporting time. Collaborated with procurement and legal teams to maintain a centralized contract repository. Supported vendor onboarding ensuring compliance with internal controls and financial regulations. Led initiatives to clean legacy vendor data and coordinated timely updates of vendor contract terms and compliance certifications.
Data Coordinator at Fresenius Kabi
October 1, 2024 - Present
Performed advanced data analytics using SQL and advanced Excel techniques to support inventory management, demand forecasting, and operational efficiency. Maintained Master Batch Records ensuring data accuracy and regulatory compliance using Excel VBA and macros. Automated repetitive data tasks with custom VBA scripts to reduce manual workload. Developed dynamic Excel dashboards and interactive Power BI dashboards visualizing KPIs for cross-functional teams. Optimized SQL queries and used data modeling techniques to summarize key performance indicators.
Data Analyst at E Procurement Technologies
July 1, 2021 - September 2, 2025
Collaborated with IT, finance, and procurement teams to implement and optimize e-procurement platforms integrating vendor data. Utilized advanced Excel, Python, and SQL for vendor bid analysis, contract compliance tracking, and performance scorecards. Conducted in-depth supplier data analysis identifying cost reduction opportunities and procurement cycle improvements. Managed vendor master files ensuring data integrity and compliance. Delivered reports and visualizations to support vendor negotiations, SLA monitoring, and supplier relationship management.
Data Analyst at E Procurement Technologies India
July 1, 2021 - August 26, 2025
Collaborated with IT, finance, and procurement teams to support implementation and optimization of e-procurement and e-auction platforms. Analyzed vendor bids and contract compliance using advanced Excel. Leveraged Python and SQL to extract and analyze procurement data for supplier performance insights. Managed vendor master file ensuring data integrity and compliance. Delivered reports and visualizations aiding vendor negotiations, SLA monitoring, and contract lifecycle tracking.

Education

Diploma in Artificial Intelligence at Durham College, Oshawa
January 11, 2030 - June 1, 2022
Diploma in Business Analytics at Seneca College, Markham
January 11, 2030 - August 1, 2021
Bachelors in Computer Engineering at Silver Oak College, Ahmedabad
January 11, 2030 - June 1, 2019
Diploma in Artificial Intelligence at Durham College
January 1, 2022 - June 1, 2022
Diploma in Business Analytics at Seneca College
January 1, 2021 - August 1, 2021
Bachelors in Computer Engineering at Silver Oak College
January 1, 2015 - June 1, 2019

Qualifications

Add your qualifications or awards here.

Industry Experience

Healthcare, Financial Services, Wholesale & Distribution, Software & Internet, Professional Services