SUMMARY

• Over 12 Years of Experience in IT and 10 years in Oracle EBS implementation as Techno functional consultant in Enterprise Applications Practice with proven experience in implementing, Customizing, Migrating and Supporting Oracle Applications (11i & R12), AOL of Oracle E - business Suite.
• These include Analysis, Design, Development and Implementation of different projects for applications based on Relational DBMS, and in the field of Oracle e-business Suite.
• Highly proficient in requirements gathering, business systems study, functional solution design, and system document preparation using AIM methodology
• Extensive Experience in using Oracle Application Object Library (AOL) features including creating and scheduling of Concurrent programs etc.
• Experienced in Full software development life cycle implementation (SDLC).
• Experience in Oracle back end programming & front end development using tools like Developer Suite (Reports 6i/2.5), SQL, PL/SQL, SQL*Loader.
• Involved in data conversions and developing validation programs for data conversion from legacy systems to Oracle.
• Involved in Financial Functional Setups for the modules GL, AP, AR and PO.
• Good Expertise in functionality of Accounts Receivables (AR), Accounts Payables (AP), General Ledger (GL), Oracle Purchase Order (PO), Oracle Order Management (OM), Inventory (INV), Oracle Application Object Library (AOL) and TCA (Trading Community Architecture), P2P cycle, Oracle Fixed Assets (FA), Project Accounting (PA) and O2C Cycle.
• Good functional expertise on Open Interfaces and conversions (Includes both inbound and outbound interface) in Oracle Financials and Supply Chain (SCM) modules.
• Involved on Multiple Environments like UAT, SIT,, and Production Environments on an Enterprise Level.
• Enthusiastic to learn new skills with a shorter learning curve.
• Excellent Communication, Good Work Ethics, good Team Player and work independently
• Good Leadership skills with managing different offshore teams.
• Expertise in developing UNIX Shell Scripts.
• Work experience in RAC and Multi - Org environment and Hyperion.
• Expertise in developing interfaces, packages, procedures and functions using PL/SQL
• Good interpersonal, Analytical and communication skills.

TECHNICAL SKILLS

Oracle ERP: Oracle Applications /11i/ 11.0.3/10.7 (General Ledger(GL), Accounts Receivables(AR), Accounts Payables(AP), Purchasing(PO), Human Resource Management (HRMS), Inventory(INV), AOL, Work Flow, System Administration), Fixed Assets (FA),Project Accounting (PA), Inventory(INV), Order Management (OM), Financial and SCM Modules

DBMS/RDBMS: Oracle 10g/9i/8.x, 10g Express and Oracle Utilities

Tools: Toad, Reports 6i/3.0/2.5,Work Flow 2.5/2.6, SQL* Loader, SQL * Plus, ORACLE Developer Suite 6i, XML Publisher

Operating Systems: MS DOS, Windows 9x/2000/NT/XP, UNIX, HP-UX,IBM-AIX, Oracle-Solaris

Lifecycle Expertise: Analysis, Design, Development, Upgrading, Testing, Implementation

Languages: SQL, PL/SQL, JAVA, UNIX Shell Scripting.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Lead Oracle Applications Techno Functional Consultant

Responsibilities:

• Interact with system users and analyze the customer migration from different sources to load them in AR.
• Interact with system users and analyze the source system(s) for Invoices from different sources to load them in AR.
• Designed Technical Designs for Conversion elements based on Functional Specs for
• Customer migration, AR Invoices conversion, AR Lockbox process to load the Client receipts to apply against AR Invoices.
• Created Customized responsibilities, customized menus, customized request groups
• Contributed towards Conference Room Pilots CRP1, CRP2 and UAT
• Coordinate with functional team and business users for data conversion.

Environment: Oracle EBS R12 Oracle Receivables (AR), Oracle Purchase (PO), Oracle General Ledger (GL), Application Object Library (AOL), Order Management (OM), Inventory (INV), Developer 2000 (Reports and Forms), RICE elements, Oracle EBS R12, Oracle Fin. R12, Oracle Database 9iAS, UNIX Scripting, SQL, PL/SQL of Oracle 10g/6i, XML Publisher, Forms Personalization, SQL*LOADER and Shell script.

Confidential, Schenectady, NY

Lead Oracle Applications Techno Functional Consultant-Offshore Co-ordinator

Responsibilities:

• Participated in the R12 Implementation and support.
• Assisted functional lead analyst to conduct CRP1 and CRP2.
• Prepared BR.100 Application setup and MD.50 Application Extensions Functional Design Documents according to AIM.
• Involved in configuration of CRP1, UAT and test instance.
• Trained Super Users and troubleshooting during UAT (User Acceptance Test) in Financials and SCM modules.
• Used the System Administrator responsibility to define users and assign responsibilities and set Profile options
• Define Organization Structure, Users and Responsibilities, Security Profiles and Flex Fields
• Set - ups and maintenance, converted the headers, lines and line locations from the legacy system to Oracle Payables.
• Involved in setup for Payables, Purchasing, General Ledger based on deep understanding of the functional processes
• Set up AP bank accounts, bank documents, bank codes and expense report templates
• Defined profile options to specify certain implementation parameters
• Set up Recurring journals template, recurring journals in GL.
• Set up suppliers, locations, and purchasing quick codes.
• Setup payment terms, invoice distribution, matching of invoices against PO.
• Configure Financial Options and Payables Options in AP.
• Activation of various flex fields in the forms to gather the additional information
• Participated in testing, user accepting testing in test instance and worked with certain key Superuser
• Created BR.100 Application setup and CV.040 Conversion data mapping documentation for GL, AP, AR,PA, PO,INV and OM

Environment: Oracle EBS R12 Oracle Payables (AP), Oracle Purchase (PO), Oracle General Ledger (GL), Application Object Library (AOL), Oracle Accounts Receivable (AR), Oracle Inventory (INV), Order Management (OM), Developer 2000 (Reports and Forms), RICE elements, Oracle EBS 11i, Oracle Fin. R11i, Oracle Database 9iAS, UNIX Scripting, SQL, PL/SQL of Oracle 10g/6i, XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME.

Confidential, Redwood City, CA

Lead Oracle Applications Techno Functional Consultant

Responsibilities:

• Interact with system users and analyze the source system(s) for Invoices from different sources to load them in AP.
• Designed various functional specifications MD 50 on client requirements for Financial and SCM Modules.
• Designed Technical Designs for RICEW elements based on Functional Specs for
• Developed custom reports in Receivables and Payables based on user requirements.
• Loaded employee expenses using DATA LOADER.
• Created Customized responsibilities, customized menus, customized request groups
• Contributed towards Conference Room Pilots CRP1, CRP2 and UAT
• Coordinate with technical team for data conversion.
• Post production for the conversions and interfaces in Oracle Applications.
• Created BR.100 Application setup and CV.040 Conversion data mapping documentation for GL, AP, AR, PA, PO, INV and OM

Environment: Oracle EBS R12 Oracle Payables (AP), Oracle Purchase (PO), Oracle General Ledger (GL), Application Object Library (AOL), Oracle Accounts Receivable (AR), Oracle Inventory (INV), Order Management (OM), Oracle Database 10g, UNIX Scripting, RICE elements, SQL, PL/SQL of Oracle 10g, XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6

Confidential, Richmond VA

Sr Oracle Applications Technical Consultant

Responsibilities:

• Designed and developed staging tables, conversion routines, custom PL/SQL on PO, AP, AR, PA, OM and INV.
• Designed, documented and developed Bank Reconciliation interface to Oracle Cash management Interface.
• Developed an interface program to load data from custom tables to interface tables and then created journals into Oracle General Ledger as per business requirements.
• Analysed an SR on interface trip stop program and modified and executed the script for different internal requisitions and sales orders (OM).
• Convert the same script into Concurrent request.
• Designed and developed staging tables, conversion routines, custom PL/SQL on AP, AR.
• Customized Account Payables (AP) Reconciliation Reports like Accounts Payable Trial Balance report, Posted Invoice Register, Posted Payment Register, Unaccounted Transactions report and consolidation journal report in General Ledger (GL).
• Customised Packing Slip and Pick slip reports.
• Developed various xml reports like Audit Trail Report, Delegation of Authority Audit Report using XML Publisher.
• Involved in Scheduling the Reportsof Financial and SCM Modules.

Environment: Oracle EBS 11i Oracle Payables (AP), Oracle Purchase (PO), Oracle General Ledger (GL), Application Object Library (AOL), Oracle Accounts Receivable (AR), Oracle Inventory (INV), Order Management (OM),Developer 2000 (Reports and Forms), RICE elements, Oracle EBS 11i, Oracle Database 9iAS, UNIX Scripting, SQL, PL/SQL of Oracle 10g/6i, XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME.

Confidential, Beloit, WI

Oracle Applications Technical Consultant

Responsibilities:

• Involved actively in deriving the requirements with the Business Folks.
• Loading the flat files into Source tables in the schema using Oracle External Tables and SQL* Loader.
• Developed the necessary Packages and Stored Procedures to in corporate the Business Logic.
• Worked as a Technical team member responsible for the following technical components.
• Worked on the Oracle e-Business Suite 11i ERP Implementation for Financials and SCM Modules.
• Worked on AR, INV, PO and OM Modules
• Participated in weekly meetings with client and appraised the work status.
• Designed technical design documents and specifications.
• AR Customer Credit Terms Report Customization.
• This report is the extension of Standard Aging Bucket report customized to show the additional details of customer name, credit terms of the customer, Average Days to Pay etc.
• Inventory Customization of Master Items Form using Custom.pll.
• This customization done to Master Items form to default the Cost of sales Account, Sales Account.
• AR Invoice Print Report Customization.
• This report is the customization of the standard Invoice Print Report.
• This report added with the feature of printing Original/Duplicate Label according to the custom user Profile option.
• Inventory Item Status Event Alert.
• This alert is generated eventually when the status of the Item has been changed and an Email message is sent to the concerned manager regarding this event.

Environment: Oracle EBS 11i Oracle Payables (AP), Oracle Purchase (PO), Oracle General Ledger (GL), Application Object Library (AOL), Oracle Accounts Receivable (AR), Oracle Inventory (INV), Order Management (OM),Developer 2000 (Reports and Forms), RICE elements, Oracle EBS 11i, Oracle Fin. R11i, Oracle Database 9iAS, UNIX Scripting, SQL, PL/SQL of Oracle 8i, XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6.

Confidential, Newark, CA

Oracle Applications Technical Consultant

Responsibilities:

• Worked as part of the offshore development team.
• Worked on customization and development of add-ons on Oracle Applications
• Worked on GL,AR, AP,PO, INV and OM Modules
• Being responsible for customizations and migrations from 11.0.3 to 11i
• Developing Reports, writing custom packages to develop conversion programs
• Being responsible for registration of concurrent programs, Forms and Reports to AOL
• Being part of the offshore development team, responsible for Customizations and Migrations from 11.0.3 to 11i.
• LOGI Fund Assignments Upload Program. Migrated custom upload Programs, which uploads the Fund Assignment Types manually.
• Changed some obsolete tables with new TCA architecture Tables.
• LOGI Fund Accruals GL Upload Program And LOGI Fund Adjustments Upload Program.
• Migrated custom upload programs from 11.0.3 to 11i used to import data to GL.
• Changed some obsolete tables with new TCA architecture Tables.
• LOGI Fund Assignment Report by Customer.
• Migrated a custom report from 11.0.3 to 11i to generate the fund assignment categorized by Customer.
• Changed some obsolete tables with new TCA architecture Tables.

Environment: Oracle EBS 11i Oracle Payables (AP), Oracle Purchase (PO), Oracle General Ledger (GL), Application Object Library (AOL), Oracle Accounts Receivable (AR), Oracle Inventory (INV), Order Management (OM),Oracle 7.3, EBS 11.0.3, 11.10.2, SQL, PL/SQL, AIX, Developer 2000

Confidential, Illinois, IL

Oracle D2K Developer

Responsibilities:

• Involved in the system analysis and designing for the upgrading of manual Sales Ordering System into Computerized system using Oracle 7.3 and Developer 2000.
• Worked as part of the offshore development team.
• Developing D2k Reports, writing custom packages to develop POS program.
• Supporting the day to day issues after implementation of POS software

Environment: Oracle 7.3, SQL, PL/SQL, Developer 2000

Confidential, Cincinnati, OH

Java Developer

Responsibilities:

• Involved in the system analysis, designing and development for the Employee payroll project.
• Developed test scripts for the developed programs
• Involved as a team member of the post production support of the project.

Environment: Java, Oracle 7.3, SQL, PL/SQL