RUONA OGRIH
************@*****.*** 832-***-**** New York, NY Portfolio GitHub
EMPLOYMENT HISTORY
Senior Data Analyst
Copperfield Family Clinic – Houston, TX (Remote) Sep 2022 – April 2025
● Owned end-to-end reporting across 8+ clinic campaigns using Tableau and Power BI, improving marketing visibility by 30%
● Queried and segmented 5,000+ patient records in SQL to analyze trends by age, region, and service type. Boosting appointment conversions by 18%
● Automated performance reports in Python/Excel, cutting manual reporting hours by 70% and accelerating weekly decisions
● Applied A/B testing logic to evaluate outreach strategies, increasing email open rates by 22% and SMS engagement by 11%
● Delivered insights that helped extend average patient retention by 25% over 12 months Cybersecurity Graduate Consultant
U.S. Department of Homeland Security – New York, NY Jan 2024 - May 2024
● Participated in a DHS Practicum led by NYU, focusing on critical infrastructure security.
● Researched vulnerabilities in U.S. critical infrastructure across 10+ sectors based on DHS frameworks.
● Synthesized findings from 40+ intelligence sources to develop actionable threat mitigation strategies.
● Analyzed the impact of Volt Typhoon on South, Southeast, and East Asian nations.
● Developed data sheets, visual briefs, and written reports outlining Volt Typhoon’s impact and mitigation strategies.
● Produced 3 strategic briefs and 2 visual dashboards delivered to NYU-DHS project leads. Data Analyst
JMAN Group – London, UK Jan 2021 – Dec 2021
● Analyzed $5M+ in sales transactions using SQL to support product pricing and discount strategy across 3 major retail clients
● Developed Power BI dashboards to track weekly sales growth, leading to a 12% uplift in underperforming categories
● Built custom KPIs to measure profitability, inventory turnover, and regional performance, later used in client board reviews
● Reduced reporting lag by 60% by creating streamlined workflows between finance, ops, and commercial teams
● Partnered with 6 consultants to deliver insights across FMCG, retail tech, and B2B SaaS verticals EDUCATION
New York University – New York, NY
M.S. Global Security, Conflict & Cybercrime
GPA: 3.5 / 4.0
University of Buckingham – Buckinghamshire, UK
B.A. Security, Intelligence & Cyber
Awarded First Class Honours (1:1)
SKILLS: SQL, Python (Pandas, NumPy), Tableau, Power BI, Excel, R (basic), ServiceNow, Smartsheet, P6 Analytics, Data Cleaning, KPI/KRI Analysis, Forecasting, Data Visualization, Cross-functional Collaboration, Leadership. RELEVANT PROJECTS
Medical Insurance Cost Prediction: Analyzed 1,300+ insurance records using Python and SQL; built Tableau dashboards on trends by age, region, smoking status.
Streaming ROI by Genre & Platform (IMDb Project): Analyzed 3,000+ movies using SQL/Python; built Tableau dashboards to compare streaming platforms.
NBA Player Performance Analytics Clustered 500+ NBA players by efficiency metrics with Python and Tableau to uncover undervalued talent.