SUMMARY

• 8 years of IT experience in database design, development, Power BI and support of Microsoft SQL Server for Production/Development environments.
• Worked onPower BIservice by publishing thePower BIreports ontoPower BIserver and collaborated team usingPower BIservice to create the dashboards.
• Expert in creating multiple kinds of Power BI Reports, Dashboards and Visualizations.
• Created the Dashboards and shared it to user groups using Power BI Apps.
• Responsible for creating SQL datasets for Power BI and Ad - hoc Reports.
• Interactive Data Visualization products focused on Business Intelligence such as Power BI.
• Extract and analyze data using Power Query, PivotTables, MS Excel, Power BIand SSAS.
• Developed confidential proprietary analytical tools and reports with Microsoft Excel, Power Pivot and Power Point.
• Publishing Power BI Reports from Power BI Desktop to Power BI Service.
• Generation of Dashboards with Quick filters, Calculated Fields, Groups, Parameters and Sets to handle views more efficiently in Power BI.
• Experience designing various visuals such as Combination Charts, Tables, Maps, Matrices, Cards, Slicers, KPIs, Funnels, Scatter Plots, and Gauges etc.
• Experience in creating Hierarchies for Slicing and Dicing using Drilling functions for various reports.
• Experience using Power BI Data Gateway for keeping data up-to-date and performing Scheduled Updates.
• Azure Log Analytics integration with Power BI Premium enables administrators to monitor usage, system health, is used for diagnosis for performance improvements.
• Experience in creating Roles in Power BI Service allow the conditional access as per the requirement.
• Managed relationship between tables in Power BI using star schema.
• Configure security, organizational content packs, DataGateways, refresh schedules forPower BI service.
• Good in creatingaggregates, hierarchies, charts, filters, quick filters, table calculations with Power BI.
• Experience of writing complex DAX Queries like Time Intelligence functions, Date and Time functions, Filter functions, and Statistical functions
• Hands on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions.
• Experience working in Agile and Waterfall model working methodologies.
• Strong experience in SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Solid experience with ETL processes; worked extensively on data extraction, data integration and loading from different data sources using SSIS.
• Designed, developed and implemented various SSIS Packages and deployed using Deployment Wizard.
• Excellent knowledge in Dimensional Data Modeling and analyzing the Data Warehouse by building multi-dimensional cubes using SQL Server Analysis Services (SSAS).
• Hands on experience in dealing with Relational Database Management Systems, including Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors, Normalization.
• Good knowledge of Database Administration operations like Backup, Restore and excellent knowledge in Transact-SQL (DDL, DML, DCL).
• Expert in developing parameterized, linked, matrix, drill down and aggregation reports with various parameters and filters using SSRS.
• Hands on experience in generating on-demand and scheduled reports for business analysis or management decisions using SSRS.
• Experience writing T-SQL scripts, dynamic SQL, creating indexed views, cursors, indexes, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Created and Deployed cubes in start and snowflake schema.
• Well versed with Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services project
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
• Good exposure in writing MDX queries while creating and customizing Cubes using SQL server Analysis Services (SSAS).
• In-depth knowledge of working and implementation of SSRS Reports, converting Crystal reports to SSRS Reports and in upgrading crystal reports.

TECHNICAL SKILLS

RDBM/Databases: MS SQL Server 2016/2014/2012/2008 R2 MS SQL Server 2000/2005/2008/2008 R 2/2012/2014/2016 , Oracle, Azure SQL DB, Snowflake, OLTP & OLAP.

Database Tools: Business Intelligence Development Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Service, SQL Server Management Studio.

ETL Tools: SQL Server Integration Service (SSIS), Power Query

Programming Languages: C, Java, HTML, MDX, T-SQL, PL/SQL, C#

Reporting Tools: SQL Server Reporting Service (SSRS), Power BI, Tableau

Application Tools: MS Office Suite (MS WORD, MS EXCEL, MS VISIO, MS Power Point), SharePoint

Operating Systems: Windows XP /Vista /7 /8 /10, Windows NT Server, Windows R2 /2012 Servers.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta GA

Sr. Power BI Developer

Responsibilities:

• Created Power BI reports from scratch, getting requirements, data modeling and reporting.
• Rebuild old Power BI reports with new visualizations and adding more data sets into the reports.
• Changing the visualization and look over of all the old reports so that all the Power BI reports look consistent throughout the company.
• Heavily used DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE.
• Involved in developing reports and dashboards in Power BI.
• Used One Drive for storing different versions of Power BI report.
• Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BIaccording to the requirements.
• Changing the visualization and look over of all the old reports so that all the Power BI reports look consistent throughout the company.
• Worked on creating hyper link views on SharePoint site content table which would help user in the Power BI reports to get them to the weblinks that needed.
• Automating the schedule refresh of Power BI reports using gateways.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Power BI.
• Generated data source filters while handling a huge volume of data from Databases.
• Expert in developing parameterized, linked, matrix, drill down and aggregation reports with various parameters and filters using SSRS.
• Hands on experience in generating on-demand and scheduled reports for business analysis or management decisions using SSRS.
• Expert in creating Power pivots, Power Views and SSRS reports using Tabular Model (DAX), Cubes (MDX) and SQL queries.
• Used Power BI Data Gateway to keep the Dashboards and Reports up-to-date.
• Created Hierarchies and KPIs for better insight into the data and applied Z-order to the visualizations in the report.
• Converted SQL Query code into DAX code for reports.
• Managed Relationships between various tables and measures to maintain a smooth and interactive flow between multiple visualizations across various reports.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power BI Services.
• Performance tuning of the datasets (queries) which takes long time to refresh on Power BI web.
• Create the Calculated columns and measures with the use of DAX Expressions.
• Involved in effectively used data blending, filters, actions feature in Power BI.
• Create the Row Level Security in Power BI.
• Interacting with Client to get requirements.

Environment: MS SQL Server 2019, Visual Studios 2017, Power BI, DAX, Agile, T-SQL, Microsoft Teams, Denodo, GIT, MS Excel, Azure, SharePoint, Windows 10.

Confidential, Atlanta GA

Power BI/ MSBI Developer

Responsibilities:

• Collaborated with a senior manager and team lead to understand the operations and system requirements.
• Worked with Databases such as MS SQL Server, MySQL, and MS Access.
• Created and Managed Parameters in Power Query Editor to work with targeted data.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Experience in developing several Details, Summary reports including line and pie charts, trend analysis reports and sub-reports per business requirements.
• Experience in generating on-demand and scheduled reports for business analysis or management decision.
• Used recently introduced Power BI to create self-service BI capabilities and use tabular models.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Developed interactive Dashboards on Power BI Service with the help of reports and visualizations Published from the Power BI Desktop.
• Shared the created workspace across the organization using Power BI Apps...
• Performance tuning of Stored Procedures and Functions by creating Indexes for the underlying tables.
• Debugging SSIS packages which have issues running in Prod at that specific point of time and Monitoring packages
• Performance tuning of Stored Procedures and Functions by creating Indexes for the underlying tables.
• Established DAX while creating data models in Power BI.
• Debugging existing SSRS reports as well as making changes and enhancements if needed.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL Server 2016 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Undertook the help of SQL Server Integration Service (SSIS) to extract particular data required for the purpose of the project scope.

Environment: MS SQL Server 2016/2012/2008 R2, Visual Studio 2015 & 2017, MS SQL Server Integration Services (SSIS), Power BI, MS SQL Server, Windows 8.

Confidential, Pittsburgh, PA

MSBI / Power BI Developer

Responsibilities:

• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• CreatingSSISpackage to load data from Flat File to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Developing reports and dashboards using Power BIstack, PowerPivot,PowerView,PowerQuery.
• Created/modified complex store procedures to fit to changing requirements and enhance performance and developed custom functions, indexes to ensure accuracy, quality and consistency of the database.
• Created databases and schema objects including tables, indexes, views and applied constraints.
• Built the report models, created a wide variety of interactive reports for business users in SSRS and deployed the reports in various formats depending on the user requirements.
• Worked onPower BIon how to import, shape (info graphics) and transform data for business intelligence (BI), Visualize data, and author reports, schedule automated refresh of reports and create and share dashboards based on reports inPower BIdesktop.
• Created reports inPower BIdesktop using theSSASTabular Model via Analysis connector.
• Created Detail reports in Power BI using Drill through filters.
• PublishedPower BIReports in the required originations and MadePower BIDashboards available in Web clients and mobile apps.
• Responsible for developing PowerApps model and canvas driven apps.
• Experience customizing SharePoint lists and disparate systems with PowerApps.
• Created Dashboard and the Content Pack for the originations to get the updatedPower BIReports. And added the refresh time for each tile in the dashboard.
• Responsible for complete maintenance and delivery of scheduled releases.
• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.

Environment: MS SQL Server 2012, Git, MS SQL Server Reporting Services 2015, MS SQL Server Analysis Services 2015, T-SQL, MS SQL Server Integration Services, Visual Studio 2015, T-SQL, Power BI, Agile Methodology.

Confidential, New Jersey

MSBI Developer/Power BI Developer

Responsibilities:

• Design and write elastic queries to access data across database and migrate an existing SQL Server Database to useAzureSQL Database.
• Introduced Power BI in company by evaluating Power BI and Tableau as earlier Crystal Reports were used.
• Developed reports and configured/managed the report services environment using Power BI.
• Created Power BI Visualizations and Dashboards in order to display the customer’s information.
• Created Dashboard and the Content Pack for the originations to get the updated Power BI Reports.
• Developed and deployed SSIS packages, configuration files and scheduled job to run the packages to generate data in CSV files and Flat files.
• Created database objects such as tables, views, indexes, stored procedures, and functions per requirement. Established joins and created indexes whenever necessary based on requirements.
• Worked on SQL Server backup, recovery scenarios and SQL Server security management.
• Created multiple complex queries for data profiling and auditing purposes utilized in the ETL process.
• Performed a multitude of ETL, data operations to support data loads and transformations with SSIS.
• Improved the performance of SSIS packages with non-blocking transformations and row transformations.
• Implemented event handlers, loggings, breakpoints, and data viewers to debug packages.
• UtilizedSSIStransformations such as Conditional Split, Derived Column, Fuzzy Grouping, and Fuzzy Lookup to validate data during staging before loading into data mart.
• Configure database replication from on premises toAzureSQL, data sync and migration of database to and from Premise/AzureSQL DBEvaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery, troubleshoot performance.
• UtilizedSSISto implement the Slowly Changing Transformation along with checksum technology, to maintain historical data in data marts.
• Identified Dimensions and Facts, Used MDX to extract data from cubes and Created MDX script for representing Cube Calculation.
• Creating, ModifyingSSASMeasures, Dimensions Attribute relationships and Hierarchies.
• Implemented robust error-handling techniques through event handlers, precedence constraints (control flow level) and error data pipeline (data flow level) per business requirements for sending emails to corresponding individual. Optimized SSRS reports with snapshots, caches, execution log views, embedded queries, and stored procedures.
• Scheduled report deliveries to multiple users utilizing subscriptions (standard/data driven).
• Created several drill down, drill through, sub, linked, cached and snapshot reports using SSRS and deployed them in Native mode.

Environment: SQL Server 2012, SQL Server Management Studio (2012), SSAS, SSRS, SSIS, T-SQL, SQL Profiler, Tableau, Visual Studio 2012, Power BI, C#.Net

Confidential

SQL developer

Responsibilities:

• Requirements gathering from Business users to perform technical design, development and testing.
• Worked extensively in writing and debugging complex stored procedures, views, triggers and user-defined functions
• Worked on designing databases according to industry standards and make tuning recommendations.
• Designed the Data warehouse and done the mappings from Source to the Target tables.
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS.
• Worked on several complex drilldown, parameterized reports and on reports that call sub reports using SSRS.
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.
• CreatedSSISPackages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Identified the dimension, fact tables and designed the Data-Mart using Star schema.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2008R2 Analysis Services.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2008R2.
• Generated multi parameterized reports in MS SSRS 2008R2 allowing users the ability to make selections before executing reports; thus, making them user friendly.
• Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS
• Created Ad Hoc and parameterized variousReportsusing SSAS and SSRS.
• Assisted in handling escalating billing issues and propagating bug fixes in production environment.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories based on business needs.

Environment: SQL Server 2008R2, DTS, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio (BIDS), SQL Server Query Analyzer.

Confidential

Software Engineer

Responsibilities:

• Created tables, views, indexes, stored procedures, functions, and triggers by T-SQL code in MS SQL Server Management Studio (SSMS) to make data transformation services (DTS) effective.
• Worked with DDL, DML, and DQL in T-SQL using CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, FROM, WHERE, ORDER BY, and GROUP BY.
• Created tables, views, indexes, stored procedures, functions, and triggers by T-SQL code in MS SQL Server Management Studio (SSMS) to make data transformation services (DTS) effective.
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Worked with DDL, DML, and DQL in T-SQL using CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, FROM, WHERE, ORDER BY, and GROUP BY.
• Responsible for quick response of SQL statement and connectivity from front application to the database servers.
• Created SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Created SSIS packages to populate data from various data sources.

Environment: MS SQL Server 2008R2/2008, MS SQL Server Management Studio (SSMS), MS SQL Server Integration Services (SSIS), MS Excel, T-SQL.