Experience

MAAB INNOVATION LLC

• Uzbekistan
• Information Technology & Services
• 1 - 100 Employee

• BI Developer at Toyota Motors North America

  • Apr 2021 - 2 years 9 months

  • As a key member of BI team, delivered the best results to the developmental needs, accomplished successful outcomes by working with SQL, Power BI, SSRS, ADF2 and SSIS. • Created client facing Power BI reports such as Resource Management Reports for HR department that shows KPI’s of different projects, number of employees worked in that project, sick leaves, PTOs so on. Also created Expense Report for HR department that shows how their budget is being used on monthly basis on social events,… Show more • As a key member of BI team, delivered the best results to the developmental needs, accomplished successful outcomes by working with SQL, Power BI, SSRS, ADF2 and SSIS. • Created client facing Power BI reports such as Resource Management Reports for HR department that shows KPI’s of different projects, number of employees worked in that project, sick leaves, PTOs so on. Also created Expense Report for HR department that shows how their budget is being used on monthly basis on social events, training programs and different cultural enrichment projects etc. • Created internal SSRS and Power BI reports for development team such as ETL Statuses/ETL Failures Report that shows the ETL issues that we captured at runtime about Control Flow Tasks and Data Flow Transformations when we run ETLs. • Involved in creating interactive, accurate, insightful, and well- organized Power BI reports/dashboards to support businesses in their data driven strategic planning. • Built custom and efficient stored procedures, CTE’s, functions (UDF), DML triggers, indexes, tables, views as part of the project.

• SQL/BI Developer at nThrive

  • Jan 2019 - Mar 2021

  • Experience in Analyzing all business functionality related to back-end database interfaces. • Used T-SQL to manage databases by managing index fragmentation, managing statistics, shrinking files and performing DBCC Checks. • Created complex stored procedures, triggers, functions (UDF), indexes, tables, views and other T-SQL code and SQL joins for SSIS packages and SSRS reports. • Configured SSIS packages with XML configuration file, SQL Server, Environment variable, Registry entry… Show more • Experience in Analyzing all business functionality related to back-end database interfaces. • Used T-SQL to manage databases by managing index fragmentation, managing statistics, shrinking files and performing DBCC Checks. • Created complex stored procedures, triggers, functions (UDF), indexes, tables, views and other T-SQL code and SQL joins for SSIS packages and SSRS reports. • Configured SSIS packages with XML configuration file, SQL Server, Environment variable, Registry entry, Parent package variable. • Logged in ETL failures using different logging options like SQL Server, SQL Server Profiler, Text file, XML file, Windows Event Log, and implemented custom logging as well by using Execute SQL Task. • Performed Incremental Loads using Lookup, Merge, and used Foreach Loop, Sequence Containers, Script Task, Conditional Split, Data Conversion, Derived Column, Union All, Merge Join etc. • Built efficient SSIS packages for processing Fact and Dimension tables with complex transformations by maintaining SCD Type 2/SCD Type 1 historical data.

• SQL Developer at CVS Health

  • Jan 2018 - Dec 2018

  • Wrote parametrized stored procedures to enable user interactivity to filter datasets, functions. expressions and variables for better performance and flexibility. • Performed regular reviews on the database to identify any performance problems, inadequate programming, and data duplication problems. • Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports. • Filtered bad data from legacy system using complex… Show more • Wrote parametrized stored procedures to enable user interactivity to filter datasets, functions. expressions and variables for better performance and flexibility. • Performed regular reviews on the database to identify any performance problems, inadequate programming, and data duplication problems. • Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports. • Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraints and triggers on database objects to enforce referential integrity for data consistency and database integrity. • Coordinated with Technical Analysts in understanding the business requirements and translated them into technical specifications. • Largely used T-SQL in supporting finance team and constructing user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity. • Created Jobs, Alerts, Activity logs, Error logs to capture any possible errors using SQL server Agent. • Achieved successful results on performance tuning based on execution plan and creating optimal logic and proper indexing using T-SQL.