Developer Supply Chain

[pic]_______________________________________________________________________

_______________

Objective

Highly motivated creative and organized IT Professional seeking a

challenging position as an Oracle PL/SQL Developer.

Summery

. 6+ years of diversified experience in analysis, design, development,

testing and implementation as ORACLE PL/SQL DEVELOPER.

. Proficient working experience in SQL, PL/SQL, Stored Procedures,

Functions, Packages, DB Triggers and Indexes.

. Experienced in Tuning SQL Statements and PL/SQL Procedures for

enhancing performance across databases.

. Worked on Table Partitioning, Bulk Binds, Bulk Collects, and PL/SQL

Collections.

. Utilization of advance futures of Oracle 10g for PL/SQL programming

(like Using cursor variables, Ref. cursors, varrays, hints, Dynamic

SQL, ORA_HASH, and PRAGME EXCEPTION_INIT.

. Good knowledge of using DBMS Oracle supplied package

. Designed Unix Shell Scripts and set the Cron jobs

. Good expertise using PRAGMA AUTONOMOUS_TRANSACTION

. Used TOAD to make database application development faster and easier

also to simplify day to day administration tasks.

. Good knowledge of working with materialized views, Global Temporary

Tables, and SYS_CONTEXT global/session variables.

. Expertise in all phases of the Software Development Life Cycle

including analysis, Physical and Logical design, Resource Planning,

code development, testing, implementation and maintenance.

. Work closely with application architect, DBA to define requirements and

interfaces and to implement business logic.

. Worked as system analyst/module lead/Sr. Oracle Developer to analyze

and gather the business requirements, create the Functional, Technical

and Unit Testing documents, implement and review the requirements,

perform unit testing, support SIT and production release and help

creating Operations/users manual.

. Provided 24X7 production/on-call support.

. Participated in QA processes like maintaining the Approval Records and,

Traceability matrix document to map the business requirements to the

functional, technical and testing document in order to ensure each

requirement is implemented.

. Experience working with the document and code version management tools

like VSS, PVCS and Share Point.

. Experience working with scheduling tools like JCI and Tidal.

. Efficiently worked as onsite coordinator in the onsite offshore working

model.

. Awarded for hard work, commitment, fast problem solving skills and

maintaining positive attitude through out the SDLC of the project.

Skills set

OS: Solaris5.9, Windows XP/2000, MS-Dos, HP-

UX 11.00

Database: Oracle 10g, Oracle 9i, Oracle8i

Tools: SQL*Plus, iSQL*Plus, Toad Professional,

SQL Developer 1.2, PL/SQL

Developer 6.0, Oracle forms9i and reports9i, Visual

Studio, Crystal Reports

Scheduling Tools: Tidal, JCI, DBMS_SCHEDULER, UNIX Cron

Version

Management Tools: PVCS, VSS, Share Point

File Transfer: FTP, Smart FTP, Hummingbird, WinSCP

Languages: SQL, PL/SQL, Shell Scripting, C

Certificate Of Excellence

. Oracle Certified Associate. SQL certification (Exam iZ0 007)

. Oracle Certified Associate PL/SQL Developer Certification (Exam iZ0

147)

. Brainbench Certified in Oracle Developer

PROFESSIONAL EXPERIENCE

Litton Loan Servicing

Houston, TX

Feb 2009 - Present

Role: Sr Oracle Developer

Litton Loan Servicing LP is one of the premier residential mortgage

servicers in the industry as it works to cure problem loans and prevent

foreclosures by providing delinquent customers with a full range of

structured counseling and support services. Some of the Support services at

Litton include collections, payoff, bankruptcy, short sale, deed in lieu,

and foreclosure.

Responsibility

. Worked as lead developer on the projects like HAMP (Home Affordable

Modification Program) and HAFA (Home Affordable Foreclosure

Alternatives Program) and met hard deadline provided by treasury.

. Designed the specifications by co-coordinating with business users to

successfully implement the government directives like HAMP and HAFA.

. Designed, developed, released and supported systems like MODTrack to

track loan modifications and ALTrack to track asset liquidation.

. Created Design, testing and release documents and scheduled reviews

with business teams.

. Coordinate with business team to receive feedbacks and system

enhancement requirements.

. Wrote PL/SQL Packages, Procedures, and Functions and utilized advance

oracle features like: Defer Transaction, Session/transaction

variables, HTML and File Extract packages.

. Performed performance tuning to make the online transactions work

faster for business users.

. Used Materialized views, Global Temporary Tables, DBMS_SCHEDULER,

Oracle hints, and Pipelined functions to implement and enhance

performance of different systems.

. Scheduled jobs to provide automating boarding of loans into the

MODTrack and ALTrack systems.

. Worked on the developing EWM (Enterprise Workflow Manager) to

automatically manage work for Loss Mit, Payoff, and Collections teams.

. Provided 24X7 on-call support.

Environment: Oracle 10g, Windows XP/2000, HP UNIX, TOAD Professional,

Putty, Visual Studio

Supply Chain Release 521 and 522

Havi Global Solutions, Downers Grove, IL

Nov 2007 - Jan 2009

Data Management and Integration Module

Role: System Analyst/ Module lead/ Onsite-offshore coordinator/ Oracle

pl/sql developer

SCR (supply chain release) is the supply chain planning software solution

designed to support the replenishment process of restaurant order proposals

(ROP) for McDonald's restaurants. The goal of the SCR/ROP initiative is to

improve restaurant operations by removing ordering from the restaurant and

creating a more accurate 'automatic' order for the Top 8 McDonald's markets

and beyond (Australia, Canada, China, France, Germany, Japan, UK, and US).

Data Management and Integration module receives and processes data in and

out of SCR using standard interfaces. This module manages Master,

Transactional, Semi-transactional and Historical data.

Responsibility

SCR521 - Functional Release

. Analyze and review Business Requirement and Specification documents.

. Coordinate with business team to provide and receive feedbacks on the

business requirements.

. Analyze existing 4 - level BOM structure and build 5 - level BOM (Bill

Of Material) structure for master data management.

. Create Process Flow Diagrams, and End2End Data Flow diagrams using

Visual Studio.

. Create Functional Design documents, and hold the reviews with business

and IT team.

. Create Technical Design documents, and hold the reviews with IT team.

. Create Unit Test Script and define Test Data.

. Provide input to create logical data model.

. Develop PL/SQL Packages, Procedures, Functions, SQLLDR control files,

and UNIX shell scripts as required to load and transform master,

transactional, semi-transactional and historical data into database.

. Developed Unix Cron and Daemon scripts, configured job chins to

automate the data load and transformation.

. Hold code reviews with the DBA team.

. Perform Unit testing and document Unit Test Results.

. Coordinate with offshore team, provide work guide lines and

participate in resource management.

. Coordinate with SP (Supply Planning) and DP (Demand Planning) modules

to understand their data requirements.

. Review and resolve the code defects as part of supporting SIT (System

Integration Testing).

SCR522 - Scalability Release

. Analyze and review BRS and TRS documents.

. Create Functional and Technical Design documents.

. SQL and PL/SQL Performance Tuning.

. Utilize bulk bind, bulk collect, GTT, materialized view and pipelined

functions to improve performance of the existing code and develop new

program components as required.

. Utilize character based array and ORA_HASH function to improve

performance and/or pattern matching.

. Write Dynamic SQL to improve performance and to build complex queries

at runtime.

. Used explain plan utility to analyze the SQL queries.

. Coordinate with offshore team, provide work guide lines, review and

provide feedbacks on the design documents and code.

. Coordinate with SP (Supply Planning) and DP (Demand Planning) modules

to understand their performance requirements.

. Perform Unit Testing and support SIT.

Environment: Oracle 10g, HP UNIX, SQL*Plus, TOAD Professional, Putty,

WinSCP, Visual Studio

Title entry & Registration Entry System

Jan 2007 - Oct 2007

IL Secretary of State, Springfield, IL

PL/SQL Developer

The project was developed for the Illinois Secretary of State's vehicle

services division. Titles entry system and Registration Entry system are

the two different applications have separate instances. From all over

Illinois State the vehicle title applications submitted by the customers

will be keyed through the Titles Entry System, in the same way the new

vehicle Registration and Registration Renewal applications keyed through

the Registration entry system. Coming to the technical aspects of the

application, it is developed using the Oracle web tool kit (HTML, DHML,

embedded Java Script and CSS) and deployed the application using the Oracle

Application Server 9i.

Responsibility

. Involved in application tuning of database by defining the suitable

indexes.

. Optimized and enhanced the existing procedures and SQL statements for

the better performance

. Maintained the data integrity and security using integrity constraints

and database triggers

. Created Stored Program Units in the Form of Packages, Functions,

Triggers, Triggers and Procedures for implementing the database

intensive business rules.

. Well versed with Explain Plan, TKProf and Statspack

. Used PL/SQL Wrap Utility to encrypt PL/SQL source code and to make the

code portable to any platform.

. Used Pragma AUTONOMUOS_TRANSACTION to avoid mutating problem in

database triggers

. Used PL/SQL%TYPE and PL/SQL%ROWTYPE declaration attributes to make

PL/SQL codes easier to maintain.

. Used different parameter modes like IN, OUT and INOUT with the stored

procedures.

. Implemented overloading feature of packages to make your package-based

features as accessible as possible.

. Used Raise_application_error, procedure of package DBMS_STANDARD, to

issue an user defined error messages from stored sub-program or

database trigger

. Using SQL Loader for populating static tables and fact tables from CSV

files.

. Performed Unit testing.

Environment: Oracle 10g, Windows XP, SQL*Plus, TOAD 9.1, Oracle Forms6i and

Reports6i

INDUSTRY EXPERIENCE:

. Mortgage/Loan Servicing

. Supply chain

. Retail

EDUCATION

. MS with Electrical and computer science New

York Institute of Technology

NY,

Dec 2006

. BE with Electrical Engineering

India, 2003

Rati Patel

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

Cell: 516-***-****

Home: 281-***-****

[pic]

[pic]

Contact this candidate