MARK MOUNTCASTLE
Vanzant, MO *****
Phone 417-***-**** email: **********@*****.***
SUMMARY
Microsoft Information Technology professional with 20 years experience as a problem-solver and developer of software systems.
Able to see the big picture to identify solutions and streamline procedures to enhance quality, efficiency, and reliability of
manufacturing processes and day-to-day business tasks. Recognized as one who has a thirst for knowledge and a passion to
conquer tough challenges.
PROGRAMMING & COMPUTER SKILLS
Databases: MS SQL, MySQL, Microsoft Jet (Access), dBase, Clipper, DB2, B-Tree, and Databasic
Languages/APIs: C/C++ (14 years), MFC (11 years), C# (1 year), VB/VBA (10 years), Java (2 years), HTML (8years), XML (3
year), DHTML (2 years), PHP (2 years) Windows Scripting (15 years), Windows API, MAPI, Window Sockets
Communication Technologies: .NET, TCP/IP, Net BIOS, Named pipes, PLC, RTOS, RS232, RS422
Software: Microsoft Office (17 years)(Word, Excel, Access, Outlook, Powerpoint), Visio (3 years), Microsoft Project (5 years),
Visual Studio (14 years), Paint Shop Pro (17 years), Adobe Photoshop Plugins(12 years), Animation Tools (8 years), Open Office
Suite (3 years)
PROFESSIONAL EXPERIENCE
Afco Steel, Little Rock, AR 09/2008 10/2008
SQL/Developer Consultant
Software Consultant
Visual Studio .NET development (C++) and MSSQL 2005 database(s) design, testing, and implementation.
Designed, implemented, and deployed a database structure and code to migrate Access data to an Enterprise
platform
Performed a one-time ETL process to move legacy data to the SQL platform.
Designed, coded, and implemented a custom application using Visual C++ to manage the data in the new database,
and run reports.
Transamerica Worksite Marketing, Little Rock, AR 05/2006 01/2008
SQL Datamart/warehouse design, testing, implementation, and migration
SQLDB Engineer
Visual Studio .NET development (C++/VB) and MSSQL 2000/2005 database(s) design, testing, and implementation.
Designed, implemented, and deployed a database structure and code to initially populate a datamart/warehouse of
historical and current company wide information. This product consolidated numerous data sources
Coded and implemented database procedures to automate updates and management of the ongoing
datamart/warehouse content (ETL).
Designed, coded, and implemented a data-error interrogation tool using Visual C++ to identify problem areas with
the process, or data integrity.
Created client-side executable programs using Visual C++ to manage and automate server-side processes.
Training in SQL coding techniques.
Documentation of the database architect and process (Server-side).
Documentation of the executable programs (Client-side).
Worked through the SDLC process with design, testing, and implementation.
Xerox Corporation, Hot Springs, AR 12/2003 01/2006
Imaging and Image archiving services.
Software Engineer
Visual Studio .NET development and MSSQL 2000 database design and administration.
Designed, implemented, and deployed software to support the Xerox production imaging processes from initial
customer concept through deployment and support on the .NET platform.
Streamlined existing processes to maximize personnel and equipment and to meet customer expectations regarding
service level agreements, often saving the company thousands of dollars in late penalties.
Cross-trained colleagues in Transact-SQL and C++ development concepts to help the team improve it's overall
skills and expertise.
Source Control Administrator.
Integrated encryption transfer technologies.
Designed, developed, and deployed automated processes for database and data communication updates and
transfers.
Rittal Corporation, Springfield OH 11/2002 03/2003
International leader in manufacturing of metal-based enclosures for technology and customer specific applications.
Microsoft Database Analyst (DBA)
DBA and Network Administrator for Microsoft SQL 2000 Systems.
Designed, developed and implemented Intranet solution for timely and readable statements for cell phone accounts
within Rittal workforce.
Designed, developed and implemented the first company-wide tracking system for shipping costs to customers.
Migrated numerous Microsoft Access databases to SQL platform to enable consistency and available data.
Dayco Corp./Parker Hannifin, Miamisburg, OH 11/2000 06/2002
Purchased by Parker Hannifin; manufacturer of rubber hose and connectors for hydraulics, oil, and mining operations.
MFC Developer and DBA and DB Architectural Engineer
DBA/Architect and Network Administrator for Microsoft SQL 6.5 and 7 Systems.
Created tools and information resources which played a key role in increasing the unit-fill/line-fill from the
60/70% range to the mid to upper 90% range.
Designed, implemented, maintained, and managed data and databases on a multi-platform enterprise system using
Access, MS SQL, Visual C++/MFC, and VBA.
Integrated data resources across computer platforms (AS/400, NT 4.0, Windows 98, Windows 2000) to make
information more available, timely, and manageable.
Integrated data across multiple applications (JD Edwards, Demand Solutions Inventory Management, CorVu, MS
Excel, MS Access, MS SQL 7) to make information more available, timely, and streamlined tasks.
Designed and created automation tools for darkroom processing to eliminate third shift staffing and processes.
Designed and implemented remote error notification and maintenance processes to maximize reliability of
darkroom processes, and minimize down-time.
Dayco Corp., Springfield, MO 04/1997 11/2000
Power Transmission Division, leading developer in belts and drive banding products.
Project Analyst/Manager
Coordinated contractors, and various departments for collaborative application development, and maintained project timetables.
MFC/C++ development and DBA and Network Administrator for Microsoft SQL 6.5 System.
Provided and managed development to streamline processes in accounting, costing, planning and forecasting.
Evaluated application development tools, and made directional decisions for project development or purchasing.
Designed, developed, and maintained enterprise-wide database system using Microsoft SQL Server.
Designed, developed, and maintained client/server applications in VB, GSL, and Visual C++/MFC to reduce
overhead and sales cycle of application engineering and quoting to the customer.
Analyzed and automated paper-intensive costing techniques to enhance sales and marketing processes.
DataTrade, Inc., Springfield, MO 06/1994 04/1997
Provider of C.O.L.D. storage software used in banking, investing, and other data archive intensive businesses.
Software Engineer
Designed and implemented IBM AFP print stream interpretation code and conversion to PostScript for cross-
platform viewing and printing.
Created and coded a PostScript viewer that could be used on any Windows platform to view archived data.
Wrote Installation routines for the server product, client workstations, demos, and proof of concepts to allow a
customer to do support-free installations and maintenance.
Designed and coded several end-user applications to enhance marketability and usability of DataTrade products.
Wrote on-line documentation for all the client applications for manual deliveries.
Member of team that developed an SDK for other companies to use DTI (DataTrade Technology Server) server.
Designed and implemented Hewlett Packard PCL interpretation code and conversion to PostScript to maintain the
DataTrade viewing and storage standard, and support laser printer formats.
Created various other data stream manipulation utilities to help other team programmers complete their individual
tasks and projects.
Primary development tools were ANSI C and Visual C++/MFC.
Creative Solutions, Springfield, MO 02/1994 02/1996
Home-based consulting business for small company transitions to digital systems.
Consultant
Successful accomplishments included electronic integration of the following types of businesses:
-Phone System/Service -School Supply Distribution Company
-Heating/Cooling, Appliance Sales and Service -Contract Digging and Maintenance Businesses
Gama Systems, Inc., Mountain Home, AR 11/1988 02/1994
Research and Development solutions provider for industrial applications and requirements.
Vice President, Software Development
Primary responsibilities of this executive position included all software research and development, software training and technical
support, and proof of concept development and analysis.
Developed permanent and portable data acquisition systems which could monitor, analyze, report, and archive analog, digital,
counter/timer, and intelligently transmit data of any type of manufacturing process equipment.
Reduced or eliminated down-time of machinery, maximized quality of production runs, and reduced cost of maintenance and
troubleshooting during manufacturing cycles.
U.S. MILITARY SPECIAL OPERATIONS
Intelligence Specialist
Counter intelligence, intelligence research specialist, psychological operations analyst, propaganda development, computer
systems interrogator, and NBC (nuclear, biological, chemical) NCOIC and threat evaluation specialist. Maintained a TS-SBI (Top
Secret Special-Background Investigation) clearance.
EDUCATION
Central Missouri State University Warrensburg, MO
Bachelor of Science (geology)
PROFESSIONAL AFFILIATIONS
* Microsoft Developer Network * The CodeProject
* Basic Users Group Association * SourceForge
COMMUNITY ACTIVITIES
Science advisor for a local scout group
Music teacher for a home-school COOP
Worship Minister in a local church
Charter member of a new church in Hot Springs, AR area