SQL/ETL Developer/Consultant Resume Bellevue, WA - Hire IT People

SUMMARY:

Results oriented MS SQL Server/ETL/SSIS/Validation/Processing/Developer.
Produce outstanding results and take complete ownership of data projects as requested.
Ready to learn new skills and practice older ones.
Great communication skills, verbally and written, mentor.
Experienced Full Life Cycle design, requirements gathering to end user.

SKILLS:

EMPLOYMENT BACKGROUND:

Confidential, Bellevue, WA

SQL/ETL Developer/Consultant

Responsibilities:

Working as an SQL developer/consultant to import data into an Azure server using SSIS. Created dozens of packages with logging and email of results.
This data came in a variety of forms from SAP to Oracle and Excel and others.
Compensation and incentive SQL to build timeline’s, perform calculations, and report results for the customers proprietary software.
Created stored procedures to move stage data to production tables using merge functions
Meta data and metric data capture systems as well as data stores.

Confidential, Austin, TX

SQL/ETL Developer

Responsibilities:

Helped engineer an “SQL Server Database Solution” and supporting objects for company’s new FIFO inventory valuation processes utilizing SQL 2008r2/2012 with the Visual Studio tool set.
Starting from scratch, successfully imported 26 months of unusable invoice information in multitude of formats utilizing Bulk Copy/SSIS/T-SQL scripting/VB.
Performed extensive data research/cleanup/categorization and processing. The initial round of analysis was executed in a waterfall fashion.
Meta data and metric data capture systems as well as data stores.
Building out data sets for the company to utilize in other system cleanup and data governance.
Automated process’s for quarterly execution and valuation report

Confidential, Austin, TX

ETL Developer

Responsibilities:

Processing and maintenance of many SSIS packages that built a set of data driven XML tables for reporting. XML document validation and error logging using open source code (Schematron and Probatron.Net).

Confidential, Austin, TX

Database Developer

Responsibilities:

Early phases of a medical claims processing system for the Veterans Administration which included requirements analysis and best practice database design documentation.
OLTP Database Schema design and documentation.
Test data creation for ETL processes.

Confidential, Austin, TX

Senior Data Conversion Specialist

Responsibilities:

Primary duties involved the gathering of data from dis-separate systems into our standard data model.
Creating data source/destination mapping documents.
Worked with the production team to develop basic load reports for the clients and solve some issues with error reporting of data loads.
Wrote scripts for diagnosing potential data load problems in the staging database.

Confidential, Austin, TX

SQL Server SSRS/SSIS Developer

Responsibilities:

Active Investor Trading DB Team production support with support of the OLTP database used for traders.
Act as SME in SSIS package design, DTS conversion, and SSRS reporting services. Sit on schema design change meetings.
Busy with multiple projects for customer metrics, executive dashboards, and many reporting requests.
I perform several adhoc data requests as well as spur of the moment requests for compliance and legal teams as needed (6-12 per week).
I perform release reviews as well as manage and perform release through DEV, QA, PRE-PROD and PRODUCTION Environments.
I am Agile and Use Case friendly.
Worked with the disaster recovery team.

Confidential, Richardson, TX

Senior Data Services Specialist

Responsibilities:

Responsible for maintenance and enhancements of several VB client server applications.
SQL server BCP/ETL/SSIS specialist
SQL Server 2008 conversion and upgrade projects on 10 + projects
On call production rotation.
DBA duties as needed…mostly database schema updates as scripts.
Database re-design and upgrade
Documentation and SDM duties.
Responsible for enhancing and maintaining a Visual Basic GUI on a high volume network with data centers in two states.
Designed and implemented an automated process for indexing large data files by certain criterion and making that data available for retroactive loading in to the database thus reducing data load turnaround time from 2 weeks per request to 24 hours.
Rewrote 10 major DTS packages each containing 20+ steps in ActiveX and optimized performance by over 50%.
Optimized and performance tuned 12 major stored procedures including trigger rewrites, increasing response time as much as 500% in some cases.
Maintained 60 + additional stored procedures in two Dev, one Test, and one Production environment.
Wrote stored procedures to auto categorize issues during data loads using table driven business rules, reducing user research time by 200+ %.
Wrote T-SQL scripts for data migration to a new server with a re-designed database.