We provide IT Staff Augmentation Services!

Systems Analyst & Delivery Execution Lead Resume

5.00/5 (Submit Your Rating)

SUMMARY:

  • 8 Years of experience in IT Services with primary focus in Master Data Management (Infosphere) arena and Secondary Informatica ETL (Powercenter). In all the projects, have worked across all the SDLC phases starting from Requirement Analysis, Design, Development & Unit Testing, System Integration Testing and deployment.
  • 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

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 Confidential 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)

Environment: IBM MDM 10.0, WAS 8.0.0.5, IBM DB2 v10.0, Informatica Power center v9.1.0,v9.6.1, Oracle Exadata, Rational Clear Case, UNIX, Splunk, Wily, SOA Services, SOAP UI, Service Now, JIRA.

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)

Environment: IBM WCC 7 & IBM MDM 10.0, WAS 7.0, IBM DB2 v10.0, Oracle Exadata, Rational Clear Case, UNIX, Splunk, Wily, SOA Services, SOAP UI, .

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 Confidential 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

Team Member - Developer (MDM)

Environment: IBM MDM( Infosphere) 8.5, WAS 7.0, IBM DB2, Rational Clear Case, UNIX SOAP UI.

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)

Environment: IBM MDM( Infosphere) 8.5, WAS 7.0, IBM DB2, Rational Clear Case, UNIX.

Responsibilities:

  • Worked as a MDM Developer and Production Support Analyst.
  • Developed custom business proxies to maintain customer information.

We'd love your feedback!