Ryan Kirwin, Ms, Mba, Rpcv Email & Phone Number

Sandpoint, Idaho, United States

Bellevue, Washington, United States

Developed and delivered analytics for store operations (7.5K+ T-Mobile and 6.7K+ Metro stores) including ad hoc and planned analysis and solutions. Responsible for production support of group’s IT environment minimizing downtime of field reporting and programs. Streamlined and automated technical processes. Provided direction for group’s technical needs by adopting best practices for automation, reporting, and infrastructure. Developed and maintained productive cross-functional relationships across the organization ensuring data and analytics needs were being met.Selected accomplishments:• Heading up a project to migrate our team to Azure; replacing our team’s Windows desktop (used for job scheduling) and our team’s on-premises MS SQL server with Azure, the new company standard.• Built a process (PowerShell, MS SQL, and Excel VBA), within a constrained timeline, to produce a monthly report capturing nine store operations compliance metrics reflecting the operational health of the fleet of stores; this is sent out via email with a larger field compliance metrics packet to drive operational compliance.

Greater Seattle Area

Selected accomplishments:• Partnered with Sales Operations to define requirements, built an ETL pipeline after finding required data, and created a PowerBI dashboard that 6.7K+ Metro stores and field leadership use daily to track customer device trade-in compliance.• Championed improvements in Windows automation, introducing the benefits of PowerShell to all teammates and establishing it as the standard for performing various day-to-day Windows automation tasks.• Advocated for the department being granted an independent MS SQL production server, versus using servers from other departments, enabling control over our ad hoc analysis and reporting environment.• Resolved a complex BI challenge involving a new T-Mobile store inventory system, creating an innovative new process with PowerShell and MS SQL server; this ad-hoc solution is still running today, 4+ years after initiating it, and is the lynchpin for key inventory data for the enterprise.• Replaced outdated Excel / SharePoint reporting methods with a modern PowerBI solution, identifying and receiving approval for the change and coordinating all training needed for the team to adopt the new solution.• Heavily leverage both MS SQL Server and Teradata SQL in data management and analytics efforts, in addition to currently participating in discussions for migrating future data warehousing to a Snowflake environment.• Coached and developed a person with a non-technical background to pass a challenging internal Excel / SQL test and served as acting technical group manager while supervisor was out (3+ months) for maternity leave.

Greater Seattle Area

Managed a $1B bad debt budget and delivered monthly/annual forecasting, analytics, and presentations.Selected accomplishments:• Inherited a dysfunctional FP&A operation related to Bad Debt operations and led a successful turnaround.• Revamped the EIP / Service financial models and SAS code, reducing forecast times from 4 days to 1 hour.• Automated SAS jobs used for the weekly financial outlook process, saving an hour of manual entry per day.• Facilitated a monthly meeting attended by senior management from the FP&A, Accounting, and Credit teams.

Greater Seattle Area

Managed a $280M handset/device remorse budget and $50M annual handset warranty program budget.Selected accomplishments:• Presented leadership with monthly/annual budget forecasting data, analytics, and recommendations.• Developed multiple Tableau dashboards, one for showing warranty backlog volumes by SKU and another, segmented by channel and device, increasing visibility into return activity for retail store operations.• Created a new channel-level handset remorse dataset in SQL Server at the IMEI level, integrated with SAP.• Overhauled the warranty outlook process to account for specific devices shipped, timing of device shipment and store receipt, and probability of customer pickups—significantly improving warranty fulfillment accuracy.

Greater Seattle Area

Recruited to develop, manage, and maintain a new financial model related to handset upgrades—partnering with Channel Managers and the Market Invest teams to ensure alignment with overall channel strategy.

Wilmington, De

Held series of progressive decision support roles for this leading global banking organization.Selected accomplishments:• Managed an enterprise-wide account tagging process to increase customer up-selling/cross-selling potential.• Completed statistical account profiling analysis to resolve a potential litigation risk involving outside vendors.

Dublin, Oh

Recruited by this top healthcare services firm to migrate a series of MS Access applications into a new SAS platform ensuring data and process integrity.

Jucialpa, Olancho, Honduras, Central America

As a Peace Corps volunteer serving in Honduras, Central America I completed 3 months of in-country technical, cultural, and Spanish-language training. I then served successfully for 24 months in two sites, including Juticalpa, Olancho fulfilling the three goals of Peace Corps: making available my skillset to local people and organizations, to help promote a better understanding of Americans on the part of peoples served, and to help promote a better understanding of other peoples on the part of Americans.During my service I lived in comparable conditions to the local population, I learned to adapt and become comfortable with local customs, and learned Spanish. This was easily one of the most challenging and transformational experiences of my life.Selected accomplishments:• Provided small business development support for a woman-owned restaurant.• Developed training materials for teaching beekeeping in rural Honduras with the goal of harvesting honey for export.• Developed a loan origination software (in Java) to support a microfinance organization.

Colorado Springs, Co

Used C, C++, Java, Perl, KSH scripting, PostScript, regular expressions, and UNIX utilities (grep, awk, sed, ed, cron, regular expressions [regex], etc.) in the vi editor in AIX and HP-UX to develop dispatching system software.Used FORTH to develop SuperTracker hand-held inventory scanning unit software.

Master Of Science - Ms, Economics

Finance / Statistical Data Analysis Concentration

Bachelor Of Science - Bsc, Communications Systems Management

Minored in Business Administration; Area of Concentration in Interpersonal Communication; Cum Laude Graduate

Mba, Business