Data Engineer, Analyst

• Sep 2022 - Present

Data Analyst

• Dec 2021 - Sep 2022

• Created dynamic SSIS packages with parameters that loads excel or flat files to staging database tables depending on the file modified dates and calling stored procedures to insert from staging into production database tables by applying business rules and data cleaning. • Created and deployed multiple SSIS packages to SQL servers and automated via SQL agent jobs with email alert failure notifications. • Worked and assisted team members in debugging and updating SSIS pipelines/stored procedures larger than 1000 script lines by running blocks of the code and narrowing down where the error would occur. • Diagnose and solve issues in existing data pipelines • Created and formatted state required healthcare reports using SSISs to refresh underline tables. • Created cluster/non-cluster indexes with included columns on large tables for faster performance. • Created views, functions, and DML triggers. • Worked with updating data warehouse tables with STAR Schema • Connected and utilized Azure blob storage containers and file shares. • Used Git to upload, update, and pull different projects from the remote team file share

Data Analyst Intern

• May 2019 - Aug 2019

•Assisting data analysts query database objects (tables and views) to retrieve and insert result sets into Excel Sheets •using data Export and SSIS • Deploying SSIS packages from Visual Studios to SQL Server • Creating and scheduling SQL Agent Jobs to execute packages with failure notifications • Creating tables, views, stored procedures, and functions • Loading flat files (text and CSV files) into SQL database tables by using SSIS and SQL import wizard • Retrieving data from multiple tables with inner and left joins • Designing SSRS reports linking multiple data sources and data sets • Building/deploying SSRS reports to SSRS reporting servers

Swim Instructor

• May 2018 - Aug 2018

• Created lesson plans to specific needs incorporating each child, resulting in every child passing the swimming proficiency test • Supervised and instructed 4 classes a day, with groups ranging from sizes of 3-8 children (ages 4-15) • Created lesson plans to specific needs incorporating each child, resulting in every child passing the swimming proficiency test • Supervised and instructed 4 classes a day, with groups ranging from sizes of 3-8 children (ages 4-15)

Lifeguard

• May 2016 - Aug 2016

• Examined injured persons and administered first aid or cardiopulmonary resuscitation • Maintained quality of the pool by testing and adjusting PH and temperature levels when necessary • Complete and maintain records of weather and pool conditions, emergency medical treatments performed, and other relevant incident information • Managed recreational demonstrations to entertain resort guests • Examined injured persons and administered first aid or cardiopulmonary resuscitation • Maintained quality of the pool by testing and adjusting PH and temperature levels when necessary • Complete and maintain records of weather and pool conditions, emergency medical treatments performed, and other relevant incident information • Managed recreational demonstrations to entertain resort guests