Dawn Betzel
Ashland City,TN
Summary
Experienced software developer with expertise in SQL, Python, and ETL processes. Skilled in application development and problem-solving to improve system performance. Proven track record in enhancing business intelligence and operational efficiency.
Overview
19
19
years of professional experience
Work History
Senior Solution Developer
Acxiom
Conway, AR
08.2022 - Current
- Advanced SQL for Oracle database
- ETL using custom built system called Fuse
- Created a Python Framework for Python machine learning models
- Maintained and enhanced SAS framework for running SAS data analytics models
- Developed software for embedded systems, coding solutions for both new installations and in-situ hardware.
- Improved and corrected existing software and system applications.
- Coordinated testing and validation procedures through software development lifecycle.
Tier 3 Support Engineer
Invia Robotics
Westlake Village, CA
04.2022 - 07.2022
- Resolved customer inquiries in a timely manner by utilizing problem-solving skills.
- Monitored system performance to ensure optimal functioning of services.
- Implemented backup and recovery procedures to safeguard against data loss.
Sr. BI Developer
Warner Music Group
Nashville, TN
03.2021 - 03.2022
- Python project for matching of invoices and POs using some fuzzy logic after internal processes failed
- Reporting for business purposes using SQL, PowerBI, and Excel VBA
- Will be soon working on AWS instance with SQL Server and SSIS tools
SQL BI Developer
SPPlus
Nashville, TN
03.2020 - 03.2021
- Move MySQL database to SQL Server
- In charge of MySQL data for dashboard portal
- Maintain and support applications
- Create and maintain stored procedures using SQL Server 2008,2012,2016
- Build and maintain data pull from remote servers
- Develop and maintain SSIS packages
- Created optimal technical solutions to user needs with in-depth system analysis.
- Analyzed existing SQL queries to identify opportunities for improvements.
Database Applications Developer
Premier Radiology
Nashville, TN
05.2018 - 02.2020
- Maintain and rewrite custom billing software written as a service in .NET 4
- Maintain and support database stored procedures and the associated programs
- Create new service using Restful API and Entity Framework
- Create and maintain stored procedures using SQL Server 2008, 2012, 2016
- Troubleshoot and debug billing process as needed for efficient business use
- Develop and maintain SSIS packages so that business owners have the data they need to help clients
- Web Development programming using ASP.NET 4 and C#
Database Developer
Healthstream/Press Gainey
Nashville, TN
10.2015 - 04.2018
- Classify textual data using python and machine learning
- Maintain and support Oracle database stored procedures and the associated programs
- Maintain and create T-SQL and PL/SQL scripts, stored procedures, indexes and triggers
- Develop and maintain PxClientSetup interface written in ASP.NET 4, MVC
- Create and maintain stored procedures for survey sampling rules using SQL Server 2008, 2012, 2016
- Develop and maintain SSIS packages so that business owners have the data they need to help clients
- Creation and maintenance of business user reports using SSRS and other tools
- Development and deployment were done using Scrum and Agile team methodologies
Database Applications Developer
Contract Work for UHG, CareHere, Alfa Insurance
Nashville, TN
11.2012 - 10.2015
- Data Analysis for Outreach Database
- Create and maintain SSIS package for campaign data
- C# scripting within SSIS
- Automate client import of data using SFTP through the creation of SSIS jobs
- Create and maintain packages using SSIS that export or import txt files
- Stored procedures and queries using SQL Server 2008 and 2012 to implement business rules
- Create C# scripts for file processing
- Check metadata of files to verify import
- Design data warehouse for Business Intelligence
Database Support Technician
Wright Industries
Nashville, TN
09.2006 - 10.2012
- Maintain custom ERP system using SQL, PL/SQL, VB, VB.NET, C#, PowerBuilder and deploy new code as needed
- Debug and rewrite their ETC (Estimate to Complete) program that they needed to estimate projects, but hadn't been working for the prior 6 months due to loss of programmers
- Facilitated the move from DTS packages to SSIS for SQL Server 2008
- Reworked a large part of their reporting system and facilitated the change from BIDS to RS 2008
- Database maintenance in SQL Server 2000, 2005 and 2008, Pervasive and Oracle RDBMS
- Ensure data transfers (ETL) ran successfully, check logs and optimize database performance
- Create user reports as needed using SSRS, Crystal Reports, ROI, and Centura Report Builder
- Troubleshoot and repair custom applications - 20+ applications recompiled in VB, VB.NET and C#
Education
Certification - Data Science
Springboard
11-2021
NanoDegree - Artificial Intelligence
Udacity
12.2018
M.S. - Software Engineering
University of Illinois at Springfield
12.2011
B.S. - Computer Science
Austin Peay State University
05.2003
Skills
- Advanced SQL
- ETL Process Development
- Business intelligence
- Data analysis tools
- Agile/Scrum Methodologies
- Git workflow management
- Application Development
- Python for Data Science
- Visual Studio Suite, C# and VBNET
- Data reporting
- Code debugging
- Problem solving
Accomplishments
- UIS Honor Society Upsilon Pi Epsilon Association of International Computer Science
Timeline
Senior Solution Developer
Acxiom
08.2022 - Current
Tier 3 Support Engineer
Invia Robotics
04.2022 - 07.2022
Sr. BI Developer
Warner Music Group
03.2021 - 03.2022
SQL BI Developer
SPPlus
03.2020 - 03.2021
Database Applications Developer
Premier Radiology
05.2018 - 02.2020
Database Developer
Healthstream/Press Gainey
10.2015 - 04.2018
Database Applications Developer
Contract Work for UHG, CareHere, Alfa Insurance
11.2012 - 10.2015
Database Support Technician
Wright Industries
09.2006 - 10.2012
Certification - Data Science
Springboard
NanoDegree - Artificial Intelligence
Udacity
M.S. - Software Engineering
University of Illinois at Springfield
B.S. - Computer Science
Austin Peay State University
Similar Profiles
Marisa JosephMarisa Joseph
Data and Delivery Analyst at AcxiomData and Delivery Analyst at Acxiom
Mike DanleyMike Danley
Sr. Director of Sales Solution Consulting at AcxiomSr. Director of Sales Solution Consulting at Acxiom
Tamara BerryTamara Berry
Senior Demand Generation and Director Industry Marketing at AcxiomSenior Demand Generation and Director Industry Marketing at Acxiom
Jason DeereJason Deere
VP Enterprise Sales, Financial Services at AcxiomVP Enterprise Sales, Financial Services at Acxiom
Robert FollisRobert Follis
Owner at Disaster Services UnlimitedOwner at Disaster Services Unlimited