Ryan M. Stearns Page *.

RYAN M. STEARNS

acreva@r.postjobfree.com

949-***-****

FINANCIAL ANALYST Software

Proficiencies:

ANALYSIS ~ FORECASTING ~ MODELING ~DATABASE -SAP

MANAGEMENT -Business Objects

-SQL Server

A true leader among leaders with an analytical goal oriented personality and work

-QuickBooks

ethic; has an innate ability to influence others and produce dynamic and long lasting -MS Word

-PowerPivot

results.

-PowerView

Self-motivated educator, diverse experience and loyal dedication have helped create

- Power BI

a powerhouse of problem-solving skills -MS Excel

Customer-focused leader with years of cross-industry experience driving -Program in VBA

impactful company change -Pivot Table

-Vlookups

Articulate communicator skilled in delivering insightful presentations and

-MS Access

strengthening relationships with business partners, peers and leadership. -Create Queries

Proven mentor, trainer and director of multidisciplinary teams in line with -Program in VBA

aggressive performance metrics -Tableau

Experienced collaborator with deft organizational, analytical, and critical -Qlik

-Datazen

thinking ability

-Crystal Reports

-Cognos

EDUCATION

Honors:

-Eagle Scout, BSA

Masters in Business Administration Graduation Date: December (2001)

2010 -Employee of the

National University, Fresno, CA Month (RHA)

Focus of study: Accounting -Tier III Employee

(James Hardie)

Bachelor of Science - Business Administration Graduation Date: December 2008

California Polytechnic State University, San Luis Obispo, CA

Focus of study: Finance, Enterprise Accounting and Public Accounting

Certifications:

Certified Management Accountant- (CMA) (Dec. 2010)

QuickBooks Certified User Program (Feb. 2009)

PROFESSIONAL EXPERIENCE

Financial Analyst Jan. 2015 Present

James Hardie Building Products, Chicago, IL

-Manufacturing company, specializing in Fiber Cement siding, with 9 plants across the country.

Built database for sales volume and utilized BI software to visualize data in

meaningful way to management and sales team

Manage security and data requests for SQL server to host data for multiple teams

Worked with multiple data visualization tools to create KPIs and dashboards for

management use

Built capital model that analyzed capital efficiency at plant asset level

Ryan M. Stearns Page 2.

Analyze capital efficiency metrics used in executive compensation plans

Improved CER forecasting model by working with business partners in operations

and utilizing data in forward looking outlooks

Initiated project to automate the capital spending tracker using SAP data within

Power Pivot

Project Manager- SAP Costing Implementation July 2014 Jan.

2015

James Hardie Building Products, Mission Viejo, CA

-Manufacturing company, specializing in Fiber Cement siding, with 9 plants across the country.

Subject matter expert for process flow building case for costing with SAP

Created workflows of current state standard costing within SAP for 15 different

processes within our operations

Collaborated with consultants to blueprint designs for SAP costing system

Cost Analyst I, II, & III June 2011 July

2014

James Hardie Building Products, Mission Viejo, CA

-Manufacturing company, specializing in Fiber Cement siding, with 9 plants across the country.

Tracked all plants performance and identified opportunities for impactful

improvement

Tracked spending on a cost per gross hour basis across multiple lines and plants

Created reports to bridge plants cost month to month and standard to actual

Closed plants monthly, and reported results to the U.S. management team

Created quarterly forecasts for network of plants to project results

Worked directly with management to project annual budget

Utilized SAP to reconcile journal entries and inventories across all plants

Utilized SQL server reporting to create reports that plants could utilize on a daily

basis for reporting and analysis purposes

Traveled to plants to train controllers and accountants on cost and performance

improvement

Created actual costing tool to help plants analyze product costing month to month

Modeled costs and prepared business proposals for new business acquisitions

Utilized Excel, SQL Server, SharePoint and Access to create reports and database

systems for reporting purposes

Built actual costing system in SQL that provided actual cost by stage by product by

plant at cost center and cost element level of detail.

Project Accountant August. 2009 June

2011

Richard Heath & Associates, Inc., Fresno, CA

-Private Management Consulting Firm with 6 offices across California managing Energy Efficiency Programs

Tracked costs and prepared detailed Profit & Loss Statements for programs

Developed and implemented invoicing and reporting database for Energy Programs

Developed and implemented Inventory database using Access

Continued on Page 3

Ryan M. Stearns Page 3.

Input general ledger and daily operation data into QuickBooks

Analyzed and prepared financial analysis reports for Program Managers

Prepared reconciliations of accounts and other GL duties

Prepared Profitability Reports for top executives

Analyzed Energy Savings from Programs and reported to clients and executives

Utilized Excel and Access with the ability to program in VBA to create reports and

database systems for Programs

Professional Memberships

Institute of Management Accountants (IMA)

Financial Management Association (FMA)

Cal Poly Accounting Club (CPAC)

American Institute of Certified Public Accountants (AICPA)

Boy Scouts of America (BSA)

Continued on Page 2

Contact this candidate