RESUME

Ramesh Mari

Phone: +1-313-***-****

E-Mail: adxapf@r.postjobfree.com

Experience Summary:

Having 17.10 Years of experience in IT which includes development and support experience in mainframe enterprise computing using IBM Main Frames MVS, COBOL, JCL, DB2, VSAM, IMS-DB/DC, CICS, Teradata and Business object. Currently working as a Sr. Software Developer at Megan Soft Inc and working in client location. Having very good functional knowledge on Healthcare, Retail, Telecom and Automotive.

Educational Qualification:

B.E. (Electrical and Electronics Engineering) from Md. Sathak Engg College, Kilakarai, Madurai Kamaraj University in the year of April 2002.

Certifications:

ITIL V3 certified.

IBM DB2 certified.

Professional Experience

Working as a Sr. Software Developer at Megan Soft Inc, Michigan, USA from June 13, 2022 to Till Date.

Working as Technical Consultant in Tech Mahindra Americas Inc, Michigan, USA from Oct 2018 to June 10, 2022.

Worked as Tech Specialist in Tech Mahindra Ltd, India from May 2008 to Sept 2018.

Worked as a Senior Consultant in Capgemini Consulting India Pvt Ltd, India from June 2007 to May 2008.

Worked as a software engineer in GalaxE solutions Pvt Ltd (IBM), India from June 2005 to May 2007.

Technical Expertise:

DBA Skills

Databases : DB2 (DB-Admin tool, FM/DB2, BMC), ETL tool, SAP Power Designer/BO

Mainframe Skills

Operating System : MVS, Windows, UNIX.

Programming Languages : COBOL, PL1 and JCL

Database :TERADATA, DB2, IMS DB/DC, Business Object

On-line : CICS

Tools : VSAM, FILEAID, FILE-MANAGER, IBM DEBUGGER, TELON, CHGMAN, ENDEVOR, XPEDITOR, CA-7, REXX, CLIST, DB ADMINISTRATOR, SPUFI, QMF, ZOS Connect API tool

Project and client details:

Client : Ford Motor Company, USA

Organization : Megan Soft Inc, Michigan, USA

Technologies : Mainframe, Java, Business Object

Role : Sr. Software Developer

Team size : 10

Duration : 13 June 2022 – Till date

About Client

The Ford Motor Company (commonly referred to simply as "Ford") is an American multinational automaker headquartered in Dearborn, Michigan, a suburb of Detroit. It was founded and incorporated on June 16, 1903. Ford Motor Company does the ITO, IT AD and AM, Enterprise and Emerging, Business IT and Office of the CIO (OCIO). Ford Motor Company has large Operations management team especially for Data and system maintenance in order to secure the data and company asset.

Project # 1

ESPARS/ESPS:

The Extended Service Plan Analysis & Reporting System (ESPARS) is a SOX critical application which supports the ESP business through Sales & Marketing reporting, calculation of Incentive/Bonus payments, Pricing Analysis, Financial Analysis and the production of month end journal entry input figures and reconciliations. System also supports Ford Credit Insurance operations with the preparation of quarterly and year end income statements for reinsurance / retrospective agreement companies. ESPARS is a data-warehousing environment uses Teradata tables that are loaded from multiple source applications on the Facility C (mainframe).

Extended Service Plan System (ESPS) is an on-line computer system used to support the administration of the Ford Extended Service Plan (ESP). The ESP coverage offers protection against high repair costs after a vehicle is out of its manufacturer warranty period. Dealers sell the ESP product to retail customers. Most sales are from retail customers and often the contract is purchased at the same time they buy the vehicle. Fleets also purchase coverage for their company cars (e.g., Hertz). This application provides for the processing and maintenance of a significant volume of high margin revenue sales for the Ford Customer Service Division.

Roles and Responsibilities as Sr. Software Engineer

Prepare design document for Project enhancements or system software upgrade.

Analyze and debug the program to determine the issue and resolve them within the SLA.

Review the open tickets with business and IT to work on those tickets based on the priority.

Follow the AGILE process to plan and work on each user story and complete them within the Iterations.

Follow Ford control process and involve in control testing twice a year to make sure the system is in control as per S-Ox process.

Involved in Data model process for decommissioning obsolete tables or creating new tables in Teradata.

Involved in Teradata development and Reporting.

Involved in integration testing with Java screens and debug the issue

Support for migration project.

Support for Business object projects

Involved in Migration project from legacy to emerging technologies.

Involved in API testing for mainframe to Web UI online screen migration.

Client : Ford Motor Company, USA

Organization : Tech Mahindra ltd/Tech Mahindra Americas Inc

Technologies : Mainframe

Role : Technical Consultant

Team size : 10

Duration : Dec 2011 – June 2022

About Client

The Ford Motor Company (commonly referred to simply as "Ford") is an American multinational automaker headquartered in Dearborn, Michigan, a suburb of Detroit. It was founded and incorporated on June 16, 1903. Ford Motor Company does the ITO, IT AD and AM, Enterprise and Emerging, Business IT and Office of the CIO (OCIO). Ford Motor Company has large Operations management team especially for Data and system maintenance in order to secure the data and company asset.

Project # 1

ESPARS/ESPS:

The Extended Service Plan Analysis & Reporting System (ESPARS) is a SOX critical application which supports the ESP business through Sales & Marketing reporting, calculation of Incentive/Bonus payments, Pricing Analysis, Financial Analysis and the production of month end journal entry input figures and reconciliations. System also supports Ford Credit Insurance operations with the preparation of quarterly and year end income statements for reinsurance / retrospective agreement companies. ESPARS is a data-warehousing environment uses Teradata tables that are loaded from multiple source applications on the Facility C (mainframe).

Extended Service Plan System (ESPS) is an on-line computer system used to support the administration of the Ford Extended Service Plan (ESP). The ESP coverage offers protection against high repair costs after a vehicle is out of its manufacturer warranty period. Dealers sell the ESP product to retail customers. Most sales are from retail customers and often the contract is purchased at the same time they buy the vehicle. Fleets also purchase coverage for their company cars (e.g., Hertz). This application provides for the processing and maintenance of a significant volume of high margin revenue sales for the Ford Customer Service Division.

ePCW (Ford)

ePCW is a web-based (PERL) interface with Mainframe (IMS) as backend. It tracks Part, Cost and Weight of a forward model vehicle program. It integrates part, cost & weight info into WERS.

HROGC(Ford)

HROGC is an application which support all the HR related information for Payroll, Plant and vehicle information belongs to NA(North America) and Canada. I am working in AXZ and CVMS applications as below.

Roles and Responsibilities as Technical Manager

Prepare design document for Project enhancements or system software upgrade.

Analyze and debug the program to determine the issue and resolve them within the SLA.

Get the Requirement from Finance Analyst to Automate the manual process.

Get in touch with interface (Internal/External) team/company to understand the data and mode of transferring data to Ford Motor Company.

Prepare the requirement documents and interface details and share with Java developer to implement the same logic which Finance Analyst doing.

Work with Java development team to make sure the data entered through automated process is matching with the data entered by Finance Analyst.

Review the open tickets with business and IT to work on those tickets based on the priority.

Follow the AGILE process in order to plan and work on each user story and complete them within the Iterations.

Follow Ford control process and involve in control testing twice a year to make sure the system is in control as per S-Ox process.

Involved in Data model process for decommissioning obsolete tables or creating new tables in Teradata.

Involved in Teradata development and Reporting.

Involved in integration testing with Java screens and debug the issue

Support for migration project.

Support for Business object projects

Managing tasks for Java application (PCF environment).

Involved in Migration project from legacy to emerging technologies.

Involved FTP to SFTP migration and also with iERP file transfer processing.

Project # 2

Client : AT&T, USA

Organization : Tech Mahindra ltd, Pune

Technologies : Mainframe

Role : Tech Specialist

Team size : 7

Duration : May 2008 – Nov 2011

About Client

AT&T is a leading telecom solution provider in United States and supplier of systems, services, and software that drive next-generation communications networks. AT&T uses its strengths in mobility, optical, software, data and voice networking technologies, research and development using modern technology.

Roles and Responsibilities

Analyze the requirement

Prepare design documents

Prepare the checklist for all the review comments to reduce the faults in forthcoming release.

Reducing the large number of outstanding faults.

Identify the repetitive issue and identify the root cause to automate them.

Follow the standard quality process for the effective delivery for all the releases.

Participate in pre/post deployment activities and in the release validation for all the release.

Sending daily status report to client.

Involved in enhancement and SMW (Small Maintenance Work).

Support for service calls and Incidents.

Load/unload encrypted data into Dev environment for the testing.

Provide Production support after deployment.

Project # 3

Client : LAREDOUTE, France

Organization : Capgemini India Ltd

Technologies : Mainframe

Role : Senior Consultant

Team size : 7

Duration : June 2007 – May 2008

About Client

LaRedoute is First in France and third in the world for direct-mail catalog sales. And it's what enables LaRedoute to deliver French savoir-faire to households from Scandinavia, across Europe to the United States and beyond. Applications across varied technologies which include COBOL, DB2, CICS, PL/1, PowerBuilder, SAS and Assembler.

LaRedoute Mainly concentrating on Catalog sales service and process the inbound and outbound stocks. Especially they are concentrates on Fashion designing products and fabric booking. It usually happens weekly, monthly and yearly basis. Depends upon the season of every year, the seasonal products would be launched.

Roles and Responsibilities

Analysis, Design

Development

Testing of the programs

Preparation of Unit test plan

Reviewing the Test Cases

Executing the Test Cases

Involved in Regression Testing

Documentation

Project # 4

Client : MEDCO, USA(IBM India Ltd).

Organization : GalaxE Solutions

Technology : Mainframe

Role : Software Engineer

Team size : 5

Duration : June 2005 – May 2007

About the project:

Medco is a pharmacy benefit management company (PBM). This means that Medco Health is a managed care organization (MCO) that focuses specifically on the cost-effective and appropriate delivery of prescription medications to the market. Claims processing, or claims adjudication, is the process of paying or rejecting a member's prescription drug claim. It is one of the most important functions at Medco Health.

Medco Health insurance company, USA offers health insurance to its policy holders. Eligibility module concentrates on getting details of the policy holders. It tailors the policyholder details and stores in the database for the future use and it acts as a input to other modules.

Roles and Responsibilities:

Involved in the entire Software Life cycle for new processes introduced in the system, starting from

Analyzing user requirement

Knowledge transfer.

Preparation of Technical requirement document (TRD)

Test plan / Test data preparation

Coding

Unit/System testing

Bug fixing

Support queries

Monitoring the schedule JOB’s

Monitoring the interface file transfer

Support after implementation

Documenting and delivering

Contact this candidate