Ronalou Malapit

- RONALOU M. MALAPIT - REPORTS AND DATA ENTRY SPECIALIST Pasay City, Metro Manila PH Profile Dynamic and results-driven Reports and Data Entry Specialist with over 12 years of expertise in managing large datasets, ensuring data accuracy, and delivering actionable insights. Proficient in Excel, Google Sheets, and data visualization tools like Google Data Studio, to create interactive dashboard reports that support strategic decision-making and business success. Experience Prudential Guarantee and Assurance Inc. Statistics Clerk 2012 - 2024 Collate, update, and manage large volumes of claims data from various sources. Generate weekly, monthly, and annual reports (detailed and summaries) on claims status, including open claims, claims under review, claims closed, and claims denied. Advanced knowledge of Excel (pivot tables, VLOOKUP, complex formulas, conditional formatting, data validation) for efficient claims data entry and reporting. Create simple claims dashboard reports using Excel and Google Data Studio. Coordinate with the claims teams to validate that all necessary documentation and information are included in claims reports, including adjusting claims based on new information. Suma Brands, Inc. Amazon Virtual Assistant (Part-time Job) January - March 2022 Download reports from Amazon Seller Central (e.g., sales). Update Shopify Attributes to ensure the reliability of the Catalog. Consolidate and create reports in Excel and Google Sheets. Education Marinduque State College BS Information Technology Hard Skills Data Reporting and Analysis Data Cleansing and Consolidation Dashboard Report Development Error Checking and Validation Spreadsheet Management Amazon Virtual Assistance 2007 - 2011 Software / Tools Detail-oriented Results-driven Confidentiality Integrity Time management Adaptability Teamwork and Collaboration Software / Tools Microsoft Excel (Pivot Table, Pivot Chart) Google Products (Sheets, Docs, Gmail) Google Looker Studio Video Recording (OBS Studio, Loom) Project Management (Trello, Airtable, Notion) Video Conferencing (Zoom, Google Meet)