Sql Server Business Intelligence

SHIVANI JOSHI

SQL/ETLDEVELOPER

PROFILE SUMMARY

Five years of IT Experience in Database Design, Development and Implementation of Microsoft SQL Server and Business Intelligence tech stack in Development, Test and Production Environments with various business domains such as Financial, Retail and Healthcare.

Strongly experienced on SQL Server as a Developer, experience includes Database Design and Development, Confidential BI Solutions, ETL Development, Data warehouse Implementation, Report Development using SSAS, SSIS, SSRS and TSQL.

Highly experienced in Data modelling, Entity relationships and Database normalization (up to 3rd normalization form).

Translated business requirements to physical data models, designed data element & created quality sets of metadata to achieve strategic goals.

Highly experienced in Data modelling, Entity relationships and Database normalization (up to 3rd normalization form).

Implemented Star Schema, Snowflake Schema models in Data Warehouses and Data Marts. Designed different types of Fact & Dimensions tables along with their ETL packages.

Implemented Slowly changing dimensions up to Type 3 and developed Late Arriving dimension and fact scenarios during data load from Staging to Data Warehouse

Implemented Integration Runtime deployments using Python scripts to bring the onPrem data to Azure SQL database using Azure Data Factory pipelines, calculated DIU and DTU required for the nightly data transfer.

Experience in publishing Power BI Desktop reports created in Report View to the Power BI Service.

Skilled in design of logical and physical data modeling using Erwin data modeling tool.

Expertise of Data Marts, Data warehousing, Operational Data store, OLAP, Data modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-flake Modeling, FACT, and Dimensions Tables using MS Analysis Services.

Experience in Other DBA activities like creating Tables, Complex views, and Database links.

Created Stored procedures for generating reports using SQL Server Reporting Services(SSRS).

Experienced in creating custom columns and measures using DAX, developing Page level Reports, Dashboards, dynamic Navigation bars & Stories in Power BI.

Involved in collaborating with Database Architects for Basic data warehousing design and developing ETL logic for moving data into data warehouse.

Implemented Azure Data Factory Integration Runtimes to execute SSIS packages, collecting On Prem data scenarios, Parametrized Linked Services and re used existing Data Sets across most of the activities in a Pipeline.

Holds good knowledge of SSAS Concepts like – Creation of cubes, Dimension/Fact Tables, Deployment process and knowledge about creation of Power pivot and performance considerations in T-SQL.

Experience in creating packages, jobs, sending alerts using SQL Mail and extended stored procedures.

Experience in Configuring and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational database such as Oracle and DB2.

Experience in Creating and Updating Statistics to improve the SQL Server Performance.

TECHNICAL SKILLS

Programming Skills: T-SQL, C#, Python, C, C++

Databases: Microsoft SQL 2022/2019/2016/2014, MS ACCESS, Oracle, Postgre MS Access, Azure SQL Database

BI and ETL Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS SQL Server.

Reporting Tools: Microsoft SQL Server Reporting Services (SSRS), Power BI, Tableau

Database Design Tools and Data Modeling: SQL Server Integration Services (SSIS), Microsoft Vision

Operating Systems: Microsoft Windows

Tools and Utilities: Agile, Jira, Waterfall, SQL Profiler, Azure Repos, Git, Visual Studio 2013/2019.

EDUCATION:

PH.D

CERTIFICATIONS:

Google IT Support Professional Certificate (coursera) (2020)

Health Information Technology Certificate, Harford Community College, MD(2024)

Certified Professional Coder (Medical Coder) by AAPC (2024)

EXPERIENCES

SQL/ETL Developer (Oct 2023 To Present)

Santander Bank, Boston, MA

Actively involved in all the phases of Software Development Life Cycle (SDLC).

Created detailed design and requirements documents with logic to help team members understand the requirements and design.

Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into enterprise data warehouse (EDW).

Dealt with a variety of data sources including OLEDB Oracle Source, XML sources and Flat File Sources.

Working on Data profiling of source data from numerous sources to check data granularity, feasibility and pattern across sources.

Implemented Change data tracking mechanism using Change Data Capture through Database Change Tracking feature of Microsoft SQL Server for the SQL Server source systems.

Working on designing staging database and related ETL / ELT along with data flows from various data cleaning and massaging phases.

Responsible for preparing high level and low-level design documents for change requests and bug fixes.

Designed ETL for implementing Slowly Changing Dimensions in order to maintain historical data.

Created configuration files to deploy SSIS packages across all environments.

Used SSIS Script Task to write C# Code Snippets to generate error reports to be sent out.

Coded in C#.Net for Assigning Values to objects dynamically and checking for conditions.

Created the complex stored procedures, user defined functions to encapsulate the business logic.

Created views, indexes, and user defined data types and implemented the cursors, triggers as needed.

Worked on building, designing and maintaining Cloud – Azure SQL Database instance (PaaS offering), Preparing foundation of data that used by Data Scientist team for research and reporting.

Implemented Azure Data Factory Integration Runtimes to execute SSIS packages, collecting On Prem data scenarios, Parametrized Linked Services and re used existing Data Sets across most of the activities in a Pipeline.

Involved in performance tuning of queries using query execution plans, SQL Profiler and also DMVs.

Responsible for creating the reports using the SQL server reporting services.

Created various types of reports including drill-down, drill-through, cascaded parameterized reports and sub-reports.

Extensive experience in designing, developing, and delivering business intelligence solutions using Power BI, SQL Server

Worked extensively on the data changes as per the user specified improvements on each release of the application build.

Environment: SQL Server 2022, SSIS, SSRS,T-SQL, Visual studio 2022, C#.NET, XML, JSON, ARM Templates, Terraform Scripting,Python Scripting, ER Studio, Visio, Microsoft Visual Source Safe, Microsoft Share point Portal Server.

SQL/ETL DEVELOPER (Apr 2021 To Sep 2023)

UCARE, Minneapolis, MN

Performed the physical database analysis and feasibility requirements. This involves the performance, security, archival, maintenance, and recovery requirements

Designed and developed logical database and converted into physical database using Erwin

Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them.

Used Execution Plan and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Tuning Queries and Database performance using tools Database Tuning Advisor, SQL Server Profiler.

Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

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

Created jobs and alters to execute SSIS packages automatically as well for reporting services.

Supported advanced efficient data retrieval and manipulation by creating indexed view and triggers.

Successfully implemented indexes on tables and views for optimum performance tuning.

Supported some business specific relationships, and advance constraints by embedding triggers on tables.

Created complex SSIS packages using transformations /tasks and designed packages with error handling and package logging that stores the logging results in SQL table and flat files on error, on warning, on task failed event types.

Developed the chart type, Tablix, matrix reports in SSRS (SQL Server Reporting Services) like enrollment status, Financial Aid, Degree Objective from the OLAP system.

Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.

Involved in modifying report content and exporting reports in multiple formats based on the business requirements.

Designed and implemented Parameterized and cascading reports using SSRS.

Environment: Microsoft SQL Server 2019 Enterprise Edition, MS SQL Server Management Studio, MS SQL Server Business Intelligence Development Server (BIDS).

Jr. SQL Developer (Feb 2020 To Mar 2021)

Heritage Bank Bellingham, WA

Programmed logic and code as per business requirements, performed reviews to advance application upgrade, extension, or other development. Analyzed application for data integrity issues.

Developed complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, and other database objects as per the business requirements

Assisted on the Ad hoc-Query Requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.

Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs. Performed Performance Tuning of the Stored Procedures and Experience in trouble shooting database issues.

Developed logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS

Automated SSIS Packages using SQL Server Agent Jobs and Windows Scheduler.

Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.

Analyzed and resolved performance issue with database code involving SSIS and MS SQL Server.

Extracted and analyzed data using Power Query, PivotTables, MS Excel, Power BI and SSAS.

Responsibilities taken as a production support Developer for applications as on needed basis.

Developed Unit test cases and perform Unit testing and system testing of assigned components.

Environment: SQL Server 2016, SSIS, SSRS, Crystal Reports,Microsoft Excel, BIDS, Toad For Oracle 10g.

252-***-**** ************@*****.*** Concord, NC 28027

Contact this candidate