$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Strong BI Developer with SQL, Cognos, Data Vault and Power BI Experience
Jacob Johannes Bester
,
Harold Hill, United Kingdom
Experience
Other titles
Skills
I'm offering
I am a Certified Cognos BI Author / Data Vault 2.0 Practitioner with 25+ years’ experience in data production, ETL, data analysis, reporting, modelling, and administering in the BI environment. My work experience includes working in the Pharmaceutical, Health Insurance, Telecommunication and Transport Industries.
With my experience in data warehousing, working with large sets of data, and optimising SQL queries etc., I managed to make great improvements in reporting turnaround times by preparing the data correctly, building a framework model on top of that and minimizing the use of using large data sets. I managed to cut the report running time by 76% or 48 hours of report waiting time per month.
I designed and hosted various comprehensive customised Cognos Training Courses and trained key client employees on-site. Recent achievements include doing a proof-of-concept in designing a data warehouse using self-building Data Vault methodology which decreased data production time to a tenth of the current run-time.
With my experience in data warehousing, working with large sets of data, and optimising SQL queries etc., I managed to make great improvements in reporting turnaround times by preparing the data correctly, building a framework model on top of that and minimizing the use of using large data sets. I managed to cut the report running time by 76% or 48 hours of report waiting time per month.
I designed and hosted various comprehensive customised Cognos Training Courses and trained key client employees on-site. Recent achievements include doing a proof-of-concept in designing a data warehouse using self-building Data Vault methodology which decreased data production time to a tenth of the current run-time.
Markets
United Kingdom
Industries
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2015 - 2021
job
BI Developer
Arcadis Gen.
(EAM systems for Railway / Airline industries)
I headed the Cognos BI team developing and implementing reporting solutions to multiple clients throughout the UK and international. Our solution incorporated the development of a Data Warehouse for custom calculations and summaries, a Data Mart for self-service reporting, a Suite of online Reports including dashboards and visualizations for performance monitoring and management decisions. It was based on Maximo data stored in DB2 / Oracle databases. I also designed and delivered various client specific training courses to help the client using our solutions.
I designed a self-build Data Vault 2.0 solution in DB2 which speed up the delivery time from the time of data capture to when the data is available in the reports by 90%. It included a complete history of the data at any point in time and was fully customizable i.e., cover as little or as much of the original database as needed.
I headed the Cognos BI team developing and implementing reporting solutions to multiple clients throughout the UK and international. Our solution incorporated the development of a Data Warehouse for custom calculations and summaries, a Data Mart for self-service reporting, a Suite of online Reports including dashboards and visualizations for performance monitoring and management decisions. It was based on Maximo data stored in DB2 / Oracle databases. I also designed and delivered various client specific training courses to help the client using our solutions.
I designed a self-build Data Vault 2.0 solution in DB2 which speed up the delivery time from the time of data capture to when the data is available in the reports by 90%. It included a complete history of the data at any point in time and was fully customizable i.e., cover as little or as much of the original database as needed.
Developer, UP, Maximo, Calculations, BEE, Online, International, Development, Monitoring, Oracle, It, Service, DB2, Management, Database, Data Warehouse, Training
2011 - 2015
freelance
BI Consultant
Red Edge.
- contract: Vodacom Cape Town, SA (Telecommunication Industry)
I mainly worked as the only BI resource assisting the Network Performance department with all their reporting needs. I managed to develop a data mart using Oracle PL/SQL and Materialized Views containing the necessary measures to build KPI's on request as well as summarizing the data on Daily / Weekly / Monthly level. With this, I modelled the data in Framework Manager and developed a Dashboard solution using Cognos BI and Cognos for MS Office, that would summarize the complete network performance in 9 KPI's which was well received throughout the regions and soon the whole country was only using this Dashboard for network performance monitoring. I also managed to introduce a Big-Event Report Pack by collaborating with different teams in the business and adding additional filters to the data mart. This was widely used during the Football World Cup monitoring Mobile Network Performance in and around the sporting venues.
Experience - Continue
I mainly worked as the only BI resource assisting the Network Performance department with all their reporting needs. I managed to develop a data mart using Oracle PL/SQL and Materialized Views containing the necessary measures to build KPI's on request as well as summarizing the data on Daily / Weekly / Monthly level. With this, I modelled the data in Framework Manager and developed a Dashboard solution using Cognos BI and Cognos for MS Office, that would summarize the complete network performance in 9 KPI's which was well received throughout the regions and soon the whole country was only using this Dashboard for network performance monitoring. I also managed to introduce a Big-Event Report Pack by collaborating with different teams in the business and adding additional filters to the data mart. This was widely used during the Football World Cup monitoring Mobile Network Performance in and around the sporting venues.
Experience - Continue
Sql, Oracle, MS office, Pl/sql, Event, Network, Monitoring, Oracle PL/SQL, KPI, Office, BEE, Framework, Manager
2008 - 2011
freelance
BI Consultant
Vodacom, Midrand, SA.
- Highbury - contract: Vodacom, Midrand, SA (Telecommunication Industry)
I joined a team of BI developers overseeing all BI aspects of Cognos including Report Authoring, Modelling, Administration and Training. Internal support with day-to-day Cognos tasks including optimising SQL queries for better performance in Cognos. I also did weekly deployments to production and scheduling of MIS reports.
I joined a team of BI developers overseeing all BI aspects of Cognos including Report Authoring, Modelling, Administration and Training. Internal support with day-to-day Cognos tasks including optimising SQL queries for better performance in Cognos. I also did weekly deployments to production and scheduling of MIS reports.
Sql, Administration, Training, Support, BEE, Production
2005 - 2008
job
Data Analyst
Discovery Health.
(Healthcare Insurance Industry)
When I started at Discovery, all the data was manually captured into an access table and the report is run when all the data was completed. I developed a solution using MS Access and VBA to fetch the data directly from the source systems and thus avoiding manual interaction for the daily dashboard to run. I also managed to extract the Call centre stats from the Avaya system and automated that part of the daily dashboard. By automating this whole process, ensured accuracy and timely reporting which ensures Management Information was readily available to make important decisions. This was even more simplified when we moved the whole reporting system over to Cognos using framework models and PL/SQL stored procedures, allowing me to deal with ad-hoc report requirements, data analysis as well as meeting with operational managers of various departments to discuss reporting needs. I designed a complex Cognos MIS report that was printed in book form for big clients and almost 80% of the report was data driven.
When I started at Discovery, all the data was manually captured into an access table and the report is run when all the data was completed. I developed a solution using MS Access and VBA to fetch the data directly from the source systems and thus avoiding manual interaction for the daily dashboard to run. I also managed to extract the Call centre stats from the Avaya system and automated that part of the daily dashboard. By automating this whole process, ensured accuracy and timely reporting which ensures Management Information was readily available to make important decisions. This was even more simplified when we moved the whole reporting system over to Cognos using framework models and PL/SQL stored procedures, allowing me to deal with ad-hoc report requirements, data analysis as well as meeting with operational managers of various departments to discuss reporting needs. I designed a complex Cognos MIS report that was printed in book form for big clients and almost 80% of the report was data driven.
Sql, Data Analysis, VBA, Pl/sql, Management, Stored procedures, Access, Analyst, Insurance, Framework, ME
1997 - 2005
job
Production Supervisor
IMS Health.
(Healthcare / Pharmaceutical Industry)
I headed the Data production team which was responsible for the data collection, ETL, coding and submission into the International Mainframe for production. I automated the data collection process as well as redesigned the ETL program that was initially Cobol / mainframe based to using MS Access and VBA and pushing the output to the SQL Server. Using T-SQL on the SQL Server, I managed to do product investigations and data analysis to QA the production data and identifying pre-production coding errors to ensure the accuracy of the data. I was also responsible for updating and maintaining client data marts and all investigations related to the data from clients, marketing, and management, as well as communicating between the IMS offices in India, Buenos Aires, Australia, and Frankfurt.
I headed the Data production team which was responsible for the data collection, ETL, coding and submission into the International Mainframe for production. I automated the data collection process as well as redesigned the ETL program that was initially Cobol / mainframe based to using MS Access and VBA and pushing the output to the SQL Server. Using T-SQL on the SQL Server, I managed to do product investigations and data analysis to QA the production data and identifying pre-production coding errors to ensure the accuracy of the data. I was also responsible for updating and maintaining client data marts and all investigations related to the data from clients, marketing, and management, as well as communicating between the IMS offices in India, Buenos Aires, Australia, and Frankfurt.
Pharmaceutical, Production, IMS, Server, International, Data collection, Access, Mainframe, Cobol, Marketing, T-SQL, QA, Management, VBA, ETL, SQL Server, Data Analysis, Sql
My education
1991
-
1992
Pretoria Technicon
BTech, Information Systems
BTech, Information Systems
1989
-
1990
Middelburg High School
Secondary, Mathematics, Science, and Music
Secondary, Mathematics, Science, and Music
Jacob's reviews
Jacob has not received any reviews on Worksome.
Contact Jacob Johannes Bester
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Jacob directly in Worksome.
38100+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark