## BIO
**Anatoli Khoroshevski**
**Springfield, NJ, USA
****
****SUMMARY ** Over 20 years of experience in computer programming including 10 years of scientific programming for radio-electronic engineering projects. Over 10 years of system design and implementation in various business areas in USA:
***HARDWARE:*** IBM PC MS-DOS, Windows NT, UNIX; NOVELL, BANYAN VINES, LAN; WAN;
DEC PDP/11; VAX/VMS; IBM/360/370 OS/MVS, JCL;
microprocessors INTEL 8085, 80x86, Z80;
***LANGUAGES:*** VISUAL BASIC 3.0/4.0/5.0/6.0/.NET; ASP, ASP.NET, VBScript, Jscript, JavaScript, VBA, VISUAL BASIC for Applications; MS ACCESS Basic; MS EXCEL Basic; MS WORD Basic; MS Power Point Basic, MS Project Basic, MS Visual C/C++; MFC, Borland C/C++; Java; HTML,DHTML, XML, XSL;
PERL, PERL CGI; Transact-SQL, PL/SQL; FORTRAN, SML, ALGOL, PL/1, PASCAL; BASIC;
Assemblers MASM, TASM, MACRO-11, BAL IBM/370;
***SOFTWARE:**** * MS Windows 3.1/3.11/NT/95/98/ME/2000/XP; UNIX; API, DDE, OLE, OLE Automation, COM+,
COM/DCOM, COM Add-Ins***,*** Active-X Controls, SDK, RDBMS, [login to view URL], Sybase 12 SQL Server, MS SQL Server 6.5/7.0/2000, ORACLE 7.0/8.0, DB2, Btrieve, GUPTA SQL, XDB, dBase, Visual InterDev 6.0, MTS, Visual Source Safe 6.0, PVCS, SP Debugger, Q+E Library, ODBC, MS Access, MS Excel, MS Word, MS Outlook, MS Power Point, MS Project 97/2000, MS Project Central, Crystal Reports 3.0-8.5, Seagate Crystal Info, Installshield, Autosys, VISIO, Rabbit Gates 3270 Emulator, Windows Communication Library, PC Client Communication Library, SQL Sombrero, ERWIN, DBArtisan, Rapid SQL, XPEditer/SQL, 3rd party VBX and OCX controls, Great Plains, MAS-90, FTP, CA WEB Project Management System, TrackWise Web TeamAccess Project Management System, Business Engine Network Project Management System, Microsoft Terminal Server, Citrix Metaframe .
***APPS:*** Project Management Systems, LIMS, Brokerage and Financial Systems, Banking, Accounting Systems, Insurance, Medical, Client Server, Relational Database Management Systems, Publishing Systems, Real Time, Embedded Microprocessor Systems, Scientific Programming, Numeric Methods.
**EDUCATION: ** Kharkov University, Ph.D. in Computer Science.
Kharkov University, MS in Radio Electronic Engineering, Degree with Exceptional Distinctions.
Berdichev College, BS in Electro Engineering, Degree with Highest Honors.
**CERTIFICATIONS: **
.NET Enterprise Application Development Certified Professional.
**EXPERIENCE:**
**07/01 – Pres Pharmaceutical Company, NJ**.
**Lead System Analyst/Programmer**
*Architectural design, data modeling and implementation* of Client Server and WEB based project management, WEB content management automation, and data transfer applications, as well as complex Crystal Reports with charts, graphs, and based on stored procedures, queries and TTX reports with subreports using Crystal Reports 8.5, ERWIN 4.1, Visio 2002, VB 6.0, VB.NET, ASP, ASP.NET, ADO, [login to view URL], VBscript, Jscript, JavaScript, HTML, DHTML, XML, XSLT; MS SQL Server 2000 tables, SQL, and stored procedures; Oracle 8.0 tables and procedures; MS Access 2000 tables, queries, SQL, forms, reports, macros, classes, and VBA; MS Project 2000 object model and VBA; MS Project 2000 Central; MS Word 2000 object model and VBA, MS Excel 2000 object model and VBA, MS Office VBA and Add-Ins; COM/DCOM, ActiveX controls; Microsoft Terminal Server, Citrix Metaframe Server; CA WEB, TrackWise, and Business Engine Network’s (BEN) business management software.
Current SQL Server database consists out of 475 tables. Data transfer applications require design of complex dynamic and static SQL statements that extract data from databases of several different systems, transform those data according to specifications, and load transformed data into one reporting database. Report wizard application allows users to select set of parameters, and generates dynamic Crystal Reports SQL statements based on user input in order to produce dynamic Crystal Reports. Requirements documents that describe data processing logic for some of complex Crystal Reports are over 30 pages long. Those complex Crystal Reports require design and optimization of stored procedures that have their code up to 100 pages long.
*Enhancements* to the warehouse automation system using MS Visual C++, VAX C, CONNX 8.6, Reflections and FTP on VAX/OpenVMS.
**01/01 – 07/01 Princeton Information Systems**, New York, NY.
**Senior Programmer/Analyst.**
* Design and implementation*of Sybase 12 SQL Server stored procedures, VB 6.0 forms, modules, classes and ActiveX controls and DLLs to create COM Add-Ins and DLLs for MS Excel, MS Word and MS PowerPoint, and design of macros and VBA code for regular applications and Add-ins for MS Excel, MS Word and MS PowerPoint. Those Applications, Add-Ins and DLLs are deployed to extend functionality of MS Excel, MS Word and MS PowerPoint for enterprise wide, internationalized, business critical Microsoft Office 2000 based PowerPoint financial publishing application as a supplemental part of DOCUMENTUM System for **Investment Banking Department** of financial company **Morgan Stanley**, using Excel, Word, PowerPoint, MS Access, Sybase 12, ADO, True DB Grid, MSXML3.0 parser, Transact-SQL, XML . This application allows users to rapidly create very impressive PowerPoint presentations, slides and exhibitions using a gallery of MS Excel Tables and Chart Templates, MS Word Documents and Table Templates, Sybase database data. System dynamically changes design of documents and charts based on user inputs.
**06/93 – 06/01 Software Development in USA**.
**Senior Programmer/Analyst.**
* *
## Area of Expertise
***HARDWARE:*** IBM PC MS-DOS, Windows NT, UNIX; NOVELL, BANYAN VINES, LAN; WAN;
DEC PDP/11; VAX/VMS; IBM/360/370 OS/MVS, JCL;
microprocessors INTEL 8085, 80x86, Z80;
***LANGUAGES:*** VISUAL BASIC 3.0/4.0/5.0/6.0/.NET; ASP, ASP.NET, VBScript, Jscript, JavaScript, VBA, VISUAL BASIC for Applications; MS ACCESS Basic; MS EXCEL Basic; MS WORD Basic; MS Power Point Basic, MS Project Basic, MS Visual C/C++; MFC, Borland C/C++; Java; HTML,DHTML, XML, XSL;
PERL, PERL CGI; Transact-SQL, PL/SQL; FORTRAN, SML, ALGOL, PL/1, PASCAL; BASIC;
Assemblers MASM, TASM, MACRO-11, BAL IBM/370;
***SOFTWARE:**** * MS Windows 3.1/3.11/NT/95/98/ME/2000/XP; UNIX; API, DDE, OLE, OLE Automation, COM+,
COM/DCOM, COM Add-Ins***,*** Active-X Controls, SDK, RDBMS, [login to view URL], Sybase 12 SQL Server, MS SQL Server 6.5/7.0/2000, ORACLE 7.0/8.0, DB2, Btrieve, GUPTA SQL, XDB, dBase, Visual InterDev 6.0, MTS, Visual Source Safe 6.0, PVCS, SP Debugger, Q+E Library, ODBC, MS Access, MS Excel, MS Word, MS Outlook, MS Power Point, MS Project 97/2000, MS Project Central, Crystal Reports 3.0-8.5, Seagate Crystal Info, Installshield, Autosys, VISIO, Rabbit Gates 3270 Emulator, Windows Communication Library, PC Client Communication Library, SQL Sombrero, ERWIN, DBArtisan, Rapid SQL, XPEditer/SQL, 3rd party VBX and OCX controls, Great Plains, MAS-90, FTP, CA WEB Project Management System, TrackWise Web TeamAccess Project Management System, Business Engine Network Project Management System, Microsoft Terminal Server, Citrix Metaframe .
***APPS:*** Project Management Systems, LIMS, Brokerage and Financial Systems, Banking, Accounting Systems, Insurance, Medical, Client Server, Relational Database Management Systems, Publishing Systems, Real Time, Embedded Microprocessor Systems, Scientific Programming, Numeric Methods.