Summary
Overview
Work History
Education
Skills
Accomplishments
Languages
Certification
Timeline
Generic

Raunak Kumar Singh

Richmond

Summary

Seasoned IT professional with 15 plus years of experience in Mainframe technologies. Extensive experience in application development, production support, leading teams in multi-vendor projects using mainframe and distributed systems, mainframe modernization and migrations of applications, data, and datacenters, mainframe operations, working on IT audits including SOC 2, SOX, DOI (Department of Insurance) audits, external audits with PWC and EY, cyber security audits, and remediation of findings, IT budgeting, forecasting, and planning. Domain expertise in insurance. Expertise in conceptualizing business problems, designing technical solutions using Mainframe technologies like COBOL, CICS, CICS Webservices for Mainframe (using XML, XSD, SOAP UI), DB2, IMS DB, and JCL. Extensive work experience with both online and batch environments. Hands-on experience with ETL tools like DataStage, Infogix, Oracle, Tableau, and their integration with mainframe systems. Experience with DevOps on the mainframe using CI/CD. On-field experience in issue-based consulting with government entities. Excellent analytical and communication skills for working with different teams, spread across various countries and time zones.

Overview

16
16
years of professional experience
1
1
Certification

Work History

Technical Team Lead

IBM (Client - Elevance Health Inc)
Richmond
07.2020 - Current
  • Responsible for interacting with the CarelonRx business team to understand the requirements for any modification or enhancement to the claims processing system.
  • Leading the mainframe application and operations team that maintains the existing legacy application code built on mainframe, AWS Hadoop, and Oracle systems.
  • Leading the mainframe modernization project, collaborating with the operations and application teams to implement DevOps for the mainframe applications, and migrating CA View to IBM Content Navigator, CA 7, Control-M, and Jobtrac scheduling tools to IBM Z Workload Scheduler.
  • Lead the project to migrate the mainframe source code from Endevor to GitLab.
  • Lead the IDz implementation for mainframe applications.
  • Lead the project to implement SSO (Single Sign-On), role-based access provisioning, and operational hygiene for the mainframe applications.
  • Implemented SSH password-less connections for the EFX (Sterling) and MGFT (Axway) connections across mainframe applications.
  • Work with PWC and EY for SOC 2 and SOX audits for the application and operations, remediate the findings of the audit for compliance, and work with the DOI (Department of Insurance) to support the audit on the application and operations. Provide evidence to prove compliance and work on the remediation of gaps found as part of the findings. Work with IBM internal auditors for the account audits targeted at finding the vulnerabilities, process gaps.
  • Support the application stability and seamless migration during the data center migration of the client’s on-premises data center to the IBM hybrid cloud data center.
  • Skills Used: Enterprise COBOL, JCL, DB2, IMS DB, Python, File Aid, QMF, VSAM, Infogix, MGFT (Axway), SFTP, EFX (Sterling), NDM, Enterprise Auditing (SOC 2, SOX, DOI, Cyber Security), OKTA, and Tableau.

Mainframe Team Lead

IBM (Client - Elevance Health Inc)
Richmond
05.2017 - 06.2020
  • Lead the team on the Mainframe data migration project for Elevance Health.
  • Coding the extraction programs in COBOL, embedded with SQL and IMS DLI calls, that read the DB2 and IMS databases on the legacy CS90 New York mainframe.
  • Coding the jobs in JCL (Job Control Language) using various sort cards to perform the transformations and filtering on the extracted data, according to the data mapping documents provided by the business team.
  • Coding the ETL jobs using IBM's Infosphere DataStage tool to perform various data transformations according to the data mapping documents, so that the data is usable on the new WGS Mainframe platform.
  • Develop the mapping specification document (STTM - Source to Target Mapping) as per the business needs.
  • Provide accurate transformation rules to be implemented, along with reference tables/files, etc.
  • Coding the COBOL and ETL Datastage scripts, programs, and jobs to perform the data integrity check on the legacy data being migrated to the new WGS system.
  • Coding the reverse extraction programs in COBOL, integrated with IMS and DB2 databases on the target WGS mainframe systems, which is loaded after the migration to check the data integrity of the loaded data.
  • Coding the audit and validation reporting jobs in the InfoSphere DataStage tool to report the success percentage of the data migrated from the legacy system to WGS, both on the record count level and field level across records.
  • Developing a secure file transfer system (EFX) for transferring files containing PHI (Personal Health Information) data between the legacy CS90 and the modern target WGS system.
  • Resolve production problems such as batch and online abends (abnormal end of job) on the mainframe, user queries, etc. Within the SLA (Service Level Agreement).
  • Skills Used: Enterprise COBOL, JCL, DB2, IMS DB, ETL Datastage, File Aid, QMF, VSAM.

Senior Mainframe Developer

IBM (Client - NASCO LLC)
Bangalore
10.2009 - 04.2017
  • NASCO is a US healthcare insurance IT solution provider that offers its claim processing system, along with other healthcare insurance products, to various healthcare insurance providers like BCBS of Elevance Health, BCBS of Horizon, and BCBS of Michigan, etc.
  • Worked on the EEC (Electronic Error Correction) application to expand the Procedure Code across the system, and the migration of the legacy system using pending VSAM files to DB2.
  • Migrate the green screens to use CICS web services and mid-tier.
  • I worked on creating four new CICS web services for BlueExchange on SOA, which were invoked by Mid-Tier, and designed the backend API that does the processing.
  • Analyzed the gap sheet provided by NASCO to create the actual requirements out of it.
  • This project included over 400 test cases to be unit tested by me.
  • Performance testing was done by the BA teams, and I worked on the optimization of the code based on the outcomes.
  • I was the single point of contact for the complex BlueExchange Member Lookup and Claim Lookup services, which I built based on SOA using web services.
  • Worked on modernizing the NASCO claims processing Front-End system, where Assembler code was converted to COBOL, componentized, and the application fragmented into individual services based on a SOA approach.
  • Worked on 200+ enhancement projects, which included changes to NASCO's Enrollment and Billing system, along with Membership systems.
  • Skills Used: Enterprise COBOL, Assembler, CICS, CICS Web Services, JCL, DB2, DB2 Stored Procedures, VSAM, QMF, SPUFI, SOAP UI, ECLIPSE.

Consultant

IBM (Corporate Service Corp)
Luanda
09.2013 - 10.2013
  • The Corporate Service Corps was launched in 2008 to help provide top-performing IBMers with high-quality leadership development while delivering high-quality problem-solving for communities and organizations in emerging markets.
  • Trained in performing issue-based consulting as part of pre-deployment training.
  • Trained on working in growth markets as part of Pre-Deployment Trainings.
  • Worked as a consultant for IBM, providing recommendations and solutions to its beneficiary, AIESPA, under the CSC assignment for developing an IT-based solution to establish national networks of institutions of higher education, and to establish and implement an Integrated Information System of Higher Education.
  • Provided the report with recommendations to AIESPA to create the desired framework.
  • The Corporate Service Corps was launched in 2008 to help provide top-performing IBMers with high-quality leadership development while delivering high-quality problem-solving for communities and organizations in emerging markets.

Education

Bachelor of Engineering - Telecommunication

BMS Institute of Technology
Bangalore, Karnataka, India
01.2009

Skills

  • COBOL
  • Assembler
  • C
  • Python
  • JCL
  • CICS
  • CICS Web Services
  • DB2
  • IMS
  • File-AID
  • SPUFI
  • QMF
  • File Manager
  • SOAP UI
  • Eclipse
  • Infogix
  • IBM DataStage
  • IBM Content Navigator
  • Service Manager
  • ServiceNow
  • Endevor
  • Changeman
  • Source Control Access Management
  • Gitlab
  • DevOps
  • NDM
  • sFTP
  • EFX (Sterling)
  • MGFT (Axway)
  • XPEDITOR
  • Debugger
  • Fault Analyzer
  • JIRA
  • JOBTRAC
  • CA7
  • Control-M
  • IBM Z Workload Scheduler
  • IDz
  • Waterfall and Agile
  • IT Auditing

Accomplishments

  • Account level Orion award for year 2012 and 2013 - Recognizing Eminence and Excellence for constant top performance for 3 years in Blue Exchange Project implementation.
  • Sector level Eminence and Excellence award 2012 for constant top performance for 3 years in healthcare industry.
  • Account service excellence award 2013 for excellent performance in NASCO account for year 2013.
  • Manager's choice awards for the year 2014 and 2015.
  • Top ratings for all the years in IBM.
  • Account service excellence award 2015 for excellent performance in NASCO account for year 2015.
  • Account service excellence award 2017 for excellent performance in Elevance Health account for year 2017.
  • Top onshore performer award for year 2018.
  • Star Performer for Finance and Accounting team award for 2020.
  • Manager's Cash award for handling the Elevance Health cloud data centre migration project.

Languages

English
Full Professional
Hindi
Full Professional
Kannada
Limited

Certification

  • Certified SAFe® 5 Scrum Master
  • Microsoft Certified: Azure Fundamentals

Timeline

Technical Team Lead

IBM (Client - Elevance Health Inc)
07.2020 - Current

Mainframe Team Lead

IBM (Client - Elevance Health Inc)
05.2017 - 06.2020

Consultant

IBM (Corporate Service Corp)
09.2013 - 10.2013

Senior Mainframe Developer

IBM (Client - NASCO LLC)
10.2009 - 04.2017

Bachelor of Engineering - Telecommunication

BMS Institute of Technology
Raunak Kumar Singh