MUHAMMAD BADAR
Toronto, ON 519-***-**** *.*****.*****@*****.***
GitHub: github.com/muhammadbadar1998
PROFESSIONAL SUMMARY
Data and Application Developer with over four years of expertise in designing data platforms and ETL pipelines across cloud and on-premises, end-to-end RAG and AI solutions across regulated nuclear, real estate, and Fortune 500 consulting, and translating executive and client requirements into reliable production software.
TECHNICAL SKILLS
● Programming & Data Processing: Python (Pandas, petl, NumPy, Scikit-Learn), SQL
(T-SQL), C#/.NET, TypeScript, Object-Oriented Programming (OOP), Data Transformation, Query Optimization
● Data Engineering & Platforms: SQL Server, Microsoft Fabric (Dataflows, Semantic Models), Azure VMs, SSIS, ETL/ELT, Power Query, Power BI, DuckDB, Parquet, SQLite, Relational & Dimensional Modeling, Stored Procedures, Partitioned Views
● Enterprise Software & Integration: REST APIs, ODBC, SFTP, Cloud-to-On-Premises Integration, ASP.NET MVC, Blazor, Azure AD (SSO), Power Automate, Power Apps
● AI & Development Practices: OpenAI API, Large Language Models (LLMs), Retrieval-Augmented Generation (RAG), Vector Search, Tool/Function Calling, AI Development Harnesses, Prompt/Context Engineering, Ollama, sqlite-vec, Git/GitHub, Azure DevOps, Agile/Scrum, CI/CD, Automated Testing
PROFESSIONAL EXPERIENCE
Data and Application Developer
Vital Infrastructure Toronto, ON (August 2025 – Present)
● Engineered a daily cloud-to-on-premises data pipeline that retrieves Yardi-hosted database backups via SFTP and automates SQL Server warehouse refreshes and database object creation, providing refreshed enterprise data for governed semantic models and Power BI reporting.
● Developed and deployed a production RAG-powered helpdesk assistant, orchestrating LLM-based summarization, structured data processing, deduplication, and vector indexing of thousands of historical support tickets to enable semantic search for approximately 10 staff members.
● Developed a Yardi-to-Building Engines API integration that transforms ERP data into validated payloads, establishing Yardi as the intended system of record while limiting Building Engines to operational work-order workflows.
● Partnered with operations teams and executive leadership, including the COO, to translate business requirements into technical solutions, investigate cross-system data discrepancies, and reduce reliance on manual quarterly data consolidation through governed data models.
● Built secure internal C#/.NET applications with Azure AD SSO and structured error logging, enabling business teams to execute self-service workflows while simplifying application support and troubleshooting.
Data Solutions Analyst
Ontario Power Generation Darlington, ON (January 2024 – August 2025)
● Engineered cloud data warehouse pipelines, stored procedures, relational tables, views and applications across an over 1 TB SQL Server environment on Microsoft Azure VMs, integrating cloud-hosted Oracle Primavera P6 and self-hosted EcoSys datasets to power internal applications for 2,000+ employees.
● Designed and deployed Microsoft Fabric Dataflows, data preparation workflows and governed semantic models, using SQL-based transformations and query-folding-aware design to deliver trusted self-service analytics adopted by 10+ developers and 100+ end users.
● Optimized SQL Server stored procedures, partitioned views, and indexing strategies to address query performance bottlenecks, while troubleshooting excessive tempdb utilization and Oracle-to-SQL Server linked-server data translation issues.
● Led technical delivery for up to three analysts and interns across multi-billion-dollar nuclear infrastructure projects, defining Agile user stories, delegating assignments, reviewing deliverables, resolving blockers, and making implementation decisions in Azure DevOps.
● Resolved more than half of an eight-person engineering team’s production bug queue across C#/.NET MVC applications, ETL pipelines, and SQL Server backends while helping establish Git and CI/CD release practices.
Client Data Specialist (Post-Sales Client Consulting) Sirva Toronto, ON (September 2022 – January 2024)
● Delivered post-sales technical consulting for Fortune 500 enterprise clients, translating customer requirements into Python/SQL data-processing pipelines and relational data models to resolve integration challenges and improve enterprise data reliability.
● Led a terabyte-scale data remediation initiative for an at-risk enterprise account, standardizing historical datasets and implementing relational schema and input validation controls to restore customer satisfaction and support account retention.
● Investigated client data discrepancies and integration issues, collaborating with internal stakeholders to troubleshoot technical problems, clarify requirements, and deliver reliable reporting and data solutions.
● Trained and supported client-services teams on KPI definitions, data quality, and metric interpretation, enabling them to explain technical measures, address customer questions, and independently lead enterprise client meetings.
SELECTED PROJECTS & OPEN SOURCE
EconData — Data Engineering & AI Platform
(github.com/muhammadbadar1998/ECONDATA)
● Built a C#/.NET 10 data platform processing 26 macroeconomic indicators across
~275 countries and aggregates, featuring Parquet/DuckDB medallion pipelines, analytics APIs, LLM tool calling, RAG, an AI-agent development harness, and 260 automated tests.
SQL Formatter Plus — Published VS Code Extension, 500+ installs
(github.com/muhammadbadar1998/sql-formatter-plus-3.0)
● Developed and published a TypeScript VS Code extension featuring a custom T-SQL tokenizer, syntax-aware formatting engine, SQL Server-specific language support, and automated unit and integration tests.
Open-Source Contributor — petl Python Data Processing Library
(github.com/petl-developers/petl/pull/682)
● Authored merged PR #682, extending relational schema inference to support JSON column types, backed by unit tests.
EDUCATION, CERTIFICATIONS & CLEARANCE
Honours Bachelor of Arts in Economics — McMaster University (2021) Quantitative Econometrics, Time-Series Modeling & Statistical Analysis Microsoft Certified: Azure Data Fundamentals (DP-900) (2023) Azure Data Services, Relational & Non-Relational Databases, Data Warehousing, Batch & Stream Processing, Analytical Workloads
Google Data Analytics Professional Certificate (2022) SQL, R Programming, Data Cleaning & Transformation, Spreadsheet Analysis, Tableau, Data Visualization & Reporting
OPG Nuclear Site Security Clearance (Eligible for Federal Level 2 Secret)