Sandeep G.

Sr. SQL Server Designer/Developer

Chicago , United States

Experience: 7 Years

Sandeep

Chicago , United States

Sr. SQL Server Designer/Developer

66000 USD / Year

Immediate: Available

7 Years

Now you can Instantly Chat with Sandeep!

Chat Now

About Me

7+ years of experience in project design, analysis, development, and management using Microsoft SQL 2005/2008/2012.
Expert in Microsoft Business Intelligence technologies including MS SQL Server Integration Services (SSIS), MS S...
Proficient in database modelling for OLTP, Data Marts, Operational Data Store (ODS), and OLAP.
Created and published reports using SSRS, Report Builder, Report Designer, and Report Manager.
Proficient in writing complex T-SQL queries using Inner, Left, Right, Outer, and Cross Joins.
Involved in designing and building OLAP dimensions and cubes using SSAS.
Experience in defining queries for generating drill down reports in SSRS.
Experience in iterative and incremental software development.
Experience in installing, upgrading, and configuring MS BI pack.
Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
Good knowledge in database and Data warehousing concepts.
Excellent skills in creating SQL objects including Tables, Stored Procedures, Views, Indexes, Cursors, DDL/DML Triggers, Temporary tables, User Defined Data types (UDF) and Functions.
Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.
Experience in migration of data from Excel, Flat file, and Oracle to MS SQL Server by using MSSQL Server DTS and SSIS.
Worked on OLAP Data warehouses, modeling, design, and cube development including KPIs, working with slowly changing dimensions.
Experienced in creating Perspectives, Partitions, Roles and Groups, Design Aggregations, Key Performance Indicators (KPIs) in cubes, working with Multidimensional Expressions (MDX) using SSAS.
Developed various business reports. Reports are provided in PDF-format, HTML-format, and can be printed directly to the specified printer.
Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model, and ad-hoc reporting using Report Builder.
Worked extensively in developing DTS packages in SQL server 2000
Experience in defining Query for generating Cross-Tab, Conditional, Drill-down, and Sub reports.
Experienced in writing scripts for Automation Testing on QTP and Selenium.
Provided 24x7 production support to Batch, continuous flow process for daily, monthly, and weekly job schedule

Skills

Portfolio Projects

Description

Installed SQL 2016 SQL server Database engine, SSIS & SSRS features in the Development environment as needed.
Experience in dealing with ambiguities to create rational and functional solution from imperfect requirements
Performed DB ADMIN activities on the Server by taking Back-up & restoring the DB, providing user access privileges, creating linked servers.
Responsible for extracting the data from OLTP and OLAP using SSIS
Worked with various tasks and transformations in Control flow and Data flow items
Developed SSIS packages that can extract data from various sources and merge into one only source for Power BI reports
Experience in creating and managing SSAS Tabular models, creating Dimension and Fact Tables
Worked in Creating DAX Expressions and implement Partitions in Tabular models
Created shared dimension tables, measures, hierarchies, levels, cubes, and aggregations on MS OLAP/ OLTP/Analysis Server (SSAS) in Tabular Model.
Implemented Copy activity, Custom Azure Data Factory Pipeline Activities
Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell
Created C# applications to load data from Azure storage blob to Azure SQL, to load from web API to Azure SQL and scheduled web jobs for daily loads
Experience in publishing the Power BI Desktop models to Power Bi Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets
Incorporated filters to narrow down data presented and slicers for appropriate user interaction, conditional formatting to spotlight alarming or profitable numbers
Created notifications and alerts, subscriptions to reports in the Power BI service
Wrote Kusto queries to pull telemetry data for analysis
Used R to extract the data from Cosmos and load it into SQL database
Knowledge of managing security and metrics of the data presented using the Admin portal
Used Visual Studio Team Services (VSTS) for version controlling, assisted in documentation, and creating data dictionary

Show More Show Less

Description

Working as Azure SQL developer maintaining the database, pull the data from blog storage loaded into the SQL Data warehouse.
Creating pipelines Azure Data Factory jobs and Schedule to import the data from legacy to Cat Digital Platform
We are recently Upgraded to Microsoft Azure Version 2.0 to create automatic alerts to developers notify if any pipelines failed or we are not receiving data it will notify the root cause.
Involved in Deployment, Design, testing on premises Azure Environment
Designed ETL packages and Workflows with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
Extensively worked on the packages created including a variety of transformations, for example Slowly Changing Dimensions, Lookup, Aggregate, Audit, Conditional Split, Merge join, Multi Cast, Pivot, OLE DB Command, Sort, Union All, and Copy Column, Derived Column using SSIS.
Created jobs using SQL Server Agent and scheduled them to execute the SSIS Packages on a predefined time interval by the business
Created C#.Net Script for Data Flow & Control Flow Error Handling using Script component in SSIS.
Maintaining, enhancing, and developing architecture of our platform
Extensively used Execute SQL Task, Data flow Task, Look up, Script logic component, Union All etc. in SSIS.
Responsible for Migrating the SSIS packages from 2005 to 2008.
Involved in extensive data analysis on the Teradata and Oracle systems querying and writing in SQL and TOAD.
Exposure creation of different kinds of reports Audit reports, Fixed income Reports, Sales Forecasting reports, Revenue reports and Decision-making reports.
Taking Backup to cloud Storage Account using Cloudberry Cloud Storage Tool
Worked on Migrating from SQL Server 2008R2 to SQL Server 2012
Created and Published Tableau Dashboards into Tableau Server.
Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS and Power BI
Wrote complex SQL queries using joins, sub queries and correlated sub queries & power queries to retrieve data from the database which should be displayed in various forms.
Developed MS Excel dashboards for executive data management presentations of procurement and supply chain metrics and KPIs.
Generated Sub-Reports, drill down reports, drill through reports, Tabular Report, Crystal, and Parameterized reports using SSRS.
Created Stored Procedures, User Defined functions, Views and implemented the Error Handling in the Stored Procedures and SQL objects and Modified already existing stored procedures, triggers, views, indexes depending on the requirement.
Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
Configured Checkpoints on SSIS packages so that the package would restart from the point of failure.
Configured SQL mail agent for sending automatic emails when SSIS package fails or succeeds.
Successfully deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
Used the SSIS Configuration files to make the packages connections, variables etc. configurable and maintained the same on Test and Production environments.
Involved in the implementation of Performance Point Server (PPS).
Modified OLAP Cubes to add Dimensions, Creating User Defined Hierarchy, created new calculated members using MDX and DAX Expression as per the business requirement.
Administered user, user groups, and scheduled instances for reports in Tableau.
Designed cubes with star schema using SQL Server Analysis Services (SSAS).

Show More Show Less

Description

Created Various Reports using SSRS i.e. Drill Down, Drill Through, Sub Reports, Charts, Tabular, Matrix and Linked reports from Database Objects.
Migrated and Deployed SSRS Reports (2008 to 2012) to SharePoint and provided Security and Subscription to various Users.
Creating and managing scheme objects such as tables, views, Indexes, Procedures, triggers and maintained Referential Integrity.
Handling IT support tickets with Issue resolution or customer requests from various levels.
Provided expertise, skills and training to effectively support customers of new and existing information systems within the organization.
Performing Unit and Integration Testing on the Development and Test Servers.
Participated in the review of Technical, Business Transformation Requirements Document.
Created C#.Net Script for Data Flow and Error Handling using Script component in SSIS.
Extensively used Execute SQL Task, Data flow Task, Look up, Script logic component, Union All etc. in SSIS packages.
Used the SSIS Configuration files to make the packages connections, variables etc. configurable and maintained the same on Test and Production environments.
Involved in the implementation of Performance Point Server (PPS).
Developed various forms of outputs like RTF, HTML, PDF files using SAS ODS facility.
Modified OLAP Cubes to add Dimensions, Creating User Defined Hierarchy, created new calculated members using MDX Expression as per the business requirement.
Worked on Migrating from SQL Server 2008R2 to SQL Server 2012.