Iván Travisany Ponce Email & Phone Number

Mississauga, On, Ca

Mississauga, Ontario, Canada

• Adapted seamlessly to the Canadian workplace by quickly understanding and integrating into local communication styles and fast-paced environments, contributing effectively in a diverse setting.• Demonstrated excellent communication skills in both English and Spanish by providing personalized wine recommendations for every customer and ensuring great experiences.• Recognized as a role model within the first two months of employment based on KPIs.• Adapted quickly to new tasks and responsibilities, demonstrating flexibility to learn and a willingness to take on additional roles such as cashier duties and product restocking as needed.

Santiago, Santiago Metropolitan Region, Chile

• Led the implementation of a critical surgical ward management software in an Agile environment, translating medical staff needs into clear software requirements for developers.• Utilized advanced DAX expressions and Power M queries in Power BI to develop over ten dynamic reports and dashboards, providing actionable insights into hospital operations and improving decision-making processes.• Developed a comprehensive Power BI report to analyze delays in various types of surgeries, providing actionable insights to optimize scheduling and reduce wait times, ultimately improving patient care and hospital efficiency.• Developed automated Power BI reports using SQL and Excel that calculated nurse-per-patient ratios, adhering to international standards and ensuring optimal nurse workload while also preventing overwork.• Streamlined complex digital processes by developing automations using RPA and Python, that reduced manual tasks, saving significant time and increasing efficiency across the department.• Managed sensitive patient data with strict adherence to guidelines, ensuring privacy and accuracy while handling large datasets for reporting and analysis.• Analyzed large and complex datasets from multiple joined SQL tables and integrated these data sources into Power BI, creating insightful visualizations and reports that supported hospital administration and operations.• Utilized Excel to create automated calculations using macros, significantly improving tasks across different departments. Proficient in pivot tables and complex formulas to enhance data analysis.• Thoroughly documented all processes, reports, and workflows, ensuring a smooth transition and comprehensive handover for the next person in the role, facilitating continuity and operational efficiency.

Santiago, Santiago Metropolitan, Chile

• Developed multiple apps from scratch using Power Apps, creating fully functional, low-code solutions from blank canvas that automated manual farm tasks with the help of Power Automate and VBA, significantly reducing human error and improving process efficiency.• Designed and implemented a Power Apps solution to calculate farm worker attendance and automate salary calculations, factoring in multiple conditions. The app also automatically transformed the data using Power Automate and Power BI into a format compatible with Softland ERP for seamless salary processing.• Created a Power App solution for front gate operations, tracking customer times and identifying bottlenecks while also flagging repeat customers who may have had recurring issues, improving both security and process flow.• Configured and maintained Dataverse as the farm’s data architecture, ensuring that all reports and apps had a reliable, scalable data foundation.• Developed a Power BI report connected to an API that provided real-time geo-management of farm machinery and trucks, optimizing resource allocation also tracking kilometers covered by each machine, translating this data into insights on machine efficiency.• Conducted technical interviews for office positions, leveraging your computer expertise to evaluate candidates’ technical skills.• Generated presentations using Office 365 and Visio diagrams to support CEO decision-making and improve visibility of key operational metrics.• Established trust and strong connections with several farm workers, pivotal in promoting the effective integration of technology in an environment where its adoption is not widespread.

Chile

• Led a project that achieved a 29% reduction in project delays by integrating commercial management and software development management through ETL processes, using Rocketbot RPA to extract data from Bitrix and load and transform it into Clarity for better availability and process integration.• Enhanced business processes by validating critical data, ensuring timely sharing of key documents, and optimizing resource availability, which contributed to improved project timelines.• Applied advanced statistical methods, pareto diagrams and root cause analysis alongside thorough research on state-of-the-art solutions to identify and address the root causes of project delays.• Standardized company documents by creating a unified design and format for all documents, making them easily accessible across the company, improving communication and documentation consistency.

Santiago, Santiago Metropolitan, Chile

Big Data Analytics, Information Technology

Bachelor'S And Master'S Degrees, Civil Engineering

Minor in Information Technologies