Summary

Oracle Apps Techno-functional Consultant with 11 years extensive experience in design, analysis, user requirement study. Development of Reports and Interfaces, implementation, setup, testing, customization, support and migration in Oracle Apps Financials, Distribution and Application Object Library modules 11i, 11.0.x . Expert in technologies like SQL, PL/SQL, SQL Loader, Forms 6i, Reports 6i, Oracle Discoverer, BI Publisher, packages, triggers, Oracle 8i/9i/10g. Good Functional knowledge of setting, configuring and use of Oracle Financials, Distribution with Apps System Administration skills.

ERP Expertise:

• Implementation and technical expertise in AR, FA, GL, AP, Inventory, Purchasing, Order Management, Enterprise Asset Management, HRMS, Oracle Projects, BOM, Installed Base, Service Contracts and Oracle Time Labor modules.
• Specialized in Oracle Applications Financials/Distribution/Manufacturing skills with sound knowledge of their integration.
• Expertise in Customization and Conversion of various modules RICE components .
• Well conversant with aspects of Application Object Library AOL of Oracle Applications.
• Good knowledge of Order to Cash and Procure to Pay cycles.
• Strong with reporting tools like Oracle Discoverer, Reports 6i/10g, XML Publisher.
• Designed, Developed and Customized Open Interfaces, Forms and Reports in Oracle Apps
• Strong technical skills with good programming experience in SQL, PL/SQL, Developer 6i/2000 Forms 6i, Reports 6i , SQL Loader, UNIX Shell Scripting.
• Post production support, Bug fixing and Enhancements.
• Good experience in Unit Testing and System Integration Testing.
• Performance Tuning and Optimization of SQL Queries.
• Have Strong Conceptual, Business, Analytical skills highly motivated team player.
• Proficient in Gathering Specs, Application design, development, and customizations, coding
• Excellent verbal, written, communication and presentation skills.
• Oracle Applications: Oracle Applications R12/11i/11.0.x, General Ledger, Accounts Receivables, Account Payables, Fixed Assets, Inventory, Purchasing, Human Resources, Order Management, Project Accounting, Time Labor, Bill of Materials, Installed Base, Service Contracts and System Administration.
• Programming Languages: PL/SQL, SQL Plus, C, Java and Unix Shell scripting
• Software Used: Oracle 11g/10g/9i/8i/8.x, Oracle Forms 10g/6i/Reports 10g/6i, Oracle BI, Discoverer, SQL Plus, TOAD, SQL Developer, XML Publisher, SSRS, JDeveloper, VSS.
• System Development: Business Process Analysis, Testing, Documentation and Implementation.
• Operating Systems: Windows 95/98/NT/2000, Sun Solaris, MS-DOS and UNIX

Confidential

Professional Experience:

Work Experience:

Confidential is the brand name for products underwritten and issued by the subsidiaries of Confidential . The Chesapeake Life Insurance Company , Mid-West National Life Insurance Company of Tennesseesm and The MEGA Life and Health Insurance Companysm. Products under the HealthMarkets brand are designed to provide personalized protection to individuals, families, the self-employed and small businesses.

Responsibilities:

• Gathered requirements and designed the functional specification documents for the implementation of interface between ADP and Oracle HRMS
• Created mapping table for job-position relationship between ADP and Oracle HRMS
• Implemented position hierarchy and setup approval limits for purchasing approval
• Implemented AP Approval hierarchies using the Special Information Types SIT flexfield.
• Created custom PL/SQL package to get first level approver for AP hierarchy
• Setup business rules in AME module for AP hierarchy
• Created custom package for Cash Management process
• Created/modified packages to combine payments from two different bank accounts
• Defined Bank Transaction codes for auto reconciliation of external transactions in cash management
• Involved in employee supervisor and position cleanup
• Created and maintained users using SSO
• Implemented setups for General Ledger approval
• Created mapping tables for promotion planning to be used with synectics and created custom forms for maintenance.
• Created Business Areas for the reports and granted security privileges to the users.
• Developed discoverer reports for Active Users and Employees, Invoice Details and Position Hierarchies as per the client's requirement
• Created workbooks based on the Business Areas.
• Created discoverer reports for audit purposes
• Created XML publisher reports Single Multiple for Printed Purchase Order to meet client's requirement
• Created Organizations, Jobs and positions in HRMS
• Written custom programs to terminate, hire and re-hire employees
• Defined concurrent programs and attached to request set.
• Creating and maintaining Users, Responsibilities, etc.
• Re-assigned workflow transactions using workflow administrator
• Involved in critical patch updates and rollup patches
• Involved in Performance tuning and post production support
• Preparing MD 070 technical design documents based on the MD 050 documents.

Environment: Sun Solaris, Oracle System Administrator, Oracle Applications Object Library, Oracle Applications 11.5.10 Oracle HRMS, Oracle Purchasing, General Ledger, Oracle Payables, Oracle Learning Management, Sysadmin, Application Developer, AME , Oracle 11g, Oracle Forms 6i/Reports 6i, Oracle Discoverer 10g, Shell Script, Windows2000

The Gavina family has been in coffee business for over 130 years as growers, importers and roasters of gourmet coffee. The company is one of the successful and largest in coffee business in the western United States. Role involved as Senior ERP Developer includes development and customization of reports, customization of Forms and data conversions. Involved in R12 upgrade. Also involved in support and enhancement of applications.

Responsibilities:

• Gathered requirements and designed the functional specification documents for the implementation of trade promotion analysis and planning system.
• Developed an Interface between the Apps system and Synectics Account Review 3rd party system for trade promotion analysis, planning and settlements .
• Implemented DFF's to store the promotional plan data whenever a Sales order is created to be used for re-conciliation with the receivables system by Forms personalization
• Developed Interface files for feeding into the synectics system and receiving the promotion files for feed into the Oracle system.
• Involved in 11i R12 upgrade. Created FNDLOAD scripts to backup and restore the customizations done to the system
• Developed a package on AR Auto Invoice Interface, imported invoices from legacy system to Oracle Receivables tables using the Auto Invoice Import program.
• Create PL/SQL packages for importing Items and On-Hand quantities into Oracle Inventory using the Import Items program.
• Developed a daily report to show the orders created for the day with the promotion plan details in Oracle Discoverer.
• Created mapping tables for promotion planning to be used with synectics and created custom forms for maintenance.
• Created Business Areas for the reports and granted security privileges to the users.
• Developed PL/SQL packages to import booked Sales Orders from the legacy system into Oracle in the Order Management module.
• Created workbooks based on the Business Areas.
• Defined concurrent programs and attached to request set.
• Creating and maintaining Users, Responsibilities, etc.
• Synchronize Active Directory with Person data using the Oracle dbms ldap package by modifying the attributes of Active Directory for use by downstream applications
• Involved in Performance tuning and post production support
• Preparing MD 070 technical design documents based on the MD 050 documents.

Environment: Sun Solaris, Oracle System Administrator, Oracle Applications Object Library, Oracle Applications R12/11.5.10 Oracle Inventory, Oracle Receivables, General Ledger, Order Management, Oracle Payables, Oracle Financials , Oracle 11g, Oracle Forms 6i/Reports 6i, Oracle Discoverer 10g, Shell Script, Windows2000

Optinuity Alliance Resources provides portfolio and operational support services to MBIA Inc. and its subsidiaries and affiliates. These services include portfolio management and remediation, claims management, financial reporting, tax preparation and auditing services, information technology, corporate administration and analytical and consultative services in remediation, financial reporting, legal, marketing, and strategy.

Responsibilities:

• Gathered requirements and designed the functional specification documents for the implementation of trade promotion analysis and planning system.
• Developed a package on AR Auto Invoice Interface, imported invoices from legacy system to Oracle Receivables tables using the Auto Invoice Import program.
• Create PL/SQL packages for importing Items and On-Hand quantities into Oracle Inventory using the Import Items program.
• Create PL/SQL packages for General Ledger Historical import
• Imported AP invoices from Legacy system to Oracle Apps
• Written cash management interface for bank transactions
• Created Business Areas for the reports and granted security privileges to the users.
• Developed PL/SQL packages to import booked Sales Orders from the legacy system into Oracle in the Order Management module.
• Created workbooks based on the Business Areas.
• Defined concurrent programs and attached to request set.
• Creating and maintaining Users, Responsibilities, etc.
• Synchronize Active Directory with Person data using the Oracle dbms ldappackage by modifying the attributes of Active Directory for use by downstream applications
• Involved in Performance tuning and post production support
• Preparing MD 070 technical design documents based on the MD 050 documents.

Environment: Sun Solaris, Oracle System Administrator, Oracle Applications Object Library, Oracle Applications R12/11.5.10 Oracle Inventory, Oracle Receivables, General Ledger, Order Management, Oracle Payables, Oracle Financials , Oracle 11g, Oracle Forms 6i/Reports 6i, Oracle Discoverer 10g, Shell Script, Windows2000

Ulticom is a global leader in service-enabling software providing solutions to Tier-1 network equipment providers and service providers. Found as a provider of contract programming and services, Ulticom amassed talent and experience in telecommunications signaling, networking and applications. Role involved as Senior ERP Developer includes development and customization of reports, customization of Forms and data conversions. Also involved in support and enhancement of applications.

Responsibilities:

• Developed a package on AR Auto Invoice Interface, imported invoices from legacy system to Oracle Receivables tables using the Auto Invoice Import program.
• Create PL/SQL packages for importing Items and On-Hand quantities into Oracle Inventory using the Import Items program.
• Created database tables, sequences and synonyms to capture the SR details when the customer takes on the satisfaction survey when the SR is closed.
• Developed the Customer Satisfaction Survey Report which gives the SR Details along with the Questions and Answers using Discoverer 10g.
• Developed Custom Reports in the OTL module to get the timecard summary and details of all employees in the organization using Discoverer 10g. This report is developed based on the supervisor hierarchy which enables the managers to get the timecard details for the list of employees under them.
• Created a custom form to keep track of the RMA Return Material Authorization transactions and two custom tables on which the form is based.
• Created the RMA Performance Response Rating, RMA Summary Details Report and the Traveller Details Report .
• Generated a commercial Invoice Report using XML Publisher. The RTF templates used to generate PDF and HTML outputs is developed using Template Builder for Word.
• Developed a custom report in the HR module to get the education details of all the active employees in the organization at a given point of time.
• Developed custom reports in the HR module to get the salary details, performance review details of all employees in the organization during a given point of time.
• Developed the VSOE Licensing Report which gives the maintenance and the contract details for all the licenses. This report fetches the data from the Inventory, Service Contracts, Installed Base and Receivables modules.
• Developed Paid Time-Off Reports which includes the Vacation, Sick Leave and Floating Holiday Details of employees in the organization based on the supervisor hierarchy which is attached to the responsibilities of all the employees. For managers, it will give their leave details along with the details of their subordinates.
• Created Business Areas for the reports and granted security privileges to the users.
• Created workbooks based on the Business Areas.
• Defined concurrent programs and attached to request set.
• Creating and maintaining Users, Responsibilities, etc.
• Preparing MD 070 technical design documents based on the MD 050 documents.
• Environment: Sun Solaris, Oracle System Administrator, Oracle Applications Object Library, Oracle Applications 11.5.10 Oracle Inventory, Oracle Receivables, General Ledger, Oracle Install Base, Service Contracts, Oracle Payables, Projects, Oracle Financials , Oracle 10g, Oracle Reports 6i, Oracle Discoverer 10g, Shell Script, Windows2000

Confidential is Atlanta's modern transit system. It is the primary bus and train facility operating in Metro Atlanta. It operates across 5 counties in Atlanta for more than a quarter century and 3.5 billion rides. Role as an Oracle Apps Tech Consultant Data Conversion from Legacy System to Oracle Applications, Interfaces, extensions to current application, reports development across modules and post-production support.

Responsibilities:

• Developed a package to load the Assets from the Legacy System into Oracle Applications using the Mass Additions program.
• Developed a package on AR Auto Invoice Interface, imported invoices from legacy system to Oracle Receivables tables using the Auto Invoice Import program.
• Developed PL/SQL packages to bring in General Ledger Balances into Oracle from the legacy system with 5 years of history as summary and the current fiscal year transactions in detail using Import Journals program.
• Create PL/SQL packages for importing Items and On-Hand quantities into Oracle Inventory using the Import Items program. Also updated the Average Cost of Items.
• Developed PL/SQL package to import Customers from legacy using Customer Import program and used API's to update the e-mail address and the salesperson.
• Created PL/SQL packages to import open purchase orders into Oracle Applications Purchasing module using the Purchase Order Import program.
• Developed PL/SQL packages to import booked Sales Orders from the legacy system into Oracle in the Order Management module.
• Written packages to import Project Balances based on awards and split percentage using the PRC Transaction Import program into Oracle Grants Accounting module.
• Written an Interface program in Inventory module to automate the Item process including Master Items, Organization Assignment, Item Catalogs, Manufacturer Part Numbers, Item Cross-references and Sub-inventory Assignment.
• Created SQL Loader scripts and temporary tables for the Data Conversion process.
• Developed Missing Assets Report in Fixed Assets FM module to identify missing assets based on physical inventory including a PL/SQL program that identifies and prints the report.
• Developed a report which updates the physical inventory name and generates a report of the updated assets using Reports 6i as per the client's requirement.
• Developed Auto Write-off Uninventoried Assets to identify Assets missing for more than two years and retire them automatically.
• Created the GL Translation Form to help the users identify the mapping of legacy values to Oracle values for Chart of Accounts in the General Ledger module.
• Developed Inventory Adjustments Report, Inventory Turn-over Report, Months of Inventory On-hand Report in the Inventory module using Reports 6i and Discoverer.
• Created SQL Loader control files and temporary tables in Oracle to bring in data from flat files to oracle for validations during Data Conversion.
• Created unit test cases and performed unit testing provided post-production support to client.
• Defined Concurrent Programs and attached to request set.
• Prepared Technical Design Documents MD070 based on Functional Design Documents MD050
• Environment: Sun Solaris, Oracle System Administrator, Oracle Applications Object Library, Oracle Applications 11.5.10 Inventory, Receivables, General Ledger, Oracle Grants Accounting, Purchasing, Payables, Fixed Assets , Oracle 9i, Oracle Reports 6i, Oracle Discoverer 4i, Shell Script, Windows2000

This project involves developing an AIS Asset and Inventory System for Singapore Police Force. This is a customized application, the Inventory System consists of modules like eKit, TOE, Loan, Condemnation, Inter Unit Transactions and Sub Inventory Transfer. Each officer is given an eKit Card based on their vocation and service status to monitor the transactions for clothing, info-communication and operation equipments issued from the different stores. My involvement was with the Data Loading interface of the Inventory, BOM and the Enterprise Asset Management modules.

Responsibilities:

• Create PL/SQL packages for importing Items and On-Hand quantities into Oracle Inventory using the Import Items program. Written a package to update Average Cost of Items.
• Written validation programs in PL/SQL to import Asset Groups, Rebuildable Items, Asset Activities and Rebuildable Serial Numbers into the Enterprise Asset Management EAM module using the Import Items program.
• Used Oracle API's to upload Meters, Associate Meters, Associate Activity and upload preventive Maintenance with runtime rules into the Enterprise Asset Management module.
• Created PL/SQL packages to import open purchase orders into Oracle Applications Purchasing module using the Purchase Order Import program.
• Developed PL/SQL programs to import Bills and Routings into the Bill of Materials BOM module using the Import Bills and Routings standard Interface program.
• Developed the e-kit transaction report using Reports 6i as per the client's requirement.
• Customized the Aging Trial Balance Report in the Payables modules as per the client's requirement.
• Created custom form for the e-kit transactions to keep track of equipments given to the officers on duty.
• Created SQL Loader programs and temporary tables for Data Conversions.
• Created test cases and performed unit testing of the modules.
• Provided post-production support to the client.
• Created Responsibilities and attached it to users.
• Effective knowledge transfer to the entire team.
• Prepared Technical Design Documents MD070 based on Functional Design Documents MD050 .
• Environment: Sun Solaris, Oracle System Administrator, Oracle Applications Object Library, Oracle Applications 11.5.10 Oracle Inventory, Enterprise Asset Management, General Ledger, BOM, Financials , Oracle 9i, Oracle Reports 6i, Shell Script, Windows2000.

Hutchinson is a leading cell phone service provider in Thailand. The Hutchinson Instance Merger project involves merging of two Instances for Hutchinson Thailand . This includes migration of data for the AP, PO, FA and GL modules and developing and customizing reports in the Inventory, OM and AR modules. My involvement was with AP, PO, FA and GL modules.

Responsibilities:

• Written extraction scripts for extracting data from the Payables, General Ledger, Purchasing and Fixed Assets modules from the Hong Kong HK instance which is used for loading into the Thailand TH instance.
• Created PL/SQL packages to load the open Invoices from the HK instance into the TH instance into the Payables module.
• Created PL/SQL packages to import open purchase orders into Oracle Applications Purchasing module using the Purchase Order Import program.
• Developed PL/SQL packages to bring in General Ledger Balances into Oracle from the legacy system with 5 years of history as summary and the current fiscal year transactions in detail using Import Journals program.
• Developed PL/SQL packages and scripts to bring in suppliers from the legacy system into Oracle Applications Payables module.
• Created PL/SQL packages to import open purchase orders into Oracle Applications Purchasing module using the Purchase Order Import program.
• Written a Custom program in Order Management module to create and close a sales order in a different company, which includes various stages in the Sales order like Pick Release and Ship Confirm.
• Customized the GL 180 char report to suit the client's requirement using Reports 6i.
• Created SQL Loader programs and temporary tables for Data Conversions.
• Created test cases and performed unit testing of the modules.
• Provided post-production support to the client.
• Created Responsibilities and attached it to users.
• Effective knowledge transfer to the entire team.
• Prepared Technical Design Documents MD070 based on Functional Design Documents MD050 .

Environment: Sun Solaris, Oracle System Administrator, Oracle Applications Object Library, Oracle Applications 11.5.7 Oracle Purchasing, Payables, Fixed Assets, General Ledger , Oracle 8i, Oracle Reports 6i, Shell Script and Windows2000

The Project involves writing Interface Programs using SQL Loader for importing Invoice information into Oracle Payables Module and customization of Oracle Payables and General Ledger modules using Reports 6i. The application has been customized to meet the need of the customer.

Responsibilities:

• Imported Journal Information into GL module using SQL loader.
• Involved in developing Future Payment Status Report as per the client's requirements using Oracle Reports 6i.
• Developed the GL Dual Currency Report as per the client's requirement.
• Imported Invoice Information into Payables module using SQL loader.
• Imported Purchase Orders and Suppliers into the Purchasing module.
• Customized the Purchase Order form to enable charge account in the purchasing module as per client's requirements.
• Developed Supplier and Site-wise report in AP using Oracle Reports 6i.
• Defined concurrent programs and attached to request set.
• Creating and maintaining Users, Responsibilities, etc.
• Creating and assigning document sequences.
• Preparing MD 070 documents based on the MD 050 documents.

Environment: Sun Solaris, Oracle Applications11.5.9, Oracle Payables, Purchasing, General Ledger, Oracle 9i, Forms 6i, Reports 6i, Shell Script and Windows2000

This project involves the implementation and support of Oracle Financials. The application has been customized to meet the needs of the customer.

Responsibilities:

• Creation of interface tables, SQL Loader control file to transfer data from flat files to Vendor interface tables.
• Developed PL/SQL programs to validate and transfer data from vendor interface tables to application tables.
• Imported invoices from legacy system into Oracle payables through Payables Open Interface.
• Developed PL/SQL script for loading Purchase Order Information into Oracle Purchasing using Purchasing Documents Open Interface.
• Developed the Invoice Aging Report without the Aging Buckets in the Payables module.
• Developed the Check Payment Voucher report as per the client's requirement.

Environment: Oracle Applications11i Purchasing, Payables, General Ledger, Fixed Assets, Forms6i, Reports6i, and UNIX.

The project involves Customization of Oracle Application by developing Oracle Forms, Reports, and PL/SQL for a telecommunication company. The application has been customized to meet the needs of the customer.

Responsibilities Included:

• Created the temporary tables for transferring data from flat files.
• Created SQL Loader scripts to import customers from legacy system to Accounts Receivables.
• Created reports as per client's requirement.
• Created SQL Loader scripts to import journals into Oracle General Ledger.
• Customized reports as per client's requirement.
• Imported external invoices into Oracle Receivables through Auto Invoice Program using SQL Loader.

Environment: Sun Solaris, Oracle Applications11i, Account Receivables, Payables, Oracle 8i, Forms 6i, Reports 6i, Shell Script, Windows2000.

The Human Resource Information System is an intranet based Management Information System that is a framework of various applications of the client's organization. This system provides an online system to obtain complete insight into the employee information by the HR and Senior Management executives. The Performance Management consists of sub-modules: Goal Setting, Appraisals, Development Plan, Rating, Assessment and Backup Identification. My involvement was with Appraisals and Development Plan.

Responsibilities:

• Involved with maintenance and new enhancement to this module.
• Validate the appraisal proposal and development plan using Forms screens.
• Validate the review rating in consensus with Goal Setting.
• Developed user interface screens using Forms 6i to capture appraisal reviews.
• Implemented database packages and procedures for Appraisals reviews using PL/SQL.
• Involved in developing unit test cases and perform unit testing of my modules.

Environment: H/w: Pentium O/s: SOLARIS 8, Windows NT S/w: Oracle 8i,Forms6i/Reports 6i, SQL Plus, PL/SQL, Shell Script and Pro C.