Data Analyst Senior

Stephanie Makatura - *

Stephanie Makatura

TX • 817-***-**** • *********.********@*******.***

www.linkedin.com/in/stephanie-makatura-mba-7121aa61 Professional Summary

Results-driven Senior Data and Reporting Analyst with over 20 years of expertise in business intelligence, data management, and strategic reporting. Proven ability to optimize business processes, conduct research design, and develop solutions that drive operational efficiency. Strong experience in data exploration, leadership, and ensuring equity and ethics. Adept at collaborating with teams and delivering data-driven insights through technical communication. Key Skills

• Data Analytics & Reporting: Advanced Excel (Macros, VBA, Pivot Tables), SQL, SAS, Cognos, SAS Visual and Access. Familiarity with Tableau, Power BI and Python

• Data Governance & Automation: Data Validation, Quality Assessment, Regulatory Compliance, Workflow Automation (Excel VBA, Access Automation)

• Leadership & Collaboration: Strategic Planning, Team Leadership, Cross-Functional Collaboration, Project Management

• Data Engineering & Research: Research Design, Evaluation, Data Infrastructure Development, Data Exploration, Machine Learning & AI Integration

• Ethics & Public Policy: Ethical Data Solutions, Equity-Focused Analysis, Public Policy Interpretation

• Technical Communication: Clear presentation of complex data findings for stakeholder decision- making

• Clearance: DHS Public Trust

Certifications

• SQL Query 70-461 Professional Certification

• Google Professional Data Analytics Certification

• Architecting with Google Compute Engine Specialization Certification

• Microsoft Power BI Certification

Professional Experience

Transportation Security Authority (TSA) – Springfield, VA January 2024 – November 2024 Sr Data Analyst

• Spearheaded the development and implementation of automated data ingestion processes for TSA’s TOTAL database, efficiently managing over 400,000 entries in line with ethical standards and data management best practices.

• Designed and executed end-to-end infrastructure guides, improving data engineering processes for physical, virtual, and cloud devices.

• Delivered secure data ingestion workflows, ensuring equity in data accessibility and compliance with security standards.

• Utilized Excel, Macros, VBA, SQL and Access to provide accurate customer reports

• Provided strategic insights through comprehensive data analysis and public policy analysis to ensure timely and accurate contractual reporting utilizing Microsoft Access

• Met monthly CDRL (Contract Data Requirement List) deadlines Stephanie Makatura - 2

Indian Health Service – Rockville, MD January 2022 – September 2023 Data Analyst

• Led research design and evaluation efforts to analyze healthcare data, providing actionable insights with a focus on equity and ethics in public health.

• Leveraged SAS and SAS Visual Analytics to create high-impact reports, ensuring regulatory compliance and facilitating data-driven decision-making.

• Conducted data exploration and validation across complex health related datasets that support over 2.8 million American Indians and Alaska Natives

• Delivered reports through dashboards and direct communication via email that supported public policy analysis and decision-making processes for executive leadership. Mercedes-Benz Financial Services USA – Fort Worth, TX March 2021 – August 2021 Reporting Coordinator

• Collaborated with cross-functional teams to gather business requirements and develop comprehensive reporting specifications.

• Led user acceptance testing (UAT), ensuring systems met business needs and aligned with reporting standards.

• Integrated data engineering practices to optimize reporting structures and data flows.

• Consistently delivered high-quality Cognos reports on schedule, driving stakeholder satisfaction.

• Played a key role in the successful company-wide rollout of new reporting systems. Santander Consumer USA – Dallas, TX January 2016 – March 2021 Data/Reporting Analyst

• Delivered accurate and timely reports to senior management using advanced Excel functions, enabling data-driven insights for strategic decision-making.

• Ensured compliance with industry regulatory standards, facilitating successful audits.

• Integrated data engineering solutions to streamline workflows and enhance reporting accuracy through effective use of SQL and Excel automation.

• Produced actionable reports that improved risk management, public policy analysis, and corporate compliance.

Bosque Systems LLC – Fort Worth, TX January 2013 – September 2015 Data/Reporting Manager

• Directed a team of data analysts, leading the creation of high-value reports and dashboards for executive leadership.

• Developed and maintained data management processes, driving improvements in operational efficiency and data accuracy.

• Produced analytical insights through data exploration techniques, enabling leadership to make informed decisions regarding customer trends and regional performance.

• Managed the development of reporting templates and forms, ensuring ease of data collection and efficiency across teams.

Education

Master of Business Administration - Ashworth College Bachelor of Science in Sociology/Gerontology - Stephen F. Austin State University

Contact this candidate