Integrations

• ERP (Microsoft Dynamics, SAP), CRM, ETL, BI (Cognos) integration design & coding ( Java / Python ) - several.
• EDIFACT D96A / XML - several.
• Accounting - several.
• Invoicing - several.
  
• Data collection & statistical data integration for multinational statistics organizations - several.
• WebShop(s) - several.
• ONIX for Books - Book article and availability and pricing information for shops.
  
• Finvoice - Electronic invoincing.
  

Software development

• Software action / operation plans for customers.
• Technical specifications for developers.
  
• Software & hardware testing and reporting.
• Deployment of hardware and software, with plenty of field experience.
• Software tailoring offers.

Networking

• LAN - All small business aspects covered.
• VPN - IPsec / OpenVPN - Connecting networks securely.
• Troubleshooting.
  
• IPv6
• All the usual protocols, smtp, http, https, spdy, ftp, websockets, etc.
  

Other

• POS peripherals - receipt printers, msr, barcode readers, touch screens - configuring, testing, low level stuff like ESC/POS etc, mPOS
  
• Writing detailed issue reports that vendors can't dismiss. They always try to tell that there is nothing wrong with their product.
• Operating environment using Apache Tomcat, MySQL, MSSQL, Windows Server 2000, 2003, 2008, 2012, virtual servers
  
• Field work: Installing and servicing POS systems and everything related and non-related to it.
• Documentation: Writing troubleshooting guides for helpdesk.
• Taking care of all small business IT needs.
• Excellent Point Of Sale knowledge. Customer requirements, including their needs and use of product.
  
• Virtual workgroups, globally distributed teams - Since 1996.
  

Programming

• Standalone Java application with modular design which allows easy extending to fill different customer needs.
  Format options include csv, which is used directly for my first ERP integration. Maintenance still continues.
• Few ERP integrations using Python.
  
• Many small utility programs & scripts, those are needed all the time. Mostly using Python or Java.
  
• Unfortunately I have other higher priority tasks. I still really do love programming.

What have I learned?

• Main goal: Increase profits, reduce costs. That's what why we got this business. Working in small business, it's very easy to learn, that if there isn't profit. There won't be salary. It won't take years to before small business runs out of money. Focus is super important. In some companies, you can do for ever non-profitable work and nobody cares about that.
  
• Don't trust user or 3rd party reports. - Always re-check everything before changing important things.
• If user input can be checked by software, do it. Otherwise there will be continuous data entry errors. It's also very important to design UI so that it guides users and reduces mishaps.
  
• It's much better to make proper plan and complete solution design. Making quick'n'dirty leads for trouble later. At that point exteding, fixing and extending system outside original design scope causes interesting issues. Which unfortunately happens quite often. It's called dynamic growth.
  
• Preventing future problems by proper robust design and implementation. If things work only most of time, it's not good enough and leads to big problems later. Especially if real reason behind the issues isn't getting fixed.
  
• Always pursue the best outcome for the customer as whole. Don't just consider own part of the project, but include all parties, partners, their strengths and weaknesses and complete customer needs.
• Efficiency comes through scale benefits, automation and finely tuned work and process flows while using  optimized tools for given task.
• UX - User Experience is very important. It doesn't matter if you have great or unique product, if nobody wants to use it due bad usability, design issues or other annoying factors.
  

Weaknesses

• Get involved with too many interesting tasks, which then causes prioritization questions, overload and stress.
  

Personal interests

KW: Lehtinen Sami, home page, pages, site, cv, curriculum vitae, resume, background, info, information, samilehtinen, lehtinensami, samleh
AS: kotisivu, kotisivut, yhteystiedot, puhelinnumero, osoite, sähköposti, kokemus, pilvipalvelut.