TECHNICAL SKILLS:

Databases: MS SQL, Oracle (Oracle Streams), SQL Server200/2005 Sybase, DB2, Terradata,Netezza

Programming Languages: C, Java, SQL, and PL/SQL

Operating Systems: Windows, Sun Solaris, HPUX, AIX and Linux

J2EE Application Servers: WebSphere and JBoss

Software: Microsoft Office, Informatica Power Center, Informatica B2B,DAC, Talend,SSIS

EXPERIENCE:

Senior Informatica Developer

Confidential

Responsibilities:

• Help develop a robust GDW to extend OBIA complete with history keeping, full and incremental load capabilities
• Identified repeatable patterns used for the project as well as other engagements
• Used Talend to develop an access report system out of OBIA
• Produced an MDM POC using Talend MDM suite for internal purposes
• Examined Talend ESB as part of the MDM POC to integrate data

Owner and Developer

Confidential

Responsibilities:

• Leveraged patterns developed in previous projects to create functional DW for the client
• Lead a team of 4 junior developers
• Act as the Informatica as well as the general architecture SME to resolve issues/alter patterns to fit new needs

Consultant

Confidential

Responsibilities:

• Played a critical role as the Informatica B2B Data Transformation tool SME. The Data Transformation tool was used to consume XML files off a messaging queue and convert data for loading into relational targets. Set up a repeatable process of integrating B2B DT tool with Power Center. Mentored junior level team members on operation of the process.
• Worked as an integration Designer for a data migration effort. Participated in requirements gathering as well as ETL design. Provided Power Center expertise in ETL process design.

Senior Associate

Confidential

Responsibilities:

• Parse incoming EBCIDIC data and load into intermediary XML files
• Apply business transformations within B2B
• Produce XML outputs from B2b to be consumed by Power Center
• Use the Unstructured Data Transformation to call the B2B Service from within a Power Center Mapping
• Use the relational hierarchy to import the B2B output
• Apply additional business transformations within Power Center
• Produce flat file outputs from Power Center for loading into DB2
• Load data into DB2 for testing
• Load data into DB2 tables to ensure relational integrity holds
• Set default values for fields where necessary to ensure proper data load
• Use Power Center 8.6 and later upgraded to 9.0

Senior Application Developer

Confidential

Responsibilities:

• Developed HL7 compliant XML documents
• Develop projects to handle XML inputs using Informatica’s B2B tool
• Map elements into HL7 compliant XML
• Work with QA group to alter existing projects to fit new requirements

Senior Database Developer

Confidential

Responsibilities:

• Participate in ODS design reviews sessions.
• Provided input during group reviews of newly designed ODS databases before development started
• Analyze source data in order to assist in optimal design of the databases
• Perform post development analysis looking for possible improvements to design
• Develop and test ETL processes using Informatica’s Power Center
• Develop mappings from source to target documents using various standards
• Create sessions and workflows with appropriate dependency considerations
• Perform unit tests on individual mappings as well as integration tests on workflows
• Document mappings and test results
• Develop workflows into various environments
• Deploy workflows between Development, QA and Production environments using deployment groups
• Schedule and monitor workflow runs
• Analyze reject records and deploy fixes to mappings

ETL Developer

Confidential

Responsibilities:

• Provide project - specific support for all facets of the ETL process.
• Assist with the necessary data analysis before source-to-target map design
• Develop, test, and maintain source-to-target Informatica mappings
• Support the data movement processes during the application development life-cycle
• Conduct performance tuning of the ETL process
• Analyze ETL workflows to identify critical sessions
• Perform source and target tuning of sessions to improve performance
• Participate in production on-call support rotation schedule for ETL processing
• Provide fixes to ensure ETL batch completion in case of interruptions
• Follow up on issues and suggest and perform permanent fixes for identified problems
• Perform testing and validation for implemented fixes

Certified Systems Analyst

Confidential

Responsibilities:

• Interpreted C code and UNIX scripts into Informatica process
• Consolidated fragmented code into a workflow
• Retrofitted and improved on process to meet new client needs
• Identified opportunities for parallel processing to cut down on run time
• Retargeted data from DB2 to Terradata at client’s request
• Installed, configured and deployed Informatica Power Analyzer and Metadata Reporter with JBoss on a Windows environment
• Installed, configured and deployed Informatica Power Analyzer and Metadata Reporter with WebSphere on a UNIX environment.
• Altered Power Center Metadata Reporter to fit client’s needs
• Development support for implementing a data warehouse at Barclays Investments
• Developed types one and two dimension table mappings for data warehouse
• Interpreted and developed documentations for complex mappings produced for project