SUMMARY:

• Working experience as Business/System Analyst, with strong domain knowledge.
• Hands - on experience in building New/Upgrading existing applications based on IBM WCC 7 /MDM Infosphere 8.5/MDM Infosphere v10.0 and understanding of MDM v 11.4 on OSGI framework.
• Hands-on experience in building new application based on Informatica(PowerCenter)
• Good understanding of Health Care Insurance Enrollment and Billing systems. Member Eligibility, Membership/Organization(group) Enrollments and insurance product packaging to members/groups.
• Business/Data Analysis specific to data requirements for Membership information of health care insurance and provide Solutions for Complex data integrations for applications to cater business requirements.
• Analysis & Solving challenging data & data integration problems for the application.
• Experience in Health Care, Banking, Retail domains.
• Experience in MDM Infosphere 10.1 installations on AIX,LINUX.
• Exposure on Virtual MDM applications (EMPI,MCID)
• IBM Certified Professional on MDM Server 9.0 ( 2012)
• Extensive experience of Project implementations using Agile Methodologies
• Experience in Automation of ETL batch jobs in WLM (Work Load Management) and Control M.
• Knowledge of Design Patterns, SOA.
• Estimation, Activity planning, and Project status tracking and reporting.
• Understanding of Server Capacity Planning, WAS/MQ Configurations.
• Well exposed to onsite-offshore model.

TECHNICAL SKILLS:

Hardware Platforms: Windows, Unix

Software: Java/J2EE,XML, SQL,WCC 7, IBM Infosphere MDM Server v8.5,MDM 10.0, Informatica Power center v9.6.1, v10.1.0

Database: IBM DB2, ORACLE Exadata

Web Servers: IBM WAS 6.1, 7.0,8.0 Tomcat Server 7.0

Job Scheduling Tools: WLM(Work Load Management), Control M

Version Control Systems: MS Visual SourceSafe, IBM Rational Clear Case, Star Team

Project Management/Defect Tracking Tools: HP Quality Center, JIRA

Monitoring Tools: Splunk, HP Introscope

Database Tools: IBM Data Studio 3.1, SQL Workbench, Oracle SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential

Systems Analyst & Delivery Execution Lead (On Site-USA).

Environment: Informatica Power center v10.1.0, Oracle Exadata, UNIX, CNTRL M, Putty, JIRA, Service Now.

Responsibilities:

• Gather business requirements and create JIRA User stories providing functional specifications and acceptance criteria’s.
• Business/Data Analysis specific to data requirements for Membership information of health care insurance and provide Solutions for Complex data integrations for applications to cater business requirements.
• Leveraging sub-application components and provide effective solutions to business needs.
• Design and Solutions for centralizing complex integrated and non-integrated membership.
• Conducted project proposal walkthroughs and meetings involving various stakeholders, leads, architects, QA and support teams.
• Analyze, Design and develop E2E solution of data integration for NASCO member eligibility in eHUB strategy.
• Regular Interactions with DAL (Data access layer), Microservices, API/APIGEE and Consumer portal teams to understand the consumer needs and centralize the data in an effective manner for consumers.
• Coordination with RDM( reference data management) and Data modeler teams for data requirements.
• Interactions with Test data management, Source teams for data set up for critical business scenarios.
• Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes
• Tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data & used pager for notifying the alerts after successful completion
• Create JIRA Stories and documents to describe program development, logic, coding, testing, changes and corrections
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Production loads (Initial and delta)
• Scheduling ETL Batch jobs on CNTRL M.
• Code Migrations ( INFA & UNIX), DDL/ DML execution.
• Offshore coordination for development tasks.

Confidential

PROD Support Lead (ETL/MDM)

Responsibilities:

• PROD support lead for ETL/MDM Applications(Consumer Hub)
• Responsible for leading MDM/ETL technical/functional change efforts/enhancements in PROD environment.
• Provide tactical solutions for member eligibility data issues across 9 source systems(WGS, ISG, CS90, ACES, FACETS, NASCO, CHIPS, MEDISYS, FEP)
• Application Server maintenance (both PROD and Test Regions) which includes UNIX patching, Server Upgrade etc. on WAS, MQ, DB servers.
• Monitor Splunk alerts and manage Splunk DashBoard for Application stability health checks.
• Performed Data Purging activities
• Reconcilement to Sync up the data with E&B systems ( Email & Phone)
• Load failure analysis.
• Enhancements for MDM retrieval services ( Alerts, threshold, dead locks) enhancements
• Perform Adhoc Data load requests
• Analyze application Impacts due to change in other systems
• Automate PROD/Non-PROD data load jobs
• Perform Disaster recovery and enhance disaster recovery methods for application
• Analysis on Weekly data load report
• DEDUP process to ensure no duplicates
• Engage in SWAT calls for critical Production issues.
• Maintain WorkOrders, Incidents, CQ SLA
• MDM and ETL PROD deployments
• Update SSL’s at Data power to ensure proper Handshake between Servers
• Worked with Source systems on Source data issues

Confidential

Team Member - Developer (MDM)

Responsibilities:

• Worked as a MDM developer from offshore.
• Development of MDM(infosphere) services using Data Additions, Extensions and Composite transactions to implement Maintain Member, Maintain Group MDM Services for WellPoint Applications FitOrbit(NASCO) using WCC 7.
• Worked for Implementing Member Alert and Member Interaction Services for AHG( Confidential Health Guide) Phase 1 & Phase 2.
• Worked for Implementing Member Demographics and Member Contract MDM Services using Common Format for VACHIPS, ACES & FACETS Source Systems.
• Identified bugs, developed the error handling, conducted Unit testing and Functional testing.

Confidential, USA

Team Member - Developer (MDM)

Responsibilities:

• Responsible for development of various services using IBM Info Sphere MDM Server v8.5
• Implemented the detail design in Java using IBM Info Sphere MDM Server v8.5, RSA 7.0.0.6
• Worked on Data Additions, Data Extensions and Composite Transactions.

Confidential

Team Member - Developer (MDM)

Responsibilities:

• Confidential Commercial Bank has incepted the Phoenix Programme to provide a global cash management Internet platform for customers
• A centralized data repository - the CDI Hub for Phoenix - is required to manage legal entity and account provisioning for the Phoenix cash management internet channel
• The key Objective of the CDI hub is to maintain a legal entity and account data store centrally and then provision onto any participating channel applications. The CDI hub that has been implemented in R1 using
• Worked as a MDM Developer and Production Support Analyst.
• Developed custom business proxies to maintain customer information.