Dan Roder

Dan Roder

Senior ETL and Data Warehouse Developer at Lockheed Martin

Greater Denver Area

Current
Past

see less...

10 more...

Education
  • Colorado School of Mines
  • Breckenridge Institute of Technology
Recommended
Dan has 3 recommendation(s) 3 people have recommended Dan
Connections
306 connections
Industry
Information Technology and Services
Websites

Dan Roder’s Summary

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.

Dan Roder’s Specialties:

Marketing, operational and financial Data Warehousing, payroll and human resource, OLTP and Operational Data Store systems in industries such as telecommunications, pharmaceutical, agribusiness, healthcare, publishing, banking and defense.

Dan Roder’s Experience

  • Senior ETL and Data Warehouse Developer

    Lockheed Martin

    (Public Company; 10,001 or more employees; LMT; Defense & Space industry)

    October 2008 — Present (3 months)

    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 Data Warehouse Developer

    Amylin Pharmaceuticals

    (Public Company; 1001-5000 employees; AMLN; Pharmaceuticals industry)

    February 2008 — September 2008 (8 months)

    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.

    • 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 Developer

    Great-West Life

    (Public Company; 5001-10,000 employees; GWL; Insurance industry)

    October 2006 — February 2008 (1 year 5 months)

    Senior ETL and PowerCenter developer on an Operational Data Store project. Primarily using Informatica PowerCenter 7.1 to develop and enhance programs to migrate data sourced from mainframe and 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 Operational Data Store.

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

  • Senior ETL and Data Warehouse Developer

    Lockheed Martin Corporation

    (Public Company; 10,001 or more employees; LMT; Defense & Space industry)

    July 2005 — October 2006 (1 year 4 months)

    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. Sourced from disparate data sources including COBOL, SAP, and DB2. Worked within a team to contribute to the successful delivery of a corporate Data Warehouse.

    • Developed custom ETL using Informatica PowerConnect and ABC toolkit to load SAP data directly into Procurement Data Mart
    • Coded complex COBOL reports in Oracle PL/SQL
    • “Shredded” eighteen years of transaction history into dimensional database.
    • Developed custom ETL software to load Procurement Data Mart
    • Primarily responsible for Informatica upgrade from version 5.1 to 7.1.2

  • Senior ETL and Data Warehouse Developer

    CoBank

    (Privately Held; 501-1000 employees; Banking industry)

    October 2004 — July 2005 (10 months)

    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.

  • Senior ETL and Data Warehouse Developer

    Dex Media

    (Public Company; 1001-5000 employees; Marketing and Advertising industry)

    March 2004 — July 2004 (5 months)

    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 Developer

    Great-West Life

    (Public Company; 5001-10,000 employees; GWL; Insurance industry)

    August 2003 — March 2004 (8 months)

    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 Data Warehouse Developer

    Qwest Communications International Inc

    (Public Company; 10,001 or more employees; Q; Telecommunications industry)

    August 2002 — April 2003 (9 months)

    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 Programmer and Analyst

    Qwest Communications International Inc

    (Public Company; 5001-10,000 employees; Q; Telecommunications industry)

    March 2002 — August 2002 (6 months)

    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

    Lockheed Martin Corporation

    (Public Company; 10,001 or more employees; LMT; Defense & Space industry)

    March 2000 — September 2001 (1 year 7 months)

    Senior ETL and Informatica 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 Programmer and Analyst

    US WEST (now Qwest)

    (Public Company; 5001-10,000 employees; Q; Telecommunications industry)

    September 1999 — March 2000 (7 months)

    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 Programmer and Analyst

    US WEST Dex (now Dex Media)

    (Public Company; 1001-5000 employees; DEX; Publishing industry)

    February 1997 — September 1999 (2 years 8 months)

    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.

  • ETL Developer and Analyst

    Tele-Communications, Inc (now Comcast)

    (Public Company; 10,001 or more employees; CMCSA; Telecommunications industry)

    February 1995 — February 1997 (2 years 1 month)

    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.

  • Software Engineer and Analyst

    1mage Software, Inc

    (Public Company; 11-50 employees; Transportation/Trucking/Railroad industry)

    June 1994 — January 1995 (8 months)

    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.

Dan Roder’s Education

  • Colorado School of Mines

    BS, Mathmatics/Computer Science, August 1989 — May 1994

    Activities and Societies:
    Rugby

  • Breckenridge Institute of Technology

    Data Warehouse Architecture & Methodology Boot Camp 2008

Additional Information

Dan Roder’s Websites:

Dan Roder’s Interests:

Rugby, Skiing, Hiking

Dan Roder’s Groups:

Denver Harlequins RFC, Colorado Mountain Club

  •    Informatica Community
  •    Business Intelligence Professionals
  •    Mines alumni - DEFUNCT / DO NOT REQUEST ACCESS
  •    Colorado School of Mines Alumni Association (CSMAA)

Dan Roder’s Contact Settings

Interested In:

  • career opportunities
  • consulting offers
  • new ventures
  • job inquiries
  • expertise requests
  • business deals
  • reference requests
  • getting back in touch

View Full Profile

Public profile powered by: LinkedIn

Create a public profile: Sign In or Join Now

View Dan’s full profile:

  • See who you and Dan Roder know in common
  • Get introduced to Dan Roder
  • Contact Dan Roder directly

View Full Profile