Pedro M.
Data Analyst

Skills

Sql

Microsoft Excel (Advanced Analytics Add-ons)

Pedro is available for hire

Meet Pedro M.

All Howdy Candidates are vetted for skills and english proficiency.

Bio

People Analytics Specialist
5/1/2023 - 12/1/2023

Managed People Analytics initiatives, providing strategic insights and actionable data for organizational decision-making. Supported the implementation and integration of the Pipefy system to streamline workflow and process management. Developed a custom application using Power Apps tailored for operational needs, facilitating the work of 900 leaders. Automated key processes including the Onboarding Survey and the Overtime report, enhancing efficiency and accuracy in data collection and analysis.
People Analytics Specialist
7/1/2021 - 4/1/2023

Developed expertise in creating and maintaining HR dashboards focused on management indicators, recruitment & selection, and training & development. Conducted comprehensive data reporting for external research and analysis for potential investors. Undertook the redesign of organizational charts within the Senior system and actively monitored the Span of Control. Provided support in the implementation of systems such as Solides and Konviva, including database loads and parameter mapping for integrations.

Gained proficiency in compensation studies by defining market parameters, building salary tables, and repositioning roles for a new organizational structure while conducting cost studies for salary adjustments. Validated job openings and internal movements, and simulated the impacts of Collective Labour Agreements (ACTs) and Collective Bargaining Agreements (CCTs). Designed benefit packages tailored for leadership and provided assistance to managers and the HR team regarding compensation-related inquiries.
People Analytics
10/1/2018 - 7/1/2021

Conceptualized and implemented HR Indicators from initial design through to interactive dashboards, including the creation of technical sheets, responsibility matrices, and comprehensive management analysis. Developed automation tools in Excel for streamlining HR routines such as budgeting, Training Status Reports, and Calendars of Periodic Examinations. Contributed to Business Process Mapping and Recruitment & Selection System Implementation Projects. Supported the preparation of the Annual Budget by providing critical information for decision-making. Conducted job descriptions and salary surveys utilizing frameworks such as Korn Ferry, Deloitte, and XR. Provided internal consulting services to business areas by devising solutions in analytics, process improvement, and professional training.
HR Budget Analyst
7/1/2017 - 7/1/2018

Led the implementation of the Hyperion Cloud (Oracle) project, guiding the technical design through to successful execution. Managed HR Budget alongside various business areas and provided comprehensive reporting of results. Developed expertise in financial planning and cloud-based solutions, demonstrating proficiency in Oracle Hyperion Planning, Budgeting, and operational management. Utilized advanced technical skills in Oracle’s suite of cloud applications, facilitated efficient budget tracking, and ensured accurate, timely financial reporting.
Management Information Analyst - Indicators
8/1/2012 - 2/1/2017

Automated the consolidation and generation of HR reports for business areas including headcount, termination, admission, leave, movement, and absenteeism metrics. Enhanced the Absenteeism Panel by integrating data from administrative staff following the migration to SAP RH - Time, and created the Birthday Book for managerial levels, featuring organizational history and personal data. Developed various tools for process automation, such as updating managerial level data, generating reports on electronic time clock pending issues, and monitoring the status of performance programs. Participated in the initial phases of migrating strategic HR indicators to SAP RH BI, including mapping and creating the functional specification. Created, updated, and monitored strategic HR indicators through several dashboards: People Management Indicators Panel, which covered headcount, turnover, internal utilization, PWDs, leaves, and periodic examinations; OI's People Management Indicators Panel focusing on headcount, internal utilization, and turnover for regions including Latin America and France; Training and Development Panel featuring metrics like training hours, average hours per employee, training adherence and satisfaction, costs, and effort index; an Absenteeism Panel detailing metrics by shift, audience, areas, and day of the week; and a Recruitment and Selection Indicators Panel covering SLA and hiring effectiveness.
HR Apprentice
8/1/2011 - 8/1/2012

Consolidated training evaluation forms and managed adherence control processes. Prepared and distributed monthly and weekly reports to business areas, encompassing detailed HR information. Conducted responses for market research and supported internal HR studies, ensuring accurate data collection and analysis. Developed skills in data compilation, report generation, and stakeholder communication. Enhanced proficiency in HR information systems and analytics tools.