Fred Dumagpi Microsoft Excel
No reviews yet

TECHNICAL SKILLS

Microsoft Excel: Experienced professional with 10 years of utilizing Microsoft Excel for data management, analysis, and reporting. Proficient in core Excel functions, including formulas, pivot tables, and basic visualizations. Possesses a strong attention to detail, organizational skills, and the ability to translate data into clear insights.

HRMS Administration: Deep knowledge of HRMS configuration, maintenance, and integration with other systems (attendance, payroll). Troubleshooting and issue resolution.

Attendance & Access Systems: Expertise in attendance systems (RAMs) and access control systems (Unis). Proficient in device configuration, data extraction, and analysis.

Data Analysis: Compiling, and analyzing HR-related data (attendance, employee profiles, compensation, etc.) for reporting and decision-making.

Vendor Management: Liaising with third-party vendors for system support, maintenance, and upgrades.

REPORTING AND ANALYSTICS

Report Generation: Creating customized HR reports (employee statistics, compensation, compliance, etc.) using the HRMS and other data sources.

Data-Driven Insights: Analyzing HR data trends and patterns for strategic decision-making.

HR OPERATIONS SUPPORT

Payroll Support: Verifies attendance and leave data for accurate payroll processing, including overtime/undertime calculations.

Mobile App Support: Providing user support, managing access, testing, and analyzing usage patterns of the HRMS mobile app.

Organizational Structure: Designing and maintaining up-to-date organizational charts aligned with the HRMS.

SOFT SKILLS

Problem-solving: Identifying issues within systems and data discrepancies, proposing timely resolutions.

Collaboration: Working closely with HR, IT, payroll, and external vendors.

Attention to detail: Ensuring data accuracy and integrity across systems.

Communication: Providing clear user support and addressing employee inquiries effectively.

Subjects

Microsoft Excel Beginner-Intermediate

Experience

Senior Officer - Compensation and Benefits (Nov, 2008–Present) at Al Ansari Financial Services PJSC

HRMS ADMINISTRATION
- Identifies and escalates system discrepancies for timely resolution.
- Facilitates seamless integration between the HRMS and attendance systems.
- Manages job designations, ensuring accurate departmental and sectional linkages.
- Provides comprehensive HRMS user support, addressing employee inquiries.
- Configures and maintains employee workflows within the HRMS.
- Generates and analyzes HR reports (e.g., employee profiles, compensation data).
- Collaborates with IT to maintain, test, and enhance HRMS features.
- Manages HR-related content uploads (policies, handbooks, announcements).

HRMS MOBILE APP SUPPORT
- Provides comprehensive maintenance and user support for the HRMS mobile application.
- Contributes to app usability improvements through testing and recommendations.
- Manages mobile app access requests and device approvals.
- Analyzes and reports on HRMS mobile app usage patterns.

REPORTING
- Extracts and prepares HRMS data (employee profiles, compensation) for strategic departmental use.
- Compiles, customizes, and analyzes HR data to fulfill internal and regulatory reporting requirements (e.g., CBUAE).

PAYROLL SUPPORT
- Verifies attendance data, absences, and late entries to ensure accurate payroll calculations.
- Prepares, calculates, and inputs overtime and undertime data for Kuwait Operations payroll processing.

ATTENDNCE AND ACCESS MANAGEMENT
- Administers the RAMs attendance system, configuring shifts, deployments, and facilitating HRMS integration.
- Manages the Unis access control and time attendance system, including terminal ID assignment, device monitoring, biometric enrollment, and access group creation.
- Extracts and analyzes attendance data for reporting.
- Liaises with third-party vendors to ensure optimal system performance, upgrades, and maintenance.

ORGANIZATIONAL CHART MANAGEMENT
- Develops and maintains current departmental organizational charts.
- Ensures organizational charts accurately reflect staffing levels and maintain alignment with the HRMS.

Education

Bachelor of Science in Business Administration major in Marketing Management (Jun, 1991–Oct, 1995) from University of Santo Tomas, Manila, Philippines

Fee details

د.إ150–200/hour (US$40.87–54.50/hour)

Free Consultation: I offer a complimentary consultation to discuss your specific learning goals and preferred course content. This allows us to tailor the session to your needs and set a rate that reflects the complexity of the material.

Courses offered

Data Analysis Using Excel
- US$41
- Duration: 9 Hours
- Delivery mode: Online
- Group size: Individual
- Instruction language: English, Filipino/Tagalog
- Certificate provided: No
This comprehensive course will empower you to transform raw data into actionable insights using Excel's powerful tools and techniques. Designed for learners with basic Excel knowledge, this program is delivered in six interactive sessions (1.5 hours each).

Throughout the course, you'll:

• Master essential and advanced Excel formulas and functions: Leverage these tools to manipulate and analyze data effectively.
• Unlock the power of data analysis tools: Learn advanced sorting, filtering, and PivotTable creation for complex data summarization.
• Craft compelling data visualizations: Go beyond basic charts and explore various customization techniques to present your data in impactful ways.
• Become a data transformation expert: Utilize Power Query to clean and transform your data, ensuring its accuracy and integrity.
• Gain a foundational understanding of Power Pivot: Learn how to create relationships between multiple data tables for deeper analysis.
• Explore different what-if scenarios: Employ Scenario Manager and Goal Seek tools to forecast potential outcomes based on changing variables.
• Implement data validation and error handling: Ensure data accuracy and safeguard your analysis with these essential techniques.

By the end of this course, you'll be well-equipped to tackle data analysis challenges with confidence and extract valuable insights from your data using Excel's robust capabilities.