About Me

Robert Lane

      Innovative Data Insight Analyst and experienced leader with a background in Python, PostgreSQL, Jupyter Notebook, and Excel Visual Basic Analysis (VBA) from Southern Methodist University’s data science boot camp certificate. Have also learned statistics, calculus, C/C++/C#, and Programmable Logic Controllers. Multidisciplinary critical thinker with nearly 10 years of broad expertise collaborating with cross-functional internal and external clients. Results-driven team leader and detail-oriented collaborator with proven success managing multiple projects and tasks simultaneously. With experience in serving numerous industries, sharing knowledge with coworkers, experience with leadership, strong analytical skills, and a voracious appetite for learning, would make a valuable asset to any analytics team.

      I live in the Dallas / Fort Worth metropolitan area, and am seeking a hybrid or remote work environment with an existing data science team where I can continue to learn while I study for my Master's Degree in Data Science at Southern Methodist University.

Technical Skills

Programming Languages & Tools: Python • Pandas • Jupyter Notebook • C/C++/C# • JavaScript • GitHub • Programmable Logic Controllers • Excel VBA • R • Selenium • Beautiful Soup
Web Languages & Tools: HTML • CSS • JavaScript • Bootstrap • D3.js
Data Platforms & Interfaces: PostgreSQL • SQLite • MongoDB • Microsoft Access • API • JSON • SQL • Google API • Flask
Cloud Platforms & Tools: Amazon Web Services (AWS) • Amazon Relational Database Service (RDS) • Google Colab • Heroku
Machine Learning: Regression, Classification, & Cluster Modeling • PySpark • Tensorflow • Scikit Learn
Data Visualization: Excel • Matplotlib • Leaflet • Plotly • Tableau
MS Office Suite: Word • Excel + pivot tables + VBA • PowerPoint • Access • Outlook • Visio • Project

Featured Projects

Gouge

      Simulates loan application process for Lending Club using data sets spanning from 2007 through 2018. Uses two machine-learning models to predict outcomes with approximately 92% precision and 92% negative predictive value. Statistical program modeling predicts loan acceptance and loan outcome (whether or not the borrower is likely to be late on payments in the future). Corrected for classification imbalance to ensure better outcome without overfitting the model. Created automation code which checks, scores, and stores multiple machine learning models for later use. Includes responsive Tableau visualization on common questions about loans in the dataset and interactive fields for users to test.

Lending Club Simulator

      This project compiled data scraped from approximately 2,400 web pages in order to present on a Leaflet map dealership asking prices in comparison to the manufacturer’s price. Dealerships which tend to gouge on prices are marked as such. In addition, Kaggle data sources were used to trim down using ETL methods to roughly 150,000 rows of vehicle sales records in order to chart average sales prices per model (using Plotly) so that users can compare options between makes without the need to analyze data. Extensive use of SQL queries and Flask APIs were formed in order to prepare the data for extraction from multiple databases in a timely manner on the site. Finally, the code and media were updated in order to facilitate sharing on social media with proper image and description previews.

Dallas Building Fire

      Performed statistical analysis for logged fires within the City of Dallas for the year 2020. Created heatmap of fire station coverage using Google API, Jupyter Notebook, Pandas, and haversine formula, and found correlation between extent of damage and the presence of fire alarms and sprinklers. Assisted team mates with troubleshooting code. This project represents a start in data processing, analytics tools, data visualization, presentation skills, and data analysis..

Professional Sports

      Performed web scraping on uneven data to programmatically list all teams for US and Canadian team sports within: MLB, NBA, NFL, MLS, and NHL. Also pulled census data for both countries for each metropolitan area containing any of these teams. This project pertains strictly to ETL (Extract, Transform, & Load) operations to pull live data into a SQL database.

Experience

Mechanical Designer / Project Manager

APS Industrial Services, Inc. (Mar 2013 - Sep 2022)
Optimized process improvement of plasma table programming, and checked material cutlists in order to reduce waste, resulting in a savings of over $6,000 of material costs in one project while simultaneously improving output quality of parts.
Authored parts documentation for complex machinery (up to 600 pages) for aerospace customer, minimizing time required for maintenance teams to locate replacement parts.
Became primary consulting project manager on all custom conveyor projects after consistently accurate quotes and timelines, ensuring customer requirements and FDA& OSHA regulations were met. Demonstrated repeated ability to maintain effective relationships and process improvement through written communication.
Conceptualized and deployed modular process improvement for custom sensor mounts which allowed crucial flexibility for field installation at medical device manufacturer, after communication with engineering department. This minimized downtime required for plant modifications and process improvements.
Led relaunch of company website. Created new web form which stopped code injection attacks. Added Google Analytics capability to aid owners in advertising attempts.

Operational Supervisor

Jay Vending Company (Mar 2012 - Jan 2014)
Complied with health code in kitchen while reporting problems to be corrected.
Ethical leadership and critical thinking facilitated effective teamwork.
Managed inventory counts.
Trained new employees in proper verbal communication skills in order to increase their ability to work independently.
In previous employment at the same location, created an Excel-based sales tracking system to replace manual system and analyze $3 million in annual revenue while managing 40 employees. Analysis of daily reporting identified a key location that outperformed expectations. Reporting this resulted in targeted staffing which was able to increase overall revenue by approximately 4%. Undertook this successful data driven project on personal stewardship.

Education

College

Southern Methodist University: Master of Science in Data Science
(currently enrolled, expected May 2025)
University of Phoenix Bachelor of Science in Information Technology
Tarrant County College Associate of Arts in Liberal Arts

Certificates