PROFESSIONAL SUMMARY:

• Over 6+ years experience as a SQL BI Developer in the IT industry with Microsoft SQL Server 2014/2012/2008 R2/2008, SSIS/SSRS/SSAS.
• Extensive experience with SQL Server and T - SQL in constructing tables, triggers, user defined functions, views, indexes, user profiles, relational database models, data dictionaries and data integrity.
• Expertise in writing T-SQL queries, dynamic-queries, sub-queries and complex joins for generating complex stored procedures and cursors.
• Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules and Validation issues.
• Experience in creating Power BI dashboards/reports using tabular models and good in managing Gateways and content packs.
• Explore data in a variety of ways and across multiple visualizations using Power BI .
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing and debugging new and existing client-server based applications).
• Well versed in Normalization/Denormalization techniques for optimum performance in relational and dimensional database environments.
• Created views as per design needs.
• Good Experience in using Microsoft BI studio for implementation of ETL methodology.
• Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Well experienced in performance tuning in SSIS packages by using row, block, and unblock transformations.
• Experienced in deploying and configuring packages, Error handling and batch logging check points and troubleshooting Reports using SSRS .
• Experienced in creating various types of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Experience in designing enterprise reports using SQL Server Reporting Services, generated drill down reports, drill through reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2008/2012.
• Wrote parameterized queries for generating reports in SSRS 2012/2008.
• Proficient in designing and implementing SSAS Tabular & Multidimensional Cubes.
• Worked on DAX scripting to access data from Tabular Model and MDX for Multidimensional Cubes.
• Expertise in creating Row Level Security & Roles for SSAS Tabular Model & Multidimensional Cubes, as well as deploying them into SSAS.
• Experienced in creating SSAS Cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Worked on KPI's, Partitions, Perspectives, and Calculated Measures.
• Responsible for designing and developing Data Warehouses and Data marts using Star and Snow Flake Schemas.
• Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.
• Used DAX (Data Analysis Expressions) & MDX functions for the creation of calculations and measures in the Tabular Mode & multi-dimensional Cubes.
• Expert in generating Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports by using Chart expert of Crystal Reports.
• Major responsibilities include getting requirements from the user and maintaining proper documentation of the reports for future reference.

TECHNICAL SKILLS:

Operating Systems: Windows, Unix, Linux, Mac

Databases: MS SQL Server 2014/2012/2008 R2/2008, MS Access

Database Design Tools and Data Modeling: Ralph-Kimball Methodology, Bill-Inmon Methodology, Star Schema, Snow Flake Schema, Extended Star Schema, Physical And Logical Modelling, Dimension Data Modelling, Fact Tables, Dimension Tables, Normalization, Denormalization, MS Visio.

Modelling Techniques/Tools: Flow Charts, Sequence Diagrams, Activity Diagrams, Use case diagrams, Data Modelling, ER Diagrams

BI Tools: SQL, SQL Server Integration Services (SSIS 2005/2008/2012 ), SQL Server Reporting Services (SSRS 2005/2008/2012 ) SQL Server Analytical Services (SSAS 2005/2008/2012 ), Data Transformation Services (DTS), Visual Studio, BIDS, Power BI.

Tools: /Database Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Business Intelligence Development Studio (BIDS), Visual Studio Team Foundation Server (TFS).

Languages: C, C++, HTML, XML/.Net/C#, Power Shell, VB.NET

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY

Power BI Developer

Responsibilities:

• Created, updated and maintained reports and dashboards in Power BI.
• Imported data into Power BI Desktop and model data using the Power Query language inside of Power BI.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards .
• Configured and Maintained Power BI Service(app.powerbi.com) to share content with the business users.
• Published the reports into Power BI service by creating and managing app workspaces and apps.
• Published reports and dashboards to PowerBI service and maintain the refresh schedules and flow of data into the related data sets.
• Created custom calculated measures using Power BI DAX language to meet the business needs.
• Implemented RLS (Row Level Security) for Power BI reports to restrict data access for given users.
• Experience in creating multiple kind of Power BI Reports and Dashboards.
• 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.
• Configured and managed Premium Capacity in the Power BI service to share apps to the business users.
• Installed and Maintained On-premises gateway to provide secure data transfer between on-premises data and the Power BI service.
• Experience in Power BI service administrator activities such as creating and managing security groups, assigning user permissions, monitoring usage metrics for dashboards.
• Created performance tuning methods on report level metrics using DAX studio.
• Automated various Power BI related jobs using PowerShell activities.
• Provided training to business users on how to use Power BI dashboards and its self service capabilities.
• Responsible in meeting different user groups to understand what dashboards need to be built.
• Provided production support on the existing Power BI dashboards.

Environment: Power BI Desktop, MS SQL Server 2017, Microsoft Visual Studio, Power BI Service, Power Pivot, MS Excel, DAX Studio.

Confidential, Troy, MI

SQL/SSIS/SSRS/SSAS/Power BI Developer

Responsibilities:

• Worked as a developer in creating complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.
• Implemented different types of constraints on tables.
• Identified the data source and defining them to build the data source views.
• Looked at the reports and fixed bugs in stored procedures.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Monitored scheduled jobs and alerts.
• Responsible for gathering/refining requirements from the customer for developing reports.
• Developed SSIS packages using various transformations such as conditional splits, fuzzy look ups, aggregations and multicasting.
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports.
• Experience in creating multiple kind of Power BI Reports and Dashboards.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using Power Pivot, Power Query, Power View & Power BI.
• As a Power BI Developer responsible for the design, development and production support of interactive data visualizations used across the company.
• Used Power BI , Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Created Power BI reports utilizing the SSAS Tabular Model via Analysis connector.
• Migrated SSRS reports to Power BI.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Experience in writing complex expressions and formulas for reports in SSRS.
• Created SSRS Reports for different teams and groups in the organization to fulfill their business needs.
• Implemented and enhanced existing reports like group by, drilldown, drill through, sub-reports, list, tabular, matrix, navigation reports, standard parameter, cascading parameter and multivalve parameters.
• Knowledge on SSRS report performance using execution logs and query improvement for datasets.
• Scheduled monthly reports/weekly reports/daily reports based on user requirements.

Environment: MS SQL Server 2012, Microsoft Visual Studio, SQL Server Integration Services (SSIS 2012), SQL Server Reporting Services (SSRS 2012), SSAS, Power BI, Power Pivot, Jira, TortoiseSVN, MS Excel, SQL Server Profiler.

Confidential, Carmel, IN

SQL/SSIS/SSRS/SSAS /PowerBI Developer

Responsibilities:

• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Extensively worked on views, cursors, CTE’s, schemas, permissions and performance issues with client/server database design.
• Responsible for transferring the data using SSIS packages.
• Developed, monitored and deployed SSIS packages.
• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Improved Report Performance and performed unit testing.
• Created SSIS packages to export data from text file to SQL Server Database.
• Created SQL Server Reports and developed query for generating drill down reports using SSRS 2014.
• Identified and worked with parameters for parameterized reports in SSRS 2014.
• Analyzed old reports designed in crystal reports and transform those reports into SSRS report with proper mapping and error handing.
• Deployed the generated reports directly on the client’s workstation.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Worked on Data Analysis Expressions ( DAX ) for accessing data directly from tabular SSAS database.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Created a cube using multiple dimensions and modified the Relationship between a Measure group and a dimension using SSAS.
• Gather data from different data sources like MySQL, Excel.
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Made changes to the existing Power BI Dashboard on a regular basis as per requests from Business.
• Provided production support on the existing Power BI dashboards and other ETL processes to resolve the issues quickly.
• Published Power BI Desktop reports created in Report view to the Power BI service.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Created Tabular Models as a source to Power BI dashboards and scheduled jobs to refresh it in a timely manner.
• Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.
• Scheduled the monthly reports/weekly reports/daily reports based on user requirements.

Environment: MS SQL Server 2012/2014 R2, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS 2014), SQL Server Analysis Services (SSAS 2014), SQL Server Reporting Services (SSRS 2014),Power BI, Power Pivot, Windows 2010, MS Excel.

Confidential, Detroit, MI

SQL BI Developer

Responsibilities:

• Created complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code for experience.
• Involved in unit testing, user acceptance testing to check whether the data is loading into target, which was extracted from source systems.
• Experience in creating database objects like procedures, functions, triggers and indexes.
• Created functions to provide custom functionality as per the requirements.
• Designed and written the queries in the query builder for retrieving the data.
• Worked extensively with SSIS to import, export and transform the data from XML and text files.
• Created and managed event handlers, package configurations, logging, system and user-defined variables for SSIS packages.
• Worked with various SSIS control flow tasks and data transformation tasks like data conversion, derived column, look-up, and fuzzy look-up, conditional split etc. as part of ETL.
• Created checkpoints and configuration files in SSIS packages.
• Extensively used merge command as alternative to small SSIS packages in dimension and fact load.
• Deployed SSIS packages with minimal changes using XML configuration file.
• Extracted data from various heterogeneous sources and created packages using SSIS, Import/ Export data, bulk insert and BCP utilities.
• Used SQL profiler to optimize stored procedures.
• Created various SSRS reports involving variety of features like charts, Filters, Sub-Reports, Drill Down, Drill-Through, Multi-valued parameters.
• Developed reports by using SSRS and deployed them on web pages using ASP.NET using C#.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Involved in designing Partitions in Cubes to improve performance using SSAS.
• Used MDX to query Analysis Service Databases, debugging and supported the purpose of data analysis.
• Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc.
• Designed and developed Crystal Reports, the Cross Tab Reports, and Top N Reports for displaying vital data and summary reports with drill-down capabilities.
• Developed various charts and graphs like bar chart side by side, stacked, line graphs, pie -charts etc. by using chart expert of Crystal Reports.
• Created calculated measures using MDX implementing business requirement.
• Worked on Star and snow flake schemas and used the fact and dimension tables to build the cubes, perform processing and deployed them to SSAS database.
• Designed aggregations and pre-calculations in SSAS .
• Extensively used Teradata SQL Assistant to extract data from Data warehouse.

Environment: Microsoft SQL Server 2008 R2/ 2012, MS Access, ETL Packages(SSIS 2012), SQL Server Reporting Services(SSRS 2012), SSAS, Power BI, Power Pivot, MDX, Teradata, .Net, VB.Net, HTML, Visual Studio, Crystal Reports, Visual Source Safe, T-SQL,XML .

Confidential

SQL BI Developer

Responsibilities:

• Created new Databases and maintained existing User / System Databases. Involved in Logical/Physical design of database and maintenance.
• Created Database objects - tables , views , and functions .
• Rebuilt Indexes and Tables as part of performance tuning exercise.
• Successfully implemented physical database design in SQL Server 2008R2.
• Wrote Triggers and Stored Procedures and T-SQL Queries to capture updated and deleted data from OLTP systems.
• Expertise in Using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component etc.
• Evaluated database population routines ( ETL ) and ensure quality of production load processes.
• Developed physical data models and created DDL scripts to create database schema and database objects.
• Wrote T-SQL queries using inner join, outer join, and self joins, merge join. And also implemented functionality for removing duplicate records like using CTE and ranking function.
• Worked collaboratively with DBA to Improve Performance of the database by creating Stored Procedures, Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Designed SSIS packages to migrate the data from DB2, flat files, excel documents and CVS files to the Staging Area in SQL Server.
• Worked on Huge Data Transfers from and to SQL Server Databases using SSIS , and used Configuration Files and Environment Variables for production deployment.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS .
• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
• Created SSIS packages to load data into SQL Server using various transformations in SSIS.
• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created Sub-reports, Parameterized and Drill-through, Drill-down reports, Matrix reports and Summary reports in SSRS .
• Created Report Snapshots to improve the performance of SSRS .

Environment: MS SQL Server 2008/2008R2, SSIS/SSRS, Query Analyzer, T-SQL, Windows Server 2008R2, SharePoint server, DTS Designer, Visual Source Safe, Microsoft Visio 2007, SQL Profiler, SQL Profiler, MS Excel 2010, MS Word 2010,Power point 2010.