DOMINIQUE BROUSSARD

Data Analysis & Reporting

Built customized analytical reports for the Community Relations team using PeopleSoft and SQL queries, tracking marketing campaign performance and event KPIs across multiple projects to measure outreach effectiveness and ROI. Developed bi-weekly budget reports with detailed financial analysis to monitor departmental expenditures, identifying trends and providing proactive recommendations to senior leadership. Created data visualizations and Power BI dashboards displaying institutional metrics, event attendance, and marketing performance indicators that improved decision-making accuracy by 25%. Executed complex SQL queries to extract and analyze higher education data from multiple databases, supporting strategic initiatives across campus locations. Applied Data Institute methodologies to develop comprehensive evaluation frameworks focused on data-driven continuous improvement for community engagement programs.

Client Relations & Training

• Serve as lead Subject Matter Expert (SME) for department operations, providing guidance when reviewing reports
• Develops reports using databases to support system-wide projects, including business intelligence and strategic planning
• Collaborate across multiple campus locations to implement consistent best practices and performance indicators for special projects
• Manage community and vendor relationships while resolving complex issues, ensuring effective communication and resolution

Systems & Process Management

• Re-engineer Standard Operating Procedures (SOPs) to ensure efficiency, documentation, and regulatory compliance within marketing campaigns and successful community events
• Process and monitor compliance documentation, maintaining accuracy in all record-keeping systems
• Ensure adherence to local, state, and federal regulations through systematic data validation

Financial Operations & Budget Analysis

• Execute daily financial operations including accounts receivable, accounts payable, purchase orders, journal entries, and procurement processes for the department
• Coordinate project timelines and deliverables to ensure on-time completion of key initiatives
• Resolve complex accounting issues through analytical problem-solving and system expertise

Data Management & Financial Reporting

Developed and maintained database applications supporting system-wide projects including business intelligence dashboards for project recruitment and community retention analytics that informed strategic planning across all LSC-HN locations. Served as PeopleSoft super user for the Community Relation's departmental financial budgets, writing and executing SQL queries to monitor and analyze Community Relations and the HN Commencement budgets totaling $500K+ for trend identification and forecasting. Created financial reports with integrated data visualizations including weekly budget analysis, statistical summaries, and variance reports that streamlined executive decision-making processes. Worked extensively with higher education data including Chief Strategist accounts by using applied database management and query optimization techniques to reconcile billing data and payment records while ensuring accuracy and policy compliance through systematic data validation.

Training & Technical Support

• Created and coordinated training materials for department procedures
• Provided technical guidance and support to staff on database systems and reporting tools for better marketing submissions
• Researched and analyzed sensitive issues, determining appropriate data-driven remediation strategies within our social marketing avenues
• Developed documentation and protocols for financial processes and data management for the department

Cross-Departmental Collaboration & Project Support

• Collaborated with Business Office, Recruitment, Retention, Disability Services, and Student Life on data-driven strategic initiatives on certain projects
• Assisted college leadership with requiring data compilation and analysis
• Facilitated HN projects through data coordination and reporting support
• Managed extremely active calendars and project timelines for multiple executives including President, Executive Director and VPs

Data Processing & Database Management

Managed inventory databases and supply ordering systems while preparing purchase orders and reconciling invoices through financial systems to ensure data accuracy and regulatory compliance. Investigated and resolved data discrepancies in invoice processing and vendor statements by conducting systematic analysis and working collaboratively with finance office and internal audit teams to address data integrity issues. Assessed effectiveness of communication tools through comprehensive data evaluation and statistical analysis, identifying trends that improved operational efficiency. Provided analytical support in budget management by analyzing spending patterns, generating data reports, and conducting trend analysis to inform strategic resource allocation decisions. Successfully completed multiple data-intensive projects under tight deadlines while maintaining quality standards and prioritizing conflicting operational needs across departments.

Technical Proficiencies

• Database & Query Tools: PeopleSoft, SQL programming, complex query development
• Analysis & Reporting: Microsoft Power BI, AIR 2.0, Excel (advanced formulas, pivot tables, macros), statistical analysis
• Business Intelligence: Dashboard development, data visualization, automated reporting systems
• Office Applications: Microsoft Office Suite (Word, Excel, PowerPoint, Outlook, Planner), SharePoint, Adobe
• Project Management: Ticket system management, multi-project coordination, deadline management