Usama Said
Mississauga,ON
Summary
Experienced data practitioner with 2+ years in the data sphere, working primarily as a Data Engineer and partially as a Data Analyst. Experience includes mapping and transforming data as well as optimizing ETL pipeline runtimes (using SQL Server, Python, and SSIS) to produce validated data for analysts and stakeholders alike. Also experienced in leveraging analytical tools to draw insights from data, creating dashboards in Tableau to effectively convey results.
Overview
9
9
years of professional experience
Work History
Data Engineer
TD Bank
11.2023 - Current
- Built ETL pipelines to map source data to reporting databases, applying data transformations, calculations, and validation checks to help assess project feasibility.
- Managed ETL pipelines by applying ad hoc updates from source data, ensuring data freshness.
- Optimized data processing by eliminating redundant data, simplifying transformations, and reorganizing data flow across multiple packages to allow for parallel processing, reducing pipeline runtime by 15%.
- Collaborated with stakeholders to refine business processes, resolve bottlenecks, and define datasets, enhancing product quality.
Data Engineer
IGM Financial
06.2022 - 03.2023
- Improved ETL workflows using SAP Data Services and SQL to optimize data warehouse processes, reducing overhead and increasing data accessibility.
- Deployed batch jobs for SAP HANA, ensuring efficient data transformation and system integration.
- Ran complex Oracle SQL queries to ensure data consistency and integrity in client account databases.
- Built and deployed ETL packages adhering to best data quality and transformation practices, ensuring robust data governance.
- Operated within Agile sprints using JIRA, contributing to efficient project delivery.
Data Analyst - Coop
Walmart x University of Toronto
04.2016 - 08.2016
- Analyzed large datasets to identify trends, patterns, and correlations for business insights.
- Modeled monthly, daily, and hourly queuing distributions using NumPy, Matplotlib, and Tableau.
- Conducted a basket analysis to identify product placement within stores.
- Analyzed sales data to identify the correlation between sales amount and payment methods.
- Prepared reports and presented them to professors and management of Walmart.
Education
Honours Bachelor of Science - Chemistry, Business & Science
University of Toronto
06.2019
Skills
- DBMS: PL/SQL, Oracle, SSMS
- ETL Tool: SSIS, SAP Data Services
- Languages: Python, SQL
- Version Control: Bitbucket, Git
- Stakeholder management
- Project Management
- Communication
- Collaboration
Accomplishments
- Junior Data Analyst: NPower graduate
- Microsoft Azure Fundamentals Certificate
- AWS Cloud Practitioner Certificate
Timeline
Data Engineer
TD Bank
11.2023 - Current
Data Engineer
IGM Financial
06.2022 - 03.2023
Data Analyst - Coop
Walmart x University of Toronto
04.2016 - 08.2016
Honours Bachelor of Science - Chemistry, Business & Science
University of Toronto
Similar Profiles
Samiul ShaownSamiul Shaown
Product Operations Lead at TD Insurance, TD BANK GROUPProduct Operations Lead at TD Insurance, TD BANK GROUP
Ashley WidermanAshley Widerman
Team Manager II at TD Auto Finance, TD Bank NATeam Manager II at TD Auto Finance, TD Bank NA
Vedansh VyasVedansh Vyas
Personal Banking Associate at TD Canada Trust (TD Bank)Personal Banking Associate at TD Canada Trust (TD Bank)