Sql Server Azure Data

Over *+ years of IT experience in building Data intensive applications (Reliable, Scalable and

Maintainable) through standard building blocks that provide commonly needed functionalities.

(Databases, Caches, Search Indexes, Stream processing and Batch processing) Conjured up a plan for migrating existing legacy data warehouse solutions to a modern enterprise analytics solution using Azure Synapse Analytics. Worked on Lift and Shift and Redesign strategies of migration.

Experienced in Data integration and orchestration to integrate data and operationalize code development, Converting physical data marts to virtual data marts – reduce the total cost of ownership and improve agility of the reporting application.

Experience in SQL Server Business Intelligence and Azure Data Analytics to deliver modeled data to Data Warehousing, big data analytics, BI and AI tasks. Design and operationalize Azure Synapse pipelines developed through Azure Data Factory for data ingestion and orchestration, directly explore data in Azure Data Lake Storage. Strong Project management experience from various applications. Key activities include Delivery Excellence, Capacity Planning, Team/Resource Management, Project Tracking & Change Management, Risk analysis, Contingency Planning, Project Scheduling & Resource levelling and Requirement Analysis. Expertise in SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services), Power BI, Power Pivot and Tabular Model, DAX, MDX queries. Implemented ETL workflow packages using SQL Server Integration Services (SSIS) to extract, clean, transform, and load data into the data warehouse.

Developed OLAP cubes using SSAS (SQL Server Analysis Services) and calculated the metrics that were revealed in the functional analysis.

Experience in Designing, Creating and processing of cubes using SSAS. Created and Configured Data Sources and Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s, Hierarchies and calculated measures for OLAP cubes.

Worked on SQL Server Reporting Services in generating parameterized, linked, drilldown and sub reports.

Very good communication, analytical, interpersonal, presentation skills and Team skills combined with self-motivation, initiative and the ability to think out of the box and worked as lead to carry out deliverables.

KUMARI SAPANA MODIWAL

SQL/ETL DEVELOPER

214-***-**** **************@*****.*** Irving, TX 75039 SUMMARY

SKILLS

Databases: MS SQL Server 2022/2019/2017/2016/2014, Oracle 10g/9i/8i, DB2 Methodologies: Agile, Scrum

Cloud: Azure SQL Database, Azure Synapse Data Warehouse, Azure Data Factory V2, Azure Data Studio, Azure Synapse Studio, Azure IAM, Azure Key Vault, Azure Synapse Link for Azure Cosmos DB, AzCopy command line tool, Azure Data Box and SqlBulkCopy API. Business Intelligence Tools: SQL Server Data Tools (SSDT), SQL Server Integration Services (SSIS), SQL server data tools using Visual Studio, SQL Server Reporting Server (SSRS) Languages: SQL, T-SQL, PL/SQL, C#

Applications: MS-Office, MS-Project

Operating Systems: DOS, Windows UNIX, LINUX

Visualization Tools: Power BI

Technical Environment: Microsoft SQL Server 2022 Enterprise Edition, Azure Synapse, Azure Data Factory V2 and GIT.

EXPERIENCE

State Farm Insurance - North Metro, GA 30029

Data Engineer

Oct 2022 to Present

Re-engineered legacy data warehouse evolved over time to migrate data warehouse data model on Azure Synapse Analytics using redesign strategy.

Reduced the complexity of existing legacy data warehouse before migrating, been aware of all ways to simplify existing data warehouse and document them. Removed and archived unused tables before migrating, avoided data which is no longer is use, helped to reduce the overall data volume to migrate.

Converted physical data marts to virtual data marts, minimized what to migrate to reduce the total cost of ownership, Optimized redundant dimension, measures into unified entities by remodeling schemas. Re-designed existing SSIS ETL packages in the Azure Data Factory Pipelines to load data from multiple sources and staging sinks, Populating data from staging to Azure Synapse. Programmed API calls to Azure Data Factory APIs to orchestrate nightly loads of Data Warehouse and Data Marts.

Prepared checklist to help collect necessary information to validate migration – Row counts, tables and indexes, Data compression ratios, Partitions, Types and Code objects (Functions, Stored procedures). Working on Postman, Gateways, JWT Tokens, Oauth Protocols as part of debugging API request payload and response codes, Registering Clients in Azure Entra ID (Active Directory) and Fetching Client Secrets from Azure Key Vault.

Explored Azure ExpressRoute to make private connection between on prem sources and Azure Data centers, AzCopy, Azure DataBox and SqlBulkCopy API to copy files and blobs to/from storage accounts.

Handled common migration issues and resolutions, Unsupported data types and workarounds, Integrity constrain differences, SQL incompatibilities and resolutions. Implemented Dynamic Data Masking (DDM) used to obfuscate data, Encryption using TLS and SSH. Been part of DevOps team to guide deployment strategies and plans using ARM template, Integration Run-times and Python scripts.

HCL Tech - Frisco, TX 75034

SQL/ETL Developer

Aug 2021 to Sep 2022

Played key role as team lead with interaction with Stake holders, Business Analysis, Understanding Requirements, and Converting Business Requirements into Technical Solutions. Responsible for preparing high-level and low-level design documents for change requests and bug fixes. Translated requirements, designs, and functional specs into use case documents. Technical Environment: SQL Server 2019, SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), C#, SQL Server Analysis Services (SSAS), Microsoft Visual Studio 2019, IIS, C#.Net, Power BI, T-SQL, Windows Server 2022.

Involved with the full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.

Analyzed source data to determine the data model and ETL solution that will meet business requirements.

Integrated Database Maintenance jobs to perform Full, differential & transaction log Backups and scheduled them with the SQL SERVER agent job scheduler. Worked in designing and optimizing various T-SQL database objects like tables, views, stored procedures, user-defined functions, indexes, and triggers. Enhance existing stored procedures, views, functions, and database objects to meet additional requirements of the latest releases, Involved in the performance tuning of table-valued functions. Administering SQL Server security, SQL Server automatic email notification. Managed SQL user logins, database user accounts, server roles, database roles and its permissions. Handle lock scenarios.

Handled PowerBI dataset refresh through Azure Data Factory pipelines and SnowFlake tasks. Developed Power BI Dashboards by implementing multi source data integration, Utilized DAX language to define Measures, Slicers and Filters etc.

Vayodha Hospital - Kathmandu, 44600

SQL/SSIS/SSRS DEVELOPER

Jun 2020 to Jul 2021

Worked closely with business analyst as a senior SQL developer to understand and translate business requirements into technical documentation such as high level and low-level design specification documents, database schema and mapping documents

Implemented DataWarehouse scaling using Data Vault 2.0 schema in DataWarehouse to support Scaling and ease of implementation.

Developed Dimension and Fact as a views in the DataMart layer of DataWarehouse, built interrelated Data Marts using Database and Views. These Datamarts are consumed by REST APIs for next generation reporting tools and dashboards.

Tuned the database to perform efficiently by managing databases using the options to grow or shrink database files and monitor the size of the transaction log. Developed complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.

Optimized stored procedures and long-running scripts using execution plan, temp tables, and code rewriting and indexing strategies to increase speed and reduce run time. Programmed SQL statements which include joins and functions.

Worked extensively on SQL System Defined Functions and User Defined Functions. Involved in complete SSIS life cycle in creating SSIS packages, building, deploying, and executing the packages in both the environments (Development and Production) Performance tuning and optimization of procedures and queries and Involved in the tuning of the existing Database Objects.

Coordinating with offshore team for on time delivery of products and query resolution activities Technical Environment: MS SQL Server 2017, MS office 2013, T-SQL, SQL Server Query Analyzer, Microsoft SSMS, Visual studio 2017, Power BI, Team Foundation Server, Windows Server 2016 IT Himalaya Pvt. Ltd - Kathmandu 44600

Jr. SQL Developer

Feb 2019 to May 2020

Involved in writing stored procedures for both Online and Batch requests handling business logic and Functionality of various modules.

Extensively used T-SQL in constructing Stored Procedures, Common Table Expressions (CTEs), User Functions, Indexes, User Profiles, Relational Database Models, Data Dictionaries, triggers, cursors, tables, views, and other SQL joins and statements for applications. Involved in source Data Analysis, Design, and Creation of Data Mapping for Extraction o bulk data from heterogeneous sources like Oracle, ADSI, and other OLEDB data sources. Worked with various upstream and downstream systems and customers in interfacing various systems for Data extractions, ETL, Analytics, and reporting needs. Developed SQL scripts to load the custom data into Development, Test, and Production Instances using Import/Export. Created scripts to create custom Tables and Views. Programmed highly complex TSQL Queries and SQL Scripts to perform efficient data load based on complex Business rules. Extensively used TSQL to manipulate and architect to produce results for business users.

Defined multiple join statements to retrieve data from multiple tables. Tuned several slow-running queries in Production. Implemented Indexes to achieve time Performance. Tuned the performance of SQL queries and stored procedures using SQL Profiler. Advised optimization of queries by looking at the execution plan for better tuning of the Database Technical Environment: SQL Server 2016, T-SQL, C#, MS Office, Windows Server 2016. EDUCATION

Master’s Degree

Contact this candidate