SUMMARY:

• Overall 12 years of Total Experience in the IT Industry
• Verified transformed feeds from ETL modules for the correctness/expected results and then loading them onto Recon systems for the testing team to test upon.
• Experience of 10 years with ETL (Extract/Transform/Load) tool Informatica Power Center.
• Expertise in analyzing the data from source system and adding all the required checks before the data is fetched in ETL or before loading in the target system.
• Interact with business users for understanding the business requirement and then create the BRD, Design Doc, Test case etc.
• Proficient in ETL, Database designs, Reporting Services and strong Excel skills for Data Analysis.
• Migration of all the ETL jobs from Informatica 7 to Informatica 8 and Informatica 9 to Informatica 10.
• Very good proficiency in Informatica Data Quality 9.5.1
• Worked on the Golden Gate replication from hetrogenous data sources.
• Have excellent knowledge on Anticipating the data issue due to user errors and have the checks in place so that the incorrect data is not loaded in the reporting tool.
• Worked on Configuration of Informatica 10 on Windows server.
• Worked on Generic ETL Framework Solutions - Synex for Exchange Traded Derivatives (ETD) Solutions using Informatica 8.6.1 for Data Integration and complex built rules.
• Have knowledge on Oracle PL SQL, MS SQL Server and I-SQL programming languages.
• Loading of ETL Files in TLM, Mapping of TLM KB to the ETL Files, TLM Engines Configurations and support management for backing out/reloading TLM files.
• Worked on upgrading all the Informatica jobs from older version to new version.
• Experience in all Phases of Software Development Life Cycle (SDLC) (from requirements gathering to post live support).
• Performed admin tasks for managing user previlages and roles.
• Good problem solving skills, analytical skills and creative skills
• Code reviewing, documenting software code from a developer’s perspective, writing user manuals and Conscious towards coding standards, debugging skill, testing, Code Review, documentation and also interaction with onsite client.
• Impact analysis of the system for new developments.
• Analyzed requirements, provided estimation, and prepared High Level Designs.
• Has very strong experience in the requirements gathering, functional gap analysis, configuration, writing training guides, training and production support.
• Team player with good interpersonal, communication and fast learning skills. Highly adaptive to any type of work environment and technology.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter, Informatica IDQ and Datastage

Databases: Oracle9i/10g/11g, DB2, Sybase

Reconciliation Tool: TLM 2.6/2.7/Premium

Repository System: SVN, Star Team

Operating System: UNIX, Windows Advanced Server 2000/NT/XP.

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Data Quality Analyst/Architect

Technology: DB2, Oracle 11g, PL/SQL, Autosys, Data Stage 8.5, Informatica 9x/10x, Informatica IDQ 9x

Responsibilities:

• Requirement Analysis for the new projects.
• Migration of ETL jobs from Datastage to Informatica 9 and Informatica 10.
• Oracle Procedure development and enhancements
• Analysis of the data that could be added in the source system and adding all the required checks for checking the correctness of data
• Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging.
• Used IDQ to complete initial data profiling and removing duplicate data.
• Golden Gate replication from sybase to Exadata
• Deployment of the Informtica and the database objects in UAT for the enhancements
• Ensuring all the validations are done at the source system before the data is loaded in database.
• Client Co-ordination

Confidential

ETL and Database Lead Consultant

Technology: Informatica Power Center 8.6.1, Unix Shell Scripting, DB2, Oracle 11g, Autosys

Responsibilities:

• Requirement Analysis for the new projects.
• ETL Development and enhancements
• Preparing design document and Technical Specification documents
• Responsible for managing the user previlages and roles on Informatica.
• Update or create new database views as per the downstream requirement.
• Support for UAT
• Client Co-ordination

Confidential

Database and ETL Lead Consultant

Technology: Informatica Power Center 8.6.1, Informatica Data Transformation B2B, Unix Shell Scripting, Sybase, Oracle 11g, Autosys, TLM Premium 3.1

Responsibilities:

• Requirement Analysis, Data Model and Data Flow Creations,
• Leading and Monitoring the development team to divide the function points and bring tasks into closure,
• ETL Development, TLM Premium Monitoring
• Preparing design document and Technical Specification documents
• Preparing Unit Test Case.
• Have been a part of correction team at the time of System Test to deliver bug-free modules
• Support for UAT
• Client Co-ordination

Confidential

ETL and Database Consultant

Technology: Informatica PowerCenter 8.6.1, Unix Shell Scripting, DB2, TLM 2.6

Responsibilities:

• Requirement Analysis, Leading and Monitoring the development team to coordinate the users with the requirements
• ETL Development, Reporting Development.
• Responsible for enhancement and bug fixing.
• Responsible for memory optimization and performance tuning.
• Preparing Unit Test cases.
• Handling Change Requests for IMPACT recs
• Client Co-ordination.
• UAT support

ETL Consultant

Confidential

Technology: Informatica, PL/SQL, MS/SQL, Ingress

Responsibilities:

• Responsible for migrating all ETL jobs from Informatica 7 to Informatica 8.
• Responsible for Requirement Analysis and Coding in Informatica
• Responsible for enhancement and bug fixing.
• Responsible for Unit Testing.
• Real Time Support, Fix bugs, Deployment of Informatica apps
• Client Co-ordination

Database Consultant

Confidential

Technology: Java, Servlets, JSP, Fatwire Content Server, IBM WSAD, Star Team

Responsibilities:

• Responsible for Requirement Analysis
• Responsible for enhancement and bug fixing.
• Responsible for Unit Testing.
• Real Time Support, Fix bugs
• Build and deployment of the application
• Client Co-ordination

Database Consultant

Confidential

Technology: Oracle, PL/SQL Developer, Fatwire Content Server, Hotdocs 2005

Responsibilities:

• Responsible for Requirement Analysis
• Responsible for enhancement and bug fixing.
• Responsible for Unit Testing.
• Development of Database modules like Table, Procedure creation,
• PDF generation, Lias with 3rd Party
• Client Co-ordination