TOM BARAHIA, MBA

**** ***** ******** **** # *** 312-***-****(cell)

Chicago, IL 60657 acgkna@r.postjobfree.com

BUSINESS INTELLIGENCE ANALYST

Multi-faceted Automotive Professional who utilizes a mix of both technical

and business knowledge to help organizations achieve breakthrough

performance. Fluent in correlation analyses, trend analyses, pivot tables,

and data visualizations (mostly Excel, some Tableau). Solid background

in cube manipulation and over 10 years of experience creating data

structures, complex SQL queries, ETL processes and building models. Skilled

communicator with the ability to engage and connect with professionals at

all levels.

STATISTICS (PARAMETRIC) . CORRELATION . LINEAR REGRESSION

PROPENSITY MODELING . HYPOTHESIS TESTING . HISTOGRAMS

MS OFFICE (EXCEL) . PYTHON . SQL . R . SALESFORCE . BUSINESS OBJECTS

PROFESSIONAL EXPERIENCE

DATA SCIENCE CONSULTANT (Independent), Chicago, IL July, 2013 - Present

Futures Trader

Managing small asset base using trading strategies based on statistical

algorithms achieving >30% annual ROI.

. Using Python, R, MySQL and MangoDB to anticipate market trends by

analyzing pipeline data from Twitter, Yahoo Finance and related websites.

(Data exceeds 1 MM rows.)

. Computed correlation coefficients across multiple asset classes to

identify hedging opportunities.

McGraw Hill: Data Science Consultant

. Assisted Director in analyzing trends in digital textbook space using

data mining techniques.

. Resulting analysis was used to support 3 year strategic plan. Used

Business Objects, Excel and Access to harvest data and develop linear

regressions to predict future sales of bound vs. digital textbooks.

NAVISTAR INTERNATIONAL, Lisle, IL June, 2012 - June, 2013

Manufacturer of commercial trucks, buses, military vehicles and MaxxForce

diesel engines.

Senior Financial Analyst (position eliminated during '13 mass layoff)

Supported 3 divisions ($300 million combined sales): Valves, Foundry

Castings and Loose Engines. Collaborated with Sales, Engineering and

Finance to develop aggressive pricing strategies for new business

opportunities using cost-plus methodology. Price points, margins and timing

were adjusted based on competitive positioning, projected volume and

expected cost savings.

. Presented 30+ business cases (including financial models) to senior

management with Cash Flow, NPV, IRR, pay back period and growth strategy

serving as key discussion points. Suggested recommendation frequently was

implemented. Underlying data was retrieved and analyzed using Hyperion

Essbase.

. Championed incorporating fixed cost in Foundry Casting and Loose Engine

quoting methodology which resulted in product margins being consistent

with quarterly and annual P&L reporting.

. Improved labor cost estimation for valve machining and assembly by

collaborating closely with engineers. Resulting increased accuracy helped

justify lower price points or acquiring newer, more efficient equipment

for assembly line.

. Published weekly dashboard with Foundry Casting and Valve sales metrics

keeping Sales Team inspired.

FINANCIAL CONSULTANT (Independent), Chicago, IL June, 2010 - May, 2012

Day Trader

Managed small asset base using automated trading strategies based on

statistical/trend following algorithms achieving >30% annual ROI.

True Value: Financial Consultant

. Responsible for monthly P&L reporting and annual budget development for

several divisions.

. Designed reports that helped the Controller investigate underlying trends

and monthly variances-to-budget; used both Business Objects and Cognos in

report development.

CARS.COM, a division of CLASSIFIED VENTURES, Chicago, IL March, 2006 - May,

2010

Cars.com helps auto consumers and dealers connect by combining inventory

access, buying guides and related services.

Senior Financial Analyst

Directed financial functions of Santa Monica Operations with a $20 million

revenue budget. Responsible for managing commission expenses for direct

sales team which were expected to be kept at (or below) 10% of revenue.

. Created comparative cost-benefit analysis of proposed products for

revenue initiative. Presented base case, aggressive case, estimated ROI,

risk factors and assumptions to management.

. Developed commission plans for 200+ reps by collaborating with Senior

Management. Key team member in growing direct sales revenue to $100

million from 2006 - 2009.

. Supervised and trained commissions analyst to take over day to day

issues.

. Improved budgeting and forecasting accuracy by creating propensity models

that captured underlying relationships between clicks, conversions,

leads, costs, margins and revenue.

. Reduced "days to close the books" from 5 to 2 by developing systematic

processes.

. Redesigned commission plan which improved equity in commission

distribution.

INGENIENT TECHNOLOGIES, Chicago, IL February, 2005 - October, 2005

Multimedia product development leader, having produced one of the first

portable media players.

Financial Analyst

Republished financial statements according to US GAAP standards for company

valuation. Converted from cash basis to accrual basis for years 2002, 2003,

and 2004; Company was sold at favorable earnings multiple shortly after

audit.

. Developed and implemented favorable tax, valuation and contract

accounting methodology by collaborating with Auditor and Senior

Management.

. Completed first time audit within short-term deadline and designed and

implemented internal controls.

COVANSYS CONSULTING, Detroit, MI March, 1996 - May, 2002

A $400 million firm providing systems integration, software development,

packaged software implementation, and IT strategy. Clients include Ford,

Chrysler, Johnson Controls, and Sprint.

Lead Analyst, Chrysler Account

Developed software system using DB2 database to expedite and optimize

border declaration and duty payments of auto parts crossing the Mexican

border from United States.

. Increased NAFTA savings by $15 million by researching Mexican Tariff

Code, maximizing parts qualifying for favored status and reducing

effective tariff rate by 1.5% on $1+ billion in annual shipments for

Chrysler.

. Supervised up to 7 programmers, each delivering rigorously tested code on

time and up to specifications

. Improved accuracy of automotive part declaration to 99.9% and tariff code

compliance to 99% through policy redesign; acquired thorough

understanding of system development life cycle.

. Reduced man-hours per customs document by 88%; achieved through

automation.

. Performed gap analysis, project design and specification development. -

developed 73 programs, created 18 data tables and implemented 4 modules -

each ahead of schedule.

EDUCATION

MBA, Business Strategy & Finance (full time), Washington University, St.

Louis, MO, 2004

BS, Electrical Engineering, University of Michigan, Ann Arbor, MI, 1992

Contact this candidate