Ramon P.

Ramon P.

Louisville, Colorado, United States of America
Hire Ramon P. Hire Ramon P. Hire Ramon P.

About Me

I am a Data Engineer with 4+ years proven SQL experience, passionate about building innovative predictive analytics and data science solutions. Coming from a technical background with 5+ years expertise in Python programming, allows me to research unknown domains as well as learn cutting-edge technologies effectively. Most importantly, I am a team player with a bias for action and a strong drive to keep learning. Right now I’m also fascinated by Reinforcement learning, Blockchain and their significance for the future.

AI, ML & LLM

Machine Learning Airflow

Database

SQL

DevOps

GCP

Workflow

Git

Other

Python Pandas Spark

Work history

UpStack
UpStack
Senior Software Engineer
2019 - Present (6 years)
Remote

  • Create and develop innovative software solutions for clients across a broad range of industries.

PythonSQLAirflowSparkGCPPandasMachine Learning
Elvira Finance
Data Engineer/Data Architect
2018 - 2019 (1 year)
Remote

  • Built Kappa architecture, allowing real-time streaming into BigQuery and ML Engine.

  • Created the backend for iOS app using Firestore and cloud functions to ease transition into other platforms.

  • Developing API communications to feed app functionality and data models.

PythonSQLPandasMachine LearningGCP
SpotX
SpotX
Data Engineer
2018 - 2019 (1 year)
Broomfield, CO, USA

  • Developed an Airflow environment and CD pipeline and migrated our pipelines to it, greatly improving ETL monitoring and maintenance. Automated ETL pipeline creation in Airflow, making time spent on new pipelines almost negligible.

  • Automated the creation and delivery of I&A fee reports to all our clients, with a 98% success delivery rate.

  • Created automated, real-time dashboard for advertisers to see ad and publisher performance and significantly increasing data transparency.

PythonSQLAirflowPandasSparkGit
L3 Technologies
L3 Technologies
Stress Engineer
2016 - 2017 (1 year)
Dallas, TX, USA

  • Analyzed stress capabilities of aircraft structures, also created a search app to find similar reports using Excel/VBA.

  • Developed a regression model to calculate fatigue concentrations on variable aluminum type parts.

  • Coordinated with design team to deliver 90% of our substantiations on time.

PythonSQLExcel VBA

Showcase

Lead Engineer/Airflow migration
Lead Engineer/Airflow migration

  • Created a new Airflow environment for ETL pipelines with continuous, automated deployment using Puppet.

  • Implemented a testing environment using Docker for the ETL pipeline creation process.

  • Automated the creation of ETL pipelines for frequently used patterns, improving team efficiency and allowing for more value-adding work.

Lead Engineer/Kappa Architecture
Lead Engineer/Kappa Architecture

  • Developed a cloud-based data infrastructure for real-time data ingestion into a warehouse.

  • Created monitoring dashboards and alerts to track usage and resources.

  • Provides real-time analysis capabilities to better understand user behavior, particularly regarding third-party API usage.

Lead Engineer/Plaid API Communiation
Lead Engineer/Plaid API Communiation

  • Automated bank account/transaction data synchronization via cloud functions, Plaid API, and DB.

  • Eliminates client-side data fetching, reducing latency and improving user experience.

  • Designed for scalability and should be easily expanded to a wider audience.

Lead Engineer/Revenue Dashboard
Lead Engineer/Revenue Dashboard

  • Developed a complex business login system for an ETL process to provide near real-time revenue insights across the company.

  • Implemented a dashboard for anomaly detection and discrepancy analysis in the company's data.

  • Utilized technologies including Python, MySQL, Tableau, SuperX, Airflow, and Linux.

Education

Education
Bachelor of Science (B.S.) Civil Engineering
The University of Texas at Austin
2012 - 2016 (4 years)