Oracle Sql

SANDHYA PATHAK

Phone: 612-***-****

e-mail: *********@*****.***

PROFESSIONAL SUMMARY

> 7+ years of experience in database development using SQL and PL/SQL by

writing Stored Procedures, Functions, Packages, Triggers and collections.

> Experienced in Oracle Forms 6i/9i/10g, Oracle Reports 6i/9i/10g,

SQL*Loader.

> Experienced in database and SQL tuning for enhancing the load performance

across databases using Explain Plan, Hints, indexes SQL Trace and TKprof.

> Well versed with UNIX shell scripting.

> Worked with version control tools like VSS, PVCS.

> Experienced in understanding requirements, writing functional specs,

writing test cases and test plan.

> Work experience in Oracle Retail, Retail Predictive Application Server

(RPAS).

> Strong work experience and knowledge in Oracle Applications e-business

suite 11i (Finance and Manufacturing).

> Experience of End-to-end life cycle in Migration, support and

implementation Oracle projects.

> Excellent leadership, communication, project management and customer

relationship skills.

CERTIFICATE

1Z0-051 - OCA: Oracle Database 11g-SQL Fundamentals, Aug 2009

Education

Aug 1996 - May 2000: S.V.P.S. College Of Engineering, India

B.E. (Bachelor of Engineer) Honors, Electronics

technical skills

Packages : Oracle Applications 11i,

Oracle Retail, Oracle Retail Predictive

Application Server

ERP Modules : AP, AR, GL, INV, WIP, BOM, PO, PA, AOL, Sys

Admin.

Tools : PVCS, I-net, Peregrine, TOAD, Mercury ITG, SQL

Developer

Programming Languages : PL/SQL, SQL

Development Tools : Oracle Forms 6i/9i/10g, Oracle Reports

6i/9i/10g, SQL*Loader

Database : Oracle8i/9i/10g/11g, Oracle Enterprise Grid

Control Manager

Operating System : Windows XP, UNIX, WINDOWS NT, IBM-AIX

Data Modeling Tools : MS Visio, Balsamiq, Rational Requisite

Pro, MS Project.

Professional experience

Client: BI Worldwide, MN Feb 2010 -

Present

Role: Oracle Developer

Responsibilities

* Analyzed business requirements and developed PL/SQL programs. Worked

almost exclusively on partner programs over 35 with diverse in and out

data requirement.

* Performed SQL tuning on programs running including multi layered report

(extract) based on business requirement for long time by restructuring

the code and by introducing staging tables in the process, using hints.

* Wrote PL/SQL code to read CSV files using UTL_FILE, validate, modify the

data and create extract file with correct data.

* Used Dynamic SQL for Data Migration.

Environment: PL/SQL, Oracle 11g, Windows NT and HP-UX,VI editor, SQL

Developer.

Client: Sky Bridge Marketing, MN Aug 2008 - Jan 2010

(Formerly Archway Marketing)

Role: Oracle Developer

Responsibilities

* Developed PL/SQL package to automate order processing for expedited ship

orders.

* Modified, maintain and develop PL/SQL procedures, functions and triggers

to develop new enhancements.

* Developed UNIX shell scripts for routine tasks.

* Created gap analysis, Use-Case, Data model diagram and technical design

documents for the project.

* Troubleshoot issues, conduct quality reviews of code developed by

development team.

* Wrote test scripts, ran test cases and was responsible for complete

testing cycle.

* Developed several forms including Back Order Release, Work-In-Progress,

Inventory Substitution, Order Status and On-Demand Shipping form.

* Perform Oracle Performance Tuning using OEM to generate Explain Plan, SQL

Advisor to tune long running jobs by created index, hint, Bulk collect,

ForAll and temporary tables to improve performance.

* Implemented complex views, procedures, functions, packages and triggers

in PL/SQL

* Migrated total 366 Oracle Forms and Reports 6i to Forms 10g (10.1.2.0.2)

using form migration assistant (FMA) replaced obsolete functions with new

functions.

* Created one time UNIX script to compile all the forms, PLL and menu at

one time for batch compilation.

* Created detailed project outlines, application design specifications, and

test plans.

* Implemented security on URL by hiding user id and password while calling

reports from forms

Environment: PL/SQL, Oracle 8i/10g, Windows NT and HP-UX,VI editor, Oracle

Forms 6i/10g, Reports 6i/10g, Oracle Application Server 10g, SQL Developer,

Oracle Enterprise Grid Control Manager 10g, Visio.

Client: Reell Mfg., MN

Apr2008- July 2008

Role: Oracle Consultant

Responsibilities

* Used Collections like variable arrays, nested tables.

* Implemented printing and sales Order Acknowledgement report to three

printers.

* Developed Shell scripts and SQL control files to load data through SQL

Loader Supported Category and Location Planning Application as On-site Co-

coordinator.

* Wrote UNIX shell scripts to automate jobs.

Environment: Oracle 10g Server, PL/SQL, VSS 6.0, TOAD

Client: United Health Care, MN

Oct 2007-Nov 2007

Role: Oracle Consultant

Responsibilities

* Imported data from database, validating the data and populating

Intermediate tables for Data Warehouse.

* Wrote Pl/SQL validation scripts for data from different sources and

exported the data to created flat files to be loaded in the system.

* Redesigned the stored procedure for proper loading of family detail data

into the Data warehouse

Environment: Oracle Applications E Business Suite11.5.8, Oracle10g, Windows

NT, PVCS, SQL Loader

Client: Best Buy Inc., MN

Dec 2006 - Sep 2007

Role: Application Developer

Responsibilities

* Responsible for source code control, code maintenance, and code migration

activities.

* Worked on Retail Demand Forecasting (RDF) and ASO module.

* Configuration Activities for Financial Planning and Location Planning on

RPAS version 12.0.x.

* Wrote and executed scripts for Assembly, Product, End-to-End, UAT,

deployment testing for Category Planning and Location Planning.

* Supported Category and Location Planning Application as On-site Co-

coordinator.

* Wrote UNIX shell scripts to automate jobs.

Environment: Oracle Retail Predictive Application Server 12.0.4, Oracle

10g, UNIX, Windows XP, Peregrine, I-net, VI Editor

Client: Eagle Logistics, TX Jan

2006 - Nov 2006

Role: Oracle Developer

Responsibilities

* Analyzed business requirements, designed, developed and modified PL/SQL

procedures, packages and triggers to implement business rules into the

application.

* Customized Custom.pll for PO form to restrict users to use item which

doesn't have a frozen cost.

* Created stored procedures and packages using REF CURSOR and DYNAMIC SQL.

Environment: PL/SQL, Oracle Applications E Business Suite11.5.8, Oracle9i,

Windows NT

Client: Service Management System (SMS 800) Nashville, TN

Jun 2005 - Oct 2005

Role: Programmer Analyst

Responsibilities

* Customer Interface: Wrote PL/SQL control file to load Customers from flat

file to temporary tables. Created PL/SQL Procedures to validate the data

before transferring into Customer Interface.

* Open Invoice Migration: Migration of Open Invoices from legacy system to

11i, Wrote procedures importing invoices into interface tables and done

validation before transferring it into base tables.

* Extracted Payment data from Oracle Base Tables and transferred into third

party database using PL/SQL Stored Procedures.

* Created DDL scripts, Created database objects like Tables, Views Indexes,

Synonyms and Sequences.

Environment: Oracle Applications E Business Suite11.5.10, Oracle9i,

Reports6i, IBM AIX,

Windows XP, SQL Loader, FTP

Client: Johnson Controls Inc. Milwaukee, Wisconsin Mar

2005- May 2005

Role: Programmer Analyst

Responsibilities

* Developed PL/SQL Procedure to generate CSV file with the help of UTL_FILE

package.

* Created DFF on transaction table to include two columns Delivery Date and

Delivery order number.

Environment: Oracle Applications E Business Suite11i (AR, AP, GL),

Oracle9i, TOAD

Client: Norwich Industries Ltd., IL

Aug 2004 - Feb 2005

Role: Programmer Analyst

Responsibilities

* Developed interface program for conversion of sales orders using the

Order Import Open Interface program.

* Customized the Order Header workflow to place custom holds as per client

requirement before the order is booked.

* Developed interface program to close old Purchase Orders in the ERP

system

Environment: Oracle Applications E Business Suite11i (AR, AP, GL),

Oracle9i, TOAD

Client: R systems Intl Ltd, India

Oct 2001- Jul 2004

Role: Technical Developer

Responsibilities

* Created an APPS rule to populate sysdate in invoice date field on Invoice

workbench forms.

* Created MFG commission report to extract customer rep and commission

information from oracle. Customized the report to use inline views to

improve the performance, performance improved from 4 hours to 15 minutes.

Environment: Oracle Applications E Business Suite11i (AR, AP, GL),

Oracle9i, TOAD

Client: R.S.B Systems Pvt. Ltd., India Sep

2000 - Oct 2001

Role: Component Engineer

Responsibilities

* Detailed analysis of the circuits and timing diagrams for the parametric

evaluation of the electrical, mechanical and functional specifications of

components.

* Create product and pin specifications sheets for microprocessors.

References: Available Upon request.

Contact this candidate