Available to hire
I’m a results-oriented Data Analytics and Business Intelligence professional with extensive experience designing and delivering BI and data warehousing solutions. I am highly efficient, goal-driven, and hold a postgraduate degree in Computer Applications. I excel at turning data into actionable insights and communicating complex findings to stakeholders.
Over my career I have led multiple BI projects across finance, merchandising, supply chain, and pricing. I thrive in cross-functional environments, mentor teammates, and continuously adapt to new technologies to drive business value.
Skills
Language
English
Fluent
Work Experience
Lead BI at American Tire Distributors
February 1, 2021 - PresentLed the design and delivery of an advanced analytics solution in Power BI to replace a slow labor planning process. Collaborated with stakeholders to define requirements and data sources. Designed a scalable DataMart in Google BigQuery and PostgreSQL tailored for labor planning analytics across 130 distribution centers. Built a Power BI report for labor planning, enabling allocation of inbound/outbound duties and tracking additional labor requirements. Integrated PowerOn visuals and services to enable write-back and real-time data updates within Power BI. Developed Labor Performance KPIs using advanced DAX for in-depth analysis. Created a Power Automate flow to automate weekly labor schedules, significantly reducing manual effort. Implemented row-level security to restrict data and writeback access by role. Optimized reports and DAX using DAX Studio for performance. Designed deployment pipelines to promote reports and datasets across environments and managed version control. Produced u
Lead BI at CDP Migration
December 1, 2023 - June 1, 2024Led migration from Snowflake to Google Cloud to preserve uninterrupted Power BI access. Re-engineered DW and Data Mart for performance, scalability, and self-service reporting. Migrated Power BI reports across supply chain, merchandising, and finance; updated queries and Power Query transformations for Google BigQuery. Redesigned DAX for cloud compatibility and performance. Established DevOps practices for Power BI reporting and collaborated with stakeholders to ensure alignment. Executed cutover with minimal downtime and prepared rollback strategies.
Senior BI Developer at Project Nirvana
February 1, 2023 - December 1, 2023Developed Power BI reporting for Merchandising to improve inventory management, profitability, and cost optimization. Built ETL pipelines using Power Query, Dataflows, and Azure Data Factory; designed scalable data model; created dashboards; empowered user analysis across Sales, Inventory, Margin, and Bonus Program (MTD/QTD/YTD). Created five additional reports; set up subscriptions and a Power Automate delivery workflow; ensured data governance and optimized performance.
Senior BI Developer at Category Outlook
May 1, 2022 - January 1, 2023Created a Power BI category outlook with dynamic field parameters to compare Market Demand and market share across multiple levels. Wrote SQL to extract data, built market share and market split measures in DAX, and established automated monthly data ingestion pipelines. Designed dashboards for visibility of demand and inventory alignment.
Senior BI Developer at SO99 Forecast Accuracy
October 1, 2021 - May 1, 2022Analyzed weekly SO99 forecast data (5B+ rows); built a Power BI report with field parameters to switch between forecast types and versions; implemented DAX to calculate MAPE, Weighted MAPE, Accuracy and Bias; documented processes in Confluence; improved forecasting insights.
Senior BI Developer at Daily Sales
February 1, 2021 - October 1, 2021Built end-to-end BI environment; created staging, landing, and presentation layers; wrote stored procedures and views; crafted advanced DAX metrics for Sales, Units, Margin; developed paginated reports; applied RLS; collaborated with Microsoft Architects to improve performance achieving load times under 4 seconds.
Manager – Planning Analytics at National Tire Distributors
July 1, 2019 - February 1, 2021Led financial planning analytics; developed Oracle queries; automated data pipelines to MSBI; built a SSAS tabular cube for financial reporting; created Master Data Management solution for financial and departmental hierarchies; applied RLS; delivered Power BI dashboards; enabled direct write-back.
Senior BI Developer at GMROI
January 1, 2020 - July 1, 2020Created Power BI tool for GMROI reporting to understand inventory profitability, optimize stock levels, and improve pricing strategies. Built ETL processes, data model, interactive dashboards, governance, and training with RLS on Oracle data.
Senior BI Developer at Customer Profitability
July 1, 2019 - January 1, 2020Developed Variable Contribution Margin (VCM) report, including data pipelines, scalable Power BI data model, and advanced DAX for VCM, vendor bonuses, dead net gross profit, and cost to serve; implemented governance and training.
Senior BI Developer at DSI Consulting
December 1, 2017 - June 1, 2019Site Scorecard & Consolidated Financials: integrated data sources, built scalable Power BI data model, DAX measures, row-level security, automated refresh and subscriptions; ensured data governance and performance.
Senior BI Developer at DSI Consulting - One Source
December 1, 2017 - December 1, 2018One Source: designed data warehouse and data marts to centralize data management; developed ETL processes; created comprehensive documentation and self-service reporting.
Senior BI Developer at Punjab Communications Ltd
June 1, 2007 - November 1, 2017Built data warehouse and data marts; SSIS packages; Master Data Services; role-based security; training; Power BI dashboards with write-back; executive-level dashboards focusing on EBITDA, working capital, and cash flow.
BI Developer at Online Application Submission System
January 1, 2013 - September 1, 2014Designed an intuitive online portal; developed data integration flows/ETLs to centralize data for reporting; contributed to revenue growth by enabling streamlined processes.
BI Developer at Biometric System For Impersonation
May 1, 2011 - January 1, 2013Developed BI solutions to curb impersonation; translated business needs into technical requirements; ensured data accuracy and process SLAs.
Junior BI Developer at Land Management System
May 1, 2009 - April 1, 2011Digitally transformed land registration processes; re-engineered workflows; ensured data accuracy and integrity across systems.
Software Engineer at Website & Web Application Development
June 1, 2007 - May 1, 2009Customized software for client use; designed and coordinated databases; provided production support and bug fixes.
Education
Master of Computer Application at THAPAR UNIVERSITY Patiala, India
January 1, 2004 - January 1, 2007Bachelor of Science at Panjab University Chandigarh, India
January 1, 2001 - January 1, 2004Qualifications
Analyzing and Visualizing Data with Power BI (MS 70-788)
January 11, 2030 - January 23, 2026Industry Experience
Manufacturing, Retail, Financial Services, Professional Services, Transportation & Logistics
Skills
Hire a Data Analyst
We have the best data analyst experts on Twine. Hire a data analyst in Oakville today.