Sign in

Sql Server Data

Richmond Hill, Ontario, Canada
June 25, 2017

Contact this candidate



** ******** ***. ******** ****, ON L4S 2E1

Cell: 647-***-****


Reliable professional with more than 10 years of experience in system analysis, software development, support, maintenance and database administration for engineering, financial, supply and education applications.

Experience in full SDLC (System Development Life Cycle) and support of large data management systems.

Expertise in structured and object-oriented analysis methodologies, database logical and physical design, coding, testing and debugging techniques.

Strong analytical decision-making and problem solving skills.

Extensive experience in 24/7 on-call system and application support for remote users across Canada and the USA.

Strengths include understanding client needs and history of satisfying customer requests without exceeding deadlines.

Ability to grasp quickly new ideas, methods and tools.

Multilingual: English, Russian and Ukrainian


Operating Systems: MVS, Z/OS, Windows 8.1, VM/ESA,

Languages: Visual Basic, VBA, COBOL, PL1, ASSEMBLER, C/C++, JCL, REXX.

Databases: DB/2 V7, SQL Server, UDB, ACCESS 2016

Tools: MS-OFFICE 2016, Visual Studio .NET, DB2-connect, IMS, CICS, SAS, TSO-ISPF, Remedy.


CONTRACTOR Application development June 2014-Dec 2014

ThyssenKrupp Elevator Toronto

Developing application in VBA for AutoCAD and SQL Server. Modified the previous system.

CONSULTANT Multimedia design Feb 2005 - 2014

Via Net TV

Work with clients of the company to support the software products. Analyze business metrics and created cases for offshore software developers.


Payroll Systems Canada, Toronto, ON (Contract) Jan 2004 – Jan 2005

Analyzed a variety of mainframe HR systems - MVS, ASSEMBLER, PL1, COBOL, IMS, DB2 and CICS. Created specifications for data conversion.

Designed test cases of HR package “Pay mate” in SQL Server 2000, Stored Procedures, VBA for ACCESS, VB.NET, C#, ADO, ASP.NET, HTML environment.

Participated in quality assurance of the product. Analyzed the results of testing the system with manual test scripts. Used Data Dictionary Standard to perform and interpret digital data.

Consulted customers during the implementation of the system


CSC Inc.-ThyssenKrupp, Horn Lake MS, USA Sep 1999 – Dec 2003

Designed the specifications for developing the purchase management system in IBM390, MVS, ASSEMBLER, REXX, PL1, COBOL, CICS, and DB2. Prepared the on-line access to purchase data using DB2-connect, UDB.

Created specification for development of the HR mainframe system for data download to client-server. Used MVS, JCL and VSAM. Used Crystal Reports for Data Performance.

Consulted the support team of the Product Data Management system on an IBM390 using ASSEMBLER, COBOL, PL1, DB/2, VM/ESA, REXX and C/SQL. The application was critical for the customer’s engineering and manufacturing departments

Managed the development and implementation of the system for an on-line elevator design. The system was critical for company market competition. Used OOP, Visual С++, Visual Basic 6, SQL Server, ADO Method, for images file access, COM and stored procedures.( Application is available for demonstration). Created the integrated system of printed and graphical documents for using in elevator design. Solved the problem of on-line access to CAD and drawings files.

Analyzed the requirements for engineering applications for ThyssenKrupp, the primary customer and created the integrated plan of their improvement and redesign.

Performed analysis of PDM system for Y2K compliance and made recommendations for system reprogramming. Evaluated conversion of system to Windows 2000 platform. Analyzed data integrity in the database. Analyzed and made recommendations to the customers for better performance of UNIX server for the database.

Managed the support team of the system for product warranty data. Used Delphi-4, 5, Pascal, ORACLE and UNIX Server. Made significant changes in software by customer's requests.


EDS, Toronto, ON (Contract) Aug 1997 – Aug 1999

The primary customer – Ultramar Diamond oil company in Montreal, QC.

Analyzed, gathered requirements, developed and supported applications for supply, financing, general ledger, property tax and HRIS in an IBM-390 DB/2 environment using VM, SAS, ISPF, REXX, PL1, COBOL, SQL and also MVS, at the customer’s request.

Maintained and supported networking applications for a supply system on client-server using GUPTA tools and ORACLE database.

Prepared test database in DB2 for Y1999 project and tested MVS based information systems. Fixed problems in PL1, COBOL, REXX programs, ISPF tables and DB/2 database to match Y1999 requirements. EDS’s management commended the results.

Participated in SAP implementation. Designed data layouts for GL and FI systems, prepared data conversion from existing database. Participated in the project for transformation of HR and Property Tax systems from mainframe to client-server. Created data layouts and converted information from DB/2 to LAN.

Maintained and programmed the real-time oil supply system on VAX/VMS. Provided on-call 24/7 support for customers across Canada.

PROGRAMMER ANALYST MGV Toronto, ON Contract Position 1995 – 1997

The primary customers – Retail companies: MLCB, LCBO, Home Depot, White Rose

Supported the mainframe systems for data analysis from POS system.

Developed variety of applications on IBM390, MVS, COBOL-II, DB2 and JCL.

Developed the applications for Electronic Funds Transaction on IBM4690 using mainframe RBC software.

Developed and implemented EFT system on IBM4694


The University of Railway Engineering M. Science in Computer Science 1994

Dnepropetrovsk, Ukraine

Evaluated by University of Toronto

Contact this candidate