Victor I. Trejo

Conroe, TX • 713-***-**** • adgz9n@r.postjobfree.com

EDUCATION

M.S. – Data Analytics – GPA: 3.7/4 May 2019

University of Houston – Downtown

B.S. – Applied Mathematics – Minor in Applied Statistics – GPA: 3.58/4 May 2010 University of Houston – Downtown

SKILLS

Programming Languages: R – Statistical Computing, Python, C++, MATLAB BI Tools: Tableau, Tableau Prep, Microsoft Power BI Databases: Microsoft SQL Server Management Studio, Oracle SQL Developer, MySQL, PostgreSQL Data Virtualization: Denodo Data Virtualization

Software and system: Qualtrics, SPSS, Microsoft Office – Advanced Excel Language: Bilingual in Spanish - Read, Speak, and Write WORK EXPERIENCE

Specialist – Enterprise Data & Analytics June 2019 - Current Cheniere Energy, Houston, TX

• Data Specialist that supports departments Enterprise wide in collecting, validating, analyzing, and visualizing data

• Passionate about data-driven insights and improving organization efficiency

• Tableau Server Administrator - Publishing, user/AD groups, and manage license permissions company wide

• Lead Tableau Support Trainer – Responsible for training Cheniere Tableau power users – 2 plant sites – 35 Engineers

• Developed Executive Governance Dashboards for Business Support Managers – 50 KPI’s – 10 dashboards

• Lead developer for Executive Governance Dashboards – Production Losses, Finance, Maintenance and Planning, Mechanical Reliability – removed the dependency on manual data collection and provided live access to data

• Created custom reports for the Mechanical Engineering Reliability Team – automated manual process for efficiency

• Collaborated with Operations Excellence to develop a Bad Actor list for equipment failures and completely automated complex MTBF calculations using SQL – saving countless hours of manual work previously done in Excel

• Created custom SQL scripts for the Gas Supply Team tracking gas flows for newly defined regions

• Collaborated with Supply Chain Management on creating a Tracker Dashboard providing new insights

• Use advanced features in Tableau reports and dashboard: Data-driven parameter extensions, parameter actions, user filters, fixed level of detail calculations, sets, groups, advanced analytics, forecasting metrics

• Experienced in writing advanced SQL queries in SSMS, Oracle, and VQL in Denodo. Use stored procedures, indexes, table valued functions, and views to improve backend Tableau dashboard performance.

• Prepare data by combining, cleaning, and validating data from multiple sources – Microsoft SQL Server, Oracle SQL Developer, Denodo, Qualtrics Survey Data, Excel, and MS SharePoint.

• Use Denodo Data Virtualization to combine data from multiple sources & provide secure data for ad hoc reporting. Tableau Projects/Dashboards developed at Cheniere – More projects available to share. Gas Supply Dashboards – Numerous Gas Supply dashboards tracking pipeline flows, storage capacities, & net receipts Taiwan Power Generation Dashboard - Time Series Analysis that tracks Power Generation Outputs in Taiwan Reliability Dashboard – Tracks Cheniere’s top 20 Bad Actors, Heavy Hitters, and Loss Accounting for equipment failures Maximo Work Order Failure Reporting Dashboard – Tracks the failure codes for work orders reported in Maximo Supply Chain – Materials Monthly Details Dashboard - Tracks Global Supplier Lead Time & Materials-Supply Chain Team Supply Chain Tracker – High level executive dashboard tracking all the projects within the Supply Chain Team HR – Training Hours Dashboard – Forecasts certification training hours and provides current training hour details Research and Data Analyst (Tableau and Power BI) November 2018 – June 2019 YES Prep Public Schools, Houston, TX

• Used machine learning algorithms in R to predict pass/fail metrics and student retention statistics

• Member of the Data and Analytics Team responsible for developing Tableau Dashboards for teachers, administrators district wide (18 schools), and Home Office Leadership Staff (Finance, HR, Chiefs of Staffs, etc.)

• Worked on the business case for migrating from Tableau to Microsoft Power BI – Conducted POC for Power BI

• Successfully applied Machine Learning algorithms in R to predict pass/fail and student retention metrics.

• Analytics Team Survey Expert – Responsible for analyzing all system surveys in Qualtrics to gain key insights

• Experienced in writing advanced SQL queries in SSMS and Oracle.

• Prepare data by combining, cleaning, and validating data from multiple sources – Microsoft SQL Server, Oracle SQL Developer, Microsoft Analysis Services – Cube, Qualtrics Survey Data, Excel, Cognos, Eduphoria, and eSchoolPlus. Dual Credit College Math Teacher 2015- November 2018 Conroe High School – Conroe Independent School District, Conroe, TX Math Department Chair and Math Teacher July 2012- June 2015 MacArthur High School – Aldine Independent School District, Houston, TX Math Teacher and Data Team Member July 2010 - June 2012 Waltrip High School – Houston Independent School District, Houston, TX Student Research Assistant & Mathematics/Statistics Tutor Aug. 2009-May 2010 University of Houston – Downtown, Houston, TX

DATA ANALYTICS PROJECTS

“A Descriptive and Predictive Approach to Understanding Student Academic Performance” May 2019 University of Houston – Downtown, Houston, TX

• Graduate Thesis – Using R and Tableau

“Exploratory Analysis on the Effectiveness of A+CE Courses Offered at UHD” October 2018 University of Houston – Downtown, Houston, TX

• Collaborative Project with Department of Urban Education– Using Tableau, R, and Excel

“E. Coli Levels in Houston’s Water Supply” May 2018 University of Houston – Downtown, Houston, TX

• Collaborative Project with Department of Natural Sciences– Using Tableau, R, and Excel

“A Machine Learning Approach to Understanding Student Academic Performance” October 2017 University of Houston – Downtown, Houston, TX

• 2017 HEENAC – GMiS Conference – Graduate Research Poster Competition Winner – 2nd Place

• Data Mining Course Project – Using R and Tableau

“Data Mining in Diabetes Diagnosis and Detection” December 2016 University of Houston – Downtown, Houston, TX

• Predictive Analytics Course Project – Using R

“An Interactive Visualization of Houston Crime” December 2015 University of Houston – Downtown, Houston, TX

• Information Visualization Course Project – Using Tableau

Contact this candidate