Timothy

Lim

Data Analytics,

Project

Management,

Mechanical Design

Engineering

advhlt@r.postjobfree.com

850-***-**** U.S. Citizen

www.linkedin.com/in/timothywlim

EDUCATION

M.S. Data Analytics,

Georgia Institute of Technology

present

Data Science Bootcamp,

Flatiron School, Online

2020

B.S. Mechanical Engineering,

Pensacola Christian College

2011

CERTIFICATES

Project Management Professional

(PMP)

PMP# 3023306

SOFTWARE SKILLS

Languages

Python, R, SQL, DAX, Power Query

Data Science

Pandas, Power BI, PyCaret, Jupyter

Notebook

Engineering

Ansys, Mathcad, Inventor,

SolidWorks, AutoCAD, Matlab, SAP

Project Management

SmartSheet, MS Project

PROFESSIONAL EXPERIENCE

Data Analyst - Business Operation Risk Management, Macquarie Group 05/2022 – present Houston, United States

•Used Dataiku and Alteryx to design and build workflow processes for ETL, data munging, data enrichment, and EDA.

•Create Power BI dashboards, using the role security responsibilities feature so that desk heads and senior management from multiple groups can monitor compartmentalized trade activities and review trading trends.

•Automated a complex weekly Excel reporting process using Python and Visual Basic. Significantly improved data integrity and reduced weekly report preparation time from 180 minutes to 30 minutes.

•Use data analysis tools to monitor and report on the company's internal communication platform usage against the company's policies.

•Employed advanced Excel data query functions to extract data for reports. Build Excel macros to meet user requirements and simplify recurring tasks (vlookups, pivot tables, graphs.)

Data Analyst, City of Houston (Contractor)

07/2021 – 05/2022

•Mined and large dataset. Performed data cleansing by joining, cleaning, and compressing 230GB of raw SCADA data to 6GB normalized dataset.

•Used variance, anomaly detection, Arima, and Time Series Analysis to define Houston City's stormwater pump operations (normal, wet weather, and overflow.) to provide warnings to City's incident response team.

•Built reports and visualizations to present insights, findings, and recommendations to management for asset management and maintenance.

Product Analyst, Project Engineer, TechnipFMC

01/2019 – 04/2020 Houston

•Managed a $2M project with an expected annual earnings of $12M for 5 years.

•Facilitated multidisciplinary daily scrum meetings aligning representatives from sales, operations, a ermarket, production, and R&D.

•Performed FEA stress analysis, analyzed project risks with PM methods like SWOT, Root Cause Analysis, and Risk Matrix to assess feasible options.

•Compiled operational and fleet data, analyzed and created visualization reports to secure funding from sponsors.

Wellhead Engineer III - Product Design Engineer, R&D Engineer, Schlumberger (Cameron International)

2011 – 2018 Houston

•Designed new variations, and converted existing product lines to fit clients' specifications: trim (metals/ coatings/ elastomeric) components, quality plans, High-pressure High Temperature/ Sweet/Sour Services.

•Investigate field failures and provide real-time support solutions, using both conventional calculation methods and FEA failure modeling.

•Designed new product, supervised testing plan, and qualification testing for prototypes in accordance with API 6A (which includes: pressure cycles, temperature cycles, cyclical loading, and fire test.) Created SOP, tables, and charts for field operators based on the test findings.

•Review and approved machine details for manufacturing, fabrication, and GD&T.

Contact this candidate