SUMMARY:

• Around 7+ years of Industry experience as a Sr. Oracle EBS Analyst with solid understanding with Manufacturing, Supply chain management, banking experience, Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• I have strong knowledge in finance MI reporting and good understanding of GL and finance reporting processes and metrics.
• Have strong experience working as Procure to Pay Liaison for Senior VP and Project Manager.
• I have experience of Investment Banks & Securities Deal and CGI knowledge.
• Expertise in Oracle General Ledger, Account Payable, Account Receivable, Purchasing Order and Fixed Assets.
• I have strong knowledge of the following business processes Order - to-Cash, Procure-to-pay, Inventory, Finance and accounting, Projects, Service Contracts and Depot Repair.
• Procure to Pay support for Go to Live group and Oracle EBS End Users.
• I have good knowledge of the Oracle EBS R12 data model for the modules OE, AR, AP, PO, GL, OKS, MTL, FND, CS.
• Participated in overall functional design & governance design for the Oracle Knowledge system.
• Involved in Enhancement of custom objects to meet the business requirements and integrate them with Oracle Application.
• Designed and developed Supplier, Supplier Site and Supplier Contact Conversions to migrate legacy Supplier data to Oracle R12 EBS system.
• Upgrading of 11i reports to R12
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
• Integrated legacy data from multiple sources including Oracle 11i into one complete EDW environment for archival, reporting, and OLAP using Oracle Warehouse Builder (OWB) and PL/SQL.
• General and ongoing EBS OTC, B2B and EBS manufacturing technical support.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Provide Fixed Asset Reporting training Controllers, Accountants, and Business Unit staff.
• Reconcile the Fixed Assets system to the General Ledger system for all of North America.
• Managing Purchase Order Process, Entering Accounts Payable, Preparing General Ledger Journal Entries and related Reconciliations, Fixed Asset Management.
• Responsible for converting a global legacy windows based application into EBS application platform.
• Experience in writing automated scripts, designing Test procedures,manual Test cases And preparing Quality feed back to QA team & manager.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall.
• Functional knowledge in the business processes such as Financial, Order to Cash (O2C), Procure to Pay (P2P) of Oracle EBS 11i and R12 in the modules GL, AP, IEX (Advanced Collections), AGIS, CM, FA, IBY Payments, AR, TCA, INV, PO, OM, AOL and Sysadmin.
• Knowledge of using automation tools - Win Runner, QTP, Load Runner, Quality Centre and Test Director.
• Responsible of Oracle SOA 11g custom applications with specifics to external data integration into EBS R12.
• Proficient in Functional testing, Regression testing, Configuration testing, Integration testing, System testing and Sanity testing
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• E xtensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Managing Collections Process, Month-end Reconciliation and Journal Entries, Fixed Assets.
• Processed maps within the OracleConcurrent manager, and utilized the Oracle E-business suite 11i embedded workflow engine for business rules and notification.
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Interface with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as the lead of the Projects.

PROFESSIONAL EXPERIENCE:

Confidential - Houston, TX

Oracle Financial Functional Analyst

Responsibilities:

• Responsible conversion and interface programs for migrating legacy Air Force data into Oracle EBS modules such as Fixed Assets, AP, QP, and EAM.
• Worked through three acquisitions to ensure the proper data was captured and loaded into the FixedAsset system.
• Creation of Purchase Order Receipt and Creation of AP Invoice and approval of the same.
• Created Automatic receipt using lockbox.
• Involved in implementation and testing of Oracle Applications Financial R12.
• Studied the existing system and performed GAP analysis for implementation of R12.
• Interacted with client to gather the requirements to design and estimate the project duration.
• Identified the structure of Flex-fields, defined Value sets and values for several flex fields in GL and AR module.
• Created Order management module mandatory set ups like Customer, Customer address, Item, Transaction type, Order type, Pricing, Sales person and document Sequence
• Worked on setting up Banks, Dunning letter, Auto Lockbox, employee expense templates and distribution sets.
• Responsible for development and support for Oracle EBS R12.1.3.
• Responsible for the setups and configuration of seven Tax Books in Oracle Assets.
• Responsible for creation of project plan and keeping project on time and within budget.
• Designing changes to the existing Oracle Applications (E-Business Suite) 11i system.
• Lead a small group of developers in the data conversion.
• Prepared training material on the Asset module .
• Extensive experience in Order Management, Inventory, Pricing, Purchasing, iProcurement, Accounts Receivable, iPayments, Accounts Payable, General Ledger, Fixed Assets, Collections, iExpenses, Service Contracts Business Process in Manufacturing Industry space.
• Dealt with various issues in I procurement, PO and INV to workflow, purchase orders, hierarchy issues, AME/Workflow requests and so on.
• Studied business requirements, fixed gaps, interface development, extract development and provided an integrated conversion solution.
• Tested the functionality by using various tests scripts.
• Other responsibilities included supporting users, diagnosing and resolving problems, implementing solutions.
• Conducted training on Assets with the Sinclair Tax department
• Worked on Auto invoice Import setup by defining transaction type, payment term, batch source, grouping rule, and transaction flex-field.
• Upgrading and Supporting full lifecycle projects on Oracle E-Business Suite Release R12 (12.1.3 and 12.2.4) and 11i.
• Created training documents for creating receipts by defining bank, receipt class, receipt source, and Auto cash rule set.
• Involved in functional support for upgrade from 11. in GL, AR, and AP modules.
• Held meetings with the client/users regarding the business requirements, limitations of existing system and proposed solutions.
• Defined rollup groups, security rules, journal sources, journal categories and budgets.
• Defined currency translation, conversion, revaluation and set the profile options for Fixed assets.
• Created and executed Profit & Loss, Balance sheet reports through FSG reports
• Defined currency conversions, currency translation and revaluations in GL & fixed Assets.
• Configured the setup for multi currency invoices and payments in AP.
• Prepared BR - 100 for configuring the Oracle EBS Applications according to the business requirements.
• Designed the Inventory reconciliation programs and reporting mechanism to keep the inventory synched between Oracle EBS and legacy warehouse systems.
• Designed Key Accounting Flexfield structure, Chart of Accounts with Multi Org and Multi Currency setup.

Environment : Oracle Applications R12, GL, AP, AR, OM, PO, INV, FA and CM, Forms 6i, Reports 6i,

Oracle 9i & Sys Admin.

Confidential - Anaheim, CA

Oracle EBS Analyst

Responsibilities :

• Involved in Oracle EBS Implementations and it’s Initiatives and cutomizations for General Ledger, Payables, I-Procurement, Accounts Payable, Receivables, Fixed Assets, PTP, Inventory, IExpense, Procure-to-Pay, Order-to-Cash Project Costing and Billing, Cash Management.
• Directed and led the Region in implementing Oracle Financials, executing all aspects of implementation for iProcurement, Purchasing, Payables, Assets and Fixed Assets (documenting business requirements, data conversion, testing and post-implementation support).
• Supporting multiple R12 EBS application, monitor, analyze, resolve support tickets, provide weekly Status report and manage customer expectation.
• Performed meeting within Business stack holders, Developers, DBAs, Quality Assurances and End users of Business high level requirements and its updates.
• Architected, designed and developed a Data Warehouse solution using Oracle 11i (GL, OE, AR, INV) and multiple third party data stores into a single complete Data Warehouse DW and an Online Decision Support System ODS.
• Having good experience in Production and Development support, upgrades and installs of 10.7SC, 11i, R12 Oracle Applications
• Warehouse workload Balancing - Provided optimum systemic solutions to manage the workload in warehouse through controlled sales order release from Oracle EBS through Ked Decision Document (KDD) after extensive analysis on customer consolidations, On Time-Delivery requirements across various regions, Credit approval processes Margin calculations etc.
• Recommended best solutions and methods per requirements and functionalities of Oracle EBS.
• Used IR Tools and OBIEE for customized reports and Reconciliation Reports and Prepared Data sheets for Reports for updates and to present in Meetings.
• Implementation of new tax reports that has saved the Asset Management department 6 weeks of manual manipulation work.
• Exposure to various oracle modules such as Account receivables, Purchasing, BOM, Oracle WMS as part of O2C, and P2P flows.
• Recommended necessary Financial Reconciliations reports and assisted to design reports and tested.
• Capital leases have been configured and added within Fixed Assets system to comply with policies that were added at the end of 2005.
• Scheduling of appointments and meetings for entire management team and the EBS project team
• Assisted in all areas of administrative work including training new staff, sending out meeting minutes, data-entry, file organization, research and development.
• Prepared Bank and Cash Reconciliation Reports and Other Financial Reconciliation and other standard reports
• Placed meetings for Requirements, Implementation, QA, Go to Live for Implementation and Upgarde
• Performed Oracle EBS Functionality Testing of business requirements for Quality Assurances.
• Used QTP and Quality Center to manage QA testing and regression testings and defects and its reports. Ran automated tests.
• Assisted to Business users for new implementations and Initiatives for testing and Designed, Created Use cases, Test Cases, Test Scripts, Test Plans and uploaded to the Quality Center and ran manual testing for Implementation on each releases.
• Defined and Created and Tested Primary Ledger, sub ledgers and Operating Units for Ledgers.
• Created, submitted and Tested Different Purchase Requisitions, Catalog/Non-Catalog, Inventory, Expense, Capital, Professional Services and approved it using iProcurement and its Notifications
• Generated Standard Receipts, Express Receipts through receiving against purchase orders, processed returns to suppliers.

Environment : Oracle EBS, IPM, Oracle General Ledger, Payables, PTP, iProcurement, Purchasing, Inventory, iExpense, Fixed Assets, Project Costing/Billing and Accounting, Cash management, HP Quality Center, QTP, QTP, AppLoad

Confidential - Collierville, TN

Oracle Financial

Responsibilities:

• Acted as liaison between client and development team for product development as per requirements.
• Conceived, developed, and instructed Standard Operating Procedures on e-Procurement and Supply Chain processes.
• Served as cross-functional technical consultant throughout the procure-to-pay cycle.
• Authored AIM documents for accounts Receivable module including: BR100-Setup Document, CV60- Conversion document.
• Multiple full Life Cycle implementations, rollouts, upgrade and support projects from 11i to R12.
• Involved in Enhancement of custom objects to meet the business requirements and integrate them with Oracle Application.
• Maintenance Route Conversion, data used to extract from legacy system called Passport and load Route Maintenance data to Oracle EBS
• Participated in planning and set-up of accounting flexfield structure and chart of accounts.
• Planned, Setup and Implementation of Account Receivables, I Expense, Cash Management and General ledger.
• With all the time saved in SAP optimization, Fixed Assets team was able to take on Snacks Operations
• Created multiple responsibilities, developed security rules and customized menu to restrict user access to functionality as per requirement.
• Managed development of Interfaces & XML reports within Oracle EBS - Including preparation of Technical design document, Installation document, and test scripts.
• Designed and Created Customers, Profile Classes & information and General Ledger Accounts.
• Worked on Allocation, Revaluation and Conversion on GL .
• Involved in month end processes for journals, SLA, Recurring and Reports with subsequent accounting.
• Provided support for Oracle Fixed Assets module.
• Customized I expense using Oracle Accounts Payable, Project, HRM, Work flow and System Administrator for implementation
• Configures ADI to download I expenses report in excel spread sheet for end users
• Applied setups for Credit card transactions processing system on I expense and tracking reports
• Involved in development and customization of reports.
• Developed comprehensive quality assurance documentation including test plan, test scenarios, and test scripts.
• Functional knowledge in Account Receivables (AR), Fixed Assets (FA), and Cash Management (CM).
• Vendor Payable Systems (VPS), Vendor PO's and Tax information integration with Oracle EBS.
• Defined testing methodologies, designed test plans and test cases, verified and validated the system and documentation based on standards for software development and effective QA implementationin all phases of Software Development Life Cycle (SDLC).
• Assisted client with final acceptance testing, and post implementation support issues for AR
• Fully participated in Conference Room Pilot (CRP) and authored user’s manuals.
• Develop Customized Supplier Interface to import customers from Legacy System and write validations for same and import in Oracle Base tables.
• Created Test Scripts (TE040’s) for UAT sessions.
• Develop Missing Mailer Expense Report based on combination of Cost center, Cost center description, UPN, Employee name, Email address, Expense Report Number, Submit Date, and Expense Amount using Oracle XML Publisher/OBIEE.
• Developing PL/SQL (Stored Procedure, Functions & Packages) implementing business logic.
• Responsible for writing of SQL queries as procedures/functions at the back end which are called from front end form.
• Registering Reports, PL/SQL Procedures, and Packages and creating executables.
• Tested new enhancement (Regression Testing/ Functional Testing, Security Testing) and bug fixes before deployment into production environment.

Environment : Oracle EBS 11.5.10, General Ledger, Payables, Procure-to-Pay, Receivables, Cash Management, iExpense.