MANNY RIVERO

Profile

Detail-oriented business analyst highly skilled in translating high-level requirements from stakeholders into actionable plans and solutions that exceed expectations, develops scalable process improvements, as well as leads projects at a high level for Global Digital Strategy. Strong technical skills in data analysis and reporting.

Holds a Master of Business Administration in Innovation Management and is a certified Microsoft Azure Data Engineer Associate.

Technical Skills

Professional Experience

Hyster-Yale Group, Inc., Greenville, NC

Business Analyst, Global Digital Platforms

July 2023-Present

• Led project to develop a Power BI dashboard for the HR Department for the India office; dashboard measured several critical KPI’s as it related to hiring practices, as well as offered strong visibility to track every candidate in the pipeline through all stages of the hiring process.
• Directed a project to automate backend data collection and curation for cost and finance teams and develop respective Power BI dashboard to track cost and price for multiple product lines. Leveraged SQL to develop a full Bill of Material with associated cost.
• Coordinated efforts to analyze data points for sales and marketing content, and visualized insights in Power BI for efficient reporting, leading to the identification and elimination of unused content, reducing waste. Built robust data model for the project, as well as extensive logic utilized for DAX measures.
• Orchestrated the integration of diverse manufacturing data sources, establishing a standardized process, and creating a global Power BI report with multiple KPI’s. This centralized approach enhanced visibility into production gaps, resource allocation needs, and daily performance against manufacturing goals, reducing manual input and data sharing.
• Drove the initiative to streamline a monthly executive report on aftermarket parts and supplier invoices, automating the process and dramatically reducing manual workload.
• Utilizes Agile project management methodologies to facilitate and lead cross-functional project meetings with internal project teams, vendors, and executive stakeholders as necessary.
• Establish pertinent project documentation including design documents, requirements documents, executive summaries, flowcharts, etc.
• Provide training and support to end-users to facilitate adoption of new processes and technologies, as well as conduct thorough project reviews upon completion to identify lessons learned and areas for improvement.
• Successfully onboarded and trained two new hires in core responsibilities such as requirements gathering, documentation, data discovery, and analysis. Delivered comprehensive orientation on company culture, key personnel, and situational awareness for enhanced integration into the organization.

Cost Reduction Analyst

January 2021 - July 2023

• Analyzed margins of $500M aftersales parts segment to ensure maximum profitability. Studied historical trends, conducted competitive analysis, and assessed domestic and global economic conditions to adjust prices and discover opportunities for driving business.
• Incorporated process automation utilizing Python and other data engineering tools that enhanced data structure, insight extraction, and data formatting. These efforts refined a critical report for key stakeholders that simplified the process and saved an hour of work time.
• Retrieves, parses, processes, and organizes data for use by non-technical staff. Develops scripts that enhance the usability of data and enables scaling, monitoring, and efficient operation of data platforms.

Demand Analyst

December 2017- January 2021

• Achieved 95% forecast success rate for product rates that enabled accurate scheduling and impacted revenue.
• Maintained working knowledge of internal systems built within IBM AS400 system and Salesforce. Collaborated with engineers to incorporate the development of truck specifications and engineering design into these systems.
• Provided recommendations to department leadership on revamping legacy processes that were costly in both time and effort. These recommendations were implemented and reduced completion time by more than half.

Business Development Representative

May 2020 - September 2020

• Logged potential sales opportunities to maintain a highly organized database of marketing information.
• Contributed to a proactive calling campaign that generated key sales opportunities, including reengagement with an account that had not been serviced in a decade.

Personal Projects

• Covid ETL Pipeline: ETL processing pipeline that digests data sources related to COVID-19, merges information into a useful dataset, removes unnecessary data points, and undergoes Python transformations. Data is then loaded into SQL database for storage/querying. Applied Microsoft Azure Data Factory skills to create and orchestrate pipelines and data flows. The resulting dataset then turned into a Tableau dashboard.
• Python EDA Traffic Data: Utilized a Jupyter Notebook to perform exploratory data analysis on a dataset from UCI Machine Learning Repository to determine influential factors on traffic patterns for I-94 Interstate Highway. Visualizations employed matplotlib.
• Business Analysis with SQL: Leveraged SQL to answer key business questions regarding the Chinook Music Store database using SQLite in a Jupyter Notebook. The analysis utilized several CTE’s, case expressions, and subqueries.

Education & Certifications

• Microsoft
  Azure Data Engineer Associate, February 2023
  Power BI Data Analyst Associate, December 2023
• Regent University, Virginia Beach, VA
  Masters in Business Administration, Concentration in Innovation Management, December 2020
• Liberty University, Lynchburg, VA
  Master of Arts in Theological Studies, December 2017
• Bob Jones University, Greenville, SC
  Bachelor of Arts in Biblical Studies, May 2015