SUMMARY

• Over 8 years of experience in Enterprise Resource Planning (Oracle EBS) system including Full life cycle experience in implementations, rollouts, design, development, CRP, testing, User trainings and support Projects.
• Has experience in upgrading a live project from previous version (11.5.10.1) to current version (R12). Also had experience in working as a production support role.
• Expertise in ERP domains such as Financials, Projects and Supply Chain Management.
• Knowledge on PMP and ITIL Foundation (IT Service Management) programs
• Extensive technical and functional experience in modules like Oracle General Ledger (GL), Account Receivables (AR), Account Payables (AP), Fixed Assets (FA), Project Accounting (PA), Cash Management (CM),iExpense, Purchase Orders (PO), Order entry (OM), Shipping (WSH), Advanced Pricing (QP) Inventory (INV), iProcurement, Bill of Materials (BOM) and various other modules.
• Strong understanding in Trading Community Architecture (TCA), Multi - Org concepts and Application Object Library (AOL).
• Prepared functional and technical design documents for customizations using AIM (Application Implementation Methodology) documentation like MD’s, BR’s and CV’s.
• Expertise in developing RICEW/F. Developed Reports, Interfaces, Conversions, Extensions on forms. Developed workflows for Order to Cash (OTC) and Procure to Pay (PTP) business flows.
• Expertise in SQL and PL/SQL. Hands on experience in writing triggers, cursors and all teh programming techniques of Pl/SQL.
• Experience in developing reports using Oracle Reports 6i/9i/10g, XML BI publisher and Discoverer.
• Excellent work ethics and interpersonal skills that help in communicating wif teh fellow team members, Managers, Developers and Users.
• Ability to handle multiple tasks and work independently as well as in a team.
• Possess rich experience in Oracle Applications and wide exposure in understanding business needs to scope and design optimal business system solution.
• Job profile includes Oracle Application Implementations, Rollouts and Support projects.
• Performed health check tasks and presented plans to increase system usage
• Experience in conducting workshops for Oracle Application modules
• Experience in mapping Business requirements, designing customized solutions and planning test strategies
• Followed BP080, BR 030, BR 100, MD 50, TE.020, TE.040 Oracle AIM documentation standards.
• Experience in Project Scheduling, Resource Requirement Analysis and Budgeting
• Developed a SOP Documents for teh Business teams
• End to end management of projects from conceptualization to final execution
• Preparation of SOW- Statement of work documents
• Has experience in conducting workshops wif Key Super users on Functional applications.

TECHNICAL SKILLS

Oracle ERP: Oracle E-Business Suite 11i and R12

Domains: Financials, Projects and Supply Chain Management

Modules: GL, AP, AR, FA,CM, PA, INV,PO, OM, iExpenses and iProcurement

Languages: SQL, PL-SQL

RDBMS: Oracle 9i/10g/11g

TOOLS: Reports 6i/9i/10g, BI Publisher, Discoverer 11.1, Forms 9i, TOAD, SQL*Loader, Oracle Workflow 2.6

Documentation: AIM (MD 50, MD 60, MD 120), BR’s and CV’s

Operating systems: All versions of Windows, Linux

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Senior Consultant

Responsibilities:

• As a Consultant, responsible for defining teh business process. Prepared AS-IS understanding document for GL, AP, AR, FA and CM
• Assisted in business process reengineering, created TO-BE process document.
• Captured high level additional requirements Future Business Model (BP 080) for GL, AP and AR FA modules, and done teh Impact analysis in current business process due upgrade changes/enhancements.
• Conducting Workshops on Financial Modules and Prepared both As-Is and To-Be process documents
• Define Chart of Accounts and Ledgers
• Created Legal Entries and Operating Units for Confidential Global requirements
• Define Consolidation mapping between Ledgers to calculate teh business at group level.
• Involved on Customer reports for General Ledger report such as Account Analysis and Intercompany reports.
• Define Application Setups for GL, AR, AP, FA & CM modules as per teh BR100 documentation.
• Drive business process reengineering and related lean concept
• Enabled Payables setups such as Payables Options, Payables system setups and Financials Options
• Defined Systems options, Receivables Activities, Auto Accounting, Transaction types and sources.
• Creation of Banks, Branches and Accounts
• Defined Asset Category, Key and Location Flex fields.
• Defined Corporate book to maintain asset transactions
• Enable Cash management setups thus helping teh business to perform automatic reconciliation and manage exceptions accordingly
• Interact wif client for both project mile stones review and Document sign off
• Involved in Performance, Regression, and Integration Testing
• Critical issues were replicated on Non-Prod instances and performed end-to-end testing before moving on Production instance
• Coordination wif DBA and Infrastructure teams
• Collected project documents from teh each team member and shared teh same documents wif clients through share point portal.
• Designed Functional specification documents for Custom objects(MD50)
• Performed Unit test scripts (TE20) on Dev server
• Mentor teh functional Concepts to Technical team
• Involved data migration documents designing for Suppliers, Bank account data.
• Providing Post-Production support for financial modules.

Confidential

Consultant

Responsibilities:

• Responsible for teh implementation of AP, Inventory and PO modules including custom Reports development and data migration tasks.
• Designed AIM documents for Custom objects (MD50, MD70, TE20 and MD120)
• Defined MOAC setups and enabled Master and Inventory organizations
• Defined Key Flex fields for teh Inventory application
• Defined Item Classification/Categories using teh current reporting structure such as major and minor categories
• Has defined teh setups for accounts payables application such as Financial, Payables Options, Payment terms, updated Supplier base and sites, Distribution sets and tolerances
• Configured PO Setups like purchasing options, Receiving options, PO Position Hierarchy, Buyers and Requisition templates.
• Developed detailed PO and Requisitions, Distribution all Information Report for specific Cost Centers.
• Uploaded around 7000 thousand Master items through SQL Loader.
• Modified teh Account Analysis reports as per teh user requirements
• Modified teh interfaces for mass allocation and asset depreciation month end process as per Client’s requirements.
• Prepared Period-end process documents and imparted training to Super users on AP, Inventory and PO Modules
• Unit and Integration Testing
• Go Live & Post Go Live support PROD Glod System

Confidential, Seattle, WA

Functional Consultant

Responsibilities:

• Conducted CRP sessions to show case teh application capabilities in support to teh business specific requirements and functions
• Performed GAP analysis and prepared Custom Solutions to fulfill teh gaps.
• Preparation of custom responsibilities, menus and functional documents for various modules
• Define Chart of Accounts and Ledgers and assigned to respective GL responsibility by using GL Ledger Profile option
• Enabled Multi-Org Access Control features to manage multiple responsibilities through single responsibility.
• Define Consolidation mapping between Ledgers to calculate teh business at group level.
• Preparation of solution design documents, test scenarios, test cases and test results for teh custom documents MD50, TE20
• Configured General ledger, Account Receivables, Payables System Options, Payable and Financial options
• Setup Suppliers, Supplier Sites, Bank Accounts and documents
• Designed teh solution in Oracle Apps R12 to interface teh Customers data from Legacy system (SOMS) to Oracle.
• Execution of system setups for teh financial modules in teh production environment. Defined Systems options, Receivables Activities, Auto Accounting, Transaction types and sources.
• Creation of Banks, Branches and Accounts
• Defined Asset Category, Key and Location Flex fields.
• Defined Corporate book to maintain asset transactions
• Enable Cash management setups thus helping teh business to perform automatic reconciliation and manage exceptions accordingly
• Involved in Functional, Regression and UAT Testing.
• Responsible for coordinating teh testing team to carry out teh end to end functional flows across teh Oracle Financial modules
• Delivered oracle applications solutions to clients in teh areas of General Ledger, Payables, Receivables and Fixed Assets
• Prepared CR Documents and getting approvals from client Team for any changes in Production Instance.
• Define E-Business Tax structure such as Regime to rate flow lifecycle
• Support for General Ledger and Accounts Payable, AR Modules
• Involved Pre Production Rehearsals and Cutover Activities
• Support for teh daily issues related to GL, AP through Service Management tool.

Confidential

Responsibilities:

• Analyzed client’s current business processes, design, coding, testing and implementation of Project Accounting modules (PC and PB).
• Development of client future business process module on Project Accounting function
• Customization of Project account generator workflow to generate custom code combination from different sources to meet business accounting requirement for both revenue and costing solutions.
• Creation of Implementation Options in Projects
• Expenditure Categories and Types were mapped to resource groups while defining Project types.
• Conducted workshops and CRP session in order to understand Business requirements and demonstrated PA processes in Oracle application respectively.
• Responsible for coordinating teh Financial and testing teams to carry out teh end to end functional flows across teh Oracle Project modules
• Preparing and Reviewing Documentation for Custom reports such as SIT Report, MD050, MD070, TE20 and MD120.
• Developed a SOP documents for Billing solutions and Revenue recognition process in PA system.
• Involved in defect fixes during SIT, UAT pre go-live, cut-over and post go-live stages.
• Enabled Form personalization at Project Header level to maintain common code between Project and GL Flex field segment value
• Development of custom reports and exceptions for Projects to Asset Integration (Mass Addition)

Confidential, Los Angeles, CA

Functional Consultant

Responsibilities:

• Business Requirement, Scope Management Documents Preparation.
• Define Accounting Structure and Ledgers.
• Enabled Foreign currency options
• Define custom general categories and source to manage accounting journals from legacy to Oracle GL.
• Developed a SOP documents on period process for GL and Sub ledger applications
• Define payment terms, suppliers and sites
• Define Payables setups - Payables Options, Payables system steps and Financial options
• Preparing functional and Technical specifications.
• Preparation of Test scenarios.
• Training for Key users.
• Worked on Setup Document (BR-100) and was responsible for configuring financial application setups in Glod instance
• Configuaring Finance Modules as per project requirement in non production instances.
• Finalized teh Primary Ledger, Secondary Ledgers and Ledger Sets - COA Defined Period Types, Accounting Calendar and Accounting method
• Defined Cross Validation rules (CVR) and security rules (SR)
• Defined teh Legal Entity in accounting setup manager of GL
• Worked on Multi-Org Access Control Feature for AP and AR
• Define Options and Defaults - Financials Options and Payable Options that are specific to Accounts Payables, and defined Banks and various Payment formats
• Defined Payment terms, Distributions sets and working on all invoice types and Payments Manager
• Configured Payables, System Options and Transaction types, Sources
• Auto Accounting, Memo Lines, Receivable Activities, Receipt Classes, Receipts Sources and Bank Accounts Definitions
• Designed Functional specification documents for Custom objects(MD50)
• Performed Unit test scripts (TE20) on Dev server
• Configured Asset Key Flex fields.
• Defined both Corporate Book and Asset categories.
• Define Bank, Branches and Accounts.
• Define System Parameters and set auto-reconciliation characteristics.

Confidential

Associate Consultant

Responsibilities:

• Handling Support and Maintenance Projects
• Identification of Key Performance Indicators
• Define SLAs for 24/7 support operations based on KPI’s.
• Application support for group countries - Level 2 and 3.
• Developed onshore and offshore models
• Implementation of Service Management
• Requirements elicitation and Solution design
• Prepared Oracle Application Roadmap
• Created a SOP documents for Shop floor activities
• Prepared weekly and monthly dashboard reports
• IM reduction commitment

Confidential

Accountant

Responsibilities:

• Ensure an accurate and timely monthly, quarterly and year end close
• Handling Bank Balances and Treasury Management
• Apply a thorough understanding of teh financial reporting and general ledger structure
• Take teh lead to complete teh quarterly NCUA Call Report
• Ensure teh timely reporting of all monthly financial information
• Initiate budget and forecasting activities
• Monitor and analyze department work to develop more efficient procedures and use of resources while maintaining a high level of accuracy
• Interface wif other departments to verify transaction report data and issues
• Preparations of Weekly and Monthly books
• Advise staff regarding teh handling of non-routine reporting transactions
• Submission of statutory reports
• Monitor and Control Monthly and Yearly budget
• Ensure all financial reporting deadlines are met
• Assist in development and implementation of new procedures and features to enhance teh workflow of teh department
• Provide training to new and existing staff as needed
• Preparation of consolidated Trial Balances
• Vendor Management and Payment
• Work wif direct report to establish performance goals and objectives for each year and monitor and advise on teh progress to enhance teh professional development of staff