Position created to support Operations Director with data analysis and reporting activities. Position eliminated due to business realignment.* Designed a new Sales Report showing Actuals to Forecast results by Agent. * Creation of a data quality report for the job and placement orders being entered into the bullhorn ATS system as part of data management/preparation for reporting out of Power BI. * Begun work on developing work on Power BI reports using Excel and Access DB tables as sources of data for Consultant Bookings and Placements data – both actual and forecast results.

Contract role to analyze and visualize datasets in Power BI for an IT department for one of Robert Half Technology clients (Emerson Electric). * Developed 3 summary reports (which included interactive detail pages) covering Servicedesk ticket item metrics tied to the department using Power BI On-Premises service with predefined datasets.* Created and published a Kanban report set related to IT service support items and projects.* Provided ad-hoc support to a sales team by generating map visuals using Power BI for an analysis on Utility Rebate Products.

Performed business intelligence and analytical responsibilities supporting inpatient operations within the Hospitalists’ department. Leveraged expertise in Microsoft Excel to build PowerQuery scripts, PowerPivot data models and Dax calculations to aggregate inpatient data for managerial reporting. Collection tools used to gather data included Epic Reporting workbench, EPSi Reporting Portal, BusinessObjects and internal datasets. Position short-lived as it was eliminated due to budget cuts.

Built tabular and graphical reports for the Ambulatory Quality department in Microsoft Excel pertaining to the ACO Quality Measures for Medicare and Medicare-Advantage patient populations. Contributed to the success of multiple data analytics assignments. Reporting packages covered managerial and clinical summaries in addition to supporting details for 48 clinics throughout the Springfield community.*Recognized for re-engineering the Triple Aim package, building a summary of 10 detail reports sorted by management, clinic, and providers. Leveraged the use of Power Pivot data models, DAX calculations, OptumOne and multiple Excel spreadsheets to aggregate data for integration into graphics and presentations.*Innovated a scorecard report to support annual performance reviews of primary care physicians, pulls data from multiple data sources (both internal and external, OptumOne and survey data) into Excel presentation files.*Power BI mini projects: geo-code and map location data for a report request from the Care Management Director engaged in the analysis of a subset of patients who frequented the ER. A second project was to map primary care clinics, providing a visualization of zip code overlap for a Services Allocation project.

Contracted to develop project status reports and dashboards within Innotas (now Planview PPM Pro), a cloud-based Project Portfolio Management(PPM) application for their client, Informatica.* Delivered 2 summary project status dashboards using data from 9 newly created reports within the application.* Researched and worked with Innotas’ support team to unlock the API data points to support an ETL process build related to phase 1 of a CIO dashboard project.* Facilitated coordination and communications between Informatica and the software vendor with respect to setups, enhancements, and environmental instances (Sandbox and Production) to support implementation of requested changes/customizations related to reports/dashboards.

Transitory position for the corporate integration between Sun Micro and Oracle America. Provided service as a subject matter agent to Oracle Collection team related to the Sun Microsystems AR reporting environments and data for subledger reporting.

Supported the management team within the Sun Global Invoice-to-Collect Business Unit with data analysis, operational reporting (assigned and ad-hoc requests), and some financial/audit reports as part of the Global Accounts Receivable reporting team. Assignments included: * Guided a small cross-functional team as to the account reconciliation and documentation on a legacy customer bankruptcy case at the request of US Sales Legal department. This resulted in more than $1.6M USD recovery checks issued from the Bankruptcy Court to Sun and a special cross-organizational award.* Member of the US AR Conversion Reconciliation team converting mainframe Receivables data to Oracle 10.7 instance. Final reconciling items totaled $185 on $805M in open A/R converted into Oracle A/R resulting in a Special Project Recognition Award.* Supported US and Latin America regions as to Customer Returns for Credit reporting. * Liaison to US Revenue Accounting for assigned audit schedules – Period 9 and Year-end audits for Trade A/R. * One of Two Data Analysts acting as front-end data support of the Global Accounts Receivable Data Warehouse which served an international community of 200+ users.* Received a Peer recognition mention announced by my director during a quarterly organization meeting for supporting the business during a major data warehouse outage.* Initiated a standard process spreadsheet template for reconciliation between the Global AR data warehouse and the Oracle Transactional subledger system for data quality and integrity. * Accounts Receivable Reporting SME attached to the Invoice-To-Collect Reporting track of the Oracle 11i upgrade project. We were tasked with developing a new corporate Trade Receivables reporting system for Sun Microsystems ($12B in Sales at the time) at global, regional, and local transaction levels using the OBIEE application. See Project details below under Sun Project IBIS (Oracle 11.05.10i Upgrade)