Uploaded File
Shravan
shravanr1990@gmail.com
shravanr1990@gmail.com
501-316-8417
15000 Chenal Parkway APT : H107
Little Rock, AR 72211
Project Delivery Senior Analyst (Senior Mainframe and DB2 SQL De
10 years experience W2
1
Recommendation
Average rating
43
Profile views
Summary

  • An accomplished Senior Software professional with 8 years of experience on Mainframe and DB2 SQL Technologies, specialized in Legacy Modernization initiatives such as Re
  • Engineering, Re-hosting, Data Migration, Legacy Code Assessment and Consulting.
  • Extensive experience in all phases of Software Development Life Cycle (SDLC) including design, development, enhancement, migration and testing of applications using COBOL, JCL, DB2, VSAM, CICS, TSO/ISPF, Expeditor, DB2, IMS DB, UNIX, C, SQL, PROC's, CA7 etc.
  • Proficient in gathering Business Requirements, functional and technical specifications and preparing high level and low-level detail design (HTD and LTDs).
  • Strong experience in relational database DB2 SQL. Expert in coding DDL/DML/DQL for retrieving and manipulating database tables using query management and reporting tools like SPUFI, DB2 FILE-AID, DBeaver and Microsoft SQL Server Management Studio for data manipulation and data cleansing.
  • Strong knowledge about normalization, DB2 stored procedures, functions, Cursors, Triggers, Views, Correlated Subquery and Subquery etc.
  • Good exposure to version control systems like CHANGEMEN, LCM and ENDEAVOR.
  • Proficient in IBM utilities and Tools including ABEND-AID, SYNCSORT, IEBGENER, IEFBR14, IEBCOMPR and IDCAMS.

Experience
COBOL Developer
Information Technology
May 2017 - present
  • Worked on analyzing Inter-plan Teleprocessing System (ITS) modules.
  • Inter-Plan Teleprocessing Services is the Blue Cross Blue Shield Association-mandated product used to facilitate the movement of out-of-area claims data between Plans.
  • Acquired good functional knowledge on ITS.
  • Analysis of existing WGS system with a focus on mapper, edit loop, adjudication, and finalization.
  • Created detail technical specifications.
  • Worked on WGS to ACES and CS90 field-to-field mapping analysis.
  • Participated in Technical Deep Dive Sessions with Anthem SMEs to define the requirements of various stages of claims processing.
  • Extensive experience in COBOL, JCL, DB2, IMS DB, VSAM, CICS, IDCAMS, QC, CHANGEMAN, XPEDITER, DFSORT, SYNCSORT
Cobol DB2 CICS CHANGEMAN IMS JCL SYNCSORT VSAM XPEDITOR Analysis
Remove Skill
References
Average Rating

1 recommendation
Project Delivery Senior Analyst (Senior Mainframe and DB2 SQL Developer)
Information Technology
Oct 2020 - present
Deloitte Consulting LLP DHS ISS Project Delivery Senior Analyst (Senior Mainframe and DB2 SQL Developer) Project Name: State of Arkansas Department of Human Services
DB2 SQL SQL Developer
Remove Skill
Mainframe Developer (Contractor at Wipro)
Information Technology
Dec 2017 - Feb 2018
Vendor AIC Talent Solutions (ACS Group) Mainframe Developer (Contractor at Wipro) Project Name: Member360 Description: Member360 is a Comprehensive Membership Management System. A member's Medicare eligibility is verified using the Centers for Medicare and Medicaid (CMS) Medicare Beneficiary Database (MBD) as applications are entered either by batch or online. During the verification process, CMS member-specific data such as ESRD, Medicare eligibility dates, LIS, and LIC are automatically added to Member360. Responsibilities:
  • Worked on day-to-day tickets for updating new/existing customers related data changes in backend Mainframe DB2 tables as requested by various clients like Excellus, Sharp, Imperial etc.
  • Worked on SSNRI (Social Security Number Removal Initiative) COBOL code changes, a new solution of replacing SSN-base Health Insurance Claim Number (HICN) with Medicare Beneficiary Identifier (MBI), proposed by Centers for Medicare and Medicaid Services (CMS).
  • Worked on INSYNC, a utility which assists to manipulate Mainframe DB2 tables.
  • Worked on SAR, Endeavor and SPUFI.
  • Worked on coding various Jobs and Proc's for generating Invoices, billing and payment reports.
SPUFI
Remove Skill
COBOL Programmer (Contractor at Deloitte)
Information Technology
May 2017 - Sep 2017
Cobol
Remove Skill
Software Engineer (System Analyst)
Information Technology
Apr 2015 - Dec 2015
Software Development India Pvt Ltd Software Engineer (System Analyst)
Software Engineer
Remove Skill
Information Technology
Nov 2014 - Apr 2015
Customer Data Management (CDM) project plays a crucial role in HSBC UK region. CDM is the main repository of customer data of UK region. It stores UK customer data and associated account and product details. CDM system provides customer details to different systems, when requested. CDM system handles a huge amount of data transactions very efficiently. Responsibilities:
  • Involved in Clear Choice Discussions with Business to understand the requirements and involved in getting the sign off on requirements from Business team.
  • Involved in Database Requirement Analysis for the project and created Technical specifications.
  • Analysis was more on data storage and data transmission to other systems in huge amounts from CDM Database.
  • Involved in preparing the technical design documents (which helped developers in writing COBOL codes and JCL's) and carrying out walk-through meetings with the IT & Business managers.
  • Worked with various business teams in gathering the Requirements following agile methodology.
  • Facilitate meetings within team members, with other project team members in providing clarification on technical requirements, conduct root cause analysis and give optimal code fixes.
  • Involved in preparing functional specification, technical specification, program specification, estimates and other design documents.
  • Assign technical work tasks to team members and monitoring their progress.
  • Ensuring project milestone for technical deliverables are met and reviewing various COBOL, JCL, DB2 deliverables produced by team members.
  • Played a crucial role as analyst in CDM project in taking decisions while importing data into HDFS system (Hadoop) from Mainframe DB2 tables using Sqoop concept.
  • Have a strong functional knowledge on CDM system.
No skills were added
Remove Skill
Software Engineer (Mainframe and COGNOS Developer)
Information Technology
Aug 2012 - Nov 2014
Software Development India Pvt Ltd Software Engineer (Mainframe and COGNOS Developer) Project Name: HSBC Core Banking Description: HSBC Core Banking (HCB) project was mainly about migration of the entire HSBC banking software product from AS400 platform to Mainframe platform. As part of this project many enhancements were introduced in the HSBC banking system. HCB project was part of Retail Banking and Wealth Management (RBWM) Business Unit. Responsibilities:
  • Involved in full project life cycle involving Requirement, Analysis, Design, Coding, Testing and Implementation phases.
  • Coded COBOL and COBOL DB2 programs and tested them thoroughly.
  • Modified and tested COBOL, CICS programs and JCL codes as per the requests of business departments.
  • Involved in preparing test cases and performing UAT activities.
  • Used Endeavor to create, stage, and deploy COBOL packages in to testing and production regions.
  • Monitoring the Error events and resolving them.
  • Involved in preparing Program Specifications, Unit Test Plans and Unit Test Results. Ensuring compliance to the Quality Standards.
  • Have a good functional knowledge on various banking products like Term deposit products, saving account products, Current account products etc.
  • Developed reports using Business Intelligence COGNOS reporting tool, which helped in making better business decisions.
  • Worked on ENDEVOR, COBOL, JCL, DB2, CICS, TSO, ISPF, ABEND-AID, File-Aid, SPUFI, XPEDITER, PROC's and SYNCSORT etc.
  • Developed simulator modules using Java and J2EE in testing region for testing backend COBOL modules, which work like front-end applications in production region.
  • Worked on DB2 to create tables, store, and alter data in them. Involved in design of new DB2 stored procedures. Increased the system performance by 20% by fine tuning SQL queries.
DB2 J2EE Java Software Engineer SQL
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Computer Science
University of Central Missouri 2016
JNTUH, India
CVSR College of Engineering
Certifications
HSBC certified Mainframe Software Engineer
Skills
DB2
2022
9
Analysis
2022
5
CHANGEMAN
2022
5
CICS
2022
5
Cobol
2022
5
IMS
2022
5
JCL
2022
5
SYNCSORT
2022
5
VSAM
2022
5
XPEDITOR
2022
5
SQL
2022
4
J2EE
2014
2
Java
2014
2
Software Engineer
2015
2
SQL Developer
2022
2
Business Intelligence
2014
1
Cognos
2014
1
SPUFI
2018
1
ABENDAID
0
1
Agile Methodology
2015
1
C
0
1
Data Migration
0
1
File-Aid
0
1
FTP
0
1
Hadoop
2015
1
HDFS
2015
1
SQL Server
0
1
Sqoop
2015
1
Stored Procedure
0
1
System Analysis
2015
1
Triggers
0
1
TSO/ISPF
0
1