SUMMARY

• Analytical, goal oriented and result driven professional with 7+ years of experience as a Data / Business Analyst.
• Well versed in IT field which includes working knowledge of Software development, Master Data Management, Data Migration, Data warehouse,Data manipulation on SQL, Teradata and MS - Access.
• Informatica MDM certified professional. Hands on experience in developing/configuring and customizing MDM solutions using Informatica MDM.
• Worked on PARTY based Data Model for an end to end implementation. Have configured all metadata tables of MDM, Trust Score setup, System setup, Mapping configuration for various sources, running various jobs (Stage/Load/Tokenization & Match jobs) to get the Master/Golden record. Involved in IDD configuration for the system, this was a Batch mode application. Along with this have also worked on Data Profiling the incoming data which involved cleansing the data.
• Hands on Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Proficient with Informatica MDM Architecture and various modules involved.
• Proficient in Databases include SQL Server, and Teradata.
• Hands on experience using query tools like TOAD, SQL Developer.
• Designing and configuration of landing tables, staging tables, base objects, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
• Experience in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation.
• Experience in designing and implementing IDD applications.
• Knowledge on SIF (Service Integration framework) and User Exits.
• Experience in data cleansing with MDM and Data Profiling.
• Extensively used of SQL Developer and SQL Assistant.
• Excellent communication and presentation skills, team player. With extensive customer relations, experience and proven ability to communicate.
• Worked in Insurance Policy Admin System for Confidential & Confidential Companies and managed Business with Client.
• Playing vital role in improving and monitoring existing business process that can be improved with help of IT landscaped solutions.
• Business requirement gathering and passing the same to development team with Business cases and process flow.
• Good experience in performing and supporting Unit testing, System Integration testing (SIT), UAT and production support for issues raised by application users.
• Good experience in project planning and resource management.
• Direct interaction with business customers for Requirement Analysis and Deliverables.
• Managing reporting, analysis and decision making for a change request.
• Received multiple client appreciation at onsite and offshore.
• Responsible for Developing, Testing and moving changes to UAT and production through client change request.
• Experienced in software testing which involves development of test cases and test scripts and User Acceptance Testing (UAT).
• Direct reporting to customers on the various bug fixes and UAT.
• Responsible for timely and quality deliverables to client through CA tickets and tickets through Test Track Pro as per Service Level Agreement.
• Experience in Microsoft office tools like MS Access, MS Word, MS Powerpoint, MS Excel etc.
• Experience with On-Site/Off-Shore Model of project delivery. Experienced in Support Model.
• Self-motivated, adaptive and able to work in a team or independently in a time boxed environment. Excellent organizational, communication and interpersonal skills.

TECHNICAL SKILLS

Programming Skills: SQL

Databases: Teradata, Oracle, MS Sql Server 2005/2008,MS Access

Operating Systems: Windows 98/2000/XP/7

Tools: Tableau, MS Office, Putty WinSCP(FTP/SFTP)

MDM Applications: Informatica MDM 10x

Packages / ETL: Test Tech Pro, iReport, Jasper, Velocity (Policy Admin System), Power center v10.x, SAS EG version 5.1

Business Skills: SDLC, Requirements Gathering, Team Management

PROFESSIONAL EXPERIENCE

Confidential

MDM Data Analyst

Environment:, Informatica MDM 10.1, Informatica Powercenter, SQL Server 2008, Test Track Pro, Open Reports,iReport, Jasper, Oracle 11g, Windows XP, Velocity Policy Admin System,Putty, Flat files, Microsoft MS Access, Microsoft Excel and Powerpoint

Responsibilities:

• Requirement gathering of various Insurance products from Business users (underwriters/product managers).
• Performed various Data Analysis and Profiling on the incoming unstructured Business Data.
• Configuring various environment required for the Business ie Development, QA, UAT and Production.
• Moving Data / changes from one environment to the other through scripts.
• Interacting with Business directly on various issues / changes / or new requirements.
• Day to day tracking of various activities and managing my team at offshore on the completion of the tasks.
• System designing for policy administration and operational procedures. This also includes system modules like Claims, Accounts, Business Intelligence and Reinsurance.
• Involvement in High Level Design and Low-Level Design document.
• Involved with ETL team to develop Informatica mappings for data extraction and loading the data from source to MDM Hub Landing tables.
• Worked with ETL Developers to integrate data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables of Informatica MDM Hub.
• As per the client architecture understand the customer/vendor/item (MDM) data model.
• Create the physical data model (Base /Stage and Landing) as per the defined architecture.
• Define the mapping for stage jobs for various source systems.
• Schedule and run the batch jobs(Stage/Load/Tokenization & Match jobs).
• Create batch groups in Informatica MDM Hub to run the staging, match and merge and load jobs as per the dependencies.
• Configure the match (Fuzzy/Exact and) &merge (Auto/Manual) strategy to remove duplicates and generate the best version of the golden record.
• Create the queries and packages for BO as per the business requirement.
• Generate the report and publish to the business periodically.
• Automate the batch jobs using automation scripts.
• Deploy the application. Define the roles and access privileges for developer/administrator/data steward/requestor etc. on requirement basis.
• Validate/test the data into xref and history tables.
• Create the packages as per the business need to pull the data from MDM.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Analyzing the data load failure and documenting the error.
• Worked closely with Informatica support to solve various defects and got it resolved.

Confidential

Data Developer

Responsibilities:

• Involved in resolving data issues/Report issues and coordinating with team members to ensure proper deliverables.
• Involved in weekly status call with client.
• Involved in the Requirement gathering Phase
• Interactions with Business Analyst in enhancing the system and support process for accurate deliverables.
• Responsible for Projects Quality deliverables as well as issue resolution.
• Worked as DP (Defect prevention) coordinator for quarterly/ monthly quality audits.
• Involved in monthly Activities involved - creating Code review checklist, Defect tracking and prevention, analyze effort and schedule variance, participate in Quality Audits, update Resource Plan.
• Involved in daily interactions with Onsite Coordinator (OSCO) and Business users.
• Involved in peer reviews for the deliverables generated in the project.
• Done automation to reduce the manual work.
• Working on enhancement requests in the existing application.