Post Job Free
Sign in

Data & Application Developer (RAG, ETL)

Location:
Toronto, ON, Canada
Posted:
November 18, 2026

Contact this candidate

Resume:

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)



Contact this candidate