Arpan Ghosh

Role: Delivery Head

• Operationalized Business Intelligence solutions and conducted advanced analytics to identify opportunities and strengths to meet business goals.
• Generated key Business Insights from developments like SFE Tracker, Cross Sell & Up Sell Dashboards.
• Managed and Implemented P&L Dashboard, Balance Sheet Reports, Budget v Actual Dashboard
• Developed project plans, assigned resources, lead weekly status call and provided status updates to the function stakeholders
• Experienced in managing large centralized EDWs as well as subject oriented data marts.
• Managed development team of 05 Person and task built across from different functional areas are being managed and supported across the business.
• Conducted presentations for the senior leadership to communicate the status and escalate any issues requiring their intervention. Responsible of creating functional and technical specification
• Responsible for Finance and Controlling projects with the business in organizing, prioritizing and finalizing the scope.

Role: Program Manager - SAP BI & BO

• Created many Proof of Concepts to help understand the requirement with the Business and to analyze the performance issues in the design
• Led the team of BI Consultants (Inhouse + Outsourced) for the implementation of SAP BW/4 HANA.
• Led the cross functional team of BI Consultants to upgrade SP from 05 to 19.
• Extensively worked on data modelling for Management Dashboards which includes Revenue v/s Cost Analysis, CEO
  Dashboard, Inventory Dashboard and Receivables Analysis.
• Worked extensively in the Finance - Accounts Payable (FI-AP) - 0FI AP 1, 0FI AP 4; Accounts Receivable (FI-AR) - 0FI AR 1, 0FI AR
  4; Finance - General Ledge (FI-GL) - 0FI GL 1, 0FI GL 2, 0FI GL 4
• Worked and administer BPC Reporting for Statutory Compliance / External Audit reporting such as Cashflow Reports, HO P&L
  and Balance Sheet Reports.
• Managed 4 employees on-site and 3 consultants off-shore.
• Created the HANA objects like ADSO, Open ODS, and Composite provider.
• Involvement in Project plan preparation, and submission for review with CoE Teams.
• Impact analysis and test strategy preparation and test cases preparation to cover all Confidential BW objects

• Extensively working on reporting in 3.x and 7.3 Versions
• Involved in scheduling and monitoring the monthly, hourly weekly and daily process chains, Data loads (Full/Delta Up-Load) and Data marts
• Technical Manager for GST Implementation across group which consists 7 business verticals.
• Fixing the load issues with Manual re-pulls, reloads and master data issues
• Handling BEX Queries using free characteristics, variables, restricted key figures, calculated key figures and exceptions in query designer
• Supporting issues related to loading and data target design issues
• Developing different type of objects like Info objects, Info cubes, DSOs, DTP, Transformations
• Working on data level authorisations in BEx Query
• Handling and implementing:
  o BEx Broadcasting in SAP BI
  o FI, ISU and Generic data sources
• Involved in:
  o Upgrading from ECC6.0 EHP5 to ECC6.0 EHP7
  o Installation of Sandbox which is copy of BW Production
• Accountable for the bifurcation and stoppage of SAP Multi-Login

Non-SAP Projects

• Managed end-to-end implementation of Google Apps (Mailing Solution) for 1000+ Users
• Handled rollout of CRM application for divisions like: Stationary, Pharmaceutical, LED Lightings, Engineering, Banking & Securities
• Responsible for the rollout of GoDB Application

• Provided support during the implementation as BASIS Admin
• Installed:
  o ECC 6.0 with Oracle 11g database in AIX & Windows Server 2008 Operating System
  o SAP BW both ABAP and Java Stack
• Applying Support packs, Kernel patch, and SAP Notes when necessary
• Managed daily backup of production server with BRTOOLS (BRBACKUP & BRRESTORE) & Weekly backup of Development & Quality server using DB13
• Created, scheduled background jobs and resolved any terminated jobs
• Monitored CPU utilization, file system, disk space and analyzed top CPU users
• Oversaw the DBA planning calendar for database system check and others
• Analyzed system logs, table lock and updated errors
• Generated Solution Manager keys and developer key

• Administered & designed LANs, WANs internet/intranet and voice networks
• Responsible for clear traffic of network for transmitting the pages of different editions to the press on time
• Analyzed & developed key components using methodology prescribed techniques
• Communicated and negotiated with users, specialists, other staff and suppliers
• Investigated, diagnosed and resolved all network problems
• Managed network connectivity troubleshooting, ping, tracert, telnet
• Handled cisco switch configuration in particular VLAN configuration/troubleshooting