SUMMARY:

• Oracle e - Business Suite Functional expert with around 8 years of IT Experience including 6 years in-depth experience in design, support and implementation of software applications Including experience as a Functional Consultant
• Extensive experience in the Functional aspects of Oracle Applications 11i, Release 12.0.3 and 12.1.1 and execution of 4 full lifecycle Oracle Applications implementations including the exposure to e-Business suite Release 12, numerous Application Support projects, RICE implementations, upgrades, with high level of Customer Satisfaction.
• Worked across different modules of the Value Chain Planning and Supply Chain Management suite including INV, Quoting, i-Procurement, OM, Advance Pricing (QP), Advance collections, Credit Management, PO, Costing, WMS, SLA, AP, AR, combined with a unique combination of their integration with other modules like Advanced Supply Chain Planning, Advanced Pricing, Rapid Planning, Shipping and Oracle Discoverer.
• Strong understanding of different methodologies (Agile, Waterfall and Iterative), finance and risk models, operation (six sigma, supply chain services), marketing and engineering.
• Excellent communication skills, managed projects with C Level executives and open source engineers.
• Extensive experience with Sub Ledger Accounting module - defining the Accounting Method Builder, setting up events and event classes, account derivation rules, SLA Accounting methods, Accounting conventions, Accounting Setup Manager.
• Experience with the return process in Order Management, Reverse Logistics flow and integration to Depot Repair.
• Extensive experience in CRM Modules of Service Contracts and Install Base.
• Extensive experience with the Order to Cash and Procure to Report business flows.
• Experience in high volume, high risk, high visibility and low downtime production systems.
• Tools used on projects: MS Office, MS Project, Visio, MySQL and PHP, statistics and risk management modeling.
• Hands on project manager, gathered requirements to develop architecture, logic and data models, used data for project estimations, sign offs and change request approvals.
• Extensive experience with Managing Off Shore and On Site teams.
• Experienced in desktop applications, hosted solutions on server farms and disaster recovery centers.
• Developed several Business Requirement Documents (BRD), Functional Specification Documents (FSD) and Financial System Configurations
• Executed critical projects as Business Analyst, Functional Consultant, Onsite Coordinator, Designer on Functional & Techno-Functional roles.
• Extensive business area experience & have received great commendations at Client site for excellent interpersonal & Client interaction skills.
• Adept in reviewing and analyzing the 'as-is' business scenarios, processes and activities, evaluating end user requirements and custom designing solutions and troubleshooting any problems in the process.
• Demonstrated abilities in mapping business requirements and translating these requirements into Oracle applications functional specifications and detailed test plans and custom designing solutions.
• Strong communication & leadership skills with an ability to interact with business users and lead business projects.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

WMS Functional Consultant

Responsibilities:

• As a Functional Consultant implemented the Procure to Pay Business flows including Quoting, Rapid Planning, iProcurement, iSupplier, OM, Shipping, Advance Pricing and INV, PO, AP and Cash Management modules.
• Worked in the configuration and Setups for WMS contracts
• Performed Requirement and Gap analysis.
• Configurations and Setups for i-Store, iProcurement, iSupplier, Service Procurement, Rapid Planning, Shipping, INV, Order to Cash and Cash Management
• iProcurement: Designed workflow customization and punch-out catalog. Define requisition template and system profile options. Extract catalog and item data. Setup of approval hierarchy, approval groups and approver assignment
• Worked on the Setups of AR, AP, GL, FA, CM, i-Expense and worked on the integration of the modules with AR and AP.
• Created FSG Financial Reports critical to company’s business process.
• Worked on Oracle ASCP Module - Defining the Phantom Routings, Utilization Efficiencies, Routing Affectivities’, Co-Products, Hard and Soft Pegging, Common supply netting, Payback demand and supply, generating planned orders, WIP Mass load and requisition interface, flow line scheduling, non mrp planned safety stock, etc.
• Worked on the BOM setups - defining the various Bill Types, setting up mutually exclusive options and option classes, defining the multi-level BOMs, setting up ECOs, etc.
• Worked on the Work Orders in Oracle WIP, non-standard WIP Jobs, Work Order Less Completions (WOLC), back flushing, WIP Accounting classes, etc.
• Worked on the setups of Global Order Promising (GOP), configuring the ATP Collection Data and Planned Output, Maintenance as a source of supply, supply part condition, defining the instances, ATP Item attributes, Transit Lead Times, Product Family ATP, etc.
• Responsible for training the end users on the new processes and facilitated on-the-job training.
• Performed Item Mapping from legacy system and vendor catalogs into Oracle - to define new items and categories.
• Worked on Oracle Quality data module including definition, data collection, data management
• Worked on the iSupplier portal setups - defining the supplier registration process, supplier creation and approval process, etc.
• Performed all of the setups of Product Data Hub module including the setups of Item Catalog Administration, Catalog Administration, Change Management Administration, Configuration Management, People and Roles, Attributes and Functions, Item Catalogs, Inbound Product Data Synchronization and Data Quality Management
• Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Worked on setting up the Modifiers, Qualifiers and Formulas in Advance Pricing Module.
• Worked on setting up the Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up the Line and Header transaction flex field in AR for Auto Invoice to work.
• Worked on the Auto Lock Box process in AR.
• Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Canada
• Pre upgrade testing and Post upgrade production live support.
• Support Production issues on a day to day basis including month end closure p1 issues
• Implementation and support of Accounts Receivables and Account Payable Module
• Provide support/enhancements for the existing Oracle and Discoverer Reports (across AP, FA, CM, and AR) and create new ones based on business requirements.
• Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex field Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options
• Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.

Environment - Oracle Applications Release 12.1.1 Upgrade from Release 11.5.10.2 Rollout for US, Canada, EMEA and Middle East AR, AP, GL, Cash Management, OM, INV, PO, Shipping, CDH, PDH, i-Store, iProcurement, iExpense, iSupplier, Rapid Planning, AOL, System Administrator

Confidential, Addison, TX

Oracle Applications Release

Responsibilities:

• As a Functional Consultant implemented the following modules: Order to Cash, i-Store, OM,, PO, Shipping, Advance Pricing, AP, AR
• Worked on the Functional mapping of data Conversions & Enhancements Quoting, OM, Shipping, Advance Pricing, AR modules
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Configured Oracle Quoting, i-Store, GL, AP, AR, Cash Management, OM, Shipping and PO from scratch and simultaneously created BR100 documentation for the setups.
• Configurations and Setups for I-Procurement, Service Procurement, iSupplier, Rapid Planning, Shipping, INV, AP and Cash Management
• Involved in developing the Process flows for the Quote to Cash and Procure to Report modules.
• Worked on the WMS Setups like Warehouse setup, Warehouse Org Setups, Locator Zones and Parameters, task type assignment rules, label formats, associating label types to business flows, receiving parameters, picking rules for warehouses, operation plan selection rules, advanced lot control, lot and serial attributes, Cartonization, Container Items, Contained Items, cost groups, cycle counts, etc
• Worked on Oracle ASCP Module - Worked on the Source and Destination instances, creating and launching plans, Generating KPIs, fixing exceptions, fixing workflow notification exceptions, running net change, defining collection strategies, collection methods, continuous and legacy collections, setting up and loading of forecasts, setting product aggregation levels, creating the routing and BOM for Make items etc.
• Worked on the setups of Global Order Promising - defining the ATP Item Attributes, ATP rules on the source instance, Transit Lead Times, Single Level Supply Chain ATP, Configuration ATP, Demand Class ATP, Data Collection, etc.
• Performed all of the setups of Product Data Hub module including the setups of Item Catalog Administration, Catalog Administration, Change Management Administration, Configuration Management, People and Roles, Attributes and Functions, Item Catalogs, Inbound Product Data Synchronization and Data Quality Management
• Setup the Approval Hierarchies in Oracle Purchasing and Shipping module including setups of Approval Hierarchies, Purchasing options, Matching etc
• Inventory - Worked on the setups of the Inventory module - defining the Master and Child Orgs, Defining the sub inventories, locators, lots, serialization, planning (Min Max and Re Order Point), Cycle Counting, Physical Invetory, etc.
• Involved in troubleshooting issues on Auto Invoice Import Program.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided with useful training to the users in GL, AP, OM, INV and PO Modules.
• Created FSG Financial Reports critical to company’s business process.
• Worked on creation of MRC Setup by defining primary Set of Books and Reporting Set of Books in Oracle GL.

Confidential, Dallas, TX

Oracle Supply Chain Analyst

Responsibilities:

• Preparing Business Requirement Documents (BRD) with the business rules associated to archive the daily transactional data across different Operating units for nine fiscal years until Sep-2007.
• Preparing business test scripts with the business rules associated with it to test the data integrity of archived data.
• Performed all the setups for PO, Inventory, OM, Sourcing, iProcurement, iSupplier, Service Procurement modules.
• Worked on the Revenue Recognition Process in Oracle AR module.
• Worked with the Business team to baseline the ‘As Is’ Process and derive ‘To Be’ flow.
• Worked on the entire upgrade strategy to upgrade the application footprint from 11.5.10.2 to Release 12.1.1
• Pricing Business Requirement Study and designed / documented Functional Specification.
• Identification of Gap & put collaborative effort with the Technical team to address the same thro Technical Specification.
• Facilitated Pricing & IT Business to obtain clarity on the Business Rules and capture the same.
• Flow Testing for Modules (AR, AP, GL, OM and Shipping) to make sure flow is working without any issues.
• I-Expense – Setup iExpense for Connected and Disconnected expense reporting including setting of several expense reporting templates, setting up the Credit Card interface, implementing P-Card functionality in i-Expense, setting up of Per Diem and Mileage, Setting up iExpense to support Multi Currency, setting up Audit Automation, Setting up of Expense Report Summary client extension, etc.
• Conducting Pre Project Review & Post Project Review.
• Providing Post Implementation support
• Worked for the Category & Mapping data migration to meet the go alive deadline.
• Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
• Assisted Business for Business Acceptance Testing and obtain Sign off.

Environment: Order Management, Order to Cash, ASCP, GOP, Shipping,, WIP, BOM PO, iProcurement, iSupplier, iExpense, Sabrix Tax Engine, Accounts Receivables, WMS, Shipping, Inventory, Purchasing modules

Confidential, TX

Distribution Functional Consultant

Responsibilities:

• Defining Flex field, Profile options, System parameters, Document Sequences
• Application support and Troubleshooting Workflow issues related to Order Management
• Worked on both CTO and ATO Models.
• Troubleshooting CSR (Customer Sales Representative) calls for Oracle Quoting module including identifying issues related to CFD’s (Customer Facing Documents).
• Worked on setting up the warranty contracts in Service Contracts.
• Worked on configuring Install Base to capture Reseller, End User and Distributor information for each Instance item.
• Worked on the Setups and Configurations of OM, PO, Order to Cash, AR, AP, GL, FA, CM, ASCP, WIP, BOM, iProcurement and iSupplier modules and worked on the integration of the modules with AR and AP.
• Worked on SABRIX Tax Engine Setups and worked on integrating it with Oracle e-Business suite.
• I-Expense – Setup iExpense for Connected and Disconnected expense reporting including setting of several expense reporting templates, setting up the Credit Card interface, implementing P-Card functionality in i-Expense, setting up of Per Diem and Mileage, Setting up iExpense to support Multi Currency, setting up Audit Automation, Setting up of Expense Report Summary client extension, etc.
• Set up Transaction Types, Applying & Releasing Holds, Credit Checking
• Advanced Pricing, Price List, Pricing Agreements, and Pricing Attributes
• Defining Modifiers, Qualifiers, GSA Price List, Pricing Formula
• Defining Standard, Internal, RMA and Drop shipment Orders
• Define Pick Release, Pick Release rules, Shipping Parameters
• ATO & PTO Models, ATP Checking, Availability & Reservation
• Worked with business users in deciding and designing new Inventory Org. from new acquisitions.
• Worked on the Revenue Recognition Process in AR Module, setting up Deferred Revenue Rules, Service Revenue Rules, Etc.
• Worked on Invoice Conversion during new company acquisition.
• Coordinated CRP and UAT testing with business users.
• Conducted user training for acquired company's employees.
• Solved day-to-day production issues for new acquisitions.
• Worked on interface design for GETPAID (A.R. erp system) integration.
• Worked on mapping from Oracle to GETAPID application.

Environment: Order Management, Order to Cash, WIP, BOM, WIPInventory, i-Procurement, WMS, MCA contracts, Accounts Receivables, Shipping, Purchasing, Quality module.

Confidential

Oracle O2C Business Analyst

Responsibilities:

• Worked on setup configurations including Flex Field Values & Value Sets, OM Order Types & Workflows, Pricelist Shipping/Picking parameters, Release rules, profile options, lookups & module specific shared entities & objects and their integration.
• Adept in reviewing and analyzing the 'as-is' business scenarios, processes and activities, evaluating end user requirements and custom designing solutions and troubleshooting any problems in the process.
• Defined the Approval Hierarchies, Document Security, Streamlined the Receiving process, Setup the Matching Process in Purchasing module
• Defined the Accounting Rules and Invoicing Rules in oracle AR module to drive deferred revenue as well as upfront revenue.
• I-Expense – Configured i-Expense for Multi-Currency capability, implemented Mileage and Per Diem, setup all mandatory configurations for i-Expense, Implemented p-Card functionality in i-Expense.
• Worked with end users to document the business processes & functional requirements also providing them with training materials
• Worked very extensively on understanding the proposed 100% customized business logic of the Business in building the customized solutions for Shipping on OA framework Technology based on the legacy of Oracle application E-business suite 11.5.10. All the above bases business logic was captured in OA Framework code.
• Coordinated activities with Implementation team on creating test plans & documents, conduct unit testing, correcting bugs and re-testing while meeting project deadlines. Facilitated discussions with end-users / managers to gather functional requirements.
• Worked in parallel with the client is resolving the CRP 2 and post go-live testing issues with offshore support.
• Coordinated with client through Concalls and WEBEX sessions to get the requirements and also coordinating with the technical team for fixing the issues for proper deliverables to the client.
• Provided KT sessions to the testing and the technical teams.

Environment: Order Management, AR, Cash Management, i-Expense, Purchasing modules

Confidential

Oracle SCM Analyst

Responsibilities -

• Performed solution pilot covering prototyping of “To Be” business process flows by analyzing the gap in the business requirements & then mapping it to oracle functionality
• Worked on setting up order verification holds and new customer credit check holds in OM
• Performed setups & did integration testing for split shipment, drop shipment process, RMA process, shipping parameters with Quoting, Order Management & custom made ‘Scheduling & Dispatch’ modules
• Responsible for understanding and documenting the O2C process and customizations required
• Worked on the Item Master setups including setting up of Inventory Orgs, Defining Item Attributes, Item Catalogs, Item Categories, Item Attribute controls, etc.
• Perform on-site deployment activities for oracle solution for Inventory, Order Management, Quoting modules & custom solutions including ‘Scheduling & Dispatch’.
• Performed Item Mapping from legacy system and vendor catalogs into Oracle to define new items & categories
• Performed configuration setup of custom module ‘Scheduling & Dispatch’ & facilitated user validation.
• Setting up of complete Order to Cash cycle setups from Quoting & order entry in order management to ship confirm in shipping execution module
• Involved in preparation of training material and training setup
• Conducted business workshops/trainings to explain OM and INV modules, workflows and review end-user and super-user feedback for improvements
• Developed test scripts & conducted CRP testing for the Order 2 Cash cycle
• Involved in the deployment cycle for Item Mapping, Production Cutover activities, helping the Pilot divisions to Go-Live, & user support in live phase
• Documented new procedures & Involved in training the business users on the new processes and also assisted them during their on-job training exercise