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:

DBMS & RDBMS: SQL Server 2008/2012, MySQL

Languages: TSQL, C, C++, HTML, VB Script, C#

SQL Server Tools: SQL Server Data Tools, SQL Server Profiler, Database Tuning Wizard, Oracle SQL Developer Data Modeler, ERWIN

ETL Tools: SQL Server Integration Services (SSIS)

Reporting Tools: SQL Server Reporting Services (SSRS), MS Excel, Tableau, Power BI

OtherTools: MS Visual Studio, MS Office, Advanced MS Excel

PROFESSIONAL EXPERIENCE:

MSBI Power BI Developer

Confidential, Providence, RI

Responsibilities:

• Enterprise Reporting Management of Microsoft was used to generate the reports for finance and operations which was built on the top of multidimensional cube and migrated into tabular modal.
• Did different POCs like Process Control Framework POC - To verify multiple worker thread under one PCS master job.
• Tabular With 500 Million Rows - To test performance and scalability of tabular.
• Experience in creating workspace at Power BI Service.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas
• PNL Report - To avoid customization like in existing PNL report using tabular cube.
• Troubleshooting of the burning issues in tabular and multidimensional cubes.
• Translated the existing Reports from Translational to Dimensional in SQL Server Management Studio.
• Involved in Installation, Configuring and Publishing various types of Power BI reports to service.
• Created complex Stored Procedures, User Defined functions, Triggers, Indexes, Tables, Views, SQL joins and defined roles and privileges to implement business rules and control access to database.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity
• Wrote complex stored procedures to process requirement and generating records between front End and back end.
• Having Knowledge on connecting various Data Sources in Power BI Service using On-Premises Gateway connection.
• Extensively worked with nearly all components of Micro Strategy product, primarily with Web, Desktop, Object and Command manager, Narrowcast server.
• Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Created New Reports by using SSRS & did the performance of SSRS Reports.
• Established the relationships among the tables in the database by assigning primary keys, foreign keys and established the referential integrity.
• Involved in Planning, Defining and Designing database depending on business requirements and provided the documentation.
• Created complex Stored Procedures, User Defined functions, Triggers, Indexes, Tables, Views, SQL joins and defined roles and privileges to implement business rules and control access to database.
• Extensively involved in the design of & Tabular storage, partitions and aggregations and developed different calculated members, KPIs, actions by using the MDX & DAX while designing the cube.
• Created Tabular Models using DAX queries in SSAS and deployed it.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
• Created POWER BI Visualizations and Dashboards as per the requirements.
• Used various sources to pull data into Power BI such as SQL Server, Excel, Oracle, SQL Azure etc

Environment: T-SQL, MS SQL Server 2016, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, Visual Studio 2016, Tableau, OLAP, OLAP, XLST, XPATH, C#.

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.