Marifat Islomova
Louisville,KY
Summary
Experienced SQL Server/ETL/Power BI Developer with 7+ years of programming and database administration experience. Skilled in developing, maintaining, and optimizing data warehouses, ETL processes, and Power BI solutions. Seeking a challenging position to leverage my knowledge and experience to help drive innovation.
- Strong understanding of Database Design Development, ETL Implementation and support of OLAP/OLTP/Data 4+ years of IT experience in Data Design and Development on Microsoft SQL Server 2008/2005/2000, T-SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS, SSAS and Data-warehousing.
- Experience in using Business Intelligence tools (SSIS, SSAS, SSRS) in MS SQL Server 2008
- Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
- Extensive knowledge of Normalization and Relational Database Management Systems.
- Hands on experience on various SQL Server Services like Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
- Hands on Experience in Installing, Configuring, Managing, monitoring, and troubleshooting SQL Server2008/2005/2000.
- Great ability to create and manage various database objects like tables, views.
- Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
- Experience in Performance Tuning and Query Optimization.
- Experienced in using ETL tools in (SSIS) MS SQL 2008, MS SQL 2005 and DTS in MS SQL 2000
- Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
- Data Loading Experience in SQL Server 2008 using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.
- Data analysis and data migration by transferring them using SSIS packages.
- Experience with logical and physical data modeling and database design using Erwin.
- Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
- Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.
- Expert in creating SSAS cubes and creating dashboards in PPS (Performance Point Server) using Business Modeler.
- Expert in creating simple and parameterized reports and complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS).
- Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drills through and Drill Down reports using SSRS.
- Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
- Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.
Overview
11
11
years of professional experience
Work History
SQL Server/ETL/Power BI Developer
Paxful
09.2019 - Current
- Installed and upgraded from SQL Server 2012 to SQL server 2016 on Various Servers
- Migrating Databases from SQL Server 2012 to SQL Server 2016
- Established end-to-end complex data migration, conversion and data modeling
- Define migration strategy and plan
- Support deployment of solution, cut over planning and execution activities
- Writing Complex Queries, stored procedures, Batch Scripts, Triggers, indexes, and Functions using T-SQL for SQL Server 2016
- Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning database
- Implemented different types of constraints on tables
- Involved performance tuning to optimize SQL queries using query analyzer
- Developed, monitored, and deployed SSIS packages
- Worked with ETL to implement slowly changing transformation, to maintain Historical Data in Data warehouse
- Used extensively SSIS Import/Export Wizard, for performing ETL operations
- Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures, and Triggers
- Enhanced and deploying SSIS Packages from development server to production server
- Created packages in SSIS with error handling
- Responsibility included creating XML and SQL Server package configuration to make package dynamic using SSIS package
- Used different methods of logging in SSIS Building, publishing customized interactive reports and dashboards, report scheduling using Power BI
- Expertise in writing complex DAX functions in Power BI and Power Pivot
- Established action filters, parameters and calculated sets for preparing dashboards and worksheets in Power BI
- Developed Power BI workbooks from multiple data sources using Data Blending
- Created Data Dictionary for business users to access in database smoothly
- Created detailed reports for customers to help End user Analyze Financial statements by showing demographic information based on various parameters.
SQL Server/SSRS Developer
Futurity
05.2018 - 09.2019
- Prepares performance Dashboard, Jobs Failure stats, Data Volume check using SSRS, SSIS, SQL and Excel and gives PPT presentation near client for this on a daily basis
- Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements
- Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files
- Developed Data Source, Data Source View to create a logical view of the data to be placed in OLAP Cubes using SQL Server Analysis Services (SSAS) projects
- Created many calculated columns and measures using DAX in Power BI based on report requirements
- Involved in Tabular Data Warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases
- Troubleshooting reports issues, ETL job failures, optimizing query performances
- Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
- Created several cubes, dimensions, and business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance
- Design and implement the ETL processes using SSIS which involves collection of data from sources like SQL Server 2008 R2/2012/2014/2016/2018
- Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes and good experience in SSAS
- Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS
- Created, Maintained & scheduled various reports in Power BI like Tabular Reports
- Explore data in a variety of ways and across multiple visualizations using Power BI
- Solid knowledge of Relational Database Management System (RDMS), Data Warehouse Concepts, PL SQL, DAX, OLAP and OLTP
- Developed impactful reports using SSRS, MS Excel, Pivot tables and Tableau to solve the business requirements
- Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries
- Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL
- Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in Azure Databricks
- Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards.
SQL SSIS Developer/SSRS Developer
MetLife
05.2012 - 08.2014
- Worked as developer in creating complex Stored Procedures, Triggers and Functions
- Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning database
- Implemented different types of constraints on tables
- Implemented Performance tuning to optimize SQL queries using query analyzer
- Tested to optimize procedures and triggers to be used in production
- Designed transformation rules and processes to derive correct data from extracted data and transform into required format and structure to support business requirements
- Loading transformed data into target database and associated metadata into enterprise metadata repository
- Experienced of using script task transformation for loading data from different sources by using VB.Net for integration purposes
- Designed various schemas which are used for Landing data, staging for transforming data and PROD in MS SQL SERVER 2014
- Hands on experience in complex joining for integration and reporting purpose
- Involved in project planning, scheduling for database module with project managers
- Created reports based on requirements using SSRS 2014/Crystal Reports XI
- Generated Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL-Promoted RDLs to Reporting Service Server
- Wrote queries for drill down reports
- Formatted reports using Global variables and expressions
- Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
- Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
- Developed Tableau workbooks from multiple data sources using Data Blending
- Created detailed reports for customers to help End user Analyze Financial statements by showing demographic information based on various parameters
- Authored performance-based reports for End user
- Identified and defined Datasets for report generation
- Extensively used SSIS Import/Export Wizard, for performing ETL operations
- Developed, monitored and deployed SSIS packages
- Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation
- Created packages in SSIS with error handling
- Used C# scripts to run custom scripts in package flow
- Worked with different methods of logging in SSIS
- Developed stored procedures to transform data from enterprise data warehouse to data mart to build dimensions and load data to fact tables
- Responsible for automation of maintenance jobs, locks and indexes configurations
- Administered SQL Server security, SQL Server automatic e-mail notification
- Managed SQL user logins, database user accounts, server roles, database roles and its permissions
- Handled dead lock scenarios
- Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet business requirements
- Configured replication servers and transactional replication between production and standby server for disaster recovery
- Examine two-way database replication using SQL server
- Experienced of using code repository Team Foundation Server (TFS).
Education
Bachelor of Science - Business Administration
SolBridge International School of Business
Daejeon, South Korea05.2018
High School Diploma - Computer Science
Community College
Samarkhand, Uzbekistan06.2012
Skills
- SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS), Microsoft Azure
- Data Transformation Services (DTS) – Export/Import, SQL Server Integration Service (SSIS), Visual Studio 2010,2012,2013
- SQL Server Reporting Services (2005/2008 R2,2012,2014,2016), Tableau, MS Access, MS Excel
Databases Tools
ETL Tools
Reporting Tools
Modeling Tools
- Microsoft Visio, SQL Diagrams, ERWIN 41
- T-SQL, PL/SQL, VBNet, XML, HTML, C#, C, C
- Operating Systems
- Windows 2012/2008 R2/2003/2000 Server (64/32 Bit), Windows 2000 Professional, Windows NT 40/35 Unix, Linux
- MS Office Suite, OLAP & OLTP, ERWIN, TriZetto Facet, Citrix, Diagnostic Manager, IBM WebSphere (One Run, CMU), TWS, Service Now, Ultra Edit, One Note, MS Outlook, SOAP UI
Programming Tools
Other Tools
Additional Information
- Authorized to work in United States for any employer
Languages
Russian
Native or Bilingual
Uzbek
Native or Bilingual
English
Full Professional
Timeline
SQL Server/ETL/Power BI Developer
Paxful
09.2019 - Current
SQL Server/SSRS Developer
Futurity
05.2018 - 09.2019
SQL SSIS Developer/SSRS Developer
MetLife
05.2012 - 08.2014
Bachelor of Science - Business Administration
SolBridge International School of Business
High School Diploma - Computer Science
Community College
Similar Profiles
Mary AiyedogbonMary Aiyedogbon
Account Manager at PaxfulAccount Manager at Paxful
Komal MalikKomal Malik
Cryptocurrency Trader at Paxful And BinanceCryptocurrency Trader at Paxful And Binance
Caleb StultzCaleb Stultz
Managing Editor at LEO WeeklyManaging Editor at LEO Weekly