David Zapata

I am an experienced professional in developing and implementing systems and applications across multiple industries. I have led teams to improve the efficiency of processes and systems, achieving successful results and significant productivity improvements. I focus on creating efficient solutions that reduce costs and increase effectiveness and customer satisfaction.

Student - Graduate Certificate in Web Development

Conestoga College-Kitchener, Ontario September 2023 to December 2024

During this period, I successfully completeda 2-year Web Development programat Conestoga College, achieving academic distinction. This experience allowedme to enhance my technical skills, deepen my understanding of modern web technologies, and prepare for the next phase of my professional career.

Web Developer Freelance/Self-employed October 2022 to May 2023

• Star Jets Mexico: Designed and deployed a fully responsive website for Star Jets Mexico (starjetsmx.com), increasing online inquiries by 20% and enhancing the company's digital presence to attract a wider audience.
• Onward Jets, Carlsbad, California, U.S: Developed and implemented a web-based flight quotation system for Onward Jets, automating the pricing process and reducing manual efforts by 40%, significantly boosting internal operational efficiency.
• SP Protector S.A. de C.V. Mexico: Designed and developed an interactive web dashboard for SP Protector S.A. de C.V., enabling real-time data analytics with GPS coordinate visualization, improving client decision-making processes and providing precise operational insights.

Odoo & Backend Manager Diri Telecommunications December 2020 to August 2022

Software Development:

• Designed and deployed web solutions to automate communication between internal systems, web portals, and databases, achieving seamless integration and optimizing performance. This enabled the successful launch of 2 web portals and drove measurable business growth. (diri.mx, pillofon.mx)
• Led a multidisciplinary team to streamline Odoo ERP workflows, improving key processes like invoicing and financial reporting. Successfully eliminated potentialinvoicing errors, ensuredaccurate and reliable financial statements, and reducedsupport complaints by 10%, drivinggreater efficiency and improving client satisfaction.

Infrastructure and IT Support:

• Managed and maintained IT infrastructure, including high-availability networks, VPNs, firewalls, switches, routers, and VoIP systems, ensuring seamlessconnectivity and securityacross the organization.
• Administered AWS and GCP services, optimizing server performance and ensuring high availability for critical business operations.
• Led a team of three engineers, providing technical support to end-users, resolving hardware, software, and network configuration issues, and maintaining a 98% resolution rate within SLAs.
• Developed backend systems to integrate payment gateways, web portals, and vendor communications, enhancing operational efficiency and reducing processing times.
• Installed and monitored CCTV and IP telephony systems, improving workplace security and communication reliability.

Systems Manager

FlyAcross

January 2016 to August 2020

Software Development:

• Implemented a comprehensive Disaster Recovery Plan (DRP) to safeguard criticalflight control data, ensuring continuity during system failures. Automated backups were sent to Customer Experience, CCO, and Hangar offices, minimizing operational disruptions and maintaining service reliability.
• Developed a Flight Confirmation System for the Sales department, integrating flight itineraries and documentation checklists across departments. The system streamlined communication within 24, 4, and 2 hours before departure, reducing customer complaints by 50% and improving client satisfaction.
• Developed a Ferry Flight application that streamlined sales operations for specialized flights, generating over USD 250,000 in revenue within four years and enhancing operational efficiency for the company.
• Designed and implemented a budget application for the procurement department, preventing unjustifiedexpenses of over USD 925,000within two years,ensuring effective resourceallocation and cost control.

Infrastructure and IT Support:

• Managed IT infrastructure across 5 operational facilities, ensuring high-quality and high-availability services for Internet, IP telephony, and CCTV systems through implementing Fortinet solutions, enhancing productivity and user experience.
• Installed and configured Astro-BoldIQ (Jeppesen-Boeing flight management software) on six on- premises servers, transitioning the Operations Control Center (CCO) from manual to automated flight calculations, significantly improving efficiency and accuracy.
• Reduced software and equipment costs by 20% through effective negotiations with suppliers and strategic management of acquisition and renewal contracts.
• Led a team of 5 technicians and 3 engineers, providing end-user support and ensuring timely resolution of technical issues, maintaining a 95% satisfaction rate among employees.

Systems Manager

Notaria 10 Acapulco

January 2012 to June 2016

Software Development:

• Developed a web-based administrative system to manage legal documentation, ensuring proper workflow, quality control, and secure archiving.
• Optimized documentation processes, reducing preparation times by 30% and enabling real-time status tracking through the platform, enhancing client transparency and satisfaction.
   

Infrastructure and IT Support:

• Restructured the network infrastructure and implemented WAN balancing using multiple providers and physical media,ensuring uninterrupted connectivity and improving servicequality for 50 users and clients.
• Installed and maintained on-premises servers (Windows Server, Linux), supporting legal document management systems and ensuring data availability and security for daily operations.
• Managed IT equipment, including computers, CCTV systems, telephony, and PBX systems,providing timely technical support to 50 users and ensuring seamless daily operations.

Java Analyst / Senior Automation Engineer

HSBC

April 2010 to October2011

• Developed a multi-threaded Java process to rename files across nationwide insurance projects, increasing processing speed from 1 file per secondto over 500 files per second, ensuring100% on-time completion.
• Automated application monitoring for production environments in Latin America using HP Business Availability Center,enhancing alert accuracyand increasing productivity from 1 to 10 monitoring scripts developed daily.
• Optimized production environments by creating tailored scripts to streamline operational tasks, reducing response times for critical incidents by 30%.

Software Engineer

SICA

January 2009 to April 2010

• Developed and enhanced a web-based OSS (Operation Support System) to monitor the quality of internet, TV, cellphone, and landline servicesfor over 60,000clients across Costa Rica, Honduras,Mexico, and El Salvador.
• Improved customer support efficiency by upgrading system features, reducing response times by 40%, and providing real-time insights into service performance.
• Streamlined operational workflows by integrating data visualization tools into the OSS, enabling telecom companies to proactively identify and address service issues.

Ontario CollegeCertificate in Web Development

Conestoga College Doon Campus - Kitchener, ON September 2023 to December 2024

Grade: Distinction

Bachelor of Science in Computer Systems Engineer

Monterrey Institute of Technology and Higher Education (ITESM) - Toluca, Mexico January 2003 to December 2008

Grade: Outstanding Performance CENEVAL