Santhosh Keesari
Cell: +1-904-***-**** Email: *.******@*****.***
12+ years of professional experience in Designing and Development of Enterprise level applications (in Waterfall, Agile Methodologies) using Mainframe and Oracle Applications in Transportation; some of them are highly coupled with Federal Railroad Administration (FRA) regulations involving both Operations and Billing systems.
Expertise:
Design development of projects involving application development, migrations, and additions to existing applications using Mainframe Technologies.
Mainframe: Working experience with CICS, JCL, DB2, IMS, SERENA CHANGEMAN, File Manager, Toad Data point, IBM DEBUG TOOL, CA Tool.
Developed Mainframe programs to read the Oracle data using the new IBM Distributed Relational Database Architecture (DRDA) communications.
Developed new Oracle stored procedures to read the DB2 data using the IBM Distributed Relational Database Architecture (DRDA) communications.
Developed new DB2 stored procedures to communicate with UI using the MQ services provided by the Integrated Service team.
Backend: Over 12 years of Experience with IMS, DB2 and 7 years of Experience with PL/SQL.
Oracle R12 Apps Financials: Working experience with Oracle forms, reports using BPA (Bill Presentment Architecture) and XML technologies.
Troubleshooting and other issues in environments like Dev, UAT, & Prod and identifying performance bottlenecks using IBM CA Tool.
Utilized JIRA as virtual Agile/Scrum board for defect tracking/work assignments. Utilized CHANGEMAN as version control.
Expertise to use ISPF/PDF, TSO, File-Aid, File-Manager, MQMon, PQEDIT, IBM DATA Studio Utilities and Command Languages.
Utilized Quality Center as defect tracking tool.
Handled Ad-hoc Queries using Toad for DATA point/QMF.
Experienced in all phases of Software Development Life cycle (SDLC) • Requirements Gathering, Functional gap analysis, Construction, Unit Testing, and Support to various Testing techniques - Integration, Quality Assurance (QA) Test, User Acceptance (UAT) Test, Regression Test, and Production support.
Developed new and modified existing CICS maps to accommodate new business rules using GTB.
Learning the new DB2 Native Stored procedures.
Expertise in understanding the Electronic Data Interchange (EDI) formats for Railroads.
Strong analytical and problem solving skills.
Railroad experience dealing with TE&Y.
Education:
1)Bachelor's degree in Computer Science
2)Diploma in Computer Science
Working Status/Authorization: H1B visa with I-140 approved
PROFESSIONAL EXPERIENCE
Client : CSX Transportation FL, USA Feb 2015 –Till Date
Role : Tech Lead/Senior Developer Consultancy Company :NTT DATA INC
Design & Development of HOURS OF Service application for CSX Transportation Trainee and Engineers. This application mainly deals with capturing Total time on duty, Limbo hours, Exclusive hours, STARTS, Total hours reported within a month. The application was developed using Mainframe technologies like MVS, COBOL, CICS, IMS, DB2, JSF 2.0, Primefaces, Web Services, Oracle, MQServcies with Agile development methodologies (uses JIRA board).
Responsibilities
Participated in Requirement Gathering.
Prepared the Business requirement document.
Prepared functional specification document.
Provided inputs to the UX team.
Developed new DB2 stored procedures to communicate with UI using the MQ services provided by the Integrated Service team.
Developed new Oracle stored procedures.
Innovative approach reduced the Risk to switch on the secondary sources when the primary method is down due to miscellaneous reasons.
Developed Mainframe programs to read the Oracle data using the new IBM Distributed Relational Database Architecture (DRDA) communications.
Developed new Oracle stored procedures to read the DB2 data using the IBM Distributed Relational Database Architecture (DRDA) communications.
Developed new and modified existing CICS programs to communicate with UI using the MQ services provided by the Integrated Service team.
Modified the existing JCL’s to communicate with UI using the MQ services provided by the Integrated Service team.
Lead a team of 5 involving Mainframe/Java/Oracle programmers/Testers.
Tested Software to meet the requirements that guided its design and development and verify response of the application to all kinds of inputs.
Trouble shoot the issues addressed using the IBM Debugger and Integrated service logs.
Responsible for Production Releases, Troubleshoot & Addressing performance issues when it’s my turn (we follow Agile 2-week iteration cycles)
Utilized JIRA as virtual Agile/Scrum board for defect tracking/work assignments. Utilized CHANGEMAN as version control.
Coordinated with Different team involving Payroll, TECS system supported by PSTechnologies.
Client : CSX Transportation FL, USA Sept 2014 – Feb 2015
Role : Senior Developer Consultancy Company :NTT DATA INC
Design & Development of a Backup Onduty time project for CSX Transportation Trainee and Engineers. Project deals to capture the data of all the employees who backup their onduty time and also captures answers to the questionnaire presented to employee to understand the reasons for backing up onduty time. The application was developed using Mainframe technologies such as Involved in Design & Development of a Backup On duty for CSX Transportation Trainee and Engineers. Project deals to capture the data of all the employees who backup their onduty time and also captures answers to the questionnaire presented to employee to understand the reasons for backing up onduty time. The application was developed using Mainframe technologies such as MVS, COBOL, CICS, IMS, DB2 with Waterfall development methodologies.
Responsibilities
Developed new and modified existing CICS programs to capture the ONDUTY BACK UP TIME and also captures answers to the questionnaire presented to employee.
Developed DB2 stored procedures and JCL’s to prepare the prepare reports.
Tested Software to meet the requirements that guided its design and development and verify response of the application to all kinds of inputs.
Trouble shoot the issues addressed using the IBM Debugger.
Utilized CHANGEMAN as version control & Quality Center as defect tracking tool.
Client : CSX Transportation FL, USA Aug 2013 – Sept 2014
Role : Tech Lead/Senior Developer Consultancy Company :NTT DATA INC
Design & Development of Computing STARTS Project for CSX Transportation Trainee and Engineers. Project deals to modify the STARTS and RSA rest provided to the employee based on the new Federal Railroad Administration (FRA) regulations. The application was developed using Mainframe technologies such as MVS, COBOL, CICS, IMS, DB2 with Waterfall development methodologies.
Participated in Requirement Gathering collaborating with business to understand Federal Railroad Administration changes on employee STARTS and REST assignment.
Provided detailed impact analysis with the new proposed changes to STARTs and REST assignment of employee.
Prepared the Business requirement document covering changes to the system and its impacted systems.
Designed the new process of calculation as per the new regulations provided by Federal Railroad Administration.
Developed new and modified existing CICS programs to capture the ONDUTY BACK UP TIME and also captures answers to the questionnaire presented to employee.
Developed DB2 stored procedures and JCL’s to prepare the prepare reports.
Tested Software to meet the requirements that guided its design and development and verify response of the application to all kinds of inputs.
Trouble shoot the issues addressed using the IBM Debugger.
Utilized CHANGEMAN as version control & Quality Center as defect tracking tool.
Lead the team, Coordinated with other groups for integration Testing/Implementation.
Client : CSX Transportation FL, USA Jan 2013 – Aug 2013
Role : Senior Developer Consultancy Company :NTT DATA INC
Design and Development of Hours of Service Report project for CSX Transportation Trainee and Engineers. Project deals to create new monitoring reports and FRA Inspector Screen.
These monitoring reports are used to keep track of the tickets that have potential violations as per the FRA regulations.
FRA inspector uses the screen to verify the employee day to day activities on CSX property.
The application was developed using Mainframe technologies such as MVS, COBOL, CICS, IMS, and DB2 with Waterfall development methodologies.
Responsibilities
Involved in providing inputs for UX design.
Developed DB2 stored procedures.
Tested Software to meet the requirements that guided its design and development and verify response of the application to all kinds of inputs.
Trouble shoot the issues addressed using the IBM Debugger.
Utilized CHANGEMAN as version control & Quality Center as defect tracking tool.
Client : CSX Transportation FL, USA Feb 2012 – Till Jan 2013
Role : Tech Lead/ Senior Developer Consultancy Company :NTT DATA INC
Involved in Design and Development to add a new level of Users to ShipCSX. ShipCSX tools help CSX customers to plan, ship, trace and pay for your shipments quickly and efficiently.
Project deals to add new level of User called Xgate. Project involves successful registration, adding default tokens, verification of confirmation code etc.
The application was developed using Mainframe technologies such as MVS, COBOL, CICS, IMS, DB2 and JSF 2.0 with Waterfall development methodologies
Involved in providing inputs for UX design.
Analyzed and provided the detail list of applications and programs that are impacted with the new User type.
Analyzed the existing system to provide detailed information on default tokens currently provided to a user.
Innovative approach reduced the duplication of effort for each time new user type.
Developed DB2 stored procedures and Mainframe CICS programs.
Tested Software to meet the requirements that guided its design and development and verify response of the application to all kinds of inputs.
Trouble shoot the issues addressed using the IBM Debugger.
Utilized CHANGEMAN as version control & Quality Center as defect tracking tool.
Client : CSX Transportation FL, USA Mar 2011 – Till Feb 2012
Role : Developer Consultancy Company :NTT DATA INC
This project involves preparing reports/Forms for Waybilling Module. The application was developed using Oracle R12 Apps Financials and PL/SQL.
Responsibilities
Requirements gathering, Business and user groups interaction
Technical support for production issues
Developed few reports using BPA and XML technologies.
Developed Oracle forms.
Provided solutions with quick analysis for performance related issues.
Developed Oracle Stored procedures.
Client : CSX Transportation FL, USA April 2005 – Till Mar 2011
Role : Team Lead/Sr. Developer/Onsite Coordinator
Design and Development of multiple projects for Way billing system. The system includes 3 tier-1 modules
Automated Way billing System (AWS): The AWS system is a part of the Centralized Transportation Management System. The purpose of the system is to create/maintain waybill information for every consignment that is transported by CSX. Waybills are informational records representing transportation of commodities and other related events.
Bill of Lading (BOL) & Interline Received Data Exchange (IRDE): The BOL & IRDE systems are part of the Centralized Transportation Management System. The BOL system processes all the waybill data coming from customers into CSXT via EDI. The IRDE system processes the entire waybill data coming from other railroads (interline traffic) into CSXT via EDI and to perform interchanges of the rail traffic. These systems provide the status of freight movements to customers & foreign railroads.
COPS REPLICATION SYSTEM: This is a system known as CUSTOMER ORIENTED PROCESSING REPLICATION SYSTEM. The way billing information is stored in both uses oracle and mainframe (IMS and DB2). CUSTOMER ORIENTED PROCESSING SYSTEM developed in power builder uses oracle as backend and Mainframe uses IMS and DB2 databases to store the waybill information. COPs Replication system ensures that both to keep both of them in sync.
Responsibilities
Requirements gathering, Business and user groups interaction.
Executed major enhancements in all the above areas involving EDI upgrades/waybilling system upgrades handling business rules around hazardous and non-hazardous commodities. Involved in developing new process flows and new business application systems.
Utilized the offshore team effectively by prioritizing the tasks in meeting the service level agreements.
Handled ‘business issue’ coordination with business partners and also entire user interaction.
Provided production support on ‘round-the-clock’ basis.
Communicating with the onsite personnel at Jacksonville, USA for analysis and implementation of Work Requests.
Executing Work requests which involve analysis, coding, testing implementation, and documentation.
Training new resources.
Generating weekly and monthly reports and summary statistics of the Performance of the module.
To provide technical help where necessary for execution and monitor progress on daily basis.
Guide the team to work towards satisfying all customer requests by ensuring smooth and effective communication.
Developed new and modified existing CICS programs/ DB2 stored procedures/Batch COBOL programs and JCL’s.
Developed new and modified existing CICS maps to accommodate new business rules using GTB