Manoj Kumar

• Having totally 7.2 years of IT Experience in SAP BW/BO which includes Implementation and Production Support projects and Hana Studio as well.
• Expertise in Data Modeling using Multidimensional/Star Schema and Extended Star Schema models. Strong knowledge of SAP BW architecture and SAP BW data model.
• Modeling-Experience in Creating and maintaining of Info cubes, ODS objects(Types), Info objects, Info object Catalogs, Transfer rules, Update rules, Info sources, Info packages, Data sources, PSA, Characteristics, Key figures, Business Content Objects, Process Chains, Data Extraction Specific to SD ,MM. Expertise in Scheduling and data load Monitoring.
• Extensively involved in setting up the procedures for LO Cockpit, involving Activating the Business Content Data Sources, Maintaining the Extract Structure, Generating the Data Source, Activating the Data Source.
• Extraction- Extracted the transaction data by LO-cockpit from R/3 to BW by maintaining the extract structures, maintaining data sources, replicating the data Sources into BW.
• Expertise in Business Explorer Suite: Worked on BEX Query Designer building Reports by using Calculated Key figures, Restricted Key figures, New Selection, Conditions, Exceptions, Filters, Structures, Variables(types) with Manual Entry, Replacement Path.
• Generated and maintained aggregates and roll up activities on info Cubes as part of the info Cube management.
• Involved in solving performance-related issues for query performance and data loading performance by using indexes, compression, and aggregates.
• Worked in BW on Hana like creation of Composite Providers and Advanced DSO's.
• Extensively involved in creation of information models like Graphical Calculation views in Hana Studio.
• Good Knowledge on Data Warehousing Concepts like Star schema, extended star schema.
• Structured Lead Consultant with excellent troubleshooting, issue resolution skills. Dependable and driven with record seeing complex projects through to completion.
• Passionate about bringing changes in businesses.
• Proficient in conducting primary and secondary research.

Industrious Senior Consultant with excellent critical thinking and team-building talents. Familiar with the policies and procedures of product development and operations. Competent in staff management, data modeling and proposal development.

Experienced and enthusiastic Consultant with track record of success across wide range of industries. Possesses exceptional interpersonal, problem-solving and analytical skills to provide advice and expertise to client organizations improving business performance. Experienced in all aspects of operations, strategy and finance.

7, TENNANT, Senior Consultant, 01/2023 - Present, Tennant is a recognized leader of the cleaning industry. They are passionate about developing innovative and sustainable solutions that help customers clean more spaces more effectively, addressing indoor and outdoor cleaning challenges., 

Analyzing business requirement documents and functional specs., Worked with Cherwell ticketing tool., Extensively worked with Bex analyzer tool., Scheduled the reports and ensured to publish as per the specified timings., Incident handling and provided end user communication support., Resolved the data mismatch issues which has been raised by user., Worked on Data source enhancements., Involved in designing of Design technical spec document., Resolved Data load failure issues., Designed and implemented robust data models in Datasphere to ensure efficient storage, retrieval, and analysis., Successfully integrated data from diverse sources, including on-premises databases, cloud platforms, and external systems, into Datasphere., Implemented data integration pipelines, leveraging SAP Data Intelligence or other ETL tools, to ensure seamless data flow and maintain data quality., Created Data builders as per the business requirements. 

6, MEDTRONIC, Technical Consultant, 07/2021 - 12/2022, Medtronic is a global leader in medical technology, offering medical devices and therapies to more than 72 million people across 150 countries. Medtronic’s four major reporting segments are cardiac and vascular, minimally invasive therapies, restorative therapies, and diabetes., Involved in resolving the User related issues., Worked on SAP BO with Webi reports as per the requirement., Designed webi reports based on the Functional specifications from User., Designed webi reports using Bex queries., Resolved the issues in webi reports as per the User’s requirement., Provided reports to Users and get the UAT sign off., Worked on data related issues and performance related issues., Involved in Migration testing of reports to Power BI. 

5, UNILEVER, SAP BW ABAP Consultant, 06/2019 - 07/2021, Unilever is a British-Dutch transnational consumer goods company co-headquartered in London, England, and Rotterdam, Netherlands. Its products include food, energy drink, ice cream and beverages (about 40 percent of its revenue), cleaning agents, beauty products, and personal care products. Unilever is the largest producer of soap in the world. Unilever is one of the oldest multinational companies; its products are available in around 190 countries., Involved in resolving the User related issues., Worked with Solman 7.2 ticketing tool., Analyzed the issues raised by User and provided solution with proper explanation., Identified errors in process chains and rectified on priority basis., Incident handling and provided end User communication support., Created Open hub destinations and placed the files in AL11 folder as per the requirement., Created Logical file paths for Open hub destinations. 

4, ANTHEA AROMATICS, SAP BW Consultant, 03/2019 - 06/2019, The Anthea Group operates 4 manufacturing facilities located near Mumbai, India, producing a range of fragrance chemicals and intermediates. Anthea has a strong presence in the global market, with exports to North and South America, Europe and Asia accounting for a significant proportion of sales turnover., Involved in designing of Functional specifications., Installation of BI content objects as per the requirement., Modified Bex queries to get the data matched to BO dashboards., Involved in designing of Test case documents and ensured the data is matching with dashboards., Involved in creation of restricted key figures and calculated key figures to get the correct cumulative balance in the output. 

3, MERCK KGaA, SAP BI BW Consultant, 03/2018 - 07/2018, Merck is a leading science and technology company in healthcare, life science and performance materials headquartered in Darmstadt, Germany. They develop specialty chemicals for demanding applications, from liquid crystals and OLED materials for displays and lighting to effect pigments for coatings and cosmetics through to high-tech materials for the electronics industry., Fixing the errors in chains whenever chain failure occurs., Involved in remodeling of ADSO’s as per the requirement., Involved in remodeling of Composite providers and created assignments in BW on Hana., Worked with JRM tool and created new requests for specific process chains., Involved in creation of Hana models using attribute views and analytical views., Identified errors in process chains and rectified on priority basis., Incident handling and provided end User communication support., Monitored hourly, daily, and weekly jobs and analyzed the reasons for frequent failures of jobs in Process chains. 

2, THYSSENKRUPP, Associate Consultant, 04/2016 - 10/2017, ThyssenKrupp Elevator, the world’s premier manufacturer, installer and service provider of vertical and horizontal transportation technology, it’s headquarter is in Essen, Germany. ThyssenKrupp companies in North America offer a range of products and services, including premium carbon steel; high-performance alloys; automotive components and systems; elevators, escalators, moving walks and passenger boarding bridges; and material trading, logistical and industrial services., Monitoring of Process chains daily and fixing the chains whenever chain failure occurs., Actively involved in Rectification of Load Failure Errors like Master Data Loads, Transactional Loads., Monitored hourly, daily, and weekly jobs and analyzed the reasons for frequent failures of jobs in Process chains., Maintained the work history for all the tickets until it is closed down., Worked in SEM-BCS Module., Resolved the incidents of errors in Structure D and provided solution to User with proper explanation., Involved in Synchronizing of Business partners in BCS to avoid errors when User executed LOAD task., Worked with Functional team whenever there is a difference in Balance sheet and P&L account., Involved in creating composite providers and Advanced DSO’s in Hana studio., Worked with Solman 7.2 and HPSM ticketing tool., Created Attribute views, Analytical views and Calculation views in Hana Modeller., Worked on Composite providers and Advanced DSO's in BW on Hana. 

1, XEROX, Associate Consultant, 02/2015 - 03/2016, Xerox is a manufacturer of office printers, scanners, toner and ink. It’s manufacturing and distribution facilities are located around the world. The company’s largest manufacturing site is in Webster, New York, where it makes fusers, photoreceptors, and it has an EA Toner plant located in Webster, New York., Involved in gathering the requirement from client for BCR activity., Experience in extracting the data from CRM system., Analyzed the High level design document given by User and designed the DTS document., Involved in designing the Test plan document and CRB check list., Given estimates for a particular BCR and met the timelines by completing the development., Involved in enhancement of standard CRM data sources 0CRM_SRV_PROCESS_I, 0CRM_SRV_CONFIRM_I for Business Change Requirement., Discussed with the functional team to get the service orders created for testing the data purpose., Worked with solman 7.1 ticketing tool., Involved in analyzing and developing of abap code related to BW i.e. Routines, enhancements., Analyzed the reasons for the fields which are not populating the data after the transports moved to production and given the proposed solution.