Oracle PL/SQL Developer

NEHA AVINASH SHEWALE

Phone: 201-***-****

****.********@*****.***

PROFESSIONAL SUMMARY

● Over 6 years of experience in IT Industry

● Expertise in PL/SQL Programming using SQL PLUS, TOAD and SQL Developer

● Strong in Creating/Debugging Database Triggers, Procedures, Functions,

Packages and Database Scripting

● Experienced in PL/SQL Query writing and Query Tuning

● Ability to perform Importing, Exporting of the database

● Experienced in working with PL JSON, SQL Loader.

● Participated in various stages of SDLC namely, Requirement gathering, Detail

Design, Coding, Unit testing and Documentation of the entire process.

● Experienced in gaining agreement on translating customer requirements into

accurate specifications and developing workable project plans.

● Demonstrated ability to identify root causes of problems, consider both the long

and short term impact of proposed solutions and develop workable solutions.

● Ability to manage competing priorities and handle tight deadlines.

● Strong listening, interpersonal and analytical skills and a good team player.

● A self starter with a positive attitude, willingness to learn new concepts and

acceptance of challenges.

TECHNICAL EXPERTISE

Operating System : Windows 95/98/2000/XP, UNIX

Data Base : Oracle 9i/ 10g /11g,

Front End Tools : Oracle Developer 2000

Languages : C, PL SQL, UNIX Shell scripting.

Other Tools : SQL Developer, Oracle Enterprise Manager, Toad,

IBM Cognos 10, MS Visio.

EDUCATION

Bachelor of Engineering, Electronics and Telecommunication University of Pune, K. K.

Wagh I. E. E. R, Nashik

PROFESSIONAL ACTIVITIES/CERTIFICATIONS

● Oracle PL/SQL Developer Certified Associate.

PROFESSIONAL EXPERIENCE

: Tangible Value LLC / Town Sports International

Client

Location : Princeton, New Jersey

: Global Information Management System

Project

: Senior Software Developer

Role

: November 2013 Till Date

Duration

Town Sports International (TSI)

Town Sports International (TSI) Health Club Company is the largest in the Northeastern

United States. TSI owns and operates the Sports Clubs Network of clubs, which includes New

York Sports Club (NYSC), Boston Sports Club (BSC), Washington Sports Club (WSC) and

Philadelphia Sports Club (PSC).

GIMS is an Enterprise application to be used by TSI Staff to manage member’s information,

alerts, member enrollment, Point of sale, Club Schedules / Classes manger, Guest

Management, Trainer & Staff Workshift manager, interfacing with various hardware systems

such as Bar Code scanner, Web Cam, Credit Card Reader, Cash Drawer.

Responsibilities:

● Developed and modified tables, views, materialized views, stored procedures,

functions and packages.

● Created and modified database triggers, sequences, indexes.

● Optimized SQL statements and PL/SQL blocks. Performed query tuning using

Explain Plan.

● Wrote stored procedure for Guest access code generation using Elliptic Curve

Cryptography.

Environment: Oracle 10g, PL/SQL, SQL Plus, Toad.

Client : Netwin Systems & Software (I) Pvt. Ltd., Nashik, India

: NEFT/RTGS Module for Co erative Banks.

Project op

: Senior Software Developer

Role

: March 2013 to October 2013

Duration

The goal of this system was to enable co operative banks to perform inter bank fund transfers

using standardized mechanisms like NEFT/RTGS and using big banks like ICICI as a proxy

which helped them expand their network and gave them the ability to transfer funds to any

other banks on this nationwide network.

Responsibilities:

● Involved in requirement gathering and design phases of the project.

● Designing database schema.

● Writing various Stored Procedures and Database Triggers for transaction

processing & validation.

● Writing Stored Procedures to encrypt table data using oracle

DBMS_OBFUSCATION_TOOLKIT.

● Mentoring two junior developers to build the front end using Java.

Environment: Oracle 10g, Oracle Developer 2000, PL/SQL, SQL Plus.

Organization : Netwin Systems & Software (I) Pvt. Ltd., Nashik, India

: Core Banking Solution for Cooperative Banks

Project

: Senior Software Developer

Role

: May 2012 to February 2013

Period

The goal of this project was to upgrade the legacy system by enhancing the User experience

as well as improve the efficiency of the backend system and data model.

Responsibilities:

● Writing Stored Procedures & Database Triggers for initializing client accounts &

transaction processing.

● Created Forms in Oracle Developer 2000 & wrote Stored Procedures to store PDF

documents & Images to database.

● Used PL JSON tool to implement JSON in oracle PL/SQL environment.

● Used SQL Loader to load from the source files to database.

Environment: Oracle 10G, PL JSON, Oracle Enterprise Manager, Oracle Developer 2000,

PL/SQL, SQL Plus, SQL Loader.

Organization : Netwin Systems & Software (I) Pvt. Ltd., Nashik, India

: Various Projects

Project

: Junior Software Developer

Role

: June 2008 to April 2012

Period

Responsibilities:

● Designed Forms & Reports using Oracle Developer 2000 for Loan Recovery System

of a Cooperative Bank.

● PL/ SQL libraries for generating PDF and text files and for multilingual application.

● Wrote Stored Procedures to generate Offsite surveillance reports as per Reserve Bank

of India guidelines.

● Used Oracle collection to receive and send data to remote databases which are

connected through DB links.

● Utility to create new users, export and import database, generate materialized views

and update data in views using refresh groups, create and manage indexes, stored

procedures, functions, packages, triggers and sequences, restart broken jobs.

Environment: Oracle 9i/10G, Oracle Enterprise Manager, Oracle Developer 2000, PL/SQL,

SQL Plus, SQL Loader.

Contact this candidate