SMYRNOVA ILONA

Personal data:

e-mail : This email address is being protected from spambots. You need JavaScript enabled to view it.

mob.: +38 (097) 538 6747

 

Skills & Abilities

• SSMS, SSRS, DBMS: MS SQL, ADS, mySQl;
• XBase++, PHP, T-SQL,
• osCommerce, WordPress, MS Access.

EDUCATION

 1987-1993  The diploma of the specialist of mathematics (with Honors) .Faculty of cybernetics of the Shevchenko Kiev State University, specialization – applied mathematics.

Concentrating on programming, calculation methods.

COURSES ATTENDED:

 1990 - 1991   Course of English for beginners

  1993    Pre-intermediate course of English at the Soros International House Language School

 1995    Course of the accountant for business of all kind of property

 1999   Course of net’s administrator (Windows NT, Novell NetWare, Free BSD UNIX)

 2012   Course «Programming 1С Enterprise 8.2» (basic)

WORK EXPERIENCE

December 2004 – June 2022 “Office Link”, Kyiv, SQL developer:

• Experience with MS SQL Server 2008/2012
• Development SQL queries, stored procedures, functions and views (DBMS)
• Development Reports (SSRS)
• ETL-process development (SSIS)
• Data transfer between databases
• Work with the large arrays of information
• Development of reports for the personalization data in MS Access
• Administration and support of Advantage Database Server (ADS)
• Administration and support of Enterprise resource planning (ERP) system “Universal” for the direct mail service
• Development of reports, decision of various tasks with T-SQL
• Development functions, procedures and views
• Development of elements for user interface
• Support business-processes, working with users
• Development of web-sites

 

 Technologies:   SSMS, SSRS, DBMS: MS SQL, ADS, mySQl; XBase++, PHP, T-SQL,

osCommerce, WordPress, MS Access

 

January 1995 – October 2004 – Information Technologies Department of the Concern «Dendi», engineer-programmer:

• working out, installation and administration the program for the furniture shop on goods calculation and movement with help of DELPHI;
• working with database PARADOX, using the CASE-methods and SQL;
• administration of ready application;
• training of users to work with personal computer and new software applications.

 Technologies:   DELPHI, SQL

 

September 1990 - January 1995 – «AIST», engineer-programmer:

• creation of the staff department and accountant workstations with help of database management system ORACLE at the Kyiv central telegraph;
• programming on SQL.

 Technologies:   ORACLE, SQL