SUMMARY:

• Over 7.5 years of diverse experience in the field of SCM Functional experience in retail and banking/ financial Industry.
• 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 i-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
• Has 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 knowledge 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 knowledge 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: i-Procurement, purchasing (PO), Oracle Order Management (OM), 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 Business Analyst

Responsibilities:

• As Confidential SCM Functional consultant implemented financial modules: i-Procurement, Purchasing (PO), Oracle Order Management (OM), Inventory (INV), BOM, WIP,
• Performed Requirement and Gap analysis. Configurations and Setups i-Procurement, Purchasing (PO), Oracle Order Management (OM), 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.
• Configured Taxation for US Sales Tax, Canadian GST and VAT Tax in EMEA in e-Business Tax module. Involved in the configuration of Tax Content Service, Tax Determination Services, Tax Users, Look Up Codes, TCA Geography Hierarchy, TCA Classifications for Tax, Tax Classification Codes, Tax Accounts and Tax Accounting Information.
• Worked on the setups of Markview 170 Systems AP Solution.
• Worked on the Markview 170 systems Invoice approval workflow
• Configured the Markview user profiles and setups
• Worked on the Markview to Oracle AP Interface
• Worked on the data conversion from 11i to Release 12 for all financial 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.
• Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Canada
• I 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
• Pre upgrade testing and Post upgrade production live support.
• Support Production issues on Confidential day to day basis including month end closure p1 issues
• Implementation and support of i-Procurement, Purchasing (PO), 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.1.1 Upgrade from Release 11.5.10.2 Rollout for US, Canada, EMEA and Middle East i-Procurement, Purchasing (PO), Oracle Order Management (OM), Inventory (INV), BOM, WIP, Markview 170 System

Confidential, San Diego, CA

SCM Business Analyst

Responsibilities:

• Conducted study on current business process and evaluated the existing system maintained.
• Performed all the setups for the O2C Business flow including i-Procurement, Purchasing (PO), Oracle Order Management (OM), Inventory (INV), BOM, WIP modules.
• Worked on the setup of the Approval Hierarchies, Document Types, Matching rules, PO Options in Purchasing Module
• Worked on the integration of Oracle AP with Markview 170 Systems
• Worked on the setups of Markview 170 Systems for AP Solution
• Worked on the setups of the Markview 170 Systems AP Approval workflow
• Worked on all of the setups in the AP module and worked on the integration of AP with Sub Ledger Accounting.
• Gathered and analyzed business requirements including process reengineering. Documented functional requirements pertaining to financial modules and security features.
• Created new Assets (from new acquisitions) in Enterprise Asset Management (EAM)
• Involved in troubleshooting issues on Enterprise Asset Management (EAM) Mass Additions.
• Worked on the process of retiring Asset process in Enterprise Asset Management (EAM).
• Setup Oracle Assets Function security in Enterprise Asset Management (EAM)
• Performed all setups and configurations for Revenue Recognition process in AR module, including the setups of Accounting and Invoicing rules, AR Transaction types, Auto Accounting, etc.
• 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 (i-Procurement, Purchasing (PO), Oracle Order Management (OM), Inventory (INV), BOM, WIP), Toad, Discoverer, Solaris 2.6.

Confidential, San Diego, CA

SCM Business Analyst

Responsibilities:

• As Confidential SCM Functional Analyst Supported Procure to Pay Process Release 12.1.3
• Lead Conversions & Enhancements for OM, PO and INV module
• Worked on setting up of Revenue Recognition process in AR Module
• Worked in configuring the Approval Hierarchies in PO module
• Worked on the setup of i-Procurement module including the setting up of Catalogs, Categories and Uploading Items into i-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, i-Procurement, AP modules from scratch and simultaneously created BR100 documentation for the setups.
• 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 Confidential 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 Confidential 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, AR, GL, AP, CM, FA.
• 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, San Diego, CA

SCM Business Analyst

Responsibilities:

• As Confidential SCM Functional Consultant implemented the Order to Cash Business flows including OM, INV and Pricing
• Performed Requirement and Gap analysis.
• Configurations and Setups for AR, OM, GL and AP modules
• Worked on the setup of Revenue Recognition in AR module.
• Setup of Accounting and Invoicing rules in AR module
• Defined the Auto Lock Box process in AR module
• Defined the Auto invoice process in AR 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 Confidential 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, LA, CA

SCM Business Analyst

Responsibilities:

• Gathering business requirement by having detailed discussions with business team.
• Functional Specification writing, Reviewing Master business requirement details, Gap analysis.
• 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 AR, AP, GL, 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, i-Procurement, PO & AP.

Confidential

SCM Business 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.