SUMMARY

• Over 20 Years IT experience including 15 years in enterprise - wide Oracle Applications design, development, systems analysis, defining system standards, implementation, and database administration.
• Solid expertise in functional as well as technical aspects of ERP solutions implementation using Oracle Financials. From 10.5.7 to Release 12.0.4
• ver 10 years Installation and configuration of Oracle tools and databases, export, import, stored procedures, packages, functions, triggers, auditing and tuning database for performance.
• Developer 2000 (Forms 5.0, 4.5, Reports 3.0, 2.5, & Graphics 2.5) between 10-15 yrs
• 3 years in SQL*Forms (3.0 & Reports 1.1) and 2 years of Pro*C
• 2 years using Java 1.2,, JDBC, AWT, JFC, Java Script, Java Swings, Web Logic 4.5, Visual Modeler 6.0

TECHNICAL SKILLS

Databases: Oracle 8.x, 7.x, 6.x, Microsoft Access, Ingress 5.43

Hardware/OS: DG Avian 5500, HP 9000, Sun Solaris, Assembled servers, SCO open server, Irix or Indy server, Unix SVR IV, DG-UX, HP-UX, Windows NT 4.0, 95/3.11

Tools: Oracle Designer 2000, Developer 2000 (4.5, 6I),shell scripting, PowerBuilder, SQL*FORMS 3.0, SQL*Report Writer 1.1, SQL Menu 5.0, SQL*Plus 3.x, Toad

Languages: PL/SQL 2.x, Power Builder 5.0, Visual Basic 4.0, Pro-C, C, C++, Java 1.2, Java script 1.0 and 1.1, Java swing, transact SQL for ms SQL server 7.0, rational rose 98, web logic 4.5, visual modeler and visual basic 6.0

ERP: Oracle Applications (Oracle Financials V 10.6 SC & V 10.7) & 11i, 11.5.10.2, R12.0.4

PROFESSIONAL EXPERIENCE

Confidential, TN

Oracle Senior ERP Developer / Support

Responsibilities:

• Working with a team of 10 developers and team of help desk support people.
• Business and technical requirements on following modules:
• Accounts payable, Inventory, Oracle Process Manufacturing, purchasing and accounts receivable
• Functional support in the above modules
• Used .net for creating interfaces for locations to enter products and sales data
• Worked on production support on above modules
• Conversion from parent company to new company in oracle applications 11.5.10 on above modules
• Worked in functional/technical aspects of Oracle Internet Expenses and iReceivables
• Production support for Oracle Process Manufacturing
• Custom built module for ctx payments using .net and tied to Oracle Payables
• Custom built module for IBM invoice imaging using .net and tied to Oracle Payables
• Fertilizer equipment systems
• Custom.pll and personalization
• Workflow notification and customization for purchasing
• Customization of invoice number and vendor merge using custom.pll and .net
• Worked on various reports and forms in developer 6i
• Worked on extensive PL/SQL in packages, workflow, triggers, libraries and used in sql executables in apps
• Using dynamic sql for reports in Accounts Receivable and Accounts payable as user was passing the criteria through the URL
• Created additional reports with java frontend and using dynamic where clause for flexible reporting
• Customer refunds - AR
• Worked on implementation of Advance Benefits, KRGNOS and Payroll and Time & Labour. Also did customization of forms and reports in the modules. Did functional and technical documentation on the same.
• The transition process (in brief) involves payables collecting copies of all utility and solid waste bills from all locations to send to Avista.
• Using XML to Load Catalog Schema
• Conversion and customization from 11.5.9 to 11.5.10 on Financials, OPM, PO and INV
• Production support in GL/AP/AR/INV/OPM/iProcurement/iexpenses
• Mentor colleagues in best practices for architecture design, development and standard toolsets used.Work with other application support team members to troubleshoot issues and ensure operational readiness as it relates to integration with upstream and downstream systems.
• Configured Oracle R12i AR and Advanced Collections as per the business needs and the user specifications. Played a major role in setting up accounting for oracle AR, Advanced Collections and GL modules of Oracle E-Business Suite..
• Configured Oracle AR to setup Transactions & Receipts. Transactions include setting up the Payment terms, Invoice Line ordering rules, Transaction Types, Transaction sources, Grouping rules, Auto Accounting, batch sources etc. Receipts configuration includes Auto Cash Rule Set, Remittance Banks, Receipt Classes, Payment methods, Receipt sources, Lock box setup, Transmission Format Setup, Setup for cross currency Receipts.
• Implemented setup for GL Daily currencies. Defined currencies for all the countries that business needs. Also setup cross currency receipts to use currencies available. Used corporate currencies as cross currencies.
• Wrote a package to load the GL daily rates into oracle and use them accordingly, made use of the staging tables for initial load, validated and loaded them into the GL DAILY RATES base table. Also performed SQL tuning to improve the loading accuracy of the data. Used shell scripts for loading the initial data into the staging tables by using SQL*Loader.
• Played a key role in assigning the reporting set of books to primary set of books. Opened and closed Periods in both reporting and primary set of books. Used MRC to convert Functional currency into another currency at the transaction level.
• Created package to load the receipts from external systems into oracle system. Checked for data accuracy and validated the same. Divided the receipts into Applied (Daily Payments), unapplied cash receipts and then processed the same using the package built. Used API’s to load the Unapplied Cash receipts. Ran and managed Auto Lockbox for payment processing. Wrote a procedure with in the same package using AR RECEIPT API PUB.CREATE AND APPLY API to create and apply cash receipts to specified debit items.
• Used Advanced Collections features to manage Transactions, customers. Ran concurrent programs for Dunning plans. Changed strategies and assigned new strategies for customers. Ran reports for Delinquent customers, payment collector summary and other reports. Created and used Dunning plans.

Confidential, Boston, MA

Sr. Oracle Developer -Supervisor

Responsibilities:

• Developed functional and technical documentation for implementing Oracle Applications 11I
• Used PL/SQL for developing packages and procedures using Dynamic SQL
• Did setup of the following in iProcurement:
• Document sourcing setup
• Catalog Setup and management
• Also was responsible for collection of functional data as needed by the users
• Shell scripting and host programs for pulling data
• Developed queries and views for reporting
• Worked on Forms 6i and Reports 6i
• Used dynamic sql for getting gl report information using .net as frontend
• Worked on the following modules in Oracle Applications AP, PO, GL, FA, MFG, OM, WORKFLOW, AOL INVENTORY.
• Performed Q/A activities to ensure that Reports meet the functional specifications
• Created PL/SQL procedures, packages and functions used to load and verify data from vendor feeds into an Oracle Database
• Working on Pl /sql packages, procedures, functions, Created views, customized forms and reports (6I)
• Also written a lot of shell scripts which are used to interact with cross modules and AOL
• Worked with Custom.pll in customization
• Used BPEL(Business Process Execution Language) in B2B for Supplier integration
• Worked on sql reports and created web reports while passing dynamic where clause to get data
• Used the dynamic sql for building query for web reports in .net
• Created web reports where data needed to be passed to sqlplus and inventory information for locations
• Worked with sql loader to load data from flat files and also using pl/sql to create flat files
• Provided Database maintenance as required to support the Reports being created.
• Worked on many complicated Oracle Reports and Forms 6i used for pulling data into applications on the Oracle 8i database
• Involved in activities on the backend as well as on the functional side of Oracle Applications and the Database.
• Worked on implementation of Advance Benefits, KRGNOS and Payroll. Also did customization of forms and reports in the modules.

Confidential, Waltham, MA

Sr. Oracle Developer -Supervisor

Responsibilities:

• Performed systems requirement study and user requirement study.
• Took a final view on all the user requirements from a QA perspective.
• Planned the database changes to be made.
• Worked on design using Visual Modeler and Rational Rose for the three-layer model
• Designed Servlets Objects and the required connectivity to the database
• Designed a Server Side objects using PL/SQL and transact-SQL
• Developed PL/SQL packages, ten SQL reports, twelve views and many triggers to support the GUI. Developed ten PL/SQL packages to integrate the Oracle Manufacturing tables and the look tables in the present system. Developed new Forms using Developer 2000 and Forms 4.5 to implement user requirements. Modules worked on include Bill Of Materials and Oracle Purchasing to integrate the current data into Oracle tables with manufacturing tables.

Environment: Database: Oracle 7.3, Oracle Manufacturing