Vivek Mistry
Dunstable,United Kingdom
Summary
Strong ability to work independently, manage one's time, and be a collaborative team member. 2+ years of SAP BW/BI experience, which includes data modelling, data extraction, data loading, scheduling monitoring, reporting, performance tuning, and strong analytical and logical skills. The ability to resolve issues in a high-pressure environment as well as being able to quickly learn and adapt I am a well-organized, self-motivated individual with the ability to prioritize, meet deadlines, and manage changing priorities. Ability to provide written responses to business and technical proposals and create reports and documentation for process-related activities.
Overview
3
3
years of professional experience
1
1
year of post-secondary education
1
1
Certification
Work history
Junior SAP BI/BW Consultant
Wizcore
London, United Kingdom
01.2023 - 08.2023
- I extensively worked on the LO Extraction cockpit to extract Logistics data from the source system (R/3), performing necessary procedures like setting up the update mode, deleting the set-up table, filling up the set-up table and loading data from ECC to BI system
- I worked with transactional data sources to load data from SAP R/3 and flat files into SAP BW
- I extensively worked on designing and creating info Objects, Info Sources, Transfer structures, communication structures, custom info cubes, and Custom Info objects (DSO)
- Experience in Data loading, Data Extraction, Data Modeling, Reporting, Performance tuning, Monitoring and scheduling using process chain
- Designed and developed queries to generate reports in BEx Analyzer
- Work with PSA to monitor the data transfer from the Source System into BW
- I worked on Multi-providers, Open Hub Destination, updating rules and authorizations, Master Data and transaction data and Data warehousing workbench
- Created Aggregates and used line item dimension to increase the performance of the query
- Created queries using variables, restricted key figures, Calculated key figures, exceptions, conditions offsets, and structures
- Expertise in front-end Business warehouse components: SAP Business object, BEx Analyzer, Query Designer, Workbooks and WAD Report Designer
- To inform the onsite people if there are any deadlocks.
Business analyst
GE HEALTHCARE
, India
06.2020 - 04.2022
- Developed automated workflows using SAP Business Objects, reducing report generation time by 50%
- Redesigned the sales performance dashboards, incorporating interactive charts and graphs for improved data interpretation
- Conducted extensive data validation and reconciliation processes, resulting in improved data accuracy and reliability
- I received positive feedback from management for the enhanced visual representation of key metrics
- Successfully identified and resolved inconsistencies in sales data, ensuring high-quality analysis
- Collaborated with the sales team to identify potential growth opportunities and challenges
- Provided data-driven insights that supported the formulation of effective sales strategies.
Education
Master of Science - Information technology
Bournemouth university
Bournemouth, England 09.2021 - 02.2023
Bachelor of Computer Application - undefined
Skills
- SAP Business Warehouse
- SAP Business Intelligence
- SAP ERP
- Power BI
- SQL
- Data ETL
- Data Mapping
- Data Modeling
- Data Lakes
- BEx Analyzer,
- SAP S/4HANA
- Data migration design
- Web-based reporting tools
- BEx Query Designer
- MS Office Suite
- Agile
- SAP reporting and analytical tools
Certification
- Supply chain foundations: Analytics, 2023
LinkedIn Learning
- SAP BI/BW Introduction, 2023
LinkedIn Learning
- SAP ERP Essential Training, 2023
LinkedIn Learning
Timeline
Junior SAP BI/BW Consultant
Wizcore
01.2023 - 08.2023
Master of Science - Information technology
Bournemouth university
09.2021 - 02.2023
Business analyst
GE HEALTHCARE
06.2020 - 04.2022
Bachelor of Computer Application - undefined
Similar Profiles
Tina mol ChenthamarakshanTina mol Chenthamarakshan
Data analyst intern at WizcoreData analyst intern at Wizcore
nicholas grahamnicholas graham
Warehouse picker at OcadoWarehouse picker at Ocado
Prachi SaraswatPrachi Saraswat
Employment Gap at Maternity BreakEmployment Gap at Maternity Break
Samreen KhalidSamreen Khalid
Teaching Assistant at Central Bedfordshire CollegeTeaching Assistant at Central Bedfordshire College
Serhii ZuievSerhii Zuiev
SAP BI BW Consultant at DTEK SERVICE LIMITED LIABILITY COMPANYSAP BI BW Consultant at DTEK SERVICE LIMITED LIABILITY COMPANY