Heather Sorrells Email & Phone Number

Nashville, Tennessee, Us

- Data Pipelines: Built and maintained AWS cloud native data pipelines using TypeScript Lambdas deployed with Pulumi CI/CD pipelines to pull data from partner APIs and write responses to either DynamoDB or S3 buckets then migrate that data into Snowflake raw, integrated and presentation layers.- Data Migration: Utilized both AWS Schema Conversion Tool and Data Migration Service to migrate legacy MS SQL Server data systems into AWS Aurora Postgres databases. - Documentation: Documented how to build AWS cloud native data pipelines using TypeScript Lambdas, DynamoDB, S3 buckets, Pulumi, and Snowflake.

Remote, Us

- Data Migration: Built and maintained dbt data models in Redshift and Snowflake published via CircleCI pipelines. Assisted with data migration work from Redshift to Snowflake.- Data Monitoring: Developed data pipeline monitoring alerts in Datadog by parsing application logs. Integrated alerts into Slack.- Data Optimization: Monitored query performance during our data migration from Redshift to Snowflake to make sure we had parity or better. Optimized SQL queries in Redshift and Snowflake to improve run times and reduce computation costs.- Documentation: Developed and documented alert procedures in Confluence for on-call shift changes. Documented data application architecture and common problems or questions in Confluence to help "pay it forward" to other members of the team.

Seattle, Washington, Us

- Pipeline Migration: Tasked in a QE role to document and assume QE duties from the client. Increased resilience of stage deployment process by improving CI/CD testing suite in Rio. Executed deployment from Dev to Staging Airflow pipelines during feature deployments and log4j security vulnerability remediation work. Improved efficiency and data quality by researching and recommending code improvements by creating scripts and documenting processes.- Data Viz Project: Created reports using MS Report Builder and Power BI. Filled the Dev QA role which developed status tracking and executed testing and deployment of reports to client QA.- DE Buddy Project: Automated the assigning of mentors to new DE hires using MS Power Automate with SharePoint forms to collect data, Excel as DB, and Office Scripts (TypeScript).- Cloud DE Academy: a 3-week training program for new hires focused on AWS and Snowflake. Achieved AWS Certified Cloud Practitioner during 3rd week.

Paris, France, Fr

- Snowflake COE group: Assisted in creating demos for Snowflake/AWS migrations- Snowflake Hackathon: Created PowerPoint presentation for potential Snowflake migration- DE Academy program: 4-week new DE hire program. Completed partner training for Snowflake.- Learn new technologies including Snowflake and Datadog

Lanham, Maryland, Us

- Provide support and guidance to the students attending various Full Stack Web Development Program operated by Trilogy Education Services.- Assist students of varying skill levels with code activities, homework, and projects related to front end, back end, and full stack development.- Reinforce lesson material presented by the lead instructor by helping students with questions and reviewing material one-on-one.

Lanham, Maryland, Us

-Assist students of varying skill levels with code activities, homework, and projects related to front end, back end, and full stack development-Update and maintain class repository hosted on Gitlab, manage distribution of class materials-Take attendance and work with the instructor to approve and track remote requests and absences-Answer & research student questions, be available for help during daily office hours before and after class

* Company is a parent corporation for truck stop plaza, two restaurants, a bar, and a hotel.* Hired for daily cash deposits and A/P for one restaurant, but promoted to handling all A/P and to assist prepping payroll within three months.* Improved efficiency & organization by updating all filing systems and paperwork flow.* Assigned special projects such as becoming a ProctorU proctor to certify restaurant personnel and learning how to program a label maker with Excel import to train deli personnel and general manager on usage and operation.

* Updated the official employee handbook for Trust Operations Trading Desk and created a detailed Trading Desk How-To manual with procedures, protocols, and graphics.* Hired as the primary trader for money market accounts and trained as backup trader for mutual fund accounts within 4 months.* Reduced the backlog of document scanning from one year down to one week within 6 months once assigned.

* Promoted to office manager within the first year which allowed me to implement employee cross-training and development of position duty handbooks.* Hired as “Cashier” and promoted to “In-House Financing Accounts Manager” within 3 months.* Reconciled over 200 in-house financing accounts to establish a reconcilable ledger for active accounts.* Reduced completion time of end-of-month duties from 10 days to 3 days.

Bachelor'S Degree, Management Information Systems And Business Analytics

Certificate, Full-Stack Web Development

Associate'S Degree, Economics