SUMMARY:

• Over 14 years of rich experience in IT and have demonstrated results in delivering custom application migration, analyzing information system needs, evaluating end - user requirement, custom designing solutions, troubleshooting for complex information systems management in Data Warehousing using Informatica PowerCenter 10.1, 9.x, 8.x, 7.x
• Strong understanding of Dimensional Modeling, Star and Snowflake Schemas and Data Warehousing
• Strong problem solving and technical skills coupled with confident decision making for enabling effective solution leading to high customer satisfaction as well as low operational cost.
• Experienced in full Software development lifecycle from requirements gathering, architectural design, writing Business Specification Document, ETL development, QA and implementation of data warehousing applications and support for Retail, Finance, Insurance Industries in various RDBMS like Oracle,SQL Server, Teradata environments.
• Extensively used SQL and PL/SQL to write stored procedures, Functions Packages and Triggers and JSON
• Hands on experience with Informatica Data Quality (IDQ) tools for Data Analysis / Data Profiling / IDQ Developer.
• Experience in using Standardizer transformation to standardize the data.
• Designed and Developed IDQ mappings for address validation / cleansing, doctor master data matching, data conversion, exception handling, and report exception data.
• Implemented functional requirements using Parser, Match, Expression, Keygen, Decision, Data Processor Transformation etc.. IDQ Transformations.
• Responsible for migrating data from IDQ developer tool to Informatica power center.
• Ability to interact with IT teams to gather source system knowledge and works with the customer to arrive at the overall architecture
• Implemented Audit and Error handling techniques using Informatica
• Customer Interaction & Review Meetings participation/ Deliverables
• Builds High Level Technical design HLD) and LLD of ETL processes
• Created and Consume REST / SOAP services using HTTP/ Web Service consumer transformation.
• Experience ICERT - Informatica Real time integration.
• Designed and enabled Informatica workflows as Web Services using Web Service consumer transformation and experience in testing the web services using Try-It option as well as with Java program.
• Extensive knowledge on WSDL, XML, SOAP messages and web services.
• Extensively used XML, XSD / schema files as source files, parsed incoming SOAP/ REST messages using XML parser transformation, created XML files using XML generator transformation
• Good understanding of Data quality/Data Modeling - Aware of Data Vault data modeling technique
• Proficient in C/C++.
• Established my ability to identify, analyze and solve technology problems that enhance business.
• Strong relationship, good communications skills, and good in customer interaction.
• Experience with On-Site and On-Site/Off-Shore Model of project delivery.

TECHNICAL SKILLS:

SKILL: Informatica-7.x,8.x,9.x, IDQ 9.0.1,Oracle, Teradata, SQL Server, C/C++,UNIX/Linux

PROFESSIONAL EXPERIENCE:

Confidential

Sr ETL Developer /Lead

Responsibilities:

• Interacting with cross functional team, Analysis, Design and Development,
• Design, develop, test and deploy ETL mappings/workflows.
• Document all technical mapping specification documents for all ETL process.
• Managed Informatica development and testing tasks and ensuring adherence to previously agreed to timelines communicating status.
• Performed technical walk-through as needed to communicate design/coded solution and to seek input from team members.
• Developed ETL processes using Informatica, control tables, error logging, auditing, data quality, etc.
• Implemented data cleanup procedures, transformations, scripts, stored procedures, and execution of test plans for loading the data successfully into the targets.
• Coordinated ETL and database development work with offshore ETL developers and conduct code reviews

Technical Environment: Informatica 9.6, Oracle 11g, DB2, Unix, Control-M scheduler.

Confidential, CA

Sr ETL (Informatica) Developer

Responsibilities:

• Interacting with cross functional team, Analysis, Design and Development,
• Implemented REST and SOAP services using HTTP/ Web Service consumer transformation.
• Designed and enabled Informatica workflows as Web Services using Web Service consumer transformation and experience in testing the web services using Try-It option as well as with Java program.
• Extensively used XML, XSD / schema files as source files, parsed incoming SOAP/ REST messages using XML parser transformation, created XML files using XML generator transformation
• Implemented Informatica Real time integration for Boarding Pass.
• Build JSON input / Output for Boarding Pass and Boking Conf/Modification/Cancel
• Design, develop, test and deploy ETL mappings/workflows.
• Assist in System, integration & performance testing.
• Document all technical mapping specification documents for all ETL process and perform unit tests

Technical Environment: Informatica 10.1, JSON, Oracle 11g, Windows,

Confidential, Florida

Sr ETL (Informatica) Developer

Responsibilities:

• Understand existing ETL scripts and document the requirements working with technical and functional resources
• Interacting with cross functional team, Analysis, Design and Development,
• Design, develop, test and deploy ETL mappings/workflows.
• Assist in System, integration & performance testing
• Document all technical mapping specification documents for all ETL process and perform unit tests and Onsite-Offshore Co-ordination
• Implemented Audit and Error handling techniques using Informatica

Technical Environment: Informatica 10.1, Oracle 11g, MySql, UNIX, Autosys

Confidential, NewYork, NYC

Sr ETL (Informatica) Developer

Responsibilities:

• Interacting with cross functional team, Analysis, Design and Development,
• Documentation, Testing,, Review Deliverables.
• Delivers a high quality technical solution for a project with data movement
• Identifies and communicates technical issues.
• Hands on experience with Informatica Data Quality (IDQ) tools for Data Analysis / Data Profiling / IDQ Developer.
• Responsible for Standardizer transformation to standardize the source data.
• Designed and Developed IDQ mappings for address validation / cleansing, doctor master data matching, data conversion, exception handling, and report exception data.
• Implemented functional requirements using Parser, Match, Expression, Keygen, Decision etc.. IDQ Transformations.
• Responsible for migrating data from developer tool to Informatica power center.
• Reviews all code before it is submitted for migration
• Implemented Audit and Error handling techniques using Informatica

Technical Environment: Informatica 9.6, IDQ, Oracle 11g, DB2, Power Exchanges, UNIX, Autosys

Confidential, Parsippany, NJ

Informatica Tech Lead/ Designer

Responsibilities:

• Perform a gap analysis and document all additional data elements needed
• Produce a mapping of finalized data elements against redesigned GDW tables for party, customer and site to store TCA data
• Review existing ETL jobs based on analysis from BA for post-GoTC implementation and document all required changes.
• Review new requirements for post-GoTC implementation and document all NEW required ETL jobs
• Prepare all Source to Target mapping specifications and Gap analysis from post-GoTC implementation perspective
• Design and document all ETL mappings, sessions and workflows
• Implemented Audit and Error handling techniques using Informatica
• Designed and Developed IDQ Data Processor transformation to transform data from one format to another format.

Technical Environment: Informatica 9.6, IDQ, Oracle 11g, UNIX,Oracle EBS R12.1, Autosys

Confidential, Boca Raton, Florida

Informatica Tech Lead

Responsibilities:

• Interaction with client and offshore team, Analysis, Design - FS, TD and Unit test cases etc, Documentation, SIT Planning and Review Deliverables.
• Customer Interaction & Review Meetings participation

Technical Environment: Informatica 8.6, Oracle 10g, Linux, Autosys

Confidential, San Diego, CA

Informatica Tech lead

Responsibilities:

• Interacting with client, Analysis, Design and Development, Documentation, Testing, Review Deliverables.
• Involved in Customer hub, Property hub, and Reservation and Product hub inventories of the project - designing and developing from end to end.

Technical Environment: Informatica 9.01, PL/SQL, IDQ 9.0.1, MDM 9.0.1, Oracle 11g

Confidential, Orlando, FL

Module Leader

Responsibilities:

• Architecture, Analysis, Design and Development, Application support and Maintenance
• The three files that send data from People Soft to local payroll systems are the EWAD (Employee Workforce Admin Data), ECD (Employee Compensation Data) and Bonus Plan. However, these files specs do not comply with ADP’s standard file specs for importing this employee data into ADP’s payroll system. As such we will require a ‘Formatter’ program(s) be developed to take the three files and reformat these into an ADP standard file format.

Technical Environment: Informatica 8.6, Oracle 10g

Confidential

Module Leader

Responsibilities:

• Interacting with business users Architecture, Requirement gathering Analysis, Design and Development, Documentation

Technical Environment: Informatica 8.6, Oracle 10g, Control-M Scheduling Server

Confidential

Module Leader

Responsibilities:

• Production Support, Analysis, Enhancement, Testing, Interaction with client, Onsite-offshore co-ordination,
• Informatica plays an important role in AZL.The system is categorized into environments like Production, QA/Test, CBO, Staging and development. Most of the applications are very critical in the environments.ASM project deals with Extraction, Transformation and Loading of data from different sources using Informatica. The data is stored in mainly in SQL server2005 and oracle. ASM project involves Informatica application support and maintenance 24x7.
• Carried out the following activities,
• Creating and managing user, managing ETL server and its services in case of failure.
• Production support 24x7 (Also giving permanent solution to fix the problem).
• Enhancement and code fixed based on requirement, deployment.
• Regular activities involved monitoring of alerts and scheduled jobs,
• Proper daily handshake with offshore on the status.
• Troubleshoot complex problems on new and/or existing products.
• Manage support process
• Ensure all project documentation is completed and follows required Standards.

Technical Environment: Informatica 8.1, SQL SERVER 2005, Oracle 10gi, Espresso Scheduler, HPOV

Confidential, Minneapolis, MN

Sr. Developer

Responsibilities:

• Analysis, Development, Testing, Production Support, Interaction with client,
• SPOT has been engaged with Teradata Professional Services in the foundational build of the Data Warehouse environment as well as the planning, designing and building of the first iteration of the project which focuses on the Dealer Credit systems. The second iteration focusing on Credit Risk. The goal of the project is to improve both the quality and availability of data needed to drive decision making for the whole organization.
• Troubleshoot complex problems on new and/or existing products.
• Ensure all project documentation is completed and follows required Standards.

Technical Environment: Informatica 7.1.3, Teradata 7.1

Confidential, Farmington Hills, MI

Module Leader

Responsibilities:

• Analysis, Development, Documentation, Testing, Interaction with client, Onsite-offshore co-ordination.
• Working with DCX Shared Services B.I. team. DCX Enterprise Data warehouse provides a central, integrated repository for all management reporting requirements. Data from various operational sources are extracted and populated in data marts such as MyPersonnel which stores information about HR of DCX. Other data marts are FLEET, VMMD and IPATS etc. These data marts are formed to separate analysis workload from transactional database and to enable a business consolidate data from several source.
• These data marts constitute Enterprise Data warehouse for DCX. This is intended to provide a central database for decision support throughout the enterprise.
• Troubleshoot complex problems on new and/or existing products.
• Manage support process
• Unix shell script
• Ensure all project documentation is completed and follows required Standards.

Technical Environment: Data Stage 7.5.1, DB2,Microsoft Visual SourceSafe

Confidential

Sr. Developer and Team lead for Testing

Responsibilities:

• Analysis, Development, Documentation and
• Team Lead for Testing,Onsite-Offshore interaction
• Honeywell has embarked on FAIR program.
• Enable the aerospace with an Enterprise Data Warehouse (EDW) that sources data from different legacy systems
• Project involves maintaining Enterprise Wide Data Warehouse that contains the data from SAP Rapid Mart and various legacy systems. In addition to this reporting capability to monitor and control different business parameters

Technical Environment: Informatica 7.1.2, BODI 6.5, Oracle 8i, PL/SQL Developer, Microsoft Visual

Confidential

Developer

Responsibilities:

• Analysis, Development and Testing, Onsite-offshore co-ordination
• Carried out the following activities:
• Analysis, coding and implementation of Change Request (using Informatica)
• Report generation using MicroStrategy.
• Developed ETL mapping using Informatica PowerCenter 7.1.1 to load data from flat files, oracle to staging Oracle and from staging to Teradata
• Created sessions from Workflow Manager for mappings.
• Developed Shell Scripts to run sessions.
• Designing test cases and obtaining results

Technical Environment: Informatica 7.1, Oracle 8i, Teradata, Toad.

Confidential

Sr Developer

Responsibilities:

• Design, Development and Testing
• The application under migration is a service provider application, interacting with the host application on one side and the ATM devices on the other side. The ATM devices being interfaced consist of Card Readers, Printers, Cash Dispensers, Cash Acceptor and Envelope Depositors. The project involves the migration of the application from XFS 2.0 to 3.0, development of a service provider application for a new printer class and migration of installation scripts from Install shield 6.3 to install shield 9.0. The project is executed on XP platform using VC++ Ver 6.
• PIN SP is a software component that provides access to the financial services and to the financial institutions' peripheral devices described by the Extensions for Financial Services (XFS) Pin Device Class interface, as a result of the CEN/ISSS XFS Workshop. This includes designing and Implementation of PIN SP commands (WFS CMD PIN HSM SET TDATAWFS INF PIN HSM TDATA,WFS CMD PIN OPEN, WFS CMD PIN INITIALIZATION, and WS CMD PIN CRYPT)
• Carried out the following activities: Study of XFS 3.0 specifications /PIN Key Pad device class interface, Studying 9x Service Providers Architecture, Documentation, Development - C/C++, Testing

Technical Environment: XFS, Agilis Power, XTG Test Tool/ Driver Emulator, Microsoft VSS

Confidential

Developer

Responsibilities:

• Study, Design and Implementation of LDAP.

Technical Environment: OPEN LDAP