SUMMARY

• Around 10 years of strong data warehousing experience using InformaticaPowercenterwith extensive experience in designing the Tasks, Workflows, Mappings, Mapplets and scheduling the Workflows/sessions using Informatica Powercenter 10/9.6/9.5/9.1/8.6/8.1/7.1/6.2 , Power Mart 6.2/5.1/5.0. AndPower exchange/Power Connect.
• Around 7 Years of Strong experience on Designing, testing, deploying, and documenting the data quality procedures and their outputs in Data Quality and Data Analysis using withInformaticaIDQ/IDE 8.x/ 9.1/9.5/9.6/10
• Around 3 Years of Strong experience on Designing, testing, deploying, Building and documenting the Master data management procedures and Automated the procedures using with Informatica MDM 9.5/9.7/10
• Strong business understanding knowledge of Financial, Telecommunications, Pharmaceutical, Insurance, Publishing, Banking, Retail, Life science and inventory management projects.
• 5 years of experience in Cognos, Business Objects 6.1a/5.1.2/4.1, Web Intelligence v6/2.6/2.5, Broadcast Agent, Power Builder and Crystal Reports.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non - Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Around 6 Years of Strong experience on Address Validation transformation (Address Doctor) and Address validation Process
• 4 Years’ experience in Unix Shell Scripting.
• 8 years’ experience on various SQL Editors such as TOAD, PL/SQL, BTEQ, WinSQL and Query Analyzer and other utilities SQL*Plus, SQL*Loader.
• 6 years’ experience in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables) used in relational, dimensional and multidimensional modeling.
• Around 2 Years of Strong experience on Informatica metadata management and Metacenter for Metadata management and Business Glossary.
• Around 2 years of experience in Informatica Axon Data Governance Procedures, Configure, Upload, Document, Reports and Review.
• Extensive knowledge of data warehouse approaches - Top down (Inmon's approach) and Bottom up (Kimball's approach), methodologies- Star Schema, Snowflake.
• Extensive experience in creation of ETL Mappings and Transformations using InformaticaPowercenter to move data from multiple sources into target area using complex transformations like Expressions, Routers, Lookups, Source Qualifiers, Aggregators, Filters, Joiners.
• Experience in integration of data sources like Oracle, DB2, TeraData, COBOL, MQ, SQL Server, Flat Files.
• Expertise in Data cleansing, Stored procedures, Triggers and necessary test plans to ensure the successful execution of the data loading processes
• Hands-on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Experience in MOLAP/ROLAP implementations.
• Experience with Autosys and Control-M.
• Experience in working with Business Objects Universes&Query development.
• Knowledge in E-commerce and Web related tools such as HTML, JavaScript, Applets, Servlets, Java Server Pages, EJB and XML.
• Good team player with leadership abilities and excellent communication skills.

TECHNICAL SKILLS

Languages: C, C++, Java, COBOL, PERL, PL/SQL.

Databases: Oracle 11g/10g/9i/8i/8/7.x, Teradata, SQLServer 2005/2008/20012 , DB2, Netezza,MS Access, Sybase.

ETL/DQ/DG: Informatica Powercenter 10/9.5/9.1/8.6/7.1/6.2/5.1 , PowerExchange8.0, Informatica Data Quality (IDQ)/IDE 8.x/9.1/9.5/10, Informatica MDM hub 10/9.7, Oracle Warehouse Builder &SQL*Loader, Toad 7.6., Meta center, Dataflux, Alteryx, Axon

Reporting Tools: BusinessObjects6.5/5.1, OBIEE 10.1.3.4, Cognos 8/7/6.0/5.0, Crystal Reports, OracleReports2.5, PowerBuilder, Tableau

Design Tools: Erwin4.0/3.5, Oracle Designer / 2000, ER Studio

GUI: Developer/2000, Visual Basic

Internet Tools: HTML, JavaScript, VBScript, JSP, XML, ASP

Scheduling Tools: Autosys, Control-M, UC4

Other Tools: Quality Center, VSS and Test Director, Jeera

0S: Windows(NT,2000,2003, XP, Vista,7), Linux (RedHat,Fedora), UNIX (SunSolaris,Linux)

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee- Wi

Informatica IDQ Lead

Responsibilities:

• Analyzed the Data Quality project requirements, documents and process
• Identified data quality issues, anomalies, patterns, based on defined business rules and created metrics and scorecards by IDQ Profiling.
• Created POC for end to end data quality process and Presented to key business and data stewards.
• Collaborated with internal and externals stakeholders such as study team members, project managers, data stewards and data analysts.
• Involved BI Report generation process.
• Data profiling and extraction of insights from data, using exact matching, de-duplication, fuzzy logic, and other techniques to review data for accuracy.
• Extract and load business rule DQ metrics into data governance management data quality dashboards.
• Provided design documents for Data quality process.
• Suggested data quality reports and notifications to identify critical gaps for business process improvements.

Environment: Informatica Data Quality 10, Informatica Powercenter 10/9, DB2, SQL SERVER, Sybase, Netezza, Power BI, Autosys.

Confidential

Informatica IDQ Lead

Responsibilities:

• Applied the Informatica Data Quality (IDQ) Best practices in the Data quality rules implementation process.
• Analyzed the data based on requirements, wrote down the techno-functional documentations and developed complex mappings using Informatica Data Quality (IDQ) 10.1.1 Developer to remove the noises of data using Parser, Labeler, Standardization, Merge, Match, Case Conversion, Consolidation, Address validation(address doctor), Key Generator, Lookup, Decision etc Transformations and performed the unit testing for accuracy of data.
• Implemented DQ business rules in Informatica IDQ based on the approval of DQ rules.
• Contributed to the data governance office to drive the data quality business cycle and roadmap.
• Involved in Data Quality Architecture from end to end with business and data steward.
• Identified data quality issues, anomalies, patterns, based on defined business rules and created metrics and scorecards by IDQ Profiling.
• Pull the various sources data from Informatica big data quality developer/analyst.
• Collaborated with internal and externals stakeholders such as study team members, project managers, data stewards and data analysts.
• Extensively validated address records with Address validation transformation process(Address doctor) for getting suggestion list, parse, Interactive, country recognition, certified, batch and Address code lookup.
• Created POC for Informatica big data quality initial data quality implementation.
• Data profiling and extraction of insights from data, using exact matching, de-duplication, fuzzy logic, and other techniques to review data for accuracy.
• Extensively validated address records with Address validation transformation process(Address doctor) for getting suggestion list, parse, Interactive, country recognition, certified, batch and Address code lookup.
• Provided various demos of Informatica big data quality profiling results for sample records.
• Created Various reusable rules using with multiple mapplets in Informatica IDQ.
• Data quality business rules implementation, metric gathering, and dashboard reporting.
• Reported the exception records to the respective business users and Clarified their questions and also get the clarification in the process of creating exception records using with Informatica Data quality (IDQ).
• Extract and load business rule DQ metrics into data governance management data quality dashboards.
• Creating the Users, Roles and Permissions for the respected Id's in the Informatica IDQ Admin Console.
• Created various scorecard lineage files using with Informatica metadata manager and exported lineage reports to business..

Environment: Informatica Data Quality (IDQ)10, Informatica BDQ 10, Informatica Powercenter 9.6,, Informatica Metadata Manger, Oracle, Toad, Sql Server, Autosys.

Confidential - IL

Informatica MDM/IDQ Developer

Responsibilities:

• Identified and communicated potential quality issues in the way data is collected, stored, process or used.
• Applied the Informatica Data Quality (IDQ) Best practices in the Data quality rules implementation process.
• Informatica MDM Hub Configuration Development: Creating BO, Stage and Landing tables, setting up relationship, Match Path configuration as per data model, creating load mapping, cleanse function, HM setup-creating entity types, relationship base objects, relationship types, profiles, put and display Queries
• Analyzed the data based on requirements, wrote down the techno-functional documentations and developed complex mappings using Informatica Data Quality (IDQ) 10.1.1 Developer to remove the noises of data using Parser, Labeler, Standardization, Merge, Match, Case Conversion, Consolidation, Address validation(address doctor), Key Generator, Lookup, Decision etc Transformations and performed the unit testing for accuracy of data.
• Proficient in Informatica MDM Hub configurations like creating mappings to pull the data from Landing tables to MDM stage tables by cleansing the data using Graphical Functions and Cleanse Lists and applying the Trust, Match and Merge settings while loading the data to Base tables. Involved in Data Quality Architecture from end to end with business and data steward.
• Identified data quality issues, anomalies, patterns, based on defined business rules and created metrics and scorecards by IDQ Profiling.
• Collaborated with internal and externals stakeholders such as study team members, project managers, data stewards and data analysts.
• Implementedin Informatica Axon for the data landscape is an inventory which classified as business glossary, policies, data quality rules, processes, systems, interfaces, data sets and attributes.
• Profiled and Analyzed the all the source data for MDM process to understand the data
• Tuned IDQ Development process to push most of the process to database and removed unwanted ports and transformations.
• Executed of data validation and data cleansing activities in a hands-on way to ensure high quality and trustworthiness.
• Data profiling and extraction of insights from data, using exact matching, de-duplication, fuzzy logic, and other techniques to review data for accuracy.
• Successfully implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries for searching.
• Informatica MDM Hub Configuration Development: Creating BO, Stage and Landing tables, setting up relationship, Match Path configuration as per data model, creating load mapping, cleanse function, HM setup-creating entity types, relationship base objects, relationship types, profiles, put and display Queries
• Applied the business rules in Informatica data quality and separated the exception data based on the business conditions.
• Design and develop Informatica MDM data model and defining logical relationships between the objects.
• Extensively validated address records with Address validation transformation process(Address doctor) for getting suggestion list, parse, Interactive, country recognition, certified, batch and Address code lookup
• Configured the Informatica MDM match (Fuzzy/Exact and) & merge (Auto/Manual) strategy to remove duplicates and generate the best version of the golden record.
• Created Various reusable rules using with multiple mapplets in Informatica IDQ.
• Data quality business rules implementation, metric gathering, and dashboard reporting.
• Reported the exception records to the respective business users and Clarified their questions and also get the clarification in the process of creating exception records using with Informatica Data quality (IDQ).
• Extract and load business rule DQ metrics into data governance management data quality dashboards.
• Publishing Data using Message Queues to notify external applications on data change in MDM Hub Base Objects
• Involved in SIF integration to develop xml code for external applications to perform search match API calls against MDM Hub Data.
• Experience in creation of subject area groups, subject areas, subject area child and search queries for managing the Informatica MDM Hub data through IDD.
• Created various Mapplets, Reference tables, Profiles, Score cards for Product and Location data in Informatica data quality and analyst tools.
• Created Various data quality Profiles in Informatica Analyst using with Logical data objects in informatica data quality.
• Managed the Informatica Data quality (IDQ) and collaborated with MHE Data Owners, Operational Data Agents, Process Owners, Policy owners and Subject Matter Experts.
• Generated data quality reports and notifications to identify critical gaps for business process improvements.
• Created Landing, Staging, Base object, Match rules, Merged, Created golden records in Informatica Master Data Management (MDM)
• Maintain and provided quality assurance oversight of data landscape inventories.
• Scheduling Informatica Data quality jobs in Production using with third party scheduling tool.
• Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes in informatica mdm.
• Suggested various Data quality Strategies and Implemented best practices on entire process.
• Supported Inforamtica data quality production scheduled jobs run and escalated the report to respective business users.
• Developed Test Plans and written Test Cases to cover overall quality assurance testing.

Environment: Informatica MDM 10.2, Informatica Data Quality (IDQ/IDE) 10, Informatica Powercenter 10, Oracle, IDD, Toad, DB2, SQL SERVER, Toad, Netezza.

Confidential

Informatica IDQ Lead

Responsibilities:

• Identified and communicated potential quality issues in the way data is collected, stored, process or used.
• Applied the Informatica Data Quality (IDQ) Best practices in the Data quality rules implementation process.
• Analyzed the data based on requirements, wrote down the techno-functional documentations and developed complex mappings using Informatica Data Quality (IDQ) 10.1.1 Developer to remove the noises of data using Parser, Labeler, Standardization, Merge, Match, Case Conversion, Consolidation, Address validation(address doctor), Key Generator, Lookup, Decision etc Transformations and performed the unit testing for accuracy of data.
• Implemented DQ business rules in Informatica IDQ based on the approval of DQ rules.
• Contributed to the data governance office to drive the data quality business cycle and roadmap.
• Documented the Data Landscape in Informatica Axon and Updated respective business approval.
• Involved in Data Quality Architecture from end to end with business and data steward.
• Identified data quality issues, anomalies, patterns, based on defined business rules and created metrics and scorecards by IDQ Profiling.
• Collaborated with internal and externals stakeholders such as study team members, project managers, data stewards and data analysts.
• Proficient in Informatica MDM Hub configurations like creating mappings to pull the data from Landing tables to MDM stage tables by cleansing the data using Graphical Functions and Cleanse Lists and applying the Trust, Match and Merge settings while loading the data to Base tables.
• Profiled and Analyzed the all the source data for MDM process to understand the data
• Tuned IDQ Development process to push most of the process to database and removed unwanted ports and transformations.
• Design and develop Informatica MDM data model and defining logical relationships between the objects.
• Extensively validated address records with Address validation transformation process(Address doctor) for getting suggestion list, parse, Interactive, country recognition, certified, batch and Address code lookup.
• Created Data quality Rules in Informatica Axon and implemented in Informatica data quality (IDQ).
• Data profiling and extraction of insights from data, using exact matching, de-duplication, fuzzy logic, and other techniques to review data for accuracy.
• Applied Exact and fuzzy match logics in INFORMATICA IDQ to get duplicate records to understand for business and provided multiple reports to business.
• Applied the business rules in Informatica data quality and separated the exception data based on the business conditions.
• Design and develop Informatica MDM data model and defining logical relationships between the objects.
• Extensively validated address records with Address validation transformation process(Address doctor) for getting suggestion list, parse, Interactive, country recognition, certified, batch and Address code lookup
• Make recommendations to operational support for enhancements to systems of record to improve accuracy of operational data.
• Update, Mange the Tns entries of database in Informatica admin server to new add ons or updating existing entries.
• Created Various reusable rules using with multiple mapplets in Informatica IDQ.
• Data quality business rules implementation, metric gathering, and dashboard reporting.
• Reported the exception records to the respective business users and Clarified their questions and also get the clarification in the process of creating exception records using with Informatica Data quality (IDQ).
• Extract and load business rule DQ metrics into data governance management data quality dashboards.
• Creating the Users, Roles and Permissions for the respected Id's in the Informatica IDQ Admin Console.
• Created various scorecard lineage files using with Informatica metadata manager and exported lineage reports to business.
• Implemented Informatica metadata manager and provide the data lineage to the respective business users.
• Created Various data quality Profiles in Informatica Analyst using with Logical data objects in informatica data quality.
• Managed the Informatica Data quality (IDQ) and collaborated with MHE Data Owners, Operational Data Agents, Process Owners, Policy owners and Subject Matter Experts.
• Generated data quality reports and notifications to identify critical gaps for business process improvements.
• Migrated the tested Informatica IDQ mappings and workflows from test environment to Production environments.
• Maintain and provided quality assurance oversight of data landscape inventories.
• Scheduling Informatica Data quality jobs in Production using with third party scheduling tool.
• Created and maintain the Data quality Dashboards using with Tableau and Informatica Axon.
• Suggested various Data quality Strategies and Implemented best practices on entire process.
• Supported Inforamtica data quality production scheduled jobs run and escalated the report to respective business users.
• Communication of synthesized data quality findings to business and technical team members, senior leaders and external stakeholders.
• Update the Informatica Axon data quality reports results every week using with exception summary which created by Informatica data quality process.
• Developed Test Plans and written Test Cases to cover overall quality assurance testing.

Environment: Informatica Data Quality (IDQ/IDE) 10, Informatica Axon, Informatica Powercenter 9.6, Informatica MDM, Informatica Metadata Manger, Oracle, Toad, Alteryx.

Confidential - MA

InformaticaIDQ/MDM Developer

Responsibilities:

• Analyzed the data based on requirements, wrote down the techno-functional documentations and developed complex mappings using Informatica Data Quality (IDQ) 10 Developer to remove the noises of data using Parser, Labeler, Standardization, Merge, Match, Case Conversion, Consolidation, Address validation(address doctor), Key Generator, Lookup, Decision etc Transformations and performed the unit testing for accuracy of data.
• Successfully implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries for searching.
• Informatica MDM Hub Configuration Development: Creating BO, Stage and Landing tables, setting up relationship, Match Path configuration as per data model, creating load mapping, cleanse function, HM setup-creating entity types, relationship base objects, relationship types, profiles, put and display Queries
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration, and user acceptance testing.
• Extensively worked on Informatica data quality, Powercenter and Master data management for Data management, Data quality, Data Migration, Data validation, Data Enrichment and Data process.
• Design and develop Informatica MDM data model and defining logical relationships between the objects.
• Extensively validated address records with Address validation transformation process(Address doctor) for getting suggestion list, parse, Interactive, country recognition, certified, batch and Address code lookup.
• Involved in the process of doing External Matching for the Records provided with the Master Data.
• Applied the various Exceptions in IDQ Process and automated the escalating to business process.
• Involved in architecture of InformaticaIDQ design and Powercenter end to end design.
• Worked on Metadata manager for validation, promotion, importing and exporting the ORS repositories to Development, QA, Pre-Production and Production environments.
• Configured the Foreign Key Relationships among the Base Objects and define the lookups for the staging tables.
• Exported theIDQ Mapplets to InformaticaPowercenter and executed in all the environments.
• Good knowledge of Data warehouse concepts and principles of Ralph-Kimball and Bill-Inmon methodologies - Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization, Facts and Dimensions tables, Physical and Logical data Using Erwin for Data Marts and Staging Database.
• Applied the Best practices of Informatica standards to increase the performance and keep it in best order for future usage and easy to understand business/end users.
• Configured the Automation process for Land, Stage and Load Process (Batch Process)
• Applied IDQ Address doctor for handling and enriching the address issues of customer and employer Data.
• Work closely with the Data Stewards in finalizing the Informatica MDM Match rules and created the Match rule document and help them understand the way the match and merge requirements were incorporated in the rules.
• Develop stored procedures for Support groups to fix problems with security reference data when reported by users, eliminating manual update of tables for support.
• Proficient in Informatica MDM Hub configurations like creating mappings to pull the data from Landing tables to MDM stage tables by cleansing the data using Graphical Functions and Cleanse Lists and applying the Trust, Match and Merge settings while loading the data to Base tables.
• Imported IDQ mapplet to Informatica power center and integrated in the regular mapping for cleansing, standardization and address validation(address doctor) issues.
• Implemented Land Process for loading the customer Data Set into Informatica MDM from various source systems
• Reported the IDQ Address doctor address validation(address doctor) scores with suggestions and various expectations to Business and Profile the details for understand the issues.
• Creating match rules, match rule sets, system trust scores and trust score decay with Validation rules.
• Used different Data profiling techniques for better Data analysis. I.e. Colum profiling and filter options for better Data over view and identifying data anomalies.
• Develop the exception handling process to handle various business and data issues using with IDQ Developer and Analyst tool.
• Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Informatica MDM Batch Viewer and Automation Processes.
• Create Profile/Scorecards reports and Understand the data to develop/report/automate the IDQ data quality/integrations process to help MDM Process.
• Automated the IDQ Address validation(address doctor) process and Analyzed the Address validation(address doctor) output along with their suggestions.
• Created Various Informatica MDM Match rule sets for the base objects by defining the Match Path components, Match columns and rules; fine tuning the match rules for optimum output and performance.
• Actively participated in Trouble Shooting to analyse the failures, identify the root cause, preparing action plan to prevent future failures, preparing KLL documentation and fixing the defects as early as possible
• Worked with different Informatica tuning issues and fine-tuned the transformations to make them more efficient in terms of performance.
• Extensively applied all the business rules in IDQ/IDE to minimize the task to Informatica MDM for matching and Hierarchy features implanting.
• Cleansed, standardized, labeled and fix the data gaps in IDQ where it checks with reference tables to fix major business issues.
• Extensively used in-built reference data such as - token sets, reference tables, regular expressions to parse/cleanse/purge incoming data.
• Configured the Informatica MDM match (Fuzzy/Exact and) & merge (Auto/Manual) strategy to remove duplicates and generate the best version of the golden record.
• Extensively worked on Data migration, Data cleansing, Data Staging of operational sources using ETL processes.
• Exported IDQ Mapplets to Powercenter and automated the process for scheduling.
• Created various Mapplets, Reference tables, Profiles, Score cards for Product and Location data in Informatica data quality and analyst tools.
• Worked on Metadata manager for validation, promotion, importing and exporting the ORS repositories to Development, QA, Pre-Production and Production environments.
• Developed Source to Target Mappings using Informatica Power Center Designer to load data from various source systems like Oracle and Flat files to target database, implementing the business rules.

Environment: InformaticaMultidomain MDM 10,Informatica Data Quality (IDQ/IDE) 10, InformaticaPowercenter 9.6, Informatica data director, Informatica Metadata Manger, Oracle, Toad.