William Roper Email & Phone Number

Portland, Or, Us

Vancouver, Washington, United States

Leveraging expertise in financial systems, data analysis, and reporting in a cross-functional collaborative capacity to administer and develop the systems and reporting capabilities used by a highly skilled team of FP&A professionals focused on periodic and ad hoc reporting, forecasting, post-acquisition evaluation, value creation, and KPI alignment within the vet-health space.

Vancouver, Washington, United States

Working with a highly skilled team of FP&A professionals focused on periodic and ad hoc reporting, forecasting, post-acquisition evaluation, value creation, and KPI alignment within the vet-health space.

Portland, Oregon Area

Serving clients as a full-time employee of Robert Half by filling senior-level finance and accounting roles on an interim basis, and by providing technical expertise and leadership on project-based engagements. Specializations include financial analysis, budgets, forecasts, complex reconciliations, COA conversions, ERP transitions, data extraction, data validation, data mapping, performance measurement, compensation models, dashboard development, ad-hoc reporting, and full-cycle accounting.Whether your financial data is housed within a legacy application like MedSeries4, has just been migrated to an Oracle-Hyperion Fusion environment, or lives on a Microsoft platform, I work with applications like SSMS, Visual Studio, SSIS, Oracle SQL Developer, Oracle Finance, Oracle Analytics Cloud, SAP Business Objects, Tableau, Power BI, and Excel to extract and transform that data in order to give my clients the accurate insights they need to improve processes and answer their most pressing business questions.

Portland, Oregon Area

Sester Farms is one of the largest wholesale nurseries in North America with approximately 1,500 farmable acres in the greater Portland Metro area. Reporting directly to the executive leadership team, I:• Developed ETL processes to bring nascent Visual FoxPro data into a SQL environment• Structured the RDBMS in MySQL Workbench, linked the server as an object in SSMS, and worked within both environments to build managed datasets for reporting purposes • Used Power Query and Power Pivot to blend and join legacy data with actively maintained production data sources in MS Access and Excel • Configured QDBC drivers to integrate financial data from Quickbooks Enterprise• Developed a reporting infrastructure for users comfortable with MS Excel, and able to adopt data delivery in visual form using Power BI• Took an activity-based costing model from concept to production • Using trend analysis, I defined the logic used in auto-populating marketing tools customized by historical spending behavior• Improved revenue reporting accuracy by more than 3.5% by improving on data validation methodologies in routine reporting processes

Portland, Oregon Area

Audigy Group is a privately held Management Company offering comprehensive consulting services to clients within the healthcare industry. Reporting to the Director of Finance and the VP of Membership Development, I conducted extensive financial analysis and built reports for my clients and team. *Defined distinctive KPI’s for international markets*Developed and delivered strategic plans for clients and executives*Delivered ad hoc reports (expansion analysis, gap analysis, operational effectiveness)*Created and implemented strategies to reach financial goals*Presented complex financial and accounting information to clients and executives*Conducted QA testing for integration of new financial reporting platforms*Established reporting infrastructure using DAX and SQL to monitor financial performance for executives and clients*Assisted clients with acquisition due-diligence and expansion analysis

Troutdale, Or

Troutwood Inc. is a privately held retailer of petroleum products that has been serving the Portland Metro Area over the past 40 years. Reporting directly to the President, I worked with a high degree of autonomy to manage the company’s daily operations. This position demanded the application of a very high-level of business acumen, and my compensation was tied directly to bottom-line profitability.*Performed ongoing, extensive market research*Analyzed commodity pricing trends and formulated retail pricing strategies*Maintained market share in highly competitive, saturated markets*Consistently grew gross profits year-over-year, for more than 10 years*Delivered financial results favorable to budget, and to industry benchmarks*Performed monthly financial analysis and developed cost-saving strategies*Developed, implemented, and managed internal controls saving more than $100K*Managed capital improvement projects in excess of $125K*Conducted due-diligence for capital expenditures/acquisitions, and expansion analysis*Managed up to 27 employees with turnover ratios well below industry standards*Optimized operations and implemented cost-saving strategies to exceed profitability targets

Vancouver, British Columbia

As a staff-level accountant within the tax group, I worked in a business unit providing comprehensive financial planning and accounting services for privately held corporations, trusts, and individuals. *Prepared financial statements, accompanying notes, and statements of cash-flow*Accounted for complex transactions, capital reorganizations, and consolidations*Calculated and recorded year end adjusting journal entries*Performed account reconciliations*Created fixed-asset amortization schedules*Calculated cost-basis and taxable income from high-volume multi-million dollar portfolios*Prepared corporate income tax returns, personal income tax returns, and tax returns for Trusts*Supported senior management through ad-hoc research in tax law*Prepared & delivered presentations for professional development of peers*Functioned as a proxy controller for the Canadian operations of a US based tech-company

Accounting And Finance

Accounting And Finance

Accounting And Business/Management

Certificate In Recording Arts - Digital And Analogue Media

Theology/Theological Studies