Brad Andrews Email and Phone Number

Pioneered the adoption of PowerBI and other modern business intelligence tools, successfully developing and leading training sessions for employees across the organization.Created PowerBI reports and dashboards that deliver actionable insights into shipbuilding operations, significantly improving decision-making and operational efficiency for all leadership levels, including the CFO and CEO.Leveraged SQL and PowerBI to transform legacy static Excel-based business processes into dynamic streamlined reporting solutions saving on average a week of report development time per report.Served as an internal business intelligence consultant, developing dashboards, reports, and tools for various departments across the company.

Developed PowerBi reports and dashboards that provided insight into credit union operations, yielding operational insight and time savings.Used Python and Power Bi to provide what if analysis of daily member rebalancing, leading to efficient and balanced goal setting.Developed a product level profitability analysis of all credit union products. Identifying those that are most profitable and popular to guide marketing decisions.Built tracking solutions for marketing, enabling them to effectively track their campaign status and effectiveness in near real time.

Improved reimbursement identification and data analysis by creating customized SQL-based rules-based analytics to meet both specified and independently identified requirements.Identified process improvement opportunities in existing code and business processes, and implemented solutions to optimize efficiency, reduce errors, and enhance overall performance.Automated the identification and submission of reimbursable claims to clients by managing complex, multistep business processes.Reduced refund workflow time by 75% while increasing quality and quantity of reimbursable claims.Integrated data from multiple sources and ensure accuracy through validation.Developed reports for system health and KPI management using PowerBI, SQL, Python, and Excel.Automated workflows by developing Airflow Dags.Automated business processes by developing Python and SQL programs.

Led reporting and analytics team in report development, process improvements, and research study presentations.Used a variety of software tools, including SQL, Report Builder, Power BI, Excel, and Python, to develop and deploy reports and dashboards for various stakeholders.Developed financial models to forecast key financial metrics and aid in decision -making.Conducted studies of Medicaid member data and implemented improvement plans to improve patient outcomes and HEDIS measures.Developed data pipelines for analytical applications using ETL tools.Analyzed call center data to ensure high customer satisfaction.Collected and analyzed geospatial data to identify regional variations in performance and ensure adequate coverage of provider services.Identified fraudulent and wasteful service activity conducted by providers through analysis of claims data.Increased operational process performance by 4,700% through automation using SQL and Excel.

Led engineering, production, and process improvement projects from start to finish as a project manager.Managed teams of engineers and technicians in product design, development, and production.Successfully transformed service department by identifying and implementing new IT solutions.Used data analysis and Lean Six Sigma methodologies to achieve cost savings and improve product quality.Programmed, setup, and operated robotic tools to manufacture parts for the Marine industry.

Provided valuable analysis and support to credit union leadership, ranging from Vice President to CEO, to help make informed decisions.Automated reporting activities using SQL and Business Objects to increase the quality and efficiency of reporting operations.Developed actionable insights by creating Business Intelligence reporting solutions using a variety of software tools, including MS Excel, MS Access, Business Objects, SQL, and Cognos.Designed a bonus program for over 1,000 mortgage processing employees using data-driven analysis and metrics, which increased productivity by 20%.Led a team in designing a new financial product, which involved gathering requirements, conducting research and analysis of potential customers and competitors, and building a return on investment model.Improved operational efficiency and quality in the mortgage department by leading a project team to identify, codify, and deploy best practices across the business unit.Developed a marketing strategy using customer and demographic data to identify target geographic regions.Forecasted company-wide production rates using predictive models.Optimized credit union processes using Excel Solver.Regularly presented analysis to executive leadership.

Deloitte & Touche National OfficeDeveloped and deployed a Project Management Office (PMO) for the Office of the CEO; developed processes governing all aspects of the project lifecycle.Facilitated the operationalization of developed processes for the Office of the CEO's PMO, including the development of tools and documentation, and prepared presentations to brief firm leadership on PMO operations.Led CEO-requested projects to improve audit quality activities across the Big 4 Firm, overseeing all phases of the project lifecycle as a Project Manager.Conducted data analysis on Firm senior leadership nationwide, identifying areas for improvement in Firm-wide processes and implementing successful improvements.Prepared recurring status reports and presentations for CEO briefs that informed strategic decision-making.Gathered project requirements, designed and developed technology solutions, and administered projects for clients using SharePoint, Excel, Access, and SQL.US Navy Special Warfare (Project Management, Process Design and Improvement)Managed the budget and schedule of multiple engineering projects while implementing tools and processes to manage and control project costs.Developed and managed an earned value tracking and reporting system, which enabled accurate financial tracking and produced regular financial status briefs for senior program leaders.Developed Business Intelligence reporting system for program leadership. Dashboards provided leadership with overarching understanding of the program’s status, yielding a 20% increase in management efficiency Developed tools and documentation needed to facilitate the operationalizing of developed processes for Office of the CEO’s PMO; prepared presentations to brief firm leadership on PMO operations.Led CEO requested projects to improve audit quality activities across the Big 4 Firm through all phases of the project lifecycle as a Project Manager.

Provided financial and project management services for multiple US Navy clients with emphasis on earned value management and schedule management.Developed robust cost surveillance and reporting system that provided better insight into a client’s program wide financial performance as well as reduced report preparation time by 80%.

Reviewed federally charted bank operations and processes in order to detect fraud, waste, and abuse