Sql Developer

Curriculum Vitae

Address YASHPAL

Mob : +91-921*******

H. No. 143,Sec-22, Sanjay Colony,

NIT Faridabad.

E mail: ****.********@*****.***

OBJECTIVES AND VISION

Desire to apply knowledge, education, experience and exposure gained so far

to update myself with the latest technological trends and contribute to its

i mplementation services and multi- tier technologies [SQL, PL/SQL( Oracle

10g)].

EDUCATIONAL QUALIFICATION

3 M.C.A. Pursing From IGNOU, Delhi(2013).

4 BCA. from M. D. University,Rohtak(2012).

5 10+2 from H BSE Board (2009).

6 10th from H BSE Board (2007).

INDUSTRIAL TRAINING

7 6 Months training on SQL,PL/SQL from DUCAT.

SKILL SUMMARY

ORACLE PL/SQL DEVELOPER

Responsibilites :-

8 Installation of Oracle 10g.

9 Extensively worked on stored procedures and triggers.

10 Worked on Materialized views, Complete Refresh.

11 Fast Refresh,Use the Rollup and Cube Operator.

12 Implict Cursor,Explicit Cursor,Error Handling.

13 Performed database activities like tables/users/indexes creation using

PL/SQL DEVELOPER.

14 Created

Users,Roles,Profiles,Triggers,Procedures,Functions,Package,Sequence

s as per business requirements.

15 Customized the Workflow process of the reports by modifying existing

procedures and developing new procedures in the PL/SQL packages.

16 Created procedures/triggers to track user activities and data loading.

17 Used TOAD to perform SQL tuning and other database maintenance

activities.

18 Worked on performance of SQL, PL/SQL and analyzed Tables.

19 Creation on new database.

20 Granting privileges on objects to user.

14 Advanced SQL & Advanced PL/SQL .

PROJECTS

Project Details#

Title:- Customer Care Administration.

Client: - Reliance India mobile .

Environment: - SQL,PL/SQL Windows xp.

Database: - Oracle9i/10g.

Team size: - 22

Description :-

This project is used to manage all the accommodation of mobile and sim card

t hat is provided by the company to their employee according to their

positions.

Roles and Responsibilities:

• Involved in table design and writing stored procedures for retrieving

and updating data for Oracle.

• Prepared the test Cases against the Basic functionality.

• Writing the database scripts, backend procedures, functions and

t riggers.

SYSTEM EXPERIENCE

21 Operating Systems : Windows XP/ 7/ Vista, Windows 2000/98 .

22 Web Tools : HTML, CSS,Adobe photo shop,dreame weaver.

23 Databases : Oracle 10g.

24 Languages & Packages : SQL, PL/SQL.

25 Tools & Utilities : Toad, PLSQL Developer.

STRENGTHS

• Work according to priorities and meet deadlines.

• Flexible at working schedules and adaptive to any change.

• Zeal to learn and take up challenges.

EXTRA CURRICULAR ACTIVITIES

• Participated in Debate Competition at school level.

• Participated in Cricket Tournament at school level.

HOBBIES & INTEREST

26 Listening Music.

27 Surfing through Internet.

28 Watching and Playing Cricket.

PERSONAL INFORMATION

Name : Yashpal

Father’s name : Sh.Jagdish Rajpal

Date of Birth : 09-mar-1991

Marital Status : Single

Nationality : I ndian

Linguistic Ability : English, Hindi, Punjabi.

DECLARATION

I here by declare that above information is correct to the best of my

knowledge and belief.

Place:

Date: (YASHPAL)

Contact this candidate