Sandy, UT *****
Experience in SQL Server migration, ETL, web development, and database administration. Strong full project life cycle knowledge. Effective problem solving skills and proven ability to work in both independent and team-based environments.
Authorized to work in the US for any employer
Operations Engineer - Database
Galileo Financial Technologies - Salt Lake City, UT November 2017 to Present
Led the on-call and change window rotations, monitored application performance and failures with Splunk. Handled outages and issues related to card processing operations in a PCI environment. Led a project to automate product setup tasks and audit the database. Mentored junior colleagues and met deadlines on over 50 client requests and issues per week. Identified issues with data and applications, designed reporting tools and scripts. Organized the team's workload, led quality initiatives, advised client-facing teams. MySQL Application Developer
SMW Refrigeration & Heating - Tempe, AZ
December 2015 to September 2017
Built PHP apps for ETL, payroll, maps, segmentation, estimates, invoicing, data cleanup, etc. Streamlined and enhanced the corporate accounting and operations system. Built custom CRM integrations which fed data from MySQL to SQL Server and vice versa. The new systems dramatically improved the efficiency of telemarketers, technicians, and office workers at SMW and other HVAC shops.
SQL Server Database Manager
Pearson - Chandler, AZ
December 2015 to November 2016
Worked with a DBA on a critical Windows Server and SQL Server migration. Installed and upgraded SSRS/SSIS, optimized stored procedures, responsible for daily reporting and DBA tasks.
Worked alone to optimize T-SQL transformations for datasets with >100MM records. Built the customer engagement SSAS cube and migrated this customer data to SalesForce. Solely responsible for daily tasks, server problems, and successfully automating all existing SSIS jobs and producing their documentation.
Senior SQL Server Consultant
CVS Health - Scottsdale, AZ
April 2012 to February 2015
Wrote ETL and reporting solutions for audits, end-to-end reporting, data processing, and executive metrics.
Submitted over 20 issue logs for systems integration testing and led the implementation of break-fixes and workarounds for my team's data extract from the Facets system. Deployed jobs, corrected production failures, and was accountable for the full life-cycle of four business-critical projects, including the first end-to-end monitoring solution for the client “NEJE”. The end-to-end visibility yielded major results: keeping the client's business during the CMS Sanction, pinpointing several process failures, stopping executive-level escalations, reduced manual effort, etc. Wrote over 100 business requirements documents and participated in database modeling and design discussions. Wrote concise documentation and work instructions. Education
B.S. in Biochemistry
Arizona State University
A.S. in General Studies
Utah State University
SQL Expert Certification from Oracle Corporation, January 2011