Rhea Engstrom

SQL Developer/Report Writer

Palm Springs, FL

330-***-****

adbbqk@r.postjobfree.com

Solutions-driven SQL developer with a proven record of accomplishment and commended performance in data migration, analysis, automation, and reporting. Proven success building customized solutions improving production processes and operations. Significant experience providing insights, analytics, and business intelligence used to identify opportunities, reengineer processes, and customer service improvement.

TECHNICAL (IT) SKILLS

Data

Management

Data Analysis, Pattern and Trend Identification, Data Quality Assessment, Database Design and Management, Data Modeling

Computer Science

T-SQL, PL/SQL, SSRS, SSIS, SSMS, Power BI, Data Compare and Schema Compare Tools, Advanced Excel Functions, Microsoft Visual Studio

WORK HISTORY

SQL Developer/Report Writer

2/2018 – Current

Clerk & Comptroller, Palm Beach County, Palm Beach County, FL

Led data conversion validation during a successful system migration, also providing data conversion code solutions to application vendor

Develop advanced T-SQL queries with multi-table joins, group functions, subqueries, and T-SQL stored procedures for data analysis and reporting purposes

Reverse engineered and rebuilt key financial processes in SQL reducing resource time by 75%

Create parameterized and ad hoc reports

Assist operations department managers and supervisors with interpreting patterns and trends in data using reports, presentations, and dashboards

Database Developer

1/2013 – 2/2018

Weiss Ratings LLC, Palm Beach Gardens, FL

Successfully migrated data from legacy system through SQL Server, completing 99% records mapping

Built, deployed, and maintained SSIS packages

Automated data extraction from different sources such as Foxpro, Excel, XML, and Flat files

Developed SSIS packages to preserve data integrity between environments during data procurement and processing

Produced ad hoc reports using Excel and SSRS

Converted financial data models and calculations to SQL from Excel and Foxpro

Reformatted data from source tables into staging tables, performed data cleansing and data type conversions before loading into destination table

Created database tables, views, indexes, stored procedures, functions, triggers, and wrote and optimized queries

Jr. QA Analyst

5/2012 – 1/2013

Weiss Research Inc, Palm Beach Gardens, FL

Assisted in creating detailed, comprehensive, and well-structured test plans and test cases

Executed testing processes to ensure data integrity in applications

Identified, recorded, documented, and tracked bugs

Participated in developing technical specification documentation

Developed user manuals for internally developed applications

EDUCATION

Master of Science – Data Analytics

Southern New Hampshire University

Expected date of completion – 3/2021

Bachelor of Science in Information Technology – Software Engineering

University of Phoenix

9/2013

Associate of Science Information Technology – Programming

Kaplan University

8/2009

Contact this candidate