Toronto, Ontario, Canada
Data Engineer with 5+ years building production data platforms, from lakehouse ingestion layers to curated, analytics-ready data products. Skilled in designing ELT pipelines and dimensional models on Azure (ADF, Databricks, Synapse) with deep T-SQL and Python, and experience integrating heterogeneous systems via REST APIs and C#. Comfortable across the modern data stack: medallion architecture, data quality frameworks, and pipeline observability that keeps downstream teams unblocked. Familiar with AI-assisted development workflows and increasingly applying LLM tooling to accelerate data pipeline design and documentation. Delivered in regulated, complex environments where reliability and data trust are baseline expectations . Open to Data Engineer and Analytics Engineer roles across Canada and globally.
• Designed, deployed, and troubleshot cloud-native data solutions on Microsoft Azure, diagnosing pipeline failures and data anomalies across Azure Data Factory, SQL Server, and PostgreSQL environments. • Wrote and maintained Python automation scripts and complex SQL queries for ETL orchestration and data processing; identified root causes and implemented fixes under live production conditions. • Delivered complex T-SQL components including stored procedures, views, triggers, and indexes with thorough documentation standards. • Integrated enterprise systems and Microsoft Dynamics CRM via REST APIs, troubleshooting data flow issues and resolving connectivity and schema mismatch errors across distributed systems. • Managed source code, pipeline deployments, and versioning through Git and Azure DevOps, reviewing code changes to maintain production stability. • Reduced pipeline execution time and manual intervention by 40% by identifying and resolving performance bottlenecks in SQL queries and ETL workflows. • Produced technical documentation covering pipeline architecture, workflow design, and operational runbooks to support knowledge transfer and team onboarding. • Contributed to the design and modelling of enterprise data solutions spanning data warehouses, data marts, and data lakes. • Played key role in migrating data from on-prem database to Azure Cloud databases using Azure Data Factory
• Developed and maintained end to end complex data pipelines using ETL for new and existing modules to perform various database related and system level changes • Extracted and analyzed customer’s data from on-prem and cloud data warehouse using SQL for ad-hoc reports and recommended analysis in business language in different meetings • Collaborated with different cross functional agile teams to establish business needs and translate data into technical solutions • Prepared analytical reports and interactive dashboards in PowerBI for C-suite executives • Created technical knowledge documents that allows Product Owners to understand the process of creating data models and algorithms, data quality and data analysis • KPI Analysis on monthly basis to drive performance and support the field force. Skills: SQL, MSSQL Server, ETL Development, Data Analysis, KPI Analysis, PowerBI, Python, Data Warehousing, Big Data
• Performed customer profiling and demographic analysis in SQL and python of all the life insured people which helped sales team in improving their sale strategies and operations • Designed and implemented Data Warehouse for their insurance system using IBM Cognos and Data Stage which is used by Data Analyst • Built a time series machine learning model for Insurance buying price in Python which indicates the future buying price (Further details about the model read my article Medium Article on Python ) • Partnered with key stakeholders to offer the best data solutions in a highly collaborative and agile environment • Integrated CRM data with their customer portal on ASP.NET Framework using REST API • Developing & maintaining Core Insurance Portal on ASP.NET C# using Oracle. Skills: Data Analysis, SQL, Python, Agile Methodologies, SQL Server, IIS Server, ASP.NET, C#, Oracle, Machine Learning, Exploratory Analysis
Being a Programmer Analyst in Arpatech. I was responsible for the following duties : - Maintaining and Developing applications in ASP.NET C# and VB.NET using SQL SERVER and also managed LIVE Server of those applications. - Looking after client’s everyday tasks including server management and development. - Identify and communicate technical problems, processes and solutions. - Prepare reports, manuals and other documentation on the status , operation and maintenance of software. - Did Research and Development in Mean Stack Development Projects and its implementation. In Arpatech my role was not only limited to Programming and Developing application according to business requirement but I was also responsible of handling the application database and its Live Server as well. Furthermore, I was responsible for the collection and development of client's business needs and then implementing it in the given time frame. Skills: Microsoft Dot Net Framework, C#, ASP.NET,VB.NET, HTML, JQuery, CSS, IIS Server, SQL, Server, JIRA.