Geir Andersen Email & Phone Number

Västerås, Vastmanland County, Sweden

Sweden

Project leader / scrum master / developer for a quotation system for service agreements etc for an industrial group with world-leading positions in compressors, construction and mining equipment

Vasteras, Sweden

Performance analysis, refactoring and redesign of existing MES System developed in Microsoft SQL Server 2005.Development of code generation templates for generating stored procedures. The procedures handles insert/updates based on large XML documents.

Performance analysis, refactoring and redesign of existing MES System developed in Microsoft SQL Server 2005.Development of code generation templates for generating stored procedures. The procedures handles insert/updates based on large XML documents.

• System architecture and design in project for implementation of new system for master data handling of products and articles.The assignment has mainly consisted of integration design between existing production and ERP.
• Specification /design of XML schemas (OAGIS)
• Design of user interfaces
• Design of BizTalk transformations
• System specifications
• Architectual documentation (UML)

Pre-study of data warehouse storage of data from test system.

System design and development of test system for steel plate manufacturing.The system was developed with Microsoft Visual Studio 2008 (C#), database development with VS Database Edition and SQL Server 2005, in addition to Altova XML Spy for design of XML schemas.Integration with mainframe systems with IBM WebSphere MQ.Authentication and authorization.

Pre-study Visual Studio Database Edition.Existing MES System developed in MS SQL Server 2005, containing approximately 2000 stored procedures and functions was converted to a Visual Studio Database solution, separated in several project.MS SQL Server 2008 was used as the Database Management System.

• Pre-study, system architecture and design of data acquisition and analysis system for pipe welding machines.The system where developed with Microsoft Visual Studio 2005 (C#).It was separated in multiple tiers:
• Client application for operator handling
• Windows service for data access
• MSMQ queued COM+ components for handling of signals from welding machine via data acquisition card National Instruments PCI-6220The system could store up to 16000 signals /sec. from the welding machine.The acquired raw.

Pre-study, architecture and development of a production planning and optimizing system.The system consisted of:Windows client for operatorsWeb client for customer portalWeb Service for Web clientWindows Service for business layer and Data access layer (.NET Remoting components)

Design and development of communication interface between Baan ERP System and Wonderware InTouch SCADA system.The system was developed with MS Visual Basic 6.0, and extensive use of Win32 API for detecting keyboard activity and location of input controls in Baan’s user interface.

• Design and development of MES System for scrap handling and steel melting.The system where developed with MS Visual Studio 2003 (VB.NET).The system consisted of:
• Windows client for operators
• Windows Services for messaging and notifications between clients
• Middle-tier components (COM+)
• FTP Server application for communication with trolley weight scalesOracle 9 was used as database management system.

Design och development of.NET OPC client for logging via OPC Server.Logging of grind time, tool shift time etc. from PLC via OPC server.The system where developed with Visual Studio.NET 2003 consisting of MSMQ queued COM+ components.Oracle 9 was used as database management system.

Design and development of MES System for grinding of steel bills.The system was developed with Visual Studio.NET 2003 and consisted of a client application and middle-tier components (COM+).Oracle 9 was used as database management system.

Design and development of wireless voting system.The system was developed with Visual Basic 6.0, and consisted of application for administration and presentation, Windows service and COM+ components for data access and communication with remote controls.MS SQL Server 2000 was used as database management system.

Design and development of communication interfaces for Movex ERP System. Service for transaction of orders and material information between MES System and Movex.The system was developed in Visual Basic 6.0 and consisted of Windows Service and COM+ components that were activated with MSMQ triggers.Communication with Movex via the Movex API.Communication.