SUMMARY

• Over 8+ years of Experienced in System Analysis, Design, Development, Conversions, Customizations, Interfaces and Implementation of Software Applications using Oracle Applications R12/11i spreading across Implementations, Version upgrades, Data conversions.
• Extensive Technical and Functional expertise in Oracle Applications R12/11i SCM modules like General ledger(GL), Account Payables(AP), Account Receivables(AR), Project Accounting (PA), Fixed Assets (FA), Order Management (OM), Inventory, Purchasing, Bill of Materials (BOM), WIP, ASCP, Human Resource(HR),, Service Contracts, Install Base, E - Business Tax (eBTax) and System Administrator Modules.
• Extensive experience in writing PL/SQL Stored Procedures, Functions, Packages, Database Triggers, Advanced PL/SQL (PL/SQL tables, Record type, Bulk Collects and Bulk Binds) SQL * Loader scripts, UNIX Shell Scripting.
• Expertise in design and development of Interface, Conversion, Migration and Customization programs to import data from legacy systems and integrate it into Oracle Applications and ETL/Data warehouseexperience with open interfaces, APIs and UTL FILE Packages.
• Exposure to Accounting Business Practices used in Oracle General Ledger (GL), Accounts Payables (AP) and Accounts Receivables (AR).
• Performance Tuning by implementing materialized views with query rewriting, creating appropriate indexes, usage of hints, rebuilding indexes and also used the Explain Plan.
• Expertise inDynamic SQL, Records, Arrays and Exception Handling.
• Adept at designing, developing, implementing and customizing of RICEW (Reports, Interfaces, Conversions, Extensions and Workflows) objects.
• Expertise in Data Modeling,Normalization, Database Design, Data Loading, Data Retrieval, Modification, and Archival Techniques.
• Good knowledge of Advanced Supply Chain Planning (ASCP), Supply Chain Management (SCM) and Finance.
• Extensive Industry Experience in implementing and testing Order to Cash (O2C), Procure to Report (P2R) and Procure to Pay (P2P) business flows.
• Experience in Application System Administration activities like application user setup, defining responsibilities, value sets, flex fields, registering menus, forms, reports, concurrent programs and migration tool KINTANA and FNDLOAD script.
• Tax Experience inimplementing Oracle E-Business Tax (eBTax) moduleat various configuration levels such as Global Configuration Level and at Operating unit level based on business requirement.
• Strong knowledge of Oracle Retail products like AIP, RMS, Allocation, RPM, RPAS.
• Experienced in loading data into Oracle Database using Data Loader and SQL*Loader.
• Extensive experience in developing and customizing Reports and Forms using Oracle Forms 10g/6i/4.5 and Reports 10g/6i/4.5, XML Publisher 5.6.2/5.6.3.
• Experience in customizing applications using OAF and ADF.
• Experienced in developing and enhancing OAF pages using Oracle JDeveloper.
• Extensively worked on System Administration responsibilities such as registration of concurrent programs, creation of Users, Responsibilities, Forms, Functions, Menus, Value sets and Flex fields in Oracle Applications.
• Work Experience in articulating design and development concepts in technical specification documents, AIM documents like MD050, MD070 and CV060.
• Strong Conceptual, Business, Analytical skills & highly motivated team player.
• Excellent communication and presentation skills, Quick in grasping client’s business requirements and good at adapting to new work environment.

TECHNICAL SKILLS

Oracle Applications: General ledger(GL), Account Payables(AP), Account Receivables(AR), Purchasing, Fixed Assets, Internet Expenses, Order Management, Project Accounting, Inventory, Service Contracts, Install Base and System Administrator

RDBMS: Oracle 7.x/8i/9i/10g, Access, SQL Server 7.x, 2000, Sybase

Tools: Oracle Reports 6i, XML/BI Publisher 5.6.2, OAF, Forms6i, OBIEE, Discoverer, BI Publisher, Workflow Builder

O/S: Windows NT/XP/2000/98, UNIX, Linux, MS-DOS

Languages: SQL, PL/SQL, Web PL/SQL, C, C++, JAVA, XML

PROFESSIONAL EXPERIENCE

Confidential, Duluth, MN

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Worked as an Oracle Applications Consultant for Implementation of Oracle, to import data from third party Legacy System, Arena into Oracle Apps R12 EBS including AP, AR, GL, INV, BOM, WIP, Costing, PO, OM, as part of the customer requirement.
• Developed PL/SQL Packages, Procedures, Functions for validating the Customer items and Customers information from the legacy system and imported it into Oracle Application using the Import Customer Items interface.
• Imported Data from Subsidiary ledgers to record budget or actual tractions into oracle GL directly.
• Design and developed Custom detail, GL Trail Balance reports and also Custom reports for reconciliation of Subledgers (SLA) to GL, pointing to SLA tables.
• Developed interface in Costs to import item cost control information (with material and material overhead) by cost type using cst item costs interface.
• Added expensed/CI/capitalized assets from legacy Payables accounting system into Fixes assets using “The Mass Additions Create Program” in Fixed Assets.
• DevelopedPL/SQLscripts to load data from external system to Fixed Assets fa mass additionsinterface tablesand developed Asset interface.
• Worked to improve the efficiency of oracle applications through the use ofindexes, compression, materialized viewsand other techniques.
• Developed Item Conversion Interface as part of manufacturing module (INV) to load item data from legacy system into oracle applications using SQL Loader and PL/SQL scripts for validating the data and Storing the data into mtl system items interface and then populating the base tables by running the standard Item Import program.
• Imported Cross reference between customer part number and Oracle item number into Oracle by Customer Item Cross References interface.
• Developed interface to import all previous and current Item Revisions for an item using mtl item revisions interface.
• Developed custom PL/SQL interface program to validate and import Bill of Material for Assembly items into bom bill of mtls interface and then populating data into base tables using standard import program, Bills and Routings Interface which is part of Manufacturing module.
• Developed Custom process to reallocate over time hours for Work Order via pa transaction interface all based on sequence in exploded time card.
• Worked on VO extensions to customize LOV query pulling information for Projects in Timecard Page using JDeveloper.
• Identified and established Item-Subinventory relationship using data loader based on transactions. This was required for picking of zero quantity items for Cycle counts.
• Worked onBillingWork bench and creating Auto invoices in AR interface with using interface tables architecture API, AR-Auto invoice Payables Open Interface tables and running the standard OracleInterface program to transform interface tables intoOraclebase tables.
• Involved in setting up Project Billing module like auto accounting, event type, implementation options and bill rate schedule.
• Inventory Items configuration for OPM, ASCP, Forecast, ISO and Quality capable.
• Developed UNIX Shell scripts to run the interface program and to archive the data.
• Debugged the custom interface betweenProject AccountingPAandReceivables AR.
• Developed various strategically critical Order and Container Scaling module within AIP.
• Helped in developing a strategy to bypass Data Management module within AIP and to create their own custom Data Management module.
• Developed custom functions for calculating Tax rate and Tax code using Oracle Standard arp tax vertex qsu wrappers.
• Also setup customer/item tax exceptions for customers and Tax calculation in Oracle E-Business suite.
• Implemented Location based tax for Accounts Payables & Accounts Receivables through E-Business Tax (eBTax).
• Involved in customizing the Project Accounting suite for reporting activities.
• Familiar withOracle Applications Framework (OAF) technology, especially with existing OA Framework pages.
• Worked on OAF Personalization of different pages based on requirement.
• Setup Cycle Count Headers for each organization for item count and posting adjustments.
• Developed Cycle Count Progress Report, Cycle Count Consolidated Report, and Cycle Count Management Report in Inventory using XML Publisher.
• Prepared integrated test cases for each setup and End User training material on the Project Accounting module
• Customized AR Aging reports in Accounts Receivable (AR) and Chart of Account Detail Listing Report using Reports 10g.
• Designed several key enhancements to AIP solution to meet client needs, including a customized cross docking solution from an inventory planning standpoint.
• Designed and developed Letter of Credit Report and Letter of Intent Aging Report using BI Publisher.
• Worked on AOL to register new reports, alerts, lookups, forms, functions, and created validation sets, request sets, flex fields and concurrent programs.
• Worked on setting up Outage messages and downtime messages when Oracle application is down for maintenance using Oracle Application Module.
• Customized Expenses workflow to divert approval for expenses with missing receipts to accountant and not manager.
• Prepared Mass Additions posting report, purge report, additions status report and unposted Mass additions report inFixed AssetsFAmodule. Established new procedures forAP, PO, GLandFA modules.
• Created Direct Margin Report, Fleet Expense Report, GL Inventory Reconciliation report, GL Variance by account, Trial Balance by account using Oracle Reports 10g.
• Planning and estimation of report and EFT deliverables for P2P and P2R tracks.
• Developed custom reports as per client requirement in OPM Forecasting module.
• Customized BI publisher report for AR Invoice in the client specified layout.
• Designed and developed Total Compensation Report and Workers Compensation Reports in HR using BI Publisher.
• Responsible for documenting the MD70, MD50, CV50 and CV60.

Environment: Oracle EBS R 12.1.1/12.1.3 (SCM, O2C, P2P, AP, AR, PO, OM, OPM, WSH, INV, HR, FA, PA, HCM, eBTAX), Oracle 10g, Oracle Reports 6i, Oracle Forms 6i, Oracle Workflow Builder, Data Loader, Oracle JDeveloper, OAF, SOA, C, C++, UNIX Shell scripting, TOAD 10.6 Suite.

Confidential, Indianapolis

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Gathering Business Requirements and setting up Business Processes within the Applications
• Involved in customer conversion from legacy system into Oracle Accounts Receivable(AR) by using Customer Interface
• Writing PL/SQL scripts to migrate the data from customers’ legacy system to Oracle Applications tables.
• Customization of Order Header workflow to close the order header once all the lines are closed.
• Modified the ‘PO: Printed Purchase order report (printed)’ to meet the client’s requirement
• Report development Character reports Daily Orders Report, Inv Shortages Report, Shipment Exception Report and label reports using Discoverer
• Customized standard reports like aging report and Invoice in AR.
• Developed a conversion program to convertFixed Assetsfrom legacy system to oracleFixed Assets (FA).
• Involved in developing open interface to transfer the data from Oracle Payables to base tables ofFixed Assets (FA).
• Extensively worked and resolved the issues on OM, Shipping Execution, INV, PO, ASCP, BOM, WIP, AP and AR Applications.
• Modified the custom hook to create internal requisitions for the customer orders placed at the distribution centers in ASCP instance.
• Worked on form personalization on User creation form and ASCP work bench.
• Coordinated with other product teams up taking SLA to understand the impact of upgrade on existing data.
• Experience in Debugging and error fixing using PL/SQL debugging tools like TOAD.
• Worked on Form personalization in receivables, where the user can’t update the last and first name of customer, bank account number, when that record is validated.
• Resolved the issues on Sub inventory transfer, Inter-Org transfer in Inventory Application.
• Proficient in generating Forms using Oracle Forms meeting variety of Business needs including custom Reports. Modifying Forms to accommodate new functionality like adding Buttons and Texts.
• Developed custom XML/BI publisher report for On-Hand-Quantity available for all the items in every sub-inventory, which belonged to a particular Organization in the Inventory module.
• Experience with Oracle environment using JDeveloper, and SOA suite.
• Extensively utilized the Application Object Library (AOL) to register SQL*Loader programs, PL/SQL packages and procedures, forms and reports
• Documented all the work using AIM methodology.
• Involved in Requirement Analysis, Data Mapping and Client Interaction. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Worked on Open Interfaces for importing transactions using Auto Invoice in AR.
• Customized Auto Lockbox Receipt Interface program to automate the receipt processing in AR.
• Wrote UNIX shell scripts for process for Data Loading, FTP, and sending mails

Environment: Oracle Apps R12 EBS, Supply Chain (SCM), OM, WSH, Supply Chain Management (SCM), Order to cash (O2C), Procure to Pay (P2P), ASCP, Warehouse Management, INV, PO, AR, AP, Fixed Assets (FA), OAF, CM TCA Architecture, Discoverer 10g, XML/BI Publisher, PL/SQL, GL, Reports 6i/10g, Forms 6i/10g, Toad, Perl, Windows XP, AIM, Oracle 10g.

Confidential, Kansas City

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Developed PL/SQL program to validate and populate Journal Entries from legacy system into interface tables
• Designed and developed Invoice conversion to import the data from legacy systems in oracle payables.
• Involved in developing Interface programs for Move Order Inbound & Outbound interfaces using MOVE Order PLSQL API between Oracle Apps and a legacy system for Replenishment Orders.
• Providing the Test Scripts, Test Scenarios to the Business to test the business process in Oracle in various modules including OM, INV, PO, FA
• Customized the ‘OM: Generate Cost of Goods Sold Account’ Workflow to generate the COGS account that meets the business requirements.
• Developed Custom Packages, which in turn were used for reporting purposes
• Developed AR GL Reconciliation report using Oracle Discoverer.
• Customized the standard AR Aging Report and Invoice History Report using XML/BI publisher.
• Designed and developed Inventory Detail report using Discoverer.
• Development of Discoverer 10g Reports includes creating complex views, folders, joins and item classes.
• Implemented form personalization in some forms based on client requirement.
• Developed AR Credit memo and AR Customers forms.
• Built custom forms using Oracle Forms 9i/10g Builder to fulfill the business requirements of the client
• Worked on Oracle Apps personalization (Standard Forms as well as JSPs) and customization and Extension using Oracle Application Framework (OAF), JDeveloper.
• Created Statement of Cash Flows and GL Period to Date Report using FSG’s.
• Converted Order Detail Report, Credit Order Summary Report and Orders by Item Report in Order management from report 6i to XML/BI publisher.
• Created Profit Center Report and Cost Center Report in General Ledger using Discoverer.
• As a Discoverer Administrator created Business Areas, Folders, and Setup joins between folders, Registered PL/SQL functions, created Item Classes, created date hierarchies and item hierarchies etc.
• Prepared MD070 Technical Design Documents for critical objects using the AIM Methodology.
• Used AOL and System Administrator modules for registering the developed and customized reports and conversion programs.

Environment: Oracle Applications R12, 11i (11.5.10) EBS, General Ledger, Accounts Payables, Account Receivables, Order Management, Inventory, Supply Chain Management (SCM), Order to cash (O2C), Purchase Order, OAF, Oracle 9i, Discoverer 10g, JDeveloper, MS Access 7.0, Windows 2000/NT, SQL*Plus, TOAD, Reports 6i/10g, Forms 6i/10g, UNIX

Confidential

Oracle Techno-Functional Consultant

Responsibilities:

• Design of documents and guides for new users of Oracle Financials R11i EBS (GL, AP, AR, FA, PO)
• Developed the Interfaces as initial data conversion from Acura (Legacy System) to Oracle Apps for INV, HRMS and BOM Modules
• Troubleshooting the Production issues on Order Management, Advanced Pricing, Inventory modules
• Testing the new functionality, identifying and resolving the issues in Advanced Pricing, Order Management (OM), Inventory (INV), Purchasing (PO) modules
• INV integration with PO and GL modules was extensively tested and verified before go live.
• Involved in Conversion Programs for Inventory Items, Inventory Transactions, Purchase Orders and Sales Orders.
• Design and development of several PL/SQL packages, procedures and functions that were used in Custom Reports and Forms development.
• Used CUSTOM.PLL extensively to modify the functionality provided by standard forms according to client requirements and created custom forms using zoom functionality.
• Register generated reports, forms, Flex fields. Defined Descriptive Flex fields, value sets and also registered PL/SQL stored procedures, SQL*Plus scripts etc.
• Developed the interface program to import Invoice data from legacy system to account payables using SQL*Loader and PLSQL packages to validate data.
• Developed Sales Order Interface by designing Staging tables, SQL*Loader Program and Custom PL/SQL to import the Sales Orders using Open interface tables in Oracle Order Management.
• Used AMG (Activity Management Gateway) in Project Accounting and developed a script to load Projects data into Oracle Projects
• Responsible for writing inbound/outbound interface programs in HR/Payroll/Oracle Advanced Benefits/Labor distribution and scheduling them to run periodically
• Responsibilities included new Reports, year-end (attended Oracle year-end Class), data clean up and all around HRMS (Benefits /PAYROLL) support.
• Designed RICE (Reports, Interfaces, Customizations and Extensions) objects to as per the custom business process within Oracle HRMS implementation.
• Development of customized forms using Oracle Application Framework (OAF).
• Designed and developed Actual Income Budget Statement, Cumulative Balance Sheet and Budget/Actual Report, Income Statement with Variance, Cumulative Balance Sheet and Income Statement Consolidated using FSG and XML Publisher.
• Used FND LOAD to upload and download the “LDT” files during the migration on Concurrent Programs registration.
• Used Discoverer 4i, Oracle Reports 6i and XML Publisher 5.6.2 to customize the reports.

Environment: Oracle Applications Release R12/11i EBS (INV, OM, Supply Chain Management (SCM) - P2P, O2C, Shipping, AR, PO, GL), HRMS, Oracle 8i, EDI, Forms6i, Reports 6i, Shipping, SQL, SQL*PLUS, SQL*Loader, UTL Scripts, TOAD, Discoverer4i, XML Publisher 5.6.2, PL/SQL, WinNT, and UNIX.

Confidential

Oracle ERP Technical Consultant

Responsibilities:

• Designed and developed custom forms and reports for multi-batch functionality which integrates planning and production operations for sheet business. Multi-Batch unites the manufacturing schedule and production operations for related product families. To implement multi-batch into OPM, requires building complex custom functionalities (Forms, Reports).
• Created Item-Lot conversion with OPM API's.
• PL/SQL Packages, Shell scripts and SQL Loader Control files for various conversions projects.
• Personalization changes to form pages.
• RTF Templates, Data Template Definitions, Data Definitions for various custom reports using BI Publisher.
• Forms, Reports, Database Objects (Views, Procedures, Functions, Triggers, Tables, Synonyms and Packages) as components of technical solutions.
• Unit / Integration testing of developed objects.
• Creating AOL objects
• Integration Test Support
• Go-Live Support

Environment: Oracle Applications 11.5.10 EBS (OPM - INV, AP, OM), Developer 6i/9i, Oracle DB 10g, PL/SQL, Toad, VSS.