Ashok Kumar 630-***-****

Objective

Challenging position in oracle applications, combining my extensive knowledge and experience in oracle applications.

Summary

• Around 10 years experience in setup and customization of ORACLE ERP Applications modules including General ledger, Purchasing, Receivables, Payables, Order Management, Oracle Inventory, BOM, CRM, OPM, Fixed Assets, Application Developer and Sysadmin.

• Database Admin tasks like Cloning, Refreshing, RMAN Backup and Duplicate database.

• Sysadmin tasks like Maintaining User security, Application security and Custom applications.

• Application Developer tasks like defining value sets, values, Functions and Menus.

• A thorough understanding of Oracle Applications Functionality, Architecture, Design, coding standards, RDBMS Principles.

• Experienced in code review, SQL tuning using EXPLAIN PLAN, TKPROF, and UTLXPLS.

• Rich Consulting experience with Fortune Clients Lucent, Cisco, NCR

• Design custom interfacing procedures in consideration to Oracle standards and functionality.

• With strong background in RDBMS principles and PL/SQL programming, able to derive solutions that are highly effective in implementing business rules.

• Vast Experience working with Forms 4.5, reports 2.5, Developer 6i, 9i, 10G and Discoverer 4i, 9i, 10G.

• Good analytical problem-solving skills, excellent verbal and written skills.

• Technical programming skills in SQL, PL/SQL, Developer and Discoverer Reports.

• Functional experience in implementing GL, AR and PO modules.

• Customization of existing reports and creation of new reports in Oracle Applications.

• Registration of reports and concurrent programs and setting up of printers in System Administration.

• Migration of data from legacy systems into Oracle Applications tables.

• Interaction with the end users to consider their requirements into the program specifications.

• Development of detailed techno-functional design, build and install/implementation documents

• Identified and corrected Post implementation problems and tasks in Oracle Applications through frequent meetings with the end-users and relevant Managers.

• Unit testing, integration testing and system testing to see that dependencies are met among different programs.

• Willingness to work non-prime shift hours, including weekends and holidays to accommodate project deadlines

• Team-oriented with a proactive and optimistic problem solving style.

• Developed the documentation using 11i tutor, AIM and 11i help builder

• Proven experience with change management products which include perforce and mercury interactive change management products.

Skill Set

RDBMS 7.3, 8.0.4, 8.0.5,8.1.6,8.1.7.4,9.2.0.7, 10g, 11g

Operating System Sun 2.6,2.8 HP 10.20,11.11,LINUX, Windows

Change Control PVCS GUI Version and RCS Character mode & Internal Controls Management, Perforce

Business Intelligence Tools 11i EDW, 11i BIS, Discoverer 4x, 9i and 10G, DBI

Performance Tools Quest SQL Lab Expert, TKPROF, EXPLAIN PLAN, UTLXPLS

Documentation Tools AIM & Oracle Tutor

Oracle Data Conversion Tools SQL Loader, External Tables, Taviz, Data Pump

Development Tools Developer2000 and Developer 6i, 9i, XML Publisher, CUSTOM.pll, AK Developer , DBA Studio SQL Navigator, Toad, SQL Plus

Oracle Applications Oracle Applications 10.7sc, 11.0.3 NCA, 11.5.4, 11.5.8, 11.5.10, 12.0.4

EDUCATION

• Master of Business Administration, Andhra University, India.

• Bachelor of Commerce from Andhra University, India

• PG Diploma in Computer Applications.

PROFESSIONAL EXPERIENCE

Company: Harper College, Chicago IL

Title: Oracle Apps Developer

Period: Aug’ 09 – Till Date

• Involved in the upgrade of Discoverer 4i to 10G. As part of the Upgrade, modified the EUL in 4i to have a clean EUL in 10G.

• Tested the reports in 10G after the upgrade.

• Worked on Discoverer Admin to create new views and import into EUL.

• Worked on Discoverer Desktop to create various folders and worksheets.

• Trained end users on Discoverer 10G.

• Responsible for maintenance of Sysadmin and Application Developer modules.

• Developed GL Journal Import interface to import accounting transactions from Banner Student system to Oracle GL.

• Developed a program to transfer Student refunds from Banner to Oracle Payables and generate invoices using Accounts Payables.

• Managed day to day concurrent manager issues.

• Created and assigned new concurrent managers to various batch jobs.

• Modified Profile values for self service Personalization.

• Set up new printers in Oracle Applications and resolved day to day print issues.

• Developed various Word templates for Oracle reports to output using XML Publisher.

• Developed Employee Mailing Label report using Reports Developer.

Company: Fort Dearborn Company, Chicago IL

Title: Oracle Apps Developer

Period: May’ 07 – Jul’ 09

• Responsible for system administration activities such as Maintain user security.

• Defined concurrent executables/ programs, creating functions/menus and responsibilities.

• Cloning Oracle Database and Applications

• Support approximately 50 users on Oracle Financials 12.0.4.

• Apply application patches

• Create tablespaces, tables, and users for custom applications.

• Maintained Oracle Applications custom schema.

• Create and maintain custom responsibilities and menus.

• Move all custom programs and reports to production. This involves enforcing naming standards, maintaining the custom application top, and setting up concurrent requests.

• Defined custom Request groups to add to custom responsibilities.

• Defined new Concurrent managers and managed concurrent manager administration.

• Modified various System Profile options in order to modify the Application functionality.

• Install and upgrade various tools like GL company on the users systems and resolved their issues.

• Developed Financial Reports using GL Company.

• Defined custom GL module in Oracle Ebusiness suite.

• Setup printers for the EBS 12i defining new Printers and Drivers.

• Implemented Oracle Applications GL Module. As a techno functional

lead of the implementation, gathered requirements from the

end users. Prepared the Functional Specs and Technical Specs.

• Responsible for General Ledger functional setups like defining Accounting Flexfields, Cross validation rules, Security rules etc.

• Developed the Journal import program to convert the Legacy Globetek data

into Oracle GL module.

• Supported the Oracle Financials Post production system.

• Developed several reports like Profit and Loss and Balance sheet to support the

financial Users of the company including the CFO. These reports output from

Globetek which is an ERP software developed for printing Industry. The Globetek

system is running on Oracle database.

• All the complex features of the Oracle reports Layout have been used to develop these Financial reports.

• Matrix reports have been developed using the print direction feature of the Oracle reports Down and Across

• Supported the Accounting users by maintaining the Financial reports.

• Modified the various reports to meet end users day to day Business requirements.

• Developed several views to support the Oracle Discoverer reporting.

• Developed several work books in Discoverer to meet the business requirements of operational users.

• The company acquired new companies in US and CANADA. Actively involved in integrating the Legacy Systems like JD EDWARDS, UNIDATA with Globetek.

• The acquired plants have foreign currency transactions. Developed P/L Sql programs to calculate FX gain or Loss on FOREX changes. This program will take care of all the Receipts from Customers and Payments to Vendors.

• The Montreal Plant has a mandatory Requirement that Customer facing Documents Show the Text in both English and French. Modified all the Customer facing documents to show text in both languages.

Company: Compucom Corporation, Dallas TX

Title: Oracle Apps Developer

Period: Oct ’06 to Apr’07

Oracle Purchasing

• Customized the Printed Purchase order report to Print output in PDF format using the Oracle XML Publisher. This report includes Blanket Agreement and Blanket Release.

• Customized the RFQ report to print output in PDF format using the Oracle XML Publisher.

Accounts Payable (AP)

• Customized the AP Invoice History report as per client requirements.

• Developed Remittance Advise report as per business requirements.

• Developed AP EDI MANPOWER Stuck Invoices report as per user requirements.

Oracle General Ledger

• Developed reports using SQL Plus to output in Microsoft Excel format.

• Customized the account Analysis report to meet customer requirements.

• The Oracle FSG reports were taking long time to complete. So Created reports as alternative for FSG Reports.

Company: NCH Corporation, Dallas, TX

Title: Oracle Apps Developer

Period: Nov’ 05 to Oct’ 06

NCH Corporation, Dallas, TX Nov’ 05 to Oct‘06

Title: Reports Developer

As part of the 11i Oracle Suite implementation, Worked extensively on XML Publisher Reports and Discoverer.

Developed views and imported into Discoverer Admin. Created complex queries to develop reports in discoverer. Developed various reports using Discoverer desktop.

Developed and Modified several 9i reports using XML publisher to meet the business needs.

Accounts Receivable (AR)

• Imported historical Customer information from the existing AR system into Oracle Receivable Applications for collection needs and better customer management by keeping track of customer, contacts and call details for future references using PL/SQL and SQL*Loader.

Oracle process Manufacturing

• Developed Manufacturing Work Order report. These reports will give the list of all the ingredients to manufacture a Product. Developed the report in XML Publisher. Bar codes in the report, this will enable the user to scan the details from the report.

• Developed Packaging Work order report. These reports will give the list of all the finished goods to be packed to ship to a customer. Developed the report in XML Publisher. Bar codes in the report, which will enable the user to scan the details from the report.

• Developed Production Batch Release report. This will give the details of all products released in a batch.

• Developed Product Specification report, which will give the Spec of the product to be manufactured.

Oracle Inventory

• Modified the existing Physical inventory counts and Physical inventory tags reports as per customer needs.

Oracle CRM

• Developed a report to give details of the active contracts and completed contracts for each salesrep.

• Developed a report that gives details of the estimated and supplied cost of product, equipment and services provided to customer for each contract.

Company: AAR Corporation, Wooddale IL

Title: Oracle Apps Developer

Period: Apr’ 05 to Aug’ 05

Played key role in the upgrade of Oracle Applications 10.7 to 11.5.9.

Order Management

• Converted reports from version 2.5 to 6i and modified the table names in the reports to be compatible with new database tables.

• Customized the Pick slip, Pack Slip, Sales Order Acknowledgement, Purchase Order Print, Shipments reports to meet the user requirements.

• Resolved the post production issues encountered by users after the upgrade of Application from

10.7 to 11.5.9.

Company: Linksys, Irvine, CA

Title: Oracle Apps Developer

Period: Jan’ 04 to May’ 05

Environment:-Oracle Applications 11.5.9(AP, AR, GL, Purchasing, OM, INV), Discoverer 4i, Discoverer 9i, and Reports 6i

Oracle Discoverer

• Implemented Oracle Discoverer. This involved in bringing the important tables in to Discoverer End User Layer from various modules of Oracle Applications and creating joins between them.

• Developed Various Custom Folders using SQL queries.

• Trained users on how to create adhoc reports using the Discoverer Desk top.

• Developed many Work Books in different modules like, Accounts Receivable, Accounts Payable, General Ledger, Order Management, Shipping, Inventory and Purchasing.

• Scheduled Discoverer Work Books to run at Regular Intervals.

• Resolved various problems users encountered day to day as part of the Support function.

Oracle Reports 9i

• Customized the Commercial Invoice Report to print total number of packages and total weight converted from Pounds to Kgs as required by Asia Pacific Operations.

• Customized the Packing Slip report to meet the Singapore requirements.

• Customized the Pick Slip Report to group delivery lines by Item

• Customized the Invoice Print report to meet the Client’s Requirements.

• Created a new report Bill Of material Take off report. This report lists all the components needed to build a Product. The report splits the Product into different components up to 26 levels.

• Created Invoice Import Error Report which would give different statuses of the AP Invoice import lines.

Interfaces

• Worked on an interface to move the Audit Trail records from Pricing, Accounts Receivables, and Item master Maintenance tables to Data Warehouse.

• Worked on shipping interface to Update Oracle with shipped data from AS400.

Used Taviz template to load data into staging table. Developed a PL/SQL program to update Oracle with the latest shipping information.

• Created an Event alert In Oracle Payables which would send email to the PO Requesters of any holds on Invoices.

Company: Delphi Mechatronic Systems, Downers Grove, IL

Title: Oracle Apps Developer

Period: Nov’ 02 to Dec’ 03

Worked on the Post Production Support for Oracle Application 11.5.7 system. Main Job was to resolve day-to-day problems, which users and the system encountered.

Account Receivable (AR)

• Resolved Issues with Day to Day Auto Invoice program.

• Customized the AR aging - 7 Buckets - By Account Report to meet Client requirements.

• Added additional fields to the Custom Invoice Print program (Invoice report).

• Developed new reports like Customer Payment Terms details, Customer Master File and Open Invoice Shipment Detail Report.

• Added the Collectors information and Remit to Information at the bottom of the Customer Open Balance Letter Report for each responsibility.

• Developed reports that show changes made to Customer data by enabling Oracle audit Trail feature.

Account Payable (AP)

• Developed reports that show changes made to Customer data by enabling Oracle audit Trail feature

• Developed AP Third Party Operations Summary and Detail reports.

General Ledger (GL)

• Customized the Journal Batch Summary Report as per requirement.

• Fixed the General Ledger Report to show the subtotals, which did not appear correct.

• Added new parameters to various reports as per user requirements.

Fixed Assets (FA)

• Developed a report for French Responsibility Liste des immos pour aide a la declaration de. This report is run at the end of each year. This report is used for the tax reporting purposes. The report gives the information about all the assets in the system such as asset Number, Description, Original cost and Asset value after depreciation at the end of the year.

Database Administration (DBA)

• Worked on Database admin tasks like cloning the Production instance to other instances like Development, QA and Test.

• Refreshed the TEST Databases from the Production database for testing purpose.

• Applied Patch sets and Patches to the various Oracle environments.

System Administration (SYSADMIN)

• Involved in sys admin tasks like Defining users, assigning responsibilities to Users, Monitoring user accounts, Administering Concurrent manager and Installing Application Printer setups.

• Created a report Active Users and Their Active Responsibilities, which provides data like User Full name, Location and all the responsibilities assigned to user.

Environment : Oracle Applications 11.5.7(AP, AR, GL, FA), PL/SQL and Reports 6i

Company: MSC Software, Los Angeles CA

Title: Oracle Apps Developer

Period: Apr’ 02 to Nov’ 02

Account Receivable (AR)

• Designed and developed a custom interface program Breaking Orders into Multiple Invoices for Auto Invoice. This program is used for German Operations of MSC where in the invoice amounts have to be split into installments to reduce the VAT tax.

• Worked on the following Functional tasks.

Writing data mapping & specification for Customer conversions

Setting up Sales Tax structure for MSC USA

Order Management (OM)

• Modified the existing Order Load Program to add additional functionality.

Added a procedure to handle Settle up charges. Settle upcharge is required when the customer is charged in advance. Added a procedure to handle Logical Vault handling.

• Created Price List Audit Extract, which is a custom program, which creates an output file.

Created a UTL file out of Oracle Price Lists. This file is used to compare if price list data from Clarus is loaded properly into Oracle price list tables.

• Customized Sales Person order summary report to meet client requirements.

Oracle Purchasing (PO)

Developed key Business Reports using Discoverer. Developed Views, Business areas and Folders for Oracle Purchasing module. Developed Work books which were helpful in making key Business decisions.

Environment : Oracle Applications 11i (AR, OM, PO), Discoverer 3.1, PL/SQL and SQL*Plus

Company: NCR Corporation, Dayton OH

Title: Oracle Apps Developer

Period: Apr’ 01 to Mar’ 02

Oracle Purchasing (PO)

Accounts Payable (AP)

• Designed and developed an interface program to transfer data from Oracle Applications to Enterprise Data Warehouse (EDW). Enterprise Data Warehouse (EDW) is targeted to facilitate reporting on ERP Procurement and Payment data. Using EDW will eliminate the need to customize Oracle standard reports or to implement other tools to generate key Business reports.

Interacted with EDW users in analyzing their Business requirements and designed the interface. The Oracle Applications interconnect was used to format data into XML messages based on rules established, and then send the XML messages to External systems.

• Worked on the Open Requisitions interface to integrate Oracle Purchasing with Order Entry and Inventory. Requisitions interface has been used to import open requisitions from Order Entry and Inventory. Open Requisitions interface enabled NCR to import and approve open requisitions to place them on Purchase orders.

Account Receivable (AR)

• Added one more bucket to the Aged Trail balance report - 4 Buckets.

• Customized Invoice Print preview report and Transactions Detail reports to meet NCR business requirements.

• Developed Customer Interface to import Customer Information from Legacy system into Oracle Receivables Using SQL*Loader and PL/SQL

Environment : Oracle Applications 11i (AP, AR, PO), Reports 6i, PL/SQL and SQL*Plus

Company: Lucent Technologies, Greensboro, NC

Title: Oracle Apps Developer

Period: May’ 2000 to Mar’ 01

Oracle Purchasing (PO)

• Customized the Standard PO Hard Copy Print Report to meet Drop shipment Functionality.

• Customized the Standard PO Hard Copy Change Print Report to meet client’s requirements.

• Created a new report SOPO Error Report. The SOPO Error Report shows us the errors occurred while running the custom program SOPO Process.

Order Entry (OE)

• Designed and developed interface program to Import Orders from legacy system into interim tables using SQL * Loader and developed a PL/SQL program to validate the data and send to Interface tables.

• Customized Backorder Detail Report to review all customer orders that have been Backordered.

• Customized Shipments report based on customer Business requirements.

• Designed Sales order detail-listing report to check tax rate and tax charged for city, county and state on each transaction.

• Created Daily Shipments report to review all the goods shipped on a particular day.

• Customized Process Exception Report with new fields like Item and Description.

Oracle Inventory (INV)

• Customized Min-Max Planning report to suit the customer needs.

• Developed New Report YTD Finished Parts Report used to display Item categories, material cost and prepares YTD figures for items, material Cost.

Environment : Oracle Applications, Reports2.5, PL/SQL, SQL*Plus and SQL*Loader.

Contact this candidate