David Estrin
2946 Quentin Rd								Tel.   Home:       [Send email to request phone number] 44.3016                           
            
Brooklyn, NY 11229								Tel.   Business:   [Send email to request phone number] 34.0772
Email: david@asa.edu                                                            
                                                                                
    

Summary: Background features 10 years of client/server development and a total
of fifteen years of application development in a production-oriented environment
both in individual and team projects. Experience includes interacting with
clients for requirements gathering, database schema design and implementation,
applications design and development, systems analysis, client-site installation,
technical and work flow documentation and systems support.  

Skills
       Programming Languages / Technologies: Visual Basic 3.0/4.0/5.0/6.0, VBA,
VB.Net, Crystal Reports 5.0/7.0/8.0/9.0/X/ XI, XML, COM/DCOM, ActiveX, 
ASP/ASP.Net, WebBase, JavaScript,  PL/SQL, Java, C, C#,CSS
       Development Environments: MS Visual Studio, MS FrontPage, Macromedia
Dreamweaver, Homesite, SharePoint Designer 
       Software: MS SQL Server 6.0/6.5/7.0/2000/2005, SYBASE SQL Server, ORACLE
8.0, MS IIS 4.0/5.0/6.0, Citrix Presentation Server 4.0, Oracle Application
Server 4.0, Livewire, MS Access, MS Word, MS Excel, MS Project, MS Visio 
       Operating Systems:Windows 95/98/XP, Windows NT/2000, VAX/VMS, UNIX

ASA College of Advanced Technology                                              
                                   10/10/2002 - present
Senior Application Developer


      Designed, implemented, and supported client/server and web-based
applications for exposing back-end financial tracking system and enrolment
information to students, faculty, and staff. Maintained and enhanced the school’s
website. Applications was done using ASP and  ASP.Net technology. 

•	Worked with various departments to gather requirements for the “Web For
Students” application
•	Implemented the systems for exposing financial records on the web by
interfacing with a proprietary back-office application
•	Created an enrolment and attendance record keeping system that was available
both on the internet and on the desktops for students and faculty
•	Utilized VB Components to manage user sessions and perform data caching to
reduce SQL server load
•	Create Objects using VB.Net on a server site
•	Designed the database schema and administered the MS SQL database server
•	Created referential integrity rules for the database
•	Create Stored procedures, triggers, views
•	Setup batch processes for backup and recovery
•	Created of ad-hoc reports for operations and management using Crystal Reports
software (X, XI)
•	Performed testing, and complete technical documentation (project work flow,
schedule for backup database MS SQL 200/2005), project plan.) utilize MS Visio,
MS Project and MS Word.


Chase Manhattan Bank                                                            
                                               03/2000 – 10/2002
Technical Officer

      Migrated  the Interoffice On-Line Billing (IOL) from Client/Server
Application written in Visual Basic and
Essbase on the back end to a WEB-based application utilizing MSSQL 7.0 and IIS 4
as the deployment platform. The primary function of the IOL system was to
broadcast the fully allocated charges from the various service providers within
Chase Manhattan Bank to the functional areas as represented by the PRF
Organization hierarchy. The system has over 2000 users.

•	Analyzed and redesigned the IOL system. 
•	Created the Referential Integrity Rules for the Relation Database based on
functional requirements.
•	Developed the back-end functionality in Microsoft SQL Server with the use of
stored procedures 
        and triggers.
•	Coded batch processes to move the data from the legacy system into the SQL
Server database.
•	Used MS Front Page and Home Site 4 to create the front end for the
application.
•	Utilized JavaScript for data validation in the client side.
Created ASP code to expose the server-side components to dynamically generate
HTML Pages
•	Create shared business rules objects using Microsoft Visual Basic 6.0 (Active
X Components)
•	Created VB Application to download data from mainframe to MS SQL Server. 
•	Created Active X Components using Visual Basic 6 for synchronizing MSSQL
Server and Essbase databases in real time.
•	Create Reporting tool utilize Crystal Report version 9.0
•	Complete Project documentation 
•	Complete User’s guide (for using application) 
•	Performed unit and system testing.


LFI Pyramid Consulting Company (Manhattan)                                      
                                  03/11/1999 – 02/2000
Client: Administration for Children’s Services (ACS), New York, New York
Senior Programmer / Analyst.

      Ported the Automated Case Reference System (ACRS) from a mainframe system
written in CICS and COBOL into a scalable, Web-based application utilizing MSSQL
Server 6.5 on the back end and Internet Information Server 4 as the middle-tier
deployment platform.  ACRS is a mission critical application that maintains and
provides searches for records of all neglect and abuse referrals to the agency
(ACS).  This project utilizes Java Script 1.2 and VB Script for the front end and
Oracle Database Server running on NT for the back end. This system has over 3000
clients.  

•	Performed database design and creation of referential integrity for the
database.
•	Created and tested tables, indexes, stored procedures, and triggers.
•	Implemented a desktop VB application to prepare files for downloading on the
back end. 
•	Designed HTML Pages currently running on the WEB Server.
•	Developed and tested code in Java Script, VB Script and ASP for both the
Client Side and the Server Side which allows data to be retrieved between the
client side and Oracle Database Server. 
•	Created server-side components in VB.
•	Developed and tested Java Script code for client side validation in the ACRS
intranet application.
•	Tested code related to the user services, business services, and data services
for the various Java servlet components in the ACRS intranet application.

PaineWebber, Weehawken                                                          
                                                10/1996-03/11/1999
Prime Brokerage, Programmer / Analyst
•	As a member of a team of developers, implemented, and maintained the Brokers
Client Contact Portfolio Management System. System is based on the SYBASE SQL
Server database located on UNIX server and utilizing VB front-end interface.
•	Created Statistic Information System for Brokers Client Contact Portfolio
Management System. 
Initially designed in VB4, the system was converted to VB5 for the front-end and
utilized SYBASE SQL as the back-end.  
•	Created Export Data Utility for the existing Brokers Client Contact Portfolio
Management System.
This utility gives users the capability to make easy backups.  Users were able
to zip data exported from the database to floppy disks and restore the data from
disks back to the database.  This utility allows users to make 
       BCP backups of all data from selected tables and selected columns from
certain tables.  This utility was created 
       in VB5 and has a GUI front end.  The back end was written on both SYBASE
SQL Server System XI running
       on Sun Solaris and MS SQL Server 6.5 running on NT.      
•	Created Web application for the existing Brokers Contact Portfolio Management
System which is currently running on Microsoft Internet Information Server 4.0. 
This application utilizes JavaScript and ASP for the front end  and  SYBASE SQL
Server XI running on Sun Solaris for the back end.  This application takes client
data, populates tables with this data, and generates custom reports that run on
WEB pages.  
       Responsibilities included:
•	Created a reporting facility that utilized Crystal Reports 5.0   
•	Developed VB application which generated MS Word documents utilizing OLE
Automation techniques for communication between VB modules and Word documents.
•	Developed VB modules for an authorization system.  Implemented the security
part of the system. 
•	Converted GUI and VB code from VB4 to VB5; Conversion of back end from SYBASE
System X to SYBASE System XI 
•	Created ActiveX controls for in and out of processing (ActiveX.exe and
ActiveX.dll files). 
•	Performed testing and wrote technical documentation ( for implementation
team)

Datalife,  Verona  		             03/1996 –10/1996 
Programmer / Analyst
Participated in a team of developers designing and implementing the company’s
Web site.  The Web server was populating HTML pages dynamically with data
received from SQL Server through WebBase.
•	Created pages with frames that allowed visitors of the Web site to enter
dynamic requests to the server, save the visitor’s profile and restrict
unauthorized access to the site.
•	Created numerous stored procedures to be run by WebBase to retrieve and update
data on SQL Server from the Web Server. 
•	Utilized Java Script to enhance graphical representation and functionality of
the Web site.
•	Created, modified, tested and implemented forms and modules in VB
applications
•	Developed and coded all SQL Server stored procedures for various VB
applications
•	Created and tested reports.
•	Wrote functional documentation.

Education
Donetsk University.  
Master Of Science - Mathematics
Master Of Science - Computer Science.