PROFESSIONAL SUMMARY:

• Over 8 years of IT experience in Software Design, Development, Analysis, Testing and Implementation of business applications for Insurance, Manufacturing, Pharmaceutical and Banking verticals.
• Defining and configuring landing tables, staging tables, base objects, hierarchies, foreign - key relationships, lookups, query groups, queries/custom queries and packages
• Implemented Hierarchy Manager Module in addition to Match/Merge/Unmerge to depict various hierarchies
• Helping business to understand the Match rules configuration and decide the trust factor and Configure match/merge rules
• Addressing issues of master data definition, metadata acquisition and data migration including data profiling, validation, clean-up and remediation, and source to target mapping
• Data standardization of addresses using Address Doctor, Informatica Data Quality and Data integration in real-time using SIF API’s.
• Performed cleansing and mapped business requirements to available features in IDD
• Implementing IDD applications to maintain/manage data, access relationship hierarchies and configured task management to route tasks to the Data stewards
• Configuring charts on the dashboard according to business requirements in IDD and user exits in IDD for selective validation alert pop ups
• Configured Message Queues and Message trigger setups.
• Proficient with Informatica Data Quality (IDQ) for cleanup and massaging at staging area.
• Designed and Developed IDQ mappings for address validation / cleansing, doctor master data matching, data conversion, exception handling, and report exception data.
• Implemented functional requirements using Parser, Match, Expression, Keygen, Decision etc.. Transformations
• Proficient in System Study, Data Migration, Data integration, Data profiling, Data Cleansing / Data Scrubbing and Data quality
• Experience in creation of ETL Mappings and Transformations using Informatica Power Center to move data from multiple sources into target area using complex transformations like Expressions, Routers, Lookups, ERP Source Qualifiers, Aggregators, Filters, Joiners
• Expertise in the development of integration mappings such as Type I, Type II, and Type III Slowly Changing Dimensions and implementing incremental loads.
• Excellent with PL/SQL Stored Procedures, Packages, Database Triggers
• Experience with Relational and Non-Relational databases i.e. Oracle 11g/11i/10g/9i, Teradata13.0, SQL Server, DB2, and flat files.
• Excellent communication and interpersonal skills and an attitude to learn the new cutting edge technologies.
• Ability to quickly analyze and come-up with an efficient industry standard solution for a given problem

TECHNICAL SKILLS:

EIM Tools: Informatica MDM Multi: domain Edition, IDD, SIF, IDQ 8.x/9.x

Databases: Oracle 8.x/9.x/10g/11g, Teradata 13.0, DB2, My SQL 5.0/4.1, MS-Access

Database Tools: TOAD, SQL*PLUS, ASE ISQL

ETL Tools: Informatica Power Center 8.x/9.x

Data Modeling: MS Visio 2008

Programming Skills: JAVA, SQL, PL/SQL, HTML, UNIX Scripting

Environment: Windows 2000/ NT/XP/Win7, Sun Solaris, Unix, Windows SERVER 2003/2005

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Informatica MDM Consultant

Responsibilities:

• Performed Business Analysis and Requirement gathering by working closely with end users
• Configured Informatica Data Director (IDD) in reference to the Data Governance of users, IT Managers & Data Stewards.
• Created Base objects, staging tables, landing tables and defined foreign key relationships among the base objects.
• Establishing relation between bases objects
• Look ups configuration on stage tables and created mappings between Landing staging tables
• Worked closely with the Business in gathering the Match rules and created the Match rule document
• Defined the MDM Development Methodology and performed Match and Merge Rules after a detailed analysis of source data.
• Created Match Paths, Match Columns for Match and Merge Process.
• Defined Exact and Fuzzy matching rules.
• Trust and validation rules set up on base objects
• Performed Data Steward Activities like manual Merge/Unmerge and updating data.
• Worked on Hierarchy manager for hierarchical relationships between design objects using entities and hierarchies
• Created Queries and packages in MDM Hub for displaying/updating the data.
• Configuring Message Queues and Real time integration using SIF API’s.
• Address standardization by integrating with Address doctor
• Adding Custom functionalities to IDD
• Define Subject Areas and Subject areas child
• Implemented real time batch processing
• Used Metadata manager for validation, promotion, importing and exporting the ORS repositories to different environments.
• Generated score cards
• Designed and Developed IDQ mappings for address validation / cleansing, doctor master data matching, data conversion, exception handling, and report exception data.
• Configuring Message Queues and Real time integration using SIF API’s.
• Implemented functional requirements using Parser, Match, Expression, Keygen, Decision etc.. Transformations.
• Implemented functionality in IDQ mappings to de-duplicating data sets using Jaro Distance Algorithm as per functional requirements
• Provided status reporting to the Higher Management and partnered withTesting, Business Information and Configuration Management/Support teams to ensure quality implementations and the rollout of standardized and supportable code.
• Helped testing team for creating test cases and platform validation
• Worked with log files to identify and rectify coding errors in process data-flow

Environment: Informatica Multi Domain MDM 9.7, Informatica Data Director (IDD), IDQ 9.1, Oracle 11g, TOAD, JBoss5.1

Confidential, Newark, NJ

Informatica MDM Developer

• Successfully completed Customer and Product centric Master Data Management initiatives using Informatica Master data management product
• Involved in discussions with the Data Architect and Solution Architect in defining and changing the data model
• Created landing tables, base tables, staging tables according to the data model and number of source systems
• Defined the foreign key relationships among the base objects and defined look ups on the staging tables and packages, query groups and queries/custom queries
• Implemented real-time integration with MDM HUB using real-time batch processing for business data coming from four source systems.
• Conducted brain storming sessions with business users to understand matching requirements and prepared high level document
• Analyzed and profiled the data and came with up the initial match rules and gone through several iterations for tuning matches.
• Designed and defined best implementation and deployment practices for Informatica Data director implementation within services organization.
• Develop standards, guidelines, processes, and expertise to consistently address strategic data issues such as data quality, cleansing, standards, and integration by using Address Doctor cleanse adapter.
• Used metadata manager for importing, exporting, validating the data for transforming the schema from development environment to testing environment.
• Did extensive data profiling techniques such as Multi Object, Join Analysis, Comparative Analysis using Data Analyst and Developer.
• Achieved data standardization using transformations like Parser, Match, Merge, and Expression along with business rules and custom developed data quality rules / functions.
• Designed and developed mappings for Global Address Cleaning which is critical and maintaining address quality for report accuracies
• Profiled Data coming from different database systems like Oracle, XML, IBM Mainframe Flat files, DB2.
• Informatica core components like Designer, workflow Manger, Workflow Monitor were used.
• Helped testing team for creating test cases and platform validation
• Worked with log files to identify and rectify coding errors in process data-flow

Environment: Informaica MDM 9.5, IDD, IDQ 8.6, Oracle 11g/10g, Toad, JBoss 5.1.0, Windows server 2008, Unix

Confidential, Jersey City, NJ

Informatica Developer

Responsibilities:

• Responsible for design and implementation needed for loading and updating the warehouse.
• Responsible for loading data from source systems like sql server, Flat files into Oracle tables using various transformation - Expression, Lookup, Source Qualifier, Update Strategy etc.
• Applied business and application knowledge to design the data loads for consistency and integrity.
• Worked with production load standards and error handing.
• Assisted in performance tuning by running test sessions.
• Created and facilitated presentations and demonstrations for Informatica.
• Scheduled Informatica workflows using Shell Scripts. Created Tasks, Workflows and Worklets using Workflow Manager.
• Created the transformation routines to transform and load the data. Tuned Mappings and Workflows for better performance.
• Fine-tuned Transformations and mappings for better performance.
• Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.
• Worked with analysts and data source systems experts to map requirements to ETL code.
• Created the transformation routines to transform and load the data. Developed processes for automation of loading data using parameter driven sessions for batch schedule processes, verification and re-conciliation of data stored in several different source systems.
• Experience with Teradata as the target, worked with BTEQ, FastLoad and MultiLoad
• Tuning and performance improvement of the jobs in Informatica. Translated business requirements to Informatica Mappings. Involved in Unit testing of mappings.
• Designed and documented validation rules, error handling routines and testing strategy for the mappings

Environment: Informatica Power Center 9.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Oracle 10g, Teradata 13.0, UNIX Shell Scripting, Toad, SQL plus, PL/SQL.

Confidential, Los Angeles, CA

ETL Developer

Responsibilities:

• Understand the functional requirement.
• Create mappings/sessions/workflows as per the design.
• ETL Tuning - SQL, Stored Procedures, Informatica Mappings to meet the SLA's.
• Created Informatica mappings using Source Qualifier, Expression, Lookup (connected and unconnected), Aggregate, Update Strategy, Joiner, Normalizer, XML transformations and Filter transformations.
• Developed Mapplets and Transformations.
• Identifying and Removing Bottlenecks in order to improve the performance of Mappings and Workflows
• Worked on creating the UNIX shell scripts, scheduling the sequence of jobs in batches.
• Create the Unit test documents and perform unit testing.
• SIT/UAT support.

Environment: Informatica Power Center 8.5.1, Oracle 10g, TOAD for Oracle, UNIX, Windows Server 2005

Confidential, Jersey City, NJ

SQL Developer

Responsibilities:

• Designed and developing Snow flake Schema and creating Fact Tables and Dimension Tables for the Warehouse and Data Marts and Business Intelligence Applications using MS Visio.
• Actively designed the database to fasten certain daily jobs and some stored procedure
• Involved in performance tuning of T-SQL queries and Stored Procedures
• Create new tables, views, indexes and user defined functions
• Complex formulas were used to show derived fields and to format the data based on specific conditions
• Worked in Data Modeling techniques
• Optimized query performance by creating indexes
• Perform daily database backup & restoration and monitor the performance of Database Server

Environment: SQL Server 2005, PL/SQL, SQL*Plus, SQL*Loader.