Business Analyst Intelligence

DAVID HOUSE

North Haledon, NJ ***** 973-***-****

****************@*****.***

SUMMARY

Results focused Senior Business Analyst with expertise in providing strategic data-driven recommendations to internal and external clients at all levels of management. Proven record of success in implementing automated reporting processes and data visualizations saving time and effort in complex analytics and scenario modeling.

PROFESSIONAL EXPERIENCE

FLOWBIRD, Moorestown, NJ 2024 – Present

Business Intelligence Analyst

•Rebuilt Apache Superset data visualization tool including requirements gathering and documentation, data modeling and visualization best practices.

• Creation of predictive analytic reports in Apache Superset for parking meter maintenance and sales in NYC DOT operations

•Creation of solutions to user data issues through data stories and data driven recommendations

•Squad leader for NYC Data and Analytics project

BAE SYSTEMS, Wayne, NJ 2019–2023

Sr. Business Intelligence Analyst

•Creation of predictive analytic reports in Power BI for supply chain management.

•Upgrading and maintaining Operational Excellence reports for Partner 2 Win initiative and defect reporting for use in supplier scorecards sent on a monthly basis.

•Conversion from excel based reporting to automated reporting utilizing Power BI with data updated daily and visualizations for use in presentations to management.

•Promoted for cultivating a data driven decision making culture within department.

•Conversion of existing Power BI reporting and visualizations to Tableau

•Complete Tableau report generation from data modeling to scheduled automation

•Advanced SQL server skills utilized in data modeling, data mart generation, stored procedure creation and data validation for reporting purposes.

SUMMIT HEALTH MANAGEMENT, New Providence, NJ 2017–2019

Data Analytics and Reporting Specialist

•Completed reporting specifications and implemented reporting for Annual Wellness Visits and Transitional Care Management to determine compliance with Summit Medical Group goals.

•Created baseline reporting to determine current performance of physician group in regards to quality measures such as BP monitoring and Vaccine Administration

•Team lead for 3 reporting specialists assisting in prioritization and work flow analysis.

•Microsoft SQL Server complex query writing, stored procedure creation and database management for automated and ad-hoc reporting.

•Implemented the use of Master Data Services for Universal Physician Incentive Program in management of physician reporting and use with Power BI visualizations.

NTHRIVE, Saddle River, NJ 2009–2017

Senior Business Analyst

•Converted existing reporting system to Tableau based reporting system with data visualizations improving the external reporting process

•Microsoft SQL Server complex query writing, stored procedure creation and database management for automated and ad-hoc reporting

•Completed reports based on hospital contracts with multiple payers to determine effectiveness of current interventions by nThrive in the hospital’s revenue cycle.

•Supervised four business analysts by setting up reporting workflow and prioritization packages.

DAVID HOUSE PAGE TWO

•Supported current client meetings with Cash Aging, Key Performance Indicator and various streamlined actionable Tableau reports saving time and effort in the creation of presentations.

•Created executive management presentations to current clients including Tableau demonstrations.

OSG BILLING SERVICES, Englewood, NJ 2008-2009

Financial Analyst

•Revised an Access based reporting system to produce management level reports and dashboards.

•Developed and implemented transition plan moving financial reporting system to the TM1 system.

•Developed budget models for all departments rolling administrative expenses, salaries, cost of goods sold and revenue data into overall balance sheets for the company.

•Created a model detailing and summarizing revenue and gross margin by client for each product.

•Reported directly to the CFO and assisted in executive management presentations.

AMERICHOICE, Newark, NJ 2006-2008

Senior Medical Cost Analyst

•Developed National Trend Binder Medical Cost and Utilization Model.

•Identified data integrity issues within the data warehouse reporting system and assisted in developing corrective actions.

•Supported regional cost containment initiatives based on the data from the medical cost model.

•Supervised two medical cost analysts in production of the trend binder model and other reports.

AETNA, Blue Bell, PA/Middletown, CT 1995-2006

Financial Analyst, Northeast Region Medical Economics (2002-2006)

Financial Analyst, National Contracting and Reimbursement Strategy (1999-2002)

Internal Audit Specialist (1998-1999)

Contract Management Specialist (1995-1998)

•Developed a contract comparative analysis database and report utilized in pricing contracts.

•Led multi-departmental contract analysis project for the Connecticut and Rhode Island regions.

•Identified system process improvements to prevent overpayments.

•Developed budget framework for national level contracts.

•Assisted in the planning phase of audits including risk assessment, documentation of processes with customers and business control analysis.

•Team lead for the Medicare claims audit, receiving an award for excellence.

•Interpretation and entry of contracted agreements within the provider contracting system.

•Led the specialty capitation team, maintained all aspects of specialty capitation tables and developed a training reference manual for the specialty capitation system.

SOFTWARE EXPERIENCE

•Power BI advanced user in creation of automated reporting and data visualizations.

•Tableau advanced user in creation of automated reporting and data visualizations.

•Microsoft Excel advanced user with experience in pivot tables, v-lookups, and macros.

•Microsoft PowerPoint utilized in creation of executive management presentations and reports.

•Microsoft SQL Server Management advanced user with thorough knowledge of SQL queries, data modeling, stored procedures and data validation

•Microsoft Access advanced user with experience in creation of database models, reports and queries.

•JIRA user managing multiple data projects

EDUCATION

B.A., Business Administration, Eastern University, St. David’s, PA

Contact this candidate