Mianframe

Raghavendhar Kamsali

+1-747-***-**** *************@*****.*** Summary:

A Highly dedicated, self-motivated, hardworking IT Professional with 17 years of experience as IT application developer, Tech Lead, Team lead and Business Systems analyst.

Functional areas include CRM (Customer relationship Management), CDM(Customer Data Management) in Retail and commercial banking, USA Healthcare Claims processing, and Capitation, MIS/DSS(Management Information system/Decision Support Systems) in Health care domain.

Worked on various major IT programs, Projects, Small enhancements/Developments and production support assignments as a mainframe application developer with primary skill set as COBOL, JCL, DB2, VSAM, CICS, IMS DB,REXX, ZOS Connect. Also gained the experience on AWS Cloud services, Kafka, snowflake, Python, Power BI/Tableau as a secondary skill set.

Working as Datafeeds specialist at the DHCS – Department of Healthcare services – California for MISDSS Datawarehouse in USA healthcare.

Worked on modernization of the Mainframes Anthem Healthcare Claims processing system onto AWS cloud to run on rule-based platform DROOLS and Kogito.

As an experienced technical lead/Senior systems analyst involved in stake holder analysis, gathering of High level and low-level Business and technical requirements, preparation of solution proposal documents, attending architectural governance board meetings along with Business and IT Application architects.

Have got expertise in Data Mapping, gap analysis, Data modelling and creating system appreciation and Business Process documents and conduct Data Analysis and prepare various business reports.

Worked as a Release manager at Anthem (USA) and HSBC(UK) to ensure that all the Endeavor change Packages are in-line with the development covering all the elements and create and submit e-forms. Attend the Change Approval Board(CAB) meetings manage Production releases and submit the ServiceNow change requests to promote the elements to production.

Played a key role at HSBC CDRM Engineering department in setting up the guidelines, check lists for systems analyst team and Level 2 production support teams as part of maturing the engagement levels from off shore.

As an ITSO (IT service owner) performed activities such as Mainframe Capacity planning, performance tuning for mainframe optimization, Disaster Recovery test and BCP Co-ordination, proactively conduct and contribute to incident management ensuring the stable IT systems for business users and customers.

Gained Knowledge of Hogan Core Banking Applications CIS(Customer Information System) on HOGAN Umbrella, Processing Environment Manager(PEM),CDMF, Logical Environments( Data Groups, Activities, Program Linking to PEM), Hogan Abend Identification and Fixing both Online and Batch.

At HSBC UK worked on ISST Program (Intelligent Sales and Service Transformation) at HSBC and successfully delivered the modernization of the CRM application running on mainframes (Batch and online) to Teradata CIM, Celebres, RTIM, Salesforce CRM.

Worked on various regulatory projects such as FATCA, KYC, AML, Earth & Moon, CDD for HSBC UK CDM (Customer Data management) and various CTA (Cost to Achieve) projects with excellent cost saving ideas to improve performance and stability of the mainframe applications.

Technical Skill set:

Operating Systems : Linux, Windows, MVS/ESA and Z/OS, OS/390

Technologies : IBM Mainframes, Salesforce CRM, AWS Cloud services.

Programming Languages : COBOL, JCL, DB2, CICS, VSAM, IMS-DB, FOCUS, DB2 Stored

Procedures,REXX.

Databases : DB2(SQL), IMS-DB, Teradata, Mongo DB (NoSQL), Graph SQL.

ETL and reporting tools : Datastage, Power BI, Base SAS and SAS Enterprise guide.

Cloud : Salesforce CRM, force.com, AWS Cloud services.

Process Tools &Utilities : Jira, Service now, HP ALM-Quality Centre, RTC, Clarity.

Development/Debugging tools : PCOM, File Manager DB2, File AID, Xpeditor, Omegamon, IBM Data studio,

Postman, Salesforce.com, SAS Enterprise guide, Teradata Studio, FileZilla, Bit Bucket, Postman, RDZ.

Version controller & Scheduler : Endeavor, Change-man, Control-M, OPC, GitHub, ESP.

Certifications:

Agile Certified Scrum Master (CSM) from Scrum Alliance.

Trained on Enterprise Architecture using TOGAF(The Open Group Architecture Forum).

Certified mainframe programmer from Maples ESM.

Certified in Business English communication (Vantage) from Cambridge University.

Education:

Bachelor of Technology(B.Tech) in Electrical and electronics Engineering from JNTU Hyderabad, 2003.

Professional Experiences:

Department of Healthcare services-DHCS, Sacramento, California, USA Jul 20023 – Till date

Mainframe Team Lead/Datafeed Specialist

Team Member: 7

MISDSS – Management information Systems and Decision Support systems is a DHCS dataware house application which receives data from various state healthcare applications such as PACES, CAM-MIS, ShortDoyle, Medical RX, IHSS, Denlta Dental, CapMan, EVV, Medicare and Medicaid data covering data across various claims, provider, member eligibility, Managed care and Fee For service(FFS), Capitation and transforms and stores on Teradata Datawarehouse. The data is sent to down stream applications whichever subscribed such as TMSIS, MARS and sent to federal CMS for FMR(Federal Management review) auditing and reconciliation.

Worked as Datafeed specialist covering the below activities.

Develop and maintain the data feed process on Mainframe(COBOL, JCL,DB2, REXX, IMS DB)/SAS/Teradata to retrieve the data from various data sources and transmit data in preparation for loading into the MIS/DSS data warehouse.

Develop ETL Process using Data Stage, Control tables, Error logging auditing Data quality, shell scripting and Unix ingesting the data from various Claims, provider, member source systems flat files, relational Databases and create business Model using star Schema.

Analyze the warehouse requirements and research existing claim, eligible and provider processes to maintain the data feed production cycle.

Utilize SAS EG statistical tool to create reports and trends from the MIS/DSS, support user, CMS-64 reports requests and provide support for existing data feed outgoing data feeds to the plans, audit and other external areas.

Create a universe and sample files, Paid amount (T19/T21) control reports for sharing with CMS as part of PERM.

Respond to help desk and system changes and updates or changes to the existing data extract and data feed process.

Conduct weekly team meetings and ensure all the Jira work requests are addressed and work is allocated across the team and managing the Jira dash board.

Carelon Global solutions (Subsidiary of Anthem Healthcare USA). Mar 2021 – Apr 2023

Tech Lead/Solution Architect

Team Member: 16

The Objective of the Claims reverse engineering program was to migrate the existing legacy mainframe healthcare Claims processing application to a rule-based platform on DROOLs and KOGITO. Worked on Conversion of COBOL code into rule based DRL files which further deployed and run the application AWS cloud.

Worked with Mainframe in enabling them creating the COBOL reverse Engineering documentation of mainframe application in the format required to develop/Build rules on DROOL and Java.

Conduct detailed analysis of the existing functional requirements based on Reverse Engineering documentation and rewrite the requirements at granular level that can fit in the AWS DROOLS platform.

Create JIRA tasks/stories/EPICs for the development of the granular level rules to execute on DROOLS/KOGITO.

Conduct detailed analysis of the evolved rules and identify the paralleling opportunities to improve the performance by effective rule sequencing.

Define Data pipelines and work on Data streaming using Kafka as part of integration.

Perform gap analysis and define and modify the data model for the future state application and architecture.

Conduct detailed analysis and prepare the API Orchestration and solution overview documents.

Create Data models for various entities as part of Data integration and implement the integrations using Kafka Connect, topics, Data streaming pipelines.

Ensure that the reverse engineering documentation is up-to date and in sync with the production code after each monthly release.

Define the acceptance criteria and create Epics/Stories/Tasks in Jira and verify and validate the results on API testing using Postman and provide PO approval.

Carelon Global Solutions (Subsidiary of Anthem Healthcare USA). Dec 2019 – Mar 2021

Lead Mainframe Developer

Team Member: 7

The Capitation system (aka Well Cap) pays a capitated amount to professional medical providers, ancillary providers, and institutions on a Per Member Per Month basis (PMPM) or % of Premium basis. The amount paid is calculated based on the negotiated base rate which is further adjusted based on the member's age, sex, and specific employer group benefits. The Cap system can support member adjustments (backdated enrolments, terminations, provider changes etc.) up to 24 months. In addition, the Cap system can support provider contract adjustments that impact provider payments up to 24 months.

Capitation payment information is sent to FCS for payment delivery. Payments can be made by check or electronically and accompanied by a detailed or summary payment report. The Cap system provides multiple reports to primary providers such as adjustments, activity, and prospective reports. Most providers access capitation provider reports via Availity. The Cap system also provides reports to the Vendor Management team for ancillary providers. In addition, the Cap system sends detailed Capitation payment information to Edward and FIRST (Actuarial and Rating system).

As a Tech lead holding the responsibility to ensure that the Capitation system is stable and mainframe Batch execution is smooth and efficient to ensure the successful delivery of the payment files to business without breaching SLAs.

Worked on various Mainframe Batch performance improvement activities and enhancements to the existing system

As a release manager ensure that all the Packages are in-line with the development covering all the elements and create e-form and get the necessary approvals and submit the ServiceNow change requests to promote the elements to production.

Share the weekly and Bi-weekly reports covering the application-level statistics with Cobol senior management at Capitation IT and Legato management.

Actively involved in the Cap LO implementation activities for monthly enterprise and off cycle releases from intake to production readiness and post Mainframe implementation support.

Worked on developing new IO routines to extract the data from IMS DB to use the files in Capitation where membership, Provider and plan details from various DB segments using various DLI functions.

Worked on delivering the audit documentations such as SoD (Segregation of Duties), Service ID password changes etc.

Testing Support from Cap LO on the application installations and upgrades along with IPL monthly activity.

Tech Mahindra/ Morgan Staley, Hyderabad, India. Jan 2018 – Dec 2019

Mainframe Tech Lead.

AIUT – Account inception and Update Tool helps financial advisors (FA) to incept an account from retail brokerage platform to AUM. FA’s can also update/change the level of services (LOS) or Manager, Risk tolerance, asset allocation across various portfolios’ etc.

Billing System: Helps to generate and track of the bills and generates various reports for MI. FA level reports such as Value pricing, discount sharing helps them to track their business AUM and compensations etc.

As a Technical lead Mainframe participated in supporting the business analysts in gathering elevated level and low-level requirements with Cobol.

Prepare estimates for budgets approvals.

Prepare high-level design document with all the changes needed in batch and online.

Worked on writing/modifying various DB2 stored procedures, Mainframe COBOL batch and online modules for the purpose of Account opening and financial advisors billing.

Guide and support the team by resolving functional, technical and design related queries.

Worked for Morgan Stanley in AUM - Wealth Management IT in Fee tracking application – which involves generation of various reports in billing system at FA and level, Value pricing, discount sharing.

Exponential Machines, Hyderabad, India. Apr 2017 – Oct 2017

Tech lead, Mainframe modernization.

Claims intake and workflow(CIW) is an entry point application for processing the claims which are submitted thru various channels by providers and members. Upon initial validation claims would further be sent to Claim processing system for adjudication and downstream processing. As part of the WGS modernization involved in exploring the various options to come up with POC’s to migrate to the new state of architect with technologies such as Java, Salesforce.

Gather high level business requirements deduce low level requirements and prepare BRD (Business requirement Documents) covering both functional and non-functional requirements.

Perform impact analysis and prepare Solution proposal and high-level design.

Guide and support the team by resolving functional, technical and design related queries Cobol.

On technical front Identify Customization Opportunities and design Custom Objects and various page layouts and integrate with existing legacy mainframe along Cobol systems.

Implementation of pick lists dependent pick list, look ups, Junction Object, MD relationships, validations, formula fields to the custom objects.

Possess comprehensive understanding of CRM, business processes like campaign management lead management, case management, workflow.

HSBC Software Development Pvt Ltd, Hyderabad, India. Feb 2008 – Mar 2017

Mainframe Developer/Systems Analyst/Tech Lead

CRM – Customer relationship management:

The objective of the CRM is to maintain a healthy relationship with customers by identifying and delivering their needs such that it can be profitable for both the parties. It enables the business to manage the sales process across multiple customer communication channels, from creation and distribution of sales leads to working of opportunities. SAMS contact and connect are integral parts of CRM.

SAMS Contact provides the functionality to deploy marketing, sales, and service customer contact strategy and to facilitate measurement of resultant activities. The bank users have used CMS Contact Management system to create, manage and execute sales campaigns and deliver the leads thru various delivery channels such as Power dealer, branch CCO lists and Internet Banking etc. CMS collects uses the data from SAMS databases which are in turn is collected from CDU or other external agencies sources periodically.

SAMS Connect, a browser-based Customer Profile System, workstation application that runs under the Browser Access Program (BAP) architecture. It involves hundreds of customer profile screens (hosted by Mainframes) to be used by users such as Relationship manager and other bank staff.

Customer Data Management (CDM): CDM (CDU) is a central repository for bank customer’s information. The customer information includes the demographics such as customer name, contact details, contact preferences, and thousands of the data elements that are captured on various account opening platforms and customer and staff channels. It interfaces with around 256 bank applications such as SAMS, RPS, WHIRL, Lipan, etc. which will use customer and product information thru access routines and Services built on COBOL and DB2. The updates on customer and product records are also notified/Streamd to the downstream systems thru change notification process in real time and batch using CICS and DB2 triggers.

Card Management and Decision System (CMDS): Receives the data from various systems such as Base 24, TRPR, and RPS and load the data into FOCUS data base. Used for generating the reports out of FOCUS on ATM transactions and ATM availability etc.

Worked on End to End implementation of various mainframe projects in CRM and CDM(customer Data management) from clear choice phase post implementation including preparation of design documents, reviews, coding and testing of various major mainframe projects, enhancements including Batch and Online applications using COBOL,JCL,DB2,CICS,FOCUS,VSAM, scheduling using OPC Control-M and CA7.

Worked on MKTIAS (Marketing Information and Analytics Systems) to generate various Flags, Scores, profiles based on various business rules in Base SAS using algorithms and scripts retrieving the data from mainframe NDM, sFTP connection.

Worked on generating various campaign reports at regional level for Management Information system(MIS) using SAS enterprise guide reporting tool.

Modified and enhanced COBOL Batch and Online CICS programs part of CMDS for generating various reports for ATM utilization, region wise fault or exception instances.

As a CRM Team lead conducting team meetings and preparing the project and application Dash boards, Resource management through WMT (Work management Tool), task allocations and maintaining project tracker and help and support team members in development and Production support(L2).

As a System analyst, involved in providing inputs for BRD, Clear choice preparation and prepared Requirement Traceability Matrix (RTM) and various levels of estimations.

As a Senior Software engineer Perform impact Analysis and prepare and come up with Solution proposal (HLD) documents create functional and/or technical design solutions covering the changes required. Apply specialist expertise in the development of IT systems with the objective of optimizing operational performance and improving quality whilst increasing cost-effectiveness.

Worked Scrum expert for RMP and Role player implementation projects on Mainframe.

Worked as a Business analyst on Earth and Moon Project, involved in stake holder analysis, Requirement gathering, Requirement elicitation and preparation and walk thru of Business Requirements Document (BRD) with high level and low-level requirements, prepared clear choice and Requirement traceability matrix and SPAD (Solution proposal and Architectural design) document collate the estimates from various teams and come up with a project plan and share with business for budget and approval.

Worked on Relationship Manager Platform (RMP) project and delivered a new tool based on mainframes for Lead management, Response and preference capture, and Service feedback functionality with front end as Java, back end as mainframe with middle layer MQ, R2DS.

Worked as Senior Mainframe application developer in building a new automated STP (Straight Thru Processing) Business Account Opening platform for HSBC Commercial Banking customers (Project Caspian).

Contact this candidate