Andres Mercado Email and Phone Number

• Developed a professional homepage for Araceli’s Cleaning Services to help attract new clients.• Configured and deployed the website using AWS EC2 for hosting and Route 53 for domain management.• Implemented SSL/TLS encryption through AWS Certificate Manager and an Application Load Balancer, ensuring secure HTTPS access.• Used Nginx and Docker for streamlined deployment and site management.• Emphasized user experience and simplicity on the homepage, with plans for future expansion to include more features.

Created and developed SkyHighOps Aviation, a comprehensive airplane management system that streamlines operations for small to mid-sized airports. Initially, the workflow was managed through a static Excel sheet, and I recognized an opportunity to make it dynamic and more efficient. The project began using the MERN stack (MongoDB, Express, React, Node.js), but due to the difficulty in managing relationships in MongoDB, I transitioned to a relational database for better scalability and data integrity. I also integrated Redux into the frontend to reduce component usage and improve state management, which resulted in a more efficient and maintainable codebase.The system facilitates dynamic aircraft parking assignments, owner linkage, and fuel request management, reducing manual work and improving accuracy. I also integrated weather and flight APIs to provide real-time data for better operational decision-making.The platform was redeveloped using Python, Flask, SQLAlchemy, PostgreSQL, and React with Redux for state management on the frontend, along with CSS for styling. It also leverages AWS S3 buckets for image uploads and Docker for containerization, ensuring a scalable and reliable infrastructure. Over the course of two years, I continuously enhanced the platform, working closely with airport employees to customize features, streamline workflows, and optimize overall efficiency.

I have extensive experience as an Aviation Line Service Technician, specializing in fueling operations for aircraft valued at millions of dollars. My role involved driving a fuel truck and ensuring meticulous attention to detail to prevent misfueling incidents, which are critical in aviation safety.My key success for this role is:• Safely operated a fuel truck to transport aviation fuel for high-value aircraft.• Conducted precise and safe fueling procedures to avoid misfueling incidents.• Implemented stringent safety protocols to ensure compliance with aviation regulations.• Secured aircraft and performed thorough safety checks to maintain operational integrity.• Interacted directly with customers, including pilots and flight crews, to deliver excellent service and address their specific needs.• Closed invoices promptly and accurately after completing fueling tasks to ensure efficient operations.

I oversee multifamily and condominium properties, ensuring tenant reliability and responsibility through thorough background checks and proactive management strategies. My role as landlord and property owner allows me to maintain high property management standards and foster a positive living environment for tenants.My achievements are as follows:• Successfully Built a Six-Figure Real Estate Portfolio: Through strategic investments and meticulous planning, I built a real estate portfolio generating a six-figure annual income within five years.• Managed a diverse portfolio of 3 properties with 14 total tenants• Research and gather data on potential future properties• Conducted Comprehensive Market Analysis: Performed in-depth market analysis to identify lucrative investment opportunities, leading to a 15% increase in property values within two years.• Achieved High Occupancy Rates: Consistently maintained an occupancy rate of over 95%, demonstrating strong tenant relationship management and effective marketing strategies.• Led Successful Renovation Projects: Managed and completed multiple renovation projects on time and within budget, enhancing property values and rental income potential.• Built and Managed a Reliable Team: Assembled a dependable team of contractors, property managers, and maintenance personnel, ensuring smooth operations and high property standards.• Utilized Technology for Property Management: Leveraged property management software and tools to enhance efficiency, track maintenance, and streamline communication with tenants.• Optimized Rental Income: Identified undervalued rents through detailed market analysis, strategically adjusting rates to achieve a projected annual increase in rental income across multiple properties.

Skills: JavaScript • React • Express.js • MongoDB • Node.js • Authentication • Authorization • One-to-many Relationship • Password HashingReorganized my current employers airplane account list. From an excel sheet to a full stack application where customers and employers are able to access each planes location. Also implemented a one to many relationship where a tail number can have multiple owners.

Skills: JavaScript • React • Express.js • MongoDB • Node.js • Authentication • Authorization • Multer • Password HashingAn application where any family member is able to add any picture that they have of my daughter. Once posted all other post from other users will be viewable.

Skills: MVC • JavaScript • React • Express.js • MongoDB • Node.js Description: Developed an application page where anyone can inquire about a properties availability.

Skills : ASP.NET MVC JavaScript , react, express , MongoDB, html , CSSDescription: Developed, organize, and collaborated a full web application where a user is able to add and review their favorite trail

As a part of this job role, I performed day-to-day tasks in the department while serving as package handler. I was entrusted with overseeing all aspects of parcels, from assembling, filling, sealing, scanning, and loading on trucks for delivery.I established a strong foundation for success by adhering to all warehouse safety guidelines. Furthermore, I guaranteed packages properly packed and loaded.My notable outcome for this role includes:• Scanned and sorted packages aimed at ensuring delivery to the proper place safely and promptly.

During this tenure, I acted as team leader and directed floor, delegated positions to staff, and scheduled daily activities. My notable duties were managing and motivating team of employees to perform jobs efficiently. What makes me stand out from the competition is my radical success in providing daily objectives and developing reward systems for productivity. One of my key tasks was to analyze and communicate any issues with management to achieve business goals effectively.Here is my proudest achievement:• Tracked inventory on daily basis to maintain optimum inventory levels.