Priya Ananthakumar
Calgary,AB
Summary
Passionate and skilled data professional with 8-9 years of experience in the end-to-end data development lifecycle, encompassing scripting, ETL, analytics and visualization. Possesses strong programming skills in SQL and Python. Holds technical certifications in Snowflake Snow Pro Core, Tableau Advanced, Alteryx. Seeks challenging opportunities in data analytics/ engineering sectors, with a commitment to continuously upskill. Obtained Canadian citizenship ; open to relocation within Canada or US ; Flexible to work either in an office or hybrid work model.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Data Engineer
Alberta Health Services
12 2022 - Current
- Spearheaded data pipelines in Informatica Powercentre along with python and sql scripts for various ETL projects.
- Created design documents, understand ETL specifications and well versed with different source formats (RDBMS, Salesforce, Flat files, XML)
- Worked on multiple databases platforms like Snowflake, Oracle, SQL server, Sybase for analysis and reporting.
- Developed Python scripts to manage data warehouses (data lading, archive, backup, transformation)
- Experience with Azure SQL DB, Azure DevOps, PowerBI
Senior Data Manager
Alberta Health Services
10.2020 - 12.2022
- Engineered Alteryx data pipelines for approximately 8-10 projects, encompassing data collection from various sources (structured and unstructured), transformation operations, and output to relational databases for management consumption
- Collaborated closely with privacy and security teams to enhance data security and privacy on Oracle/ Snowflake platform - Focusing on removing sensitive personal information from ingestion to database.
- Developed Alteryx apps to streamline day-to-day tasks for team, enabling efficient execution with single click
- Played integral role in recruitment process for new team members.
Data Manager
Alberta Health Services
10.2018 - 10.2020
- Orchestrated creation of intricate datasets from diverse sources using Python(pandas, numpy), Alteryx, SQL developer and Tableau prep thereby empowering data analysts to execute complex queries and generate reports
- Created complex datasets which includes transformations using stored procedures/packages and chained/scheduled jobs.
- Responded to management inquiries, providing in-depth insights and analysis related to reports
Associate System Engineer
IBM
06.2015 - 09.2017
- Specialized in Mainframe datasets, utilizing technical skills in COBOL, JCL, and DB2
- Created ad-hoc reports to support business operations
- Updated critical monthly reports with global impact
- Provided on-call support to promptly resolve JCL job failures
- Conducted bug fixes in application code to prevent future errors
- Received training and certification from IBM on DB2
Education
Bachelors in Engineering - Materials Science
College of Engineering Guindy
Chennai 04.2015
Skills
- Data Warehousing, modeling, SCD
- Relational Databases
- Cloud Architecture
- T-SQL, PL/SQL, Python, Power shell
- Snowflake
- Azure SQL DB, Synapse analytics, ADLS, Data Factory
- Relation databases - Oracle, SQL Server, Sybase
- ETL Tools - Alteryx, Informatica Power Centre, SSIS, IICS
- Reporting Tools - Tableau, Power BI
- Microsoft Excel
- SSRS, SSDT
- JIRA
Certification
Coursera : ETL and Data Pipelines using Apache Kafka, Shell, Airflow - April 2023
Snowflake : SnowPro Core - June 2023
Tableau : Tableau Desktop Advanced - Feb 2022
Alteryx Core - Feb 2022
IBM Database Associate DB2 Fundamentals - June 2015
Timeline
Senior Data Manager
Alberta Health Services
10.2020 - 12.2022
Data Manager
Alberta Health Services
10.2018 - 10.2020
Associate System Engineer
IBM
06.2015 - 09.2017
Data Engineer
Alberta Health Services
12 2022 - Current
Bachelors in Engineering - Materials Science
College of Engineering Guindy
Similar Profiles
Nerissa DauloNerissa Daulo
Environmental Services II at Alberta Health Services University of AlbertaEnvironmental Services II at Alberta Health Services University of Alberta
Brenda BaltimoreBrenda Baltimore
Temporary Clinical Supervisor at Alberta Health Services / Recovery AlbertaTemporary Clinical Supervisor at Alberta Health Services / Recovery Alberta
FREDERICK PahanonotFREDERICK Pahanonot
Environmental Services II at Alberta Health Services - University of Alberta HospitalEnvironmental Services II at Alberta Health Services - University of Alberta Hospital