Sumit Nandy
Mainframe Tech Lead COBOL Developer Medicare Eligibility-Enrollment Analyst
LinkedIn: https://www.linkedin.com/in/sumit-nandy-553b156/
Blog: https://medicareadvantage.home.blog/
SUMMARY
IT experiences of 13+ years as a Cobol Developer, 5+ years as a Mainframe Tech Lead.
Currently working as a Mainframe Lead/Developer and Medicare Eligibility/ Enrollment / Membership Analyst in Jefferson City, MO with Wipro for Blue Cross Blue Shield/MN, Independence Blue Cross, Highmark (product M360).
Extensively worked on batch – application development/enhancement/ maintenance and production support as a COBOL Developer, L2 Support SME and Technical Analyst.
Excellent knowledge of Medicare MA (Medicare Advantage), MAPD (MA Prescription Drugs), PDP (Standalone Prescription Drug), COST and Supplemental Plans.
HIPAA (Health Insurance Portability & Accountability Act), ‘CMS – Fraud Waste and Abuse’ (FWA) and ‘CMS – General Compliance’ trained and certified.
Worked as L2 Technical Support/SME with Home Retail group (Sainsbury’s) in Milton Keynes, United Kingdom. Have developed the entire backend of Stock Auditing system designing/ coding all the DB2 Stored procedures independently.
Developing applications by COBOL, JCL, DB2, DB2 Stored procedure, DB2 Triggers, VSAM, SAS, APS-COBOL, APS/CICS, and IMS/DB.
Worked with DBAs and have excellent knowledge of DB2 Database activities such as – LOAD, UNLOAD, IMAGECOPY, REORG, REPAIR, REBUILD RUNSTATS, and many other weekly maintenance activities.
Have experience of DB2 performance optimization/tuning (improved 95%).
Worked on tools/utilities – Changeman, Endevor, Panvalet, Expediter/Debugger, File-Aid/File-Manager, SORT, DumpMaster, SAR, Jobtrac, CA7; have basic knowledge in DWH & ETL.
Worked primarily in the domain of US Healthcare/Medicare and UK-Retail.
Awarded ‘Feather-In-My-Cap’, ‘Gyan-Guru’ for commitment to meet flawless delivery.
PERSONAL STRENGTHS:
oExcellent technical and analytical knowledge; dedicated, hardworking, self-motivated.
INTERESTS BESIDES WORK:
oBlogging, playing Guitar/performing at Open Mic, researching micro-cap companies.
TECHNCIAL SKILLS
Technology: IBM Mainframe
Programming Language: COBOL, JCL, SAS, APS
Database: IBM DB2, VSAM, DB2 Stored Procedure, IMS DB, TERADATA, ORACLE
Other Languages: C, C++, SQL
Tools & Utilities: File-aid, Endevor/Changeman, Expediter, Insync, DumpMaster, JOBTRAC, CA7
Domain Knowledge: US Healthcare (Medicare), Retail, Securities, Finance.
TRAININGS/CERTIFICATIONS
COBOL, JCL, MVS, DB2, VSAM, SAS, CICS.
Cognizant Certified Professional in COBOL, DB2 & Life Insurance
HIPAA (Health Insurance Portability & Accountability Act) trained and certified by Wipro Security and Compliance team.
‘Fraud Waste and Abuse’ (FWA) and ‘General Compliance’ trained and certified by CMS (Centre of Medicare and Medicaid services).
EDUCATIONAL QUALIFICATIONS
B-Tech in Computer Science & Engineering, JGEC (West Bengal University of Technology), 2006
PROJECT EXPERIENCE
Project #8 Mar’14 – Till Now
Project Title
Medicare-Support (US Health care)
Client
Blue Cross Blue Shield, Highmark Health and Independence Blue Cross
Role
Mainframe Technical Lead, Eligibility/Enrollment Analyst
Environment
OS-390
Programming Languages
COBOL, JCL, DB2 Stored procedure
Database
DB2, VSAM
Project:
At Infocrossing (a subsidiary of Wipro), we developed Memeber360 – a product/a single platform to Medicare eligibility verification, enrollment and membership management through transactions with CMS (US Federal Agency).
Health Insurance companies/Medicare sponsors use M360 platform to verify beneficiary eligibility, enroll applications/and then manage membership for their Medicare Advantage plans. We developed the product for Highmark Health then customized for Highmark partners such as Independence Blue Cross and BCBS/MN.
Responsibilities:
Developed and customized Memeber360 – a product/single platform to perform Medicare eligibility verification, enrollment and membership management through transactions with CMS (US Federal Agency, The Centers for Medicare & Medicaid Services).
Support the system/batch processing of enrollment/disenrollment application (COBOL/DB2/JCL,SQL,DB2 Stored Procedure) E2E that includes modules – Medicare Eligibility/Election period verification, Late-Enrollment and Low-Income subsidy derivation, Application RFI process, CMS correspondence letter generation and TRR run etc.
Developed independently the enrollment/disenrollment application verification, Election Type Code derivation/and verification and transaction generation modules.
Worked on SSNRI – replacing HICN with new MBI. Involved in design/development and testing of modules.
Worked on development and customization of the M360 product for new Customer – Blue Cross Blue Shield for Minnesota (Highmark partner), for its COST (CO/COPD) plans.
Working on regular activities such as Part C/D report generation, Auto and Facilitated enrollment process etc.
Support the batch application(and online interface developed in Java) of the product, working on on-call production support, new enhancements as per customer needs and CMS guidelines; and working on maintenance activities that involves resolving incidents, root cause analysis, big fixing.
Project #7 Apr’11 – Feb’14
Project Title
Argos Mainframe production Support (UK Retail)
Client
Home Retail Group, UK
Role
Onsite SME and Support Lead
Environment
OS-390
Programming Languages
COBOL, JCL, APS, DB2 Stored procedure, CICS
Database
DB2, VSAM
Project:
Home Retail Group (now a subsidiary of Sainsbury’s) is UK’s leading home and general merchandise, they sell products under brands – Argos and Homebase. As part of head office support, Wipro, in partnership with client teams, carries out current system maintenance, production support and minor enhancements for Argos mainframe applications.
Responsibilities:
Worked as an onsite coordinator/ SME/Application developer to maintain the Stock Transaction/ Balancing /Auditing system from client’s onshore location Milton Keynes, UK.
Worked on effective incident management and problem management to achieve 100% response and resolution SLA for all the incidents.
Worked on change requests, system enhancements, production support, overnight job failures and Proposing/implementing service improvements which involve requirement gathering, discussions and analyzing resolving incidents, root cause analysis, big fixing etc.(COBOL/DB2/JCL,SQL,DB2 Stored Procedure, VSAM).
Project #6 Jun’09 – Mar’11
Project Title
HRG - Mainframe Appl support
Client
Home Retail Group, UK
Role
Application Developer
Environment
OS-390
Programming Languages
COBOL, JCL, CICS
Database
DB2, VSAM
Project:
Home Retail Group is the UK’s (now a subsidiary of Sainsbury’s) leading home and general merchandise. We developed the Stock ledger application – restructuring the stock accounting, stock balancing and stock auditing system across all the locations/stores/warehouses.
Responsibilities:
Developed Stock transaction (from warehouse to stores) and Stock Balancing system by COBOL, JCL, VSAM and DB2.
Worked on complete software development cycle that includes business requirement, analysis, design, technical specification preparation, coding & unit testing; provided SIT and UAT support.
Developed Stock Auditing system, independently designed and developed application with DB2 stored procedures. All the Stored procedures in the system designed/developed by me.
Project #5 Sep’08 –May’09
Project Title
Casino Information Technology
Client
Groupe Casino, France
Role
Application Developer
Environment
OS-390
Programming Languages
COBOL, JCL
Database
DB2, VSAM
Project:
‘Groupe Casino’ is one of France’s leading food retailers, with more than 10,000 stores. Company operates different hypermarket and super market chains, as well as small inner-city retail stores. The MVS domain, that consists of more than 134 applications supported and maintained by Wipro production support team.
Responsibilities:
Worked on production support through batch (COBOL/DB2/JCL, SQL, and VSAM) monitoring and proving on-call support for job failures.
Worked on different work requests – minor enhancements and bug fixes.
Worked on change requests which include analysis, design, coding & unit testing.
Project #4 May’08 – Aug’08
Project Title
EIS – RR Application
Client
Wachovia Securities
Role
Application Developer
Environment
OS-390
Programming Languages
COBOL, JCL
Database
DB2, VSAM
Project:
Wachovia Securities is the third largest brokerage group and a leading corporate and investment bank in USA. They provide financial services, advice, and guidance to successful individuals, institutions, and corporations.
Responsibilities:
Worked L2 production support.
Worked on minor enhancements, change requests and bug fixes.
Project #3 Feb’08 – Mar’08
Project Title
Back Office Financial Systems – FDCS
Client
First Data
Role
Batch Support/Technical Analyst
Environment
OS-390
Programming Languages
COBOL, JCL
Database
VSAM
Project :
Back Office financial System involves with the background processing of merchant transactions starting from accumulation of merchant transactions from all sources, discount calculations, funding, settlement and statement generation.
Responsibilities:
Worked as an on-call batch support person.
Participated in analysis, design, coding, testing, implementation and documentation for minor enhancements and change requests.
Project # 2 Jun’07 – Jan’08
Project Title
Levi’s Offshore EDWARD Support
Client
Levi Strauss & Co.
Role
Developer – Programmer Analyst
Environment
OS-390,ETL Studio
Programming Languages
COBOL, JCL, SAS
Database
DB2, TERADATA
Project:
LEVIS is a 150-year-old Jeans manufacturing organization, privately held worldwide known American clothing company. Cognizant’s support team was responsible for production batch support and system maintenance activity on module EDWARD (Enterprise Data Warehouse And Report Distribution) deals with data warehouse part.
Responsibilities:
Worked on production support through jobs monitoring, provided on-call support for job failures.
Worked on enhancements includes analysis, design, coding & testing (COBOL/DB2/JCL, SQL, DB2 VSAM).
Project # 1 Oct’06 – May’07
Project Title
MetLife DIS Replatform
Client
New England Financials (MetLife Insurance)
Role
Developer – Programmer Analyst
Environment
OS-390,
Programming Languages
COBOL, JCL
Database
DB2, IMS
Project :
Cognizant development team were engaged in development of a database migration project from IMS to DB2, for NEF (New England Finance) – a subsidiary of MetLife. NEF sells Traditional and Non-traditional insurance products through the network of independent insurance agents.
Responsibilities:
Worked on database migration project, IMS to DB2, written re-platform COBOL program replacing IMS calls to equivalent DB2 sqls.
Worked on CUT, supported SIT and UAT.
Phone: +1-573-***-****
Mail: *****.*****@*****.***