Enrico R. Mendiola

O

Business Operations Support Senior Analyst

Optimum Info Solutions Philippines, Inc

Apr 2024 - Apr 2025 (1 year 1 month)

• Develops understanding of exploratory data analysis and statistical measures. • Uses tools like Power BI, Power Query, Excel, Python Pandas, and Tableau for data manipulation, transformation and visualization. • Supports the creation of charts for reporting metrics. • Analyzes business processes and their financial implications. • Collaborates on data quality processes using tools like Marketo and Salesforce to maintain accuracy and consistency in marketing and CRM data. • Documents data quality standards and procedures using Microsoft Word and SharePoint to ensure accessibility and version control. • Provides insights through data visualizations for decision-making. • Captures and tracks meeting notes and action items. • Oversee

Services Operations Senior Analyst

Dayforce

Apr 2023 - Feb 2024 (11 months)

• Analyze operational and financial data for decision-making. • Understand and document business processes. • Create and report on metrics using Power BI tools. • Support financial reporting and analysis. • Track revenue and expense impacts of operations. • Manage the Implementation Incentive Plan. • Identify and quantify process improvements; recommend actions. • Ensure data integrity and process compliance within teams. • Deliver accurate financial models and presentations. • Collaborate with Finance and Sales Operations on initiatives. • Tools and technologies used: Advanced Microsoft Excel with dynamic arrays, Power Pivot, Power BI, Power Query, DAX, SQL, Salesforce, SharePoint, Confluence( for documentation ) and Microsoft W

Senior Software Engineer

Cloudstaff

Oct 2022 - Mar 2023 (6 months)

• Design reports and forms using DevExpress End-User Report Designer based on data from TMS and WMS systems. • Enter data into TMS and WMS systems. • Create import and export files for TMS and WMS systems. • Manipulate and correct data in EDI files (XML, CSV, JSON). • Use TSQL to extract data for reporting, KPI/SLA benchmarks, and helpdesk inquiries. ◦ Perform technical root cause analysis using log files and TSQL to trace problems and provide resolution reports. • Create Excel reports with PIVOT tables and graphs. • Produce data visualizations in formats like MS Word and PowerPoint for Account Management, Sales, customer reviews, and KPI/SLA assessments. ◦ Support external reporting needs with appropriate tools and formats. ◦

Workforce Reports Analyst

Wonders Corporation

Jul 2022 - Oct 2022 (4 months)

• Recommending establishment of new or modified reporting methods and procedures to improve report content and completeness of information • Conferring with persons originating, handling, processing, or receiving reports to identify problems and to gather suggestions for improvements. • Examining and evaluating purpose and content of business reports to develop new, or improve existing format, use, and control • Reviewing reports to determine basic characteristics, such as origin and report flow, format, frequency, distribution and purpose or function of report • Evaluating findings, using knowledge of workflow, operating practices, record retention schedules ◦ • Preparing and issuing instructions concerning generation, completion,

Access and Data Administrative Analyst

Alphanumeric Systems

Jul 2021 - Jul 2022 (1 year 1 month)

• Administer user data and respond to queries in a timely manner • Edit learning curriculum and send out training invites • Management of user data using client provided tools (i.e. account provisioning, deactivation, modification) • Maintain technical proficiency with client tools • Suggest process improvements to improve quality and consistency • Preparation of Knowledge Base entries • Contact with clients when necessary to clarify a specific process other duties as assigned. ◦ Conduct training • for newly hired Data Analyst • Tools and technologies used: Advanced Microsoft Excel with dynamic arrays, Power Pivot, Power Query, and Excel VBA.

A

Reporting Analyst - (Australian

ARF Consulting and Services

Apr 2019 - May 2020 (1 year 2 months)

• Scheduling/informing residential and small business owners that Upgrade Manager will conduct inspection for upgrading of existing non LED lights if qualified. • Drafting of Reflected Ceiling Plan for residential and commercial owners. Process commission payments for sales employees, electrician and Inspection Managers based in Australia using CRM and XERO • accounting software. • Resolve issues of electricians regarding their payments. • Provide weekly and monthly report for management extracted from CRM by transforming to usable format using excel advance formula or google sheet advance formula. • Escalate issues regarding CRM errors and raise ticket. • Provide resolution of CRM errors. • Data cleaning, data extraction, and data

Financial Advisor

Insular Life Assurance Co Ltd

Jan 2012 - Dec 2018 (7 years)

• Present life insurance and investment products to clients. • Provide tailored financial advice based on client needs. • Explain product benefits and assist clients in decision-making.

I

Benefits Reports Specialist

Insular Life Assurance Co., Ltd

Jan 1993 - Oct 2011 (18 years 10 months)

• Managed the evaluation, planning, and administration of the various employee benefits programs, • including retirement; assess effectiveness of programs in meeting overall strategic objectives, and oversaw • the development and implementation of changes and improvements to benefits programs. • Responded to and resolved employee concerns regarding benefits programs • Effectively ensured that development and execution of administrative policies governing employee benefits are in compliance with all state and federal regulations. • Administered organization's performance appraisal programs including the design of the company's performance management system. • Reconciled all Health Insurance Invoices and code to appropriate departments

Enrico R. Mendiola

About

Detail

Timeline

Résumé