Jake T. Johnson

Multivariate methods — multiple regression, time series, and data preparation — worked through in Excel and JMP, with emphasis on presenting results to a non-technical audience.

• Statistical & Predictive Modeling
• Advanced Excel
• BI & Dashboarding

Relational database design and management, ending in a group build: a SQL and PHP application over a sales dataset, with the work tracked on a Gantt chart.

• Data Extraction & Preparation
• SQL & Database Design
• Web & Application Development
• Project Management

Python from the ground up — computational problem-solving first, then analysis on small datasets using Pandas, NumPy, and SciPy.

• Python
• Statistical & Predictive Modeling

The systems development lifecycle end to end: requirements gathering, star-schema data modeling, process diagrams in draw.io, and interface prototypes — run on an Agile cadence with simulated stand-ups.

• Data Extraction & Preparation
• SQL & Database Design
• BI & Dashboarding
• Project Management

Object-oriented programming in JavaScript. Built a fitness app with a group that took plain-English food entries, resolved them against a natural-language nutrition API, and charted weekly calorie trends.

• Web & Application Development
• BI & Dashboarding

Supervised methods — logistic regression, decision trees, and neural networks — applied to large datasets for prediction and pattern discovery in a business context. Modeling is done in SAS.

• Statistical & Predictive Modeling
• Python

Financial statement preparation and the principles behind it, from the corporate reporting perspective.

• Financial Accounting & Analysis

Cost measurement and internal reporting for decision-making — operational budgeting, cost behavior, cost-volume-profit analysis, and activity-based costing.

• Financial Accounting & Analysis

Investment, financing, and working-capital decisions, built on time value of money.

• Financial Accounting & Analysis

Risk and return across stocks, bonds, and derivatives, with modern portfolio theory and valuation technique.

• Financial Accounting & Analysis

Portfolio theory and performance evaluation, applied: a ten-year personal financial plan, an ETF portfolio constructed entirely with AI tooling, and biweekly presentations tracking the communications sector.

• Financial Accounting & Analysis
• Market Research
• Client & Stakeholder Management

How banks and insurers actually operate — loan and investment portfolio policy, pricing, underwriting, and the structural logic behind risk-pooling.

• Financial Accounting & Analysis

The FinTech landscape — emerging models in payments, banking, insurance, and wealth management, and the technologies underneath them: blockchain, smart contracts, AI, and big data.

• Financial Accounting & Analysis

Oral fluency and vocabulary built through sustained conversation, including regular sessions with native speakers from across the Spanish-speaking world.

• Spanish

Written fluency at length — original pieces taken through repeated peer and self-editing to build deliberate, controlled composition.

• Spanish

Professional Spanish for commercial settings, alongside economic and social comparison between Latin America and the United States. Ran a small business for the course — Spanish-language custom T-shirts — which returned its seed capital and turned a profit.

• Spanish
• Cross-Cultural Communication
• Field Sales & Negotiation
• Business Operations
• Market Research

Close reading across Spanish and Latin American literature from romanticismo through the Boom. Wrote an anthology on the Latin American Boom and magical realism.

• Spanish
• Research Design & Synthesis

Intensive immersion taken on site in Spain — intermediate language work, grammar reinforcement, and conversational fluency, in class five days a week for four weeks.

• Spanish

Spanish culture studied on site: city tours, museums, concerts, theatre, and cinema. We were examined on the material the guides covered, so the tours were the lecture. Prerequisite was six credits at the 300 level.

• Spanish

Women writers from Latin America and Spain, read for the social and political weight of what they chose to write about.

• Spanish

Operations as a business function — inventory, shipment, and logistics modeling worked through quantitatively in Excel.

• Advanced Excel
• Statistical & Predictive Modeling

The American legal system and the fundamentals of torts and contracts, framed around managing legal risk in business decisions.

• Client & Stakeholder Management