End to end implementation of PowerBI Solution including Planning, Developing, administering within Power BI environment with Microsoft recommended best practices

Designed and implemented BI solutions using Power BI Responsible for Power BI tenant administration and monitoring user activityPower Bi Capacity planning, installing gateways, troubleshooting Power Bi datasetsAdministration within Power BI system, gateway, tenant settings and user supportSupport Tabular models in Azure and performance monitoringWork directly with Business Users and Supervisors representing multiple program offices across the agency to gather requirements

• Involved in Legacy Report System Migration to SSRS.• Created Drill down & Drill Through reports using SSRS.• Designed Highly Parameter driven reports using SSRS.• Migrated SSRS Reports & SSIS Packages from SQL2005 to SQL2008R2• Used SQL Server Profiler to trace out stored procedure calls of slow running SSRS reports and do Performance tuning.Creating cubes from Dimension Modeling using Fact tables & Dimension tables using SQL Server Analysis Services (SSAS). Defined Measures, Measure Groups, Hierarchies, and Dimensions by configuring Data Sources & Data Source Views.• Supported users to fix issues related to reports &cubes.• Actively involved in daily scrum meeting for status updates and used JIRA for logging project updates.

• Involved in logical and physical data modeling, database design, star schema, data analysis.• Designed, developed and deployed Business Intelligence solutions using SSIS, SSRS and SSAS• Used Dimensional Modeling Techniques to identify parameters necessary to create Dimensions and Fact tables.• Built efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 slowly changing dimensions• Make modifications and add new MDX to query the cube• Created partitions and aggregated cube for better performance.

• Designed, developed and deployed Business Intelligence solutions using SSIS, SSRS and SSAS• Involved in performing database code and design reviews and worked with application code teams in developing, delivering and modifying database objects as per project requirements• Created and maintained databases, tables, views, users, logins, Indexes, check constraints, and business rules using T-SQL.• Designed and maintained complex stored Procedures using Joins and Sub queries and to retrieve data from multiple tables

• Developed SSIS packages to conduct simple and complex transformations, and executed these packages using the execution package• Conducted data migration processes in the SQL Server environment using SQL Server Integration Services• Created SSIS packages with which data sources such as Flat files,Teradata,DB2, Excell files, and PDF files Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS2008)• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse• Developed adhoc reports without formal specifications often.• Created and developed the stored procedures, triggers, views, and user-defined functions to support application development.• Created alerts, notifications, and emails for scheduled SSIS packages execution. • Writing T-SQL queries, Stored Procedures, View to extract data and to get the required value from the given data.• Created SQL jobs in Managements Studio.• Cube designing using SSAS and creating ad-hoc reports.• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.• Worked closely with IT project managers, programmers, and testers.• Developed Custom ad-hoc, Tabular, Drill Down, and Parameterized, cascaded and sub-reports using SSRS 2008.

• Build SSIS Master and child packages for initial load of data and incremental (monthly) loads of data for small data mart consisting of 10 standard type1 dimensions and 4 aggregated fact tables.• Manage the ETL function and use of staging tables.• Proactively diagnose, research, monitor for and resolves SQL and database-related faults and performance problems• Develop and maintain appropriate repositories of data model and dataflow diagrams relating to the data warehouse. • Ensures that data projects follow prescribed agile development life cycle and meet quality standards• Function as a technical expert in the design, development, modification and debugging of data OLAP cubes and databases, etc. • Advise technology architects on database subjects appropriate for supporting ongoing development efforts• Develop ETL specifications, source to target mapping and other documentation required for ETL development. • Ensure appropriate documentation is completed and stored in the repository database.• Built Reports in SSRS for errors generated in SSIS Packages.• Generated Reports using Data Source Views.• Developed Reports Using SSRS on statistical data during migration of data.• Created Drill Down, Drill through, linked and sub reports,highly parameter driven reports using SSRS 2008