Malcolm Burton – Malcolm@cmcdevelopment.com

3122389383

Experience Summary
Experience
Corneilius & Merril Corporation 1994 - Present
Project: Digital Pix Web	This web application in .net was designed to allow the user to administrate customers, organizations, invoicing, orders, and the entire business process start to finish include product production. Microsoft SQL Server , commerce server, and extensive use of stored procedures, web services, and Reporting Services. It included over 2000 stored procedures. The commerce server was used for product catalog and purchasing code.
Project: Fellowes website	This project included many small and large projects all regarding the programming for Microsoft Commerce Server on the public website for fellowes. I rewrote the entire business and data layer for the website in commerce server, created custom stored procedures for commerce server (and in some cases modified the existing ones), worked with commerce server reporting, list manager, and created numerous custom applets for managing website elements such as custom relationships between products. In addition, worked on programming for integrating data from various data sources including Oracle. Create several webservices for other internal applications and external vendors to retrieve user object data or catalog data from the commerce server catalogue. Made several installations and troubleshoot commerce server errors with the com+ or dcom objects as well as the database.
Project: Digital Pix Pose Selection	This project engagement was composed of several major and minor projects. The digital pix website was a .net application in c# for the purpose of allowing client customers to come to the web, register, view the pictures that they took at the photoshoot, select the chosen picture for a portrait or composite, verify information and in turn confirm the composite process in a clean, wizard like fashion. The system also had a webservices component for bringing data from the access databases containing picture and consumer information and uploading it to the website and database.
Project: State of Illinois - IDPH Role: Consultant	This project involved first the design and planning for an upgrade of content management server to the latest version. Illinois Department of Public health had an extensive existing content repository that needed to be migrated. In addition a new architecture to allow public read only servers, authoring servers, and development servers. Malcolm was also responsible for implementing this architecture and setting up a best practices sql server implementation to support the 3-tier system. Malcolm also served as the lead architect to direct and train the developers on best practices for migrating to .net c# programming for the site from asp. Malcolm also converted the main portions of the site to .net templates and .net code behind. Malcolm also implemented SourceSafe and created training reference materials for the developers to have best practice procedures for future development and trained them on how to convert older include files to server side classes in .net.
Project: State of Illinois - DCEO Role: Consultant	State of Illinois - DCEO - This project involved the creation and deployment of the http://www.illinoisworknet.net website using .Net and Microsoft Content Management server. The purpose of the site was to allow job seekers and employers to search for resources and setup accounts. The web site was deployed on content management server. Malcolm served as sql server dba and programmer for the content management server using c# (c sharp). This also included creating custom .net events for department users to post resources or job fair events via the dontent manager console to perform additional validation or apply business logic during standard content management operations such as saving a post or deleting a post. Malcolm was also responsible for the creation of all stored procedures and database design, and creation of web services such that other state departments could obtain statistics on the usage of the system by job seekers at various state offices.
Project: Littelfuse Intranet Role: Consultant	The Intranet project was designed using SharePoint 2001 and Microsoft Content Manager. The system was later upgraded to 2003 of SharePoint and Content Manager. This project entailed developing web parts by using existing web parts and applying them with either .net web services or .net web applications to create customized portals that went beyond single sign on. Some web parts would logon to SAP or Citrix applications and pull specific information from the server before presentation to the user, for example. This project involved the installation of server software, configuration, upgrade, customization of templates, and .net programming of interfaces to foreign applications.
Project: Littelfuse – Online Status Reporting Role: Consultant	This .net web application was designed to web enable the process of tracking employee projects, project metrics, weekly status reports for management. Information was secured such that users with specific permissions to see certain kinds of activities would be restricted or allowed based on integrated Active Directory security. Users can view online reports and generate online status reports as well as charts and graphs. Users are also notified when projects become late or warned when a threshold of resource allocation is reached. SQL Server 2000 is used on the data layer, .net and crystal web reports are used for the web application layer
Project: Chicago Metropolitan Chamber Of Commerce Role: Consultant	This website was designed originally with Microsoft Content Manager to enable the client to manage documents and news and events on their own. This project involved the server setup and security, hosting, and content manager configuration for client
Project: Score with Motorola Role: Consultant	This .net application was used to promote Cellstar’s Motorola promotion. The system retrieved data from various independent stores across the country, compared cell phone parameters with Motorola’s database and provided points and prizes based on specific sale combinations. Users were able to SpinToWin a wheel of fortune like applet that used a mathematical algorithm to determine who should win and under what circumstances based on a derivative function (slope of a 2^nd degree equation). The project used .net, SQL Server, Crystal Reports, and Java
Project: RadioShack – Monopoly Role: Consultant	This web-enabled ecommerce application was designed to facilitate employee involvement and synergy for the Verizon - RadioShack partnership. The application is completely web based and has several components.  First, data is transferred from the RS secured servers to the CMC infrastructure, decrypted, and loaded into SQL Server 2000 databases.  The data is process per complex business rules to determine how employees are awarded points or cash based on what was sold, what combinations existed, how it was returned, whether partial exchanges or upgrades were made, and other complex but true to life retail business scenarios.  This is done on a daily basis.  Employees can then come to the site, register and login.  Upon login, they have the option to view their place on the monopoly board.  This position is determined by the number of points accumulated thus far.  Each position on the board represents a certain point range.  The employee can also go to a link that shows them their total points and exactly where the points came from: phone sales, accessory sales, community chest bonus points, administrative adjustment, and so on.  This detailed accounting helps the employee reconcile and verify their point status.  The employee can also go to a link that shows them what prizes they qualify for and can purchase using their points.  The users can put those items in their cart.  A real time report is available in the secure reports section that shows fulfillment status.  Their is a separate secure reports section that allows higher level managers to look at all aspects of the application: registration status with drill down to any level, employee point reports, graphs and charts that show real-time trends in helping characterize the success of the program and how immediate changes can be made to increase sales, such as a web-based contest.  There is also a blast fax section of the application where stores are sent faxes letting them know the current status of employee participation at their store. The entire process is web based and available 24/7. The customer service section of the system is secure and separate, but also completely web based.
Project: RadioShack – RSStars Role: Consultant	This web application was designed to rank managers and facilitate a web based sales competition.  District managers compete within their region, store manager compete within the district, and regional managers compete within the division. First, data is transferred from the RS secured servers to the CMC infrastructure, decrypted, and loaded into SQL Server 2000 databases.  The data is process per complex business rules to determine how employees are awarded points or cash based on what was sold, what combinations existed, how it was returned, whether partial exchanges or upgrades were made, and other complex but true to life retail business scenarios.  Further, dish sales or DirecTV sales are examined at the sales ticket level and weighed to arrive at a point status.  This is done on a daily basis.  Employees can then come to the site, register and login.  Current sales are ranked and compared against prior sales to arrive at growth percentage values also used in the ranking process.  The secure reports section allows for complex reports at the detail store level and overall pie/graph/trend level so that higher-level managers can view real-time status of the performance of subordinate managers and take appropriate action to increase sales. There is also a blast fax section of the application where stores are sent faxes letting them know the current status of how their store ranks.  Employees qualify for prizes based on how well all stores within a group perform.  The entire process is web based and available 24/7. The customer service section of the system is secure and separate, but also completely web based.
Project: Relo Registration Website Role: Consultant	This web ecommerce application was designed to enable members of the largest real estate network in the country to peruse registration classes and purchase them via credit card over the web.  The key unique factor in the application is its link to the other existing applications and member database systems that are not web based.  These legacy systems had to be seamlessly integrated without being modified directly into the web application.  Class combinations had special business rules that added to the layer of complexity.  For example, members could only register for particular classes depending on what other classes where already purchased or registered.  If a member met special criteria such as being from a specific state and registering at a specific time for a combination of classes, they would be afforded additional options and discounts.  Hotel reservation is also handled by the application.  The customer service section of the system is secure and separate, but also completely web based.
Project: EBind Insurance Services Role: CTO	Responsible for both the networking and website development, hosting, email server, SQL server, and technical leadership. Malcolm setup the entire site infrastructure including servers, security, firewalls, SQL server, and so on. Malcolm coordinated tasks for the developers. Malcolm performed hands on programming and database programming and design as well as overseeing and tutoring the junior developers on programming concepts and strategies. Malcolm also functioned in the role of project manager for the website development. The website is an online insurance B2B eCommerce system. The agents are able to purchase workman’s compensation and business owner policy insurance online, get multiple quotes from multiple vendors, and bind online in real-time. Malcolm was also responsible for leading the initiative with contract negotiations for vendors and assist the CEO with support for business plan and presentation to insurance carriers. Skills used were ASP, Visual basic, SQL Server 2000 and 7.0, JavaScript, Java, VBScript, COM, DCOM, ADO, and so on.
Project: Animal Events Role: CTO	Responsible for both the networking and website development, hosting, email server, sql server, and technical leadership. Managed the project from a technical perspective. Set up the entire site infrastructure including servers, security, firewalls, sql server, and so on. Coordinated tasks for the developers. Performed hands on programming and database programming and design as well as overseeing and tutoring the junior developers on programming concepts and strategies. This website is a B2B and B2C site with a much broader audience. Responsible for the developers to drive the technical team, instigate correct design and development process procedures, and do the actual programming and database programming and administration. Skills used were ASP, Visual basic, SQL Server 2000 and 7.0, JavaScript, Java, Exchange Server, VBScript, COM, DCOM, ADO, and so on.
Project: CDUniverse.com Role: CTO/Consultant	Headed the technical department as acting CTO until a full-time CTO was identified. As a consultant, responsible for both the network and programming departments. Headed the development team to design key aspects of the ASP website, complete new programming projects for marketing, customer service, and the e-commerce site. Headed the networking team on site migrations, network topology, backup implementations, SQL replication, network administration for the internal corporate network and the e-commerce network. Implemented security for the network, the workstations, e-commerce databases, and the websites. Responsible for all aspects of technology including hiring and interviewing new employees for networking and programming. Functioned as SQL DBA for SQL Server and admin for Exchange Server. Planned and outlined programming and networking projects. Served as interface for all technology vendors and security concerns. Reported to the CEO, board of directors, and VP of E-commerce for this public company. Worked to close weaknesses in security in all aspects of the network and application. Made programming and network changes to increase performance of page downloads from 1.5 minutes at worse to consistently less than 3 seconds. Implemented load balancing among the web servers. Mentored and trained the developers on proper methodologies and more advanced programming and SQL Server concepts. Worked to bring website uptime from 75% to 100% by analyzing and correcting programming and ADO issues. Functioned both as a high level manager, team leader, lead developer, programmer, SQL Server DBA, and technical operations manager. Skills used were ASP, Visual basic, SQL Server 2000 and 7.0, JavaScript, Java, VBScript, COM, DCOM, ADO, and so on.
Project: Unext Role: Consultant	Worked on the Oracle data modeling and SQL programming for the online Training website. Integrated Lotus Domino chat and Broadvision web data into centralized database for online analytical processing. Created layered OLAP SQL queries for the Oracle. Analyzed and consulted with several departments on a unified SourceSafe implementation. Trained users and gave best practices and methodologies. Utilized extensive experience in SourceSafe and Development projects.
Project: Anexsys Role: Consultant	Worked on the IRS Electronic Funds Transfer System programming using vb6 to bring a consumer tax software from two tiered to multi tiered. Changed the communication layer and improved performance as well as numerous VB programming changes. Made the conversion from DAO to ADO as well. Due to the obvious high visibility, the customer needed a VB expert with focus on proper coding, maintainability, and quality assurance.
Project: Ask Ark International Role: Lead Developer	Set up and configured the web server environment from ground up – including security and firewall issues - and was responsible for all system infrastructure issues including IIS, security, firewall configuration for the website, exchange Server, SQL Server. Set up and maintained all Microsoft back office products. Programming responsibilities were to create an artificial intelligence website using Java, some client script as well as server script. Programmed in Perl as well. Also programmed in Flash’s Action Script handling the programming functions of flash. After the website was successfully completed, created a Japanese site and addressed the multi-lingual issues of the site from the programming and system perspective. Skills used were ASP, Visual basic, Exchange Server, SQL Server 7.0, JavaScript, Java, VBScript, COM, DCOM, ADO, and so on.
Project: TAMS – Tams Database System Role: Consultant	Designed and created vb6 web application. User layer in ASP, business layer in active x components on NT server, data layer also in active x components to sql server 7.0 backend. Project included full programming from concept to up and running web site including NT Server configuration, TCP/IP configuration, DNS, IIS configuration, MTS integration and programming in the VB6 components, error handling for special needs of web application, creation of hundreds of stored procedures for business logic and data application. Key focus was programming and design for performance. Budget constraints yielded a low scale NT server. Web app designed to use small memory footprint and return result to user as quickly as possible. Requirement dictated running on both MACs and PCs. User can create their own data forms and reports on the fly as well as links and menus within the application. Screens are customized per user per group. Crystal 7 web server and capabilities used. Continues to support existing app and move into phase two for additional enhancements.
Project: CCTS – AON Insurance Role: Lead Developer	Worked on existing insurance software. Took existing 2-tier model and converted code to full three-tier model. User layer running as vb6 app. Business logic layer running as active x components. MTS implemented at the server and coding level (VB coding MTS compliant where applicable). Backend SQL Server 6.5 migrated to 7.0. Project involved design, programming, SQL Server database administration, sql server programming on front end and back end via stored procedures and business data logic. Project also involved understanding of Insurance industry issues. Crystal Reports and numerous third party tools used in project.
OOO Courseware – OneOnOne Training Project: Consultant	Took existing ‘off the shelf’ multimedia training software for the MSOffice suite and modified both the software and install program to create new Networking version. New version uses neHertwork aware concepts and user-friendly network setup to facilitate complex behind the scenes integration. Project included creating licensing OLE component that uses calculus based algorithm for verification. Key part of project was to make application more stable and prevent system crashes via proper error handling. Continues to support OOO staff.
Project: Cooler Pro – Quaker Role: Project Lead	Designed and developed for customer market analysis tool used to analyze the customer’s sales data and compare it with the markets syndicated data (from Nielsen). Marketing and mathematical concepts were the key focus for complex sql for reporting and analysis. Wizard style application walks the customer through a complete market analysis with full reporting and graphing at the completion of the input. This product is currently used nationally by the Quaker sales force for convenience stores and presented and the 1998 National Association of Convenience Stores technical convention. The technologies used were sql, visual basic, ole automation, crystal reports, relational database design, and custom graphing. Recalled to continue and add features and enhancements to initially delivered system for past three years.
Project: FaxSystem/Exchange Server – Profile systems Role: Consultant	Designed and developed custom fax and internet MAPI server. The application used active X to access the SQL Server 6.5, and depending on a set of criteria, automatically fax, email, or internet email clients in the database in real-time. The project involved Exchange server administration and engineering, SQL Server programming using stored procedures and database analysis, and Visual Basic 5.0 programming. Separate project for same company involved advanced Exchange server 5.0 engineering including connectors, X 400 Gateways, MTA Transport stacks, Fax Gateways, and MS Mail Gateways. Some NT Server and SQL Server administration involved as well.
Project: BHS – Bell & Howell Systems Role: Consultant	Worked with team to design and implement specialized mail sorting software. Involved in the visual basic and c++ programming, testing, documentation. Programming and debugging for the real-time embedded processor in c (68000 processor). Created ole servers, numerous visual basic applications: ErrorWizard – automatically implements advanced error handling into any visual basic project also uses ole automation. Helpdesk – allows tracking and maintenance of helpdesk calls, customers, problems, provides graphs and reports, designed to easily expand with new dynamic reporting, uses network messaging to notify engineers of tasks and allow responses, uses ole automation with Word, and implements an answer wizard help find answers to customer problems. Responsible for other software and network tasks at the same time. Some departments, including corporate headquarters, have abandoned their old software to use my new system. OLE Error Object – functions as out of process OLE server application to track application errors for reporting and debugging. OLE Network object – out of process server to allow communication between computers on a network using interprocess communication (mailslots, etc). Implemented NT 4 network with MS Exchange. Heavily involved with networking and software testing as well. Described by supervisors as having an "excellent detail knowledge".
Project: CLC Chicago Leadership Council Role: Consultant	Created Network based software package to allow the maintenance and tracking of HUD and marketing rate properties and prospective clients. Created search engine to find property matches for clients based on income, amenities, and other government stipulations. Internetworked final package in a NT Server based network over a WAN. All remote sites dial in to the server, download the database, the separate server application performs a series of SQL queries and database manipulation to create a final database containing the combined changes and updates of all sites. Remote sites upload the new updated database to view the work of all other remote sites. Continued to secure Software maintenance agreement and perform NT server administration and network administration for all sites. Provided training, documentation, and testing. Presently making software enhancements and operating under a network and software maintenance agreement.
Project: Patient Alert Role: Consultant	Created Unix Network based software system to allow communication between multiple workstations so that medical patient schedules and time slot availability can be dynamically updated and performance and response reports generated. Continued to design, engineer, install, configure, and maintain Unix network.
Project: Federal Aviation Administration Role: Consultant	Worked with team on real-time embedded system project to control runway lighting for airport runways using object oriented programming in C++. Implemented Department of Defense documentation standards for the high level and detailed design.
Project: CIS Amoco Corporation Technology Licensing Role: Consultant	Designed and implemented an integrated database management, network messaging, and using C++, Visual Basic, extensive SQL, Access, Excel, and Word Basic. The CIS is an intellectual, chemical patent, and plant process license agreement management system used for agreement management, payment and invoice tracking, and graphic reports (summaries, bar charts, projections, pie charts, etc.). Use Windows API calls and OLE Automation to access Objects (linked as well as embedded) from the CIS to Excel and word. Used dynamic Data Exchange to communicate with exposed Excel and Word Objects, documentation, and training provided.
Project: RTRAQ Keebler Corporation-MIS dept Role: Consultant	Programming, modification, error correction, enhancement, and debugging of Keebler’s remote sales order system. Created and debugged C++ programs, DLL’s and Visual basic code. Used the DBASE data base engine.
Project: Consultant Thomas Gunt Enterprises Role: Consultant	Performed assessment of technical skill level of prospective employee applicants, test screening in Visual basic, Access, C, C++, NT networking, Unix programming and System Administration, x windows, Motif, TCP_IP, Novell, SQL, and analytical programming skill.
Project: RAMIS Ram information System Role: Consultant	Designed and implemented database management system customize for the mechanical press industry. RAMIS tracts orders, purchase orders, invoices, accounts receivable and payable payments received and due, and multiple financial reports. System designed using visual basic, SQL, and Access.
Project: Shipmaster Role: Consultant	Complete UPS shipping system for networks that integrates into the MAS90 accounting software designed to allow the user to barcode the sales order number and automatically receive a completed invoice, shipping labels, and code labels with minimum user entry. The system electronically interfaces with the scale, the multiple customer and inventory database, the UPS zone, and a personally created rate database, and prints a complete manifest at the end of the day. The system updates mas90 databases as well. (Because of the complexity of this project, a full technical specification sheet can be supplied).
Project: Windows Role: Consultant	Point of Sale Bar-coding system that enables users to enter customer number, items, and quantities and output a complete invoice and up date the MAS90 invoice database as well. Again, this is a greatly simplified summary.
Project: Credit Alert! Role: Consultant	Special integrated add-on program that checks each customer being entered into the system, accesses the customer databases, and checks to see-to-see if his credit limit has been exceeded. If so, the program gives audible alert.
Project: Paymaster Role: Consultant	Payroll system that lets every employee barcode his employee card and action updates the payroll and employee databases and print a daily report as well as maintains a permanent database.
Project: Invreal Role: Consultant	Real-Time inventory control program that has a version for a radio frequency barcode reader and a portable barcode reader: Both versions allow the remote entry of idem and quantities, and immediately updates the inventory database and prints a complete inventory report at the end of the session.
Project: General Motors Corporation Role: Consultant	Responsibilities include rotating through various departments to create custom software for the speed, efficiency, and reliability of that department. A few of the projects included:
Project: LDAF Locomotive Database Access Feature Role: Consultant	This windows communication system was designed to let the railroad engineer remotely access the Motorola microprocessor on board a distance locomotive to query its database, download data, and monitor engine, cooler, transformer, and other locomotive functions in graph or report form all in real time.
Technical Skills
Education & Certification
	Illinois Institute of Technology 4 years Computer Engineering - Deans list, 3.0 Club Microsoft Certified Professional