Wolfrank Guzman - Data Engineer & ETL Development Specialist

About Me

I'm a Data Analytics Professional with over 6 years of experience in database administration, cloud architecture, and ETL development using AWS and Python. My passion lies in combining real-world trading experience with Data expertise to create innovative solutions that bridge the gap between markets and cloud technology. This is why when not working for Imperium, I'm a funded derivatives prop trader with over 15 years trading experience. I am currently developing algorithmic trading systems for Nasdaq 100 derivatives and Forex USD pairs. I love optimizing complex systems.

Core Technical Competencies

Cloud Data Platforms & Big Data

Databricks (3+ years)
Microsoft Azure Cloud (Data Factory, Dataflows, Azure Functions)
Snowflake Administration & Development (SnowSQL, SnowPipe - 4+ years)
AWS RDS optimization
GCP BigQuery
Distributed architectures

ETL Development & Data Pipelines

ETL pipeline design and implementation (4+ years)
Apache Spark development and optimization
Python scripting for data processing (PySpark)
Linux scripting and command-line proficiency
Multi-source data integration
Apache Airflow workflow orchestration

AWS Services

Athena
S3
QuickSight
RDS
Lambda
CloudWatch
Glue

Data Storage Technologies

Apache Parquet
SQL databases
NoSQL databases
Data lakehouse patterns
Serverless architectures

Production Support & Operations

On-call production support rotations
Real-time monitoring and incident response
System performance analysis and optimization
Troubleshooting complex data pipeline issues
Documentation and SDLC best practices

Professional Experience

Data & AWS Cloud Engineer

Imperium, Tampa, FL (Remote)

February 2023 - Present

Architect and maintain cloud-based data analytics solutions including Snowflake environments, implementing RBAC best practices and user management protocols
Design and deploy ETL pipelines for multi-source data integration, reducing manual processing overhead by 60% through automation-first approach
Conduct comprehensive database performance analysis and optimization, improving query response times and system efficiency by 40%
Lead cross-functional collaboration with Executive, Product, and Data teams to resolve complex technical issues and implement data architecture improvements
Create and maintain data infrastructure including schemas, tables, views, pipes, streams, and automated tasks
Develop monitoring and reporting solutions for database performance tracking and optimization identification
Mentor and train team members on database administration best practices and advanced analytical methodologies

Derivatives + Alternative Investments

AG Wolf Capital, San Francisco, CA (Remote)

August 2012 - Present

Started a boutique signal service developing proprietary algorithmic signals for institutional and retail clients
Execute systematic futures strategies with funded capital using custom block trading system developed on Quantower platform
Provide quantitative trading signals and alternative investment solutions to external capital allocators and CTAs
Built and optimized financial reporting databases for signal generation and client portfolio management
Developed complex SQL queries and database solutions for signal backtesting infrastructure and client reporting
Designed real-time database monitoring systems for signal performance tracking and portfolio analytics
Implemented comprehensive data validation processes for signal delivery and automated trading systems

Derivatives Trader

FC Stone-League Trading, Chicago, IL (Remote)

April 2019 - April 2023

Traded Nasdaq 100 Derivatives with institutional capital.
Achieved a low drawdown system with a 2.5 Sharpe Ratio trading on CME GLOBEX Platform via CTS TRADER.
Administered and optimized financial reporting databases, implementing performance tuning strategies that reduced report generation time by 30%
Developed complex SQL queries and database solutions for regulatory compliance and financial data analysis
Collaborated with compliance teams to ensure data governance and regulatory adherence for financial data handling
Designed and maintained database monitoring systems for real-time performance tracking
Conducted technical training sessions on database optimization and query development best practices
Implemented data validation processes and quality assurance protocols for financial reporting systems

SAP Database Analyst

Tarkett, Solon, Ohio (Remote)

March 2017 - March 2019

Managed enterprise SAP database ETL processes, implementing data profiling and quality improvement processes that increased accuracy by 25%
Experience with enterprise data integration from legacy mainframe systems
Implemented automated monitoring solutions for proactive database maintenance and optimization
Created comprehensive documentation and training materials following SDLC best practices
Collaborated with teams to troubleshoot and resolve complex database performance issues

GitHub Projects

Data--SQL Architecture

🔗 View Code

SQL + DATA

This repository demonstrates practical applications of SQL and Python for data analysis, visualization, and dashboard creation across different domains like banking, real estate, and salary data.

Python Airflow SQL

🔗 View Code

Snowflake Optimization Suite

This project is aimed at performing data analysis on transactions stored in a Snowflake database.

Snowflake Python SQL

🔗 View Code

AWS

Some projects include scalable data lake implementation using AWS Glue, S3, and Athena for analytics workloads.

AWS Glue S3

🔗 View Code

Quantitative

High-performance data processing pipelines, backtests and Quant Analysis tools.

Python SQL Yfinance

Get In Touch

I'm always interested in discussing new opportunities, innovative data solutions, and ETL development projects.

[email protected]