SUMMARY

• Around 6+ 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)
• 3 Year 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.
• Expertise in Power BI Premium, Power BI Pro, Power BI Mobile.
• Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Power BI Desktop.
• Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
• Utilized power BI desktop to design real time dashboards and scorecards for analytical decision.
• 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

Reporting Tools: Power BI,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, Minnesota

Power BI Developer

Responsibilities:

• Developed the reports in Power BI desktop, publish the report and pinned dashboards in the Power BI Service.
• Created Power BI reports and Dashboards to identify the bottlenecks and coordinated with the Oracle source system.
• Set up the Power BI environment and manage the permissions to the Power BI Service.
• Created Drill Down, Drill Through, Book Marking and Hyperlinks features in the Power BI report.
• Created the On-premises Gateway and implemented Raw level Security in Power BI.
• Create various Financial Reports by using direct query mode in Power BI, connecting with SQL Server Azure database.
• DAX Query filtering data and creating Calculated columns and Measures.
• Extensively worked in analyzing profiling and modeling data in the Power BI Desktop using Query Editor and Relation Ship view.
• Created SSIS packages to perform the ETL operation and load data from excel spreadsheets, text files etc.
• Used SQL Server Package Configuration technique to make Dynamic configurations.
• Used Text Files/ SQL Server Logging for all SSIS packages.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Involved in gathering business requirement from business users and prepared BI technical specifications.
• Expertise in performance tuning and optimization of the Reports and Dashboards.

Environment: Oracle 9i/10g/11g, Power BI.SQL Server

Confidential, Philadelphia

Power BI developer

Responsibilities:

• Worked in Power BI environment to create dashboards like daily, weekly, monthly reports using Power BI desktop and publish them to server.
• Created reports using Power BI Desktop and published them to Power BI Service.
• Created Power BI Dashboards and scheduled the data refresh and set subscriptions as per the reporting needs.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports,Matrix Reports.
• Converted around 50 SSRS based reports to Power BI reports.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).
• Published Power BI Desktop reports created in Report view to the Power BI service.
• Made changes to the existing Power BI Dashboard on a regular basis as per requests from Business.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize 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,Power BI, Visual Studios BIDS (SSIS/SSRS/SSAS), SSMS, VSTS

Confidential, New York

Power BI 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.
• Develop the reports in Power BI desktop, publish the report and pinned dashboards in the Power BI Service
• Developed BI Letters in Visual Studio 2010 and 2012.

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

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.