Hurshid Urunov

About Hurshid Urunov

Full stack MS BI developer who has been exposed to all stacks of BI development and who…

Experience

1. Bi Developer Sql Server Developer

   Univar Solutions

   Feb 2019 — Present

   Created Queries in T-SQL, Stored Procedures and Views to store the data of clients, advisors using SQL Server Management Studio and created indexes to the tables that have least updates to improve the query performance. • Created ETL packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column and so on, to import and export information • Developed ETL packages in SSIS to ensure data quality and data consistency using Lookup, Execute SQL Task, Sequence Container, Breakpoint, and Checkpoint • Created ETL packages and send emails to managers when a package was run and when an error occurs using Event Handler • Tune SQL queries and database performance by improving overall table design, indexing, query plan analysis and refactoring. Create database design documentation at architectural and functional level. • Review database objects for data integrity, quality, security, recoverability, scalability, maintenance and capacity recommend changes as necessary. • Recommend new strategies and architecture to enhance efficiency of data systems. Plan, manage and track database and SQL procedures system changes. • Designed developed the SSIS packages to extract, transform, load the data into Target. • Extensively Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations. • Worked with mappings to dynamically generate parameter files used by other mappings. Involved in performance tuning of the ETL process by addressing various performance issues at the extraction and transformation stages. • Documented the mappings used in ETL processes including the Unit testing and Technical document of the mappings for future reference.