Summary:

• 9 years of experience in IT Industry with experience in analysis, design, testing, development, documentation and implementation of client server applications.
• Experienced in leading a team of 4 or more offshore
• 5 years of ETL Experience using Informatica Power Center 9.1/8.6/8.5/8.1/7.3/6.2/5.1.2, Warehouse Designer, Power Connect, Power Plug, ETL, Datamart, TIDAL, OLAP, OLTP, Business Objects 5.1/5.0 Web-Intelligence 2.5, Designer 5.0, and Developer Suite Set Analyzer 2.0 .
• 3 years of ETL Lead Experience architecting solutions and creating ETL solutions.
• 5 years of work experience in Oracle 9i/8i/8.0/7.3, SQL, PL/SQL, SQL Loader, Stored Procedures, TOAD, Explain Plan, TKPROF Functions, Ref Cursors, Constraints, Triggers, Indexes-B-tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links, Export/Import Utilities.
• Strong analytical and conceptual skills in database design and development using Oracle 9i/8i/8.0/7.3, MS Access, MS Excel, Sybase 12.0/11.x/10, MS SQL Server 2000/7.0/6.5/6.0, DB2.
• Installation and upgrade of Informatica Version 9.5/9.1 and version and 8.6 on Solaris/Linux/AIX/Windows.
• Responsible for interacting with business partners to identify information needs and business requirements for reports.

Professional Experience:

Confidential

Informatica Lead

Responsibilities:

• Architected solutions and created and database solution framework.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Performed Configuration Management to Migrate Informatica mappings/sessions /workflows from Development to Test to production environment.
• Developing code to extract, transform, and load ETL data from inbound flat files and various databases into various outbound files using complex business logic.
• Created automated shell scripts to transfer files among servers using FTP, SFTP protocols and download files from web servers and hosted files.
• Developed Informatica mappings, enabling the ETL process for large volumes of data into target tables.
• Designed and developed process to handle high volumes of data and high volumes of data loading in a given load window.
• Developed and Tested Informatica mappings to load data into various dimensions and fact tables from various source systems.
• Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all applications and systems.
• Performed ETL extract, transform, and load duties to include requirements validation, code development, source control, unit testing, and version deployment scripting.
• Performance turning was done on various Informatica mappings to reduce the execution time.
• Experience in monitoring informatica repository health through informatica admin console
• Installed the v9.1/v9.5 Powercenter on AIX.
• Performance tuning of Oracle PL/SQL Scripts

Environment: Informatica 9.1.0/9.5, Oracle 10g, AIX, UNIX Shell Scripting, SQL, PL/SQL, SQL Plus 9.2, TOAD 8.0.

Confidential

Informatica Lead Developer

Responsibilities:

• Parsing high-level design spec to simple ETL coding and mapping standards.
• Develop Logical and Physical Data Model using Erwin, followed Star Schema to build Reporting datamart.
• Coordinating with source system owners, day-to-day ETL progress monitoring.
• Acted as Team lead in coordinating offshore ETL Development
• Project coordination, SME- End User meetings.
• Documenting design and mapping specs.
• Developed various Mappings and Transformations using Informatica Designer.
• Developed transformation logic and designed various complex Mappings and Mapplets using the Designer.
• Worked with Union, Lookup, Aggregator, Expression, Router, Filter, Update Strategy Joiner, Source Qualifier, Sequence Generator, Stored Procedure, XML Souce Qualifier transformations, XML parser Transformations.
• Designed complex mappings involving target load order and constraint based loading.
• Designed Informatica transformations for loading data from various like flat files/OCI/ODBC sources. Populated data from JMS queues from Intermediate Staging to flat files and staging tables, from staging tables to Relational Targets.
• Maintain and Document the Informatica Power Center setup on Windows environment. Worked on Informatica PowerCenter tool Source Analyzer, warehouse designer, Mapping Designer, Mapplets, Workflow Manager, Workflow Monitor, Data Analyzer, Metadata Manager and Reusable Transformations.
• Applied appropriate field level validations like date validations for cleansing the data.
• Using Informatica Designer designed Mappings, which populated the Data into the Target Star Schema, which is on Oracle Instance.
• Using Workflow Manager, for creating, Validating, Testing and running the Batches and Sessions and scheduling them to run at specified time.
• Estimated Level of effort required, planned and executed tasks to achieve project goals.
• Systematically planned and approached execution of project tasks as well as came up with ways to thoroughly systematically review and test deliverables by team members.
• Analyzed requirements and specifications for complex processing to verify that current and future business requirements are met and obtained relevant test data. Designed, coded and reviewed accurate and thorough test material Test Plan and Test Cases with pre-determined results within specified scheduled dates.
• Created copies for the non-production environments by masking the data to make sure test and development processes are not exposing sensitive information.
• Performance tuning of Oracle PL/SQL Scripts

Environment: Informatica 9.1.0/8.6.1, Oracle 10g, AIX, UNIX Shell Scripting, SQL, PL/SQL, SQL Plus 9.2, TOAD 8.0.

Confidential

BI Lead

Responsibilities:

• Designed and lead complex ETL Processes and identify areas of optimizations
• Provided a completed Data Mapping document with all business rules defined.
• Analyzed the data models of legacy implementations, identifying the sources for various dimensions and facts for different data marts according to star schema design patterns.
• Worked with multiple sources such as Relational Tables, Flat Files, Excel Sources for Extraction using Source Analyzer and Source Qualifiers.
• Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.
• Assisted in designing Logical/Physical Data Models, forward/reverse engineering using Erwin 4.0.
• Developed mappings to extract data from SQL Server, Oracle, Teradata, Flat files and load into Data Mart using the Power Center and acted as PR4/PR3 programmer.
• Developed common routine mappings. Made use of mapping variables, mapping parameters and variable functions, worked with Informatica IDQ for data cleansing.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Mart.
• Developed Slowly Changing Dimension for Type 1 SCD and worked on ETL ODI applications.
• Used mapplets for use in mappings thereby saving valuable design time and effort
• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, worklets and workflows.
• Estimated Level of effort required, planned and executed tasks to achieve project goals.
• Designed the ETL process for extracting data from heterogeneous source systems, transform and load into Data Mart
• Developed various slowly changing dimensional mappings according to the data mart schemas.
• Provided support including error handling and validation of mappings, sessions and workflow.
• Extensively used Debugger Process to test data and applying Break Points while Session is running.
• Provided support for Business Users and documented problems and solutions for running the workflow.
• Performance tuned the long running sessions.
• Installed software upgrades and patches.
• Responsible for applying EBF.
• Installed the v9.1 Powercenter on Linux.
• Performance tuning of Oracle PL/SQL Scripts

Environment: Informatica 9.1.0/8.6.1, Oracle 11g, RedHat Linux, UNIX Shell Scripting, SQL, PL/SQL, SQL Plus 9.2, TOAD 8.0.

Confidential

DW Support Analyst/ Informatica Developer

Responsibilities:

• Responsible for program and project management support for the CMS NDW for Department of Health and Human Services.
• Informatica administrator of the Informatica repository server and Informatica pmserver
• Responsible for migrations/upgrades for different versions of informatica. v7 to v8.5
• Functioning in a business analyst role by interfacing with traders and other users to identify gaps between the new and old securities end to end system, and introducing enhancements to the new system's securities pricing processes.
• Responsible for overall of all Informatica development.
• Responsible for migrations/upgrades for different versions of informatica. v7 to v8.5
• Performance tuning of Oracle PL/SQL Scripts

Environment: Informatica 8.6.1, Oracle 11g, Windows NT 4.0, UNIX Shell Scripting, SQL, PL/SQL, SQL Plus 9.2, TOAD 8.0.

Confidential

Informatica Admin

Responsibilities:

• Responsible for applying EBF and Upgrading Informatica from version 7.1.3 to 8.1 then onto 8.5 and 8.6.
• Informatica administrator of the Informatica repository server and Informatica pmserver
• Responsible for migrations/upgrades for different versions of informatica. v7 to v8.5
• Performance tuning was done for various complex mappings facts and dimension maps to reduce the load time.
• Responsible for configuring the Server Grid/HA Recovery and set the sessions to recover automatically in case of any failure which are configured on a 4 node Grid.
• Responsible for registering the AS400 tables for changed data capture using power exchange and creating PowerExchange CDC maps.

Environment: Informatica 8.6.1, Oracle 11g, Windows NT 4.0, UNIX Shell Scripting, SQL, PL/SQL, SQL Plus 9.2, TOAD 8.0.

Confidential

Informatica Admin

Responsibilities:

• Responsible for overall delivery of all Informatica development done locally and in New York
• Responsible for providing knowledge transfer and mentoring junior developers with new versions of informatica, Grid functionality and HA Recovery.
• Created Test Strategies, Test Plans and assisted the manager in generating estimates based on approved BRD.
• Responsible for creating comprehensive test artifacts test plans, test cases, bug reports, etc. and documented ETL Test Plans.
• Responsible for testing different versions of informatica and resolving the issues identified in the new version with the Informatica Support Team.
• Functioning in a business analyst role by interfacing with traders and other users to identify gaps between the new and old securities end to end system, and introducing enhancements to the new system's securities pricing processes.
• Improved development time by leveraging metadata, and reduced IT coordination costs by providing a common working business model across the Company's enterprise architecture.
• Working directly with traders to automate manual processes that previously caused losses in revenue
• Leading the day-to-day functions of a four person operate team that is responsible for the support of the Informatica application delivered in Phase I of the project.
• Designed architecture of Informatica and database environments for development, test and production.
• Performance tuning of Oracle PL/SQL Scripts
• Designed and developed UNIX shell scripts.
• Optimized/Tuned mappings for better performance and efficiency
• Created complex joins, transformations of all types to pass data through ETL maps.
• Acting as technical lead in Informatica, assisting in implementation of best practices, development standards, migration, and operating procedures
• Mentoring other Informatica Power Center developers
• Upgraded the application from informatica v6 to v7.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
• Used UNIX Shell scripting for automation of the process, invoking PL/SQL procedures, and Informatica sessions.
• Did Unit/Stress Testing for the entire application.

Environment: Informatica 8.5.1/7.1.2/6.2, Oracle 9i/10g, DB2,MS SQL Server 2000, Windows NT 4.0, UNIX Shell Scripting, SQL, PL/SQL, SQL Plus 9.2, TOAD 8.0.