Post Job Free

Resume

Sign in

Sql Server Maintenance, Access, VB. VBA

Location:
New York, NY
Salary:
70,000
Posted:
October 22, 2014

Contact this candidate

Resume:

David Glassberg 212-***-****

*** ***** ****** ***, *** York, NY 10002 acggts@r.postjobfree.com

*Note: I was in an accident in January of 2009, so there is no work listed

for 2009 and longer. I was in no condition to work for a long time but am

fully better now and can work.

Education

BROOKLYN COLLEGE, Brooklyn, NY

B.S. Computer Science, received Magna Cum Laude 1990

BARUCH COLLEGE, New York, NY

MS SQL Server 2000 DBA Certificate, Introduction and Advanced HTML 2003, MS

Access Course and Training, .Net training.

Technical Skill and Years of Experience

Skill Years Skill Years

Visual Basic 18 Access (97, 2000, 2003,

2007) 15

C 15 Excel 15

C++ 10 VBA 15

SQL Server (2000, 2005) 10 HTML

10

Sybase 10 ASP 05

Professional Experience - Full timer to 2002, Consultant since 2002

LAURAND ASSOCIATES, Great Neck NY Part Time February

2008 - August 2008

Programmer/Analyst

Achievements: Access Database Access 2003 VBA DB used to store and

process data for parts supplier.

Responsibilities: Tables, data normalization, queries, forms, reports, all

code. Building of all SQL Statements. Creation and testing of all Macro

statements. Complete project lifecycle. Performed Unit testing,

integration testing and code review, closing the issues raised by Quality

testing Team

HNTB, New York, NY Consultant August

2007 - February 2008

Programmer/Analyst

Achievements: Access Database Access 2003 VBA DB used to compare data

for competing companies seeking NYS DOT contracts.

Responsibilities: Involved in Technical Analysis of the proposed System

including architecture design and technical specification. . Building of

all SQL Statements. Creation and testing of all Macro statements.

PB- URS, New York, NY Consultant

May 2007

Programmer/Analyst

Achievements: Access Database Access 2003 VBA DB used to track the

construction projects for the new WTC and Transit Hub construction.

Responsibilities: Implementing application in OOD and Design patterns.

Tables, data normalization, queries, forms, reports, all code. . Building

of all SQL Statements. Creation and testing of all Macro statements.

Complete project lifecycle.

SCHOOL LINK, New York, NY Consultant

April 2007

Programmer/Analyst

Achievements: School Link Database Access 2003 VBA DB used to track the

lunch systems used in NYC schools.

Responsibilities: Co-ordinate with the QA lead for development of test

plan, test cases, test code and actual testing, responsible for defects

allocation and ensuring that the defects are resolved.

SUBSTITUTE TEACHER, NYC schools, New York, NY

September 2006 to 2007

Substitute Teacher

Achievements: Substitute Teacher for Math, Science, English classes

CLIFFORD CHANCE US LLP, New York, NY

April 2006 to June 2006

Programmer/Analyst

Achievements: Initial Checks Database Access 2003 DB used to check

incoming data for consistency and correctness before loading to

Introspect.

Responsibilities: Tables, data normalization, queries, forms, reports, all

code. Complete project lifecycle.

KATTEN MUCHIN ROSENMAN LLP, New York, NY October 2004

to November 2005

Programmer/Analyst

Achievements: Firm Name Change Task Across all applications, intranet,

etc. Daily New Data Job SQL Server 2000 DB to DB transfer. Update of

Invoice Generator app. from Access 2000 to VB6, SQL Server

Responsibilities: SQL Server 2000 Database, triggers, jobs, etc. Firm

Intranet HTML, ASP. Daily updates. User Maintenance. Used Visual Source

Safe for source code maintenance.

FISH AND NEAVE, New York,NY June

2003 to September 2003

Litigation Support Developer Analyst

Achievements: TV Guide Access 2000/SQL Server 2000; Full project life-

cycle

Responsibilities: Litigation Support, Access DB Updates, SQL Server Tasks

ROYAL BANK OF CANADA, New York, NY

February 2003 to June 2003

Programmer/Analyst

Responsibilities: Access 97 DB development, maintenance, updates., Sybase

table linka

KATTEN MUCHIN ZAVIS ROSENMAN, New York, NY September

2002 to February 2003

Programmer/Analyst

Achievements: Sign In Sign Out Time management. SQL Server 2000, VB6,

KMZR Invoice Generator Access 2000, VBA

Responsibilities: SQL Server 2000 Database tasks, Access 2000 application

development, maintenance, updates

MORGAN STANLEY CO., New York, NY

June 1998 to June 2002

Programmer/Analyst

Achievements: CS - Optime Time management. Sybase 11, VB6. Conference

Room DB Global use. Web Accessible. Access 97.

Responsibilities: Access 97 DB application development, maintenance,

updates. Excel 97 application development, maintenance, updates

PHILLIP MORRIS CO., Rye, NY January

1998 to March 1998

Programmer/Analyst

Achievements: Sales Data Application VB5, Excel 97

Responsibilities: Access 97, Excel 97 application development,

maintenance, updates

BANKERS TRUST CO., New York, NY September 1995

to April 1997

Programmer/Analyst

Achievements: Best Link/BT World Financial data reporting. VB5, Excel 97.

NASI DB Access 97, Oracle DB table links

Responsibilities: Access 97, Excel 97 application development, maintenance,

updates

BMG MUSIC, New York, NY

October 1994 to September 1995

Programmer

Achievements: BMG Classics DB SQL Server, Excel 97. RCA Daily Sales DB

SQL Server, Excel 97

Responsibilities: Access 97, Excel 97 application development, maintenance,

updates

FEDERAL RESERVE BANK OF NEW YORK, New York, NY

July 1990 to October 1994

Programmer

Achievements: Fedline3 VB 3.0, Visual C++ 1.5. Fedline Incoming

Processor Application C. Electronic US Treasury Auction application.

Responsibilities: Access 97 DB application development, maintenance,

updates. Excel 97 application development, maintenance, updates



Contact this candidate