Candidates About

 

Vijayakumar Vaddi 

Professional Summary:

·         Having 11 years of IT Experience involved in all the phases of Software Development Life Cycle in terms of Analysis, Design, Coding, Testing and Implementation in Mainframes Environment

·         Extensively worked with Mainframe technologies COBOL, JCL, VSAM, DB2 and CICS on MVS, OS/390 and Z/OS systems

·         Very good working knowledge on Utility programs SORT, MERGE and JCL PROC.

·         Extensively used various tools SPUFI / QMF, SQL, RACF, ENDEVOR, CHANGEMAN, SPUFI, FILE AID, TSO, ISPF, XPEDITOR, PLATINUM, FILE MANAGER, CA-LIBRARIAN, PANVALET & APPTUNE

·         Good exposure on relational databases DB2, Oracle and SQL

·         Strong experience in Mainframe development, Mainframe testing and worked as a Mainframe Test Lead

·         Extensive development experience in CA Gen releases 8.0 or 8.5. Exposure to performance monitoring and application tuning

·         Good Experience in Mainframe Migration projects using ETL Informatica

·         Experience with CA Gen 8.5 in a MVS mainframe DB/2 environment

·         Had a good experience with Changeman version control tool on maintaining and staging/promoting the components to different levels to test the changes in different test regions. Creating packages, Checkout the components from production and Stage the components from local directories into package

·         Good Hands on experience of CA-ADS programming language in developing the Online and Batch applications. Extensively worked in available edited and error handling methods in CA ADS application

·         Good experience in resolving issues in a CA Gen environment

·         Good knowledge around LoanServ software retail loan support ( HELOC & HELON )

·         Experience in detailing test plans, test cases, tracking defects, reporting status to various levels.

·         Good knowledge in Unit testing, System testing and Regression testing

·         High self-motivation worked with manager, other testers and programmers to system, unit and User Acceptance cycle testing including creating Test Plans, Analyzing output test data using File Manager, creating datasets to test, setting up JCL, and Creating packages, Implementing test/productions code to various levels using Panvalet/Endeavor/Changeman tools

·         Self-motivated, innovative, hardworking and flexible with strong interpersonal and communication skills.

• Experience working in the domain of financial, banking & Retail applications. Extensive hands on experience on IBM Mainframe Application programming.
• Hands on experience creating tables and stored procedures.
• Very good experience in trouble shooting and system performance tuning.
• Undergone training in Time Management, Project action Planning, Cross culture, interacting with client, Assertiveness skills and Effective Team meetings.
• Project delivery of various sizes, performance tuning, production support, trouble shooting.

Skills Profile:

 

Technical:

 

Operating System	MVS - OS/390, z/OS, Windows 98/2000/XP, Linux
Environment	Mainframe, Informatica & Client Server Applications
Database	DB2, IMS DB/DC, SQL Server, VSAM, ORACLE 9i
Internet Tools	IBM Utilities, TSO/ISPF, JES2, SPUFI, QMF, Panvalet, Changeman, CA-Librarian, Xpeditor, Platinum, Endeavor, Control-M, File Aid & File Manager   CA-Librarian, Xpeditor, Platinum, Endeavor, File Aid, File Manager
Languages/Software	COBOL, MF COBOL, AS-400, PL/I, JCL, C, C++,  CICS, CA Gen, LoanServ & CA-7
Other	Informatica (Mappings & Job execution support), Control-M Work Load Automation & Informatica Power Center tools

 

Professional Experience:

Project 1:

 

Organization Name: Capgemini Technologies INC

Client Name: State Farm Insurance

Project Name: Digital Solutions Bank Support

Project Duration: Sep 2012 – Till Date

Role/Title: Mainframe Technical Architect

Technologies/Tools: COBOL, PL/I, JCL, DB2, VSAM, CICS, CA Gen, LoanServ, Panvalet, Xpeditor, Apptune, File manager, Base/DB2/IMS, QMF, SPUFI, MVS & Z/OS, OS/390, Informatica Powercenter, Control-M, CA-7 and Client Server Applications

 

  About Client:

State Farm is a family of insurance and financial services companies that together serve tens of millions of customers, 68,000 employees and more than 18,000 Agents service 81 million policies and accounts throughout in the U.S. and Canada. Our many lines of business together offer over 100 products and services, in five different lines of business, to help customers. We show our commitment to our policyholders by handling nearly 35,000 claims per day. My client (Large Auto Insurance Company) is currently ranked number 34 on the Fortune 500 list of largest companies.

Project Description: 

State Farm Bank’s vision is to provide simple, integrated solutions that meet our customers’ needs, deepen customer relationships, and grow the State Farm enterprise. Bank Deposits & Vehicle Loan Integration project will meet the CDE (Customer Driven Evaluation) objective of providing a remarkable customer experience, consistent and stream line process for our internet customers, Agents and Non Agents users to complete application for Stare Farm Bank Deposits & Vehicle Loan.

We will differentiate ourselves from our competitors by:

 

1.        Delivering an integrated Customer Platform

2.       Integrating the ways we serve the multiple needs and preferences of  customers

3.       Creating consistently remarkable customer experience

The full scope of Bank Deposits & Vehicle Loan will bring the new underwriting and Fulfillment solutions into the production with planned application capture.

 

Bank Deposit & Vehicle Loan project deals with the services providing to the customers with different bank products. State Farm Bank’s vision is to provide simple, integrated solutions that meet our customers’ needs, deepen customer relationships, and grow the State Farm enterprise, below mentioned are the products we are dealing with,

1. Deposit product

2. Vehicle loan Product

Deposit Products is responsible for developing, enhancing, and communicating deposit Products and achieving goals set by the Team, Bank, and Enterprise. Applications may originate in the Agent’s office, on the Internet, or through the BRC. Online applications are available for Checking, Interest Checking, Savings, Money Market, and Fixed Rate Certificates of Deposits.

Vehicle loans are a perfect complement for auto insurance customers. Realizing there are multiple factors that impact retention, Auto households with Bank products added during the last five years have had an average tenure of 2.6 years which is 37% higher than auto only households1. For the agent, it provides them with the cross-selling opportunity for vehicle loans and Individual Credit Disability Insurance.

Roles and Responsibilities:

1          Writing new COBOL / DB2 programs & File mapping using Informatica power center.

2         Changes to the existing functionality / enhancing the existing functionality by making changes to the programs.

3         Executing the Mainframe jobs & generating the reports using Control M/Control D

4        Recommend the future Enhancements for better performance.

5         Batch job tuning and Set-up of daily schedule.

6        Communicating with the customers, for analysis and implementation of work requests.

7         Performing Coding & Unit Testing based on the changes specified by customers.

8        Client Server GUI Applications developed using CA Gen and extensively involved in resolving the issues in CA Gen environment

9        Mapping using Informatica power center tool and job execution using Control-M work load automation tool.

10      Hands-on experience in Performance tuning of SQL Queries

11       Duties include creation of Unit test scenarios, running of tests, analysis of test results, resolution of differences in actual and expected test results

12      Providing required information to the end users by running the different mining queries based on the given inputs

13      Analyzing and proposing the time frame to schedule the mainframe jobs using CONTROL-M schedulers.

14      Providing support on trouble shooting activities of mainframe job failures in test region and data backup, reload process in necessary regions

15      Coordinate and plan for final, near-production development efforts, includes reviewing issuance documentation and resolution of outstanding problems. 

 

Project 2:

 

Organization Name: Capgemini Technologies INC

Client Name: State Farm Insurance

Project Name: ECRM- Marketing Electronic Library services

Project Duration: Dec 2010 – Sep 2012

Role/Title: Module Lead

Technologies/Tools:  COBOL, PL/I, JCL, DB2, VSAM, CICS, CA Gen, Panvalet, Platinum, Xpeditor, QMF, File- Aid, MVS & OS/390.

       

  About Client:

My client (Large Auto Insurance Company) is a family of insurance and financial services companies that together serve tens of millions of customers, 68,000 employees and more than 18,000 Agents service 81 million policies and accounts throughout in the U.S. and Canada. Our many lines of business together offer over 100 products and services, in five different lines of business, to help customers. We show our commitment to our policyholders by handling nearly 35,000 claims per day. My client (Large Auto Insurance Company) is currently ranked number 34 on the Fortune 500 list of largest companies.

Project Description:

The Electronic Library is a marketing application, this application houses information and data about agents and is used for imprinting and displaying on marketing materials. It is used by business partners in the Marketing department to maintain agents’ information. The Electronic Library transaction processing consists of mainframe and workstation processing. There are three distinct mainframe processes; AIMS transaction processing, Internet Email processing and subsequent letterhead reproduction on the mainframe:  The AIMS transaction processing uses a transaction file created by AIMS to create transactions for the Electronic Library.  In addition to the AIMS transactions, internet email transaction are also created via a separate process and merged with the transactions from AIMS.  This is necessary because AIMS does not carry the Internet Email address.  After the mainframe transaction files are merged, the files are downloaded to a workstation to be used as input for the Upload/Download application.  This application applies the transactions to the Electronic Library Tables.

Roles and Responsibilities:

1.        Communicating with the customers, for analysis and implementation of production support issues.

2.       Analysis of failures in testing and suggesting / fixing possible solutions.

3.       Development, unit testing of Change requests for the Electronic Library application.

4.      Worked in developing the AIMS (Agent Information Management System) screens using CA Gen

5.       Extensively involved in CA Gen agile development methods, design and deployment for various GUI screens

6.      Giving Support to team members for resolving their technical problems.

7.       Involved in design, code reviews and preparing the test cases for unit testing.

8.      Preparing the issuance documents and providing support for new production issuances.

 

Project 3:

 

Organization Name: Capgemini Technologies INC

Client Name: State Farm Insurance

Project Name: Health Interoperability portability and accountability Act (HIPPA) 4010 to5010

Project Duration: June 2011 – Aug 2011

Role/Title: Team Member

Technologies/Tools:  COBOL, PL/I, JCL, DB2, CA Gen, VSAM, IMS DC/DB, Panvalet, Platinum, Xpeditor, QMF, File- Aid, MVS & OS/390.

 

Project Description:

 

Health and Human Services (HHS) has adopted a new version (5010) of the HIPAA Electronic Transaction Standards.  Health Claims, as a covered entity under the HIPAA legislation, currently supports eight of these transactions.  Health Claims will need to make significant changes to comply with the 5010 version.  Planning project R15278 was created to consider the impact of the 5010 version. That project team estimated it would take around 12,000 project hours to implement the new version. This release will accomplish that.  The compliance date for 5010 is January 1, 2012.

 

Contributions in this project include:

 

•     Involved in the development for online Screens using CICS & CA Gen

•     Coordinated with the team technically

•     Developing code as per the Detail level technical specification document

•     Doing self and peer reviews of developed code.

•     Preparing & Executing Unit test cases

•     Setting up the Unit test execution environment

•     Executing Unit test cases

 

Project 4:

 

Organization Name: Capgemini Technologies INC

Client Name: ACS – Affiliated computer Services

Project Name: PBM - MAPOPSIII

Project Duration: Aug 2010 – Dec 2010

Role/Title: Team Member

Technologies/Tools:   COBOL, MF COBOL, DB2, VSAM, ORACLE, JCL, CA Gen, MF Net-Express, MF - ENTERPRISE SERVER.

About ACS:

ACS, a Xerox company, is a premier provider of diversified business process outsourcing (BPO) and information technology (IT) services and solutions to commercial and government clients worldwide. ACS is recognized as one of the best performing companies. As a FORTUNE 500 company, ACS has proven success delivering strategic value, business results, and operational gains to our clients. At ACS, it’s people, clients, and culture that make the difference.

Project Description:

The Commonwealth of Massachusetts Executive Office of Health and Human Services (EOHHS) is the single state agency responsible for administration of the state’s Medicaid program (known as “Mass Health”) to provide and pay for medical services to eligible members. EOHHS has developed and currently operates a POPS through a contract with Affiliated Computer Services, Inc. - State Healthcare.

 

This Project is intended to migrate the current Legacy POPSII system which is operating in COBOL, DB2 environment to the POPS III (Massachusetts Health Third-Generation Pharmacy On-Line Processing System) which uses MF-COBOL, ORACLE environment.

Roles and Responsibilities:

1.              Conversion of Cobol programs to micro focus Cobol, Conversion of Eztrieve programs to micro    focus Cobol, Preparing Functional Specification document.

2           Test Data creation using batch files and processing them thru CA Gen online screens

3           Testing the converted programs in Enterprise Server.

4          Testing in Mainframes and comparing the results with Net Express results

5           Preparation and execution of Unit Test Cases.

6          Reviewing the migrated code.

7           Involved in Identifying the System flow.

8          Testing the Flow of the System.

 

Project 5:

 

Organization Name: Tech Timers Solutions Private Ltd (Contractor to Capgemini Technologies INC)

Client Name: ACS – Affiliated computer Services

Project Name: Prescription Benefit Management System

Project Duration: Jan 2010 – July 2010

Role/Title: Team Member

Technologies/Tools:   COBOL, JCL, DB2, VSAM, CA Gen, CA-7, Endeavor, Platinum, Xpeditor, QMF, File- Aid, VIEW, MVS & OS/390, X-2 PBM, CE-2000.

About ACS:

ACS, a Xerox company, is a premier provider of diversified business process outsourcing (BPO) and information technology (IT) services and solutions to commercial and government clients worldwide. ACS is recognized as one of the best performing companies. As a FORTUNE 500 company, ACS has proven success delivering strategic value, business results, and operational gains to our clients. At ACS, it’s people, clients, and culture that make the difference.

Project Description:

The Claims subsystem stores all information related to claim adjudication, payment, and history processes within the Prescription Drug Claims System (PDCS X2).

PDCS X2 processes claims and re-bills that are submitted electronically from the Pharmacy (point-of-sale), electronically in batch form, and through the mail in paper form. ACS uses NCPDP 5.1 standards to edit and reformat claims. All claims, regardless of how they are submitted, are subjected to the same edits. This approach, which allows ACS to maintain a common processing engine, provide improved data accuracy, reduce the cost of software maintenance, and a system that easily accommodates change.

The Claims subsystem includes components which support multiple levels of inquiry, exam entry for data entry of paper pharmacy claims, entry of adjustments and reversals of previously adjudicated drug claims, and the submissions of electronic batch transaction data.

Roles and Responsibilities:

1.        Writing new COBOL / DB2 programs.

2.       Changes to the existing functionality / enhancing the existing functionality by making changes to the programs.

3.       Debugging the online programs by passing different inputs thru CA Gen online screen

4.      Worked in CA Gen online screen maintenance activities

5.       Recommend the future Enhancements for better performance.

6.      Batch job tuning and Set-up of daily schedule.

7.       Communicating with the customers, for analysis and implementation of work requests.

8.      Performing Unit Testing based on the changes specified by customers.

 

Project 6:

 

Organization Name: Cognizant Technology Solutions

Client Name: Wal-Mart Stores INC

Project Name: Wal-Mart Finance Project

Project Duration: Feb 2008 – Mar 2009

Role/Title: Team Member

Technologies/Tools:   COBOL, JCL, DB2, VSAM, CICS, CA Gen, CA-Librarian, Platinum, Xpeditor, Endeavor, QMF, File- Aid, CA7, MVS & OS/390.

About Wal-Mart:

Wal-Mart International is a fast-growing part of Wal-Mart's overall operations, with 3,629 stores and more than 680,000 associates in 15 markets outside the continental U.S.: We are operating retail stores in China, Canada, Puerto-rico, Brazil, Japan, Argentina and Great Britain other than US. We are planning to launch new stores in India shortly. We are providing a better service to customers in retail sector. Wal-Mart is the world number one retailer with 350 Billion dollars revenue.

Project Description:

Accounts payable team takes care of all payables for Wal-Mart. The AP job flow starts with loading invoices, purchase orders and receiving.

Apptricity (Payable to Associates):

        This application creates expense reports in which several expenses can be attached for reimbursement and sent for approval. Also, this application houses the receipts that were obtained during the associates travel and serves a record for reimbursement and proof of expense. The expense reports that are entered into the system are approved at different levels using a pre-defined workflow and then move on to be processed through the AP Check writer.

Invoices and purchase orders (Payable to Vendors):

Reconciliation process:

The invoice details sent by the Vendor are received at the home office. The entry details will be loaded in APIE screen online. For some vendors this process is done through EDI process. The data will be stored in IMS and DB2 tables in the AP system. This data is matched with the purchase order of Wal-Mart Stores, Inc. In case there is a mismatch the issue has to be researched and fixed before it can be reconciled. The balance to be paid to the vendor will be done thru the Check writing process.

Roles and Responsibilities:

1.        Adding new functionalities, modifying existing business logic as per customer specifications.

2.       Interacting with the OSC to discuss the status of the current task, clarification of queries regarding the functionality and resolving issues w