Rick Brooks Email & Phone Number

Texas, United States

United States

United States

United States

Richardson, TX

Streamlined and automated legacy reporting processes Created ad-hoc reports, metrics calculations documentation, and training materials Analyzed complex business problems and issues to provide insight to decision-makers Partnered with business areas to develop and document business requirements Identified and interpreted trends and patterns in datasets to.

Richardson, TX

Performed research and assisted in analyzing financial and health data, including medical algorithms to determine health care expenditures, medical and economic outcomes, and cost containment strategiesAnalyzed complex business problems and issues for decision-makers Identified and interpreted trends and patterns in datasets to locate influencesDeveloped.

Richardson, TX

• Developed executive and operational dashboards in Tableau using multiple data sources
• Developed semantic data layer based on dashboard requirements in Oracle, SQL Server, Teradata
• Improved and documented productivity goal sets process handling for EHCM clinical division
• Installed, configured, maintained Tableau Server development and production environments
• Developed and administered ETL processes using extracted data from various sources into data marts, tables, and views for Tableau using Oracle, Teradata, SQL Server, and Business Objects Data Services (BODS)

Dallas, TX

• Produced financial reports using Crystal Reports, SQL Server Reporting Services (SSRS), Access, Excel
• Performed analytical modeling, forecasting, and trending in Excel and R (Rattle, R Studio)
• Developed self-service dashboards/visualizations using Qlikview
• Facilitated the overall development, implementation, and use of the association’s data infrastructure
• Managed various implementation and integration projects with vendors

Plano, TX

• Created financial dashboards using data extracted from various systems in Excel
• Worked with EMEA, APAC, LA and NA marketing groups in developing metrics and identifying KPIs
• Streamlined and automated partner rebate program processes
• Conducted root cause analysis of operational trends and identify variations in key performance indicators
• Developed ad-hoc reports in SQL Server Reporting Services (SSRS)
• Created user stories and Proof of concepts for new initiatives

Richardson, TX

• Gathered specifications and business process requirements for the application from various business areas for application integration and implementation
• Identified the business rules and requirements and then documented them into format that can be reviewed and understood by both business areas and technical resources.
• Built and maintained workflows, individual project schedules, budgets, issue/ action logs, contact lists and other project documents in Microsoft Project, Microsoft Visio
• Tracked project status and key deliverables against milestones and budget and reported to sponsors/stakeholders
• Ensured all issues/actions/ decisions are identified, documented, assigned and resolved promptly
• Conducted end-user testing and data validation

Dallas/Fort Worth Area

• Performed research, statistical reporting and analysis related to client administration of the Work Opportunity Tax Credit (WOTC) and other analogous tax incentive programs using Statworks, Excel, Access
• Defined, developed and modified processes to streamline workflow and increase quality and efficiency
• Performed data audits and program compliance analysis
• Worked with off-shore team in modifications to proprietary programs
• Assisted in identifying, evaluating, and developing business processes and workflows.
• Developed and administered ETL processes using SQL Server Integration Services (SSIS)

Grapevine, TX

• Produced analytics reports for Verizon SMB and online marketing divisions
• Developed models and documentation to support business requirements
• Performed research, statistical reporting, and analysis using Excel, Access, and SQL Server Analysis Services (SSAS)
• Assisted in identifying, evaluating, and developing business processes and workflows.
• ETL development and administration using SQL Server Integration Services (SSIS)
• Identified, reported, tracked and updated incidents, system reports, and logs

Master Of Business Administration - Mba, Business Intelligence & Analytics

Masters, Management Information Systems, General, 4.0

Bachelors, Education