Learn Data Skills
Beta
Adrian Promediaz

Adrian Promediaz

Certified

Analytics Engineer

Studytube | Amsterdam

Technologies

My Portfolio Highlights

My New Course

Intermediate Python

My New Course

Intermediate Python

Dedicated and results-oriented Analytics Engineer/Data Scientist/Data Architect with seven years of comprehensive experience in SQL, Python, AWS, Docker, dbt, Git, data warehouses, Fivetran, and ETL/ELT methodologies. Throughout my career, I have demonstrated a keen ability to design, develop, and optimize data infrastructures, empowering organizations to derive meaningful insights and drive strategic decision-making. With a proven track record in crafting intuitive dashboards and generating actionable insights, I am committed to bridging the gap between complex data sets and business objectives. This commitment ensures optimal data utilization and drives organizational growth.

My Work

Take a look at my latest work.

course

Introduction to Functions in Python

course

Data Manipulation with pandas

course

Intermediate Python

course

Introduction to Functions in Python

My Certifications

These are the industry credentials that I’ve earned.

Data Scientist

Data Scientist

Other Certificates

Data Camp Python Developer

Data Camp Machine Learning Engineer

Data Camp Data Scientist

DataCamp Machine Learning Fundamentals with Python

DataCamp Statistics Fundamentals with Python

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to SQL
Intermediate SQL
Intermediate Python
Joining Data in SQL

My Work Experience

Where I've interned and worked during my career.

Studytube | Oct 2022 - Present

Analytics Engineer / Data Engineer

1. Design, develop, and maintain robust data pipelines and ETL/ELT processes utilizing Fivetran and Matillion for extracting raw data from multiple sources. 2. Collaborate with the DevOps team to manage EC2 instances supporting the ETL/ELT process, leveraging Docker for deploying packages in AWS, and customizing data extraction processes. 3. Transform raw data using dbt and load data from various sources into the centralized Snowflake data warehouse, ensuring data quality, integrity, and reliability. 4. Collaborate with cross-functional technical teams using GitHub and work with business stakeholders to comprehend business requirements, translate them into technical specifications, and implement scalable solutions to address analytics initiatives, providing comprehensive data documentation. 5. As the ORGADMIN of Snowflake, establish and maintain failover groups of Snowflake to facilitate migration across regions. Using dbt’s Jinja and Seeds to Reduce Code Duplication 6. Optimize and fine-tune database queries, Kimball data models, and workflows to enhance system performance, reduce Snowflake computing costs, minimize latency, and support real-time analytics and reporting requirements. 7. Implement data governance frameworks and best practices to ensure compliance with regulatory standards, data privacy policies, and security protocols across all data management processes and systems. 8. Develop and sustain data visualization tools and dashboards using platforms like Looker, Metabase, and other relevant tools, enabling stakeholders to easily interpret and derive insights from complex datasets.
Show More

HousingAnywhere | Oct 2021 - Sep 2022

Lead Business Analyst / Lead Data Analyst

1. Lead a team of business analysts, offering mentorship, guidance, and coaching to cultivate a collaborative and high-performing culture focused on achieving strategic business objectives and delivering impactful insights. 2. Define and prioritize the team's goals, objectives, and deliverables in alignment with the organization's overall business strategy and key performance indicators (KPIs), ensuring clear communication and accountability across all stakeholders. 3. Collaborate closely with cross-functional teams, including product management, engineering, marketing, and sales, to comprehend business requirements, define project scope, and translate complex business problems into actionable analytics solutions. 4. Maintain the team's agility by applying the Kanban framework. 5. Utilize dbt to create and update data models and GitHub to review code from other technical peers. 6. Set up technical and analytical tests and interviews to recruit the data analytics team. Collaborate with the M&A team to propose acquisition targets by benchmarking competitors' performance using. Similarweb and create valuation targets using the DCF methodology.

HousingAnywhere | Oct 2020 - Sep 2021

Senior Data Analyst / Senior Business Analyst

1. Lead the analysis of complex business problems, requirements, and processes, collaborating with stakeholders across various departments to define clear objectives, scope, and success criteria for analytics projects. 2. Utilize advanced tools such as ModeAnalytics, dbt, Mixpanel, GitHub, and Google Analytics to visualize and analyze large datasets, identifying key trends, patterns, and insights that drive strategic decision-making and business growth. 3. Create, monitor, and analyze regional and city profitability (Contribution Margins) and identify strategies to enhance profitability. 4. Benchmark the performance of the existing regional European market with potential regions in the Middle East and the US market. 5. Develop and maintain standardized reporting frameworks, data stacks (e.g., ModeAnalytics, Mixpanel, dbt, Snowflake, and Google Analytics), dashboards, and KPI metrics to monitor business performance, track key trends, and identify areas for optimization and improvement while ensuring data accuracy, consistency, and integrity. 6. Develop and maintain sophisticated predictive models, statistical analyses, and forecasting methodologies to support booking forecasting, demand prediction, pricing optimization, user segmentation, and other strategic initiatives, leveraging both structured and unstructured data sources. 7. Design and implement comprehensive reporting solutions, dashboards, and performance metrics to monitor key business metrics, track operational performance, and provide actionable insights to senior management and key stakeholders. 8. Support the evaluation of acquisition targets and the definition of valuation targets using DCF methodology.

HousingAnywhere | Apr 2018 - Sep 2020

Business Intelligence Analyst

1. Create the query in dbt and visualize it in ModeAnalytics to display the KPIs for multiple departments. 2. Automate the creation of financial reports, including P&L and Balance sheet, for the finance team. 3. Conduct analytical research to identify bottlenecks in the conversion funnel. 4. Utilize the BeautifulSoup Python library to scrape data for performance benchmarking with competitors. 5. Utilize the Prophet library to develop and maintain sophisticated predictive models, statistical analyses, and forecasting methodologies supporting booking forecasting, demand prediction, pricing optimization, user segmentation, and other strategic initiatives, leveraging both structured and unstructured data sources.

HousingAnywhere.com | Sep 2017 - Feb 2018

Data Scientist Intern

Translating plenty of data into actionable product improvements. The main task includes mining the data and cleaning data using SQL. Furthermore, the data are analyzed using R & Python.

Baker Hughes | Aug 2014 - Feb 2015

Wireline Field Specialist 3

Dealing with Cased Hole Operations in Offshore: Perforation, Cement evaluation (SBT), Setting Plug, Reservoir Performance Monitor (RPM), Jet Cutter, and Pressure Contained Equipment.

Schlumberger | Aug 2012 - Aug 2014

Wireline Field Engineer

Responsible with operation in field dealing with open hole tool : Porosity, Resistivity, & Lithology, Density tool (Triple Combo, PEX-HALS, PEX- DLT), Pressure Test (RFT, XPT, MDT), Core Sampling (CST), Petrophysic Evaluation (Sonic Scanner) Familiar with Cased Hole Operation : Perforation & Setting Plug, Reservoir Monitoring (RST), Pipe Recovery (GPPT, Jet Cutter, Tubing Puncher, Back Off), Casing & Cement Evaluation (USIT, SCMT & CBL), Cased Hole Resistivity (CHFR), Pressure & Temperature, Pressure Equipment.

OGRINDO | Sep 2011 - Jun 2012

CO2 Assistant Researcher

Assisting Researcher of CO2 flooding project Research title = "CO2 sequestration in aquifer"

Weatherford | Jun 2011 - Aug 2011

Internship M/LWD

manager

My Education

Take a look at my formal education

Master's degree, Management of TechnologyDelft University of Technology | 2017
Bachelor of Science (B.S.), Petroleum EngineeringInstitut Teknologi Bandung | 2012
Senior High School, ScienceCanisius College (Kolese Kanisius) | 2008
Junior High School, GeneralCanisius College Jakarta | 2005
Elementary School, GeneralMarsudirini | 2002

About Me

Adrian Promediaz

Dedicated and results-oriented Analytics Engineer with seven years of comprehensive experience in SQL, Python, AWS, Docker, dbt, Git, data warehouses, Fivetran, and ETL/ELT methodologies. I'm looking for opportunities in Data Science area

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free