Travis T. Email & Phone Number

Austin, Tx, Us

Santa Barbara, Ca, Us

• Lead and drive data architecture design on a distributed infrastructure, focusing on maximum scalability for a rapidly growing organization.• Develop models in Data Build Tool (DBT) to solve business problems and create a consistent data lineage.• Train and mentor a growing BI team to develop datasets, pipes, tasks, and front end user experiences in meeting strategic data objectives and goals.• Develop components in Salesforce (Aura, Lightning Web Components, Apex) to incorporate our product and related data into the platform to operationalize it for business teams.• Research and identify Key Performance Indicators within the business and develop a means to capture them consistently.• Manage overall data infrastructure on a Fivetran, Looker, Snowflake, and Data Build Tool (DBT) technical stack.

Santa Barbara, Ca, Us

• Manage and develop functionality for a corporate data warehouse to include ELT/ETL pipes, data modeling, testing, alerting, and documentation.• Worked directly with VPs and executive leadership to design and engineer datasets and data processes that defined key metrics for account growth, product direction, churn reduction, and sales.• Design product metrics, key performance indicators, and datasets to improve access and reliability of business insights using Python, R, SQL, LookML, and Spark.• Develop apex applications in Salesforce to automate strategic goals around opportunity and quote scoring. • Develop Salesforce features. To include flows, process builders, CPQ, apex, triggers, lightning web components.• Integrate SAAS products to Cloud Marketplaces (GCP/AWS).• Design and develop unified, standardized business processes centered around rapid scaling.• Developed data warehouse auto-scaler application to dynamically meet computational needs of business intelligence while also cutting down on warehouse-related costs. Saving ~$100k/year in cloud computation and hosting costs.• Help end-users in understanding our data and BI platform. Evangelize and develop a strong data culture within the company.

Santa Barbara, Ca, Us

• Leader in total refactoring of existing corporate data warehouse into a more efficient, scalable, and pragmatic solution. • Managed and Administered company wide Data Warehouse and BI platforms using a Snowflake, Looker, AWS, and Fivetran warehouse technology stack.• Develop and refine metrics and data related processes for the sale and management of a SaaS product.• Develop datasets using data from Salesforce, Zuora, Marketo, Jira, Comm100, ZenDesk, Pendo, Gainsight, Unomaly, and internal product data.• Develop datasets, models, persistent derived tables, calculations in Looker and Python (pandas) for finance, talent acquisition, marketing, product usage, internal operations, sales, sales operations, company operations, and customer success/experience.• Developed billing dataset saving 100+ hours a month in preparing monthly billing for clients.• Developed in house ETL solution saving over $1M/year in ETL costs within a AWS/Snowflake data stack.• Improved product usage metrics exposing ~$50k/month in unsecured revenues lost to data inefficiency.• Experienced in using AWS to include IAM, EC2(Linux), S3, Lambda and the AWS API.• Redesigned product databases to create more efficiency and reduce the need for massive and inefficient data stores. Saving on data storage costs and increasing ease of use of complex product data points for day to day business analytics.

Dallas, Texas, Us

• Engineer datasets and metrics in the Healthcare industry.• Create hypotheses on business processes then test them for veracity within existing data structures. Define what is truly happening within a business.• Develop ELT/ETL pipes between product systems, google cloud, and Snowflake using python, R, and Spark.• Specific focus on metrics around provider-customer relationships and service fulfillment.• Develop data pipelines between Google Analytics (GA4), Google Cloud Platform, and Snowflake.• Utilize GCP features to include AI Notebooks, Cloud Scheduler, Storage, and BIgQuery.• Develop Looker data models, looks, explores, and dashboards to showcase Key Performance Indicators and dashboards designed to present the story of data to stakeholders and decision-makers.

Detroit, Michigan, Us

• Performance Engineer in Global Finance. 3 years working in LoadRunner and ALM to perform performance testing/tuning and analysis/reporting. Currently learning Jmeter.• Extensive experience in database design, SQL optimization, and data analysis in SQL Server 2012-14, SQL Profiler, Oracle databases ( 9 and 11). • Troubleshooting issues with data, writing SQL queries, improving stored procedures, sanitizing and optimizing data. Innovating new queries for data efficiency. Analyzing Oracle AWR reporting to find issues.• Configured and maintained performance monitoring tools in HP Sitescope and CA Application Performance Management.• Used Tomcat and Weblogic to host applications and configuring them to capture performance analytics.• Familiarity with Linux to manage tools, files and middleware applications.• Designed in depth and easy to read Performance Analytics reporting in HP Analytics to cover all performance related server metrics such as HEAP, CPU usage, Database read/write, file read/write, Disk, transaction time requirements, etc.• Continuously worked in an Agile/SCRUM environment to efficiently produce quality software applications.• Designed 16 management level QA focused status reports to cover a multitude of project status updates for decision makers (Test Execution to Date, Agile Sprint Summary, Test Creation Metrics, Defect Reports) within the Team Foundation Server Environment using SQL Server Reporting Services tools (Microsoft Business Intelligence Extension for Visual Studio/SSRS Report Designer for use in TFS).• Used API testing tools Fiddler and Postman to troubleshoot application issues and debug performance scripts.• 1 year as Tech Lead on an electronic billing application. Worked to set up the application infrastructure, firewall rules, load balancer rules, establish DNS, port forwarding and all other aspects to successfully launch the application.

Detroit, Michigan, Us

• Analyzing requirements and ensuring their correct translation into usable end user products.• Designed and wrote test cases for wide variety of applications for use in GM Global Finance.• Developed fully automated data-driven testing suites in C# and Selenium for major Finance projects.• Experience testing and using enterprise applications such as DataStage, MicroStrategy, Cognos, Sharepoint, Business Wise, Citrix, Autosys, Active Directory, Crystal Reports, SAP, Power BI and Tableau.• Worked in enterprise level data mart consolidation projects and data center transfer projects.

• Sergeant, 2nd Brigade, 82nd Airborne Division• Paratrooper• Secret level security clearance.

Master Of Science - Ms, Data Analytics

Bachelor Of Science (B.S.), Economics

Bachelor Of Science (B.S.), Management Information Systems

Associate Of Arts (Aa), Arabic Language

High School Diploma