Benjamin Appollis
Senior Consultant at Powerdobs- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Native or bilingual proficiency
-
Afrikaans Native or bilingual proficiency
-
Netherlands Professional working proficiency
Topline Score
Bio
Antonio Vara Piquer
Working together in the R4 project, Benjamin was an asset to the team, he provided his knowledge in power BI,SQL Server, SSIS,... He was going the extra mile for the project the last but not least a great professional to work with.
Ryan Bartlett
Benjamin was an integral part of the R4 programme team, in particular our data stream. His desire to make sure efforts are successful were as crucial for us as his expert skills that allowed him to deliver results. He leveraged his technical and people skills to make a difference in a variety of ways. As the Technical Lead he built new ETL pipelines and improved the existing ones whilst training other team members on many parts of the chain for example developing SSIS packages and automated jobs in SSMS, as well as maintaining the programmes VDIs and servers with limited support from IT. Ben also produced several PowerBI dashboards for different customers implementing agile principles to collect requirements deliver MVPs and managing improvement cycles. When called upon Benjamin also proved to be an asset to our team in covering data analysis tasks. If you have the chance I highly recommend adding Ben to your team!
Antonio Vara Piquer
Working together in the R4 project, Benjamin was an asset to the team, he provided his knowledge in power BI,SQL Server, SSIS,... He was going the extra mile for the project the last but not least a great professional to work with.
Ryan Bartlett
Benjamin was an integral part of the R4 programme team, in particular our data stream. His desire to make sure efforts are successful were as crucial for us as his expert skills that allowed him to deliver results. He leveraged his technical and people skills to make a difference in a variety of ways. As the Technical Lead he built new ETL pipelines and improved the existing ones whilst training other team members on many parts of the chain for example developing SSIS packages and automated jobs in SSMS, as well as maintaining the programmes VDIs and servers with limited support from IT. Ben also produced several PowerBI dashboards for different customers implementing agile principles to collect requirements deliver MVPs and managing improvement cycles. When called upon Benjamin also proved to be an asset to our team in covering data analysis tasks. If you have the chance I highly recommend adding Ben to your team!
Antonio Vara Piquer
Working together in the R4 project, Benjamin was an asset to the team, he provided his knowledge in power BI,SQL Server, SSIS,... He was going the extra mile for the project the last but not least a great professional to work with.
Ryan Bartlett
Benjamin was an integral part of the R4 programme team, in particular our data stream. His desire to make sure efforts are successful were as crucial for us as his expert skills that allowed him to deliver results. He leveraged his technical and people skills to make a difference in a variety of ways. As the Technical Lead he built new ETL pipelines and improved the existing ones whilst training other team members on many parts of the chain for example developing SSIS packages and automated jobs in SSMS, as well as maintaining the programmes VDIs and servers with limited support from IT. Ben also produced several PowerBI dashboards for different customers implementing agile principles to collect requirements deliver MVPs and managing improvement cycles. When called upon Benjamin also proved to be an asset to our team in covering data analysis tasks. If you have the chance I highly recommend adding Ben to your team!
Antonio Vara Piquer
Working together in the R4 project, Benjamin was an asset to the team, he provided his knowledge in power BI,SQL Server, SSIS,... He was going the extra mile for the project the last but not least a great professional to work with.
Ryan Bartlett
Benjamin was an integral part of the R4 programme team, in particular our data stream. His desire to make sure efforts are successful were as crucial for us as his expert skills that allowed him to deliver results. He leveraged his technical and people skills to make a difference in a variety of ways. As the Technical Lead he built new ETL pipelines and improved the existing ones whilst training other team members on many parts of the chain for example developing SSIS packages and automated jobs in SSMS, as well as maintaining the programmes VDIs and servers with limited support from IT. Ben also produced several PowerBI dashboards for different customers implementing agile principles to collect requirements deliver MVPs and managing improvement cycles. When called upon Benjamin also proved to be an asset to our team in covering data analysis tasks. If you have the chance I highly recommend adding Ben to your team!
Credentials
-
Analyzing and Visualizing Data with Microsoft Power BI
MicrosoftDec, 2021- Sep, 2024 -
Professional Scrum Master I
Scrum.orgSep, 2021- Sep, 2024 -
Developing SQL Data Models
MicrosoftMay, 2020- Sep, 2024 -
Power BI Data Modeling with DAX
LinkedInMay, 2020- Sep, 2024
Experience
-
Powerdobs
-
Netherlands
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Senior Consultant
-
Jul 2022 - Present
-
-
-
Valcon
-
Netherlands
-
Business Consulting and Services
-
1 - 100 Employee
-
Data Engineer - Senior Specialist
-
Jun 2019 - Jul 2022
As a Data Engineer/ Senior Specialist, I work together with the customer on information solutions. I translate the information needs of the customer into functional and technical design and implement these into management information solutions. Features of this role • Preparation of functional and technical designs, development and implementation of Business Intelligence or management information systems • Realizes ETL procedures based on a technical design, data warehouses, BA front-end solutions (dashboards, analyzes and management reports) • Working both on the business side and on the technical side of BA projects • Sparing partner for the customer and his colleagues in the field of: - Data warehousing and ETL; - BI front-end tooling; - Data warehouse methodologies Show less
-
-
-
Fixx iT
-
Netherlands
-
IT Services and IT Consulting
-
1 - 100 Employee
-
BI Consultant : Data Analyst and Analyst Programmer
-
Feb 2019 - May 2019
Design, development and implementation of Business Intelligence Solutions on various platforms including SAP, Power BI and Tableau. Responsible for understanding business needs and processes to act as a liaison between the business and the technical team. Responsible for building relationships with business teams with the focus on increasing the capabilities and improving efficiency within the teams. Creating dashboards and reports Designing, testing and implementing analysis and reporting solutions Developing the structure of foundation business data in relation to business requirements for reporting and analysis Ensure quality and data integrity in BI Products Implementing new reporting & analysis systems in the organization and giving training on those tools Show less
-
-
-
PBT Group
-
South Africa
-
IT Services and IT Consulting
-
200 - 300 Employee
-
BI Consultant - Data Analyst & Analyst Programmer
-
Feb 2015 - Dec 2018
Client / projects : PEPKORIT (Retail) MTN Irancell (Telecommunications) Clicks (Retails) - current On-site client responsbility: • Requirement elicitation • Compile Gap analysis and present findings to client, • Recommendations and man-day estimates for implementing changes or new development • Report and Dashboard development • User Acceptance Testing • Client Sign Off • Local client responsbility: • Liaise with client(s) to gather business requirement and business rules for ad-hoc request • Liaise with Architectural forum to ensure that new request meet design specification • Gather information across all business units • Analyze data and creating mappings to the BI solution • Develop prototypes (SQL) for the purpose of data integrity checking and ensuring that business rules can be applied • Design and Analysis of BI solution • Internal testing of interfaces to other systems, if applicable • Responsible for iteration documentation • Provision of hands-on training for own system and changes being implemented • Problem solving and user assistance for own systems supported (functional, not technical) Show less
-
-
-
Datonomy Solutions
-
South Africa
-
IT Services and IT Consulting
-
1 - 100 Employee
-
BI Analyst Developer
-
Sep 2014 - Jan 2015
Client : Woolworths (Retail) • SQL BI Solution Development • Fact-finding and Analysis • Gathering/ Understanding detailed requirements • Where required, conduct user interviews/ JAD sessions with relevant clients and stakeholders • Define, evaluate and present alternative solutions • Assist in the implementation and rollout of solutions Client : Woolworths (Retail) • SQL BI Solution Development • Fact-finding and Analysis • Gathering/ Understanding detailed requirements • Where required, conduct user interviews/ JAD sessions with relevant clients and stakeholders • Define, evaluate and present alternative solutions • Assist in the implementation and rollout of solutions
-
-
-
-
Data Analyst
-
Sep 2013 - Aug 2014
Client : MTN South Sudan ( Telecommunications)On-site client responsbility:• Requirement elicitation• Compile Gap analysis and present findings to client, • Recommendations and man-day estimates for implementing changes or new development• Report and Dashboard development • User Acceptance Testing• Client Sign Off• Local client responsbility:• Liaise with client(s) to gather business requirement and business rules for ad-hoc request• Liaise with Architectural forum to ensure that new request meet design specification• Gather information across all business units• Analyze data and creating mappings to the BI solution• Develop prototypes (SQL) for the purpose of data integrity checking and ensuring that business rules can be applied• Configuration of soft rules in the BI solution• Provide business functional specification to factory da & development team.• Internal testing (factory testing) of interfaces to other systems, if applicable• Complete factory testing plans before the deployment to the customer site.• Responsible for iteration documentation• Provision of hands-on training for own system and changes being implemented• Problem solving and user assistance for own systems supported (functional, not technical) Show less
-
-
BI Consultant
-
Nov 2007 - Aug 2013
Client : MTN Irancell(Telecommunications)Develop and test data extraction, transformation and load routines for population of data warehouse and data marts as well as the provision of data extracts;Quality assurance of dataDeveloping BI Solutions using PL/SQl , Business Objects ,OBIEE, SAS and advance AnalyticsUnix Scriptingprocedure optimisationoperational monitoringLiaise with business analysts in terms of business requirements and development of requests
-
-
Education
-
University of Cape Town
Data Analysis certificate, Data Analysis -
University of the Western Cape/Universiteit van Wes-Kaapland
B.Sc, Computer Science , Statistics , Information Systems -
Eben Donges High School
Matriculation Certified with Excemption, English, Afrikaans, Mathematics, Physical Science, Geography,Biology