Simba Ralph

About Me

SAP BW Consultant with 2 years of SAP BW/BI experience, which includes data modeling, data extraction, data loading, scheduling, monitoring, reporting, and performance tuning. I am a quick learner with a strong desire to learn and master new technologies.

  • Phone:+27 61 470 1860
  • E-mail:srshokobishi@gmail.com
  • E-mail:email@simbaralph.com
  • Location:Stellenbosch, South Africa
  • Availability:2 Week's notice

What I Do

BW Modeling

InfoCube & DSO design, 7.0 InfoSources, Infosets, Hierarchies, Multiproviders Transformations, DTPs, InfoPackages, InfoObject and PSA maintenance

BW Reporting

BEX Query Designer, BEX Analyzer, Web Application Designer, Custom queries using conditions, exceptions, filters, calculated and restricted key figures

SAC

Story Creation and Augmented Analytics

BW Extraction

Data extraction from flat files for Master Data and Transaction Data, Business Content extractions, LO extractions and generic extractions

BW Performance Tuning

Data load and report performance strategies Use of Aggregates, Rollups, Partitioning, and Compression Data Loading (Full /Delta Up-Load), Monitoring

HANA

ADSOs, Calculated Views

Recommendations

Every expert was once a beginner.

Resume

Work Experience

01/2022 to date
Debtchamp
(Financial Services)

Data Analyst

  • Participated in requirements gathering, data modeling, planning, and scheduling data extraction from source systems, interacting with users for customized and standard reports, gap analysis, and associated solutions
  • Created and monitored process chains to automate the loading process for master data and transactional data.
  • Data Management: Data wrangling and processing
  • Reporting: Developing data models and calculation views for report writing in SAP Analytics Cloud.
  • Using BEx Analyzer filters and navigational attributes to facilitate data analysis in a drill-down or summarized format.
  • Loading tables into Hana using the Smart data access and Data services
  • Unpacking scripted views and redefining them in BODS for SQL HANA Tables
01/2021 to 12/2021
Debtcare
(Financial Services)

Junior Data Analyst

  • Involved in the rectification of load failure errors like Master Data loads and Transaction data loads. Designed and developed process chains for Master data loads and Transaction data loads with the help of Info packages.
  • Complex queries in Sales and Payment Reports using Analysis for Office
  • Query design and report development and testing in Lumira Discovery Design Studio
  • Designed and implemented SAP HANA data modeling using Calculation Views
  • Created Aggregates on Info Cubes to improve the query performance.
  • Actualized various types of BEx query variables including User exit, Replacement Path, Text, and formula variables.
  • Created calculated and Restricted Key Figures and Structures
  • BW Query reporting in Web Intelligence
  • Compiled the requirements blueprint
  • Unit testing of Transactional data loads and Master Data Loads
02/2020 to 12/2020
Primetalk
(BPO)

IT Support: Data Services

  • Extensively worked on designing/creating InfoObjects, InfoSources, Transfer structures, Communication structures, Standard and Custom InfoCubes, and Data Store Objects (DSO).
  • Assisted in the following SAP HANA Data Models: Attribute Views for master data
  • Handled the tickets of priority 1, 2, and 3 by following standard operating procedures
  • Building Composite Providers and exposing BW objects in SAP HANA Views, Operational Data Provisioning, ADSO etc
  • Created calculated and Restricted Key Figures and Structures
  • Handled all IT requirements of the companies such as Windows 7/10 support, Active Directory user management, printer, server and dialer trouble shooting, system backups, help, and advice

Certifications

Education

IMM
(South Africa)

Bachelor of Business Administration Degree

 

 

Soft Skills

Communication, interpersonal and presentation skills

90%

Ability to prioritize, manage time and multi-task

80%

Adaptable, analytical, resilient, stress tolerant, and a keen learner

90%

Ability to work in a diverse team environment

90%

Contact

Stellenbosch

South Africa

+27 61 470 1860

email [at} simbaralph [dot] com

Available for Freelance Work

How Can I Help You?