MARK S. GANCHROW
123
Varinna Drive
(585)
520-0269 (cell)
Additional
information available at http://www.linkedin.com/in/markganchrow
Technical Skills
5/04
- Clover Capital Management, Inc.
Senior Application Developer
Design, develop, specify, implement,
and support new and legacy financial database applications, using SQL Server (2000
and 2005) and related tools. Automate processes that had previously been manual
and labor-intensive to improve efficiency and reduce errors. Serve as primary
helpdesk resource for internal customers for all PC-related issues, including
hardware (desktops, laptops, and network), software, and various software
packages. Train users in proper PC, Web, and Email usage. Ongoing training in
new technologies and techniques. Liaise with vendors and support people.
1/96
10/04 NetWorks, Inc./Structured
Technologies, Inc.
Senior Project Manager
Director,
Applications Support and Development
Consult
with client management and end-users to design, develop and support client
systems, using Microsoft FoxPro and Visual FoxPro (VFP) power tools and programming language, including
using VFP as front-end for SQL Server back-end, and object-oriented programming
(OOP). Write and publish user and system documentation using Microsoft Word for Windows. Project Management for my own
and other developers projects at various levels. Software testing and
debugging, and Technical and End-User Documentation. Create application help
files using Doc-to-Help.
4/91
Accounting Management
Systems/Dataware Technology Group, Ltd.
President/Systems
Developer/Programmer
Consult
with client management and end-users to design, develop, document, implement,
and support client systems, using various tools and programming languages.
Write and publish user and system documentation.
Train/tutor FoxPro programmers at various levels. Subcontract from other
developers to complete, support, debug, and streamline existing systems.
1/92
2/93 Softcare Computer Services, Inc.
- Senior Programmer/Developer
Design,
develop and support vertical FoxBASE+, FoxPro and Magic PC applications. Convert
client applications from various languages to FoxPro 2.0.
Customize SBT Accounting modules per client
specification. Develop user documentation using Hijaak
screen capture utility, WordPerfect and Word for Windows word processors. Write
and edit client newsletter.
3/89 -
4/91 Standard Systems Solutions, Inc. - Consultant/Programmer
Supervise
Programming Department. Install Novell Netware
Hardware, Software, and Applications. Support clients who had no in-house
Network Administrator or Information Services Department. Custom FoxPro and FoxBASE+ System Design,
Specification, Development, Coding and Documentation.
Applications
developed include: Commercial:
Inventory/Transaction Tracking, Sales Orders, Purchase Orders,
Invoicing/Statements, Rental Systems. State Agencies:
Purchase Orders, Inventory Tracking, Accounts Payable/Vouchers, General Ledger.
1/87 ‑
12/89 Interactive Data Corp. (IDC) ‑
Project Consultant
Specialize in fixed‑income
and equity issues, providing pre‑ and post‑sales support and
account management to clients. Develop, present, customize, install, maintain
and document financial software, and train clients in its use.
Applications
developed include: Convertible Securities Analysis (in IDC Database Language on IBM/370), Daily Stock Price Tracking by
Industry (in FORTRAN & IDC database), and Swap
System ‑ tracking trades and hedges, and maintaining portfolio (in DBase III+ on IBM PC/AT).
|
Software: |
Since: |
|
|
MS SQL Server (2000, 2005) |
1999 |
Extensive |
|
Microsoft Access |
1997 |
Regular Use |
Visual FoxPro
(versions 3,5,6,7,8,9)
|
1995
|
Extensive |
|
FoxPro (DOS, Windows, Mac) |
1990 |
Extensive |
|
FoxBASE+ |
1989 |
Extensive |
|
Visual Basic/VBA/VB.NET |
2002 |
Regular Use |
|
MS-Windows 95, 98, NT, 2000, XP (installation &
configuration) |
1990 |
Regular Use |
|
MS Word |
1992 |
Regular Use |
|
MS Excel |
1995 |
Regular Use |
|
Doc-to-Help |
2000 |
Light Use |
|
Magic-PC (DBMS) |
1992 |
Light Use |
|
Recital for VAX (VMS) |
1991 |
Light Use |
|
QUERY Database (DBMS) |
1986 |
Education |
|
|
|
|
|
Other Database |
1987 |
Regular Use |
|
Microsoft Internet Explorer, Outlook, Outlook
Express |
1996 |
Regular Use |
|
WordPerfect (5.1) |
1989 |
Regular Use |
|
Novell Netware (Support) |
1988 |
Regular Use |
|
(Installation) |
1988 |
Light Use |
|
QEMM/Desqview 386 |
1989 |
Extensive |
|
Brief/dBrief Program Editor |
1989 |
Extensive |
|
PC Tools (DOS, Windows) |
1989 |
Regular Use |
|
Norton PCAnywhere |
1989 |
Regular Use |
|
MS-DOS (3.3, 5.0, 6) |
1987 |
Extensive |
|
DR-DOS (6.0) |
1991 |
Regular Use |
|
COBOL |
1986 |
Moderate Use |
|
Fortran |
1986 |
Light Use |
|
BASIC |
1986 |
Light Use |
|
C |
1989 |
Education |
|
Hardware: |
|
|
|
PCs (DOS/Microsoft Windows - XP, Vista, 2000 Server) |
1986 |
Extensive |
|
IBM 370 (VM) |
1986 |
Regular Use |
|
HP3000 |
1985 |
Education |
|
VAX (VMS) |
1991 |
Light Use |
|
IBM S/38 (COBOL & CL) |
1987 |
Light Use |
MBA,
UNIVERSITY OF ROCHESTER (Simon School/Graduate School of Management)
Concentration in Finance,
Accounting, and Information Systems.
Grade Point Average: 3.5
Top 25% of Class
BBA,
BARUCH COLLEGE (CUNY) cum laude
Major in Finance and Investments
Grade Point Average: 3.5
PROFESSIONAL
1998
Microsoft Certified
Professional, Visual FoxPro
1996 Wrote user-training manual for Quicken V6
1995 Co-wrote Microsoft Visual FoxPro Step by
Step Microsoft Press
(book won
award from Society for Technical Communication)
10/92
- 8/95 Greater
1994/95
Beta Tester for Microsoft Visual FoxPro 3.0 for Windows
Since
1993 Member,
Microsoft Developer Network
6/93 Beta Tester for Central Point Backup for Windows 2.0,
PC
Tools Gold (V9.0),
PC
Tools/Windows
1/93 Article
accepted for publication by FoxPro Advisor Magazine (May 1993
Issue)
10/92 Beta Tester for Microsoft FoxPro 2.5 (DOS and Windows)
Ongoing
education and training and seminars in FoxPro 2.5, 2.6, Visual FoxPro, MS SQL
Server
PERSONAL
Congregation
Beth Hakneses Hachodosh
President 10/2002
12/2004
Web
Site developer/Webmaster 2003
- 2006
Financial
Secretary 6/2000
9/2002
Vice
President 9/1999
6/2000
Greater
Rochester Fox User Group founding President
Software
Executives Group
Graduate
Business Club (
Investment
Club (
Finance‑Economics
Society (Baruch) ‑ Investment Advisory Committee
Financial
Management Association (
1996 Microsoft Visual FoxPro Step by Step won award for Technical Writing
Dean's
List ‑
CUNY
Merit Scholarship
1985
1979 National Merit Scholarship Commendation
1978 NYS Stock Market Competition ‑