PROFESSIONAL SUMMARY:

• Techno - functional expertise in Financial and Oracle Supply Chain modules.
• Extensive experience working with Oracle Applications E-business suite (11.5.10/11.5.9/ R12), with major focus in financial modules likes GL, AP, iExpense, AR, FA, Cash Management and Distributions modules like PO, iProcurement, INV, Shipping and OM.
• A solid understanding of functional and technical knowledge of Procure to Pay (P2P) and Order to Cash (O2C) business flows (General Ledger, Receivables, Payables, iExpense, Oracle Inventory, Purchase Order, Shipping and Order Management).
• Experience working on projects which involves integration of Oracle e-Business suite with legacy systems and e-commerce tools through Oracle Open Interfaces (Standard API) and workflows.
• Good experience customizing and personalizing approvals using Oracle Approval Management (AME).
• Experience working on projects encompassing all the phases in the life cycle of software development including requirements elicitation, analysis and design, coding and implementation, testing and quality assurance
• Experienced in Performance Tuning and Optimization of SQL Queries and also tuning at database level.
• In depth experience in using Agile and AIM Methodology, Designing and Developing RICE components during the SDLC.
• Working experience of Middleware SOA and Informati Confidential .
• Extensive experience working with super and end users providing implementation /Go-Live Support during their Software development cycle.
• Good Team player with logical thinking and motivational leadership abilities ready to take up challenges and initiatives.
• 11+ Years of strong experience in various stages of the Oracle E - Business Suite implementation, upgrade and support lifecycle in financial and distribution modules as a Techno-Functional Consultant.
• Expert Oracle e-Business Suite Implementer. End to End business knowledge to provide best suitable solution to any business.

TECHNICAL SKILLS:

ERP: Oracle Applications R12/11i in Financials modules like Accounts Receivables(AR), Account Payables (AP), iExpense, General Ledger (GL), ProjectAcounting (PA), Fixed Asset (FA), EB-Tax and Distributions modules like OrderManagement (OM), Purchasing (PO), iProcurement, Inventory (INV), Shipping(WSH) other modules Like Sysadmin (AOL), Workflow Administrator and Alerts.

Language: SQL, PL/SQL, C, C++, Shell Scripting

Tools: Forms 6i/10g, Oracle Reports6i/10g, XML Publisher Technology, XML- Gateway, Toad, SQL Developer

Databases: Oracle 8i/9i/10g/11g, MS Access, Microsoft SQL Server 2000

Environment: s: Windows 98/NT/2000/XP, UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

Environment: Oracle Applications R12 and 11.5.10

Responsibilities:

• Involved in the development and end to end testing of major AR and AP conversions. Major conversion program includes:
• Program to Reconcile, Validate and Process the Suppliers/Customer from 11i to R12.
• Program to create the bank accounts for the Suppliers.
• This program Reconcile AR (Transactions/Receipts) from 11i to R12.
• Responsible for preparing BR100 for setups up Account Payables, Accounts Receivalbles and System Adminstrator responsibilities in production.
• Developed scripts to audit all the production setups and raising tickets and incidents with the IBM (setup) team to get the indescripencies resolved.
• Supporting testing issues raised in UAT testing using Clear case, Clear quest ticketing system.

Confidential, Sunnyvale, CA

Environment: Oracle Applications R12 and 11.5.10

Responsibilities:

• Upgrade Impact Assessment on Standard Oracle Objects for Purchasing, Payables, Project Costing, Billing and Order Management.
• Working as Architect in conversion of Optio reports to XML Publisher reports in R12 version of E-Business Suite in AP, AR and Order Management.
• Responsibilities involved analysing present business structure and interacting with client across different regions and provide optimal reporting soultion to cater all the business needs, as well as provide simple and robust solution in XML Publisher reporting.
• Developed approval rules based on invoice amount using Oracle Approval Management (AME) and configured action types and actions and set up the profile option to work for Payables only and also the required setups.
• Co-ordinate with the offshore team to ensure round the clock of defect fixing for timely completion of UAT testing.
• Major components supported in testing:
• AR Receipts Conversion to Import Receipt Data from legacy system into Oracle Applications, using Standard API.
• Worked on one time conversion of AR Invoices and Customers.
• Synchronzing AP Payments between legacy system and Oracle EBS.
• Program to create Service Contracts from the Sales Order.
• Program for Termination and updation of Service Contracts
• Order Import program to create Sales Orders from legacy system data.
• Creating conversion scripts to import Service Contracts from legacy system.
• Customized various standard workflows to cater user requirement.

Confidential, Milwaukee, WI

Environment: Oracle Applications 11.5.10, Siebel 8.1

Responsibilities:

• Designed the process flow for the full Order to Cash cycle between Siebel and Oracle Applications v 11.5.10 as an Oracle Architect.
• Worked as offshore lead and responsibilities include interacting with Siebel and Middleware teams, understand client requirement and propose the best possible solution.
• Design various interfaces in conjuction with Middleware (SOA and Informatica) and Siebel teams.
• Designed, developed and tested various interfaces between Siebel and Oracle Applications. The major one includes:
• Customer Interface to transfer the customer data to Siebel, both synchronously and asynchronlusly using business events (SOA) and Informatica respectively.
• Sales Order Interface, to create Sales Order in Oracle through the data received from Siebel in real time, for both Field Engineers and end Customers.
• Parts Return Interface to create Return Orders in Oracle from Siebel, on demand.
• Status Synchronization Interface, to send current status of Sales Order Lines in Oracle ERP to Siebel, both on demand (SOA) and through batch interface.
• Parts Validation Inteface, to validate the parts in Siebel before placing the order. Request is send from Siebel in Oracle, where validity and availability of the part is checked and proper response is send back to Siebel synchrounously.
• Material Transaction Interface, to check on-hand quantity for the Field Engineers in Siebel.
• Stock Decrement Interface, to decrement the stock for the Field Engineers once there stock items are utilized.
• Item interface, to population of Item data and Modality data in Americas Service CRM.
• Involved in the end to end testing for the whole process flow involving multiple interfaces developed for the Siebel AM Program.
• Customize the workflow processes in Order management. Customization of various Extensions in 11.5.10.2 to enhance the client’s requirements.
• Worked in Siebel tools to create IO for the BI Publisher Reports in Siebel.

Confidential, Milwaukee, WI

Responsibilities:

• Configure and develop reports based on the User requirements using BI Publisher.
• Define different data set used for developing the reports like OLTP, OLAP and WSDL files.
• Development around "list style" reports from within the Siebel application in BI Publisher. Major Reports includes:
• PSA Proposal and Agreement Report.
• Manage Quote Report.
• Payroll Exception Report.
• Time and Expense Report.
• SR Invoice Report.
• Configure BI Publisher Scheduler to schedule reports to be generated as per business requirement.
• Work on OLTP data model and Siebel Tools.
• Tuning of the queries of the report for performance enhancement.

Confidential, Chicago, IL

Environment: Oracle E-Business R12, Unix

Responsibilities:

• Responsible for design and development of the BI Publisher Reports in various modules like Accounts Receivables, General Ledger, Property Manager, iExpense etc in R12 version of Oracle applications.
• Developed Reporting Standards to be followed in all the McDonalds Reports for new R12 architecture, in both Report 10g and XML/BI Publisher Reports like Currency formating standards, Disclaimer text etc.
• Designed mojor reports for the Confidential Corporation. The prominent ones inclue:
• Monthly Customer Statement Report
• Delinquent Interest Letter Report
• Late Interest Charges Report
• Outstanding Credit Card Transactions Aging Report
• Approval Audit Report Report
• Change Approver on Expense Report Report
• AMEX Cardholder Report
• Policy Violation Report
• Unapplied Checks Report
• Credit Card Accrual Report
• Chart of Accounts Segment Value Listing Report
• Recoded Expense Report
• Designing various extensions for the Property Manager Modules to customise it to the customer requirement.
• Developed Store Open Date Lease Finalization Extension in property Manager to automatically updating the required fields based on a given rule based date.
• Developed and Tested Interface and report for the Real Estate Tax history from 1st America, to map the data presented by the periodic 1st American Report to the one present in oracle data base.
• Giving post production support to the released object.
• Proper documentation of the product developed and verification of the RICE products developed by the team as reviewer.

Confidential, Phoenix, AZ

Environment: Oracle Apps 11i/R12, Sun Solaris 5.7

Responsibilities:

• Responsible for Business Requirement gathering, gap analysis to define the functional framework for implementation of different RICE components in order to cash (OTC) and procure to pay (P2P) cycles.
• Designed and developed numerous reports from Report 6i/10g in 11i to XML Reports in R12, in GL, AP, AR, FA, PO, OM, INV modules. The major reports include:
• Detailed GL Account Analysis Report to display of accounting transactions details along with extra information from the subledgers
• GL Journal Details Report, sorted by “Posted Date” and “GL Journal Sequence Number” from Oracle General Ledger
• AP-AR forms Report listing the goods and services purchased and sales from/to a company or Legal Entity
• Inventory Turnover Report.
• Enhanced the convertion program to validates invoice information and load the invoices into AR by running Auto Invoice daily.
• Personalization of Payables Invoice Form for Unique Invoice Number by Supplier and year.
• Personalisation of AP Invoice Matching Form. Requirement was while match the freight carrier’s invoices to the receipts, debit its amount to the item cost account.

Confidential

Environment: Oracle Application R12, Win 2000/NT, Sun Solaris

Developer

Responsibilities:

• Worked in the development of forms, reports, PL/SQL programs for EMEA localization.
• Involved in R12 Impact analysis of objects to be developed.
• Transitions of the reports from Report 6i/10g in 11i to XML Reports in R12.
• Designed and developed numerous PL/SQL programs, extension for various localization. The major programs include:
• FA Depreciation Rounding Program for CZ and SK localization which gives the rounding values of the depreciation based on the parameter defined in the Book Controls Form.
• Exchange Rate gain and loss Interface program to create Journals using xla journal entries pub pkg API or Invoices in Accounts Payables and Receivables to accomodate the taxation of the Exchange Rate gains and losses between invoice date and payment date. The program includes the creation of Form and a report to display the new transactions created.
• Importing Invoices into Oracle Receivables Using Auto Invoice Import Program.
• VAT Reconciliation Additional program to cover the gaps of the VAT reporting process that consists of VAT Reconciliation and VAT Statutory Reporting.
• Involved in developing Reports using XML Publisher. The major reports include:
• Non-Invoiced Goods and Services Report to report all transactions where invoice has not been furnished by the vendor till before a stipulated time.
• GL Accounting details Report. Report gives the details of the General Ledger journals. This report contains three layouts based on the country specific code from the profile option.
• AP and AR Exchange Differences Report to give the details of the Exchange Differences in the sub ledgers Payables and Receivables.
• Materials return to Supplier Report
• PO Printed Purchase Order Report Customised the report for orders that are shipped early, late and on time for each customer using Oracle Reports, and developed design
• Working with business analysts and functional resources to troubleshoot application issues.
• Worked on tuning the SQL queries using tuning utilities like indexing, SQL trace and Explain Plan.

Confidential

Environment: Oracle Apps 11.5.7, 11.5.10, Unix

Responsibilities:

• Reviewing business processes, initiate setups, prepared data sheets, defining concurrent requests and test scripts
• Reviewing Functional documents and Developing Technical Specifications for Custom reports & forms in reports 6i, forms 6i.
• Prepared Migration technical documents for Data Conversions and Interfaces.
• Writing custom packages to develop conversion programs.
• Developed GL Balances Conversion program to load the beginning balance in the base tables.
• Involved in development and testing of the custom program for validation of the GL Budget data to be uploaded using GL Budget Interface.
• Development of database triggers for data security within the application.
• Customization of Oracle Application forms using CUSTOM.pll.
• Developed custom forms using standard AOL components like template forms and libraries.
• Involved in developing technical design document (MD 70) for technical solutions using oracle AIM standard
• Worked on tuning the SQL queries using tuning utilities like indexing, SQL trace and Explain Plan.
• Designed AR Invoice Aging Report to view Customer Outstanding Balances by 9-Aging Buckets.
• AP Invoice Report which tracks the record of all the Unpaid Invoices - Matched with Receipts.
• Conversion of unprocessed employee expenses using the open Interface.
• Open Purchase Order conversion from the legacy system to standard application
• PO Revision Report to shows, for a PO or release, the revision amount, incremental amount, and total amount of each revision.
• Proper documentation and performance tuning of the RICE products developed by the team as a reviewer.