Sukhvinder Singh

#****,***-**,*******

Cont : +91-959*******

Email: acd8sl@r.postjobfree.com

Professional Synopsis:

• A dynamic Software Technical professional over 6 Years of experience in IT Industry, Telecom, ERP system Development.

• 4+ years of experience of working on @billity Postpaid Billing System for Idea Cellular Pvt. Ltd.

• Presently associated with IBM India Pvt Ltd, Gurgaon as Senior Software Engineer in the Bharti Airtel CS Automation Team.

• Product analysis & enhancement, development, user interaction & implementation of Business Applications.

• Sound knowledge of Oracle RDBMS, SQL, PL/SQL, Core Java, Forms & Reports Developer (D2K) and Operating Systems like UNIX/Windows.

• A good understanding of Telecom (CRM, CMG,Billing,Roaming, Rating, Discounting, GPRS, MMS, MNP, Rating of 3G Video Calling etc.

• Deliver the expected deliverables before the timeline with excellence, coordination with quick problem solving capabilities.

• An effective communicator with excellent relationship management & analytical skills. Experience Summary

• IBM India Pvt Ltd, Gurgaon : Senior S/w Engineer – Oracle (Sep 2010 – Till Date)

• Infinite Computer Solutions, Mohali : Software Engineer – Oracle (Aug 2009 – Sep 2010)

• Eastern Software System Pvt. Ltd, N Delhi : S/w Engineer – Oracle D2K (Aug 2008 – May 2009) Presently Working with

IBM India Pvt Ltd.

Position : Senior Software Engineer.

Client Site: Bharti Airtel Ltd. Gurgaon.

Current Project: Customer Business Management System. Presently working: As a part of CS Automation team, Involved in development in CBMS Project Phase II. Educational Qualification

• Mater in Computer Application (MCA) From Kurukshetra University - 2006

• Bachelor of Science (N/M) from Maharashi Dayanand University, Rohtak (HR.) -2001.

• Senior Secondary from Board of School Education Haryana. Technical Summary

Prog. Languages: SQL, PL/SQL C, C++

Front End: Oracle D2K, Forms 6i 10g, Report 6i,

Operating Systems: Windows XP/2000, Window7, Unix AIX RDBMS: Oracle 6i/9i, 10g, 11g.

Tools: SQL Developer, Toad, SQL* Plus, ClearCase, EditPlus, UltraEdit. Remedy, Maxit, IBM Rational ClearQuest, Informatica. Billing Systems Experience

CRM Mobility-CRM Application.

Postpaid @billity - Lifetree postpaid billing product Roles:

IBM India Pvt Ltd.

Client: Bharti Airtel Ltd.

• Being a part of CS automation team of the IBM-GBS in Bharti Airtel at Gurgaon location.

• Working as Senior Database Developer in Oracle Technologies.

• Responsible for all modules of SDLC involving, RA (Requirement Analysis) with business Interaction and coordination with quick problem solving capabilities. Designing HLD, LLD and code development and all type of testing (UT, SIT, UAT).

• Conducting Knowledge Sharing Sessions, also contributed independently to achieve the various milestones

• Involved in end to end (Coding,Ops Testing Security,UAT and deployment support)deployment for CR/RFC/CBR.

Client: IDEA Cellular Ltd. Pune

• Part of the postpaid AMS team of Punjab Idea circle at Mohali location.

• Taking care of Change request and incident raises for Postpaid system.

• Managing the team work and resource timing for development and issue handling.

• Responsible for Postpaid related Development in applications.

• User discussion, requirement freezing, designing, developing and UT,UAT and SIT testing.

• Responsible for Billing, Rating, GPRS/MMS, Activation, CMG Modules development as well as supporting the operational issues also.

• Responsible for UAT of defects and new functionalities in applications.

• Contribute to the test deliverables e.g. Scenarios and Testing. Infinite Computer Solutions. Gurgaon.

• Responsible for Postpaid related Development in applications.

• User discussion, requirement freezing, designing, testing.

• Responsible for Billing, Rating, GPRS/MMS, Activation, CMG Modules development as well as operational issues also.

• Responsible for UAT of defects and new functionalities in applications. Eastern Software Systems Pvt. Ltd Okhla, New Delhi.

• Designing, development and deployment of reliable and secure business applications in ERP systems.

• Analyzing current processes and identifying functionality required to support product improvements.

• Defining new business processes for managing new developments in ERP Systems.

• Planning new developments implementation.

• Onsite-coordination, Programmer Analysis, Design, and Development.

• Worked on different phases of SDLC like Project Planning and Estimation, Requirements gathering Analysis, Design, Development, Testing, Deployment, User Acceptance and Support. Project details:

Company: IBM India (P) Ltd.

Client: Bharti Airtel

Project: Customer Business Management System.

Status: On-Going

Period: 02-Jan-2015 to 15-June-2015

Technical Environment: Oracle PL/SQL 11g

Description: CBMS project is a much-awaited project for Bharti Airtel and it includes four(OMNI, IDOC, EAI and CRM ) Project Teams for integration with different systems, This System Enable online and bulk data processing for customer's documents to Bharti. all the major release including integration and configurations are done by our project team.. This application is integrated to different -2 applications in place like OMNI, IDOC, EAI and CRM. All application is custom (developed by IBM) application, Responsibilities: • Worked as Senior Database Developer in Oracle Technologies.

• Responsible for all modules of SDLC involving, RA (Requirement Analysis) with business Interaction and coordination with quick problem solving capabilities. Designing HLD, LLD and code development, all type of testing (UT, SIT, UAT).

• Conducting Knowledge Sharing Sessions, also contributed independently to achieve the various milestones.

• Involved in end to end (Coding,Ops Testing Security, UAT and deployment support)deployment for CR/RFC/CBR.

Company: IBM India (P) Ltd.

Client: Bharti Airtel

Project: International Roaming Packs

Status: Successfully Completed

Period: 16-Oct-2015 to 26-Feb-2015

Technical Environment: Oracle PL/SQL 11g

Description: IR Pack project was required to automate the process of Deactivation and Renewal of International Roaming Packs for customers. Prior automation, the whole process is manual and quite time consuming. In case the customer asks for extension then agent has to deactivate and re activate the IR pack. Business need was to automate the process based on customers request. If customer deactivates IR facility the NRC

(Non-Recurring Charges) IR packs should automatically get deactivated. Responsibilities: • Worked as Senior Database Developer in Oracle Technologies.

• Responsible for all modules of SDLC involving, RA (Requirement Analysis) with business Interaction and coordination with quick problem solving capabilities. Designing HLD, LLD and code development, all type of testing (UT, SIT, UAT).

• Conducting Knowledge Sharing Sessions, also contributed independently to achieve the various milestones.

• Involved in end to end (Coding,Ops Testing Security, UAT and deployment support)deployment for CR/RFC/CBR.

Company: IBM India (P) Ltd.

Client: Idea Cellular Ltd.

Project: Prepaid Transformation

Status: Successfully Completed

Period: June-2013 to Dec-2013

Technical Environment: Oracle PL/SQL 10g and Forms 6i And BSCS Description: A much awaited and critical transformation, On Time Delivery without any deviation from any activity despite very tight timelines. This project is to streamlining the Punjab Prepaid stack with PAN India. In the first phase the critical applications like NSMS, CRM, FTA and LWISMS made live. And on-Line sync-up of Punjab I-Edge

(Local with Punjab) with centralized Apps for critical events with Idea BSCS. Responsibilities: • Impact analysis for Prepaid side.

• Listing of effected applications.

• Design to implement this feature in Punjab circle for Postpaid.

• Development for respective effected module.

Company: IBM India (P) Ltd.

Client: Idea Cellular Ltd. Pune

Project: Decimal Charging in Postpaid

Status: Successfully Completed

Period: Oct-2011 – Feb 2012

Technical Environment: Oracle PL/SQL 10g and Forms 6i Description: Decimal Charging in postpaid for Idea operator in Punjab circle, which gives the functionality of charging the customer’s calling upto decimal points. For example, in existing system if the charging is according to 1 paisa per second. After this project launched in Punjab circle the charging done as 1.2 paisa per second. Responsibilities: • Impact analysis from postpaid side in Home Rating Engine.

• Listing of effected application.

• Design to implement this feature in Punjab circle for Postpaid.

• Development for respective effected module.

Company: IBM India (P) Ltd.

Client: Idea Cellular Ltd.

Project: 3G Video Calling

Status: Successfully Completed

Period: April-2011 to July-2011

Technical Environment: Oracle 10g and Forms 6i

Description: In 3G video calling project, the operator provides the functionality of video calling to the customer by which the customer can do video calling with the second party via a 3G enabled mobile phone. Also it enables customers to use internet via 3G network. Responsibilities: • Impact analysis from postpaid side.

• Listing of effected application.

• Design to implement this feature in Punjab circle for Postpaid. Company: IBM India (P) Ltd.

Client: Idea Cellular Ltd.

Project: Mobile Number Porting (MNP)

Status: Successfully Completed.

Period: May-2010 to Jan-2011

Technical Environment: Oracle and Forms 6i and Reports 6i Description: MNP is first of its kind project to be launched in India which enables a customer to retain his mobile no. on changing his service operator. In first phase of the project, mobile portability is allowed within the same circle as per TRAI guideline. Responsibilities: • Impact analysis from postpaid side.

• Listing of effected application.

• Design to implement this feature in Punjab circle for Postpaid. Company: IBM India (P) Ltd.

Client: Idea Cellular Ltd.

Project: Billing Porting

Status: Successfully Completed.

Period: Aug-2009 to Dec-2009

Technical Environment: Oracle 9i Form 6i.

Description: As a part of Idea-IBM centralization project, Punjab postpaid server was migrated to Pune, due to which performance of the legacy CRM application @bility was de graded when accessed remotely from Punjab location. In order to reduce response time of application performance tuning of D2K forms was required. Responsibilities: • Forms performance should not be decreased.

• Tuning of forms over WAN.

• Optimization of SQL queries.

• Test scenarios for UAT.

• Operational Issue.

Company: IBM India (P) Ltd.

Client: Idea Cellular Ltd.

Project: Selective Barring

Technical Environment: Oracle 9i Form 6i.

Description: In @bility billing system there was only option for monthly or fixed rental offers creation. This project facilitates the customer to just subscribe for daily rental pack at any time once then customers un-billed amount will be added on a daily basis through a scheduler until and unless customer raise request for un-subscription. Responsibilities: • User Interaction requirement freezing

• Check feasibility on current system

• Design of new Model.

• Configuration for Selective barring Grades and categories. Company Eastern Systems Software Pvt. Ltd.

Project Product Ebizframe 7.4

Role Oracle Forms & Reports developer

Technical environment Oracle 10g, Form & Report 10g, Application Server Oracle 10g, 3- tire Architecture. Responsibilities Development of new Forms as per the need of the users and business practices and also to make the software user friendly in terms of functionality and usage. Also Involved in the Developing and designing of database and the PL/SQL functions as well as maintenance of ebizframe 7.3, Customization as per specs and standards. Clint Name: Sterling Tools LTD. Faridabad

Role: Forms and Reports developer

Technical environment: Oracle 8/9i/10G, Designer 6i/10G, PL/SQL, Forms & Reports 6i/10G, Toad, Description: Sterling Tools LTD. is manufacturing Machine Parts since over 3 decades. Products are marketed all over India and are also exported including U.S.A, UK, South East Asian countries etc.

Responsibilities: Involved in the Analyzing,designing of database and customization, Implementation and maintenance of ebizframe 7.3, Customization as per specs and standards, Coding for Stored procedures, functions, packages in PL/SQL, Coding, Developing and Testing of Forms. Responsible for distributing jobs to the team. Industrial Training and Honors:

● Attend the Database Deep Dive Training In Oracle Database 11g Conducted by Sonata Software Pvt. Ltd. The topics covered as Oracle Database Deep Dive Training in oracle DB 11g at New horizons, New Delhi. In Oracle Real Application Clusters. Demo for Database replay. Oracle Active Data Guard.

● Attend the Microsoft Live Meeting on VirtualTechDays.com. Achievements

● Got Team Excellence Award in Idea Cellular Ltd, for Prepaid Stack RollOut Project.

● Team of the Month in Dec.2008.

● Got 2 times Employee of the Month In Eastern Systems Software Pvt. Ltd. Personal Details:

Date of Birth : 04th .October, 1981.

Father’s Name : Sh. Mehtab Singh

Nationality : Indian

Passport : Available

Languages Known : English, Hindi

Declaration:

I here by declare that all above information is true and no attempts have been made to present any false information.

Place: Gurgaon (Sukhvinder Singh)

Contact this candidate