I am a Senior Data Analyst and Engineer with over 15 years of experience designing scalable data solutions for healthcare, public sector, and enterprise environments. I specialize in developing custom AI and machine learning systems without relying on frameworks, which helps modernize legacy reporting and drive cloud migration strategies. I enjoy working hands-on with complex ETL pipelines, cloud platforms like Azure and AWS, and leveraging large language model APIs for similarity search, embeddings, and metadata inference. My inventive approach bridges traditional enterprise systems with emerging AI-native architectures, making data work smarter and more efficient.

Soheil Ramazani

I am a Senior Data Analyst and Engineer with over 15 years of experience designing scalable data solutions for healthcare, public sector, and enterprise environments. I specialize in developing custom AI and machine learning systems without relying on frameworks, which helps modernize legacy reporting and drive cloud migration strategies. I enjoy working hands-on with complex ETL pipelines, cloud platforms like Azure and AWS, and leveraging large language model APIs for similarity search, embeddings, and metadata inference. My inventive approach bridges traditional enterprise systems with emerging AI-native architectures, making data work smarter and more efficient.

Available to hire

I am a Senior Data Analyst and Engineer with over 15 years of experience designing scalable data solutions for healthcare, public sector, and enterprise environments. I specialize in developing custom AI and machine learning systems without relying on frameworks, which helps modernize legacy reporting and drive cloud migration strategies.

I enjoy working hands-on with complex ETL pipelines, cloud platforms like Azure and AWS, and leveraging large language model APIs for similarity search, embeddings, and metadata inference. My inventive approach bridges traditional enterprise systems with emerging AI-native architectures, making data work smarter and more efficient.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate
Intermediate
Intermediate
See more

Language

English
Fluent
Persian
Advanced

Work Experience

Data Engineer at Assent Compliance
May 31, 2025 - July 20, 2025
Developed a custom LLM-powered system to analyze and optimize thousands of existing SSRS reports without using frameworks. Designed similarity scoring pipelines using OpenAI API and embedding models to identify duplicate reports and queries. Ingested JIRA ticket metadata and report usage metrics creating dashboards to highlight high-traffic reports. Proposed and prototyped Snowflake migration schemas and built internal pipelines linking reports, tickets, and source data to enable clustering, deduplication, and trend analysis at scale.
Data Engineer at Assent Compliance
September 30, 2023 - July 20, 2025
Developed a custom LLM-powered system to analyze and optimize thousands of existing SSRS reports without using frameworks. Designed similarity scoring pipelines using OpenAI API and embedding models to identify duplicate reports and queries. Ingested JIRA ticket metadata and report usage metrics creating dashboards to highlight high-traffic reports. Proposed and prototyped Snowflake migration schemas and built internal pipelines linking reports, tickets, and source data to enable clustering, deduplication, and trend analysis at scale.
Data Engineer at TransLink
December 31, 2024 - July 20, 2025
Designed and implemented a real-time Vehicle Health Monitoring dashboard using Azure EventHub, Synapse Analytics, and Data Explorer. Built scalable ingestion and transformation pipelines using PySpark and SQL to support diagnostics and performance across fleet operations. Conducted detailed data analysis identifying anomalies and quality issues. Developed automated data quality controls and data models aligned with enterprise architecture. Collaborated with BI and warehouse teams to maintain consistent data definitions and governance.
Data Conversion Analyst at TransLink
March 31, 2024 - July 20, 2025
Led documentation and analysis of data processes across asset management, finance, and supply chain systems assessing migration requirements. Created data dictionaries, integration flow diagrams, and logical models to support ERP migration. Built and supported ETL workflows using SSIS. Coordinated with stakeholders and vendor teams under Scrum framework using Azure DevOps. Developed traceability matrices, test plans, UAT scenarios, and delivered post-migration SOPs and support materials.
Business Information Data Analyst at TransLink
April 30, 2022 - July 20, 2025
Resolved data integrity issues in the enterprise data warehouse by profiling source systems and validating schemas. Applied machine learning techniques to backfill missing historical data to improve analytics accuracy. Designed custom data pipelines using Python, SQL, and Azure Data Factory. Tuned database performance by optimizing query plans and indexes supporting reporting workloads.
Senior Data Analyst at HealthSpace US & Canada
December 31, 2021 - July 20, 2025
Led large-scale data conversions from legacy on-premises systems to cloud-based SaaS platforms across government agencies. Streamlined data migration and transformation processes with SQL, Python, MSSQL, SSIS, and Azure Data Factory. Collaborated cross-functionally to ensure data accuracy, compliance, and continuity. Maintained version-controlled ETL pipelines using Git and served as technical liaison between clients and internal teams.
Senior Data Analyst at Morneau Shepell
January 31, 2020 - July 20, 2025
Delivered regular and ad-hoc financial reports using SQL, SSRS, and Power BI supporting multiple business units. Played a key role in CRM migration from Microsoft Dynamics 365 to Salesforce, cleaning and transforming customer data. Worked closely with finance, marketing, and IT to align data definitions and support downstream reporting. Developed standardized SQL scripts and reporting templates reducing operational overhead.
Data Analyst at Alberta Health Services
August 31, 2014 - July 20, 2025
Performed data analysis and reporting for HIV and Hepatitis studies contributing to scholarly publications. Developed a custom cost engine integrating clinical service data for budgeting and planning. Designed automated tools for importing lab results and genetic data improving clinical reporting. Created interactive dashboards and reports supporting healthcare staff and administrators. Collaborated with epidemiologists managing provincial and national data systems.
Data Analyst at Alberta Health Services
November 30, 2016 - July 20, 2025
Performed data analysis and reporting for HIV and Hepatitis studies contributing to scholarly publications. Developed a custom cost engine integrating clinical service data for budgeting and planning. Designed automated tools for importing lab results and genetic data improving clinical reporting. Created interactive dashboards and reports supporting healthcare staff and administrators. Collaborated with epidemiologists managing provincial and national data systems.
Statistics Analyst at Government of Northwest Territories
March 31, 2015 - July 20, 2025
Developed statistical models and forecasting tools to support territorial policy and planning. Created automation pipelines for processing datasets from government and third-party sources. Maintained the Bureau of Statistics online data portal ensuring public access to accurate indicators and trends. Produced reports and dashboards for surveys on social, economic, and demographic data across the territory.
Senior Systems Analyst at Nova Scotia Health Authority
April 30, 2013 - July 20, 2025
Led system integration, data migration, and software development efforts across provincial and federal healthcare IT systems using Microsoft .NET and MSSQL. Designed and maintained dashboards tracking blood inventory and expiry dates. Built data conversion tools supporting national blood surveillance initiatives. Developed applications automating lab data submission processes. Ensured interoperability of systems aligning with security and privacy standards. Authored technical and policy documentation supporting IT operations and compliance.
Software Developer at KLJ Computer Solutions
December 31, 2009 - July 20, 2025
Developed and maintained custom web applications using .NET, ASP, and MSSQL for healthcare, insurance, and accounting clients. Integrated accounting software like QuickBooks and Sage into web platforms for billing and financial tracking. Led data migration and modernization efforts for legacy systems improving reliability and automation. Enhanced front-end interfaces using JavaScript, AJAX, XML/XSLT, and CSS modernizing legacy tools.
Data Engineer at Assent Compliance
May 31, 2025 - July 20, 2025
Developed a custom LLM-powered system to analyze and deconstruct thousands of SSRS reports, extracting SQL queries and metadata to optimize and consolidate reporting. Designed similarity scoring pipelines using OpenAI API and embedding models to identify duplicate and overlapping reports. Created dashboards combining JIRA ticket metadata, report usage, and data access logs. Proposed Snowflake migration schemas and built internal pipelines for clustering, deduplication, and trend analysis using Python, SQL, ChromaDB, and ElasticSearch.
Data Engineer at Assent Compliance
September 30, 2023 - July 20, 2025
Developed a custom LLM-powered system to analyze and deconstruct thousands of SSRS reports, extracting SQL queries and metadata to optimize and consolidate reporting. Designed similarity scoring pipelines using OpenAI API and embedding models to identify duplicate and overlapping reports. Created dashboards combining JIRA ticket metadata, report usage, and data access logs. Proposed Snowflake migration schemas and built internal pipelines for clustering, deduplication, and trend analysis using Python, SQL, ChromaDB, and ElasticSearch.
Data Engineer at TransLink
December 31, 2024 - July 20, 2025
Designed and implemented a real-time Vehicle Health Monitoring dashboard using Azure EventHub, Synapse Analytics, and Data Explorer to ingest streaming telemetry data. Built scalable PySpark and SQL pipelines for fleet diagnostics and performance monitoring. Coordinated with data stewards to identify data quality issues and developed automated data quality controls. Maintained data models aligned with enterprise architecture and supported master data management initiatives.
Data Conversion Analyst at TransLink
March 31, 2024 - July 20, 2025
Led documentation and analysis of data processes across asset management, finance, and supply chain systems using SQL and Azure SQL for ERP migration requirements. Created data dictionaries and integration flow diagrams. Built and supported ETL workflows with SSIS. Coordinated with vendor teams under Scrum framework and developed test plans and UAT scenarios. Delivered SOPs and knowledge base materials for operational readiness.
Business Information Data Analyst at TransLink
April 30, 2022 - July 20, 2025
Resolved data integrity issues in the enterprise data warehouse through source system profiling and schema validation. Applied machine learning to backfill missing historical data. Designed custom data pipelines using Python, SQL, and Azure Data Factory. Tuned database performance through query and index optimization for reporting workloads.
Senior Data Analyst at HealthSpace US & Canada
December 31, 2021 - July 20, 2025
Led large-scale data conversions from legacy on-premises systems to cloud-based SaaS platforms for government client agencies. Streamlined data migration and transformation with SQL, Python, SSIS, and Azure Data Factory. Ensured data accuracy, compliance, and continuity while acting as liaison between clients and internal teams. Maintained version-controlled ETL pipelines using Git.
Senior Data Analyst at Morneau Shepell
January 31, 2020 - July 20, 2025
Delivered financial reports supporting multiple business units with SQL, SSRS, and Power BI. Key participant in enterprise CRM migration from Microsoft Dynamics 365 to Salesforce, including data cleaning and transformation. Collaborated with finance, marketing, and IT teams to maintain data integrity and alignment post-migration. Developed standardized SQL scripts and report templates to reduce overhead.
Data Analyst at Alberta Health Services
August 31, 2014 - July 20, 2025
Analyzed and reported on national and international HIV and Hepatitis studies contributing to peer-reviewed publications. Developed a custom cost engine integrating clinical data for budgeting. Automated import tools for lab results and genetic data improving reporting accuracy and availability. Built dashboards for clinical and public health stakeholders and collaborated with epidemiologists on multi-system data management and analysis.
Data Analyst at Alberta Health Services
November 30, 2016 - July 20, 2025
Analyzed and reported on national and international HIV and Hepatitis studies contributing to peer-reviewed publications. Developed a custom cost engine integrating clinical data for budgeting. Automated import tools for lab results and genetic data improving reporting accuracy and availability. Built dashboards for clinical and public health stakeholders and collaborated with epidemiologists on multi-system data management and analysis.
Statistics Analyst at Government of Northwest Territories
March 31, 2015 - July 20, 2025
Developed statistical models and forecasting tools to support territorial policy and planning. Created automation pipelines for statistical datasets from government and third-party sources. Maintained the online Bureau of Statistics data portal for public access to indicators and produced reports and dashboards on social, economic, and demographic data.
Senior Systems Analyst at Nova Scotia Health Authority
April 30, 2013 - July 20, 2025
Led system integration, data migration, and software development in provincial and federal healthcare systems using Microsoft .NET and MSSQL. Designed a Provincial Red Blood Cells Dashboard for expiry tracking. Built transfusion data conversion tools for Public Health Agency of Canada supporting national surveillance. Developed automation applications and facilitated interoperability ensuring compliance with security and privacy standards. Authored technical and policy documentation.
Software Developer at KLJ Computer Solutions
December 31, 2009 - July 20, 2025
Developed custom web applications for healthcare, insurance, and accounting clients using .NET, ASP, and MSSQL. Integrated QuickBooks and Sage accounting systems to streamline billing and invoicing. Led legacy system modernization to improve reliability and automation. Enhanced front-end interfaces with JavaScript, AJAX, XML/XSLT, and CSS.

Education

Health Information Management at Canadian Health Association
January 1, 2011 - December 31, 2013
Computer Software & IT Program at Azad University
January 1, 2001 - December 31, 2003
Health Information Management at Canadian Health Association
January 1, 2011 - December 31, 2013
Computer Software & IT Program at Azad University
January 1, 2001 - December 31, 2003

Qualifications

Microsoft Data Science Program
January 1, 2019 - December 31, 2020
SQL SSIS & SSRS
January 1, 2013 - December 31, 2013
Microsoft Data Science Program
January 1, 2019 - December 31, 2020
SQL SSIS & SSRS - Web Age Solutions
January 1, 2013 - December 31, 2013

Industry Experience

Healthcare, Government, Transportation & Logistics, Financial Services, Software & Internet