SUMMARY:

• 15+ years of experience delivering ETL, data migration and data integration solutions for database and data warehouse projects with full SDLC experience
• Experience managing teams of developers, software product support and offshore assets
• Experience with various ETL, database and reporting technologies: Microsoft SSIS, IBM Information Server (Datastage), Talend, Informatica Cloud, Oracle, Microsoft SQL Server, Sybase, UNIX shell scripting, Perl, Microstrategy, Tableau, ERWin, Powerdesigner and Visio

PROFESSIONAL EXPERIENCE:

Senior ETL Developer

Confidential

Responsibilities:

• Stood up and managed a 24/7 on - call support service for the BI team of a multinational manufacturing client resulting in a 43% reduction of calls to the developers for ETL issues
• Developed policies, procedures, and materials for on call service, including metrics to measure team performance and track overall improvement over time
• Transitioned to a role providing senior level ETL services using Datastage 8.5, 11.5 and SSIS/SQL Server 2012
• Support both new project development and “break fix” scenarios for an ETL infrastructure that contains over 5000 ETL jobs supporting a data warehouse processing feeds from multiple locations and time zones.
• Evaluate ETL code and provide guidance on best practices and opportunities for improvement in daily data processing.

Consultant

Confidential

Responsibilities:

• Assisted client with SSIS ETL development and assessment of current ETL strategy with the goal of identifying issues affecting the current quality of data
• Developed SSIS code to load client data warehouse tables
• Assisted test team with creating and loading data to test specific cases as needed

Confidential

ETL Developer/Consultant

Responsibilities:

• Technologies: Talend 5.5.x and 6.0.x, Microsoft SQL Server 2008, MySQL
• Role: Used Talend to provide an automated framework for various applications that had previously been manually executed.
• Used Talend to integrate Java, R, and C# modules used to analyze FAA flight data
• Installed and administered Talend.
• As ETL Developer, responsible for providing technical expertise for the EDRM project which provides data warehousing and reporting services to GSA. As part of this effort, participated in the following activities:
• Implementation of ETL using IBM Datastage to load staging areas and Enterprise Data Warehouse
• Interface with test team to define and execute test strategy
• Troubleshooting and administration of Datastage environment
• Developing dashboards using Tableau

Senior Consultant

Confidential

Responsibilities:

• As Data Quality Lead, responsible for providing technical direction regarding the Data Quality aspect of the ETSS project, which provides management and technical assistance for the collection, warehousing, reporting, and customer services center functions for the Department of ’s program performance data. In addition, provides support for ETL development on the Department of ’s Enterprise Data Warehouse. As part of this effort, participated in the following activities:
• Gathering requirements in support of the development of DataFlux routines to assess the quality of data collected and reported by the US Department of . The collected data can be related to school demographics, test results, graduation rates, staff and personnel, etc.
• Development and implementation of DataFlux routines during periodic data quality assessments
• Design and management of a Data Quality Metadata Repository to store results generated during the assessment of data quality
• Supported requirements and design as well as led the data integration migration effort of the first phase of the EMDR (EDFacts Metadata Repository), a web-based application with an Oracle database, to replace the legacy database which stored metadata related to the collection of US Department of data
• Input into data migration test and implementation strategy
• Implementation of ETL using IBM Datastage to load Enterprise Data Warehouse

Confidential

Responsibilities:

• Microsoft SSIS, MS SQL Server 2008
• As ETL Lead, responsible for providing senior ETL design and development leadership to provide a standardized/uniform data warehouse solution to address the information needs of the key business areas across the enterprise. As part of this effort, participated in the following activities:
• Gathering requirements in support of the development of a unified data model that represents the corporate business view and supports varied corporate initiatives
• Design and development of an automated ETL infrastructure utilizing Microsoft SQL Server Integration Studio and Windows DOS batch scripting
• Management of offshore ETL development team and input into direction of ETL and test strategy

Confidential

Responsibilities:

• IBM Datastage, MS SSIS, Oracle 10g, Microsoft SQL Server 2008
• As ETL Technical Lead, responsible for providing senior ETL design and development leadership to provide data to an integrated suite of applications developed by Confidential that provide project managers actionable information related to project management activities.. As part of this effort, participated in the following activities:
• Design and development of an automated ETL infrastructure utilizing IBM Information Server and UNIX scripting
• Design and development of additional ETL functionality to integrate Microsoft Project Server data with corporate financial data to provide Earned Value Management reporting using Microsoft SSIS
• ETL performance tuning
• Participation in development of a unified data model that represents the corporate business view and supports varied corporate initiatives
• Gathering requirements and mapping corporate data sources to a unified data model
• Provide technical leadership to members of development team to ensure completion of objectives

Confidential

Confidential

Responsibilities:

• Responsible for providing senior ETL design and development leadership, both performing and managing the technical portion of the project scope, which was being delivered using a joint Claraview/subcontractor project team. The team delivered a successful pilot program to the customer as well as prepared the first phase of the program for deployment into the production environment. Successfully completed the following activities:
• Installation, configuration and administration of IBM’s Information Server software suite that was acquired for DMT: Information Analyzer, Quality Stage, DataStage and Metadata Workbench
• Design and implementation of an automated ETL infrastructure utilizing Information Server and UNIX scripting
• Participation in development of a unified data model that represents the corporate business view and supports varied corporate initiatives
• Gathering requirements and mapping corporate data sources to a unified data model

Confidential

Responsibilities:

• IBM Datastage, MS SSIS, Oracle 10g, Microsoft SQL Server 2008, Microstrategy
• As a BI developer for the project to develop the FMP solution that collects and integrates travel data of U.S. Federal Law Enforcement Officers (LEOs) and Confidential agents, responsibilities included ETL development using Ascential DataStage Parallel edition and PL/SQL Stored Procedures to support reporting via a Microstrategy front end.

Systems Engineer

Confidential, Chantilly, VA

Responsibilities:

• Oracle 9i, PeopleSoft, Business Objects, Autonomy IDOL, Sybase ASE, MS SQL Server 2000, Perl, Embarcadero DT Studio
• Developed Perl modules for parsing data and automated scripts for deployment
• Developed ETL code using Embarcadero DT Studio

Database Developer

Confidential, Dulles, VA

Responsibilities:

• UNIX Shell scripts and Transact-SQL (Sybase IQ and ASE)
• Lead Sybase DBA and lead developer for process to load custom Sybase IQ schema used for actuarial analysis

Senior Consultant

Confidential, McLean, VA

Responsibilities:

• Microstrategy 7, Powerbuilder, Sybase SQL Server (with SYBASE Replication Server)
• Lead DBA for International mining client and development of custom Powerbuilder modules

Programmer/Analyst

Confidential, Fairfax, VA

Responsibilities:

• Powerbuilder development and management of software production support team