Sr SAS Developer & Analyst

**** **** *** ***., ***. **A Brooklyn, NY *****

Tel: 718-***-****

Email: ******@*****.***

LEV TARNOPOLSKIY

_____________________________________

Summary of Qualifications:

• Senior VBA developer with 15+ years of solid application experience using MS Access, MS Excel.

• Strong design and development applications, database, reports, with business oriented analysis.

• Over 10 years exp working as a DBA for Bear Stearns helping different departments (Clearing, Risk, Fix…)

• Strong db knowledge of MS SQL with design and optimization experience Stored Procedures, triggers

• ODBC, API, DAO, RDO, ADO

• Connection and Conversion (using ODBC) between different types of data from (to): PC/Mainframe, DB2, SYBASE, SQL, FTP.

• Software: VB, VBA 2.0+, MS Access 2.0-7.0, MS Excel 2.0-7.0, SQL, Crystal Reports, PLC Assembly Oriented Command Language, C

• OS: DOS, Windows 3.x, Windows 9x, Windows NT, Windows XP,

Experience:

1998 – 5/2009 SPHERION / BEAR STEARNS (JPMorgan), New York, NY

Consultant

Basic Responsibilities:

• Full cycle applications VBA MS Access, Excel (GUI, Database, Reports, Updates),

• Conversion and Connection (using ODBC) between different types of data from (to): PC/Mainframe, DB2, SYBASE, SQL, FTP.

Using all of the above, I created application which helps personnel:

• Track clients (in all aspects)

• Track and dispatch any type of issues with different departments, which may arise, to make decisions about or on behalf of the clients in order to conserve time.

• Implemented/Managed projects to provide services for corporate personnel. All projects are involved with different types of security levels, independent updates, back up systems, to automatically generated reports.

Conception of development independently built modules and loaded those into the system which helps update (GUI, Reports) without any interruption to users.

Management was able to track every aspect of the business process.

1997 to 1998 CEDAR GRAPHICS, Inc., Ronkonkoma, NY

Programmer / Analyst

• Conception and development of Replication Connection System between remotely located databases, custom built Client/Server Application for the Windows NT - LAN environment with integrated synchronization locations providing users with time management, by bypassing replication, and logistic, through fast access solutions and automatic updating and transactions posting control into the databases

• Produced the GUI and object representation protocols including dynamic form creation and loading, using the VB 5.0 controls, third party Custom Controls, and Windows API functions responsible for all aspects of connectivity of internal company’s network following programmable security clearance pattern

• Designed and wrote several modules used by all other system components to create, delete and update various types of system objects, In-Proc/Out-Proc OLE Servers (ActiveX DLL/EXE), etc.

• Conceived Customer Purchase Pre Ordering Estimating System allowing customers to estimate cost of the order in advance by using company’s proprietary information without disclosing it

• Developed communication protocols allowing the customer’s connection to databases through Dial-up-Networking

1995 to 1997 UFA TECHNOLOGIES, Inc., New York, NY.

Programmer / Analyst

• Involved in the conception and development of the Distribution Management System a custom built Client/Server Application in the Windows NT LAN-based environment devised for a major retailer of General Merchandise using the MS Visual Basic 4.0 as front end and the power of MS Access 7.0 engine and the SQL Server 6.0 as back end. Provided tools to track the information on inventory purchase and distribution, internal costs, purchases, sales and other related expenses and consisting of the Interactive Visual Presentation managing all the aspects of GUI and Object Representations, the Object Administrator and Reports modules.

• Conceived the user interface for various object representations including dynamic form creation and loading for the Interactive Visual Presentations module using VB 4 Controls and the Windows API functions for graphic effects and incorporated 32 bit OCX Controls, such as TreeView, ListView, ImageList etc., third party custom controls and Windows API functions in the Application's design.

• Produced some of The Object Administrator's components enabling to create, manage and delete several types of application's objects and collections of objects and designed several report templates dynamically downloadable at user's request stored in the SQL Server database and catalogued among the Report module's lists of all available reports.

1992 to 1994 ELECTRONIC DATA MANAGEMENT, Inc., Brooklyn, NY

Programmer/Analyst

• Developed and maintained a Multifunctional Informational System for the Windows 3.11 LAN-based, MS Access 2.0 environment designed for in-house control of the manufacturing process featuring the tools necessary to book Sales Orders, issue Purchase and Work Orders, Track Inventories, generate Invoices and perform various Accounting operations. The System included functional modules like: Sales, Purchasing, Inventory, Configuration Manager and Accounting.

• The Project responsibilities included data's logic modeling, data base normalization, design of menus and dynamically linked multifunctional forms, debugging, maintenance and updating.

1986 to 1991 CENTRAL RUSSIAN POSTAL SERVICE, Moscow, Russia

Software Engineer/ Project Management

• Responsible for the hardware implementation and maintenance of computerized sorting process in the Moscow's central mail sorting point.

Education:

COOPER UNION SCHOOL OF ENGINEERING, New York, NY

1993 Computer Networking

COLLEGE OF AVIATION, Moscow, Russia

1987 Engineering- Programmer

UNIVERSITY OF WATERWAY NAVIGATION, Moscow, Russia

1983 Navigation/Engineering and Technology

Contact this candidate