SUMMARY:

• Hands - on Techno Functional
• Over 15 years of experience in Oracle Financials and/or Oracle Manufacturing space
• Well conversant with the following process/business flows in Oracle ERP

• Order to Cash
• Make to Order
• Make to Store
• Fulfillment and Shipping
• Interfacing to AR
• Create Accounting
• GL Posting
• Revenue Accounting
• Financial Statement Generator
• Lockbox
• Interface to AP
• Procure to Pay
• Depot Repair
• Transportation Management System

• Did functional implementation with CEMLI in the following Oracle ERP space
• Manufacturing: INV, ENG, BOM, OM, WIP, CST, QA/QM, Ware House Management/ Data Warehousing, MRO
• Distribution and Sales: PO, INV, OM, TMS, Advance Pricing
• Very good exposure in GL/AR/AP modules
• Well conversant with MS Office suite; has scripting experience using Excel VB Script and merging in Word.
• Well Conversant with ADOBE Java Scripting
• Discovery, Design, Setup
• Used Oracle AIM methodology extensively to identify requirements. Well conversant with BP, MD, TE and CV documents.
• Conducted/Attended multiple conference room pilot (CRP) featuring canned functionality
• Rigorous Mapping and GAP analysis (Upstream and Downstream)
• Used Oracle Designer (long back)
• Identifying Conversion and Migration requirements and AUTO/SCHEDULED conversions
• Identifying CEMLI (Customization, Extensions, Modifications, Localization and Interface)
• Creating and Managing Testing Scenarios
• Creating and Managing End User Training
• Exclusively worked on a Project involving Cash Managements, Assets & Liabilities transaction Process flows
• Designed and developed complex CEMLIs using
• Oracle Forms Personalization: Trapping user events and creating messaging routines for validations
• Oracle Forms (Master & Detail): New Master/Detail form to support additional data entry what is not possible using ERP canned objects
• Using OBIEE 11g (as part of Fusion Application)
• Creating and manipulating Metadata
• Creating & manipulating Logical SQL and Physical SQL
• Getting Data from multiple sources
• Using BI Publisher and BI Server mechanics
• New Dashboard using Analytical and Hierarchical Data
• Using Oracle Reports & Discoverer (prior to using BI Pub)
• Self-made PLSQL Reporting for better messaging functionality and avoiding middle tier
• Using ODBC data in MS Excel and programming using VB in excel to manipulate data
• Using Mail merge technique to generate custom bills (prior to using BI Pub)
• Using ADOBE JSP and creating interacting PDF. Really useful for Legal documents implementation.
• Using custom PL/SQL triggers, functions and procedures
• Calling Oracle APIs
• Using SQL to write Adhoc queries
• Using SQL*Loader to automate loading data into custom interface tables and run API at load complete to generate receipt transactions
• Using Shell Scripting (Unix)
• Running custom concurrent routines from backend. Also used for piping.
• Creating and Modifying Oracle Workflow to integrate with new events and creating alerts and process steps

PROFESSIONAL EXPERIENCE:

Confidential

Other Software: MS Office Suite, Barcode Drivers, Printer Drivers, ACE Projects

Development Tools: SQL*Plus, Toad, Oracle Forms and Reports, OBIEE 11g, SQL*Loader, PL/SQL, Oracle Workflow Builder

ERP Space: GL, AR, AP, Cash Management, Requisition and PO with Approval Hierarchy, ASCP, INV, BOM, WIP, OM

Responsibilities:

• Supporting their Make to Store cycle. Confidential purchases raw materials form different part of the world along with the original iomin component. Confidential Gets order from various parts of the world. Planning/Forecasting and storing is one of the most critical components of their business.
• Confidential
• Supporting the following flows:
• Flow Demand to build
• Flow Design to release
• Flow Sub-Ledger Journals to Post
• Flow Supplier Invoice to Payment
• Flow Project Execution to Invoice
• Posting Invoices to A/R and G/L
• Creating Credit Transactions in A/R
• Cash Application
• ISOLATEK
• Supporting
• Order to Shipment, Order to Drop Shipment, Customer Return to Credit, Customer Return to Replacement
• Wall to Wall Accuracy - Physical Count, Plan to Replenishment
• Source Requirements to Agreement, Requisition to Receipt - Direct, Requisition to Receipt - Indirect
• Forecast to Plan, Plan to Schedule, Schedule to Build - Discrete, Product standard Costing to Inventory Revaluation
• Lead to Opportunity for Telesales, Service Request to Resolution for Teleservice
• Scoping, Design, Estimation / Designing Solutions and CRP / Drafting and Managing Project Plan(s)
• Maintaining Task Assignments using ACE Projects

Sr. Consultant

Confidential, Elizabeth, NJ

ERP Space: GL, AR, AP, Cash Management, Lockbox, Requisition and PO, INV, FSG, BI Publisher, Collection Workbench, Oracle Grants and Projects

Responsibilities:

• SFA Audit, Financial Audit, IRS queries
• Extraction and Analysis of Student Receivables
• Creating Outstanding Debt details for Students to sell AR to Collection Companies
• Closing all Open students ledger - R2T4 Calculations
• Asset Depreciation, Asset Marketing for Auction-able items
• Processing and creating Auction Data in GL, Closing Out Vendor
• Equity Distribution, Closing Periods, Closing GL

Sr. Consultant / VP Operations

Confidential, Elizabeth, NJ

ERP Space: GL, AR, AP, Cash Management, Lockbox, Requisition and PO, INV, FSG, BI Publisher, Collection Workbench, Oracle Grants and Projects & HR

Development Tools: SQL*Plus, Toad, SQLServer, Excel VBA, Word VBA, Adobe JavaScript, Oracle Forms and Reports, OBIEE 11g, SQL*Loader, PL/SQL

Other Software: MS Office Suite, Quick Books, ACE Projects

Responsibilities:

• Implemented INV, AR, AP, GL, Requisition, PO, Cash Management, Grants and Projects, Collections and HR
• Scoping, Design, Estimation. Designing Solutions and CRP.
• Drafting and Managing Project Plan(s). Resource engagements
• Maintaining Task Assignments using ACE Projects
• Setups and Documentations
• Data fields mapping between Oracle data structure versus custom staging tables and then automate data migration from third party tables using Oracle APIs
• Identifying & Developing CEMLIs
• Rigorous Mapping and GAP analysis (Upstream and Downstream), Conversion/Migration script development. Writing various documentations - BR / MD / CV/ TE and User Process Documents
• Deployment from Test to Production environment
• Post GOLIVE support
• Institution Line of Credit Management
• Return to Title IV Calculation
• 90/10 Calculation
• Confidential Reporting, Regulatory Reporting, Default Management
• Managed operations and owned following department / process
• Financial Aid, Accounting, HR, Student Services, Student Records, Inventory/Store, Compliance

Sr. Consultant

Confidential, Atlanta, GA

ERP Space: GL, AR, AP, Cash Management, Lockbox, Requisition and PO, INV, FSG, BI Publisher, Collection Workbench & HR

Development Tools:SQL*Plus, Toad, Oracle Forms and Reports, OBIEE 11g, SQL*Loader, PL/SQL, Barcode Reader, Oracle Workflow Builder

Other Software: MS Office Suite, ACE Projects

Responsibilities:

• Implemented Transport Management and Logistics using
• Rigorous Mapping and GAP analysis (Upstream and Downstream)
• Order Management, Oracle Logistics, Inventory, Advance Pricing and various CEMLIs
• Changing OM Workflows
• Setting up ATP
• Creating appropriate Order Types and Ship Methods for Truck, Rail and Ocean
• Changing existing DB Triggers, Form Personalization, new Lookup Codes for Ship-to-Countries, creating custom forms
• Automate population of Ship Method based on a destination
• Automate calculation of Ocean Freight based on a Final Destination
• Automate calculation of freight based on the INLAND BOL Deliver TO data
• Calculate Freight Cost / Fuel Surcharge using the Shipping Weight for Slurry Orders automatically.
• Implementing preferred Carrier for a Customer
• Implementing getting Shipment Master Extract to get shipment data from Order header and Lines
• Workflow associated with Existing Orders and New Orders changed to avoid re-rating principle and force re-price at shipping
• Implemented CEMLI to trap error and hold using bar code reader
• Implementing Oracle Reports and BI Publisher for reporting
• Conversion/Migration script development
• Setup and Documentations (BR, CV,MD, TE)
• Implemented Inventory management, Purchasing with Approval Hierarchy, RMA processing, Oracle Financials, Lockbox and Cash Management using
• INV,GL, AR, AP, PO, Lockbox, CE
• Custom Revenue Recognition
• Setup and Documentations (BR, MD, TE)
• Writing Test Scripts and results
• Deployment from Test to Production environment
• Scoping, Design, Estimation / Designing Solutions and CRP / Drafting and Managing Project Plan(s)
• Maintaining Task Assignments using ACE Projects

Sr. Consultant

Confidential, Atlanta, GA

ERP Space: GL, AR, AP, Cash Management, Lockbox, Requisition and PO with Approval Hierarchy, ASCP, INV, BOM, WIP, FSG, BI Publisher, Collection Workbench, & HR

Other Software: MS Office Suite, Barcode Drivers, Printer Drivers, ACE Projects

Development Tools: SQL*Plus, Toad, Oracle Forms and Reports, OBIEE 11g, SQL*Loader, PL/SQL, Barcode Reader, Oracle Workflow Builder

Responsibilities:

• Customer Invoice to Cash using, Supplier Invoice to Payment (w/ XpenseXpress), Sub ledger Journals to Post (REQUIRED), Period End Close to Financial Reports (REQUIRED)
• Order Management
• Order to Shipment, Order to Drop Shipment, Customer Return to Credit, Customer Return to Replacement
• Inventory Management
• Wall to Wall Accuracy - Physical Count, Plan to Replenishment
• Purchasing Management
• Source Requirements to Agreement, Requisition to Receipt - Direct, Requisition to Receipt - Indirect
• Discrete Manufacturing
• Forecast to Plan, Plan to Schedule, Schedule to Build - Discrete, Product standard Costing to Inventory Revaluation
• Sales & Service
• Lead to Opportunity for Telesales, Service Request to Resolution for Teleservice
• Designing Solutions and CRP / Drafting and Managing Project Plan(s) / Maintaining Task Assignments using ACE Projects

Confidential, Long Island, NY

ERP Space: GL, AR, AP, Cash Management, Requisition and PO with Approval Hierarchy, ASCP, INV, BOM, WIP

Solution Design and Development: Project Management

Development Tools: SQL*Plus, Toad, Oracle Forms and Reports, OBIEE 11g, SQL*Loader, PL/SQL, Oracle Workflow Builder

Other Software: MS Office Suite, Barcode Drivers, Printer Drivers, ACE Projects

Responsibilities:

• Owned the Project Plan.
• Used ACE Projects to manage tasks properly.
• Used self-made Project Meeting and Status Monitoring system (excel based) to make sure all the items are addressed and proper resource is allocated.
• Used a self-made Vacation Calendar to in corporate Client Resource Vacation Calendar and Core Resource Tile/OFF calendar.
• New CRP for testing Groups, Identifying milestone dates and estimating additional resource requirement.
• Issue was in proper testing planning. Owned the test scripts and conducted testing with users.
• Mostly worked with ENG Module.
• Managing Oracle TAR to make sure this functionality works. Issue with prior patches. Create Accounting wasn’t affecting distribution accounts.
• Resolving Invoice holds functionality
• Posting Invoices to A/R and G/L
• Creating Credit Transactions in A/R
• Cash Application

Confidential, CT

Other Software: MS Office Suite, ACE Projects

Development Tools: SQL*Plus, Toad, Oracle Forms and Reports, OBIEE 11g, SQL*Loader, PL/SQL, Oracle Workflow Builder

ERP Space: GL, AR, AP, Cash Management, Requisition and PO with Approval Hierarchy, ASCP, INV, BOM, WIP

Responsibilities:

• Rigorous Mapping and GAP analysis (Upstream and Downstream)
• Conversion/Migration script development
• Vanilla upgrade from 8.0.3 to Release 11
• CRP Phase 1 to identify existing functionalities worked
• Vanilla upgrade from Release 11 to Release 12
• CRP Phase 2 to identify existing functionalities worked
• Identified personalization and customization and Developed for Release 12 environment
• CRP Phase 3 - Identified new functionalities offered by release 12
• Created Test Scripts
• Creating User documentations
• Deployment from Test to Production environment
• Drafting and Managing Project Plan(s) / Maintaining Task Assignments using ACE Projects

Sr. Consultant / Engagement Manager

Confidential, New York, NY

ERP Space: GL, AR, Cash Management, FSG

Development Tools: SQL*Plus, Toad, Oracle Forms and Reports, OBIEE 11g, SQL*Loader, PL/SQL

Other Software: MS Office Suite, ACE Projects

Responsibilities:

• Rigorous Mapping and GAP analysis (Upstream and Downstream) - understanding how Confidential wanted to handle revenue recognition on
• Even quarterly payments
• Un-even quarterly payments
• Guarantee with no Advances
• Contract Executed after 1st period
• Contract Executed before 1st period
• 3rd Party (Cash Basis)
• All types of recognition process were successfully implemented with multiple CRP
• Implemented the Fadel’s software to get the right data in the IFACE tables so that the recognition process takes place depending upon which Accounting Rule is passed.
• An accounting rule was set up for each recognition process in addition to changes in Invoicing Rule. Also, GL Date, Rule Start Date and Invoice date are changed accordingly to support every recognition process.
• Setup and Documentations (BR, CV, MD, TE)
• Writing Test Scripts and results
• Deployment from Test to Production environment
• Scoping, Design, Estimation / Designing Solutions and CRP