SUMMARY:

• Over 9 years of experience in Information Technology, involving in Analysis, Design Development and documenting of Oracle Applications Implementations.
• Experience in 2 Full Cycle ERP Implementation’s and various CEMLI's in 11i.
• Worked Extensively on RICE components (or CEMLI’s) (Reports, Interfaces, Conversions, API’s and Extensions) and Oracle AOL objects.
• Extensive experience in customizing and implementing Oracle applications (EBS) 11i.
• Working knowledge of Oracle Forms and XML/BI Publisher reports.
• Worked on Order to Cash, Quote to Cash and Procure to Pay business processes.
• Working knowledge of different components of Oracle RightNow and Cloud Architecture.
• Experience in Oracle R12 (Customers Online module).
• Experience in R12 financials (AP, AR, GL) and order to cash process.
• Knowledge in Manufacturing/retail, pharmaceuticals, Communication and fuel industry domains.
• Worked on Production support for full cycle implementation.
• Experience in requirement gathering and using Oracle AIM methodology (MD120, MD 70, RD60, and CV 40, CV 60 etc.) to document the requirements.
• Worked on EDI 940,945,850,855 and 810.
• Experience in Implementation, SIT, UAT testing cycles and production migration activities in test and production and post implementation support.
• Experience in working on projects individually and as part of teams as big as 30 people.
• Experience in working with business users as well as through BA’s and team leads on projects.
• Experience in Technical, Techno - functional, BA/business process consultant/functional and Production support roles.

TECHNICAL SKILLS:

Oracle Applications: 11iOracle Database RDBMS versions 9.0.2, 8.0SQL* Plus 8.0, Oracle 9i PL/SQL Language SQL* Loader 9.0.2Developer SuiteDiscoverer 4i/9i /10gOracle Reports 6i/9iSQL * Trace 8.0.x

Oracle Manufacturing Modules: Shipping, BOM, OPM, Inventory (11i and R12)OthersTCA, Oracle Internet Expenses, Oracle Eng.

VERSIONING TOOLS: Mercant PVCS, Serena, Dimension ExpressO.S

PROFESSIONAL EXPERIENCE:

Confidential, Bridgeton, MO

Sr.Oracle Application Techno-Func Consultant

Responsibilities:

• Configured setups for AR Transactions, Receipts and Customer Interfaces.
• Worked on AR Transactions Conversions process.
• Worked on End-to-End implementation of AR.
• Documented Functional requirements and Technical requirements.
• Responsible in documenting the functional and technical requirements in tracking system.
• Worked with the business users in documenting test cases.
• Experienced in customizing the AR invoice and shipping documents according to business specs.
• Worked on RICEW components.
• Worked on gathering requirements from business users.
• Maintained detailed functional and technical documentation during all phases of SDLC lifecycle.
• Responsible for documenting and tracking the status of requirements in the tracker application.
• Experienced in coding and performance tuning in Sql and PL/SQL.
• Experience with SLA timeframes .
• Worked on Order to Cash cycle.

Environment: Oracle EBS R12, OM, AR, TCA, PO,Oracle PL/SQL, Serena

Confidential, Mineral Wells, TX

Sr. Oracle Applications Techno-Functional Consultant

Responsibilities:

• Conducted a Business Process Review for Purchasing and Engineering Departments.
• Developed the functional and technical documentation based on the requirements gathered.
• Testing of the deliverables was done with the business users and timelines were met.
• Worked on Requisition’s issues involving Price lists, which were not turning into sales orders.
• Set up Burn Pattern Number in oracle for the Drafting department to streamline the process and reduce the redundancy and add the BP number to the Cut Sheet report for the Engineering Department, EDM and Shop floor’s usage.
• Worked on the Internet expense reports issues, which were failing in the Oracle Internet Expense import program.
• Created a custom menu for Order Management Super with the Projects View only responsibilities.
• Added new INCO terms to the existing Freight terms on the Purchase Order and Sales Order.
• Worked on Oracle AOL objects.

Environment: Oracle EBS 11i, Oracle Advanced Pricing, BOM, Purchasing, OM, Shipping, Oracle Internet Expenses, Oracle Engineering, TCA, Oracle PL/SQL, WINDOWS NT 4.0.

Confidential, Seattle, WA

Sr. Oracle Applications Techno-functional Consultant

Responsibilities:

• Gathered and elicited information from existing business processes and supporting systems for documentation and creation of reports.
• Developed functions and package for the calculations being used in the reports to improve performance of the reports as well as to avoid the redundancy in the database.
• FDA approved environment cGMP, cGDP and 21 CFR part 11.
• Worked on Oracle AOL objects.
• Created appropriate documentation in work assignments such as functional requirements (MD 50 and MD 70) documents and business process flows.
• Purchase Price Variance Report
• Item Usage Variance Report

Environment: Oracle EBS 11i,TCA, Oracle OPM, Purchasing, ONT, WIP, GL, AP, INV, Oracle PL/SQL, WINDOWS NT 4.0.

Confidential, Pittsburgh, PA

Sr. Oracle Applications Techno-functional Consultant

Responsibilities:

• Worked on R12Customers online governance.
• Created customers and sites in R12 customer’s online governance.OPEX and CURE:
• Worked on Production support Issues for Customers from Customers online to OPEX and to CURE.
• Worked on data mapping for R12 Customers online for Europe segment for Confidential .

Environment: Oracle EBS R12, Oracle Customers Online, Oracle PL/SQL, WINDOWS NT 4.0.

Confidential, Rockville, MD

Sr. Oracle Applications Technical Consultant

Responsibilities:

• Developed Oracle EDI interfaces 940,945,850,855 and 810.converted into X12 format using a third party vendor.
• Worked on Oracle AOL objects.
• Created reports in Oracle reports 10g
• MDD Kit Order Details Report
• Shipping exception report

Environment: Oracle 10g, Oracle EBS 11i, ONT, PO, Shipping, EDI, Oracle PL/SQL, Oracle Reports 10g,WINDOWS NT 4.0.

Confidential, Ashburn, VA

Sr. Oracle Applications Techno-functional Consultant

Responsibilities:

• Designed and developed Customer Outbound Interface (RICE).
• Designed and developed UNIX shell script to run the concurrent program through the UNIX script.
• Developed custom mail package to send the output of the packages as an attachment to the email to the users and also worked with UTL SMTP Package.
• Worked on Oracle AOL objects.

Environment: Oracle 10g, Oracle EBS 11i, AR, TCA, Oracle PL/SQL, Oracle Reports 10g,WINDOWS NT 4.0

Confidential, Miami, FL

Sr. Oracle Applications Technical Consultant

Responsibilities:

• Worked on Reports, Conversions and Interfaces (RICE) in a Full cycle ERP Implementation.Order to cash:
• Designed and developed open sales order conversion.Item Master Conversion:
• Designed and developed conversion programs for converting approx. 250,000 items for six different organizations.Oracle Discoverer 10g:
• Developed Various Custom Reports as per the client requirements using Discoverer 10g.Oracle Reports 6i:
• Gathered requirements and developed WFS Order Entry RMA Report
• Customized WFS Pick slip Report and WFS Packing slip Report

Environment: Oracle Applications (EBS) 11i (11.5.10), AR, AP, BOM, WIP, INV, GL, ONT, HR, ORACLE 9i, PL/SQL, Discoverer 10g, Oracle Reports 6i, Windows NT 4.0

Confidential, Dallas, TX

Sr. Oracle Applications Technical Consultant

Responsibilities:

• Focus on querying the data associated with purchase order lines requisition receipts and revision information to find the data issues.
• Monitor and manage programs in the Application Object Library that run all above processes transfer files to and from Oracle and have incoming files properly loaded into the Oracle Applications database (Concurrent Manager).Discoverer 10g Reports:
• AR Aging detail and Summary Report.

Environment: Oracle Applications (EBS) 11i (11.5.10), AR, ORACLE 9i, PL/SQL, Discoverer 10g, Oracle Reports 6i, Windows NT 4.0.Cricket

Confidential, San Diego, CA

Sr. Oracle Applications Tech Consultant

Responsibilities:

• Order Import conversion
• Order to Cash cycle.Discoverer 9i Reports:
• Developed discoverer reports based on Noetix views.Oracle Reports 6i Reports:
• Supplier Analysis Summary Report

Environment: Oracle Applications (EBS) 11i (11.5.9), OM, INV, PO, AR, AP, BOM, WIP, ORACLE 9i, PL/SQL, Discoverer 9i, Oracle Reports 6i, Windows NT 4.0

Confidential, Austin, TX

Oracle Applications Tech Consultant

Responsibilities:

• Oracle Discoverer Administrator and Oracle Discoverer desktopOracle Reports 6i:
• Shipment-planning report.Oracle Conversions:
• AP Closed Invoice Conversions (invoices, invoice distributions and invoice payment schedules.
• Oracle Inventory (Items Conversions)

Environment: Oracle Apps 11.5.5 (AP, AR, BOM, PO, INV, Shipping), Oracle 8.1.7, Oracle Reports 6i, Discoverer 4i.

Confidential, Pekin, IL

Oracle Applications Tech Consultant

Responsibilities:

• Was responsible for the Oracle Discoverer Administrator and Oracle Desktop
• Contract Gallons Summary Report.
• BSA System Monitoring Report.Oracle Reports 6i:
• New Business Order Report.

Environment: Oracle Applications 11i (11.5.10), AR, AP, GL, ONT, ORACLE 9i, PL/SQL, Discoverer 10g, Oracle Reports 6i, Oracle Forms 6i, Windows NT 4.0.

Confidential, Ann Arbor, MI

Oracle Applications Technical Consultant

Responsibilities:

• As per Oracle Methodology, Created CV40, CV60, RD60 and MD120 documents for the conversion and interface programs.
• Developed Financial Statement Generator (FSG) reports for users for analysis purposes.Conversions:
• Order Import interfaces
• Worked extensively in Order to Cash cycle.
• Custom conversion program for Vendors and Vendor detailsDiscoverer 9i Reports:
• Vendor Analysis Report.
• Orders On hold Report
• Customer info ReportOracle Reports 6i Reports:
• Supplier Analysis Summary Report
• Supplier Analysis Detail ReportADI Reports:
• Cost Center Summary report
• Cost Accounting Format report