Ankur Limbashia Email & Phone Number

Ajax, On, Ca

Toronto, Ontario, Canada

● Formed and led the analytics team to help support businesses across Canada and the USA● Conducted in-depth churn analysis across multiple contract stages, including creation, renewal, expiration, and churn, to identify patterns and risk factors influencing customer retention.● Designed and implemented a Python-based automation tool to streamline the quotation follow-up process, resulting in a 20% reduction in quote rejection rates.

Etobicoke, Ontario, Canada

● Proposed and championed the migration of existing reports to Power BI, resulting in increased adoption across the organization.● Developed the data architecture, identified and defined security requirements, and structured the report hierarchy successfully.● Established complex data relationships between SQL Server for operational data and Oracle schema for financial data (JDE) during Power BI and Excel data modeling. ● Consolidated financial and operational information, streamlining contract renewal decisions and enhancing decision-making efficiency by approximately 25%.● Engineered a Python-based package for converting PDF bills into images, utilizing OCR techniques to extract relevant text and numbers. Reduced data extraction time by 97%.● Created a Windows executable to automate data scraping from the organization's BI tool using Selenium. This reduced a day's manual work to just 17 minutes of automated processing.

Mundra, Gujarat, India

● Automated report generation in Excel using VBA and macros, resulting in a 75% reduction in MIS dashboard creation time, facilitating timely operational decisions.● Identified and designed interactive dashboards aligned with key operational KPIs, empowering the production department to enhance productivity and ensure on-time delivery.● Analyzed complex data, transforming them into presentable reports and dashboards using BI tools like Excel and Tableau that led to improvements in production, quality, cost management, and inventory management.● Introduced an hourly data monitoring system for machines, leading to early detection and reduction of product rejection from 0.8% to 0.07%.● Conducted exploratory data analysis to evaluate efficiency across workstations, identifying machine bottlenecks and optimal operator stations, resulting in a 30% increase in production output.● Developed a standardized reporting template to ensure data quality and consistency in communication of insights across all reports.● Implemented exception reports to identify anomalies in the integration between operation and finance databases, ensuring data integrity and quality.

Postgraduate Degree, Data Analytics For Business

Bachelor'S Degree, Electrical Engineering