David Sevier adg71e@r.postjobfree.com

**** ******** ****** ****: 858-***-****

San Diego, CA 92129 Skype: live:mephansteras

Database Architect with 20 years of experience in database programming, data modeling, ETL and data warehousing. Proven track record of delivering high quality solutions in agile environments using a mix of industry standards and innovative thinking. Highly experienced at team leadership and mentorship of less experienced team members.

Recent Work History

BI Consultant – Tek Systems 12-2019 – 07-2020

Working at Progenity

Tech: Snowflake, Matillion, NiFi, SSIS, SQL Server, Salesforce, Powershell

Designed and built a system to parse and load expense data to keep the company in compliance with Federal regulations

Designed and built a system to monitor Audit systems and ensure that they were running properly

Imported data mart data into Salesforce

Reviewed potential SSIS/Salesforce components and selected one for company use

Migrated ETL systems from SSIS to Matillion

Database Architect – Skillsoft 09-2014 – 05-2019

Tech: MySQL, Pentaho, Perl, Git

Modeled all new schema changes as well as revamped existing schemas to follow best practices

Improved database performance at all levels of the application and reporting databases reducing slow query times by over 50%

Designed and Implemented a rapid updating Dashboard ETL system that had been attempted and failed numerous times before

Reduced ETL nightly job runtimes from ~8 hours to ~2.5 hours

Automated many recurring processes to be faster, more accurate, and require less human effort

Developed ETL jobs using Pentaho Data Integration

Mentored team members on SQL best practices and query performance

ETL Developer – Millennium Laboratories 01-2013 – 08-2014

Tech: SQL Server, SSIS, C#, Perl

Developed ETL jobs using SSIS and T-SQL

Designed and Implemented a comprehensive ETL Control and Monitoring system

Refactored many processes and Data Models to bring the system up to best practices

Mentored junior developers in T-SQL and SSIS best practices

Contractor – Odesus 06-2012 – 12-2012

Working at Union Bank of California

Tech: SQL Server, SSIS, C#, PowerShell

Developed ETL jobs using SSIS and T-SQL

Developed a Powershell script to aid in refactoring over 1000 procedures, drastically reducing the time needed to complete the project

Developed a Function to convert Oracle Datatypes to SQL Server to standardize development

Contractor – Harmer Consulting 11-2011 – 06-2012

Working at Apollo Global

Tech: Oracle, Talend, Oracle Enterprise Data Quality, Perl

Developed ETL jobs in Talend to support a new BI initiative

Installed Oracle Enterprise Data Quality (OEDQ) into a dev environment

Developed OEDQ jobs to profile and cleanse Source data

Created a Logical Model of the new Data Store for internal and external clients

Liaison between the BI team, University IT, and 3rd party developers

Contractor – Modis 06-2011 – 10-2011

Working at LPL Financial

Tech: SQL Server, C++

Optimized SQL Server Procedures for improved performance

Created Procedures to handle archiving data in large volume environments

Analyzed table indexing for improved performance and space management

Wrote C++ Data Mover application to interface with existing in-house scheduling program

Database Developer – Sony Online Entertainment 05-2008 – 05-2011

Tech: Postgres, Oracle PL/SQL, Talend, Perl

Migrated Oracle systems over to Postgres databases

Designed, built, and maintained mission critical PL/SQL and Postgres codebase

Designed and built a Talend system to extract, process, and deliver game data to a 3rd party client

Founder and Lead Researcher – Latent Knowledge 05-2007 – 05-2008

Tech: MySQL, Pentaho, C++, C#, Perl

Founded a new company for the purpose of researching advanced data mining and artificial intelligence techniques.

Successfully bid on an SBIR Phase 1 grant.

Developed a new data architecture with embedded data mining algorithms for analyzing Aircraft maintenance and logistics information for the Department of the Navy under the SBIR program

Managed Contractors hired to build supporting applications for the system

Designed and built a program to simulate aircraft flight, damage, maintenance, and inventory control for testing purposes.

Senior Consultant – BearingPoint 05-2006 – 07-2007

Tech: Oracle PL/SQL, ErWin, Perl

Architected the entire Data Warehouse ETL system including custom framework, scheduler, and auditing

Modeled aspects of the new Data Warehouse

Successfully researched and developed a system to convert and load legacy county data into a Vendor’s database

Senior Information Analyst – HSBC Auto Finance 11-2000 – 05-2006

Tech: SQL Server, Oracle, Perl, Datastage

ETL Team lead for onshore & offshore developers

Modeled new Data Warehouse functionality

Designed and built new ETL Architecture, Monitoring, and Auditing systems

Led the Transition from the perl homegrown ETL framework over to DataStage, spearheading development, training junior developers, and implementing best practices

Skills:

Computer Languages: PL/SQL, SQL, T-SQL, Perl, C/C++/C#, Visual Basic, Python, Powershell

Databases: Snowflake, Postgres SQL, Oracle, SQLServer, DB2, MySQL, MariaDB

Database Tools: Matillion, PL/SQL Developer, DataStage, Erwin, DBMain, Toad, Toad Modeler, DBDesigner4, Talend, Informatica, Oracle Enterprise Data Quality, SSIS, Pentaho DIS, Spark

Web: HTML, CGI, Web Design

Operating Systems: Windows NT/2000/XP/7/10, Linux/Unix

Office Software: Lotus Notes, Microsoft Word/Excel/Powerpoint/Visio, Latex

Knowledge and Practices: Cloud Architecture, Data Mining, Data Modeling, Structured Analysis and Design, Data Warehousing, Artificial Intelligence, Business Intelligence and Reporting, Agile Development (Scrum), Master Data Management, Data Governance

Education:

Bachelor of Science: Business Administration – Information and Decision Systems from San Diego State University

Masters of Science: Business Administration – Information and Decision Systems from San Diego State University

In Depth ETL methods – Ralph Kimball Group

Contact this candidate