Matthew Smith, Mba Email & Phone Number

Mountain View, Ca, Us

Strategic Cloud Engineer - Data Engineer - Google Cloud Platform at GoogleProfessional Services, Data and AnalyticsAreas of focus: Data Architecture, Data Engineering, migrations, integrations, data analytics, cloud native AI/ML services Industries: Software, Telecommunications, Healthcare, Consumer Products, Financial Services, Manufacturing, E-commerce, state/local/fed govtProject Summary:2024: Projects: Data Engineering, Data Warehousing, Database Migration & ModernizationData Eng: Dataflow, GCP Infrastructure, Performance Tuning, ReplicationDatabase Migrations: Mainframe,MySQL,MSSQL,PostgresData Warehousing: BigQuery,LookerVertex AI: DocAI, Gemini2023:Projects:Data Engineering, Big Query Data Warehousing, Analytics, AI/ML integrationsData Eng: Dataflow, GCP Infrastructure, Performance TuningDatabase Migrations: AWS to GCP, Azure to GCP, OCI to GCPAWS Aurora to Cloud Spanner, AlloyDB, Postgres, SQLServerAI/ML: GCP Vertex AI service integrations, ML Ops, Airflow2022: Financial ServicesProjects: AWS to GCP: HBASE to Bigtable, Bigtable high availability, backup and DR2022: Ecommerce, Travel, Consumer Products, FinancialGCE database stabilization & performance tuning, GCP infrastructure best practicesData architecture cloud foundationsData Pipeline Architecture, CI/CD, ELT: batch, streaming, micro-batchDatabase migration from SQL Server to PostgreSQL, OLTP and EDW2022: TechnologyVMware Explore 2022 Conference: Database Migrations to GCVE: OLTP, EDW & GCP Cloud Services integration. Performance Tuning2021: TelecommunicationsProjects: Cloud Architecture, CI/CD, Database Migration to GCVE and GCE, VMware HA, Actifio, Financial Systems Interfaces, BigQuery EDW. Database Migrations, Performance TuningOther: Internal Conferences: Heterogeneous Database Migrations, Infrastructure Benchmarking, Database Performance, GCE, Migration Tooling, Data Warehousing with Big Query, Data Engineering, Legacy databases, mainframe integrations, GCVE

Round Rock, Texas, Us

EMC Global Professional Services - Consulting DeliveryData Engineering, Big Data & Analytics Solution Engineering, Software Development2020-2021:Big Data Analytics:Commercial, US Federal DODLead Solutions Architect for three net new consulting engagements resulting in > $2.2M revenue in 2020.Lead solutions architect for a Microsoft Azure Modern Data Analytics Platform: EDW, Azure Data Factory,Synapse,Azure Data Lake, DataBricks,PowerBI,Azure Dev Ops.Data Engineering: Migration from APS/PDW to SQL Server Big Data Clusters (Microsoft, Ernst & Young)Software Development-ETL Framework: Spark,Python,SQL,HDFS,Polybase2019-2020:US Federal DOD - TRMCData Engineering: EDW, HDP Data Platform,hadoop architectureSoftware Development: C# ,ELT/ETL, pythonData Engineering & Analytics: .Net C#: csv to parquet, webhdfs - windows & linux, python,hive,orc,spark,sql server,tableau,Power BIAnaconda Data Science SuiteHybrid Cloud Architecture and Integration:Azure,AWS2017-2018:US Federal DOD-TRMCData Engineering: EDW, Greenplum (MPP) development, Postgres, SQL Server, Hadoop,ETL,Kafka,Hive,ORC,Parquet,Avro,Spark,Python,TableauHortonworks: Architecture,Development,Dell EMC IsilonSoftware Development: C# ,Python,SparkDevOps: Build & Release automationSQL Server development,SSIS, ETL2017:Insurance, Healthcare-EpidemiologyData Engineering, DevOps BI and Analytics Solution:InfluxDB,Grafana,Python,JenkinsSQL Server Always On, powershell automation for HA/DRData Engineering-Immunization Analytics:Colorado Immunization Information System,C#,SQL Server2016-2017:Healthcare-EpidemiologyData Engineering, Business Intelligence, Analytics,Data Lake & EDW solutions for epidemiology including: HIV patient monitoring,outreach,careColorado Immunization Information System (CIIS). Immunization analytics (HLN ICE)Common data models for data sharing, research and grants (VDW and PCORnet CDM)Epidemiology Surveillance Reporting for tracking disease and outbreaksNSSP Biosense

Fort Collins, Co, Us

As the owner of the OtterBox Enterprise Data Warehouse (EDW) and the manager of the EDW team I was responsible for the development, availability,operations and customer adoption of the Enterprise Data Warehouse and Analytics systems in a 24/7 global business environment.• Stabilized the EDW to meet business SLAs through migrating application servers and SQL Server database servers to a new physical/virtual hybrid architecture, tuned the EDW database infrastructure and the EDW code base, database schemas, and optimized SSIS package framework.• Led a team of four including two ETL developers and two BI developers in an Agile software development environment.• Owned user story intake, backlog, and sprint planning for all incoming work from customers including Finance and Accounting, Supply Chain, Sales, Marketing, Product Development, Business Process Excellence and Customer Service.• Provided development and support services for the following software and systems: custom ELT/ETL packages (SSIS), SSAS cubes (Multidimensional, Tabular), reporting (SSRS and PowerPivot), SharePoint integrations, SQL Server 2008 and 2012. Designed SQL Server HA/DR for the EDW & OLTP.• Sourced new data sources into the EDW including CRM, Web Analytics (Google Analytics and Adobe Site Catalyst), ERP (Infor M3, Compiere, Netsuite), Call Center (Cisco UCCX, Calabrio), Oracle Agile PLM, SharePoint.• Production support, performance tuning, infrastructure design and installation for EDW including source OLTP databases. SQL Server log shipping and replication, Vmware, Microsoft Change Data Capture. • Projects: Incremental Loading of the Enterprise Data Warehouse with Microsoft Change Data Capture, Upgraded reporting and BI environments, data warehouse upgrade to accommodate an ERP upgrade to Infor M3, migrated EDW dev and qa environments to AWS EC2, added Global Reporting for EMEA and APAC subsidiaries, integrated Oracle Agile PLM/PPM implementation, added custom PX reporting interfaces

Ignacio, Colorado, Us

As a software architect & DBA I worked closely with finance, engineering and operations to develop data warehousing, analytics and BI solutions for oil and gas production, forecasting, economics and program profitability for a petroleum exploration company. • Data warehouse design and development (data modeling, ETL, SSIS, SSAS, SSRS).• Applications management, development and maintenance of custom ERP system interfaces (Enertia, JibLink, Aries, Petra, Tobin).• Development and support of internal financial reporting tools to support capital planning, production accounting and expense forecasting and analysis for onshore and offshore programs• Project management – software development projects, accounting and finance projects, ERP software & systems implementations.• Developed Analytics and BI dashboards for LOE (Lease Operating Expense) and Oil and Gas Production. • Leadership of a company-wide, cross-functional continuous process improvement (CPI) team, tasked with designing and rolling out CPI standards & processes to the entire organization. • DBA production support, data modeling, database development and business intelligence planning and development.

Durango, Colorado, Us

As COO I was responsible for finance, business operations, client profitability, proposal development and service delivery to Verde’s 20+ Outdoor Industry clients. I launched the Verde Paid Media Division to offer digital advertising, web development and database services to Verde clients.• Launched Verde’s Paid Media Division and the integration of earned, owned and paid media services• Design and delivery of integrated media strategies, kpi's and analytics• Introduced Agile development principles to internal cross-functional teams and Verde clients• Implemented accounting controls, budgeting, cash flow management, employee benefits and 401k• Business management, project management, project delivery

Cincinnati, Ohio, Us

Led and managed the MPS database team (eleven employees) at three different locations (Denver CO, Durango CO, Phoenix AZ). Responsibilities included database and systems architecture for transaction processing and business intelligence systems, database infrastructure, database design, database development, database security and support of highly-secure systems for credit and gift card processing. Projects and roles included the following:• Redefined team roles and responsibilities to segment the DBA team into development, production support and business intelligence roles.• Worked with internal departments including sales, marketing, HR, finance and accounting to define and deliver business intelligence services including merchant demographic data and financial reporting.• Worked closely with the QA department to create database code testing processes.• Worked closely with IT Development teams to assess infrastructure for new database systems.• Designed a model and project plan for the separation of business and production data through auditing and reverse engineering databases and applications. • Led a security audit project to document database security, identify permissions and risks, created end-user classifications, and realign security with the appropriate roles.• Interim IT Operations Manager (concurrent role). Led 16+ IT operations employees to support infrastructure, engineering, software release and production support

Ignacio, Colorado, Us

Led professional services teams to design and implement technology solutions for the Southern Ute Growth Fund's sixteen+ businesses. Businesses industries include oil and gas (upstream and midstream), real estate (residential and commercial), private equity, mining and construction materials.• Worked directly with business unit presidents, controllers and executive directors to maximize technology investment and drive success of enterprise-wide IT projects. • Managed a team of seven including software developers, DBA’s and business analysts.• Supported core financial systems and applications including application use, upgrades, security, interfaces, reporting, budgeting & licensing.• Led the database design of software applications including a natural gas plant accounting system.• Designed and code general ledger interfaces from financial applications to Peoplesoft 8.4.• Implemented Microsoft Office Sharepoint Server 2007, developed multiple internal web applications for various businesses, managed ERP system implementations for Growth Fund businesses• Led the implementation and support of numerous software applications including: Microsoft Sharepoint 2007, ESRI ArcGIS 9.2, Tobin, Cygnet Scada, Command Alkon, Timberline and custom in-house web and VB.net applications.

Golden, Colorado, Us

www.BikeParts.com : Entrepreneur/Small Business Owner. Authored and executed business plan for an ecommerce bicycle parts and equipment business, selling 30,000+ products online globally with over 100,000 retail customers. Led development of Ecommerce systems (.Net), web applications, database platforms and vendor integrations. Designed & managed all Internet marketing initiatives (sem,seo,paid,organic) . Developed relationships with suppliers and company partners including Specialized, Giant, QBP, BTI. Business management including accounting, sales, finance, operations.

Boston, Massachusetts, Us

Managed the development and support of ecommerce platform (.Net, Java, C#) for Sports Express, a travel logistics company. Responsibilities included development and maintenance of ecommerce sites and internal business applications, management and mentoring of junior developers.• Designed and developed a SOAP XML API (EasyShip) to allow partners to place orders directly into the Sports Express ecommerce system.• Managed a team of five including three college software development interns.• Led Microsoft Commerce Server pipeline component development including a custom implementation of Sports Express Gift Cards.• Led all SEM initiatives including SEO and paid advertising.

San Diego, Ca, Us

Managed, coded and supported all Intranet and Internet sites for Wireless Knowledge (a Qualcomm, Microsoft startup).• Developed and maintained corporate web sites, www.wirelessknowledge.com, and internal web applications and databases (SQL Server, MS Access).• Integrated ASP/.Net/SQL Server ecommerce applications with JD Edwards.• Worked with marketing and product development teams to define business requirements, document process and information architecture, and develop applications to meet those requirements.• Designed and managed search engine registration program for corporate site and product sites.

Colorado Springs, Colorado, Us

• Designed, coded and supported web (ASP/SQL) and VB6 applications for various HP and Agilent divisions. • Designed and programmed web based business software utilizing Microsoft Active Server Pages (ASP), SQL Server, HTML, JavaScript, XML, and Visual Basic for clients including Hewlett-Packard and Agilent.• Developed a custom call tracking support application (mrc.fc.hp.com) to track, manage, and report customer generated research requests from internal HP division.• Worked as SQL Server DBA and Systems Administrator for the HP Market Intelligence Center to install SQL Server 7.0, develop data models and databases, write stored procedures, and implement a backup and recovery plan.• Designed and programmed secure data transformation forms in ASP for administrators to import and export data from SQL databases and excel spreadsheets for Hewlett-Packard’s e-financial services website, myfsi.hp.com.• Developed and implemented content management systems to track and manage business documents for Agilent’s US Customs Division (gtt.agilent.com) and HP’s World-Wide part tracking team (cvs.cv.hp.com).

Professional Cyclist, competed in US National Series (NORBA) and Grundig World Cup events. 1997-1998, Team Chevy ZR2, Opportunity Management1995-1996, Team Mongoose, Service Cycle/Bell 1991-1994, Barracuda Dos Equis, Barracuda Bicycle Company1991-US National Team, 1991 UCI World Championships, Lucca, Italy

Mba, Business Administration

Ba, Finance