Oracle PL/SQL Developer Resume

Title
Oracle PL/SQL Developer

Primary Skills
Oracle PL/SQL Forms Reports Oracle HRMS

Location
US-MO- (will consider relocating)

Posted
Sep-19-08

Sr. Oracle Developer

Professional Summary

• More than SEVEN YEARS extensive Software Development Life Cycle experience.
• Strong and seven years of development experience with Oracle PL/SQL, Oracle Forms & Reports.
• Strong experience in migration from Oracle Forms 6i to 10g
• Experience in Performance Tuning and Explain plan, Tkprof ,Sql loader,DBMS_Scheduler, Utl_File, Triggers, Indexes, Import and Export utilities and Shell scripting for auto process.
• Worked with a team which Upgraded Oracle DB 8i to Oracle 10g .
• Strong DBA Skills and Extensive experience with Oracle PL/SQL, HRMS/Payroll, Oracle Forms & Reports, Unix shell scripting, Unit testing, logical and physical database design, Performance Tuning, database security maintenance Shell scripts for batch processing.
• Strong Knowledge in ETL technology with Informatica and Oracle Warehouse Builder.
• Experience in Export, Import and SQL*Loader Utilities
• Created complex functions, stored procedures and packages, Triggers by using PL/SQL
• Experience in conducting Requirement and Systems Analysis, Feasibility Studies, Design Reviews, Plan Reviews, Implementation, and Post Implementation surveys. Highly skilled in Design, Development, Implementation, and Testing of business applications, Unit and System testing on database.
• Good Knowledge in data extraction, transmission and loading`
• Worked under Agile Scrum Methodology

Education
Master Of Computer Applications (M.C.A.), University of Madras.

Technical Summary
Operating Systems
Sun Solaris, AIX , UNIX, Windows NT /98 /2000, MS-DOS

Databases
Oracle 8i/9i/10g, SQL Server 2005, Access.

Tools & Languages

PL/SQL 8i/9i/10g,
SQL Server 2005,
Oracle Forms & Reports 6i/9i/10g,
SQL Server 2005 Reports,
Oracle Application Server 10g,
Oracle Designer 6i/10g,
JDeveloper 10g,
Oracle Applications
HRMS/PayRoll
Discoverer,
Explain plan,
Tkprof,
Oracle Enterprise Manager,
SQL*Plus, SQL*Loader,
Toad 9.0
SQL Navigator,
Shell Scripting
Informatica,
Perl,
VB 6.0,
VB Script,
VB.Net,
Pro*C,
C++,
Java,
JavaScript,
HTML,
XML,







EXPERIENCE

Client: Tyco (Covidien) HealthCare, St.Louis, MO
Jan'08 till Date
Project: Laboratory Information Management System (SQL*LIMS)
Role: Sr. Oracle Developer

Laboratory information management system is an application to verify the raw materials are qualified for their finished products , in detail the information about samples of the materials/chemicals logged for the testing ,the tests performed on them and the results. Track progress of samples from receipt in the lab until all tests are completed. Also it has to do the stability study, it assesses the shelf life of products under different combinations of product package type, temperature, humidity, and any number of other variables.

Responsibilities As Developer
• Created complex functions, stored procedures and packages by using PL/SQL
• Sub-queries and joins were extensively used in stored procedures
• Involved in extensive coding in Oracle forms/reports 6i/10g.
• Worked with and developed scripts for Team leads, QA and Business Team to ensure the Quality of the applications.
• Created Shell scripts to generate oracle reports and send to e-mail
• Rectification of errors reported during System Test and User Acceptance Test.
• Documentation of the work assigned.
• Extensive testing was done on the programs for achieving accuracy, timely processing of data.
• UTL_File Packages used for interface programming.
• Sql Loader was used to convert the data from the CSV to oracle tables.
• Created matrix reports and Label Reports using Oracle Reports 6i/10g
• Sub-queries and joins were extensively used in stored procedures
• WRQ@Reflection used to access the host application and FTP
• PVCS used for the version control
• Used Collections like variable arrays, nested tables extensively.
• Worked to maintain Oracle software, worked with development team to fulfill there requirements like design and creation of objects
• Table/Index Creation
• Database Objects Recreation on Development after Refresh from Production
• Worked on tuning of SQL after analyzing the table
• Worked on Table partition


Environment:
Windows NT, Sun Solaris, Oracle 8i/10g , PL/SQL (Stored Procedures, Packages, Triggers, REF Cursors, DBMS_Scheduler,DBMS_Pipe), Oracle Forms & Reports 6i/10g , PL/SQL Developer, Oracle Application Server 10g, Oracle Enterprise Manager, Collections, SQL*Plus, Unix Shell Scripting, Toad.9.0, TKProf, Explain Plan


Client: Jewelry Television, Knoxville, TN
Aug'06 to Dec'07
Project: Order Placement and Returns Management
Role: Sr. Oracle Developer

Responsibilities As Developer
• Wrote Stored Procedures for effective insertion and updation of the data in to the tables .
• Sub-queries and joins were extensively used in stored procedures
• Involved in extensive coding in Oracle forms/reports using PL/SQL.
• Worked on migration from Oracle Forms 6i to 10g.
• Worked with a team which is responsible for Oracle 10g Upgrade to make the required changes in the coding and testing.
• Used SQL Loader to automate the load of data from Text files to Oracle Tables.
• Worked as a Team Lead to do the development and implementation of the applications.
• Created Packages to automate transactions from the Developer 2000 Applications.
• Worked with and developed scripts for Team leads, QA and Business Team to ensure the Quality of the applications.
• Sql Loader was used to convert the data from the CSV to oracle tables.
• Created matrix reports using Oracle Reports 6i/10g
• Used Collections like variable arrays, nested tables extensively.
PL/SQL was extensively utilized for coding and writing complex stored procedures and packages.
• Worked to maintain Oracle software, worked with development team to fulfill there requirements like design and creation of objects
• Worked on performance tuning of SQL, PL/SQL and analyzed Tables
• Experience in Creation of Table/Index etc
• Database Objects Recreation on Development after Refresh from Production
• Worked on Table partition
• Creation of users, roles and procedures for data clean up to protect the database security / consumer payment information.


Environment:
Windows NT, Sun Solaris, Oracle 8i/10g , PL/SQL (Stored Procedures, Packages, Triggers, Cluster, Containers, REF Cursors), Oracle Forms & Reports 6i/10g , Discoverer, Oracle Application Server 10g, Pro*C, Oracle Enterprise Manager, Collections, SQL*Plus, Unix Shell Scripting, Toad.9.0, TKProf, Explain Plan

Client: Intrepid Capital, Jacksonville, FL
Jul'05 to Jul'06
Project: PMS (Portfolio Management System)
Role: Sr. Oracle Developer

Portfolio Management System is application software, which is developed to handle the money market dealings on government securities. This system is generates quarterly, half yearly interest, after authorization and settlement on each security, which has purchased by the dealer and also maintains the stock details for starting of the day (SOD) and end of the day (EOD). It has the reports like Stock register, interest received, outstanding interest, custody holding, interest watch register etc.

Responsibilities
• Sql Loader was used to convert the data from the Excel to oracle tables.
• Wrote Stored Procedures for effective insertions and updations of the data to the tables when the application is online reducing the network traffic.
• Sub-queries and joins were extensively used in stored procedures
• Created Shell scripts to automate the load of data from Text files to Oracle Tables.
• Created Packages to automate transactions from the Oracle Forms.
• Involved in extensive coding using Oracle PL/SQL.
• Created database triggers to automate the transactions that take place online.
• Subversion technology used to maintain the source code.
• Extensively worked with table partitioning and tablespace creation etc.
• Used UTL_File Packages to Load data from Excel Sheet to Oracle Tables.
• Used Oracle Forms 9i to design and develop the interface for the system.
• Created matrix reports using Reports 9i
• Created Object Groups to create to screen templates with Forms 9i
• PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages.

Environment:
Windows NT, AIX, Oracle 9i, PL/SQL (Stored Procedures, Packages, Triggers), HRMS/Payroll, Forms & Reports 9i, Oracle 9iAS, Shell scripting, SQL*Plus, Toad.

Client: Datascan Technologies, Atlanta
Sep'04 to Jun'05
Project: Wholesale Management System -- Enterprise Edition
Role: Oracle PL/SQL- Forms Developer

This Wholesale Financing and Accounting system enables financial institutions to automate their Floor planning or wholesale financing operations.

Responsibilities
• Developed functions, procedures and packages using PL/SQL.
• Handled DBA activities like user creation, backup, partition, tablespace etc.
• Involved in PL/SQL Debugging and support.
• As part of a core development team, cleaned up existing code, fixed problems and achieved in making the system production ready in remarkably short time.
• Used Collections like variable arrays, nested tables extensively.
• Used Oracle Forms 9i was used to design and develop the interface for the system.
• Used Import Export tools to create dump files for exporting and importing data to the database
• Extensively worked with table partitioning and tablespace creation etc.
• Oracle Report 9i was used to create a matrix report.
• Created Object Groups to create to screen templates with Forms 9i
• Used SQLLDR to load data from CSV file to database.
• Created front-end procedures and functions with Forms 9i

Environment:
Windows NT, Oracle 9i, PL/SQL (Stored Procedures, Packages, Triggers), Forms & Reports 9i, Oracle 9iAS , SQL*Plus, Toad.

Client: SSA Global, Chicago, IL
May'03 to Aug'04
Project: An Enterprise Resource Planning System
Role : Oracle PL/SQL- Forms Developer

MATRICS is ERP application software specially designed and developed for manufacturing, distribution, trading and service organizations. Each module has extensive query on any field with facilities of drill-down keys to view and analyze information pertaining to other relevant modules with very simple keystrokes. The system follows a single point-of-input principle for easy use and generates all standard reports, which can be customized to meet specific needs. It is designed to cover the financial, distribution, manufacturing and human resources activities of a medium to large manufacturing, trading and service organization.

Responsibilities
• Designed, Architected the two-tier client server application running on Oracle 8i database, on a HP-UX Unix Operating System.
• PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages.
• Generated Forms using Forms 6i
• Involved in Tuning the database server performance by reducing disk I/O, Sizing rollback segments.
• Worked with long and complex stored procedures with error handling
• Involved in the development of a migration tool to convert data from the existing database to the required database format.
• Shell Scripts were written to automate the stored procedures, triggers and functions.
• Involved in the physical and logical backups and restore the database.
• Developed packages by using PL/SQL for automating the transactions happening in the tables.
• Various features of PL/SQL such as Dynamic SQL and parameter passing of PL/SQL tables were evaluated
• Ran SQL Scripts from Shell.
• Developed SQL Applications for extracting the data from the Oracle tables.
• SQL*LOADER was used for data loading.
• Extensive testing was done on the programs for achieving accuracy, timely processing of data.
• Utilized SQL*Plus as the main interface with Oracle 8i.

Environment:
Oracle 8i, PL/SQL, HP-UX 10.x, complex Stored Procedures, triggers and packages , SQL Loader, Oracle Forms & Reports 6i, SQL*Plus, Toad.

Client: Tisco Estate, India
Feb'02 to Apr'03
Project: EMS (Estate Management System)
Role : Oracle PL/SQL- Forms Developer


EMS is a total solution for Maintenance of very large estates/quarters of public or private Sector Company's. It is comprehensive and user-friendly menu driven application. It has four modules Maintenance, Service, Contract Service, and Inventory. The maintenance module will take care of all the maintenance details like quarter occupant details, quarter vacant details, quarter history, quarter maintenance, electricity and water bill details. Service module will take care of all the complaint calls received, maintains the call history by generating a unique call id for the call received. Allow you to schedule the work and allocate a service personnel based on the priority of the work. Allows you to generate the service slips for complaint registered and maintains the service status like service personal name, items used, date and time of service etc., It also provides reports like service register, service personals report, call summary report etc., Contract service maintenance all the details of contracts given to the third party and monitor the job done by the contractor for the given contract. Inventory Management module will take care of all the inventory details like Issue and Receipt, stock ledger, stock ledger summary, stock consumption, quarter wise stock consumption etc.

Responsibilities:
• Developed forms and reports using Oracle Forms and Reports 6i
• Used Stored Procedures, Packages and Database Triggers extensively.
• Involved in preliminary and detailed design of modules.
• Developed Oracle reports using Reports 6i
• Involved in Unit Testing of the modules.
• Rectification of errors reported during System Test and User Acceptance Test.
• Documentation of the work assigned.

Environment: Oracle 8i, Oracle Forms & Reports 6i, VB 6.0, SQL*PLUS, PL/SQL, Intel based PC under Windows NT/95, Windows 2000 environment.

Client: Hidustan Lever Limited, India
Dec'00 to Jan'02
Project: Shipments Accounting.
Role : Oracle PL/SQL-Forms Developer

This project is developed for the Exports division of HLL, Ltd will make fast the process of invoice entries, realization, accounting and report generation. Invoices are the shipping details of the products, realization is the difference between the actual earnings and the invoice amounts and also generating the accounting entries. Moreover this package includes the reports like sales register, accounting, product wise, party wise etc.

Responsibilities:
• Used Oracle Forms 6i to design and develop the interface for the system.
• Created matrix reports using Reports 6i
• The database design responsibility included the conceptual data model design using ER diagrams, logical database design and physical implementation of the database.
• Identification and implementing business rules (constraints, triggers etc.) and views.
• Creating stored procedures for implementing required business logic.
• Made necessary changes to existing Database Objects and added new whenever required.
• Added provision to add or modify users and their privileges.
• Done unit testing and module testing.
• Generated performance (machine and operator wise) and stock reports.
• Prepared the necessary documentation and design specifications of project.

Environment: Windows NT, Oracle 8i, PL/SQL, Oracle Forms & Reports 6i, VB 6.0 SQL*Plus

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

| Resumes in Missouri

View other Oracle PL/SQL Developer resumes