PROFESSIONAL SUMMARY:

• 10+ years of total experience in Information Technology Industry and 3.2 years experience with Informatica MDM tool and 5.3 years with Informatica ETL tool.
• Extensive experience in Installation and Configuration of Informatica MDM Hub, Cleanse and Match Server
• High exposure on MDM Hub configurations - Data modeling for System Sources, Data Mappings from landing table to staging tables, setting data validation configuration, Match and Merge rules, Hierarchy Manager.
• Expert in Creating Landing, Staging and Base Object Tables and defining Foreign Key relationships, Lookups in the Hub.
• High developing experience in Mappings Data from Landing to Staging and use cleanse functions.
• Good work exposure on Hierarchy Manager to develop to Hierarchies as per the business needs.
• Creating IDD application as per the business needs by creating the subject area and subject area groups.
• Developed Put and Display packages for both Hierarchy Manager and IDD Application.
• Excellent knowledge in configuring the Match and Merge Rules in the MDM Hub by defining properties for Fuzzy and Exact match, creating Path components, Columns and Match Rule Sets.
• Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes
• Good hands on experience on publishing Data by configuring Message Queues to notify external applications on data change in MDM Hub Base Objects
• Data Quality and Data integration in real-time using SIF API’s
• Skillful in developing Web Service by using SIF APIs to get registered Operational Store (ORS).
• Practical experience in using SIF APIs such as Get, SearchQuery, CleansePut, SearchMatch, Merge and Unmerge to develop complex application to communicate with Hub Server and process the data from Base Object.
• Good knowledge in Transaction Management in SIF Environment.
• Data Validation and Data cleaning using User Exits.
• Participated in requirement gathering and preparation of High level and Low level Designs throughout the Software Development Life Cycle. Very good in understanding the MDM requirements from the business in achieving the BVT (Best Version of Truth) Record and publish to the downstream applications.
• Expertise in implementing Service Oriented Architectures (SOA) with JAX-WS - Web Service.
• Strong database experience in Oracle 10g/11g, DB2, with good programming skill in SQL and PL/SQL Technologies.
• Extensive experience on Weblogic with MDM Hub 9.7, WebSphere 6.0+ and RAD8.0, Eclipse, XML Spy, SOAPUI Tool.
• Worked extensively version control using RTC (Rational tool), SVN, CVS, VSS (Visual Source Safe), MKS Integrity client, Archiva along with defect tracking tool such as Polarion, CISM, JIRA
• Excellent knowledge on J2EE design patterns such as Singleton Design Pattern, Factory Design Pattern, Front Controller Design Pattern, N-Tier Architecture, MVC Architecture

TECHNICAL SKILLS:

Tools: Informatica MDM Hub 9.5/9.7/10.1 , Informatica power center 8.x/9.x.

Programming Methodologies: Agile Methodology, Water fall Software development methodology, Object Oriented Analysis and Design (OOAD), Unified Modeling Language (UML).

Product Platforms: Informatica MDM, WebSphere 6.0+, JBoss, Tomcat, Weblogic

Language/Technologies: Services Integration Framework (SIF) APIs, Web Services, WSDL, XML, XSD, Core Java, JSP, Servlets, J2EE, EJB, SOAP, Struts

GUI Tools: MDM Hub 9.5/9.7, RAD 7.0/7.5/8.0, Eclipse, SoapUI Tool

Configuration Tools: RTC, CVS, SVN, MKS Integrity client

Defect Tracking Tools: Polarion, CISM, JIRA, RTC (Rational Team Concert)

Toad, Oracle10g/11g, DB2, MS: Access

Microsoft Office: MS. word, MS. Excel, MS. PowerPoint, MS. Access, MS. Outlook

EXPERIENCE:

Confidential

MDM Developer

Responsibilities:

• Involved in gathering business requirements from the business users in understanding the new enhancement changes such Populating GPM ID for each record
• Design and implementation of Post Landing User Exit for updating landing table with GPM IDs, Post Stage User Exits for achieving online unmerge and deferred unmerges
• Configure Foreign Key Relationships among the Base Objects and define the lookups for the staging tables
• Configure Informatica Data Services to populated data in IDD using MDM and ODS database. IDS Services also available for custom applications
• Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes. Batch groups are created and parallelism is achieved by configured table execution sequentially.
• Provide solution approach for fixing online unmerge and deferred unmerge.
• Knowledge transition to business team about new functionality in Informatica MDM 10 such as smart search, composite services and composite object, MDM migration from MDM 9.7 to MDM 10
• Fix issue of child unmerge using MDM9.7.1 HF4 Get, SearchQuery, Put, CleansePut, SearchMatch etc SIF APIs to develop complex application to communicate with Hub Server and process the data from Base Object.

Environment: Informatica MDM 9.7, Services Integration Framework (SIF) APIs, JAX-WS Web Services, Log4j, JDBC, WSDL, SOAPUI Tool, DB2, Windows 7, Weblogic, Informatica Multidomain MDM 9.7, DB2, SQL Developer, Eclipse

Confidential, Columbus, IN

MDM Developer

Responsibilities:

• Involved in gathering business requirements from the business users in understanding the MDM SIF Web Services needs and user exits
• Configured different Source Systems such as ALARS, LKP, CITA of RMVM System in MDM Hub, Configured MDM tables in the following sequence: Landing Tables, Staging Tables, Base Objects.
• Configured the Foreign Key Relationships among the Base Objects and define the lookups for the staging tables
• Worked closely with RMVM Business team in identifying match columns and setting Match Rules (Party Org and Party Person)
• Involved in process of identifying and configuring the Match paths, Match Columns and Match rules for Exact and Fuzzy the Match and Merge Process.
• Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes
• Develop MDM SIF web services for real time out bound operations from internal and the external applications
• Designed and implemented User Exits for Validation such CITA date and active indicator validation etc, Back End Processing of Data and Error Handling.
• Used SIF APIs such as Get, SearchQuery, CleansePut, SearchMatch, Merge to develop complex application to communicate with Hub Server and process the data from Base Object.
• Worked closely with Informatica support to solve various defects and got it resolved. Proxy error during communication with MDM hub, 9.7.1 HF3 issues, consolidation indicator 1 issues.
• Worked with other supporting teams such as Legacy systems to verify a record created or updated in database is reflected in all downstream systems (Update Address case)
• Custom implementation of Address doctor in SIF Web Services using MDM Hub Address doctor.

Environment: Services Integration Framework (SIF) APIs, JAX-WS Web Services, Log4j, JNDI, JDBC, SOAP1.1, WSDL, SOAPUI Tool, CVS, XML 1.0, XSD, Oracle 11g, Windows 7, Weblogic. Informatica Multi-domain MDM 9.7, Oracle 11g, SQL Developer, Eclipse, XML Spy.

Confidential, Austin, TX

MDM Developer

Responsibilities:

• Involved in gathering business requirements from the business users in understanding the new enhancement changes such Use of Google API for Geocoding calculation
• Design and implementation of Post Landing User Exit for providing sleep functionality after each record processing due business limitation on number records per second processing.
• Configured the new BO, Staging and Landing Table as per business requirement
• Configure Foreign Key Relationships among the Base Objects and define the lookups for the staging tables
• Worked closely with Power Center team in order to implement sleep functionality for processing records.
• Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes
• Provide solution approach for Hard Delete Detection (HDD), providing knowledge transition for Data Steward for new functionality in Informatica MDM 10.
• Develop prototype MDM SIF web services for real time out bound operations from internal and the external applications such as Netezza.
• Used SIF APIs such as Get, SearchQuery, CleansePut, SearchMatch, Merge to develop complex application to communicate with Hub Server and process the data from Base Object.
• Worked closely with Informatica support to solve various defects and got it resolved for Geocoding calculation issues

Environment: Services Integration Framework (SIF) APIs, JAX-WS Web Services, Log4j, JDBC, WSDL, SOAPUI Tool, Oracle 11g, Windows 7, Weblogic. Informatica Multi domain MDM 9.7, Oracle 11g, SQL Developer, Eclipse

Confidential, Miami, FL

MDM Developer

Responsibilities:

• Involved in gathering business requirements from the business users in understanding and fixing IE11 redemption.
• Configure new Landing, Staging and BO Tables as per schema design changes
• Define and Configure Relationships and Lookups
• Configure Match Path, Match Columns and Create Match Rules and other match process related properties as per business requirement
• Run the Stage, Load, Tokenization, Match and Merge job for consolidation of records
• Create new and update existing Batch Groups for new enhancements
• Design and implementation of SOAP Web Service to provide data from Informatica MDM to calling application 0such as APIGEE.
• Provided detailed view about the new changes in Informatica MDM Hub 10 and Informatica Data Director
• Updated existing Packages and Queries as per changes request for Custom application enhancement such adding new search functionality to HCP Search application
• Prepare Requirement, Interface Design and Detailed Design document, also provided Test Case documents
• Deploy and Test application in Development, QA and Production Environment
• Knowledge sharing for Technical things such as Java, JavaScript, Weblogic Administration, Power Center Tasks etc.
• Fix the match rule changes related issues with Informatica Support team

Environment: Informatica MDM 9.5, Services Integration Framework (SIF) APIs, JAX-WS Web Services, Log4j, JDBC, WSDL, SOAPUI Tool, Oracle 10g, Windows 7, Java Script, Weblogic.

Confidential, Pittsburgh, PA

ETL/Informatica Developer

Responsibilities:

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Designed ETL specification documents for all the projects.
• Created Tables, Keys (Unique and Primary) and Indexes in the SQL server.
• Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Maintained source and Confidential mappings, transformation logic and processes to reflect the changing business environment over time.
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
• Extensively used the Add Currently Processed Flat File Name port to load the flat file name and to load contract number coming from flat file name into Confidential .
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Confidential .
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in Unit, Integration, System, and Performance testing levels.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Migrated the code into QA (Testing) and supported QA team and UAT (User).
• Created detailed Unit Test Document with all possible Test cases/Scripts.
• Conducted code reviews developed by my team mates before moving the code into QA.
• Provided support to develop the entire warehouse architecture and plan the ETL process.
• Modified existing mappings for enhancements of new business requirements.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Involved in production support.
• Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.

Environment: Informatica Power Center 8.6, Oracle 10g, SQLServer2008, IBM I Series (DB2), MS Access, Windows XP, Toad, Tidal, Cognos 8.4.1., SQL developer.

Confidential

Informatica Developer

Responsibilities:

• Actively Participated in collecting user requirements.
• Involved in drafting Software Requirement Specification for the project.
• Developed High Level Technical Design specification and Low-level Design based on business requirements.
• Drove the development of the logical and physical data models, ETL programs/scripts, metadata definitions, schedules, work processes, and maintenance procedures
• Prepared database DDL scripts for create, delete, alter table.
• Created ETL specifications describing the mapping logic for developers.
• Identified bottlenecks in source, Confidential , mapping, session and resolved them by implementing better logic and/or database object/query optimization.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volumes of data.
• Monitoring Production system, performed complex defect fixes in various environments like UAT, SIT etc. to ensure the proper delivery of the developed mapping into the production environment.
• Oversaw the design of the data and technical architecture for the data warehouse.
• Evaluate the Change Data Design, including slowly changing dimensions and Operational Data Store Design.
• Prepared time estimates and tracked each task against the estimated task and assisted in keeping project delivery deadline.
• Document all ETL related work per company's methodology.
• Worked with the testers closely in determining both medium and high severity defects, and also fixed the defects before moving into production.
• Worked along with UNIX team for writing UNIX shell scripts to customize server job schedules.
• Co-ordinated with Off-Shore team in .
• Documented the process for maintenance of the project and for production support.
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.

Environment: Informatica Power Center7.x, Oracle 10g, Pl/Sql , Visio, Erwin, Windows, UNIX Shell Scripts, AIX.

Confidential

ETL/Informatica Developer

Responsibilities:

• Responsible for designing and developing of mappings, mapplets, sessions and work flows for load the data from source to Confidential database using Informatica Power Center and tuned mappings for improving performance.
• Performed Informatica Admin role by creating new repositories, users and groups.
• Involved in ETL process from development to testing and production environments.
• Extracted date from various sources like Flat files, Oracle and loaded it into Confidential systems using Informatica 7.x.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.
• Used Informatica Power Center Workflow Manager to create sessions, batches to run with the logic embedded in the mappings.
• Tuned mappings and SQL queries for better performance and efficiency.
• Performed Unit testing and validated the data.
• Created & Ran shell scripts in UNIX environment.
• Created and ran the Workflows using Workflow manager in Informatica Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
• Created tables and partitions in database Oracle.

Environment: Power Center 7.x, Oracle, SQL developer, MS Access, Windows XP