PROFESSIONAL EXPERIENCE:

Confidential, Dayton, Ohio

Informatica Developer

Responsibilities:

• Designing/Developing process flows, Informatica processes (mappings, mapplets, sessions, workflows and worklets) to load staging targets for data profiling and then transforming and loading staging data to an ODS
• Creating Source to Target mapping document
• Unit testing
• Documentation

Confidential, Dayton, Ohio

Informatica Developer

Responsibilities:

• Developed Informatica mappings, sessions, workflows in support of a Healthcare analytics project

Confidential, Dayton, Ohio

Informatica Developer

Responsibilities:

• Worked with Business/Data Analysts in development of Informatica processes to meet business requirements
• Unit Testing
• Assisting Integration testing team
• Creation of Software Implementation documentation for Integration, Certification and Production migration
• Worked on major enhancement of Scion Dental Claims interface which included modifications to existing Informatica objects as well as development of new

Confidential, Miamisburg, Ohio

Informatica Developer

Responsibilities:

• Worked with BA to solidify business requirements
• Created/Modified/Unit Tested Informatica mappings, sessions and workflows to meet requirements for enhancements to existing systems
• Created migration package for the QA testing team

Confidential, Fairborn, Ohio

Informatica Developer

Responsibilities:

• Worked on the Requirements Traceability Matrix
• Worked on the Source to Target Matrix
• Created/modified Source to Target mapping
• Developed, unit tested and documented Informatica workflows
• Participated in UAT

Confidential, Tampa, Florida

Informatica Developer

Responsibilities:

• Modified and tested Informatica mappings, sessions and workflows based on pre - defined requirements and business rules.
• Monitor, identify and correct production issues related to Informatica workflow defects.

Confidential, Miami Lakes, Florida

Informatica Developer

Responsibilities:

• Modified and tested Informatica mappings, sessions and workflows based on pre-defined requirements and business rules.
• Monitor, identify and correct production issues related to Informatica, database and UNIX scripts.

Confidential, Charlotte, North Carolina

Informatica PowerCenter Developer

Responsibilities:

• Requirements review and analysis.
• Detail design documentation review for Informatica mappings, sessions and workflows.
• Construction of Informatica mappings, sessions and workflows.
• DDL creation and submission to the DBA
• Work with Business Analyst through QA testing process
• Ensure all objects deployed correctly to Production
• Member of production support rotation

Confidential, Dallas, Texas

Informatica PowerCenter Developer

Responsibilities:

• Requirements gathering.
• Detail design documentation for Informatica mappings, sessions and workflows.
• Construction of Informatica mappings, sessions and workflows.
• Deployment to QA.

Confidential, Atlanta, Georgia

Sub-Contractor

Responsibilities:

• Detail design documentation for multiple Informatica mappings, mapplets, sessions and workflows that were slated to populate the corporate ODS and data warehouse.
• Collaborated with and assisted offshore team with detail design documentation.
• Coding of multiple Informatica mappings, mapplets, sessions and workflows. The mappings and mapplets were comprised of the following Informatica transformations; Source Qualifier, Expression, Aggregator, Lookup, Normalizer, Filter, Router, Update Strategy, Input and Output.
• Construction of parameter file. We used session level parameters.
• Participated in code reviews with the Duke Energy Informatica Competency Center.
• Responsible for unit testing of each Informatica process.
• Participated in System Integration Testing which involved collaboration with multiple teams.
• Responsible for the migration documentation submitted to the administrator to get the Informatica objects migrated from Development to Test to QA to Production.
• Worked with the team to develop, test and implement an automated scheduling strategy. We used the ESP Cybermation scheduling software.
• Responsible for the production implementation all Informatica processes.
• Provided production monitoring and support thirty days post implementation.
• Created knowledge transfer documentation for the client production support team.

Confidential, Cincinnati, Ohio

Informatica Developer

Responsibilities:

• Responsible for the creation, testing, scheduling, and implementation of Informatica processes to process clinical drug information
• Responsible for supporting production Informatica processes

Confidential, Raleigh, NC

Informatica Developer

Responsibilities:

• Responsible for creating, testing, scheduling, implementing, and supporting Informatica processes created from specifications provided by the customer
• Creation and modification of Korn Shell scripts executed from Informatica objects
• Source data comprised of Oracle tables and flat files
• Targets comprised of Teradata and flat files
• Workflows comprised of Sessions, Command Tasks, Links, and Worklets

Confidential, Tampa, Fl

Informatica Developer

Responsibilities:

• Worked primarily in a HP UNIX environment using Informatica 6.2 and Oracle 8i.
• Responsible for creating interface from EDI source to financial datamart. This interface consisted of Informatica mappings and workflows

Confidential, Tampa, Fl

Developer

Responsibilities:

• Responsible for modifying COBOL programs to allow the UPC code to be expanded.
• Responsible for baseline, unit testing and documentation of all changes.

Confidential, Tampa, Fl

Informatica Developer

Responsibilities:

• Worked primarily in a HP UNIX environment with DB2.
• Responsible for design and creation of Informatica mappings, sessions and workflows to migrate Direct Mail data from IBM AS400 to HP UNIX data vault
• Worked closely with development team and client to document and test new mappings