Senior Data Analyst & ETL Consultant
Resume:
SYED IMRAN ASHRAF
647-***-**** ***********@*****.***
PROFESSIONAL SUMMARY
Senior Data Analyst and ETL Consultant with 20+ years of experience delivering enterprise reporting, business intelligence, SQL-based analytics, dashboard development, KPI scorecards, and data warehouse solutions across Utilities, Retail, Supply Chain, and Oil & Gas industries. Strong expertise in SQL, Oracle PL/SQL, Snowflake, Informatica, and business data analysis, with extensive experience transforming complex datasets into actionable business insights.
Proven ability to partner with Product, Revenue, Operations, and executive stakeholders to gather business requirements, develop analytical solutions, create executive-ready reports and dashboards, and improve business decision-making. Experienced supporting global data initiatives, production support, and Agile delivery using Jira and AI-assisted analytics tools to streamline reporting, validation, and documentation.
TECHNICAL SKILLS
Data Analytics & Reporting
Dashboard Development
KPI Scorecards
Executive Reporting
Business Requirements Gathering
Stakeholder Management
Root Cause Analysis
Operational Analytics
Business Process Analysis
Data Storytelling
Microsoft PowerPoint
Data Analysis & Validation
Reporting Automation
BI & Visualization Tools
OBIEE
Business Objects
Oracle APEX
ETL & Data Warehousing
Informatica PowerCenter 9.x/10.x
Informatica Data Quality
Oracle Warehouse Builder
ETL Testing & Validation
Star Schema Modeling
Fact & Dimension Tables
Databases & Cloud
Oracle 10g/11g/12c
SQL Server
Snowflake
Amazon Web Services (AWS)
PL/SQL
Automation & AI Tools
Python
PyTest
REST API Testing
ChatGPT
AI-Assisted Documentation & Analysis
Tools
Jira
Git
AutoSys
ESP Scheduler
Unix Shell Scripting
SQL Developer
Toad
SQL Developer
PROFESSIONAL EXPERIENCE
Senior Data Analyst / ETL Consultant
Enbridge — Toronto, ON
Jul 2025 – Present
Analyzed enterprise business data to identify trends, operational issues, and opportunities for process improvement.
Partnered with Finance, Procurement, Product, and Operations stakeholders to gather business requirements and translate them into analytical reporting solutions.
Developed advanced SQL queries to extract, transform, and analyze large datasets for business reporting and decision support.
Designed KPI datasets, scorecards, and executive reports supporting operational performance monitoring.
Validated reporting accuracy through data reconciliation, transformation validation, row count verification, duplicate analysis, and quality checks.
Supported dashboard enhancement initiatives by validating business metrics and improving reporting accuracy.
Collaborated with cross-functional teams to resolve production reporting issues and improve data quality.
Supported Snowflake cloud migration by validating reporting datasets and business metrics.
Automated ETL validation and reporting processes using Python and PyTest, reducing manual effort.
Participated in Agile ceremonies, sprint planning, issue tracking, and stakeholder review meetings using Jira.
Leveraged AI-assisted tools, including ChatGPT, to streamline SQL development, documentation, reporting analysis, and data validation.
Senior Data analyst / BI Consultant
Hudson's Bay Company — Toronto, ON
Dec 2019 – Apr 2025
Performed business and data analysis supporting retail operations, inventory, revenue, merchandising, and operational performance initiatives.
Developed complex SQL queries, reporting datasets, KPI scorecards, and analytical reports for business stakeholders.
Gathered reporting requirements from business users and translated them into scalable analytical solutions.
Supported executive reporting by preparing dashboards, performance metrics, and business insights for leadership teams.
Worked closely with Product, Operations, and Finance teams to investigate reporting discrepancies and improve data accuracy.
Built and validated reporting datasets using SQL, Oracle PL/SQL, Informatica, and Snowflake.
Participated in enterprise migration projects from Oracle/Informatica to Snowflake on AWS.
Automated reporting validation, reconciliation, and quality assurance processes using PySpark.
Supported production incidents, issue resolution, and release validation using Jira.
Created technical documentation, business process documentation, and analytical reports to support ongoing business operations
Senior ETL / BI Developer
Enbridge — Toronto, ON
Feb 2017 – Oct 2019
Developed enterprise reporting and analytics solutions using Informatica, OBIEE, Oracle SQL, and PL/SQL.
Built and optimized SQL queries for financial and procurement reporting systems.
Supported dashboard implementations and data warehouse reporting enhancements.
Worked with cross-functional teams to validate reporting requirements and troubleshoot data discrepancies.
Automated ETL testing and reporting validation processes using Python.
Improved reporting reliability through workflow optimization and monitoring solutions.
Programmer Analyst / Data Analyst
Canadian Tire — Toronto, ON
Jun 2014 – Dec 2016
Developed SQL and PL/SQL solutions supporting Supply Chain Forecast & Replenishment analytics systems.
Created data mapping documentation and reporting support processes.
Performed backend data analysis, validation, and performance tuning.
Developed Oracle APEX enhancements and reporting modules.
Supported testing, reporting validation, and batch processing automation initiatives.
EARLIER EXPERIENCE
Team Lead / BI Developer
Toronto Hydro
2011 – 2014
Application Support Analyst
Loblaws
2010 – 2011
Senior Programmer Analyst
Toronto Hydro
2005 – 2009
Programmer Analyst
Indus International
1998 – 2004
EDUCATION
Bachelor of Commerce
Diploma in Computer Science
Oracle Developer 2000 Certification
Contact this candidate