Docstoc

Otto Schreibke CV

Document Sample
Otto Schreibke CV Powered By Docstoc
					                                          OTTO SCHREIBKE

Weinhaldenstr 37B                                                               Mobile: +41 76 390 2721
CH-8645                                                                            Tel:+41-55 214 2721
Jona                                                                              Fax: +41-55 214 2724
Switzerland                                                                     Email: otto@solwiz.ch


Profile
A highly skilled senior IT consultant with an impressive track record of solutions development in international
corporate environments. Extensive experience in the harnessing of new technologies to achieve strategic
commercial aims. Strong European business perspective, with the mobility to locate within the UK and Europe.


Career

March 2011- date                        IT Consultant at Helvetia Insurance, Basel.
       Application developer on a project to complete a MS Access application for a pension planning tool.
        Technologies employed: MS Access 2010 front-end to a SQL/Server 2008 database back-end.

June 2010 – March 2011                  IT Consultant at Bank Morgan Stanley AG, Zurich,
       Application designer and developer on a project to upgrade monthly regulatory reporting for investment
        bank BMSAG, working inside Swiss banking secrecy laws. The project migrated the current solution
        based on MS Access and manual procedures to a more robust and secure platform based ON MS SQL
        Server. This phase addressed statutory reporting for the Swiss regulatory authorities. Information is
        consolidated from various sources, including databases on Informix and Sybase. A follow-on project
        developed a solution to automate data feeds to regulatory reporting for Financial Controllers. Prepared a
        preliminary design for an application to report the requirements for accounts in segregated markets.
        Reverse engineered an application to print customer confirmations in preparation for migration from VB6
        to C#. Involved in support activities for the confirms application, including performance analysis of the
        application's Sybase database. Technologies employed: MS SQL/Server 2005, SQL Server
        IntegrationServices and SQL/Server Reporting Services, Autosys job scheduler and VB6. Shell scripting,
        PERL and awk on Solaris platform for data extracts from Informix, Sybase and MS SQL Server.

July 2009-Oct 2009              IT Consultant for ITPS AG, Kreuzlingen.

       ITPS provides professional services to a number of companies, primarily related to MS SQL/Server.
        Performed a DBA role for ITPS’ customers, primarily in the banking sector. Responsibilities included
        day-to-day supervision of MS SQL server installations, activities related to compliance and introduction
        of the company’s backup application. Some development work in C# for a customer’s asset
        management system. Platform: Wintel: MS SQL/Server 2000 and 2005. C#, T-SQL and batch scripting

July 2008-June 2009             IT Consultant for IBM Banking Competency Center (BCC), Prilly.

       The BCC provides services to a number of banks in French Switzerland. Initially member of a team to
        assist the BCC to prepare for audit readiness on the hosted customer servers. Activities included an
        assessment of MS SQL server, MS Windows and MS IIS installations for compliance with IBM’s security
        policies, together with support for other team members. On completion, performed a DBA role
        responsible for backup and operation of the MS SQL Server instances, together with ongoing
        responsibility for compliance. As part of the compliance effort, responsible for the implementation of a
        backup and monitoring solution. Platform: Wintel: MS SQL/Server 2000 and 2005, T-SQL, VBScript and
        batch scripting.

May 2007-March 2008             IT Consultant for DWS Holding & Service GmbH, Frankfurt.

       Designed and developed an application to create Excel templates for Asset Management reports. The
        template application also provides a multi-threaded generation facility for the templates. The whole is

                                                                                                     Page 1 of 4
                                         OTTO SCHREIBKE
       integrated into an existing application framework. Additional tasks include maintenance of the existing
       reporting application. Platform: C# (Winforms) with SyncFusion and Aspose components and Excel
       automation, SQL/Server 2000, Windows XP and Visual Source Safe.

July 2006-April 2007           IT Consultant for Dresdner Kleinwort, London.

      Member of a team to support a sub-ledger application to reconcile information coming from the front and
       back offices, and make accounting postings from the consolidated information for the investment bank.
       Primarily tasked with specifying, developing, documenting and implementing changes based on client’s
       work requests. Platform: MS Windows 2003; Finarc’s Financial Studio package; SQL/Server 2000 with
       T-SQL, DTS, stored procedures, user defined types (UDTs), user defined functions (UDFs), table and
       view definitions; Visual Source Safe 6.0.

Dec 2005-July 2006             IT Consultant for Dresdner Kleinwort Wasserstein, Frankfurt.

      Member of a team to implement a sub-ledger application to reconcile information coming from the front
       and back offices, and make accounting postings from the consolidated information for the investment
       bank. Primarily tasked with specifying, developing, documenting and implementing changes based on
       client’s work requests. Platform: MS Windows 2003; Finarc’s Financial Studio package; SQL/Server
       2000 with T-SQL, DTS, stored procedures, user defined types (UDTs), user defined functions (UDFs)
       table and view definitions; Visual Source Safe 6.0 and some vbScript and batch job scripting.


April 2004 - Dec 2005                  IT Consultant for Accenture.

      Member of a team to design and develop data load routines for a major (ca. GBP 5 billion) project for the
       UK’s National Health Service. Worked on both primary (Torex Synergy) and secondary (iSoft iPM) care
       applications, on file validation, Audit and reconciliation and reporting components. Additional tasks
       involved database performance monitoring and tuning. Recommended changes to improve the
       performance of the vendor’s software. Platform: MS Windows 2003; SQL/Server 2000 T-SQL, stored
       procedures and DTS; C# 2003; XML and XSL; vbScript.


April 2003 – April 2004        IT Consultant for ActivAD GmbH

      Designed, developed and implemented web-based tool to conduct and manage SMS-based
       competitions. Platform: MS Windows 2003; ASP/IIS with SQL/Server using T-SQL and stored
       procedures, with web service components in C#.Net 2003.

1996 – April 2003      IT Consultant for Dow Europe GmbH

      Offering contract-based web application and desktop database development services, primarily to
       European arm of global chemicals and plastics manufacturer Dow (annual sales $27,609 million, with
       33% in Europe).

      Additional development projects delivered alongside Accenture BV, Dow’s outsourced development
       partner.

      Designed, developed and managed delivery of multiple pan-European desktop and web development
       projects. Comprehensive skills in MS Access, ASP (IIS), VBScript, JavaScript, DHTML, XML, XSL,
       Oracle, SQL/Server, MS Excel VBA and MSWord VBA. Typical small project value $30-$50K.

      Delivered pricing application to two European business units over 12 month period. Significant
       commercial impact included formalisation and control of price negotiation, and improvements in pricing
       data quality. The application includes an automated upload to SAP/R2. Technology used: MSIE,
       JavaScript, XML/XSL, Extra! (Client), ASP/VB with ADO, MS Access database, MS Excel.



                                                                                                    Page 2 of 4
                                          OTTO SCHREIBKE
       Designed and developed major application to facilitate price and manufacturing forecasting and
        planning. Delivered to 3 of Dow’s 15 business units over a 3-year period. Technology used: MSIE,
        JavaScript, VBScript, XML/XSL. MS Access (Client), ASP/VB with ADO, SQL/Server database, MS
        Excel.

       Delivered key application to enable the production of highly commercially sensitive information
        determining customer profitability, by allocating costs to sales, based on activity. Used globally across
        multiple Dow business units by individuals responsible for the financial analysis of business
        performance. Extensive consolidation and "Slice and Dice" functionality. Used Business Objects with
        MS Access database and reporting components in MS Excel.

       Developed distributed financial forecasting application with global reach, used by several Dow business
        units in the four administration sites around the world. Used MS Access with Oracle 8i database to
        collect financial forecast, actual and plan information and allow comparison at various consolidation and
        selection levels.

       Produced sales and purchase reporting application to present unit price information for performance
        analysis and market price comparisons. Used Business Objects for data extraction and MS Access for
        data consolidation, loading and reporting, with SQL Server database. Export functionality to MS Excel.

1994 - 1996      Project Leader at Dow Europe SA, Switzerland

       Project leader for site workstation rollout
       Project leader for accounting application decommission.
       Facilitated Project Planning workshops.
       Project Estimator for Europe.

1990 - 1994       Internal Auditor at Dow International Service Center NV, Belgium

       Led and participated in Internal EDP audits.
       Developed audit support software (IBM 370/MVS, Dyl/280, TSO/ISPF)

1983 - 1990       Project Leader/Developer at Dow Europe SA, Switzerland

       Technical project lead on multiple development projects in IBM CICS Cobol and ADABAS/NATURAL
        environment.
       Extensive Data Modelling (IEW) and database design.
       Provided technical and methodology consultancy for development group.

Pre 1983          Analyst Programmer

       Excellent early IT experience as Analyst Programmer on IBM and ICL Cobol projects in UK companies.
       Culminated in Technical Project Leader role on multiple key projects for CAP-Gemini in Zurich,
        Switzerland.

Education & Professional Memberships
Chartered Engineer (CEng)
Chartered IT Professional (CITP)
Member - British Computer Society (BCS)
Member - Association of Computing Machinery (ACM)
BA (Hons) Computing Science 1972 - University of Essex, U.K

Languages
English (Mother Tongue), German, French

Personal
Date of Birth:   13 December 1950

                                                                                                     Page 3 of 4
                                        OTTO SCHREIBKE
Nationality:   British/Swiss Dual National

                                     References Available on Request




                                                                       Page 4 of 4

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:4
posted:6/28/2012
language:
pages:4