Project experience
Project experience
For an association of Dutch insurers |
(July 2009 - To date) |
|---|
|
Role |
SAS consultant |
||
|
Technology |
SAS Information delivery portal |
||
|
SAS version |
9.2 & 9.1.3 |
||
|
Environment |
Windows 2003 server 32-bit and 64 bit. |
||
|
Project summary |
Migration of the clients Information Delivery Portal applications, themes and CMS synchronisation application from SAS 9.1.3 on Windows server 2003 32-bit to SAS 9.2 on Windows server 2003 64-bit. |
For an international clinical solutions organisation |
(April 2009- To date) |
|---|
|
Role |
Project manager / senior SAS consultant |
||
|
Technology |
SAS Enterprise Guide Add-in (Microsoft DotNet) |
||
|
SAS version |
9.1.3 |
||
|
Environment |
Windows XP. |
||
|
Project summary |
Development of an application allowing the users to perform guided statistics via an enterprise guide Add-in; therefore creating a validated and controlled environment for reporting and allowing the users to exploit the functionality of enterprise guide with the results of the analysis. |
For an international veterinary life science organisation |
(April 2009 – To date) |
|---|
|
Role |
Project manager / senior SAS consultant |
||
|
Technology |
Microsoft DotNet, SAS server, Integration technologies, Oracle |
||
|
SAS version |
9.1.3 |
||
|
Environment |
Windows XP / Windows 2003 server |
||
|
Project summary |
Development of a Windows based client server application communicating with the SAS server using SAS Integration technologies and storing the data in Oracle. The application allows the users to enter the results from their measurements into the application and perform Trend analysis or stability analysis on the results of their measurements to ensure the results stay within the required range (six-sigma). |
For an international pre-clinical life science organisation |
(January 2009 – To date) |
|---|
|
Role |
Project manager / business analyst |
||
|
Technology |
Microsoft DotNet, Oracle, POS |
||
|
SAS version |
NA |
||
|
Environment |
Windows CE / Windows XP / Windows 2003 server |
||
|
Project summary |
Development of a Dose Control system using Pocket PC scanners in a Point-Of-Service architecture. With the Pocket PC scanners the bio technician scans the Cage or animal and the dosing. The information is send via the secure wireless network to the server for verification and registration. |
For an association of Dutch insurers |
(July 2007 - To date) |
|---|
|
Role |
Project manager / SAS consultant |
||
|
Technology |
SAS Information delivery portal |
||
|
SAS version |
9.1.3 |
||
|
Environment |
Windows 2003 server |
||
|
Project summary |
Implementation of the SAS Information Delivery Portal. This portal allows controllers, analysts and researchers to benchmark their company results against the market by means of on demand reports. The information is extracted directly from their data warehouse consisting of several OLAP cubes. To allow the users to request detailed information by querying the information in the OLAP cubes a bespoke user interface was developed allowing users to drag and drop dimensions and measures to the rows and columns of their report. Before this data will be presented to the user several tests are performed on the data to ensure that the market total cannot be traced back to a data of a single competitor. To enable automated user and group management, programs have been developed that synchronise the information between the customers’ CRM system and the SAS information delivery portal. The differences will be displayed in bespoke maintenance programs in the portal as the administrator wishes to manually verify the changes. Group membership can be modified. |
For an international Telecommunication supplier |
(May 2007 – June 2007) |
|---|
|
Role |
SAS Consultant |
||
|
Technology |
SAS add-in for Microsoft Office |
||
|
SAS version |
9.1.3 |
||
|
Environment |
Windows XP / Windows 2003 server |
||
|
Project summary |
Development of several stored processes tailored to be used through the SAS add-in for Microsoft Office, allowing key users to extract the Business Intelligence information available into their office applications in a controlled manner. |
For an international pharmaceutical organisation |
(May 2006 – December 2006) |
|---|
|
Role |
Project manager |
||
|
Technology |
SAS Information Delivery Portal |
||
|
SAS version |
9.1.3 |
||
|
Environment |
Sun Solaris 5.8 |
||
|
Project summary |
Development and implementation of additional user requirements for the SAS Information Delivery Portal (IDP). Which included: A data explorer able to display study datasets in the IDP, Functionality to sort and filter dataset in the bespoke data explorer, Functionality to search for specific strings in all study data sets, A tables and listing browser with the ability to save the existing tables and listings as a PDF or Word document, An audit trail to enable reproduction of results and Data driven menu items and interface screens. |
For an international pre-clinical life science organisation |
(December 2004 - June 2005) |
|---|
|
Role |
Project manager / SAS Consultant |
||
|
Technology |
Delphi, SAS server, Integration technologies, SAS/AF |
||
|
SAS version |
9.1.3, 8.2 and 6.12 |
||
|
Environment |
Windows XP / Windows 2003 server |
||
|
Project summary |
Migration of two existing SAS/AF reporting applications from PC based SAS (version 6.12 and version 8.2) to server based SAS version 9.1.3. The migrated application is a multi-user, client/server reporting application with a Windows based User Interface. |
For an international Telecommunication supplier |
(September 2004 - January 2005) |
|---|
|
Role |
SAS Consultant |
||
|
Technology |
SAS server, Integration technologies, Microsoft Excel (VB script) |
||
|
SAS version |
9.1.3 |
||
|
Environment |
Windows XP / Windows 2003 server |
||
|
Project summary |
Development of a SAS data warehouse system and accompanying client interface developed in MS Excel (prototype follow-up). Functionalities include porting data from Excel to the SAS data warehouse and retrieving the information from the data warehouse via custom build Excel function or as complete reports via the Interface developed in Excel. |
For an international office equipment supplier |
(July 2004 - September 2004) |
|---|
|
Role |
SAS Consultant |
||
|
Technology |
SAS/IntrNet, SAS Campaign management, Oracle |
||
|
SAS version |
8.2 |
||
|
Environment |
Windows XP / UNIX |
||
|
Project summary |
Development of a browser-based SAS application allowing users to optimise campaign strategy. The data to be used was imported from SAS Campaign management, processed by the user via the browser interface and the result was exported to Campaign Management again. |
For an international Telecommunication supplier |
(July 2004) |
|---|
|
Role |
SAS Consultant |
||
|
Technology |
SAS server, Integration technologies, Microsoft Excel (VB script) |
||
|
SAS version |
9.1.3 |
||
|
Environment |
Windows XP / Windows 2003 server |
||
|
Project summary |
Development of a Management Information System prototype to establish insight on effort and feasibility for a large MIS project encompassing a SAS data warehouse and an Interface via MS Excel. |
For a pre-clinical life science organisation |
(January 2004 - June 2004) |
|---|
|
Role |
SAS programmer / Business analyst |
||
|
Technology |
SAS/AF |
||
|
SAS version |
8.2 |
||
|
Environment |
Windows XP. |
||
|
Project summary |
Development of a reporting system capable of reporting on historical data. The data is extracted from the clients Oracle based data-entry package in which the results of all studies are stored. |
For an accountants organisation |
(May 2002) |
|---|
|
Role |
Web developer |
||
|
Technology |
HTML, JavaScript and Perl |
||
|
SAS version |
NA |
||
|
Environment |
NA |
||
|
Project summary |
Development of a dynamic website to present the company. |
For a pre-clinical life science organisation |
(February 2000 – August 2002) |
|---|
|
Role |
SAS programmer |
||
|
Technology |
SAS/AF, PostScript and RTF |
||
|
SAS version |
6.12 |
||
|
Environment |
Windows 2000 |
||
|
Project summary |
Development of a flexible reporting system for pre-clinical data residing in an Oracle based data-entry package. During a nightly Extraction Transformation and Load process the application prepares the data for reporting. The User can select the reports to be created from the SAS/AF application and these can be presented in MS Word and PDF. |
For an art consultancy company |
(October 1999) |
|---|
|
Role |
Web developer |
||
|
Technology |
HTML, JavaScript and Perl |
||
|
SAS version |
NA |
||
|
Environment |
NA |
||
|
Project summary |
Development of a dynamic website to present the company including an online ordering facility. |
|
Internal project |
(September 1999 – February 2000) |
|---|
|
Role |
Web developer |
||
|
Technology |
SAS IntrNet, HTML, JavaScript and Perl |
||
|
SAS version |
6.12 |
||
|
Environment |
Windows 98 |
||
|
Project summary |
Development of the company Intranet |
|
Practical period |
(February 1999 – June 1999) |
|---|
|
Role |
Student |
||
|
Technology |
SAS IntrNet, HTML, JavaScript |
||
|
SAS version |
6.12 |
||
|
Environment |
Windows 98 |
||
|
Project summary |
Researched the usability of SAS/IntrNet to web-enable existing SAS applications. |