SUMMARY

• Extensive experience as Microsoft Power BI developer, database developer and data analyst with Microsoft SQL Server SSIS/SSRS/SSAS, OLTP, OLAP (Different environment such as Production, UAT, and development) and Power BI in various domains.
• Strong programming experience in TSQL, PL/SQL Development (SQL SERVER) and Report Development (SSIS, SSRS), Performance Analysis, Deployment Script Development, Production Support.
• Worked on all the Products in Power BI such asPower BI Desktop, Power BI Pro, Power BI Embedded, Power BI Report Server.
• Assist end users with problems installing thePower BI desktop, installing and configuring the Personal and On - Premises gateway, connecting to data sources and adding the different users.
• Experience in Power Apps applications & BI development using the Microsoft Power Platform.
• Involved in Requirement Analysis, Functional Analysis, Design, Development, Implementation, Testing, Debugging and Maintenance of Power BI Applications.
• Hands on experience of configuring components of Dynamics 365 and office 365 product stack.
• Expertise Knowledge in writingDAX Queries and MDX Queries.
• Published reports to Azure - based Power BI services (Pro) and schedule subscription and various sharing options (workspace, content pack, and Apps).
• Experienced in design and development of SSIS packages to Extract, Transform and Load data from heterogeneous sources (excel, flat files) to data warehouse (OLAP) according to user requirements.
• Extensive experience in implementing ETL, Microsoft BI/Azure BI solutions like Azure Data Factory, Power BI, and Azure Data bricks, Azure Analysis Services, SQL Server Integration Services, SQL Server Reporting Services and Tableau.
• Experience in Deploying and Monitoring ETL packages in SQL Server by job scheduling the flow of packages from Development Server to Test and Production Server.
• Proficient in optimizing SQL queries, performance tuning using SQL Profiler as well as understanding execution plans.
• Experienced in creating various reports like Tabular, Matrix, Drill down, Drill-through, Parameterized, Cascading, Conditional, Chart, Sub Reports and Deploying Reports in report server.
• Developed SQL queries for data extraction, analysis and reporting.
• Strong Knowledge in Data Analytics tools such as Power BI, Tableau etc.
• Expert in generating reports using SQL Server Reporting Services (SSRS).
• Proficient in SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, and SQL Profiler.
• Worked in all the products in Power BI such as Power BI Pro, Embedded, Premium, and Power BI Mobile.
• Experience in Cube designing in BI Development Studio(SSAS)to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Experience in creating different types of Complex Reports usingSSRS.
• Experience in analyzing design, development and application usingSQL Server Integration Services(Control Flow, Data Flow, Error Handling, Datatransformation Tools, Data Conversion).
• Experience at building and deploying multi-valued parameterized reports usingPower BI,Tableau.
• Experience in Developing and ExtendingSSASCubes, Dimensions and data source viewsSSAS-Data Mining Models and Deploying and ProcessingSSASobjects.
• Experience in buildingTabular Model Cubefrom Scratch in Databases with differentMeasuresandDimensions.
• Worked withConfidential Power BI,DAX expressions, Power View and Power Query integrated with share point.
• Experience in developingOLAP Cubesby using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Experience in a fast-paced Agile Development Environment, Test - Driven Development(TDD)and Scrum.
• Experience in calculating measures and dimension members using multi-dimensional expression(MDX),mathematical formulas, and user-defined functions.
• Experience with SQL Server Reporting Services(SSRS)and generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts inSSRS/Power BI.
• Having Knowledge onSQL Azure,Azure Data warehouse,Azure Data Lake.
• Cloud computing implementation experience using Azure Data Lake, Azure Data Factory, Azure Machine Learning & Power Shell scripting.
• Excellent Analytical, Problem-solving Skills, and Communication Skills, a Motivated Team-player with Excellent Inter-Personal.

TECHNICAL SKILLS

Data Warehousing/BI Tools: SQL Server, Business Intelligence Development - Power BI, SSIS, SSAS, SSRS, DTS, Tableau.

Database tools: Management Studio, SQL Profiler, Database Tuning Advisor, Query Analyzer, DTS, Performance Monitor, Client Configuration Utility, Server Configuration Utility, Big Query, Azure SQL, Azure Data Factory.

Power BI Tools: Power BI Desktop, Power BI Gateway, Power Query, DAX, Power BI App, SSIS, SSRS, SSS.

Operating System: Windows, Unix/Linux

Visualization Tools: Power BI, Tableau, Power Pivot, Qlik.

Auxiliary Skills: MS Office Suite, Microsoft Visio, ER Modelling, Erwin.

PROFESSIONAL EXPERIENCE

Confidential

Sr. MSBI/Power BI Developer

Responsibilities:

• Import data from different data source to create Power BI/Cognos reports and dashboards.
• Involved in creating dynamic well-organized, accurate and insightful Power BI/Tableau reports/dashboards to support strategic decisions.
• Worked on end to end project in Azure Environment by pulling the source data from SQL Server and storing the data in Azure SQL Server using Blob Storage and creating reports using Power BI Desktop.
• Expertise in data transformations such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split column, Date & Time Column, etc.
• Created different reports in Power BI Desktop and publish to Power BI online.
• Strong knowledge in SQL Server and SSIS, SSAS, SSRS experience in data visualizations and report development with Cognos.
• Worked on Power BI desktop and power BI service to publish the reports.
• Created complex calculations using DAX.
• Created reports like Drill-Down, Drill-Through, Chart, Sub Reports Bar charts, Line charts, Pie charts using SQL Server Reporting Services (SSRS).
• Defined the report layout in SSRS. Created complex stored procedures for Reporting services, Analyzed Reports and Fixed Bugs in stored procedures.
• Implemented SSIS packages to load the Data into Staging, ODS and dimensional model.
• Designed and developed SSIS packages using various control flow and data flow items to transform and load the data from various databases and into server integrations services (SSIS).
• Configured package with checkpoints, package logging, error handling and event handling to redirect error rows and fix the error in SSIS.
• Developed Lookup Transformation package for data matching, compare source and destination data based on id and get the new and updated records and then used conditional split to select that new records before inserting into the database.
• Created Dimensions with the cube wizard and T-SQL programming. Refreshing the cube to get the latest information updated for OLAP databases. Deployment of Cubes to the production server.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Created Clustered and Non-Clustered Indexes on tables for performance optimization of complex stored procedures.
• Generated daily, weekly and monthly reports for the managers.
• Provided 24X7 production support to ensure timely and error free delivery of reports.

Confidential, New York

Power BI/MSBI Consultant

Responsibilities:

• Developed SSIS packages for extract/load/transformation of source data into data warehouse/OLAP cubes as per the functional/technical design and conforming to the data mapping/transforming rules.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script taskandSend Mail tasketc.
• Performed data cleansing, enrichment, mapping tasks and automated data validation processes to ensure meaningful and accurate data was reported efficiently.
• Developed free-form reports using SSRS for consolidating multiple reports into single report delivered in .pdf format to the power users.
• Developed parameterized reports,drill down, drill through reports,sub reportsas per the report specifications and functionality.
• Implemented complex business logic throughT-SQL stored procedures, Functions, Viewsandadvance query concepts.
• Created databases and schema objects including tables,indexesand appliedconstraints, connected various applications to the database and written functions, stored procedures and triggers.
• Data copied from ADLS to Azure SQL database using ADF pipelines invoked using PowerShell scripting.
• Provided valuable suggestions to users in terms of database design and new application implementation to overcome existing performance and reliability issues.
• Created report schedules and subscriptions. Created data drivensubscriptions, reports that run on demand, cached the Reports, Snapshot of the Reports. Deployed reports both to theSharePoint server, IIS Server, Integrated SharePoint serverwith Report Server.
• Performance tuned long running lengthy SSRS reports and optimized rendering time by 10 times of the actual time.
• Integrated Custom Visuals based on business requirements usingPower BI desktop.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to supportPower BIand SSRS reports.
• Developed complex calculated measures usingData Analysis Expression language (DAX).
• EmbeddedPower BIreports on SharePoint portal page and also managed access of reports and data for individual users using Roles.
• Provided 24X7 production support to ensure timely and error free delivery of reports.
• Performed performance tuning and optimization of SQL queries to improve query performance and to reduce runtime.
• Extensively worked on enhancements and performance issues of the existing data import processes.
• Developed Multi-dimensional, OLAP cubes as per the specifications using SQL Server Data Tools. Participated in the design, development ofhierarchies, dimensions, attributes, properties, calculationand allocation routines for delivering the desired KPI’s in the Cubes.
• Independently worked on different stages of SDLC by gathering requirements, managing development, providing support and documentation processes thereby ensuring timely deliverables and uninterrupted continuity of business.
• Developed meta-data structure and configuration for storing/preserving database connection and security parameters usingSQL Server configurations, XML configurations.

Confidential, Tampa, FL

Power BI Developer

Responsibilities:

• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Hands-on working on dummy projects with creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, and Histograms in Power BI.
• Developed Custom Visualization in Power Bi such as Fuel tank, Liquid fill Gauge, Charts.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required.
• Familiar with Apps work spaces and Embedding power bi reports from Power BI Service.
• Published Power Bi reports to end user via mobile and content packs.
• Worked on Data Cleansing Part in Power BI desktop using concepts such as, Merge Columns, Merge Queries with necessary joins, Pivot, Un pivot and Transpose columns and rows in query editor
• Created the KPI to show the difference between actual, budget and forecast data using visuals such as DUAL KPI, KPI and Power KPI
• Created and Presented Power point presentation to business users on Prototype and Wire frame of Power bi reports visually every week.
• Worked on Type script, D3 Java script, html, CSS and developed custom visualization in Power BI.
• Created KPI, Gauges, Clustered column chart, Slicers for better understanding of the report

Confidential

BI Data Analyst

Responsibilities:

• Gathering requirements from clients and convert to user stories for the internal teams.
• Highly analytical and process-oriented data analystwith in-depth knowledge of database.
• Furnish insights, analytics and business intelligence used to advance opportunity identification, process reengineering and corporate growth.
• Developed Key Performance Indicators to monitor sales and decreased costs
• Spearheaded data flow improvement.
• Successfully interpreted data in order to draw conclusions for managerial action and strategy.
• Used statistical techniques for hypothesis testing to validate data and interpretations
• Presented data and conclusions to team in order to improve strategies and operations.
• Proposed solutions to improve system efficiencies and reduce total expenses.
• Manage the planning and development of design and procedures for metrics reports
• Develop new reports and delegate tasks to team members
• Perform market analysis to efficiently achieve objectives, increasing sales
• Investigate and conduct studies on the forecasts, demand, and capital of products
• Optimized data collection procedures and generated reports on a weekly, monthly, and quarterly basis
• Used advanced Microsoft Excel to create pivot tables and pivot reporting, as well as use VLOOKUP function.