MARK S. GANCHROW

123 Varinna Drive

Rochester, NY 14618

(585) 520-0269 (cell)

Additional information available at http://www.linkedin.com/in/markganchrow

Summary of Qualifications

  • Experienced database/software analyst and application developer
  • Excellent problem-solving and debugging skills
  • Expertise in modifying existing systems and code
  • Customer and end-user support
  • Hardware and Network Support
  • Accounting and Financial systems
  • Extensive experience supporting and enhancing client/server applications

 

Technical Skills

  • Database software: Visual FoxPro (FoxBase+ through VFP 9), Microsoft SQL Server (2000, 2005; T/SQL, Stored Procedures, Functions), Microsoft Access/VBA
  • ODBC/OLE DB data access to MS SQL Server
  • Application automation: Excel, AutoHotkey scripting
  • Platforms: Windows XP, Vista, 2000 Server

Work Experience

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).


 

TECHNICAL SKILL INVENTORY

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

EDUCATION

MBA, UNIVERSITY OF ROCHESTER (Simon School/Graduate School of Management)

               Rochester, NY

            Concentration in Finance, Accounting, and Information Systems.

            Grade Point Average: 3.5

            Top 25% of Class

 

BBA, BARUCH COLLEGE (CUNY)   cum laude

             New York, NY

            Major in Finance and Investments

            Grade Point Average: 3.5


ACTIVITIES       

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 Rochester Fox User Group - President, Newsletter Editor

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

            Rochester Professional Consultants Network

            Software Executives Group

            Graduate Business Club (UR)

            Investment Club (UR)

            Finance‑Economics Society (Baruch) ‑ Investment Advisory Committee

            Financial Management Association (UR)

            Baruch College Newspaper, Reporter and Columnist

HONORS AND AWARDS

1996    Microsoft Visual FoxPro Step by Step won award for Technical Writing

            Dean's List ‑ Baruch College (3 years)

            CUNY Merit Scholarship

            New York State Regents Scholarship

1985    UR Stock Market Competition (3rd Place)

1979    National Merit Scholarship Commendation

1978    NYS Stock Market Competition ‑ First Place, NYC Region