Janilson Andrade

Architectural Oversight: Designing and documenting robust software/data architectures to support large-scale integrations. Performance Engineering: Optimizing complex Presto/Spark queries and Airflow workflows to improve system reliability and processing efficiency. Operational Automation: Developing internal productivity tools and dashboards using Retool and Python. Technical Advisory: Leading client-facing discovery sessions to translate business objectives into engineering roadmaps.

Focused on large-scale data migrations and the design of high-throughput data pipelines for enterprise environments. Migration Lead: Spearheaded a mission-critical migration from Vertica to Oracle, ensuring 100% data integrity and zero downtime. Pipeline Infrastructure: Engineered real-time data streaming pipelines integrating Kafka, S3, and Snowflake. System Optimization: Conducted architectural reviews and query tuning to enhance ETL performance across distributed systems.

Led the cloud strategy and technical execution for a major US-based e-commerce platform. Cloud Strategy: Designed and implemented scalable AWS Serverless architectures (Lambda, API Gateway) using Node.js and Python. Technical Leadership: Acted as the primary architect for business discovery, bridging the gap between stakeholders and engineering teams. Data Engineering: Developed high-performance data processing routines and specialized image processing workflows.

Sharing 15+ years of industry experience with the next generation of data professionals. Lectures: Introduction to Big Data, Big Data Architecture, and ETL Tools. Focus: Bridging theoretical concepts with real-world implementation in Cloud and Big Data environments.

Provided senior technical leadership for high-availability systems with a focus on cloud-native scalability. High-Availability Design: Directed architecture for distributed microservices to handle peak traffic loads. AWS Infrastructure: Optimized cloud resource utilization using SNS, SQS, Route 53, and Aurora. Full-Stack Leadership: Managed the technical roadmap and led development using Go (Golang) and Serverless patterns.

Systems development in Fluig, Python/Flask, Chatbot, Machine Learning, ERP Protheus, Business Intelligence, etc.

BI and Datawarehouse development using Looker, Pentaho Suite, Airflow, Spark, Databricks, AWS e SparkSQL, weblogs, Google Ads, RDBMS, webservices, NoSQL Databases, etc.

Development of reports using Microsoft Stack (SSRS, SSIS, MSSQL, PowerBI). I was responsible to create complex queries, stored procedures and user defined functions. I was always in contact with the client and we both design the reports

Creation and maintenance of the Buying/Financing Management software Migration of current BI software to Qlik Sense format. I'm responsable to create the dimensions, Qlik load scripts and Qlik administration. Meanwhile I continue to give support to current BI software, creating new report when it is needed, and managing its database.

Development of a web system for contract administration. This System gives a large number of functionalities and many management reports. Everything was done using Scriptcase as RAD (Rapid Application Development), Eclipse BIRT (Business Intelligence Report Tool) for reports and Oracle as main DBMS. This system is integrated with the ERP VetoRH, from Senior Sistemas Company

Technical support to a php and ajax framework (code generator). Manipulating databases such as SQL Server, Oracle, Postgres, MySQL. International video conferences (english and spanish) for training about that framework

Development of java applications using webservices and Databases (Oracle, MySQL)