Pujan Modi

Data Analyst · Calgary, Canada

Pujan Modi

About

I am a data analyst with a strong foundation in data engineering and analytics, experienced in building automated solutions and advanced visualizations that drive business insights and operational efficiency. Skilled in leveraging data to support strategic decision-making, improve data accessibility, and deliver impactful, data-driven solutions. Highly organized, detail-oriented, and committed to continuous learning and professional growth.

Experience

Procurement Data Specialist — Finning Canada

Hyper-Automation & Workflow Optimization: Engineered sophisticated Power Automate workflows to autonomously parse and analyze raw supplier error logs. This solution eliminated the manual ticket-raising process for pricing adjustments, ensuring real-time price accuracy for the buyer team and significantly reducing operational friction. Large-Scale Operational Efficiency: Developed and deployed a comprehensive suite of automated auditing reports and performance trackers that slashed manual data review cycles by 90%. This efficiency gain allowed the procurement team to pivot from a reactive monthly reporting cadence to proactive weekly strategic reviews. Advanced Data Engineering & ETL Architecture: Leveraged SQL (SSMS) to design and execute complex ETL processes, transforming fragmented datasets into structured, high-integrity data lakes. This foundation ensured the delivery of robust, "single-source-of-truth" analytics for internal team KPIs and supplier performance tracking. Financial Analytics & Cost Management: Conceptualized and launched a dedicated Financial Spend Dashboard, utilizing advanced DAX modeling to uncover hidden cost-saving opportunities. The tool empowered leadership to monitor spend categories in real-time, driving more aggressive and informed vendor negotiations. Enterprise BI Migration & Strategic Visualization: Supported the end-to-end migration of the procurement analytics suite from Tableau to Power BI, contributing to the re-architecture of legacy data models and the design of high-performance dashboards that enhanced data accessibility for executive decision-making. Strategic Collaboration & Data Governance: Acted as a key liaison between the data team and procurement stakeholders to establish rigorous data governance standards. By translating complex technical metrics into actionable business insights, I fostered a culture of data-driven strategy that enhanced overall departmental accuracy and supplier relations.

Skills

Business Intelligence & Visualization

Data Engineering & Analytics

Data Analysis & Machine Learning

Programming & Databases

Cloud Platforms

ERP Tools

Additional Tools

Education

Postgraduate in AI and Data Science — Loyalist College

Toronto, Canada

Bachelor of Engineering in Computer Engineering — Kadi University

Gandhinagar, India