Jan Berends

Owner at Data Professionals
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
The Hague, South Holland, Netherlands, NL
Languages
  • Dutch -
  • English -
  • Spanish -
  • French -
  • German -

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • Netherlands
    • Information Technology & Services
    • 1 - 100 Employee
    • Owner
      • Mar 2010 - Present

      Data Professionals is an innovative company that has many years of experience in the field of data, in every sense of the word, specifically in the Windows/Office environment. Data Professionals offers services such as: • Data Entry • Data Conversion and Migration • Database and data warehouse design an implementation • Business Intelligence solutions • Customized software solutions Data Professionals is an innovative company that has many years of experience in the field of data, in every sense of the word, specifically in the Windows/Office environment. Data Professionals offers services such as: • Data Entry • Data Conversion and Migration • Database and data warehouse design an implementation • Business Intelligence solutions • Customized software solutions

    • Netherlands
    • Construction
    • 400 - 500 Employee
    • Assignment: Database Developer
      • Sep 2017 - Present

      Manage, maintain, support and improve a large number of databases which have been developed to support the operational processes around scaffolds and industrial isolation. Manage, maintain, support and improve a large number of databases which have been developed to support the operational processes around scaffolds and industrial isolation.

    • United States
    • Plastics Manufacturing
    • 700 & Above Employee
    • Assignment: Excel Expert
      • Aug 2018 - Dec 2018

      Automation and development of a template which all the Account Managers use to enter the (yearly) price changes and which are imported and processed in a centralized system from which it is then exported to the financial system. Automation and development of a template which all the Account Managers use to enter the (yearly) price changes and which are imported and processed in a centralized system from which it is then exported to the financial system.

    • Netherlands
    • Telecommunications
    • 100 - 200 Employee
    • Assignment: Financial Database
      • May 2017 - Oct 2017

      Development of a database for the registration, analysis and reporting of yearly expenditures. The system provides for the ability to enter yearly Capex and Opex budgets, which amounts can be based on so called Cost Drivers, which in turn are based on uploaded historic (distribution) data. Budgets are “frozen”, after which deviations and changes can be entered during the year and compared to the approved budget. The financial progress (actuals) are loaded into the system as well and compared to the budget, including forecasts for the remainder of the year. Finally, a reporting module provides for extensive reporting facilities on yearly and multiple year periods. Show less

    • Netherlands
    • Appliances, Electrical, and Electronics Manufacturing
    • 1 - 100 Employee
    • Assignment: Redesign Service Database
      • Apr 2017 - Jun 2017

      Redesign and development of a Service Database in MS Access. This database is used to register all steps of a repair process from the initial registration up to the shipment of the repaired item, including the materials used and costs that were made. Users receive real-time notifications when an items has reached their step in the repair process (workflow management). Reports about the process are generated in Excel. Redesign and development of a Service Database in MS Access. This database is used to register all steps of a repair process from the initial registration up to the shipment of the repaired item, including the materials used and costs that were made. Users receive real-time notifications when an items has reached their step in the repair process (workflow management). Reports about the process are generated in Excel.

    • Netherlands
    • Construction
    • 400 - 500 Employee
    • Assignment: Improvement Projects and Hours registration system in Excel
      • Mar 2017 - Jun 2017

      Expansion and improvement of a project and hour registration system. Foremen register the hours worked by their team members and materials used into an Excel template. These templates are loaded daily into a central Excel database. During this process the new templates are generated and emailed to the foremen. The data is also exported to the financial system. Expansion and improvement of a project and hour registration system. Foremen register the hours worked by their team members and materials used into an Excel template. These templates are loaded daily into a central Excel database. During this process the new templates are generated and emailed to the foremen. The data is also exported to the financial system.

    • Netherlands
    • Higher Education
    • 700 & Above Employee
    • Assignment: Trainer Excel and VBA
      • Sep 2016 - Jun 2017

      Support and train employees of the Hogeschool Leiden (Scheduling department) in the field of Excel, VBA and building of effective reports. Support and train employees of the Hogeschool Leiden (Scheduling department) in the field of Excel, VBA and building of effective reports.

    • France
    • Food and Beverage Manufacturing
    • 700 & Above Employee
    • Assignment: Excel Expert
      • Sep 2016 - May 2017

      Redesign of an Excel tool with which the available stocks of a (flexible) number of products are being allocated to a (flexible) number of customers, based on the orders and pre-defined reservations. Redesign of an Excel tool with which the available stocks of a (flexible) number of products are being allocated to a (flexible) number of customers, based on the orders and pre-defined reservations.

    • Assignment: Access Database Specialist
      • Nov 2012 - Apr 2017

      Maintain, improve and extend an existing MS Access database (Bres), used to register and process all aviation license requests, approved licenses and license audits. Apart from the database, this application also contains an integrated audit & visit planning module, a linked MS Word module to generate certificates and (audit) reports directly form the database, and a linked Excel module to generate (management) reports. Maintain, improve and extend an existing MS Access database (Bres), used to register and process all aviation license requests, approved licenses and license audits. Apart from the database, this application also contains an integrated audit & visit planning module, a linked MS Word module to generate certificates and (audit) reports directly form the database, and a linked Excel module to generate (management) reports.

    • United Kingdom
    • Banking
    • 700 & Above Employee
    • Assignment: Design and Build Migration Database
      • Jun 2015 - Sep 2016

      Development of a migration database which contains and combines data from a variety of different data sources in order to create a complete overview of the worldwide customers, accounts and products that need to be migrated to RBS England. The application also caters for an interactive module in which users can update statuses and add comments with regards to the migration, which is then loaded into the database and processed into the Management Reports. Development of a migration database which contains and combines data from a variety of different data sources in order to create a complete overview of the worldwide customers, accounts and products that need to be migrated to RBS England. The application also caters for an interactive module in which users can update statuses and add comments with regards to the migration, which is then loaded into the database and processed into the Management Reports.

    • United States
    • Computer Games
    • 700 & Above Employee
    • Assignment: Database Developer
      • Mar 2016 - Jul 2016

      Design and build a database for the Technical Department in which all equipment offered for repair is registered and tracked. Apart from the registration and storing of additional information concerning the repair, the application also provides automatically printed letters, quotes, invoices, etc. And at the same time the application keeps track of the spare parts stock. Payments are also imported into the tool so that a complete (financial) overview is created that can be presented in management reports and other overviews. Show less

    • France
    • Food and Beverage Manufacturing
    • 700 & Above Employee
    • Assignment: Excel Specialist
      • Nov 2015 - Feb 2016

      (Re-)design of an Excel report in which all Sell-In and Sell-Out data is collected from various sources for actual, planned, budget and (rolling) forecast figures. The data is then combined into a single data file from which the users can view and analyze the data in a simple and efficient manner. (Re-)design of an Excel report in which all Sell-In and Sell-Out data is collected from various sources for actual, planned, budget and (rolling) forecast figures. The data is then combined into a single data file from which the users can view and analyze the data in a simple and efficient manner.

    • Netherlands
    • Telecommunications
    • 700 & Above Employee
    • Assignment: Design and build a Deal Tracker database
      • Jan 2013 - Apr 2015

      Development of an application which contains all the roaming agreements (over the years) between various Mobile (GSM) Operators and VimpelCom (an Operator located in countries such as : Russia, Ukraine and Italy). The agreements are entered into the tool and then the effects of the agreement can be calculated, monitored and financially settled within the application. Unique to this project is that the users are located all over Europe, who can all access the tool and upload and download their data. The verification of this data is done in the HQ office (in Amsterdam), where they can also calculate the benefit, the monthly accruals and the final settlements. The program is equipped with a very flexible calculation module which can cope with a large variety of tariff and commitment conditions which, together with traffic predictions and real traffic figures, can determine what the “effective rates” (and benefit) of the agreement is (or will be). Show less

    • France
    • Food and Beverage Manufacturing
    • 700 & Above Employee
    • Assignment: MRP database
      • Aug 2013 - Dec 2013

      Build of a database (MRP) for the collection, storage and analysis of the material needs of 8 milk factories, in order to optimize the efficiency of the central purchasing and provide reporting capabilities of the production in the factories. Build of a database (MRP) for the collection, storage and analysis of the material needs of 8 milk factories, in order to optimize the efficiency of the central purchasing and provide reporting capabilities of the production in the factories.

    • Assignment: Design and build Asset Database
      • Jul 2013 - Nov 2013

      Development of a database to manage mast locations in the Netherlands, including a projects module to register, monitor and execute Mast Sharing Requests from (GSM) Operators. This project included the design of a suitable data model, the build of an Access database and extensive reporting capabilities in Excel. Development of a database to manage mast locations in the Netherlands, including a projects module to register, monitor and execute Mast Sharing Requests from (GSM) Operators. This project included the design of a suitable data model, the build of an Access database and extensive reporting capabilities in Excel.

    • United Kingdom
    • Banking
    • 700 & Above Employee
    • Assignment: Design and develop a Clients/Accounts/Products database
      • Apr 2011 - Jul 2013

      Development of a central database which contains and combines data from a variety of different data sources in order to create periodic overviews which are distributed and reviewed and which are then used to improve data quality. Furthermore this database is used for complex analysis and ad hoc reporting, thus supporting the everyday business. Development of a central database which contains and combines data from a variety of different data sources in order to create periodic overviews which are distributed and reviewed and which are then used to improve data quality. Furthermore this database is used for complex analysis and ad hoc reporting, thus supporting the everyday business.

    • Assignment: Development of Projects Database
      • Jan 2013 - Jun 2013

      Design and development of a projects database, to be used by Actavis to monitor and steer the migration of their medicine packaging (including the re-design of the package, the instructions for use, etc.) to a different supplier. The tool includes automatic signaling of deadlines and reporting in Excel. Design and development of a projects database, to be used by Actavis to monitor and steer the migration of their medicine packaging (including the re-design of the package, the instructions for use, etc.) to a different supplier. The tool includes automatic signaling of deadlines and reporting in Excel.

    • France
    • Food and Beverage Manufacturing
    • 700 & Above Employee
    • Assignment: Excel Specialist
      • Oct 2012 - Jan 2013

      Design and build a data collection and aggregation system in Excel (Deep Dive), used for bi-weekly analysis and steering of purchasing, stocks and production of semi-finished products.

    • Assignment: Excel Specialist
      • Mar 2012 - Sep 2012

      Create Excel templates for the collection of weekly and monthly sales and stock information from international Sales Units and Factories. Development of a central database and automated tools for the processing of the templates and generation of various KPI reports to monitor the Forecast-Accuracy-Bias and Customer service Level.

    • Netherlands
    • Hospitals and Health Care
    • 700 & Above Employee
    • Assignment: Database Developer
      • Feb 2012 - Jun 2012

      Development of a volunteer database in which the volunteers, the internal volunteer projects of the various locations and the external clients which are supported by volunteers, can be easily managed. Development of a volunteer database in which the volunteers, the internal volunteer projects of the various locations and the external clients which are supported by volunteers, can be easily managed.

    • Netherlands
    • Pharmaceutical Manufacturing
    • 1 - 100 Employee
    • Assignment: VB programmer
      • Jul 2010 - Apr 2012

      Development of various standalone applications in VB6 which are distributed via USB drives and are used to run Flash presentations and courses. Activities consisted of building a standard framework application on which customer specific software versions were developed. Each application can be assigned to a trainee and the results are automatically uploaded to a central database. Development of various standalone applications in VB6 which are distributed via USB drives and are used to run Flash presentations and courses. Activities consisted of building a standard framework application on which customer specific software versions were developed. Each application can be assigned to a trainee and the results are automatically uploaded to a central database.

    • Netherlands
    • Telecommunications
    • 700 & Above Employee
    • Assignment: Excel/VBA specialist
      • Nov 2011 - Dec 2011

      Automate and improve various Excel reports, so that all reports are automatically filled and distributed. Automate and improve various Excel reports, so that all reports are automatically filled and distributed.

    • Netherlands
    • Utilities
    • 700 & Above Employee
    • Assignment: Process analist & reporting specialist
      • Mar 2011 - Aug 2011

      Advise and support the management of the emergency room regarding processes, systems and reporting. Development of several reports used to manage and improve the department. Advise and support the management of the emergency room regarding processes, systems and reporting. Development of several reports used to manage and improve the department.

    • Assignment: DBA + programmer
      • Jul 2011 - Jul 2011

      Development of a database in which the administration and correspondence regarding subsidy requests, assignments and payments can be recorded. Development of a database in which the administration and correspondence regarding subsidy requests, assignments and payments can be recorded.

    • Netherlands
    • Banking
    • 700 & Above Employee
    • Assignment: Access specialist for Corporate Compliance Risk Management
      • Jan 2011 - Mar 2011

      Access specialist for Corporate Compliance Risk Management. Development of tools and databases in MS Access which were used by a large group of reviewers and QA’s screen, analyze, QA and report on large amounts of swift messages. Access specialist for Corporate Compliance Risk Management. Development of tools and databases in MS Access which were used by a large group of reviewers and QA’s screen, analyze, QA and report on large amounts of swift messages.

    • Netherlands
    • Hospitals and Health Care
    • 700 & Above Employee
    • Assignment: Data conversion from iTask to ZiZo format
      • Jan 2011 - Jan 2011

      Develop and operate a database which converts data exported from Argos's iTask system into XML files that are imported into the ZiZo portal. ZiZo collects data from health care providers in a standardized format, so health care providers can be compared on the quality of their services. Develop and operate a database which converts data exported from Argos's iTask system into XML files that are imported into the ZiZo portal. ZiZo collects data from health care providers in a standardized format, so health care providers can be compared on the quality of their services.

    • Belgium
    • Advertising Services
    • 1 - 100 Employee
    • Assignment: Build Site Acquisition Administration Tool
      • Jun 2010 - Nov 2010

      Development of a Site Acquisition Tool to keep track of the progress and financial administration of the acquisition process of GSM/UMTS sites. The acquisition process for finding a suitable location goes through many stages before a GSM/UMTS site can actually be built. With this tool both the employee and management have a clear overview of all sites, the possible candidates and it’s status, the costs, etc. Development of a Site Acquisition Tool to keep track of the progress and financial administration of the acquisition process of GSM/UMTS sites. The acquisition process for finding a suitable location goes through many stages before a GSM/UMTS site can actually be built. With this tool both the employee and management have a clear overview of all sites, the possible candidates and it’s status, the costs, etc.

    • Netherlands
    • Banking
    • 700 & Above Employee
    • Assignment: Modify and Expand an Access Database Template
      • Jun 2010 - Nov 2010

      Adapt and enhance an Access template which was protected on a user-level. The template is then used to develop applications which meet accountant requirements. ABN AMRO Pensioenbureau uses various Access databases to retrieve, modify and upload data in a main system. All databases are developed based on a standard template which handles all standard tasks, amongst which the user-level security. After an audit it was decided to expand the template with extra functionality so that it not only secures all applications, but it also improves the audit trail. Show less

    • Netherlands
    • Telecommunications
    • 700 & Above Employee
    • Assignment: Automate Weekly Reports Process
      • Jun 2010 - Aug 2010

      Build and automation of a data collection and aggregation tool which can process reports from Changepoint and Business Objects, in order to be able to generate the combined report with “a push of a button”. Build and automation of a data collection and aggregation tool which can process reports from Changepoint and Business Objects, in order to be able to generate the combined report with “a push of a button”.

    • Netherlands
    • Farming
    • 300 - 400 Employee
    • Assignment: Modify and Expand an Access Database
      • Jun 2010 - Jun 2010

      Modify and improve an MS Access database which imports and converts price lists from SAP to letters for individual customers in different languages. Modify and improve an MS Access database which imports and converts price lists from SAP to letters for individual customers in different languages.

    • South Korea
    • Computers and Electronics Manufacturing
    • 700 & Above Employee
    • Assignment: Upgrade of Access Database
      • May 2010 - May 2010

      Converting an existing Access 2003 database (for registering commitments) to Access 2007 and adding additional features. For this assignment the existing VBA code had to be upgraded to Office 2007 in order to make it work again. Furthermore the existing code was analyzed, improved where necessary, and made more robust. Extra features were added, such as synchronization via email. Converting an existing Access 2003 database (for registering commitments) to Access 2007 and adding additional features. For this assignment the existing VBA code had to be upgraded to Office 2007 in order to make it work again. Furthermore the existing code was analyzed, improved where necessary, and made more robust. Extra features were added, such as synchronization via email.

    • Netherlands
    • Non-profit Organizations
    • 1 - 100 Employee
    • Assignment: Implementation of an Online Survey Website
      • Mar 2010 - Apr 2010

      Development of a software package for online surveys, which included the distribution, collection, storage, analysis and reporting for the project “Ondernemerschap in de Wijk”. The surveys could be taken online via a dedicated website (MySql database) and offline via an interview and a Word document. The data was then automatically imported and stored in an Access database. The reporting (including selection and filter options) was done in Excel via an ODBC link. Both the database and the report can be operated by MKB-Nederland with “a push of a button”. Show less

    • Netherlands
    • IT Services and IT Consulting
    • 1 - 100 Employee
    • Business Consultant
      • Jun 2007 - Feb 2010

      Business Consultant to fulfill temporary consultancy assignments in the field of Business Intelligence (BI), Information/Business analysis, Information management, Reporting and Data warehousing. Specialist in database, data warehouse and reporting tools. Business Consultant to fulfill temporary consultancy assignments in the field of Business Intelligence (BI), Information/Business analysis, Information management, Reporting and Data warehousing. Specialist in database, data warehouse and reporting tools.

    • Netherlands
    • Non-profit Organizations
    • 1 - 100 Employee
    • Assignment: Database Developer
      • Oct 2009 - Jan 2010

      Develop software for downloading, storing, analysing and reporting on online surveys for the project “Keurmerk Veilig Ondernemen - Bedrijventerreinen”. MKB-Nederland had used Socratos (an online survey tool) to do the surveys. Because the surveys were grouped per industrial area, MKB-Nederland needed a tool to collect and aggregate the results to a national level. Thanks to an Access database and a Winstan™ script (a tool I developed myself) this could now be done with “a push of a button”. A special matching algorithm ensured that all questions from the different surveys were collected into a uniform survey. The report (with numerous filter options) was developed in Excel with an ODBC link to the database. Show less

    • Netherlands
    • Telecommunications
    • 700 & Above Employee
    • Assignment: Datawarehouse Developer
      • Dec 2008 - Dec 2009

      Development and maintenance of a data warehouse for an Oracle Enterprise Suite ERP system, including a reporting module and standard Business Objects reports. While the permanent DWH solution was designed and developed that, on a daily basis, automatically extracted data from Oracle EBS, which was then transformed and enriched and stored in an Access database. Reports were made using Business Objects and Excel.

    • Assignment: Data Migration Specialist
      • Jun 2009 - Nov 2009

      Data conversion specialist for a data migration project where data from various sources (for example Oracle Enterprise Business Suite ERP and Business Objects) needed to be converted and migrated to Changepoint at exactly the right moment.The data was collected via reports from the source systems using a Winstan™ script (a tool I developed myself). Another tool developed for this project made it possible to easily combine and format the data to meet the import requirements.

    • Assignment: Business Consultant
      • Apr 2008 - Nov 2008

      Participation in work groups for the merger with Multikabel en @Home, specifically addressing: processes and procedures, reporting, configuration of the CRM system and the preparation and accompaniment of the migration to the new CRM system.

    • Assignment: Quality Control Consultant
      • Jan 2008 - Mar 2008

      Development and implementation of a TNO advise concerning the calculation of the uptime of the primary services (RTV, DTV, Internet, Telephony), based on trouble tickets. The results are presented in a monthly Business Objects report.

    • Quality Control Engineer
      • May 2006 - Dec 2007

      Development and maintenance of a data warehouse for an Oracle Enterprise Suite CRM system, including a reporting module and standard Business Objects reports.

    • Netherlands
    • Education Administration Programs
    • 1 - 100 Employee
    • Assignment: Information Analist
      • Sep 2009 - Nov 2009

      Extract, transform and store data from Exin's CRM and Trainings system for reporting purposes. Extract, transform and store data from Exin's CRM and Trainings system for reporting purposes.

    • Netherlands
    • Non-profit Organizations
    • 1 - 100 Employee
    • Assignment: Data Specialist
      • Nov 2008 - Nov 2008

      Smart collection and presentation of survey results in an Excel sheet, for the project “Evaluatie Onderwijs Commissies”. Smart collection and presentation of survey results in an Excel sheet, for the project “Evaluatie Onderwijs Commissies”.

    • Telecommunications
    • 1 - 100 Employee
    • Implementation Services Manager
      • 2002 - 2005

      Responsible for process definition and improvement, Specifications, Contract Management, Reporting, Interfacing to other Operators, etc. Designed and built a reporting tool in the Microsoft Office environment, making data in various SAP modules easily accessible for all employees within the company. Allowing them to make their own selections and integrated reports of all available SAP data without the need to have knowledge of SAP or the SAP data structures. Responsible for process definition and improvement, Specifications, Contract Management, Reporting, Interfacing to other Operators, etc. Designed and built a reporting tool in the Microsoft Office environment, making data in various SAP modules easily accessible for all employees within the company. Allowing them to make their own selections and integrated reports of all available SAP data without the need to have knowledge of SAP or the SAP data structures.

    • France
    • Telecommunications
    • 700 & Above Employee
    • Regional Manager
      • 1998 - 2002

      Rollout Manager for the Orange GSM network of approx. half of the Netherlands (around 1500 sites). Responsible for a team of professionals dealing with the Acquisition, Permitting, Engineering, Construction and Telecom Implementation of the network. Rollout Manager for the Orange GSM network of approx. half of the Netherlands (around 1500 sites). Responsible for a team of professionals dealing with the Acquisition, Permitting, Engineering, Construction and Telecom Implementation of the network.

    • Netherlands
    • Technology, Information and Internet
    • 1 - 100 Employee
    • Systeem Ontwerper
      • 1993 - 1998

Education

  • Fontys Hogescholen
    Bachelor of Science, Electronics/Telecommunications
    1985 - 1989

Community

You need to have a working account to view this content. Click here to join now