Senior Data Analyst and Reporting Lead
Resume:
TONIA LOVELACE
BALTIMORE, MD *****
****************@*****.***
OBJECTIVE
Experienced Data Analyst with over 25 years in data mining, analytical evaluation, reporting, data validation and visualization. Skilled in using analytics to deliver business solutions and improve efficiency. Seeking to apply strong analytical skills to enhance data accuracy to support reporting and develop effective routines and solutions. Home office remote setup: dual monitors, desktop, laptop and printer. SKILLS
• Data Analysis Tools - Proficient in Excel, including VLOOKUP, pivot tables, and other advanced functions; experienced with SQL, Python, and R for data manipulation and reporting.
• Data Visualization - Proficient in Microsoft Excel, Power BI, Qlik, and other tools for creating dashboards, graphs, and reports.
• Statistical Analysis - Strong understanding of statistical methods, hypothesis testing, and predictive modeling.
• Database Management - Skilled in design, administration, and optimization.
• Business Intelligence – Skilled in decision-support tools for trend forecasting and ensuring report accuracy and data compliance.
• Data Cleaning and Preparation – Demonstrated proficiency in data wrangling and preprocessing to maintain high standards of data quality and integrity.
• Communication Skills – Strong ability to convey complex information clearly and effectively to diverse audiences.
• Problem Solving - Strong analytical and critical thinking skills to identify trends and patterns in data.
• Team Collaboration - Able to work effectively in cross-functional teams to achieve business objectives. EXPERIENCE
HOUSE OF RUTH MARYLAND (100% REMOTE)
BALTIMORE, MD
Data Systems Manager 09/2022 to 05/2025
• Management of a staff and client database to ensure accurate data performance and reporting. Met with software vendor for updates, system issues and maintenance. Was responsible for testing, translating system updates that apply to documentation and reports.
• Collaborated with program managers to reconfigure dashboards and create staff management reports to monitor staff data entry timeliness to satisfy audit and report requests.
• Provided group and one on one user training to develop troubleshooting techniques to utilize monitoring and abilities to review validation reports to self-resolve data errors.
• Developed a comprehensive cross-dimensional validation report incorporating targeted guidance for identifying specific errors and self-resolution procedures. Implementation of this report contributed to an 84% reduction in validation errors, enabling meeting agendas to refocus on addressing other data quality issues.
• Collaborated with leadership by presenting trend analysis reports to discuss low KPIs, strategies to improve outcomes and meet future goals.
• Collaborated with Finance staff to validate financial data accuracy and alignment with client data system used for housing and supplies to meet grant reporting timelines.
• Participated as an agency representative in external partner committees and meetings, addressing Federal, State, Local, and ad hoc reporting requirements, data updates, and policy revisions. ZOLON TECH SOLUTIONS/EXELON (100% REMOTE)
Baltimore, MD
Business Analyst II
06/2020 to 06/2022
• Developed reports on gas pressure mapping to help monitor program-specific assignments being carried out or finished by contractors.
• Coordinated with contractors to resolve data discrepancies for accurate month-end reports and YTD proactive renewal completions.
• Created and managed pivot tables, pivot charts, and graphs in Excel to reconcile and report data discrepancies to stakeholders and executive leadership.
• Reduced missing pavement request tickets by 45% creating improved efficiencies in the ledgers system, using pivot charts and tables giving the ability to monitor and report billing code usage for services rendered.
• Developed a validation process to clean up historical ledgers where contractors billed for services, but no online documentation was performed.
IN HOME CARE
Baltimore, MD
Caretaker 1/2019 to 6/2020
• Cared for Father diagnosed with Alzheimer’s Disease.
• Delivered medical, physical, and administrative support until transitional housing became available. DC GOVERNMENT-OFFICE OF STATE SUPERINTENDENT OF ED Washington, DC
Data Analyst Manager 10/2008 to 1/2019
• Managed a data analytics team responsible for reporting education data for all Washington, DC residents enrolled in programs including special education, English learner services, homelessness support, early childhood education, Title I initiatives, and adult education.
• Managed federal reporting of assessments, demographics, and special education billing data to the U.S. Department of Education, increasing report timeliness by 70% and contributing to the removal of the 2006 Blackman/Jones Consent Decree in Washington DC.
• Temporarily assigned to review and supply data for FOIA requests following the 2015 education data breach, pending implementation of a more secure process. Communicated with parents to notify them and provide data monitoring services for students impacted by the breach.
• Acted as the Special Education Software Data Administrator, overseeing user roles and permissions and interfacing with the software vendor to report system errors and issues. Provided comprehensive user training focused on enhancing documentation and data entry practices, which resulted in a 25% decrease in denied Medicaid claims pertaining to billing and reimbursement. EDUCATION AND TRAINING
Baltimore City Community College Adult Learning Center 04/2000 Medix School 01/1986
Southwestern High School 06/1983
Contact this candidate