Raveen Rachamallu
***************@*****.***
Summary
Overall 20+ years of total IT experience in Application Delivery, Application Development, Maintenance and support projects in fortune 100 companies
Roles performed as Technical lead, onshore offshore coordinator and Subject Matter Expert (SME) with domain expertise in Financial services, Healthcare, Transportation, Banking, and Insurance domains
Expertise on Requirement analysis, Estimations, On-site/off-shore project execution model, and customer interaction
Strong experience in Design, developing, debugging, maintaining and enhancing Application using Mainframe technology. My technology Forte is COBOL, JCL, VSAM, DB2, Easytrieve, ISPF, IBM Utilities etc
Exceeded client expectations in development of scalable Mainframe Applications
Clear understanding of business procedures and ability to work as an individual and as a part of a team
Excellent analytical, functional, design and development skills with excellent communication skills, both written and verbal
Very good Data migration experience of Database conversion projects using IDMS to DB2, DB2 to DB2 conversions.
Extensively worked on Financial services, healthcare, Transportation, Banking, and Insurance domains
Very experienced in gathering Requirements and analyzing technical impact.
Experience creating and executing the Unit Test cases.
Experience with tools like XPEDITOR, FILEAID, SPUFI, PLATINUM and QMF.
Hands-on Experience in creating Test plans, Test strategies, Test data.
Well versed in validating Test Plans to expected Test Results
Experience in Unit Testing, Integrated Testing, System Testing and User Acceptance Testing
Participated in daily meetings with the team, walkthroughs and defect tracking meetings
Developed preventive measures on recurring Incidents and batch abends.
Provided support for system testing and Implementation.
Very good knowledge of DB2 and writing SQL Queries using QMF/SPUFI.
Experience in using DB2 EXPLAIN to optimize the queries.
Interacting with Business users and preparing Technical Specification.
Experience in working on call24/7 Production support.
Restarting jobs within CA7 or via direct customer communication
ITIL V3 foundation certified from EXIM.
Skills Summary
Special Skills
Requirements Gathering,Analysis, Design, Estimations, coding & Testing
Team Management and Status reporting
Programming Languages:
VS Cobol II, Ideal, Stratus Cobol, JAVA
Databases
DB2,Datacom,IMS,IDMS
Operating Systems
MVS, Win NT/2000/95
Control Languages
JCL
OLTP
CICS
Version Control Tools
ENDEVOR, ISPW, GIT, Git Hub
Utilities
VSAM, ISPF/PDF, SMARTTEST,INSYNC, SPUFI, Advantage Gen
Tools
File-Aid, QMF, Xpeditor, Teradata SQL Assistant, MS Office, MS Visio,qTest, Service now, MQ
Educational
B.E in E.E.E from Madras University, Chennai.
Professional Experience
Mastercard, St. Louis, MO 12/2024 – Till Date.
Sr Consultant
Project Name: Global file transfer support.
Responsibilities:
Design and implement controls for proactive monitoring of critical file transfers to detect and report potential delays or issues.
Coordinate with global teams across Mastercard and facilitate onboarding to both Global File Transfer and NextGen File Transfer Platforms.
Collaborate with File Transfer Product and Engineering teams to provide product feedback and address issues in existing platforms.
Manage production and change activities to enhance customer experience and maximize application value.
Ensure high system availability, capacity, performance, Monitoring, self-healing, and deployment automation are implemented throughout the delivery process.
Develop and execute SQL queries using Oracle SQL Developer (v23.1), PgAdmin (PostgreSQL), and IBM QMF for DB2 for reporting and troubleshooting file transfer issues.
Technical Environment: COBOL, JCL, ENDEVOR, DB2, VSAM, MVS, SPUFI, File Manager.
Edward Jones, St. Louis, MO 10/2016 – 12/2024.
Sr Programmer Analyst
Project Name: Request Respond & SRV Support, IDMS to DB2 Conversion.
Portfolio Support & OAG Data Conversion
Responsibilities:
Involved in discussions with business users and perform requirements gathering
Analyzed existing Cobol online and batch modules to create current state system diagram, and system documentation for RRD system
Created a new user validation module to be used in 800 + Batch/Online programs.
Converted RRD batch and online programs from current IDMS to new DB2 database.
Designed and created new CTG modules to feed the data to message center application.
Designed and migrated data for outside assets initiative for portfolio application Migrated (Db2 to Db2)
Support and maintenance of RRD system
Designing and developing the Batch COBOL Db2, IDMS Module to process the operations in the Db2 Tables.
Designing and developing the Cobol CICS programs to transfer the data between the online modules using
the MQ, TSQ, TDQ and Channels and containers.
Working as Mainframe programmer to support all the modules of the Portfolio Application
Preparing the unit test cases and created the test plan documents.
Working on the Clone testing SIT and UAT Defect and provide the Resolution.
Preparing the implementation plan and the post implementation validation docs.
Working on the production incident and provided the resolution to meet the SLA.
Designing and developing the Batch and Online programs using the COBOL Language.
Designing and developing the Batch COBOL Db2, IDMS Module to process the operations in the Db2 Tables.
Designing and developing the Cobol CICS programs to transfer the data between the online modules using the MQ, TSQ, TDQ and Channels and containers.
Designing and developing many CICS BMS screens to display the details from the VSAM Files and Tables.
Created Requirement Traceability Matrix to track the completeness of given requirements
Technical Environment: COBOL, JCL, ENDEVOR, DB2, VSAM, MVS, SPUFI, File Master, ISPW, SFTP.
Express Scripts, St. Louis, MO 01/2015 to10/2016
Tech Lead & Offshore Coordinator
Project Name: Phoenix Development
Involved in workshops with business users and perform requirements gathering.
Developed functional and technical specification documents
Provided effort estimates to the project management team
Involved in data model creation
Responsible for status tracking, identifying risks and issues, presenting the same to project management team on daily basis
Conducted review meetings on deliverables and obtaining approvals from Client team
Prepared High Level and Low Level design as per Requirements and presented them to client team
Establish off-shore team and trained them on the functionalities
Created check lists for the deliverables
Co-ordination with QA team for SIT and UAT testing, present the test results to Business team
Continual interaction with the stake holders to understand the issues and to provide workarounds / permanent fixes
Developed components for POD ( Proof of Design) during HLD phase
Created Requirement Traceability Matrix to track the completeness of given requirements
Technical Environment: COBOL, JCL, ENDEVOR, DB2, VSAM, MVS, SPUFI, File Master, MS Visio, Oracle
Express Scripts, St. Louis, MO 08/2010 to 12/2014
Team Leader
Project Name: Workers Comp maintenance
Traveled to onshore for KT. Built the offshore team.
Responsible for Requirement gathering for the enhancement requested by Client.
Co-ordination with team and client effectively.
Conducting status meetings on weekly and need basis.
Clarifications to technical and functional queries posed by team.
Interacting with client to understand and analyze the requirements (CR).
Preparing technical specifications.
Writing queries using DBQ to extract data from various VSAM files reporting purpose
Technical Environment: Stratus Cobol, Files, Command macros, Forms,VOS
Royal Bank of Canada, Canada 03/2010 to 08/2010
Team Leader
Project Name: GRADS maintenance
Knowledge acquisition from Onsite
Interacted with client to understand and analyze the requirements (SCR).
Prepared Understanding document and high level estimates
Helped team members in developing and testing.
Coordinate the System Integration Testing and Sign-off.
Technical Environment: Cobol, DB2, MVS, Windows – XP, SPUFI, File Aid, Endevor
Legal and General, Red hills, UK
Developer 06/2007 to 03/2010
Project Name: FPF Application Support
ADF to COBOL Conversion
Knowledge acquisition from SMEs and preparing System Design Documents.
Resolution of production problems within Service Level Agreements (SLAs) defined, and ensure system availability
Onsite-Offshore co-ordination
Continual interaction with the stake holders to understand the issues and to provide workarounds / permanent fixes
Technical Environment: Cobol, DB2, IMS DB/DC, MVS, Windows – XP, SPUFI, File Manager, Endevor, QMF, DOC Direct, Debug
Canadian Imperial Bank of Commerce, Toronto, Canada 10/2006 to 06/2007
Developer
Project Name: Co-Borrower Implementation
Interaction with client and understand/Analysis the requirement.
Analyze/Review the business objective and functional requirement and prepare the estimates.
Identify and design the changes to all the impacted systems
Prepare the project plan and Build the changes.
System Integration Testing.
Technical Environment: MVS, Windows – XP, Advantage Gen, JCL,DB2,GDF, SPUFI,File Aid
AXA Insurance, Lytham, U.K 08/2005 to 10/2006
Developer
Project Name: SOLUS
Requirements gathering and documenting
Interaction with client and understand/Analysis the functional requirement.
Building technical specifications.
Attending review meetings.
Offshore coordination and knowledge sharing.
Developed POLARIS interface, which was core for projects success.
Technical Environment: MVS, Windows – XP, COBOL, IDEAL, DATACOM
Panalpina Management Ltd., Basle, Switzerland 05/2004 to 08/2005
Developer
Project Name: FOS Application Maintenance
Involved in requirement gathering from the business users.
Involved in the documenting HLD and DLD.
Prepared Low level design for AE modules.
Developed Data validation module.
Was responsible for peer reviewing the modules.
Create Unit test case document and perform unit testing.
Technical Environment: Unix, Windows – 2000, OCL, COBOL, Message members, Format files, OPEN RS