SUMMARY

• 7+ years of IT experience in complete System Development Life Cycle (SDLC): Analysis, Design, Development, Testing, Implementation and Maintenance, customization and production support of Oracle applications and client - server environment. 5+ years of experience in technical development of Oracle Applications E-Business Suite.
• Expertise includes Oracle Applications R12/11i, Forms 10g/6i, Reports 10g/6i, Oracle Workflow 2.6.3, Oracle 11g/10g, SQL, PL/SQL, XML Publisher 5.6.3 and Oracle Discoverer 10g/4i.
• Good working knowledge in Supply Chain Management (INV, PO and OM), Manufacturing (BOM and WIP), Financial (GL, AP and AR) modules, Order to Cash (OTC) and Procure to Pay (P2P).
• Excellent technical skills working on RICE components, AOL setup, Data migrations, customizations of Oracle Forms, Forms Personalization, Oracle Alerts and Oracle APIs.
• Proficient working experience in creating Stored Procedures, Functions, Packages, DB Triggers and Indexes.
• Extensive experience in SQL tuning and Performance tuning of PL/SQL programs.
• Expertise includes Oracle Workflow design and development using Workflow Builder, understanding and customization of Workflow APIs, Workflow Notification, Workflow Background Engine and Workflow Purge.
• Developed UNIX Shell Scripts (ksh) for data interfaces and batch jobs.
• Good understanding of Software Engineering Principles, RDBMS/DBMS concepts and techniques.
• Good knowledge of Implementation Methodologies like AIM (MD200/MD60/70/BR100/CV60, TE50 Process documents).
• Performed unit testing and integration testing and created Test plan documents.
• Proficient in SQL*PLUS, TOAD, PL/SQL developer, SQL Navigator, SQL Developer and SQL*Loader applications.
• Proficient in TeamTrack 6.5, PVCS Tracker 7.5, PVCS Version Manager 8 and AppWorx 6 tools.
• Also worked aspost go live support/on-call production support consultant to monitor the production support applications.
• Mentor the team members in the design and development of oracle procedures, queries with onsite/offshore execution model.
• Has good experience in solving critical production problems and in taking critical business decisions.
• Ensure the resolution of incidents and bugs within agreed time frame.
• Ability to quickly master new concepts and implement latest technologies.
• Good team player with excellent analytical, communication and interpersonal skills.

TECHNICAL SKILLS

ERP: Oracle Applications (E-Business suite) R12/11i and Oracle Workflow 2.6.3Purchasing, Inventory, Work In Process, Bills of Material, Order Management, Sales Contracts, Procurement, iSupplier, General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, Payroll, HRMS

Programming Languages: PL/SQL, Visual Basic 6.0, Java/J2EE, C, C++, Pro*C, BPEL

Scripting Languages: HTML, XML, Unix Shell Scripting

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2000, MS Access 2003

Operating Systems: Windows 7/Vista/XP/NT/2000, UNIX and MS-DOS

GUI tools: Developer 10g/6i (Forms 10g/6i and Reports 10g/6i), Application Object Library (AOL), Oracle Workflow Builder, XML Publisher 5.6.3, Oracle Discoverer 10g/4i, Oracle Application Express (APEX), Oracle Designer, Oracle Application Framework (OAF), ADF, JDeveloper, JSP, SOA, Crystal Reports 11.0, MS Project, MS Visio and MS Office 2010

Oracle Utilities: SQL Plus, SQL Navigator, TOAD, PL/SQL Developer and SQL*Loader

PROFESSIONAL EXPERIENCE

Oracle Apps Developer

Confidential, San Clemente, CA

Responsibilities:

• Participated in and drived the analysis, design, development and customizations of theOracleApplications eBusiness suite (Forms,Reports, PL/SQL queries) and deployed such modification/customization inOracleeBusiness environment.
• Analyzed the user requirements and developed technical design documents for conversions, extensions, interfaces and reports.
• Created Forms Personalization on Purchase orders form.
• Developed Duty Drawback Report for Logistics to request a refund for the customs fees ICU paid on raw materials that were first imported to the USA and then shipped back out as a subassembly or finish good out of the country.
• Develop a report for Business Continuity Planning Project that lists all the multilevel exploded Bills of Material for a group of items loaded into a temporary table.
• Developed a report that gives all the WIP Component Issues for EAM spare parts against work order performed with cost and total value information for EAM organizations.
• Developed a report for work order status for maintenance group to keep track of individual and group performance.
• Developed Italy Critical Care Sales XML Report.
• Coded SQL* Loader programs to upload into temporary tables and developed PL/SQL procedures for validating and transferring the data in temporary table into Oracle Applications interface.
• Created test scripts, performed unit testing and documented unit test results. Provided support/issue resolution during user acceptance testing.
• Worked as an Onsite/Offshorecoordinator as part of onsite/offshore execution model project.

Environment: Oracle Applications R12, Forms 10g, Reports 10g, Oracle Database 11g, SQL, PL/SQL, XML Publisher, Oracle Discoverer 10g, TOAD 9.6, SQL*Loader, Altiris Helpdesk Solution 6 and Windows 7

Senior Oracle Developer

Confidential, KS

Responsibilities:

• Gathered, documented and reviewed requirements, helped in database architecture, drafted test plans and provided progress reports to project manager.
• Performed technical support and administration of theOracleSupplyChain, which consists of Inventory, Order Management, Purchasing and Warehouse Management.
• Participated in the design, development and maintenance of interfaces to and from OracleE-Business Applications and external applications.
• Used AIM Methodology to support the life cycle of the implementation.
• Understood the requirements and created technical design documents.
• Administered key setup screens, flexfields, profile changes, and concurrent managers.
• Designed and developed RICE(Reports, Interfaces, Conversions, and Extensions) objects.
• Developed an outbound shipment interface program.
• Worked on tuning of queries of the custom reports to improve the performance utilizing diagnostic tools (Explain Plan, TK Prof).
• Sourcing Rule Allocation, customize and generate Purchase Requisition through Request Import Program. Created a PL/SQL Package to do allocation program depending on sourcing rule defined. Created a Request Set to call sub requests to automate the whole process to create Purchase Requisition. Loading data from Legacy to staging table to interface table using PL/SQL program.
• Customized Forecast forms to see forecast data for different seasons.
• Developed reports for Planners to check the demand and supply for items across organizations.
• Created Cost Detail Report and convert into excel format using XML Publisher.
• Created Invoice Print Program to print invoice using XML Publisher.
• Created process diagrams using Oracle workflow. Called procedures from Oracle Workflow in creating cartons process.
• Created UTPs (TE20) and performed unit testing.
• Conducted research and tested patches necessary to correct bugs and enhance system functionality.
• Documented key application functionalities and processes and provided user training on them.
• Opened and managed TAR service request tickets withOracleSupport.
• Provided production support on a rotational on-call basis.

Environment: Oracle Applications R12/11.5.10, Forms 10g/6i, Reports 10g/6i, Oracle Database 10g, SQL, PL/SQL, Oracle Workflow 2.6.3, Oracle Discoverer 10g, XML Publisher, Oracle Application Express (APEX 3.1), SQL Navigator, SQL*Loader, PuTTY, PVCS Version Manager 8, and Windows XP

Oracle Developer

Confidential, Winston Salem, NC

Responsibilities:

• Analyzed business processes and documented the requirements.
• Documented technical design specifications as per company standards.
• Developed stored procedures, functions, packages, DB triggers, indexes, materialized views and used Dynamic SQL.
• Developed of all the major screens in Rating using Oracle Forms.
• Performance tuning of PL/SQL programs and oracle queries.
• Responsible for assigned code/screen modifications, enhancements and adhoc data requests.
• Collaborated with functional and technical teams.
• Configuring AOL setup in Oracle Applications 11i - registering Executables, Concurrent programs, and assigning to Request Groups.
• Develop iClose Central Console. It is a workbench screen that allows users to review status, review notifications, review exceptions, do corrections and submit for reprocessing.
• Develop iClose Status View. It is a web version to view status and notifications on the web and submit responses.
• Develop iClose Master Workflow and created process diagrams for various sub-processes that cover the entire closing processes.
• Customized the Accounts Payable Vendor Entry Form as per requirements.
• Created Alerts to notify users on various business events.
• Involved in writing PL/SQL package to perform the validations on the imported data and then load the data to the base table.
• Developed UNIX Shell Scripts (ksh) for data interfaces and batch jobs.
• Modified custom.pll according to the requirements.
• Generated flat files containing statistical data to send to government agencies.
• Created report to display premium rates depending on rating parameters.
• Checked in and checked out processes in PVCS Version Manager.
• Prepared of Technical specifications and Unit test plans.
• Performed other duties as requested by the manager.

Environment: Oracle E-Business Suite (EBS) 11.5.10, Forms 10g/6i, Reports 10g/6i, SQL, PL/SQL, Oracle Application Server 10g, SQL Navigator, TOAD, SQL*Loader, WinSCP, UNIX, TeamTrack 6.5 and Windows XP

Oracle Developer

Confidential, Fridley, MN

Responsibilities:

• Developed new programs from functional specifications.
• Designed and developed of screens using Forms 6i.
• Created login screen and implemented password protection facility.
• Created Oracle Forms to maintain material costs, labor costs, equipment costs, subcontracting costs and miscellaneous costs against each Project activity of the project for Project execution module and Project estimation module.
• Created reports to display the expenses against each cost components i.e. material costs, labor costs, equipment costs, subcontracting costs and miscellaneous costs by grouping each Project activity of the under each project, summary cost details for project activity under each project for Project execution module and Project estimation module.
• Created a report to compare the cost differences between Project estimation and actual expenses against each project.
• Created consolidated expenses of all the costs of each project activity for a given period of time.
• Implemented invoking estimated cost reports from the form after selecting the construction facility components on the form.
• Performance tuning of PL/SQL programs.
• Read data from flat files to Oracle tables using SQL*Loader.
• Job scheduling processes using AppWorx tool.
• Analyzed data issues and provided solutions to fix them.
• Prepared Technical design documents and Unit test plans.
• Technical support and training to end users.

Environment: Oracle 10g, PL/SQL, Forms 6i, Reports 6i, BI Publisher, Oracle Designer 10g, AppWorx 6, TOAD, SQL*Loader, Java, J2EE, JDeveloper and MS Visio