PROFESSIONAL SUMMARY:

• Over 15 years of developing Oracle custom applications and performing Oracle E Business suite design, development and production support in various industries including Oil & Gas, Financial, Manufacturing, Energy and Retail
• Techno Functional Experience with Oracle Apps R12/11i, Oracle 10g/11g database, Oracle Forms 10g/Reports 10g
• Solid experience in implementations of Oracle Apps (R12/11i). Modules: AP, AR, GL, FA, INV, PO, OM, BOM, WIP, Engineering and Quality, Oracle Projects & Oracle Energy Base, Oracle Revenue and Upstream modules. Coding standards for the best technical practices, AIM methodology document deliverables Ex: Mapping Documents(CV40),Technical Design Docs(MD70), Functional Design documents(MD50) etc.
• Ability to work on a team or independently and resolve time critical business issues
• Extensive production support experience across various industries
• Strong technical skills in conversions, custom Inbound/Outbound interfaces and APIs. Heavy experience in data conversion/interfaces between different systems using PL/SQL and SQL Loader.
• Expertise in back - end development of Oracle database (procedures, functions, packages, and database triggers) using PL/SQL and tuning the applications
• Strong Unix shell scripting, SQL Loader, Oracle Forms 10g/9i/6i, Reports 10g/9i/6i, Workflow Builder, Oracle BI /XML Publisher, J Developer and Oracle Discoverer skills. Developed extremely complex Oracle Reports/XML Publisher Reports & Oracle Forms in both Oracle Custom data base environment and Oracle Apps environment.
• Experience with full lifecycle software development from Requirements/Analysis to Unit/System integration testing
• Masters in Computer Science GPA 3.75

TECHNICAL SKILLS:

Software: ORACLE 10g, 9.X,8.X,7.X/6.0, Oracle Applications R12/11i

Tools: Toad 10.1.2.0.2, PL/SQL Developer, SQL Navigator, Oracle Developer Suite 10g/6i, Forms 10g/6i, Reports 10g/6i, XML/BI Publisher 10.1.3.4.1, Workflow Builder 2.6.3.5, Oracle Discoverer & SQL Loader

Languages: C, SQL, PL/SQL, Pro *C, TSQL, HTML

PROFESSIONAL EXPERIENCE:

Confidential, Houston, Texas

ASM Technology Consultants

Responsibilities:

• Oracle Applications R12.1.3, Senior Oracle Consultant
• Involved in the implementation of partner balancing module. Designed and Developed several custom loaders for Companion Allocations, Marketing Groups, Add Facility to Completion, RC Equations and Product/Property Xref. This involves complex PL/SQL coding. Loading data from excel file to the Upstream module tables. These loaders loads data automatically without manually entering through the Upstream forms.
• Designed and developed BI Publisher reports for the above loaders to report errors and warnings to users.
• Imported sales orders (OM) using order import API.
• Gathered functional requirements and developed Bill and Routing interface to create, update and delete manufacturing and engineering bill of materials(BOM) and products.

Confidential, Houston, Texas

Senior Oracle Consultant

Responsibilities:

• Designed and Developed split parish, drip skim, buy back(Normalization) post processes that runs after Monthly/Daily allocation process. These processes will create new dispositions/virtual completion records in AMD/AMDD tables.
• Automated all Production Management post processes so that they run automatically after the Monthly/Daily allocation run. Automation includes running post process program from the allocation form and displaying complete process log for the users so that they can evaluate any errors in the process.This automation saved tremendous amount of time for business and all the post process are run from one place in the order business wants.
• Involved in effective date implementation of plant field for all the interfaces that runs from custom PDREP database(Maintains EU Data for reporting) to other BHP systems. This involves modifying all custom interfaces/views to reflect the new effective date change. Designed and developed new data model to reflect new changes in their custom PDREP database.
• Involved in the production support of Upstream Production Management modules

Confidential, Houston, Texas

Senior Oracle Consultant

Responsibilities:

• Oracle Applications R12.1.2, AP, GL, PO, AR, Developer Suite 10g Senior Business Analyst
• Did OAF Form Personalization to add the Supplier Status / Inactive Date to the AP Supplier Search form.
• Functional/Technical analysis of “AP Invoices Validated and approved, not paid” problem. This involves checking the conditions that prevent an invoice from being selected for payment.
• Worked on Supplier Payment History errors after ATG 12.1.3 upgrade. Analyze the problem and apply required patch to fix the problem.
• AP invoice and PO Amount out of synch problem. Analyzed and fixed the problem by fixing the AP invoice. This involves fixing AP invoice lines and applying data fixes.
• Created brand new AP Invoice Account Distribution Report and BWP Workflow Status Report using BI Publisher. Workflow status report will report Projects personnel status of Project workflows that are initiated across the application. This involves requirement analysis and creating MD50
• Email of Reports after ATG 12.1.3 - Configured the email delivery options in concurrent program submission.
• Worked on Create Suppliers in Upper case only.
• Analyzed how to not display the service PO amount on a PO Document. At present Boardwalk creates service Pos manually as they don’t want to show the dollar amount on the existing PO document which is taking several man hours. Analyzed and implemented change to the PO document so that it will not display service PO amount in the PO document. This involves customization of po headers xml, po lines xml views.
• PO Requisition Workflow errors process beat by first responder. Debug/trace/reproduce and fix the problem. Involves testing complete PO requisition workflow at different approval levels.
• Created Custom Request Groups and Custom Responsibilities.

Confidential, Houston, Texas

Senior Oracle Consultant

Responsibilities:

• Oracle Applications R12.1.3, Oracle Reports 10.1.2
• Involved in the implementation of new operating unit for Occidental Petroleum Corporation. Converted the whole Energy Upstream Revenue data into existing ONEOXYP Revenue.
• Converted the OEMI revenue to ONEOXYP Revenue. The data conversion process involves using heavy PL/SQL procedures, functions, Packages to convert entire revenue data. Ex:codes, banks, Parites, Sites,roles, Report Centers, DOIs, Agreements, Attach DOI to Agreements, Party Transactions, Revenue Bank Accounts, Price Schedules, Product UOMs, Backup withholding rates etc in Oracle Enterprise Upstream Revenue application.
• The conversion of DOIs, agreements, Party transactions include loading of the data into XP tables and submit Appropriate XP program to create the DOIs/Agreements/Party transactions. Check EB XP Errors for possible errors in loading and rerun until the errors are fixed and also validate data through front end forms for any possible errors
• Involved in multi org testing of data to make sure migrated data is not causing any conflict with the already existing Org. Testing also includes making sure the data looks good through the front end forms(eg: Parties, DOI forms, Agreements forms etc)
• Involved in the Unit/System Integration testing/go live of the new operating unit implementation.
• Assisted in go live of Entire Revenue data conversion into production instance and also wrote SOX audit scripts for Energy Revenue Data Conversion.
• Automated the “Revenue payment generation process” in Energy Upstream module so that it will process the payment generation for all the processing parties without manual intervention. This process tremendously reduced the man hours required and also saved tremendous amount of time in the payment generation process. This process involves creating complex PL/SQL packages, Oracle Reports to submit the concurrent programs automatically by using fnd submit. This payment generation process involves automation of Payment Generation(ERPYPAYG-Builds Payment Registers tables), Stamp document number(ERPYUPDT), Wire transfer Remit Advice(ERPYWXRA). Also customized the existing payment process summary, GL Generation Summary reports as part of automation
• Debugged and fixed the problem of pressure base missing on Revenue checks..
• Created a concurrent program to populate Temp tables for Regulatory Users for comparing oil & gas volumes from TOW to Oracle Revenue for a given accounting period.
• Developed several brand new Irrigation/Gas reports by using Oracle reports 10.1.2.
• Created materialized views for revenue party transactions.

Confidential, Houston, Texas

Sr. Oracle Developer

Responsibilities:

• Oracle Apps R12(AP, AR, GL, PO, PA), Oracle 11g, Reports 10g/BI Publisher 10.1.3, PL/SQL
• Involved in the upgrade of Oracle Applications from 12.0.4 to 12.1. Fixed workflow customization problems in various modules during upgrade. This includes PA Projects workflow, PA Budget workflow, Expenses workflow etc. This involves heavy PL/SQL, Workflow builder expertise. Involves writing custom packages that are called by the workflow process.
• Customized PO Requisition Account Generator(POWFRQAG) workflow. This involves customizing ‘Generate Default Accounts’, ‘Generate Default Accrual Account’ processes to derive Accrual Account company segment based on Charge Account Company segment for project based, non project based expenses.
• Customized “Project Expense Report Account Generator(PAAPWEBX)” workflow to derive Account segment based on intercompany or non intercompany transaction.
• Prepared MD70 for all the development done. Coordinated the unit/system integration testing with the users

Confidential, Houston, Texas

Sr. Oracle Developer

Responsibilities:

• Involved in implementation of Oracle Applications R12(12.0.6) on AIX server. Modules: GL, PO, INV, OM, BOM, WIP, Engineering, Quality. Developed Custom extensions and several custom reports using BI Publisher. These involve heavy PL/SQL, SQL Skills using Oracle 10g database.
• Developed Progressive Billing Alert to send email messages to the Project Manager, Sales Person on the Sales order saying it is time to bill the customer. This Alert initiates on the request date of Sales Order, VTI Progressive Billing Order Types in Order Management
• Customized Engineering ECO Approval workflow so that the email notifications are sent sequentially to the approvers in the Engineering approval list. This also sends the rejection reason to the requestor if the ECO is rejected.
• Uploaded ADP Payroll data into Oracle GL. Created custom layout, column mappings for payroll data using Web ADI. Converted the excel file from ADP to tab limited text file and uploaded to Oracle GL using Web ADI. Setup Journal Ledger Source, Category for Payroll data.
• Designed and developed several complex custom reports using Oracle Reports 10g, BI/XML Publisher 10.1.3.4.1 . This includes Territory Sales, Industry Sales Reports to display the sales order quantity, dollar value by territory and order types for a given period. Vendor Packing List, Product Inspection (SVF 105) confirmation report to display the product inspection results that are captured in Oracle Quality plans, Commission report, Sales Order transaction detail report, Project Profit Summary, BOM Reports etc using Oracle Reports 10g/XML Publisher. These reports include creating complex BI publisher templates using Microsoft word and using the bursting functionality of XML Publisher.

Confidential, Houston, Texas

Sr. Oracle Developer

Responsibilities:

• Involved in implementation of Oracle Applications 11.5.10.2 Modules: AP, AR, GL,FA, PO, INV,OM, Oracle Projects, Oracle P2ES Applications
• Gathered requirements for several interfaces, performed design using MD70, data mapping documents and developed several custom interfaces by writing custom packages using PL/SQL
• Interfaces include AR interface from Lease cost system (Oracle) to Oracle AR, Journal Import from Lease cost system to Oracle GL, AR invoices import interface from Open Link Endur to Oracle AR. Developed and tested all the Interfaces mentioned above and provided production support after go live.
• Designed and developed Bengal interface to load AFEs from HighMount Bengal system to Oracle
• Energy Authority for Expenditure(AFE). Loaded data into AFE interface tables (ee afes xp, ee rc associations xp, ee line items xp) and Submitted the API “AFEXPAPI” from PL/SQL package.
• Customized Distribution Transactions, DOI Allocations forms using Oracle forms personalization to restrict the functionality of the form by the login responsibility in Oracle Energy Revenue Module. Also customized DOI parties, DOI Report Centers forms to do custom validations using Forms Personalization.
• Converted assets from the other asset system by loading the information into the Confidential table and running the mass additions process. Also used mass additions to import asset information into
• Oracle Fixed Assets from Oracle Payables. Developed a custom program to validate and load asset information from Oracle ADI to FA.
• Interfaces involved complex SQL, PL/SQL, Shell scripting, SQL Loader skills and the functional knowledge of underlying tables
• Involved in the functional setups of Oracle Financials for all the custom interfaces mentioned above
• Conversions from SAP to Oracle E-Business. This involves detailed interface tables mapping(CV40),
• Design, lookups and scripts using the SQL, PL/SQL, SQL*Loader, UTL FILE and Unix Shell scripts.
• Conversions include Open Purchase Orders, PO Attachments, Inventory Items(INV), Items On hand
• Balances(INV), Open Sales Orders(OM). Imported transactions from expense reports into Oracle Projects by using PRC: Transaction Import open interface. This involves populating the interface table and running Transaction import, review import exceptions in Review transactions window. Created projects by using pa project pub.create project. This involves creating PL/SQL Package to create projects through backend.
• Provided primary production support resource after go live
• Analyzed day to day production problems and resolved the business critical problems in a timely manner which involved interacting with several users and the management team and performed several custom development efforts after go live which involved extremely heavy Oracle backend and front end Oracle tools including Oracle Forms 6i/Reports 6i and BI Publisher
• Web/OA Framework: Developed a Self Service OAF Form using Jdeveloper for Inventory Material transfer, Added additional columns to i-expense entry form with VO extensions, Also added drop down/pick lists using VO extensions, developed inventory item search screen. Developed jsp page to launch the filenet application from AP invoice. Developed many custom OAF Self Service web pages in General Ledger and Inventory, PO using Jdeveloper. Some key OAF tasks include, extending VO,AM and OAF personalizations
• Developed Oracle Web ADI to GL import with custom validations and a custom Journal import program which included validation of data in GL interface tables and submitting when the validation was a success which involved extremely complex PL/SQL backend development skills
• Developed custom validations on several AP, GL and PO Requisitions forms by using custom.pll and Oracle forms personalization
• Developed custom forms for GL reconciliation process using Forms 6i
• Developed the scripts for AP 1099 process which involved loading 1099 vendors and updating 1099 tax codes. Customized 1099 reports using Reports 6i and developed several Oracle Reports in Oracle Financials modules using Reports 6i
• Converted numerous RDF reports into XML publisher and developed new reports as well as modified existing reports using XML (BI) Publisher
• Developed custom reports to generate bar codes for GL Journal voucher Header page by using BI Publisher which involved creating templates in Microsoft Word as .rtf files, creating barcode fonts and the report consists of parameters
• Performed Oracle forms customizations using Oracle forms personalization to restrict the functionality of the form by the login responsibility

Confidential, Houston, Texas

Senior Oracle Consultant

Responsibilities:

• Oracle 9.2.0.8, Developer 6i, Reports 6.0.8.20.1, Oracle Forms 6.0.8.21.3
• Involved in the customization and production support of Retek Merchandising System (RMS) and Retek Distribution Management (RDM) systems
• Duties included the resolution of ongoing production problems that included custom processes and reports (both batch and web)
• Involved in the enhancements of several custom Oracle Reports for Stage using Oracle Reports 6i
• Created the design documents and merged existing style reports into one and enhanced them to create extra sort conditions
• Designed and developed Everyday and Holiday tax rate change screens to implement the new tax rate for Confidential using Forms 6i which were complex forms that contained multiple tabs and involved heavy Forms 6i development skills

Confidential, Houston, Texas

Senior Oracle Consultant

Responsibilities:

• Oracle Applications 11i (11.5.10.2), Oracle 9.2.0.7.0, Developer 6i, Discoverer 9.0.2
• Modules: AP, AR, GL, PO, iExpenses, Workflow etc, ADI (Application Desk top integrator), FA, etc.
• Primary production support for the Oracle Applications
• Resolved day to day production support issues in different Oracle Application modules
• Resolved several CU2 patch issues with workflow notifications of PO and expense reports, FSG reports, report publishing issues from ADI
• Fixed incorrect calendar periods in the fixed assets tax set of books
• Created new users, registered new printers and issues with workflow notification servers
• Involved in resolving the issues with workflow notification servers and monitoring the status of auto invoice programs

Confidential, Houston, Texas

Senior Oracle Consultant

Responsibilities:

• Oracle Applications 11i (11.5.5), Oracle 8.1.7.4, Developer 6i, Discoverer 9.0.2
• Modules: AP, AR, GL, PO, INV, iprocurement, Oracle Energy, HR
• Involved in the maintenance and migration of Unocal Oracle Applications 11i which involved on going production maintenance and migration of Oracle Application 11i to SAP
• Involved in the ongoing support and enhancement of AP, AR, GL, PO, FA and iprocurement modules
• Created a process to disable all the associated GL Code combinations when a user disabled a key accounting flex field value
• Enhanced the data extraction process for different GL Groups
• Played major role in generating 1099 for IRS for AP, Energy Revenue modules
• Customized the 1099 patches and also the 1099 reports using Oracle Reports 6i
• Developed ad-hoc reports in Oracle Discoverer 9i
• Developed, supported and customized reports for Accounts Payables and Fixed Assets such as Invoices, Distributions, CIP/Capitalized Assets by using Discoverer 9.0.2
• Created ad-hoc reports for Oracle GL, HR used for payroll related finance analysis
• Created new reports for HR employees who work and live in different states using XML Publisher
• Created the scripts to end date the user responsibilities and assigned them the view only responsibilities as a part of decommissioning of Oracle Financials

Confidential, Houston, Texas

Senior Oracle Consultant

Responsibilities:

• Oracle 10g (10.1.0), Forms/Reports 10g (9.0.4), Oracle Applications 11i (11.5.9), Oracle 9i/10g, Developer 6i, Discoverer 9.0.2, HR
• Involved in the implementation of Gulf State Toyota AR module in Oracle Applications 11i which involved major migration of their mainframe AR system into Oracle Receivables 11.5.9 by using ETL tools and the scheduling tools
• Migrated all miscellaneous invoices/credit memos entered in excel spreadsheet by Gulf State Toyota AR group into Oracle AR
• Gathered functional requirements for this implementation and wrote the Functional/Technical design document and visualized the dataflows between different platforms by using Visio diagrams
• Developed a wrapper program using Shell scripts that does FTP of Excel spreadsheet and loads the data from spreadsheet into Oracle Auto Invoice staging tables
• Ran auto invoice for different batch sources to successfully load invoices/credit memos into Oracle AR
• Reviewed the final invoice/credit memos creation in Oracle AR
• Actively involved in the functional setup of AR module
• Setup batch source, transaction types, system options, auto invoice grouping rules, invoice transaction flexfields, Invoice line flexfields etc.
• Reviewed the GST (Gulf State Toyota) AR setup document
• Developed a wrapper program to load different batch data from mainframe AR to Oracle AR
• Actively involved in unit testing and system integration testing of GST AR implementation
• Migrated the customers from Mainframe AR into Oracle AR Staging tables and ran customer interface to transfer the customers into Oracle AR
• Upgraded the Forms/Reports from 6i to 9i/10g (9.0.4)
• Created views, added the views to the user requested business areas by using Oracle Discoverer
• Created workbooks with joins and maintained folders using Oracle Discoverer 9.0.2
• Developed several workbooks that contain several pages and by using different layouts in AR module
• Extraction of employee data from HR tables using custom views

Confidential, Houston, Texas

Senior Oracle Consultant

Responsibilities:

• Oracle Applications 11i (11.5.4/11.5.9 ), Oracle 8i, Developer 6i
• AP, AR, GL, Work Flow Builder 2.6.3.0.1, 11i CRM, Oracle Contracts Core & Oracle Contract Service Modules, PL/SQL Developer 6.0.0.840
• Upgraded the Oracle Financials and CRM applications from 11.5.4 to 11.5.9 on Sun Solaris 2.8
• Worked on upgrading all the custom workflow notifications in Oracle Contracts Core module
• Fixed the problem of workflow notifications displaying HTML source code in the message body by using Work Flow Builder 2.6.3.0.1
• Tested all the custom workflows in Oracle Contracts Core module
• Upgraded all the custom forms and reports from Forms 6i/Reports 6i to Forms/Reports 6i
• Migrated all the custom changes from old custom.pll to new custom.pll in 11.5.9 and created the new custom.pll
• Created shell scripts to automatically recompile all the custom Forms/Reports in 6i
• Scripts enabled to recompile all the forms and reports in batch mode
• Worked on several custom AR Aging reports to fix the upgrade performance problems
• Involved in testing several custom reports for 11.5.9 upgrade
• Involved in the testing of Several customizations for the 11.5.9 upgrade

Confidential, Houston, Texas

Senior Oracle Consultant

Responsibilities:

• Oracle Applications 11i(11.5.8), Oracle 8i, Developer 6i, PL/SQL Developer 5.1.4, Work Flow Builder 2.6 Modules: AP, AR, GL, PO, Work Flow
• Customized the AR Receipts workbench to restrict the manual application of cash depending on the login responsibility of the user and customer type
• Change implemented by using custom.pll change
• Fixed the performance problems by using SQL tuning and Explain plan
• Automated the cash application process for receipts that are on account by using AR Receipts API
• Process found all On account applications after the Lockbox run was completed and applies them to the correct invoice
• Implemented email notifications to send the output to the users
• Email notifications implemented using Oracle work flow
• Developed Custom AP, PO writeoff reports using Reports 6i

Confidential, Houston, Texas

Senior Consultant

Responsibilities:

• Oracle 8i, Developer 6i, SQL Server 2000, Shell scripts
• Involved in the support, migration and enhancements of CORE, MSDS(Material Safety Data Sheet) applications
• Gathered the business rules from the end users, designed and developed the custom
• Oracle database (8i) and its GUI using Oracle developer6i
• Application was on web so that both internal and external users can access this
• Migrated all the data from the vendor application to CORE application
• Developed several custom forms, reports for MSDS/Core Application from scratch using Oracle Forms 6i, Reports 6i and was involved in the enhancements/support of these custom applications
• Migrated the databases, applications from the Tempe servers to new Bville servers as the part of Newco separation of Confidential
• Created the web interface for the Super Bowl competition games for the employees by using Java Script, VB Script, HTML
• Created the web pages using XML schema and Style sheet
• Mentored several user training sessions and trained the users with the applications
• Experienced in creating Visio diagrams

Confidential, Houston, Texas

Senior Systems Analyst

Responsibilities:

• Package: Oracle Applications 11i, 10.7 SC 16.1 on HP Server
• Modules: AP, AR, GL and Oracle Energy 3.3.1
• Involved in the support of different client (Torch Energy, Newfield Exploration, Belwether, Mission etc) databases for AP, AR and GL modules in 11i
• Developed several custom reports, forms, triggers in AP that deals with Invoices, Invoices On
• Hold, Payment Schedules, Vendors and Vendor Sites
• During the support assisted different client problems in Setting up Suppliers, Entering and Approving Invoices,
• Paying Invoices, creating accounting entries and sending transactions to the General Ledger (GL)
• Involved in the setup of AutoLockbox in AR for the Confidential Clients
• Imported the data from the data file provided by the Bank, submitted Validation and Post QuickCash processes and tested the Autolockbox
• Helped the users in setting up the Banks, Bank Accounts and Receipt Classes in AR and AP modules
• Worked on several database triggers, reports in GL
• Modified Custom trial balance report to use the account grouping to be setup with descriptive flexfield instead of the hardcoded values used to group the report
• Created User Documents for various custom Forms and Report developed
• Trained all the relevant Confidential customers on the usability of developed forms and Reports
• Worked on different Oracle Energy 3.3.1 modules like Oracle Energy Base, Oracle Energy Land, Oracle Energy Production Accounting for different Confidential clients
• Worked on several reports 6i/2.0, forms 6i/4.5 and processes in these modules
• Worked on Parties, Party Aliases, Report centers, Prospects, Agreements etc in Oracle Energy Base
• Worked on Custom Land Operator Mass update form which is used to selectively update Report Center operators, Obligation Responsible parties and the obligation Flexfield in Oracle Energy Land
• Developed custom reports for Gas Allocation, Injection History Information, Theoretical Production Report, AFE Template for two AFEs etc.
• Carried out upgrade of AP, AR, GL from 10.7SC to 11i for different Confidential clients
• Upgraded several custom forms and custom reports from 10.7 to 11i environment using Oracle Forms/Reports 6i
• Developed several discoverer reports in Oracle Energy/Oracle applications using Discoverer 3.1
• Created workbooks, views to show the AP Supplier information
• Used Toad 6.5/SQL Navigator 4.0 to access and analyze the data from database
• Trained in Oracle Payables 11i at Confidential, Houston

Confidential, Houston, Texas

Senior Oracle Consultant

Responsibilities:

• Specifically upgraded the AOL, OE, AR, GL, INV and AL Oracle Application modules from version 9.4.2 to 10.7 using Oracle RDBMS 7.3.4.4 on Digital Dec Alpha 4.0e for Year 2000 compliant
• Ran AutoInstall on existing system (version 9.4.2) to be upgraded and also, actively worked in applying Y2K patches for Oracle Server and Oracle Applications
• Recompiled and linked all the custom Pro*C user exits into aiap
• Thoroughly tested all the user exits functionality to get item price from SAP system by using Tuxedo Service
• Upgraded all the existing custom interfaces including customer interface, RMA (Return Material Authorization) interface and OMAR (Order Management Account Receivable) interfaces
• Thoroughly tested all of the above interfaces as well as the Y2K compliance
• Identified and setup all the incompatible programs in the Custom Application at program and report set level so that they does not run at the same time as other reports or concurrent programs
• Investigated upgrade path for Compaq's Corporate Returns System (CRS) from release 10.7 to release 11
• Replicated Compaq's existing Applications (r10.7) environment on a Sun Solaris (v2.6) server with Oracle7.3.4 and Applications release 10.7 by using Auto-install, Oracle DBA and UNIX utilities
• Configured SCO Unixware7 server with Oracle8.0.5 and Applications release 11.0.2 using Auto-Install as a vanilla baseline system to perform gap analysis

Confidential, Houston, Texas

Oracle Applications Manager

Responsibilities:

• Involved in the customization implementation phase of OE, INV, Sales Compensation Oracle Applications 10.7.0 PROD 16.1 SC using Oracle RDBMS 7.3.3 on Sun Server
• Responsibilities included interacting with a group of developers for migrating the server side, client side files to different instances and specify documentation specifications for the release notes
• The duties include creating tables, views, synonyms and compiling packages, stored procedures, database triggers, etc.
• Moved all the customizations to Integration Test instance and also to the Production instances which included registering all the Concurrent Programs, Customized Forms with Oracle Applications and defining Menu Structures etc.
• Defined the concurrent managers and their workshifts and specializing managers to run only certain programs
• Defined the request sets and Request Groups and submitted the Concurrent Requests to run at specified intervals and at specific time of a day
• Defined the Independent Value Sets and their Values, Table validated Value Sets, Dependent Value Sets etc.
• Responsible for registering all the customization, created and compiled all database side objects and to make the system up and running as a “go live” trial
• Responsible for checking the invalid objects in various instances and making them valid