TSG INTERNATIONAL, LLC
INFORMATION SYSTEMS

Highly motivated, quality minded ETL, Data Warehouse and Business Intelligence developer. Mr. Roder has thirteen years of ETL experience with a wide variety of other programming skills and languages on an assortment of hardware platforms including eight years of expert Informatica PowerCenter skills. Background includes successful implementation of marketing and financial Data Warehouses, payroll, Human Resource, OLTP and Operational Data Store systems in wide variety of business including telecommunications, pharmaceutical, agribusiness, healthcare, publishing, banking and defense. Mr. Roder combines a superior work ethic with excellent communication and interpersonal skills.

Technical Summary

Environments	UNIX, Windows NT, DOS, WWW
ETL Tools	Informatica PowerCenter, Ascential DataStage
Languages	UNIX shell, SQL, PL/SQL, Perl, C/C++, Java, HTML
GUI Tools	Microsoft C++, PowerBuilder, Visual Basic, Neuron Data
Databases	Oracle, Sybase, Access, Universe, SQL Anywhere
Webmaster	http://www.roder.com, http://denver.harlequins.org

Experience Summary

Client: Lockheed Martin	Littleton, CO
Position: Senior ETL and Data Warehouse Developer	10/08 - Present

Senior ETL and Data Warehouse Developer on large scale integrated Human Resources Data Warehouse. Loaded several disparate sources from a number of external vendors to create an integrated Data Warehouse to provide client with automated, efficient and integrated services for:

• Recruitment and Hiring
• Personnel and Payroll Action Processing
• Workforce Planning
• Position Management/Position Classification
• Benefits Management

Senior ETL and PowerCenter developer on a Data Warehouse project. Primarily using Informatica PowerCenter 7.1 to develop and enhance programs to migrate data sourced from third party customer complaint software to reporting data marts. Responsibilities include, but are not limited to:

• Working with the Data Warehouse Architect to perform source system analysis and identification of key data issues via analysis of the data profiling results and queries
• Assistance in the creation of ETL design specifications
• Development of Informatica mappings, mapplets, workflows and worklets
• Design and development error handling processes
• Assisting in the implementation of the scheduling strategy
• Working with business partners to review prototypes and develop iterative revisions.
• Participation in unit and system test process
• Performing troubleshooting and providing resolutions to ETL issues

Senior ETL and PowerCenter developer on an Data Warehouse project. Primarily using Informatica PowerCenter 7.1 to develop and enhance programs to migrate data sourced from relational sources. Designed testing requirements and code modules according to specifications and client standards. Worked within a team to contribute to the successful delivery of an Data Warehouse.

• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental Informatica mappings and workflows to provide data for Data Warehouse.
• Develop, test and implement break/fix change tickets for maintenance and enhancement of Operational Data Store.

Senior ETL and Informatica developer on a Data Warehouse project. Primarily using Informatica PowerCenter 7.1 to design and develop a corporate Inventory and Procurement Data Warehouse. Designed testing requirements and code modules according to specifications and client standards. Prepared test plans and modules. Worked within a team to contribute to the successful delivery of a corporate Data Warehouse.

• Develop, test and implement Procurement Data Mart
• Develop, test and implement Manufacturing Data Mart
• Upgrade from Informatica 5.1 to Informatica 7.1.2

Senior ETL and Informatica developer on a Data Warehouse project. Primarily using Informatica PowerCenter 7.1 to maintain and enhance corporate Data Warehouse. Designed testing requirements and code modules according to specifications and client standards. Prepared test plans and modules. Worked within a team to contribute to the successful maintenance and enhancement of a corporate Data Warehouse.

• Develop, test and implement break/fix change tickets
• Develop, test and implement Release 3.2 enhancement requests
• Respond to customer calls as necessary
• Provide on-call 24x7 support to COSTAR program

Senior ETL and DataStage developer on a Data Warehouse project. Primarily using Ascential DataStage 7.0 to migrate data sourced from relational sources. Designed code modules according to specifications and client standards. Worked within a team to contribute to the successful delivery of data warehouse.

• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental DataStage jobs to provide data for data warehouse using Ascential DataStage 7.0.
• Wrote complex DataStage jobs to populate marketing data mart to assist Dex Media sales staff in preparing for new sales campaign and to populate historical data in marketing data warehouse.

Senior ETL and Informatica developer on a Data Warehouse project. Primarily using Informatica PowerCenter 6.2 to migrate data sourced from mainframe and relational sources. Designed testing requirements and code modules according to specifications and client standards. Prepared test plans and modules. Developed program and system documentation. Worked within a team to contribute to the successful delivery of an Operational Data Store.

• Translated raw HIPAA X12 requests into proprietary mainframe source files using Informatica PowerCenter 6.2 to assist client to become HIPAA compliant.
• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental Informatica mappings and workflows to provide data for Operational Data Store.

Senior ETL and Informatica developer on a Financial Data Warehouse project. Sourced from several disparate data sources including mainframe and legacy Oracle database financial data systems for reporting to SEC and Federal Authorities. Worked within a team to contribute to the successful delivery of a Financial Data Warehouse from the ground up.

• Senior ETL and Informatica developer responsible for ETL for the Northstar financial Data Warehouse project.
• Successfully sourced mainframe financial data into Oracle8i Data Warehouse using Informatica PowerCenter 5.1.
• Primarily responsible for design and coding of fallout process to back fill missing data elements.
• Worked within a team to populate Type I and Type II slowly changing dimension customer tables from several mainframe flat files.

Senior ETL developer on a data consolidation project. Architecture involved development of an Operational Data Store. Sourced from two mainframe systems and one existing PeopleSoft System.

• Senior ETL developer responsible for consolidation of three Procurement Systems on to one Data Master.
• Primarily responsible for large scale data cleanup for Procurement Systems.

Senior ETL and PowerMart developer on a full-lifecycle PeopleSoft Human Resources project. Sourced from fifteen disparate data sources including mainframe and existing Oracle databases. Worked within a team as a test manager to test, maintain and deliver the PeopleSoft Payroll Module from the ground up.

• Primarily responsible for ETL of Human Resources data from legacy system to Oracle database using Informatica PowerCenter.
• Performed as test manager for PeopleSoft Payroll implementation and Informatica PowerCenter.
• Testing and maintaining of PeopleSoft SQRs and Informatica mappings.
• Data migration from fifteen Business Units into one central database.
• Data feeds to fifteen Business Units.
• Created and Maintained 1600 UNIX Shell Scripts for data migration.
• Developed script generator software in Perl.

Senior developer on a full-lifecycle 'screen-scraping' project. Gather requirements from users and tailored system to meet business needs. Worked within a team to contribute to the successful delivery of a reporting system from the ground up.

• Screen scraping project written in Perl to update legacy system. Data was entered into an Oracle database and reported using a web interface using CGI and Perl.
• Executed full software life cycle from data requirements to implementation.

Senior ETL developer on a full-lifecycle data warehousing project. Architecture involved stage, operational data store, and warehouse areas. Sourced from several disparate data sources including real-time and legacy Sybase databases. Worked within a team to contribute to the successful delivery of a data warehouse from the ground up.

• Primarily responsible for ETL of several large Sybase tables (8 million plus rows) into relational data warehouse model. Several large C ETL programs were written using Sybase DB Lib downloading history data into flat files and processing it back into the Sybase relational model.
• Wrote several C program tools for evaluating warehouse and legacy data, creating database DDL and validating conversions and data replication.
• Scrubbed production warehouse data using UNIX shell scripts, SQL, Perl with SybPerl and Sybase stored procedures.
• Transformed Object-Oriented InConcert Sybase database into data warehouse. Data was replicated into operational data store using Sybase Replication Server then transformed into a relational model using function strings and stored procedures.
• Replicated existing production tables into Operational Data Store database using Sybase Replication Server. Data was denormalized and optimized for reporting using function strings and stored procedures.
• Primarily responsible for the design, implementation, and maintenance of subscriptions, repdefs, function strings, and stored procedures for use with Sybase Replication Server.

ETL developer and analyst on a full-lifecycle OLTP project. Sourced from Universe legacy system. Worked within a team to contribute to the successful delivery of a software system that the business could use to make daily business decisions.

• Primarily responsible for ETL of existing Legacy UNIVERSE database into Sybase System 10. Created PIC BASIC programs to extract data from Legacy system. Designed and wrote C programs transform data. Developed Sybase 10 stored procedures to load data and create indexes, triggers, and tables. Wrote UNIX shell scripts for loading data.
• Created and maintained GUI front-end in Neuron Data and C.
• Technical lead over four people for Technical Profits and Losses reporting system. Over saw every aspect of development, including application and database development, documentation and data conversion.
• Developed a reporting system and a GUI interface for an Automated Payable application using Sybase and PowerBuilder 4.0.
• Worked on a Technical Profits and Losses reporting system doing data migration and GUI front end. Created programs to extract data from former Excel system using UNIX shell scripts and AWK and SED. Developed Sybase 10 stored procedures, indexes, triggers, and tables. Created GUI front-end using PowerBuilder 5.0

Sole developer for new flood zone reporting software. Worked all aspects of software development lifecycle successful implement and maintain software.

• Designed and implemented a Flood Zone Reporting Database using Microsoft Access database and GUI environment. Worked all phases of software development for the project: requirements gathering, screen design, coding, testing, reports and installation.

Maintenance developer for existing trucking software. Worked within a team to contribute to the successful maintenance and upgrades of existing software.

• Maintained PC scanning software in C and developed new Microsoft Windows applications using C, C++ and Visual Basic.
• Created PC interface to legacy system using PIC BASIC for research and development and customer support departments.

Colorado School of Mines	Golden, CO
B.S. in Mathematics/Computer Science Option	May 1994

Breckenridge Institute of Technology	Breckenridge, CO
Data Warehouse Architecture & Methodology Boot Camp	September 2008