marcel kreijne

Built a model in Excel and Access to merge a set of Excel files and output from the intended permanent solution (PowerSteering) into one dataset that can be maintained by users across Europe with the goal to have one complete and consistent set of details for the many projects already while the rollout of PowerSteering slowly progresses.

Collecting and structuring data, providing and analysing information needs and maintaining reporting. Changing report production from push to pull and managing projects on these areas. Implemented Counter compatible usage reporting for online products, developed sales commission model, financial reporting and analysis, royalty analysis etc.

Improving and standardizing managementinformation while creating more flexibility for expected changing demands.

Tasks include leading a team of business controllers, do monthly reporting, maintaining Excel spreadsheets, technical and operational management reporting software. Participate in project for transforming Excel spreadsheet reports into SAP reports. Position ended by terminating my own function.

Supporting Real Estate department in improving their financial forecasting model

Solving bottlenecks in the development of a 25 year, monthly based forecast model in Excel, for an "unlimited" number of buildings and its individual units, throughout their investment lifecycle (development, build, exploit, sell). The model includes scenario analysis, version management, user autentication, reporting and has got a database back-end. It is able to show results of changed input for a buidling immediately and recalculates the 25 year plan for a building within a second.

Building a similar reportingmodel like in previous project, but now focussed at quality measurements. The project also includes structuring of subsystems and making their information available to the reporting model. This model is more complex than the previous one, since it is processing far more data and is "rolling" through the years in stead of starting a new model at year end.

Working on projects at top-200 companies within the Netherlands.

Implementing new processes regarding moneyflow and goodsflow for 220 pharmacies. Project includes optimizing spreadsheetforms, organising roll-out workshops and support of central and decentral administrators.

Harmonising processes of 7 decentral Staffing administrations and upgrading the processes to match with the new system (Peoplesoft) that would be switched to early 2006.

Realiseren van hogere informatiewaarde voor eindgebruikers, zorgen dat bestaand datawarehouse betrouwbaar, snel en transparant wordt.

Back at Wolters Kluwer to re-align the processes and train a newly hired Business Analyst. Contribute in switch of fullfilment partner and SAP implementation

Designing the webbased application that is to replace the spreadsheetforms used in the previous project. After initial specification guiding the developmentprocess (external development by Evident Interactive) from customer-side to ensure a tight fit with the processes and a user friendly interface for the 220 pharmacists that will use the application. During the process I organised several acceptance-tests, done by small group of users. Of course I did some extensive testing on the application myself too.

Setting up a new administration for a multi-year project (Parkstad) to cover the building fase and the exploitation. The project is a joint-venture between Nuon Warmte and Gemeente Amsterdam and will deliver warmth to households in the north-east of Amsterdam. My project also included expanding existing reports and processes to include this new administration.

Implementing the budgetting method Activity Based Budgetting Building budget 2005 using that method Project included adjusting some systems to make sure the required information about actuals would be available too. Next step was to implement Activity Based Reporting. To do so I built a reporting- and budgetting model in Excel to build budgets and forecasts, collect actual volumes and costs from other systems and report a comparace of actuals, allowed costs and budget/forecast in all desired forms. Reports became more informative and more efficient to produce.

Interim Financial Controller, responsible for month closure, reporting, analysis of costs and fixed assets, budgetting and inter-company settlements. I took the local lead in the upgrade of Oracle 10.7 to Oracle 11i. My project ended by transferring my knowledge to a shared servicecenter in United Kingdom, due to centralisation of all financial departments of Europe.

Started off as general ledger accountant, progressed to be supervisor of 6 accounts payable accountants. The company did start with SAP not long before I arrived, and the process around procure-to-pay needed finetuning, to make it run smoothly. I finetuned the way purchase requests (PR) were built, the way they were to be turned into purchase orders (PO), the way the goods receipt was booked (GR) and the way invoices were to be booked on the newly built orders. After this the blocked invoices (due to incorrect ordering) could be solved, so the company gained control over the payment of suppliers again.

Assistent Controller, responsible for monthly reporting and analysis of revenue and costs. During the project I re-engineered the reportingmodel in Excel for it to be more stable and produce reports that are trustworthy, available early and with less effords. Thus resulting in more time for analysis of the figures, which on its own had a positive impact on the quality of the reports too.

* Helping out Excel-users with tips and tricks for common and uncommon problems * Building new functionalities for Excel * Excel-trainer * Building spreadsheetmodels from basic to advanced/complex * Coaching spreadsheet development projects

Combo function to backfill the management accountant on Cheese, Butter and Milkpowder who is now full time working on the upcoming SAP implementation and empowering the Retail department with additional controlling capacity to fulfill the most valuable information requirements and improve quality and efficiency of reporting and analysis processes and structures. Blending SAP BW, HFM, SmartView, Excel, creativity and process and grapical design skills into dynamic, easy to use interactive reports that provide true insight without information overload.

* Adding comfortable solutions at the linking edge of finance and ict to: * interim controlling * interim business analyst * developing management information (definition, design, programming, producing, analysis) * process (re-)design * implementing software * software development projects

Collecting, processing and analyzing data into solid information.

Proud to be creative and technical spreadsheet consultant since the very beginning of this promising start up that after a few years of development is about to enter the market with the most impressive, fast and powerful audit- and analysis tool for Excel files: ExcelAnalyzer. ExcelAnalyer eliminates one of the biggest weaknesses of Excel files by disclosing the structures, formulas, (in)consistencies, complexities, dependencies and manual manipulations that normally remain hidden in plain sight, but require lots of energy, attention and concentration to understand. As a result the analysis exposes bugs that grow inside your models starting as a lingering feeling that something is not entirely right until they suddenly become humiliating emergencies. Catch those bugs before they harm your credibility and honor.