Ramon P.

Ramon P.

Senior Software Engineer

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.

Work history

UpStack
UpStack
Senior Software Engineer
2019 - Present (5 years)
Remote
  • Create and develop innovative software solutions for clients across a broad range of industries.

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.

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.

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.

Portfolio

Lead Engineer/Airflow migration
Lead Engineer/Airflow migration

Created new Airflow environment for our ETL pipelines with continuous, automated deployment using puppet, and a testing environment using docker. Automated the ETL pipeline creation for our most commonly used patterns. The user drops his query/ddl/ingSpec in the folder and a pipeline is generated. Monitoring and maintenance became much more sustainable allowing our team to spend more time actually adding value instead of fire fighting. Launched and now is the preferred home for our ETL processes. Currently used by our whole data engineering team. Technologies Used: Python, MySQL, Hive, Druid, Puppet, Docker, Linux

Lead Engineer/Kappa Architecture
Lead Engineer/Kappa Architecture

Built data infrastructure in the cloud to allow real time data ingestion into the warehouse, data models and visualization dashboards. Created monitoring dashboards and alerts to keep track of usage and resources. Being able to do analysis real time has been very helpful to better understand users at these early stage. Also, it provides an easy and accurate way to monitor the usage of third party API’s. Launched (Beta) currently only open to a small audience but should have no difficulties scaling. Technologies Used: Python, Apache Beam, Graph DB, BigQuery, Pub/Sub,DataFlow, Cloud functions, Linux

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

Automated communication via cloud functions with our DB and the Plaid API to keep bank account/transaction information synched for all users. Pretty much eliminated the need to make client side calls to fetch new data, decreasing latency and improving user experience. Launched (Beta) currently only open to a small audience but should have no difficulties scaling. Technologies Used: Python, Graph DB (Firestore), REST, DataFlow, Cloud functions, Linux, Flask

Lead Engineer/Revenue Dashboard
Lead Engineer/Revenue Dashboard

Built complex business login into ETL process to provide near real time insight into the revenue of the company as a whole and by offices. Provided an easy and straight forward way to detect anomalies and discrepancies in the data that could impact the health of the company. The dashboard is currently used across the company and by the CEO and COO. Technologies Used: Python, MySQL, Tableau, SuperX, Airflow, Linux

Education

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