ROBIYAHON AZAMOVA
PANAMA CITY,FL
Summary
Senior Data Engineer with 7+ years of experience in the field, with a deep understanding and extensive knowledge of SQL reporting, Business Intelligence, and Data Engineering. My expertise lies in designing and optimizing ETL solutions, leveraging tools such as SSIS, Azure Data Factory (ADF), Synapse Pipelines, Databricks, Logic Apps, and Function Apps to deliver efficient and scalable data integration and transformation processes. Excel in environments that require strong time-management and excellent interpersonal and communication skills. Proficient in multiple programming languages, including SQL, Python, PYSPARK, and PowerShell. This linguistic agility enables me to tackle complex data engineering challenges, with a strong background in data modeling and visualizations. This blend of technical expertise, coupled with my strong team collaboration and project management abilities, makes me an asset to any organization aiming to leverage data for strategic advantage.
Overview
8
8
years of professional experience
Work History
Senior Data Engineer
BOOZ ALLEN HAMILTON
PANAMA CITY, FL
09.2022 - Current
- Worked jointly with stakeholders to conceptualize and deliver scalable and reliable architectural solutions for the Optum Public Cloud Initiative
- This involved staying updated with the latest technologies and best practices, as well as coordinating with other technical teams for optimal system integration and performance
- Employed Terraform for creating and implementing Azure resources, focusing on enhancing performance, security, and cost-effectiveness of the company's infrastructure
- Led the creation and execution of a unified framework for data ingestion and transformation within Azure, covering RDBMS and flat files
- Also managed data transfers from On-prem to Azure, adhering to enterprise security protocols and collaborating with stakeholders to establish data quality and validation procedures
- Utilized Data-frame API, Scala API, Python, and Spark SQL for data ingestion into Azure SQL and NoSQL databases, including Azure SQL DB, PostgreSQL, MySQL, Cassandra, and Cosmos DB
- Participated in constructing pipelines in Azure’s cloud environment, using various services such as Data Lake, Blob Storage, Data Factory, and others
- Developed ETL data pipelines from various source systems to Azure Data Storage services using Azure Data Factory, Spark SQL, and Azure Data Lake Analytics
- Provided integration solutions for Azure Data Lake Analytics, Storage, Data Factory, SQL databases, and SQL Data Warehouse
- Created Azure Data Factory pipelines with Linked Services, Datasets, and Pipelines for data extraction, transformation, and loading from various sources
- Applied data modeling methodologies for designing Conceptual, Logical, and Physical Data models
- Automated Dynamic Snowflake queries using dbt, git, and Azure DevOps for CI/CD
- Extensively developed Azure Data Factory (ADF) for data ingestion from various sources to meet business needs
- Built Streaming pipelines with Azure Event Hubs and Stream Analytics for real-time data analysis
- Developed Databricks ETL pipelines using notebooks, Spark Data-frames, SPARK SQL, and Python scripting
- Managed one-time data migration from SQL server to Snowflake
- Designed custom input adapters with Spark, Hive, and Sqoop for data ingestion and analysis from Snowflake, MS SQL, and MongoDB into HDFS
- Worked with report analysts and Epic build teams to resolve discrepancies
- Implemented an automated Azure cloud process for daily data ingestion from web services into Azure SQL DB
- Performed ETL operations in Azure Databricks, connecting to various database systems using JDBC connectors
- Analyzed data directly in its environment by mounting Azure Data Lake and Blob to Databricks
- Developed custom alerts using Azure Data Factory, SQLDB, and Logic App
- Created interactive business reports for key data insights
- Maintained, validated, and developed Power BI reports
- Built and published interactive dashboards using Power BI Server, set dataset refresh schedules, and utilized various DAX functions for data visualization
- Used Power BI Gateway for dashboard and report updates with on-premises data
- Applied Dimensional Modeling techniques, including Star and Snowflake Schemas, during the logical modeling phase
- Orchestrated the complete development of Azure Data Factory (ADF) pipelines, incorporating various nested copy and transformation activities for efficient data management
- Initiated the architectural and design processes for data ingestion, processing, and warehousing strategies, focusing on Business Intelligence needs using Dimensional Models
- Successfully led the Data Lake project, creating a solid framework for future data integration into Azure Data Lake and Data Bricks
- Authored PowerShell scripts for initiating, deploying, and monitoring ADF pipelines through the command-line interface and Azure ARM templates
- Integrated Azure Logic App with Data Factory pipelines for improved monitoring and notification services, boosting pipeline efficiency and responsiveness
- Incorporated Azure Key Vault to enhance data security practices and securely transfer connection strings within the Data Pipeline
- Designed and architected Power BI Data Models and Reports to meet business user requirements
- Created and published multiple Power BI reports with time intelligence features, including complex DAX measures and tabular reports for time-based analysis.
Data Analytics Engineer
Johnson & Johnson
TAMPA, FL
04.2016 - 09.2022
- Worked in tandem with BI developers, converting functional requirements into technical specifications
- Conducted detailed business requirement gathering and documentation, transforming these into thorough Business Requirement Documents (BRD)
- Utilized a variety of tools such as Test Cases, Prototypes, Network diagrams, and UML (E-R Diagrams) for system integration and software project execution
- Facilitated in-depth customer feedback discussions to identify service improvement opportunities
- Implemented Microsoft cloud technologies like Azure Data Factory, Azure Data Lake, Azure Synapse, Azure Kusto, Logic Apps, Key Vault, and Azure SQL
- Built efficient data pipelines using Azure Data Factory (ADF) to ensure smooth data transfer into Azure Data Lake, Azure SQL Database, and Azure SQL Data Warehouse
- Performed Dimensional Modelling using Star and Snowflake Schemas, identifying Facts and Dimensions, and engaged in both physical and logical data modeling using tools like Erwin and ER-Studio
- Developed scalable data ingestion pipelines in Azure Data Factory, sourcing data from SQL databases, CSV files, and REST APIs
- Crafted data processing workflows in Azure Databricks, employing Spark for distributed data processing and transformation
- Maintained data quality and integrity through validation, cleansing, and transformation processes using Azure Data Factory and Databricks
- Designed and deployed a cloud-based data warehouse solution on Snowflake in Azure, leveraging its scalability and performance features
- Optimized Snowflake schemas, tables, and views for effective data storage and retrieval, supporting analytics and reporting
- Worked with data analysts and business stakeholders to deliver suitable data models and structures in Snowflake
- Utilized Azure Synapse Analytics for integrating big data processing and analytics, facilitating data exploration and insight discovery
- Implemented data governance and thorough data quality checks with Azure Data Factory and Snowflake to ensure data accuracy and consistency
- Configured event-based triggers and schedules in Azure Data Factory for automating data pipelines and workflows
- Designed ADF and SSIS ETL data pipelines, enabling smooth data transfer to Data Warehouses and Data Marts
- Led the complete development of Power BI Reports, using tabular models and conducting time series analysis with DAX expressions
- Adapted visualizations based on client feedback, managed Power BI report hierarchies, and oversaw Power BI dashboard management
- Utilized SQL DDL and DML to create triggers, stored procedures, and perform data manipulations
- Conducted Performance tuning in MS SQL server development using tools like SQL Profiler and Performance SQL scripts, focusing on optimizing stored procedures, triggers, functions, transactions, indices, and statistics Query Optimizer
- Managed both logical and physical database design, including data modeling, maintenance, problem diagnosis, and resolution
- Ensured effective communication of process results to various user communities
- Performed extensive data testing, cleansing, and standardization to align with business standards, using Fuzzy/exact lookups in SSIS tasks
- Showcased expertise in SSAS storage and partitions, aggregations, MDX query calculations, Data Mining Models, and developed reports using MDX and SQL
- Participated in analyzing, designing, constructing, and testing OLAP cubes with SSAS, including adding MDX calculations
- Key contributor in designing new reports, creating technical documentation, requirement gathering, data analysis, and building SSRS reports and dashboards for over 20 client companies
- Created Ad-hoc SSRS Dashboards based on user specifications
- Produced a variety of reports such as tabular, matrix, lists, charts, parameterized, sub-reports, Ad-hoc, drill-down reports, etc., tailored to specific business needs within strict deadlines
- Developed complex reports featuring sub-reports, graphical elements, multiple groupings, drilldowns, parameter-driven elements, formulas, summaries, and conditional formatting using SSRS and Tableau.
Skills
- Areas: Extensive knowledge of SQL reporting, Business Intelligence and Data Engineering
- ETL: SSIS, ADF, Synapse Pipelines, Databricks, Logic Apps, Function Apps
- Data Modeling: SQL Server, Skilled in writing T-SQL scripts and designing databases
- DBMS: SQL Server, Oracle, IBM DB2, MySQL, Redshift, Synapse Pools, AWS RDS, Azure SQL DB
Language: SQL, Python, PYSPARK, PowerShell
- Data Modeling Tools: Lucid Chart, Drawio, Erwin
- Data Visualization Tools: Tableau, PowerBI
Languages
English
Native/ Bilingual
Uzbek
Native/ Bilingual
Timeline
Senior Data Engineer
BOOZ ALLEN HAMILTON
09.2022 - Current
Data Analytics Engineer
Johnson & Johnson
04.2016 - 09.2022
Similar Profiles
Randy BrownRandy Brown
Physical and Personnel Specialist at Booz Allen HamiltonPhysical and Personnel Specialist at Booz Allen Hamilton
Kimberly GrayKimberly Gray
Senior Executive Administrative Assistant at Booz Allen HamiltonSenior Executive Administrative Assistant at Booz Allen Hamilton
Charles ProctorCharles Proctor
Logistics Analyst / Project Manager at Booz Allen HamiltonLogistics Analyst / Project Manager at Booz Allen Hamilton
Averi FetrowAveri Fetrow
Senior Consultant at Booz Allen Hamilton, Inc.Senior Consultant at Booz Allen Hamilton, Inc.
Melany CreelMelany Creel
Substitute Teacher at Bay District SchoolsSubstitute Teacher at Bay District Schools