SUMMARY:

• Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading.
• Excellent in creating reports using Themes from Microsoft Store at MS Power BI Desktop and publishing in web version and Mobile
• Extensive database programming Experience in writing T - SQL Stored procedures, User Defined Data Types, Triggers, Constraints and Indexes.
• Have good knowledge in stored procedures, functions and Views in SQL Server.
• Experience in creating Jobs, Alerts, SQL Agent and Scheduled SSIS Packages.
• Performance tuning, deploying and processing SSAS cubes
• Strong understanding of SQL performance tuning, query optimization, and query Execution Plans
• Expertise in using different SSIS transformations like Lookups, Derived Column, Merge Join, Conditional Split, Union all etc.
• Expertise in Package Configuration, Logging, Error handling by using Event Handler, in SSIS Packages.
• Having hands on experience in using slowly changing dimension to track changes in dimension attributes for maintaining historical data.
• Experience in designing data source, data source views, dimensions, user defined hierarchies, and cubes using SSAS.
• Involved in performance tuning of dimensions, cubes for achieving better processing performance and quick query response.
• Good team player, strong interpersonal and communication skills combined with self- motivation, ability to think outside the box.

TECHNICAL SKILLS:

• ETL
• SSIS
• SSRS
• Power BI

PROFESSIONAL EXPERIENCE:

MSBI/ PowerBI Developer

Confidential

Responsibilities:

• Experience in Extracting, Transforming and Loading (ETL) data from Flat file, excel (spread sheet), MS SQL and oracle to MS SQL Server database by using SSIS services.
• Involved in Installation, Configuring and Publishing various types of PowerBI reports to service.
• Having Knowledge on Connecting various Data Sources in PowerBI Service using On - Premises Gateway connection.
• Performed optimization of T-SQL stored procedures by analyzing execution plans, creating proper indexes and employing SQL profiler and Database engine tuning advisor in OLTP environment.
• Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, OLTP, Dimensional Data Modeling and Relational Data Modeling.
• Designed and implemented data models and data marts for database and data warehouse
• Worked in building complex T-SQL queries and stored procedures for the reports in SSRS.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Azure Data Factory and Bulk Insert.
• Created a report model on SSAS cubes.
• Prepare the unit test case document and provide UAT support.
• Guiding team members while solving critical QA and UAT defects.
• Responsible for import data from Azure and build the dashboards as per the requirement
• Responsible for implementing the ETL solutions using SQL Server Integration Services (SSIS).
• Generating reports for SLAs, Health Dashboards and team efforts using SSRS and PowerBI by connecting various data sources. Also build reports as per the Client's requirements.
• It Involves database performance tuning techniques for both On-Premises databases and azure databases.
• Developed, deployed and monitored SSIS Packages for new ETL Processes.
• Used SSRS to create reports, customized Reports, on-demand reports.
• Worked on the PowerBI reports & dashboards with SQL Server sources.
• Wrote complex T-SQL queries and stored procedures for the building reports in SSRS.
• Creation and scheduling of ETL Packages Using SQL Server Management Studio.
• Created and Enhanced SSRS Reports by creating Expressions/Parameters/Sub-Reports/Sorting & Grouping.
• Strong knowledge of Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly reports SSRS.
• Created complex stored procedures with parameters and generated multi parameterized SSRS reports from them, where the user has a choice to select the parameters.
• Contributed in writing complex T-SQL's for meeting the OLAP requirements.
• Involved in T-SQL Programming techniques in query optimization and performance tuning.
• Created SSIS packages for data conversion using Data Conversion Transformation.
• Experience in Creating workspace at PowerBI Service.
• Experience in Creating various types of Dashboards from Different Published reports at PowerBI Service.
• Used SSRS to create, execute, and deliver tabular, matrix, and charts reports.
• Responsible for writing T-SQL queries, Stored Procedures and user-defined functions for handling the business requirements.

MSBI Developer

Confidential, Houston, TX

Responsibilities:

• Extensively involved in gathering business requirements that will facilitate the planning and the implementation phase of OLTP database.
• Developed ETL jobs like data transformation using Microsoft SQL Server Integration services (SSIS).
• Created SSIS packages, staged data from different data sources into a SQL Server Database using SQL Server Integration Services (SSIS).
• Designed and created SQL Databases, tables, indexes, and views, User Defined Functions, Stored Procedures, and Triggers to support business applications.
• Developed SQL Server reports on daily performance of databases using SQL Server Reporting Services (SSRS).
• Administered minor databases of the facility using SQL Management Studio.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Performance Tuning and Maintenance plan for consistency checks, backup/restore and Rebuild Indexes.
• Wrote stored procedures using T - SQL and implemented them.
• Worked with various business groups while developing their applications, assisting in database design, phasing from development to QA and to Production environment.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Managed SQL Servers in 32/64bit Clustered environments.
• Implemented Database Mirroring on SQL Server 2008/2010/2012 environments.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, Wed Services) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created drill down reports by linking data from Data Warehouse Cubes using SSRS 2005/ 2008/2008 R2.
• Written SQL queries for back- end data validation database testing and reports verification.