BI engineer

ULUGBEK ASATULLAEV

+1-650-***-**** ****.******@*****.*** www.linkedin.com/in/uluggg

Authorized to work for any employer in United States

Professional Summary

Skilled Sr Database/BI engineer/ETL architect with 6+ years of experience in healthcare, social media and Entertainment industries.

-Proficient in building and optimizing ETL pipelines, advanced T-SQL/PL-SQL queries, and developing comprehensive reporting solutions using Power BI, Tableau, SSRS, and SSAS.

-Adept at data modeling, performance tuning, and managing large-scale datasets for real-time analytics. –

-Expertise in leveraging Informatica, Talend, SSIS, Python, and cloud platforms (Azure blub, Azure Data Factory, AWS) to deliver scalable data solutions that enable automated workflows, real-time insights, and strategic, data-driven decision-making.

- Proficient in Power BI with advanced skills in DAX, Power Query, and data modeling, effectively developing dynamic reports and dashboards that streamline data analysis and business decision-making processes.

- Expert in integrating Power BI with various data sources, optimizing performance, and implementing security protocols such as Row Level Security, enhancing data integrity and accessibility for diverse organizational needs.

-Experience in Data Warehousing and Business Intelligence applications in Financial and CPG domains.

-Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

-Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.

-Hands-on experience in Microsoft SQL Server database, SSMS, MSBI (SSIS, SSRS, SSAS) and Power BI.

-Deployed reports created report schedules and subscriptions. Managing and securing reports using SSRS.

-Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS).

-Experience in Extraction, Transformation and Loading (ETL) processes in SQL Server database, SQL Server 2012, 2015 and 2016 versions.

-Working with SQL server Job scheduling to execute Integration Services packages and send report to the management.

-Wrote stored procedures, functions and created indexes.

-Created different transformations for loading data into SQL database which includes (Derived column, Lookup, Data Conversion, Conditional Split, Merge, Merge Join, Union ALL).

-Proficient in Python for data analytics and ETL processes, expertly using libraries such as Pandas, NumPy, and PySpark to extract, transform, and load large datasets, facilitating insightful business intelligence solutions.

-Proficient in leveraging AWS cloud solutions for data storage and ETL processes, utilizing services like AWS S3, Redshift, Glue, and Lambda to build scalable data warehousing and real-time analytics platforms.

Work Experience

Tik Tok Los Angeles, CA

Sr ETL/BI engineer Jul 2022 - present 2024

-Developed complex SQL queries and stored procedures in Azure SQL, optimizing data retrieval and processing times to enhance backend operations for TikTok’s e-commerce analytics platform, resulting in a 60% improvement in processing efficiency.

-Led the integration of Kafka streams with Python scripts for real-time data streaming, handling over 2 million daily transactions. This setup improved data throughput and enriched user behavior analysis by automating data transformations and anomaly detection.

-Designed, implemented, and automated ETL processes using Python to handle data extraction, transformation, and loading across multiple Azure data services, enhancing workflow efficiency and data integrity.

-Developed dynamic Power BI dashboards to visualize critical KPIs, sales metrics, and trends, increasing decision-making efficiency by providing actionable insights into user engagement and product performance.

-Played a pivotal role in the full lifecycle management of BI solutions, from designing data models in Azure Data Warehouse to deploying and maintaining them, ensuring seamless integration with business intelligence strategies.

-Implemented best practices in database management using Azure SQL, including advanced indexing, query tuning, and partitioning strategies, which led to a 50% reduction in data load times and improved system responsiveness.

-Automated various backend processes using Python and Shell scripts, enhancing the security and efficiency of data exchanges between UNIX systems and network data movers (NDM).

-Engaged in continuous performance tuning and optimization of SQL databases and Oracle RDBMS using advanced planning and SQL tuning strategies, ensuring high performance and scalability.

-Led the adoption of new BI technologies and methodologies, particularly leveraging Azure and Power BI, to foster a culture of innovation within the data team.

-Provided mentorship and technical guidance to junior engineers and analysts, improving team competencies and project outcomes through targeted training and development initiatives, emphasizing best practices in Python, SQL, and BI tool usage.

Facebook (Ads team) Menlo Park, CA

BI/Database developer/ ETL architect Jun 2020 - Jul 2022

-Designed complex SQL queries on Microsoft SQL Server to optimize ad spend analysis, directly impacting the efficiency of $10M in monthly budgets

-Developed robust ETL pipelines with Informatica PowerCenter, leveraging its high-volume data integration capabilities to synchronize clickstream and sales data for campaign analysis

-Managed Snowflake data warehousing, utilizing its seamless scalability and real-time shared data capabilities to support extensive query operations

-Leveraged Apache Airflow to automate and orchestrate complex data workflows, significantly reducing manual intervention and enhancing pipeline reliability

-Transitioned to ELT with Snowflake for immediate data querying capabilities, improving real-time analytics for Facebook’s ad strategies

-Integrated machine learning with TensorFlow and PyTorch for predictive analytics in ad targeting, enhancing ROI through improved user engagement predictions

-Optimized Oracle Database and Microsoft SQL Server for data modeling, utilizing advanced features like partitioning and parallel execution to enhance query performance

-Directed data compliance and governance using DataRobot and Alteryx, ensuring adherence to international standards while maintaining data integrity

-Implemented rigorous data quality protocols using Talend and Informatica Data Quality, achieving and maintaining high accuracy levels in critical financial reports

-Conducted database performance tuning in SQL Server, utilizing its query optimization and indexing features to significantly reduce decision-making time

-Developed and maintained dynamic BI dashboards and reports using Tableau, Power BI, and Looker, providing actionable insights into campaign performance

- Employed Power BI's DAX for deep custom analytics, refining customer engagement insights.

-Established version control systems using Git and Subversion within Jenkins and GitLab CI/CD pipelines, enhancing development processes and deployment reliability

-Utilized Kubernetes to manage containerized ETL jobs, optimizing resource use and ensuring high availability during peak loads

-Authored detailed documentation on ETL architectures in Confluence, improving transparency and facilitating better team collaboration

-Employed Python and R for scripting data transformations and automations, streamlining preprocessing and ensuring consistent data quality

-Managed projects within the Ads team using JIRA, maintaining timelines and ensuring deliverables met Facebook’s standards for quality and performance

-Utilized Splunk for operational intelligence, conducting in-depth analyses to detect anomalies and optimize data systems' health and performance

NHS healthcare London, UK

Data Analyst /DBA Jan 2018 - Apr 2020

- Designed Power BI dashboards using DAX and Power Query, providing real-time insights into patient flow, improving hospital resource allocation by 15%

- Built and maintained ETL processes with SSIS and Talend, reducing data integration time by 30% and improving data availability

- Optimized T-SQL and PL/SQL queries in SQL Server and Oracle, cutting query run times by 40% for clinical and operational reports

- Developed predictive models in Python and R for patient admission forecasting, decreasing A&E congestion by 20%

- Implemented OLAP cubes in SSAS, enabling advanced multidimensional analysis, improving tracking of clinical outcomes by 10%

- Improved data integration using SSIS, ensuring seamless data flow between Epic, Meditech, and Allscripts, reducing discrepancies by 25%

- Performed SQL performance tuning on SQL Server and Oracle, enhancing query execution speeds by 35%

- Developed clinical reports with SSRS, automating the generation of key NHS reports for monitoring hospital resource allocation and patient outcomes

- Led ETL migrations to Azure SQL Data Warehouse, improving scalability and processing capacity for large healthcare datasets

- Optimized stored procedures and functions in T-SQL and PL/SQL, improving data retrieval efficiency by 30%

- Developed advanced data models using Snowflake and SQL Data Warehouse, optimizing data storage solutions and cutting costs by 15%

- Enhanced data visualization using Looker and QlikView, providing intuitive dashboards for non-technical users, which increased decision-making speed by 20%

SKILLS

Database Management: MySQL, PostgreSQL, NoSQL, Snowflake, PLSQL, SQL Enterprise Manager, Query Analyzer, SSAS, Microsoft Azure, SSMS

Data Warehousing: Data modeling, OLAP, OLTP, Star Schema, Snowflake Schema

Programming Languages: SQL, T-SQL, PL/SQL, Python, Java, C#, MDX, DAX, VB.NET, XML, ASP.NET, .NET Framework

ETL Tools: SSIS, Informatica, Talend, Apache NiFi, Alteryx, Airflow

Data Visualization & Reporting: Tableau, Power BI, SSRS, Matplotlib, QlikView, SAP BusinessObjects

Version Control & Collaboration: Git, GitHub, GitLab, Bitbucket, JIRA, Confluence

Operating Systems: Windows 2012/2008 R2/2003/2000 Server, Windows NT 4.0/3.5, Unix/Linux, macOS

Education

Ulster University London, UK

Bachelor's, Computer Science - (GPA 3.7)

Contact this candidate