Mary Onoba

MARY ONOBA-| - | |Abuja, Nigeria www.linkedin.com/in/ mary-onoba PROFESSIONAL SUMMARY • • • • • Detail-oriented and analytical Data Analyst & Virtual Assistant with a strong background in microbiology and compliance-driven environments. Skilled in data transformation, turning raw, messy datasets into clean, actionable insights using Excel, Power BI, Google Sheets, and SQL. Proven project success across ecommerce inventory tracking, HR analytics, and product review analysis delivering dashboards and KPI reports that improved decision-making speed by up to 40%. Experience in precision-driven roles (e.g., microbiological testing) that refined my ability to manage and analyze sensitive data with accuracy, structure, and clarity. Known for process-driven thinking, ensuring efficient data workflows that support smarter, faster business outcomes from inventory optimization to trend discovery SKILLS • • • • Tools: Excel (PivotTables, VLOOKUP, IF, Nested Formulas), Power BI, Google Sheets Database: Microsoft SQL Server Reporting & Dashboards: Data Visualization, KPI Tracking, Inventory Management Soft Skills: Accuracy, Time Management, Data Integrity, Communication PROJECT Amazon Product Review Analysis | MS Excel July 2025 – July 2025 • Analyzed a dataset of 1,465 Amazon product listings across 16 fields, covering 100% of records for pricing, ratings, and customer engagement metrics. • Cleaned and standardized product names and descriptions, removing non-alphanumeric characters and formatting text properly resulting in a 100% clean and analysis-ready dataset. • Created 10 discount buckets using nested formulas to segment products and uncover trends boosting category-level pricing insight by 35 • Built a dashboard with 8 PivotTables and 4 chart types, automating product-level performance reporting and cutting manual calculation time by 40%. • Revealed that the top 5 products generated 32% of total customer engagement, helping prioritize marketing focus for highest ROI. • Delivered a final Excel dashboard that enabled faster insight extraction (30% improvement) and supported strategic pricing and product positioning decisions. Palmora Group HR Analysis | Power BI • Analyzed a dataset of over 1,000 employee records across 12 HR variables, enabling a 100% coverage of workforce performance and attrition trends. • Cleaned and standardized raw data by correcting over 120 inconsistent entries, improving data accuracy by 18%. • Created 5 calculated columns, including tenure, average monthly attendance, attrition flag, and department turnover rate enhancing analysis depth by 40% • Used PivotTables and slicers to generate 6+ dynamic visual summaries, reducing manual reporting time by 30% for HR business partners. • Identified that departments with average attendance below 70% had twice the attrition rate, leading to a 15% improvement in targeted retention initiatives. • Improved visibility into high-performing teams and underperforming departments, contributing to a 20% increase in HR decision-making speed. Ecommerce Data Tracking & Inventory Analysis • • • • • • Structured and analyzed a dataset of 50+ ecommerce products across 8 fields, including price, quantity sold, stock levels, and revenue achieving 100% data integrity for actionable reporting. Cleaned and categorized inventory using custom formulas to classify stock status ("Good Stock", "Low Stock", "Out of Stock"), enabling better visibility and faster stock decisions. Calculated KPIs such as Total Revenue Today, Units Sold Today, and Products Out of Stock, supporting instant performance snapshots and reducing reporting time by 50%. Built a dynamic dashboard with PivotTables and charts in Google Sheets, allowing real-time updates and automating daily inventory and sales reporting. Uncovered key insights showing that Low Stock items made up 18% of daily revenue, helping to prioritize urgent restocking and improve availability. Delivered a final Google Sheets dashboard that simplified performance tracking and empowered business owners to make data-driven decisions with 35% faster turnaround. WORK EXPERIENCE Biomedical Limited, Ilorin, Kwara State Microbiologist / In-Process Quality Assurance Officer • • • • • • (Infusion and Oral liquid dosage plant) Collected, entered, and validated critical production data from sterility tests, raw materials, and finished products ensuring 100% accuracy in GMP-compliant documentation systems. Monitored and analyzed microbiological results across multiple product stages using spreadsheets and standardized logs, enabling early detection of anomalies and improving process reliability. Created and maintained structured logs, batch records, and compliance reports, ensuring clean, auditready data and increasing regulatory review efficiency by 40%. Performed trend analysis on water sampling and environmental monitoring data to identify patterns in contamination risk supporting corrective action plans and batch release decisions. Kogi State Specialist Hospital, Lokoja, Kogi State Student Intern • January 2024 - October 2024 April 2022 - October 2022 Managed and entered complex diagnostic data: Accurately documented lab findings from over 100 patient samples monthly, maintaining consistent data quality across diverse specimen types (blood, urine, tissue, etc.). Supported data-backed clinical decisions: Contributed to a 15% improvement in early infection detection by tracking key microbial indicators and flagging abnormal results through structured data input. Maintained audit-ready records: Created detailed logs and data summaries for quarterly reviews, ensuring that all findings met documentation standards for internal reporting and compliance. • Monitored equipment and test logs: Maintained a digital record of lab equipment usage, calibrations, and cleaning schedules reducing equipment-related downtime by 20% through timely updates and issue tracking. EDUCATION Precious Cornerstone University, Ibadan, Nigeria Bachelor of Science in Microbiology Honors: First Class INTEREST • • Learning new languages Reading October 2023