Developer Oracle

* ********** ******** ********

Mobile: 818-***-**** Email :

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

PROFESSIONAL SUMMARY

. Nearly 16 years of experience in the field of Information Technology.

. Strong skills in SQL, PLSQL, Oracle Developer 2000, SQL*Plus,

SQL*Loader, Oracle Forms, SQL Developer/TOAD, UNIX shell scripting

and Design experience in Data warehousing using Oracle

. Intermediate knowledge in ETL Tools like Infomatica

. Strong in RDBMS & Data Modeling Concepts, and excellent working

knowledge of database design, creation, writing Complex Stored

Procedures, Triggers in Oracle.

. Hands on experience in all levels of Software Development Life Cycle

(SDLC) includes Requirement gathering and Analysis, Database design,

Database development, Application development, Test, Implementation &

Support.

. Excellent analytical, problem solving, communication and interpersonal

skills, with ability to interact with individuals at all levels.

. Expertise in designing and developing strategic Test plans, Test

Cases, Test Scenarios, Test Reports for Manual Testing.

. Skilled in writing scripts/cases for manual testing of Insurance

business applications

. Worked at different levels of development process that involved

gathering information from end user and communicating with the

organizational people to resolve key issues.

. Good team player, hardworking and have consistently exceeded client's

expectation during engagement performance reviews.

WORK STATUS: H1

TECHNOLOGIES

Languages & Tools: SQL, PL/SQL,SQL Developer, SQL Loader, Toad, can do code

walk through on JAVA and Pro*C, EDI for claims reporting, Design

experience in Data warehousing using Oracle, Infomatica

RDBMS: Oracle RDBMS 8, 8i, 9i, and 10g,

Clients: Oracle 9i/10g/11g, Oracle Forms 4.5/6i/9i/10g, Designer 6i,

Operating Systems: Windows NT/2000/2003/XP, Linux

PROFESSIONAL EXPERIENCE

KFORCE

Client : DIRECTV Dec 2013 - till

date

Oracle Developer & Analyst

SMS Totals is a sub-system of SMS, the Supplier Management system. This

project will redesign the current process to make it more flexible and user

friendly and minimize manual work, which, in turn, allows the Supplier

Payments group to be more efficient in supporting existing programming

contracts as well as new programming contracts that DIRECTV enters into.

THIS PROJECT WILL DELIVER THE FOLLOWING KEY BENEFITS:

1. INCREASE THE FLEXIBILITY TO CALCULATE TOTALS.

2. REDUCE OR ELIMINATE MANUAL PROCESSES.

3. BETTER AUDIT

RESPONSIBILITIES:

. Prepared low level detail design document from Functional spec

document.

. Developed oracle forms for different application screens around 12

screens which will serve major functionality of the application.

. Written extensive pl/sql scripts for major database processing using

different db objects like packages, procedures, functions, triggers

and views.

. Developed reports using Sql script and sqlplus formatting commands

. Followed Agile methodology

. Involved in code reviews

Environment: Oracle 9i/10g, Forms 10g,SQL Developer

TheZenith Insurance Woodland Hills, CA

Oct 2007 - Dec 2013

Lead Oracle Developer & Analyst

TheZenith is a leading Insurance company in Workers Compensation Insurance.

As a Leading company serving millions of Workers Zenith continuously

upgrades its applications to keep pace with the industry and customer

needs.

RESPONSIBILITIES:

. Involved in Enhancement and Maintenance of Policy and Claims Module.

Policy Module covers Prospect, Quotation, Policy and Endorsement.

Claims Module covers Claims Reporting & Processing, Claims Reserves,

Claims Payments and EDI for claims reporting.

. Analyzed Business Requirements documents and created Functional and

Technical Requirements documents.

. Interacted extensively with the BAs and SMEs to identify the business

needs and prepared programming standards and Functional and Technical

design specifications.

. Designed the Front end screens and Developed the code for various

complicated Transactions using Oracle Forms

. Developed and Maintained Several Transaction forms and shell scripts

. Developed and executed various Stored Procedures, Database Triggers,

Packages, functions, and cursors using PL/SQL Programming, perform

code Review, defect Analysis.

. Involved in the Testing, Tested various Transactions in Unit level,

Functional level and Integration level

. Tuned various SQL Queries and PL/SQL Stored Procedures using Explain

Plan, TOAD

. Provided production support to business units as well as worked on

several critical projects.

. Responsible for Initial testing, Unit Testing, Functional Testing,

Integration Testing and Migration testing

Environment: Oracle 9i/10g, Forms 6.0/6.0i/10g,PL/SQL,SQL*Loader, SQL*Plus,

SQL Developer, Import/export Unix Shell scripting

Universal Weather Aviation, Houston, TX

Jun 2005 - Sep 2007

Lead Oracle Developer

Universal Weather Aviation provides forecast services for weather and

Flight support Services. The Module includes forecast services related to

planning, severe alerts, hurricanes and offshore concerns. In flight

support services, it has got trip support in which the data from Weather

forecast is used .The Trip support includes modules such as Pre-post trip

services viz. Landing Permits, Overfly permits, Fuel etc. The

corresponding reports also generated for these purpose

Responsibilities:

. Created PL/SQL stored procedures, functions, packages and triggers to

transform and load staging table data into fact & dimension tables, by

applying critical business needs of Aviation Industry.

. Maintained log of unprocessed records by writing efficient exceptions

in PL/SQL programs.

. Responsible for interacting with business analysts to apply data

transformation rules in PL/SQL programs.

. Created and maintained Partitioned Tables and Indexes that helps in

maintaining large tables efficiently.

. Written functions and procedures for implementation of the business

logic as per the client requirement

. Created Materialized Views to leverage speed of extracting data from

large fact tables.

. Excellent knowledge and experience in creating source to target

mapping, edit rules and validation, transformations, and business

rules.

. Maintained data security by creating database triggers to populate

audit trail columns in dimension, lookup and cross-reference tables.

. Performed SQL & PL/SQL tuning using Explain Plan and TKPROF

. Used TOAD Schema Browser to navigate through various objects and SQL

Editor to test and tune complex SQL Queries

. Designed database schema using Erwin tool.

. Created the database schema objects like tables, views, synonyms,

indexes, procedures, and functions.

. Written UNIX shell scripts to transform & load data from flat file to

staging tables.

Environment: Windows 2000, HP UNIX, Forms 6i/9i,SQL, PL/SQL with Oracle

11i, Oracle 9i, Pro * C, Designer 6i, TOAD, SQL*Loader, SQL*Plus.

Ministry of Health, Canada, Long Term Care

Jan 2005 to May 2005

Lead Oracle Developer

Ministry of Health, Canada is having a financial system for funding the

hospitals in Canada for their various projects. The main objective is to

Migrate, Re-engineer and do code optimization of the existing application

in forms 3.0 cui to forms 9i GUI and also to convert the existing 2 tier

to 3 tier (9ias) Environment. The Proposals for the various projects will

be entered through a module and based on the criteria there will be a

committee will be formed with technical knowhow and meeting will be

arranged for the same .The committee decides the sanction amount and

finalizes the project proposal. The reports in this regard as well as for

accounting purpose will be generated.

Responsibilities:

. Customized forms and reports using Forms 6i and Reports 6i.

. Converted Oracle Forms 5 to 9i.

. Created common procedures, functions, object groups, record groups and

list of values in Forms 9i to be use in all Forms.

. Created PL/SQL store procedures, packages and triggers.

. Created SQL*loader scripts to load flat file data into Oracle staging

tables.

. Created UNIX shell scripts.

. Involved in web development by developing the forms (screens)

according to the user requirements.

. Involved in the customization of Purchase Order form.

. Worked on Data Extraction, Data Transformations, Data Loading, Data

Conversions and Data Analysis

Environment: Oracle 10g, PL/SQL, Forms 10g, UNIX, TOAD

HDFC Ltd. Corporate Loan System

Aug 2004 to Dec 2004

Lead Oracle Developer

HDFC Ltd is a leading Banking company. This system addresses the needs of

the corporate loans. The main objective is to Migrate, Re-engineer and do

code optimization of the existing application in forms 4.5 cui to forms 9i

GUI and also to convert the existing 2 tier to 3 tier (9ias) Environment.

This involves granting of loan based on the checklist and disbursement of

loans in parts for various needs. It also addresses the need of Bridge

Loan which has to be granted and tranche which has to be split.

.

. Involved in the Database design and Technical Design Specifications

for enhancement of the application

. Involved in the Data modeling of ER diagrams, Functional flow

diagrams, Data Flow diagrams.

. Created table spaces, tables, views, indexes, synonyms, and integrity

constraints.

. Designed and Developed the Master and Transaction Forms using Oracle

Forms 9i

. Designed and developed 25 Master forms, 30 Transaction Forms using

Oracle Forms 10g, and PL/SQL

. Wrote stand alone stored procedures, triggers, functions and packages

using PL/SQL

. Developed and executed Template form using Oracle Forms 9i and PL/SQL

which is used throughout the application

. Worked on Predefined, User-defined and System defined exceptions to

handle different types of errors like NO_DATA_FOUND, DUP_VAL_ON_INDEX,

and PRAGMA EXCEPTION_INIT etc.

. Involved in the SQL query tuning of the application using TOAD,

EXPLAIN Plan

. Involved in major role of Conversion and Migration of the data from

old system in the new System

. Involved in Testing of Unit, Functional Testing and Integration

Testing

Environment: HP Unix, Forms 9i, SQL, PL/SQL with Oracle 9i, TOAD, Shell

scripting, SQL*Loader, SQL*Plus,

1 Premia 10i (Insurance Product) July 2003 -

Jan 2004

2 Lead Oracle Developer

Premia 10i is an insurance product integrated with the financial module

ORION (Final 7.0) an ERP product of ICICI INFOTECH as a complete solution

for the insurance business globally. This was developed as an enhanced

version of the existing Premia 8i/9i product. I was involved in the Design

of underwriting and Claims process

3

. Implemented SDLC (Software development Life Cycle) as a Senior

Developer and worked as a team member in the development of RS, FS,

coding and final implementation.

. Documented functional specification, requirement specification and gap

analysis.

. Created tables, views and different schemas of the database-using

Oracle 8i, PL/SQL, stored procedures and triggers.

. Documented and compared the actual results with the expected results

based on the business functional requirements.

. Conducted walkthrough with the team in reviewing test plans, test

cases and updated the documents accordingly.

. Performed functional, integration testing, and boundary testing of the

front end of the application where required for browser and system

compatibility.

. Followed the Quality Assurance Life Cycle (QALC) during the testing by

implementing SQA Plans and Test plans which involve thorough testing

of the applications by creating Test plans, Test Cases, Bug Reports,

Status reports, Test summary reports, Traceability matrix and finally

Closure Report.

. Prepared UAT Test plan and coordinated UAT with stakeholders and

business users.

. Responsible for determining defect priorities, root cause analysis and

tracking defects to resolution.

Environment: HP Unix, Forms 9i, SQL, PL/SQL with Oracle 9i, TOAD, Shell

scripting, SQL*Loader, SQL*Plus,

4 Bank Staff Pension System April 2001 -

June 2003

5 Oracle Developer

Bank staff pension system is one of the modules of UCO bank mentioned

above. Bank Staff Pension System involves the computerization of the

pensions of bank employees. Bank staff pension system includes basic

pension, DA computation for basic pension and DA calculation.

6

. Implemented SDLC (Software development Life Cycle) as a Senior

Developer and worked as a team member in the development of RS, FS,

coding and final implementation.

. Documented functional specification, requirement specification and gap

analysis.

. Created tables, views and different schemas of the database-using

Oracle 8i, PL/SQL, stored procedures and triggers.

. Documented and compared the actual results with the expected results

based on the business functional requirements.

. Conducted walkthrough with the team in reviewing test plans, test

cases and updated the documents accordingly.

Environment: Windows 95/NT, Forms 6i, SQL, PL/SQL with Oracle 8i

7 Espiem Plastics Ltd, Chennai. Jan 2000

- March 2001

Stores Inventory System

8 Oracle Developer

This project deals with computerization of Inventory System in stores and

to improve the efficiency in the purchase and maintenance of the stores and

used to keep track of stock on the basis of Inventory. All the information

with regards to the sales, quantity of items sold, sales price / unit are

captured. Reports like inward register, outward register, raw material

ledger, goods in transit ledger, stock statements, sale of each Item date

wise, month wise etc. are generated

. Involved in Object Modeling, Analysis Modeling and Implementation

Modeling

. Documented functional specification, requirement specification and gap

analysis.

. Created tables, views and different schemas of the database-using

Oracle 8i, PL/SQL, stored procedures and triggers.

. Developed 3 Master and 5 transaction forms

Environment: Windows 95/NT, Forms 5.0, SQL, PL/SQL with Oracle 8i

9 Payroll System Jan 1999 -

Jan 2000

10 Oracle Developer

This project is developed keeping the objective that the payroll should

have accurate data for Calculating salary of employees and to cater to

around 5 branches of the company .This involves maintaining a grade master

register,Attendance register, Employee master register. Based on the

attendance and the availability of casual leave, sick leave salary will be

calculated

. Involved in Object Modeling, Analysis Modeling and Implementation

Modeling

. Documented functional specification, requirement specification and gap

analysis.

. Created tables, views and different schemas of the database-using

Oracle 8.0, PL/SQL, stored procedures and triggers.

. Maintenance of grade master, enhancement of Attendance Register and

Employee Register

Environment: Windows 95/NT, Forms 4.5, SQL, PL/SQL with Oracle 8.0

EDUCATION

. MBA in Systems Management from Annamalai University.

. B.Sc. in Physics from DG Vaishnav College.

Other Courses

. Diploma in Systems Management in NIIT, Chennai.

. PG Diploma in Computer Application in Software Solution

Integrated Ltd, Chennai.

. INS-22 AICPCU Certification For Insurance

. ORACLE 8.0 OCP DBA Certification

Contact this candidate