Sql Server Data Warehouse

Professional Summary

More than * years of experience in Software Analysis, Design, Development, Testing, and Implementation of Business Intelligence/Data Warehouse Solutions using Microsoft SQL Server

Designed ETL packages using proper Loggings and Checkpoints, secured packages with Encryption in conjunction with passwords.

Responsible for designing test cases for testing the ETL packages.

Designed SSIS packages using various Transformations such as Fuzzy Lookup, Fuzzy Grouping, Aggregate and Derived Column Transformations.

Experience in Error Handling and Debugging packages using Checkpoints, Data Viewers, Breakpoints, Event Handlers and Loggings (SSIS or Custom Loggings).

Performed data cleansing using different transformations within SSIS packages to eliminate redundant data from the pre-staging database.

Extensively worked on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema.

Hands on experience with Erwin to forward and reverse engineer data models.

Actively involved in the enterprise Data Warehouse designing using Kimball design methodologies and following DW Design best Practices.

Created Indexes, Views, Index views, Constraints, Stored Procedure, User-Defined functions, CTEs, and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency.

Experienced in all the stages of Software Development Life Cycle and in the migration and up gradation of databases.

Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization.

Monitored and tuned the performance of Complex T-SQL queries and stored procedures by analyzing the execution plan and using tools like SQL Server Profiler.

Involved in Staging Partitions and Usage Based Optimization (UBO) mechanisms for SSAS and OLAP databases.

Optimized cubes by assigning appropriate storage modes to partitions and created usage-based optimizations for better query performance.

Worked on data import from different file systems including XML, text, and CSV and Excel files.

Created partitions on tables, indexes and index views as well as querying and managing partitions from optimization point-of-view according to the business criteria.

TECHNICAL SKILLS

RDBMS

SQL Server, Azure SQL database, Oracle

Languages\Tools

T-SQL, C#, PowerShell, XML

Modeling Tools

MS Visio and SQL Server Data Modeler

ETL Tools

SSIS, Azure Data Factory

Reporting Tool

Power BI, SSRS

Analysis Tools

SSAS (Tabular and Multi-Dimensional)

Other skills/tools

Agile Methodology, GitHub, Jira, MS Excel

Professional Experience

Wells Fargo

02/2022 - Present

SQL /ETL Developer

Responsibilities:

Involved in requirement gathering, understanding, and validating the project specifications.

Developed and maintained documentation in the process of bug fixing and Enhancements to all the applications that are part of support responsibilities.

Implemented all phases of Software Development Life Cycle SDLC involving Systems Analysis, Design, Development and Implementation.

Worked on building SQL queries for Data manipulation and for also creating DQL objects like tables, triggers, stored procedures, views and more.

Worked on adding more data integrity check to the existing database and for the newly added SQL objects.

Optimized the long running Stored Procedures by rewriting the script, created temp table and indexes, recompiled stored procedure, updated statistics and make the process simpler and faster.

Created and managed Clustered Indexes, Non-Clustered Indexes, and Index fragmentations.

Developed SSIS packages for Uploading of different formats of files and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).

Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems.

Involved in designing and developing Data Warehouses, Data Marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for generating reports using SSRS.

Implemented SSIS packages to perform ETL data messaging operations (data profiling, cleansing, and verification).

Implemented package configurations on development, test, and production environments utilizing parameters. Designed, Developed and Deployed custom reports in MS SQL Server environment SSRS.

Designed packages in SSIS with various complex transformations such as derived column, conditional split, lookup, aggregation, execute SQL task.

Created user variables, property expressions, script task in SSIS.

Implementing various SSIS packages having different tasks and transformations, developed Incremental Load using Lookup and scheduled SSIS packages.

Developed SSIS packages to make sure that Item rename data is refreshed daily and all the orphan records are cleared. Involved in creating multiple parameterized stored procedures used by SSRS reports.

Create scripts for test cases in Development and QA environments and make sure that the test results are as expected according to the Business Requirements Document/Functional specifications.

Developing complex data integration workflows in SSIS to transform and load data into DW.

Ensuring data quality, accuracy, and consistency throughout the ETL process.

Writing and optimizing SQL queries and PL/SQL code to interact with the Oracle database.

Review and provide feedback on project deliverables, Capacity Maintenance and Weekly status updates to Team and Business.

Implemented code check-in/check-out and managed multiple versions of complicated code within TFS.

Environment: SQL Server, SQL Server Management Studio (SSMS), Oracle, MS BI Suite (SSIS/SSRS), SQL Server Data Tools (SSDT), Visual Studio, MS Office Suite 2010 (Excel, PowerPoint, Word), Tableau, Agile/Scrum, JIRA, Microsoft Visio

Kroger

02/2017 to 02/2022

Database Developer

Responsibilities:

Design and develop ETL process to integrate data among business systems and Data warehouses in MS SQL Server.

Develop physical data models using ERWIN and create DDL scripts for database schema and objects.

Maintain and develop system integrations among enterprise front and back-end applications (ERP, CRM, EDI, Demand Planning, Manufacturing Control Systems)

Extracted data from data sources Oracle, CSV files, text files, SQL-Server and applied required transformations to clean the data.

Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.

Worked with SQL Profiler for troubleshooting, monitoring and optimization of SQL Server and T-SQL code.

Check daily jobs and verify databases in order to ensure the correct flow of data from different systems like IFS (Industrial and Financial Systems) which is a Oracle Financial ERP system for Silgan, WMS (Warehouse Management system), Pivotal system which holds retail and distributor data.

Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2014.

Design, code and test and trouble shoot business reporting for end users in Business objects Crystal Reports, SSRS and Tableau.

Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.

Created Dashboards with interactive views, trends and drill downs.

Published Workbooks and Dashboards to the Tableau server.

Developed Flowcharts with Visio/VBA/Excel/SQL, which was used in storing Flowchart elements.

Environments: SQL Server, SQL Server, DTS, SQL Server, SSDT, Informatica, Microsoft Visual Studio, MS Excel, MS Access, Windows Server, Crystal Reports, Tableau, Oracle, Power BI

Contact this candidate