Advisor
Dell International Services Private Limited
Total years of experience :18 years, 10 Months
Oracle- Business System Analysis
Project Title : Star Project - F16/FY17
Duration : Star FY16 -
R12.1.3
Responsibilities :
•To have daily meetings with MASCOT development team to understand in-depth of the requirements from outbound interface from AP to MASCOT.
•To explain the current solution in the outbound interface from Novora and MASCOT
•To map the data requirement from MASCOT and the data captured in Oracle AP and other dependency to the scope of the project.
•To provide a functional solution in Novora to capture additional information in Oracle and send in the required data to MASCOT to improve future projections and bridge the existing gaps in the reporting tool.
•To do the MD050 Kick off meetings and 25%, 50% and 90% review calls with the business and other stakeholders in the project.
•To get approvals for the MD050, and coordinate with the development team to review the changes to be updated in the MD070 and provide approvals.
•Support the Dell performance testing team on the process and to involve business partners in UAT for testing and sign-offs
R12.1.3
Responsibilities :
•Sizing of Concur Phase V Project.
•To update the BRD and get the required approvals from stakeholders.
•To have regular meetings with business to understand the functional aspect of the requirements and the dependency on other modules and external systems to R12.
•To have review calls and to do the MD050 Kick off meetings and 25%, 50% and 90% review calls with the business and other stakeholders in the project.
•To update the solution accepted by the stakeholders in MD050 of the component.
•To be a part of the MD070 review calls and provide recommendations and approvals for development and deployment of the changes in production.
•To coordinate with the performance testing team support the criteria that needs to be tested.
•To prepare test scripts for UAT and get the approvals.
•To support the business during the final testing and gather the sign offs
R12.1.3
Responsibilities :
•To improve the outbound interface with Novora and Dell Market Costing Tool (MASCOT)
•To study the business requirement and its impact on the changes in Novora.
•To conduct MD050 Kick off meetings and 25%, 50% and 90% review calls with the business and other stakeholders in the project.
•To provide a functional solution in Novora to capture and send in the required data to MASCOT to improve future projections and bridge the existing gaps in the tool.
•To get approvals for the MD050, assist the performance team on the process and to involve business partners in UAT for testing and sign-offs
R12.1.3
Responsibilities :
•To engage with the business partners, technical leads and informatica consultants to understand in depth the current usage of Applimation tool in 11i for archiving data related to Financial Modules.
•To study the business requirement and its impact on the system for rolling out the archiving functionality of applimation tool for Oracle Projects module.
•To highlight the changes on Oracle tables in R12 for transactions currently archived that would need the archiving rules in applimation to be fine-tuned for R12.
•To understand and formulate testing scenarios for CRP and UAT for data before archiving and after achieved.
•To identify reports effected on archiving responsibilities via SLA and other changes to tables and to involve Oracle technical team to work on standard reports and other custom reports to fine tune the results.
•To involve performance testing team to conduct a performance testing on the effected reports fine-tuned for R12.
•Conducted CRP1, CRP2, UAT with business involvement and systems control group at Dell
R12.1.3
Responsibilities :
•Driven the R12 Upgrade Project for Procure to Pay Modules for the existing Oracle E-Business Suite (Novora) as Oracle will discontinue customer support for version 11i in Nov 2013
•Completed a detailed R12 assessment of business challenges (pain points) and existing customizations and reviewed the new R12 functionality to determine best fit for Dell business and stakeholders.
•Performed a technical upgrade in test environment on the Recommendation for Novora R12 Upgrade feature-set and sized the project in mid-2012 to obtain project funding for FY14 roadmap
•Conducted workshops on future state requirements for P2P processes (Purchasing, Payables, Novora System Close, Intercompany, Inventory, Tax and Multi-Org) to understand ‘Current State’ process, pain points and improvement opportunities, Road blocks and dependencies, Benefits, risks, concerns, ‘Future-State’ design recommendations.
•Mapped as-is and to-be process flows in Novora and reviewed flows for impacts to current Novora R12 upgrade. Interacted with Deloitte and other partner consultants on the project to streamline various process as per the business needs.
•R12 Upgrade Timeline
•P2P workshops completed 8/19
•BRD workshops completed 8/8
•BRDs to be approved by 8/17
•CRP1 (minimal business involvement) - 78 components plus regression testing of standard functionality
•CRP2 w/increased global business involvement (~75% of code ready)
•UAT - heavy global business involvement - 100% of code ready, with business involvement from Austin, Bratislava, India and Penang to ensure current and new functionality works properly for all regions and organizations
Project Title : GERP
R12.1.3
Responsibilities :
•Manage Incidents in HPSM and worked on RICEFW components.
•Prepare FD and get it approved on Product Enhancement Request.
•Provide test cases in Mercury Quality Center and assist in UAT and deployments.
•Worked on planning Upgrade Activities of 12.0.4 to 12.1.3 instance
Oracle AM
Project Title : R12.1.3
Project Title : 12.0.4 Upgrade & AM
R 12.1.3 Period end closing Q2 & data migration
Project Title : 12.1.3 Implementation
R12.0.4 Rollouts & Data Migration
Project Title : 12.0.4 Implementation
Project Title : 11.5.10.2 Implementation
Oracle R12 EBS (Novora)
Mascot Phase IV (Outward Integration
Concur Phase V (Inward Integration)
Novora R12 Upgrade
Applimation Tool
Mascot Phase IV (Interlock)
R12.1.3
Responsibilities :
•To conduct Concur Phase V Novora Sizing.
•To get approval for the Concur Phase V BRD from all stakeholders.
•To provide solution in Novora MD050 for the effected componnent for bringing in both the expense and tax lines for all countries from Concur.
•To provide solution for the process change in Brazil and Chile for its employees.
•For Poland and Croatia, business process change from Individually Billed Individually Paid (IBIP) to Individually Billed Card Paid (IBCP) and this would impact Novora on Payment to AMEX and remittance files to Concur process
Oracle R12
Oracle Application
Responsibilities :
Payables
•Confirmation of outstanding bills with the statement received from the parties.
•Reconciliation of Statement of Accounts on a quarterly basis.
•Preparing the Cheaque on a daily basis for vendors.
•Releasing the Cheaque based on the due dates applicable.
Receivables
•Reconciliation of Statement of Accounts on a half yearly basis.
•Providing reserves based on the history of Cash discounts, Credit notes.
Fixed Assets
•To ensure adequate coverage of Insurance on the basis of Assets.
Banking
•Preparing Bank Reconciliation Statement.
MIS
•Provisional Profit and Loss Statement for the month.
•Analysis of Prime Cost for the past two month.
•Quantity Sold or Dispatch Comparison for the past two months.
•Factory and Administrative Overheads Distillery and the Head Office.
•Selling and Distribution Overheads for the past two months.
•Comparison of Rectified Spirit Purchase Price & Neutral Spirit Direct Purchase Price.
•Brand Wise Contribution i.e. profit for each brand.
•Cost Sheet brand wise.
From:
in
From:
Standard Institution Name:
