Resume

Sign in

Financial Analysis, Data Analysis

Location:
San Jose, California, United States
Posted:
August 28, 2017

Contact this candidate

Theo Callahan

(408) ***-**** ac11tj@r.postjobfree.com

https://www.linkedin.com/in/theocallahan/

Accomplished IT and Business President with over 15 years’ experience providing financial analysis, data modeling, and decision support services to C-level clients. Highly successful at conducting risk assessment, revenue forecasting, analyzing business needs and incorporating technology to streamline processes for better efficiency and productivity. Displays solid leadership and managerial skills when empowering employees to achieve a high level of performance. Excellent interpersonal and communication skills affords the ability to interact well with clients of all levels both technical and non-technical.

Client Support & Training

Financial Analysis

Revenue Forecasting

Data Security

Leadership & Management Skills

Employee Training & Development

ROI Calculation & Evaluation

PowerPoint Presentations

Risk Assessment & Management

Business Analysis & Development

Market Analysis & Forecasting

Data Queries & Analysis

Technical Knowledge: Microsoft Word, Excel, Access & PowerPoint, Excel Power Query, VBA programming, C#,

T-SQL, HTML, JavaScript

PROFESSIONAL EXPERIENCE

I GET IT! DEVELOPMENT 1999 - Present

President

Provide consulting services to the finance, medical device, and high tech communities. Clients include: Sequoia Capital, US Venture Partners, Trident Capital, Boston Scientific, Abbott Labs, Stryker Neurovascular, KeyPoint Credit Union, and Aggregate Knowledge.

Conducted risk assessment and designed a financial model in SQL Server and MS Excel to break down risk and return by origination period, direct and indirect business, new vs. used and credit score band. The new model was successful at minimizing bad debt for a credit union automobile loan portfolio.

Designed a comprehensive view of at-risk properties and forecasting loan write downs in SQL Server and MS Excel for the Vice President of Lending.

Created a tool for a publicly held software company to forecast quarterly revenue, predict if sales targets could be achieved, and ensure accurate revenue recognition at quarter close by combining MS Access and Excel.

Tracked competitive landscape by publishing monthly competitive bulletins to assist sales with closing business and product management essential in determining new features to initiate.

Collaborated with CFOs and controllers to create ad hoc analysis with MS Excel VBA, direct database connections to MS SQL Server to simplify their work. Trained personnel on the new systems.

Facilitated CFO and controller in implementing new reporting standards to accommodate constantly changing requirements from auditors, examiners, and regulators.

Created customer-specific PowerPoint presentations that interactively allowed the client to determine device/procedure ROI based on real time input using SQL Server, C#, PowerPoint VBA and Excel VBA.

Designed a user interface in Excel spreadsheet model that enables stakeholders to engage and fully utilize cost and reimbursement data for their new medical device.

Published multiple articles in AICPA’s Journal of Accountancy.

Taught Excel VBA, Access VBA and Microsoft Office courses to corporate personnel.

Utilized Excel Power Query, PowerPivot and Power BI to automate data wrangling and allow self-serve business intelligence.

Created web site in C# for Venture Capital partners to enter employee performance reviews either by downloading and uploading Excel files (for offline use) or by using web application when online.

SIEMENS BCS 1997-1999

Program Manager, Marketing Intelligence

Collected and analyzed quantitative and qualitative market intelligence within the voice and VOIP space.

CENTIGRAM 1995-1997

Manager, Market Intelligence And Promotions

Collected, analyzed, and presented competitive intelligence to senior staff, product development and sales force.

EDUCATION & CREDENTIALS

MBA, International Business Studies, USC IBEAR.

Bachelor of Science, Geophysics, Texas A&M



Contact this candidate