Managed Snowflake SQL pipeline for Big Data ELT processes to deliver data products to stakeholders across growth-stage financial startup Ensured consistent output to AWS cloud warehouse across legacy and modernized tables, including deduping, normalizing, and deterministic ordering Designed and contributed to intermediate and incremental models across the company codebase to enhance performance and usability of materialization stages Enhanced validity of forecast analytics by investigating and data modeling the ETL process of external data Mentored coworkers in software and structured tables, documenting to empower end users to answer their own questions Designed data ingestion mechanism to meet ELT needs of large unstructured data Optimized end-to-end data translation for Looker users to access metrics and KPIs Engineered Snowflake SQL OLAP system cubes to build LookML metrics and Looker Dashboards for Data Science, Payments, Client Relations, and other users

Schnitzer Steel | Sep 2021 - Jun 2022

Business Record System Analyst

Data/Business Analytics • Data mining historical and forecasted records to map out statistical trends and anomalies to project seasonal pricing and distribution of company productions • Lead cross-functional discussions with subject matter experts for planning rapid changes in trade costs and budgets • Utilize market research to present proposals to sell the materials; either raw or processed, to deliver the most financial impact Software Engineering • Build Oracle BI SQL queries on relational databases and VBA programs on extracted data for tracking company’s nationwide sales and purchases on a daily basis • Generate ETL processes and programs working across multiple tools and programs to track each stage checkpoint in sales, shipping, receiving, and revenue recognition

HNTB | May 2018 - Jun 2020

Data Analyst, ITS Engineer

Data Analytics • Analyzed deviations in bid prices outside interquartile range of similar bid items to investigate the cause and validity of values towards cost reports • Built SQL data pipeline structures to analyze product and labor cost growth of contracts over past 10 years to forecast upcoming trends for next 5-10 years Software Engineering • Developed Python API to revitalize clients’ budget gaps to targeted 10% above bids through identifying steady cost growths versus market influenced growths • Established secondary queries and VBA algorithmic testing to data cleanse existing Access database and setup autocorrection for future data entries Professional Services • Organized team labor tasks between multiple simultaneous and forecasted jobs to keep balance without dead time • Brought key stakeholders to a mutual agreement during various stages of contracts for the clients whenever there were any concerns or conflicts • Reviewed construction proposals and plans to approve or disapprove by code of conduct

PBS Engineering | Jun 2017 - May 2018

Data Analyst, ITS Engineer

Data Analytics • Designed data models and gave presentations to convey the story of connections and impacts between multiple stake holders’ responsibilities Software Engineering • Produced VBA processes to clean up extracted, dirty data from multiple sources and marry them through API for application into transit scheduling system Professional Services • Drafted and calculated preliminary plans and diagrams, estimates, and schedule forecasts for joint venture contracts exceeding $100 million

Aldridge Electric | Jul 2012 - Jun 2017

Data Analyst, Project Engineer

Data Analytics • Conducted analyses of over 600 installation sites while estimating costs of new/refurbished hardware, labor, and probability of completion dates and order • Presented multiple scenarios with data models expressing costs and risks to program management and corporate Software Engineering • Owned VBA program developed to allow UI input towards engineered virtual layouts and automated worksite redesign with output of CAD drafting code for plan execution and delivery on-call • Created VBA program to track field changes and bring attention to negative domino effects, allowing for real-time markups and design changes as necessary • Integrated multiple programs by porting into one platform of VBA coding for universal compatibility among users reducing output time by 80%. Professional Services • Engaged in discussions with client and stake holders for a $350 million project on changes to a dynamic schedule and design while building relationships on all disciplines • Presented to senior management calculations of installation statuses concerning geographical and angular concerns, exposing issues for later reconstruction

Aldridge Electric | Jun 2009 - Jul 2012

Project Engineer, Draftsman

N/A

Aldridge Electric | May 2008 - Aug 2008

Intern/ Draftsman

• Drafted electrical plans for new and renovated stations in Chicago Transit Authority subway and elevated lines • Overlooked structural plans for platform in Chicago Transit Authority elevated lines

Lake Process Systems, LTD | Jun 2007 - Jul 2007

Intern/ Draftsman

Assigned projects in drafting to organize and document as-built plans of fluid piping systems in processed food production plants.

MuranNowak Architects, LTD. | Feb 2005 - Jun 2005

Draftsman

Trained in specialty drafting software to update utilities and door and window schedules for custom residential architecture plans.

Exclusive Woodworking, Inc. | Jun 2004 - Feb 2005

Estimator/Draftsman

Calculated estimates for bids and drafted plans in residential custom carpentry.

My Education

Take a look at my formal education

Bachelor of Science, Civil EngineeringUniversity of Illinois at Chicago | 2009

Associates, EngineeringCollege of Lake County | 2006

Create Your Data Portfolio for Free