GDS ConsultingSAP BW Consultant

At EY youll have the chance to build a career as unique as you are with the global scale support inclusive culture and technology to become the best version of you. And were counting on your unique voice and perspective to help EY become even better too. Join us and build an exceptional experience for yourself and a better working world for all.

Ernst &Young
Job Description

Job Title:
BW/HANA & BOBJ specialist Job Rank (must note a single rank only for each job description):
Assistant Director
Function:
IT Services CBS Scope (indicate either global/cross-border or local/country):
Global / Cross-border
Sub Function:
MST Technology Reports to (Job Title):
Application Technology Lead
About Program Mercury

Program Mercury is a large multi-year enterprise-wide process transformation that will replace more than 1400 EY business systems and related processes with an integrated SAP centric platform that will standardize and harmonize activities throughout the organization and significantly improve how EY manages its business. Program Mercury is a key enabler of EYs Vision 2020 directly supporting the efforts of a number of transformation initiatives across the Firm by streamlining the application portfolio reducing operating costs and providing a platform to deliver services more efficiently.

About the Mercury Solution Support Center (MST)

As an organization jointly owned by the business and IT the MST is a centralized and global organization which will provide operational support for the delivered Mercury solution and manage and support the Mercury user community. The MST will play an integral role in governance of the Mercury solution and the global template from both a business and IT perspective and will evolve to work closely with the business in enabling the benefit and value to be realized from the investment in Program Mercury and to set the furture direction and technology road map to support Vision 2020.

Technical integration management is one of the four core functions of the Mercury support Team and its key to Operational Stability function will provide an appropriately resourced and skilled organization that will:
accept the delivered Mercury solution from the Program and provide integrated seamless functional and technical support
take accountability for the delivered Mercury solution and deliver services in line with defined service targets to the Mercury user community
act as the single point of contact for vendors delivering support services across the integrated Mercury application landscape
enable the Program Team to focus on the continued deployment of the global template and ongoing localization requirements.

Job Summary:
(Briefly describe the main objectives and purpose of the job. Why does the job exist What is it expected to accomplish)

The BW and BOBJ support Specialist Manager will play a key role in the support reportings and analytics in BW and BOBJ reporting based on associated technology solutions which leverage or integrate for SAP ECC CRM SRM CLM CPM and GRC. BW/HANA lead will work closely with the Technical Integration Manager and the process aligned Service Delivery Managers to provide specific technical expertise regarding the integrated solution which is required to run each business process including knowledge of the dependent and impacted applications and the associated inbound or outbound interfaces.

This role is to support Mercury multi generation SAP production maintenance and support of reporing and analytics assist application Technology leadership with the definition of reporting models and analysis required for each business process area ensuring that both the functional and technical support teams have the required knowledge of the integrated reporting solution and how it is supported.
Incumbent in this role will receive and take ownership of the BW reporting and analytics artifacts and deliverables provided by program implementation team for support and maintenance which will be defined by the program team and will take the accountability for the end-to-end support of reporting in BW HANA BOBJ COFI analyzer systems including the monitoring restart recovery and house-keeping procedures.

Reporting analyst will assess the impact of changes to reporting solution and will provide challenge and validation of estimates provided by vendor and internal teams. Role will work closely with the SAP Product Experts SDMs and the SAP AMS Support team to ensure that proposed solutions are supportable by design and must consider the ongoing impact to support requirements and the ability to maintain system currency and integrity in line with agreed technical road maps.

Essential Functions of the Job:
(Identify and describe essential functions or primary duties and responsibilities. Assume that the reader does not know the role or function of the job.)

Responsibility for the support of the reporting and analytics in Mercury solution support
Responsibility for the support and proactive BW/HANA reporting data feeds which send data to or from the core SAP applications
Researching complex application integration and reporting issues with functional teams; examine integration between various systems (SAP and non-SAP) for inconsistencies review transformation logic and propose corrective alternatives
Utilizing knowledge of defined reference architectures technology trends and implementation experience in order to translate business requirements into a solution blueprint that represents an end-to-end technical solution.
Input to the definition of the solution road map integrating multiple disparate processes and addressing short and long term organizational needs
Creation of detailed solution documentation and presentations
Leveraging standard processes and architecting innovative solutions for timely execution within the agreed time lines and the cost
Day-to-day maintenance of production application systems
Ensures that changes to SAP are delivered in line with the business standards in terms of development and testing
Ensures that changes to dependent applications are viable in SAP and do not cause a detrimental impact to production
Retains in-house technical knowledge to validate and where appropriate challenge technical solutions and the associated cost hen delivered by external vendors.
Solution design for integrating SAP products identifying potential gaps and identifying possible solutions for bridging these gaps.
Performance tuning of the integrated solution
Leading integration activities during upgrades and major releases with multiple stakeholders
Make informed judgments and take appropriate action regarding issues which may potentially impact the quality of services delivered via the MST
Analyze requirements from the business and take appropriate steps to define action plans which are detailed meaningful and set expectations appropriately with the business
Analyze service performance based on data provided and interpret the data to determine the quality of the service validate this against the user perception of the service
Determine when it is appropriate to escalate and use judgement and experience and to determine the most effective course of action
Working with implementation teams on program mercury for new deployments.

Analytical/Decision Making Responsibilities:
(Describe the kind of problems and challenges typically faced and decisions required to perform the job as well as recommendations made to supervisors or others. Focus on the nature of existing policies precedents and procedures used to guide decisions and the degree to which the incumbent is free to make decisions requiring interpretation and judgment. Provide an example.)

Make informed judgments and take appropriate action regarding issues which may potentially impact the quality of services delivered via the MST
Analyze requirements from the business and take appropriate steps to define action plans which are detailed meaningful and set expectations appropriately with the business
Analyze service performance based on data provided and interpret the data to determine the quality of the service validate this against the user perception of the service
Determine when it is appropriate to escalate and use judgement and experience and to determine the most effective course of action

Knowledge Experience and Skills Requirements:
(Describe the knowledge or skills needed to perform this job; these may be technical managerial or behavioral in nature.)

Experience handling highly critical and sensitive BW on HANA production issues.
Experience with data tiering and sizing on BW on HANA optimization.
Knowledge and experience with BW process chains fom ECC and CRM/C4C.
Experinec with daily integration of ECC to BW to EDW systems for reporting.
Experience working with Process Chains Data Load Issue resolutions
Experience working with performance tuning of the data loads
Experience working with migration of BW to HANA database
Experience working with ODSO ADSO Composite providers in BW on HANA and EDW layers
Experience working with NetWeaver products
Experience with SAP Business Intelligence and analysis tools (Webi and Analysis for Office)
Experience with SAP mobile solutions and usability products
Hands-on experience with data migration
Hands on experience with Incident Management related to BW data issues
Managing offshore resources for development related to break fixes incidences
Good understanding of software development testing and release management.
International experience and experience working with global ERP roll-outs
In-depth knowledge of the relevant functional area: Procurement Finance Engagement Management
Knowledge of IoT Big Data HANA Vora.
Data Modeling: Info Cube design Info Source Info Object maintenance ODS object Multi Provider Update rules Transfer rules Info Packages Info Package Groups Key figure and characteristics BADI - Restricted and Calculated Key figuresCMOD Virtual key figures.
Worked on Information broadcasting and VBA MACRO EXCEL. Sound knowledge in Visual composer. Published the Reports on the Enterprise Portal Dashboard
Hands-on experience in Universe Design using Universe Designer / Universe Design Tool.
Performance Tuning: Rollup Collapse Aggregates Reconstruction and Partitioning of Info Cubes Indexes.
Experience in the design and implementation with SAP Business Objects BI Product Suite Web Intelligence Explorer Xcelsius Visual Intelligence and Mobile BI .
Built complex WEBI reports by combining 3 OLAP universes using Merged Dimension
Prepared User manual/authorization roles and also trained business users about WEBI functionalities.
Exclusively worked on WEBI by using variable calculations merged dimension sections Input Controls Rankings Query filters as well as Table filter functionalities.
Built Cross Table Column and Stacked Charts according to functional requirement provided by business users..
Experience with SAP Business Objects BI Suite Tools Web Intelligence Xcelsius Explorer Lumira
Experience in Universe Design using Universe Designer / Universe Design Tool.
Worked on Performance tuning of WEBI and BEX reports by using Query Stripping BI Indexes BI statistics Aggregates Partitioning of Info cube and also OLAP based Cache.
Extensively worked on the expert routine to load data from Inventory cube for Store Obsolescence report.
Activated and enhanced standard PM Data Sources and also Data Modeling in BW system.
Experience with Business Objects Enterprise / SAP Business Intelligence Analytics Platform 4.0.
Hands-on experience in Universe Design using Universe Designer / Universe Design Tool.
Knowledge of business intelligence best practice processes tools standards and practices.
Extensively worked on SAP BW functionality like LO Extraction update routines as well as developed custom BW cubes and queries for specific user requirements that could not be met by using Standard Business Content.
Worked on extractions from heterogeneous Source System including SAP and non-SAP Developing SAP BW Objects applying extended Star Schema modeling principles in Data Design used expert knowledge of data warehousing concepts Info Cube data design and reporting
Designed Sales MultiCubeover the Sales order Delivery and Billing cubes to provide visibility of data across the sales cycle in the same query
Activated Standard Business Content and loaded large volumes of production data into Info Cubes pertaining to SD MM.
Configured and activated SAP BW Adapter in CRM to extract CRM related objects into BW.
Extended Activity Data Source 0CRM SALES ACT 1 in CRM to add custom fields like owner Id and buyer contact fields
Created custom Master Data Sources using tables views domains ABAP query and set up Delta for custom fields.
Extensively worked on reporting using BEx Analyzer created calculated and restricted key figures variables exceptions conditions jump queries and Excel properties to meet client requirements.
Implemented BW Web reporting and well versed with Web Publisher Wizard to publish views on the web.
Involved in translating business process into business and technical requirements.
Created Generic extractors/Cubes/ODS/objects in BI.
Involved in creating Data Sources Info sources and Transformation.
Extensively worked on extracting the data from SAP R/3 and Flat Files to SAP BI.
Extracted data from different modules in SAP ECC like FI/CO CRM modules.
Extensive work done on Process Chains as well as performance enhancing Aggregate tables and system settings and parameters to speed up loading as well as reading of data.
Experience to design and Enhance existing master data and transactional data extractors.
Worked extensively with loading Transactional data.
Created Multi providers by defining to utilize the existing data of the Basic Cubes and enhance reporting flexibilities.
Worked on Restricted Key Figures RRI Calculated Key Figures Exceptions Conditions Variables and Filters.
Experience with Business Intelligence/ Datawarehouse data store design Datawarehouse - Datamart / Operational Data Store environment.
The client had Data Services jobs running on MySQL Server and worked on upgrade to HANA Database for performance tuning worked extensively in the Data Services Upgrade.
Business objects Data services is ETL tool which was used to extract data from source ECC and then load into HANA.
Monitored with Basis Team to create connectivity to HANA.
Trigger-Based Data Replication used with SAP Landscape Transformation LT Replication Server
Extraction-Transformation-Load ETL Based Data Replication used with SAP Business Objects Data Services to specify and load the relevant business data in defined periods of time from an ERP system into the SAP HANA database
Extracted Metadata from the source system into the Target SAP HANA system.
Configured on the HANA Studio the import server to pull data into HANA from SAP Business suite.
Supervision Responsibilities:
(Describe the level of supervision received (i.e. the frequency of supervisory contact degree to which the individual acts independently and on what kinds of issues). Describe the level of supervision of others if any (i.e. assigning work reviewing performance direct or indirect responsibility).

Able to act independently seeking consultation guidance and advice as appropriate from BW lead
Actively develops team members and direct reports by providing day-to-day guidance feedback and on-the-job coaching
Assists in preparing and tracking budgets
Responsible for compliance with performance management objectives
Mentor and counsel staff members
Other Requirements:
(Describe other functions or expectations of the job such as whether overtime is regularly required (e.g. during busy season) whether there are particular times of the year that vacation may not be taken whether there is frequent travel whether there are any physical requirements beyond those expected in a normal office environment or any other miscellaneous things about the job that should be made known.)
Demonstrate an inclusive and globally aware mindset
Ability and flexibility to work in a virtual environment across multiple time zones
Flexibility to work non-standard hours in supporting global production systems.
International travel may be needed.
Job Requirements:
Education:
(What is the minimum level of education needed/suggested to perform this job)

Bachelors degree in a relevant discipline or equivalent work experience
Experience:
(What is minimum number of years needed/suggested to perform this job)

Minimum of 10 years of SAP BW/HANA/BOBJ experience gained through a combination of implementation projects and post go-live support
Relevant functional experience for data extractions from source SAP systems to down stream systems

Certification Requirements:
(Describe and explain any certifications and/or licenses needed or helpful to perform this job).

SAP certification preferred
Note:
This job description is intended as a guide to reflect the principal functions of the job. However it is not an all-inclusive listing of the required job functions and functions may vary depending on the particular geographic location of the job and/or the manager. Further the job description is subject to change at the discretion of management.

EY Building a better working world

EY exists to build a better working world helping to create long-term value for clients people and society and build trust in the capital markets.

Enabled by data and technology diverse EY teams in over 150 countries provide trust through assurance and help clients grow transform and operate.

Working across assurance consulting law strategy tax and transactions EY teams ask better questions to find new answers for the complex issues facing our world today.