Sign in

Oracle Sales

Edison, NJ
March 10, 2020

Contact this candidate


Nirmala Musipatla

Tel: (***) ***- **** © / Email: / LinkedIn

Executive Summary

A dynamic, logical thinking, customer focused performance driven IT professional, with 20+ years of experience in Functional, Techno-Functional & Technical with Oracle e-Business Suite applications, including a total 9+ years of Sr. Business Analysis in Oracle e-Business Suite, Salesforce, Zuora, ERP Implementation, Informatica & Cloud (SAAS) integration, Customization, Analysis, Design, Development, Testing, Quality Assurance, Performance Tuning, Maintenance and Operations.


Experienced in Subscription & Billing Process Management, Manufacturing, digital content delivery/entitlement processes & Finance Industry experience.

As a Sr. Business Analyst conducted interviews with key business users to collect requirements and business process information, Fit/Gap Analysis, prepared Business Requirements Document (BRD), Solution design, functional design, analyzed data/workflows by working with the business/IT teams & project managers.

Experienced in Data Cleansing, Conversion, Migration and Integration activities.

Experienced as an Agile PM/BA, Agile/Scrum and Software Testing Life Cycle (STLC)

Experienced in Software Development Lifecycle (SDLC) using Waterfall/Agile process including requirements definition, prototyping, Proof of concept, design, implementation, testing and support.

Hand on experience in 4 full life cycle Oracle ERP implementations.

Hands on experience with Oracle ERP, Designer, Forms, Reports, Discover, SQL & PL/SQL.

Liaised with business stakeholders and functional owners during risk engineering and high-level review sessions to derive & execute action plans, meeting deadlines and standards using prioritization.

Extensively worked on technical feasibility analysis. High-level & low-level design, development, unit testing/planning, training, maintenance, code merge, and effort estimation.

Experience in writing test plans, test cases scenarios (Unit, Integration, Regression and UAT).

Experience in Oracle Application Implementation Methodology (AIM).

Profound knowledge in configuration management tools like PVCS, CVS and Kintana.

Experienced in evaluating and identifying RICE objects.(Reports, Interfaces, Conversion & enhancements)

Hands on Post Go Live support, worked on day-to-day production issues using tools ITSM/ServiceNow.

Experienced in End user training along with user manual preparation.

Experience with current industry Audit standards Sarbanes-Oxley (SOX).

Experienced in Word, Excel, Visio & PowerPoint.

Extremely organized, strong work ethics with Excellent Communication, Interpersonal Skills, troubleshooting and analytical problem-solving skills.

Technical Skills

Agile Methodology: Scrum Master/PM/BA, Azure DevOps, JIRA, Confluence, TFS, Serena, ALM Tool.

Oracle E-Business Suite: Oracle Receivables, Oracle General Ledger, Order Management, TCA with DQM,

Advance Pricing, Bill of Materials, Inventory, WIP, Oracle Purchasing, Oracle Payables, Quality & Alerts.

CRM: Salesforce, Zuora, CPQ, Oracle Service Contracts, Oracle HTML Quoting, Oracle Incentive Compensation,

Oracle Tele Sales, Oracle Sales Online (Field Sales), Oracle Sales Offline, Oracle CRM Foundation, Oracle Content

Management, Teleservice, Depot Repair, Install Base, Field Service, Akritiv & Ungerboeck.

Tools: Appian, Toad, Informatica Cloud, Data Loader, Developer Tools, Zuora Workflow, Oracle Workflow, BI

Publisher, OBIEE, SQL*Loader, Oracle Forms/Reports, Designer 2000, TRS, Serena, HPPPM, Azure DevOps,

Workbench, PVCS, Star Team.

Languages: JSON, Python, Java, C, C++, SQL, SOQL, ZOQL, PLSQL, COBOL, Frotran.

Collaboration Tools: Skype, Microsoft Teams, Outlook, Word, Excel, Visio, PowerPoint.

Software: Power Builder 4.0, Visual Basic 4.0.

Professional Experience:

S&P Global, NY/NJ Lead BA / Project Manager October 2014-Present

Environment: Zuora CPQ, Salesforce, Appian, Oracle EBS R12, Financials, Advanced Collections, Advanced Pricing, Inventory, TCA, DQM. Oracle 11i / Oracle R12 Service Contracts, Advanced Pricing, INV, AR, GL, and System Administration, ORACLE, PL/SQL, SQL, Akritiv, Ungerboeck, Informatica Cloud, JSON, SOQL, ZOQL, Workbench, Postman, Azure DevOps, ServiceNow & Serena.

Supported 20+ Informatica cloud Integrations out of 90+ OTC Integrations in complex OTC architecture.

Implemented new Informatica Cloud Integration using API’s & JSON that automated multicurrency activation so sales could sell products in 16 different currencies.

Implemented transaction error tracking mechanism dashboard, by pulling the transaction errors from applications (SFDC/Zuora/Oracle R12) and integrated into Appian dashboard after post go live for Quotes awaiting fulfillment delay tracking & Stuck Transactions for business users.

As a Lead Business Analyst, Gathered business requirements, creating use Cases, Interviewing the Tech Leads, SMEs and PM on the different aspects of Migrations with 100% data accuracy and data reconciliations.

Worked on Order to Cash (OTC – Subscription management), Data Conversion/Migration Project pertaining to migration of Oracle ERP (11i)/legacy data into Salesforce, Zuora & Oracle ERP R12 using tools like Informatica on cloud.

Used Agile Methodology to release the changes in sprints including story writing, pointing, Sprint Demos and cleared impediments within a project by getting them answered in a timely fashion in order to deliver the overall sprint goals.

Post Go Live OTC support, Worked on day-to-day production issues via Service Now ticketing tool.

Managed operations issues from Salesforce Quotes to Zuora Subscription/Invoicing and reconciliation between Zuora to Oracle AR, and developed offshore team business operations.

Managed financial reconciliations activities between Salesforce Quotes to Zuora Subscription, Zuora Sync, Product Pricing updates, Billing Proration & Auto Renewals for audit, compliance & revenue recognition.

As one of the biggest process improvement, reduced the uptime from 2+ days to day on monthend.

Implemented new Integration to map invoice reference numbers on credit memos.

Coordinated with Business and getting Sign Offs on Business Process Requirements (BPR) and coordinated with Developers and Architects in order for completion of the Project.

Coordinated the testing with Business Users to get signoffs before deployment.

Project Managing including tasks and timelines for Conversion work streams. Coordinating with the Development Manager, and the Developers and track where we are on these work Streams.

Ensured artifacts are based on corporate SDLC Policies, guidelines & change management approvals.

Supported S&P Platts’ Oracle 11i EBS Billing & Subscription Applications for Platts & unified S&P OTC Quote to Subscription Billing.

Implemented Integration between Akritiv Cloud Collector portal & Oracle 11i.

Hands on with API’s, JSON, SQL, SOQL, Workbench, Data Loader, Workflow, ZOQL and Developer Tools.

Canon Solutions America, NJ Oracle Business Applications Analyst MAR’12-SEP’14

Environment: Oracle Applications 11i (11.5.8/11.5.9/12), Service Contracts, Install Base, Field Service, Quality, Oracle Alerts, Order Management, INV, AR, GL, Oracle BI Discoverer 11g, ORACLE 10g, PL/SQL, Oracle Enterprise Linux 5.7 + RHEL4.9, Windows 2007, FrontRange IT Service Management Application 7.1, Serena PVCS, HPPPM.

Integration\Conversion of existing Oracle 11i (11.5.7) system to Oracle 11i (11.5.9).

Implemented Integration between Oracle 11.5.9 Applications to IT Service Management Application 7.1.

Reviewing of Conversion/Interface Implementation Strategy.

Participated in Business requirements sessions & reviewed Testing Strategy for new implementation.

Provided performance metrics data from the existing Oracle 11i system.

Analyzed Business needs and created Technical/Functional Design Documents & Test plans for data validations.

Supported Canon Oracle 11i EBS Applications, and IT Service Management Application.

McGraw-Hill Companies/S&P Global, NY Engineer Oracle Specialist FEB’04-MAR’12

Environment: Oracle EBS R12 Tele Sales, Quotes, BOM, Service Contracts, Financials, Advanced Collections, Advanced Pricing, Inventory, TCA, DQM. Oracle 11i (11.5.8/11.5.7) Service Contracts, Advanced Pricing, INV, AR, GL, and System Administration, ORACLE 9i, PL/SQL, Sun Solaris HP-UX, Windows XP/2003/2007.

Provided Post Implementation Support for Platts Oracle 11i system

Supported Admarc (Platts Advertising) application, Ungerboeck (Platts Conference) application & Horizons (Construction) applications being part of Shared Services Team.

Integrated seamless integration of Bentek acquisition to Oracle 11i.

Implementation involved conversion of existing 11i to R12 with new some additional business rules.

Reviewed Conversion/Interface & Testing Strategy.

Participated in Business requirements & reviewed BRD, FD, TD and BR 100.

Provided performance metrics data from the existing Oracle 11i system.

Implemented Customer Merge (DQM) & Customer data deactivation for legacy data to reduce duplicates.

Implemented Data Warehouse for Platts’ data from all internal/external applications to one source for reporting purpose for finance, marketing and sales.

Developed Functional, Technical Requirements documents & created Test plans for validation.

As part of maintenance & support performed Oracle 11i & Ungerboeck monthends.

Developed custom forms, reports, packages using PL/SQL to support data dump reports & SQL Loader control Scripts for new enhancements.

Previous Work Experiences:

Kravet Inc. - Bethpage, NY

Sr. Programmer Analyst / Oracle Financials & Service Contracts ERP

Nov 2003 - Jan 2004

Expanets - Roselle Park, NJ/ Englewood, CO

Sr. Programmer Analyst / Oracle Financials & Service Contracts ERP

May 2001 - Oct 2003

Ingersoll Rand - Annandale, NJ

Sr. Programmer Analyst / Oracle Financials & Manufacturing ERP

Jul 2000 - Mar 2001

Sony – Park Ridge, NJ

Sr. Programmer Analyst / Oracle Financials & Manufacturing ERP

Nov 1999 - Jun 2000

USCG Finance Center - Chesapeake, VA

Sr. Programmer Analyst / Oracle Designer 2000, Developer 2000 Oracle Financials ERP

June 1998 – Oct 1999

Voters News Service - New York, NY

Sr. Programmer Analyst / Oracle Designer 2000 & Developer 2000

Nov 1997 - Jun 1998


B.E: Bachelor of Engineering in Computer Science from Gulbarga Univ., India.

P.G Diploma: Post Degree Diploma in Business Mgmt. (PGDBM) from Gulbarga Univ., India.

Business Analysis: Certificate in Business Analysis from Mercer County College, New Jersey USA.


Zuora Solutions Architect, Oracle 7.x Client server Systems, Oracle Designer/2000, Oracle DBA 8.0, Oracle 11i

Financials Functional Foundation, Oracle 11i/2.6 Implement Oracle Workflow, R12.x Oracle Advanced Pricing

Fundamentals, R12.x Oracle Financials Functional Foundation & R12.x Oracle Service Contracts.

Work Status: US Citizen.

References: Furnished upon request.

Contact this candidate