Rasulbek Makhmud Azure Operations Support/Big Data Specialist

Azure Operations Support/Big Data Specialist

Molina Healthcare

Mar 2023 - Current (3 years 6 months)

• Daily monitoring activities for Production Autosys job runs and Databricks workflows. • Daily SLA Trend updates as well as issue tracking. • Obtain SLA details and DQ status to compose daily reports to inform Users and Molina stakeholders of data stability and accuracy. • Maintain and update the incident tracker if any new business incidents get created. • Investigate failures, DQ issues, and resolve open incidents while collaborating with other teams (Hadoop Admins, Bas Team, Development Team…) • Jira bug creation to address data quality issues fixable through help of the Development team. • Optimization load runs for Production and UAT jobs to improve project performance. • Mitigate sunk costs by freeing up extra storage space through v

Senior Data Engineer

AmerisourceBergen

Sep 2021 - Feb 2023 (1 year 6 months)

• Azure Data Factory (ADF), Integration Run Time (IR), File System Data Ingestion, Relational Data Ingestion • Migration of on-premise data (SQL Server) to Azure Data Lake Store (ADLS) using Azure Data Factory (ADF V2). • Configured Azure platform for data pipelines, ADF, Azure blob storage and data lakes, and built workflows to automate data flow using ADF. • Combined structured, unstructured and semi-structured data (log files, and media) using Azure Data Factory to Azure Blob Storage. • Build operational reports and analytical dashboards on top of Azure Data Warehouse to derive insights from the data using Power BI together with Azure Analysis Services. • Used Azure Data Factory pipelines to pull data from variety of semi-structured data

Senior Business Intelligence Developer

DB Best Technologies

Feb 2020 - Aug 2021 (1 year 7 months)

• Actively participated in migration of on-premise SQL Server schemas to cloud on Azure SQL Server DB and Azure VM and developed and maintained databases across both on-premise and cloud deployments. • Designed SSIS packages and Azure Data Factory pipelines to Extract, Transfer and Load (ETL) existing data into Data Warehouse from different source environments such as ERP, CRM, Azure, AWS, and other systems. • Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures. • Created Alerts, Notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors and security violation. • Implemented Data Cleansing, Incremental Data Loading, Logging, Event Handling

Senior Business Intelligence Developer

GODIVA CHOCOLATIER

Jan 2018 - Feb 2020 (2 years 2 months)

• Built efficient ETL packages, using both SSIS and Azure Data Factory ADF2 pipelines for processing Fact and Dimension tables with complex transforms and SCD type 1/ type 2 changes. • Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database. • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task. • Designed reports on account information, research reports using ad-hoc reporting to be used by clients and advisors. • Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to

SQL/BI Developer

TDK

Jan 2015 - Dec 2017 (3 years)

• Developed database objects like tables, stored procedures, triggers, user defined data types and functions. Created and updated clustered and non-clustered indexes to keep up the SQL Server performance. Implemented Error handling through TRY-CATCH method and used CTEs. Responsibilities included fine-tuning the SQL Server to achieve best performance. • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance. • Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages. Published SSRS reports in Report Manager, SharePoint web pages and in custom made ASP.NET web applications. • Performed SSIS Development and support, developed ETL solutions f

ETL Developer

State Farm

Jun 2013 - Jan 2015 (1 year 8 months)

• Configuring tuning and optimizing T- SQL. Responsible for performing basic developer task like creating, altering and updating tables. Developed simple stored procedures, queries, views, joins and indexes by using T-SQL. • Normalized the tables and maintained Integrity by using Primary and Foreign Keys. • Performed SSIS Development and support, developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File, and DB2 into the data warehouse. • Created, maintained and updated ETL packages loading both OLTP and OLAP database tables. • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load. Created packages

Rasulbek Makhmud

About

Detail

Timeline

Résumé