Summary:

• Over 11 year's experience in IT Industry with 4 full lifecycle data warehousing projects using Informatica.
• 11 year's work experience in Oracle 11g/10g/9i, SQL, PL/SQL, SQL Loader, extensive use of Stored Procedures, Functions, Triggers, Views, Materialized Views, Database Links, and in using Export/Import Utilities in the data warehousing projects
• Strong communicating skills in interacting with business partners to identify information reports.
• Certified as Informatica Developer by Informatica Inc.
• Well versed in administrative, development aspects of Informatica MDM 9.5, Informatica MDM Hub 9.5, IDD Developer 9.5 tool, Power Center, Power exchange and B2B exchange.
• Expert in development of cleanse functions and message handling using Informatica MDM Hub 9.5.
• IBM Initiate 9.7 developer in the domain of Health Care Industry for the Albany, State of New York
• Well versed in exposing stored procedures as web services in Informatica for data warehousing projects
• Well versed in implementation of e commerce tools like IBM MQ Series, MSMQ Series and JMS Series in Informatica for data warehousing projects
• Well versed with use of Power Exchange Informatica Module for VSAM Files and CDC for oracle source used in data warehousing projects.
• Strong in analytical and conceptual skills for database design and development using Oracle11g /10g/9i/and best in utilization of six years experience in generation of T-SQL scripts using MS SQL Server2008/2005/2000/7.0/6.5/6.0 used in datawarehousing projects
• Strong in Unix Programming used in data warehousing projects
• Strong in developing data models including Logical, Physical, Conceptual and additionally dimensional modeling using star schema for data warehousing projects.
• Strong knowledge of TeraData RDBMS Architecture, Applications and Tools Utilities.
• Extensively used TeraData utilities SQL Assistant, FastLoad Fload , MultiLoad MLoad , BTEQ scripting, FastExport, OleLoad and Queryman, TeraData PMON for data warehousing projects.

Technical Summary:

Professional Experience

Confidential

Informatica MDM 9.5 IDD Developer

Responsibilities

• Interacted with the client to understand the business requirements in particular with MDM requirements for Address, Address Units, Company site and Other Party Site
• Developing validation, cleanse functions and message bundles and testing user exits developed by user exit developers for Address, Address Unit, Company site and Other Party Site MDM Hub 9.5 and MDM IDD 9.5 Development tool
• Solid understanding various data warehouse concepts like dimension and fact tables, Star and Snow flake schema, reference tables, fact less fact tables, bridge tables
• Solid understanding of data modeling like primary, foreign ,surrogate keys and various constraints and efficient in use of Ervin Modeling Tool
• Hands on experience in writing technical documents like creation of migration documents, source to target matrix documents, volumetric documents, and Visio documents if needed by the business team to explain the flow
• Developed and did extensive testing of mappings, source to target comparison of number of rows, data quality issues, type II issues, audit column issues using Informatica 9.1 and other databases like Oracle 11g and SQLServer2005 to migrate the data from data sources to Data Warehouse.
• Experience in working with different types of sources like Oracle, Flat Files, dynamic XML files, DB2 and SQL Server.
• Well versed with add search and matching applications to identity data stored in databases and Data Warehouses.
• Well versed Informatica MDM 9.5 stored procedures for match and merging in the stage tables.
• Developed mappings using extensively transformations like Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Generator, XML Parser, JMS, Source Qualifier and Stored procedure transformations.

Environnent: Informatica9.5, Informatica MDM 9.5 Hotfix5, MDM Hub Console 9.5, Informatica Data Director IDD 9.5, Oracle 11g, Unix Environment

Confidential

Informatica Integration Specialistt

Responsibilities

• Interacted with the client to understand the business requirements in particular with MDM requirements from the various sources.
• Solid understanding various data warehouse concepts like dimension and fact tables, Star and Snow flake schema, reference tables, fact less fact tables, bridge tables
• Solid understanding of data modeling like primary, foreign ,surrogate keys and various constraints and efficient in use of Ervin Modeling Tool
• Hands on experience in writing technical documents like creation of migration documents, source to target matrix documents, volumetric documents, and Visio documents if needed by the business team to explain the flow
• Developed and did extensive testing of mappings, source to target comparison of number of rows, data quality issues, type II issues, audit column issues using Informatica 9.1 and other databases like Oracle 11g and SQLServer2005 to migrate the data from data sources to Data Warehouse.
• Experience in working with different types of sources like Oracle, Flat Files, dynamic XML files, DB2 and SQL Server.
• Well versed with add search and matching applications to identity data stored in databases and Data Warehouses.
• Well versed Informatica MDM 9.1 stored procedures for match and merging in the stage tables.
• Developed mappings using extensively transformations like Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Generator, XML Parser, JMS, Source Qualifier and Stored procedure transformations.

Environnent: Informatica9.1, Informatica MDM 9.1, MDM Hub Console 9.1, Informatica Data Director IDD 9.1, Population Override Manager 9.1, Oracle 11g, Unix Environment

Confidential

Informatica Integration Specialist

Responsibilities

• Daily monitoring for more than eighty production jobs related to General Ledger, Consolidation and others aspects of accounting, SAP HR, SAP MM, SAP FM etc.
• Maintenance of Operational Data Store jobs, raising issues in Quality Center.
• Correction of mappings based on testing results and scenarios.
• Implementation of well versed in custom CDC like based on the maximum of created date or modified date
• Implementing slowly changing dimensions Type II for those columns which are critical and tracking is a requirement using existing mapplets.
• Well versed in PPDM data model,concepts like zonemaps,snippets,FPGA
• Filled out MDM details for several work flows and sessions
• Used Putty for unix file navigation
• Developed and designed twenty tables for the ODS database
• Well versed in SAPHR extractions, generation of Transports, Migration Docs.

Environnent: Informatica9.1, Putty, Tidal Enterprise Scheduler version 11, Sqlserver2008, Oracle 11g, Unix Environment

Confidential

Informatica IDQ System Specialist/Administrator

Responsibilities:

• Achieved the target of implementing the IDQ plans within four of five months allotted to the project.
• Contacted and discussed Informatica customer support team to buy the Identity Match option module.
• Dealt with the Informatica Data Quality license options based on processors, standalone or enterprise.
• Used Putty for unix file navigation
• Loaded 2 million Party table data using 10,000 records slots also customized IDQ mapplet validation for the standardizing address and de-duplication efforts in dev and test environments.
• Implemented IDQ components such as Search Replace, Merge, Rule Based Analyzer and scripting in standardizing plans.
• Wrote several BTEQ scripts and maintained several scripts.
• Configured the IDQ configuration file to make it read the ODS database.
• Generated analyzing plans for each column in table especially for full name columns. For example no of spaces between the last name and first name.
• Generated match plans, imported into the designer and used association, consolidation transformations in the designer to consolidate the data flow.

Environment: Informatica Power Center 9.0, B TEQ Scripts, Teradata,Windows Platform, Informatica Data Quality 9.0, Workflow Designer, Workflow Manager, MS-SQL Server 2008, Oracle 11g,PL/SQL,Putty

Confidential

Informatica ETL Developer/System Specialist

Responsibilities:

• Actively implemented ETL Architecture's initiatives including tweaking the existing logical model to include the new business requirements, mapping naming standards, estimating the number of mappings, merging the mappings wherever possible to minimize the maintenance and optimize the ETL system.
• Expert in ETL system loading and maintenance.
• Maintained the audit requirements of the client to implement new passwords for database for every three months, including created, updated active, effective dates, and extraction flags for the required attributes in the tables like the history maintaining tables.
• Heavily involved in the sharing experience to the new project team members including the architecture, database design issues, ETL environments, mapping and workflow logics.
• Written Korn Shell Scripts as per the needs in controlling mapping interface dependencies.
• Involved in the OBIEE Reporting System.
• Well versed in the LDAP and Active Directory Technologies
• Developed architecture deliverables including ETL weekly, mapping specifications, source-target matrix, unit cases, migration, load statistics, validation reports.
• Identified different source systems based on the datamart requirements and requesting access via business sponsors and project managers.
• Created approximately twelve T-SQL scripts using MS SQL Server 2005 for answering the business analyst questions regarding the business.
• Reviewed performance issues in the datamart like analyzing and optimizing query by involving the DBA's for the SQL override lookups.
• Modified /Created parameter files in development, test and production environments.
• Reviewed performance issues in the datamart like analyzing query plans by involving the DBA's for the SQL- override lookups.
• Used putty tool for navigation of unix files.
• Was responsible for performance tuning of PL/SQL Packages, procedures, Cursors and Informatica Mappings.
• Developed and designed twenty tables for the ODS database
• Developecd complex sql to test the data.
• Provided production support for Informatica daily loading process using Informatica 8.6

Environment: Informatica Power Center 8.6.1, UNIX Platform,Workflow Designer, Workflow Manager, Oracle 11g, MS-SQL Server 2005, PL/SQL, Datawarehouse Aggregates, SharePoint.Putty

Confidential

Informatica ETL Developer/System Specialist

Responsibilities:

• Actively implemented ETL Architecture's initiatives like mapping naming standards, estimating the number of mappings, merging the mappings wherever possible to minimize the maintenance and optimize the ETL system.
• Loaded 113 million transaction data and aggregation reports using six-month slots while taking care of index drops and creations as per the need of writing or reading of the data.
• Bounced the Informatica servers as per the need.
• Expert in system loading and maintenance.
• Put jobs on-hold and released the jobs by whenever there were upgrades or patches needs to be applied.
• Maintained the audit requirements of the client to implement new passwords for database for every three months. This was achieved by querying the repository tables for the information on which databases, the relational connection objects are pointing.
• Implemented web services and treated to capture various SOAP faults, white spaces, resolved URI's,proficient in bindings, resolving issues with 'any' datatype.
• Written Korn Shell Scripts as per the needs in controlling mapping interface dependencies.
• Well versed in the LDAP and Active Directory Technologies
• Developed architecture deliverables including ETL weekly, mapping specifications, source-target matrix, unit cases, migration, load statistics, validation reports.
• Identify different source systems based on the datamart requirements and requesting access via business sponsors and project managers.
• Used data transformation studio for parsing unstructured pdf data and pushing the data to flat file.
• Created approximately twelve T-SQL scripts using MS SQL Server 2005 for answering the business analyst questions regarding the business.
• Reviewed performance issues in the datamart like analyzing and optimizing query by involving the DBA's for the SQL override lookups.
• Modified /Created parameter files in development, test and production environments.
• Reviewed performance issues in the datamart like analyzing query plans by involving the DBA's for the SQL- override lookups.
• Was responsible for performance tuning of PL/SQL Packages, procedures, Cursors and Informatica Mappings.
• Developecd complex sql to test the data.
• Provided production support for Informatica daily loading process using Informatica 8.6

Environment: Informatica Power Center 8.6.1, Workflow Designer, Workflow Manager, Oracle 10g, MS-SQL Server 2005, PL/SQL,JCL