Ryan Morrin Email & Phone Number

Kirkland, Wa, Us

Dearborn, Michigan, Us

*Ford Customer Service Division (FCSD) - Responsible for analysis around parts, extended service plans and customer repair orders. Perform quantitative analysis around pain points we face in the organization, as well as leading and directing others to run analysis and present their findings*Created automated Alteryx workflow to consolidate 4B+ data points into manageable format that can be used for supporting executive business reviews, earnings supports, etc.*Developed and implemented a new process to address vehicles that require parts not available in depot stock. Analyzed 10M+ parts within the dealer network and created scoring mechanism to prioritize parts dealers are most willing to sell across the network. Trained team on new system and built out work instructions along with a call script to contact dealers. Increased success rate from prior process by 2.6x

Dearborn, Michigan, Us

*Revenue Management and Variable Marketing*Developed/tested thesis for how commercial customers will react to macroeconomic changes and what measures can be taken by Ford*Analyzed VIN level detail on orders, vehicle stock and sales to find trends on vehicles and share insights with senior management*Created Alteryx data workflow tying together company data and integrated cleaned data into Qlik Sense dashboard. Data sourced includes order, financial, vehicle milestone, and vehicle attribute data. Provides new capabilities to the executive team to make vehicle line decisions in real time, leveraging data. Over 160 users across the c-suite level, finance, marketing, and operations. Product supports weekly commercial leadership meeting and is major supporting tool in achieving corporate transformation goals*Acted as liaison between finance and sales operations to ensure that deals with customers are being completed correctly*Partnered with marketing to strategize on complexity reduction across the commercial portfolio

Dearborn, Michigan, Us

*Automated the daily plant cost report w/ 83% run-time reduction transforming the process from data gathering into actual analysis *Rolled out learnings from automating reports to other plants to help widen the impact of the new-found capability within finance saving 800 hours per year in time spent building reports *Tracked and verified that internal controls at the plant were effectively implemented to reduce risk of errors in reporting *Recognized as a “top performer” each full year eligible – distinguished as performing in the top 10% of analysts at Ford

Dearborn, Michigan, Us

Supported the financials behind the manufacturing of the Ford Explorer and Lincoln Aviator. Leveraged big data to analyze plant performance on a daily basis (Utilize Hadoop, Alteryx, SQL). Communicated with departments and drive cost improvement. Provided strategic thinking on how to roll out modernization projects to manufacturing plants throughout North America. Helped with integration of new processes and provide support where needed.

Dearborn, Michigan, Us

Assisted with the preparation, reviewing, and submission of Ford Credit SEC Filings along with monthly and quarterly closings and other special projects as needed. Responsible for building the Statement of Shareholders' Interest, Statement of Comprehensive Income and providing inputs for other footnotes. Consolidated global data that is used for reporting purposes

Provo, Ut, Us

Teaching assistant in the accounting, investments and advanced excel spreadsheets classes. Helped students understand accounting principles and how to use excel to analyze business problems. Taught investment principles such as CAPM, Alpha, Sharpe Ratio in small group settings.

Dearborn, Michigan, Us

Worked on the healthcare finance team and helped streamline the process of obtaining actuals used for forecasting. Provided a tool that was implemented to cut down the forecast process time by 80%. Tool provided team with capability needed to run month-end reporting, and stop using original software ($303k annual cost save).

Arlington, Tx, Us

Created macros that decreased working time on everyday tasks by approximately 50%. Performed revenue analysis to determine highest grossing periods. Used ERP system to mine data for ad hoc analysis

Generated reports to present financial and market research to company leaders. Performed research on TAM, pro-forma financials, and a SWOT analysis to view competitors in the building materials industry

Arlington, Tx, Us

Worked in the Legacy Farms subdivision in Saratoga Springs (300+ homes). Prepared homes for inspections and ensured that the new homeowner would be pleased with the work done by thoroughly checking the home for any issues. If issues were found then I would perform light repairs, and if anything beyond minor cosmetic repair was needed then sub-contractors were notified to come in and make the fix

Master Of Business Administration - Mba

Bachelor'S Degree, Finance, General

Minor, Spanish