Ajao Olamilekan

DATA ANALYST/REPORT WRITER

Quality Clouds • Período integral

Feb 2025 - May 2026 • 1 yr 3 mos

Key Contributions & Achievements: • Data Integration & ETL: Integrated data from multiple sources (Remedy, ServiceNow) into SQL Server 2012 using SSIS (2015), streamlining data pipelines and improving reporting accuracy. • Database Development & Maintenance: Designed, modeled, and maintained SQL Server databases; created tables in MS Access linked to SQL Server; performed periodic database structure and data updates. • Advanced SQL & Reporting: Wrote complex SQL queries to generate ad-hoc and automated reports (ticket/call statistics, operational metrics) and conducted ongoing data quality validation and root-cause analysis to resolve anomalies. • Business Intelligence (BI): Built customized Tableau dashboards and managed Tableau servers (local and online), deployed dashboards, refreshed data sources with Tableau Bridge Client, and supported stakeholder decision-making with interactive visualizations. • SSRS & Reporting Automation: Developed and scheduled SSRS reports to meet management and compliance requirements, ensuring timely delivery of accurate insights. • Data Governance & Security: Created user roles/permissions in CTERA, ensuring compliance with access control requirements. • Publishing & Program Support: Supported CMS (Centers for Medicare & Medicaid Services) by providing actionable reporting, high-quality publication support, and program management deliverables. • Cross-Functional Collaboration: Partnered with stakeholders (internal & external) to define reporting requirements, delivering customized reports that enhanced operational efficiency and informed business strategy.