SUMMARY:

• Over 10.8 years of professional experience in Analysis, Design, Development, Testing and Implementation of various Data Warehousing and Software Applications.
• Design & implement data quality & business rules usingPower center workflows, Mappings, Mapplets, Exception tables, ad - hoc reporting.
• Configured and maintained various components of the MDM Hub including the schema, landing and staging tables, configuring Base Objects, Look-ups, Hierarchies, Queries and Query groups.
• Improved data quality by Match analysis, analysis of the MDM system performance and tuning the performance by changing existing match rules and cleanse functions.
• Hands on experience with SIF API.
• Hands on experience in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups
• Worked on automation of Daily score cards associated based on MDM Match & Merge results.
• Worked Rematch solution to get BVT.
• Worked on SOA/Java Web Services development with SOAP/WSDL.
• Hands on experience working with SIF.
• Extensively involved in ETL Data warehousing using Informatica Power Center 7.x/8.x/9.x Designer tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor. Very strong in writing SQL Joins, Nested Queries, Unions, Multi-table joins.
• Experience in scheduling the batch jobs using workflow manager and UC4 scheduling tools.
• Worked with Dimensional Data warehouses in Star and Snowflake Schemas, created slowly changing dimensions (SCD) Type1/2/3 dimension mappings.
• Experience with Informatica MDM Hub configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, writing and customizing user exits, customizing/configuring Data Director.
• Experience with Informatica Data Quality (IDQ) for Data profiling, Cleansing and validation reports for data migration.
• Experience in working with JAVA and XML & WebServices
• Experienced in logical and physical data modeling of staging and warehouse environments using Data modeling tools like Erwin.
• Experience with different scheduling tools like Autosys, UC4 & IBM Tivoli Scheduler tools.
• Experience in Optimizing the Performance of SQL scripts and Oracle database/application tuning.
• Excellent in coding using SQL, PL/SQL, Procedures/Functions, Triggers and Packages.
• Developed Batch Jobs using UNIX Shell scripts to automate the process of loading, pushing and pulling data from different servers.
• Good experience in performing and supporting Unit testing, System Integration testing (SIT), UAT and production support for issues raised by application users.
• Used best practices on Process Sequence, reference table Data Quality Lifecycles, Naming Convention, and Version Control in Power Centre mapping.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Expertise involved ICM (Incentive Compensation Management) tool.
• Extensively involved in working on Callidus Suite (Informatica, Truecomp, BO/Actuate).
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, mappings and sessions. Hands on experience in optimizing SQL scripts and improving performance loading warehouse.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6, 9.1, 8.x, 7.x (Designer, Workflow Manager, Workflow Monitor, Informatica Master Data Management (MDM), Informatica IDQ, Repository Manager, Repository Server, Administration Console).

RDBMS: Oracle11g / 10g / 9i, SQL Server, DB2, Teradata.

Operating System: UNIX, Linux, Mac, Windows NT/2000/XP/7

Languages: SQL, SQL*PLUS, PL/SQL, XML, Core Java

Other Tools: MS-Office, Callidus Suite, Truecomp, QlickView, CA Workload Control Center, Clarity, Harvest, UC4

PROFESSIONAL EXPERIENCE:

Confidential

Sr MDM Developer

Responsibilities:

• Involved in extraction of Customer and its associated data from different source system and loading the MDM HUB.
• Worked on automation of Daily Score cards associated based MDM match & Merge Results.
• Worked on Re Matching solution using Informatica MDM
• Worked on SIF API using Informatca web services
• Worked with Address doctor and validation of customer address
• Worked on Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• Worked with and analyzed large amounts of data: facts, figures, and number crunching to identify and interpret patterns and trends, assess data quality and eliminate irrelevant data and finally draw data driven conclusions
• Develop, monitor, analyze and maintain data quality metrics and drive resolution of discrepancies
• Evolve data quality metrics as needed to provide insight into the data quality levels of key data elements, systems, and processes
• Perform ad hoc analyses and extract data from multiple source systems and the Customer Hub Master data
• Own the development and maintenance of ongoing metrics, audit reports, data analyses, dashboards, etc. to drive key business decisions.
• Collaborated with Data Governance, ETL, MDM and Data Quality teams to ensure compliance with standards
• Provided end to end solution of automation of daily Scorecards
• Extensive data analysis of the source data, landing, reject and staging tables, trust rules, survivorship rules, Match & Merge rules, Xref tables and Base object tables in Customer Hub.
• Worked with team, that was focused on capturing mainly changes in customer plans.
• Speeding up of work by using re-usable transformations and work-lets, for further lowering of errors and enhancing work flow performance. Developed schedules to automate the update process and Informatica Batches/Sessions.
• Created and Configured Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse using Informatica workflow Manager.
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, Mapping designer and Workflow Manager
• Organized data in order to capture the basic nature of the business environment, providing a stable view of the data associated with the core business processes.
• Monitored sessions that were scheduled, running, completed or failed
• To retrieve the data from various Tables and to test the database, wrote SQL Queries.
• Worked on Documentation to describe program development, logic, coding, testing, changes and corrections
• Participated in Enhancements meeting to distinguish between bugs and enhancements.

Environment: Informatica PowerCenter 9.6, IDQ 9.6,Informatica MDM 9.7, Windows, Oracle 10g, Flat Files, TOAD, SQL Developer, UNIX, MS Office, MS Visio, Java, Web Services, XML.

Confidential, Ridgefield, C

MDM Developer

Responsibilities:

• Analysis, involved in acquiring Requirements from Business Requirement Document (BRD), function/technical specification, development, deploying and testing by Business Analysts, UAT, TQA and Developers.
• Worked on Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• Configured and maintained various components of the MDM Hub including the schema, landing and staging tables, configuring Base Objects, Look-ups, Hierarchies, Queries and Query groups.
• Improved data quality by Match analysis, analysis of the MDM system performance and tuning the performance by changing existing match rules and cleanse functions.
• Hands on experience in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups
• Converted the business requirements into technical specifications for ETL process by populating the fact and dimension tables of data warehouse.
• Created and executed SQL scripts in oracle to test the data flow from OLTP systems to data warehouse.
• Designed & assisted Informatica ETL developer to create new Aggregate.
• Created Informatica mappings for initial load and daily updates.
• Developed several mappings (Source Qualifier, Lookup, Filter, Joiner, Aggregate, Sequence Generator, Expression, Lookup, Router, Normalizer, and Update Strategy) to load data from multiple sources to data warehouse.
• Created sessions, workflows and database connections using Informatica Workflow Manager.
• Worked with pre and post session SQL commands to drop and recreate the indexes on data warehouse using source qualifier transformation of Informatica Power center.
• Involved in troubleshooting the load failure cases, including database problems.
• Handled Full load and refresh load via staging tables in the ETL Layer.
• Involved in Design and Data Modeling using Star schema.
• Configured environments for full ETL and incremental data loads from OLTP to OLAP data sources using DAC and Informatica routines.

Environment: Informatica Power Center9.6, Informatica MDM, IDQ, Oracle, UNIX, Java, Web Services, Sybase Power Designer Global CRM, XML, Veeva CRM, Qlikview, Cognos, Windows XP, TOAD, MS Visio, Putty, Hortonworks.

Confidential

Senior Application Developer

Responsibilities:

• Extensively used Power Center to design multiple mappings with embedded business logic.
• Created Mapplet and used them in different Mappings.
• Provide Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mapping.
• Developed Complex mappings and workflows using Power Center designer and Workflow manager for loading data into Data warehouse from staging.
• Experience with building DataMart’s and data warehouses
• Developed and maintained custom PL/SQL packages and procedures for analysis of source system data and also for data validation
• Extensively involved in creating design documents for loading data into Data warehouse and worked with the data modeler to change/update the Data warehouse model when needed.
• Reporting based on Slowly Changing Dimension of SCD1 and SCD2.
• Responsible for Performance Tuning at the Source & Target level, Mapping Level and Session Level.

Environment: Informatica PowerCenter, DT/DX Designer, Callidus, Truecomp, Clarity, SCM Workbench, XML, Windows, CA Service Desk, Oracle 10g, Flat Files, TOAD, SQL Developer, SQL Server, VB .Net, UNIX, MS-Office, EDI Files, Business Objects, Actuate, Putty

Confidential

Application Developer

Responsibilities:

• Collaborated with Business Analysts and the DBA to gather requirements, business analysis and designing of data marts.
• Involved in Preparation if high level Design document for Data Integration
• Involved in Starting from requirement gathering to till production support activities.
• Prepared Micro Design documents for DI Interfaces.
• Prepared UTP documents for DI Interfaces.
• Developed reusable mapplets using mapplet designer.
• Created and executed sessions using Workflow Manager.
• Used Source Analyzer and Warehouse Designer to import the source and target database schemas, and the mapping designer to map source to the target.
• Understanding existing business model and customer requirements.
• Used Transformation Developer to create the Joiner, filters, Router, lookups, Expressions, Aggregation transformations, Update strategy, Stored Procedure Transformations used in mappings.
• Interaction with VF NZ directly and assisting them at the time of Go-Live.
• Transformations.
• Extensively used ETL to load data from wide range of source such as flat files (csv, fixed length), Oracle and XML to ORACLE.
• Extensively worked in the performance tuning of the mappings, ETL Procedures and processes.
• Developed re-usable transformations, mappings and mapplets confirming to the business rules. Used Debugger to test the mappings and fix the bugs.
• Performed Unit Testing on the developed Mappings.
• Supported QA Testing and Production Testing by identifying the bugs and also helped to resolve various Data issues.
• Involved in the Migration process from Development, Test and Production Environment
• Wrote stored procedures and triggers in Oracle 9i for managing consistency and referential integrity across data mart.
• Unix shell scripts are used for scheduling to automate the load process.
• Developed Reports for the clients using business objects.

Environment: Informatica PowerCenter 8.1, Sun Solaris 8,Oracle 9i,Callidus,Truecomp,Callidus, Windows XP, SQL, PL/SQL, Business Objects.

Confidential

Application Developer

Responsibilities:

• Created and executed sessions using Workflow Manager.
• Used Source Analyzer and Warehouse Designer to import the source and target database schemas, and the mapping designer to map source to the target.
• Understanding existing business model and customer requirements.
• Used Transformation Developer to create the Joiner, filters, Router, lookups, Expressions, Aggregation transformations, Update strategy, Stored Procedure Transformations used in mappings.
• Transformations.
• Developed re-usable transformations, mappings and mapplets confirming to the business rules. Used Debugger to test the mappings and fix the bugs.
• Performed Unit Testing on the developed Mappings.
• Supported QA Testing and Production Testing by identifying the bugs and also helped to resolve various Data issues.
• Involved in the Migration process from Development, Test and Production Environment
• Wrote stored procedures and triggers in Oracle 9i for managing consistency and referential integrity across data mart.
• Unix shell scripts are used for scheduling to automate the load process.
• Developed Reports for the clients using business objects.

Environment: Informatica PowerCenter 8.1, IBM AIX, Oracle 9i, Callidus, Truecomp, Callidus, Windows XP, SQL, PL/SQL, Business Objects.

Confidential

IT Consultant

Responsibilities:

• Understanding existing business model and customer requirements.
• Used Source Analyzer and Warehouse Designer to import the source and target database schemas, and the mapping designer to map source to the target
• Used Transformation Developer to create the Joiner, filters, Router, lookups, Expressions, Aggregation transformations, Update strategy, Stored Procedure Transformations used in mappings.
• Transformations.
• Developed re-usable transformations, mappings and mapplets confirming to the business rules. Used Debugger to test the mappings and fix the bugs.
• Performed Unit Testing on the developed Mappings.
• Supported QA Testing and Production Testing by identifying the bugs and also helped to resolve various Data issues.
• Involved in the Migration process from Development, Test and Production Environment.

Environment: Informatica PowerCenter 8.1, AIX, Oracle 9i, Windows XP, SQL, PL/SQL, Business Objects, Putty, SQL Developer, MS Office.