Oracle Sql

[pic]

EXPERIENCE SUMMARY

Oracle Certified Professional (OCP), Oracle PL/SQL Developer with close to

* ***** ********** ** *** design and development of Oracle University/

Oracle Education Online applications. Worked with Oracle University

Maintenance and Support team at Oracle Corporation. Possesses strong

knowledge of Oracle SQL, Pl/SQL, Mod-Pl/SQL, HTML DB, Data Warehousing

concepts, data modeling techniques. Worked as a point of contact for

customers and has excellent experience working in offshore-onsite model.

Experienced in managing small teams.

Excellent communication and interpersonal skills with good analytic power

and client facing skills.

Skills Matrix

PL/SQL SQL Mod-PL/SQL

Testing UNIX Shell scripts TOAD

Java script Performance Tuning SQL Plus

SQL Developer C,C++ Data warehousing

Operating Systems : Windows Xp, Windows vista, Unix

Database : Oracle 9i,10g

PL/SQL Concepts : Stored Procedures, Functions, Triggers, Packages,

Cursors, REF Cursors, Collections,

Materialized views, Exception Handling

Oracle Discoverer 10g

PROFESSIONAL EXPERIENCE

Oracle Corporation, Bangalore, India

July 2007 - April 2010

Senior Oracle PL/SQL Developer

Oracle Corporation (NASDAQ: ORCL) is a multinational computer technology

corporation that specializes in developing and marketing enterprise

software products - particularly database management systems. Headquartered

in Redwood City, California, United States, Oracle employs more than

100,000 people worldwide.

Industry: Training&Education

Environment: Oracle 9i, SQL, Pl/SQL, Java scripts, HTML, Mod pl/sql, HTML

DB

Project 1: Oracle University Resource Center (OURC)

Oracle has partners and contractors globally across all the regions like

APAC, NORTH AMERICA, LATIN

AMERICA, JAPAN AND EMEA.OURC is an online application which is being used

by Oracle University

Instructors and the Regional Managers across the globe. This OURC is used

by the Oracle Instructors, Partner

Instructors and Contractors. All users have their own access to the

application. This application is a one point

show stop of all the information about the Oracle University Classes that

are scheduled, Instructors handling

The classes, the student evaluations etc.,

Responsibilities:

. Requirement gathering and enhancing the features of OURC application.

. Development, Support and maintenance of Oracle Education site

http://education.oracle.com.

. Created SQL scripts, PL/SQL stored procedures to extract data and show

them on the UI of the OURC application.

. Tuned complex SQL queries running in Oracle Education portal database.

. Developed materialized views to be used by the Oracle Education

portal. These views were created to enhance performance of the system.

. Worked on Collections like Record type, Table data types.

. Worked on REF cursors with in the procedures to dynamically run the

cursor queries.

. Created reports in Mod Pl/SQL to extract data from various data marts

which are used by the instructors, users, regional managers of Oracle

University globally

. Created various reports that provide the required information to the

users of OURC. The reports included Event Schedule reports, Instructor

Schedule reports, Evaluation reports, etc.,

. Created Refresh procedures, stored procedures, designed collections,

triggers to be used on the Oracle Education portal.

. Created technical documents and Developer Guides for the customer

facing applications.

. Resolved bugs and other issues arising in Oracle Education site.

. Conducted technical trainings on Oracle SQL, PL/SQL as part of Oracle

academy.

Project 2: Oracle University E-Attendance

E-Attendance is an online application that is being used by Oracle

University worldwide. It's an application which is used by the OU

instructors and the customers/students who attend the class. Students who

attend the class sign in the attendance using this application. The

instructor checks that all the students signed in and he verifies the

attendees list. This list is the main report which is being used by the

Oracle University to charge the customer and get the revenue. This is a

customer facing application which should be up always since it effects the

revenue generation of Oracle University. This application is developed in

Mod PL/SQL and the reports are developed in HTML DB. Oracle partner and

contractor employees also can attend the classes.

Responsibilities:

. Requirement gathering and enhancing the features of Oracle University

EAttendance

. Development, Support and maintenance of the customer facing

application

. Provided UI enhancements to the Reports available on Oracle

EAttendance portal.

. Created reports in HTML DB to extract data from various data marts

which are used by the instructors of Oracle University globally.

. Created SQL scripts, PL/SQL stored procedures to extract data from

OLTP systems & to load into the data marts.

. Created reports using Oracle Discoverer 10g

. Tuned complex SQL queries running in Oracle EAttendance portal

database.

. Developed materialized views to be used by the Oracle EAttendance

portal. These views were created to enhance performance of the system.

. Designed and developed Business Reports to be used by the customers on

Oracle EAttendance portal. The reports included Student sign in,

Instructor verify reports etc.,

. Created stored procedures, designed collections, triggers to be used

on the Oracle EAttendance portal.

. Created technical documents and Developer Guides for the customer

facing applications.

. Resolved bugs and other issues arising in Oracle Education site.

. Trained other developers/team members on functionality of the

application and on Oracle's coding and compliance standards.

. Resolved high priority issues with a quick turn around time.

Achievements:

. Awarded as "The Unsung Hero" for the 2009-Q3 for the best performance

and contribution towards the enhancement of the customer facing

applications.

. Received a memento for mentoring the junior developers efficiently and

supporting them to work on board.

. Resolved the highest number of issues raised in the online

applications with quick turnaround time.

Wipro Technologies, Bangalore, India

November 2004 - June 2007

Oracle Developer

Wipro Technologies Limited is a giant information technology services

corporation headquartered in Bangalore, India. Wipro is one of the largest

IT services company in India and employs more than 108,071 people worldwide

as of March 2010.It has interests varying from information technology,

consumer care, lighting, engineering and healthcare businesses.

Industry: Banking and Insurance (Jan 2006 - June 2007)

Client: The Hartford, Connecticut

Environment: Oracle 9i, SQL, Pl/SQL, UNIX

Project Name: Claims Processing

Responsibilities:

. Involved in requirements gathering, creating functional & technical

design documents, Coding & Unit Testing, SIT and UAT.

. Responsible for development, implementation and support of the

database.

. Optimized and modified the triggers, complex store functions,

procedures etc.

. Assisted a junior developer in the development of the database,

procedures, functions, etc.

. Responsible for the dealing with the problems, bug fixing and

troubleshooting.

. Written UNIX shell scripts to execute the oracle stored procedures on

the server.

. Tuned complex SQL queries to improve the performance.

. Resolved bugs and other issues arising in Oracle Database.

. Developed materialized views to be used by the application. These

views were created to enhance performance of the system and to refresh

the data on the local servers.

Industry: Banking and Insurance (Nov 2004 - Dec 2005)

Client: UBS

Environment: Oracle 9i, SQL, Pl/SQL

Responsibilities:

. Understanding business data relationships

. Created Complex SQL queries and PL/SQL procedures

. Created database objects and refreshes for refreshing the data from

external database servers to local servers.

. Responsible for the development, implementation and support of the

database of the server.

. Optimized and modified the triggers, complex store functions,

procedures etc.

. Responsible for the dealing with the problems, bug fixing and

troubleshooting.

. Worked on materialized views and refreshed the data at regular

intervals to refresh the data on the local servers.

. Handling duties like designing, updating, debugging, writing

specifications and codes for applications.

. Maintained good rapport with the co-partners and seniors.

. Given some technical sessions to the team.

Achievements:

. Received FIMC (Feather In My Cap) Award twice for the best performance

and the maximum fixes in the application.

EDUCATION

. Bachelor of Technology in Computer Science & Engineering from

Nagarjuna University with 83.96% (2000-2004).

[pic]

VENKATA S. MADDALI

Contact this candidate