SUMMARY:

• About 10+ years of total experience in Information Technology Industry, expertise in developing Business Intelligence and Data Warehousing applications, especially on ETL Informatica PowerCenter.• Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as Design,Development, Testing, Deployment, Maintenance and Production Support for DWBI technologies on various platforms like UNIX and Windows.
• 2Years of experiencing in configuring maintenance, testing and troubleshooting on Informatica Master Data Management9.5/9.1(MDM).
• Expertise in Installing, Managing and configuring Informatica MDM Hub Server, Informatica MDM Hub Cleanse Server, Cleanse Adapters (Address Doctor), Hub Resource Kit.
• Experience in creating Base objects, Staging tables, foreign key relationships, queries, packages, query groups and custom functions in Informatica MDM.
• Successfully implemented IDD using Hierarchy Configuration and created subject area groups, subject areas, subject area child, IDD display packages in huband search queries for searching the data.
• Good working experience in SIT, Preparing Test Plans, and Test scenarios/Cases execution and also involved in Analysis, Design and Implementation of DW & BI Projects.
• Expertise in dimensional modeling, especially in star schema.
• Excellent working experience in Informatica PowerCenter 9.1.0/8.6 (Designer, Workflow Manager, Workflow monitor, Repository Manager, Administration Console)
• Good experience in Informatica PowerCenter performance tuning and Administration. Knowledge of IDQ 9.5 standards, guidelines and best practices.
• Knowledge of Data Profiling guidelines and best practices.
• Knowledge of best practices on Process Sequence, Dictionaries, Data Quality Lifecycles, Naming Convention, Version Control.
• Technical hands - on experience in managing production deployments and automation. And monitoring, job control and production support.
• Technical hands-on experience using OLAP tools likeOBIEE (dashboards, Answers and RDP).
• Expert Developer skills in SQL, PL/SQL and good knowledge in Teradata RDBMS development and use of Teradata utilities.
• Good exposure in Data modeling using Erwin.
• Domain expert in the areas of Banking&Finance, Communications,IME, andPharmacy
• Good working experience with Agile Software Development Methodology.
• Worked on projects for clients such as Confidential.
• Excellent communication and inter personnel skills, Proactive, Dedicated and Enjoy learning new Technologies and Tools.
• "Chandra is a dream of a client. He would be a welcome addition to any organization and I endorse his work 100+%. He is a great asset to any company." -UMG client.

TECHNICAL SKILLS:

Operating System: Windows 2000, Windows XP/7, UNIX Programming Languages: UNIX Shell Scripting

ETL Tools: Informatica PowerCenter 9.5/ 8.x Informatica MDM 9.5,Informatica Data Quality 9.5 OLAP Tools:OBIEE10g Data Modeler:ERwin7.2

RDBMS: Sybase 12.6, DB2 9, SQL Server 2008, Oracle11g, Teradata 13, Netezza v6

Other Utilities: Test Management Tool:Quality Center10 Scheduling Tools: Control-M, Autosys. FTP Tools: WinScp, SmartFTP, Putty

Database Tools Used: Rapid SQL, DBArtisan, TOAD, and SQL Developer, Text Editor Tools Used: TextpadSCM Tools Used: Microsoft VSS and RCS

PROFESSIONAL EXPERIENCE:

Confidential, New Brunswick, NJ

Developer

Responsibilities:

• Involved in gathering business requirements for the HUB configuration.
• Involved in implementing the Land Process of loading the data into Informatica MDM Hub.
• Defined the Base objects, Staging tables, foreign key relationships, lookups, queries, packages, message queues and query groups.
• Created mappings and scheduling the batch jobs.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules. Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
• Implemented IDD as per the Business requirements and Security Setup and updated resource groups, Scheduling and supporting HUB data base weekly backups.
• Used Metadata manager to validate ORS and promote the objectsbetween environments.

Informatica MDM HUB/IDD Specialist& PowerCenter Developer

Confidential, Sunnyvale, CA

Responsibilities:

• Involved in gathering business requirements for the data - warehouse as well as business-intelligence reports to be used by the management.
• Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.
• Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM Hub using ETL tool that was coming from various source systems.
• Defined the Base objects, Staging tables, foreign key relationships, lookups, queries, packages and query groups.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
• Implemented IDD as per the Business requirements.
• Worked with business SMEs on developing the business rules for cleansing.
• Used Metadata manager for validation, promotion, importing and exporting the ORS repositories to Development, QA, Pre-prod and prod environment.
• Identified Master records for Party Data by analyzing the data and duplicate records from source systems.
• Created mappin gs using Informatica Designer, Sessions & Workflows using Workflow Manager Performed Unit testing and System Testing.

Informatica MDM Hub Consultant& IDQ

Confidential, Durham, NC

Responsibilities:

• Collaborated closely with Business Analyst to understand the business data flow and in gathering requirements
• Configured and installed Informatica MDM Hub server, cleanse server, and Address Doctor5 in Development, QA, Pre - prod and Prod Environments.
• Worked closely with ETL data architect for performing land batch process to populate data from external source system to landing tables in hub.
• Configured the Base objects, Staging tables, foreign key relationships, lookups, queries, packages, query groups and custom functions.
• Used Hierarchies tool, for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD.
• Set up match/merge and run match rules to check the effectiveness of MDM process on data.
• Successfully implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries for searching the data for Organization, Individual and Products in IDD data tab.
• Implemented the approval process for subject areas in IDD, according to business rules and requirements Closely worked with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Defined the security such that MDM ORS schema will be secured with access only granted for specific integration uses, using users created for those specific integrations.
• App lied business rules using Informatica Data Quality (IDQ) tool to cleanse data. • Documented Cleansing Rules discovered from data cleansing and profiling.

ETL Developer and Production Support

Confidential, Irving, TX

Responsibilities:

• Performance tuning of the Informatica jobs.
• Responsible to ensure 24*7 production support for the project.
• Daily/Weekly Deployment of UNIX & Database code between DEV, UAT & PROD environment.
• Project Requirement Analysis, System Study and Estimation.
• Automation of existing manual jobs and processes reducing manual efforts.
• Continuous tracking of production issues and provide solutions to prevent recurring issues.
• Coordination between client business leads and Cognizant development team to ensure quality services.
• Continuous performance tuning of production jobs providing improvement in the completion times for critical production jobs.
• Provide statistical reports to business on various metrics like SLA misses during the month, number for production issues faced during the month etc.
• Communication and deliverables between Cognizant onsite - offshore and work with the clients.
• Guide team members in all technical challenges faced in the execution of project.
• Weekly Status Conference with the Client Project Management.
• Internal/External Quality Audit Representative of Project.
• Ensure adherence to Cognizant/JPMC Standards in Release/Change Management.
• Scheduling & un-scheduling of the jobs for Holiday based on source available.

ETL Informatica Lead

Responsibilities:

• Created mappings using Informatica Designer, Sessions & Workflows using Workflow Manager
• Created Perl scripts to schedule Informatica objects.
• Reviewed the mappings developed by members.
• Created SQL scripts to create tables.
• Guided team in technical difficulties and functional areas.
• Migration of objects in all phases (DEV, QA and PRD) of the project.
• Interacted with Onshore/Offshore meeting to get new requirements and update status.
• Support and manage Informatica ETL applications
• Coordinate & analyze data quality issues.
• Monitor inbound and outbound Informatica jobs
• Incident management and resolutions
• Design, Develop and Enhance Informatica mappings, workflows / sessions
• Perform unit testing, SIT and support for UAT
• Troubleshoot and resolve issues in transformations and mappings.
• Review and mentor junior team members.
• Planned / Emergen cy enhancement release support

ETL Informatica Developer

Responsibilities:

• Created mappings using Informatica designer, sessions using workflow manager and testing the sessions using test data.
• Worked extensively on different types of transformations like Source Qualifier, Expression, Aggregator, Filter, Router, Joiner, Update Strategy, Normalizer, and Lookup.
• Created shell scripts.
• Prepared test cases and test data.
• Performed Unit testing and System Testing.
• Interacted with Onsh

ETL Informatica Developer

• Installing Informatica PowerCenter 8.6.1 on Windows.
• Experience in Applying Informatica PowerCenter Hot fixes/Patches
• Ensures proper configuration of the PowerCenter Domain components.
• Experience in nodes, Repository services and Integration services.
• Create, backup, restore for Informatica Repositories.
• Creating Folders and manages user and user groups access to objects.
• Created System Delivery Specification (SDS) and Technical System Design (TSD) Documents From SRA. • Developed mappings/mapplets using Informatica designer, sessions using workflow manager and monitoring using workflow monitor.
• Worked extensively on different types of transformations like Source Qualifier, Expression, Aggregator, Filter, Router, Joiner, Update Strategy, Stored Procedure, Union and Lookup.
• Sending mails after load process using session command components and e-mail tasks.
• Created SQL scripts to create tables and create triggers and PL/SQL scripts to insert or update tables.
• Prepared test cases and test data.
• Performed Unit testing, SIT and support for UAT
• Interacted with Onshore/Offshore coordinators in status meetings.

ETL Informatica Developer

Responsibilities:

• Created mappings using Informatica designer, sessions using workflow manager and tested the sessions using test data.
• Worked extensively on different types of transformations like Source Qualifier, Expression, Filter, Aggregator, Joiner, Rank, Update Strategy, Stored Procedure, Sequence Generator and Lookup.
• Resolved if any issues in transformations and mappings.
• Prepared the shell scripts to load feeds coming in text files into database and then shoot Informatica jobs.
• Analysis of feeds sent by the various systems like GPLUS, IFTCS, and LS2 etc.
• Reviewed the mappings developed by other team members.
• Used Informatica features to implement Type II changes in slowly changing dimension tables.
• Monitored the scheduled jobs and resolved issues or job fails in Autosys.
• Maintain the root cause analysis & issues tracker sheet
• Interacted