Oracle Apss Techno Functional - Supply Chain,Finance

Summary :

Oracle EBS Techno Functional Senior Business Analyst with 14+ years of industry experience in development, support, analysis and testing of Supply chain/Finance module within Oracle EBiz Suites (P2P, MFG, INV, WIP, OTC, AP, AR) projects for many Fortune 1000 clients like Google, Riverbed, Johnson & Johnson, Lexmark etc.

Highly recognized and recommended within IBM and also from client’s business and IT stakeholders for problem solving abilities, strong PL/SQL expertise, Oracle ERP functional knowledge and overall work ethics with hands on coding abilities. Best Achievers Award from GOOGLE INC or Client Dedication Award, BRAVOAWARDS from IBM are some of those special awards.

Hands on Experience with RevPro Implementations and Deep Business Acumen in supply chain and finance operations, including various process like O2C, P2P, GL Processing. Knowledge of Tax Integration in terms of business processes with financial systems.

Extensively involved in working with business users, identifying functional and technical gaps, estimating work to fulfill business requirements, designing custom solutions, programming, scheduling, documentation, and production support.

Expertise in Support Production issues on a day to day basis including month end closure p1 issues or functional Support for SOX and PWC Audit

Extensive familiarity with application Implementation Methodology (AIM) for different phases i.e. gathering requirements, analysis, design, build, test, transition, training & production or Handling customer cases, testing and resolving by interacting different teams.

Specialized in Documenting business process, activity flows and sequence diagrams.

Proficient in set up application system based on setup documents (BR100), reviewing business & functional specs documents, reviewing data and process flows.

Good understanding in Quality assurance activities for testing System & UAT; developing test strategy & plan for system, integration, and upgrade tests.

Expert in developing procedures and functions using SQL and PLSQL

Have strong interpersonal and relationship management skills. Preparing resource, Job allocation and performance reports for management. Always recognized as a Great Team player and also both individual contributor or Lead with steep learning curve

Awards:

Best Achievers Award from GOOGLE INC for outstanding work in Oracle Tuning Project.

Client Dedication Award from IBM

BRAVOAWARDS from IBM

Skills:

Oracle Ebiz Modules : Purchasing, Order Management, Inventory, Manufacturing, Shipping, Pricing, Cash Management, AP,AR

Release Version: 11i,R12

ORACLE Tools: SQL*Loader, SQL*Plus, Discoverer 9i, SQL, PL/SQL,D2k,Reports Forms, Oracle 9i/8i,

Revenue Management Tool : Revpro

Databases: Oracle, Sybase, MS Access

Modeling Tools: RationalReqPro,Relational Rose, UML, MS Visio

Database Tools: TOAD, SQL Developer

PM Tools: MS-Projects, MS-Office suite

Professional Experience:

Riverbed Technology

May 2013 – Till dated

Role : Senior Business Analyst

Riverbed uses Revpro (Leeyo software) tool for their revenue module. This project is mainly to deal with the oracle integration between the riverbed system and revpro module.

Some of the activities / responsibilities include :

Understanding the business of the client as well as "As-Is" business processes and reports, with special reference to OTC cycles.

Gap Analysis between the existing processes, standard processes and reports of Oracle Applications. I.e. preparation of Business Requirement Documentation (RD20 Questionnaires), Process Mapping (RD20 Process Definition) using AIM Methodology.

Documentation of Future Business Requirements (BP-80) & Requirement Mapping document (BR 30) as per AIM Methodology.

Preparation of BR 100 Setup Document based on Previous Documents.

Setup of UAT instance for testing and subsequent setup of CRP Instance.

Extensive knowledge in drop ship as well back to back(B2B) order flow.

Developed Test Plan and Scripts for different Modules.

Worked on different setups in the order flow process like different order types setup etc.

Extensive Testing done for OM,INV,MFG modules.

Have successfully completed some multicurrency setups and also experience in working multi-org structures

Training the End users & Preparation of Training Materials.

Gathering Report Formats for custom reports and working with Tech Team for development.

Development of FSG Reports as per Business requirements.

Involved in resolving functional issue which user face in the time of Order booking

Need to interact with business to convert their requirement to oracle apps environment, Preparing the BRD docs for technical team and resolving all there functional concern related OM area

Documentation of existing logic of each report/extraction.

Re-design different production objects

Coordinating with onsite lead for getting the clarifications related to the issues

Coordinating with the offshore members as well

Google INC,MountainView

Jan 2008 – May 2013

IBM

Role : ERP Senior Developer ( Supply Chain)

This project has been identified as one of the most visible Production Support Ebiz project within Google as it involves external entities and Google's key client and suppliers. The business goal behind this project was to streamline the daily interaction of Google's supply chain and Order management activities to provide a better customer support. Abarna is playing the role of a key techno functional resource representing IBM to support the production process and also help Google's DEV team by providing suggestions on fixing critical production issues, introducing new process, new enhancements or correct tool selection etc.

Some of the activities / responsibilities include:

This production support project involves providing extensive support to Google’s day to day work

Solving different urgent, high as well as medium priority ticket within the decided SLA.

Involve extensive client interaction to discuss the daily discrepancy in Google’s Inventory with supplier, which leads to finding out the root cause of the inventory Delta.

From OM perspective her job involves, providing solution for all the issues that issue user faces while performing the drop ship OM cycle which includes problem in PO, problem with receiving etc.

Job involves Consulting with suppliers for material movement process and need to implement this in oracle .It also includes 24 hours support in month end activities for closing the period.

Extensive involvement in solving critical ticket problems like different types of production issues,issues while creating there expense reports, purchase orders, requisitions and also issues related to different type payables problem such as problem in expense report importing, problem in invoice import etc.

Provide solution for different types of Workflow related problems

Exposure to different setups in production such as bank setups, AP distribution sets, Inventory setups, new entity etc.

Involved in development of Oracle reports, database analysis, data mapping activities, status meeting, and onsite offshore coordination.

Direct interaction with the Google users/employees,understanding there requirements and giving them technical solutions

Documentation of existing logic of each report/extraction.

Re-design (Technical) different production objects

Coordinating with onsite lead for getting the clarifications related to the issues

Coordinating with the offshore members as well

Abarna has achieved couple of very prestigious awards like IBM BRAVO award for outstanding performance in the project and Google Best Achievers award for the outstanding work in oracle tuning project.

Johnson & Johnson

Jul2006 – Dec2007

IBM

Some of the activities / responsibilities include:

Abarna’s responsibility involved extensive hands on work on in Transportation, Order Management, Shipment, Accounts payables, Accounts receivables.

Extensive handling of service requests which typically fall under Q2C modules which generally Transportation, Order Management, Shipment

Understand the existing transportation model of Nordian.

Involved in development of Oracle reports, database analysis, data mapping activities, status meeting, and onsite offshore coordination.

Documentation of existing logic of each report/extraction.

Re-design (Technical) transportation model.

Develop the shipping documents (Reports).

Involved extensively in the testing life cycle of the project

Developed Application screens for providing authority limit to examiner.

Responsible for increasing the performance of batch reports by making changes in the database structure.

Maintained security features that control access to the database.

Maintenance of source code, quality documents using PVCS version manager.

Maintaining quality procedures related to the project.

Conformed to client coding and document standards.

Consultant for delivering technical solutions for Customized Oracle applications in Client Location - Toronto, CANADA.

She was handling Oracle apps customization requests from client, during which I was involved in the following activities:

Size /Schedule Estimation of Client Requests

Design of Technical Design Specification from Functional Specification

Coding & Unit testing

Issue resolution and reporting/escalation

Quality related activities for ISO Audits for the project

Rolling out Trainings & Interviewing

Knowledge Transfer sessions with onsite.

She had also worked with different interfaces along with reports(RDF and discoverer).In addition to this I also have worked on XML Publishers object and delivered to client successfully

Got appreciations from client for good analysis and successful implementation. Good appreciation for my outstanding performance.

Lexmark,Lexington,USA

IBM

AUG 2003 - June 2006

Analyzed system specification and involved in creation of technical design.

Coding consists: Creating several procedures and functions and packages. Designed and developed several critical reports of modules Purchase, Sales, Inventory, General Ledger, Accounts Payable, and Accounts Receivable.

Developed several critical reports for normal and preprinted stationary.

Involved in unit testing and integration testing

Involved in Implementation and user training.

Contact this candidate