Ismail Ismailov
Renton,WA
Summary
Results-driven BI SQL Developer with 7+ years of experience in designing, implementing, and optimizing MS SQL databases and BI solutions across hospitality, healthcare, and sales industries. Adept at translating complex business requirements into scalable data architectures and actionable insights, driving data-driven decision-making.
Recognized for delivering high-impact solutions under tight deadlines, with strong problem-solving, collaboration, and communication skills. A quick learner, adaptable to evolving technologies, with a passion for data analysis, visualization, and business intelligence.
Currently seeking a Senior BI Developer role to leverage expertise in SQL, data integration, and reporting—transforming raw data into strategic business value while continuing to grow in fast-paced, innovation-driven environments.
Overview
8
8
years of professional experience
Work History
Sr. BI Developer
Tivity Health
01.2022 - Current
- Designed and developed complex ETL processes, data pipelines, and data integration solutions in the Azure Cloud using Azure Data Factory (ADF2), Azure Synapse Analytics, and Azure Cosmos DB
- Developed data transformation logic using C# and Python programming languages
- Worked with JSON and REST APIs to integrate data from various data sources
- Designed and implemented data models and schemas for data storage in the Azure Cloud
- Created custom activities, stored procedures, and functions using Azure Databricks
- Conducted performance tuning of SQL queries and data transformation logic to optimize ETL processes
- Skilled in Spark-based data processing within Databricks for real-time and batch analytics
- Developed and maintained SQL queries and stored procedures to support the application's data layer
- Created and maintained Azure Virtual Machines for application hosting
- Developed reports and dashboards using Power BI for data visualization and analysis
- Work with a team of developers to move, update, and report data using SQL, SSIS, and PowerBI
- Manage daily operations, including database backups and restores, maintenance jobs, and developers’ requests
- Developed ETL packages to extract, transform and load into Data warehouse using of SQL Server Integration Services (SSIS)
- Created complex analytic queries on huge data sets
- Developed T-SQL stored procedures, triggers, and user-defined functions
- Handled data manipulations as required
- Evaluating Source systems, standardizing received data formats, understanding business/data transformation rules, business structure and hierarchy relationships
- Worked independently and as part of a team to accomplish critical business objectives and to make decisions under pressure
- Created ER diagrams, Dimensional Modeling using MS Visio, Erwin and Toad
- Generated SSIS packages/projects to pull out, modify and load data from various sources such as Oracle/SAP and SQL Server Database, Flat Files, Excel source files to specific destinations by using Visual Studio into Data Warehouse
- Converted old ETL packages to the new version, performed optimization by applying more stored procs instead of using visual studio tasks
- Worked with the team/architect to create logical/physical modeling and created Cubes (fact, dimensions and calculations)
- Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports
- Developed Qlik Sense dashboards to visualize key business metrics, improving reporting efficiency by 40%
- Optimized performance using QVD files, incremental loading, and data modeling best practices
- Created Set Analysis expressions for advanced calculations and comparisons across time periods
- Built QlikView reports for financial data analysis, integrating multi-source data from SQL databases
- Improved overall efficiency by mentoring junior developers in best practices for BI development and report writing.
- Enabled real-time decision making with the development of innovative data visualization techniques to effectively display complex datasets for easy consumption.
- Maximized resource allocation with accurate forecasting models that factored in historical trends and future predictions for better budget planning.
- Reduced data discrepancies with the implementation of robust ETL processes to extract, transform, and load data from multiple sources into the data warehouse.
- Increased user satisfaction by optimizing existing BI systems through performance tuning, troubleshooting, and bug resolution.
- Strengthened interdepartmental cooperation through consistent collaboration across various teams during project ideation phases to ensure alignment of goals in line with business requirements.
- Wrote and optimized SQL statements to assist business intelligence practices.
- Tested functional compliance of company products.
- Supervised work of programmers, designers and technicians, assigned tasks and monitored performance against targets.
SQL/ETL Developer
Epam Systems
12.2018 - 12.2021
- Company Overview: It is a global provider of digital platform engineering and software development services specializes in software engineering services, digital platform engineering, and digital product design
- Collaborated closely with the Billing department to gather requirements and business rules necessary for implementing a data warehouse
- Produced monthly, quarterly, and annual reports by writing Oracle PL/SQL scripts
- Created various types of ad-hoc reports by writing Oracle PL/SQL and T-SQL scripts from both OLTP and OLAP database environments
- Held responsible for integrating data from multiple sources, such as Oracle, MySQL, and Excel files
- Ensured data cleanliness and quality through SSIS lookup and Fuzzy lookups before loading them into the live database
- Guided junior developers in certain areas of development by helping them understand which technologies could better serve them in resolving issues during the project development process
- Conducted code reviews for junior developers to help them enhance the performance and clarity of their T-SQL and PL/SQL codes
- Cooperated in designing and implementing process for deploying, upgrading, managing, archiving and extracting data in Azure SQL
- Performed ETL (Incremental Loading) tasks in a Data Warehouse environment utilizing SSIS packages
- Utilized Power BI Desktop to analyze data from multiple sources and generate reports and dashboards
- Developed SSIS packages for file transfer from one location to another using FTP task and modified packages accordingly using advanced features of SQL Server Integration Services
- Created, updated and modified database tables, views, and stored procedures as per business requirements
- Gathered, analyzed, and documented business requirements and rules by working directly with end users/clients
- Developed custom Functions, manual running totals and complex formulas for reports
- Created SQL Server Reports for Management using SSRS
- Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS 2012
- Developed several reports with consistent drill-down functionality including Drill-down reports, Summary reports and Master Detail reports
- It is a global provider of digital platform engineering and software development services specializes in software engineering services, digital platform engineering, and digital product design
- Reduced processing time for ETL tasks through the implementation of parallel execution strategies.
- Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.
- Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
- Resolved production issues quickly and efficiently, minimizing downtime and maintaining high levels of user satisfaction.
- Developed custom reports for business stakeholders, providing valuable insights into key performance metrics.
- Mentored junior developers on best practices in ETL development, fostering a culture of continuous learning within the team.
- Established effective communication channels with key stakeholders to ensure timely delivery of project milestones.
- Implemented proactive monitoring solutions for ETL processes, identifying potential bottlenecks before they impacted users.
- Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and big data installations.
- Documented technical specifications and designs, facilitating knowledge sharing among team members and supporting future development efforts.
- Increased data accuracy by implementing thorough validation checks and error-handling mechanisms.
- Designed and created ETL code installations, aiding in transitions from one data warehouse to another.
SQL Report Developer
Rotana
03.2017 - 12.2018
- Company Overview: The Rotana Hotel Management Corporation
- Create dynamic SSIS packages using complex expressions, variables, and control flow components such as for each Loop Container to load inbound files coming daily
- Developed and maintained SQL Server Integration Services (SSIS) packages for data migration and ETL processes
- Created SSIS packages using Fuzzy Lookup, Derived Columns, Condition Split, Execute SQL Task, and Data Flow Tasks
- Worked on database design, normalization, and schema creation
- Designed, developed, and deployed reports using SQL Server Reporting Services (SSRS)
- Involved in the development of custom SQL, T-SQL, custom stored procedures, functions and triggers
- Worked on the analysis and implementation of new functionalities that can be brought into the Target from other source systems
- Worked on Data Transformation Activities using SSIS Import/ Export for transferring data between different Data Sources to SQL Server using ETL Concepts
- Worked on with Report Manager, Report Builder, and Reporting Security and Reporting Services Configuration manager
- Identified the database tables for defining the queries and datasets for report generation
- Created and maintained accurate and complete documentation for all tasks performed
- Designed and developed data transformation logic within Databricks, leveraging Python and Spark for efficient data processing
- Collaborated with cross-functional teams to implement scalable machine learning models using Databricks' MLflow
- The Rotana Hotel Management Corporation
Education
Bachelor of Science - Computer Science
INHA
TashkentAssociate of Science - Computer Science
TATU
FerganaSkills
- Database Design
- MS SQL 2008/2012/2014/2016
- SQL Server Objects
- Tables
- Constraints
- Indexes
- Joins
- T-SQL development
- Stored Procedures
- Triggers
- User-Defined Functions
- Query Optimization
- Azure Data Factory
- ETL Pipelines
- Azure Key Vault
- Key Vault Secrets
- Integration Runtimes
- Cloud Data Warehouses
- SQL Server Integration Services (SSIS)
- SQL Server Analysis Services (SSAS)
- SQL Server Reporting Services (SSRS)
- Power BI
- Azure Synapse
- Azure SQL Hyperscale
- Serverless Azure SQL
- Azure Blob Storage
- Database Management
- Indexed Views
- Complex Parametrized Stored Procedures
- DDL/DML Triggers
- Cursors
- User Defined Data Types
- Data Conversion
- Conditional Split
- Bulk Insert
- Derived Column
- Merge
- Union All
- Entity-Relationship Concept
- Facts and Dimension Tables
- Slowly Changing Dimensions (SCD)
- Dimensional Modeling
- Star Schema
- Snowflake Schema
- Report Development
- DAX
- AWS EC2
- AWS RDS SQL Server
- Amazon Redshift
- AWS S3
- Databricks
- Data Modeling
- Performance Optimization
- Critical Thinking
- Interpersonal Skills
- Communication Skills
Locations
- Tivity Health, Arizona, US
- Epam Systems, New-York, US
- Rotana, Abu-Dhabi, UAE
- INHA (University in Tashkent), Tashkent, UZB
- TATU (technical college), Fergana, UZB
Languages
English
Full Professional
Russian
Full Professional
Uzbek
Native or Bilingual
Timeline
Sr. BI Developer
Tivity Health
01.2022 - Current
SQL/ETL Developer
Epam Systems
12.2018 - 12.2021
SQL Report Developer
Rotana
03.2017 - 12.2018
Bachelor of Science - Computer Science
INHA
Associate of Science - Computer Science
TATU
Similar Profiles
Ana SusanoAna Susano
Executive/ Personal Assistant to President / CEO at Tivity HealthExecutive/ Personal Assistant to President / CEO at Tivity Health
Laura JaloveLaura Jalove
Compliance & Privacy Manager at TIVITY HEALTHCompliance & Privacy Manager at TIVITY HEALTH
Jazmine ClarkeJazmine Clarke
Representative, Member Technical Expert at Tivity HealthRepresentative, Member Technical Expert at Tivity Health