Jose Rogelio Aguilar Perdomo Email & Phone Number

Toronto, On, Ca

Toronto, Ontario, Canada

•Designed and executed comprehensive data governance strategies and policies to ensure quality, security, and compliance with the Alteryx Server ecosystem.•Created and implemented 20+ automation workflows, leveraging Analytic Process Automation (APA) principles, optimizing the Treasury, Tax, Billing, and Management teams' time and resulting in over 1,500 hours saved. •Developed a comprehensive handbook of guidelines and best practices which streamlined processes and resulted in 40% increase in the Finance Solutions team’s efficiency and productivity.•Led workshops/training sessions and provided expert guidance on SQL, PowerBI, Alteryx, PowerAutomate, and PowerQuery, empowering teams to leverage advanced tools effectively.•Engineered a standalone status tracker using custom architecture with PowerBI, the Power Platform, and SQL to monitor all units in the Canada region, resulting in over 500 hours saved for a dozen stakeholders.•Provided consulting services to internal stakeholders on optimizing Alteryx workflows, focusing on enhancing security measures, efficiency, optimization, and server readiness, thereby elevating operational effectiveness and data integrity.

Guadalajara Area, Mexico

• Automated team-wide daily metrics reports, integrating data from several platforms (HP Application Lifecycle Management, BMC Remedy, and proprietary tools) decreasing document creation and analysis time by 60%. • Provided all data analysis and reporting in the closure of 131 critical defects for the largest national account, received Employee of the Month award for outstanding leadership, technical, and teamwork skills demonstrated throughout the project.• Liaised between management and technical personnel to ensure a mutual understanding of processes, applications, and software development lifecycle.• Self-taught scripting in Python to automate data retrieval from Defect Management platforms, reducing web stress by 30%. • Developed and improved reporting architecture based on client's requirements, streamlining the process from data procurement to presentation to Senior Management. [Python, VBA, MySQL, Tableau]

Villahermosa Area, Mexico

• Implemented an Integral Management system of Digital Oilfield and Asset Optimization Technology (SIAPPEP), merging the data procurement from several isolated databases, and allowing to measure flow of oil and gas with 70% more precision. • Developed and supported a system in C# to troubleshoot connections between SCADA stations and remote operations sites, mapping and monitoring all physical locations and points of data entry to increase security.• Supported, filtered, and cataloged data from remote stations according to data quality criteria.• Created, reviewed, and edited technical documentation related to the project. [C#, SCADA, NIST SP 800-53]

Monterrey Area, Mexico

• Automated and streamlined end-of-month financial processes reducing time to close and report by 30%.• Executed trades, managed finances, and investments of individual and corporate portfolios. Increased client satisfaction metrics by up to 20% using time-saving automation tools.• Analyzed and monitored trading details to understand market changes and plan personal investment strategies, to maximize price benefits and minimize risk factors. [VBA]

Monterrey Area, Mexico

• Designed and programmed a LabVIEW based Station from the ground-up, including mechanical mounting structure, software, analog and digital data acquisition, involved in the process of pressure measurement of heavy-load automobile braking systems, increasing the number of tests completed by 100%.• Developed a key-on-hand software-based solution, including data procurement, intuitive graphical interface, internal compensations for accuracy, non-repeatability, and hysteresis in the pressure sensors. [LabVIEW, MATLAB, SolidWorks]

Advanced Diploma, Computer Software Engineering, Software Engineering Technology

Bachelor'S Degree, Mechatronics Engineering

Mfi, Finance, General, Master Of Corporate Finance And Management