SUMMARY:

• Database Developer / Analyst with extensive experience in MS SQL Server and Confidential ’s suite of products like SSIS, SSAS, and SSRS, Power BI and Confidential Azure.
• Create pipelines and schedule activities using Azure Data Factory.
• Write queries using T - SQL, create and manage various database objects like Stored Procedures, Views, Functions, Indexes, Logins, and Triggers etc.
• Design and develop OLAP Cube, Facts and dimensions using Snowflake Schema, Star Schema and scheduling the SSAS Cube Processing using SSIS.
• Design Tabular Data Models and Creating Measures using DAX queries.
• Create Power BI reports using Power BI Desktop and publishing them to Power BI Site.
• Load data from Tabular data models and create reports in Excel.
• Experience designing database, creating the Logical and Physical design of database using tools Erwin data Modeler and Confidential Visio.
• Use Temporal tables and implementation of Row-Level Security in SQL Server 2016
• Experience using Query Tuning using tools like SQL Server Profiler and SQL Query Analyzer
• Experience handling Database Migration Activities.
• Database Administration Activities like Backup and Restore, Implementing Security, change data Capture, configuring Recovery models, configuring different Replication Procedures - Snapshot and Transactional, Installation and Configuration of SQL Server, Setting up Linked Server Connectivity.
• Experience in scheduling the Rebuilding and reorganize Indexes based on the Index Fragmentation percentage.
• Expertise in Setting up ETL packages which fetches data from various sources like OLAP/ODS/SQL to SQL server/Excel/Access/Text file destination using various transformations.
• Experience in writing C# Scripts for Script Component tasks in SSIS.
• Develop Parameterized Reports using SSRS & Creating Reports using Report model and Report Server Templates.
• Write Scope Scripts to handle multi-million rows and for daily loading data from COSMOS Server and scheduling the data load using DataGrid.
• Write Kusto (KQL) and Cosmos Queries (SCOPE) and publish the data into Power BI
• Manage offshore and onsite resources, working with large and collaborative teams and successfully participated in diversified implementation partnering projects.

TECHNICAL SKILLS:

Databases: SQL Server 2012/2008/2005/2000/2014/2016/ SQL Azure, MS Access, Kusto

Programing Languages: T-SQL, MDX, SCOPE, HTML, XML, C#, Scope, KQL

ETL Tools: Azure Data Factory(ADF), SSIS (SQL Server Integration Services), DTS (Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

Database Tools: SQL Query Profiler, Database Engine Tuning Advisor, Confidential Visio

Other Software: Xflow, DataGrid, Visual Studio Online, Visual Studio TFS, Visual Source Safe, MS Office, MS SharePoint 2010, Perforce, JIRA

PROFESSIONAL EXPERIENCE:

Confidential

Cosmos/SQL-BI Developer

• Responsible for Monthly releases and sync up with Client and Offshore Team.
• Wrote Scope Scripts in Visual Studio IDE and schedule them for daily load into SQL Server database using DataGrid by Creating Credentials in XFlow.
• Developed and Scheduled Data Load jobs in Data Studio Tool/Cosmos UI using Scope Scripts from both Structured and Non-Structured streams.
• Worked on NGP Onboarding to Implement Delete Processor in Cosmos/Azure SQL
• Created Web Jobs on Azure Portal to Schedule Delete Agent for SQL Azure
• Designed Tabular Data Models and created calculated measures.
• Created Power BI Reports and worked on Adhoc updates to existing reports.
• Used Kusto Explorer to write Kusto queries which are used in Power BI Reports.
• Created Power BI Reports by loading data from Tabular Data Model/SQL Server.
• Created Org Related reports in Excel by pulling the data from Kusto and SQL.
• Created Pipelines, jobs for Data Flow using Azure Data Factory.
• Responsible for monitoring the DTU% and resources used by SQL Databases in Azure.
• Created Database objects like Stored Procedures, functions, tables based on the requirements.
• Designed Cubes with Snow flake & Star Schema and was responsible for regular processing of cubes.
• Wrote T-SQL Queries for Data Analysis.
• Created reports in Excel by loading data from Tabular Data Model.
• Troubleshot Power BI Dashboards.
• Created Mapping Documents from Source to destination which helps in easier transition for Source change.
• Created C# Scripts for SSIS Packages in Control Flow Tasks.
• Created automating Excel Reports Refresh and Logging using VBA Code.
• Implemented Row Level Security on tables and worked on creating temporal tables to track history.
• Developed solutions to monitor the SQL Jobs, trouble shoot them from UI which would reduce the task load of a DBA.
• Responsible for overall performance of Database, hence ensured that all Stored procedures were tuned and developed jobs for Index Rebuilding to avoid fragmentation Overheads, Space availability.
• Responsible for project management activities like Task management using TFS, preparing Weekly Burn down
• Responsible for checking in Database and Data warehouse solutions into Source Control (TFS) and VSO.
• Designed the database and OLAP cubes and maintained OLAP Mapping document.
• Created ETL Solutions using SSIS for incremental/full data loads from OLEDB data source/ file source to OLEDB Destination using various transformations, for Processing of OLAP cube periodically, for database maintenance Plans.
• Created Excel Pivots which are connected to Analysis Servers for Data Analysis and Power Pivot reports with data loaded form Cubes by using MDX queries.
• Technologies: Kusto, Scope, SQL Server 2008/2012/2016/ Azure, SSIS, SSAS, MS Excel, SQL Profiler, COSMOS, C#, Siebel,

Confidential

SQL Developer

• MDP - Master Data Profiles Team works on Indexes and Securities data, by working closely with the business to create reports/Stored Procedures to meet their data needs.
• Created stored procedures as per the requirement.
• Created JIRA Cards for work items, update it as per the work flow.
• Created Reports in PowerBI Suite and SSRS and responsible for any new updates/fixes to the existing reports.
• Responsible for ad-hoc Code fixes.
• Maintained SSAS Cube and addition/modifications of any Dimensions and Measures.
• Performed Data Analysis to compare the data between different systems.
• Implemented Temporal Tables to track history.
• Worked on Performance Tuning the Stored procedures, Views and Other Objects.
• Used SQL Profiler and Query Analyzer for Query Optimization.
• Responsible for providing security on database and database related objects.

Confidential

Database Developer

• Confidential HRIS Department deals with Employee, Recruitment and other related data. Daily load is consumed from Workday into HRIS Databases and reports are built on top of it. Daily Work requests are created in JIRA and are assigned accordingly.
• Responsible for loading XML data Files into SQL Server.
• Created Stored procedures which would read the data from XML Files and load the data into SQL Server tables.
• Created Power BI Dashboards for HR Related Reports.
• Extensively worked on Power View and Power Map Features in Excel.
• Created SSIS Packages which load the data from Flat files into SQL Server.
• Involved in Troubleshooting Existing SSIS Packages and SQL server jobs in event of a failure.
• Responsible for releasing builds once the fix has been developed and the code has been checked in.
• Created SSRS reports with new employee and exiting employee changes data.
• Responsible for documenting all the builds before release.

Confidential

SQL Developer

• Designed database using Erwin Tool and generated scripts for Creation of database.
• Involved in Creation of SSIS packages which involved data import from Flat file to SQL Server.
• Created Tables, Stored procedures and other objects based on requirements.
• Responsible for documentation of Detail Design Documentation, Low Level and High-Level Documentation.
• Involved in Creating data dictionary using SQL Server.
• Created Parameterized reports using SSRS which would call SQL Stored procedures for data input and retrieval.
• Implemented backup strategies with Full backup and Differential Back up for high availability of data.
• Technologies: SQL server 2000, MS Access, SSIS, VSTS.