Luciana Rocha

• Architect and develop an AWS-based serverless SaaS EdTech platform, owning cloud architecture, backend workflows, and data design end to end.
• Design DynamoDB data models and access patterns for users, practice modules, attempts, scoring, results, and learning progress.
• Build application workflows supporting authentication, exam processing, scoring, analytics-related functionality, payments, and product execution.
• Apply security, reliability, maintainability, and cost-conscious decisions across the product and cloud architecture.

Technology: AWS Lambda · DynamoDB · Amazon Cognito · API Gateway · S3 · AWS Amplify · Next.js · TypeScript · Stripe

• Led reporting and data migration work from SQL Server 2022 to PostgreSQL while preserving analytical continuity and trusted outputs.
• Developed and optimized ETL/ELT workflows using Amazon S3, AWS Glue, Python, and Jupyter.
• Redesigned and modernized 15+ production dashboards from Tableau to Amazon QuickSight.
• Partnered with product, engineering, and business stakeholders on KPI definitions, data quality, reconciliation, and dependable analytics delivery.

Technology: PostgreSQL · SQL Server · AWS Glue · Amazon S3 · Python · Jupyter · Tableau · Amazon QuickSight

• Built AWS data pipelines that received raw files in Amazon S3 and transformed CSV data into date-organized, partitioned Parquet datasets.
• Developed Python ETL workflows for cleaning, standardization, duplicate handling, and consistency controls before analytical delivery.
• Orchestrated pipelines with Apache Airflow Python DAGs, using S3KeySensor and completion-marker controls to detect expected deliveries and surface missing-file failures.
• Maintained cataloged data through AWS Glue and enabled ad hoc analysis with Amazon Athena and warehouse analytics in Amazon Redshift.
• Collaborated with Finance, Operations, BI, and Data Science stakeholders to shape reliable downstream analytical structures and data access.

Technology: Python · Apache Airflow · Amazon S3 · Parquet · AWS Glue · Amazon Athena · Amazon Redshift

• Developed an HR analytics and data platform using Oracle, Informatica PowerCenter, and BusinessObjects to support HR indicators and more frequent reporting availability.

• Translated Marketing and Sales requirements across pharmaceutical-market, distribution, commission, and tender domains into PowerCenter ETL and Cognos analytics, coordinating development, testing, and business approval.

• Managed a team of four analysts delivering BI and ERP integration with Oracle and PL/SQL, spanning stakeholder requirements, data quality, ETL, analytics, and reporting.

• Developed Oracle and PL/SQL reporting and contributed to an evaluation framework for selecting business-intelligence tools.

• Developed PowerCenter 8.0 ETL for nine Latin American affiliates, applying ETL practices, testing, risk management, and BI user support.

• Led BI, ETL, and reporting delivery for clients including PepsiCo, Vale, Cyrela, and Red Bull, delegating development work and providing technical and functional guidance across BusinessObjects, Cognos, and PowerCenter.

• Improved data-warehouse ETL processes with Informatica PowerCenter for sales and marketing BI, including workflow restructuring and performance tuning.

• Delivered DataStage ETL, PL/SQL, SQL performance tuning, and data-warehouse work for clients including Vivo Telecom and GE Capital Brazil.

• Supported ETL strategy, database restructuring, SQL tuning, data modeling, quality assurance, and warehouse delivery using Cognos and BusinessObjects for clients including Parmalat and Mapfre.

• Supported data-flow architecture and DW, data-mart, and ODS work with DataStage for credit and finance analytics.

• Collaborated with business analysts on iterative data, report, and dashboard delivery.