Daniel Chicaiza

Designed and evolved production data systems on AWS using Python, SQL, PySpark, AWS Glue, Lambda, Step Functions, EventBridge, S3, and Aurora PostgreSQL. Supported multiple production pipelines for several clients, including ETL integrations with third-party APIs and ongoing troubleshooting. Improved infrastructure delivery by creating reusable CloudFormation templates and managing production ingestion powering Power BI reports via Streamlit. Coordinated deployments and debugging across CI/CD workflows and AWS networking infrastructure.

Designed, built, and maintained AWS data pipelines that integrated third-party APIs and operational platforms into analytics-ready datasets and PostgreSQL. Developed ETL workflows with Python, SQL, PySpark, AWS Glue, Lambda, Step Functions, EventBridge, S3, RDS, IAM, CloudFormation, and Airflow. Used GitHub and GitHub Actions to manage version control, automate CI/CD deployments, and address production issues. Contributed to architecture discussions and helped create maintainable pipeline structures for the team.

Built and deployed an end-to-end AWS ETL and analytics solution using Terraform for infrastructure as code. Created reusable Terraform configurations to provision pipeline and data-supporting resources. Implemented a programmatic Amazon QuickSight reporting layer, including data sources, datasets, calculated fields, dashboard components, and row-level security. Improved consistency by replacing manual environment setup with code-based, version-controlled deployments.

Developed Python-based data processing and analysis workflows for a cardiac research team using SQL and PySpark. Transformed complex datasets to support research and analytics use cases. Contributed to AWS SageMaker machine-learning efforts by supporting data preparation and experimentation. Helped enable cloud-based analytical workflows for the research team.

Implemented PLM/ERP solutions and advised customers on software-supported design and production processes. Supported the transition of business workflows to configured PLM/ERP capabilities as described in the CV. Responsibilities and tooling details are not specified further in the CV.