Developer Oracle

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

Phone: 347-***-****

PROFESSIONAL SUMMARY:

Over Eight (8) years of collective experience in analysis, design, development, testing and Implementation as Oracle Developer, Oracle Apps Technical Developer and as Java Developer.Excellent expertise in Software Development Life Cycle (SDLC) including Physical

and Logical design, code development, testing, implementing and maintenance. Development experience in requirement analysis, design, development and

implementation of Oracle Financials (AP, AR, GL, PO).Proficient working experience in SQL, PL/SQL, Stored Procedures, Functions,

Packages, DB Triggers and Indexes.Expertise in using Oracle 9i/10g Databases.Very good working knowledge in Java, J2EE, JSP and Struts Framework.Strong in using tools such as PL/SQL developer, TOAD, SQL*Plus, Eclipse.Expert in implementing, administering and supporting Oracle Discoverer.Extensively worked on Oracle Bulk Binds and Bulk Collects.Knowledge on DBA activities such as Performance Tuning, Grants and

Privileges.Creating scripts for Create, Alters and Data Modifications.Excellent technical abilities, strong oral and written communications skills,

analytical and interpersonal skills.Good team spirit and organized working habits with a willingness to learn new

concepts.

TECHNICAL SKILLS:

Languages : SQL, PL/SQL, C/C++, Java, J2ee, JSP, Web pl/sql

Scripting : Java script.

Web technologies : HTML, XML.

Databases : Oracle 8i/9i/10g, Oracle Apps 11.5.8/11.10.2.

Tools : PL/SQL developer, Toad, SQL*Loader, SQL *Plus, Eclipse,

Track record, Remedy, Smart CVS.

Operating Systems : Windows 2000/XP, UNIX.

Packages : MS Office (Word, Excel, Access, Power Point, Visio)

Open Source Tools : CVS, PVCS.

WORK EXPERIENCE:

State of Tennessee (DCS), Nashville, TN Nov-07 - till date

Project:

Sr. Developer

The Tennessee Department of Children’s Services (DCS) is committed to development of the partnerships, infrastructure, and resources fundamental to the achievement of improved outcomes for children and families in Tennessee. Its mission is to empower families and support community safety and partnerships to help ensure safety, permanency and well being for children. It provides services to kids and families by providing custody of the kid to the foster parent, Youth Villages or to the Youth development centers.

Responsibilities:

Participate in project planning sessions with business analysts and team members to analyze business IT Requirements and translate business requirements into working model.Maintained and supported Oracle Modules INV, AP, PO, GL and Custom Module.Developed complex Programming interfaces between Oracle Apps Custom Module and Oracle Modules using PL/SQL.Created and Developed complex Database objects like Packages, Procedures, Functions, Triggers, Tables, Views and SQL scripts.Developed User Interfaces using Web PL/SQL.Re-wrote the existing modules in Web/App tier using Struts, Java, J2ee technologiesUsed JavaScript for performing show/hide functionalities and Client side Validations.Developed Web based Interfaces using JSP, HTML and CSS.Enhanced/Customized existing Oracle Apps Custom Schema by creating new database objects per the clients requirements.Imported data from legacy system to Oracle 11i using SQL*Loader.Performed data cleansing using SQL Functions like Trim, Lpad, Nvl for the data received from the legacy.Developed Reports using Oracle Discoverer.Participated in knowledge transfer sessions for application maintenance and enhancement/change requests.Did Data reviews for Data converted from Legacy systems.Performed integration testing and helping User in acceptance testing.Work with Business Analysts to resolve functional issues, provide technical recommendations and solutions.Provide technical guidance to team members

Environment: Oracle Applications 11.5.8 (AP, GL, INV, PO), Oracle 9i/10g, Java,

J2EE, JSP, Struts, PL/SQL, JBOSS 4.2.3, CVS, Track record, Remedy, HTML,

SmartCVS, MS SharePoint Server, Web PL/SQL, SQL*Plus, Toad, SQL Developer,

Discoverer 4i, UNIX, Forms 6i.

Solyndra Inc, CA Dec 06 - Oct 07

Oracle Developer

Solyndra Inc is a Solar Energy Equipments manufacturing organization. It is involved in

developing high efficiency Photovoltaic’s technology, helping alternative energy break

through to the next level. The manufacturing facility consists of fully automated factory

setup. My primary responsibility in this application is to develop the back end database.

Responsibilities:

Created database objects like Tables, Views, stored Procedures, Functions,

Packages, DB triggers and Indexes.Involved in Unit and Multi load testing of each module.Extensively used SQL*LOADER facilities.Involved in extracting the required data from the Tables.Coordinate with the front-end design team to provide them with necessary stored

Procedures and Packages and the necessary insight into the data.Developed and customized existing reports in PO module.Monitoring existing SQL code and fine-tuned the SQL queries using optimizer hints

for joins and Explain plan.Prepare design documentation for system level maintenance.Developed inbound interfaces for PO and AP modules in order to upload data into

Oracle apps base tables.

Environment: Oracle10g, Oracle apps (11.5.10), TOAD, PL/SQL developer,

SQL* Plus, CVS.

180 connect, New York Jun 05 - Nov 06

Oracle Developer

180 Connect was a rapidly growing provider of technical support services including

new installations, reconnections, disconnections, service upgrades and downgrades and

Service calls for broadband video, data and voice services for residential, business and

commercial marketplaces. My primary responsibility in this application was to

develop back end database.

Responsibilities:

Involved in the creation of database objects like tables, views, stored procedures,

functions, packages, DB triggers, Indexes and Collections.Coordinate with the front end design team to provide them with necessary stored

procedures and packages and the necessary insight into the data.Fine-tuned the SQL queries using optimizer hints for joins and Explain plan.Created Indexes to improve the performance while using tables containing large

number of columns and rows.Involved in Unit and Multi load testing of each module.Extensively used SQL*LOADER facilities every day.Used external tables to manipulate data obtained daily before loading them into the

tables.Involved in extracting the required data from the Tables.

Environment: Oracle 10g/9i, TOAD, PL/SQL developer, SQL*LOADER, UNIX.

Alpha Thought Inc. Chicago, IL Oct 04 – May 05 Oracle Developer

Alpha Thought is a provider of healthcare enterprise point-of-care solutions to large health systems and medical practices. This is a back end based healthcare information management application. This project is a comprehensive web based solution for their business services. It is focused on extensive data capture and comprehensive reporting to evaluate and monitor payments as well as utilization of services. My primary responsibility in this application was to develop back end database.

Responsibilities:

Coordinate with the front-end design team to provide them with necessary stored

procedures and packages and the necessary insight into the data.Involved in the creation of database objects like tables, views, stored procedures,

functions, packages, DB triggers, Indexes and Collections.Fine-tuned the SQL queries using optimizer hints for joins and Explain plan.Extensively used SQL*LOADER.Used external tables to manipulate data obtained before loading them into the oracle

tables.Involved in extracting the required data from the Tables.Documentation of modules for system level maintenance.

Environment: Oracle 10g/9i, SQL*LOADER, UNIX shell scripting, TOAD, PL/SQL developer.

Contact this candidate