Alan L. Lin
San Francisco, California (415)
956-5153
email: alan@zot.net
OBJECTIVE
To develop software using Microsoft and other development technologies.
QUALIFICATIONS
A solid software engineer with
experience developing complex applications in ASP.NET, C#, Visual Basic, MS
Access, and other Windows development environments for industries including
corporate real estate and insurance.
Experience with several relational databases, SQL, and triggers/stored
procedures. Learns quickly and works
well and easily in a highly coordinated team environment as well as alone. Native English speaker with
clear communication skills.
TECHNICAL SUMMARY
Hardware: IBM PC
compatibles
Languages/Development Environments: ASP.NET, C#, Microsoft Visual Basic
3.0/5.0/6.0,
SQL,
HTML, C/C++, ASP, Microsoft Access, ActiveReports,
Crystal Reports
Operating Systems: Microsoft Windows from 3.x to XP,
MS-DOS, Unix
Databases:
Microsoft SQL Server, Microsoft Access, Oracle, Sybase, Ingres
EXPERIENCE (abridged)
California State Automobile Association San Francisco, CA Dec 01—Dec 03
Developer/Programmer (contract)
Developed ASP.NET and Classic ASP intranet applications for software change management and application inventory management, employing C#, JavaScript, Windows-integrated security, and DataDynamics ActiveReports. Worked directly with non-technical end-users to gather requirements and design applications. Extensively modified an existing VB6 application for homeowner’s insurance underwriting, and ported the entire application from an Access database to SQL server.
Digital Generation Systems San
Francisco, CA Feb 01—Aug 01
Developer/Programmer (contract)
Reconstructed (from incomplete files), repaired and enhanced a Visual Basic 6.0 order tracking application with a Visual C++ “middleware” layer running on Windows and UNIX, connecting to a Sybase database. The application enables client services personnel to supervise and facilitate approximately 8,000 deliveries of digital media files to the broadcast industry per day. Altered SQL, C++ code, and InstallShield scripts. Worked with end users on interface design and produced technical documentation.
Newmark & Co.
Real Estate New York, NY(offsite) Feb 00—Nov 00
Developer/Programmer (contract)
Ported a large Corporate Real Estate information system from Visual Basic 3.0 to Visual Basic 6.0. Performed code and SQL optimizations, wrote triggers and stored procedures, and built/modified database structures. Created an ActiveX/COM DLL containing functions shared by multiple executables. Employed object-oriented technologies to create reusable components. Implemented reports in Crystal Reports 8 using Seagate’s RDC object model to integrate reports into the main application.
Bank of America
San Francisco, CA Jun 99—Jan 00
Developer/Programmer (contract)
Worked on a team developing a VB6/MS SQL Server application for the bank’s Personnel department. The application aided the bank’s 100 compensation analysts to determine pay increases and incentives for the bank’s 150,000+ employees. Implemented user-level security for the application and coded screens including complex data viewing, search, and navigation facilities. Created and modified stored procedures and Crystal Reports and assisted in tuning application performance in both SQL and VB.
Charles Schwab
San Francisco, CA Dec 98—Aug 99
Developer/Programmer (contract)
Performed alterations and enhancements on an existing Visual Basic application for viewing and copying financial data stored on CD-ROMs.
Bay
Logics/Peninsula Advisors, Inc. San
Francisco, CA Jun 95—May 99
Developer/Programmer
Designed and coded Visual Basic database
applications for a corporate Real Estate information system used at several
Fortune 500 companies. Created subsystems including a project tracking module, a budgeting
module, and a vendor database. The system employed over 100 database
tables and connected to databases including Oracle, MS SQL Server, and
Sybase. It used the Crystal Reports
engine and boasted extensive user security.
Maintained and augmented the company’s
earlier Microsoft Access product.
Assembled reports in the Access reporting tool and created facilities
for data import/export.
Deloitte & Touche LLP
(DRT Systems) New York, NY May 94—Jun 95
Consultant
For a large financial
brokerage firm, led development on a Visual Basic/Access/Crystal application
for account executives to illustrate financial scenarios to prospective
clients.
For Deloitte & Touche and DRT, created Lotus Notes databases for storing
consultants’ resumés, client information, legal
documents, and project proposal documents. Assisted in administering a
Notes installation employing a Lotus Notes Server for Netware.
For the IT department of a major food
corporation, developed screens, code, reports, and reporting capability in an Access
2.0 application for budget and expense management. Worked
directly with end users on the application’s design.
For a large government agency, created
Microsoft Excel 5.0 worksheets for time-billing reporting, employing
field-level OLE links to import data at runtime from ASCII text files.
Electronic Data Management, Inc.
Fremont, CA Sep 93—Apr 94
Programmer/Intern
Created Lotus Notes
databases, and applications in Visual Basic and Borland ObjectVision. Installed and configured operating systems
and software.
EDUCATION
B.A., University of California, Berkeley Winter
1993
Completed coursework in
programming concepts and practice, structured and functional programming, data
structures and their implementation, computer architecture, object-oriented
programming, data modeling, SQL, and triggers and stored procedures.
Earned both the National Merit
Scholarship and UC Regents Scholarship awards.
OTHER INTERESTS Ongoing
Semi-professional violinist performing with a number
of rock and classical music projects, including a group that has opened for
Patti Smith, Los Lobos, Ani DiFranco,
Boz Scaggs, and others. Featured on numerous
independent and small-label musical recordings.
References available upon
request.