Patrick Strittmater's Location
Phoenix, Arizona, United States, United States
Patrick Strittmater's Contact Details
Patrick Strittmater work email
- Valid
- Valid
- Valid
- Valid
Patrick Strittmater personal email
n/a
Patrick Strittmater phone numbers
About Patrick Strittmater
Patrick Strittmater is a Senior Data Engineer at Block. He possess expertise in business intelligence, microsoft sql server, microsoft office, leadership, agile methodologies and 36 more skills. He is proficient in Spanish.
Patrick Strittmater Work Experience Details
-
Senior Data EngineerBlockPhoenix, Az, Us -
Senior Data EngineerSecond Dinner 2024 - PresentIrvine, California, Us -
Senior Data EngineerTatari 2021 - 2024San Francisco, California, Us -
Data EngineerAmazon 2019 - 2021Seattle, Wa, Us -
Data EngineerBlizzard Entertainment 2017 - 2019Irvine, Ca, Us• Developed and implemented multiple Apache Spark production applications in Java and Scala, and scheduled and monitored with Apache Airflow• Enterprise Application development using Maven, Jenkins, and Artifactory• Streamed 7M+ Overwatch records daily in real-time from Kafka, classified with TensorFlow Serving model and output to RabbitMQ queue using Apache Flink• Consumed 7M+ Overwatch records daily and 1M+ Heroes of the Storm records daily from Hive, classified with TensorFlow model and output to Hive for analytics and KPIs using Apache Spark• Sessionized 20M+ login records daily for Business Intelligence Hive data warehouse using Apache Spark -
Associate Data EngineerBlizzard Entertainment 2016 - 2017Irvine, Ca, Us• Architected, designed and implemented ETL and modeled data marts (using star schema framework) in the Business Intelligence Teradata data warehouse for multiple Blizzard organizations• Reduced World of Warcraft ETL runtime from 12 hours to 50 minutes and improved uptime from 50% to 99% by utilizing ELT, parallelization, and consuming data from REST API for static dimensions• Reduced Customer Service ETL runtime from 4 hours to 20 minutes and improved uptime from 70% to 99% by utilizing ELT and parallelization
-
Developer ConsultantExsilio Solutions 2014 - 2016Irvine, Ca, UsDesigned, created, implemented, and maintained massive data warehouse with over 50 data sources. Led project to create and implement data warehouse and corresponding cube, along with custom Excel reports and dashboards, for Microsoft Finance BI team. Facilitated creation of ad hoc reports. Created numerous ETL solutions, utilizing stored procedures, dynamic SQL, and parameterized and data-driven SSIS packages. Implemented backend procedures for data process flow: parallel optimization, auditing, and reporting. Experimented with predictive analytics machine learning processes, including supervised and unsupervised learning, to research implementation for client.• Increased throughput on BMX by lowering duration of ETL by roughly 40% via parallel optimization• Created SQL utility and automation tools and packages to facilitate development and troubleshooting• Created and maintained fully automated DW and cube• Built proof of concept for predictive analytics using Python scikit-learn -
Application DeveloperPacific Life 2013 - 2014Newport Beach, Ca, UsCollaborated with application and business analysts, technical leads, and other internal customers to validate application and business requirements. Provided analysts business reporting solutions utilizing SSRS. Data integration and ETL via SSIS. Implemented Master Data Services to streamline data management for non-transactional data. Worked closely with technical leads, DBA’s and IT Management to troubleshoot and resolve production issues for reporting, data applications, and ETL processes. Utilized TFS for development source control. Multiple code deployments to numerous environments. Integrated SQL Server with Mainframe and DB2 systems.• Dynamic SQL and complex coding implementation for custom applications.• Production Support – on call for multiple systems.• Achieved 100% completion and customer satisfaction• Led and engaged in frequent customer-facing meetings and presentations. -
Business Intelligence ConsultantElevano Consulting 2013 - 2013Newport Beach, Ca, UsBI Developer - ICU Medical - San Clemente, CAWorked on Business Intelligence team to develop internal BI Solution for Sales, Ops, and Finance departments. Experience with ETL from Oracle ERP system into cube through ODS and Data Warehouse (Data Marts) layers. Writing, testing, and debugging complex SQL queries for data integration and cleansing. Experience with master data management, using Microsoft Master Data Services (MDS) 2012. Familiar with building advanced hierarchies, both parent-child and ragged.• Microsoft SQL Server 2012: Management Studio, Integration Services, Analysis Services, Reporting Services (SSIS, SSAS, SSRS)• Operated utilizing agile (scrum) methodology with Team Foundation Server (TFS)• SharePoint dashboard creation with KPI's for business analysts• Testing and debugging ETL processes and cube -
Technical EngineerLaserfiche Sep 2012 - Dec 2012Long Beach, California, UsTroubleshot issues with the Laserfiche software suite: either by instructing over the phone or via web meetings, as well as working solo via VPN. Installed the Laserfiche suite on servers and client computers for customers. Implemented the Laserfiche suite for customers, including building workflows, troubleshooting, testing, and customizations for automated processing. Requirements gathering: planned infrastructure and hardware requirements for customers.• Proficient in Microsoft SQL Server 2008: database creation/deletion, migration, and backup; SQL queries• Kanban team: agile methodology for smaller customer installations, implementations, customizations, and upgrades through teamwork• Training program: achieved proficiency with network fundamentals, specifically TCP/IP and client-server model• 100% of customer support cases completed by SLA deadline• Developed positive relationships with customers due to daily interaction and excellent customer service skills -
Us Naval OfficerUs Navy 2011 - 2012Washington, Dc, UsUS Naval Aviation Training Program:Trained and prepared to be US Naval Aviator by taking various engineering, weather, and navigation courses, followed by numerous flights in Naval Training Aircraft.Lead Ensign:Coordinated, administered, and managed over 300 students and their schedules at world’s largest Naval Aviation Training Command. Delivered daily and weekly briefings utilizing PowerPoint to teams of at least 20 officers at a time. Organized groups of officers, ranging from entry to senior level, and planned numerous events and formal ceremonies. Arranged, structured, and scheduled watch bill that consistently involved management of 30 new officers per week.• Developed rapport with customers while solving a high volume of customer service problems: both internal and external issues revolving around pay, military duties, quality of life, scheduling, and public relations• Consistently met and exceeded customer service goals• Outstanding leadership and management skills developed
Patrick Strittmater Skills
Business Intelligence
Microsoft Sql Server
Microsoft Office
Leadership
Agile Methodologies
Data Warehousing
T Sql
Sql
Ssis
Etl
Management
Java
Python
Object Oriented Languages
Databases
Data Analysis
Master Data Management
Troubleshooting
Customer Service
Public Speaking
Training
Ssrs
Tfs
Ssas
Crystal Reports
Spotfire
Tableau
Hadoop
Hdfs
Hive
Apache Pig
Mapreduce
Big Data
Big Data Analytics
Analysis Services
R
Data Mining
Machine Learning
Statistics
Predictive Analytics
Microsoft Excel
Patrick Strittmater Education Details
-
United States Naval AcademyHistory -
University Of California, Irvine Division Of Continuing EducationData Science Certificate
-
UdacityMachine Learning Engineer Nanodegree
Frequently Asked Questions about Patrick Strittmater
What company does Patrick Strittmater work for?
Patrick Strittmater works for Block
What is Patrick Strittmater's role at the current company?
Patrick Strittmater's current role is Senior Data Engineer.
What is Patrick Strittmater's email address?
Patrick Strittmater's email address is pa****@****lio.com
What is Patrick Strittmater's direct phone number?
Patrick Strittmater's direct phone number is +156247*****
What schools did Patrick Strittmater attend?
Patrick Strittmater attended United States Naval Academy, University Of California, Irvine Division Of Continuing Education, Udacity.
What are some of Patrick Strittmater's interests?
Patrick Strittmater has interest in Learning, Traveling, Exercising, Reading.
What skills is Patrick Strittmater known for?
Patrick Strittmater has skills like Business Intelligence, Microsoft Sql Server, Microsoft Office, Leadership, Agile Methodologies, Data Warehousing, T Sql, Sql, Ssis, Etl, Management, Java.
Free Chrome Extension
Find emails, phones & company data instantly
Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Aero Online
Your AI prospecting assistant
Select data to include:
Total price:
$0.00
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial