SUMMARY

• Over 10 Years IT experience including 5 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.
• over 10 years Installation and configuration of Oracle tools and databases, export, import, stored procedures, packages, functions, triggers, auditing and tuning database for performance.
• 5 years of experience in Developer 2000 (Forms 5.0, 4.5, Reports 3.0, 2.5, & Graphics 2.5)
• 3 years in SQL*Forms (3.0 & Reports 1.1) and 2 years of Pro*C
• 1 ½ years using Java 1.2, , JDBC, AWT, JFC, Java Script, Java Swings, Web Logic 4.5, Visual Modeler 6.0

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

EXPERIENCE

At present working for Confidential Collierville TN
Current Job description from May 2003 till present

• 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.
• Positive pay
• Hierarchy in GL reports
• Did setup of the following in iProcurement:
• Document sourcing setup
• Catalog Setup and management
• Requisitions setup
• Using XML to Load Catalog Data
• Using XML to Load Catalog Schema
• Search Engine
• PO History Feeds
• 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
• 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
• 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 dynamnic where clause for flexible reporting
• Customer refunds –AR
• Worked on implementation of Advance Benefits, KRGNOS and Payroll and Time & Labor. 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.
• Positive pay
• Hierarchy in GL reports
• Did setup of the following in iProcurement:
• Document sourcing setup
• Catalog Setup and management
• Requisitions setup
• Using XML to Load Catalog Data
• Using XML to Load Catalog Schema
• Search Engine
• PO History Feeds
• 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/Order Management
• Hands on extensive experience on the core Oracle SOA Suite components – BPEL, ESB(OSB), OWSM, BAM, ODI etc
• 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.
• Collaborate with Enterprise Architecture teams on recommendations and changes in service/integration best practices, processes and frameworks.
• Orchestrate alternative technology solutions for business requirements.
• Recognize and promptly advise management of potential problems and or potential follow-on business opportunities.
• Keep current with new products / technologies, that Oracle and Non-Oracle software provides for continuous improvement in client Applications Architecture
• Operates with appreciable latitude for un-reviewed actions and decisions in determining the technical direction of projects

Specific to AR/GL

• 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.
• Educated users for using Oracle AR and Advanced Collections for implementation. Participated and played a key role in understanding business needs and integrating them with Oracle.

Confidential.,Boston, MA February 2000 – 2003

Sr. Oracle Developer -Supervisor

Managing a team of 7 developers for custom application development and support

• 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
• Requisitions setup
• Using XML to Load Catalog Data
• Using XML to Load Catalog Schema
• Search Engine
• PO History Feeds
• 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
• Used JSP, Javascript, Java Servlets and HTML to create an interface for users to see Distribution details such as booked orders and shipped orders.
• 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 November 1999-February 2000
Sr. Oracle Developer -Supervisor
Managing a team of 10 developers

Trade Funds Management System

• 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
• Used dynamic sql and passing where clause for getting information using java frontend
• Designed the data model in MS SQL Server 7.0 and Oracle 8i
• Development using Java on the Server for web based applications using Oracle 8i and Oracle Applications Financials Version 10.7 and 11.0 and also Oracle HR.
• Development of Java objects at the client for VB 6.0 that accessed Oracle Financials and HR for web development.
• Planned Server Side programs.

Confidential, Minneapolis, MN March 1999-November 1999
Sr. Oracle Developer

Official Checks Application/Money gram

• 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.
• Performed system requirement study and user requirement study
• Took a final view on all the user requirements
• Planned database changes to be made and Server side programs to be developed
• Used SQL Reports for formatting
• Wrote user test scripts for package testing
• Used International Project Management Tools for managing the process to handle the release of Money Gram stock. This was done to issue customers electronically to the vendor with minimal manual large volume data updates. Maintained data integrity of serial number ranges assigned to customers. The project automates the process of tracking and reporting the start of the ordering and provisioning stage until the final completion of the order. The project is web-based and uses Java, JavaScript, HTML, Visual Modeler, VB 6.0 and JDBC. The backend database is Oracle. The tool is designed to be completely compatible with Netscape version 4 and above.

Environment: Database: Oracle 7.3, Oracle Manufacturing

Confidential., Lakeland, FL February 1998-February 1999
ERP/Developer Consultant

Prison Call Record System:

• In charge of development of reports/cleanup of the existing reports using Reports 3.0. Writing stored programs, libraries, and development of forms.
• Designed and implemented both the graphical user interface (GUI) and the server of a multi-tier Java-based client management system.
• Designed and implemented Cross Product Management system

Environment: Developer 2000 (Forms 5.0, Reports 3.0), PL/SQL, Oracle 8.0, Sun Solaris Server, Unix, Windows NT

Hotel Management System:

• In charge of development of reports/cleanup of the existing Reports using Reports 3.0. Writing stored programs and libraries.
• Developed 10 reports of matrix cross tab type and the others are of group above type using Reports 3.0 (Developer 2000). Developed master forms using Forms 5.0. Also was a team player in developing the data model of the project. One such form used the navigator system of the menu, which is a feature of Forms. On the left hand side the navigator was presented and on the right hand side the respective window was displayed which can be edited and also queried. Total number of Forms developed were 15. Wrote 15 critical packages using stored procedures, functions. Also developed triggers which where used for updating ledger data. Data from FoxPro which are stored in DBF files where transferred into Oracle using Pro*C were I wrote major scripts for loading important master file data. Used Visual Basic (5.0) having Access as backend developed 3 to 7 forms for a small financial project.

Environment: Developer 2000 (Forms 5.0, Reports 3.0), PL/SQL, Oracle 8.0, Sun Solaris, UNIX

California Students Aid System:
Converted programs from Natural to PL/SQL.

• Developed 14 complicated Reports and Forms using Reports 3.0 and 5.0. Wrote pseudo-code for batch programs to be written by junior team members
• Assisted DBA in the development of the data model
• Integration testing of Forms and other PL/SQL packages
• Used Forms 5.0 for developing 10 complicated Forms of query and master type. The query forms where based on views which were in-line. Some forms had direct querying from database tables. Worked on Forms (Forms 4.5, Reports 2.5) which required customization of Oracle Financials Forms and used SQL*PLUS for generating Reports. Mainly forms for querying AR, GL, AP modules of Financials. Used Pro*C for transferring data from mainframe files where the concept of array handled data in Mainframe Cobol has to be handled in Oracle.
• Used Visual Basic (5.0) having Access as backend, developed 10 forms for a students project.

Environment: Developer 2000, PL/SQL, Oracle 7.x, 8.x, Windows NT/95

Confidential April 1997-February 1998
Assistant Manager IT

Financial-Accounting / Integrated Inventory Control:

• The company is in business of manufacturing and marketing UPS systems and stabilizers. It has two operations in India & Australia. It also undertakes to provide support services maintain the UPS systems of its own and third party. The marketing and service operations are divided into four zones having two depots in each zone. The company treats each of its products as profit centers.
• General Ledger, Setting of Books, value sets, Flex field structures, segmental values, cross validation rules, accounting, calendar, currencies.
• Define chart of accounts, suspense accounts, summary accounts. Journals (Reverse, recurring, mass allocation) closing of periods and review of balances. Budget control and define budgets. Encumbrances accounting & using financial statement generator.
• Team member in setting of books in oracle payables. Setting of distribution sets in payables. Invoice entry-Payment details, tax distribution lines; match to PO, release holds. Sets up of books, quick codes and document sequences. Customer’s overview, process transactions-Under invoicing, credits invoices, credits, refunds etc. Lockbox interface, update balances, remit, & reconcile receipts and integration with GL. In fixed assets- Define set of books, setup asset key flex field. In AOL-Value set definitions (Table, register table, form registration, AOL Features-calling key flex fields, desc. Flex fields, quick pick, quick code, programs & repast ID) Steps to follow in GUI application development for attaching new forms / reports.

Oracle Financials, version 10.x SC., Developer 2000 (Forms 4.5, reports 3.0), Oracle 7.2, SCO-Open server UNIX, Windows 95

Banking Operations and Management System:

• The project included all phases of software development life cycle. The system manages complete banking operation like withdrawals, deposits, fixed deposits, transfers, loans, and advances. The integration is designed by creating a distributed database to transfer information between the branches.
• Business interviewing and requirements capturing. Prepared software development specification documents. Preparation of system design standards and guidelines including entity relationships, data flow diagrams, function hierarchy diagrams. Installation of Windows NT 4.0, Designer 2000. Coding of system using Oracle Designer 2000 and Developer 2000. Database administration including database sizing.

Designer 2000, Developer 2000, Oracle 7.2, HP 9000/Windows NT 4.0, Windows 95

Accounts Payable System:

• This system captures all aspects of accounts payable system like vouching invoices, payments outstanding invoices, management of various reports, provisions, liability estimation and check printing. The system followed a duplication of data entry into both the systems. This system serves as a link between the existing finance system in Ingres and the materials management system in Oracle using power builder as a front-end tool. The updating of ledgers is done through Power builder in the Ingres Database. SQL Loader was used extensively. The other tables are updated through Power builder and Developer 2000. Performed requirement analysis at client site, interviewing end users. Coding of system using Oracle Designer 2000 and Developer 2000. Coding using Power Builder 5.0 for updating in Ingres database. Using SQL loader for transfer of data. Testing and debugging. Implementation support.

Designer 2000, Developer 2000 (Forms 4.5, Reports 2.5), Power builder 5.0, SQL-PLUS 3.1, Oracle 7.3, DG 5500/SVR IV Windows 95

Responsibility Accounting

• The management of the company had a policy of making the sectional head responsible for costs. The responsibility drills down to the general managers and the department heads. The expenses are captured from the finance system in Ingres. This included transfer of data on a batch basis to Oracle using SQL loader and database triggers for updating in the budget tables in Oracle. The use of Report writer 2.5 was used extensively for all MIS reports. A responsibility code along with various general manager codes and further break down to the department manager code was implemented. The entity is a total master detail relationship up to 3-degree normalization. Performed requirement analysis at client site, interviewing end users. System Design/Documentation. Coding of system using designer 2000 and developer 2000. Loading data from Ingress to Oracle Testing and debugging Done a system analysis and design documentation.

Designer 2000, Developer 2000, (Forms 4.5, Reports 2.5), Oracle 7.x, DG-5500/SVR IV, Windows 95

EDUCATION Bachelors Degree, Commerce
Diploma Computer Applications and Software Development

TRAINING Oracle Financials V 10.7 SC
Modules: General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets & AOL