SUMMARY:

• Overall 9years of IT experience in the Business Analysis, Design, Data Modeling, Coding, Implementation and Testing of Applications using wide range of Technologies including Data Warehousing, Database and reporting systems for Sales, & Distribution, Retail and Finance Industries.
• Having good expertise in migrating various Informatica sessions and mappings from one version to another.
• Well versed with Informatica 8.1, 8.6, 9.1, 9.5, 9.6 64 bit.
• Experience in working with all the transformations in Informatica and applying the logic with the requirement.
• Data warehousing experience using InformaticaPowerCenter 9.x/8.x/7.x/6.2/5.0, Informatica Power Exchange 8.1 and extracting data from Db2, Oracle, MS SQL Server, MS Access, AS400.
• Extensive experience on Data Quality by creating checks to know the Quality of Data in Confidential project.
• Sound knowledge on Informatica Data Qualityconceptsand IDQ tool.
• Extensive experience in using various Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer and Warehouse Designer.
• Knowledge on reporting tool Business Objects.
• Experience in integration of various data sources from Databases like MS Access, Oracle, SQL Server and file formats like flat - files, CSV files, COBOL files and XML files.
• Sound knowledge of Oracle 10g/9i/8i/8.0/7.x, MS SQL Server 2000, MS Access 2000, PL/SQL, SQL*Plus, DB2 8.0.
• Worked on various database tools like Toad, SQL Developer, PL/SQL Developer, Rapid SQL developer.
• Extensively executed SQL queries on Oracle using Toad and SQL server tables in order to view successful transaction of data and to validate data.
• Good knowledge of Data warehouse concepts and principles (Ralph Kimball / Inman), Star Schema, Snowflake, SCD.
• Experience in integration of various data sources with multiple Relational Databases like Oracle, SQL Server, IBM DB2 and XML filesand worked on integrating data from flat files like fixed width and delimited.
• Used informaticaNORMALIZER Transformation to convert the data from Legacy systems.
• Expertise in several key areas of Enterprise Data Warehousing such as Change Data Capture (CDC), Data Quality, and lookup Tables and ETL data movement.
• Experience in identifying Bottlenecks in ETL Processes and Performance tuning of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, and Normalization/ Denormalization strategies.
• Experience in database performance tuning.
• Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Good knowledge in InformaticaBIG data concepts and BDE tool.
• Experience in ETL testing, involved in QA testing with various teams.
• Highly Motivated to take independent responsibility as well as ability to contribute and be a productive team member
• Ability to work in multiple projects simultaneously.

TECHNICAL SKILLS:

ETL Tools: InformaticaPowerCenter 9.6/8.6/8.1/7.1/6.2, SQL*Loader, IBM Datawarehouse tool.

Reporting Tools: Business Objects XI, Tableau 7.0.

Databases: Oracle 11i/10g/9i/8i/7.x, SQL Server 2012/2008/2005, DB2 UDB, MYSQL, Netezza, IBM AS400.

Data Modeling: Erwin 4.0/4.1/5.0.

Scripting: Unix Shell Scripting.

GUI: Toad 9.x/7.4,Oracle designer2000, Pl/SQL developer, SQL Developer

OS: UNIX(Sun Solaris 2.x,HP/UX 11), Win 95/NT/98/2000/XP, MVS,MS-DOS, IBM AIX 4.2.

Scheduling: Control-M, Informatica Scheduler

Other: SQL* PLUS, SVN, MS Word, Excel, Outlook, PowerPoint, HP Lifecycle,Tortise,BMC Remedy,Rapid SQL, Tibco, Mercury Quality center.

PROFESSIONAL EXPERIENCE:

Confidential, Woonsocket, RI

Sr. Informatica Consultant

Responsibilities:

• Create Test templates that will be used for validation testing and testing with the various tool sets which includesUnix Batches, Informatica, Control M, SQL Developer, SBM teamtrack, Sharepoint.
• Create the results summaries once tests are completed which contains the required information on performance parameters like CPU utilization, SBS, Runtime, stability of ENV during the test.
• Worked on various tasks including enhancements, new developments of ETL loads in the MySchedule project.
• Interface with Business Owners and project team resources on the requirement gathering. Various changes has been done to the ETL loads in WFM and RTM application based on business requirements.
• Worked on new project LTC (Omnicare) where we need to create ETL loads for the LTC application for the LTC employees forecast and demand. Involved in discussions with RXDW team which provides the source data. Got all the clarifications from the source team for the files they provide.
• Had various discussions with business team on the requirements for ETL loads which consists of HR load, Volume Drivers, Punch. Once the requirements are finalized then prepared the ADD’s (Application Design Document) and got it approved from the various stakeholders.
• Once the ADD’s are approved worked on the ETL development and also on the job set up through Control-M. Created batch jobs which will invoke the Informatica workflow through Control-M via pmcmd command.
• Unit testing is performed once the development is done and next the code is pushed to QA.
• Supported QA team on the QA testing. Once the QA is passed it is moved to UAT where the End to End testing happens.
• Worked in setting up the DB connection from DB2 database to ETL server by creating the required catalog entries in ETL server.
• Worked in creating purge mappings for the DB2 database tables.
• Also created Control-M FTP jobs for all ETL loads which will put the ETL load files into application server.
• Apart from this I have also taken care of the Business manual requests which needs to be tested in uat and send to prod on the same day once the business confirms the data is fine in uat.
• Also worked on the Data Masking job for LTC employees data. Used Substitution Masking for Employee names. Used Expression masking for Phone Nbr’s, Email id’s. Used Key masking for Date of Birth, SSN.

Environment: InformaticaPowerCenter 9.6.1, Data Masking, SQL Developer, Teamtrack, Unix-Putty, Oracle, Tortoise, Control-M 7.0, WinScp, IBM DB2, Toad for IBM DB2

Confidential

Sr. Informatica Developer/Lead

Responsibilities:

• Designed and Developed ETL mappings using transformation logic for extracting the data from various sources systems.
• Worked on converting technical specifications into Informatica Mappings.
• Loaded data from different source systems like Flat files, Excel, Oracle, .txt files.
• Worked with Reporting team to get to an agreement on what level of complexity to be handled by ETL and reporting side.
• Worked on Informatica tuning at mapping and sessions level.
• Extensively used InformaticaPowerCenter 8.6/9.5 and created mappings using transformations like SourceQualifier, Joiner, Normalizer, Aggregator, Expression, Filter, Router, Normalizer, Lookup, Update Strategy, and Sequence Generator .
• Have used NORMALIZER Transformation heavily to convert the data in flatfile RDBMS structures.
• Used Mapplets, Parameters and Variables to facilitate the reusability of code.
• Worked on Pre and Post SQL queries on target.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Created scripts which are reviewed by DBA’s and checked in SVN tool Tortoise.
• Created unit test cases and checked them in HP lifecycle management tool which will be accessed by QA team for testing.
• Done many comparisions between source data and staging data through excel for the QA.
• Worked in Agile model projects.
• Worked on various UAT and PROD incidents raised by users and which require timely response for L3 support.
• Solved many production tickets as part of PRODUCTION L3 SUPPORT.
• Involved in Unittesting, User Acceptance testing, Stress Integration testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Implemented many technical JIRA’s and released it to production with proper user sign off’s.
• Documented the various development JIRA’s I have worked on and created TDD (technical design document) incorporating the changes done.
• Responsible for Regression testing ETL jobs before test to production migration.
• Created scripts based on existing procedures according to the user requirements.
• Investigated and fixed problems encountered in the production environment on a day to day basis.
• Troubleshoot the data and performance issues raised by user community, designed, developed and deployed the code to fix them.

Environment: InformaticaPowerCenter 8.6/9.5, PL/SQL Developer, JIRA, Unix-Putty, Oracle, Tortoise, HP lifecycle management tool, SVN commit tool

Confidential

Informatica SoftwareDeveloper

Responsibilities:

• I have been given KT as my project started from Dec 28th.
• Knowledge transfer on various support procedures followed by Confidential .
• Studying the various Confidential KT support documents.
• Have been back up for both ETL and DQ (Data Quality) teams.
• Worked on InformaticaPowerCenter 8.6 creating various mappings, sessions, worklets, and workflows.
• Extensively used Informatica Power Center and Talend Open Source and created mappings using transformations like SourceQualifier, Joiner, Normalizer, Aggregator, Expression, Filter, Router, Normalizer, Lookup, Update Strategy, and Sequence Generator .
• Done migrations from AS400 to Informatica, there are some processes running with less performance and taking long hours in AS400. These have been identified and the AS400 RPG code has been migrated to Informatica where now it runs with better performance and completes in acceptable time.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Done DQ work like preparing CPM/Everest reports, sending the delay mails, taking care of the conflicts occurred in table loads and sending mails to ETL team regarding this and also sending the DQ daily verifications report.
• Worked on full time ETL from July, completed various migrations, Change requests from clients and taken care of remedies.
• Used various heterogeneous sources like Oracle, Flat files, AS400 power exchange to develop the code in Informatica. Used various transformations like look up, joiner, expression, filter, update strategy, router, sorter, aggregator, source qualifier to develop the code.
• Worked on GM leasing project where 797 flat files are loaded into Oracle tables using various worklets, mappings, sessions. Post production issues with source have been reported to client. Monitoring the workflow for post-production issues.
• Interacted with client to clarify the queries and complete the development.
• Total SDLC cycle has been implemented in the migration of CCARE process.
• Also involved in adding the missing columns in XML.xsd source and updated the mapping with the columns.
• Sending Daily Informatica support handover at the end of day to the client, taking care of weekly KPI’s, Documentation changes from clients, sending monthly job report and explaining the cause of table load delays to DQ (Data Quality) team in the table load delay email.
• Acted as primary offshore support person which rotates alternate week.
• Received client accolade for improving the performance of critical job which is running for 3 hrs to 15 mins and making the table loads ready by the time business users started their reporting.
• Migrated SQL server packages into Informatica and the SQL server packages has been retired.
• Involved in Unittesting, User Acceptance testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.

Environment: Power Exchange 8.6, Oracle 11i/10g, MS SQL Server, XML Files, SQL, PL/SQL, Windows XP, UNIX, InformaticaPowerCenter 8.6/9.0, SQL Developer, BMC Remedy Tool, Putty, AS400, Rapid SQL tool.

Confidential, San Antonio, TX

Informatica Consultant

Responsibilities:

• Analyzed user requirements for the system
• Installed and Configured Informatica Power Center 8.1 on Client (windows) / Server (UNIX) for Development, Test and Production Environments.
• Experience working with enterprise-wide conformed dimensions.
• Designed and Developed ETL mappings using transformation logic for extracting the data from various sources systems.
• Developed mappings, mapplets by using mapping designer, and mapplet designer in Informatica Power Center 8.1 designer.
• Performed Data Extractions, Data Transformations, Data Loading, Data Conversions and Data Analysis.
• Worked heavily on processing the unstructured data.
• Developed Reusable Mapplets and Transformations for reusable business calculations
• Extracted data from different sources like Oracle, SQL Server 2005 and Flat files to load into ODW.
• Involved in collection of statistics on original query and analyze them to set up a test environment.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Expression, Lookups, Filter, Router, Sequence Generator, Update Strategy, and Joiner transformations have been used.
• Involved in Unittesting, User Acceptance testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Performed tuning of Informatica sessions by implementing database partitioning, increasing block size, data cache size, sequence buffer length, target based commit interval and SQL overrides
• Documented standards for Informatica code development and prepared a handbook of standards.Involved in migration of ETL code from development repository to testing repository and then to production repository.
• Worked on netezza databases.
• Handled the dead lock errors that occurred due to dependency of jobs running simultaneously.
• Provided support for daily and weekly batch loads.
• Prepared Run book for the daily batch loads giving the job dependencies and how to restart a job when it fails for ease of handling job failures during loads.

Environment: InformaticaPowerCenter 8.6.1,Netezza, Business Objects XI, Oracle 11i/10g, TOAD, SQL, PL/SQL, Windows XP, UNIX.

Confidential, Columbus, OH

Informatica Developer

Responsibilities:

• Involved in developing mapping from the design documents.
• Extensively worked on the Confidential 's weekly sales data from US and Canada.
• Used DB2 as the source to populate the data starting of the week. Used data warehouse Manager to load weekly data before.
• Reviewed and analyzed the existing ETL logic that was developed through earlier ETL tool “IBM Data Warehouse Center”.
• Migrated existing ETL code from “IBM Data Warehouse Manager” to InformaticaPowercenter 8.1.1 by creating new mappings/sessions/Workflows.
• Created Flat files and imported to Unix Box.Checked the file using Putty.
• Used mapping designer to generate different mappings for different loads.
• Developed mappings, sessions and workflows (ETL) for SCD types I, II and III to meet the requirements
• Worked on performance tuning and optimization of the Sessions, Mappings, Sources and Target.
• Created Informatica mappings with PL/SQL procedures/Functions to build business rules to load the data.
• Created shortcuts for the necessary sources and targets in the Versioned Repository shared folders to continue the migration work of Phase1.
• Responsible for Unit Test, System Integration Test and UAT to check the data quality and documenting the test results.
• Designed necessary “Reusable” command tasks for calling appropriate “Groovy Scripts”, which will manipulate the data in “Hyperion Essbase Cubes”.
• After migrating the ETL logic into Informatica Code, tested the results between both “Informatica& IBM Data Warehouse Center environments” by designing the test scripts in “Mercury Quality Center”.
• Migrated through various environments in Informatica 8.1(Test, PQA and Prod).
• Responsible for writing unit test cases and performing the unit testing for data validity based on business rules.
• Designed and tested the reports in Hyperion Excel Essbase Add in to compare the reports between “Informatica& IBM Data Warehouse Center environments”.

Environment: InformaticaPowerCenter8.1,IBM DB2 8, IBM Data Warehouse Center, Toad, SQL, Putty, Hyperion Essbase Administration services, Mercury Quality Center 9.0.

Confidential, Jefferson City, MO.

Jr.Informatica Developer

Responsibilities:

• Involved in gathering the business requirements and in the analysis & design of the Data Warehouse model with Facts and Dimension Tables.
• Extensively worked with Designer, Workflow Manager, Workflow Monitor and Repo sitory Manager.
• Extensively used Designer to manipulate source definitions, create Mappings, Mapplets.
• Converted procedures into mappings using various transformations like Source Qualifier,Expression, sorter, Update Strategy, Filter, Lookup, and Aggregator etc.
• Developed the ETL logic to load data from various heterogeneous systems such as Oracle,Flat files and xml files.
• Validation of Informatica mappings for source compatibility due to version changes at the source.
• Worked on SQL Loader for bulk load of data and used SQL tuner for tuning SQL.
• Implemented Type2 SCD Methodology.
• Created and refreshed repositories for test phase’s crp1, crp2, uat with prod repository.
• Monitored Workflows and Sessions using Workflow Monitor.
• Trouble shooting of long running sessions and fixing the issues.
• Created workflows using Session, Command, and Email tasks
• Monitoring of workflows and running of workflows by changing the incremental windowsfor test purposes.
• Documented every aspect of data migration and reporting any problem, missing data or ambiguity into exception report.
• Resolved various production tickets.

Environment: InformaticaPowercenter 7.1.4, Oracle 10g/9i, Toad, UNIX, Windows XP, Flat Files.