Резюме Senior Software Engineer

Професійні навички

• DB2
• API
• AWS
• Big Data
• Business
• Cloud
• CMS
• CRM
• DBMS
• Design
• Excel
• Management
• MySQL
• OLAP
• OOP
• Oracle
• Postgres
• PostgreSQL
• Python
• SAAS

Початковий текст

Javokhir Saporbaev – Senior Software Engineer

Summary

• ••Over 7+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server in Development, Test and Production Environments on various business domains like Financial, Insurance, Software and Manufacturing.

• ••Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2************8/2012 R2.

• ••Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.

• ••Experience in SQL server MDS 2012 features include hierarchies, granular security, transactions, data versioning, and business rules.

• ••Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, SAS, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.

• ••Developing reports on SSRS on SQL Server (2************8). Sound Experience and understanding of SSAS, OLAP cube and Architecture.

• ••Good hands-on Azure Data Factory, configuring Azure platform for data pipelines, ADF, Azure Blob Storage and data lakes, transforming data in Azure Data Factory with the ADF Transformations

Skills

EPAM

• ••Technologies: T-SQL,PostgreSql, Tabular, SQL, DAX, SSAS

Microsoft Azure

• ••Microsoft Azure/Azure Analytics: Azure Data Factory

Microsoft Power Platform

• ••Microsoft Power Platform/Microsoft Power BI: Power BI Report Development

Technologies

• ••Integration Platforms: Microsoft SQL Server Integration Services

• ••Microsoft SSRS: Microsoft SSRS Report Development

Work experience

Apr 2021 - Present

Data Engineer, EPAM SYSTEMS

Customer: TRI-RCMS

Project: Datawarehouse development, using T-SQL

Team Size: Project Manager Team Lead Senior data engineer 2 Junior Data engineers

Project Role: SQL BI SSAS, SSRS, SSIS Developer /Team Lead

• As a key member of BI team, delivered the best results to the development needs, accomplished successful outcomes by working with SSIS, SSAS and SSRS.

• Supported the Project Manager in leading multi-functional project teams in implementing data conversion strategies and communicating essential information to team members.

• Gathering, analyzing and documenting the business requirements and business rules by directly working with end users/clients.

• Created and maintained documents like Documentation Roadmap, DATA Models, ETL Execution Plan, Configuration Management Procedures, and Project Plan.

• Designed and developed various SSIS packages (ETL) to extract and transform data and involved/Scheduled in Scheduling SSIS Packages.

• Created complex Stored Procedures/execute task, wrote c# hard codes in script task for ETLs, updated/maintained the ETL packages with high performance.

• High Experienced in all Visual studio components for Integration services such as Control flow( Data Flow, Execute SQL, Expression ,File System, Script, XML tasks and For Loop Container, Foreach Loop Container, Sequence Container.

• Development, Maintenance and Administration of SSIS packages using SQL Jobs, Alerts, SQL Mail Agent, Logging and Configurations.

• T-SQL skills in writing difficult Queries using Lead, Lag, Window Functions, Joins, Bulk Insert, Merge and OpenQuery

• Excellent in High Level Design of ETL/SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, flat files, MS Access, SAS, Oracle, DB2, SalesForce, CRM) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Derived Column, Merge, Merge Join and Union all and ETL Development leveraging Python and Data Warehousing.

• Experienced in writing SSIS script/script component tasks using C# script for customized data manipulation of complex SSIS packages.

• Adept in Createing SSIS Packages to load data for dimension tables, Fact tables and also Configuring packages using XML, Sql Server, Parent package variable methods.

• Hands on experience of Migrating on-premise SQL Server databases to the cloud Azure platform (SQL Server DB) and from Azure to on-premise Server environment. Experience working with AWS big data technologies (Redshift, S3, EMR, Glue, etc.)

• Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, Cache, for each loop, multi cast and Derived column.

• Expert knowledge in creating Simple and Parameterized Reports using SSRS and Power BI

• Conceptual and Logical plus Physical Data Modeling skills and experience with JAD sessions for requirements gathering, creating data mapping documents and queries.

• Strong skills in creating and using linked servers from SQL server to Oracle, MySQL and PostgreSQL.

• Solid knowledge of addressing performance issues related to Queries, Indexes, Subqueries and other database related activities.

• Strong experience of creating and maintaining complex queries in different RDBMS environments such as Microsoft SQL Server, Oracle and MySQL.

• Excellent communication and interpersonal skills and proficient in writing and presenting complex technical concepts for technical and non-technical people.

• Developed python script to automate the API process and managing the historical records of user to history table.

Jan ***************

Data Engineer, MAAB Innovation

Customer: LEK Consulting

Project: Custom applications development

Team Size: Team lead + Senior BI developer + 3 Junior Developers

Project Role: Power BI Developer

Tasks performed:

• ••As a key member of BI team, delivered the best results to the development needs, accomplished successful outcomes by working with SSIS, SSAS and SSRS.

• ••Supported the Project Manager in leading multi-functional project teams in implementing data conversion strategies and communicating essential information to team members.

• ••Gathering, analyzing and documenting the business requirements and business rules by directly working with end users/clients.

• ••Created and maintained documents like Documentation Roadmap, DATA Models, ETL Execution Plan, Configuration Management Procedures, and Project Plan.

• ••Designed and developed various SSIS packages (ETL) to extract and transform data and involved/Scheduled in Scheduling SSIS Packages.

• ••Created complex Stored Procedures/execute task, wrote c# hard codes in script task for ETLs, updated/maintained the ETL packages with high performance.

• ••High Experienced in all Visual studio components for Integration services such as Control flow( Data Flow, Execute SQL, Expression ,File System, Script, XML tasks and For Loop Container, Foreach Loop Container, Sequence Container.

• ••Performed SSIS Development and support, developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File, and DB2, SharePoint Lists into the central OLTP database.

• ••Deployed projects and packages into different places like SSISDB, MSDB and File System replacing configurations with project parameters.

• ••Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for SSIS packages and SSRS reports.

• ••Design, maintain and deliver SSRS reports sourcing from central database.

• ••Extracted and Loaded SharePoint Lists and Surveys Data into SQL Server Database with SQL Server Integration Services.

• ••▪ Experienced in Cloud implementation for BI platforms using Azure SQL PAAS/SAAS/IAAS, Azure Synapse and Azure Data factory.

• ••▪ Created Multiple Data Sets in Azure worked in migration of SQL Server 2************4 to SQL Server 2017.

• ••Developed python code to merge multiple files from different services in Azure.

Environment: T-SQL SSIS SSRS SSAS Power BI Azure Data Factory

Jun ***************

Data Engineer, Data Network Solutions

Customer: Data Network Solutions

Project: App development

Team Size: Project Manager Team Lead Senior data engineer 2 Junior Data engineers

Project Role: ETL developer

Tasks performed:

• ••Worked on creating SQL Server jobs and scheduled them to load data over nightly using SQL server Agent.

• ••Created packages using the various control flow task such as data flow task, execute SQL task.

• ••Achieved successful results on performance based on execution plan and creating optimal logic using T-SQL.

• ••Created Joins and sub-queries for complex queries involving multiple tables from different databases Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.

• ••Wrote Stored Procedures, Functions and expressions for better performance and flexibility.

• ••High Experienced in generating SSIS Packages/projects from various sources to specific destination by using Visual Studio 2012, building and scheduling jobs for ETL process.

• ••Developed SSIS packages to pull out, modify and load data from Oracle/SAP and SQL Server databases into Data Warehouse.

• ••Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.

• ••Created and Designed Data Source and Data Source Views and also configured OLAP Cubes (Star and Snowflake Schema) using SSAS.

• ••Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.

• ••Developed ETL solutions using SSIS and Azure Data Factory for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server Raw File and DB2 into the data warehouse.

Environment: T SQL database, T-SQL SSIS SSRS SSAS Azure Data Factory

Education

Name of the Education *************: Westminster International University in Tashkent

Faculty/College: Business Information Systems