Learn Data Skills
Beta
Lorenz Madarang

Lorenz Madarang

Data Analyst

Mezo | Las Vegas, NV

Technologies

My Portfolio Highlights

My New Track

Data Scientist

My New Course

Introduction to Python

My New Track

Data Scientist

Inquisitive analyst, forever asking 'Why?' to uncover the truth in data.

My Work

Take a look at my latest work.

course

Introduction to R

course

Introduction to Python

course

Intermediate Python

course

Introduction to R

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to R
Intermediate Python
Introduction to Excel

My Work Experience

Where I've interned and worked during my career.

Mezo | Nov 2021 - Dec 2023

Data Analyst II

➤ Data analyst in two-person data team for seed-round funded data-driven property maintenance intelligence start-up. ➤ Transitioned 50+ BigQuery analytics views to data models using dbt and SQL to cut development time by 50%. ➤ Parsed and analyzed product data for case study using SQL and Python that revealed 2.7x ROI and $27k in savings for a customer. ➤ Collaborated cross-functionally with R&D, customer success, sales, engineering and marketing teams to create 50+ KPI dashboards using Metabase and SQL. TECH STACK: GCP, BigQuery, Metabase, ClickUp, dbt, Google Sheets, Python, GitHub, Mode, Jupyter Notebook
Show More

OnPoint - A Koch Engineered Solutions Company | Feb 2021 - Oct 2021

Technical Product Manager

➤ TPM for AWS-hosted Electrical Grid Fault Prediction AI Software. ➤ Led development team to completion of Phase 1: end-to-end automatic ingestion of disparate data sources, data engineering, and prediction in AWS. ➤ Implemented agile best practices for development team in Azure DevOps, consistently completed 75% of the committed sprint work. TECH STACK: AWS, Azure DevOps, Redshift, Lambda, API Gateway, Data Pipeline

V Shred | Mar 2019 - Feb 2021

Product Owner Analytics/Data Science

➤ Advanced analytics team lead for rapidly growing direct-to-consumers supplement and fitness company. ➤ Led VShred advanced analytics team to integrate finance, marketing, social media, and sales operations data into AWS Redshift. ➤ Collaborated with internal stakeholders to create 50+ KPI dashboards using AWS Redshift and Tableau to provide insight to help double revenue from $100M to $200M. TECH STACK: Redshift, Tableau, Google Analytics, AWS, PostgreSQL, Jira, Jupyter Notebook, Sagemaker

Barrick Gold Corporation | Feb 2017 - Mar 2019

Technical Project Manager

➤ Managed $7M Azure data lake project that consolidated mining operations data and finance data. ➤ Facilitated data curation for predictive maintenance app, helped prevent $100k unplanned maintenance event. ➤ Led data-discovery of automated underground productivity report in PowerBI, saving 100+ hours of manual reporting. TECH STACK: Jira, Azure, Microsoft SQL, PowerBI

(LVRC) | Aug 2014 - Feb 2017

IT Project Manager

➤ Managed project planning, budgeting, vendor selection and quality assurance efforts of IT projects for Central Recovery. ➤ Implemented electronic medical billing software that saved $1k+ a month in manual medical billing labor. ➤ Set-up Google Analytics for sister publishing company website allowing comprehensive view of website performance.

The Shade Tree | Aug 2013 - Aug 2014

Life Skills Instructor

Taught women who have been affected by homelessness and domestic violence the proper way to resolve conflict.

MilSatCom Systems Directorate | May 2011 - May 2013

Test & Evaluation Operations Analyst

➤ Spearheaded Developmental Test Program, resulting in a multiple agency- reviewed test program with zero identified critical issues. ➤ Conducted and designed key program risk reduction test campaign for $1.7B satellite program.

Missile Defense Agency | May 2009 - May 2011

Space Operations Analyst

➤ Analyzed 125 system tests that certified operational readiness of advanced satellite and enabled integration of 8 major joint/international flight tests. ➤ Received Junior Office of the Quarter Award for assigned Division, helped secure divisions' receipts of the Technical Excellence & Pinnacle Award.

United Sates Air Force | May 2008 - May 2009

Student Pilot

Studied and trained to become a pilot in the United States Air Force

My Education

Take a look at my formal education

Master of Science - MS, Computer Science, Data ScienceColorado Technical University | 2020
Graduate Certificate , Applied Statistics Penn State University | 2017
Bachelor of Science (B.S.), Human Factors/ErgonomicsUnited States Air Force Academy | 2008

About Me

Lorenz Madarang

Lorenz hasn't filled in a bio text

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free