RAÚL COLINA LLERENA

• Provide insights to Operations through Data Visualization and Analysis in reports created within Microsoft Power BI.
• Extensive use of Power Queries and Power Pivot through Microsoft Excel.
• Responsible for integrity of data collected from various sources (SSMS, Excel) to ensure it's accuracy within reports.
• Support area to identify opportunities to improve efficiency or presentation of information.
• Enhance data integrity by applying meticulous attention to detail when reviewing and analyzing data maintenance processes.
• Generate queries utilizing SSMS to create required reports.
• Continuously assess current reporting techniques and developed improvements to boost accuracy.
• Produce quality reports formatted in compliance with data quality standards.

• Analyze information for construction of "Improve Assessment" methodology during development of project.
• Assist project manager with projects follow-up.
• Create documentation and mapping of processes in different areas such as Human Resources, Accounting, Operations.
• Analyze information, create dynamic tables and dashboards in Excel, Power BI, Google Sheets to track operational personnel metrics within organization.
• Develop monthly reports for client business lines.

• Plan and execute required maintenance to ensure repair quality in workshops and continuous operation.
• Assist in creation of procedures to ensure repair processes.
• Perform critical purchases to maintain job site safety.
• Project CAPEX for investment in tools for company's headquarters.
• Calculate performance indicators.
• Manage technician time registration.
  
  

• Create and keep records of interventions on engine components as well as those of maintenance execution on these.
• Monitor oil analysis and field reports.
• Assist in monthly planning meetings associated with preventive engine maintenance.
• Execute functions as Project Supervisor in charge of different mine sites (Prodeco Calenturitas, Drummond El Descanso and Pribbenow) and prepare monthly reports for each of them.
• Calculate performance indicators.

________________________________________________________________

Achievement: 90% decrease in delivery times and generation of monthly reports (from the 4th week to the 1st of the month); through the implementation of a monitoring model, organization of templates and automation of production processes through Excel and Visual Basic.

• Coordinate planning and execution of adequate maintenance on the vehicles used in the operation as well as on the different refrigeration equipment delivered to customers.
• Approve adequate installation of refrigeration equipment according to customer requirements.
• Manage operating budgets.
• Track performance indicators.

• Ensure the availability of the necessary elements to carry out the disassembly and cleaning of components.
• Maintain monitoring of the programming established for the disassembly of components.
• Ensure ranges of delivery times for evaluations and quotes.

________________________________________________________________

Achievement: the delay in washing times and saturation of components in bays is reduced by 35%, by generating an identification system to be distributed to different washing areas. Optimization of 4 hours to 2.5 hours is achieved in the process.

• Develop concept drawings for bucket elevators using SolidWorks.
• Assign bill of materials according to product specifications.

________________________________________________________________

Achievement: optimization of blueprint delivery times by 66%, from 3 days after receipt of the request to 1 day. This is achieved through the implementation of Visual Basic for automation of assembly and drawing creation through Solid Works.