Asrorjon Teshaboev

Asrorjon Teshaboev Uchkuprik, Ferghana, Uzbekistan| Cellphone +998 91 - |-| Summary MSBI professional with extensive of IT experience in querying, designing, maintaining databases, and developing Business Intelligence Solutions on MS SQL Server. Strong knowledge and wide working experience in developing ETL packages using SSIS to automate data migrations from various sources. Skilled in developing reports, dashboards using different reporting and visualization tools such as Power BI, SSRS and others. Wide working experience in cloud services, including Azure IaaS, PaaS, SaaS. Experience Sr.bi developer | City star | january 2020-Present Ferghana, Uzbekistan Actively participated in gathering Business Requirements and System Specification. Participated in implementing the logical design to the physical design by creating tables. Strong experience with SQL Server and T-SQL in implementing, maintaining, developing Stored Procedures, Triggers, Nested Queries, Joins, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, creating and updating tables and checking the database consistency by executing DBCC commands. Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures. Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database. Created Alerts, Notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security violation. Migration of on-premise data (SQL Server) to Azure Data Lake Store (ADLS) using Azure Data Factory (ADF V2). Created various types of reports such as sub reports, Tablix and Matrix using SQL Server Reporting Services and created Parameterized Reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required. Created reports on both cascading and standard parameters. Designed reports on account information, research reports using ad-hoc reporting to be used by clients and advisors. Worked on Power BI in creating dashboards and reports and visualizing data. Used Power Query to acquire data, developed calculated columns and measures using DAX in Power BI desktop for designing rich visuals using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map. Shared with user groups, scheduled and maintained the Power BI reports published to the Power BI Service. Sourced data from SQL Azure database, SQL Azure Data warehouse, AWS RDS solutions such as MySQL Aurora and Redshift for my Power BI Reports. 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. Configured Azure platform for data pipelines, ADF, Azure blob storage and data lakes, and built workflows to automate data flow using Python and ADF. Combined structured, unstructured and semi-structured data (log files, and media) using Azure Data Factory to Azure Blob Storage. Created SSIS Packages by using advance transformations (i.e., Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate) and used Custom components such as Audit on Pre-Execute, Audit on Post-Execute and Statistics Logging Component. Used Python Notebooks in Databricks/Synapse/ADF and did data cleansing by flattening json data before pushing it into Power BI Service. Proficient in developing parameterized reports, chart, graphs, linked reports, drill-down reports using Power BI. Used SharePoint as a place to keep Power BI reports, by using ready to use Power App Solution to do Version Control of reports Used Power BI to implement a semantic model to simplify the analysis of business data and relationships by loading relevant data from Azure Synapse data warehouse. SQL BI SSIS, SSRS/Power BI Developer, Conversion-Data Analyst| bozoraka | june 2017-december 2019 Seoul, South Korea Involved in writing heavy T-SQL stored procedures, complex joins, new T-SQL features like Merge, Except commands Developed data standards, data exchange, XML data standard or data sharing model. Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy LookUps, and Derived Columns with Multiple Data Flow tasks. Created XML Package Configurations, Error Handling using Event Handlers for On Error, On Warning, On-Task Failed event types. Worked with re-directing outputs into different formats including XML Files and various other data sources. Involved in automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler, and third-party tools. Worked on several transformations in Data Flow including Derived-Column, Script, Slowly Changing Dimension, Lookup, Data Conversion, Conditional-Split and many more. Worked on XML Web Services Control Flow task to read from XML Source. Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages. 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. Interpreted data, analyzed results using statistical techniques and provided ongoing SSRS and Power BI reports. Created, maintained and updated ETL packages loading from/to both OLTP and OLAP database tables. Developed and implemented data collection systems and other strategies which optimize statistical efficiency and data quality. Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load. Created packages in SSIS with error handling and worked with different methods of logging in SSIS. Acquire data from primary or secondary data sources and maintain databases/data systems Identify, analyze, and interpret trends or patterns in complex data sets. Filter and “clean” data, and review computer reports, printouts, and performance indicators to locate and correct code problems. Converted old ETL packages to the new version (did optimization by applying more stored procedures instead of using control flow tasks). Work closely with management to prioritize business and information needs. SQL/bi developer | Ishonch med | january 2016-january 2017 Uchkuprik, Uzbekistan Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects and Reports. Involved in creating various Tables, Views, Stored Procedures and Functions based on the requirements specified by Power Chart team and wrote complex Join statements for combining data from various Databases and tables. Proficient in tuning SQL queries using execution plan, index and DMV Normalized the tables and maintained Integrity by using Primary and Foreign Keys. Created indexes and views, stored procedures to enhance database/application performance. Created SSIS packages with different data sources (SQL Server, Flat files, Excel files, CSV files) and loaded the data into target tables by performing different kinds of transformations using SSIS. Used T-SQL to manage databases by managing index fragmentation, managing statistics, shrinking files and performing DBCC Checks. Staged data from various sources in designing and building warehouse Dims and Facts with Full & Incremental Loads and populated data in the appropriate destination tables. Applied various data cleansing and data transformations like Slowly Changing Dimension (SCD), Derived column, Aggregate, Sort, Multicast, Conditional Split, Union All. Logged various packages as well as individual tasks using SQL server log providers like text file, SQL server database, trace file, xml file. Involved in scheduling SSIS packages in multiple servers using SQL Server Agent. Documentation for all kinds of reports and SSIS packages. Schedule and maintain Full, Differential, Transactional Log Backup and restore the data using restore with recovery and restore with no recovery option. Responsible for database tuning using normalization and application tuning. Worked on locking, blocking and dead lock issues. Performed troubleshooting for the project assigned personally to me and projects assigned to the other BI team members. Scheduled jobs and alerts using SQL Server Agent and configured database mail for any job failure using SQL Server Agent, Windows Scheduler to perform various administrative tasks. Created many Power BI reports and dashboards by using efficient and complex DAX expressions and creating measure/columns with drill down/drill through/hyperlink options, dynamic slicing/dicing features, custom interactive tooltips on visuals and KPIs, providing insights on different visualization options. Involved in creating interactive, accurate, insightful, and well-organized Power BI reports/dashboards to support businesses in their data driven strategic planning. Worked on various DAX expressions in Data Model based on the business requirements. SQL/ETL developer | infin bank | january 2014-january 2016 Kokand, Uzbekistan Interacted with users and team leads for better understanding of the business specification and requirements, identifying data sources and Development strategies. Evaluating Source systems, standardizing received data formats, understanding business/data transformation rules, business structure and hierarchy relationships. Configuring, tuning and optimizing T-SQL. Responsible for performing basic developer tasks 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 regular reviews on the database to identify any performance problems, inadequate programming, and data duplication problems. Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages. Performed SSIS Development and support, developed ETL solutions for integrating data from multiple sources like Flat Files, Excel, SQL Server, and Raw File into the data warehouse. Created ER diagrams, Dimensional Modeling using MS Visio, Erwin and Toad. Created, maintained and updated ETL packages loading both OLTP and OLAP database tables. Developed complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load. Created packages in SSIS with error handling and worked with different methods of logging in SSIS. Configured SSIS packages with XML configuration file, SQL Server, Environment variable, Registry entry, Parent package variable. Moved data from SharePoint List into SQL Server database by creating SSIS package Acquired data from Primary or secondary data sources and maintain databases/data systems. Designed and developed MS SQL server stored procedures using T-SQL statements from scratch. Developed triggers on views to populate tables. Rigorously tested and debugged the stored procedures and used triggers to test the validity of the data after the insert, update and delete. Filtered and cleansed data, and reviewed computer reports, printouts and performance indicators to locate and correct code problems. Performed debugging and troubleshooting the technical issues while implementing the applications. Created complex stored procedures, triggers, functions (UDF), indexes, tables, views and other T-SQL code and SQL joins for SSIS packages and SSRS reports. Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS). Created linked, drill through, drill down, cashed, snapshot and sub reports using Report Server Project & Report Model Template in SSRS and was responsible for deploying them. Skills & Abilities T-SQL, PL SQL, PostgreSQL, MySQL MSBI (SSIS, SSAS, SSRS) Power BI, Tableau C#, Python (Pandas, Matplotlib) Azure Data Factory SharePoint Education MBA | ajou university| - Suwon, South Korea.