Project Manager Oracle

Naresh Sabhnani

Mail: ***************@**.**

M: 408-***-****

linkedin.com/in/nsabhnan/

EXPERIENCE SUMMARY:

Oracle EBS Techno Functional consultant having 8+ years of experience and specialization in Oracle Modules such as Order Management (OM), Account Receivables (AR), Accounts Payable (AP), General Ledger (GL), Fixed Assets (FA), Subledger Accounting (SLA), CRM and TCA architecture

Experience in working with multiple users in gathering requirements, system analysis, preparing Functional and Technical Design document following AIM methodology

Good knowledge in Oracle Workflow, Oracle Application Framework (OAF)

Strong hold over AutoInvoice, Account Payables, Revenue Recognition (RevRec), Accounting setups and GL posting process

Technically proficient in RICEW components [Reports, Interfaces, Conversions and Extensions] components, BI Publisher, Oracle API’s, Oracle Alerts and Application Object Library (AOL)

Experienced in complex customized environment which involves robust IT processes, multiple instances and coordination with cross flow teams

Working Knowledge to Financial statements like Income statement, Retained earnings statement, balance sheet and have high level understanding of budgeting process

Understanding of Java OOPs concepts and worked on multiple Java based in-house tools

Experienced in using software development methodologies - SDLC, Waterfall, and Agile

Worked over integrating Oracle application functionality with 3rd party tool such as, eCredit for customer credit check functionality, Tidal (TES) for scheduling jobs

Excellent Communication, Analytical, Interpersonal and Presentation skills

Excellent technical project, team & task management skills progressive experience

EDUCATION:

Master of Computer Applications - 2008, Jai Narain Vyas University, INDIA

BSc in Computer Science - 2005, Jai Narain Vyas University, INDIA

SKILLS:

Oracle Modules: Order Management (OM), Accounts Receivables (AR), Cash Management,

Sub-Ledger Accounting (SLA), General Ledger (GL), TCA architecture

ERP: Oracle R12 and 11i e-Business suite

Technical: PL/SQL, Reports, OAF, XML Publisher, shell script, XML, J2EE

Databases: Oracle 11g, 10g

EXPERIENCE:

Cisco Systems, Milpitas CA

Role: Systems Analyst Jan’15 -Current

Roles and Responsibilities:

Root cause analysis and solution for assigned Production Incidents.

Co-ordinate work within the team and review solution / code changes with I2C Architects.

Co-ordinate with cross-functional teams to resolve Incidents having upstream dependencies.

Document and present STF / LTF / PDF solutions for biz critical incidents.

Monitor delivered solution and co-ordinate with biz teams for sign-off's / case closures.

Conduct regular status reviews with Biz/ IT teams and provide plan / ETA for assigned cases.

Working with business users to gather request for enhancement, analyzing and creating design documents, in-depth analysis for impacted objects and providing solution

Involved in analyzing and updating Autoinvoice grouping rules and ordering grouping rules

Taking up small enhancements which impact Revenue Recognition and GL Posting process

Define secondary ledgers with different Chart of Accounts.

Resolving one of a complex problem where data for secondary ledger was not getting posted

Created XML Publisher report to help business in reducing the manual efforts needed in Reconciliation process as:

Worked on setting up AR Receipts classes, receipt methods and Automatic receipt methods

Coming up with multiple solution and working with users to finalize the most effective one

Environment:

Oracle AR, SLA, GL, Reports, Toad, XML Publisher, eclipse, SSH Tectia Client, Kintana, Rally, PL/SQL

Cisco Systems, Milpitas CA

Role: Technical Analyst Feb’12-Jan’15

Roles and Responsibilities:

Analyzing issues with Complex Cisco Print Functionality and providing fixes to move testing

Worked on complete AR cycle from Invoice generation, Revenue Recognition, Creation Accounting, to GL Posting

Implemented Invoice orchestration BPEL process for pulling data from 3-4 sources and interfacing it to AR

Used Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions

Extensively used Records, PL/SQL Tables, Objects, Collections (Nested Tables and Arrays), and Bulk methods to improve the performance of the application

As a module leader I need to co-ordinate with onsite and offshore team

Worked extensively on PL/SQL Stored Procedures, Functions, Packages and Package Constructors to enforce Business rules

Worked on multiple Java based tools for reporting purpose which varied from J2EE to struts framework

Created multiple JSP pages for enhancing User interface RRR tool, created couple of controllers to implement complex business logic

Extensively worked over RICE components for defect analysis, data migration and technical understanding sessions

Worked with QA team in SIT, UAT, and Load testing, Smoke testing and supported them by resolving the issues

Worked on a complex requirement to fetch a PDF from SOA web-service call using only PLSQL

Used Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions

Created web services using SOA and BPEL to import invoices, credit memo and receipts from various integration systems.

Created database objects tables, views, triggers, according to the requirement

Extensively used Records, PL/SQL Tables, Objects, Collections (Nested Tables and Arrays), and Bulk methods to improve the performance of the application

Mentoring and supporting the team in resolving the issues

Environment:

Oracle AR, SLA, GL, Reports, Toad, XML Publisher, eclipse, SSH Tectia Client, Kintana, Rally, PL/SQL

Fullerton Financials, Hyderabad India

Role: Senior Developer Jan’11-Feb’12

Roles and Responsibilities:

Analysis of the Client specifications, Preparation of Design Docs, Test Cases, and Implementation documents

Developed reports and conversion for data migration and validation purpose

Created Packages and complicated data migration scripts in Oracle from scratch for Customer information

Created/Modified the Packages to extract the Customer data and place the files in respective paths

Presenting the Technical Design Document to different cross flow teams and Cisco IT team

Worked with QA team in SIT, UAT, and Load testing, Smoke testing and supported them by providing necessary data to execute the test scripts successfully

Worked on Cisco Specific tools and Interfaces

Supported the defects raised by the testing team mentioned on the priority basis with quick resolution during development phase

Environment:

Oracle CRM, AR, Toad, SQL plus, SQL*Loader and SSH Tectia Client, Kintana, PVCS and Quality Center, PL/SQL,

Cisco Systems, Hyderabad India

Role: Sr. Oracle Developer Aug’09-Jan’11

Roles and Responsibilities:

Analysis of the specifications provided by the clients, Preparation of design Docs, Test Case, and implementation documents

Impact Analysis of the changes to integrate SA’s operations with Cisco’s

Presenting the Technical Design Document to different third parties and Cisco IT team

Co-coordinating with Onsite about the Test Cycle planning

Responsible as the Point of Contact (POC) at offshore

Preparation of the technical documents, Preparation of testing strategy & test scripts and perform Unit, acceptance testing

Wrote/Modified stored procedures, Triggers for Database operations in Oracle

High level integration testing with the members handling the order tool with our ERP, due to cross Flow dependencies involved

Presentations to cross-flow teams and client

Helping the project manager in preparing contingency plan & project planning

Review & Execute the unit test cases

Review the code migration documents

Do the code fixes for the bugs raised during QA testing or UAT

Environment:

Oracle OM, Oracle AR, Forms, Reports, PL/SQL, Java, Toad, SSH Tectia Client, Kintana, PVCS and Quality Center.

Cisco Systems, Hyderabad India

Role: Oracle/Java Developer Jul’08-Aug’09

Project Description:

Customer Partner Account Management (CPAM) initiative was to addresses the need of having one unified view of a customer, which enables a 360º view of a customer through entire commerce transaction lifecycle.

Responsibilities:

Worked as team member and helped in end to end project life cycle from development, testing and support

Working in Technical design document and implementation

Creating interface, package procedure, trigger and views

handled in-house Revenue reporting tool based on java struts technology, activities involved deployment and small enhancements

Worked on Customer Form personalization

Environment:

Oracle Apps 11i, PL/ SQL, Data Loader, Toad, SSH Tectia Client, Kintana, PVCS and Quality Center

Contact this candidate