SUMMARY:

• Sr. Business Analyst with 13.5 years of experience in Oracle Applications with specific focus in Finance, OTC and PTP domains. Conversant with all the phases of a project life cycle including requirement analysis, design, development, implementation, customization, conversion, testing and production support.
• Currently working at Sunrun for more than 4yrs as account manager/architect/functional lead and contributing in various ongoing initiatives.
• I worked as a Programmer/Analyst in the areas of Order Management, Receivables, Revenue Recognition, Advanced Collections, General Ledger, Inventory, Payables, Cash Management and Service Contract. I worked as architect in designing key processes in billing, Revenue, Collections, General Ledger
• Managed team of 15 technical resources ( Onsite/offshore)
• Project planning and resource management
• Architected processes for revenue, billing, collections, chargeback, goodwill credit, Open balance Write - off process, Suspension Resumption & Termination, Cash application, month end reconciliation processes, FTP for partner accounts, Service address level taxation, financial data integration, modeling multi-org for SaaS
• Implementation of Oracle Application R12 with focus on Account Receivables, Revenue Recognition, EB-Tax, Sub Ledger Accounting(SLA), General Ledger, Cash Management
• Enhancement of processes in Account Receivables, Account Payables, FA, Advanced Collections, OLFM
• Implementation, Customization, Migration, Development and Testing of Oracle Applications 11i with strong focus on Order Management, Account Receivables, Account Payables, Advanced Collections, FA and OLFM
• Prepare Business requirement, functional and technical design documents
• Production support for R12/11i ( Finance, OM, OLFM modules)

TECHNICAL SKILLS:

Software: Oracle SQL*Plus, Oracle Developer Reports 6i, SQL*Loader, TOAD, Workflow 2.6, Kintana, Test Director

Programming Languages: SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Project Manager/ Sr. Oracle apps Functional/ Architect

Confidential, CA

Responsibilities:

• Preparing project plan
• Managing technical resources (onsite/offshore)
• Analyzing Business requirement and Preparing conceptual design
• Initiating deep dive design discussions with all key stake holders
• Architected - AR/AP netting, revenue recognition and accrual processes
• Designed AR processes- Retail invoice billing, revenue amortization schedule correction
• Designed AP processes- Advance milestone payment, COGS recognition
• Designed FA Processes- Asset retirement and asset cost correction
• Functional setups for AP, OLFM, FA, AR, GL, Sub Ledger Accounting
• Preparing UAT plan and test scripts
• Cut-over activity co-ordination with cross functional teams
• Post Go-Live support
• Month end close support activities

Environment: Oracle Pl/Sql, Oracle apps R12, GitHub

Sr. Oracle Apps analyst/Functional

Confidential, CA

Responsibilities:

• Interaction with Business, gathering requirements, writing design document
• Preparing conversion strategy for routing existing AR transactions through new revenue engine
• Prepared detailed test and execution plan for all revenue models
• Prepared reporting and reconciliation strategy
• Prepared month end close activity plan

Sr. Oracle Apps Analyst

Confidential, CA

Responsibilities:

• Analyzing the Business process and requirements - Understanding Business and Functional processes flow. Clarifying requirements with Business.
• Writing design documents - Proposing design approaches to the Business process owners with Proof of concept. Preparing design documents as per AIM (Applications Implementation methodology). Reviewing design documents with Business owners and cross functional team.
• Architected processes like- Billing Invoice, Revenue recognition, Suspension-Resumption- Termination process, Chargeback, Refund, Item interface, Customer Interface
• Functional setups for AR, GL, Sub Ledger Accounting, EB-Tax
• User interaction and coordination with cross functional teams.
• Peer review of design documents - Reviewing design documents for other track and team members
• Writing test cases - preparing test plan documents including test scenarios
• Test plan execution- co-ordination of testing with cross functional teams, QA teams

Environment: Oracle Pl/Sql 10g, Oracle apps 11i/R12, Software configuration management, CVS

Sr. Oracle Apps Analyst

Confidential, CA

Responsibilities:

• Analysis of Business requirement
• Preparation of Solution Design document for revenue recognition
• Preparation of Test plan & test scripts
• UAT co-ordination

Environment: Oracle Pl/Sql 9i, Oracle apps 11i (AR, Revenue Recognition)

Sr. Oracle Apps Analyst

Confidential, CA

Responsibilities:

• Analysis of Data Extract Template for data mapping between systems
• Mapping of Source data like KFF structure to Reporting system
• Preparation of Technical design document
• Development of Pl/Sql Package, Procedures, Functions
• Development of Test Cases
• Development of Extract based on the logic of reconciliation
• Data reconciliation with Account Analysis report & Journal Entry Reports in GL

Environment: Oracle Pl/Sql 9i, Oracle apps 11i (AR, Advanced Collections)

Sr. Oracle Apps Analyst

Confidential, CA

Responsibilities:

• Interacting with business users for any production issues & Enhancement requests
• Preparation of Functional & Technical design document for enhancement
• Enhancement of Invoice import program for sales tax calculation, customer PO info, VAT tax details
• Enhancement of advanced collections for Collector assignment, restructuring the strategy work items
• Enhancement of customer interface for termination date population, new payment methods.
• Development of automatic write off program for writing off Inactive accounts
• Development of Pl/Sql Package, Procedures
• Enhancement of OM import for Importing Bundle orders
• Setting up new payment methods
• Development of credit card charge API for iportal application
• Debugging & fixing the production issues

Environment: Oracle Pl/Sql 9i, Oracle D2K, Oracle apps 11i (AR)

Sr. Oracle Apps Analyst

Confidential, CA

Responsibilities:

• Interacting with business users for requirement collections.
• Preparation of Functional & Technical design document
• Preparation of BR-100 documents for all functional setups
• Setting up of all functional setups i.e profile setups, collector setups.
• Involvement in User Acceptance Training, Bug fixing.
• Involvement in End User Training i.e On-line demo on application, Preparation of Training document.

Environment: Oracle Pl/Sql 9i, Oracle D2K, Oracle apps 11i (AR, Advanced Collections, CRM Admin)Oracle Apps Analyst

Confidential, PA

Responsibilities:

• Analysis of MD070 design & sign off
• Code review to compliance with functionality
• Unit testing per TE020
• Assigning defects to design team thru Test Director
• Providing technical details to design team for the defects.
• Interaction with functional team, design team.
• Migration of codes to another instances thru Kintana packages
• Debugging of issues related to Kintana migration
• Development of Pl/Sql Package, Procedures, Functions

Environment: Oracle Pl/Sql 9i, Oracle D2K, Oracle apps 11i ( OLFM, AR ), Advanced collections, Kintana

Oracle Apps Analyst

Confidential, CA

Responsibilities:

• Analysis of Functional design document.
• Preparation of Technical design document
• Interaction with client for daily status of project and requirement clarification
• Interaction with offshore team for development
• Review of codes/Unit test cases developed by offshore team
• Release of codes and unit test cases to client for review
• Migration of codes to another instances thru Kintana packages
• Debugging of issues related to Kintana migration and QA / UAT

Environment: Oracle Pl/Sql 9i, Oracle apps 11i (AR, OM)

Oracle Apps Analyst

Confidential

Responsibilities:

• Analysis of interfaces for up gradation.
• Preparation of ASIS document.
• Preparation of Technical Design Specification
• Up gradation of interfaces as per 11i tables structure Preparation of Unit test cases
• Development of Pl/Sql Package, Procedures, Functions

Environment: Oracle Pl/Sql 9i, Oracle apps 11i/10.7 (OM)

Oracle Apps Analyst

Confidential

Responsibilities:

• Analysis of functional specs of reports
• Preparation of Technical design documents for reports
• Coding as per Technical design doc
• Release of codes and unit test cases for review
• Development of Pl/Sql Package, Procedures, Functions

Environment: D2K Report6i, Oracle Pl/Sql 9i, Oracle apps 11i (AP, OPM, PA)

Oracle Apps Analyst

Confidential

Responsibilities:

• Analysis of interfaces for up gradation.
• Preparation of Technical Design Specification
• Up gradation of interfaces as per 11i tables structure
• Performance tuning of reports
• Customization of AP invoice approval workflow for approval hierarchy
• Customization of AR Credit Memo Approval Process Workflow
• Development of Pl/Sql Package, Procedures, Functions

Environment: Oracle D2K (6i), Workflow 2.6, Oracle PL/Sql 9i/8i, Oracle apps 11i/11 (INV, PO, AP, AR)