Isroil Urunov
Sacramento,CA
Summary
Business Intelligence (BI) specialist and Data Engineer with over 8+ years of data warehouse architecture and data management experience, seeking a challenging position in the Data Warehouse/BI, Data Lakes, OTLP, and OLAP environments. ETL design and development, testing, deployment, and documentation, managing information ranging from Finance, Accounting, HR, Supply-Chain, Operations, Sales, Marketing to E-Commerce business domains. Data Engineering and Reporting using BI applications such as SQL Server, Azure Data Factory, Databricks, Azure Synapse, SSIS, Azure Logic App, Function App, Azure Data Lake, CICD pipelines, Power BI, SSRS, Tableau, and many others.
Overview
8
8
years of professional experience
Work History
SQL/SSIS/ETL/Power BI/Azure Developer Engineer
CALIBER HOME LOANS
01.2023 - Current
- Managed all SQL documentation, including installation guides and data conversion procedures.
- Developed SSIS packages for populating Data Warehouses using tasks like Execute SQL Task, data flow task, and file system task.
- Designed SSIS packages to extract data from diverse sources such as flat files and Excel spreadsheets and load it into SQL Server.
- Utilized various SSIS tools like Data Flow Task, Execute SQL Task, Script Task to achieve desired outcomes within set deadlines.
- Retrieved data from multiple sources and stored it in an intermediate Staging Database using the SSIS ETL tool.
- Created SSIS (ETL) packages to validate, extract, transform, and load data from OLTP systems and the Staging Database to the Data Warehouse.
- Created dynamic visuals using features like Bookmarks, Slicers, and custom tooltips in Power BI. Published and shared Power BI reports and data models in Power BI workspaces.
- Architected scalable data solutions on Azure using services like Azure Data Factory and Azure Synapse Analytics.
- Built and maintained strong relationships with Microsoft Azure support teams, ensuring access to timely assistance when required.
SQl/SSIS/ETL/Power BI/Azure Engineer
KIMBERLY-CLARK
06.2019 - 12.2022
- · Assisted in the development and maintenance of ETL pipelines using SSIS to integrate sales data from CRM systems into SQL Server databases.
- Participated in the optimization of ETL processes to enhance data processing efficiency and reduce data latency.
- · Developed, maintained, and updated SSIS and ADF ETL processes for loading tables in both OLTP and OLAP databases.
- · Created dynamic visuals using features like Bookmarks, Slicers, and custom tooltips in Power BI. Published and shared Power BI reports and data models in Power BI workspaces.
- Evaluated emerging technologies related to Microsoft Azure services to identify areas for future growth or improvement initiatives within the organization''s IT landscape.
- Conducted regular reviews of system logs and performance metrics to identify trends or anomalies that may signal areas for improvement in the Azure environment.
- Created, updated and maintained Azure security standards and best practices across Azure domain.
- Developed and implemented security measures for Azure environments, ensuring data protection and compliance with industry regulations.
SQL/SSIS/ETL/Power BI/Azure Developer
Kaiser Permanente
10.2017 - 05.2019
- Designed and implemented ETL pipelines using SSIS and Apache NiFi to integrate patient data from various healthcare systems into a centralized Azure-based data warehouse.
- · Optimized SQL Server (SSMS) queries to improve the performance of clinical data reporting and analytics.
- ● Used SSIS packages to perform ETL operations, moving data from MYSQL (RDBMS) data warehouses to SQL Server databases while ensuring data integrity with primary keys, indexes, and eliminating duplicates.
- ● Developed SSIS Packages to integrate data from diverse sources such as Excel, CSV, flat files, and text-formatted data using OLE DB connections. Used various SSIS transformations like Merge, Conditional Split, Union All, Script Task, OLE DB Command, Data Conversion, Lookup, and others.
- · Created dynamic visuals using features like Bookmarks, Slicers, and custom tooltips in Power BI. Published and shared Power BI reports and data models in Power BI workspaces.
- · Expanded my expertise in cloud systems, notably Azure, where I handled data transactions with Azure Blob Storage, enhancing data accessibility and security.
SQL/SSIS/ETL/Azure Developer
Assurant Solutions
07.2016 - 09.2017
- Developed SQL databases and write applications to interface with SQL databases. Designed and developed SQL queries for integration with other applications. Maintained and enhanced existing SQL databases and applications.
- Troubleshoot and resolved database issues in a timely manner. Researched and proposed new SQL technologies to improve application efficiency.
- Designed and developed ETL processes using SQL Server Integration Services (SSIS). Collaborated with stakeholders to gather ETL requirements and specifications. Performed data profiling, cleansing, and transformation activities.
- Developed and maintained documentation for ETL processes and data mappings. Optimized and tuned SSIS packages for improved performance and reliability. Troubleshoot and resolved issues related to data quality and ETL processes.
- Implemented best practices in ETL development and ensured compliance with data standards. Provided support and guidance to junior developers and team members.
- Designed, developed, and implemented ETL processes to support data integration and migration. Collaborated with business stakeholders and IT teams to gather ETL requirements.
- Developed and maintained documentation for ETL processes, data mappings, and data dictionaries. Designed and deployed scalable and resilient Azure solutions in accordance with best practices.
- Designed and deployed scalable and resilient Azure solutions in accordance with best practices.
- Architected scalable data solutions on Azure using services like Azure Data Factory and Azure Synapse Analytics.
Education
Bachelor of Science - Information Technologies
Institute of Information Technologies
Samarkand, Uzbekistan06.2014
Bachelor of Science - Banking
Tashkent Institute of Finance
Tashkent, Uzbekistan06.2006
Skills
- Programming Languages: SQL, Python
- Database Management: SQL Server (SSMS), Oracle, MySQL, MongoDB
- ETL Tools: SQL Server Integration Services (SSIS), Azure Data Factory (ADF)
- Cloud Platforms: Microsoft Azure (Azure Data Factory)
- Data Visualization: Tableau, Power BI
Timeline
SQL/SSIS/ETL/Power BI/Azure Developer Engineer
CALIBER HOME LOANS
01.2023 - Current
SQl/SSIS/ETL/Power BI/Azure Engineer
KIMBERLY-CLARK
06.2019 - 12.2022
SQL/SSIS/ETL/Power BI/Azure Developer
Kaiser Permanente
10.2017 - 05.2019
SQL/SSIS/ETL/Azure Developer
Assurant Solutions
07.2016 - 09.2017
Bachelor of Science - Information Technologies
Institute of Information Technologies
Bachelor of Science - Banking
Tashkent Institute of Finance
Similar Profiles
Danielle BiermannDanielle Biermann
VA Eligibility and Entitlement Analyst at Newrez Home Loans (Formally Caliber Home Loans)VA Eligibility and Entitlement Analyst at Newrez Home Loans (Formally Caliber Home Loans)
Lesa ClarkLesa Clark
Licensed Loan Officer Assistant at Union Home Mortgage / Caliber Home LoansLicensed Loan Officer Assistant at Union Home Mortgage / Caliber Home Loans
Alexis ClingermanAlexis Clingerman
SENIOR MORTGAGE LOAN PROCESSOR at Caliber Home Loans, LLCSENIOR MORTGAGE LOAN PROCESSOR at Caliber Home Loans, LLC
Alexis ClingermanAlexis Clingerman
SENIOR MORTGAGE LOAN PROCESSOR at Caliber Home Loans, LLCSENIOR MORTGAGE LOAN PROCESSOR at Caliber Home Loans, LLC
Kyle AndersonKyle Anderson
Warehouse Associate at Lineage Logistics LLCWarehouse Associate at Lineage Logistics LLC