Post Job Free

Resume

Sign in

Financial Analyst Sql Server

Location:
Seattle, WA
Posted:
June 21, 2018

Contact this candidate

Resume:

Sean L. Baugh

Current Contact:

541-***-****

ac5yg9@r.postjobfree.com

Personal University of Denver

Education Major: International Business

Experience

**/** – 03/18 The Resource Group

Consultant

BI360 Reporting for Clients throughout the western U.S.

Integration of disparate systems into the BI environment for Dashboard(s) and Data Warehouse based Reporting

05/17 – 08/17 Sound Physicians

Senior Financial Analyst

Budgetary and Reporting assistance).

Kaufmann Hall integration analysis in preparation for fiscal Budget

02/17 – 05/17 RobertHalf Inc.

Senior Budget Analyst – Operations Finance (Franciscan)

Lead the FY 2018 Budget creation and training to all Account ‘Owners’ for the PNW Region of CHI (Franciscan).

Manage reporting, (Intra-system) created using (SQL Server and Oracle)

Participate in the weekly, and Monthly analysis, and preparation of financial statements for the region including monthly conferences with Staff, across CHI corporate, to discuss and resolve system integration success’ and ‘struggles’ in order to further advance the organization in preparation for 2019 Budget process

03/16 – 09/16 TEKsystems Inc.

Senior Analyst – Technical Operations (Comcast)

Manage reporting, both Legacy and Newly created (SQL Server)

Participate in the periodic analysis and preparation of written summaries of analysis of assigned areas; able to present analysis to senior leadership

5/15 – 01/16 Providence Health & Services

Senior Financial Analyst

Prepare consolidated monthly, quarterly and annual financial reporting for presentation to Senior Leadership out of Hyperion.

Partner with all levels of the organization to provide ad hoc financial analysis and recommendations to support business decisions for efficiently accumulating, analyzing and reporting financial information.

Sharepoint Administrator for Regional reporting and task management

Created lot of custom reports using complex stored procedures and Crystal reports

Participate in the monthly analysis and preparation of financial statements for the region including monthly written summaries of analysis of assigned areas

Lead for financial reporting standardization projects between health system entities (Lawson).

8/14 – 5/15 SEFNCO Communications

Senior Business Analyst

Create, Maintain, and Distribute Financial Forecast and Reporting templates (Oracle and Excel based) at the Corporate, Regional, and Local market levels

Create Ad-hoc reporting for Senior Management, used in shareholder and banking reviews

Present Financial Forecasting to Senior Management at Quarterly and Monthly ‘SYNC’ meetings at Corporate Headquarters and Regional offices

Design and implement reporting ‘Dashboards” for use by Field Technical staff and Management resulting in increased efficiency of operation

9/12 – 8/14 Comcast Cable Corporation – Engineering Operations, HFC Engineering

Analyst 3 (Contract 9/2012 to 10/2012, REGULAR thereafter)

Create, Maintain, and Distribute Financial Forecast and Reporting templates for the Washington Engineering, Planning, Design and Construcction Department

Manage and maintain database operation, functions, administration, and support for all users in the West Division of JOB TRACKING

Directly involved in planning, development, and implementation of PROJECT TRACKING Oracle Database application in all other WEST DIVISION regions

Create and maintain all USER accounts with proper access levels, permissions upon request and approval along with training and supervision of Analyst staff

5/12 – 9/12 PACE Staffing – Multicare Health System, FDSTacoma, Washington

Senior Financial Analyst

Simplify and automate Financial Data Systems data migration and reporting processes for bi-weekly, monthly, and quarterly review and distribution

Collaborate with Controller and SEC reporting teams to create more timely and effective data warehouse mining tools and procedures

Create and train team of Analysts on reporting created in newly implemented Business Intelligence platform integrated through EPIC and MS Access\

2/11 – 5/12 TrueBlue, Inc. Tacoma, Washington

Senior Financial Analyst

Manage vendor relationships and procurement strategies for all brands and corporate headquarters: gross spend of more than $65 million annually

Create, maintain, and distribute all forecasting models used to promote pricing strategy development across five subsidiary brands using advanced Excel, Access, and SQL Server

Create and integrate advanced Visual Basic (Excel) and SQL Server reporting tools and templates out of PeopleSoft for revenue trending, and pricing analysis’ to be distributed and presented to Senior Management each month

Led team in creation of Monthly and Quarterly Compliance reporting

12/09 – 2/11 Morgan Stanley Smith Barney Tacoma, Washington

Financial Advisor

Prospect for and maintain client accounts (both business and individual) for funding, financing, retirement, risk management, and estate planning needs

Held Series 7, and 66 licenses, as well as Washington State Life and Health insurance licenses

9/08 – 12/09 Troon Golf Inc. Corporate Headquarters, Scottsdale, Arizona

Regional Controller & Senior Financial Analyst

Completed the fiscal review and distribution of monthly, quarterly and yearly financial analysis reports of 180+world-class golf properties worldwide

Trained and managed on-site Accounting/Finance staff responsible for daily operations and functions using industry standard, GAAP compliant methodologies and practices

Responsible for Month-End Close review and Reconciliation Audit(s) of 13 Golf/Hospitality Properties in the United States

Under tight deadlines, presented analysis of compiled financial reporting for all properties worldwide to the COO and CFO weekly in an effort to manage cash flow and revenue growth

Created and maintained all fiscal/budgetary processes that governed daily operations including cash flow forecasting and requisition

Developed and distributed budgeting, reporting, and forecasting templates created using Microsoft Excel via Visual Basic (Macro) to manage 180+ properties’ while also training the staff worldwide to integrate

3/08 – 9/08 Troon Golf Inc. Oceanico Group USA, Pinehurst, North Carolina 3/08-9/08

Finance Manager (Interim Role)

Was responsible for the financial management of all divisions of Oceanico Group USA

Prospected for and obtained funding for future development projects from Banking Institutions on the East Coast and throughout Europe

Created all fiscal/budgetary processes to manage daily operations including cash flow forecasting for multi-billion dollar acquisitions – which included migration to Dynamics ERP

Developed audit and analysis processes to ensure GAAP and Sarbanes-Oxley compliance in all financial reporting to lenders and the Board of Directors

Was also responsible for all IT infrastructure and maintenance including software implementation and training

Developed Human Resources Policies and Procedures including the Employee Handbook which brought all hiring and Human Resources policies into compliance with State and Federal regulations

8/06 – 3/08 Troon Golf Inc.Broken Top Club, Bend OR 6/07-3/08Sandpines Resort, Florence OR 8/06-6/07 Sr. Property Accountant

Was responsible for the financial management of two world-class resorts and private clubs including tax planning and accounting, all accounts receivable and payable, as well as payroll for 75+ employees

Prepared and presented all financial reporting and analysis to ownership monthly and quarterly

6/04 – 8/06 Strategic Financial Partners Denver, Colorado

Financial Advisor

Prospected for and maintained 50 client accounts for retirement, risk management, and estate planning needs

Held Series 6, 63, and 65 licenses, as well as Colorado Life and Health insurance licenses

Activities - Early Experience Scholarship (University of Denver)

And - University of Denve rDeans’ List 2001, 2003, and 2004

Honors - Avid Golfer, and Guitarist



Contact this candidate