Yilmar – Python, React, MongoDB

An intelligent dynamic reporting platform that automates project governance and progress tracking across multiple organizational initiatives. The system leverages an autonomous SQL agent to query, aggregate, and analyze multi-source project metrics, generating customizable data visualizations, structured tables, and executive summaries that users can refine via interactive chat before exporting to production-grade PDF and PowerPoint decks.

• Architected and implemented the end-to-end full-stack platform using FastAPI, Python, React, and TypeScript, delivering a high-throughput reporting engine.
• Designed a LangChain-powered SQL agent capable of dynamically inspecting schema definitions, synthesizing optimized read queries, and aggregating project metrics with strict read-only execution sandboxing.
• Built dynamic chart- and table-generation pipelines, allowing users to customize, edit, or regenerate specific report sections via natural language commands and real-time UI controls.
• Engineered backend export workers capable of rendering complex document templates into high-fidelity PDF reports and interactive PowerPoint presentations asynchronously.
• Implemented structured error handling, schema validation using Pydantic, and comprehensive API caching to maintain sub-second response times across heavy analytical queries.
• Containerized all application services using Docker and configured CI/CD delivery pipelines via GitHub Actions targeting AWS infrastructure (ECS Fargate, Aurora PostgreSQL, S3).

Client-facing web applications developed for a digital marketing agency, supporting business and marketing operations through Python- and React-based solutions.

• Developed a responsive web platform to manage registration, attendance tracking, and certification for scientific congresses.
• Designed relational database schemas and implemented data access using ORM-based models.
• Built frontend interfaces with React and JavaScript to manage forms, workflows, and user interactions.
• Implemented backend services using Python and Django-based APIs to support core business processes.
• Developed and maintained frontend and backend features.
• Participated in client meetings, demos, training sessions, and production releases.
• Developed a responsive web application for formulation and recommendation of nutraceutical products, including email-based interactions for patients and notifications for distributors and manufacturers.
• Designed and implemented Python-based APIs to support product logic, recommendations, and notification workflows.
• Contributed to the frontend using React and TypeScript, implementing complex forms and validation flows.
• Collaborated closely with clients to gather requirements, present progress, and deliver production-ready features.
• Developed and maintained backend APIs and frontend components.
• Integrated business logic with database models and external services.

Client-facing web solutions and reusable web platforms for building, managing, and maintaining websites. The platforms support flexible website development and provide reusable components that can be adapted across different web projects.

• Delivered a responsive website for an educational organization, working directly with stakeholders from requirements gathering to training and final delivery.
• Designed and implemented relational data models to support dynamic, content-driven pages.
• Built reusable UI components and layouts that enabled faster delivery of similar client websites.
• Contributed to the creation of an internal website builder, which became the foundation for multiple subsequent projects.
• Developed frontend and backend features for client websites.
• Participated in client meetings, progress reviews, training sessions, and production handover.