Sr. SAP BO Consultant

Project Name: WIP (Work In Progress) Dashbaord
Industry: Automobile  
Role: Sr. SAP BO Consultant
Tool: SAP Design Studio 16.1.1, BW 7.4
My Responsibilities:
? Requirement gathering for the project
? Understanding the Work in Progress operation and its key features
? Define Project Scope documents and approach towards project
? Manage team members and accountable for all deliverables, pertaining to the assigned projects.
    Manage SAP BO administration including users group and authorization
? Sought out issue and provide best efficient solution
? Direct interaction with client

Project Name: SAP LUMIRA Finance dashboard 
Role: Sr.SAP BO Consultant
Platform:SAP ECC 6.0, SAP BW 7.4
Reporting Tools: SAP LUMIRA
My Responsibilities:
? Finance dashboard ,highlighting the key financial aspects of the organization
? Complete and interactive drill down package, showing actual and budget by controlling area and cost center.
? Showing forecast of actual and budget with respect to cost center, using a Bar chart
? Top 10 actual, budget and forecast by P&L P, using bubble chart
? Total actual and budget with respect to P&L elements
? Actual and budget by Month
? Revenue and expenses comparison by Year, Department and Country wise by applying filters ito the dashboard
? Using ranking feature into the dashboard to analyze the performance in terms of revenue by various measures.
? Send visualizations by using mail feature in Lumira, directly to CFO
? Print Visualizations

Project Name:LUMS Analytics
Role: Sr.SAP BO Consultant
Platform:SAP ECC 6.0, SAP BW 7.3, Oracle 10
Reporting Tools: SAP Dashboard Designer 4.1 SP 6 
My Responsibilities:
? Involved in BO end to end implantation
? Installation of SAP BI/BO 4.1 SP6 server
? Data Modeling at BW level
? Designed BW Queries and analyzed it using BEX Analyzer
? SAP BO Administration
? Developed 5 detailed interactive dashboards based on drill down at a granular level for top level management
? Designed Admission dashboards, CFO, Finance Dashboard, OSPR Dashboards, and Dashboards for Vice Chancellor and Finance Committee
? Provided comprehensive analytics of the applications being submitted and students enrolled in the university
? To analyze the number of applications for admission generated Year, Country, City, Career Group, Program Group and Program Wise
? Current and previous year’s performance based on Year, Country, City, Career Group, Program Group and Program
? Trends showing applicant's interest in the top 5and bottom 5 courses based on applications generated
? To analyze financial at G/L level
? Profit and Loss Statement, Balance Sheet and analysis of revenue generated along with the expenses based on YTD
? Department wise drill down at G/L Level
? Top 5 expense Vs top 5 revenue heads and highlight the department pertaining to expenses and revenue
? Accounts payable aging and Accounts receivable aging and their detailed analysis
? Provided Analytics of Actual Vs Budgeted data
? Provided Analytics of Capital Expenditure (CAPEX) and Operational Expenditure (OPEX)
? Designed detailed OSPR dashboard for grants and evaluation of pending grants, number of proposals submitted, funds approved and funds received.

Project Name: ATLAS HR Analytics
Role: Sr.SAP BO Consultant
Platform: SAP ECC 6.0, SAP BW 7.3
Reporting Tools: SAP Dashboard Designer
My Responsibilities:
? Developed comprehensive and interactive HR dashboard with drill downs
? Performed requirements gathering activities with client
? Worked closely with the BW team in extracting and modeling data from database
? Designed BW Queries and analyzed it using BEX Analyzer
? Comparisons of HR Exit analysis and Exit Trend based on Department, Designation and Supervisory Status
? Department wise analysis and Productivity in last five years
? Used KPIs, reflectingthe average head count, Employment status, length of services etc.
? Dashboard mapping
? Go live the project

Project Name: DHCC Analytics
Role:Sr. SAP BO Consultant
Platform:SAP ECC 6.0, SAP BW 7.3
Reporting Tools: SAP Dashboard Designer SP6, WEBI
My Responsibilities:
? Involved in BO end to end implantation
? Installation of SAP BI/BO 4.1 SP6 server
? SAP BO administration
? Data Modeling at BW level
? Designed BW Queries and analyzed it using BEX Analyzer
? Developed comprehensive and interactive dashboards for 5 modules such as Advertisement, Sick Leaves, Quality Insurance Department and Complaints monitoring dashboard with drill downs
? Performed requirements gathering activities with others
? Worked closely with the BW team in extracting and modeling data from database
? Prototype of Dashboard Layout for Historical and Operational modules
? Finalization of creative and attractive Mobile compatible Dashboard Layout with client
? Coordinate with Client to lock KPIs
? Designed BW Queries and analyzed it using BEX Analyzer
? Data Validation and UAT
? Developed reports on WEBI based on Bex queriesfor Advertisement, QID and Complaints modules
? Designed and developed dashboards in Dashboard Designer for all modules
? Was involved in power user and end user training for Bex, WEBI and Dashboard Design
? Created project related documentation such as KPI Analysis sheet, Gap Analysis Sheet etc.
? Dashboard Mapping
? Go live project