John S.

For a detail of these projects please see more at: http://www.linkedin.com/profile/view?id=60969174&trk=tab_pro • RJ Hayes - FCC Broadcast Attorney - Web Designer/Programmer - Designed and programmed in PHP, JavaScript, JQuery, Ajax, HTML, MySql a WordPress web site that integrated FCC radio station data with US Census demographic data and specialized Google maps for radio station Marketing and research. • BirdDog Solutions -Web Designer/Programmer - Designed and programmed in PHP, JavaScript, JQuery, Ajax, HTML, MySql, a web site that maintained and provided searchable call center meta data and recordings including. In addition, supervisor, group, and user management tools. • Client name withheld due to Non Disclosure Agreement - Transformed tens of thousands of xml files containing patent data into data that was then loaded into MS SQL Server 2008 database using C#. Designed and created database’s and tables for this data. Designed and created using C# the user interface programs to access the data. • Cannon for Congress - IT Data Specialist - Identification of data elements and sources required by the campaign, designed and created records, tables, databases, extraction of voter data from a variety of data sources, established criteria for determining the accuracy of data, transform data into usable data records and load into data bases, deliver custom reports, tables, and files using SQL based on client request • Utah Valley University - IT Data Modeler - Work/Data Flow Analysis - Consulted with all workers in the Administration Department of a State College, Analyzed all documents and software, Extracted data elements, Mapped work flow and all data requirements for the entire department, Documented duplications, areas of possible improvements, and bottlenecks. • FXCM - Designed and created a software system that delivered real-time data of foreign exchange market changes and international news to mobile pda’s and a web based portal for professional currency traders around the world. Data items were extracted from multiple sources needing transformation into a deliverable standard data set (ETL) for delivery over a secured Internet connection. Wrote client-server applications in Visual BASIC that established, maintained, and managed communication links with hundreds of data client ports to extract and port data from various vendor sources. Coded applications for both the host and client using a variety of technologies including, Visual Basic, mobile Visual Basic, HTML, JavaScript, PHP, Excel, Access, and MySql on an Apache Server • Fandango - Designed, created, and tested a prototype management software system for a resort management company, including reservation, check-in, housekeeping, and checkout systems. This system used mobileVisual BASIC on the client side and Visual BASIC on the server side accessing a MS Access and MySql backend. Designed the enterprise data model and relational databases used for the resort-management software system. Provided all documentation, data requirements, database designs, and business rules • General Dynamics - Research, compilation, and design of a software enterprise data model system that would allow for a data model to create, modify, and maintain the enterprise software and data structure of all components of the enterprise. • Faith Computers - Created a complex COBOL production control system utilizing a customized bill of material, which allowed production management greater flexibility in delivering product to the customer. This system was able to deliver a schedule of production, stock status of all component inventories, identify back order inventory, alternate inventory, identify needed delivery dates of component inventory not in stock, and project a completion date for the customer order. Wrote all code documentation and user manual for end users. Worked with department heads and end users in the development of project goals, requirements, and guidelines and user interfaces.