SUMMARY:

• Around 5 years of extensive IT experience as SQL Server and Microsoft Business Intelligence applications developer, specialized as SQL Server 2008 R2/2012/2014, 2017, Reporting Services and Analysis. (SSIS, SSRS, Tabular model SSAS)
• 10+ months of experience in designing and developing Dashboard Reports using Power BI.
• Well versed in Normalization/Demoralization techniques for optimum performance in relational and dimensional database environments.
• Both logical and physical Dimensional/Data Modelling experience using Erwin tool.
• Reverse engineered Databases using Erwin tool to build Logical data model for databases.
• Experience in building Data Warehouse from scratch, build both Star and Snow Flake schema for Data Warehouse Development.
• Used SSIS as an ETL tool to load Dimension and Fact tables.
• Hands on experience in creating Indexed Views, Complex Stored Procedures, Functions, Triggers, CTE’s to assist efficient data manipulation and data consistency and used DDL, DML commands for various business applications.
• Hands on experience working with SSIS, for ETL Process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created SSIS packages with complicated transformations like Lookup, Derived Column, Condition Split, Multicast, Sort, Union All, Cache Transform, and Conditional Split, Fuzzy Look - ups, Checksum, Conditional Splits and Event Handlers, Error Handlers etc.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Expertise in designing, supporting complex reports like Drill-Down, Drill-Through, Parameterized, Matrix, and formatting Reports using SQL Server Reporting Services SSRS) based on client requirement.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• 6+ months of experience in Azure Analysis services development.
• Good verbal and written communication skills.

TECHNICAL SKILLS:

Languages: C, T-SQL, PL/SQL

RDBMS: SQL Server 2014/2012/20008

Web Technologies: HTML, XML, JavaScript, PHP, Shell Scripting.

Version Controlling Tools: TFS, VSTS, Azure DevOps

SQL Server Tools: SQL Server Management Studio, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Business Intelligence Development Studio, SSIS, Tabular SSAS, SSRS.

Data Modeling Tool: Erwin, Visio.

Methodologies: Logical and Physical Database Design, Star Schema, Snow Flake Model.

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia

MSBI developer/Power BI developer

Responsibilities:

• Converted around 50 SSRS based reports to Power BI reports.
• Build Data warehouse ETL packages using SSIS
• Using ETL tool SSIS built Full and Delta load logics for Data Warehouse loads.
• Built Logical and physical Data model using Erwin tool
• Built Analysis Services Tabular Model for Financial Model using Azure Analysis Services.
• Built YTD, WeekToWeek, MonthOnMonth, Cummualtive Sum, Prior Year measures using DAX.
• Utilized common DAX functions like Calculate, Filter, Rankx, Sumx, and IsFiltered.
• Created CI/CD Build and release pipelines for deployment.

Environment: MS SQL Server 2012/2014, Visual Studios BIDS (SSIS/SSRS/SSAS), SSMS, VSTS

Confidential, New York

Data ware House Developer

Responsibilities:

• Developed and Optimized Stored Procedures, Views, and User-Defined Functions, custom scripts and stored procedures for data import and manipulation.
• Developed Physical data models and created DML scripts to create database schema and database objects.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects, and Implemented Incremental load, used Event Handlers to clean the data from different data sources.
• Having Experience on Exception Handling, Configurations, Project Deployment.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed different kind of reports such a Drill-through and Drill-down, Sub Reports, Charts, Matrix reports, Linked reports.
• Created Power BI dashboards for SLAs, System Uptime, and Service Requests using Power BI Desktop.
• Developed BI Letters in Visual Studio 2010 and 2012.

Environment: MS SQL Server 2012/2014, Visual Studios BIDS (SSIS/SSRS/SSAS), SSMS, Team Foundation Server

Confidential

SQL Developer

Responsibilities:

• Developed complex programs in T-SQL\PL-SQL, writing Stored Procedures, Triggers, stored procedures, triggers, Views, cursors, CTE’s, T-SQL scripts, schemas with best execution plan.
• Worked on UI Data pop and Meta-data for populating data in EXCEL 2007/2010 using SQL macros.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Developed dashboards using Excel Power Pivot.
• Developed Query for generating drill down and drill through reports in SSRS 05/08.
• Uploaded reports on to the report manager and organized them into folders.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Identified and worked with Parameters for parameterized reports in SSRS 2005/2008.
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.