Sql Server Quality Assurance

LEAH M.

BERKOWITZ

Southfield, MI

(***)

***-**** ****

(248)

***-**** ******

abqfh6@r.postjobfree.com

EXPERIENCE SUMMARY

Leah is

Systems Support Specialist with 21 years of experience in Information

Technology, beginning a in mainframe environment programming, adding experience in client/server Windows

NT/2000/2003 network administration and web design, migrating and

integrating multiple platforms. For the past 8 years, has created web

applications on large corporate Intranet and the public Internet, using HTML,

DHTML, XML, SQL Server, Oracle, Active Server Pages,

IIS, VBScript, Visual Basic, Javascript, Dreamweaver,

Photoshop, Acrobat PDF and MS Visual Studio, and has programmed web

pages in multiple languages, including German, Russian and Hebrew

(right-to-left). Her specialty is interactive database programming in Oracle,

Access or SQL Server and back-end integration with XML.

She possesses excellent technical knowledge and language communication skills. EDUCATION

Lawrence

Technological University

Southfield,

MI

Bachelor of Science, Mathematics/Computer

Science, 1986

SOFTWARE

and PROGRAMMING

PROGRAMMING

VBScript,

VBA

Active Server Pages

Visual Basic

Javascript

Java applets & servlets

XML, HTML, DHTML

CSS

Multilingual

web programming

browser

compatibility

MQ

Series

Oracle

PL/SQL

Fortran

PL/1

PLC Ladder Logic

Plant floor data acquisition SOFTWARESharepoint Services

MS

Office 97-2007

MS FrontPage 97-2003/Expressions

MS

Access 97-2007

MS Infopath Forms

MS Visual Studio

MS ASP.Net

MS SQL Server

Oracle

IIS

4.0, 5.0, 6.0

NFS

Maestro

Adobe

Web Premium CS2,CS3,CS4,CS5:

Photoshop

Dreamweaver

Illustrator

Ulead Photoimpact

OmniPagePro 15 OCR

APF Formatter

Browser HARDWARE

IBM PC/Compatibles

Windows NT/2000/2003 server PDC and

BDC setup

Ethernet cards, Terminal Emulation

cards, Graphics cards, SCSI cards,

Modem cards, USB,

Memory upgrades

Hard-drive replacement

CDRW/DVD installation

scanners

PCMCIA card

RSA SecureID

Hubs, Routers

Wireless networks

Disaster Recovery

Backup Devices

PLC S

OPERATING SYSTEMS

Windows

NT/2000/XP/2003 Server

WINDOWS

95/98/Me/2000/XP/Vista client

VAX/VMS

UNIX (HP-UX and SCO-UX)

PROFESSIONAL EXPERIENCE

11/2010

current, Ford Motor Company, Business Assistance Center.Web

Developer. Create, maintain and improve web-based and PDF reporting

for call centers in Dearborn and Melbourne, Florida, calculating customer

satisfaction statistics from phone and web surveys, gathering data from Oracle,

Informix, Qfiniti and SQL Server

databases, and from IVR phone switch. Maintained Sharepoint web portals for internal Ford BAC members and

Ford dealerships on http://www.fmcdealer.com.

2/1997 current.Jewish-American

History Foundation

Web

Developer

for 501(c)(3) non-profit educational foundation, http://www.jewish-history.com/,

featuring a Civil War veterans search engine, http://www.jewish-history.com/SearchCWData.asp

which allows the Internet user to query an MS Access database and view

on-screen reports, by selecting multiple criteria from dropdown lists. An SQL

Command combining all the user s selected query terms is sent to the server

to retrieve the records and display in a report format. Another feature is the Walnut Street

Electronic Library, which includes the full text of hard-to-find 19th-Century

Judaica, including The Occident And

American Jewish Advocate, a magazine published from 1843-1868.

Occident pages are scanned from 35mm microfilm using Microtek

i800 scanner and Omnipage Pro 15 OCR. An ASP

portal redirects web browsers to different domain names hosted on the same

IP. The website project was constructed according to SDLC, constructed using HTML,

Active Server Pages, javascript,

java applets, VBScript, Visual Interdev, Photoshop, Acrobat, Dreamweaver,

Fireworks and FrontPage. The site receives an average of 50,000

visitors a day, and has received awards from The History Channel, PBS,

Britannica Online, Civil War Interactive and Yahoo! Listed in the Top 100 of Civil

War on the Web: A Guide to the Very Best Sites published by Scholarly

Resources and the subject of an interview on Sirius XM radio program Studio

J. The site also generates revenue from affiliate partnerships with various

Judaica and Israel online vendors at http://www.jewish-history.com/emporium.

8/2006 2/28/2007. Ford Motor Company,

Service Engineering Operations. Web Programmer.Part of E-business

team providing 2nd tier customer support to dealerships and body

shops using the Professional Technician Society, http://www.motorcraftservice.com,

http://www.fordinstallersupport.com

and http://www.fordasset.com

websites. Updated pages with PDF documents as requested. Maintained CSS

style sheets for look and feel, and programmed VBscript

ASP pages for backend connections to SQL Server databases and CDO

email procedures. Created SQL stored procedures. Shared

SQL Server database information across platforms using XML.

5/2005 5/2008. http://FJC.ru Federation of Jewish

Communities of the CIS Writer/Editor/Translator.

Editor of English language content for Russian-based web

portal.

Rewrote raw Google translations of Russian news articles into

colloquial U.S. English for distribution on English-language portal and to U.S.,

European and Middle East news agencies.

1/2003 7/2003

Wayne County Treasurer s Department, 400 Monroe, Detroit, MI

(contract assignment)

Web and Database Programmer for Property Tax Assessment

application.

Used Active Server Pages to retrieve property tax

information for parcels in the County. Created and modified PL/SQL

stored procedures and SQL to update

tax information in Oracle database, generate reports from XML and

certificates and track tax status of personal and commercial property, for

interactive and batch procedures.

1/2002 3/2002.

6/2002-11/2002.

MSX International, Ford Motor Company, Dearborn, Michigan

(contract assignment)

Web

Programmer

for Ford Design Institute educational program. Used Cold

Fusion, HTML and javascript to

create popup menus and online quizzes with overlaying graphics. Used Adobe Photoshop and Macromedia Dreamweaver and Flash

to integrate graphical content. Created graphics and

interactive multimedia presentations using Adobe Illustrator, Adobe

Photoshop, and Macromedia Flash MX. Translated

graphical elements from English to German.

7/2000

2/2001. ELECTRONIC DATA SYSTEMS, Troy,

Michigan. (contract

assignment)

Web

Developer

for internal, web-based corporate tracking system, using Active Server

Pages, ActiveX Data Objects, SQL stored procedures, VBScript server script,

MS Business Objects and javascript client-side

script, communicating with a database on SQL Server. Enhanced and

modified existing java servlets and applets. Created Active

Server Pages to allow a user to view, update and

add records to the database. Analyzed database table

information with Entity relationship and Schema diagramming tools.

5/1998-6/2000. FORD MOTOR COMPANY, Dearborn, Michigan. (contract

assignment)

4/1999-6/12/2000. Web Developer, "Health Charts

for Quality", web-based database application on Ford Intranet, for vehicle

engineers to generate live HTML web tables or MS Excel

spreadsheets of model year vehicle assessment specifications and update Oracle

7.0 database using SQL and PL/SQL commands in VBScript.

Application developed in MS Visual Interdev, Visual Basic, Javascript,

Active Server Pages, MS Business Objects and MS Excel and VBA,

for a Netscape web browser interface. (Contracted through Comprehensive

Data Processing)

5/1998-4/1999. Systems

Administrator

for Global Ford Financial Network of VAX/VMS cluster and Windows

NT network. Responsible for maintaining integrity of international

financial transactions applications and maintaining open channels using MQ

Series with Ford financial offices in the United Kingdom. Prepared and

rehearsed disaster recovery procedures. Installed and configured SecureID

cards and trained users. Performed installation of new software, upgrade,

and Year 2000 preparation. (Contracted through TAC Automotive)

5/1995-5/1998

SMART Transportation Authority

Oakland Terminal

2021 Barrett

Troy, MI48084

Senior Systems Analyst; Systems administrator for VAX/VMS

cluster, Windows NT network and UNIX-based vehicle-locator GPS

system.

Maintained user security for multi-user system, configured local area

transport servers and ports, setup terminals, workstations

and print queues, maintain disk integrity, system administrator for bus

scheduling, timekeeping and inventory maintenance systems. Installation,

upgrade and setup of VAX/VMS operating systems, terminals, PC network

connections, remote access security. Webmaster and Developer

of Authority Intranet, created using MS FrontPage (97, 98), MS Visual

Studio, ActiveX controls, Javascript, maintained using IIS. Achieved Level 2 site builder certification in 1997.

4/1992-5/1995 Freelance PC consultant for small business

and home office computers. Installed and configured new systems;

connected printers, and modems; installed and configured CD-ROM drives;

installed software applications; customized application and Windows at the

customers' request; provided private training at customer's location in use of Windows,

WordPerfect, MS Excel, MS Word, MS Works, MS Office, PowerPoint. Answered customer requests for troubleshooting and instruction by

phone.

2/1989

4/1992 Electronic Data Systems

Assigned

to: GM Cadillac Engineering

Position:

SYSTEMS ENGINEER

Provided

extensive systems support, including engineering needs analysis, installation

and maintenance of hardware, software, and networking, for vehicle

engineering test labs and experimental assembly garage at Cadillac. This system

consisted of a DEC VAX 8600 server, networking with close to 100 PCs

and two standalone Macintosh workstations. In addition, several

peripherals, including modems, laser printers, plotters, device drivers, data

acquisition devices, mainframe emulators and

communications boards were installed through serial ports. Converted

All-in-One documents to WordPerfect.

9/1987

2/1989 BASF Wyandotte

Position:

PROGRAMMER ANALYST

Developed, from specifications through testing and

analysis, a Quality Assurance system for chemical testing,

specification, statistical analysis, control and trend charting. Utilized Fortran with FMS, FDL, RS/1 and various

graphics applications on a clustered VAX 8650 and 11/785, running

VAX/VMS.

3/1986-3/1987

Textron

Developed, from concept through implementation, several database modules, files

and tables, using FMS, FDL and Fortran on a DEC Microvax

II, running under VAX/VMS. The databases encompassed data collection

and acquisition, shop floor control, and interfaced with ALLEN BRADLEY

and SIEMENS PLC devices for AGV (Automated Guide Vehicle), tool

selection robot arms, manufacturing tool inventory, scheduling, and other

applications. TECHNICAL TRAINING

UML,

Object-Oriented Design, Rational Rose, April 2000

MICROSOFT VISUAL INTERDEV, April 1998 (Web Development Kit, Active Server)

UNIX Administration, August 1991

DEC VAX/VMS Systems Management, March 1990

Contact this candidate