PL SQL Developer Resume

4 Years Experience PL SQL Developer Resume

POOJA GAWDE
Contact: 0091-7788994512
E-Mail: pujagawdeplsql@yahoo.com

Seeking managerial level assignments in Oracle PL/SQL Development / Database Administration with a leading organization of repute in IT sector preferably in Pune /Bangalore / Hyderabad

Profile Summary

•    A focused professional with nearly 4 years of experience in:

~ Software Engineering        ~ Database Administration        ~ System Analysis
~ Requirement Gathering        ~ Query & Package Optimization    ~ Oracle PL/SQL Development

•Expertise in applications encompassing system design & analysis, development and implementation
•Deft in handling project management activities which include planning, design, scope management, estimation, resource administration and completion of project within specified parameters
•Possesses extensive experience with in constructing triggers, tables, user defined functions, views, indexes, user profiles, relational database models, data dictionaries and data integrity
•Extensively worked on SDLC, J2EE, Oracle SQL, PL/SQL, Oracle Forms and Oracle Reports
•An effective communicator with honed people management, relationship management, analytical & coordination skills

Core Competencies:

Managerial

•Handling end to end project management activities inclusive of planning, effort, design, scope, estimation, resource coordination and delivery as per specified timeframes
•Leading & managing project teams throughout the project lifecycle and providing them support & guidance on technical and project-related issues
•Managing code deployment, change management and quality assurance; providing technical support to Application Development Teams and setting / maintaining standards
•Preparing work plan, design activities, use case, etc.; carried out the study of the current system

Functional

•Creating tables paces, rollback segments, user maintenance, database security imposition by creation and granting of roles & privileges, performance tuning, backups, tuning of SQL statements and support for oracle toolsets and utilities
•Undertaking design & development, testing, debugging and troubleshooting of the application; overseeing smooth implementation of the application

Organizational Experience:

Infosys Technology Limited, Pune as Senior System Engineer

Key Result Areas:

•Spearheading entire gamut of operations inclusive of:
oMapping client requirements by participating in meetings and studying existing system review
oCreating E-R diagrams, Function Hierarchy diagrams, Process diagrams, Data Flow diagrams using Oracle Designer
oBackend Programming using PL/SQL, Stored Procedures, Functions Packages, Database triggers for Oracle 10g/11g and also SQL queries and migration scripts
oUsing SQL TRACE and Profiler, Pl/SQL developer tools for debugging, Explain Plan, SQL tuning, collection of statistics and creation of indexes for database access and indexing the required columns
oProviding Front End Support using J2EE, experience in working with application servers like Tomcat, Web Sphere
oCreating complex relational and data warehouse infrastructures DB Objects (Triggers, Stored Procedures) / DB Models and associated architecture
oDesigning application CSS for 24 companies like Nomura, Shire, Addidas, Videophone and UBS (Union Bank of Switzerland), etc.
•Looking after analysis, design, development, maintenance, testing, documentation and implementation based operations
•Managing OLTP, OLAP components, stored procedures, triggers, analytical functions and complex queries
•Working on Composite data types, Cursors, Dynamic SQL and Global Temporary tables
•Accountable for issue resolution and root cause analysis
•Monitoring the design and development of reusable enterprise systems and various web applications using J2EE technologies like Servlets, JSP, and JDBC
•Rendering services as Onsite Coordinator since 1 year, directly interacting with clients gathering requirement, and do the development as well as assign work

Highlights:

•Rewarded with:
oSpot Award for Excellence in Quarter Q1 11-12, Q2 11-12
o3 Quarterly Awards
oAn appreciation from Business Head of the client
•Dexterously cleared Infosys Training with 4.52 CGPA
•Essayed a stellar role as:
oOffshore Database Anchor for coding standards and best practices
oOnsite Coordinator for the execution of Corporate Employee Financial Services based project using PL/SQL Programming, database optimization
•Meticulously contributed in the successful:
oExecution of projects such as Washsale and TFM, Swiss Banking Secrecy Waiver, etc.
oDeployment of the code review packages in UAT which facilitated the timely running of automation scripts
•Proactively trained the team members on the process improvements

Academic Details:

•BE Computer Science & Engineering Girdhar Siksha Evam Samaj Kalyan Samiti Group of Institutes

Certifications:

•Oracle Certified Associate (OCA)-Oracle Database SQL Expert & Oracle Database 10g: Administration I 1Z0-042
•Banking and Capital Markets

IT Skills:

Databases    :    Oracle 10g, 11g, Database Design and Normalization
Operating Systems    :    Microsoft Windows, Unix
Languages    :    PL/SQL, SQL, Java, JSP and ANT
Web Technologies    :    HTML, CSS
Application Server    :    Tomcat, Websphere
Tools        :    Toad, PL/SQL Developer, RAD (Rapid Application Developer Tool)
Others        :    Basic UNIX Commands and Shell Scripting & Tuning Poor SQL Queries for Performance Improvement

Social Engagements:

•Rendered services as the Member of Green Peace Organization
•Contributed in Charity Donations

Personal Details:

Date of Birth    :17th Septer, 1985
Address        :Schaffhauserstrasse 463, Zurich - 8052 
Languages Known    :English & Hindi

(Refer to Annexure for Project Details)

ANNEXURE

Major Project:

Title:            Corporate Employee Financial Services (CEFS)
Client            Union Bank of Switzerland (UBS)
Synopsis:    A CMMI Level 5 Project, department of UBS Wealth Management US delivers first class equity compensation plan services and support for stock, options, restricted grant awards, performance grant awards, stock appreciation rights and employee stock purchase plans.UBS Corporate Employee Services (CEFS) delivers comprehensive expertise, professional implementation and effective communication support for your equity-linked compensation plans throughout their life cycle.

Role:    Deftly carried out the following accountabilities based on:

•Backend Programming using PL/SQL, Stored Procedures, Functions Packages, Database triggers for Oracle 10g, 11g and also SQL queries and migration scripts
•Serving as DB Anchor for the team, for following Coding Standards and best practices during database development
•Analysis, design, coding and testing
•Using SQL TRACE and Profiler, Pl/SQL developer tools for Explain Plan, SQL tuning, collection of statistics and creation of indexes for database access and indexing the required columns
•Handling composite data types, cursors, dynamic SQL and global temporary tables
•Following the coding standards and best practice in project and served as DB Anchor for same
•Providing  Front End Support using J2EE, experience in working with application servers like Tomcat, Web Sphere
•Maintaining proper documentation of the application
•Looking after the issue resolution, root cause analysis and designing applications like Nomura, Shire, Addidas, Vodaphone and UBS (Union Bank of Switzerland), etc.
•Design and development of reusable enterprise systems and various web applications using J2EE technologies like Servlets, JSP and JDBC

0 comments:

Post a Comment