IT Executive with expertise in the design and delivery of cost-effective, high-performance technology solutions in support of rapid growth with budget responsibilities up to $12 million annually. Skilled in all phases of the project life cycle, from initial feasibility analysis and conceptual design through implementation and enhancement. Effective at building culturally diverse, team-centered operating units, with excellent business process and strategy development skills. Customer-centric with the ability to initiate profitable alliances with global vendors and suppliers.
Specialties: Strategic & Operational Technology Planning, IT Infrastructure Design & Implementation, Technology & Business Linkage Planning, Sensitive Global Voice/Data Telecommunications, Global IT Delivery & Data Center Operations, Emerging Technologies & Enterprise Architectures, Capital Planning & Investment Control, Technology Architecture & Integration, IT Skills Gap Analysis & Performance Optimization, Master Data Design for Big Data Models, Cloud Based Infrastructure Models
CTO @ We are trying to make the next big thing! From November 2014 to Present (1 year) Miami/Fort Lauderdale AreaVice President of Engineering @ Direct all Software Mobile Web Development, Data and Business Intelligence resource planning, and development budgeting for this million+ user, 100+ employee, global television network. Hold autonomous decision-making authority for all Web and Software Development, Business Intelligence and Data development and innovation, with a focus on system integration, emerging technologies, enterprise architectures, strategic alliances and data security. Report to the President.
. Architected and Implemented a Node.js web application as a website.
. Creation of Dynamic Response Mobile Web Applications which are supported on multiple browsers Windows, OS X, iOS and Android as a Suite of Node.js Admin Tools including a Social Media curation tool and a Custom CMS.
. Architected and Implemented a Node.js REST based API.
. Architected and Implemented a Service Oriented Architecture based in Node.js, Redis, MongoDB, SQL Server on AWS that is completely Scalable globally on a moments notice.
. Led development of the TV Everywhere of a live television network using Adobe Pass to Authenticate with Time Warner Cable and Comcast.
. VOD player that is adaptive streaming for all VOD playback and can accommodate external video sources such as YouTube
. A 2 Way video chat in a Google Hangouts LIKE session over the Website to a TV Studio’s LIVE Broadcast. 16 people at once to date.
. An Over the Top, Neflix Like, subscription product and service on the Web and at least 9 platform specific apps.
. An iOS and Android app with TV Everywhere authentication for live TV Steaming as well as VOD playback.
. An Mobile feature a 2 Way video chat in a Google Hangouts LIKE session over the Website to a TV Studio’s LIVE Broadcast. This has never been done on mobile before.
. Digital Ads Serve integrated API for web and Mobile.
. Built our own Push notification service for both iOS and Android.
. Created a Federated Authentication and TV Anywhere Authentication Single Sign-on solution (SAML). From July 2013 to November 2014 (1 year 5 months) Hollywood, CA@ @ From June 2011 to July 2013 (2 years 2 months) Greater Los Angeles AreaSr. Director of Engineering, Hosted Services @ Hired to turn a desktop client software engineering company into a SaaS based Big Data and Business Intelligence company. Held autonomous decision-making authority for all levels of enterprise architecture, operational design, data center expansion, product development, data security, strategic alliances and innovation. Manage 9 direct reports and 47 indirect reports in 4 global locations while giving direction to Product, Sales, Marketing and Operations. Report to the CTO.
• Designed and led the development of a Master Data driven API/Service Layer SaaS product which was core to the new business model moving toward Big Data before the term was invented, costing $4 Million in 10 months to return $5 Million per month.
• Created an operational infrastructure in 2 different data center locations to support a SaaS modeled business with implementation of hardware and software in a project plan requiring 12 months to deploy and succeeding in 8 months.
• Spearheaded the project and design of using Amazon’s AWS EC2 services as the new Cloud based architecture of this Big Data SaaS product which was ahead of its time and implementation happened 6 months after when Amazon’s pricing model made the change cost effective saving the company $2 Million annually.
• Generated revenues in excess of $4 Million annually by implementing a web-based API and Analytics platform to provide customers with data from the web in a timely and meaningful method.
• Hired and created departments for Operations, QA, Engineering, Product, Project Management, Negotiated vendor contracts and developed a relationship with 3 offshore vendors for development of the new products. From May 2010 to June 2011 (1 year 2 months) Director of Data Services @ Managed the data engineering and operations for 50,000+ users SaaS based Financial Services e-mail archiving company. Developed the annual budget, implemented process models. Created and mentored a 16 person SaaS Operations team. Creation of assessment programs and then mapped them against planned milestones for operations and engineering.
• Partnered with Microsoft and 3Par in order to create cost savings in space management of large amounts of data saving the company $1 Million annually.
• Conducted a needs analysis to determine application requirements for both domestic and international user communities, resulting in the creation of new products adding $500,000 annually.
• Designed and implemented a new LAN/WAN architecture as part of a global design and disaster recovery model required by clients and FINRA.
• Implemented an operational model giving 24 hour, 7 days a week, 365 days a year support while minimizing the impact on the lives of employees. From March 2009 to May 2010 (1 year 3 months) Director of Data Services @ Directed all data, database, business intelligence resource planning, budgeting, operational and development for a 500+ person startup in the world of internet based television advertising as well as online advertising. Served as Architect and principle liaison between technical analysts, developers, sales personnel and the company’s non-technical client base. Managed a team of 8 direct reports.
• Integrated all data into a Globally unique data warehouse giving business intelligence to a local television advertising product. From April 2008 to March 2009 (1 year) Director of Data Technologies @ Developed software, processes and data designed to integrate survey data into one uniform and centralized format for consumption. Managed a team of 7 direct reports.
• Architected and managed the development of a $4 million Internet based application to drive business intelligence and understanding in the world of IT resourcing and hardware spending for IBM. From November 2006 to April 2008 (1 year 6 months) Sr. Database Architect @ Development of SQL Reporting Services 2005.
Transactional Replication design and implementation for SQL Server 2005 from Oracle to SQL.
Database Architecture/Administration/Design/Implementation for new Software.
Database Design and implementation of SQL Server 2005 databases for applications.
Database Modeling and Design and implementation of Stored Procedures, Views, Normalization, Performance, Optimization and Referential Integrity.
Design and implementation of backup/recovery schema.
Design and implementation of Disaster Recovery plan.
Data Migration from SQL to SQL Server 2005 using Complex DTS Packages.
SQL Server DBA including performance monitoring and tuning, synchronization, backups, restores, and alerts.
Administration, Development, and Implementation of Onyx in a SQL Server environment.
.NET development of for Reporting Services. From May 2006 to May 2007 (1 year 1 month) Sr. Database Architect @ Database Development for Stored Procedures and Views in SQL Server 2000.
Database Development in a Great Plains environment. From May 2005 to November 2006 (1 year 7 months) Sr. Database Architect @ Database Architecture/Administration/Design/Implementation for new Software.
Database Design and implementation of SQL Server 2000 databases for applications.
Database Modeling and Design and implementation of Stored Procedures, Views, Normalization, Performance, Optimization and Referential Integrity.
Design and implementation of backup/recovery schema.
Design and implementation of Disaster Recovery plan.
Data Migration from SQL to SQL Server 2000 using Complex DTS Packages.
SQL Server DBA including performance monitoring and tuning, synchronization, backups, restores, and alerts.
Administration, Development, and Implementation of Onyx in a SQL Server environment.
.NET development of database applications.
VB 6 and .NET development and support of integration applications From March 2006 to June 2006 (4 months) Sr. Database Architect @ Database Architecture/Administration/Design/Implementation for new Software.
Database Design and implementation of SQL Server 2000 databases for applications.
Database Modeling and Design and implementation of Stored Procedures, Views, Normalization, Performance, Optimization and Referential Integrity.
Design and implementation of backup/recovery schema.
Design and implementation of Disaster Recovery plan.
Replication Architecture, Design, and Implementation.
Data Migration from Access and SQL to SQL Server 2000 using Complex DTS Packages.
Working with ASP/XML/VB developers for design and implementation of data entry database design.
SQL Server DBA including performance monitoring and tuning, synchronization, backups, restores, and alerts.
Complex DTS Packages for Data Migration and Transformation.
Working in a Semi Extreme Programming Environment.
Use of ERwin for Data Modeling and Design. From December 2005 to May 2006 (6 months) Sr. Database Architect @ Database Architecture/Administration/Design/Implementation for new Software.
Database Design and implementation of SQL Server 2000 databases for applications.
Database Modeling and Design and implementation of Stored Procedures, Views, Normalization, Performance, Optimization and Referential Integrity.
Design and implementation of backup/recovery schema.
Design and implementation of Disaster Recovery plan.
Data Migration from FoxPro to SQL Server 2000 using Complex DTS Packages.
Working with ASP/XML/VB developers for design and implementation of data entry database design.
SQL Server DBA including performance monitoring and tuning, synchronization, backups, restores, and alerts.
Complex DTS Packages for Data Migration and Transformation.
Working in a Semi Extreme Programming Environment. From November 2005 to January 2006 (3 months) Sr. Database Architect @ Database Architecture/Administration/Design/Implementation for new Software.
Database Design and implementation of SQL Server 2000 databases for applications.
Database Modeling and Design and implementation of Stored Procedures, Views, Normalization, Performance, Optimization and Referential Integrity.
Design and implementation of backup/recovery schema.
Design and implementation of Disaster Recovery plan.
Data Migration from FoxPro to SQL Server 2000 using Complex DTS Packages.
Working with ASP/XML/VB developers for design and implementation of data entry database design.
SQL Server DBA including performance monitoring and tuning, synchronization, backups, restores, and alerts.
Complex DTS Packages for Data Migration and Transformation.
Working in a Semi Extreme Programming Environment. From May 2005 to November 2005 (7 months) Sr. DBA/Architect @ Replication design of a 1000 Node Merge Replication Environment.
Database Architecture/Administration/Design/Implementation for new Software for Pet Hospitals.
Database Design and implementation of SQL Server 2000 databases for applications.
Database Modeling and Design and implementation of Stored Procedures, Views, Normalization, Performance, Optimization and Referential Integrity.
Design and implementation of backup/recovery schema.
Design and implementation of Disaster Recovery plan.
Data Migration from FoxPro to SQL Server 2000 using Complex DTS Packages.
Working with ASP/XML/VB developers for design and implementation of data entry database design.
SQL Server DBA including performance monitoring and tuning, synchronization, backups, restores, and alerts.
Complex DTS Packages for Data Migration and Transformation.
Working in a Semi Extreme Programming Environment.
Use of ERwin and Rational XDE for Data Modeling and Design. From December 2004 to May 2005 (6 months) Sr. Consultant/Sr. DBA/Architect @ Consultant at Hollywood Ent. as a Sr. DBA/Architect.
Database Architecture/Administration/Design/Implementation for new Software for Video Stores.
Database Design and implementation of SQL Server 2000 databases for applications.
Database Modeling and Design and implementation of Stored Procedures, Views, Normalization, Performance, Optimization and Referential Integrity.
Design and implementation of backup/recovery schema.
Design and implementation of Disaster Recovery plan.
Working with ASP/XML/VB developers for design and implementation of data entry database design.
SQL Server DBA including performance monitoring and tuning, synchronization, backups, restores, and alerts.
Complex DTS Packages for Data Migration and Transformation.
DTS Packages for Migration from Oracle 9i environments.
Working in a Semi Extreme Programming Environment.
Data investigation with PL/SQL using PL/SQL Developer and Oracle Enterprise Manager.
Use of ERStudio for Data Modeling and Design. From June 2004 to November 2004 (6 months) Sr.SQL Server DBA/Architect @ Database Design and implementation of SQL Server 2000 databases for websites and applications in an N-Tier environment.
Database Modeling and Design and implementation of Stored Procedures, Views, Normalization, Performance, Optimization and Referential Integrity.
Data Marts for reporting.
Disaster Recovery plan including redundant replication.
DTS Packages for Data Migration.
Working in a Semi Extreme Programming Environment.
Crystal Reports Development in Version 8.5 and 9.
Database creation and implementation in a SAN environment of Tera-Data size. (1.2 Terabytes)
Use of Erwin and System Architect for Data modeling.
Onyx on a SQL Server 6.5 platform.
Great Plains on a SQL Server 6.5 platform.
JD Edwards Database Administration.
Development of E.piphany AP reporting on version 5.0.
ASP and ASP.NET Development on SQL Server 2000.
Visual Basic and Java Script Development. From February 2002 to June 2004 (2 years 5 months) Sr.SQL Server DBA/Architect @ Database Design and implementation of SQL Server 2000 databases for websites and applications in an N-Tier environment.
Jr. Oracle DBA duties for performance on Sun Microsystems and Oracle 8i.
Database Modeling and Design and implementation of Stored Procedures, Views, Normalization, Performance, Optimization and Referential Integrity.
Transactional/Merge Replication.
Failover Clustering for SQL Server 2000.
Data Marts for reporting.
Disaster Recovery plan including redundant replication.
SQL Server DBA including performance monitoring and tuning, synchronization, backups, restores, and alerts.
SQL Server security for a Web/Database design with SQL Server and Windows 2000 Server.
Design and implementation of automated tasks to cellular phones for text messaging of alerts.
Documentation of SQL Server Environment.
DTS data into data marts and to clean up data.
DTS Linked server to Oracle.
IIS Implementation and Administration.
COM+ Administration. From November 2001 to March 2002 (5 months) Sr. SQL Server DBA/Architect @ Database Design and implementation of SQL Server 2000 databases for websites in an N-Tier environment.
Database Modeling and Design and implementation of Stored Procedures, Views, Normalization, Performance, Optimization and Referential Integrity.
Transactional/Merge Replication.
Data Marts for reporting.
Automation of maintenance and performance tasks.
Backup/recovery schema.
Disaster Recovery plan.
Working with ASP/Java/HTML developers for design and implementation of data entry database design and reporting structures.
Design of Project Plan for Database Design and implementation for Website Driven Database structures.
SQL Server DBA including performance monitoring and tuning, synchronization, backups, restores, and alerts.
SQL Server security for a Web/Database design with SQL Server and Windows 2000 Server.
Design and implementation of automated tasks to cellular phones for text messaging of alerts.
DTS data into data marts and to clean up data. From August 2001 to September 2001 (2 months) SQL Server DBA @ SQL Server DBA including performance monitoring and tuning, synchronization, backups, restores, alerts, creation of disaster recovery methods, and creation of databases.
Database Design and Data Modeling including Referential Integrity, dependencies, stored procedures, triggers and maintenance plans in an N-Tier environment.
Database enhancements for Web designs in an E-Commerce company.
Database Optimizations for an Internet Company in an E-Commerce business.
Worked with Cold Fusion and Java.
Development of a Web ordering/purchasing database system.
Testing/Development of a web based Application Database in an E-Commerce Environment.
Data Manipulation for internal application development.
SQL Server 7.0 and 2000 testing.
Working with Microsoft IIS and MTS.
Datawarehousing using E.piphany version 4.0.
Crystal Reports development and repair.
Visual Basic application development for data maintenance.
DTS data into data marts and to clean up data. From August 2000 to April 2001 (9 months) SQL Server DBA/PeopleSoft Admin @ SQL Server DBA including performance monitoring and tuning, synchronization, backups, restores, alerts, stored procedures, creation of disaster recovery methods, and creation of databases.
PeopleSoft Administration including installation, implementation, support, applying fixes, applying upgrades, creation of process scheduling creation and administration of 3-tier environment, for both Financials and HR.
PeopleSoft Tools used were SQR, Nvision, and Crystal Reports.
Progress DBA.
GrainSMART Administration.
Marcam Product Administration.
LIMs LabSys Administration.
Crystal Reports repairs.
Database Design and Data Modeling for Support/FAQ helpdesk application.
Creation of applications in Visual Basic 6.0 for use with other 3rd party applications.
Creation of SQA scripts for SQA Robot for testing and Data Entry.
Creation of Access 2000 Reporting Databases.
Experience with COM and COM+.
DTS data into data marts and to clean up data. From May 1999 to August 2000 (1 year 4 months) SQL Server DBA/NT Admin @ From November 1997 to February 1999 (1 year 4 months) Software Test Manager @ From August 1997 to October 1997 (3 months) SQL Server DBA and NT Admin/PA @ From March 1997 to August 1997 (6 months) SQL DBA/NT Systems Admin @ From August 1996 to March 1997 (8 months) Systems Analyst/Tester/Jr. SQL DBA @ From May 1995 to June 1996 (1 year 2 months) IT Support @ From May 1994 to January 1995 (9 months)
None @ Washington State University Grant Koeneke is skilled in: Big Data, Business Intelligence, Databases, Data Warehouse..., Data Management, Data Analysis, Data Mining, Data Modeling, Database Administration, Master Data Management, Database Design, Relational Databases, Analytics, Software Engineering, Start-ups, Report Writing, Oracle, Analysis Services, Data Cubes, MongoDB, Hadoop, Node.js, Microsoft SQL Server, Executive Management, Engineering Management, Data Marts, Master Data, Database Development, Relational Data Modeling, Dashboards, SQL Server, PostgreSQL, DB2, OLAP, Snowflake, Star Schema, PowerPivot, MS Integration Services, ETL Tools, NoSQL, Enterprise Architecture, IIS, SQL, Cloud Computing, .NET, Software Development, Integration, SQL Tuning, SOA, Disaster Recovery
Websites:
http://www.GrantDKoeneke.com,
http://www.klique.com