VENKATA
( **.*******@*****.***
EXPERIENCE SUMMARY
EIGHT plus years of professional IT experience in different phases of
SDLC methodology - Analysis, design, development and Testing on IBM-
Mainframe Technologies in TELECOM, BFS (BANKING and FINANCIAL SERVICES),
INSURANCE, and RETAIL domains. Working as Onsite coordinator (SME) and
QA Tester (Mainframes / PEGA) and having knowledge on Win-RUNNER, LOAD-
RUNNER AND QTP. Worked and Created Test data from various database
sources like SQL, Ms-Access, DB2, VSAM and Flat files.
As a Senior Mainframe Programmer:
. Extensive experience to analyze and document business requirements
and system functional specifications.
. Worked on Emulators like RUMBA, Quick 3270.
. Worked on ONLINE and BATCH environments using ROSCOE, TSO, CICS
. Having Good knowledge on application programming Languages like
COBOL, PASCAL, Delta-COBOL, C, C++, Visual Basic, HTML, DAS and
DBS.
. Having strong knowledge on Job Controlling Language (JCL).
. Created MACROs using emulators like Quick 3270 and RUMBA.
. Well versed in system analysis, design and developing application
using COBOL, DB2, CICS, VSAM, EZYTRIVE.
. Efficient in creating MAPS using SDF-II and develop online programs
using CICS.
. Effectively used tools like FILE-AID, INSYNC, EXPEDITOR, INTERTEST,
SDF-II, DITTO, DATAMOVER, QMF, TRACE MASTER, ENDEVOR and PR-TOOL.
. Created many reports and printed in different locations as per the
requirements using EZYTRIVE and JCL.
. Experienced in handling the Databases like DB2 using SPUFI and QMF.
. Strong knowledge on RDBMS concepts.
. Worked on performance tuning projects using DB2 and VSAM.
. Experience in backend programming including schema and table
design, stored procedures, Triggers, Views, and Indexes.
. Experience in providing technical support and preparing technical
documentation for the end user.
. Worked and extracted data from various database sources like DB2,
VSAM and Flat files.
As a QA Tester (MAINFRAMES / PEGA):
. Worked on Multiple projects and handled multiple roles like Senior
Application developer and QA Tester.
. Efficient knowledge in Testing Methodologies.
. Extensively used Testing tools like WIN-RUNNER, LOAD-RUNNER and
QTP.
. Experienced in creation of Test Specifications Documents and Test
plan preparation.
. Active participation as a QA member in Application and integration
Testing (AIT), Functional Testing and User Acceptance Testing
(UAT).
. Created many test objectives as per the business needs and executed
thousands of objectives on time with proper planning and estimation
in different environments like Mainframes and PEGA.
. Having strong knowledge on PEGA Rule Engine and Rules Fire
concepts.
. Found anomalies in different phases of Testing from Mainframes and
PEGA environments and Properly logged each anomaly in Mercury TEST
DIRECTOR
. Received high customer satisfaction rating from cleint in all the
projects handled till now.
. Experience in preparing test plan, test objectives and test
scripts.
. Delivered all the products on time with high quality.
. Quick learner and Quick starter with ability to master and apply
new concepts and a highly motivated team player.
. Excellent communication, interpersonal, intuitive, analysis and
leadership skills.
TECHNICAL SKILLS
Operating Systems : OS-390, MVS, Windows 95/98/NT/2000/XP, MS-DOS
Languages : COBOL, Delta-COBOL, SQL, PASCAL, C, C++, Visual
Basic, HTML,
DAS, DBS, EZYTRIVE
Databases : VSAM, DB2, DATACOM.
OLTP : CICS
Rule Engine : PEGA
IDE(facility) : TSO/ISPF, IEBGENER Utility Files, ROSCOE
Defect Tracking : Mercury TEST DIRECTOR, REMEDY, PR-TOOL
Tools : SPUFI, QMF, FILE-AID, ROSCOE, DATA MOVER, TRACE
MASTER,
INSYNC, SDF-II, ERWIN r7.3,
HIPERSTATION, ELIXIR, MQ-SERIES,
INFORMATICA, SQL-SERVER, TOAD.
Testing Tools : XPEDITOR, INTERTEST, WIN-RUNNER, LOAD RUNNER,
QTP
Change Control : ENDEVOR, INFOMAN, VSS
EDUCATIONAL QUALIFICATIONS
Masters in Computer Science, Andhra University, India
Bachelors in Computer Science, Andhra University, India
PROFESSIONAL EXPERIENCE
Farmers Insurance
Simi Valley, CA
Role: QA Tester (MAINFRAMES / PEGA)
July 07 - Till Date
The Farmers Insurance Group of Companies is a personal lines property and
casualty insurance group providing homeowners insurance, auto insurance,
life insurance, and financial services in the United States. It is the
third largest insurance group in the US. CLS provides a system for End
Users, Underwriters, Agents for maintaining all transaction and maintaining
and developing new business by calculating Premiums, Commissions,. The
system involves more than 1000 programs and covers the repository of the
entire data as well.
Roles and Responsibilities:
. Participated in different phases of projects starting from Business
Walk through for requirements gathering, business analysis, Design,
Coding Testing and project coordination.
. Gathered and translated business requirements into detailed, technical
specifications, new features, and enhancements to existing technical
business functionality.
. Worked with the project manager to develop the project plan for the
first two phases of the project.
. Resolved the revolving issues by conducting and participating in
different meetings with the users, SME's of different systems and
developers.
. Conducted design discussions and meetings to come out with the
appropriate design.
. Played a key role in motivating team members and problem-solving
during development of migration plans, screen designs using SDF-II.
. Created documentation, worked with users for new module enhancements
and testing.
. Played a key role in identifying critical anomalies in different test
phases as a QA tester.
. As a QA tester involved in different test phases like Application and
Integration Testing, Functional Testing and User Acceptance Testing in
different Environments like Mainframes and PEGA.
. Actively participated in Test Plans and Created different test
objectives in each phase of the testing.
. Executed many objectives in Functional and Regression Test phases.
. Identified many anomalies when firing RULES from PEGA engine.
Ensure an excellent quality of deliverables and efficiency in meeting
deadlines for all assignments.
. Performed impact analysis on system jobs and created many JOBS,
Procedures and Control cards.
. Created many reports using EZYTRIVE.
. Printed many reports in various locations by routing the documents
using JCLs.
. Performed significant role in Developing CICS programs.
. Created different screens using Macros (BMS)
. Modified many existing programs to read new files
. Created many control cards and copybooks as per the requirements
. Testing the downstream data.
. providing different reports and files to the Downstream teams from CLS
system
. Creating Test data from production files by FTPing the datasets.
. Routing reports on different printer at different locations to print
documents for the policies listed.
. Working on different tasks related to DOCUMERGE and responsible for
Printing reports and various forms for the policy holder in various
conditions.
Environment: MAINFRAME (CICS, COBOL, DB2, VSAM, JCL, EXPEDITOR, INTERTEST,
INSYNC, FILE-AID, PEGA, WIN-RUNNER, LOAD-RUNNER, MERCURY TEST DIRECTOR,
HIPERSTATION, ELIXIR)
T-COM PUNE,
INDIA
Role: SME / QA Tester (Mainframes)
Jan 07 - Jun 07
T-Com is a division of Deutsche Telecom AG and operates primarily in German
market. Deutsche Telecom's Broadband / Fixed Network business area operates
world's most modern and powerful infrastructure for fast and secure
information exchange. KONTES is the primary application for order
processing for T-Com. It manages DTAG's mass market business processes and
fixed network products. CUT is the development team for KONTES which works
on system maintenance and enhancements.
Roles and Responsibilities:
. Involved in all phases of project and actively participated in
Multiple Roles.
. Have Excellent Business Knowledge on TELECOM domain and played a key
role as a SME in gathering requirements for EA-Services (Connection
Applications) of Telecom Business.
. Gained good knowledge on Deutsch Language in a very short span of
time.
. Gathered Business information from Walk through sessions and getting
translated them from German Language to English.
. Created many Test Objectives and executed in different phases of
Testing.
. Proactively involved in translating and understanding the Business
requirements from Deutsch Language to English
. Identified many anomalies in Functional and regression testing.
. Logged each defect in each phase and reported the issues using PR-
TOOL.
. Thoroughly tested Delta-COBOL programs and delivered high quality
product.
. Extensively tested Online Screens and Databases (DBS and DAS)
Environment: MAINFRAME (CICS, Delta-COBOL, DBS, DAS, PR-TOOL)
Federated Department Stores Inc. / Macy's Inc.
Mysore, INDIA
Role: Sr. Software Engineer / Mainframe Tester
Aug 05 - Dec 06
Federated Department Stores, Inc., parent company of Macy's is one of the
nation's leading retailers. Federated operated 866 stores in 45 states, the
District of Columbia, Guam and Puerto Rico under the names of Macy's,
Bloomingdale's, Famous-Barr, Filene's, Foley's, Hecht's, Kaufmann's, L.S.
Ayres, Marshall Field's, Meier & Frank, Robinsons-May, Strawbridge's, and
The Jones Store.
RDSMVE
RDS is a System which is nothing but Reservations and Delivery System.
It deals with the Inventory and will maintain the items in Stores,
Warehouses and DC's. RDSMVE online function will be initiated in
Macy's Home or Bloomingdale's only. Users will request for a
DEPT/VEND/CLASS change and are able to generate the exception reports
thru online function.
The RDS System Facilitates the following features:
. SKUs are Created and maintained Online.
. Stock orders entered on POP and fed back to RDS
. Special Orders are generated by the System.
. Delivery to the Customer is scheduled at the time of reservation
for in-stock merchandise.
. Price changes are booked based on upon transaction versus owned
retail.
CREDIT BUSINESS:
The Credit business unit develops and supports systems for the
following functions:
Credit and insurance Fraud prevention
marketing Proprietary credit systems and application
Credit customer service processing
Credit sale authorization Third-party credit card settlement and
Employee discounts reporting
FDS Bank
WAREHOUSE MANAGEMENT SYSTEM (WMS)
WMS is a system was developed to monitor the inventory of the
organization. The system recorded all stores transactions like
material receipt against purchase order, material issues, and stock
adjustment vouchers, distribution centers, vendors, items and so on.
Roles and Responsibilities:
. Involved in various phases of project and actively participated in
Multiple Roles.
. Got in depth Business Knowledge on RETAIL and BANKING domains and
played a key role as a Team Lead and QA Tester.
. Worked in a Warehouse environment and worked with ERWIN tool to create
Models.
. Played significant role in Performance Tuning methodologies using DB2.
. Effectively implemented performance tuning methods and brought the
system thoughput from 4 hours 20 minutes to 4 minutes 49 seconds.
. Provided necessary knowledge to the Team on Database concepts.
. Involved in business analysis, Design, Coding Testing and project
coordination.
. Created many Test Objectives and executed in different phases of
Testing.
. Worked in different test phases like AFT, AIT, Functional and
Regression.
. Worked on different automated testing tools like Win-RUNNER, LOAD
RUNNER and QTP.
. Extensively worked on Credit Business and having good knowledge on
BANKING Domain.
. Performed significant role in Developing CICS programs with scrolling
logic.
. Developed Backend programs to send the necessary information to the
approver to take decisions.
. Tested many Online Screen programs and Data in the Databases (CICS and
DB2)
. Played an important role as a QA tester to make sure the high Quality
of the product.
Environment: MAINFRAME (CICS, COBOL, DB2, VSAM, JCL, EXPEDITOR, INTERTEST,
INSYNC, FILE-AID, DATAMOVER, RUMBA, SPUFI, QMF, ERWIN, ROSCOE)
APPOLLO
Bangalore, INDIA
Role: Mainframe Consultant
Apr 05 - Aug 05
APOLLO is one of the leading providers of life and Health insurances for
USA. Apollo is one of the largest insurer in the world. APOLLO Health
insurance having several modules like, Ingenix, Portals, etc., TOPS is used
to process the claims very faster for different policies. The System has
the policy proposals, claims, accounts and reports.
Roles and Responsibilities:
. Involved in various phases of project and actively participated in
Business Walkthroughs.
. Performed impact analysis on system jobs and created many procedures
and control cards.
. Extensively worked on SORTING techniques.
. Created many reports using EZYTRIVE.
. Printed many reports in various locations by routing the documents
using JCLs.
. Performed significant role in Developing CICS programs.
. Created different screens using Macros (BMS)
. Created many control cards and copybooks as per the requirements
Environment: MAINFRAME (CICS, COBOL, DB2, VSAM, JCL, EXPEDITOR, INTERTEST,
INSYNC, FILE-AID, EZYTRIVE)
B & C Technologies
Chennai, INDIA
Role: Application Developer
June 03 - Apr 05
B & C Technologies is globally competitive manufacturer of technology
driven products like Automotive Accessories, Transmission Line Accessories,
Isolated Phase Bus for Power Plant, Generator Cubicles, and Electrical
Machinery. A system was developed to monitor the inventory of the
organization. The system recorded all stores transactions like material
receipt against purchase order, material issues, and stock adjustment
vouchers.
Roles and Responsibilities:
. Involved in the entire system study, analysis and design.
. Generated report and printed the invoices on various printers using
JCL.
. Created online screens for the agents to receive orders and enter
values for different items.
. Developed the Database Maintenance System with various COBOL/CICS/BMS
programs to receive data from user entries and stores the values in
different tables in DB2.
. Involved in UNIT testing, Application Integration testing to validate
the data and handled the performance issues efficiently.
. Involved in documenting the entire technical process.
. Supported technical teams involved with DB2 issues and operations.
. Involved in the maintenance of the database.
Environment: COBOL, DB2, JCL, SPUFI, QMF, ENDEVOR, INTERTEST, EXPEDITOR.