SAP BW Senior Consultant

At EY, you’ll 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 we’re 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. 

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 EY’s 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:

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:

•    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: 
•    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:

•    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 figures,CMOD,

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:

•    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:
•    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:

•    Bachelor’s degree in a relevant discipline or equivalent work experience

Experience:

•    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:

•    SAP certification preferred
 

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.