Learn Data Skills
John Lott jr

John Lott jr

Data Engineer

City of Detroit | Detroit, MI

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

My New Course

Introduction to Python

Data gardener, nurturing insights to bloom and thrive in the data ecosystem.

My Work

Take a look at my latest work.

course

Understanding Data Engineering

course

Introduction to Python

course

Intermediate Python

course

Understanding Data Engineering

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Microsoft Azure Fundamentals

Google Google Generative AI Leader

DataCamp Course Completion

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

Courses

Introduction to Python
Intermediate Python
Understanding Cloud Computing
Understanding Data Engineering

My Work Experience

Where I've interned and worked during my career.

City of Detroit | Mar 2020 - Present

Data Engineer III

• Creating and maintaining scheduled data pipelines for Detroit citizen COVID-19 vaccines using of Python scripts, PostgreSQL queries, and Airflow CRON schedules • Managing a PostgreSQL Database containing data from various City of Detroit government departments • Maintaining healthy data processing of Detroit neighborhood improvement projects between PostgreSQL data warehouse and Tableau dashboards • Developing geospatial feature layers for the Detroit land bank authority using ArcGIS online and the ArcGIS API
Show More

The Auto Club Group | Apr 2019 - Mar 2020

Data Enginner

• Built AAA customer insurance data pipelines from vendor application databases to Google Cloud using Python, Talend, and Airflow. • Used Google Cloud Platform technologies (Big Query, Cloud Function) to build and improve overall ETL infrastructure between customer database and data lake • Created an automated Python script that provided up-to-date database memory statistics, eliminating a 45-minute manual task

Sandler & Travis Trade Advisory Services, Inc. | Oct 2017 - Mar 2020

Data Engineer

• Wrote and developed Microsoft SQL queries and stored procedures to manage TradeVia web portal access • Applied database code changes in GIT source control • Created pass through queries with Microsoft Access and Microsoft SQL • Completed client tickets and projects using JIRA project tracking systems

Team Detroit | Mar 2016 - Apr 2017

Junior Data Operations Analyst

• Processed dealer enrollments/cancellations in Ford’s Owner Advantage Rewards Program for US and Canadian dealers • Collaborated with the Account and Development teams in an agile-based environment • Developed and delivered daily reports using Microsoft SQL queries and Microsoft Excel charts

Accenture | Jan 2016 - Mar 2016

Test Development Intern - (DTE Customer 360 Project)

• Designing presentations for the post-launch employee learning courses • Providing weekly reports of progress to management using Microsoft SharePoint • Collaborating with other developers to improve the quality of courses

Denso International America | Jan 2016 - Mar 2016

IT Administration II CO-OP

-Processing requests for Intercall and WebEx Accounts -Developing end user communications for the introduction of new products or services -Developing self-help user documentation -Assisting Lotus Notes team with Associate Directory updates -Working with Corporate Communications/HR Training to develop end user "Tips and Tricks" training

Denso International America | Sep 2014 - Jan 2016

Accounts Receiveable CO-OP

• Electronically categorize customer charges and reimbursements based on payment discrepancies • Electronically track customer credits and debits to the company • Gather information to support payment owed to the company from customers

Wayne State University | Jun 2014 - Sep 2014

Finance Accounting Intern

• Updated financial spreadsheets daily using Microsoft Excel • Completed online financial forms pertaining to university financial transactions • Relay and discuss invoice statuses with Finance Advisor

My Education

Take a look at my formal education

Bachelor of Business Administration (BBA), Management Information Systems, GeneralWayne State University | 2016
Associate's degree, Business Administration and Management, GeneralHenry Ford Community College | 2013

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free