SUMMARY:

• 10+ Years of IT industry Expertise in Requirement Analysis, Functional Analysis, Design, Development, Implementation, Testing, Debugging, Productions Support, Informatica PowerCenter Administration and Maintenance of various Applications.
• Participate in Agile team activities including daily standups, sprint planning, PSI planning, product demos, etc.
• Highly proficient in ETL using Informatica Power Center 10.1/9.6, 9.5, 9.1/8.x/7.x, Informatica Cloud, Informatica DVO, IDQ, MDM and reporting using OBIEE.
• Extensive experience in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Experience in scheduling the Informatica workflows using Cntrl - M and Informatica Scheduler.
• Extensive experience working with databases like IBM UDB DB2, Oracle and MS SQL Server.
• Extensive experience working with Salesforce & Informatica Cloud environment.
• Experience in working with UNIX, LINUX and windows environments.
• Involvement in different phases of the Software Development Life Cycle (SDLC).
• Strong expertise in designing and developing Business Intelligence solutions in staging, populating Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Data Marts / Decision Support Systems using Informatica Power Center 10.x/9.x/8.x/7.x Versions.
• Experience working with onsite-offshore model projects while working closely with clients and team members.
• Extensive experience in Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, and Dimension Data Modeling.
• Domain Experience: Diversified experience in multiple domains like Insurance and Supply Chain.
• Excellent communication skills and analytical skills and ability to Lead & perform as team player.

TECHNICAL SKILLS:

ETL, BI Tools: Informatica PowerCenter 10.1/9.5/ 9.1, 8.x, 7.x Power Exchange and OBIEE 12c Reporting.

Packages/Validation Tools: Informatica DVO, Informatica Power Exchange, SAS DataFlux, Pentaho Data Integration, Pentaho Spoon, IDQ and MS Office Tools.

Languages: SQL, PL/SQL, Shell Programming, Windows Batch Scripting

RDBMS & other Tools: Oracle 11g/10g/9i, Oracle, SQL Server, Teradata, DB2, TOAD, IBM Data Studio, SQL Developer. Etc

PROFESSIONAL EXPERIENCE:

Confidential, Hanover, MD

Sr. Data Analyst / Sr. Informatica Lead Developer

Responsibilities:

• Client Description: Confidential (NASDAQ: CIEN) is a United States-based global supplier of telecommunications networking equipment, software and services that support the delivery and transport of voice, video and data services. This project manages the BI\DW for the networking giant.The project deals with producing reports for the users and the senior management regarding the expenses incurred and the procurements as against the sales volumes. Reports are generated to showcase the existing contracts, invoices from customers about equipment’s and to forecast the renewal of contracts by customer as and when required..
• Technology/Environment: Informatica PowerCenter 10.1/9.6, Informatica Cloud, Salesforce, OBIEE Reporting, Oracle & Unix.
• Responsibilities:
• Working with customer and Sr Technical Managers for business information and application needs.
• Developed Informatica Cloud tasks and populated EDW from salesforce objects.
• Working on Supply chain Domain.
• Extensively worked on Informatica ETL development and provided files to third party vendors.
• Developed medium to complex level informatica mapping and tuning the mappings and workflows for optimum performance.
• Extensively worked on data analysis, design, ETL development, Unit testing, QA/Production deployments and production support.
• Working with offshore team and provided requirements for ETL development.
• Working with the business analyst team to analyze the final data and fixed the issues if any.
• Extensively worked with Informatica migration team for QA and Production deployments.
• Conduct code walkthroughs and review peer code and documentation.
• Extensively used Informatica Cloud and replicate the objects in oracle from salesforce.
• Used Active Batch for informatica jobs scheduling.
• Provide resolution to the incidents and tickets raised

Confidential, Bloomington, IL

Sr. Informatica Lead Developer/Administrator

Responsibilities:

• Client Description: Confidential is a large group of insurance and financial services companies in the United States. The group's main business is Confidential Mutual Automobile Insurance Company, a mutual insurance firm that also owns the other Confidential companies.
• Project Description: The Data Movement Framework provides a set of reusable templates that work together to provide a holistic end-to-end view of data movement. The framework provides consistency for executing data movement, handling exceptions and reprocessing of those exceptions as well as generating incidents. This means that business partners are able to understand the data movement flow without having in depth technical knowledge.
• Technology/Environment: Informatica PowerCenter 9.5, Oracle, SQL Server,DB2
• Responsibilities:
• Analyze user requirements, Coding, Prepare testing specs, database designing.
• Design and Develop Mappings, sessions and workflows in Informatica for data migration.
• Extensively worked on data analysis, design, ETL development, Unit testing, QA/Production deployments and production support.
• Create Reusable Transformations and Mapplets and used them in various Mappings to reduce the redundant work.
• Extract data from flat files and other heterogeneous sources and load the data into respective tables and files.
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.
• Extensively worked with Informatica migration team for QA and Production deployments.
• Conduct code walkthroughs and review peer code and documentation.
• Involve in Data validation, Bug Fix, determining the bottlenecks and fixing the bottlenecks.
• Developed PL/SQL stored procedures, packages and functions.
• Extensively worked on Data Integration and Data Management.
• Discussion with Business Analysts and System Analysts to understand the application.
• Design and Develop UNIX Reusable Scripts to be used across the enterprise for Data Movement Projects under HDM.
• Provide support for HDM Framework Utilities across different Projects.
• Provide Production support on shared platforms for different projects.
• Setup and configure power center domain, GRID and Services.
• Apply Hotfix’s as and when required
• Setup an administer power center security for projects
• Design and Develop UNIX Reusable Scripts to automate installation steps

Confidential, Bloomington, IL

Sr. Informatica Lead Developer/ On-Site Coordinator

Responsibilities:

• Project Description: The Data Movement Framework provides a set of reusable templates that work together to provide a holistic end-to-end view of data movement. The framework provides consistency for executing data movement, handling exceptions and reprocessing of those exceptions as well as generating incidents. This means that business partners are able to understand the data movement flow without having in depth technical knowledge.
• Technology/ Environment: Informatica PowerCenter 9.6 and UNIX shell scripting.
• Responsibilities:
• Analyze user requirements, Coding, Prepare testing specs, database designing.
• Design and Develop Mappings, sessions and workflows in Informatica for data migration.
• Provide support for the implemented code for defects and enhancements.
• Work closely with QA team during the testing phase and fix bugs that were reported.
• Create Reusable Transformations and Mapplets and used them in various Mappings to reduce the redundant work.
• Work with Data / Data Warehouse Architect on logical and physical model designs.
• Perform data validation, reconciliation and error handling in the load process.
• Design and Develop UNIX Reusable Scripts to be used across the enterprise for Data Movement Projects under HDM.
• Provide support for HDM Framework Utilities across different Projects.
• Defect logging and Tracking as per Confidential standard and expectation.
• Unit testing and Integration testing for any issuance changes as per Confidential standard and expectation.
• Communicating day to day status with Project Manager.
• Understanding the business functionality of the application.
• Understand the Business, Technical and Functional Requirements .
• Discussion with Business Analysts and System Analysts to understand the application.
• Discussion with Vendors of the Product to understand the functionality of the Hardware Machine.

Confidential, Bloomington, IL

Sr. Informatica Lead Developer/ On-Site Coordinator

Responsibilities:

• Project Description: The goal of the MFI Data Conversion is to migrate all customer credit card data and bank accounts for (27 regional offices) from existing plus systems to new database.
• Technology/ Environment: Informatica PowerCenter 9.1, Informatica Power Exchange, Informatica DVO, DB2 on Z/OS, IDQ and LINUX scripting.
• Responsibilities:
• Analysis of the specifications provided by the clients.
• Design of Conversion, Data extraction, transformation and load.
• Testing, validation and implementation of delivered conversion components - with SFI’s active participation.
• Provide support for Integration testing.
• Client Support for Project pilot and rollouts.
• Responsible for overseeing the Quality procedures related to the project.
• Monitoring all the subject areas under all the iterations.
• Developing data naming standards
• Analyzing source systems and creating a Best Practices mapping to the target database schema.
• Defining and implementing the required business transformation rules and logic (ETL development).
• Designing and developing exception handling and data cleansing / standardization procedures.
• Optimizing ETL performance.
• Identifying and managing data quality issues.
• Assessment and recommendation of ETL/other tools.
• Defining a suitable architecture for data integration from multiple, disparate data sources.

Confidential, Bloomington, IL

Sr. Informatica Developer

Responsibilities:

• Project Description: The goal of the ECS Data Conversion is to migrate all data for (27 regions) Insurance Property and Casualty Claims System functionality from the existing legacy HP9000 platform to a J2EE platform. Out of this, the Data Management Project (R12800) has the responsibility to develop and implement Data Conversion related products (that includes referring Logical & Physical models, Database and Test data to Design Conversion, Develop Informatica Mappings, Unload, FTP & Wrapper Scripts for automation, JCLs for DB2 Load/Unload) and Data Quality Assurance.
• Technology/ Environment: Informatica PowerCenter 8.5, DVO, DB2, Salesforce, Oracle, SAS DataFlux, Pentaho Spoon, Cntrl-M, and UNIX shell scripting.
• Responsibilities:
• Analysis of the specifications provided by the clients.
• Design of Conversion, Data extraction, transformation and load.
• Testing, validation and implementation of delivered conversion components - with SFI’s active participation.
• Migration of data from all source system data to target DB2.
• Knowledge transfer to the team on iterations of the project.
• Assigning day to day tasks to the offshore team and reviewing the end product.
• Training on Conversion.
• Provide support for Integration testing.
• Client Support for Project pilot and rollouts.
• Responsible for overseeing the Quality procedures related to the project.
• Monitoring all the subject areas under all the iterations.
• Developing data naming standards
• Analyzing source systems and creating a Best Practices mapping to the target database schema.
• Defining and implementing the required business transformation rules and logic (ETL development).
• Designing and developing exception handling and data cleansing / standardization procedures.
• Optimizing ETL performance.
• Identifying and managing data quality issues.
• Assessment and recommendation of ETL/other tools.
• Defining a suitable architecture for data integration from multiple, disparate data sources.

Confidential, Bloomington, IL

Informatica Developer

Responsibilities:

• Project Description: This project is a post conversion activity for ECS migration project, which discards some data during conversion due to some business rules and exceptions such as duplicate data, referential integrity violation, Nulls in the primary key, Nulls in the non-key attributes. This objective of this project to analyze these data which didn’t get converted properly and lying into exception files/tables. Defects need to be raised for all the exceptions and assigned to the concern team such as data, development and requirement teams. Various tools were used such as RUMBA, IBM command editor for DB2 SQL queries, Informatica for analyzing complex and cross platform exceptions and MS Access, Excel BOXI for reporting.
• Technology/ Environment: IBM DB2 OPTIM DATA STUDIO, IBM HOST,Informatica 9.0,UNIX,Putty
• Responsibilities:
• Involved in Analysis of source target parent child relationships.
• Conduct data quality analysis on various source data systems.
• Analyzed Informatica data mapping requirements.
• Developed complex queries, UNIX scripts and Informatica mappings to analyze exception data.
• Communicate Requirements, Development and Data related issues to concerned teams.
• Raised defects in Lotus Notes with complete defect descriptions.
• Development of reporting module using Ms Access & Excel reports.
• Tracked each exception defect till its resolution.
• Presentation of Issues and findings to subject matter expert.