Oracle Software Engineer

Dhaval Sanghavi Cell: +91-998*******

********@*****.**.**

B-303, Ushas Apartment,

Jayanagar 4th Block,

16th Main,

Bangalore - 560011

Certified Oracle BRM Server Developer

Prometric Testing ID: PR0927524

Test Registration ID: 1Z0-23620043

Experience Summary

Almost 7 years of extensive experience in Telecom BSS Domain and particularly in Oracle BRM 6.5, 6.7 FP1, 7.0, 7.3.1 developments.

Technical Expertise in C, Perl Scripting, UNIX and shell scripting.

Proficient with different Database systems like Oracle and SQL Server.

Expertise in Customization of FM policy modules and new FMs/Opcodes creation.

Developed Custom data managers.

Expertise in modules like Billing, Rating, Invoicing.

Expertise in Infranet data model and database structures of Oracle BRM and in depth knowledge of individual tables (Data models). Extended and created new data models as well.

Worked in Oracle BRM Production Support/Maintenance for issues related to pricing, billing and rating.

Expertise in Oracle BRM pricing plans, deals, products creation.

Strong SQL and PL/SQL knowledge and experience.

Ability to interact and communicate with clients and staff at all levels.

Managing deliverables and making sure that its get delivered with good quality.

Basic knowledge on pipeline.

Attended PMP (project Management professional) training.

Technical Summary

Billing and Revenue Management Tool: Oracle BRM 6.5, 6.7 FP1, 7.0, 7.3.1

Languages known : C, C++, Java, JSP, Servlet, Pro*c, Perl, Shell scripting, SQL, PL/SQL, VB

RDBMS : Oracle 9i, SQL Server 2000, Access

Other Tools : TOAD, SQL Developer, Visual Source Safe, Remedy, Star Team, CITRIX, CVS, SVN, WINSCP, Mantis, Merant Tracker.

Operating Systems : UNIX (Solaris) and Windows (XP, Vista, NT)

Education

Masters in Science (Computer Application & Information Technology) – North Gujarat University: 2005

Bachelor of Science (Computer Application & Information Technology) – North Gujarat University: 2003

Professional Experience

Logica India Pvt Ltd. Feb ‘2010 – till date

Job Title: Sr. Developer

Client: TeliaSonera, Sweden

TeliaSonera is based in Sweden which provides Broadband, Digital TV, Mobile, VOIP, email and Video services to the customers of Sweden.

Roles & Responsibilities:

Heading team of 5 people in development team.

Preparing Solution design based on customer’s requirements.

Mentoring juniors and making them capable to work independently.

Working on developments includes Pricing configuration, opcode changes and new opcode developments, Scripting etc...

Working independently on major developments, new offers, summer campaigns introduce by clients.

Managing deliverables and making sure that it is getting delivered with good quality.

Working on Change requests. We get SRS document from the client and from that I would prepare detailed design, Estimation, coding and Unit testing independently.

Working on maintenance defect raised by production support or Client within the specified time period call SLA.

On call support 24/7 in case if required.

Technology Used: Oracle BRM 7.0, Oracle 9i, SQL Developer, UNIX, Perl Scripting and Mantis.

Cap Gemini consulting India Pvt Ltd. Feb ‘08 – Feb’ 2010

Job Title: Consultant

Client: France Telecom, OCH Switzerland

Role: Senior Developer

Roles & Responsibilities:

Worked on Change requests like Prepay Favourite number development (PFN), Design, coding and Unit testing. Support to the Integration testing team.

Technical BRM support to the team on the developments.

Resolved Maintenance and Support tickets in the specified SLA.

Client: BT Spain, Madrid

Role: Project lead

BT Spain is the MVNO (Mobile Virtual Network Operator) which do not have own frequency spectrum and Infrastructure and providing services of other populations customers.

Roles & Responsibilities:

Handled BT Spain project independently for 2 years with 2 resources only. It includes :

In charge of Change Request design and developments.

FRIENDS AND FAMILY ERA offer / Promotions and CDR recalculation.

Developer for creating service level Friends and family promotions which will charge the customers on discounted tariff

Define Price Plans, Products for these offers

Batch Rating through UEL

Customized UEL (batch rating) for CDR template preparation for TELEPHONY, SMS, MMS and DATA service.

Used Re-rating functionality of BRM.

Customization of Invoice in Policy files.

In charge of Production defects solving in SLA and client meets.

Euro tariff change in the pricing.

SR (service Request) creation and follow up with Oracle.

Packaging, code Build and deploying package on the production.

Worked as per the Client SLA

Technology Used: Oracle BRM 7.3, Oracle 9i, TOAD, UNIX, Perl Scripting and Merant Tracker

A.T.I Consulting LLC Aug ‘07 – Feb ‘08

Job Title: Independent Consultant

Client: XM Satellite Radio, US

Role & Responsibilities:

Working on Major Release as well as Minor Release for customization of the product.

Gives support to Performance testing team for different billing utilities (i.e. pin_collect, pin_bill_accts, pin_inv_accts etc…)

Doing RCA (root cause Analysis) for the incident happens on production and makes the changes as per client’s request.

Co-ordination with onsite team members to be work done in proper way.

Billing, Invoicing and Pricing.

Technology Used: Oracle BRM 6.7 FP1, Oracle 9i, TOAD, UNIX, Perl.

Video (Digital TV Using CAS) (YOU Telecom India Pvt. Ltd.) Feb ‘07 – Aug ‘07

Job Title: Software Engineer

Description:

YOU Telecom has planned to launch Video Services(Digital TV) to the Customers. It requires integration of Oracle BRM, CAS.

Role & Responsibilities:

Defined new business type using the infranet utility.

Create new opcode, which creates additional service if requires and also attach multiple services on single account.

Create new opcode for plan change.

Created new service ‘/service/video’ using Event Map.

Creation of Parent-Child relationship using Hierarchy

Technology used: Oracle BRM 6.5, Oracle 9i, TOAD, UNIX, Perl, Pro*C.

VOIP and Broadband Services (YOU Telecom India Pvt. Ltd.) Jul ‘06 – Jan ‘07

Job Title: Software Engineer

Description:

You Telecom is Internet Service Provider, which provides a Broadband services to the Customers.

Role & Responsibilities:

Defined the plan as per business requirement.

Defined an event map as per customized need to record the events in infranet.

Defined user-defined RUM using the infranet utility.

Defined custom GLIDs using the infranet utility to track revenue.

Used UEL for rating.

Customized policy files for invoice display.

Developed a rating script that logs the customer session in BRM and defines the balance impacts.

Created reports as per requirement through SQL.

Applying patches if needed via contacting Oracle-BRM Support.

Customized policy file for suspension of suvidha customers.

Running Pin_bill_day at month end for billing purpose.

Technology Used: Oracle BRM 6.5 and 7.2.1, Oracle 9i, TOAD, UNIX, Perl, Jsp, Pro*C, VSS.

Suvidha - Postpaid Broadband (YOU Telecom India Pvt. Ltd.). Oct ’05 - Jun ‘06

Job Title: Software Engineer

Description:

Suvidha introduces postpaid billing option for the customers.

Created postpaid plans as per business logic for Data Transfer, Unlimited and Hourly-customers.

Bill and invoice the customers monthly. Provision for the customer to change from prepaid to suvidha services through form-based renewal process. Suvidha to Suvidha plan change is also permissible through form-based process.

A) Suspension of customer: Broadband or VOIP (Oracle BRM 6.5, 7.2.1)

Customer get suspended if he exceeds his credit limit via Oracle BRM Opcodes using Pro*c script .It may be possible that one of his service may be suspend not whole account.

B) Deal Purchase or cancel: Broadband or VOIP (Oracle BRM 6.5)

Purchase of any product or any deal using perl, UNIX scripting.

C) Games On Demand (Oracle BRM 6.5, C)

Customer can play games online. This code developed in core C. This Opcode can

Handle Registration, subscription and unsubscription of customers.

D) Dealer Top up (Oracle BRM 6.5, C)

Customers can top up online using web pages. Used PCM Java API Of Oracle BRM.

Role & Responsibilities:

Creating reports as per requirement through SQL.

Define Custom opcode for Dealer top up in C.

Developed a suspension script for Suvidha suspension based on customer’s credit limit.

Used UEL for rating.

Developed a purchase deal script in perl for Custom Purchase or any adjustment.

R & D on various topics on Oracle BRM.

2mbps speed plans change for all existing customers.

Technology used: Oracle BRM 6.5 and 7.2.1, Oracle 9i, TOAD, UNIX, Perl, JSP, Pro*C, VSS.

Personal details:

• Gender: Male

• Marital Status: Married

• Date of Birth: 25/09/1982

• Nationality: Indian

• Languages: English, Hindi, Gujarati

• Passport: E3661235

Contact this candidate