Software Engineer Resume Ofallon, IL - Hire IT People

SUMMARY

Information Technology professional with 22 years of design and development experience in large Data Warehouses and Decision Support Systems with expertise in ETL and Database technology.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Software Engineer

Confidential, Ofallon, IL

Responsibilities:

Consultant involved in the expansion and maintenance of an Enterprise Data Warehouse for materiel asset visibility, transportation, distribution and logistics for the DOD USTRANSCOM IGC program.
Create and maintain numerous data integration processes for multiple data sources using Informatica PowerCenter 10.2 on Red Hat Linux 6 in an Oracle 12, Teradata 16 and Business Objects 4 environment.
These processes include multiple Informatica mappings with EDI, flat file, XML and Oracle sources and targets, shell and python scripts and Teradata TPT and MLOAD scripts. Create and maintain Erwin data models.
Create and maintain business rules and source-to-target mapping documentation. Support all aspects of the technical efforts associated with the development, modification and testing of the components of the Data Warehouse as a DOD logistics and transportation subject matter expert.
Participate in technical peer reviews and act as a technical liaison between the development and system test teams.

ETL Engineer

Confidential, Boca Raton, FL

Responsibilities:

Consultant involved in the de-integration of the ADT/Tyco Enterprise Data Warehouse.
Create/modify Informatica workflows, worklets, sessions, mappings.
Create/modify pl/sql packages, procedures and shell script based sql loader/sqlplus processes.
Support all aspects of the technical efforts associated with development, modification and testing of the components of the Data Warehouse.
Maintain numerous data integration processes for multiple data sources using Informatica PowerCenter 9.1 on AIX 6.1 in an Oracle 11 environment.

Software Engineer

Confidential, Ofallon, IL

Responsibilities:

Consultant involved in the expansion and maintenance of an Enterprise Data Warehouse for materiel asset visibility, transportation, distribution and logistics for the DOD USTRANSCOM IGC program.
Create and maintain business rules and source-to-target mapping documentation. Support all aspects of the technical efforts associated with the development, modification and testing of the supply components of the Data Warehouse as a DOD logistics subject matter expert.
Maintain numerous data integration processes for multiple data sources using Informatica PowerCenter 9.1 on Solaris 10 in an Oracle 10 and Teradata V2R6 environment.
These processes include multiple Informatica mappings with EDI, flat file and XML sources and targets, shell scripts and Teradata TPT and MLOAD scripts. Perform a detailed regression test for a PowerCenter 9.1 to 9.5 upgrade.
Participate in technical peer reviews and act as a technical liaison between the development and system test teams.