Sql Server Azure Data

Location:

Posted:

August 14, 2023

Resume:

Dave Narzi

Converting client business requirements into technical solutions; creating custom information systems; troubleshooting bugs.

BI Development Troubleshooting & Debugging Database Designing Database Management

425-***-**** - 419-***-**** *********@*****.*** WA 98424 LinkedIn

Senior SQL/BI developer with 8+ years of IT experience in Database and Business Intelligence technologies with expertise in T-SQL, SSIS, ADF SSRS, PowerBI, SSAS and other BI technologies.

Database Development and Management

SIS and SSRS Expert

QL & Relational Database Programming

Cross-Functional Collaboration

Technical Documentation

Strategic Designing & Implementation

SQL, T-SQL, CSS, .NET, TFS, Java, JavaScript, C++, C#, HTML, Visual Studio

SQL Server Management Studio, Git

Professional Experience

ETL Developer, (SQL,SSIS, SSRS, Power BI)

07/2021 – Present

Blue Cross and Blue Shield of Louisiana

Louisiana, Baton Rouge Remote

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.

Experience developing PL/SQL procedures, functions, packages, triggers, and other database objects.

Strong understanding of Oracle database management, including database architecture, security, backup and recovery, and performance tuning.

Created Complex ETL Packages using SSIS and Azure Data Factory to extract data from staging tables to partitioned tables with incremental load; Created ETL packages with error handling and worked with different methods of logging in SSIS and ADF.

Performed SSIS and Azure Data Factory 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, Oracle 7.x/8i/9i/10g/11g, Sap, XML files, SharePoint Lists into the central OLTP database;

Familiarity with DAX data types and how to use them in formulas.

Converted old ETL packages to the new version (did optimization by applying more stored procedures instead of using control flow tasks).

Created, maintained, and updated ETL packages loading both OLTP and OLAP database tables.

Proficient in Alteryx Designer, Server, and Connect

Expertise in data preparation, cleaning, transformation, and blending using Alteryx

Experience in building complex workflows and creating macros in Alteryx

Knowledge of predictive modeling, statistical analysis, and machine learning using Alteryx

Data Insight - Insights Analyst delivered the best results to the developmental needs, accomplished successful outcomes by working with SSIS, SSAS and SSRS. Tableau, SQL, Data Visualization, Data Analysis, Microsoft Power BI, Customer Insight, Analytics and Data Analytics.

Ability to write complex DAX formulas to create calculated columns, measures, and calculated tables.

Understanding of DAX functions and their usage, including aggregation, filtering, time intelligence, and table manipulation.

Ability to troubleshoot and debug DAX formulas to resolve errors and improve accuracy.

ETL Developer, (SSIS, SSRS, PowerBI and SSAS, Azure) 12/2020 – 07/2021

Providence health & services

Washington, Seattle

Created complex stored procedures, triggers, functions (UDF), indexes, tables, views and other T-SQL code and SQL joins for SSIS packages, SSRS and PowerBI reports.

Knowledge of SQL query optimization techniques, such as the use of indexes, partitioning, and query tuning.

Actively participated in gathering Business Requirements and System Specification. Participated in implementing the logical design to the physical design by creating tables.

Using SSRS and PowerBI, 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

Designed PowerBI reports on account information, research reports using ad-hoc reporting to be used by clients and advisors. Created reports on both cascading and standard parameters. Worked on PowerBI and DOMO in creating dashboards and reports and visualizing data Experienced in Cloud implementation for BI platforms using Azure SQL PAAS/SAAS/IAAS, Azure Synapse and Azure Data factory.

Skilled in collaborating with cross-functional teams and communicating technical concepts to non-technical stakeholders

Familiarity with integrating Alteryx with other tools such as Tableau, Power BI, and Python.

Proficiency in using DAX to perform calculations, such as statistical analysis, forecasting, and data modeling.

Experience with DAX syntax, such as functions, operators, and parameters.

Configured Azure platform for data pipelines, ADF, Azure Blob Storage and data lakes. Build workflows to automate data flow using Python and ADF.

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 Databases Models, creating and updating tables and checking the database consistency by executing DBCC commands.

Ability to debug and troubleshoot PL/SQL code using debugging tools and techniques.

Expertise in optimizing the performance of PL/SQL code and database queries.

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.

Published SSRS reports in Report Manager, SharePoint web pages and in custom made ASP.NET web applications.

Implemented cloud solutions for migrating on-prem application ecosystem into Azure VM and AWS EC2. Created Star and Snowflake schemas for Data Warehouse application via AWS Redshift and Azure Synapse.

TFS (Azure DevOps) and GitHub

Created complex stored procedures/execute task, wrote c# hard codes in script task for ETLs, updated and maintained ETL packages with high performance.

AEG Consultant (ETL,SQL, SSIS, Azure)

03/2020– 12/2020

Affine analytics inc.

Washington,Seattle

Worked with off-shore team-members or off-shore clients and vendors, schedule early morning or late evening meetings to meet with them, who are 13 hours ahead of time zone

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 into the data warehouse.

Designed SSRS and PowerBI reports to deliver Daily, Weekly and Quarterly KPIs to end users, clients and senior level management. Maintained and administered dashboards, scorecards, and reports for scheduling data refreshes and for implementing security measures such as Row Level Security (RLS), User mapping, etc.

Performed Data Mapping, Normalization, Batch jobs, Troubleshooting, Data migration, Data collation, Data cleansing, Entity Relationship Design (ERD) model and application-oriented design.

Using SSRS, PowerBI and Tableau reporting tools, created accounting reports included Year-To-Date, Month-To-Date, Period Close reports, Transaction and Snapshot reports for General Ledger, Budget reports, etc.

Knowledge of DAX evaluation context and its impact on calculation results.

Ability to optimize DAX expressions for better performance and faster query execution.

Created both clustered and non-clustered Indexes to retrieve faster the data from the databases. Modified slowly running queries by replacing row by row operations with set-based approaches which implement correct joins, CTEs, Temporary Tables and Window/Ranking Functions.

Designed Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Complex views, Dynamic SQL, Triggers, Cursors and ER Diagrams.

Experience with data modeling, including designing and implementing database schemas using entity-relationship diagrams and normalization techniques.

Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.

Performance Tuning and Optimization using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor and Query Execution Plans.

Managed ongoing design work in accordance with the company’s requests. Optimized database for faster performance.

Created, maintained, and updated ETL packages loading both OLTP and OLAP database tables.

Knowledge of source code management tools such as Git or Subversion, and experience using them to manage PL/SQL code and collaborate with other developers.

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.

Performed Dimensional Modeling for Data Warehousing development using Azure data platform, including Azure SQL, Azure Data Factory, Azure Databricks, Azure SQL, Azure Data Lake Storage, Azure Cosmos DB, SQL IAAS/PAAS/SAAS

Collaborated with QA teams to create Test Cases applications for performance, data integrity, validation issues, job scheduling and other alerts.

Supported Business Analysts and Architects for PowerBi, SSRS and Tableau report writing, from concept to operations, to understand the data quality issues in integration, standardization, harmonization, and its implication on reporting layer.

Senior SQL BI/Database Developer - Team Lead

02/2019 – 03/2020

Boeing Employees’ Credit Union (BECU)

Washington, Tukwila

As a key developer/lead for the project, gathered and analyzed business requirements and translated business needs into long-term business intelligence solutions.

Profound Knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Complex views, Dynamic SQL, Triggers, Cursors and ER Diagrams.

Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.

Expert level skills in Data Mapping, Normalization, Batch jobs, Troubleshooting, Data migration, Data collation, Data cleansing, Entity Relationship Design (ERD) model and application-oriented design

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.

Designed and developed various SSIS packages; Involved in automating SSIS Packages using SQL Server Agent Job, 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;

Provided performance tuning within SSIS packages and SQL Stor Procs, Views, Inline Queries and Dynamic Queries.

Provided support and guidance to other members of the BI team on separate projects; Designed and built Dimensions and Facts; Staged data from various sources for future use in building warehouse Dims and Facts.

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).

Created reports using Power BI Desktop and deployed to Power BI Service to share with end users via Workspaces and Apps which implemented Row Level Security and User Group management.

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

Configured Azure platform for data pipelines, ADF, Azure Blob Storage and data lakes. Build workflows to automate data flow using Python and ADF.

Hands-on experience with AWS cloud solutions such as AWS RDS SQL server, MySQL, Amazon Redshift, AWS EC2, AWS S3 buckets.

Worked on various DAX expressions in Power Pivot based on the business requirement

Understanding of DAX relationships and how to create them for data modeling.

Performed debugging, data analysis and system analysis as required.

TFS (Azure DevOps) and GitHub

BI/Database Developer-Team Lead, (SSIS, SSRS, PowerBI and SSAS)

06/2017 – 01/2019

Northwest Hospital & Medical Center

Washington, Seattle

As a Team Lead of Digital Insight team, delivered the best results to the developmental needs, accomplished successful outcomes by working with SSIS, SSAS and SSRS.

Actively participated in gathering Business Requirements and System Specification. Participated in implementing the logical design to the physical design by creating tables.

Created complex stored procedures, triggers, functions (UDF), indexes, tables, views and other T-SQL code and SQL joins for SSIS packages, SSRS and PowerBI reports.

Experience with DAX in various business intelligence tools, such as Power BI, Excel, and SQL Server Analysis Services.

Designed SSIS packages and Azure Data Factory pipelines to Extract, Transfer and Load (ETL) existing data into Data Warehouse from different source environments such as ERP, CRM, Azure, AWS, and other systems.

Experience in data discovery to data provisioning to Azure ADW and leveraging SSIS to create facts and dims, leveraging ADF to automate and provision data inbound to DW.

Implemented Data Cleansing, Incremental Data Loading, Logging, Event Handling and Error Handling. Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task

Created complex stored procedures/execute task, wrote c# hard codes in script task for ETLs, updated and maintained ETL packages with high performance.

Published SSRS reports in Report Manager, SharePoint web pages and in custom made ASP.NET web applications.

TFS (Azure DevOps) and GitHub

SQL Data Modeler /Database Developer

01/2015 – 05/2017

Sofi Mary

Washington, Bellevue

Developed, maintained, and administered databases of cosmetics website from scratch, sofimary.com using cloud-based technologies such as AWS (RDS, S3 buckets, EC2) and Azure (Azure SQL Paas, Azure VM IAAS, Blob storage, Key Vaults, Azure Data Lakes).

Designed Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Complex views, Dynamic SQL, Triggers, Cursors and ER Diagrams.

Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.

Performed Data Mapping, Normalization, Batch jobs, Troubleshooting, Data migration, Data collation, Data cleansing, Entity Relationship Design (ERD) model and application-oriented design.

Performance Tuning and Optimization using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor and Query Execution Plans.

Managed ongoing design work in accordance with the company’s requests. Optimized database for faster performance.

Created, maintained, and updated ETL packages loading both OLTP and OLAP database tables.

ETL Developer

06/2012 – 01/2015

Banner Bank

Washington, Walla walla

Developed SSIS packages for File Transfer from legacy systems to upgraded application backend systems, Data flow task, File system task, Execute SQL task, and FTP task and modified the packages accordingly using the advanced features of SQL Server Integration Services.

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

Designed ad hoc SSRS reports in the test environment for data validation utilized SQL Server 2012.

Developed and deployed database objects such as stored procedures, triggers, indexes, views, and UDFs in SQL Server.

Modified temporary tables, indexes, and lookup techniques to optimize stored procedures.

Created SSIS packages for data loading utilizing various tasks and transformations (such as execute SQL task, script task, execute package task, data flow task, fuzzy lookup, lookup, OLEDB command, derived column etc.).

Extracted and loaded data from multiple sources (Excel, flat files, SQL Server, Oracle) to the staging area.

Repaired SSIS packages with checkpoints, breakpoints, and data viewers.

Created SSIS packages utilizing different transformations in SSIS toolbox such as aggregate, Merge, and Merge join.

Maintained and updated server-side programming with Java, JavaScript through Node.Js to build fast and scalable server-side applications.

Education

BS in Tashkent University of Information Technologies with concentration in Data Analytics Jul 2006

Contact this candidate