Technical Proficiency

Programming

SQL/TSQL C#, Visual Basic, VBA, ADO, ADO.NET, MS Access, Visual FoxPro 9, FoxPro 2.6, HTML, Assembler, COBOL, VBScript, JavaScript

Software

Visual Studio, Visual Interdev, Rational Requisite Pro, Visio, MS Project, Dreamweaver, Homesite, Fireworks, Crystal Reports, Microsoft Office Suite

Professional Summary

07/08 - Present
Various Clients
Consultant

Currently developing and modifying MS Access applications for 2 clients:

• Program to manage the annual fundraising effort for the 92nd Street Y nursery school. This is an Access project using a SQL back end.
• Two applications that track aspects of driver activity for Empire Merchants, the largest liquor distribution company in the Northeast.

These are Access applications using a mix of native and SQL back end.

08/07 - 07/08
InSource Consulting, Inc.
Consultant

Developing reports from the Charles River SQL database using Actuate reporting software.

• Conducting analysis and custom queries in TSQL
• Creating custom interfaces in Excel and Access (VBA) for business analysis

06/07 - 07/07
BlackRock, Inc.
Consultant

Developed a small document management application in MS Access (VBA).

04/06 - 04/07
LECG, Inc.
Consulting

In support of forensic data mining, reverse engineered a SQL database.

• Created multi-section reports in Crystal 11
• Wrote a VBA front end to generate reports based on selectable criteria
• Writing a client facing application in C# that organizes and presents reports for searching, tagging and filtering.

02/04 - 12/05
SEIU Local 1199
Consulting

Architect/Lead Programmer of a system to support administration of unemployment benefits and to operate a placement service that serves 150 member institutions and a few thousand job applicants. Development platform is Visual Foxpro 9 running against MSSQL 2000.

• Designed the application object framework and database schema
• Developed TSQL and DTS to migrate data and to accommodate transitional implementation of business logic.
• Programmed framework classes and business objects and forms.
• Launched a company-wide campaign to improve knowledge management, with a focus on improved communication between business management and MIS.
• Implemented project management processes and management infrastructure

10/03 - 02/04
Conscious Decision, Inc.
Software Consultant

Short term projects

• Program to manage a fundraising operation in MS Access 2002
• Order management invoice system in MS Access 2000
• Migrate a Clipper application to Visual Foxpro 8 with SQL 2000 backend for a union benefit fund.

1999 - 2003
Holsted Marketing, Inc.
Information Systems Consultant

Developed a company-wide, information management system for Holsted Marketing, Inc., a Direct Marketing Syndicator. System provides the operational facilities for managing this $200M/year business. Project entails management of $30M per year inventory including integration of information flow both within the company and with external entities, e.g. order processors, vendors, service providers. Responsible for determining technologies to be applied, hiring and managing software development team, Database Design, C++ and TSQL programming, project management, liaison with business managers.

• Designed and developed detailed specifications for enterprise sales forecasting/inventory management system.
  
• Designed database using Embarcadero erStudio. Wrote enhancements to erStudio to enable custom trigger generation and to automatically update stored procedures during database generation process. Wrote all triggers and stored procedures for the database in Transact SQL.
• Developed a full suite of DTS scripts to migrate data from legacy FoxPro DBFs. Wrote a shell program in VB to manage and automate execution of DTS packages
  
• Wrote programs in Visual FoxPro to massage legacy data into SQL database.
  
• Coordinated activities of 3-4 person team in development of object-oriented software application using Visual C++ 6.0

1995 - 1999
Marketing, Inc.
Director of MIS (de facto)

Reporting to CFO and President of Holsted Marketing, Inc., held overall responsibility for IS infrastructure. Devised strategies for accomplishing business objectives. Advised managers on ability to support business administration with technology. Guided training initiatives.

• Designed and implemented software in FoxPro to manage company-wide sales and inventory, enabling company to increase sales volume 4000%, from $5M to $200M with minimal increase in staff requirements.
  
• Developed complex business modeling and forecasting technology considered the most sophisticated in the Direct Marketing industry.
  
• Managed full life-cycle project including specifications, team programming, testing and installation for mission critical database applications.Designed and implemented Just-In-Time inventory management system to reverse practices that had resulted in over $3 million of dead inventory.
  
• Managed company growth and IT evolution through times of rapid change.
  
  
• Reduced costly upgrade cycles by anticipating the conjunction of business needs and technological evolution.
• Implemented and managed a campaign to raise the technological sophistication of staff of 30 to increase productivity and reduce reliance on expensive MIS resources.

1986 - 1995 Conscious Decision, Inc.
Consultant

Various Projects

Bertelsmann Music Group

Custom program in FoxPro to manage editing of catalog copy. Featured a custom editor written in assembler to facilitate their proprietary page mark-up, which included special characters and color coding.

American Express

Reporting tool in Paradox to enable sales force to evaluate savings they could provide to prospective customers.
Tool in Excel for converting international currencies.

American Export Line

Conversion of enterprise-wide business management system from FoxPro 2.5 DOS to FoxPro for Windows.

SOFT, Inc.

COBOL programming

Utitily Programs and Metering (for Comsult Consulting)

Enhanced and maintained complex program to track usage and calculate billing for utility metering company.

Vision Care Consortium (for DPM Consulting)

Complex profit distribution system in FoxPro and Excel using data ported from proprietary mini-computer based application for a doctor's consortium.

Prior Career History

American President Lines Manager, Finance Department

Staff and Line Officer, US Army

Education

Certification: Computer Programming, Baruch College/City University of NY - First in Class

City College of New York, Liberal Arts

Memberships

Mensa, Toastmasters

References

Marvin Stiefel
1199 Employment Training & Job Security Program
(917) 623-1475
marvinstie@aol.com

Roy Rathbun
Holsted Marketing, Inc.
(212) 686-8537 x. 166
rrathbun@holstedmarketing.com

David Rosenthal
Health Care Compliance Strategies, Inc.
(516) 933-2000 x109
dmr@hccsonline.com