Sql Oracle

Divya K Manjunatha

Phone:408-***-**** / Email: *****.**@*****.***

SUMMARY

. Around 7 years of IT experience in Applications Design, Development,

Integration & System Testing of Oracle as PL/SQL Developer on Unix

platforms.

. RDBMS experience includes SQL, PL/SQL Programming on DB2, Oracle

Databases, Performance Tuning, Trouble Shooting, Packages, Stored

Procedures, Triggers, SQL*Loader.

. Experience using Oracle Application Express (Apex), JQuery and Oracle

Forms.

. Application Design, Development and implementation using C, Pro*C, C++

. Sufficiently Skilled on Unix Shell scripting, XML, with exposure to

Perl.

. Strong knowledge of Web UI technologies using HTML, JavaScript and CSS

. Knowledge in SAP BI.

. Experience in Team Leading activities (Like work assigning,

estimation, monitoring, help to debug problems, Knowledge sharing

etc.)

. Was complimented by IBM with "BRAVO AWARD" - "In recognition of

significant contribution to the application & continued dedication to

the Sprint Nextel-EmbarQ Account" with a cash award and a Certificate.

. Actively involved in Production Support for CDR Archive of Sprint

Telecom.

. Exposure to Production Outage Activities.

. Played the role of Build Master during deployment to Production.

. Solid experience in designing test plans and writing test cases.

. Took up the role of Quality Assurance Lead and assisted in Audit

Activities.

. Hands on experience with all phases of Software Development Life Cycle

(SDLC).

. Good Exposure to interacting with the customers.

. Good analytical skills along with a can do attitude.

. Self-motivated, quick learner and willing to adapt new challenges,

Team player.

TECHNICAL SKILLS

Operating Systems : AIX, Unix, Windows, Sun Solaris

Language : C, C++, PL/SQL, HTML, XML, Pro*C

Scripting : Unix Shell Scripting, JavaScript, Perl.

Database : DB2, Oracle 9i/10g

Version Control : Configuration Management using

SVN Tool

Tools : SQL Developer, TOAD 8.6 / 9.0, GDB, Oracle Application

Express 3.0/3.1, Oracle Forms, Erwin, Visio, SAP BI

7.0, Matlab Image Processing Toolbox.

EDUCATION / CERTIFICATIONS

. B.E in Electrical & Electronics from Dr Ambedkar Institute of

Technology, Bangalore, India.

. Oracle Certified Professional: Form Developer

. Oracle Certified Associate: SQL + PL/SQL Programming

. Brainbench Master Certification in Oracle PL/SQL Fundamentals.

. IBM - AIX Certified.

WORK EXPERIENCE

Walgreens, Deerfield, Illinios Jan 2010 -

Current

Oracle Developer

Current in-store workflows and Pharmacy IT systems do not support the 90-

day offer and conversion process. Provide pharmacy staff with a flag driven

automated process to convert 30-day chronic care scripts to 90-day scripts.

This project will provide the KPIs needed to manage and measure pharmacy

operations that are specific to a 90-Day. 90Day specific KPIs are needed to

measure growth and identify opportunities for improvement in the stores.

Roles / Responsibilities:

. Involved for the complete software development life cycle.

. Designed the logic and implementation in pro C also enhanced the

current features to include 90Day changes.

. Optimized the logic and was part of the sustenance activity.

. Responsible for performing code reviews. Fine-tuned and optimized

different SQL queries to ensure faster responses.

. Additionally was solely responsible in code changes of unattended data

process, which synchronizes the changes from the central database to

the local store's databases without manual intervention.

. Created the Unit test cases and Unit tested the code.

. Build activities and supported the release to customers.

. Investigated and created the test data from the front end IC+, which

is Walgreen proprietary software those are used in stores.

. Was actively involved in project meeting. Submitted technical

knowledge document to the company's knowledge portal.

Environment: Oracle 10g, ProC, SVN, SQL, PL/SQL, AIX, Linux, Golden

Rainin, Oakland, California April

2009 - Dec 2009

Oracle Developer

Rainin's B2B customers orders are received through market places sales

channels like Sciquest and Ariba, where the catalogs are hosted. With the

B2b e-Commerce design, a middle ware application is developed which handles

market place integration, CXML Validation, CXML Processing and which takes

care of the order validation and pushes the order into Entered State.

Roles / Responsibilities:

. As a programmer, I was involved in the coding back end interfaces

using PL/SQL stored procedures, functions, packages which performs the

Order validation, exceptions handling processing of the incoming

orders

. Used the Analytical functions to handle consecutive query conditions.

. Created schedules using built-n packages like dbms_job, dbms_scheduler

. Utilized SQL*Loader to load flat files into the database tables.

. Utilized TOAD in developing all back end database interfaces.

. Maintained Log files during analysis and subsequently report any

performance defects.

. Responsible for performing code reviews. Fine-tuned and optimized

different SQL queries to ensure faster responses.

. Created the Process flow diagrams for each functions on the schema

using the MS Visio

. Developed user documentation for all the application modules. Also

responsible for writing test plan documents and unit testing for the

application modules.

. Actively involved in End-to-End testing.

. Worked with DBA in making enhancements to physical DB schema. Also

coordinated with DBA in creating and managing tables, indexes, table

spaces, auditing, data quality checks and db links.

. Was actively involved in project meeting. Submitted technical

knowledge document to the company's knowledge portal.

Environment: Oracle 10g, SQL, PL/SQL, SQL*Loader, UNIX, TOAD, TKPROF, ERWIN

IBM India Private Limited July 2006 -

March 2009

CDR Archive, Sprint Telecom

Application Developer

Sprint is one of the leading telecom service providers in US. CDR Archive

is a 24x7 system that receives all type of call / mobile user's records,

which is processed and then loaded into appropriate database. Various

Sprint departments like Fraud, Finance, and Marketing etc use this data.

Courts and FBI etc also use these for legal purposes.

Roles / Responsibilities:

. Development/Enhancement

o With growing telecom technology new categories of calls get added and

sometimes the existing feed needs to be enhanced. As a part of Core

development team we incorporate these into the Database.

o Depending on the requirements of down stream different types of reports

that cater to their need are generated on Daily, Weekly and Monthly

basis.

o Some Adhoc requests for one time generation of reports are also honored.

o Maintenance and enhancements of the existing GUI Applications developed

using Oracle Application Express.

o Scripts to monitor the system health were developed time and again.

. Configuration Management

o Assigned as the Build master of the deployment was responsible for

> Creating the environment for the developers.

> To co-ordinate with Build Management Team for build issues.

> Migrate executables to the testing environment and finally to the

production environment.

. Production Support

o Support the system on 24X7 (including the weekends) basis to monitor the

application, aided with automated reports and pager facilities to help

identify issues if any.

o Some scenarios might need to bring down the applications completely

resulting in an Outage. These could be both planned and unscheduled as

well. As a production support activity need to take care of stopping and

starting of the applications and taking care of the communicating to

Business Users during this time frame. Later redo the activities that

were scheduled during outage time.

Environment: AIX, C, C++, Pro*C, SVN, DB2, Oracle 10g, GDB, SQL, PL/SQL,

Oracle Application Express, TOAD

HPPTT (High Performance Push To Talk) Report

CDR Archive needs to generate a report consisting of call, minutes, summary

and PII interop reports to Product Team on monthly basis.

Categorization were based on different types of

. Segments - Consumer, Enterprise, General Business, Public Sector, and

System Integrators/Alliance.

. Call - Direct, Adhoc Group, Closed Group, and Closed Chatroom, each

were further classified as Buy-Up, PAYGO, and Price Plan.

. Member - Originator, Participant.

For summary report, average number of calls/active subscriber and average

number of minutes/active subscriber will be based on unique count of

subscriber in HPPTT UDR table for that month.

Analysis also indicated total number of calls made and total minutes of

usage.

All these details were fetched based on the specific business logic

assisted with an Input file that will be sent from the user.

Roles / Responsibilities:

. Implemented PL/SQL stored procedures that load the temporary table over

which SQL Queries are executed.

. Entire process was automated by a script and triggered from the cronjob

. Report needs to accumulate previous month's data. Since the base table

had the limitation of having only 60 days of records, a additional table

was created to accumulate all data required for this report.

. Implemented a summary process that could be executed to validate the

results.

. Created a User interface using Oracle Application Express, which

retrieved the needed information from the Results table. Multiple reports

based on different categorization mentioned above were displayed in

different tabs using JQuery Tabs.

Environment: Solaris, Oracle 10g, PL / SQL, SQL*Loader, Oracle Application

Express 3.1, JQuery Tab, Shell Scripting.

Migration of CDMA data to Nextel (iDEN) platform

Merger of Sprint-Nextel resulted in 2 CDR applications and architectures -

CDMA and iDEN, supporting primarily the same customer. Both CDR

architectures collect, store, retrieve and present information for numerous

departments (Downstreams). Migrating of CDMA CDR Data to the iDEN platform

will support projected volume, additional CDR detail and providing the

reports to many groups. This involves migrating CDMA data from DB2: AIX to

Oracle: Solaris Platform - Involved re-coding of 40+ Reports, checking its

performance, validating the outputs with users.

Roles / Responsibilities:

. Monitoring the execution of Reports in development, Testing and finally

Pre-prod servers.

. Involved in Performance Tuning, scalability of the applications and

reports.

. Troubleshooting and optimizing the report generation process.

. Responsible for writing Triggers and Procedures using PLSQL, and fine-

tuning of Queries.

. Responsible for Data Migration Scripts, migrating data from DB2 to

Oracle10g.

. Created a User interface using Oracle Application Express, and PL/SQL

packages, which process the parameterized inputs and designs Dynamic

SQL Queries.

. Responsible for deploying application.

Environment: Solaris, Oracle 10g, SQL *Loader, Oracle Application Express

3.1, PLSQL.

STS Report

Business users send Daily report request (CSV file), it consists of more

than thousand records with details of different type of search constraints.

Queries are triggered based on design specification for each record and the

reports along with the error file are provided to the corresponding

Business User. CDR Archive will automate the process to receive request and

send the CDR data to STS.

Roles / Responsibilities:

. Implemented a script that reads the Input file line by line and match the

criteria to trigger corresponding Query with appropriate search

parameters.

. To support huge number of request, dynamic SQL and background / parallel

processing are implemented.

. Added a new requirement to send Completion notification only after all

the records are read and processed.

. Care was taken not to process the same file, not to process record with

invalid data and also to follow the required file naming conventions

along with the automation of the entire process without manual

interference.

. Additionally a feature to document the failures and reporting back was

implemented.

. Required indexing was built by coordinating with DBAs involved.

Environment: Sun Solaris, Dynamic SQL, SQL*Loader, PL/SQL, Shell

Scripting.

Development of HDR Application

CDR is an application that is used to store call details into database.

These records can be of type 2G, 3G, NGG/WISP, CRSCIBER, XDR, ROAMEX, BMP

etc. According to the type of record we have different applications within

CDR Archive System. There are 19 applications / feeds supported. This

project was the development of one such 3G feed called HDR.

Roles / Responsibilities:

. Development of complete process involves fetching the DATA file from

Upstream, processing and loading to the database.

. Implemented two Purge processes - one clearing the files already

processed and the other taking care of removing the old data from the

Database.

. Enhanced it to take backup of the File and also to generate a summary

report.

. Designed Test Plan and scripted the test cases covering comprehensively

all system functionalities.

. Ran regression test cases and verified the legacy code.

Environment: AIX, C, C++, Pro C++, SQL, Unix Shell Scripting, SVN, DB2.

Siebel Technology Center

Application Developer

OnDemand Office

Development of Siebel CRM OnDemand. This offers built-in integration to

Microsoft Word and Excel to extend the value of CRM to the desktop

applications that employees use every day. It comprises of 3 applications:

1. Mail Merge for MS.Word: embeds an easy-to-use toolbar right into

Microsoft Word that enables end-users to download and filter real-time

lists of CRM records into MS.Word for easy and powerful mass customization.

2. Reports and Analysis for Excel: enables end-users to seamlessly create

Excel reports and analyze data from CRM OnDemand. Easily generate portable

reports that can be easily distributed across the enterprise and viewed

when disconnected from the Internet.

3. Segmentation Wizard: For "marketing program development and planning",

the new Marketing Segmentation Wizard helps uncover additional revenue-

generating opportunities within contact networks. By segmenting contacts

using multidimensional criteria, users can customize campaign messages for

effective target marketing. As campaigns are deployed into the field,

marketing program managers can use insight-driven analytics and business

intelligence tools to monitor and react to the sales performance on

opportunities generated, ultimately improving program ROI and delivering

immediate business impact.

Roles /Responsibilities: Maintenance and Support of the application.

Environment: VBA, XML, Web Services.

SAS Techno SolutionS Dec 2002 - Nov

2005

Project Engineer

Credit Card Management System

This system keeps the track of loan booked against the each customer for

the transactions done each month. The tracking is based on the Credit-card

number issued to the customer. It works on the similar lines of a Debit

card. This system holds all the details of the transactions done by the

customer from the loan booking till the loan liquidation. Also, system

generates Reports for all kinds of enquiries, like the Billing,

Liquidations, and Disbursements etc, made by the customer.

Roles / Responsibilities:

. Analysis of customer specifications and custom design of applications.

. Successfully implementing designs in new/existing applications using

Oracle, PL/SQL.

. Developed PL/SQL- Packages, Procedures, Functions, SQL Scripts, and

Database Triggers to populate the historic data in the tables applying

business logic.

. Performed application SQL tuning using SQL Trace/Explain plan and

TKPROF for optimum performance.

. Involved in coding and designing of the Transaction Module using

PL/SQL Procedures.

. Tune frequently used SQL Statements and increased performance by

passing appropriate HINTS.

. Compiled, tested and debugged to implement business logic and to

enhance modularity, reusability and serviceability for maintenance of

the application.

. Actively involved in System Integration testing on the client as well

as on the users end.

. Trained end users on the functionality and operability of the

application.

Environment: Oracle 9i, PL/SQL, SQL*PLUS, HTML

Implementation of Aircraft Stability Control using error estimation and

correction

The Stability control system of an aircraft has three control elements;

each of these is implemented as a typical control system. The sensor for

each of these elements sense for any change in the altitude and gives this

data as input to the control system. The control system then compares this

input with the reference data and produces a correction to the control

element. This correction is practically applied by the actuators,

proportional to the magnitude of the correction. The software application

developed controls the stability for these control elements and does error

correction for these control elements.

Roles /Responsibilities:

. Designed and implemented the task scheduling for Pitch, Yaw, and Roll

controls.

. Implemented the algorithm for altitude estimation.

Environment: Embedded Development in C/C++ on Vxworks - Real Time OS.

Development and Analysis of Lip prints using C language and Image

Processing Techniques for Personal Identification.

Certain distinct lines and fissures in lips show distinct patterns similar

to fingerprints and don't change with time. This project involves in

identifying and classifying the distinct lines that are unique to an

individual. These patterns of the wrinkles and grooves on the lips can be

utilized in personal identification.

Roles / Responsibilities:

. Coding and development of the Image Processing modules. These serve as

background modules that have the actual Image processing algorithm and

does complex computations on the 2 dimensional image matrixes. The

algorithms developed and implemented involve - Image Enhancements,

Segmentation, Morphological Processing, and Wavelet Techniques.

. Product with GUI that offers classified and color-coded groove

sequence.

. Making the inner grooves distinct without loosing the valid

information.

Environment: Software Development in C/C++ and MatLab.

Implementation of algorithm for Detection of malignancy from Cervical PAP

smear

This project involves Screening of Cervical PAP smear of middle-aged women

for prediction of malignancy. The software detects the abnormal smear by

detecting inflammatory cells and by computing the ratio of diameter of

nucleus and cytoplasm (N/C ratio).

Roles / Responsibilities:

. Coding and development of the Image Processing modules that run in the

background and provide the required result with a click of button. The

algorithms/applications implemented and tested involve - Segmentation,

Histogram threshold, Region based segmentation using polygon

approximation, Shape measure.

. Product with GUI, which offers preliminary diagnosis of the PAP smear

with the classification of cells and their malignancy.

Environment: Software Development in C and MatLab.

PUBLICATIONS

. Presented a technical paper on "IMAGE PROCESSING OF CERVICAL SMEAR",

in National Conference - 2005.

. Proceeding in SASTECH Journal on "IMAGE PROCESSING OF LIP PRINTS",

along with Dr Ananthapadmanabha T V.

Contact this candidate