SUMMARY

• Around 7 years of IT experience with special emphasis on MDM hub configuration and Master Data Management, System Analysis, Design, Development of applications and Quality Analysis.
• Designing, Installing, Configuring core Informatica MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, IDD
• Defining and configuring landing tables, staging tables, base objects, hierarchies, foreign - key relationships, lookups, query groups, queries/custom queries and packages
• Designed & developed multiple cleansing and standardization scenarios using Address Doctor
• Implemented Hierarchy Manager Module in addition to Match/Merge/Unmerge to depict various hierarchies
• Helping business to understand teh Match rules configuration and decide teh trust factor and Configure match/merge rules
• Configuration Address Doctor for address cleansing in MDM Hub
• Addressing issues of master data definition, metadata acquisition and data migration including data profiling, validation, clean-up and remediation, and source to target mapping
• 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 teh Data stewards
• Configuring charts on teh dashboard according to business requirements in IDD and user exits in IDD for selective validation alert pop ups
• Experienced in testing Client/Server, and Web based, mobile applications by using automated & manual testing.
• Strong Knowledge of Software Development Life Cycle (SDLC), Testing Life Cycle (TLC), Testing Methodologies and Techniques.
• Extensive abilities in operations and technology related to financial, business and administrative applications and related hardware and software.
• Proficient in development, execution, maintenance of Test plans, Test cases, Test scripts, Test specifications and Test scenarios.
• Excellent communication and interpersonal skills and an attitude to learn teh 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 9.x, IDD

Cleanse Adapters: Address Doctor

Databases: Oracle 8.x/9.x/10g/11g, DB2, My SQL

Testing Tools: Quality Center, Selenium, Cucumber, TFS, JIRA

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

Application Servers: JBoss, Web Logic 10.x/9.x

Package: MS Office (MS Access, MS Excel, MS PowerPoint, MS Word), Visual Studio 6.0.

Environment: Windows 2000/ NT/XP, Sun Solaris, Unix, Windows Server 2003/2008

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Informatica MDM Developer

Responsibilities:

• Involved in teh brain storming sessions for deciding teh data model with Solution and Data Architect
• Created, redesigned and worked on physical data model and helped for logical data model extension using Erwin
• Configured Address Doctor by doing teh changes in teh Config files on teh hub server
• Created teh landing tables, base tables and staging tables as per teh data model
• Defined and developed teh ETL process to load teh data into teh landing tables during teh land process
• Configured teh Foreign Key Relationships among teh Base Objects and define teh lookups for teh staging tables
• Configured teh Automation process for Land, Stage and Load Process (Batch Process)
• Developed mappings using various cleanse and address doctor functions
• Did manual landing, staging and loading process using teh batch viewer
• Used Metadata manager to Import and Export of Metadata and Promote Incremental changes between environments from development to testing phase
• Worked closely with teh Business in gathering teh Match rules and created teh Match rule document
• Developed teh Match paths, Match Columns and Match rules (Exact and Fuzzy) in teh Match and Merge Process
• Ran teh Match and Merge set up and fine-tuned teh Match rules
• Worked on Hierarchy manager for hierarchical relationships between design objects using entities and hierarchies
• Worked Security Access Manager (SAM) for creating roles and assigning users.
• Created and Implemented IDD applicationto search Dealer by creating subject area groups, subject areas, subject area child.
• Created MDM stored procedures and batch groups for MDM hub.

Confidential, Fairfield, CT

Informatica MDM Consultant

Responsibilities:

• Involved in working closely with teh business in developing an approach for Product Master and Customer Master based on mergers.
• Installed and configured Informatica Hub 9.5 on Dev Box and configured address doctor
• Worked closely with teh Business in gathering teh Match rules and created teh Match rule document
• Developed teh Match paths, Match Columns and Match rules (Exact and Fuzzy) in teh Match and Merge Process
• Involved in teh process of doing External Matching for teh Records provided with teh Master Data.
• Involved in providing support for teh Application and looking into any data related issues and understanding teh root cause.
• Worked with SOAP UI to Force Publish records using teh WSDL files.
• Involved in working with teh Business in gathering teh requirements for Supplier Master.
• Involved in Creating all teh Staging Tables and Base Objects for Mastering Records for Supplier Master.
• Involved in Configuring JMS setting in Informatica MDM and integrating teh external applications using SIF.
• Used teh Informatica Service Integrated Framework (SIF) to develop teh web service for MDM Process.
• Involved in using teh web services created using SIF for publish and Force Publishing a Duns Number.
• Provide weekly status updates on progress, status and issues.
• Developed high level and low level design documents.

Environment: Informatica MDM 9.5.1, IDD, Java, SOAP UI, Informatica Power Center 9.1, Oracle 11g/10g, Toad, JBoss 5.1.0, Address Doctor, Windows server 2008, Unix

Confidential

Informatica MDM Consultant

Responsibilities:

• Successfully completed Customer and Product centric Master Data Management initiatives using Informatica Master data management product
• Installed and configured Informatica Hub 9.5 on Dev Box and configured address doctor
• Involved in discussions with teh Data Architect and Solution Architect in defining and changing teh data model
• Created landing tables, base tables, staging tables according to teh data model and number of source systems
• Defined teh foreign key relationships among teh base objects and defined look ups on teh 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 teh data and came with up teh 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 teh data for transforming teh schema from development environment to testing environment.
• Profiled Data coming from different database systems like Oracle, XML, IBM Mainframe Flat files, DB2 and performed Data Quality Audit.
• Informatica core components like Designer, workflow Manger, Workflow Monitor were used extensively.
• Created Sessions/Batches in Informatica server manager to execute mappings.

Environment: Informatica MDM 9.5, IDD, Informatica Power Center 9.1, Oracle 11g/10g, Toad, JBoss 5.1.0, Address Doctor, Windows server 2008, Unix

Confidential

Informatica MDM Hub Developer

Responsibilities:

• Worked as closely with Business users, Data Architects in understanding teh business and teh needs
• Involved in redesigning teh data model by doing teh necessary changes by enhancing teh scope of teh project
• Created Landing Tables, Staging Tables and Base tables by making teh Data Model as teh base
• Defined teh Trust scores for teh source systems as per understanding teh business process
• Defined teh Foreign Key relationships and provided lookup information for teh required columns in teh staging tables
• Developed teh mappings and used teh necessary cleanse functions by analyzing teh data using teh data quality tool
• Concatenated teh columns to get unique values loaded into teh Pkey source of teh staging tables
• Fixed teh issues while getting teh data loaded in stage and base tables and worked with Informatica Support
• Used hierarchies workbench tool, for converting base objects into entity base objects, creating entity types, relationship base objects, relationship types, profiles, put and display Queries
• Configured match and merge and run match rules to get teh matches by eliminating teh duplicates and merging teh records using teh merge process
• 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 teh
• Implemented teh approval process by enabling and disabling teh buttons for subject areas in IDD, according to business rules and requirements
• Configured Auto Merge and Manual Merge settings for Data Stewards in Hub and IDD
• Worked extensively on BDDConfig.xml, BDD Bundle Properties, Error code Bundles, Message bundles properties, Metadata Bundle properties in IDD
• Created documents for teh relationships, landing tables, staging tables, base objects, hierarchies, and IDD application
• Provided end user and helped them to understand teh new features and application

Environment: Informatica MDM 9.5.1, Informatica Power Center 9.1, Base SAS, Oracle 11g, Unix

Confidential

Software QA

Responsibilities:

• Analyzed and understood teh requirements.
• Involved in Functional, System and Installation, User Acceptance Testing on both web and mobile.
• Executed teh Test scripts written in RUBY
• Creating framework using CUCUMBER for automation of headless testing.
• Involved in writing test cases using Quality Center.
• Proactive participant in weekly AGILE team meetings and updated team lead and manager on status of testing
• Involved in UAT Test Case Creation & Execution with End Users
• Executed teh Selenium test scripts for each build for Functional & Regression Testing.
• Performed Peer review of test cases and executed them.
• Built a Detailed, Reusable, Script-free Keyword+ data Driven Automation
• Created Data Driven Framework & included teh previous scripts as per requirement in Framework.
• Exhibited strong aptitude in implementing Quality Assurance Standards & Testing Methodologies using Use Case documents, functional specifications & requirements
• Created, designed & executed test plans, test scenarios, test cases & test reports.
• Conducted test plan reviews & Test case review for teh project team.
• Ensures applications are setup correctly & working in both test & production systems.
• Prepared High Level test scenarios & Test Scripts & cases for Functional testing based on user stories.
• Involved in Behavior Driven Testing using CUCUMBER.
• Tested User Interface inconsistency and application functionality.
• Performed Regression testing.
• Identified and documented all teh issues and defects in TFS to ensure application software works as per SRS
• TEMPEffective coordination between development team and testing team.
• Involved in weekly status reporting.

Environment: Java, CUCUMBER, RUBY, Selenium Web Driver, Perl, SQL Server 2008, Windows 7, Linux, TFS, TDD, Quality Center, iOS, Android, Agile Methodology, Scrum

Confidential

QA Engineer

Responsibilities:

• Participated in teh full project lifecycle with particular emphasis on creation, maintenance and execution of test to ensure teh capability of teh systems being built. W
• Working closely with teh Developers and Engineering Teams in teh review and modification of teh product and its specifications using Agile-testing methodology.
• Developed automated test cases, scripts for teh core modules using BDD (CUCUMBER - RUBY for several modules.
• 3 Amigos sessions where me worked with a BA and a Developer throughout teh development lifecycle. 3 Amigos meeting created story card and use cases.
• Executing teh Test scripts written in RUBY and maintain script
• Created high level quality test cases for execution during each release in teh Software development life cycle.
• Identify, Report, Track, and Monitor Defects in defect tracking system(JIRA)
• Implemented CUCUMBER for unit testing, Implemented Selenium for Integration Testing, Implemented image based automation for Cross browser and cross platform testing
• Performing all QA tasks following Agile Methodology (scrum).
• Worked very closely with Business consultants, System Designers and Project managers to ensure teh
• Creating High Level Scenarios and Test cases to follow teh SDLC guidelines and processes.
• Performed Acceptance Testing using CUCUMBER.
• Involved in Behavior Driven Testing using CUCUMBER- RUBY.
• Performed Function and Regression testing
• Ensure entire end user experience meets expectations.
• Used Quality Center for Writing test cases, mapping requirements with test cases, executing them and
• Creating defects.
• Involved in executing teh Test cases.
• Involved in Defect tracking and reporting.
• Performed Functional, UI Testing, Integration, System, Regression Testing.
• Performed validations in different systems such as backend and middle tire.
• Provided teh regular status updates to all stake holders and upper management.

Environment: .NET,, Selenium, Perl, SQL Server 2008, Windows 7, Linux, TFS, RUBY, TDD, Quality Center, iOS, Android, Soap UI, Manual Testing, Waterfall, Agile Methodology

Confidential

Quality Engineer

Responsibilities:

• Analyzed and understood teh Business requirements.
• Involved in creating Test Cases based on teh functional specifications.
• Executed test cases and verified actual results with teh expected results.
• Based on Test Plan, Reviewed teh Test Cases.
• Performed Functional, Ad hoc, User Acceptance, and Regression Testing.
• Used Selenium for automating web applications.
• Tested User Interface inconsistency and application functionality.
• Logged teh defects using Quality Center.
• Participated in weekly meetings.

Environment: Quality center, Windows XP, Waterfall Model, TFS, Selenium