MARK MOUNTCASTLE HC 73 Box 1A Vanzant, MO 65768 Phone: (417) 948-0114 email: mtcastle_m@yahoo.com 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 Dates: 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 Dates: 05/2006 – 01/2008 SQL Database design, testing, implementation, and migration SQLDB Engineer Visual Studio .NET development and MSSQL 2000/2005 database design, testing, and implementation. Designed, implemented, and deployed a database structure and code to initially populate a datamart of historical and current company wide information. Coded and implemented database procedures to automate updates and management of the ongoing datamart content. Designed, coded, and implemented a data-error interrogation tool to identify problem areas with the process, or data integrity. Created client-side executable programs to manage and automate server-side processes. Training in SQL coding techniques. Documentation of the database design 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 Dates: 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 Dates: 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 Dates: 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 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 Dates: 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 Dates: 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 Dates: 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 Dates: 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