CURRICULUM VITAE
ROOPESH REKHAWAR
E-mail : *********@*****.***
Mobile : +91-810*******
PROFESSIONAL SUMMARY
Knowledge in COBOL, JCL, DB2, CICS, ORACLE, ORACLE UTILITIES
CC&B
Experience in External Design Analysis and Coding in Oracle Customer Care &
Billing.
Involved in Development and Unit Testing of Multiple Requirements using Oracle
Utilities Framework and CC&B 2.2 (COBOL).
HIGH LIGHTS:
8 4 years 3 months of software experience in utility company. Worked for
Production support, maintenance and development of enhancements.
9 Worked extensively in the key interfaces of utility company like metering,
prebilling, Billing, Bill Print, Payment systems and Debt Recovery.
10 Multiple skill set of Mainframe Technologies.
11 Good Communication Skills.
12 Willingness to learn new technology and to explore new Business areas.
ACADEMIC QUALIFICATION
13 MS in software Engineering from BITS Pilani in the year 2010
14 BSc (MECs) from Osmania University in the year 2006
PROFESSIONAL EXPERIENCE
15 Working as a Project Engineer in Wipro Technologies from October, 2006.
PROFESSIONAL SKILLS
Database : Oracle Database 11g, DB2
ERP Tools : Oracle Utilities CC&B
Programming Languages : COBOL, PLSQL
Software Engineering Methodologies/
Tools/Technologies : SQL Developer, Micro Focus, Xpeditor &
Intertest
Domain : Energy & Utilities
PROJECT EXPERIENCE
PROJECT- 1:
Project : Veolia
Role : Project Engineer
Skills : Oracle Database 11g, Oracle Utilities CC&B, COBOL, PLSQL,
Utilities
Environment : Micro Focus COBOL, Oracle 11g, CC&B2.2
Tools : SQL Developer, Crystal Report
Duration : January 2009 to till date
Description : Oracle Utilities Customer Care and Billing handles every aspect of utility
customer information-service connection, meter reads, rating, billing, and more-while
also undertaking associated functions like payment processing, collections, field service,
and meter management. The product evolves with business demands, minimizing cost
and risk. It helps utilities in any market maximize revenue, create cost efficiencies, and
respond to market change. It scales from a few thousand to many millions of customers.
Upgrades are quick and easy. As a result, Oracle Utilities Customer Care and Billing
clients reliably meet market windows and regulatory deadlines while enjoying a low total
cost of ownership and a high return on investment.
Roles & Responsibilities:
16 Involved on all the aspects of the project development such as understanding the
technical things in COBOL & functional specifications.
17 Involved in developing the Crystal Report using PLSQL.
18 Involved in Functional and Integration Testing.
19 Involved in all the Build process.
20 Involved in SP6 - SP9 Upgradation.
21 Involved in complete configuration of Product installation.
PROJECT- 2:
Project : AGLR-CIS-CMA
Role : Project Engineer
Skills : COBOL, DB2, JCL,CICS, Utilities
Environment : Mainframe
Tools : Xpeditor and Intertest
Duration : October 2006 to December 2008
Description : The client is one of the leading nation's preeminent distributors of natural
gas. A Fortune 1000 company that ranks No. 46 in the Fortune gas and utilities sector
Provides service through six utilities, two gas storage facilities and an asset management
company and Currently 2.2 million natural gas customers (and growing rapidly). Alliance
Data has had a long standing relationship with AGLR and continues to provide a variety
of services, Customer Information System is one of the application used by client who
stores all the data related to customers and does a billing for the customers.
The main part of this system is billing, using the meter read (gas consumed by the
customer) the bills are produced and sent to the customers. CIS consists of both ONLINE
and BATCH, online is nothing but CICS screens and TSO region is used as backend,
there is nightly batch cycle which extracts the meter reads and bills the customer
accordingly.
CIS also handles the processing the orders Turn on, turn off and various other orders,
there is also other application know as CMA (Customer Management Application) this is
user friendly application developed using .net & SQL server, Authorized users can surf
the customer information, it also handles the processing of orders, this application is
mainly used by customer care executives.
Roles & Responsibilities:
22 Involved on all the aspects of the project development such as understanding the
technical & functional specifications.
23 Involved in production support activities and providing the fix.
24 Debugging and fixing the code.
25 Involved in Functional Testing.
PERSONAL DETAILS
Date of Birth : 10-06-1986