Senior Power BI & SQL Developer Leader

ERIC BROOKS

**** ***** **** **., ***** Hills, California 91709

PH: 626-***-**** EM: ************@*****.*** LI: https://www.linkedin.com/in/eric-brooks-4546a84b/ MSBI DEVELOPER/ENGINEER

Senior SQL Developer with over 20 years of expertise in T-SQL programming and the Microsoft BI stack, including SSRS, SSIS, SSAS, and Power BI. Skilled in designing, developing, and optimizing complex queries, stored procedures, and ETL pipelines, with a focus on performance tuning and root cause analysis in enterprise environments. Proven ability to deliver scalable database solutions and interactive dashboards while collaborating with distributed teams. AREAS OF EXPERTISE

• AREAS OF EXPERTISE: Power BI, SSAS, SSRS, SSIS, SSMS, T-SQL, SharePoint, Power Automate, Python, Pandas, Numpy, ETL, Troubleshooting & Maintenance, Business Development Solutions, Quality Assurance, Process Improvement, Data Governance, Staff Coordination, Training, & Development, Team Building & Leadership, Video & Audio Editing, Graphic Design, Dashboard & Reporting Repository Presentations, Database Performance Tuning, Database Architecture, Data Modeling, Schema Design, SharePoint

• Languages: T-SQL, Python, MDX, VBScript, DAX, HTML, CSS, JavaScript, XML

• Software: MS (Visual Studio, SQL Server Management Studio, SQL Server 2012-2025, Power BI, PBI Report Builder, SharePoint, Excel, Word, PowerPoint, Outlook, Teams), Epicor Prophet 21, Infor Syteline, Adobe: (Photoshop, Illustrator, InDesign, Premium Pro)

• Applications: Power BI, SSAS, SSRS, SSIS, SSMS, Crystal Reports, SharePoint, Power Pivot, Power View, Power Automate, Tableau, MS Office 365, Copilot Studio, AI (ChatGPT, Midjourney, Leonardo.ai), Business Objects

• Operations Systems: SQL Server, Oracle, UNIX, Windows, SQL Server Agent, Active Directory PROFESSIONAL EXPERIENCE

Flow Control Group Feb 2023 - Dec 2025

ERP Reporting Analyst/Developer Charlotte, NC

• Streamlined manager & supervisor workflows by automating report delivery via email, reducing data gathering time by up to 90% through database performance tuning and query optimization

• Design, create, troubleshoot, retrofit and deploy dozens of log jammed reports and dashboards into custom SharePoint portals by refining schema designs, and bringing ticket count down to a consistent single digit count even with new requests submitted daily

• Design, develop, and maintain new interactive Power BI dashboards, reports, pipelines and data models, applying data modeling best practices to ensure scalability

• Created and or managed data, document, form and workflow SharePoint portals for various organizational groups including

(Executive, Mid-level, Operational and Sales managers), Sales reps and Tech Ops utilizing Power Automate and other tools

• Design, create, test, maintain, optimize, deploy and (diagnose & debug) T-SQL stored procedures to eliminating data errors and inconsistencies for dashboards, reports and data feeds, applying troubleshooting & maintenance methodologies

• SharePoint administration (portals, dashboards, document management, training videos, forms, workflows and approvals)

• Perform various maintenance and administrative tasks in Epicor Prophet 21 ERP software application such as security access, manager sales reps, reporting branches, and many others

• Train staff of acquired companies on how to access/view/run reports & dashboards on the various reporting portals and ERP embedded reporting repositories available within the organization environment via Microsoft Teams KForce Jun 2022 - Feb 2023

Senior SSRS Developer Tampa, FL

• Drive Crystal-to-SSRS conversion and provide guidance on migration approach and architecture

• Interface with Vail’s leadership and audit the consistency of reports developed by developer team, performing root cause analysis to identify discrepancies

• Migrate complex reports into SSRS platform, ensuring report performance optimization and providing prioritization of conversion tasks

Dynamic Healthcare Systems Mar 2016 - May 2022

Lead MSBI Developer Irvine, CA

• Architect and developer of the Dynamic Healthcare fully integrated BI Dashboard and Reporting Portal for proprietary Medicare/Medicaid SAAS ERP application

• Supervise and/or perform the design, development and deployment, and maintenance of all Microsoft BI Stack objects (Power BI, SSAS, SSRS, SSIS, T-SQL, MDX, SSMS, OLAP/OLTP databases

• Create and maintain daily dashboard data refresh jobs via SQL Server Agent

• Design, implement, and maintain organizational Power BI & SSRS, cubes & reports across our client base

• Perform internal and external product training via training manuals, Power Point slide presentations, and online telecommunication software

• Perform live product (Dashboards and report) presentations for organization user conference, and existing and potential clients

• Train subordinate contractors to facilitate organizational directives, and projects

• Perform T-SQL Stored Procedure and Query optimization for performance improvement

• Provide organizational guidance and recommendations as to best practices for Data Warehouse, and report implementations

• Developed VB deployment script for cross-server, multi-client SSRS report deployment process

• Deploy SSRS report version upgrades across multi-server/multi-client report repositories utilizing single job/script

• Co-Authored written MSBI Stack post-interview test for employee and contractor candidates

• Interview employee and contractor candidates for BI/SSRS and Business Analyst positions

• Supervise the design, development, deployment, and maintenance of 15 client and internal organization servers and their three report environments (Development, Test, and Production) with a combined total of over 1000 MSBI objects

• Authored all MSBI Stack development SOP organizational guides

• Determine required resource allocations for development and updates/modification projects

• Provide project status reports for management

Anemostat Aug 2012 - Apr 2016

SQL Server/ SyteLine Developer Carson, CA

• Plan, design, develop, and implement application and report form database code objects, such as stored procedures, tables, views, functions, and stored procedure wrappers.

• Design, and develop Syteline ERP user interface panels for report and form parameter passing.

• Create SSRS and Crystal Reports for daily business function and statistical analysis, as well as resource monitoring.

• Troubleshoot and reverse-engineer stored procedures to satisfy the organization’s data requirements, as well as handle data issues; validate result sets; and implement necessary process improvements.

• Maintain both customized and vendor provided reports for data integrity.

• Monitor archive table sizes for optimal system performance.

• Directly coordinate with IT director, President, CFO, as well as other senior management and staff to accomplish the information needs of the organization.

Freelance May 2010 - Apr 2011

Website Developer - Client - Rosalyn Morris Montclair, CA

• Exemplified innovative skills in designing, developing, and creating website and article fashion ensemble displays. Set up and deployed client’s e-commerce website.

Bank of the West Apr 2006 - Mar 2010

IT Application Engineer II Monterey Park, CA

• Rendered support with the installation, maintenance, and enhancement of patches to multiple applications.

• Performed all SQL Server query and stored procedure design, development, and maintenance.

• Took charge of small and medium-sized projects by utilizing all aspects of SDLC.

• Demonstrated expertise in providing effectual technical guidance to junior members of the group.

• Assumed full accountability in rendering 24/7 on-call and off-hour support for the Oracle HR system applications and programs.

• Conducted research, as well as determined, designed, developed, tested, debugged, installed, and modified computer software through various platforms in a complex integrated multi-system environment.

• Administered the entire website portal development by using the HTML, CSS, and JavaScript.

• Directed the collection of data into Oracle database tables from Excel files through SQL loader.

• Served as the lead developer responsible for implementing Learning Management System and creating numerous reports and interface programs.

• Led the development and implementation of dozens of SQL report and interface programs by completing the entire systems development life cycle (SDLC) during major Oracle upgrade. Countrywide Financial Corp

Programmer Analyst

May 2001 - Apr 2006

Pasadena, CA

• Executed the creation and maintenance of enterprise-wide personal data change customized with the use of Oracle application.

• Carried out the overall maintenance of enterprise-wide expense report, direct deposit, and online W4 Form through Oracle applications.

• Provided oversight to the generation of reports, validations, and file interfaces utilizing SQRs.

• Processed the setup and arranged schedule of jobs of process scheduler; facilitated training for users with regard to the setup of their own jobs for automated program execution.

• Regulated the importation of data into Oracle tables from Excel files using SQL loader; expertly used TOAD in extracting data from databases and exporting into Excel files.

• Played a key role in creating, debugging, and upgrading more than 100 SQR programs as well as maintaining of dozens of PeopleCode Programs for various applications.

• Spearheaded the upgrade of the Personal Data Change Application from PeopleSoft version 7.x to 8.x EDUCATION AND TRAINING

DeVry University/Institute of Technology Bachelor of Science, Computer Information Systems

Contact this candidate