SQL Developer/Analyst/Data Engineer
Resume:
Database Developer/Administrator
Professional Summary
Results-driven Database Developer/Administrator with 15+ years delivering data solutions across healthcare, finance and enterprise environments. Expert in designing and implementing SQL and cloud data platforms (Snowflake, Azure Synapse, Databricks), building robust ETL/ELT pipelines (SSIS, ADF, SparkSQL) and authoring performant T-SQL/PL/SQL stored procedures and reports (SSRS/Power BI). Experienced in SQL Server administration—backup/recovery, provisioning, monitoring—and in migrating legacy Oracle/SQL data warehouses to modern platforms. Strong communicator who translates business requirements into reliable, automated data solutions and collaborates effectively with technical and non-technical stakeholders to drive analytics and reporting.
Address
Beaverton, Oregon
***********@*****.***
Phone
Professional Experience
Data Engineer at Providence Health & Services
January 2019 — Present
Develop and deploy views and stored procedures and ETL solutions utilizing Snowflake, Azure Databricks and SparkSQL, Azure Data Factory, Synapse and Snowflake for use in analytics models, dashboards and reporting,
Data Systems Engineer (contractor through TEK Systems) at City of Vancouver, WA
January 2018 — September 2020
Develop and deploy SSRS reports with Oracle data – write Oracle stored procedures for data access. Develop ETL packages for legacy Oracle system to XML files to be loaded into WorkDay utilizing Powershell & SSIS Migrate SSRS 2008R2 databases and services to new SSRS 2016 server, Utilize Analysis skills to facilitate cleanup of legacy data and items.
Migrate an Oracle data warehouse to SQL Server 2016 with SSIS and BIML.
Data Systems Engineer (contractor through VanderHouwen) at FamilyCare Incorporated, OR
April 2017 — September 2017
Develop ELT & ETL processes in SSIS and T-SQL to transfer and normalize data from legacy databases to new “enterprise data portal". Design and develop SSIS packages to directly pull from and push data to Salesforce.com web service platform utilizing CozyRoc’s SSIS controls.
Developer (contractor through Tek Systems) at The Standard Insurance Co, OR
March 2017 — April 2017
Develop Powershell-based processes to do large-scale, deep file crawl through network drives utilizing Win32 API calls to overcome Powershell file path length limits. Access 2015 development to analyze the files as part of Oracle data connections in specific file types
Database Developer at Providence Health Plans (PHP), OR
November 2014 — March 2017
As part of the Reports & Extracts team, develop and maintain a wide variety of SQL Server-based reports with the FACETS platform through Crystal Reports, SQL Server and SQL Server Reporting Services in support of PHP’s various business platforms and groups. 10/2017 – provided additional help to Finance agile team for their year-end backlog items.
Data Conversion Specialist at Viewpoint Construction Software, OR
September 2013 — November 2014
As part of the Data Conversion team for the Professional Services Group, provide in-house and customer-requested customizations and data conversions for the Viewpoint Construction ERP system
**Key Project Accomplishments:**
Utilize various SQL Server skills – T-SQL stored procedures, SSIS, Powershell scripts to develop internal and customer-requested customizations for the Viewpoint ERP system. Utilize linked servers (FoxPro, SQL Server, DB2) for data extraction & load processes. Developed an SSIS package utilizing C# code and the SSIS APIs to manipulate itself to do dynamic data extractions from ODBC databases to SQL Server
Independent Consultant at OR & IL
September 2003 — September 2013
Engaged thru TEK Systems & Comsys **1 Year**
**Clients:** Viewpoint, TRM Corporation, Knowledge Learning Corporation, NetIQ, Hollywood Entertainment, Merrill Lynch/Wilshire Credit Corporation
**Key Project Accomplishments:**
•**Viewpoint** (3/2013 – 9/2013): Provide customer-requested customizations to the Viewpoint ERP database as part of the Professional Services Group (converted to FTE 9/2013)
•**Epiq Systems** (7/2010 – 3/2013): Strong knowledge of various production database systems, performing data analysis, limited developer DBA skills. Tune and improve T-SQL queries and stored procedures. I have begun learning some basic DBA skills to help off-load more mundane requests from the production DBA in support of developer groups. Automate low-level admin tasks, such as ETL tasks, utilizing SSIS, VBScript, command-line utilities.
•**Bank of America Merrill Lynch/Wilshire Credit Corporation** (10/2006 – 7/2010): Maintain, refactor and develop Access front-end solutions to SQL Server 2000 & 2005 databases. Maintain and implement Transact-SQL stored procedures, DTS packages and system jobs in support of key financial and reporting systems for Wilshire Credit Corporation. Provide back-end support to JD Edwards 8.10 implementation on SQL Server 2005. Convert Access-based reports to SQL Server Reporting Services reports as well as new SSRS development.
•**TRM Corporation** (05/2006 – 10/2006): Facilitated the hardware upgrade of over 150,000 ATM machines, by developing an ASP application that interfaced with SQL Server 2005 to efficiently collect and manage data. Also maintained and enhanced Oracle 8i and 11 applications.
•**Knowledge Learning Corporation:** Reengineered several business-critical MS Access applications used to combine SQL Server and Informix databases for field reporting.
•Utilized DTS packages to migrate database objects in SQL Server.
•Enhanced application used as an intermediary between Lawson and PaymentNet.com ASP system.
•Provided SQL Server application support between vendor and users.
•**NetIQ:** Designed and implemented a SQL Server 7 database storing data from 9 SAP reports for comprehensive financial analysis. Created automated DTS packages to load & clean SAP text into database server.
•**Hollywood Entertainment:** Produced custom Crystal Reports for use with the JDA Portfolio Merchandise Management system running on Oracle 8.1.7. Developed several complex queries in Oracle that facilitated reporting.
Database Developer at Abbott Laboratories, Abbott Park, IL
July 2001 — May 2003
Core in-house development team member, producing database applications and supporting enterprise-wide business development and invoice tracking systems.
•Aided project managers with Access, Oracle and other database issues.
•Developed reporting solutions in Crystal Reports and Crystal Enterprise.
**Key Accomplishments:**
•Enhanced reports for several pre-purchased or previously developed Access applications, including Weiland Bank Relationship Manager.
•Seamlessly converted a widely-used financial planning application from Lotus 1-2-3 to Excel 2000. Improved efficiency by replacing Lotus menu interface with a custom menu and 1-2-3 macro functionality with VBA code.
**Environment:** Access, Oracle, Crystal Reports/Enterprise, Lotus, Excel, VBA
Independent Consultant at IL
February 2000 — August 2001
Engaged thru TEK Systems & Alternate Resources **1 year 6 months**
**Clients:** Abbott Laboratories, Council for Adult & Experiential Learning, Motorola, Alternate Resources
**Key Project Accomplishments:**
•**Abbott Laboratories:** Significantly improved and maintained 2 Access database applications managing charitable donations.
•**Council for Adult & Experiential Learning:** Successfully consolidated 50 individualized Access databases into one system for conversion to Act!2000.
•**Motorola:** Migrated data from legacy systems into 2 consolidated enterprise-wide purchasing systems, requiring close work with Purchasing and Project Leads in multiple locations. Utilized Access SQL and VBA to clean, analyze and reformat all data before conversion.
•**Alternate Resources:** Optimized underlying PL/SQL procedures for client’s PeopleSoft financial reports. Modified PeopleSoft panels and Crystal Reports. Developed an Excel-based data query tool to provide functionality not available from client’s Tenfold data system.
**Environment:** Access, Act!2000, SQL, VBA, PL/SQL, Crystal Reports, PeopleSoft
Database Programmer at University of California, San Diego, CA
January 1997 — September 1999
Provided application, Web and database support to the Alzheimer’s disease Cooperative Study and Department of Chemistry Business Office.
**Key Accomplishments:**
•Solely developed Oracle database used for all future clinical trials.
•Constructed UNIX shell scripts to automate functions and support data downloading of critical information from Sybase databases.
•Contributed to maintenance of the departmental Website.
**Environment:** Windows NT, Sun/Solaris, Oracle, UNIX Bourne & C Shell, TCL/Expect, awk, Sybase
Education
University of Washington
B.S., Physics
Present
In Progress
Skills
Databricks and SparkSQL
Synapse
Snowflake
TSQL
PL/SQL
Powershell
Snowflake
SQL Server 2008-2019
Synapse
Oracle 18i
Windows
Linux
Databricks
Azure Data Factory
Azure Data Studio
PowerBI
FACETS
Salesforce.Com ETL
SSIS 2008-2016
SSRS
various ERP and financial systems
VBA
Lawson
SAP
Crystal Reports
MS Excel
Contact this candidate