Sr Developer & Analyst

Sapna Gupta MCA, Work Exp (* Yrs)

Mobile-779-***-****

PROFILE SUMMARY

• Recently completed Oracle training cum certification from Naresh technologies, Hyderabad

• Worked with Ashok Leyland for 2 years.

• Experience with Oracle 10g (PL/SQL).

• Knowledge of tool for oracle application(TOAD)

• Worked as a lecturer in GGDU University For 2 months.

CORE COMPETENCIES

•Sound Understanding of Oracle Database Architecture, Having Good Exposure in PL/SQL Procedures, Functions, Cursors, View, Triggers & Packages.

EDUCATIONAL QUALIFICATION

2008 M.C.A G.G.D.U. university 80%

2004 B.C.A Makhanlal Chaturvedi university 78%

2001 12th Science(Non Medical)MP board 76%

1999 10th MP Board, Bilaspur 74%

WORK EXPERIENCE

Project:

1. Intranet:

Intranet developed by & for Ashok Leyland pvt ltd is a comprehensive Human Resource Management System (HRVee)/Project Management System (ProVee) that brings greater organization and effectiveness to the full range of Human Resource/Project related functions, and responsibilities. Intranet provides for easy, accurate and timely retrieval of Employee and activity-oriented information through menu driven, user-friendly operations.

The network features of intranet are also robust. It can create user groups and can assign different levels of security to each group/user. Accordingly, the level of access to information is restricted to the end user, with the managerial authority having full access and front desk person having the least access. Relevant reports can be taken from the software in various formats which can be sent over to screen, file, printer, and email and web browser.

Role: Database Engineer Duration: (Nov 08) – (Dec -09)

Environment: ORACLE10g: Windows/Linux Team Size: 2

Responsibilities:

1. Analysis of software requirement specifications document.

2. Feasibility study and impact analysis of requirement specifications.

3. Creation of data dictionary.

4. Implementation of procedures functions & Trigger.

Organization: Ashok Leyland Duration: Jan 10 – Dec 10

Role: Database Development Location: - Bilaspur

Project:

1. Customer Management System (CMS):

The CMS is responsible to provide centralized environment for storing customer specific information (including personal information). CRS helps to target, aquire, retain, and understand prospective and sold customers.CMS is used to help manage a company or customers and sales relationship. It is used to organize sales, marketing and customer services areas.

Role: Database Development Duration: (Jan/2010) – (Dec/2010)

Environment: ORACLE10g Team Size: 4

Responsibilities:

1. Analysis of software requirement specifications document.

2. Feasibility study and impact analysis of requirement specifications.

3. Implementation of CMS system.

4. Creation of data dictionary.

5. Implementation of procedures functions & Trigger.

6. Involved in Coding, testing and debugging of PL/SQL stored sub-programs.

Contribution

As an entry level software engineer I was involved in preparation of interface, Data Dictionary documents and software release documents and coding of CMS releated Modules like Database, Stored Procedures, Tables, Triggers, Indexes, Sequences, etc. Procedure and view based interfaces coding .

ACHIEVEMENTS

• University Topper and Gold medallist in MCA .

• Done Course of Oracle 10g from Hyderabad.

• Done 1 month Traning on DMS software through Ashok Leyland.

• Awarded as a best employee of Ashok Leyland.

PERSONAL INFORMATION

Name : Sapna Gupta

Date of Birth : 10/06/1983

Gender : Female

Marital Status : Married

Languages known : English, Hindi

Address : Widiya Colony, Miyapur

Hyderabad

Contact this candidate