SUMMARY

• Over 9+ years of diverse experience in the field of SCM Functional experience in Oracle e - Business Suite.
• In-depth Knowledge of the Retail, financial, mortgage and banking Industry and its processes.
• Rich experience in ERP product - Oracle 11i - in Multi-Org environment and in modules comprising of experience in me-Procurement, Purchasing (PO), Oracle Order Management (OM), Inventory (INV), BOM, WIP, AOL and System Admin and integrated custom applications.
• Experience with Markview 170 Systems
• Experience with Oracle User Productivity Kit (UPK) and Oracle Tutor
• Experience in Planning modules of Advance Supply Chain Planning (ASCP), Collaborative Planning, Production Scheduling, Mobile Supply Chain Planning (MSCA) and Advanced Planning Command Center (APCC)
• TEMPHas experience in Implementation and Production support
• Having enriched experience as Business Requirements gathering, Gap analysis, solution design, configuring, setups, Test Plan Preparation, Unit Testing, System Integration testing, and production support in supply chain and distribution industries
• Experience and noledge on AIM methodologies.
• Project Management & Coordination in multinational and multi-cultural environment.
• Effective communicator and energetic team player with excellent business and interpersonal skills.
• Heavily involved in brainstorming sessions, GAP analysis, Root Cause Analysis, Risk Analysis, walkthroughs, meetings, and JAD sessions with all stakeholders in the project.
• Strong experience in interviewing End-Users, Internal and External Stakeholders, Business Owners and Subject Matter Experts to gather business requirements.
• Specialized in creating UML Diagrams like Use Case, Activity and data flow diagrams using Rational Rose and MS-Visio.
• Experienced working with Developers and Quality Analysts both onsite and offshore teams.
• Worked on different application solutions including client server application and web based applications.
• Worked with the QA team in conducting System Integration Testing (SIT) and supported the User Acceptance Testing.
• Experience in QA procedures, Test Plan, Test Scripts and working with multiple testing environments.
• Extensive noledge of generating reports by executing SQL queries against different databases such as Oracle, MS Access.
• Used web-based test management tools such as Mercury Quality Center to link requirements and tests; execute tests and report/monitor bugs until completion. Generated execution report, defect report and traceability matrix by using Quality Center.
• Experience in finance industry and in the ETL process.
• Extensive experience in writing correspondence, project status reports, e-mails, etc. to keep executive staff and team members apprised of goals, project status and resolving conflicting issues.
• Excellent judgment skills in identifying areas of high-risk, critical business areas, early in an application and prioritize my tasks to focus my efforts when time is limited.
• Highly motivated team player with good communication and interpersonal skills.

TECHNICAL SKILLS

Software: Oracle 11i

Modules: me-Procurement, purchasing (PO), ), Advance Supply Chain Planning (ASCP), Oracle Order Management (OM), Costing (CST), Inventory (INV), BOM, WIP, Markview 170 Systems, Fixed Assets (FA), Cash Management (CM), Costing and Inventory (INV).

Expertise: General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Purchasing (PO), Inventory (INV)

Operating System: MS-Windows & DOS, Mac OS

Productivity Packages: MS Office, MS-Access, PowerPoint, MS Outlook

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

SCM/Planning Functional Consultant

Responsibilities

• As a SCM Functional consultant implemented SCM modules: me-Procurement, Purchasing (PO), Oracle Order Management (OM), Advance Supply Chain Planning (ASCP), Sourcing, Costing (CST), Inventory (INV), BOM, WIP,
• Performed Requirement and Gap analysis. Configurations and Setups me-Procurement, Purchasing (PO), Oracle Order Management (OM), Advance Supply Chain Planning (ASCP), Sourcing, Costing (CST), Inventory (INV), BOM, WIP
• Worked on the Oracle OM module - setting up the transaction types, credit check rules, order and line workflows, defaulting rules, processing constraints, etc.
• Worked on the setups Sourcing module - defining of the approved supplier lists, Blanket agreements, sourcing rules, etc.
• Worked on Oracle ASCP to setup Constrained plan options, setup for multi node instance, configured the planning flex fields, worked on the ODS Load process, defined the plans and plan options, worked on the ASCP Collection process.
• 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.
• me procurement: 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
• Implementation and support of me-Procurement, Sourcing, Purchasing (PO), Advance Supply Chain Planning (ASCP), Oracle Order Management (OM), Inventory (INV), BOM, WIP Module
• Provide support/enhancements for the existing Oracle and Discoverer Reports (across OM, INV and PO) 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.2.4 Rollout for US, Canada, EMEA and Middle East me-Procurement, Sourcing, Costing (CST), Purchasing (PO), Advance Supply Chain Planning (ASCP), Oracle Order Management (OM), Inventory (INV), BOM, WIP, Markview 170 Systems

Confidential, San Diego, CA

Oracle SCM/Planning Functional Consultant

Responsibilities

• As a Functional consultant, worked on Implementation of Oracle Applications, me-Procurement, purchasing (PO), Oracle Order Management (OM), Inventory (INV), Advance Supply Chain Planning (ASCP), Costing (CST), Sourcing, BOM, WIP Security features including System Administration (SA) activities all processes of project life cycle are documented as per Oracle Application Implementation Methodology (AIM).
• Conducted study on current business process and evaluated the existing system maintained.
• Performed all the setups for the O2C Business flow including me-Procurement, Purchasing (PO), Oracle Order Management (OM), Inventory (INV), Advance Supply Chain Planning (ASCP), Sourcing, Costing (CST), BOM, WIP modules.
• Worked on the setup of the Approval Hierarchies, Document Types, Matching rules, PO Options in Purchasing Module
• Gathered and analyzed business requirements including process reengineering. Documented functional requirements pertaining to financial modules and security features.
• Worked on the setups of the Sourcing module
• Involved in troubleshooting issues in the Sourcing rules in Sourcing module.
• Defined the Approved Supplier Lists in Sourcing module.
• Worked on the ASCP Setups - setting up the planning flex fields, defining the plan options, setting up constraints for the plan, worked on defining the demand and supply sources, worked on tweaking the plan attributes for tuning the plan, etc.
• Setup Oracle Assets Function security in Enterprise Asset Management (EAM)
• Worked on the Costing Module to Update Standard Costs, rolling up Assembly Costs, Updating Pending Costs to Frozen Standard Costs, Setup Inventory Standard Costing method.
• CRP and user acceptance test (UAT) were carried out for the above modules. Trained the end users and resolve problems during UAT.
• Prepared whole data conversion approach and cutover strategy for balances from their legacy system to Oracle Application.
• Assisted the Client with Production Data Conversion, Reconciliation and Execute tasks for Go-Live activities.
• Developed and tested the financial statements as per requirement using Financial Statement Generator (FSG)
• Coordinated with technical and DBA team for resolving the customizations issues and documenting them
• Provided functional support to other teams and troubleshooting and maintaining the system

Environment: Oracle Apps 12.1.1 (me-Procurement, Costing (CST), Advance Supply Chain Planning (ASCP), Purchasing (PO), Oracle Order Management (OM), Inventory (INV), BOM, WIP), Toad, Discoverer, Solaris 2.6.

Confidential, San Diego, CA

SCM Functional Analyst

Responsibilities

• As a SCM Functional Analyst, Supported Procure to Pay Process Release 12.1.3
• Lead Conversions & Enhancements for OM, Costing (CST), Advance Supply Chain Planning (ASCP), PO and INV module
• Worked on the setup of me-Procurement module including the setting up of Catalogs, Categories and Uploading Items into me-Procurement, Punch-out’s both transparent and direct.
• Worked on the setup of Purchasing Options, Financial Options and Document Types in PO Module.
• Worked on the configuration of the Intercompany transactions using the Internal Requisition Internal Sales Order (IRISO) process.
• 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 PO, INV, Costing (CST), Advance Supply Chain Planning (ASCP), me-Procurement, AP modules from scratch and simultaneously created BR100 documentation for the setups.
• Worked on the Localizations for Europe (Netherland, Spain, Italy), UK, Mexico, Latin America, Japan, China
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Completed Multi-Org configuration by creating a new Organization Structure for WVI (World Vision International) by creating new Business Group, Legal Entity, Set of Books and Operating Unit.
• Conducted Regression testing to examine the effects of a new Org on the previous Org.
• Conducted Multi-Org Revert Testing to create an effective Revert Plan for WVI, as and when required.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided with useful training to the users in Order to Cash, OM, Costing (CST), Advance Supply Chain Planning (ASCP)

Confidential San Diego, CA

SCM Functional Analyst

Responsibilities

• As a SCM Functional Consultant implemented the Order to Cash Business flows including OM, INV and Pricing
• Performed Requirement and Gap analysis.
• Configurations and Setups for OM, Costing (CST), Advance Supply Chain Planning (ASCP) modules
• Worked on the setups of Costing (CST) module
• 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 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.
• 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
• Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.

Confidential, CA

SCM Functional Analyst

Responsibilities

• Gathering business requirement by having detailed discussions with business team.
• Functional Specification writing, Reviewing Master business requirement details, Gap analysis.
• Worked on the Localizations for Mexico and India.
• Review other functional Specifications.
• Worked on the set ups all the modules in Order to cash cycle.
• Preparing various functional requirement and propose high-level design details for programs to keep data in Costing (CST), OM and INV
• Involved in setups, requirement gathering and functional specs preparation for Oracle incentive compensation.
• Prepared high-level technical design document.
• Coordinated and lead the entire phase of the project which included initial operations analysis, business process re-evaluation, conversions, customizations, testing, training, documentation and implementation of modules.
• Interacting with upper management to identify the business process and needs and with end users to identify their requirements.

Environment: Oracle 9i, Oracle Financial Applications 11i (11.5.10.2), AR, me-Procurement, PO & AP.

Confidential . Los Angele, CA

SCM Functional Analyst

Responsibilities

• Provided analysis, design, installation, setup and rollout of Oracle 11i Order Management Logistics, Manufacturing module and established proof-of-concept.
• Setups included Multi Language, Multi Reporting Currency, Multi Organization
• Worked extensively on TCA architecture and was involved in migration of customers from various legacy systems into Oracle TCA architecture.
• Coordinated and lead the entire phase of the project which included initial operations analysis, business process re-evaluation, testing, training, conversions, customizations and documentation and implementation of modules
• Developed interfaces and data conversion programs for applications
• Addressed operational problems, concerns, and questions posed by users
• Interacting with upper management to identify the business process and needs and with end users to identify their requirements
• Setting up profile options values (standard and custom), set up for OM, AR and PO.
• Involved in Inventory org setups.
• Was involved in the 4-D methodology (Discover, Design, Develop and Deploy).
• Preparing technical specifications for the sub modules like (Customers, OM, Shipping, Interfaces, etc.).
• Implementation methodology documentation including technical specs and functional specs.
• Liaising with client key users and technical team, conducting CRP/testing
• Ensuring order Processing/Booking (OM) during month/quarter/year end and resolving inter-company accounting issues.
• Responsible for transfer of data from External systems like Web, EDI, PO to OM.
• Responsible for transfer of data from OM to AR and ensuring no records are stuck in the interface.
• Resolving issues related to flex fields and sysadmin setups.
• Design and development of custom reports and FSG reports.
• Design of custom forms and extensions for OM and PO module.

Environment: Oracle 8i, Developer 2000(6i), PL/SQL, SQL, Oracle Financial Applications 11i(11.5.10.1), AP, AR, PO, OM (Functional & Technical - AOL, Sys admin), SQL Net, Oracle Workflow, Oracle Discoverer, Designer 2000, TOAD, SQL Loader, Unix.