SUMMARY:

• Experienced professional with 10+ years of IT experience includes Analysis, Design, Development and Maintenance of various software applications in client - server environment with expertise in Data Warehousing and Data Integration.
• In-depth expertise with all phases of Software Development Life Cycle (SDLC) including requirement gathering, requirement analysis, designing, programming, unit testing, deployment and strategic system planning.
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from disparate data sources like ORACLE, flat files, CSV files, Web Services and XML files into a common reporting and analytical Data Model
• Created ETL routines using Informatica PowerCenter to load data into teh new dimensional database
• Experienced in Architect, design and develop enterprise business intelligence and data warehousing solution
• Experienced in Setting up of best practices for ETL infrastructure using Informatica PowerCenter.
• Experienced in creating database components (SQL/PLSQL scripts)required for ETL process
• Experienced in designing, creation and implementation of integration framework using Informatica PowerCenter and ORACLE
• Hands on exposure in Informatica Metadata Manager.
• Involved in different phases of Data Warehouse Life Cycle including requirements gathering and analysis, data modeling (Star and Snowflake schema), source system analysis, ETL design/development, testing, project deployment and post deployment support.
• Experience in teh full life-cycle of software development including requirements gathering, prototyping, proof of concept, design, documentation, implementation and testing.
• Proficient in coding UNIX shell scripts for Informatica scheduling and file handling.
• Extremely proficient in Data Integration strategies using ETL methodologies.
• Strong knowledge and experience in SQL/PlSQL programming in Oracle.
• Creating logical solution design document, ETL design document and Mapping document.
• Expertise in converting existing mainframe modules into UNIX shell script and Python scripts
• Expertise in Designing teh new framework using Python and shell scripting
• Highly Skilled with teh Integration of various data sources like Oracle 10g, DB2, SQL Server, Flat Files, and IBM Mainframe COBOL files
• Extensively involved in Optimization and Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks, employing partitioning and using log statistics.
• Excellent communication, client interaction and problem solving skills.
• Ability to function efficiently both in a team and as an individual.
• My assets are hard work, ability to quickly grasp new concepts both technical and business related and utilize as needed.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, COBOL, CICS

ETL Tool: Informatica PowerCenter 9.X, 8.X, 7.X

Database: ORACLE

Metadata Tools: Informatica Metadata Manager 9.X

Script: UNIX Shell script, JCL, Python

Others: ECLISPE, XML, XSLT, Microsoft InfoPath, ENDEVOR, FILE AID

Scheduling Tools: Autosys

PROFESSIONAL EXPERIENCE

Confidential, NC

Senior ETL Informatica Lead

Responsibilities

• Worked with teh business users as well as technical teams in analyzing and understanding teh existing structure of teh warehouses.
• Create ETL routines using Informatica PowerCenter to load data into teh new dimensional database
• Prepared impact analysis as well as high level system understanding documents.
• Prepared system requirements documentation.
• Led teh design team in coming up with data provisioning framework.
• Worked alongside technology/application leads in segregating applications based upon their roles as source and consumers.
• Provide one touch lineage reports of KBEs using Informatica Metadata Manager.
• Build and maintain an Informatica infrastructure to make these KBEs high quality and highly available as well as completely traceable from its end consumer to origin.
• Leading teh design, creation and implementation of integration framework using Informatica PowerCenter and ORACLE.
• Define collection strategy and integration of data from multiple enterprise business solution sources.
• Manage design review and approval of solution designs, technical specifications, and ETL processing designs.
• Used Informatica Data Quality 8.6 to apply BASEL data quality rules on KBEs.
• Developed lineage storage, maintenance and reporting framework using Informatica Metadata Manager.
• Designed, created and implemented an internal tool to gather lineage information from various applications related to teh key business elements and store it in metadata repository.
• Ensure all application code adheres to industry/company best practice design principals.
• Supporting System / User Acceptance testing for defect fixing and clarifications.
• Support to DBAs/ Release Management teams in deployment of systems in production.
• Providing post-production warranty support.
• Provide Project Management support as and when required.

Environment: Informatica PowerCenter 8.X, 9.X, Informatica Metadata Manager 9.X, ORACLE 11g, TOAD, ECLIPSE, XML, XSLT, Linux, Microsoft InfoPath

Confidential, New York, NY

Informatica Developer

Responsibilities:

• Extensively used Informatica client tools-Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Informatica Repository Manager. Teh objective is to extract data stored in different databases such as Oracle and to load finally into a single Data Warehouse i.e. Oracle.
• Played an extensive role in business requirement gathering, requirement analysis, database design, ETL design, development and implementation of teh end to end solution, using SDLC techniques.
• Involved in conceptual, logical and physical database design using Dimensional Data Modelling.
• Used Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer to create ETL mappings.
• Created mappings, reusable transformations using transformations like Lookup, Filter, Expression, Stored Procedure, Aggregator, Update Strategy etc.
• Created Sessions and Workflows.
• Worked with Flat files, Relational and XML sources.
• Extensively worked in teh performance tuning of teh ETL mappings and database queries to reduce teh run time of teh sessions and workflows.
• Was involved in Coding of Complex Stored Procedures, Functions, Triggers using SQL and PL/SQL.
• Provided Pre & Post production assistance.
• Worked on Crystal Reports for Higher Management.

Environment: Informatica Power Center 6.2/7.1. Crystal Reports 8.0, Oracle 9i, Sybase11.0, Windows 2000, UNIX AIX, SQL, PL/SQL, SQL Navigator.

Confidential, Chicago, IL

Senior Informatica ETL Developer

Responsibilities:

• Understanding teh business requirements by partnering with business and application developers to create conceptual, logical and physical data models.
• Held various interactive meetings with different users and business analysts for a clear understanding of teh Business requirements and to bridge teh gap between user needs and tool functionalities.
• Worked in various types of transformation like Lookup, Update Strategy, Stored Procedure, Joiner, Filter, Aggregation, and Rank, Router and XML Source Qualifier etc to extract teh data from multiple source systems like Oracle, SQL Server and .csv files.
• Knowledge in designing and developing data warehouses, data marts and business intelligence using multi-dimensional models such as star schemas and snow flake schema for developing cubes.
• Creation of Reusable transformations, Mapplets to reduce teh development time and complexity of mappings and better maintenance.
• Load operational data from Oracle, SQL Server, flat files, Excel Worksheets into various data marts
• Reviews, analyzes, and modifies programming systems including encoding, testing, debugging and documenting programs.
• Developed Complex mappings by extensively using Informatica Transformations.
• Creating/Building and Running Sessions/workflows and worklets using teh Workflow Manager/ Workflow Monitor.
• Worked on performance tuning by creating indexing, hints, used explain plans and analyzing teh database.
• Created Standard and Ad-hoc reports using Desktop Intelligence and Web Intelligence.
• Published reports on to Central Management Console on Business Objects Enteprise.
• Used Drill down Group Levels, Conditional formatting, Alerters, Alternate row shading futures and Created Label reports for Providers and Subscribers.
• Running teh SQL scripts from TOAD and creating Oracle objects like tables, views, Indexes, sequences, synonyms and so.
• Worked with offshore team by halping them to understand teh requirements and co-ordinate with them to meet teh deadlines.
• Extensively used UNIX shell scripts and called teh shell script in teh workflow manger through command task.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate teh activities.
• Unit testing, System testing and User Acceptance Testing (of Reports) throughout teh migration process.
• Worked on UNIX shell scripting, Job scheduling using Autosys and Ctrl-M schedulers.
• Responsible forTesting and Validationof teh code in teh mappings using teh data populated.

Environment: Informatica 8.6.1, Oracle 10g, PL/SQL, TOAD 8.6.1, SQL Server 2005, Business Objects XIR2, Windows NT, UNIX Shell Scripting.

Confidential, Cranbury, NJ

ETL Informatica Lead

Responsibilities:

• Led a team of 8 members (onsite + offshore) for dis effort.
• Involved in creation of documentation for gap analysis, impact analysis, high level designs and low level designs of current as well as to-be system.
• Involved in design discussions for redesigning teh new consolidated database.
• Developed / Translated detail design requirements into feasible technical Informatica implementations. Assist identifying key deliverables and defining timelines from Business Unit program perspective.
• Led technical discussions impacting solutions and data integration technology.
• Involved in defining and implementing standards for technology and business processes.
• Designed ETL mappings using Informatica Designer 8.x and Oracle PL/SQL to extract teh data from Oracle databases and Flat files.
• Created Informatica PowerCenter mapping / mapplets, reusable transformations using all teh transformations like normalizer, lookup, filter, expression, stored procedure, aggregator, update strategy, sessions and workflows etc.
• Worked extensively in Oracle PL/SQL, Toad, SQL*PLUS, Query performance tuning, created DDL scripts, created database objects like Tables, Indexes, stored procedures etc.
• Created utility programs for file manipulations, pre-session, post-session using shell scripts and also used autosys for scheduling workflows.
• Involved in ETL testing created Unit test plan and Integration test plan to test teh mappings and created teh test data.
• Provide support for system and user acceptance testing.
• Support DBAs and Informatica Admins during QA / PROD deployment.
• Streamlined teh process of production releases by creating a new release management process of deploying components from development to production.

Environment: Informatica 8.X, ORACLE 10g, TOAD, Linux, QC (Defect Tracking).

Confidential, Virginia

Senior Consultant

Responsibilities:

• Understanding teh current system as well as teh future state proposed by teh Business team
• Analyze and understand data coming from all applications
• Work with teh engagement team to identify business requirements, perform requirement management, functional design, prototyping, process design including scenario design and flow mapping, testing, training and defining support procedures
• Architect, design and develop enterprise business intelligence and data warehousing solution
• Define, design and implement logical and physical data models
• Design and develop data cleansing routines utilizing typical data quality functions involving standardization, transformation, rationalization, linking and matching
• Create processes for defining and documenting data standards and meta models
• Build an integrated metadata environment consisting of both operational and business metadata and ensure quality and integrity of teh data
• Create ETL routines using Informatica PowerCenter to load data into teh new dimensional database.
• Optimize performance of existing data structures, design and implement data quality and data auditing processes as well as continue to provide expertise in data discovery and profiling

Environment: Informatica PowerCenter 9.X, ORACLE 11g, TOAD, ECLIPSE, XML, Subversion, Linux, Autosys.

Confidential, Jersey, NJ

Informatica Consultant

Responsibilities:

• Played an extensive role in ETL mapping design, development, Unit Testing and implementation of teh end to end solution using SDLC techniques.
• Developed Mappings, Sessions and Workflows using Informatica Power Center Designer and Workflow Manager.
• Provided Pre & Post production assistance.
• Was involved in SQL and PL/SQL Coding of Stored Procedures, Functions and Triggers.
• Worked on Crystal Reports.

Environment: Informatica Power Center 5.1, Crystal Reports 8.0, Oracle 9i, UNIX AIX, Windows 2000, PL/SQL, SQL Navigator.