Page * of *

CURRICULUM VITAE

RAM SINGH

**** * **** **, ***#345,

Prospect Heights,

IL – 60070 – 1723,

United States

Mobile: +1-224-***-****

Email: ac0o5q@r.postjobfree.com

ac0o5q@r.postjobfree.com

Career Objective

To gain further exposure and experience & to touch new horizons. Improvising the known skills and exploring the unknown ones.

Professional Qualification

COURSE SCHOOL/COLLEGE DIVISON MARKS IN

%

Master in Computer

Application

Harcourt Butler Technological

Institute, Kanpur, India

First 76.06

B. Sc. (Computer

Science)

Lucknow University,

Lucknow India

First 67.33

Intermediate (XII) Lucknow Public School,

Lucknow India

First 79.80

Work Experience

Working as an Senior Associate with 7.5+ years experience in Mainframe. I am currently working in Banking and Credit card domain.

Senior Associate, Cognizant Technology Services US Corp (Oct 2015 – Till Date) Senior Software Engineer, Accenture LLP (Dec 2009 – Oct 2015) Intern Shadow Developer, Accenture LLP (Jan 2009 – July 2009) Project Details

01 Project Name Discover maintenance and testing support Domain Bank/Credit Card

Client Discover Financial Services

Application Install, Refresh, Operation Analysis, Batch Role Senior Associate

Team Size 20

Description of the project

Discover Financial Services, Inc. is an American financial services company, which issues the Discover Card and operates the Discover and Pulse networks. Discover Card is the third largest credit card brand in the United States, when measured by cards in force, with nearly 50 million cardholders.

Page 2 of 7

Role: I am currently working with testing support team which is responsible for preparing test environments for various bank and credit card domain projects. I am also responsible for running the batches and automate the existing manual processes in the team. Responsibilities handled:

• As a Senior Systems Analyst, I am responsible for resolution of any issues on time by involving/coordinating the appropriating teams, investigating defects and assigning to appropriate teams, resolving batch run and environment issues in their assigned environments.

• I am also responsible for refresh and port initiation & coordination, & validation. Review and approve EIS, coordinate any installation issues for resolution. Weekend support of projects upon request and approval.

• I am responsible for design, development, unit testing, system testing, user acceptance testing, Final implementation and production assurance/ESQM region support in Discover Financial Services in Production Assurance region using COBOL, JCL, DB2 and CICS. I am using OPC to schedule, maintain and monitor batch jobs. I am utilizing Endeavor in implementing COBOL, JCL and DB2 modules on Discover Financial Services mainframe.

• I am using File-Aid for data processing, development and testing COBOL/DB2 programs. I am executing the project based on Discover Financial Services strict methodologies that dictate the implementation and maintenance of trouble reports, system coding and data set naming conventions.

• While in U.S., I am also acting as key liaison between our client and our offshore software development team in India. I have applied my advanced knowledge of our Indian subsidiary’s proprietary software tools, quality assurance standards and procedures in working with our team of U.S. software professionals to develop and enhance our U.S. client’s computer applications in accordance with our quality control standards and business practices and procedures.

• I have been identified as an expert in the utilization of our internal tools and, as such, I am performing system analysis, design, coding and testing and am managing the implementation and post implementation phases of project.

• My substantial role in the project described above translates into specialized experience with work flow, procedures and standards followed by our Indian teams for processing information from client sites in the U.S. and creating and implementing applications remotely. This provides me with a unique perspective on what information the team in the U.S. will need to gather from the U.S. client and forward to the Indian team for optimal and efficient results on a particular project.

• Automating project processes using REXX.

Duration : From: Oct, 2015 To: Till date

Hardware : MVS Mainframes (IBM 360)

Software : COBOL, DB2, JCL, VSAM, SORT, UNIX, ICETOOL,TSO/ISPF, Sharepoint, CICS, IBM Code Debugger, ServiceNow

Tools Used : ENDEVOR, FILE MANAGER, REXX, TWS OPC, ALM Defect Manager

Page 3 of 7

02 Project Name Allstate

Domain Insurance

Client Allstate Insurance

Application State models, Corrective action, Alliance Role System Analyst (techno-functional BA)

Team Size 12

Description of the project

The Allstate Corporation is the America’s largest publicly held personal lines insurer. A Fortune 100 company, with $130 billion in total assets, Allstate sells 13 major lines of insurance, including auto, property, life and commercial. Allstate also offers retirement and investment products and banking services.

Role: The main focus of Intake Management System Analysts is to supervise the compliance issues with Allstate onshore and offshore developers. I was responsible for analyzing a defect and fill out the complete information related to a defect on centralized database (CARS). This information is referred by audit developers to create audit programs to fetch impacted policies (SQL Queries), by current term correction developers to create the COBOL-IMS programs to correct the current term identified broken policies and by refund developers to create refund program (COBOL-IMS program) in order to refund the overcharged customers for prior term.

Responsibilities handled:

• Manage client visits and presentations

• Ensure that compliance issues are completed well before the Corporate Compliance Deadlines.

• Interacting with the business to gather requirements.

• Provide BA/SME support to client captives.

• Coordinate with client captive in optimization of their processes.

• Handle client calls.

• Requirement analysis for all the defects.

• Participate in CAMD meetings to discuss the open issues related to a defect.

• Give the policy identification criteria for defects, so that developers can write the audit.

• Once the audit results are available, validate the results and query (SQL query) as per broken and approve it.

• Prepare the design for current term correction of broken policies. Provide necessary information to Corrective action developers for database correction.

• Review the Z transaction code and test results (IMS – COBOL Code).

• Validate the summary of correction.

• Provide necessary information to refund developers for refunding the prior term policies.

• Review the refund code and test results (COBOL-IMS Code).

• Validate the refund summary sheet.

• Collaborate with Customer Executive Support (CES) team on manual correction/refund

(provide the CES team functional solutions for manual fixes) policies that could not be corrected/ refunded through mechanical correction/refund.

• Contribute to Accenture level recruitment by being an empanelled interviewer. Page 4 of 7

Duration : From: Apr, 2014 To: Oct, 2015

Hardware : MVS Mainframes (IBM 360)

Software : COBOL, DB2, JCL, CICS, ADW- Oracle, Java, Sharepoint, Easytrieve, IBM Code Debugger, SAS, TSO/ISPF, ServiceNow Tools Used : SCLM, STARTOOL, REXX, CA7

03 Project Name CW Corrective action

Domain Insurance

Client Allstate Insurance

Application Corrective Action

Role COBOL/IMS Developer – Audit/Z/Refund lead

Team Size 14

Description of the project

The Allstate Corporation is the America’s largest publicly held personal lines insurer. A Fortune 100 company, with $130 billion in total assets, Allstate sells 13 major lines of insurance, including auto, property, life and commercial. Allstate also offers retirement and investment products and banking services. Allstate is widely known through the

"You're In Good Hands With Allstate®" slogan. Allstate was founded in 1931 and became a publicly traded company in 1993.

Allstate caters to approximately 17 million households. Allstate has approximately 14,700 exclusive agencies and financial representatives in the United States and Canada. Major projects handled:

1) Compliance Action Corrective Team – The main focus of this team is the Client Compliance Issues wherein we are required to identify broken customer policies. Team deals with creation of Audit programs using SAP architecture (Streamlined audit process – COBOL/DB2 Code, JCL used for report creation) to identify these policies and create Z-transaction (COBOL/IMS Code) and refund modules

(COBOL/IMS Code to carry out the correction process. Role: I was managing a team of 14 people across 3 different geographies. The team started as staff augmentation to support the client team. In the fifth year of the contract due to the high quality delivered and the Metrics reporting and process changes implemented. The team transitioned into Managed delivery. We were in the 5th year of the contract.

Responsibilities handled:

• Interacting with the business to gather requirements.

• Handle calls with Client leadership.

• Implementing process improvements in client systems.

• Metrics reporting (Resource forecast, DART etc)

• Coordination of work across 3 geographies Ireland, India and US.

• Functional review of artifacts and business functionality of changes which will be implemented.

• Delegation of tasks and status reporting

• Estimation of tasks and Root cause analysis

• Preparation of Design and test plans for Streamlined Audit Process (COBOL/DB2 Page 5 of 7

code)/ADW(SQL Queries) .

• Carry out Reviews for deliverables.

• Coding using SAP architecture (COBOL/DB2 Code) and testing and ADW (SQL queries).

• Conducting CAMD walkthroughs.

• Mentoring new resources.

• Build Z-transaction routines (COBOL/IMS Code) for the data and premium correction of the broken policies identified by Streamlined Audit Process /ADW audit.

• Generate Z/Z-Refund-transaction summary report (Use JCL/SORT/SAS/IceTool, EasyTrieve), identifying all the policies which got successfully processed and the ones which need to be sent to CES team for manual correction. Duration : From: Dec, 2009 To: Apr, 2014

Hardware : MVS Mainframes (IBM 360)

Software : Cobol, JCL, CICS, VSAM, DB2, SQL, REXX, Endeavor, OPC Scheduler, File Manager, UNIX, SORT, ICETool, Easytrieve, TSO/ISPF Tools Used : SCLM, STARTOOL, REXX

04 Project Name EDF Energy

Domain Utilities – Gas/Electricity/Phone

Client EDF Energy, UK

Application Data Migration

Role IBM Data Stage – Intern Shadow Developer

Team Size 6

Description of the project

EDF Energy is an integrated energy company in the United Kingdom, with operations spanning electricity generation and the sale of gas and electricity to homes and businesses throughout the United Kingdom. It employs 13,158 people and handles 5.7 million customer accounts.

Major projects handled:

1) Data Migration Team – The main focus of this team is the Client Compliance Issues wherein we are required to identify broken customer policies. Team deals with creation of Audit programs using SAP architecture (Streamlined audit process – COBOL/DB2 Code, JCL used for report creation) to identify these policies and create Z-transaction (COBOL/IMS Code) and refund modules (COBOL/IMS Code to carry out the correction process.

Role: I joined EDF energy team as a fresher, shadow intern developer. My main job was to help out senior developer in creating technical specifications using functional specification document with the help of IBM Data Stage. Responsibilities handled:

• I was basically working as a shadow developer who used to prepare technical specifications with the help of functional specification (with the help of jobs on IBM data Stage).

Page 6 of 7

• The work was based on Data Warehousing.

• Follow various project processes.

• Preparation of IBM data stage Jobs for various objects of Utility Industry.

• Estimation of tasks.

• Prepare Unit / Integration test plan and carry out Unit, Integration & Regression testing.

• Performing unit testing of jobs thru ADW (SQL).

• Exposure to deal with the Onshore regarding the project activities. Computer Skills

Operating Systems: Windows 95, 98, 2000, NT, MVS, UNIX and DOS. Languages/Tools: COBOL, JCL, CICS, DB2, SQL, C, JAVA, VSAM, TSO/ISPF, CLIST, REXX, File-Aid, ENDEVOR, IBM Code Debugger, SAS MF, SCLM, File Manager, TWS OPC Scheduler, IBM Datastage etc.

Databases: DB2, IMS, Oracle etc.

Certifications

AINS21 - Property and Liability Insurance Principles - The Institutes

Insurance Foundation certification

Insurance generalist certification

ITIL V3 foundation certified.

Cherished Values

Honesty, Hard work, Operating at higher energy levels. Hobbies

Interacting with People, Computers, Sports & Reading. Other Achievements

Received ACE – Accenture celebrates excellence for Nov 2012 – Client Champion for doubling the corrective action team size from 7 to 14 resources for 2014 contract.

Received Best Performer at Accenture in 2013.

Won ISU Cricket Tournament at Accenture, Pune in 2009.

Organized fests in college.

Personal Details

NAME : Ram Singh

DATE OF BIRTH : 7th July 1985

MARITAL STATUS : Married

NATIONALITY : Indian

Page 7 of 7

CURRENT OCCUPATION : Senior Associate

EDUCATIONAL

BACKGROUND (MONTH AND

YEAR OF PASSING)

: Master in Computer Application (MCA – July

2009)

PASSPORT NO. (VALID UPTO) : Z2859004 (11th August 2024) Thereby I declare that the above mentioned information is true to the best of my knowledge.

DATE: 06/05/2017

PLACE: Prospect Heights, IL (Ram Singh)

Contact this candidate