Learn Data Skills
Beta
Feruz Urazaliev

Feruz Urazaliev

Data Engineer

Kearney | Des Plaines, IL

Technologies

My Portfolio Highlights

My New Project

When Was the Golden Age of Video Games?

My New Course

Introduction to Python

My New Track

SQL Fundamentals

Quantitative strategist, harnessing the power of data for strategic advantage.

My Work

Take a look at my latest work.

course

PostgreSQL Summary Stats and Window Functions

course

Data-Driven Decision Making in SQL

course

Time Series Analysis in SQL Server

track

SQL for Business Analysts

course

Data Communication Concepts

track

Understanding Data Topics

track

SQL Server for Database Administrators

track

SQL Server Developer

track

Data Analyst

DataCamp Course Completion

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

My Work Experience

Where I've interned and worked during my career.

Kearney | Oct 2019 - Present

Senior Data Engineer

- Worked with clients to understand their business requirements and designed solutions to meet their needs. Developed and maintained data governance policies and procedures to ensure data accuracy and consistency. Maintained and improved data security and compliance requirements for clients, ensuring data privacy and protection. - Worked with business users to understand their data needs and developed custom solutions to meet those needs. Designed and implemented data models to support reporting requirements, utilizing best practices for data architecture. - Designed and developed complex data pipelines using Databricks and Spark technology for clients in the healthcare, finance, and retail industries. Built and optimized ETL processes to ingest and transform data from different sources, such as SQL Server and Hadoop. - Mentored junior developers and provided guidance on best practices and techniques for effective big data development. - Designed and developed Snowflake data warehouses for clients, including schema design, loading data, and optimizing query performance. - Developed ETL pipelines using ADF to extract, transform, and load data from various sources into Snowflake. - Created data models using Erwin and Lucid chart to visualize data structures and ensure data integrity. - Conducted performance tuning of Snowflake data warehouses, optimizing query execution time by up to 40%. - Tuned Spark jobs to improve performance and scalability, including optimizing Spark configurations and partitioning data for parallel processing. Deployed and managed Spark clusters on cloud platforms such as Microsoft Azure and AWS. - Designed and developed ETL processes using SSIS, ADF, Synapse Pipelines, Databricks, Logic Apps, Function Apps to move data from various sources to a centralized data warehouse. - Worked closely with business users to gather and analyze their requirements for data reporting and provided solutions to meet their needs.
Show More

PepsiCo | Feb 2014 - Sep 2019

Data Engineer

- Collaborated with business users to understand their reporting needs and developed custom dashboards to meet those needs. Designed and implemented data models to support reporting requirements, utilizing best practices for data architecture. - Created and optimized T-SQL queries, stored procedures, and functions to retrieve and manipulate data for reporting purposes. - Worked with a healthcare client to build a data warehouse solution using Databricks, Spark, and Hive, which improved data processing and analytics capabilities. - Collaborated with data scientists to implement machine learning models using Spark and Databricks, which improved customer targeting and increased revenue for a marketing client. - Developed and maintained ETL processes for various clients using Databricks, Python, and PYSPARK, ensuring data accuracy and consistency. - Created executive dashboards for a finance client, providing key financial metrics and insights. - Designed and developed complex dashboards and reports for clients in the healthcare industry, showcasing patient data and analytics. - Worked on designing, developing, and implementing ETL processes using SSIS, ADF, Synapse Pipelines, Databricks, Logic Apps, Function Apps to move data from various sources to a centralized data warehouse. - Designed and developed SQL Server databases, including writing T-SQL scripts and developing database objects. - Worked on testing and reviewing code for reports and ETL processes via Git Hub and Azure DevOps. - Collaborated with business users to gather and analyze their requirements for data reporting and provided solutions to meet their needs. - Utilized data modeling tools such as Lucid Chart, Draw.io, and Erwin to design and optimize data models for various databases. - Developed ETL processes for moving data from on-prem SQL servers to Azure SQL PAAS and Azure Synapse SQL Pools using Azure Data Factory.

My Education

Take a look at my formal education

BS in Economics with FinanceWIUT

About Me

Feruz Urazaliev

Nevermind

Powered by

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