GDS Consulting_SAP BW Senior Consultant 4

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.

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 from ECC and CRM/C4C.
• 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.

Benefits

• Generous Paid Time Off
• 401k Matching
• Retirement Plan
• Visa Sponsorship
• Four Day Work Week
• Generous Parental Leave
• Tuition Reimbursement
• Relocation Assistance