Dan Bryan Otero

Dan Bryan Otero Reporting & Data Analyst Passionate about transforming raw data into actionable insights! With expertise in Excel (advanced formulas, pivot tables, macros) and Power BI (dashboards, data modeling, DAX), I excel at creating clear, impactful reports that drive informed decision-making. Skilled in data cleaning, visualization, and storytelling, I turn complex datasets into user-friendly, visually compelling narratives. WORK EXPERIENCE JEG Tower, Business Park Cebu City, Cebu 6000 Reporting: Generate and distribute financial reports, dashboards, and analytics for stakeholders Database Maintenance: Regularly update and maintain accounting databases to ensure data integrity and security. Data Entry Oversight: Supervise data entry processes to minimize errors and ensure consistency. - Reporting: Generate and distribute financial reports, dashboards, and analytics for stakeholders. Audit Support: Assist auditors by providing accurate and organized financial data during audits Improvement: Identify inefficiencies in data workflows and recommend solutions for optimization. Collaboration: Work closely with accountants, analysts, and IT teams to ensure seamless data operations. Data Management: Oversee the organization, storage, and retrieval of financial data to ensure accuracy and accessibility. Visualization & Automation: Create data automation in a form of formulas, pivot in excel with data visualization for Dashboards both excel in Power BI. Worforce Management - Data & Reporting Analyst Vital Business Partners March 2023 - October 2024 JEG Tower, Business Park Cebu City, Cebu 6000 Provide administrative support to the operations team. This may include tasks such as scheduling meetings, managing calendars, taking minutes, and preparing productive reports reports. Maintain the operations team's records and files. This includes keeping track of contracts, invoices, and other important documents. Assist with training and onboarding new employees. This may involve providing orientation materials, answering questions, and helping with the transition to the new role. Perform other administrative tasks as needed. This may include answering phones, greeting visitors, and running errands. Provide weekly seat plans for Office, Hybrid, & Province Team members. Monthly Analysis in productivity reports for Quality Assurance Team Post-vetting assessment for paraplanners Responsible for Cagayan De Oro Seat plan and Schedules Weekly, Monthly, Annually. EDUCATION University of San Carlos Bachelor of Science in Business Administration Major in Marketing June 2014 - October 2018 Asian College of Technology High School Years June 2010 - March 2014 - Minglanila, Cebu, Philippines https://oteromarketing.wordpress. com/ PERSONAL INFORMATION Data Administrative Matthews Steer October 2024 - Present - Age: 28 Birthdate: April 06, 1996 CIvil Status: Married Religion: Iglesia Ni Cristo Nationality: Filipino TECHNICAL SKILLS Client Relationship: Skilled in building trust, resolving issues, and fostering long-term client partnerships with exceptional communication and empathy. Data Administrator Skills: Database Management Systems (DBMS): Proficiency in Power BI, Oracle, Airtable, etc. Data Modeling & Design: Understanding of ER diagrams, normalization, and schema design. Data Administrator Skills: Database Management Systems (DBMS): Proficiency in Power BI, Oracle, Airtable, etc. MS Excel: Excel & Spreadsheet Tools: - Advanced functions, pivot tables, and macros. Data Analyst Skills: - Data Visualization: - Expertise in tools like Tableau, Power BI, or Looker. Performance Tuning: - Optimizing database queries and indexing for efficiency. PDF Docs: Excellent in creating, editing, and optimizing PDF documents with precision and efficiency. REFERENCE Jonathan Lim Workforce Management Lead, VBP- Pascual Tabuac Quality Assurance Manager, VBP-