Michael Melgar Email & Phone Number

• Designed database schema (PostgreSQL) for holding survey data
• Developed ETL (using Python/pandas) processes to structure and normalize data to be loaded onto database
• Constructed aggregate data structures using pandas DataFrame and hierarchical indexing to facilitate data analytics
• Consulted on data analysis and presented next phase solutions which include data visualization dashboard (using Dash) and full-stack survey application (React/Rails/PostgreSQL)

• Oversaw day-to-day operations of a boutique, white-glove transportation company consisting of 80+ employees and 40+ vehicles, working closely with President/Owner to ensure streamlined and effective processes
• Developed new trip record parsing system to aid with analytics as well as reducing the time required for producing weekly trip reports to comply with new TLC directive by over 70%
• Forged partnerships and negotiated contracts with clients totaling over $4,000,000
• Handled escalated client relations in addition to brokering partnerships and general stakeholder management

• Coordinated dispatch of 200+ trips per day, making quick decisions to manage immediate requests from VIP clients while maintaining 98% satisfaction of scheduled trips
• Integrated on-board tablets in vehicles, combined with OBD GPS to streamline trip update/tracking process, reducing office staff data entry workload by over 50% and reducing trip lead times by 30%
• Managed IT Support, ensuring all hardware/software on and off the field were optimal, using feedback and data to iterate upon ideal implementations

• Dispensed account support/troubleshooting and upheld SLAs via phone, email, and Remedy ticketing system
• Provided occasional on-site client walk-in support for troubleshooting network device setup and account access.

Computer Software Engineering

1000 hour coding intensive with a 3% acceptance rate. Instruction focused on Ruby, Rails, JavaScript, SQL, React, Redux, HTML5, and CSS3..

Psychology

Activities and Societies: Academic Achievement Program (AAP)

Advanced Regents Diploma W/Honors

Activities and Societies: Educate to Elevate (Multicultural enrichment/appreciation society)• Passed 8 NY State Regents exams with <90%.