SUMMARY

• Having 7+ years of experiencefor the Development, Maintenance and Production support projects.
• Experienced in all aspects of SDLC including analysis, design, code, testing, and production support.
• Proficient in understanding business processes/requirements and translating them into technical requirements, design specifications and implement those requirements.
• Proficient in Data Modeling concepts usingErwin, Star Schema, Facts & Dimensiontables for Logical & Physical data modeling.
• MDM Hub configurations - Data modeling, Data Mappings, Data validation, Match and Merge rules, Confidential Manager, customizing/configuring Informatica Data Director.
• Defining and configuringlanding tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
• Experience in integrating/upgrading Address Doctor with Informatica Developer, Power Center and MDM.
• Played the role of MDM Admin partially.
• Experience integrating/installing the AVOS with MDM in windows environment.
• Experience in ActiveVOS workflows in MDM.
• ConfiguredInformatica Data Director (IDD)to meet Data Governance objectives.
• Configured JMS message Queues and message triggers.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server.
• Worked on integrating data from flat files like fixed width and delimited using Informatica.
• Used Informatica Designer Components - Source Analyzer, Transformation Developer, Mapplet and Mapping Designer.
• Worked extensively with complex mappings using multiple transformations likeSource Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected/Connected Lookups and Aggregators, Stored Procedures and Normalizer.
• Strong Experience in usingMapping Parameters and Variables, Session and workflow level parameter and variables.
• Strong Experience in developingSessions/tasks, workflows usingWorkflow ManagerTools-Task Developer, Workflow Designer.
• Experience in using the Informatica command line utilities likepmcmdto executeworkflowsin non-windows environments.
• Loaded the data from EDW to the SAP system via LSMW tool.
• Proficient inperformance tuningof Jobs. Strong in finding out the bottlenecks and fixing them using various tuning methods like session partitioning, reducing the lookup sizes, using persistent caches etc.
• Worked withStored Procedures, Cursors, Indexes and Functions.
• Experience inUNIX Shell Scripting, CRON, FTP, Connect Direct (CD)and file management in various UNIX environments.
• Good experience in using the defect tracking tools like BMC Remedy, JIRA, HP-Quality Center.
• Skilled in delivering quality deliverables and meeting project objectives in tight deadline.

PROFESSIONAL EXPERIENCE

Confidential, Albany, NY

Informatica MDM Developer

Responsibilities:

• Expertise in Address Doctor Integration with Power Center, Developer, MDM.
• Address Doctor Upgrade in Power Center and Developer.
• Configure AVOS with hub and made sure that default workflows are integrated.
• Experience configuring BE workflows with IDD.
• Installed MDM in the windows development environment.
• Expertise in handling Address Cleansing before populating the data into landing tables.
• Worked on ETL process for bringing in the data into MDM landing tables.
• Worked on profiling the data using Developer tool/Analyst Tool for identifying the data integrity from different sources.
• Most of the data is cleansed in Power Center/Developer before the data is placed in MDM landing tables.
• Based on the data quality analysis and discussion with stake holders the source data trusted scores are defined.
• Validation rules are developed based on the profiled data quality and data analysis.
• Came to conclusion on key fields after discussing with people in the knowledge of data.
• Defined Match rules in Match and Merge settings of the base tables by creating Match Path Components, Match Columns and Rule sets.
• Configured match rule set filters for meeting the different data scenarios.
• Performed match/merge and ran match rules to check the effectiveness of MDM on data and fine-tuned the match rules.
• Developed adhoc queries like Execute Batch Delete SOAP requests for deleting the specific data from the concerned underlying tables using.
• Developed Unmerge user exist for reprocessing the some of the records which are supposed to be processed differently.
• Closely worked with Data Steward Team for designing, documenting and configuring Informatica Data Director.
• Used ActiveVOS for configuring workflows like One step approval, merge and unmerge tasks.
• Configured static lookups, dynamic lookups, bulk uploads, extended search and Smart search in IDD.
• Configured JMS Message Queues and appropriate triggers for passing the data to the contributing systems.

Environment: Multi-Domain MDM 10.0, IDD, Oracle 11g, Oracle PL/SQL, Windows Application Server, ActiveVOS, Informatica PowerCenter 10.1,Informatica Developer, Address Doctor 5.1, PowerShell.

Confidential, Atlanta, GA

Informatica MDM Developer

Responsibilities:

• Produces detailed MDM design specifications consistent with the high-level MDM design specifications.
• Coordinated with ETL team for performing batch process to populate data from external source systems to landing tables in hub.
• Analyzed the source systems data for identifying integrity issues and incorporated the same in Systems and Trust.
• Configured Landing, staging tables, Base Objects.
• Design, document and configure the Informatica MDM Hub to support loading, cleansing.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Defined Match rules in Match and Merge settings of the base tables by creating Match Path Components, Match Columns and Rule sets.
• 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 on data and fine-tuned the match rules.
• Customized User Exists for deferent scenarios.
• Used Confidential tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles.
• Closely worked with Data Steward Team for designing, documenting and configuring Informatica Data Director.
• Used ActiveVOS for configuring workflows like One step approval, merge and unmerge.
• Used Repository Manager/Change List for migrating incremental as well as bulk the meta-data.

Environment: Multi-Domain MDM 9.7, IDD, Oracle 11g, Oracle PL/SQL, Windows Application Server, ActiveVOS.

Confidential

ETL Developer

Responsibilities:

• Implementing Slowly Changing Dimension (SCD type II) design for the Data Warehouse.
• Developing workflows with Worklets, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle and Flat files and loaded into Oracle, Vertica
• Developed Informatica Workflows and sessions for mappings using Workflow Manager.
• 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.
• Conducting weekly meetings with offshore team members.
• Driving the KT sessions for bringing up the team members up to speed.

Environment: Oracle 10g SQL/PLSQL, Toad, Oracle SQL Developer, Visio, Windows XP, Remedy Change Management, Control M, Unix Shell Scripting, Informatics, Business Objects, VPN, Putty, SVN, Erwin.

Confidential

Jr. Java Developer

Responsibilities:

• Involved in analyzing the client requirements and convert them into technical specifications.
• Worked in Analysis, Design and Coding for client development using J2EE stack and Eclipse platform.
• Involved in analyzing the requirements, modeling &, designing the features.
• Coding and maintaining Oracle packages, stored procedures and functions.
• Prepared technical design documents that include UseCase &, Sequence diagrams using Rational Rose.
• Involved in creating web-based java components like client Applets and client-side UI using JFC in Eclipse.
• Set up Data sources and queues set up in JBoss Application Server that is responsible for transferring data to other queue managers.
• Used Spring MVC to develop the application &, control the operation flows.
• Developed PL/SQL stored procedures to perform complex database operations.
• Designed and developed SQL queries in the application.
• Developed Design documents for various components identified in the system.
• Generated the Hibernate, XML and Java Mappings for the schemas.
• Extensively used J2EE, Servlets, JSP and XML.
• Generated the Hibernate, XML and Java Mappings for the schemas.
• Collaborated with offshore team to ensure the project HTML tasks are completed on time with accuracy.
• Used Subversion as the version control system.
• Transactional Data Analysis in MatLab.

Environment: Java/J2EE, JSP, EJB, Servlets, MVC, Hibernate, Applets, HTML, Oracle, JavaScript, JBOSS, XML, SQL, PL/SQL, Eclipse and MatLab.