Data Manager Resume Profile
GA
Summary
Internet software developer and systems architect with 20 years experience across a variety of platforms. Linux and Windows systems programming and administration experience. Familiar with a variety of RDBMs systems and programming languages.
Work Experience
Data Manager, Confidential
Data manager and sole technologist for a twenty million dollar, three year, oceanographic research project spread across a dozen universities in the aftermath of the Deepwater Horizon disaster arrived one year into the project . Managed collection, storage, archiving and documenting of all data produced by researchers in the lab and the field tens of terrabytes worth of data in a variety of formats and degrees of quality . Developed, implemented and enforced data policies Developed standard spreadsheet based templates for collecting data and associated meta-data from field and lab activities using Excel and LibreCalc. Designed and programmed databases primarily MySQL and Postgres and LAMP based applications for collecting, archiving, proofing and tracking raw data-sets. Built applications in PHP to automatically generate ISO 19115-2 standard XML meta-data and for submitting data-sets via web service and gridftp to various archival repositories. Designed, built and administered cluster of Centos Linux servers and RAID NAS devices to support all data activities over an iSCSI network. Managed all other data activities necessary including developing ancillary websites in Drupal.
CEO, Architect, Programmer, Confidential
- Founded a company to produce searchable handheld and tablet based nature guides. Did all design, modeling and development for beta product. Applications designed to pull together all existing scientific knowledge on living things in an easy to understand, search and use format.
- Large scale, configurable OO PERL Web Scrapping and Data Loadingapplication architecture utilizing DBI, WWW::Mechanize, HTML::TreeBuilder::Xpath, Image::Grab, Image::Magick
- OO-PHP Editing Application.
- AJAX/Jquery enhnced XHTML pages for Data Presentation.
- Android SDK and Plugin with Eclipse IDE/JAVA
- MySQL DB development and administration using MySQL workbench.
- SOAP web services using PERL SoapLite.
- Apache, Tomcat, CentOS, Ubuntu, Komodo, SVN, SQLite
Commissioner, Athens-Confidential
Designed and ran successful campaign in a competitive general-election race to represent a district of 16,000 constituents on a board of 10 commissioners and one mayor. Broad legislative and management responsibilities including oversight of general budget in excess of 100 million along with numerous multi-million dollar capital contracts.
Founder Owner, Confidential
Started, developed and ran a small business offering high-end laundry and dry cleaning services with a business plan developed around a IT an e-commerce front-end with social-media marketing. IT infrastructure was developed using Quickbooks POS integrated into an Access Backend. Backend interacted with an e-commerce HTML 4.0, with SSL ordering system integrated with phone based texting. Marketing managed though automated campaigns using Google Adwords, Facebook and Twitter.
Scientific Computing Specialist, Dept. of Genetics Center for Tropical and Emerging Diseases, Confidential
- Hired to produce a number of brand-new whole genome databases for a series of apicomplexian protists class 2 bio-terrorisim threats This required developing both a complete Perl pipeline for accessing scientific databases, running bioinformatics applications and loading the data into a complex data model running in Oracle and developing and MVC front-end for querying the databases. Primarily responsible for developing backend data loading applications.
- Developed a complex set of O.O. backend applicatons and data pipeline in PERL for loading numerous scientific data sets in a variety of formats into a multi-schema oracle database CPAN Modules used included: BioPerl, XML Simple, XML Twig, DBI
- Installed, tuned and supported Oracle Backend. This included significant work using Autotrace and Oracle Hints to tune very SQL queries as well as some PL-SQL programming. Installed and configured Oracle Dblink for data federation with external data sites. Database schemas based on the Genomics Unified Schema GUS1.0 .
- Java/Struts MVC frontend running on Apache/Tomcat used for data queries and display.
- Wrote XML-RPC based Java web services via Tomcat for data sharing between applications.
- Supported an old database that used flat tables and mod-perl to answer web queries.
- CVS source control used by multiple sites. Wikis used to coordinate discussions and planning.
Systems Analyst, Confidential
- Hired as systems analyst to move the entire data infrastructure of a school district with 12,000 students in 21 schools from an AS400 server to a Microsoft based system running on multiple servers and terminals.
- Exporting, scrubbing and loading of data from AS400 mainframe to incompatible SQL Server database supporting SASIxp tables and application infrastructure
- T-SQL procedures, MS Access Applications and VB Module programming of support applications using new SQL Server database.
- ASP active server pages web front-end to SQL Server for real time data queries and reports.
- Evaluated OLAP systems for a future Data Warehouse of all student and school records.
- Established system wide best practices for staff using system.
Sr. Internet Developer, Confidential
- Hired as main programmer to transition a print company ApartmentGuide to a web format. Promotted to Senior Internet Architect and development team lead for version 2.0 and 2.5 releases.
- Version 1.0: Designed application architecture to meet a 2 week release schedule for a radically late project. Programmed ASP to Oracle via ADO 2.1 migrated to 2.5 on NT 4.0 search pages with Perl application for static page generation. Other technologies: Mapquest, Accipiter AdBureau, Dart Doubleclick, ASP Mail, ASPUpload, PL/SQL stored procedures in Oracle 8i on Solaris. SQL Server on NT 4.0 for logging. Client-side page scripting in Javascript. Primary IDEs: Interdev, Visual Studio, Visual Modeler, Visio and Visual SourceSafe.
- Version 2.5: Led 5 programmer team designing and programming a 3-tier DNA application using an ASP front-end and VB COM middle-tier running in MTS on NT 4.0 along with Visual C caching objects. Production data was Oracle accessed via Merant SequeLink. Responsibilities included defining the OO interface and Object architecture Object Modeling , documenting all APIs and Object Models, as well as application and server tuning and configuration. Also helped design a Visual Source Safe usage policy and archive structure.
- Version 2.5: Helped lead the movement towards a .Net architecture. Work included using the Microsoft XML Parser and converting some of our cached data into XML as well as designing a prototype XML DTD to lead all XML based initiatives. Migrated all VB Com objects in MTS to COM on Windows 2000. Mail applications re-developed using MS CDO. Other: Designed and programmed new leads system using NT scheduler launched VB COM EXEs going against SQL Server 2000 to create queued print jobs for a fax server. Wrote TSQL procedures and PL/SQL procedures using SQL-Plus and Procedure Builder to keep the SQL2000 database synchronized with the Oracle 8i production database. Some report generation from SQL Server and Oracle. Helped design data models of application components. Some support of an online transaction system written with the PL/SQL cartridge in Oracle 8i.
Sr. Vice President for Development, Confidential
Started a software company with three friends including 2 doctors in dermatology to maximize billing, perfectly match documentation, reduce workload, automation Worked with dermatological surgeons and dermatology practices to design an application that used scanned forms to simplify doctor descriptions of their procedures. Responsible for analyzing problem, selecting technology and executing solution including all data modeling and programming. Application was developed to using Teleform scanner software to load data into a highly normalized SQL server database. This database fed a VBA application built for Office 97 using MS Access connected to SQL server as the front end to manage all records and to generate all of the billing and documentation using MS Word Templates. The application successfully created maximum billing levels with full documentation while eliminating the need for transcription services. However, the use of paper scan forms as the form of input proved to be a sale physicians wanted hand-held devices . Application proved to be 10 years ahead of the available technology.
Internet Developer, Confidential
Hired to move contract billing services reporting and product databases to an online format for ease of use, speed of updating and accuracy of contract negotiation and billing for large client contracts. Most of the data was stored in Oracle databases so I designed and developed Oracle Web Applications using the Oracle Web Applications Server OWAS , primarily with PL/SQL and the PL/SQL web packages HTP, HTF and OWA now the PL/SQL cartridge in the new OWAS . Primary development tool was SQL-Plus. Some data modeling. General Intranet development including Javascript enhanced HTML pages and PERL CGI scripts running on a UNIX-based Netscape Enterprise Server. Some small, local databases supporting specific contracts were developed in MS Access so I had to enable intranet access to these data stores using a number of PC-web gateways including DB-Web and IDC/HTX paired files. A couple clients also requested near-real time reports of usage data so I prototyped a JAVA thin-client CORBA compliant using Power-J development tools for securely storing confidential data in PDF format stored in an Oracle backend and accessing it from the internet through three layers of firewall.
Developer Webmaster, Confidential
Hired as sole technologist for an early e-commerce site to market and sell high-end fitness equipment online before any shrink-wrapped applications for e-commerce were available. Primary application written in PERL using CGI with an S-HTTP switch for secure transactions. Catalog and shopping-cart ran off of a CVS type data file. HTML layout and basic graphic manipulation in Adobe Photoshop and Illustrator. Experimented with RealAudio. Scripts ran on off-site hosted UNIX servers running Solaris. Also: UNIX based SMTP services, Excite for Webservers search engine, Unix Shell Scripting in C-shell and Bourne-Shell for site maintenance and monthly logging. WebTrends for detailed monthly reporting and LinkBot for link maintenance. Managed all Internic DNS registration about 12 domain names and Verisign certificates. Evaluated Open-Market Transaction Server and ICAT Commerce Server. Did early SEO work testing page layouts, keywords and other items to ensure our rankings in Yahoo, Alta Vista and other early pre-google search engines.
Intranet Consultant, Confidential
- Hired on contract to develop demonstration projects to help Lithonia Lighting determine how to move their documents and procedures to an intranet.
- Ported RoboHelp documents to HTML
- Converted MSOffice Templates to CGI forms.
- Developed a CGI gateway in VB to run on Purveyor early MS webserver to query Access and other ODBC compliant databases
- Configured Windows NT server to provide corporate forms and quarterly reports via TCP/IP over a Windows NT network using Internet Explorer ver 1.0 as a file query client.
Intranet Consultant - Confidential
- Installed and configured first generation Netscape servers directory and access policy to allow individual departments to develop their own intranet sites.
- Created numerous CGI forms in PERL pre mod-perl for a variety of corporate services including an online version of the entire corporate directory online integrated with SMTP. Also developed a number of other form templates for internal use.
- Evaluated, installed and deployed early website administration tools including link checking robots e.g. MOM Spider , WAIS and search engines Excite
- Some basic shell scripting for administrative and reporting purposes.
- Asked to make a number of important corporate databases hosted in Oracle available over the internet. Development used early Oracle-to-web gateways including W.O.W. and OraPERL. Most work done with Web-Oracle-Web Gateway W.O.W. which was all Pro C source code. Tuned configuration and make files and compiled PRO C source files. Wrote connect strings to query various databases in the Southern Company WAN. Wrote PL/SQL procedures to return query and results pages in HTML utilizing the HTP and HTF packages.
Designer Programmer Confidential
Designed and developed a text based, virtual university to support the teaching of Freshman composition at the University of Georgia. VirtUS was intended as both a pedagogical and a research tool, allowing me to collect protocol data on the cognitive processes underlying composition and writing. The application was designed to be easy to modify for research needs. It was written in C LP-C variant utilizing a MUD server running on a Solaris workstation . This application also supported other internet services including Gopher, Usenet, Lynx, FTP and SMTP.
