Providing hands on Cloud Solution Architecture, Strategic Planning, Management, Design and Development in these areas: + Data Architecture - OLTP, OLAP, STAR Schema, Spark RDD, Dynamic schemas using JSON + Data Engineer - Stored Procedures, SQL, Python, Perl, Shell, (Learning Scala) + Database - Oracle, MySQL, PostgreSQL, Greenplum, Redshift, Spark-SQL, Hive, HBase + Technical Product and Project Manager - including strategic planning and roadmap design + Data Services Director / Manager Software + Oracle, MySQL, PostgreSQL, Teradata, Greenplum, Redshift, Hadoop, Hive, HBase, Cassandra + PeopleSoft, Maximo, MES, CMM, Historian, Salesforce, Trizetto Facets, Documentum + SQL, PL/SQL, Perl, Python, Shell, Pig, Scala + Tableau, Business Objects, Pentaho My current specialty is extracting data from SQL RDBMS and file sources into Redshift on Amazon AWS and via S3 for files and using a combination of Pentaho PDI and Python. In the last year it has been 100% Redshift, Greenplum, Hive and Hive and SparkSQL on the analytics side of the stack, and I create both static structured tables as well as JSON based Dynamic Schema based tables. I am most interested in companies who are making a firm commitment to Spark. I feel that Spark will finally make the Hadoop Stack go "mainstream" and accessible to so many who have been waiting on the sidelines. I am especially interested in the near real time and batch aspects of building data pipelines. Please request CV for full details - if the opportunity is in the San Francisco or SF East Bay area.

Data Architect / Engineer / TPM (Contract) @ Conducted 4 "Industrial Internet" Proof of Concept projects including strategic planning, design and implementation phases and delivered: + Train Fault Event management tracking working with train fault sensor data (Python and Greenplum) + Power and Water Event Data Management (Hadoop, Pig and Hive) + Brilliant Factories manufacturing event data and MRP data correlation for process improvement (Python and Greenplum) + Contract risk assessment parsing legal contracts to assess risk (Python and Greenplum) From February 2015 to Present (11 months) Senior Project Manager @ Managed $500K budget for Cordell's Climate Change scientific expedition and mission to Heard Island, a sub antarctic island and Australian possession. The project web sites are here: http://heardisland.org/ and http://vk0ek.org/ + Raised $500,000 funding for this non-profit by writing proposals and project plan + Created multi-channel marketing program + Assembled team of scientists to participate + Assembled international support team in Australia, South Africa and the US + Built satellite internet based network and IT infrastructure to support the project + Built social media presence and web site to drive awareness of the project + Assembled and worked with corporate sponsors + Planned executed logistics to ship equipment From August 2013 to Present (2 years 5 months) Director of Customer Support @ + 100% Cloud / Cloudera Hadoop / AWS environment + Set up Zendesk, Twilio and an off shore telephone technical support staff to provide Splice Machine customers with 24 x 7 "always on" technical support. Hired technical support staff + Worked on projects to certify Splice Machine for Pentaho BI/PDI, Tableau and Microstrategy. + Created Splice Machine database clusters, Hadoop / HBase clusters, Oracle Database, MySQL and and Redshift Data Warehouses on Amazon AWS + Designed schemas and applications on Splice Machine. + SQL, Stored Procedures and Jython From August 2013 to February 2015 (1 year 7 months) Senior Data Architect @ + Created a draft Data Governance Program + Established Evolutionary Database Design (EDD) and Continuous Integration + Evaluated several Big Data / NoSQL technologies MongoDB, HBase, Cassandra and Neo4J + Designed a re-factored Product Catalog database model From September 2012 to August 2013 (1 year) Principal Data Architect @ + 100% in house Cloud (multi - tenant) environment + Saved Lithiums aging Data Warehouse by multi-threading Pentaho ETL and sharding MySQL + Created a Product Roadmap + Evaluated Hadoop / Hbase, SAP HANA, VoltDB, Infobright, Teradata Aster, LexisNexis HPCC, Greenplum, MapR, Sisense Prizm, AWS, Datameer, Karmasphere, BitYota KDS and EdgeSpring. From November 2010 to September 2012 (1 year 11 months) Lead Data Modeler, Developer and Data Architect @ + Delivered a highly modified Teradata "FS-LDM" logical and physical data model + Wrote ELT routines to load data from 7 data sources + Cross trained the technical team and documented all data flows and data models From July 2007 to November 2010 (3 years 5 months) Senior Oracle Data Architect and Developer (Contract) @ + Designed, coded and documented a multi ­ threaded ETL system using PL/SQL and SQL*Loader + Migrated all Norwest Bank Internet Banking (WIB) customer's scheduled transfers to Wells Fargo From July 2006 to July 2007 (1 year 1 month) Senior Trizetto FACETS Engineer and Data Architect @ + Architected, designed and coded custom Oracle database applications + Became a domain expert with Trizetto FACETS. + Developed Web applications development using PHP, Perl, PL/SQL and shell From July 2003 to July 2006 (3 years 1 month) Director of Database Services @ + Lead Oracle DBA and Data Architect reporting to V.P of Engineering. + Built Marketing Reporting Database System and Data Mart using Oracle8i Designer and + Launched Leapfrog.com website, using ATG Dynamo 5.1, Oracle8i 8.1.6, Solaris8, Red Hat Linux 6.2, Javascript and Java/JHTML; + Designed site fail over and backup and recovery system using Veritas Cluster Server and Oracle Hot Backups. Hired the full Leapfrog.com site maintenance staff. + Created OPEX and CAPEX budgets for 2001. + Planned and purchased all development, staging and production hardware and software + Installed Oracle on all development, staging, and production Solaris and Linux environments. + Installed and configured Dynamo 4.5.1 and 5.1 Application Server (DAS), Commerce Server (DCS) and Scenario Server (DSS) on Linux and Solaris. + Wrote PL/SQL, Bash and SQL code for a number of projects. + Used ERWin to create database data models and generated schemas for several databases. From March 1999 to July 2003 (4 years 5 months) Data Warehouse Architect and Engineer (Contract) @ + Designed, developed, and supported an Oracle Web Data Mart called "PowerSight," an energy usage information system. + Designed and developed PL/SQL data access layer (API) for Java programmers. + Provided systems integration for several custom built Oracle Operational Data Stores (ODS), and Meta Data Data repositories. + Completed full cycle delivery of BAAN / Aurum SalesTrak Sales information System. + Implemented and supported UMS PowerLine. + Built development, test and production Sun Solaris UNIX servers (Ultra I, II, 450 and 4000) running Solaris 2.6. Built development, test and production Oracle\ Enterprise database systems on NT 4.0 server. + Provided Webmaster services for two Sun Solaris based Netscape web sites (Intranet and Internet). + Wrote Perl and JavaScript database applications. + Wrote Oracle DBA Guide, Web Site Strategy and Standards documents. + Used ERWin to create database data models and generated schemas for several databases. From December 1997 to March 1999 (1 year 4 months) Director of Data Systems @ + Planned the move of Trans Ocean Containers data center from San Bruno to Los Angeles + Designed and integrated PeopleSoft 5.01 Financials, Aurum SalesTrak 6, Raxco Helpline, EDI and Inter/Intranet applications. + Installed and supported global production and test systems. + Installed and tuned Oracle 7.3 Server on DEC Alpha 2100 and 8200 servers and Win95 and NT clients. + Migrated SQL Server applications to Oracle. + Installed and maintained MS IIS and Netscape Commerce Web Servers. + Wrote Perl5, OraPerl, Korn/Bourne and Oracle backup, recovery and failover procedures. + Wrote Oracle DBA and PeopleSoft systems guide. + Used ERWin to create database data models and generated schemas for several databases. From July 1995 to December 1997 (2 years 6 months) Senior Oracle DBA and UNIX System Administrator @ + Maintained nine IBM RS6000 C-10 servers running AIX 3.2.5, and one Sequent 450 server running Dynix/ptx 2.1.5 supporting 150 PeopleSoft HR and Financials databases. + Responsible for all hardware and software installation, including base operating system, database, network and PeopleSoft products. + Project management responsibilities included capacity planning and UNIX system administration as well as "team leading" a staff of four. + Wrote first PeopleSoft DBA Guide. From February 1994 to July 1995 (1 year 6 months) Technical Marketing Manager @ Employee #30 + Managed the communications, product and marketing collateral channel for 14 International Distributors. + Consulted with Gupta Technologies European distributors to provide a consistent technical marketing strategy. + Provided train the trainer support, especially in the area of SQL GUI application performance tuning. + Interviewed, hired and trained a startup technical support staff in London. + Provided marketing, pre and post sales support, product training and sales demonstrations. + Provided customer SQLWindows, SQLBase and SQL performance tuning consulting. From February 1988 to February 1994 (6 years 1 month) Database Administrator @ Employee #127 + Managed production and test databases on an IBM 4381 (VM). + Managed training databases and systems used for all West Coast in house training on a VAX VMS 8650. + Managed a VAX-11/750 Computer. Taught all Oracle version 3 and 4 RDBMS and Tools classes. From May 1984 to February 1988 (3 years 10 months)

B.S, Computer Science @ Lock Haven University of Pennsylvania From 1977 to 1981 Richard Holoch is skilled in: Data Warehousing, ETL, Databases, Data Modeling, Database Design, Business Intelligence, SQL, Unix, Hadoop, PL/SQL, Microsoft SQL Server, Perl, Oracle, Data Integration, Linux