Learn Data Skills
Beta
William Spichiger

William Spichiger

Business Intelligence Analyst

Stevens Institute of Technology | Austin Texas

Technologies

My Portfolio Highlights

My New Course

Intermediate SQL

My New Course

MLOps Deployment and Life Cycling

My New Course

Developing Machine Learning Models for Production

My New Course

Intermediate SQL

Seeking data analyst, business intelligence, technical role

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

Amazon Web Services AWS Certified Solutions Architect - Associate

Palo Alto Networks Cybersecurity Academy Palo Alto Networks Cybersecurity Specialization

University of Michigan Statistics with Python

University of California - San Diego Big Data

DataCamp Course Completion

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

Courses

Introduction to Python
Introduction to SQL
Intermediate SQL
Intermediate Python

My Work Experience

Where I've interned and worked during my career.

Capital One | May 2021 - Present

Product Owner

Product Owner of the One Lake Access API leveraged by data engineers, analysts to access S3 data assets.
Show More

The Related Companies | Jan 2017 - Aug 2018

Financial Planning and Analysis Analyst

• Reported capital sourcing for expenditures associated with the construction of Hudson Yards. Annual project wide requisitioned development costs for 20+ Hudson Yards projects ranged up to $3B. • Improved project wide monthly capital call reports for executives and key stakeholders. Focused on working capital management activities, development budget variances, changes in debt/equity stakes, and significant events (acquisitions/closings) associated with HY projects • Created overhead dashboard in Excel linked to Access. Featured a flexible, compact view of KPIs & costs associated with employee budgeted/actual time charged per business unit • Tracked cash flows and changes in project capital structures associated with Hudson Yards including development fees, leasing commissions, EB-5 funding, equity investments, credit facility borrowing capacity etcetera

Tenaris | May 2014 - Mar 2015

Variable Cost Analyst

• Reported manufacturing costs (steel, labor, consumables, and maintenance services) of North American Oil Pipe & Coupling Mills. Monthly costs ranged from $1M to $10M • Leveraged cost model to forecast monthly plant costs by multiplying product demand by standard costs of manufacturing processes. Provided month end analyses to upper management. • Created macros and queries within Access to bridge data from ERP systems [SAP & JDE] to Excel

My Education

Take a look at my formal education

Master of Science in Computer ScienceStevens Institute of Technology | 2021
Bachelors of Arts in EconomicsUniversity of Texas at Austin | 2014

About Me

William Spichiger

Analytical professional seeking data centric role. Graduate of the University of Texas at Austin and Stevens Institute of Technology. Professional experience in real estate finance, banking technology, product management, and data security.

Powered by

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