David Zajac
Data Engineer at Fama Technologies Inc.- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Spanish Full professional proficiency
-
Portuguese Limited working proficiency
Topline Score
Bio
Credentials
-
Amazon Web Services Solutions Architect Associate
Amazon Web Services (AWS)Mar, 2022- Sep, 2024
Experience
-
Fama Technologies Inc.
-
United States
-
Software Development
-
1 - 100 Employee
-
Data Engineer
-
Sep 2022 - Present
Data Engineer and Solutions Architect building robust ETL Pipelines and Cloud Infrastructure. Data Engineer and Solutions Architect building robust ETL Pipelines and Cloud Infrastructure.
-
-
-
Zillacode
-
United Kingdom
-
Graphic Design
-
1 - 100 Employee
-
Founder
-
Nov 2022 - Present
The ultimate resource to become a modern Data Engineer. Used by thousands of Data Engineers and students to practice for coding interviews. The only platform with Snowflake/DBT, PySpark, Spark and Pandas live coding questions. The ultimate resource to become a modern Data Engineer. Used by thousands of Data Engineers and students to practice for coding interviews. The only platform with Snowflake/DBT, PySpark, Spark and Pandas live coding questions.
-
-
-
Wrench.AI
-
United States
-
Software Development
-
1 - 100 Employee
-
Data Engineer
-
Oct 2021 - Sep 2022
- Created several ELT Pipelines using DBT and data ingested via FiveTran - Established networking and permissions for Jenkins server to deploy AWS infrastructure across multiple accounts - Integrated a Lambda based REST API with Stripe API to programmatically bill customer based on usage - Created template repo that allows for Fargate tasks and Lambda Functions to use to the Python file - Created Database, Browser and API tests using Robot Framework and integrated with Jenkins - Created SQL triggers to programmatically populate populate other tables - Debugged many existing PySpark Glue jobs and optimized joins and replacing UDFs with native Spark functions - Used CloudFormation in tandem with Makefiles to deploy various AWS resources smoothly across accounts - Created API Gateway endpoints leading to Lambda Functions and a Flask app Show less
-
-
-
Self Employed
-
Real Estate
-
1 - 100 Employee
-
Data Engineering Contractor
-
Jun 2021 - Oct 2021
- 100% Job Success Score, only 5-star client reviews on Upwork.com profile - Created several ETL pipelines pulling from APIs and webscraped data deployed on AWS infrastructure - Created an automatic forecasting software using Pandas, Matplotlib and SciPy - 100% Job Success Score, only 5-star client reviews on Upwork.com profile - Created several ETL pipelines pulling from APIs and webscraped data deployed on AWS infrastructure - Created an automatic forecasting software using Pandas, Matplotlib and SciPy
-
-
-
-
Owner/Operator
-
Jul 2020 - Apr 2021
- Completed a variety of Webscrapes to obtain sales leads and industry data using Python - Used Python Pandas library to analyze production costs and customer data to redo pricing scheme - Connected PowerBI to Access database to create real-time financial dashboards - Automated landline sales call downloading using Selenium Python library - Used Quickbooks Online to bring billing and payroll completely digital - Completed a variety of Webscrapes to obtain sales leads and industry data using Python - Used Python Pandas library to analyze production costs and customer data to redo pricing scheme - Connected PowerBI to Access database to create real-time financial dashboards - Automated landline sales call downloading using Selenium Python library - Used Quickbooks Online to bring billing and payroll completely digital
-
-
-
CrownQuest Operating, LLC
-
United States
-
Oil and Gas
-
100 - 200 Employee
-
Lease Manager
-
Jun 2019 - Jun 2020
- Oversaw all field production operations for 15 facilities each containing about 5 wells - Used Python and VBA to automate various Excel spreadsheets - Automated production data downloading using Selenium Python library - Optimized pumping units, gas lift systems, ESPs and plunger lift systems using various oilfield softwares - Oversaw all field production operations for 15 facilities each containing about 5 wells - Used Python and VBA to automate various Excel spreadsheets - Automated production data downloading using Selenium Python library - Optimized pumping units, gas lift systems, ESPs and plunger lift systems using various oilfield softwares
-
-
-
Denbury Resources Inc.
-
United States
-
Oil and Gas
-
1 - 100 Employee
-
Operations Engineering Intern
-
May 2018 - Aug 2018
- Analyzed production data for 158 conventional wells for potential workover opportunities - Forecasted production declines and estimated operation costs using Excel and Python - Visualized data using PowerBI and Excel and presented results to executive management - Analyzed production data for 158 conventional wells for potential workover opportunities - Forecasted production declines and estimated operation costs using Excel and Python - Visualized data using PowerBI and Excel and presented results to executive management
-
-
-
-
Field Engineering Intern
-
May 2017 - Aug 2017
- Designed and implemented a procedure for on-site drilling personnel to increase rate of penetration and prevent operational issues such as bit balling, stick-slip and whirl, by minimizing mechanical specific energy - Created a Microsoft Excel spreadsheet to identify where open-hole problems such as cuttings settling and washout could occur in the wellbore, using drilled cuttings volume - Designed and implemented a procedure for on-site drilling personnel to increase rate of penetration and prevent operational issues such as bit balling, stick-slip and whirl, by minimizing mechanical specific energy - Created a Microsoft Excel spreadsheet to identify where open-hole problems such as cuttings settling and washout could occur in the wellbore, using drilled cuttings volume
-
-
Education
-
Colorado School of Mines
Bachelor of Science - BS, Petroleum Engineering, minor in Economics -
Culver Academies
Community
