John David Stoops – Technical Director / Software Architect

Contact Me | PDF | MS Word | LinkedIn | oDesk

        Summary

 

10 years experience gathering business requirements, leading analysis/design, and developing software. I'm a very motivated individual who enjoys solving complex problems and designing elegant solutions, including knowledge management systems (KMS) for the U.S. Navy, scientific data analysis systems for the Environment Protect Agency (EPA) and State Water Boards, education portals, and a wide range of commercial, publicly accessible Web sites with e-commerce and content management solution (CMS) capabilities.

I thrive in positions such as a .NET Application Architect, C#/PHP Developer, and Systems Analyst / Designer. For the past year I have been developing my skills as a Flex Developer and with several successful Rich Internet Application (RIA) projects completed I am now using this technology to create use-friendly, feature rich Enterprise systems and Web applications integrated with back-office and legacy systems through Web service APIs.

I'm a legal citizen of both UK and USA currently residing in Alexandria, VA USA. Willing to travel and meet clients on-site for requirements gathering, training sessions and deploying production systems.

        Computer skills

 

Languages

·       6+ years: C#, UML, Web Services, SOAP, ASP.NET, AJAX, Visual Basic (VB) 6, VB.NET, VBA, ASP, JSP, PHP, ODBC, ADO.NET, VBScript, JavaScript, XML, XSLT, HTML, DHTML, XHTML, CSS, PL/SQL, T-SQL

·     1+ year: ActionScript 3.0, MXML, Flex Framework, LiveCycle, Java, C++, Cold Fusion, COM, PERL, CAML

Software

·       Applications: MS SharePoint (MOSS 2007, WSS 3.0), MS Visual Studio (6, 2005-8) , Flash 9.0, Flex Builder, MS Office, Project & Visio (97, 2000-7 & XP), Crystal Reports (8-XI), MS SQL Reporting Services, Photoshop, Enterprise Architect, RedDot, GoldMine, Dundas Graphs, Dreamweaver, Homesite, Eclipse, JDeveloper, Joomla!, DotNetNuke (DNN), VirtueMart, ZenCart , SalesForce, QuickBooks

·     Systems Software: MS SQL Server, MS Access, Oracle, MySQL, MS Windows (3.11-2000, XP, Vista), MS Windows Server (2000-8, NT), MacOS, Internet Information Services (IIS), Apache, JBoss

        Experience

 

Technical Director / Software Architect / Web Developer

03/09-Present

LeafDev, Alexandria, VA 22312, USA

Environment: UML, C#, ASP.NET, VB.NET, PHP, AJAX, Web Services, SQL Server, Oracle, MySQL, XML, XSLT, MS Office, HTML, CSS2, WSS 3.0, MOSS 2007, Visual Studio 2005-8, MS SQL Reporting Services, Enterprise Architect, Joomla!, DNN, VirtueMart, ZenCart, SalesForce, QuickBooks.

Providing custom software development services, install/setup/customization of CMS and SharePoint, enterprise systems integration, and rich internet applications (RIA). All Web design and branding by the Creative Director which I converted to CMS templates for custom look.

Current Flex, DNN, Joomla!, and .NET projects through LeafDev:

·     Xpensert Web site (not live) for Xalles, Inc.: Custom DNN skins and purpose built Flash return-on-investment (ROI) calculator using ActionScript 3.0 and the Flex Framework to build Flex components that visualize the results as charts and tables. These components along with a custom video and software walkthrough presentation component are packaged as an RIA for the homepage and as DNN modules for placement on other pages so they interact with each other and log inputs for analysis.

·     PikStik Web site and Storefront for Reid Industries, Inc.: Using DNN CMS with Flash presentation for PikStik product site and ASP.NET Storefront (ADNSF) shopping cart solution for direct sales site.

·     Luxury Property Showcase Website for Exotic Estates International (EEI): Including custom built RIA property gallery built in Flash CS3, ActionScript 3.0, PHP, and MySQL.

·     SiriusG3.com Web site for Sirius Group LLC: Installed/setup Joomla! CMS with e-commerce solution VirtueMart so that security classes can be advertised and purchased online.

·     Xalles Limited client sites: Using Joomla! CMS to create standard platform for several of their client sites, including Ghana Cyber City, Co-owners, Inc., and Co-owners Rewards.

 

Systems Analyst / Software Architect / Developer / Tester

07/06-Present

Tetra Tech, Inc., Fairfax, VA 22030, USA

Environment: UML, C#, ASP.NET, VB.NET, AJAX, Web Services, SQL Server, Oracle, Java, JSP, XML, XSLT, MS Office, HTML, CSS2, Crystal Reports XI, WSS 3.0, MOSS 2007, Visual Studio 2005-8, MS SQL Reporting Services, Photoshop, Enterprise Architect.

Lead analysis and design for U.S. Environment Protection Agency (USEPA), U.S. Navy, Department of Energy (DOE) and State Water Board projects. Technical lead and developer for all .NET and SharePoint projects, ensuring timely delivery of development tasks. 10% rise in pay first year and 25% rise in second year.

·     Dynamic Document System (DDS) for Naval Facilities Engineering Command (NAVFAC): Systems Analyst, Business Workflow Developer, and .NET Developer on project customizing enterprise document management system (DMS) Laserfiche with custom business process applied for developing the US Navy Marine Resource Assessments (MRA) document and extensible content types for other documents.

·     Forest Information Management (FIMS) for Camp Leijune and Marine Corp: accepts entry of forest inventory data collected from the base's forests calculates forest product metrics available as reports. Systems Analyst and Technical Lead on system developed using ASP.NET 2.0, .NET Framework 3.5 with MVC 1.0 and LINQ to SQL for generating the data access components for the SQL Server 2005 database. Report developed using SQL Server 2005 Reporting Services.

·     SharePoint Intranet for Tetra Tech’s Information Technology and Modeling Services Group (ITMSG): technical lead implementing the office’s Intranet site built using MOSS 2007 which includes documents libraries, Wikis for knowledge bases, custom views of lists using Web services, custom XML and XSLT data views, and custom work flows for projects. Leading development team planning, designing, building, and administrating SharePoint site and sub sites.                                                                                

·     Coral Triangle Initiative (CTI) for USAID: technical lead for development team planning, designing and building SharePoint application used in Philippines to collaborate on various initiatives to protect coral reefs. Includes custom Web part using Google maps and a backend Geographic Information System (GIS) for spatially-enabled project information, a custom Web part to replace SharePoint’s document library for more ease of use and publishing documents to other sites and MS SQL Reporting Services reports using Web services to pull data from SharePoint lists.

·     ALA-WADR for Alabama State: technical lead for development team adding functionality to existing multi-tier ASP.NET application for collecting fish and macroinvertebrate samples.

·     eReporting for United States Environment Protection Agency (USEPA) Office of Waste Management (OWM): lead analyst and designer for the eReporting module which is part of the eNOI system - online electronic permit application system. eNOI allows construction site operators to apply for coverage under EPA’s NPDES storm water Construction General Permit (CGP) and for industrial facilities covered by EPA’s Multi-Sector General Permit (MSGP).  The requirements were gathered in joint application development (JAD) sessions with key stakeholders and users, analyzed using various agile and Unified Process (UP) compatible techniques to design business process workflow, use cases and scenarios, logical data models and documentation of non-functional requirements.  The design was documented in the form of diagrams compliant with latest UML. Ensured electronic signatures and permit encryption complied with CROMERR check list standards.

·     Check-Up Program for Small Systems (CUPSS) for USEPA Office of Ground Water and Drinking Water (OGWDW): selected appropriate technology and system architecture through proof-of-concept studies for multi-platform, free asset management tool. Lead tester and configuration manager for build phase of CUPSS desktop application that’s an electronic mechanism for tracking and planning basic facility operations, maintenance activities and long term asset management.  CUPSS provides asset inventory, planning and preventive maintenance and financial planning components for small drinking water utilities.  The test plan includes the testing strategies, test cases, and expected results used to test system.

·     Comment-Response System (CRS) for Department of Energy (DOE): functional lead and configuration manager for system that manages the comment-response process and generates scoping reports and environmental impact statements (EIS).  The SDLC followed an approved set of processes that ensure quality in the development of the system and Enterprise Architect was used to document design that met strict QA procedures.

·     California Water Quality Assessment (CalWQA) System for State Water Resources Control Board (SWRCB): lead analyst and designer for system that collects lines of evidence (LOE) on water body impairments in state of California. Allows regional boards to make decisions on these LOE for SWRCB and USEPA to approve and create 303(d) and 305(b) listings for public and USEPA Integrated Report.

·     Water Quality Monitoring (WQM) Data Flow System for Texas Commission on Environmental Quality (TCEQ): analyzed requirements and designed data flow system using UML diagrams to communicate behavior, architecture, and realization of components to be implemented in Java. Used a model and test-driven approach in line with UP and agile practices to manage development effort and comprehensive test strategy. The Surface Water Quality Monitoring System (SWQMIS) is used to enter WQM data in an Oracle database that is submitted to USEPA’s Central Data Exchange (CDX) system via Web services in XML format conforming to a specific set of CDX compliant XML schemas and data validation rules. Part of team responsible for updating design documentation and testing SWQMIS.

·     California Integrated Water Quality System (CIWQS) for USEPA: responsible for gathering business requirements from EPA and various water boards in California. Then translated requirements into designs for developers and database administrators (DBAs) to create Web-based reports from WQM data held in CIWQS using Java, PL/SQL and Oracle.

Software Analyst / Web Developer

09/05-07/06

Confi-Chek, Inc., Sacramento, CA 95811, USA

Environment: UML, ASP.NET, C#, AJAX, Web Services, XML, XSLT, SQL Server 2000-2005, Reporting Services, Visual Studio .NET & 2005, Indigo, Design Patterns, HTML, DHTML, IIS (5 & 6), Windows Server 2000-3, Enterprise Architecture, MS Viso & Office (2000 & XP).

Performed business analysis and software design using CASE tool for creating UML diagrams to communicate with business managers and other developers in line with eXtreme Programming (XP) process. Implemented systems in C#, ASP.NET, SQL Server, SQL Reporting Services, and Web Services.

·     Designed architecture, enhanced search functionality, and added visitor tracking for multiple Web sites providing public records search capabilities using C#, ASP.NET, and Web Services. Sites targeted different audiences, such as public searching for friends and companies needing background checks on employees, hence need for common application framework and multiple front-ends. System met current design standards and used latest technology by utilizing design patterns like Model-View Controller (MVC) and Indigo messaging framework (now known as the MS Windows Communications Foundation- WCF). Innovative use of WCF combined with AJAX for providing search-as-you-type results.

·     E-marketing Web tool: designed and implemented system in ASP.NET and MS SQL Server with advanced sales tracking integrated with front-end public records search sites. Enabled staff to create email marketing campaigns that automatically send custom branded emails, newsletters, offers and discounts to prospects and existing customers by intelligently selecting relevant promotions based on visitor tracking data and past purchases. Made an additional $200K for Confi-Chek, Inc. within 3 months of launching first email marketing campaign.

Director / Architect / Analyst / Developer

01/03-09/05

Koala Tree Ltd., Camborne & Bath, UK

Environment: UML, XML, SQL Server 2000, Access (97, 2000 & 2002), MySQL, ODBC, ADO.NET, ADO, OLE DB, Visual Studio .NET, COM+, ASP.NET, VB.NET, VBA, ASP, JSP, PHP, VBScript, JavaScript, HTML, DHTML, XHTML, CSS2, IIS (5 & 6), Windows Server 2000, Crystal Reports, Dundas Graphs, GoldMine, MS Office automation, Photoshop, Search Engine Optimization (SEO) tools, Enterprise Architecture, MS Project & Office (2000 & XP).

I setup a limited liability company to accept new government contract and protection for commercial contracts providing systems analysis, Web development services and custom desktop software solutions.

·     Waste Recycling Web site for Europe (EU) Environment Agency (EA): lead analyst and designer in producing detailed design documentation (including UML diagrams) and development plans for system allowing businesses to search for waste recycling facilities in their area. The system was created for Agricultural Waste Stakeholders’ Forum that included Department for the Environment, Food and Rural Affairs (DEFRA), EA, National Farmers Union, and other organizations from which requirements were gathered. Web development team leader implementing multi-tier system with ASP.NET, VB.NET, and SQL Server.

·     Remas for EU EA: Web developer for system used to analyze environmental data using graphs.  Wrote detailed user guides and implemented in ASP, Crystal Reports 10 and MS Access XP.  This project required careful negotiation in meetings and pacifying a disgruntled client that I achieved within a few weeks of taking over project by being honest with timelines and understanding to problems client had encountered with first version. Then followed through by producing a quality system that met and exceeded the client’s needs.

·     Landcare UK for UK EA: Web developer for land management best practices site that met accessibility guidelines, adhering to not only the UK AAA web accessibility standard but also compliance with US section 508 and ADA. Developed using HTML, CSS2, ASP and MS Access.

·     Greenerfutures for the Peterborough City Council: required analysis of key stage 1 & 2 data on their education portal using JSP and MySQL.

·     Stock exchange utility for Regisdata: updated stock quotations on daily basis and exported specified fields to be uploaded to Web site and sent to clients. Automating file creation from MS Access database was achieved using VBA, also detected spikes in data by comparing two files.

·     Listencloser music portal: provides free web pages, streaming and online promotion for bands, DJ’s and solo artist of all music genres and trained staff in Web site development and to administer it, validate HTML code, and meeting accessibility guidelines.  Trained bands and DJs to use Cakewalk to practice recording and mixing themselves for a single to be recorded in a studio then promoted and sold as a music CD and downloaded with digital rights management software used to lock download after 3 free plays unless purchased.

Chief Programming Officer

02/01-07/03

Nuera Ltd., Redruth, UK

Environment: UML, XML, Access (97 & 2000), MySQL, dBase, PostgrSQL, ODBC, Jet, ADO, Visual Studio 6, VB6, VBA, ASP, PHP, VBScript, JavaScript, HTML, DHTML, CSS2, IIS, Apache, Windows Server (2000 & NT), Crystal Reports, GoldMine, MS Office automation, Photoshop, Dreamweaver, Homesite, NuSphere, Search Engine Optimization tools, Project, Office, Visio, Reddot.

Provided all training, support, Web site, custom software, Intranet, and Web script development services for the company and to their clients.

·     Public Web site for Eden Project: worked with Technical Director to set up Reddot CMS (now knows as OpenText) for users to manage public Web site and used ASP, Access and JavaScript to implement custom education games to entertain children coming onsite for a school trip or with the family.

·     Intranet Web site and DMS for Eden Project: Web developer and back office system integrator using ASP, Access, and MS Office automation (Word).  Compared and recommended best existing CRM and Knowledge Management Solutions (KMS) available but client chose a custom document and event management system, along with a phonebook/contact system with all staff and Eden Project contacts made available over company network.  Trained staff and wrote user documentation.

·     NeuQuote Web site for Nuera, Inc.: staff configures available online marketing services for resellers and clients to select, enter monthly marketing budgets and generate a custom quotation online or in PDF to print and turn into an invoice.  Designed to be database agnostic and works with MySQL, MS Access, SQL Server, dBase, and PostgreSQL. System implemented using PHP, MySQL and UML to design it.

·     Web site review desktop application for Bishops Flemming and UK Online: initially developed for Nurea Ltd. before becoming a full-time employee (see experience below) then updated for accountant’s Bishop Flemming and UK Online to include the latest recommendations in meeting accessibility guidelines and various government directives (i.e. E-commerce 2002).

·     Other projects include creation of custom scripts for Star Internet complex form registration process, event management system for Cornwall Arts Marking (Seen), custom CMS for CESA foreign language courses Web site, and search engine optimization (SEO) services.

Software Analyst / Web Developer

06/00-01/03

Self-employed, London, Bath & Poole, UK

Environment: Access (97 & 2000), ODBC, Jet, ADO, Visual Studio 6, VB6, VBA, ASP, VBScript, JavaScript, HTML, DHTML, CSS2, IIS (4 & 5), Windows NT, MS Office Automation, Photoshop, Project, Office.

Contractor providing services ranging from building custom back office software solutions (Web site review and news sector summary system) to developing company Web sites (online photo gallery, accommodation availability Web site, council contact solution, online credit card processing).  All projects were self-managed using a range of traditional analysis and design techniques.

·     Web site review desktop application for Nuera Ltd. and Business Link: Nuera Ltd., the Internet marketing company offered me a full-time position after completing this application.  Built to assist Web site Review Initiative that allowed staff to enter information gained from questionnaires sent to companies that received government funding and generated preliminary and final Web review reports. Achieved by automatically analyzing company Web site for bugs, problems with search engine indexing, metadata quality and log file analysis. Recommendations on improving Web site generated based on past recommendations made on relevant previous reviews.  System helped save time, create consistent reports, and provide a database with potential to produce advanced Web site analysis for Business Link and other organizations involved in UK and USA Web initiatives.

·     Kwikrooms for Emagine New Media: Used ASP and Access to implement online hotel availability system.  Custom built map, utilized Web positioning techniques, SEO and e-commerce solution.

·     North Dorset Council Web site: Directory of council staff, councilors and parish clerks stored online.  Provides interface for users to manage contact details and an intelligent public to staff contact system using ASP and Access. This filters enquires to staff that are in a position to help, thus helping improve communications between public and council.

·     Presswatch Web site and DMS desktop application: online news summary archive Web site built using ASP and Access. Updated daily via custom DMS distributed over Intranet developed in VB6 to manage document input process.  The DMS tracks documents written in MS Word and on completion extracts news summary text, keywords and newspaper references into Intranet archive.  Each new day’s news summaries are then synchronized with online Web site’s archive and sent via FTP, e-mail, or fax in various formats to clients with new summary subscriptions.

·     N.B. I traveled US and EU for 8 months after Industrial Placement (see Education) and completed final year of my Bachelor’s degree program, hence 1 year gap in employment history here.

IT Technician / IT Consultant

05/99-08/99

Express Personnel, Redding, CA 96002, USA

Environment: Access, ODBC, ADO, Visual Studio 6, VB6, VBA, PERL, Cold Fusion, VBScript, JavaScript, HTML, Windows NT, Crystal Reports, MS Office, Photoshop, Corel Draw, Office.

·     InterStar Networking Services (Redding, CA) Web site: Developed routines in PERL to automate the set up of server-side services.  Then integrated with existing server-side routines and ISP accounting system.  Helped save server administrator time by allowing services to be set up, and instantiated, from ISP accounting system by sending a request to Web server.  This meant no manual intervention, which eliminated problems due to missing, incomplete, or inaccurate service set up.  Automated ISP services included: Web site space, POP and other e-mail accounts, aliases and many more.

·     The ISP accounting system: there were known bugs in existing system used for tracking customer accounts, services and automated billing. Fixed all known bugs along with other issues found in logic of SQL and functionality of some screens.  Extra functionality and managerial querying added, including set up of invoicing via postal system and email, more intuitive filtering system for intelligent querying and others to make the Office Manager’s job more efficient.  Used VB6, Access, Crystal Reports, a custom file template to specify the layout, format, variables and text of email invoices and statements.

·     North Valley Bank Web site: Worked with head Graphic Designer to develop site in FrontPage.  This included several meetings with the Managing Director and Branch Executive over lunch to discuss site’s purpose.  Being a major customer it was also desirable to enquire on any improvements that can be made to InterStar’s services, thus getting idea for redesigning monthly statements and set up of invoicing on ISP accounting system.

·     E-commerce site debug and Web site graphic design: used Cold Fusion to debug and correct problems in existing site and add extra functionality.  Developed some graphics and simple animations for sites being working on.  Used Abode’s Photoshop and Corel Draw to create these images.

·     Checked accounting company’s computers were year 2000 (Y2K) compliant (Red Bluff, CA).

Programmer

07/98-04/99

Robbins (Marine) Ltd., London, UK

Environment: Access 97, ODBC, Jet, ADO, Visual Studio 6, VB6, VBA, Windows 98, MS Office Automation, Office 98.

Developed custom hotel management and marketing tool used by independent hotels. This was a complete back office system for receptionists to book rooms (intelligent search suggested best rooms for client type), log information, and track costs incurred (including integration with phone logging systems).

The managerial part meant intelligent booking based on past performance, useful graphs and tables on efficient running of hotel and use of advertisements (Web site brought in majority of guests, especially from abroad).

Printing, faxing and e-mailing incorporated to save time for receptionists.  A highly selective mailing list was developed to pinpoint key customers, which could automatically e-mail, fax or print out newsletters to send to previous guests.

Separate database to store all valid UK postcodes to date meant as receptionist enters a guest’s postcode address appears and house number is all that is required to complete address.

Call logging system data stream received from switchboard analyzed to gain knowledge of interface between switchboards and PC. Call logging data used to bill guests and itemize hotel’s outgoing calls by incorporating it into system database via ActiveX control for receiving external ANSII streams.  Unique format of call logging system data streams stored in Comma Separated Variables (CSV) type files to integrate with other hotels using system.

        Links

 

Full professional experience, work history, achievements, and portfolio of work available at:

·      ITArchitectOnline.com

·      LinkedIn.com/in/jstoops (see references)

·      oDesk.com

·      LeafDev.com

        Education

 

Colorado Technical University Online

2005-2006

·     Completed first 2 courses of the MSM Business Management program.

·     Accredited by the Higher Learning Commission and a member of North Central Association.

·     Gained a 4.0 GPA on all courses completed (e-Business Strategies and Leadership) but stopped to work full-time at Confi-Chek, Inc.

 

University of Plymouth

2001-2002

 

·     Certificate for successfully completing a software development project.

·     Government subsidized program for companies in Cornwall provided Nuera Ltd. 50% of salary.

 

University of Bournemouth

1996-2000

 

·     B.S. (Hons), Software Engineering Management

·     Accredited by British Computer Society with year in Industrial Placement (see Experience).

·     Specialized in: Artificial Intelligence (AI) and Distributed Object Computing.

·     Other subjects: Requirements Engineering, Software Design, Development & Implementation, Systems Architecture, Databases, Computing Law, Mathematics, Human-Computer Interaction, Business Management, and Accounting.