SUMMARY

• Around 5 years of programming experience as anOracle PL/SQLDeveloper in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Expertise in Client - Server application development using Oracle11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOADandSQL*LOADER.
• Effectively made use ofTable Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-WriteandTransportable table spaces.
• CreatedTables, Views, Constraints, Index(B Tree, Bitmap and Function Based).
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience inOracle supplied packages, Dynamic SQL, RecordsandPL/SQL Tables.
• Loaded Data into Oracle Tables usingSQL Loader.
• Partitioned large Tables usingrange partition technique.
• Experience with Oracle Supplied Packages such as UTL FILE.
• CreatedPackagesandProceduresto automatically drop table indexes and create indexes for the tables.
• Worked extensively onRef Cursor, External TablesandCollections.
• Expertise inDynamic SQL, CollectionsandException handling.
• Experience in SQLperformance tuningusing Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such asQuery Optimizer, Execution PlansandIndexes.
• Experience withPerformance Tuningfor Oracle RDBMS usingExplain PlanandHINTS.
• CreatedShell Scriptsfor invoking PL/SQL Programs.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Databases: Oracle 7.x/8i/9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers).

Tools: Oracle Reports, SQL*Loader, Bi Publisher,XML Publisher,Toad,PVCS,Kintana,Win SCP

Operating Systems: LINUX, Windows NT/98/95/2000 & Windows XP.

Languages/Utilities: SQL, PL/SQL, Unix shell scripts.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta

Oracle PL/SQL Developer

Responsibilities:

• Developed AdvancePL/SQLpackages, procedures, triggers, functions, IndexesandCollectionsto implement business logic usingSQLNavigator. Generated server sidePL/SQLscriptsfordata manipulationand validation and materialized views for remote instances.
• Wrote conversion scripts usingSQL, PL/SQL, stored procedures, functionsandpackagesto migrate data from one billing system to other .
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
• Created and modified severalUNIX shell Scriptsaccording to the changing needs of the project and client requirements.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, AnalyseandAUTOTRACE.
• Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day. Used standard packages likeUTL FILE, DMBS SQL, and PL/SQLCollections and usedBULKBinding involved in writing database procedures, functions and packages for Front End Module.
• Developed and modifiedtriggers, packages, functionsandstored proceduresfor data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• WroteSQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.

Confidential, NJ

Oracle Consultant

Responsibilities:

• Design and develop the Objects and discuss with Functional Consultant regularly on the Progress and give module wise demos to be on sync.
• Triage tickets and update it with necessary information.
• Worked on existing tickets assigned and follow up on status for speedy closure of tickets.
• Extensively worked on Finance (AP, FA, AR, GL) Oracle Reports as per the Client requirements.
• Developed “Receipt Report History Report” for the User to display receipt and Transaction Payments information for the given Ledger.
• Worked on “Single Instance analysis” Project to analyze the impact if the reports in two instances when migrated to SI.
• Developed and modifiedtriggers, packages, functionsandstored proceduresfor data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• WroteSQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.
• Check in code to Version Control on regular basis and update Jiira Tool for the regular tracking of Work.
• Worked on Performance tuning to tune different queries by rewriting and applying hints if needed.

Confidential

Oracle apps Consultant

Environment: Oracle Apps R12(PO, INV, AP, AR, GL), Oracle 10g Database, PL/SQL Developer, TOAD, SQL Navigator, Oracle Reports 10g, Oracle Forms 10g, UNIX Shell scripting,, XML/BI Publisher, Workflow Builder.

Responsibilities:

• Created New supplier/new supplier site report and implemented bursting logic to send the output as email attachment.
• Worked with Cisco Invoice Hold Report which works at Operating unit level and has made it globalized to run at theater level.
• Involved in adding new descriptive flex fields in Order Management (OM) to capture additional information.
• Development and Customization of Oracle reports by using Oracle Report 6i/10g and PL/SQL Reports, XML Publisher, BI Publisher.
• Development of Conversions and Interfaces to import data into Oracle Applications and to export data from Oracle Applications to external files using UTL FILE Package.
• Worked in developing Procedures, Packages, Functions, Triggers, views, records, constraints, synonyms, indexes and other database objects using SQL and PL/SQL for validating the data loads.
• Registered Reports as concurrent programs in Application Object Library (AOL)
• Code Migrations using FNDLOAD for AOL objects and Shell Script for Database objects.
• Prepared Technical documents for requirements, design, and implementation steps, test plans and functional user training guides for all the phases of the project.
• Worked onperformance tuninglike Explain Plan to improve the performance of various custom PL/SQL Packages developed.
• Developed a procedure to Update External Mass Additions with FCM Details and registered as concurrent program.
• Develop shell script programs to implement mailing and send email notifications to multiple users.
• Designed and developed XML reports, BI reports, PL/SQL reports and implemented bursting logic to send the report to requested users.
• Used FND PROGRAM APIs for registering and deleting programs and executables also used ad dd.register table/register column for registering user tables/columns.
• Created SQL Loader scripts to load data from legacy systems to Oracle Apps.
• Worked with XML Publisher responsibility and defined data definition and template definition while developing BI reports.
• Customized standard Oracle Apps Reports in Inventory and AP Modules.
• Developed Order Management, Inventory, and Fixed Assets, Receivables queries to compare summary information of the standard and custom reports.
• Involved during the Development, Production and Post-implementation support phases of the project.
• Activities also involved migration of deliverables such as PL/SQL packages, LDTs, RDF, and rtf templates to various environments using UNIX shell scripts and FNDLOAD.
• Worked on System Administration activities like Concurrent manager activities, Creating Users, Responsibilities, Menus, Request Set/Groups and Value Sets.
• Used SVN to maintain the code repository and developed migration scripts to migrate all the development work into new instance

Confidential

Software Engineer

Responsibilities:

• Designed and developed layout model and data model for Customization of Reports using Oracle Reports 6i as per the business requirement.
• Used custom SQL*loader program to load the invoices from other accounting systems to payables staging tables.
• Involved in checking the validity and accuracy of the legacy data by writing PL/SQL packages.
• Developed several Procedures and Database Triggers as per Business requirement.
• Imported Items from legacy system into Oracle Inventory base tables using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories.
• Worked with Synonyms, Sequences, Views and Materialized Views.
• Developed Reports like Weekly reports, Daily Stock status report, Weekly, Monthly, and Periodical Reports.
• Created various (Back-end) PL/SQL code to implement business rules through procedures, functions, and packages using SQL*Plus.
• Creation of AOL Objects like concurrent Programs, Executables, Lookups, Messages.
• Created Indexes on various table for faster retrieval of the data to improve the database performance.
• Created inline and correlated sub queries based on the business requirement.
• Expertise in using joins in where clause to achieve correct output, which are inner join, left outer join, right outer join, full outer. join.
• Have good knowledge on working with Oracle Pseudo columns like ROWID, ROWNUM, SYSDATE, CURRVAL, NEXTVAL.
• Experience in working with analytical functions, RANK, DENSE RANK, PARTITION OVER.
• Created triggers for auditing purpose.