Project Software Engineer

Anil Sunkara

E-Mail: **************@*****.***

Contact No: +91-741*******

Passport No: K7652829

CAREER OBJECTIVE

Dedicated IT Graduate with 3.8 years of professional experience, seeking a

challenging and interesting position as a PL/SQL Developer with

opportunities for advancement and to demonstrate my capabilities

contributing to the efficient working of the organization.

PROFESSIONAL SUMMARY

Strong skills include Oracle 10G,PL/SQL

Exposure writing complex SQL Queries

Having good exposure in coding Procedures

Created Procedures,Functions,Packages,Triggers & Views

Experience Using PL/SQL Collections, RefCursor and Bulk collect

Having 2 months of experience in Telecom Production Supporting

Interaction with co-workers and users to high level of service provided to

company

Able to work with high productive as per the project plan and schedules

Able to fix the issues of other team members coding and resolve the issue

Can adopt in any environment and quick learner

Able to fix all level bugs raised by QA Team.

Generated the reports using UTL_FILE package.

Scheduled jobs using DBMS_JOB package.

Knowledge on Unix .

TECHNICAL SKILLS

RDBMS : Oracle 10g

Tools : Sql Plus, SQL developer & Toad

Ticketing Tool : BMC Remedy tool(Incident Ticket Tracking

Tool)

ACADEMIC QUALIFICATIONS

B.E from Lord Venkateswara Engineering College, Kanchipuram. Affiliated by

Anna University in April 2009.

PROFESSIONAL EXPERIENCE

Currently working with Pyro group as Senior software engineer

Duration: Feb 2013 to till date.

Worked as associate consultant in Capgemini India private limited.

Duration: June 2012 to Feb 2013.

Worked as Software engineer in Tata Consultancy services.

Duration: October 2011 to May 2012.

Worked as Software engineer in Cybermate infotek.

Duration: November 2009 to September 2011.

PROJECT

Title : CTOPUP E-Recharge application (ALL ZONES)

Client : BSNL SOUTH,BSNL NORTH,BSNL WEST,BSNL EAST

Duration : Feb 2013- Till date

Description:

Ctopup is an electronic recharge application which supports recharges,topups,flexi topups to the Bsnl Dealers. This product also provides the

facilities of stock movement from one dealer to another dealer,stock

allocations from BSNL operator,check stock of dealers,Roaming

transactions,Dealer movements, recharge reversals to subscribers etc. DB

supports around 10 lac transactions per day in each zone.

Roles & Responsibilities:

Developed the tax calculation part while allocating stock to franchisees.

Generated the Daily sales transactions reports.

Fixed Issues raised by support team from all the ZONES.

Implemented Mulit wallet concept for post paid and Land line bill payments.

PROJECT

Title : ADT (Account Data Transfer

Client : Allianz

Duration : June 2012- Oct 2012

Description:

Global ADT (Account Data Transfer) is a system where end users upload the

bulk bookings in the form of CSV file into it. Global ADT accept the ADT

file, validate the file as per business requirement and write the ADT file

into SICS (Global Accounting system). This projects deals with Reinsurance

booking accounts. Major components involved in ADT.

Read the ADT file into system.

Verification and Validation of ADT file.

Write the ADT file into SICS (Global Accounting System)

Roles & Responsibilities:

Making code changes in packages/procedure/functions as per the requirement

Preparing test cases to test the initial flow.

Environment: Oracle 10g PL/SQL, Java, Windows, TOAD, and SQL PLUS

PROJECT

Project Title : CPOS (Centralize Point Of Sale)

Client : Vodafone

Duration : Oct '2011'-May '2012'

Description:

Vodafone Essar is the largest service provider of GSM cellular service

in India. It provides pre-paid, post-paid and value-added services like

GPRS, WAP, edge, news etc. to its customers. Vodafone Essar currently has

operations in 16 circles covering 86% of India's mobile customer base, with

over 40 million customers.

Vodafone Essar currently has multiple points of sale applications (multiple

locations, multiple instances, different technologies). This POS

transformation project is intended towards having a single instance

installation of the application CPOS which would have better performance,

scalability, maintainability and better time to market.

CPOS will be a single integrated system.

CPOS will have automation built in wherever possible.

CPOS will display a high degree of flexibility and configurability.

Security standards will be as per the secure coding guidelines document

provided by Vodafone / IBM.

CPOS will be architected to ensure high availability

Roles & Responsibilities:

Daily interaction with client to discuss about requirements

Developed PL/SQL Packages, Procedures and Functions accordance with

Business Requirements

Loading data using SQL Loader.

Involved in Unit testing.

Involved in supporting production support team to fix bugs.

Coordinate with the team

Environment: Oracle 10g, Java, and Toad

PROJECT

Project Title : Health Care System

Duration : July '2010'-Sep '2011'

Description:

"Health Care System" which addresses the entire modern functional areas of

modern multi-specialty hospital. HCS can be easily customized to be the

requirements of any hospital. This application contains a reminder system

for Doctors and patients. This application is designed to reduce the

redundancy in Collecting the same information from the patients, Insurance

Assistance, Drug Assistance, In and Out Patient Details etc. Any patient

and doctors current location can be verified through enhancement search

technique.

Roles & Responsibilities:

Developed PL/SQL Packages, Procedures and Functions.

Design user defined integrity triggers to maintain the security and

validity of data between users

Involved in Unit testing.

Environment: Oracle 10g, Java, Windows XP and Toad

PROJECT

Project Title : Project Office System

Duration : Nov '2009'-June '2010'

Description:

POS is a highly useful system to manage the project related activity

effectively and efficiently. It helps us to operate easily on the system

and viewing the information is also flexible and understandable. A major

aspect of project management is, however the on-going management of the

project-keeping the project on time and within budget. The Project Office

Executive System assist the organization in the form of Perform Analysis

and Reporting, View all the information regarding projects/resources

Capture/Edit the Project information, Capturing Project Metrics, Allocation

of resources for the project, Update the skill sets of resources

Roles & Responsibilities:

Developed PL/SQL Packages, Procedures and Functions.

Design user defined integrity triggers to maintain the security and

validity of data between users

Loading data using SQL Loader.

Involved in Unit testing.

Environment: Oracle 10g, Java, Windows XP and Toad.

Personal Details

Father's Name : Venkateswarlu

Sex : Male

DOB : 05-06-1988

Marital Status : Single

Nationality : Indian

Language Fluencies : Telugu, English

DECLARATION

I hereby declare that all the above written particulars are true to the

best of my knowledge and belief.

Place:

Date:

Anil Sunkara

Contact this candidate