Sql Server Visual Basic

LEONID IDASHKIN

PHONE: 732-***-****

E-MAIL:**************@*****.***

** ****** ******* ***.** PARLIN, NJ 08859

Objective: Senior Programmer/Analyst

With Areas of Professional Expertise:

Mainframe Design & Maintenance: Fifteen years’ experience on variety of applications with:

COBOL

COBOL II

CICS

DB2/SQL

SPUFI

QMF

Teradata,

SAS

Easytreive

Syncsort

Comparex

JCL

M.F COBOL

File Aid

File Aid/DB2

Xpediter

TSO/ISPF

Some C++

Object Technologies

Com, Ole, Active X Automation, Compositive Active X Controls, Object Oriented Design Using Visual Basic 6.0

Win32 Development

• N-Tier Client-Server with Visual Basic 6.0.

• Sheridan Data Widgets 2.0.

• APEX DB Grid 6.0

• PVCS (Version Control) 6.0

• Olestra Resizer

• Install Shield 5.0.

• GUI Design &Implementation

• Visual Studio Modeler

Database Technologies

Database design and implementation with SQL Server 6.5 and DB2 Universal Database.

Focus on achievement of Object Orientated Design in SQL Tables.

Database access through DAO, ODBC, ADO and RDO.

Other Skills: Five years’ experience on variety of PC applications including

Internet Development –Active Server Pages, VB Script, Java Script, HTML, DHTML.

Project Consulting

MS Data Report

Crystal Report 6.0

Professional Experience with Areas of Notable Accomplishments In:

Manager: LID Trading: Parlin, NJ 02/2004-03/2015

Communicated with stock brokers all over the United States and completed thousands buy and sell orders

Traded millions of trading shares on electronic networks daily.

Analyzed markets and stock fluctuations when calculating optimal trade times

Senior Programmer/Analyst: Administrative Services Only, Inc. Stream Valley, NY: 02/2000- 03/2003

Database Technologies

Administrated and maintained SQL Server 6.5 databases, including tables, views, stored procedure design, backup, recovery and tuning of databases. Expertise in dbcc, bcp and spsysmom utilities.

PC Applications

Designed and implemented a three-tier business application using Visual Basic 5.0, SQL Server 6.5 and Active Server Pages consisting of VB 5.0 and HTML front-ends and business objects written in VB 5 communicating to SQL Server 6.5 via ADO.

Created HTML front-end using XML Technology and available online (hpp://www.ASONET.com).

Maintained various business objects (Client, Member, Claim Contribution, Employer) packaged into ActiveX DLL’s written in VB 5.

Design and created various ActiveX controls.

Created various types of reports using SQL Server 6.5 and Crystal Report.

Senior Programmer/Analyst: Guardian Insurance, New York, NY 02/1999- 02/2000

Analyzed, designed and programmed of the Agent Service and Employee Help desk System to provide users with complete information related to the company’s employees and agents.

Accessed if specified. The system utilizes existing mainframe components (DB2 tables, batch modules, queries, etc.) and new GUI components developed on Visual Basic 5.0.

Connectivity between Client and Mainframe were provided using application-to-application interface (AAC).

New DB2 tables were added to the existing employees DB2 Warehouse database to reflect agent data. Involve in GUI screens design, validation modules, testing requirements, etc.

Mapped elements in flat files and DB2 tables, coded COBOL/SQL programs to loaded data from files into DB2 tables, created JCL deck, coded COBOL/SQL programs to loaded data from files into DB2 tables.

Programmed COBOL/CICS processors to transfer data from VB screens to the mainframe and back to the PC. Logical and physical SQL Server 6.5 database design for testing purpose.

Senior Programmer/Analyst: Bristol-Myers Squibb, Hopewell, NJ 04/1998 –02/1999

Member of design/coding and testing team for SFA system using interactive front-end written in Visual Basic 5.0 and calls to mainframe CICS region.

Involve in testing and renovation strategy to be used, analysis of the application to identify and fixing Y2K related problems.

Unit/System testing was performed.

Testing was coordinated with CorNet to fully test the entire SFA process.

Test Protocols were developed to ensure that critical business functions supported by SFA continue to operate before, during and after Year 2000.

Test Cycles were identified to exercise the domain of dates and range of processed data.

Installation of the SFA application in the production environment

Used Comparex to compare files.

Education

Bachelor Degree in Computer Science. Polytechnic University, USSR

Contact this candidate