Ankur Limbashia
Senior Business Intelligence Analyst
No Data Found
Ankur Limbashia
Business Intelligence | Data Engineering | Data Science | Machine Learning | Kaggle 3x Expert
Experienced BI Analyst specializing in interpreting complex data sets, developing impactful BI reports and dashboards, and driving operational efficiency through data-driven insights and automation. Proficient in SQL, Power BI, Tableau, and Python for end-to-end data processes including data ingestion, data modeling, visualization, report automation, and complex data analysis. My competencies include leading analytics teams, spearheading annual reporting initiatives, and enhancing data integrity and accessibility through robust Row-Level Security (RLS) implementations and integrating diverse data sources. I excel at data consolidation, data modeling, and bulding interactive reports, alongside developing and deploying Python-based automation tools for various data tasks. I also bring a strong background in predictive modeling using machine learning techniques, which enhances forecasting and insight capabilities.
Work Experience
Empowering operational excellence through data
October 2024 - Present (10 months)
Ainsworth Inc
Senior Business Intelligence Data Analyst
I have led an analytics team that support operations across Canada and the USA, consistently driving data-driven decision-making. I've spearheaded annual reporting initiatives, overseeing everything from strategy development to execution and ensuring seamless stakeholder alignment. A core focus of my work has been on strengthening data integrity and compliance, achieved through the implementation of robust dynamic Row-Level Security (RLS) in Power BI. I've also significantly improved data accessibility by designing centralized reporting solutions that integrate diverse datasets from five distinct SQL Server instances. My analytical expertise extends to conducting comprehensive churn analysis across various contract stages to pinpoint retention risk factors. Furthermore, I developed a Python automation tool that successfully reduced quote rejection rates by 20%.
June 2022 - October 2024 (2 years 5 months)
Ainsworth Inc
Data Analyst
I led projects to transform data accessibility and automate key processes. I proposed and successfully championed the migration of existing reports to Power BI, which significantly increased organizational adoption. I developed the report architecture, defining security requirements, and structuring the report hierarchy. I established complex data relationships between SQL Server and Oracle (JDE) for robust Power BI data modeling, directly consolidating financial and operational information and enhancing decision-making efficiency for contract renewals by approximately 25%. I also engineered a Python-based package that utilized OCR to convert PDF bills into images, reducing data extraction time by 97%. Furthermore, I created a Windows executable to automate data scraping from the BI tool, cutting a day of manual work to only 17 minutes.
August 2016 - October 2020 (4 years 3 months)
Adani Solar
Data Analyst
I drove operational efficiency through data analysis, dashboard development, and automation projects. I reduced MIS dashboard creation time by 75% via VBA and macros, and designed impactful KPI dashboards that directly empowered production teams to boost productivity and on-time delivery. My work in transforming complex data into actionable reports in Tableau, yielded improvements in production, quality, cost, and inventory. A key project involved introducing an hourly data monitoring system that cut product rejection from 0.8% to 0.07%. Additionally, my exploratory data analysis led to a 30% increase in production output by optimizing workstation efficiency. I also established standardized reporting templates and implemented exception reports to ensure robust data quality and consistency.
My Skills
Core competencies that drive my performance.
My Skills
SQL90 %
Power BI90 %
DAX80 %
Tableau85 %
Snowflake75 %
Python80 %
Data Modelling85 %
Predictive Analytics80 %
ETL80 %
Azure Data Factory80 %
Education
Empowering Creativity through
January 2021 - May 2022
Postgraduate Degree
St. Clair College
Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.
July 2012 - May 2016
Bachelor's degree
The Maharaja Sayajirao University of Baroda
Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.
Microsoft Certified: Power BI Data Analyst AssociateMicrosoft Certified: Power BI Data Analyst Associate
not found
Full Name
Email
Message
Send
