Data Sql Server

COVER LETTER

Sir or Madam,

I wish to submit my vita for the contract to perm Software Development position you recently posted on ComputerJobs.com (http://www.computerjobs.com/E6eLg). I am a software engineer, systems architect, administrator and data manager with two decades worth of experience in web based applications most of it using open-source LAMP technologies. While I do not have direct experience with Magento or the Zend framework underlying it, I have extensive experiennce with all of the other technologies listed and I am sure learning Magento will not prove difficult. My previous work has involved :

Middleware/Controller (PHP Applications Development)

Expert LAMP application development with OO and procedural PHP. (Also Perl if needed)

Familiar with the internals and management panels of both Drupal and Wordpress as well as a variety of MVC frameworks such as Cake.

PHP code and server tuning for optimal application performance

Familiar with a variety of third-party Web Service APIs such as Amazon (AWS), Google and others. Experience integrating third-party WSs into large PHP applications.

Experience with the production of XML (preferred) and JSON (less so) objects for serialization of application states and transfer of information including in forms compliant with ISO standardized schemas or DTDs

Experience programming and managing web services for serving XML, JSON and application specific data in a RESTful manner. Includes work with Node.js on server side.

Experience creating and protecting API libraries to guide the development and future expansion of middleware code.

Diligent observer (and, if need be, enforcer) of correct procedures and guiding principles for the development of good, useful and reusable OO code.

Interface/View Development (HTML, XML, CSS, Javascript)

Guru level understanding of HTML, DOM, related Markup Languages and their protocols, including HTTP. Limited experience with HTML 5.

Experience with client side programming and automation with AJAX using Javascript and the jQuery library. Limited familiarity with single-page app development with Angular and React and Node.js.

Fluency with CSS and experience producing correctly ordered series of integrated style-sheets as well as in-line tweaking of individual scripts or pages. Experience producing templates for a variety of frameworks.

Detailed understanding of the DOM.

Experience programmatically accessing, manipulating and producing XML documents with XSchema and XQuery.

Basic understanding of Android and Android studio. Reasonably good understanding of the production of mobile HTML applications and the programming and release of shell-applications for all major hand-held platforms to correctly request, size and handle mobile HTML Apps.

Database/Model Design, Development and Administration

Conversant in all major RDBMS (MySQL, Oracle, SQL Server, Postgres). Expert at the administration and optimization of their server applications and the enforcement of best data practices.

Decades of experience writing, tuning and optimizing complex queries, procedures, triggers and other functions with SQL, T-SQL and PL-SQL.

Proficient tuning and optimizing SQL queries for each different server and flavor of SQL.

Expert OLTP design skills including schema design and data normalization.

Developed numerous Model level APIs through the use of procedures to allow separate and safe development between application levels.

Experience with data-scrubbing and data-loading, programing of ETL scripts and data-pipelines with Perl as well as automated web-scrapping and the production of data mash-ups. (Decades of experience programming Perl applications)

Familiar with OLAP Schema design and Data Warehouse development, loading and administration on Oracle and SQL Server. Familiar with some of the OLAP tool sets for Oracle and SQL Server. Experience with dimensional computing using Perl with specialized, scientific MDDS.

Geographic information coding, production and storage with Postgres. (for service via LAMP(+Perl) applications)

Limited familiarity with object and xml database systems as well as open-source big-data systems and their tool sets (Mongo and Hadoop.)

Familiar with data analytics methodologies and visualization tool sets. Experienced with Neural Network development and data mining.

Linux Server Administration and Programming

Decades of experience with Unix/Linux configuration and administration including scripting, automation, disaster recovery and virtualization.

Apache installation, configuration, optimization and administration including direct programming of the HTTP and related Protocols.

Webservice programming with SOAP, RPC, WSDL, RSS, SAX and over HTTP (RESTful)

Linux Security including Selinux, Key & Certificate management, VPN management, user accounts management

Socket and application gateway programming in C.

Server configuration, optimization and automation with shell scripting and Perl applications.

Installation and management of Physical and virtual NAS and D-NAS systems including networking, security and RAID configuration.

General Coding Practices

Long experience using and enforcing correct OO practice in software production and management.

Extensive experience using Agile and other RAD development methodologies in a variety of different settings.

Implementation and enforcement of full lifecycle management best practices and procedures for code.

Experience using and administering a variety of Project management tools (too many to list) including probably a dozen or more GANNT based applications and an even greater number of communication and collaboration tools.

Familiar with too many IDEs to list. My favorites tend to be pretty simple (vi, Komodo). The rest tend to be IDEs designed to support a specific framework or language (VisualStudio, AndroidStudio) or open-source favorites associated with particular user communities (Eclipse).

Extensive experience both using and managing software versioning and control packages including SourceSafe, CVS, SVN and (my favorite) Git.

Varying degrees of familiarity with related MVC type architectures including ASP/.Net and Java Struts. Also familiar with a number of legacy architectures including Perl CGI. Also know the Oracle Web Toolkits.

Recent experience with Blockchain application development primarily Etherium using Solidity on the Truffle/Mist/testrpc/web3.js stack. Have also worked with the BitPay API for apps using Bitcoin Wallets on Android.

In addition to my technical qualifications, my work history will show that I have also held numerous leadership, client-facing roles overseeing projects and budgets. This includes experience managing project time-lines, developing and producing unambiguous project specifications to support development and testing, implementing and enforcing programming and testing standards as well as overseeing full-lifecycle software development best practices.

If you have any questions, please feel free to contact me at any time. I am free to relocate anywhere in the Atlanta area and can travel on short notice. I can provide references as needed upon request. I look forward to hearing from you.

I look forward to hearing from you,

-Ed Robinson

706-***-**** / *************@*****.***

RESUME

Edward A. Robinson

706-***-**** 255 Deerfield Rd, Bogart, GA 30622 *************@*****.***

Data Management and Analysis; IT Architecture Design, Maintenance and Security; Software Engineering – Full Lifecycle Design, Development and Management.

Education

B.A. Linguistics and Cognitive Science, Brandeis University

M.A. Cognitive Science and Linguistics, University of California, San Diego

C. Phil. Cognitive Science and Linguistics (A.B.D.), University of California, San Diego

Technical Skills

Database Developmnt & Administration: SQL, T-SQL, PL-SQL; Procedure programming, Query Tuning, Database Administration, Database Development, Database Programming for Oracle, Postgress, MySQL & SQL Server; OLTP Database Design & Normalization to Form 6; OLAP Schema Design, Data Warehouse Development & Implementation; ETL script programming; Experience developing propriety NoSQL systems; Limited familiarity with MongoDB, Hadoop, Object and Meta-data based DBMS.

Data Analytics, Algorithmics and Practical A.I. Practical experience developing and using Neural Networks, Genetic Algorithms, HMMs in data analysis; (PDP++, Emergent, HMMER (also Excel add-ons Xlpert, NeuroXL, Ayuda, Tiberius); Expert system design and development; Data Warehouse Visualization and Mining (MAS, ODM).

XML Programming & Meta-Data Management: Programatic parsing, manipulation and generation of documents using DOM, XPath, & XSD (Schema); Programmatic interface and automation development using RPC, SOAP, WSDL, RSS, SAX often meeting REST standards via HTTP calls. Experience developing DTDs, Meta-data standards maintained: ISO 19115, ISO 19115-2, ISO 19139, Darwin Core (Z39.50 /ISO 23950)

PERL Programming, Data-scrubbing, Data Scrapping, ETL scripting: Extensive experience developing ETL scripts, Webscrubbing, Data Extraction, Data Parsing and Bulk Data Loading scripts, modules and objects with PERL. Full pipeline (multicomponent) development with error-checking and flagging for customized runs. File types include raw Oceanographic and Genomic data files from a variety of sources, XML and raw text data from scientific databases (often queried directly via webservice), student records from disparate systems, medical records from disparate systems and raw scrapped webpages. Automation of data-push and data-pull to related websites/services. Intimately familiar with a large variety of CPAN modules. Experience optimizing scripts and objects for optimal performance.

Dynamic Website Programming: LAMP/PHP/Javascript; Familiar with numerous PHP based frameworks including Wordpress, Drupal and Cake; Customized MVC application design and development with MySQL, PHP and Javascript. PHP Application tuning and optimization; Integration of LAMP applications with third-party web services; CGI with Perl and C-shell (full CGI e-commerce application hand-coded in Perl); Oracle Web Server PL/SQL cartridge (OWA package) applications.

Web Frontend Design & Development: HTML, HTML5, CSS, Javascript, AJAX, Jquery, Familiar with a wide variety of graphics applications including the Adobe Suite.

Unix/Linux Systems Adminstration, Installation, Configuration & Security: C-Shell scripting; Basic system, file and acount management; Automation of basic server routines; Apache, Tomcat, Oracle, MySQL administration. Specialized HTTP, SMTP, TCP/IP, FTP, applications programming; Systems security implementation and maintenance including firewall configuration (iptables/nftables), account management, Selinux administration, security monitoring; VPN management and administration (OpeConnect, OpenVPN); File, Disk and traffic encryption using SSL, TLS, SSH, SMIME, PGP, Crypt and custom developed systems for service via RPC using a wide variety of cryptographic suites; Key/certificate management; NAS design, instalation, security and maintenance using LDAP, RAID, DRAID, iSCSI; System and application integration with cloud based resources including AWS, Google, Carbonite, Dropbox and others. Traffic Anonymizing using Tor.

Bioinformatics Programming: Cluster Computing with a variety of Bioinformatics tools including BLAST, BioPerl, Pfam, EMBOSS, SignalP, TmHMM, Mummer, BLAT, Interpro, RepeatMasker using a variety of databases including GenBank and other NCBI databases, EMBL and TIGR; Bioinformatics website development using GUS and Gbrowse

Blockchain Development: Etherium, Solidity, Truffle, MIST browser, testrpc, web3.js, node.js, Bitcoin API, BitPay API, Metamask, Oracilize.

Microsoft, ASP, COM, COM+, VB, VBA, Visual Studio, .Net, Prototyping with MSAccess

Java Applications Development: Java, Android Studio, Eclipse, Tomcat with Struts

Code & Project Management Tools: SourceSafe, CVS, GIT; Deep understanding of OO, MVC and other coding practices. Experience using and implementing a variety development methodologies including Agile, Rapid and Rad. Experience developing, documenting and maintaining the integrity of published APIs and coding standards.

Work History

Currently Active Projects:

Treichel Media - Started a media publishing company to release content developed over the past two decades. Development of business included development and implementation of all programmatic production methods and websites.

ShareMaker – Etherium based blockchain application for creating, trading and tracking shares in small start-ups, partnerships, coops and jointly owned properties. Developed using NodeJS and Solidity with the Mix IDE for for a private etherium network supported by client/user/company maintained nodes.

Gnized – Android application for sharing of household data in real time using STM messaging for the automatic, real-time synchronization of shopping lists, todo lists, schedules and other household documents.

Data Manager, ECOGIG (University of Georgia) 2012 – 2014

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).

Developed LAMP based application to collect, proof, archive and manage raw oceanographic data sets.

Built and administered servers and RAID NAS devices (over iSCSI network) to run applications and store data.

Developed standardized spreadsheets for collecting field meta-data and laboratory analysis data.

Developed PHP applications to automatically generate ISO 19115-2 standard XML meta-data.

Developed PHP applications to query and submit raw data and XML data to major scientific databases (primarily GRIDC) via restful HTTP web services.

Supported all other IT activities including developing ancillary websites in Drupal.

Architect, Programmer, Linneaus Guides 2010 - 2012

Founded a company to produce searchable hand-held 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 enhanced 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.

Website developed using CakePHP.

Commissioner, Athens-Clarke County Government, 2009 - 2012

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. Ran for only single term.

Founder & Owner, Sudz Laundry, 2007 – 2011.

Started, developed and ran an internet based business offering pick-up, delivery and automated payment of laundry and dry cleaning services to UGA students and others in the Athens, GA area. Responsible for all aspects of the business including IT development and management.

Scientific Computing Specialist, Dept. of Genetics & Center for Tropical and Emerging Diseases, University of Georgia (Aug. 2004 – July 2006)

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 OO 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, Clarke County Board of Education (Oct. 2001 – Apr. 2004)

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, Apartmentguide.com (Oct. 98 – Aug. 01)

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, Paracelsus Software; March 98 – April 2000

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, SQL-Server, VBA, MSAccess, MS Excel and MS Word Templates. Software was used by the Emory Hospital Dermatology Department for a number of years.

Internet Developer, MCI March 1997 – Sept. 1998:

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.

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, The Fitnesszone (May 1996 – Oct. 1997)

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, Lithonia Lighting, March & April 1996

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 - The Southern Company (Oct. 1995 – March 1996)

Hired by the Southern Company as primary intranet programmer to develop their pilot intranet and demonstrate its potential usefulness.

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 of VirtUs – U. of Georgia; June 1994 – Sept. 1995:

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.

Other Employment History:

V.P. Finance & Partner, Yeasty-Boyz Inc. (D.B.A. The Normal Brew Shop, Prince Ave. Athens GA.) April 1999 – 2001.

Founder/Owner - Earmarked Productions, June 1995 – 2000.

Co-founder COGLING network. April 1992 – June 1996; June 1999 – July 1999.

Adjunct Research Associate, University of Georgia, March 1995 - March 1996.

Instructor (Faculty), University of Georgia, Sept. 1993 - March 1995.

Visiting Researcher, Max Planck Institute, Nijmegen, Netherlands, fall 1991.

Graduate Research Assistant, Distributed Cognition/Cognitive Engineering Laboratory (Donald Norman, Lead), Department of Cognitive Science, UCSD, June 1990 - Sept. 1991.

Teaching Assistant, UCSD, Sept. 1988-June 1990; Jan. 1992-June 1993.

SDSU Foundation Researcher, Naval Ocean Systems Center, Code 444 (machine translation project), San Diego, CA, April - Aug. 1988.

Laboratory Technician, Dept. of Genetics, University of Georgia, April - Aug. 1987.

Contact this candidate