SUMMARY:

• 16 years of IT experience in implementation, upgrade, customization, design, development and maintenance of business applications and ORACLE front - end & other development tools. Worked on Oracle Applications 10.6/10.7/10 SC/11.0.x/11i/R12
• 12 years of ORACLE Applications experience. Worked with versions 10.7, 11.0.3 & 11i (11.5.7,115.9,11.5.10.2), R12 system Administration
• Tuning Applications for better performance
• Training Users on Application functionality and usage.
• Extensive experience in Distributed Database Systems and Client Server Architecture.
• Profound knowledge of business process flow, operations and control.
• Experience in 11.5.8. to 11.5.10 upgrade,11.510 to R12.
• Experience in mapping and data conversions
• Experience in conversion data validation.
• Expertise in customizing modules. Modules that were customized include Accounts General Ledger, Accounts Receivables, Accounts Payables, Cash Management, HRMS, Pay Roll, Fixed Assets, Order Entry, Order Management, WIP, BOM, Depo Repair, Alerts, Purchasing, Inventory, General Ledger, CRM (Service Contracts and Install Base) and knowledge of oracle Quoting.
• Experience in using Oracle Trading Community Architecture (TCA).
• Experience in using TCA API's.
• Developed and customized reports Using XML Publisher including Custom Check Print Programs.
• Legacy system migration planning and execution.
• Experience in Customization of Reports using ORACLE Reports 2.5, 6i and 9i.
• Experience in Customization of Forms using ORACLE Forms 2.3/2.4/ 4.5, 6i and 9i.
• Well versed in the following Oracle Applications, Software, Programming Languages, Tools, Operating Systems and Hardware.
• Experience in writing CV40, MD70, MD120 and User documents.

TECHNICAL SKILLS:

ORACLE Applications: Oracle Applications 10.6/10.7/10 SC/11.0.x/11i General Ledger (GL), Accounts Receivables (AR), Order Entry (OE),Cash Management(CA), Order Management (OM),Costing(CST), Shipping (WSH),WIP,BOM, Accounts Payables (AP),HRMS, OTL,Oracle Alerts, Oracle Workflow, Fixed Assets(FA),Purchasing (PO), Inventory (INV), Customer Relationship Management (CRM)(Service Contracts, Install Base),Oracle Projects, Trading community Architecture (TCA) and Application Object Library (AOL),Oracle Process Manufacturing(OPM).

Tools: ORACLE 6/7/8.x/9i/10g,Developer 2000, Forms 6i,10g,Reports 6i,10g, Discoverer 4i, 10g, PL/SQL, SQL *Plus, SQL *Loader, TOAD, XML Publisher, Knowledge of J-Developer.

PROFESSIONAL EXPERIENCE:

Confidential, CA

Oracle Technical Consultant

Responsibilities:

• Created New time card Layout.
• Modified Existing Timecard.
• Created new Payroll fast formulas in OTL for New employee.
• Created new formulas for custom messages in Time cards for Holiday Time Entry.

Confidential, CA

Oracle Consultant/Architect

Responsibilities:

• Created AS-IS and TO-BE process documents for Confidential interfaces.
• Designed inbound interface for Confidential HR/PAL system with Fi$Cal People Soft ERP.
• Modified PAL Time entry forms to integrate with Fi$Cal PC Module.
• Designed inbound interface for Confidential HR/PAL system with Fi$Cal People Soft ERP.
• Modified HR/PAL aliases and HR Admin forms.
• Implemented silent features of Project Accounting such as rate schedule, transaction control and auto-accounting rules, Implementation of labor cost rate schedules .
• Setup of Expenditure categories and Expenditure types .
• Creation of expenditure types for interface supplier costs and miscellaneous transactions.
• Redesigned and developed State Controller Office (SCO) Interfaces functionality to automate Payroll and California Leave Accounting (CLAS) processes:
• Modified PAL time entry forms .
• Created new custom forms for PAL setups relating to time entries.

Confidential, CA

Sr Oracle Consultant

Responsibilities:

• Re-mediated Complete Claim Schedule Custom Application related objects like interfaces, reports and forms.
• Designed and Developed new reports.
• Purchase order, Invoice, Check Printing, Remittance Advice reports using XML Publisher.
• Created Custom Discoverer reports in AP and AR.
• Created new time card.
• Reviewing current custom objects to replace with seeded functionality in R12.
• Redesigned Custom Module Claims schedule to reduce customization according Oracle Standards and replace some with standard Oracle functionality.
• Prepared MD 70, test scripts and user docs for changes in functionality.
• Attending production issues relating to HR, AP, CS etc.
• Reviewing the current Design of Time Entry System.
• Working OTL Production issues.
• Gave training to new Accounting and HR users.
• Moving all custom objects from 11.5.10 to R12.
• Educating/Clarifying users about new functionality in R12.
• Attended month end closing issues.
• Preparing Migration documents.
• Designed and developed new Oracle and OA framework forms for Claims Schedule.
• Personalizing forms to meet current user needs.
• Providing training documents to users.
• Conducted CRP1, CRP2, UAT.

Confidential, CA

Sr Oracle Consultant

Responsibilities:

• Reviewing current custom objects to replace with seeded functionality in R12.
• Moving all custom objects from 11.5.10 to R12.
• Educating/Clarifying users about new functionality in R12.
• Modified existing BI Templates in Purchasing and Payables.
• Modified workflow for Notifications.
• Preparing Migration documents.
• Personalizing forms to meet current user needs.
• Created new custom Timecard.

Confidential, Sacramento, CA

Sr Oracle Consultant.

Responsibilities:

• Design and development of 8 custom forms to maintain SCO information.
• Prepared MD 70 for out bound and inbound interfaces.
• Design and development out bound interface to send Employee information.
• Design and development out bound interface to send Employee payments information.
• Design and development Inbound interface to bring Employee Travel Advance information and create invoices.
• Design and development Inbound interface to bring Employee Travel Expenses information, create invoices and apply to prepayment invoices.
• Modified their highly customized reports to accommodate employee travel expenses process.
• Experience with Sub Ledger.
• Modified existing Order Management reports.
• Working on Customization of iProcurement workflow/approval process.
• Prepared MD 50 for custom reports.
• Experience in writing CV40, MD70, MD120 and User documents.
• Understanding of PAL And OTL .

Environment: ORACLE10g, SQL, PL/SQL, Report/Forms 10g, Oracle Applications R12, AP, AR, HRMS,OTL, OM, INV

Confidential, SFO,CA

Techno-functional

Responsibilities:

• Analyzed their current system and provided some option to resolve the existing unclosed Invoices and Payments information received from sister Companies.
• Design and development interface to create payments in oracle.
• Applying these payments to unclosed or open invoices.
• Creating credit memos for refunds in AR through Automation.
• Closed on all open payments after applying to Invoices
• Prepared Technical Design
• Changed existing reports to accommodate new acquired companies.
• Involved in R12 update discussions.

Environment: ORACLE10g, SQL, PL/SQL, Oracle Applications 11.5.10,GL, AP, AR, HR.

Confidential, CA

Sr Oracle Financial Analyst

Responsibilities:

• Design and development of BI reports (OM,WIP,BOM,INV,AR,HRMS) relating to ERP.
• Preparing Technical Design for New reports.
• Performed System Administration Role
• Guiding/Clarifying Oracle BI(OBIEE) team in implementation from ERP.
• After live providing updates to Mgmt relating to Sales order.
• Helping Order fulfillment in R12 mapping.
• Developed reports in HRMS.
• R12 Post go live support.
• Developed reports in Payables and Receivables.
• Written documents for AR, CM reports
• Design and development Inventory Category, Mkt&Mfg, E&O reports.
• Prepared user-training documents.

Environment: ORACLE10g, SQL, PL/SQL, Oracle Applications (R12), OBIEE, IB, GL, AP, AR, PO,AOL, OM, INV, HRMS, BOM, WIP.

Confidential, Santa Clara, CA

Sr Oracle Financial Analyst

Responsibilities:

• Responsible for analyzing the IB, Service Contracts conversion fallout issues, CV 40, MD 70 documents and Working with Business and Technical team to close the issues. Responsible for data conversion from SAP, ACES, Oracle 10.7 data.
• Designed and Developed CV 40 and conversion scripts for SAP,ACES, Oracle 10.7 data
• Working customer related issues in IB and Contracts conversion issues.
• Collected requirements and involved in business decisions for back-office inbound /outbound interfaces for AP, AR.
• Recent experience in Conversions, Interfaces and Report Customization in oracle modules Service Contracts, Install Base.
• Validation converted data against legacy data for each source.
• Providing random sample data after conversion to Auditors from all converted sources.
• Verifying customer converted data using SQL queries.
• Running statistical reports using sql/discoverer/reports6i for validation purpose.
• Providing required conversion data to Auditors.
• Working closely with Business team in Interface testing, maintaining MD70 documents and co-coordinating offshore team to close the bugs.
• If needs getting CCB approval for any changes in Interfaces and updating MD70 documents.

Environment: ORACLE10g, SQL, PL/SQL,Forms,Reports, Discoverer, Oracle Applications (11.5.10.2), IB, Service Contracts, AP, AR, TCA, PO, OTL,OM, INV,CRM and OBIEE.

Confidential, Sacramento, CA

Techno - Functional Consultant

Responsibilities:

• Prepared Technical Design document (MD70) and Developed Custom check printing using XML Publisher.
• Custom auto lot creation for Manufactured and received Inventory Items.
• Design and Development of CV40 and custom program Supplier data conversion
• Design and Development of CV40 and Developed customer Conversion program.
• Validation of converted data and providing statistical info to users.
• Running validation SQL queries requested by Quality control person.
• Running validation SQL queries requested by System Validation person.
• Prepared Technical Design document(MD70) and Developed Bank statement Import
• Design and Development of Positive Pay (bank statement Export).
• Post Implementation support in Financials.
• Attended month end closing issues.
• Purchase order, Invoice, Pick slip, bill of lading reports using XML Publisher.
• Created Custom Discoverer reports in AP and AR.
• Installed and trained Discoverer 4i admin and Desktop for users
• Customized Account Generated workflow for Fixed Assets.
• Customization includes Barcode Label printing using loftware software and Zebra printers.
• Designed and configured Approved Raw materials, Finished Goods, Sample and other Bar code Labels using Loftware Print server.

Environment: ORACLE9i, SQL, PL/SQL, Discoverer 4I, Reports 9i, Forms 9.i, Oracle Applications (11.5.10.2), GL, AP, AR,PO, OM, WIP, INV, CST, FA, Workflow Builder 2.6.3, XML Publisher 5.5 and 5.6

Confidential, Sacramento, CA

Techno - Functional Consultant

Responsibilities:

• Responsible for day-to-day maintenance issues in Inventory, Shipping, BOM, WIP, WMS, OM, AP, AR, GL, FA, Barcode, Mobile apps issues.
• Development of technical designs and code for new requirements.
• Tuning existing financial discoverer and oracle reports.
• Supporting month end closing issues.
• Providing customer requested information like orders, payments, invoices and equipments.
• Working closely with Business Analysts and User's to resolve issues, new requirements and Enhancements.
• Design and Development of 2005 Physical Inventory (PI) Interface.
• Design and Development of many Discoverer reports in GL, AR, AP, PI, INV, OM.
• Designed, documented and developed Interface between ADI Time Management system and Oracle Time and Labor for employee time tracking.
• Designed and Developed custom forms and reports in MIN-MAX Inventory project
• Customized TASQ Order workflow.

Environment: ORACLE9i, SQL, PL/SQL, Discoverer, Reports 9i, Forms 9.i, Oracle Applications, GL, AP, AR, BOM, WIP, INV, CST, FA.,ADI Workflow Builder