Project Manager Sql Server

Jeffrey A. Schwimer

**** *. ******* **** **** #**2

Chicago, IL 60614

************@*****.***

770-***-**** (C)

CAREER OBJECTIVE: Senior-level systems developer position in client-

server development including project managerial

responsibilities.

EDUCATION: MBA, Information Systems and Science, Technology, and

Innovation, George Washington

University, May 1987 (3.8 GPA/4.0)

BSCS, University of Vermont, May 1982 (3.3 GPA/4.0)

SOFTWARE: Microsoft Visual Studio 2010, Microsoft Visual InterDev,

Microsoft Visual SourceSafe, Crystal Reports.NET, Microsoft.NET

Framework, SQL Server 2012, Oracle, Rational ClearCase,

Subversion, DIA

INTERNET: ASP, ASP.NET, VB.NET, C#.NET, VBScript, JavaScript, SOAP,

XML, Web Services, SSIS, ADO.NET

EXPERIENCE:

2/99 to Present Macys Systems and Technology

Sr. Systems Analyst/Project Manager/Development Lead

Full-life cycle development of Risk Management System,

consisting of Accident Reporting, Safety Management and Business

Continuity Life Safety Plan, including requirements gathering,

technical/functional specifications, storyboarding, coding

(front-end, business layer and back-end) and unit and system

testing. All systems written in ASP and .NET with SQL Server

and Oracle back ends. These applications have resulted in a

reduction of over 2400 man-hours of effort on a monthly basis

across the company. Worked with System Owners, Managers,

Directors and Vice Presidents developing concepts, design ideas,

and implementation of all three systems across all 800+

locations. Mentored other programmers learning ASP, .NET, Web

Services and SQL Server.

Developed and maintained Security Information System (SIS) to

track arrests and perform background checks for 7 department

store chains using ASP and SQL Server. Trained users and helped

manage project.

Managed, designed and developed Common Civil Recovery System

(CCR) to initiate and track restitutions made by individuals

based on feeds from SIS system using ASP, SQL Server and SSIS

packages. System automatically generates collection letters,

records payments made, and out sources delinquent payments to

third party for collection via FTP server. Application is

directly responsible for collecting $8-$10 million worth of

restitutions on a yearly basis.

Managed, designed and developed Fraud Loss Prevention Management

System (FLPM) to help track and prosecute internal fraud and

theft cases. Converted application from VB application to Web-

based, .NET application.

Developed Desktop Alert Notification tool to alert security, via

desktop pop-up display and audio sound when a store transaction

is outside the limits defined by the system. This provides

security personnel with a tool to quickly review the transaction

for potential fraudulent activity. Mentored other programmers

learning ASP, VB.NET and SQL Server.

Project Manager for Macy's BOPS (Buy Online-Pickup in Store)

development effort. Worked with System Owners, Project

Managers, and Directors across the corporation to develop and

implement a system that allows customers to make purchases

online and have them picked up in the nearest location.

Directed our specific team effort to ensure that real-time BOPS

transactions were filtered through our Fraud detection system

and processed without negatively impacting processing time in

our current system.

Project Manager for Macy's-May conversion effort. Worked with

System Owners, Supervisors, Managers, and Directors. Provided

team of 10 with direction, requirements, and scheduling to

ensure data and code merging of 200+ Mays locations with 200+

Macy's locations was a smooth and seamless transition.

7/97 to 2/99 FOSTER CONSULTING

Senior Systems Engineer/Project Lead

Provide technical support to corporate-wide sales force and customer base

for Year 2000 line of products. Accompany sales managers to potential

customers to provide technical support during demonstrations.

Provided project lead support on projects that required company

personnel on-site. Responsible for training, project planning,

manpower estimates, and project status reports to customers.

Headed development team that was responsible for upgrading and redesigning

in-house sales tool

CHECKMATE using VB 5.0. Headed entire project from JAD sessions through

development.

Application allows sales force to configure potential switching system for

customer, and generate quotes and purchase orders based on the

configuration options selected. Updates to pricing tables are performed

via an update disk that is sent to the field personnel, and imported via

the application.

11/94 to 6/97 CONSULTANT - DRACS CONSULTING GROUP

Clients:

MINDSTORM LLC 4/97 to 6/97

Project Lead

Headed development team that was responsible for designing and

developing kiosk application that allows users to access

Internet via Visual Basic 4.0 application.

Buttons and screen saver for kiosk are maintained at remote site

and are updated via e-mail.

Developed screen saver application that can be used with kiosk

application or as stand-alone application. The screen saver

parameters and images are maintained remotely and can be

configured from a remote site via e-mail.

Created web page and server-side database for online

registration.

INHOUSE PROJECT 3/97 to 6/97

Task Lead

Headed in-house development effort to create web-based job

search site.

Designed and developed interactive web pages using HTML,

VBScript.

Designed and created back-end database tables (SQL Server) on

IIS 3.0.

Scripted HTML/ASP files for publication on IIS 3.0.

COMPASS MANAGEMENT 12/96 to 2/97

Project Lead

Headed development team that designed, developed, and tested 5-

year budgeting system in Access. This system tracks Actual and

Forecast Expenses and Revenues and is used by 28 Financial

groups nationwide.

Developed customized reports on both group and regional levels.

Converted Access data to SQL Server.

Responsible for Intranet publication of data from SQL Server.

Scripted HTML/ASP files for publication on IIS 3.0.

Trained client personnel on maintenance and upgrading of system

for future changes.

MELITA INTERNATIONAL 5/96 to 11/96

Task Lead

Responsible for client site upgrading Windows 3.X application to

Windows NT.

Developed supervisor desktop applications to monitor agent

calling and traffic for a predictive dialing system.

Used Visual Basic 4.0 to write in-process and out-of-process OLE

Servers to give users seamless control over multiple running

applications that are controlled from a single source.

McDONNELL DOUGLAS 12/95 to 4/96

Task Lead

Headed team responsible for redesigning and coding inventory

parts procurement system for NASA's International Space Station

project.

Wrote functions to allow users to create and track parts lists,

Logistical Corrective Action Requests, and Proposed Maintenance

Concept Plans.

Designed and coded a tool to allow project accounting data to be

reviewed in multiple formats prior to being sent to NASA.

Tested and benchmarked project up-sizing plans to allow move

from Access to SQL Server.

JOHNSON CONTROLS 11/94 to 12/95

Project Lead

Involved in all aspects of client move to client-server

technologies, including Business Process Re-engineering, Joint

Application Development, Database/Data Warehouse Design, Project

Design, System/Application Programming, and Staffing for NASA's

45th Space Wing Division (Space Shuttle Program).

Developed Decision Support System in Power Builder to create ad-

hoc queries for multiple heterogeneous databases (Oracle, SQL

Server, DEC RDB).

Developed client-server budgeting system in Visual Basic which

supports department level budgeting with roll-ups to multiple

levels and both static and dynamic reporting functions.

Trained client personnel in Visual Basic and Power Builder.

Effort resulted in two highest performance ratings for client in

over five years.

11/92 to 11/94 AT&T - Consultant

Task Lead

Responsible for redesigning and testing upgrade to existing

Vendor Payment system.

Redesigned and tested conversion of Employee Voucher system from

DOS to Visual Basic.

Designed and developed new Billing Report system in Power

Builder for internal use to track unauthorized calls.

8/87 to 10/92 MARTIN MARIETTA CORPORATION

Sr. Programmer

Developed, tested, and implemented software for paperless

manufacturing environment.

Wrote software and system documentation and requirements

definitions.

Provided on-site system support.

8/84 to 6/87 TECHNOLOGY, MANAGEMENT, AND ANALYSIS CORPORATION

ADP Manager

Managed computer center, hired programmers, designed and

programmed Management Information Tracking Systems.

Redesigned and converted database software packages to meet

Naval contract requirements.

8/83 to 7/84 G.R. PITCHER, INC.

Senior Programmer

Designed and programmed Payroll and Inventory Control systems.

Provided on-site and system maintenance support.

8/82 to 7/83 CYBERNETIC DATA CORPORATION

Data Center Manager

Designed and programmed system software, supervised system

usage, and analyzed user problems.

Maintained program software for Citicorp's electrical power

tracking system database.

Contact this candidate