Robert E Sterrett Problem Solver, Application Developer Design, Build, Integrate WEB, Client-Server, Cross-Platform ========================================================================== Expertise | Software | Platforms | -------------------------------------------------------------------------- System Design/ |ASPNet/VBNet/C#/ | NT, Win98/95/ME | Implementation/Integration/ |ASP/JavaScript/ | Win 2000 Server | Support |VBScript/HTML/DHTML | Advanced Server | Biz-to-Web |VB/FOXPro/Access/ | IP Integration | Data Integration/ |SQL Server/Exchange/ | Other: Solaris/SCO | Portal Support |COM/DCOM/ActiveX/MTS/ | | Client/Server |JAVA Servlets/Applets/| | |C/C++ (some time ago) | | |XML/BizTalk/ | | |Remote Scripting/ | | |Remote Data Services/ | | ========================================================================== formatted versions of this resume-- www.novares.com/novaweb/presume8.doc word document www.novares.com/novaweb/presume8.pdf pdf version or visit www.novares.com and select the resume option ========================================================================== Skills/Expertise: Professional Experience: Consulting April 1999-Present Americans for Democratic Action, Arlington County, VA, Dayton Power & Light, Global Y2k Consortium, Intl. Boundary Commission, Dept. of State, FDIC, IntoTheNet.com, Premier Inc., Trust Building Associates, Universal Services and Assistance Corp, Mid-Atlantic Group Psychotherapy Society, USAID Membership System -- Rewrote DOS based application (which I wrote in 1985) as a Windows and WEB app using VB6.0, VBNet, C#, ASP, ASPx and Com/DCOM. The system maintains member records, supports solicitations and member communications via mail, email and the WEB, and enables lobbying at national and grassroots levels. Implemented SharePoint Team Services for intra-office communication. Implemented SPAM filtering on the Exchange 2000 Server. Supported are WhiteLists, BlackLists, IP Source rejection and key word filtering using regular expressions. Incoming statistics are collected. Individual items may be enabled/disabled and logged. Corporate Time an Attendance Worksheet (CTAW) -- Extensive DHTML and browser model interaction to create a time capture tool for 6,500 desktops and detached workstations. Generalized poll module for websites. http://www.adaction.com/test/strawpoll.asp Helped Premier, a woman-owned 8a company update, maintain, and extend the Small and Disadvantage Business Utilization (SADBU) web site for the Army (http://www.sellingtoarmy.info/). Added a sub-site to present forecasts of small business work for the coming year. This is an interactive site with search capabilities. On the main site, reduced maintenance by using a back-end database to eliminate 50+ static pages. Created links for the client to do direct data entry reducing transcription errors and reducing the time required to get changes implemented. Created dynamic PDF (http://www.novares.com (demo)) and RTF (http://www.novares.com/sadbu/poc/pocreport/testfle.rtf (sample)) reports. Participated in the preliminary design of a system to connect a BtoB marketplace to the payment engine of a major bank. Hardware includes F5's BigIP, Compaq's 8 way servers, and EMC's storage framework. Software includes Windows 2000 Enterprise Server, IIS5, MSMQ, SQLServer, Visual Basic, and MTS. Prototyped the https/XML interface for the front-end. http://novares.com/xmlsend.htm. Test and evaluation of MSMQ2.0 on Windows Advanced Server. http://novares.com/MSMQ (IE5 required) Building a standardized address list for Arlington County with cross-references by people and property. Updating some files for this long-time client. http://www.internationalboundarycommission.org/ Developing a web monitoring system for the entelligence Power Monitoring network (http://www.waytogo.com). This process does end-to-end testing of the system and sends pager and email notification of failures to designated personnel. http://novares.com/novaweb/dpl.htm Y2K Emergency Infrastructure Reconstitution System (USAID) -- Participated in the construction of a system to fast-track Y2K problem remediation for 3rd world countries. This system matches problems with funding sources and contractors. Automated workflow with web-based interfaces, PKI signatures on forms, email notification yielded problems to solutions paths in as little as a week. Heavy ASP, SQL server, some VB. http://novares.com/novaweb/yeirs.htm Y2K preparedness and remediation for the developing world (USAID sponsored). Emphasizing planning for governments and businesses. Wrote Y2K help tools in Access that were distributed in 100+ countries. Organization IDEF0 diagram — http://www.novares.com/Globaly2k/orgdef/ofst.asp Download & Information page — http://www.novares.com/Globaly2k Web site — http://www.novares.com/GlobalY2K/web Sample Screens — http://www.novares.com/novaweb/y2kscreens.pdf (318k) Y2K mitigation for existing membership and donor system. Patching legacy system until new hardware and software can be installed. Built a Windows 2000 server running Exchange 2000. Implemented Text-to- Speech support for help, error reporting and instruction over the intranet (http://www.novares.com/test/dubyaquotes.htm (demo)). Initial web presence, www.universalassist.com Converted aging Win3.11/Novell network to Win98/NT. Updated procedures for the new system. Converted Access 2 software to Access 7. Corporate Phone Book --- www.novares.com/bscripts/corphne.asp On-line Survey Processing --- http://www.novares.com/novaweb/surveyproc.htm Built a couple of web pages. — www.novares.com/trustbuilding Houston Associates Consultant February 1998-April 1999 US Electronic Grants Project/National Partnership for Reinventing government -- Updated the Java applet based front-end for entering grants information to the pilot database. Incorporated new screens using Swing classes, added servlet based reporting, and repackaged the project for the two major browsers (Verisign and Thawte code signing). Database connections (oracle) were through the Active Works messaging system. Application Integration -- www.novares.com/bscripts/cie.asp -- Using event brokering techniques, disparate applications are linked through JAVA wrappers and adapters. A general framework of components is being developed to support rapid connections between programs, objects, and databases on any platform that supports a virtual JAVA machine. The package contains graphical interfaces for design (Visio), deployment, and control (ASP, DHTML, VB, MTS, JAVA). The system supports demo, test, and production environments. The project combined commercial software (ActiveWorks), JAVA applets and applications, server and client side web programming (VBScript, JAVAScript), Visual Basic and MTS to produce a scalable integration environment. Network Integration & Monitoring - Supporting DARPA's Leading Edge Services (LES), Houston Associates is charged with maintaining facilities to support both classified and unclassified demonstrations of software being developed to support the War Fighter. Working as a consultant to Houston Associates the Empire SystemEdge SNMP agent software was installed on SUN and NT machines. HP's Openview, custom VB programs, and other net management tools were used to assemble and display the data from the workstations, ethernet and ATM switches, and routers to assess the suitability of current hardware for the new generation of training and planning tools. Also installed SNMP on Win95 and Win98 machines. National Federation of Clinical Social Work Societies Consultant February 1998 Office Automation Support Mid-Atlantic Group Psychotherapy Society Consultant February 1998 Directory Publishing — http://www.novares.com/directories.htm LAM Enterprises Consultant Aug 1997 to January 1998 Replaced a stolen 13 giga-byte NOVELL server with an NT4 system with 18 giga-bytes of storage. Set up internal networking, an internet presence — ( www.lam-ent.com ) and e-mail for this South Florida military exporter. 486 workstations were updated to Pentiums. Office 97 and Internet explorer 4.01 were chosen to support LAM's data and communication requirements. Data systems were re-written to use Active Server Pages, allowing controlled access and update to the 10 million data records supporting LAM's clients. NetMeeting was used to support video conferencing internally at LAM, and between LAM and work sites in Turkey and Nicaragua. DATABASICS, Inc. Senior Systems Analyst. Dec 1995 to August 1997 WebMaster- Set up corporation's first NT server, WEB server, WEB site, mail server, and database server. Subsequently upgraded the site to NT 4.0, IIS3, and SQL 6.5. The site has been the development host and the major selling vehicle for the company's Enterprise-wide (WEB, ODBC, and mail) time and and expense collection products. Used dbWeb, PERL, and Visual Basic to develop CGI interfaces. Developed animated GIF's, sound, and other elements to promote the site. Recent emphasis has been on Active Server Pages, Active Documents, com and dcom interfaces to back-end databases. Integration and support of the American Institute in Taiwan's automated accounting effort. Brought hardware (NT servers in Taiwan and Arlington, VA connected by a 56k line) and accounting software together to track the income and expenses of our embassy in Taiwan. Maintenance and extension of the ExpenSite module using PowerBuilder and PowerSoft WEB extensions. Prepared the system for install (InstallShield) and provided customer support. Provided pre-sales and sales support and conducted demos for the TimeSite/ExpenSite systems. Developed documentation and usage instructions using Pagemaker and Abobe Acrobat. Budget pre-processing for Interealty Corp. Rationalization of operating unit budgets (96 and 97) using Visual Basic coding within Excel spreadsheets. Results fed to HP-9000 based corporate accounting system. CBMI, Inc. Systems Analyst. June 1995-Dec 1995 Object oriented design and analysis of a list management and distribution system for a major mailing house. Maintenance and modification of text retrieval and management system for Dept. of Education's state-level reporting system (SQLbase). Preliminary design of a replacement system for Dept. of Education's Contractor Resource System. Maintenance and operation of Kaiser Permanente's distributed At-Risk Mothers Tracking System. (SQLbase). Maintenance and extension of American Anthropological Association's FoxPro membership, subscription and meeting management system. NOVA Research Associates. President 1984-1996, Vice-President 1980-1984. Provided computer consulting, training, and support to a variety of clients—ADA, DCCC, US Dept. of Commerce, Planned Parenthood, US State Dept., Xerox, DC govt., GAO, etc. File Management, Database Design & Modeling, Decision Support, Marketing Information and Executive Information Systems design and development. Forecasting, profiling, targeting for direct marketing. Large NOVELL server systems. GAO LAN Performance study. Collected and analyzed data via NetVision and VigiLAN for several servers, multiple LAN links. Advertising tracking system for small newspapers. Database publishing. Tracking system for State Dept. resettlement loans. Congressional vote tracking. FEC reporting, donor and membership list management, PAC management. Four million record parts database on an AT in 1984! Routine processing of 38 million records on tape using an AT. Immigration amnesty program. Hospital equipment inventory. Expense management for a lobbyist. DC taxicab fare study. School lunch survey analysis. Subscription fulfillment. Preparation for submission to NGS of survey data defining the US/Canadian Border including computer generated maps. System to process business license delinquencies (Arl. Co.) Identify sales tax cheats (CA.) Daycare management (Ft. Myer.) Drug sales tracking. XENIX/SBT/FOXBASE order taking system. Fraud Prevention Department text database (KWOC). Proprietary grant application scoring program used to evaluate over 400 proposals for OJJDP in 5 separate competitions. DOS training, dBASE training, course development. (Smithsonian, XEROX). Dept. of Commerce. IRM support. November 1993. Supported 100 NTIA computer users while their regular IRM manager was on vacation. Maintenance and extension of the grants system for National Public Radio (FoxPro). Softrac America. Director, Client/Server Applications. March-June 1993. Supported start-up mail-order sales firm with list management and business-to-business marketing analyses. XCEL Computer Services. Director Microcomputer Applications. November 1991-October 1992. Maintained and extended a client/server decision support system for Gevalia coffee. Direct mail solutions and analysis for several Fortune 1000 companies. Office support for Intl. Boundary Commission, Planned Parenthood, David Vienna and Associates, LAM Enterprises, Public Voice, etc. Newsletter setup & support. News wire capture for Catholic newspapers. Copy protection for mini-cassettes on FLUKE PC analyzer. Voice recognition using the DRAGON board. Blackstone Data Services/Associates. President/Senior Systems Analyst, Computer Consultant. 1977-1980. Data management for youth opportunity program (CETA nationwide.) Training management system for Va. State Police./Sheriffs. Fiscal and performance management of Sports Directions Summer Youth program. Management and supervision of several large data entry/acquisition projects providing efficient and accurate service to DC employment Commission, DC Summer Youth, Youthwork, etc. NASTRAN analysis of COMSAT model 'C' earthstation. Trade calculations, Special Trade Rep. (OTP.) 1978 WIC survey, analysis and table production. 1978 OCR survey, file design and report production. ELSEGIS survey processing. Processing of Natl. Guard accession and continuance data (RAND.) Statistical analysis of Job Corps entrance and exit data. Evaluation of future Vehicle Identification Number schemes (CA DOT.) Cross cultural survey processing - Taiwan, Nepal, Maharastra, Gujurat, Sri Lanka, and Malaysia (World Bank.) Analysis of Navy 3M system (AMS.) RAC/General Research Corp. Member, Technical Staff. 1973-1977 Analysis of Army accession and retention data, AFEES entrance exams, Gilbert Youth Surveys. Creation of a large model projecting the number of qualified military availables by county. Small farmers surveys - Costa Rica, Guatemala, Chile, Paraguay, and Kenya (AID.) Analysis of lending objectives and School achievement data (World Bank.) Processing of Army Surgeon General alcohol abuse surveys. Forecasting via regression, auto-regressive supply functions, and biased estimators. OSHA/BLS accident data processing and analysis. Designed and supervised implementation of 16 programs for satellite circuit analysis for COMSAT. Benchmarking and cost analysis of internal procedures to support contract claims. The Hendrickson Corp. Programmer/Consultant 1969-1973 Data processing support, JEC, using census, public use samples. Support of Gary Income Maintenance experiment. Analysis of data from Trenton experiment. Housing management surveys, (Urban Inst.) On-site at HEW supporting women's work force analysis (Marshall Wood.) Preliminary analysis of training and riffing component for MPS360 model of military manpower. Job Corps PPBS (Fair-Isaac). Input/output model of New York State (Natl. Planning Assoc.). Survey analysis, courtship and marriage study (NIMH). Medical College Aptitude test scoring. Project management/manpower tracking. Aircraft acquisition cost model (WSAO). CAB cargo survey processing (ATA). Systems Research Corp. Associate. 1968 Gaming and threat analysis in support of the DXGN nuclear guided missile frigate ship development plan. Expected value model of helicopter losses at fortified landing zones. CPFF Time & Billing tracking. Electron Physics Laboratory (U. of Mich.) Assistant Research Mathematician. 1966-1968 Computer modeling of high-energy amplifiers, plasma devices, and solid-state materials. Supported PhD candidates in thesis work, doing numerical analysis and graphic displays using FORTRAN, MAD and UMAP. Bendix Aerospace. Programmer. 1965 Computer simulation of rocket hardware, trajectory analysis, arms control calculations, computer gaming, structural analysis of Lunar Lander, moon rover. Most work was done in FORTRAN on a Bendix G-20, later CDC G-20. Education: BS Rose Polytechnic Institute (Math, Physics) 1964 Math Courses University of Michigan 1966-67 Sociology Courses George Washington University 1968 Professional Skills: ?Win2000 Server, Advanced Server, NT 4.0, 3.5 ?Windows XP, 2000, 95, 98, 3.x ?UNIX SCO/Solaris ?IBM mainframes (OS, MVS), CDC Cypher, Univac ?NOVELL, LAN MANAGER ??SP,ASPX, HTML, DHTML, C, Visual C++, c#, FORTRAN, ASM, Visual BASIC, VBNet, VBscript, VBA, JAVA Servlets/Applets, JAVAScript, PL/I, PASCAL ?COM/DCOM/MTS/ActiveX/ ?dBASE, Visual FoxPro, AREV, DataFlex, Informix SQL, ESQL, SQL Server, SQLWindows, SQLBase, Oracle, ErWin ?PC's ?SPSS, SAS ?System Integration, IP integration ?Distributed Systems, BIZTALK, SOAP, XML ?Remote Scripting/Remote Data Services/ ?Website development, design & maintenance Professional Skills: ?Accounting systems ?Database design, modeling, development ?Publishing, Database Publishing ?Econometric modeling ?Mathematical modeling ?Membership maintenance ?Manpower analysis & forecasting ?Simulation of physical systems ?Statistical analysis ?Survey processing Training: two week course on Template Enterprise Integration Technology (now part of Level8's Geneva system) 2842 Dover Lane, Suite 202 Falls Church, Va. 22042 (703) 849-9656 www.novares.com bob@novares.com