SQL Server Developer

PROFILE

Analytic thinker, and detail oriented person who constantly seeks opportunities for

improvement. Multifaceted experience with SQL Server including: building reports, database administration, designing databases, and ETL. Innately curious, and always looking for new ways to expand personal knowledge. EXPERIENCE

DATABASE ARCHITECT, SAFEPOINT INSURANCE; TAMPA, FL — 2018-PRESENT

- Collaborate frequently with non-technical users from other departments to create new reports according to business needs, as well as to streamline business processes.

- Designed and built data warehouse with star schema that contains data from multiple sources and systems.

- Used stored procedures to shred data from large and complex XML documents into tables in referential database I built to store its output.

- Cut page load times on user facing SSRS reports from up to minutes to sub-second by optimizing queries, and pre-loading data as needed into tables I setup to update nightly.

- Built financial reports to specifications set by the Accounting Department, and wrote a PowerShell script to save their daily/monthly output into CSV files available to them.

- Took part in data migration from previous policy system to the current one DATA ANALYST, SAFEPOINT INSURANCE; TAMPA, FL — 2015-2018

- Slashed the runtime of slow queries from hours to seconds by restructuring tables, creating indexes, and rewriting inefficient queries. .

- Query reports and data analysis.

- Automated data loads from various sources.

- Wrote queries/reports for requests with ambiguous specifications. SKILLS

Nearly 6 years SQL experience (T-SQL, joins, views, functions, stored procedures, indexes, common table expressions, query optimization, designing databases, ETL)

10 years Excel

4 years PowerShell

3 years XML

2 years SSRS

Python

Microsoft Office Suite

Windows, macOS, and a bit of Linux.

EDUCATION

UNIVERSITY OF SOUTH FLORIDA — B.A. MATHEMATICS, MAY 2015 New York, NY 10016 813-***-**** ******.********@*****.*** MARCOS HOKANSON

Contact this candidate