Venu Bhimavarapu

Venu Bhimavarapu

Venu B

Mobile: 9290289160

SUMMARY:

Over all 7.5yearsof Information Technology experience in companies like HSBC, EDS,and CTS at various levels.

As part of my assignments, I have been in Development, Analysis, Functional Studies, Testing and Business Analysis. I have worked on projects for clients such as HSBC, ING, Northern Trust, and JPMC

EDUCATION

Title of the Degree / Degree/University
MASTER DEGREE / M.Sc.Computers/Bharathidasan University
BACHELOR DEGREE / B.Sc.Computers/Kakathiya University

TECHNICAL SKILLS

Operating System / Windows-98, XP, OS/390
Programming Languages / COBOL
Database / VSAM, ORACLE, DB2
Other Utilities / CICS, Endevor, Xpediter,File-Aid-DB2,File-Aid
Production support Tools / CA-7

EMPLOYMENT HISTORY:

Name of the Company / Designation / Address of the employer / From / To / Duration(Years)
HSBC / Senior Software Engineer / HSBC, Hyderabad / October, 2007 / Till date / 2.6yrs
EDS / Information Analyst / EDS, Chennai / November, 2006 / September, 2007 / 11 months
Cognizant Technology Solutions Ltd. / Associate / CTS, Chennai / November, 2004 / October,
2006 / 2 yrs
Sara Software Solutions / Programmer / Hyderabad / Mar,2002 / July,2004 / 2.2yrs
PROJECT TITLE / One HSBC APe
Duration / February 2009 – Till date
Client / HSBC-UK
Domain / Banking
Project specific Skills / COBOL, JCL, DB2, ENDEVOR
Role / Team Lead
Location / Hyderabad

PROJECT DESCRIPTION

The Account Opening (AO) is a process that has been selected to be re-engineered under One HSBC principles. The goal for this project is to take a fresh look at the different account opening processes that are currently being used around the Group, in order to define a single, common, best-in-class account opening proposition, which will become the HSBC Group standard. Within the proposed One HSBC AO process will exist the One HSBC Application Processing Engine (OH APe) which will provide a fully generic and adaptable account opening framework for use across group and shall be integrated into the One HSBC product suite.

OH APe will enable products and services to be advised and fulfilled through an externalised business defined process flow which it continually assesses and governs via a collaborative effort between OH APe and its Service Requester,such as a Front End browser.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Role: Team lead

Responsibilities

Coordinating the team of in providing work assignments, business and technical problem solutions, follow-ups and reviews.
Designing the TD (Technical Design), Review and walk thru with the clients
CodingUnit Testing
Preparation and Review of Unit Test Plans, and Results
Ensuring Timely Deliveries

Additional Responsibilities:

Involved in System testing support
Involved in Defects resolution

DURATION OF THE PROJECT: Overall experience in this project is 14months to till date

PROJECT TITLE / FTP UK Enabling - Retail Data Pool
Duration / October 2007 – January 2009
Client / HSBC-UK
Domain / Banking
Project specific Skills / COBOL, JCL, DB2, ENDEVOR
Role / Module Lead
Location / Hyderabad

PROJECT DESCRIPTION

Data Pool is one of the key systems that provides the Balance analysis, Off-Balance Sheet analysis, Interest analysis, Commission analysis, Manual Adjustments and a few other processes before the entries are passed on to GL and IMIS (the Management Information System)

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Role: Module lead

Responsibilities

Designing the Functional Specifications, TD (Technical Design), Review and walk thru with the clients
Coding & Unit Testing
Preparation and Review of Unit Test Plans, and Results
Preparation of Pre-delivery & Post-delivery follow up documents
Ensuring Timely Deliveries

Additional Responsibilities:

Involved in System testing support
Involved in Defects resolution

DURATION OF THE PROJECT: Overall experience in this project is 14months to till date

PROJECT TITLE / ING Life Insurance
Duration / November 2006 – September 2007
Client / ING
Domain / Insurance
Project specific Skills / COBOL, JCL, DB2,ENDEVOR, CA-7, INTERTEST
Role / Team Lead/Application programmer
Location / Chennai

PROJECT DESCRIPTION

ING is an end client for which this project is being executed. Security Connecticut Life(SCL) was the parent company which was then taken over by ReliaStar which in turn was taken over by ING. All the applications mentioned below were basically applications used by SCL and were enhanced for ReliaStar.

The project compromises of Common New Business, Insurance Machine and Policy Admin applications which run in Windows, Unix and Mainframe systems. The scope of work for India is to perform the following work types.

Production Support (PS)
Maintenance
User support

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Role: Team Lead

Responsibilities

Raising the new SPRs in order to provide the permanent solutions for production issues
Understanding, Analysis and Review of Business/Technical Requirements
Designing the TD (Technical Design), Review and walk thru with the clients
Impact Analysis and Estimations
Coding
Preparation and Review of Unit Test Plans, and Results
Preparation of Pre-delivery & Post-delivery follow up documents
Ensuring Timely Deliveries

DURATION OF THE PROJECT: Overall experience in this project is 11months to till date

PROJECT TITLE / Core trade on Demand
Duration / January 2006–October 2006
Client / NORTHERN TRUST
Domain / BFS
Project specific Skills / COBOL, JCL,CICS, DB2
Role / Team Lead
Location / Chennai

PROJECT DESCRIPTION

TNT wants to implement a new concept called consulting on demand we will receive work packets from Northern Trust. The work packet may come from different trade application systems. The work involved can be in any phase of SDLC. Once cognizant receives the work packet, it will perform an effort estimation based on the complexity of work. Estimation will be sent to client by onsite coordinator. The work will be executed based on the approval. The closure of the work packet is received through sign off mail from the client. Once the work is executed, the Cognizant team will take up new tasks. The entire work packet has to be completed with in the estimated time and would be of high Quality.

CLIENT DESCRIPTION:

Northern Trust's trade processing group has beginning-to-end process teams to focus on the full spectrum of trading activities worldwide, from the point of trade notification through the settlement of the trade. The teams are:

Northern Trust in Chicago manages all North American trading and related activity. Northern Trust has direct membership and electronic links to the Depository Trust Company (DTC), and the Chicago Federal Reserve Bank in the U.S.; and, in Canada at the Canadian Depository for Securities Limited (CDS)

Northern Trust in London manages all global custody trades and related activities. Northern Trust has direct membership and electronic links to CREST in Ireland and the UK, and Euro clear

Northern Trust in New York handles the purchases and sales of physical securities in the U.S.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Role: Team member

Responsibilities

Understand business requirements and turn them into detailed designs. Work with business partners to gather business requirements
Should be responsible for development, testing and implementation of any new business requirements
Should prepare CR for the offshore effort documenting the deliverables and resource model.

DURATION OF THE PROJECT: Overall experience in this project is 8 months to till date

PROJECT TITLE / JPMC US IS GAD INFOLINK
Duration / August 2005 - Dec 2005
Client / JPMC
Domain / BFS
Project specific Skills / COBOL, JCL, CICS
Role / Team member
Location / Chennai

PROJECT DESCRIPTION

This project caters to Production Support of Infolink applications for JPMC IS in US. This is a fixed price Project. In the current environment, SWIFT (Society for Worldwide Interbank Financial Telecommunication) MT565 messages (corporate action client instructions) that are based on the ISO (International Standard Organization) 15022 message standards are routed to the Corporate Actions department printers via INFOLINK and US MERVA. (MERVA stands for Message Entry and Routing with interfaces to Various Applications.) Corporate Reorganization/USSO (US Security Operations) staff members visually identify the relevant pieces of information from each MT565 message and are required to input a complete instruction on MCA via the Response Control System.

INFOLINK currently processes MT565 messages by: 1) routing all the domestic instructions to the printer, and 2) routing the global instructions to UK/Neonet.

The project to automate domestic MT565 will bring forth the following changes in INFOLINK: 1) a new outbound interface, MCA, will be created to send all the reformatted domestic MT565 to MCA for processing, 2) all inbound domestic SWIFT MT565 instructions will be sent to US/Neonet for reformatting, 3) a new functionality in the inbound monitor screen to display ONLY domestic MT565 messages which came in via the SWFT interface will be provided, and 4) ability to print the detail of the inbound domestic MT565.

All the global MT565 instructions will still be processed BAU by routing to the existing INFOLINK outbound interface, UK/NEONET

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Role: Team Member

Responsibilities:

Involved in analysis of Infolink module to add new interface in INBOUND and OUTBOUND screens
Coding new programs on CICS and used TSQ and TDQ concepts
MQ SERIES is used for transferring the messages form INFOLINK to MCA
Tested all the programs with all possible test cases and together worked with MCA project for testing the messages.
Prepared complete Unit test document. This includes all screen prints of the CICS programs

DURATION OF THE PROJECT: Overall experience in this project is 5 months

PROJECT TITLE / JPMC US IS GAD WINS-UK BGI
Duration / December 2004 - July 2005
Client / JPMC
Domain / BFS
Project specific Skills / COBOL, JCL,CICS, VSAM
Role / Team member
Location / Chennai

PROJECT DESCRIPTION

WINS is an on-line investment accounting and fund accounting system and Reporting system that handles virtually all types of investment portfolios, transactions and securities. The primary purpose of the WINS system is to calculate the Net asset value of portfolio assets. The GAD team will work on 1. Any enhancement to WINS system will be taken up (stages involves: Design, Construction, System testing, UAT, Implementation and post-implementation.) This includes Customization of systems to the respective clients based on their business requirements. 2. Core Development (When ever Sunguard changes, JPMC–IS needs to implement these changes to their customer systems). 3. Maintenance of the existing systems. 4. UAT testing for other interfaces and generation of reports during the process. Coding and Testing. Prepared Online SDS.

CLIENT DESCRIPTION:

WINS is an Investment Fund Accounting system consisting of the Sungard Invest One application supplemented by over 1500 JPMorgan Chase-developed modules. WINS is a central application for Investor Services that performs processing and valuations for a variety of mutual funds, insurance funds, pension funds/401k and unit trusts, providing daily and monthly valuations (NAVs). WINS sends, receives and formats data to/from numerous internal and external systems, including Infolink, Warehouse, GMRD, Titan 3/4, Titan2, COSMIC, PSA/MNPF, Wilshire, Infostation, AIRS and COACS. Pricing information is supplied from vendors IDC, JJ Kenny, FDIT (Extel) and Bloomberg. Extracts are created in various media including CDs, tapes and transmissions such as NDM, FTP and IMLITE. Customer interfaces are supported, directly and through Warehouse and Views – the WINS to Warehouse interface is a key deliverable both from the nightly cycle and intra-day as accounts are closed

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Role:Team Member

Responsibilities:

Involved in designing the SDS for Online programs
Involved in coding for one module of BGI project
Coding new programs on CICS and Batch programs
Modification of Procedures in JCL
Involved in reviewing the programs for other module programs
Tested all the programs with all possible test cases
Preparation of Unit test document
K.T documents prepared about BGI

DURATION OF THE PROJECT: Overall experience in this project is 8 months

PROJECT TITLE / Bank master Information in Cash Module
Duration / Mar 2002 - July 2004
Client / Andhra bank
Domain / BFS
Project specific Skills / VB, RMCOBOL
Role / Team member
Location / Hyderabad

PROJECT DESCRIPTION

The Bank master Information project consists of various sub modules such as Bank Master, Holiday List master, User Authentication, Working Hour Scheduling etc. These sub modules are assisted with help modules like Branch Information Help, Bank Master Help, Holiday List Help, and Working Hour Specification Help. These forms together form the Cash Module. The module is being coded in RM-COBOL. The work commenced with the designing of Graphical User Interface forms. These forms are made operative similar to Windows® based forms. Once the forms are designed, they are coded to make the functional as per the requirements of the client. The data being handled in managed using files in the backend. After the coding the forms are tested for bugs. The sub modules are the amalgamated and tested for integrity.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Role: Team Member

Responsibilities

Involved in analyzing the project and estimations for new programs.
The work includes conversion from VB to RM-COBOL languages
Preparations of SDS
Involved in coding new programs in RMCOBOL
Prepared Unit test document

DURATION OF THE PROJECT: Overall experience in this project is 26months

HSBC (India) Pvt. Ltd.- 1 -