Sofia Andreina A.

Hi there! I'm Sofi, a Data & Software Engineer with over 3 years of experience building well-structured backend architectures, end-to-end data pipelines, and AI-driven solutions. I specialize in bridging the gap between software development and data engineering. From architecting scalable microservices to deploying custom AI models that interact with databases. 🔻 End-to-End Data Engineering & Architecture 🔹 Complete ETL/ELT Pipelines: Designed, orchestrated, and deployed 100% integrated data pipelines using Python and Apache Airflow. Experience ingesting and transforming data from diverse sources (REST APIs, Web Scraping, Google Sheets, MongoDB, CSVs) and processing 100k+ daily records. 🔹 Database Mastery & Modeling: Advanced SQL/NoSQL modeling (PostgreSQL, MySQL, MongoDB). Developed tables, views, stored procedures and triggers to optimize performance, alongside using DBT for modern data transformations. 🔹 Cloud & Infrastructure: Hands-on experience deploying in Google Cloud (GCP), AWS and MS Azure, implementing secure tunnels (Tailscale), and containerizing applications with Docker. 🔻 AI & Advanced Integrations 🔹 AI-Powered Analytics: Developed NLP systems using OpenAI, Gemini and Claude APIs to transcribe, classify and analyze data automatically. 🔹 Conversational Metrics: Engineered custom AI chatbots directly connected to SQL databases with read-only permissions allowing stakeholders to query complex business metrics using natural language. 🔹 Custom Training: Experience implementing and fine-tuning personalized AI models tailored to specific business needs. 🔻 Software Engineering & Back-End 🔹 Scalable APIs & Multitenant Systems: Architected RESTful APIs from scratch using FastAPI, Django, Express, NestJS, and Java. Proven experience building multitenant architectures for CRM, ERP and forms ecosystems. 🔹 Best Practices: Applied Clean Code principles, Hexagonal Architecture, and Domain-Driven Design (DDD) to ensure modularity, high testability and separation of concerns. 🔹 DevOps & CI/CD: Automated reliable deployments via GitHub Actions, Vercel and Railway. 🔻 Business Intelligence & Reporting 🔹 Dynamic Visualizations: Built interactive dashboards in Tableau, Power BI, and Looker Studio. Created dynamic parameters and calculated fields to track key KPIs (LTV, WoW, CTC). 🔹 Data QA: Automated report testing with Pytest to guarantee data accuracy and consistency across all visualizations. 🔻 Agile, QA & Technical Documentation 🔹 Agile PODs: Active participant in Scrum ceremonies, working closely with cross-functional web and data teams to deliver incremental value. 🔹 Quality Assurance: Applied ISO 25010 standards, creating automated test cases (Selenium, JMeter, Flood io) and comprehensive technical documentation (API specs in Swagger, SRS, QA plans). 🔻 Technical Toolbox 🔹 Languages: Python, JavaScript, TypeScript, Java, SQL. 🔹 Frameworks: FastAPI, Django, Express, Flask, React, NodeJS, NestJS. 🔹 Data & Cloud: PostgreSQL, MySQL, MongoDB, Apache Airflow, Docker, AWS, GCP, DBT. 🔹 Languages: Spanish (Native), English (Advanced C1), Portuguese (Intermediate B1). Thanks for taking the time to learn about me. Examples of my work are available for your review. If you have any questions or would like to discuss how my skills and experiences align with your needs, don't hesitate to reach out and let's connect!