Current Consulting Project• Create and improve Power BI and SSRS dashboards that offer valuable insights for stakeholders.• Improve existing report logic to provide up-to-date analysis for accurate decision making.• Work with stakeholders to understand reporting needs and determine designated sources to retrieve requested information.• Manage and prioritize project requests to ensure deadlines are met.

• Create and maintain Power BI dashboards for Operations team and clients.• Act as the business liaison between IT and Operations.• Identify reporting needs and define criteria for key stakeholders to organize requirements for the IT team.• Manage Power BI tables using Visual Studio and creating Dax formulas.• Work with clients to understand reporting needs and determine designated sources to retrieve requested information.• Manage and prioritize project requests to ensure the IT team meets deadlines.• Support the Operations team with technical help and be the SME on data inquiries.

• Built complex queries to create and maintain Fact Table for all products sold via online and in-store channels.• Organize weekly and monthly plan, considering all criteria and timing of seasonal sales, to complete Online to Store SKU conversion.• Retrieve data for ad hoc requests using Google BigQuery, Tableau, and Excel.• Create slide presentations to present weekly plan updates and potential challenges to leadership.• Provide weekly project updates and manage weekly task priorities.• Act as the business liaison between IT and Operations.• Communicate with suppliers to inform them which products are planned for One SKU conversion.

• Completed data integration in SQL to enable users to retrieve tax information for audits via PowerQuery/PowerPivot.• Built SQL queries to retrieve data requested by various departments.• Built SSRS reports to automate processes and enable users to retrieve information.• Produced reports using Tableau and Power BI for C-Suite level management.• Created monthly revenue reporting in MS Excel for C-Suite level management.• Created revenue reports and ensured accurate mapping of information by entity for monthly tax filings.• Automated monthly reporting for tax department and C-Suite level management using SQL, MS Excel, and MS Access.• Worked with Business Intelligence to ensure accurate data was provided for audit preparation and monthly reporting.• Analyzed and organized data to assist with pricing projects.

• Tracked monthly expenses and revenues on projects related to facility closures, organization restructuring, and operations integration.• Worked with Project Managers and HR Directors to obtain information on future costs and provided projections to executive leadership.• Managed fixed asset capitalizations, transfers, retirements and managed monthly records.• Provided financial reporting on all investment projects to executive management.• Estimated investment return using NPV, IRR, and Payback methods.• Ensured proper documentation for 1099, W-8 BEN E, Sales by State, and Asset tax filings.• Reconciled accounts and completed monthly journal entries related to benefits and reclasses.

• Provided detailed monthly and year-to-date variance analysis on expenses of $150 million to VP’s, Directors, and Cost Center Owners, and worked with all business partners to meet budget tasks.• Reported monthly, quarterly, and annual expenses plus headcount for Global Quality, Regulatory, and Clinical Affairs to the Senior VP, VP’s, and Cost Center Owners.• Created presentations and completed ad hoc projects for the Senior VP and the Director of Accounting related to Cost of Quality and other projects.• Provided NPV estimation for capitalization requests on assets valued at $25,000 or more. • Led VP’s and Cost Center Owners through the 2015 budget process and communicated leadership objectives.

• Tracked and audited expenses directly funded by Title I, Title II, and No Child Left Behind Act.• Budgeted expenses for all campus departments by working with team leads and executive leadership to fulfill academic goals while operating within financial constraints.• Provided financial reporting and variance analysis monthly, quarterly, and annually to team leads and upper management.• Forecasted monthly and quarterly expenses by department, reconciled accounts, and processed payroll for all campuses.• Reconciled accounts and completed all month-end journal entries.• Managed and processed payroll for all employees using ADP and Paycom.