Sr. Oracle Pl SQL Developer

SONAL SHROFF

(Sr. Software Developer)

Email: ******.*****@*****.***

Ph: 703-***-****

Experience Summary

Experience in implementing SDLC: (Modified/Iterative Waterfall model) Requirements gathering, System Design, Development and implementation of enterprise applications, Testing and Deployment

5 years of experience working with Oracle 8i/9i/10g including PL/SQL programming.

Proficient in writing complex SQL Queries, stored procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries

Certified in Oracle 9i IZ0-007 – Introduction to Oracle 9i – SQL. Testing ID: OC0929153

4 year of C/C++ experience in software application development and support in IBM for Telecom Giant – Vodafone

4 years of database management experience with more then 1 TB of data

3 year of Experience with Tuxedo middleware, TIBCO, Shell Scripting

1 year of experience with VB.Net stand alone application

Good experience working on Crystal Reports for reporting

Very Good experience with UNIX Cron Jobs, Batch Processing with highly complex data model

Expert in Performance Tuning, Analyzed long running queries and tuned them to optimize the system performance.

Good Experience working with large set of data

Good exposure in building Android apps. Developed small applications such as scheduler

Experience in designing, configuring of console applications in VB.NET

Good Experience working in Telecom domain, Healthcare domain

Developed various Re-usable components and C/Unix based utilities for team use and awarded with quality points (Q-Forum) in IBM.

Involvement in System Study, preparation of Detailed Design (DD), Development (Coding), Unit testing, System testing and Integration testing,

Good Exposure to all Quality Assurance processes from requirements phase to project deployment

Good Experience in development and maintenance project.

Very good team Player

Excellent Communication and Interpersonal Skills

Enthusiastic, Hardworking, Quick Learner and always eager to take up new challenge

Skills

Languages Oracle SQL, Oracle PL/SQL, C, C++, UNIX Shell Scripting, VB.Net, Java, ClearBasic, Perl

CRM Packages Clarify 10.1(Amdocs Product)

Operating Systems Windows 9x/2000/XP, UNIX, Android 2.2

Database Server Sybase, Oracle 9i/10g

Tools SQLDbx, IBM RPM, IBM Clear Quest, Toad, Sql Developer, Putty, Crystal Reports

Development IDE Microsoft Visual Studio 2005/ 2008, Eclipse

Configuration Management PVCS (Open Source)

Project Experience

Client Cigna Jan’10 to Jan’11

Role Sr. PL/SQL Developer

Project Health Inform

Health Inform is a System, which gives all information about the Patient including his Medical History, treatments, prescriptions, drugs he is taking currently, his doctor information etc.

Responsibilities:

Configured and designed Entity Relationship Diagram (ERD) with Data Design Team to illustrate the logical structure of database

Developed stored procedures and complex packages using PL/SQL for maintaining Patient Information

Developed complex SQL queries using various joins and developed various dynamic SQL(Sub queries and Join conditions, correlated sub queries)

Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment in PL/SQL and SQL*Plus.

Optimized the query performance with modification in PL SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful indexes

Created Documentation of development code and the test cases involved.

Create reports in Crystal Reports. Used PL SQL & Toad for creating queries/ procedures for reports

Designed database tables using various normalization techniques and database rules

Followed all processes and procedures for application deployment for new as well as existing.

Design, develop, and conduct unit test plans for ensuring application code is functioning correctly

Environment:

Oracle 9i, PL/SQL, UNIX Shell Scripting, C, C++, Crystal Reports

Client Vodafone Spain Feb ’09 to Jan ‘10

Role Sr. Application Developer

Project Manhattan Vodafone

This project aimed at transition for a customer from Simple Fixed line connection to a high Speed Internet Connection. The functionality to be implemented under this Project was to provide ADSL services to Vodafone clients in areas where Vodafone does not have direct access. Hence, ADSL services are provided indirectly in locations where Vodafone cannot serve directly in order to offer service of national coverage.

My role was the development of a batch process (cron jobs) which will run on a fixed schedule and would perform the activations/deactivations of promotions Discounts etc. and send orders for Networking (Serpa system) and Billing (Arbor). Also Analyzed long running queries and tuned them from 20 minutes to 14 minutes, to optimize the system performance with the help of indexes.

Responsibilities:

Understanding and transforming the High level design documents to low level detailed design.

Development of New GPRS line activation timely and integrating it further to be a part of whole running project and Customizing existing activation flow.

Responsible for Data modelling and schema changes (new tables addition and updating existing tables) in production.

Developed stored procedures and complex packages extensively using PL/SQL and shell programs

Performance testing of the application programs using EXPLAIN PLAN, TKPROF, SQL TRACE

PL/SQL Coding and SQL tuning throughout the development wherever needed.

Since project involved many teams (provisioning, Billing, Tibco, Clarify) I Worked with multiple teams starting from determining software requirements till deployment of the project.

Set up historical data (6 months of transactions) for all different teams in the platform using stored procedures

Done the performance tuning of the existing batches handling more then 1 TB of data.

Developed Functions and procedures for the reconciliation of data

Preparation of large volume of test data for batch execution.

Used to give the estimate of development percentage done for project planning updates

Designing & giving recommended approach to satisfy the requirements

Done all versioning control and followed all processes and procedures for application deployment for new as well as existing.

Preparing Weekly Status Reports and SLA reports.

Environment:

C, C++, UNIX Shell Scripting, Tuxedo Middleware, PL/SQL, Oracle 9i

Client Vodafone Spain June ’08 to Jan ‘09

Role Sr. Application Developer

Project Blackberry batch performance tuning

This project was solely aimed at performance tuning of a batch named “batac_blackberry_db”. This batch used to take 48 hours to send data to stratus system on daily basis.

My job was to fine tune the batch involving the SQL queries in such way that it takes minimum amount of time to send Customer billing data. To achieve the desired result we reduced the workload by using the concept of incremental batch processing. In spite of doing table scan daily we changed the query such that it used to pick data as per the timestamp and all other information was taken from flat file. Main query use to run once in every month and data would be kept in files for faster access.

After performance tuning, Batch execution time was reduced from 48 hours to 22 hours! This project was a big success.

Responsibilities:

Performed performance tuning of the overall system by eliminating redundant joins, creating indexes, removing redundant code handling more then 1 TB data.

Performance testing of the application programs using EXPLAIN PLAN, TKPROF, SQL TRACE

Preparation of large volume of test data for batch execution.

Tuning and optimizing current and new applications through regeneration and rebuild of indexes and creation of views.

Introduced flat file processing in batch.

Incremental batch processing instead of scanning whole database at a time

Performance tuning of existing batch handling more then 1 TB of data

Restructured C modules for activation, deactivation and modification of blackberry plans in Clarify Front End

Carrying out Product Unit and Integration Testing

All quality processes including Defect Tracking using IBM ClearQuest

Environment:

C++, C, UNIX Shell Scripting, Tuxedo Middleware, PL/SQL, Oracle 9i

Client Vodafone Spain Jan ’08 to June ‘08

Role Sr. Application Developer

Project Lunitari

This project introduced new Price Plans with features of low-cost time slots to be chosen by the customers. This price plan was available only for corporate clients. It included national calls to landline and mobiles.

My work was to design, code and implement the new requirement and customize the existing application as per need. Development of batch programs to activate the newly configured price plan was the key part of the project and I successfully id the same. The Project also aimed at Providing Customers of Vodafone Spain with special Discounts and promotions on various types of usage including SMS, MMS and GPRS based usage. Discounts were based on the customer loyalty with Vodafone and were based on usage.

Responsibilities:

Involved in all phases of the SDLC for Designing & giving recommended approach to satisfy the requirements.

Responsible for schema changes (adding new Tables and updating existing Tables) in production.

Preparation of large volume of test data for batch execution.

Developed Procedures and functions for activation of price plans

Implemented cursors in numerous procedures

Performance tuning of existing batch because of addition of a new price plan for exiting price plans.

Development of C modules for activation, deactivation and modification of these plans in Clarify Front End

Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.

Setting up Best Practices for Architecture, Coding & Content Deployment

Carrying out Product Unit and Integration Testing

All quality processes including Defect Tracking using IBM ClearQuest

Environment:

C++, C, UNIX Shell Scripting, Tuxedo Middleware, Oracle 9i, Clarify

Client Vodafone Spain May ’07 to Dec ‘07

Role Sr. Application Developer

Project Clarify Migration Process

The Project Migration of Clarify was aimed at transferring the application and Business knowledge from existing vendors to IBM India. It also involved setting up of new environments for Development, Testing and Preproduction Steps. It also aimed at integration of Clarify CRM with other existing systems through Middleware.

Responsibilities:

Involved in all Knowledge transfer sessions from Onsite Coordinators

Played a key role in all Data modelling discussion for Data design Team

Responsible for sharing application knowledge with all team members

Involved in Performance tuning concepts, future scope, Limitation.

Responsible for the maintenance of all Application Information documents

Building a central repository of all Application Interface documents

Maintaining MOM’s for all offshore KT sessions.

Environment:

C, C++, UNIX shell scripting, Oracle 9i, PL/SQL, Toad, Clarify

Client IBM Feb ’07 to May ‘07

Role Application developer

Project Reading/Recovery of files in FAT file system

This tool reads Master Boot Record, Boot Sector, File Allocation Table, Root Directory entry, Data Area of FAT12, FAT16, FAT32 File System using the low level programming features available in C. Along with reading it can also recover files, deleted from FAT12 system.

Responsibilities:

Understanding the requirement and done the feasibility analysis

Preparation of high level design and Mapping it with low level design

Followed best approach to solve design issues.

Involved with design, coding implementation, testing

Environment:

C Graphics (Low level C program implementation)

Client IBM Research Lab Sep ’06 to Jan ‘07

Role Application Developer

Project Sanrachna – Hindi Grammar Checker

Sanrachana - Hindi Grammar Checker includes Spell Checking facility designed along with Bottom-up Parser and Semantic Analyzer for text written in Hindi. This tool has an in built in text editor where a correct syntax of a Hindi statement can be checked. Implemented Semantic Analyzer does the correction on the basis of number and gender usage. It also gives a feature of spell checking and provides suggestions for incorrect word.

Responsibilities:

Understanding the requirement and done the feasibility analysis

Preparation of high level design and Mapping it with low level design

Followed best approach to solve design issues.

Involved with design, coding implementation, testing

Environment:

VB.NET, MS-Access 2000

Client IBM Jun ’06 – Sep ’06

Role Application developer

Project Transliteration Mapping System

Transliteration Mapping System is script convertor software that converts Devnagari Script (Hindi Text) into Roman Script (English Text). This script convertor is helpful for those who do not have knowledge of Devnagari script. But to read out the content this tool converts the script to roman script.

Responsibilities:

Understanding the requirement and done the feasibility analysis

Preparation of high level design and Mapping it with low level design

Followed best approach to solve design issues.

Involved with design, coding implementation, testing

Environment:

VB.NET, MS-Access 2000

Employer: Manipal Hospital, Bangalore, India Feb ’06 - Jun ‘06

Role: Developer

Project: Health Information System

This application automated the Health Information flow in Manipal Hospital, Bangalore. The Windows based application involved integrating 52 departments including In-patient, Outpatient, Lab, Surgery, Billing, Registration, Cardiac Ward, and many more.

Responsibilities:

Component Development using VB

Design and Coded Business Process Designer for capturing new processes

Involved in Code Reviews of other modules

Test Script for uploading test data

Code generator for new Windows Forms

Environment:

Visual Basic 6.0, Java Script, IIS 5.0, Windows 2000, Visual Source Safe

Educational Qualification:

Masters in Computer Application (Banasthali University, Rajasthan, India)

Bachelor of Computer Science Honours. (Banasthali University, Rajasthan, India)

Achievements:

Won Star Performer award, in IBM Vodafone Spain project, with team size of 80.

Silver Medal in MCA (Master in Computer Application) Banasthali University

Silver Medal in B.Sc. (Computer Science Honors) Banasthali University

Vice-President of Computer Science Department, Banasthali University

Contact this candidate