Objective

• Seeking a responsible and challenging position where my experience, skills, passion, knowledge in technology and business processes will significantly contribute to the overall success of the organisation, bridges the gap between functional & technical team and provide opportunities for my career growth.

SUMMARY

• 4+ years of technical/functional expertise in MDM and DW/BI in financials, insurance and healthcare domain.
• Adept in analysing business needs, gathering requirements, planning, organizing, documenting.
• Experience in creating prototypes, use case diagrams, sequence diagrams, process flow diagrams.
• Have ability to understand business processes, coupled with sound technical knowledge.
• Experience in risk analysis & use case analysis.
• Facilitated JAD session with business and technical team.
• Excellent communication, good listener and able to maintain good rapport with clients.
• Adept at writing data mapping documents, data transformation rules, data migration documents, BRD, SRS, HLD and LLD
• Have hands on experience in all SDLC phases - requirement analysis, design, development, testing, maintenance and support.
• Hands-on experience on different styles of MDM flavour.
• Involved in discussions with clients on deciding short term and long term goals for MDM implementation.
• Prepared MDM proposal for a leading American bank.
• Prepared MDM case study and mentored team to build a reusable technical solution in IBM MDM Initiate.
• Took training session on MDM as part of building competency.
• Adept at multitasking to achieve individual and team goals.
• Coordinate all aspects of project - planning, scheduling tasks & tracking deliverables.
• Experience in writing test plans, test cases, generate test scripts and maintain reports for defect tracking.

TECHNICAL SKILLS

MDMMDM: IBM MDM Initiate/IBM Infosphere MDM Standard Editon, IBM MDM Server

ETL: Informatica PowerCenter, Clover ETL

Languages: C, C++, Java

Database: SQLServer, Oracle

OS: Windows XP/Vista/7, Windows Server 2008

PROFESSIONAL EXPERIENCE

Business Analyst

Confidential

Technology Used: Informatica PowerCenter 9.5.1, Informatica DT Studio, IBM Cognos, Oracle 11g

Responsibilities:

• Analysis of requirements and effort estimation.
• Communicating requirements to development team and tracking deliverables.
• Co-ordinating with business teams, development team, testing team, support team and other stake holders to make sure that project is always in stable state.
• Making process flow diagrams, use-case diagram and sharing with stakeholders.
• Conducting JAD session and preparing BRDs.
• Preparing mapping documents for data transfer between systems.
• Making system ready for user acceptance testing.
• Planning and working on release activities.
• Participating in meetings related to SLA violation. Analysing the root cause of problem and preparing RCA document and guiding team on corrective actions.

Business Analyst

Confidential

Responsibilities:

• Analysis of legacy reports.
• Co-ordinating with business users for clarifications on the usage of reports.
• Co-ordinating with SMEs on clarifications and functionality of reports.
• Preparing SRS document for reports.
• Identifying the duplicate reports, parent-child reports.
• Identifying common attributes used across multiple reports.
• Identifying fact and dimensions and working on logical data model.

Techno-Functional Consultant

Confidential

Technologies Used: IBM MDM Initiate, Clover ETL, Java 1.6, SQL Server 2008, Informatica PowerCenter, IBM QualityStage

Responsibilities:

• Interaction with client to understand their challenges and problems with master data.
• Participated in JAD discussions.
• Perform analysis of customer data across source systems and recommended hub configuration for identity matching and house holding.
• Prepared Use-Case diagram and workflow diagram and shared with stakeholders.
• Prepared technical design document and unit test plan based on functional specification and checked the code for coding standards compliance.
• Prepared mapping documents for upstream and downstream systems.
• Implement configuration of hub, develop algorithm for identity and household, and perform iterative matching and analysis.
• Configuration of Inspector to support out of box features for manual link and unlink records.
• Configuration of inbound broker to perform Initiate transactions on source data.
• Develop Clover ETL graph using workbench to publish golden record changes, Identity changes and household changes to data mart.
• Conduct knowledge sharing sessions on Hub configuration, Inbound broker and Outbound change propagation of source data.
• Performed integration testing of MDM application with quality stage and ETL team.
• Prepared deployment document for all MDM components and participated in release activities.
• Supporting MDM application after release for any issues.

Techno-Functional Consultant

Confidential

Responsibilities:

• Participate in requirement discussions and analysing requirements.
• Documented business requirements and wrote use cases.
• Effort estimation using FP estimation methodology.
• Involved in Data-Modelling activities and prepared logical data model diagram.
• Conducted sessions on DSUI in MDM.

MDM Consultant

Confidential

Responsibilities:

• Analysis and Design of the APIs which will add / update the customer preferences based on its own business rules.
• Analysis and Design of the data model for storing customer preferences in custom tables.
• Prepared HLD and LLD.
• Development of JMS messaging queue (Websphere MQ) framework services for asynchronous publish/interact with downstream systems notifying them of data changes.
• Messaging format used is OAG.
• Development of Batch/OAG API for changing the document preferences in asynchronous manner.
• Development of caching framework to cache the code tables.
• Preparation of the Test Plans and Review of the Test Scripts for both Unit and Integration Testing
• Coding for all the business entities based on MDM framework requirements.
• Testing the implementation for all the production scenarios
• Testing with other system for publish framework testing.
• UNIX logs management.
• Responsible for the Production Implementation support.