SUMMARY:

• Around 7 years of experience as consultant in Oracle ERP Implementations, Upgrades and support mainly in General Ledger, Account Payables, Account Receivables, Fixed Assets, Cash Management, Purchasing (PO), Inventory (INV) and Order Management (OM) modules. Well experienced in identifying Gaps & developing Custom components as per business requirements.
• Hands - on experience in project management, financial analysis, customer service, quality assurance, support of IT services, and strategic planning for a variety of industries. Skilled strategic thinker in Financial Systems implementations.
• Experience in system analysis, configuration, documentation, testing, user training, technical support and maintenance of information systems with emphasis in generating implementation documentation e.g. process flow, process mapping, functional gap analysis documentation.
• Excellent knowledge of MS Office especially MS Excel, Visio, Power Point, Word and skilled in the use of UML, RUP and Requisite Pro.
• Good Technical Knowledge on SQL, PL SQL, Forms and Reports using for Inbound, Outbound, Extensions and Reports.
• Experience in Application Object Library (AOL) for registration of Forms, Concurrent Programs and oracle API's and Menus.
• Responsible for Software design, development and implementation of Oracle Inventory Management System, GL, Warehouse Management System using Oracle 8i, 9i and 10g.
• Expertise in the AIM Methodology, Documentation, Configuration of Applications, Testing, End-User Training and Supporting for Oracle Financials Fusion Cloud, R12, &11i in iexpenses, iprocurement, Inventory, Purchasing, Order Management, AP, AR, FA, CM, E-Business Tax and GL modules.
• Good Exposure to Reconciliation of Sub-Ledger modules with GL, Accounting Setup Manager, Inter Company Accounting and MOAC.
• Expertise in conducting requirement gathering sessions, feasibility studies and Impact Analysis, Cost/Benefit analysis and Risk analysis, Basel lining acceptance criteria.
• Solid understanding of Use Cases, Sequence Diagrams, Collaboration Diagrams, Activity Diagrams, and Class Diagrams.
• Experience in designing, developing, testing, performance tuning and supporting data base applications using Developer Tools (Reports 6i/9i/10g, Discoverer4i/9i/10g, XML/BI Publisher), Packages, Functions, Procedures, Triggers, Views and Indexes, PL/SQL on UNIX and Windows platforms.
• Well experienced with Application Tools TOAD, SQL Developer, Data loader, ADI & Web ADI.
• Solid understanding of integration of Oracle Applications modules, Multi Org, Reporting Currencies Setups, Chart of Accounts, FSG, Budgets and Flex fields.
• Experience testing implemented systems and system changes including liaising with QA teams to develop test cases, test plans, test scenarios, and generating test data; and conducting manual testing (regression, end-to-end, functional).
• Experience in writing Test Plan, Test Strategy, Test Cases, and Traceability Matrix, communication and presentation skills.
• Technical Expertise in SQL, PLSQL, Oracle Reports 6i/10g, Discover, Oracle Forms 6i/10g, (XML) BI Publisher, XML Bursting, Oracle Workflow and SQL Tuning.
• Extensive knowledge and experience of oracle database development, oracle SQL,
• PL/SQL (triggers, procedures, functions and Packages), SQL Developer and SQL
• loader.
• Excellent technical writing skills to create Business Requirements Document (BRD), Functional Specifications Document (FSD), Non-functional Requirements Document and Use Cases Specifications.

TECHNICAL SKILLS:

• Agile methodology
• MS Visio
• MS Excel
• MS PowerPoint. Scrum
• JIRA
• Cognos BI
• MS Office Suite
• Smart Draw
• Crystal Reports
• BRD
• FRD
• Waterfall
• MS Office
• JIRA
• Agile
• Rational Unified Process (Rup)
• UML
• UAT
• SQL
• Oracle EBS R12 - AP
• AR
• GL
• FA and AOL
• Reports 10g
• Forms 10g
• BI Publisher
• SQL
• PL/SQL
• TOAD

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Oracle EBS Consultant

Responsibilities:

• Worked as a Functional Analyst in Implementations, Upgrade and Post Production Support of Oracle EBS in various industries like Banking, healthcare, Manufacturing, aviation, and Pharmaceutical.
• Worked as an ERP Professional on Oracle Applications (E-Business Suite) experience on financial modules Oracle Applications including R12.1.3.
• Developed control file to load sales orders created in legacy system into staging tables using SQL * loader then validated data and inserted into OM interface tables.
• Two full lifecycle Implementations R12 with GL, AP, AR, FA, CE, iProcurement, iReceivables, iExpenses, E-business tax and Sub Ledger Accounting(SLA).
• Designed functional documents design document for interface from Oracle Financials R12.1.3 and designed process flows for each functional area during the implementation, carrying out requirement gathering, requirement analysis, gap analysis, setups, functional modifications, unit testing, and CRP’s.
• Expertise in AIM Methodology to enrich project management and documentation processes.
• Designed solutions to enhance standard oracle flows for Order to Cash(O2C), Procure to Pay(P2P), Assets to GL, Inventory, TCA, Credit Card Transactions, GL Accounting processes.
• Customized PO Approval workflow process using Workflow Builder and define processes based on the purchasing amount and ship to location.
• Performed conversion Activity in Inventory module initially and getting user acceptance, after which the final conversion took place.
• Worked on Applications Object Library (AOL) features like Descriptive Flex Fields, Value Sets, Concurrent Programs, Responsibilities, Request Sets, Profile Options, Functions, Menus and Printers.
• Proficient in designing and requirements for RICE (Reports, Interfaces, Configuration, Enhancements) Implementation, Conversion, Data Migration.
• Designed the Functional solutions to the Key Gaps through Interface, Extension, Customization, Reports.
• Collaboration with the Business users during the various stages of project lifecycle.
• Wide experience in requirement analysis, GAP analysis, Design the ‘to be’ process, Process mapping, Data Conversion Management, Testing (unit/integration/system).
• Expertise in post implementation support, prepared training manuals and trained end users.
• Worked with different business groups to document the Current and Future business process flows using Microsoft Visio.
• Performed database migration & Upgrades from Oracle & databases from 9i, 10g to 11g to 12c
• Developed Shell script program to call the SQL loader program that transfers data in data and file to staging table and runs the custom concurrent program to transfer data from staging table to interface tables
• Participated in Requirement Gathering Sessions & JAD Sessions and help business understand the native
• Led the bi-coastal team responsible for the formulation of business to business Internet/eCommerce sales strategies.
• Designed of several EDI integration, Purchase-to-Pay and Order-to-Cash transactions into and out of the Oracle Applications.
• Analysed and reviewed the functional Requirements, system requirements and process flow documents and performed peer code review sessions and coordinate with QA/ BA teams to deliver the task.

Confidential, Aspen, CO

Business Analyst

Responsibilities:

• Successfully led and conducted JAD sessions to facilitate business process agility and to identify the content flows and processes. Worked in an agile environment in the billing center team to gather business and system requirements.
• Coordinated the successful design, development (User Interface/API/Backend layers), and implementation of Business to Consumer (B2C) and Business to Business (B2B) Internet booking client/engine.
• Served as the advisor to the global alliance organization on business-to-business Internet marketing best practice.
• Developed PL/SQL Procedures for Customer interface using Trading Community Architecture (TCA) in Accounts Receivables according to Requirements.
• Worked on Oracle EBS R11i Supply Chain modules such as Inventory, Purchasing, Order Management and Finance Modules like GL, AR, AP and iExpenses. Worked on EDI transactions and partnering with Innovis/GSX for maintaining EDI translation mappings.
• Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
• Responsible for Software design, development and implementation of Oracle Inventory Management System, GL, Warehouse Management System using Oracle 8i, 9i and 10g.
• Created procedures and SQL*Loader Scripts to populate Customer interface tables with data such as Customer Profiles, Phone Contacts at various levels, Payment Method data and Customer Bank data.
• Implemented Google Analytics to create the data needed to measure product implementation and identify performance improvement initiatives that were needed.
• Connected with current ERP users and provided assessment of user experience and recommendation of future optimization.
• Conversion of existing website to ATG software client moved from custom built application to ATGs eCommerce suite.
• Designed, tested and implemented within existing set of books new operating units encompassing GL, AR, AP, PA, Purchasing, iExpense, Purchasing, iProcurement, Inventory, and Oracle Time and Labor in Oracle ERP system. Provided post implementation support for new operating units.
• Designed and developed AR Auto Invoice inbound interface program. Loads the data from flat file to staging tables using SQL* Loader.
• Customized various workflows using workflow builder to meet business requirements, including Requisition Approval, PO Approval, Invoice Approval, iExpense Approval, Order Header Workflow, Order Line Workflow, Auto Create.
• Good knowledge in development of Business Processes, Custom interfaces, APIs, building control files, dealing with Application Object Library (AOL), reports and workflows.
• Developed asset inventory organizations which specified inventory parameters and accounting information to improve upon the previous system.
• Developed a standard template and procedure to upload budgets from Coherent's different business units into Oracle General Ledger (R11i), using Oracle's Application Desktop Integrator (ADI).
• Developed Project specifications using Microsoft Visio Flows, Prototypes, Use Cases, Business Requirement Documents, and/or User Stories.
• Created screen mock-ups, wire frames, User Interface/Graphic User Interface (UI/GUI), context diagrams, business process flows, and in developing Use Case Diagrams, Behavior Diagrams (Sequence Diagrams and Activity Diagrams) based on the UML Methodology.
• Performed complex SQL queries for retrieving data from the database, generating ad-hoc reports, and conducting data validation testing.
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Involved in QA/Testing processes like User Acceptance Testing (UAT) and System Integration Testing (SIT). Experience with Microsoft Test Center, JIRA, Bugzilla.

Confidential, King of Prussia, PA

Business Analyst

Responsibilities:

• Supported Development and Testing phases of the SDLC, by conducting walkthroughs of requirements, providing clarification and facilitating issue resolution.
• Organized many Joint Application Developments (JAD) sessions and Joint Requirement Planning sessions (JRP), walkthrough, Interviews, Workshops and Rapid Application Development (RAD) sessions with end-user/clients/stake holders and the IT group.
• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API to import the Customers using TCA (Parties, Party Sites, Party Accounts, Party Account Uses), Items, Item Categories, Item Revisions, Open Sales Orders etc., from legacy system.
• Analysed user security and access rights in Oracle Financials (R11i) for General Computer Controls and Segregation of Duties issues, working with the Internal Audit Manager and users to identify violations.
• Participated in multiple Oracle apps 11i implementations in multi org/multi-currency scenarios, Order management and worked as areas involving Pricing, Purchasing, and Inventory
• Created specifications and documentation for projects based on the needs of the business through Use Cases and Visio Flows.
• Customized goods receipt notes to track inventory assets and cited return note to ensure asset location during return from tower sites.
• Worked independently in configuring R11I Oracle Network Logistics and its integration with Oracle Inventory,
• Developed a common loader program for interfaces using Shell Script and registered as HOST program in AOL.
• Registered Reports, SQL*Loader Scripts and PL/SQL Packages as Concurrent Programs using System Administrator Responsibility.
• Performed UAT/SIT Testing and provided technical support and utilized Google Analytics to run reports and review promotional campaigns.
• Actively conducted SCRUM meetings and ensured all Agile project techniques are used in accomplishing the tasks based on the dead-lines

Confidential, Hollywood, FL

Business Analyst

Responsibilities:

• Involved in the Software Development Life Cycle (SDLC): Design and Code Development phases and Interacted with QA team for Unit/System testing/Integration.
• Conducted a Joint Application Development (JAD) session with stakeholders and business partners to resolve open issues.
• Designed and reviewed of various documents including the Software Requirement Specifications (SRS), including USE Cases, Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• Customized AP Approval, Requisition Approval and AP Approval workflow for Procurement, developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Reviewed 11i Interfaces and upgraded them to R12 with code modifications. These involved changing APIs, adding additional validations, adding/removing API fields.
• Designed and developed interfaces using PL/SQL to feed the data from custom application to Oracle E- Business Suite Order Management tables.
• Formulated and maintained Requirements Traceability Matrix (RTM) to trace technical requirements to their business requirements and the test case to their functional requirements.
• Developed Order Import Interface for business applications to load header and line details by creating Staging Tables and performing validations by writing PL-SQL package into the Order Import (OE) headers and line interface tables and then to OE base tables.
• Worked with Finance team to resolve any issues related to month end and quarter end close processes in AR, Inventory and General Ledger and data transfers for final financial book keeping.
• Worked on Oracle EBS Procure to Pay modules - Inventory (INV), Purchasing (PO), General Ledger (GL) and Accounts Payable (AP).
• End to end Oracle Applications (GL, AP, PO) implementation project from assessment to production support as a functional analyst.
• Extensively utilized the Application Object Library (AOL) to Register PL/SQL Procedures, forms and reports.