SUMMARY

• Over 8 years of IT experience in various domains including 7+ years of experience in Oracle Applications.
• An excellent professional with good work experience in Implementation and support projects with Oracle E - Business Suite(EBS) 11i(11.5.10.3) and R12(12.0.6,12.1.1,12.1.3) applications.
• Active involvement throughout the entire Software Development Life Cycle on various domains such as Financial, Hospitality, Healthcare, Manufacturing and Transportation.
• Designed and Developed Custom components in 11i & R12 Using SQL, PL/SQL, Oracle 6i/10g Reports, XML/BI Publisher Reports, Oracle Forms 6i/10g, Oracle Discoverer 11g/9i, Oracle Workflow Builder 2.6.
• Involved in multiple large ERP projects End to End implementations: Development, Implementation, testing, training, support and documentation.
• Good understanding and work experience on functional flow of Procure to Pay (P2P), Order to Cash (O2C).
• Expertise in various technical components (RICE) with Finance & SCM modules - PO, OM, INV,WMS, AP, AR, GL, FA and CM and other modules such as Project Accounting, Sourcing, CRM and Core HR.
• Have very good experience and exposure towards TCA and Sub-ledger accounting (XLA) tables.
• Worked on various Data Conversions, Migrations and Interfaces from Legacy Systems.
• Experience in Oracle Apps System Administration activities such as application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports and concurrent programs, providing support to apps users for any technical issues.
• Proficient in SQL, PL/SQL coding (Procedures, Functions, Cursors, Triggers and Packages).
• Gained a thorough acquaintance with the Oracle Application Framework(OAF) .
• Good Knowledge and experience on oracle API’S in Oracle Applications.
• Performance Tuning of custom applications including reports and back-end programs by using different application tuning techniques like Explain Plan, tkprof etc.
• Interacting with Oracle Support team including opening service requests (TAR/SR) and working closely with Oracle support.
• Good experience in Technical documentation using AIM Methodologies (MD70 MD50, CV020, CV040 MD120’) and various other documents during various phases.
• Successfully implemented projects with high degree of client satisfaction, completed on schedule, have met all client expectations and received appreciations and reward from client for delivery.

TECHNICAL SKILLS

E-business suite(EBS): Oracle Applications 11i(11.5.10.3) & R12(12.0.6,12.1.1,12.1.3)

Oracle Application Modules: Financial Modules, Manufacturing Modules (General Ledger, Accounts Payable, Accounts Receivables, CM, FA, INV,OM,PO,WMS), SOURCING

Databases: Oracle 8, 9i and 10g.

Development Tools: SQL Developer, Oracle 6i/10g Reports, XML/BI Publisher Reports, Oracle Forms 6i/10g, Oracle Discoverer 11g/9i, Oracle Workflow Builder 2.6, Toad, UPK (user Productivity Tool Kit)

Utilities: SQL*Loader

Languages: SQL, PL/SQL, C, Core JAVA, Unix Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, Oak Creek, WI

Oracle Applications Techno Functional Consultant

Environment: Oracle Apps 11i(11.5.10.3) and R12(12.1.3), Oracle 6i/10g

Responsibilities:

• Data Conversion - Supplier, Item Master, PO Requisitions and Purchase Orders starting from data formatting, cleansing, loading with SQL * Loader and to base table with interface programs and APIs.
• Involved in the development of Outbound Interface to export the data from oracle application base tables into legacy system
• Imported Invoices usingAuto-invoiceprogram and applied receipts usingAuto-Lock Box
• Extensively worked on Oracle Reports 6i/10g and Oracle forms 6i/10g which includes Finance and SCM module reports.
• Developed custom Material Issue form to transact the material against a Purchase Requisition to various requesting departments and stores based on the availability of the on Hand quantity of the stock.
• Provided high level estimations to the project manager by task breakdown for different teams and identifying the dependencies.
• Wrote detailed technical design documents for some of the core functionalities and helped the team members on others. Functioned closely with the delivery team to implement the changes.
• Worked on Custom pll's in the process of upgrade.
• Created logical and physical database objects - tables, indexes, referential integrity constraints, and triggers to development needs.
• Worked on interface tables of purchasing to update purchase order line details and wrote PL/SQL codes to validate data and used concurrent program to load the data into base tables.
• Developed custom reports AR RECEIPT REPORT, AP PETTY CASH EXPENSE REPORT,DEBIT NOTE PRINT VOUCHER REPORT,AP INVOICE VOUCHER REPORT using XML/BI Publisher.
• Developed PURCHASING ACTIVITY REPORT, OVERDUE VENDOR SHIPMENTS REPORT, BUYERS REQUISITION ACTION REQUIRED REPORT using Oracle Reports 10g.
• Worked on Form personalization in Order Management and Purchasing.
• Used FNDLOAD to move the AOL objects from one instance to other instance.
• Working on Post production support to resolve the issues in day to day business process around the Finance and SCM modules.
• Trouble shoot issues in P2P like PO Approval workflow, AP Invoice Interface, Payment processing and AR Auto Invoice Interface.
• Involved with study of existing system, prepared the Technical (MD70) design document and Conversion Mapping Document (CV40) as per the AIM standards.

Confidential, Bismarck, ND

Oracle Applications Technical Consultant

Environment: Oracle apps R12(12.1.3), Oracle 10G

Responsibilities:

• Developed Customer Creation form to capture customer information which includes APIs hz cust acct v2pub, hz location v2pub, hz party site v2pub to load customer data into base tables with Workflow approval.
• Created logical and physical database objects - tables, indexes, referential integrity constraints, and triggers to development needs.
• Worked on Complex reports like Aging report in AR module.
• Involved in developing new reports as per Client Requirement and modify existing reports according to the requirement using XML Publisher. For example PO PRINT REPORT, PRE PRINTED CHEQUE REPORT, RECEIVING TRANSACTIONS REGISTER REPORT, EXPECTED RECEIPT REPORT, CANCELLED PURCHASE ORDER REPORT
• Involved in Preparation of Test Plans & Test Cases and Unit Testing.
• Worked in Oracle PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers using Toad as development tool.
• Review of the Technical Designs and Codes.
• Maintained Installation Scripts for Concurrent Programs and Value Sets.

Confidential, Woburn, MA

Oracle Applications Technical Consultant

Environment: Oracle Apps R12(12.1.3), Oracle 10g

Responsibilities:

• Created User documents using User Productivity Kit (UPK) for all Modules used in the project.
• Published the UPK at Server Side.
• Completed End User training on all modules which are in the project using User Productivity Kit.
• Developed and customized Oracle Reports according to the Client requirement in Account Payables Module.
• Developed Payment Alerts in Payables Module.
• Worked on Oracle Form Personalization to enable and disable the fields.
• Implemented Form personalization like serial number should be unique in assets form in fixed assets module.
• Implemented Form personalization like invoice date should be equal to the distribution date in account payables.
• Prepared MD070 and MD120 which gives the complete installation document for Custom components.

Confidential

Oracle Apps Technical Consultant

Environment: Oracle Apps R12(12.1.3), Oracle 10g

Responsibilities:

• Worked as technical consultant to develop and customize Oracle Apps components according to the requirement.
• Developed Alerts in projects Module to notify the clients regarding the new projects or modified projects.
• Created Alerts for all the items moved to expired sub inventory and also developed an alert for the stores to receive alert mails based on Item lot expiry date.
• Involved in creation of Projects and Project status, Created various projects, tasks and sublevel tasks with in those projects.
• Developed RFQ REPORT, RFQ SUPPLIER APPROVER REPORT, CAMPAIGN EFFICIENCY REPORT, TRIAL BALANCE REPORT, BANK ACCOUNT TRANSFER REPORT, GL PROFIT AND LOSS REPORT using XML/BI Publisher.
• Worked on System Admin activities such as application user setup, defining responsibilities, value sets, flex fields, registering menus, forms, reports and concurrent programs, providing support to apps users for any technical issues.
• Worked on Code review and performed unit testing before functional review.
• Contributed in different phases such as technical design, code, Object testing, Deployment and post prduction technical support.
• Involved in preparation of Documentation (MD70, TE120 and Installation Note) for Reports, forms.

Confidential

Oracle Apps Technical Consultant

Environment: Oracle Apps 11i (11.5.10.3)and R12(12.0.6), Oracle 6i/10g

Responsibilities:

• Key technical team member in development and customization of Reports, Interfaces, Conversions and Extensions (RICE components).
• Involved in different development phases such as technical design, code development, object testing and Deployment.
• Worked on Oracle Form Personalization, Custom PLL’s on Standard forms according to client requirement.
• Created an alert to notify the users regarding the Currencies entered in the Daily Rates Currency Master in General Ledger.
• Designed and created custom form using form 6i tool. Registered the form and migrated to the server.
• Worked on Oracle Discoverer Reports.
• Involved in the development of GL Interface.
• Worked on Oracle Apps Alerts in Financial Modules (AP and FA).
• Developed Oracle Discoverer Reports and XML publisher Reports in HRMS (Core HR) Module. For example HR AGE Report, HR CABIN CREW GENDER WISE-ACTIVE REPORT, HR JOINED OMANI STAFF REPORT, HR RAMP ASSISTANT REPORT, HR STAFF DEMOGRAPHIC REPORT.
• Developed finance reports AP INVOICES APPROVAL REPORT, AP SUPPLIER STATEMENT REPORT, AP STATEMENT OF COMPARATIVE BALANCE REPORT using Oracle Reports 10g.
• Involved in Code review and unit testing before functional review.
• Developed Technical design documentation Such as MD70s and MD120s.

Confidential

Oracle Apps Technical Consultant

Environment: Oracle Apps R12(12.0.6), Oracle 10g

Responsibilities:

• Involved in the Development of New Reports and also in the Customization of Existing Reports using RDF and XML/BI Publisher.
• Developed Oracle Reports, Forms for various business process in Supply Chain Management (PO, Inventory) and Finance Modules.
• Developed Custom AP HEALTH Budget ENTRY FORM.
• Worked on Form Personalization in the Finance Module for the annual Budgets allotted to the Government Hospitals.
• Created Oracle Alert to notify the Head of the Departments regarding the inventory.
• Created an Alert to notify the GM/MD when invoice/debit memo is submitted for approval.
• Developed Custom Reports NONPROCUREMENT DETAILS REPORT, BUDGET ALLOCATION SUMMARY REPORT, BUDGET PASSBOOK REPORT, CONSOLIDATED EQUIPMENT INDENTED REPORT, SAMPLES STATUS WISE REPORT using XML/BI Publisher.
• Using Oracle Reports 10g developed FORECASTED QUANTITY AND INDENTED QUANTITY BY HOSPITALS REPORT, STORES RETURN SUMMARY VALUE REPORT.
• Provided 24/7 support to the accounting and procurement users around the world.
• Worked on Technical design and documentation.

Confidential

Programmer Analyst

Responsibilities:

• Accountable for Design, Development and Programming
• Analyzed and provided support for legacy applications, performed coding and debugs programs
• Performed cost and feasibility study for different projects
• Prepared and obtains approval of system and programming documentation
• Involved in unit testing, system testing and user acceptance test