SUMMARY

• 7+ years of extensive experience as Power BI Developer in Power BI / SSIS / SSRS / SSAS with exposure to Database Administration.
• Extensive experience in implementing Microsoft BI solutions like SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, Power BI and Tableau.
• Extensive experience in preparing Test Plans, Test Scenarios, Test Cases, Test Reports and Documentation for both Manual and Automated Tests.
• Experience in writing Complex SQL Queries involving multiple tables inner and outer joins.
• Proficient in creating multiple kinds of Power BI Reports and Dashboards.
• Worked on end to end project in Azure Environment by pulling the source data from SQLServer and storing the data in Azure SQL Server using Blob Storage and creating reports using Power BI Desktop.
• Creating complex Custom Views using Toad and SQL Developer to create data sets for Power BI dashboards.
• Good knowledge in MS SQL Server suite of products like SSRS, SSAS and SSIS of MS SQL Server
• Well versed with client server environment and tools like SQL Loader, UNIX shell scripts and TOAD
• Involved in importing the data from various source systems and create the rich dashboards using Power BI.

TECHNICAL SKILLS

Programming Languages: C, C++, SQL, T - SQL, PL/ SQL

RDBMS: MS- SQL Server, Oracle 9i/10g, Microsoft Access, DB2

ETL Tools: SQL Server Integration Services (SSIS) 2005/2008/2012 , DTS

Reporting Tools: SQL Server Reporting Services (SSRS),QlikView 11,Tableau

Database Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), Enterprise Manager, SQL Profiler, Teradata, Query Analyzer

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. Power BI Developer

Responsibilities:

• Implemented Role based access security using Microsoft Power BI.
• Interacted with the business users for understanding the business requirements and the existing system Understanding the business requirement and functional specification of the client module with Business Executives & Analysts.
• Fetched the data from different sources like SharePoint, and cloud solutions like O Data feed and MS Access data base - Flat files, SAP BEx queries, SAP HANA Calculation Views. Able to load data from Excel, Flat Files, XML, different databases and SQL database .
• Developed Tableau and Microsoft Power BI Dashboards to showcase the result of data analysis from the database.
• Developed Tabular Reports, Sub Reports, Matrix Reports, drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Involved in creating MDX,DAX, Cubes and Tabular models using SQL Analysis Services (SSAS).Used different types of visualization Like (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer etc.) in Power BI according to the requirements.
• Generated dashboards in POWER BI Desktop and POWER BI Service using super-fast slice and dice and modern data visualization features.
• Defined and created MicroStrategy reports and dashboards on system performance and utilization metrics for preventive monitoring and effective capacity planning.
• Integrated custom visuals based on business requirements using Power BI desktop
• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Migrated existing Qlikview reports to POWER BI reports.
• Created Gauge Report, Sub Reports, Drill down Reports, Summary Reports, Linked Reports and Parameterized Reports in SSRS for different departments.
• Implemented skills like MS Power BI. Practical knowledge on Tableau, Azure related data management and good exposure to Python and Hadoop.
• Using parameterized loading of data into the OLAP tables and Cognos cubes.
• Implemented dashboards and scorecards with power pivot for executive management for data insights as per business requirements.

Environment: SQL Server, SQL Server Management Studio (SSMS), Visual Studio, SSAS Tabular Cubes, T- SQL, Excel, DAX, SSIS, Business Intelligence Development Studio (BIDS), TFS, R, GIT, Azure Analysis services ( AAS) and Power BI.

Confidential, Tampa, FL

Power BI Consultant

Responsibilities:

• Built and published customized interactive dashboards utilizing Power BI.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
• Applied transform rules Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split.
• Created new measures and new calculated columns for reports and dashboard analysis.
• Utilized the Agile Scrum methodology to analyze the requirements to create stories.
• Extracted data from Oracle, SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data.
• SS
• Wrote DAX Expressions, Power Query, Functions in Power BI .
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), to support Power BI and SSRS reports.
• Involved in SQL testing to meet business deadlines.
• Used different types of visualization Like (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer etc.) in Power BIaccording to the requirements.
• Implemented data migration from Microsoft Azure cloud platform to on-premises data servers utilizing Azure cloud technology.
• Created various SSRS dashboard reports for commission, sales and profit analysis.
• Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
• Implemented Star and/or Snowflake schemas while designing relational database and data warehouse as per business and report requirements.
• Used Microstrategy dashboards for data analysis and custom reports.
• Adopted Agile Software Development Methodology.

Confidential, Boston, MA

SQL Developer / Data Analytics

Responsibilities:

• Data analytics and engineering experience in multiple Azure platforms such as Azure SQL, Azure SQL Data warehouse, Azure Data Factory, Azure Storage Account etc. for source stream extraction, cleansing, consumption and publishing across multiple user bases.
• Developed SQL queries or Stored Procedures used by reports to retrieve information from Relational Database and Data Warehouse.
• Actively involved in Developing, executing and managing T- SQL stored program units, like procedures, functions, packages and database triggers.
• Wrote T- SQL queries, created tables and indexes, store procedure.
• Involved in analyzing the old database system and mapping tables, relationships, columns to SQL Server.
• Efficiently worked in installation, configuration, design, implementation of staging database for data migration and data entry.
• Developed SQL scripts to Insert, Update and Delete data in MSSQL database tables in OLTP environment.
• Used Microstrategydashboards for data analysis and custom reports.
• Developed SQL queries, Stored Procedures, and data mining as necessary in collaboration with the Database developer and BI Team as needed.
• Developed Custom SQL scripts to view required claim data in developed dashboards
• Gathered software requirements from clients and end users