Education

• AAS, Hamilton College, Mason City, IA
• BA, Communications, Western Illinois University, Macomb, IL
• AA, Liberal Arts, Southeastern Community College, West Burlington, IA

Certifications

• Microsoft Certified Solutions Associate – Database Development, SQL 2016
• Foundation-Level QA Certification, American Software Testing Qualifications Board
• CompTIA A+ Desktop Technician

Software & Hardware Experience

• ETL development using SQL Server, SSIS, and Alteryx in a combined Salesforce and MSSQL environment (3 years)
• Writing queries for SQL Server, including Teradata, Microsoft, and Oracle platforms (5 years)
• Developing reports in SSRS, MS Report Builder, Power BI, and InfoMaker report development software (5 years)
• MS Office Suite 2007–2016, expert level user of Word, Excel, and PowerPoint (10+ years)
• Microsoft Windows 95-Windows 10 troubleshooting (10+ years)
• MS SharePoint for documentation and forms creation (2 years)
• Adobe Acrobat Professional (5 years)
• XML and HTML development (2 years)

Professional Experience

Wells Fargo, Data Consultant (April 2020–present)

• Writes complex SQL queries in Teradata for data analysis and transformation
• Creates data analysis reports in Microsoft Excel
• Creates and maintains complex ETL processes with SSIS to move data between servers so as to measure key performance indicators for marketing campaigns

 Intoxalock, Data Analyst/Report Developer (September 2019–April 2020)

• Writes complex MSSQL queries for data analysis and transformation
• Creates data analysis reports in SSRS and Microsoft Power BI
• Advises the engineering department on historical patterns of system performances of small-scale mechanical and digital devices

Holmes Murphy & Associates, ETL Developer (November 2018–September 2019)

• Developed workflow packages for insurance benefits department
• Created new database structures in MSSQL for ETL processing
• Wrote complex MSSQL queries for data analysis and transformation
• Assembled ETL workflows in Alteryx for transferring data between MSSQL and Salesforce.
• Performed quality assurance testing in Salesforce front-end environment

Amerigroup Iowa, Business Information Analyst (June 2017–November 2018)

• Worked in the finance department to produce Medicaid reporting and data analysis
• Produced advanced, ad-hoc T-SQL queries for reporting purposes
• Assembled data within Excel, using pivot tables, charts, and trend lines
• Provided low- to high-level analysis of financial trends for the finance director and company executives

Wells Fargo Financial Services, QA Analyst (April 2017–June 2017)

• Worked within a 15-member team with a high degree of collaboration to ensure accurate deployment of internal content management system
• Examined source and targeted files in HTML and XML to verify accuracy of translation to new content system
• Used Access and Excel for error tracking and reporting

Iowa State University, Ames, IA, Support Specialist II (January 2015–February 2017)

• Implemented new Oracle PL/SQL-based browser management and billing software system for animals cared for in the ISU’s Lab Animal Resources department
• Created custom business reports for end users using Oracle SQL Developer 3 and 4, within SSRS
• Generated ad-hoc SQL queries as needed for multiple lines of business and analytic requirements
• Created new views and stored procedures for new system requirements
• Made periodic recommendations to the director of Lab Animal Resources and the Attending Veterinarian on technology issues and system performance
• Collaborated with database administrators to implement database upgrades in coordination with the software vendors
• Gathered end-user requirements, documented them, and either passed them on to the software vendor or developed and implemented them myself
• Performed basic and advanced modifications to the program’s layouts in XML, per requirements gathered from end users
• Conducted in-house training and continuing education sessions for university personnel, including veterinarians, bookkeeping personnel, and animal caretakers
• Served as CorePlus Coordinator for the Lab Animal Resources department, maintaining and troubleshooting department computers and peripherals

Xpanxion, LLC, Ames, IA, QA Tester (February 2013–December 2014)

• Executed test cases and test plans including executing SQL scripts in testing environment.
• Performed comparison queries between T-SQL and PL/SQL
• Verified and prioritized defects and determining their severity
• Updated knowledge base for client project using various tools, including MS Excel, Microsoft Test Manager, Google Drive, and SharePoint

Senior Forms Developer

• Developed PDF reports using Sybase SQL Server
• Delivered QA products under deadline
• Used web-based business analysis software to report to team leaders and other project members

Ortho Computer Systems, Ames, IA, Software Support Representative (May 2000–January 2013)

• Provided phone support of multiple proprietary software programs across a wide variety of platforms
• Conducted over 150 trainings for customers’ office staff on the implementation of proprietary software both on-site and company sponsored training environments
• Trained new employees on software
• Managed software issues across departments