ANDREI VARELA SOLANO
Full Stack Developer | Backend & Data-Oriented Engineer
Summary
Technically skilled and self-taught Full Stack Developer with a strong foundation in backend development. Expertise in data-driven development, platform optimization, and AI-assisted workflows. Designed, built, and scaled systems for logistics, analytics, dashboards, reporting tools, and customer-facing platforms over the past 7+ years. Focus on reducing costs, streamlining operations, and transforming complex data into actionable insights. Core stack includes Node.js, Express, PostgreSQL, Prisma, SQL Server, REST APIs, and cloud platforms like DigitalOcean and AWS. Excel in leadership roles by setting an example for teams. Experience managing small development teams, mentoring junior developers, conducting thorough code reviews, and taking ownership of projects from requirements to deployment. Well-versed in working across deployment pipelines and reengineering legacy systems when necessary. Self-taught wedding and portrait photographer with a keen eye for light, storytelling, and emotional impact. Embrace the use of AI tools like ChatGPT, Claude, Midjourney, Davinci, and Lovable to accelerate ideation, optimize workflows, and expand creative possibilities. Continuously learning advanced prompting techniques and integrating AI into both technical and creative projects. Prioritize clarity, functionality, and meaningful impact in all endeavors.
Overview
10
10
years of professional experience
2
2
Languages
Work History
Freelance Photographer & Videographer
Varela Photography
01.2021 - Current
- Professionally captured over 50 weddings, managing the entire production process—from pre-production planning and creative direction to post-production editing and final delivery.
- Specialized in emotional, storytelling-focused photography and videography that highlights human connection and atmosphere.
- Self-taught and continuously improving through hands-on practice, research, and exploration of new trends and technologies.
- Edited, toned, captioned, and uploaded photographs for publication and client delivery across various platforms.
- Digitally enhanced photos and video using Adobe Lightroom, Photoshop, and Premiere Pro to meet professional visual standards.
- Utilized both natural and artificial lighting setups to achieve desired aesthetics in diverse shooting environments.
- Maintained excellent communication with clients before, during, and after each project to ensure creative alignment and satisfaction.
- Managed multiple concurrent projects, meeting tight deadlines through careful scheduling and attention to detail.
- This creative work has strengthened my visual composition, narrative thinking, and client engagement—skills that directly enhance my work in tech and design.
Full Stack Developer & Tech Lead
Alltruck
01.2018 - Current
- Designed and built a scalable logistics platform with integrated data tracking to support business KPIs.
- Migrated infrastructure from AWS to DigitalOcean, reducing operational costs and improving data access performance.
- Led the development of driver and admin applications, used daily by 600+ users handling over 400 daily trips.
- Built and maintained internal tools for operational dashboards, client reporting, and custom data queries.
- Integrated third-party systems like Burger King's app via APIs, centralizing and streamlining external data feeds.
- Developed functional databases, back-end applications, and servers to support scalable web platforms.
- Integrated third-party APIs to enhance functionality and improve overall user experience across web platforms.
- Collaborated with back-end developers to design robust APIs.
- Used Node.js, ORMs, and SQL/No-SQL databases for application development and data management.
- Developed responsive web designs ensuring compatibility across multiple devices and browsers.
- Led by example, actively contributing to the codebase, conducting code reviews, debugging issues, and maintaining best practices.
- Tested, deployed, and maintained scalable and highly available software products.
- Promoted innovation by researching and applying cutting-edge technologies to projects.
- Improved database efficiency through the design of normalized and optimized schemas.
- Built and structured relational databases and table designs for dynamic web applications.
- Managed and motivated employees to maximize productivity and engagement.
- Conducted regular performance reviews, identifying improvement areas and implementing actionable development plans.
- Successfully managed multiple projects simultaneously by prioritizing tasks based on urgency, resources, and business objectives.
- Planned, designed, and scheduled phases for complex, large-scale projects.
- Assisted in promoting and selling the logistics system to potential clients.
- Provided technical support and training to employees and customers.
- Gathered, analyzed, and documented business requirements based on client and user needs.
- Participated in cross-functional meetings with managers, owners, and department heads to define project scopes and strategic goals.
- Acted as a liaison between technical teams and business stakeholders, translating requirements into technical solutions.
- Handled DevOps-related tasks such as server migrations, deployment pipelines, and basic infrastructure management on DigitalOcean.
- Managed end-to-end project delivery, from initial client consultation and technical planning to implementation, testing, and deployment.
- Coded websites using HTML, CSS, JavaScript, and jQuery.
- Planned and developed websites, converting mockups into fully functional web presences using HTML, JavaScript, AJAX, and JSON.
- Developed and implemented custom WordPress sites, themes, and plugins.
- Optimized website performance through regular updates, security enhancements, and advanced optimization techniques.
Co-Founder / Developer
GravityCR
01.2015 - 01.2021
- Designed and developed custom websites for high-profile clients such as BrujulaTV and Los Tenores.
- Consulted clients on branding, digital presence, and web strategies to enhance business visibility.
- Managed client acquisition, building and maintaining strong relationships to expand company portfolio.
- Provided end-to-end support including domain registration, server hosting sales, and web maintenance.
- Delivered graphic design services, creating logos, brand assets, and visual content for client websites and marketing campaigns.
- Advised businesses on web analytics and reporting tools to track and optimize online performance.
- Developed backend systems and basic data insight tools to support operational efficiency.
- Handled post-launch technical support, ensuring high service satisfaction and client retention.
Software Developer
NW Ideas
01.2017 - 01.2018
- Created backend solutions for small businesses that needed data access with limited tech infrastructure.
- Debugged and restructured legacy projects to improve database use and performance metrics.
- Built internal and client-facing WordPress platforms with custom analytics and usage stats.
- Improved software efficiency by troubleshooting and resolving coding issues.
- Saved time and resources by identifying and fixing bugs before product deployment.
- Updated old code bases to modern development standards, improving functionality.
- Developed software for desktop and mobile operating systems.
- Developed customized software solutions for diverse clients, resulting in increased satisfaction and repeat business.
- .Mentored junior developers to improve their technical skills, fostering a culture of continuous learning within the team.
- Increased development speed by automating repetitive tasks using scripts and tools.
- Translated customer requirements into written use cases.
- Optimized database queries for enhanced performance, enabling faster data retrieval and processing.
- Played key role in mentoring junior developers, elevating team competencies and fostering supportive work environment.
- Rapidly prototyped new data processing capabilities to confirm integration feasibility into existing systems.
IT & SQL Developer
Euromobilia
01.2016 - 01.2017
- Generated high-impact SQL reports for accounting, inventory control, and executive-level decision-making.
- Supported internal departments with real-time data fixes, ad hoc analysis, and reporting using SQL Server.
- Improved database performance by optimizing queries and implementing effective indexing strategies.
- Developed and maintained custom database objects, stored procedures, and backend logic to support business applications.
- Conducted code reviews and rigorous testing to ensure clean, secure, and maintainable code.
- Analyzed and refactored existing SQL codebases to increase efficiency and reduce processing times.
- Delivered application support and resolved technical issues with speed and precision.
- Handled customer complaints with empathy and professionalism, contributing to higher client retention and satisfaction.
- Maintained composure and professionalism in high-stress environments, effectively resolving disputes and internal escalations.
Education
Técnico medio - Desarrollo de Software
Ing. - Informática
Skills
SQL
undefinedPhotography Video Experience
Freelance Photographer & Videographer, 01/01/21, Present, For the past four years, I've worked professionally in wedding and portrait photography and videography. With over 50 weddings captured, I manage the entire process-from pre-production and direction to editing and delivery. I specialize in capturing emotional and storytelling moments, and I've developed all of my skills through self-teaching, practice, and passion. This creative experience has enhanced my attention to detail, composition, and client communication-skills that also strengthen my tech work., Adobe Lightroom, Premiere Pro, Photoshop, DSLR & mirrorless cameras, lighting setup, audio capture, video editing, creative direction
Timeline
Freelance Photographer & Videographer - Varela Photography
01.2021 - Current
Full Stack Developer & Tech Lead - Alltruck
01.2018 - Current
Software Developer - NW Ideas
01.2017 - 01.2018
IT & SQL Developer - Euromobilia
01.2016 - 01.2017
Co-Founder / Developer - GravityCR
01.2015 - 01.2021
Universidad Hispanoamericana - Ing., Informática
CTP Abelardo Bonilla - Técnico medio, Desarrollo de Software
Similar Profiles
Arsal FaisalArsal Faisal
Indenpendent Contractor at Varela Limo IncIndenpendent Contractor at Varela Limo Inc
Leonardo Andrés MolinaLeonardo Andrés Molina
Subsecretario de Acciones territoriales at Municipalidad de Florencio Varela, Secretaria de SaludSubsecretario de Acciones territoriales at Municipalidad de Florencio Varela, Secretaria de Salud
Ryian VarelaRyian Varela
Shop Hand at Varela Diesel PerformanceShop Hand at Varela Diesel Performance
Casey J PorterCasey J Porter
Freelance Photographer · Videographer · Editor at Various ClientsFreelance Photographer · Videographer · Editor at Various Clients
Manuel RamosManuel Ramos
Freelance Photographer/Videographer at Manual Labor MediaFreelance Photographer/Videographer at Manual Labor Media