Curriculum Vitae - Robert Grierson

Nationality: Canadian / Swiss

Residence: Martin-Disteli-Strasse 72,

**** *****, ***********

Telephone: 0041 (0-62-296-**-** (P)

**** (0-76-205-**-**

Email: acd0y2@r.postjobfree.com

Civil Status: Married

Birth date: June 28, 1948

EDUCATION AND TRAINING COURSES

Bachelor of Applied Science University of British Columbia

Member of the Association of Swiss Engineers and Architects (SIA)

CERTIFICATIONS COURSES

Oracle Database Administration Oracle Corp., D ttwil

Object Oriented Technology (Booch DigiComp, Schlieren

Rumbauch)

C# DigiComp, Schlieren

FileNET Supporting IMS on Unix - FileNET Corp, Cosa Mesa, California

AIX

Corba Middleware. Internal courses

at UBS

TECHNICAL CAPABILITIES

OS: Windows NT, Windows XP, Windows 7

Languages: C#.NET, VB.NET, ASP.NET, VB 6.0, C++, VBA, VBScript,

JavaScript, XML, XSD

RDBMS: SQL SERVER 2008, ORACLE, MS-Access, Infragistic

components

Networking: IIS, WCF, TCP/IP, HTTP

Tools: Visual Studio.NET 4.0, TFS, nUnit, Subversion,

WinForms, Visio, ClearCase, SourceSafe, CorelDraw,

Microsoft Office, SSIS, Team Foundation Server, XML Spy,

Reporting Services, MS Access 2010, Excel 2010

Methodologies: UML, Scrum / Agile

Hardware: Intel-based PCs, Windows Servers

TECHNICAL INTERESTS AND DEVELOPMENT

I have extensive experience with VB 6.0, VBA, MS-Access. Ported databases

from MS-Access to SQL Server and modified the client programs accordingly.

Have experience rewriting VB 6.0 source code in C# and VB.NET.

Good documentation skills using CorelDraw, VISIO, PowerPoint, and Microsoft

Office.

Good people skills working in teams large and small.

Worked as an engineer; both as a designer and on the construction site in

Canada, Nigeria and Saudi Arabia.

LANGUAGES

English: Mother tongue German: Good spoken and

written

PROFESSIONAL OBJECTIVES

Technical consultant.

Project leader.

Senior designer / analyst.

PROFESSIONAL EXPERIENCE

01/08/2012 - 31/03/2014 Credit Suisse Developer / Analyst

Achievements: Asset Management - Indexed Solutions (ETFs)

Maintain and extend programs that manage indexed portfolios for

large corporate

clients. Production support. Development of MS Access,

Excel and C#.NET programs.

- Designed and developed Swiss Corporate Bond Index (Ticker CHCORP)

- Excel 2010, MS Access 2010

- Excel Addins, Subversion source archiving, Remedy ticketing system

- Visual Basic for Applications

- SQL Server 2008, SQL Queries

- Technical documentation with Visio and Word

01/06/2011 - 01/06/2012 UBS AG Developer / Analyst

Achievements: Ported a VB 6.0 program from Windows XP to VB.NET and

Windows 7.

This program manages all dividends and interest payments for UBS

customers in Switzerland.

It interfaces to IBM Mainframes via Corba services.

- VB.NET, VB 6.0, Visio, .NET Framework 4.0, SQL Server 2000

- WinForms with native Microsoft components.

- Crystal Reports to create XLS and PDF printed output

- Excel with Visual Basic for Applications (vba)

- Technical documents with Visio and Word

- SourceSafe code archiving system

28/06/2010 - 01/06/2011 Fischer Clinical Developer /

Analyst

Achievements: Fisher Clinical Services creates drugs for pharmaceutical

companies such as Novartis,

Bristol-Myers Squibb and Merck. The software is used to create

very flexible price quotations that can be sent to the customers

in PDF format. Complex reports can be created that monitor

database changes and employee performance. Documents can be

archived to the database and

attached to individual quotations.

- Project management, analysis and development

- C#, WCF, SQL Server 2008. Visual Studio 2010 Ultimate und Framework

4.0

- Excel with Visual Basic for Applications.

- Wrote interfaces to production machines.

- Flexible PDF, multi-language output.

- WinForms with Infragistics components

- Used Reporting Services extensively to create ad hoc reports and

fixed reports

(Tables, matrix tables, pie charts, bar charts, etc.)

- Compared Silverlight with WinForms

- Technical documents with Visio and Word

- Scrum / Agile

01/08/2008 - 27/06/2010 Trueb AG Developer / Analyst

Achievements: Developed and maintained all UBS credit cards and Maestro

cards, COOP Supercard. TicketCorner cards and Corn rBank cards.

Was responsible for all Swiss identity cards.

Converted VB 6.0 / MS-Access programs to C#.

Wrote software that drove the DataCard and Muehlbauer machines.

- C#, VB.6.0, MS-Access, SQL Server 2008, N-Unit testing, Rich

clients with interface architecture. Used web services to store

customer images, parse import files, etc.

- MS Access with Visual Basic for Applications.

- Card production machines: DataCard, Muehlbauer

- XML Spy, Team Foundation Server, Visual Studio - Framework 3.5,

NUnit

-

01/01/2008 - 01/04/2008 Bank of International Settlements, Basel

Analyst / Developer

Achievements: Wrote risk management software that calculates and

presents time series, correlation and

values at risk data using VB.NET with SQL

Server 2005.

Wrote a package using the Integration Service

from SQL Server 2005 that transfers data from

XML files and store it in an SQL Server 2005 database.

Wrote highly generic code that allows BIS to add new

currencies and investment instruments

without requiring changes to the front end.

VB.NET, SQL Server 2005, Visual Studio, SSIS

- VBA for MS-Access and Excel

- Database design. WinForm Development

- Source code management with Subversion and PVCS

- Risk Metrics datafeed

- Correlations, TimeSeries, Value at Risk

01/01/2007 - 01/09/2007 UBS Analyst / Developer

Achievements: Analyzed the existing software. Designed a new system

based on a SQL Server solution

Modernized the UBS program that manages salaries for all UBS and

contract employees.

Wrote C# .NET web utility programs to managed the data transfer

to SQL Server.

Wrote VBA code to recognize the new SQL Server database.

- Project lead

- Provided schooling for the UBS employees with regards to the SQL

Server database

- VBA for Access, SQL Server 2005, Visual Studio 2.0, ASP.NET 2.0,

C#, CruiseControl

01/06/2006 - 01/01/2007 Credit Suisse Production Support /

development

Achievements: Developed and maintained software that manages the

salaries and compensations for

all bank employees. WinForms and Web programming.

Ported megabytes of Excel data to SQL Server. Intensive use of

MS SQL.

Implemented exception handling and error handling.

- VB 6.0, VBA, SQL Server, Citrix, Visio, Excel,

01/08/2005 - 01/06/2006 Winterthur Insurance Visual Basic / Oracle

developer

Achievements: Designed a graphical user interface that managed hundreds

of investment portfolios.

Wrote programs to assist portfolio managers with foreign

exchange hedging and asset management.

Insurance companies in Switzerland are obliged by law to hedge

all investments against

currency fluctuations. The software combines hundreds of Excel

sheets into one program

that gives fund manages an overview of all investments. Unique

user-friendly graphical

user interface.

Extensive use of metadata to generate forms automatically from

templates.

- Visual Basic, 'True DBGrid', Excel Macros, Oracle Warehouse Builder (OWB)

- Oracle database, PL SQL, TOAD, Windows 2000 Clients, Citrix Servers

01/10/2004 - 01/08/2005 Inkpot Software C# Developer

Achievements: Designed a 'Drag and Drop' graphical user interfaces

to build XML trees.

C# development with WinForms

Wrote C# software to create detailed XML / XML-Schema files according

to the W3C norms.

The software is used to create XML documents and to validate those

documents with XSD files.

- DOM Validating Text Reader, tree views.

- Project lead

01/01/2004 - 01/10/2004 Syngenta Program builder, installer.

Achievements: Delivered a high performance software package that

allowed chemists to discover effective fungicides and

herbicides quickly.

Assisted developers with C# web development.

Coordinated the activities of two large development teams, in Basel

and in Jealott's Hill England.

Built program packages usng the NANT compiler.

Used a ClearCase source repository for source control. Created virtual

website using IIS.

Ported program builds to the various websites for tester and

developers.

- Constructed and configured IIS Web Servers

- Windows Services

- Wrote and debugged C# code

- Generated executables and deployed them on various servers

- Stored and managed source code with ClearCase.

01/04/2003 -01/ 01/2004 Credit Suisse Web Developer.

Achievements: Extended the life cycle of a large legacy web

application - Compliance Tool

used by the front office to administer all corporate and

client accounts.

This included all numbered accounts, custodian accounts,

private and corporate accounts. Wrote extensive MS SQL

code for SQL Server 2000 databases.

Maintained and improved a large web application that controlled all

private and corporate

accounts at Credit Suisse. Wrote ASP and VBScript code for the serve-

sider, and JavaScript for the client-side. Added new features as

requested by the Swiss Banking Association.

Wrote stored procedures for the SQL Server database to fix bugs and

improve performance.

- ASP, HTML, XSL

- JavaScript (Client-Side)

- VBScript (Server-Side)

- SQL Server (Stored Procedures, Triggers, Normalized tables)

01/02/2002 - 01/03/2003 Inkpot Software Web Developer, C#

Achievements: Created a web site using the newest .NET technology

Created a website from beginning to end with Visual Studio.NET using

ASP.NET and ADO.NET with an MS Access database. Animated the home page

with JavaScript. Developed a document ordering system for the SIA.

Multi-language feature (English, French and German).

- C#, ADO.NET, ASP.NET, HTML, XSL

- Used JavaScript to allow dynamic updates of home page.

- Uses MS Access database as a data store.

- Project lead

01/09/1998 - 01/ 01/2002 UBS C++ Developer, Middleware

Developer

Achievements: Delivered UBS's first phone banking service.

Wrote C++ code that allowed customers to query their accounts over

the telephone.

Wrote middleware (Corba)programs that allowed cashiers to communicate

with the mainframes.

- C++, SNIFF++, Rogue Wave

- Lucent Technologies Voice Recognition

08/1997 - 01/09/1998 FileNET Solutions System Engineer

Achievements: Mastered the hardware and software of a large, high

end document archiving system.

Installed FileNET IMS software, AIX Unix, Oracle database, scanners,

and printers.

Installed systems are Credit Suisse, St. Gallen Kantonal bank, etc.

01/1997 - 08/1997 Imagic Bildverarbeitung SQL Server database

administrator

Achievements: Delivered a large, high performance SQL Server

database to store customer

images and documentation

Created and maintained a large SQL Server database that stored

thousands of bitmap images.

Wrote C++ software to view and manipulate those images.

Created a complete SQL Server database with tables, stored

procedures, triggers,

keys, and constraints. Loaded all IMagic bitmaps into the database

and wrote client

software that allowed customers to browser the "thumbnails".

- Microsoft C++

- SQL Server (Triggers, Stored Procedures, Constraints)

- MS Access

01/1984-11/1996 Worked as an IT analyst and developer at several

Swiss companies.

03/1977-01/1984 Worked as a design engineer and as a site engineer

in several countries.

Contact this candidate