Michael Schaefer
|
Qualifications |
Experienced in design, implementation, support, and supervision in the areas of Web page programming, database design, data retrieval and conversion, server administration, and networking systems. |
|||
|
Primary Skills Experience Summary |
Skill |
Mastery |
Last Used |
Experience |
|
Access |
Intermediate |
Current |
10 years |
|
|
ADO |
Expert |
Current |
10 years |
|
|
ASP |
Expert |
Current |
10 years |
|
|
ASP .NET dotnet |
Intermediate |
Current |
5 years |
|
|
C# / Csharp |
Intermediate |
Current |
5 years |
|
|
C++ |
Intermediate |
Current |
9 years |
|
|
DNS |
Intermediate |
Current |
4 years |
|
|
Dotnet framework |
Intermediate |
Current |
3 years |
|
|
HTML |
Expert |
Current |
12 years |
|
|
JavaScript |
Expert |
Current |
10 years |
|
|
Server Administration |
Intermediate |
Current |
4 years |
|
|
SQL |
Expert |
Current |
8 years |
|
|
VB |
Intermediate |
Current |
3 years |
|
|
VBScript |
Intermediate |
Current |
5 years |
|
|
Languages Experience |
2002-Present: CSharp / C#, C++, ASP .NET framework 2001-Present: ADO, ASP, HTML, JavaScript, SQL, VB, VBScript; 1998-2000: ADO, ASP, DHTML, HTML, JavaScript, XHTML; 1996-1998:Microsoft C/C++, Microsoft Visual Basic, ProComm Aspect Language, portable UNIX C for various UNIX platforms; 1988-1996: Borland C/C++, Borland Pascal, Clarion (4GL Design/Database Program), HTML, Microsoft Visual Basic, Paradox Script |
|||
|
Databases Experience |
2006-Present: Microsoft SQL Server 2005 1999-Present: Microsoft SQL 2000, Microsoft Access 2000; 1999-2002: Microsoft SQL 7.0 1998-1999: Microsoft Access, Microsoft SQL 6.5, Microsoft SQL 7.0, XML; 1988-1996: Btreive, Clarion (4GL Design/Database Program), dBase, Microsoft SQL, Paradox, Paradox for DOS, Q&A. |
|||
|
Software Tools Experience |
2002-Present: Visual Studio, Visual Interdev.NET, Microsoft SQL (various editions) 2001-Present: Visual InterDev, Microsoft SQL; 1999-2000: Visual InterDev, HTML Tidy, Microsoft Access, Microsoft SQL; 1998-1999: Front Page 98, Visual InterDev 6.0, Microsoft SQL;1996-1998: Lex/Yacc, Norton Tools, Visual InterDev 5.0; 1988-1996: Borland Paradox Engine/Database Frameworks |
|||
|
Contact Information |
Email: mbs@mistrealm.com World Wide Web:www.mistrealm.com |
|||
|
Employment & Accomplishments |
POPULAR ENTERPRISES December 2002 – Present Knoxville, TN Database Analyst, Senior Systems Analyst Abacus Pixel Counter. Designed and implemented a “single pixel .gif” tracking system that used .NET framework technology on the front end to capture data, and a C++ .NET Windows Service on the back end to import data into SQL. This system created hourly, daily, and monthly reports while it handled 10,000,000+ transactions per day with no bottlenecks. APInfoSweep. Designed and implemented a C++ .NET Windows Service that imports XML NITF (News Industry Text Format) articles into SQL. Database Administrator and Analyst. Resolved database problems, provided regular backups of data, implemented informative web interfaces, and advised staff on intermediate and advanced SQL query questions. DNS. Updated company’s DNS servers as needed, and was responsible for troubleshooting DNS resolution problems. DominLU/Pinger. Took over and extensively revised a Visual Basic program designed to validate a large number (500,000+) of domains. Eping/PagePing. Designed and implemented a set of utilities to monitor web page and email performance. Used these tools in conjunction with IPSentry to watch over a number of servers located in different data centers in the USA and in Canada. Mentoring. Provided suggestions, education and coding advice as required in all aspects of development. Server Administration. Maintained and helped build customer’s local Data Center, resolved SBS Exchange Server issues, installed and hardened a number of systems for internet service, and detected and eliminated large-scale denial-of-service attacks. Vortex DNS. Designed and implemented a DNS program in C# ASP .NET framework that allowed wildcard domain handling, and other custom features. |
|||
|
|
INDEPENDENT CONTRACT March 2001 – Present Knoxville, TN Contractor for PDS Lake House Project.Designed and implemented a Windows Service in C++ using ASP .NET framework technology to import real estate data into SQL. Also implemented a web-based search interface that featured the ability to save searches, and receive new listings via email as the data is updated. Case Clerk Web Project.Designed, implemented and supported a project for web customers seeking online legal research capabilities, and provided support for a variety of payment options and automated web responses. Court Clerk Data Conversion. Created a data conversion program to import attorney records from Microsoft Access tables into an undocumented and unusually complex SQL format. This project also required a number of updates to Visual Basic .COM objects. Court Clerk Public Interface. Created an attorney search web tool that provided advertising pages for Court Clerk clients, as well as public access to the attorney database. Credit Card Interface. Implemented an ASP interface to the Authorize.net credit card processing portal as part of an online signup form. Created a database interface to track user information and security settings for Case Clerk web project. |
|||
|
Employment & Accomplishments |
APPALACHIAN ELECTRIC COOPERATIVE February 2003 Jefferson City, TN Contractor for PDS Recloser Tracking System. Designed and implemented a set of forms and reports to allow data entry of Reclosers, Locations, and Test Records that used the look and feel of the company's existing web pages. |
|||
|
|
INDEPENDENT CONTRACT April 2002 – May 2002 Knoxville, TN Contractor for EduTrax Import Process. Revised a complex, forty-seven-step import process in Microsoft Access, in order to bypass network traffic limitations and decrease processing time significantly. Web Interface. Initiated the conversion of an existing Microsoft Access application to an intranet web while retaining existing functionality. |
|||
|
|
VOLT SERVICES GROUP Jan 2002 - March 2002 Charlotte, NC Contractor for Microsoft ASP .NET (Dotnet). Trained in ASP .NET by Microsoft staff. Focused on architecture (HTTP Runtime, HTTP Modules, HTTP Handlers, HTTP Context Object), configuration, security, server controls, data binding, custom controls, caching, state services, debugging, and Visual Studio support. |
|||
|
|
Developer Support. Performed technical troubleshooting and support for Premier and Professional developers with a variety of ASP and ASP .NET issues. Created a variety of working examples using C# and the ASP .NET framework to resolve, "How do I…?" questions and demonstrate ASP .NET capabilities for the developer community. |
|||
|
|
INDEPENDENT CONTRACT December 2001 – September 2002 Knoxville, TN Contractor for WorldVoice City Personals Web. Repaired navigation system of a website that was created using a mixture of technologies. Web pages were also updated with current information. LabLine Central. Constructed a new web interface using ASP .NET framework technology to facilitate physicians contracted to the LabLine Central voice system. SQL Consultant. Provided database design techniques and SQL tuning tips for Microsoft SQL versions 6.5, 7.0 and 2000. |
|||
|
|
INDEPENDENT CONTRACT October 2001 Knoxville, TN Contractor for American Consulting Shopping Cart Program. Added third-party graphics and new functionality to a shopping basket / sales catalog application that uses VBScript, VB Com objects, and sockets to communicate with an AS-400 system on the back end. |
|||
|
Employment & Accomplishments |
INDEPENDENT CONTRACT April – May 2001 Knoxville, TN Contractor for Custom Internet Designs Code & Image Upload Feature (various webs). Added capability for various customers to modify and remotely update web pages. Implemented the feature with ASP, ASP Upload object, HTML and VBScript. Credit Card Interface. Implemented an HTML interface to the Authorize.net credit card processing portal as a demonstration of the technology. Newsletter Web Interface. Added template-driven HTML support, pixel-tag tracking and click-through counting to an online newsletter generation program. Tracked statistical responses in SQL databases and implemented some basic reporting features with ASP, ASP Upload object, CDONTS, JavaScript, SQL and VBScript. Vol Heritage Website.Interfaced to the University of Tennessee LDAP authorization object for user authentication. Implemented various revisions and updates with ASP and VBScript. |
|||
|
|
INDEPENDENT CONTRACT January – February 2001 Knoxville, TN Contractor for Digital Crossings Customer Charge Tracking. Designed and implemented a customer data entry system using ASP, HTML, JavaScript, and Access 2000. In addition to basic customer data, this web-based system allowed attachment of an unlimited number of circuits, changes, charges, contacts, cross-connections, racks and sales agents. System also provided various month-end reporting of charge data to support the billing system. Microsoft Bug Resolution. Isolated a heap corruption bug in ASP/ADO during development. Developed a workaround that allows stable web development. Microsoft will eventually develop a patch to resolve this issue. |
|||
|
|
MAXIM GROUP December 2000 – January 2001 Knoxville, TN Contractor for Med Images, Inc. Concentrators.Participated in the design of a client-driven subscription process where individual workstations dynamically locate the best master controller and replicate current data. File Layouts. Designed file layouts from functional specifications and developmental meetings. File layout design included support for custom data fields. Created initial tables in Access 2000 for the development team and web pages that dynamically document the current file structures. File-Checking. Created a high-level overview of a client-driven file-checking process for networked clients. Replication. Designed and implemented proof-of-concept of an N-way data replication process, where modifications made at any node are replicated throughout the entire system. |
|||
|
Employment & Accomplishments |
MAXIM GROUP 1999 - 2000 Knoxville, TN Contractor for Duro Communications DuroForm. Designed, implemented and maintained a complete Internet web-based data entry system that tracked Circuit Entries, Circuit Orders, Co-Location Data, Configuration Changes, Contacts, Customer Data, Escalation Tickets, Facility Requests, Incident Reports, POP Location Data, Purchase Requests, Software Installations, Trouble Tickets, User Data, Vendors, and Work Orders (for Administrative, Engineering, and Facilities). Project included significant interaction with users to determine their needs. System included file attachment capability, emails of status changes, and other features. DuroForm Call Center. Implemented system to support the front-line call center, with customer information tracking, trouble ticket handling, and internal escalation capability. Imported and translated over 200 megabytes of individual html pages to load system. DuroForm DNS. Implemented DHTML web interface using RDS technology. Imported various DNS records into SQL database. DuroForm Form Attachment. Implemented capability to attach various forms in the system to each other, allowing users to quickly find related data items. System reflected updates to original forms in cross-linked forms without incurring heavy system load. DuroForm SMTP Import. Implemented a generic import utility that would allow formatted imports from email files directly into various databases. Project Leader. Provided training, support and direction for junior programmers. Provided project leadership for several in-house development efforts. |
|||
|
|
MARKETLINX SOLUTIONS 1998 –1999 Knoxville, TN Senior Programmer/Analyst ASP Objects.Designed and implemented extensive back-end server-side code libraries with object-oriented programming methodologies using JavaScript to access ADO. Clean Data. Designed and implemented Web interface to safely mass-update SQL tables using cursors with rollback capabilities. IDC to ASP. Designed and implemented a code-conversion tool, using Microsoft C to render IDC files into ASP format, allowing the conversion of numerous HTX/IDC files. Individualized Custom Reports.Implemented user-tailored reports, saving user preferences in SQL tables. |
|||
|
|
Third Party Interface. Implemented and supported a third party interface, allowing third-party developers to send queries and to retrieve results in CSV or XML format. Web Reports. Designed and implemented reports from SQL databases using ASP. Developed code to automatically generate complete reports from a list of fields, allowing the user to sort the data on demand. Web-Generated Data Entry. Designed and implemented Web interface to generate tables and source code for data-entry screens for real-estate properties. |
|||
|
Employment & Accomplishments |
USERBASE SYSTEMS 1996 – 1998 Knoxville, TN Senior Programmer/Analyst, Network Administrator Crypt. Designed and implemented source code encryption/decryption utilities using C on the UNIX platform. Sockets. Designed and implemented code to interface with remote modems using socket technology using C on the UNIX platform. Sync Files. Designed and implemented C++ cross-platform source code synchronization utility using FTP. Usilink. Supported and extensively redesigned a large legacy UNIX C communications product on the UNIX platform. Windows NT Communications. Implemented file transfer code using PDQ Communications libraries for transfer of data using Visual Basic on the Windows 95/NT platforms. Windows NT Services. Designed code-framework to take advantage of Windows NT service features using Microsoft C/C++. |
|||
|
|
NOVA INFORMATION SYSTEMS 1988 – 1996 Knoxville, TN Senior Programmer/Analyst Auto. Designed and implemented a job process control system implemented in Pascal using Paradox databases on the DOS platform to spawn jobs under designated conditions based on time, date, disk space, or other events, saving the company thousands of man hours. Conversions. Implemented multiple data conversion programs in Q&A, Clarion, Pascal, Paradox, Borland C++, Dbase, and Microsoft C++ on the DOS and Windows 95 platforms that translated data files from a number of different financial institutions and imported the data into our company databases. Database Management. Designed, implemented, and maintained the company database systems using Q&A, Clarion, ASCII, Paradox, and Dbase formats in an environment of more than 230 databases. Fraud Control System. Designed and implemented a values-based decision system, using Pascal on the DOS platform to screen transactional data for merchant fraud. Also implemented an online report-viewing program to display and print fraud data. NDI (Next Day Inquiry). Designed and implemented high-speed search, retrieval and display system for large databases using Pascal on the DOS platform. Rebates. Implemented payment programs to calculate residual payments and rebates for sales representatives and financial institutions, featuring multiple payment levels with complex formulas, a manual payment entry screen, online and printed statements, and a link to our company ACH system. This was implemented using Borland C++, Microsoft C++, and Pascal on the Windows 95 platform. Supervisory Experience. Operated a department of seven employees. Supervised meetings, project management, and problem resolution. |
|||