Financial Analyst Sql Server
Resume:
Sean L. Baugh
Current Contact:
****.*****@*****.***
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