SUMMARY

• About 12+ yearsof total experience in Information Technology Industry, expertise in developing Business Intelligence and Data Warehousing applications and Master Data Management process, especially using ETL InformaticaPowerCenter, IDQ and Informatica MDM.
• Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such asInstall, Design,Development, Testing, Deployment, Maintenance, and Production Support for DWBI technologies on various platforms like UNIX and Windows.
• 5+Years of experiencing in configuring maintenance, testing, and troubleshooting on Informatica Master Data Management 10.2/9.7.1/9.5.1/9.1 (MDM) and Informatica Data Quality 10.1/9.5.1.
• Provide technical leadership to MDM team on design and implementation for Supply Chain and Provider.
• Expertise in Installing, Managing, and configuring Informatica MDM Hub Server, Informatica MDM Hub Cleanse Server, Cleanse Adapters (Address Doctor), ActiveVOS, and Hub Resource Kit.
• Worked on upgradation MDM version 9.7.1 to 10.2 and configured Business Entity 360.
• Designing, developing multiple cleansing and standardization scenarios. Worked extensively on BDDconfig file to get the changes reflected on IDD.
• 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 involved in Analysis, Design and Implementation of DW & BI Projects.
• Expertise in dimensional modeling, especially in star schema.
• Excellent working experience in InformaticaPowerCenter 10.1/9.6/9.1.0/8.6 (Designer, Workflow Manager, Workflow monitor, Repository Manager, Administration Console)
• Good experience in InformaticaPowerCenter performance tuning and Administration.
• Working experience with IDQ 9.5, Data Profiling, Standardization and Data Analyst, guidelines, and best practices.
• Knowledge of best practices on Process Sequence, Dictionaries, Data Quality Lifecycles, Naming Convention, Version Control.
• Informatica Address Doctor, address validation service to validate address information using IDQ and MDM.
• 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.
• Domain expert in the areas of Banking&Finance, Communications,IME, Pharmacy, and Health care.
• Good working experience with Agile Software Development Methodology.
• Worked on projects for clients such as Deutsche Bank, FRANKLIN TEMPLETON,D&B, Universal Music Group, JPMorgan Chase & Co, Frontier Communications, Pharmacyclics Inc, JNJ and Confidential .
• “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/2008/2012 , Windows XP/7, UNIX

Programming Languages: UNIX Shell Scripting, Batch scripts, JAVA

DWBI Tools: ETL Tools InformaticaPowerCenter10.1/9.x/ 8.x /7.x/6.x Informatica MDM 10.2/9.7.1/9.5.1/9.1 Informatica Data Quality 10.1/9.5.1

Data Modeler: ERwin7.2

RDBMS: Sybase 12.6, DB2 9, SQL Server 2008/2012, Oracle11g/12g, Teradata 13/14

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

SCM Tools Used: Microsoft VSS and RCS

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

MDM consultant

Responsibilities:

• Perform high-level architectural planning, proof-of-concept and software design.
• Develop solution outline, and support requirements gathering for MDM projects.
• Interface with businessand IT stakeholders to identify issues and develop solutions.
• Contribute to the analysis of data requirements, data integration, and perform data mapping.
• Creating views for DQ dashboards.
• Modified Informatica ETL inbound and outbound processes for Informatica MDM Party model.
• Worked on cleanse rules and data quality rules.
• Performed match analysis and tweaked rules base on business requirement.

Confidential, Irving, TX

Informatica MDM Developer

Responsibilities:

• Participate in the BRDs Sessions, giving insightful perspective of the MDM Hub and its environment for Item Master and Provider domains.
• Participate in planning and design review meetings with technical leads and project managers to determine schedules, review technical problems, and assign tasks and resources in Provider Domain.
• Provided technical leadership to MDM team on design and implementation for Item Master and Provider Domains.
• Participate in Requirements Analysis, Gap-Fit each MDM requirement as well as provide high level of estimate for the level of effort required to meet each requirement.
• Implemented the Land Process of loading the data 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.
• Configured Address Doctor which can cleanse addresses and enhanced by making some modifications based on requirements. Upgraded Address Doctor from 4.8 to 5 and licenses keys (unlock codes).
• Designing and developing 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.
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
• Customized/configured IDD application and Subject Areas, Subject Area Groups, Deploy and test IDD application, cleanse functions, utilizing timeline, export and import master data.
• Apply Hotfixes to MDM servers and supported for server maintenance.
• Installing of ActiveVOS Server in Windows, JBOSS.
• Scheduling of ActiveVOS Automatic Processes.
• Worked on upgrade from 9.7.1 to 10.2 and configured Business Entity 360.
• Created Users, Roles, and User Groups to grant required access.
• Taking care about administration tasks like creating MDM ORS, migrating objects between environments and server’s maintenances.
• Taking care about ETL and MDM jobs which are running daily, weekly, monthly and quarterly basis.
• Problem solving, data issues and reject resolutions for MDM process.
• Created user exists for task assignment and HDD implementation.

Confidential, New Brunswick, NJ

Informatica MDM HUB Consultant

Responsibilities:

• Involved in gathering business requirements for the HUB configuration.
• Worked closely with ETL data architect for performing land batch process to populate data from external source systems to landing tables in hub.
• Configured the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages, query groups and custom functions.
• 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 per Business Rules.
• Set up match/merge and run match rules to check the effectiveness of MDM process on data.
• Scheduling and supporting HUB data base weekly backups.
• Used Metadata manager to validate ORS and promote the objectsbetween environments.

Confidential

Informatica MDM Hub & IDQDeveloper

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.
• 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 per Business Rules.
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
• Data Analyst tool to manage the data quality and address doctor to validate addresses.
• Complex quality rule and index design, development and implementation patterns with cleanse, parse, standardization, validation, scorecard, exception, notifications.
• Used Metadata manager for validation, promotion, importing and exporting the ORS repositories to Development, QA, Pre-prod and prod environment
• 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.
• 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.
• 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.
• Utilized of InformaticaIDQ 9.5.1to complete initialdata profiling and matching/removing duplicate data
• Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
• Documented Cleansing Rules discovered from data cleansing and profiling.

Confidential

ETL Developer and Production Support Lead

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.

Confidential

Mapper

Responsibilities:

• Involved in Requirement gathering, System Designing, Application Development, Deployment and Testing
• Understanding the current design and Data Model
• Translate Business requirements into formal requirements and design documents.
• Preparing Data Flow Diagram with respect to the source system by referring cLDM.
• Regular discussions with the Business Analyst about the requirements and business
• Prepared the DA (Data Architect) Specs and passed to the development team
• Incorporated the mappings into a consolidated document and get it reviewed by Lead architect and then generated the PDM’s from the logical data model.
• Involved in Data Modeling to identify the gaps with respect to business requirements and transforming the business rules.
• Meetings with the development team to discuss the Data Architect designed documents