Experience

GGA Software

02.2012 - now - software developer.
Developing components and intranet products for major pharma companies. VBA/ASP.NET/MSSQL

Visma Services Teemuaho Oy

06.2011 - 12.2011 - software developer.
Creating intranet portal for accounting agencies in Nordic countries. Developing budgeting and forecasting module. ASP.NET, MSSQL 2008, Ajax

European Bioinformatics Institute

06.2009 - 12.2010 - staff software developer.
Providing technical support for scientific research, development of online database of genetic data (Gene Expression Atlas). http://www.ebi.ac.uk/gxa Java, Jsp, Spring, JQuery, Oracle 11g, PL/SQL, bash scriptiing, Maven, IDEA IDE. Continous integration suite - SVN, Bamboo, Track. Implemented scientific data exchange protocols (DAS, Eb-eye). Developed and implemented CEO strategy, designed object model for query interface, completely rework database schema and provided stored procedure interface for application development. Performed query optimisation and created bulk load utilities. Created several visualization modules using SVG and batik toolkit.

US Concepts

11.2006 - 03.2009 - Senior Software Engineer.
Web application development, MSSQL development and administration, ASP.NET 2.0 WebForms and WinForms development, legacy applications support, staging and production environment setup and administration (IIS 5.0,6.0, MSSQL 2000, 2005, 2008), collaboration suite setup (Microsoft Visual Studio 2005, Microsoft Visual Source Safe, Mantis, Subversion, MSBuild, TeamCity build server).
Diageo Event Management Center (http://diageo.usceventcenter.com) intranet website allowing our client to schedule promotions and book samplers to work on those events. I made major contribution in developing relational models (MSSQL 2000/2005 150+ tables, 1500+ database objects, 2GB+ of relational data, 1600 registered users),created responsive UI library using Microsoft Ajax Toolkit, MS Excel integration, created numerous data entry and reporting forms (ASP.NET 2.0, Ajax),implemented granular authorization control using Microsoft Role/Membership providers. Important part of work was analyzing user’s requirements, planning work for deadlines, creating project documentation and setting objectives to junior developers and outsourcing vendors.
RSVP websites - family of websites inviting users to register for promotions (which was scheduled in Event Management Center above). User can choose event, submit some personal info and survey responses, and receive confirmation email with barcode, which they can use at check-in. I designed and prototyped architecture, created SOAP WebService used as unified data source, set up and administer high-availability production environment (load balancer recorded 400 tcp connections per second, 30 registrations per minute was recorded at peak). Numerous maintenance and reporting tasks was performed after sits was launched, including IIS web and SMTP log analysis.
Handheld Data Capture - Checking in customers to events, scanning IDs, uploading data to centralized database. Tablet PC computers (Windows XP tablet PC edition, .NET 2.0) or PDA (Windows Mobile, .Net Compact Framework) are used to scan diver licenses (we use PositiveAccess parsing library) or enter data manually. I created set of utility programs to access PDA settings (unmanaged C++), made major changes to device program, created synchronization application (utilizing OneClick technology) to download current version of device software from server and install it on PDA (WinForms, connect to device using open-source ActiveSync wrapper), web service used to download promotion schedule, and upload consumer’s data. Created encryption library for .Net compact framework compatible with System.Security.Cryptography.Xml.EncryptedXml

Thomas Publishing Company

03.2003 - 11.2006 &ndash (US) - Software Engineer

Web-based catalog hosting solution, focused on advanced search capability. http://catalogs.thomasnet.com/index.html - list of clients. My job role is to create data maintenance utilities (command line, windows applications, web application). I made several integration components – ISAPI filters, IFilters, COM objects for accessing IIS metabase. MSSQL 2000, web farm with IIS 6.0, ASP.NET 2.0.
Database performance troubleshooting, query optimization. Designing database schema, creating stored procedures, UDF, indexed views, triggers.ISAPI filter for user-friendly URLs rewriting and HTTP 301 redirects .NET object for data upload/download/move between servers. (C#, bcp utility, TSQL) Porting Java-based image optimization server to C#. Batch email utility – Add-In for Outlook2003 (C#,WinForms), that call web service for list of email addresses, and create customized emails for each client. Web interface to review and edit email addresses in database. Integration link browser web application http://catalog.orientalmotor.com/links (example). Google sitemap creator - C# class that retrieve all possible client’s catalog urls from database, zipping and saving in virtual web server root, as per google specs. Google ranking tool - used to automatically evaluate position of client’s catalog in google searches for given keywords (Google API). Web log analysis application (DTS, Reporting Services, TSQL, ip addresses geolocation database – mySQL, weblogs raw data – Oracle DB). Replication set-up and troubleshooting, OLE-DB linked servers setup and use (Oracle, mysql), IIS server metadata browser/virtual directory rename utility. (C#,ADSI)

Aelita Software Corporation

10.2002 – 03.2003 - VC++ programmer
Projects: Domain Migration Wizard, Exchange Migration Wizard - Windows network administration tools.
COM components implementing LDAP, HTTP protocols.
Querying Active Directory via LDAP

Intellex Co.

09.1999 - 10.2002 - (Russia) - Lead Software Developer
Projects: "ETRAN","ARM Agenta" – Automation systems for ministry of railway transport of Russia. (MSSQL 6.5/2000/Oracle 8i/Micrososft IIS. Participation in development of database schema, server side coding, tuning optimization and maintenance (MSSQL 6.5,2000, Oracle 8i). Development of client-side application (Delphi 4.0,5.0/BDE) Development of communication services (MSVC++ 6.0, STL, WinSock, DB-Lib, OCI, Win32 API, multithreading, TCP/UDP). Extended procedures (MSSQL 6.5, 2000) and PL\SQL wrappers for communication with IBM MQSeries Server (GNU C for SUN Solaris). Oracle Heterogeneous Services (HS) tuning for communication with OLE-DB/ODBC data providers.

Astro Soft Co.

01.1999 - 07.1999 - Software specialist
Senior specialist on MS SQL Server 6.5 and 7.0. Participation in development of several projects (VB 5.0,MS Access 97,MS Access 2000,VBA,MSSQL 7.0) Database administration.(MS SQL 7.0)

IT.Co

11.1997-12.1998 Programmer, project manager
"Boss-Company" - ERP system for large industrial enterprises. Server: Btrieve, MS SQL Server 6.5. Development of accounting modules, Extensive use of CASE tools: ER-Win, BP-Win. Managing project on system customizing for Moscow Mill Factory N4. (3-5 people group/ 3 month)

Physical-Technical Institute, St.Petersburg.

1994 - 1997 Research assistant (part time)
Quantum electronics lab, Semiconductor lasers investigations. Diploma on numeric simulation of high-speed laser behavior. Numerical calculation (MatLab, MatCAD,Fortran) Experiment automation setup and data processing. (Turbo Pascal 7.0, ASM, RS232 protocol) Data analysis (Origin,Fortran)