We provide IT Staff Augmentation Services!

Vertex 8.0 Upgrade Specialist & Oracle Gl Business Analyst Resume

Minneapolis, MN

EXPERTISE SUMMARY:

  • Over 10+ years of IT experience in Requirement Analysis, Implementation, Development, Testing & Customization of Oracle Applications R12, 11.5.10 in the modules of General Ledger, Account Receivables, Accounts Payables, Order Management, INV and Oracle Purchasing.
  • Extensive Functional experience in Vertex Series Upgrade.
  • Major focus areas include General Ledger (GL), Order Management (OM), Purchasing (PO), Oracle Quoting (ASO), Advanced Pricing (QP), Advanced Supply Chain Planning (ASCP), Sub Ledger Accounting (SLA), warehouse management (WMS), Application Object Library (AOL), Inventory (INV) and Bills of Material (BOM).
  • PO / Sourcing & AME - Purchasing configuration, PO options, PO types, PO notifications, Approval Hierarchies, Approved supplier lists, Sourcing rules, Sourcing rule assignments, requisition templates, information templates, catalogs, catalog loading, catalog management, content zones, non-catalog requests, RFI, RFQ, Sourcing templates, contract template, contract authoring, bidding, Prospective PO Approvals using AME, Supplier Mass updates using WEBADI.
  • OM / Shipping: Order types setup, defaulting rules, Processing constraints, fulfillment sets functionality, ship / arrival sets, Pricing modifier/ qualifier, pick release, ship confirm, Customer acceptance, Defaulting rules, Processing constraints, Item Order ability, Cascading of Header attributes, Mass change & Mass Scheduling
  • WMS: WMS Rules workbench, pick put away rules, Label design, Strategies, Resource management etc.,
  • INV - Inventory setups, items, Transactions UOM, move orders, Kanban Cards, Kanban Pull Sequences, Kanban Auto-replenishment, Kanban Card Sizing, Physical inventory, cycle counting, Org setup, sub-inventories, locators, Item templates, cost controls, pick rules, categories, Catalogues, DFF/KFF, calendars, Intercompany setups
  • Proficient knowledge of the project life cycles. i.e. SIT, CRP/CAT, Go-Live activities and Production support activities.
  • Experience in the preparation of Standard Operating procedures specific to Client's business process with screen prints.
  • Functional Expert at designing configurations, enhancements, conversions and interfaces which may include customizations and workarounds when the delivered functionality is not sufficient to meet the client’s business process requirements.
  • Strong expertise in study/audit of existing business process and preparation issue logs, collection of functional/technical requirements, client/user interaction, GAP Analysis, technical data mapping analysis and design of technical/functional data process flow charts
  • Profound experience in EDI Integration.
  • Collaborated EDI implementation and onboarding efforts, including definition of customer requirements and system.
  • Knowledge of EDI document types such as Purchase Orders (850), Invoicing (810), Advanced Shipment Notification (856, 857), Error Messages (824, 864), Remit Advice (820)
  • Build appropriate time lines and coordinate cross-functional teams
  • Experience inSystem Administration tasksrelated to Menus/Functions, Responsibilities and Users.
  • Good experienced in preparing Requirement Analysis Documentation, Scripts, Functional Documentation, User and Customization Documents.
  • Strong Exposure in preparation of high-level functional design documents for custom application development, Conversions, Interfaces & Reports.
  • Worked on Onsite and Offshore model projects and coordinating offshore team.
  • Adaptability to any new business environment. Excellent team player and excellent communication and inter-personal skills.
  • Experienced in developing functional requirements to support end user and business needs, develop and conduct sessions, and develop and execute system test plans and process.
  • Confident and resourceful with a willingness to learn new concepts and apply them to yield successful results.
  • Implemented Oracle Applications in all aspects of Software Development Life Cycle i.e. from executing CRP sessions, business requirement gap analysis, solution requirement gathering for custom interfaces, reports and conversions, QA Testing, Integration testing, user acceptance sign off, writing and reviewing QA, UAT test scripts and documentation.

FUNCTIONAL SKILLS SUMMARY::

Enterprise Resource Planning (ERP) Solutions Oracle Applications: Oracle Applications R12 (12.0.4/12.0.6/12.1.3/12.2.5 )/11i (11.5.9, 11.5.10.2) General Ledger, Accounts Payables, Accounts Receivables, SLA, iExpense, Payments, Purchasing, Sourcing, iProcurement, iSupplier, Contracts, Cash Management, Oracle Advanced Collection, Fixed Assets, Order Management and others.

AREAS OF WORK:

Implementation and

Oracle Applications / EBS

Implementation of Country Specific /Custom Solutions

Implementing Customizations

FULL PLC EXPERIENCE:

  • GL, MRC/MOA Implementation
  • Procure to Pay (P2P) with Purchasing, Inventory, Account Payables
  • Order to Cash with OM, AR and Advanced Collections
  • Record to Report (R2R) CM, FA, PO, GL
  • Oracle Manufacturing Modules
  • Credit Management
  • Self Service Modules including iExpenses, iProcurment, iSupplier, iPayments and iReceivables
  • VAT reporting across financials.
  • UK specific depreciation rules and grants reporting in Fixed Assets.
  • EFT Templates (Electronic Funds Transfer).
  • Statutory Ledger Implementation
  • Interfaces: AP invoices, AR transactions, MTL transactions.
  • AR Invoice format, Purchase Order format.
  • Extensions on Discount Processing, iSupplier invoice Processing, EBTAX integrations, etc.,
  • Unit Testing
  • System Integration Testing
  • User Acceptance Testing
  • Regressive Testing
  • Various reports.
  • Business requirements analysis.
  • Requirements mapping.
  • Solution design.
  • Application configuration.
  • System and functional testing.
  • Creation of client specific documentation.
  • User (all levels).
  • User support (ongoing support, month-end closing, year-end procedures).

TECHNICAL SKILLS:

RDBMS /Database: Oracle 11g/10g/9i.

Languages/Scripting: SQL, PL/SQL, UNIX Shell, C++, JAVA.

Operating Systems: Windows XP NT/ 2000, UNIX, AIX, LINUX, SOLARIS.

Other Tools: Data Loader, TOAD, Visio, Microsoft Project, Web ADI, MS Office Suite.

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Vertex 8.0 Upgrade Specialist & Oracle GL Business Analyst

Responsibilities:

  • Vertex 8.0 Upgrade: Confidential is upgrading from Vertex 6.0 to Vertex 8.0
  • Responsible for Upgrading Vertex O series system and integrating with Oracle Application system and other supporting systems which need Tax related information.
  • Scheduled Kick-off meetings with Indirect Tax Systems on high level approach to meet the Project goals and objectives.
  • Scheduled meetings with individual Tax owners to gather business requirements. Prepared the functional requirements and sign offs from Tax Directors.
  • Scheduled monthly calls with Vertex to discuss the changes from Vertex6.0 to Vertex8.0. Configured Vertex system for Confidential Business rules for effective tax calculations based on multiple data inputs from multiple source systems, built custom tax rules as needed, built framework for supporting custom objects in Vertex.
  • Worked on various designs as part of Direct Fulfillment Process, for processing data into Oracle Applications, feeding data (Orders, Shipments, Tax Information) to downstream systems.
  • Designed interfaces between various systems for effective tax calculation across different channels.
  • Configured multiple Order to Cash modules (Order Management, Accounts Receivable, Accounts Payable) for various business solutions.
  • Interact with different IT Teams (Development, Quality Testing Functional/Integration/UAT, External IT Vendors, Production Support) for support / issue resolution related to Design and Testing.
  • Extensively worked with Tax Research, Tax Reporting and Finance teams for business requirements, solving problems and soliciting their input on project related activities
  • Successfully deployed as per schedule.
  • Conducted sessions to understand the process flow, business needs and gather business requirements.
  • Created Lookup for the account code generating and drafted the functional design document for business to sign off
  • Scheduled sessions with developer and integration teams to work on the interface logic. SOX Compliance, PPM & Cost to Serve Projects
  • Created outbound extracts and Views for SOX, PPM and Cost to Serve Projects

Confidential, Boca Raton, FL

Oracle Apps - IT Consultant

Environment: Oracle Application R12 - Inventory, GL, Oracle Project Accounting, Procurement, EDI Implementation, Order Management, Account Payables, GL and SharePoint.

Responsibilities:

  • Prepared Organization Inventory Implementation Playbook document from scratch for business and internal teams.
  • Designed Process Flows and Work Flows.
  • Lead the Lawson to Oracle R12 conversion for ProtectionOne.
  • Setup 225 new Inventory Orgs for ProtectionOne, along with the setup of Master Items and Child Orgs.
  • Implementation of 4 EDI vendors; migrated to Oracle R12. EDI Purchasing setup for Options, types and notifications.
  • Configured OM Order types, Constraints, defaulting rules and functionality.
  • Setup Drop Ship Location for the Customer/Technician to directly received the material ordered.
  • Setup Shipping ship/arrival, pick release and ship confirmation.
  • Established Purchase Requisition process and Approval hierarchy to manage non - production (Indirect) Items purchases in the Organization.
  • Developed solution to manage Stock Items and recurring non-stock purchases using Blanket Purchase Agreement (BPA) and Blanket Releases.
  • Configured Auto-Sourcing rules, Approved Supplier List(ASL) and BPA to enable Buyers to release purchase orders automatically from Planners Workbench.
  • Developed solution to manage Inventory using Inspection as receipt routing for Items routed through Quality department and established Return to Vendor process.
  • Setup 4 different approval hierarchy limits/requests for each EDI vendor using AME.
  • Configured profile options, item specification, picking customization, picking rules and locators for WMS.
  • Worked with business to gather requirements, designed the functional documents and did the handoffs and walk through with technical team and business stakeholders.
  • Prepared job costing MDs for Logical Applications (LA) Rules, Account Aliases, Material Ordering, Item Deplete and P1 MMB to ADT MMB.
  • Done Module Integrations of Procure to Pay and Order to Cash Processes with AR, GL, AP, OM, WMS and INV.
  • Prepared Data Loaders scripts for Account Codes, Location Setup, Orgs Setup, Parameters, Inventory Hierarchy, Shipping Networks, Account Aliases, Item Setup in Demantra, Internal Customer Account, Sub-Inventories, Drop Ship Technicians Address for new SSOs, Min/Max Setup and On hand balance.
  • Created excel templates for Field-Ops (business) to capture the information for setups.
  • Owned the Cutover task sequencing, uploading and updating the respective task owners and task validators. Developed the sequencing for SIT and UAT, helped teams identifying dependencies and see through a smooth transition.
  • Produced different types of testing Unit Testing, System Integration Testing, User Acceptance Testing, Regressive Testing and Quality Testing

Confidential, Las Vegas, NV

Senior Oracle R12 Finance & SCM Specialist

Environment: Oracle Financial Applications R12 (General Ledger, Accounts Receivable, Accounts Payable, Cash Management, EBTax (Vertex), SLA, Inventory, WMS, Procurement, Purchasing, Project Accounting,) JIRA, SQL, CSS, SharePoint, MS Visio

Responsibilities:

  • Defining and setting up of complete Procure to Pay cycle setups from entering the requisition in purchasing to entering the receipts and creating of the invoice in account payables module to support business requirements.
  • Performed and prepared Setup Specification Documents BR100 INV, WMS, PO, OM modules.
  • Coordinated and configured the setups for Inv, AP, and GL Modules.
  • Performed inventory organizations setup, items and parameters.
  • Setup New Child Organizations in INV and Set up New Master Items in INV.
  • Performed Physical inventory, cycle counting, Org setup, sub-inventories, locators, Item templates, cost controls, pick rules, categories, Catalogues, DFF/KFF, calendars, Intercompany setups
  • Setup custom transaction types (defined custom transaction source type, transaction action & transaction reasons) in WMS.
  • Designed WMS Rules workbench, pick put away rules, Label design, Strategies.
  • Responsible for purchasing configuration, PO options, PO types, PO notifications, Approval Hierarchies using AME.
  • Setup Order types, defaulting rules, Processing constraints, fulfillment sets functionality, ship / arrival sets, Pricing modifier/ qualifier, pick release, ship confirm, Customer acceptance, Defaulting rules, Processing constraints, Item Order ability, Cascading of Header attributes, Mass change & Mass Scheduling
  • RMA and Approval Management functionality setup reduced the process time in Customer Returns management in OM Module.
  • Set up Transaction Types, Applying & Releasing Holds, Credit Checking in OM Module
  • Set up WMS system profile options and defined Item Specification.
  • Designed Picking customization. Worked on WMS Picking Rules.
  • Worked on configuring the WMS locators
  • Defined Standard, Blanket Purchase and Contract Purchase Agreement in PO Module.
  • Involved in setups for Payment Methods, Payment Documents, Bank, Bank Accounts, and Payment Process Profile in AP Module.
  • Provided continuous support to Business user community on EDI 850 Order Import Processes.
  • Collaborated customization of distributor, reseller EDI files across the Distributors/Resellers and assisted onboarding.
  • Worked on General Ledger (GL) by defining chart of accounts. Opening and closing calendars (Accounting & Transaction).
  • Support Production issues on a day to day basis including month end closure p1 issues
  • Worked on conducting Conference Room Pilots (CRP) and User Acceptance Testing (UAT)
  • Developed Test Scripts and Executed Test Scripts.
  • Worked on Mercury Quality Center to log defects and report back to the team.
  • Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex Field Segments / Values, Security Rules, Multi-org Setup, Profile Options
  • Setup eBTax and Vertex O Series integration and Developed customizations for integration to Vertex O Series at invoice distribution level.
  • Uploaded the values for all Value sets using Data load in set up steps of General Ledger, Fixed Assets, Account Payables and Cash Management modules including System Administration set ups.
  • Responsible for preparing upgrade plan for GL, AP, PO, AR, Fixed Assets and I-Expenses with all customizations and form personalization.
  • Assist Testing Team in validating User Acceptance Testing Test Scripts related to R12 Conversions and involved in Unit Testing, System Integration Testing, User Acceptance Testing, Regressive Testing and Quality Testing.
  • Performed fit/gap analysis, pre-production business testing, conference room pilot support, interface/conversion mapping, and related documentation/deliverables.
  • Reviews done on technical designs, codes and test cases as per the functional requirements.
  • Shared knowledge with associates for completing tasks as per schedule.

Confidential, Atlanta, GA

Senior R12 Oracle IT Specialist

Environment: Oracle Applications R12.1.3 (GL, FAH/XLA, E-business Tax, AGIS, Grant Modules, AP, AR, PO, Fixed Assets, OM, HR, AOL, JIRA, Inventory, P2P, WMS, Cash Management), PL/SQL, Credit Management, SharePoint, MS Visio

Responsibilities:

  • Implemented financial Modules: GL, AGIS and Shared HR of Release 12.1.3 of Oracle EBS.
  • Worked on Functional Design Documents (FDD’s) for designing various RICE Objects.
  • Successfully implemented Oracle Financial Accounting Hub (FAH) in 5 Countries for the Financial Module (GL), which included implementation of 5 Ledgers (12 Operating Units) with one Global Consolidation Ledger.
  • Implemented Advanced Global Intercompany System (AGIS) for all the states to have Intercompany Transactions with any of the Entities.
  • Configured the setup for AGIS (Advance Global Inter-company Systems) and transit the entries at sub-ledger (AR & AP) and GL level.
  • Involved in the implementation of Cash Management, Accounts Payable and Treasury management.
  • Worked on setting up the Oracle Human Resource Module for the Employees for all Countries and setting up Employee-Supervisor Hierarchy.
  • Configured transactions types that included Source, Action and Reasons in WMS. Also, worked on WMS rules workbench, pick-put away and strategies.
  • Configured the INV Org setup from scratch, include Item Catalogs, Categories, attributes and security.
  • Designed the Functional Document for GL Balances Conversion from Legacy to Oracle.
  • Lead the Global Order to Cash implementation, trained the global users on how to use. Prepared step by step process document and did walk through with all users.
  • Identification of Gap & put collaborative effort with the Technical team to address the same through Technical Specification.
  • Facilitated Pricing & IT Business to obtain clarity on the Business Rules and capture the same.
  • Order Management;
  • Implemented Quote Management system through OM which reduced the ‘Quote to Order’ process time
  • Available to Promise(ATP) and Auto-Scheduling functionality configuration reduced the Scheduling process time and enhanced customer service level
  • Drop ship Functionality was setup to enable the OM team to ship the goods directly to Customers from Supplier warehouse.
  • Internal Sales Order/Internal Requisition process was configured to establish a simplified Intercompany sale across operating Units
  • RMA and Approval Management functionality setup reduced the process time in Customer Returns management
  • Worked on both CTO and ATO Models Flow in OM
  • Performed functional testing and document test results and functionally designed the Chart of Accounts Report.
  • Leading Finance & Accounts and Customer Inquiry process area in Production Support for Oracle Financial modules.
  • Reviewed and troubleshoot the eBTax setups for multiple countries Procure to Pay, troubleshoot their Taxware integration issues, Automated migration scripts for moving tax setups from development to test and production instances.
  • Responsible for end-to-end Oracle applications implementation project from assessment to production support as a Functional Analyst.
  • Provided Sales Tax, Use Tax as well as VAT solution with the use of Vertex and have a knowledge about VAT Connector.
  • Review final scope of Procure to Pay, and Plan to Inventory Management.
  • Study of current business processes, future business flows and identification of gaps and workarounds to provide an integrated Procure to Pay business flow to meet the business needs of the company.
  • Defined AP and AR Payment Methods/Terms, Lookup/Quick Codes, Payable System Options and Financials Options.
  • Worked on encumbrance accounting on the modules like GL, AP and PO.
  • Produced different types of testing like Unit Testing, System Integration Testing, User Acceptance Testing, Regressive Testing and Quality Testing.
  • Presentation of Financial Consolidation system to the Management and Involved in Month-end support for close and reconciliation for AP, Fixed Assets and AR modules.
  • Used Accounting Rules to determine total revenue to be recognized (Revenue Recognition) in each accounting period.
  • Designed and created Oracle materials using UPK, ( Manuals and Step-by-Step Job Aids)

Confidential, Philadelphia, PA

Oracle Financials | SCM Functional

Environment: Oracle Applications R12 12.1.3 Implementation and Support (AR, Grant, AP, GL, Fixed Assets, OM, PO, iProcurement, Payments, EB Tax, SLA, Credit Management, Cash Management, Project Management, AME, AOL, PL/SQL, MS word)

Responsibilities:

  • Worked as Senior Business Consultant for implementation of Oracle ERP Financials, SCM & Project Management.
  • Involved in Enhancing and supporting Oracle implementation as an EBS Finance R12 Financial Functional Analyst for AP, AR, Fixed Assets and GL modules, played a key role in IT Support Team for the client.
  • Worked on setting up Third Party Payments in Oracle Payables R12 for Suppliers in EBS.
  • Implemented and supported AME for Payables Hold Resolution Workflow and Requisition Approval Workflow.
  • Created Lease Sales quotes and worked with the Project and Management Credit Lines.
  • Performed CRP & UAT for Financials modules, which includes AGIS, Advanced Collections, Accounts Receivable and GL.
  • Defined Request Sets with several reports and concurrent programs for GL manager such as Intercompany, Auto invoice, Costing and Accounting details for review and analysis.
  • Supported Payables & Receivables users on a day to day basis on Payment and Billing related issues in Oracle R12.
  • Led the Order Management implementation for North American operations encompassing the client’s main inventory facility and over 80 field sales offices. Assisted with the scope and planning efforts for the client’s operations.
  • Conducted Order to Cash requirements gathering, map & gap analysis and global business process design.
  • Performed core Order Management configurations and helped with Advanced Pricing, Inventory and Account Receivables modules.
  • Assisted client with compilation of materials, establishing class formats, etc. Conducted knowledge transfer sessions with key stakeholders to initiate transition of implementation efforts.
  • Provided OM and Shipping Execution go-live support for client’s main distribution facility
  • Led OTC Management Modules to load, import and auto-reconcile bank statement transaction against payments in Accounts Payable (AP), Accounts Receivable AR, Fixed Assets (FA).
  • Extensively worked on Oracle Receivable setups including Auto Lockbox, Auto invoicing & Auto accounting and resolved Auto invoice interface issues.
  • Setup and documented Payables Invoice Sweep Program for unaccounted transactions from one accounting period to another.
  • Used and generated stream Process in Finance and Project Management and worked with Master Lease agreements.
  • Setup Considerations for Finance and Project Management Accounting Transactions.
  • Resolved issues related to credit card refund, return, Lease bills, freight charge return, credit card authorization, consolidated invoicing and receivables.
  • Involved in GL Ledger setups using ASM, LE configuration, Cross validation rules, security rules, COA segments, Currencies, Accounting Calendar and Operating Units.
  • Implementation of Fixed Assets, involved in requirements gathering sessions with the client and Preparation of Functional Test Scenarios & Test cases for Fixed Assets.
  • Used OUM methodology for documenting business requirements and design documents as per business needs.
  • Involved in testing process like Unit Testing, System Integration Testing, User Acceptance Testing, Regressive Testing and Quality Testing.

Confidential, Kerrville, TX

Oracle Financial | SCM Functional R12 Upgrade Analyst

Environment: Oracle Applications Release 12.1.3 (General Ledger, Account Receivables, Account Payables, Order Management, Credit Management, E-business Tax, Procurement, Inventory, PO, Fixed Assets), PL/SQL, MS Visio

Responsibilities:

  • Preparing BR100, MD050, TE40, TE50, CRP execution, User and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
  • Completed Multi-Org configuration by creating a new Organization Structure by creating new Business Group, Legal Entity, Set of Books and Operating Unit.
  • Worked on the Configurations of AP, GL, AR, Cash Management, I-Expense, I-Receivables.
  • Conducted Regression testing to examine the effects of a new Org on the previous Org.
  • Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
  • Communicated with business users about the implementation and requirement gathering questionnaire, explaining oracle’s functionality extension from R12 vs. 11.5.10.2 within oracle financials
  • AP- Defined invoicing information including payment terms, invoicing and accounting rules, territories and invoice sources. Defined accounting options, methods of accounting, realized gain / loss account, unallocated revenue account, auto cash rule set.
  • Setup Oracle Payables includes Payment Terms, Banks and Bank Accounts, Define Quick codes, Define Financial Options and Payable Options and Defined Corporate books, fixed assets categories, assets keys etc.
  • AR - Defined receivable activities for misc. receipts, finance charges, bank charges, defining distribution sets. Worked on receipt class, specifying creation method, payment method, defining collectors and aging buckets. Created customer profile classes, attaching payment terms, collectors, matching receipts, statement cycle to profile classes.
  • Set up transaction types, invoices, guarantee, deposit, and credit memos, debit memos.
  • Customized collector’s portal to add additional transactions and customer information in Advanced Collections.
  • Preparing of all the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.
  • Worked in the process of unit testing, System Integration Testing (SIT), performance testing, regression testing.
  • Documented Functional Design, Applications Setups & User Manuals Provided with useful to the users in GL, AR, OM, INV and PO Modules.
  • Developed UPK simulations for Oracle EBS Inventory & Quality, PS (Production Scheduling), and Siebel CRM (Customer Relationship Management) application and Developed basic navigation UPKs and courseware

Confidential, Cambridge, MA

Oracle Applications Functional Analyst

Environment: Oracle Applications Upgrade to R12 (12.1.2) (GL, AR, PO, INV, OM, AGIS, iStore, AOL, Manufacturing, Fixed Assets), Oracle 11g Database, Workflow Administrator, EDI, Clear Case, Kintana, PL/SQL

Responsibilities:

  • The Oracle Financial Module had successfully implemented and gave support for the Confidential .
  • Communicated with business users about the implementation and requirement gathering questionnaire.
  • Analyzed the requirements, performing risk analysis and mapping the business processes. Understanding the gaps, recommended the necessary customizations.
  • Performed setups for secondary Ledger and Chart of accounts mapping using rollover rules.
  • Authored Functional design documents for customization and development of interfaces, reports and extensions across various financial modules, interacting with business users.
  • Designed and implemented various Conversions including Customer accounts, customer sites and profiles, Items, Item costs, Fixed Assets on hand quantity and Pricing headers/line, in R12.
  • Root level interaction with the implementing consultants since the beginning of the project, which involves interpretation & demonstration of AS-IS business processes of product development, process manufacturing& planning, quality.
  • Designed, configured and tested various Inventory reports for on-hand available items with accurate transfer and cost prices.
  • Worked on various client business process designs like Delivery status notification, EDI configuration for third party Sales Order transitions, Work flow Business events setup for notifying and publishing across inter companies when a new customer account is created etc., Repaired and updated existing UPK topics which were off-shored for phase 1
  • Developed new UPKs for Accounting, Expense Reporting, Purchasing, and Time Reporting
  • Study of current business processes, future business flows and identification of gaps and workarounds to provide an integrated Procure to Pay business flow to meet the business needs of the company.
  • Worked in various phases of project from process design, development to unit testing, System Integration Testing (SIT), performance testing, regression testing, UAT, pre-production and post-go live support.
  • Given 24/7 support to the team during the go live phase for meeting deadlines with complete documentation and testing.
  • Performed extensive defect fixing and support during the client pre-production testing phase, identifying the problem tickets through quality center.
  • Worked with Kintana for code/setup migrations between test instances, for concurrent programs, forms personalization, menus, responsibilities, value sets and other AOL objects.
  • Set up Banks account, transaction types, invoices, guarantees, deposit, and credit, debit memos. Defined customer and setting up credit management and Tax rules. Set up transaction types, invoices, guarantees, deposit, credit memos and debit memos.
  • Populated the Oracle Instance with data in preparation for class. Created materials using UPK, Power Point and MS Word

Confidential

Oracle EBS Functional Consultant

Environment: Oracle Applications 11.5.10.2 (AP, AR, Fixed Assets, Purchasing, GL, AOL, Inventory, OM), SQL, PL/SQL, TOAD.

Responsibilities:

  • Involved in the Implementation of the Application for all financial modules like GL, AP, AR, FA, CM & PO.
  • Prepared and updated CV40, BR100 documents and created MD 50 Functional Design documents per AIM.
  • Configured, Accounting setup manager, COA Structure, Segments, Values Sets, Flex fields, Account qualifiers and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar and Currencies.
  • Expertly defined, configured and implemented Rollup Groups, Aliases, Dynamic Insertion, Accounting Calendar, Summary Accounts, Intercompany accounts, and consolidation ledgers.
  • Designed various Quarter and Year end reports for Higher Management review in like Top Ten vendor payments, Overall Payments history, Employee etc.
  • Created users and modified the privileges for users, rollup group and summary accounts.
  • Conducted orientation, System integrated testing (SIT), Unit Testing (UT), CRP, User Acceptance Testing (UAT) and Rollouts strategies for System up gradation.
  • Provided production support for day to day business issues and worked on SRs with Oracle.
  • Set up Banks account, transaction types, invoices, guarantees, deposit, and credit, debit memos. Defined customer and setting up credit management and Tax rules. Set up transaction types, invoices, guarantees, deposit, credit memos and debit memos.

Confidential

Oracle Applications Functional Consultant

Environment: Oracle Applications 11.5.10.2 - (GL, AP, OM, AR, CM, FA), SQL, PL/SQL, TOAD.

Responsibilities:

  • Involved in direct interaction with the business users and collecting information required for resolving support incidents.
  • Developed Material for AP and AR modules and prepared impact analysis.
  • Extensively worked on Month end and Year end reconciliations for closure of subledger modules - AR and AP.
  • Worked on Quality Center to create Test Scripts, Test Cases and testing various Functional activities.
  • Involved in the Bridge Calls during Cut-over/ Go-live phase.
  • Established control over data access with creation of Menus and Responsibilities and by setting up flex field security rules and involved in Quality Testing (QT).
  • Analyzed the support incidents logged in the remedy system and suggested as well implemented solutions.
  • Conducted knowledge sharing sessions for the team members in the functional areas of known modules.

Hire Now