SUMMARY

• Around 7 years of professional experience in developing and designing Business Intelligence solutions utilizing SQL Server and Power BI.
• Experience in developing, implementing, documenting, monitoring and maintain the data ETL process in various industries like Financial, Health Care, etc.
• Ability to work with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation using Waterfall and Agile methodologies.
• Ability in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Data Import and Export.
• Working with DAX formulae for creating variables like Previous Month, Previous Quarter, etc. and creating interactive visuals using geographic data.
• Expertise inPower BI Desktop, Power BI Service, Power BI Pro, Power BI Mobile.
• Experience in Power BI Desktop, Report Service, Gateway Connectors, Data Models, Relationships, Publishing / Updates to Apps Work spaces, Data On - Demand Refreshes, Scheduling, Testing and Deployment.
• Imported data using Azure Data Link (ADL) to SQL Server in Power BI to generate reports.
• Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, and Excellent knowledge in RDBMS concepts and Data Warehouse Concepts.
• Involved in publishingPowerBIDesktop reports to thePowerBIservice.
• Designed reports in SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Cubes, SQL Server Integration Services (SSIS), and Power BI
• Good understanding of the Data modelling (Dimensional & Relational) concepts like Star Schema Modelling, Snowflake Schema Modelling
• To generate underlying data for the reports and to export cleaned data from an Excel Spreadsheet, Flat file and CSV files to the data warehouse.
• Experience in Microsoft Azure Portal, Azure Data bricks, and Azure Cosmos DB and creating data pipelines and building governance model
• Experienced on creating multiple kind of Report in Power BI and present it using Story Points.
• Worked on all aspects of the ETL pipeline, as well as aggregated and reported on operational system metrics, using Microsoft BI stack like SQL Server, SSIS, SSRS and SSAS.
• Database development for both OLTP and OLAP systems using MS SQL Server.
• Proven experience developing and managing data integration solutions using Microsoft BI technologies.
• Experience in creating complex reports in Power BI (List reports, Cross-tab reports, Drill through reports, Sub reports and Cascading prompts)
• Publishing Power BI Desktop reports created in Report view to the Power BI service.
• Possessing a high level of proficiency in Data Analysis Expressions (DAX) with demonstrated capabilities in this area.
• Experience working in Agile and Waterfall model working methodologies.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills.

TECHNICAL SKILLS

Reporting Package: Power BI( Desktop, Server, Pro), MS ( SSAS, SSRS), QMF

Integration Tools (ETL/ELT): Microsoft SSIS, ADF, SAP BI

Data Modelling: Star and Snowflake with Erwin, Visio, SQL Architect

Cloud reporting services: Azure

Database tools: Microsoft SQL Server Management Studio, SQL developer, Toad

MS Office: MS-Excel, MS-Access, MS- Power Point, Office 365, SharePoint

Databases: Oracle, SQL Server, DB2, Teradata, MySQL, XML, AWS-Redshift

Operating Systems: Windows, Linux

Languages: SQL, PL/SQL, T-SQL, Transact SQL, Python, R, PHP

PROFESSIONAL EXPERIENCE

Confidential

Power BI Developer

Responsibilities:

• Collaborated with Business team to gather requirements and analyses source data
• Utilized Power Query to make transformations like removing duplicates, data conversion, creating conditional column.
• Implemented DAX to get KPI’s which depicts MOM changes.
• Utilized Time Intelligence functions to calculate Year to Date sales, to get most recent month data
• Analyzed data in Source Database (SQL Database) and wrote SQL Query to get necessary column and remove unnecessary data
• Created VIEW’s in Azure SQL Database by writing complex T-SQL Queries to leverage data in the tables
• Maintained live connection to Power BI Dataset and Online Services
• Interact Actively with Business team to understand the expectations of End User and SLA’s
• Responsible to Create SQL Query by Joining Multiple Tables and Optimize SQL code in order to pull necessary columns and improve data loading
• Utilized connectivity mode to Import Data into Power BI using Direct/ Import based on Table size, also created lookup tables to maintain Relationship
• Create DAX functions for various fact calculations for efficient data visualization in Power BI
• Utilized Data Analysis Expressions, created Measures and Calculated columns based on requirement
• Designed Background Image of the report, maintained organizational font and colour code
• Designed Line charts, Bar charts, Trend charts in order to display streaming sets of Time Intelligence data on daily basis
• Utilized Power BI (Power View) to create various analytical reports that depicts critical KPIs such as Health Assessment Percentages and Risk factors etc.
• Responsible to Create Navigation Page using Buttons and Bookmarks feature in Power BI and design UI of the report as per SLA
• Worked on Page level, report level and Visual level filters and used Slicers to best design UI for Users
• Responsible for creating dynamical Conditional Display of Data based on Business Privacy requirement
• Responsible to Utilize Dynamic Row-Level Security and maintain Security for End- Users while Embedding Reports to Customers
• Responsible to Publish reports to Power BI Service and create Dashboards using Reports in Power BI Service.
• Created Flow to automate data export from Planner to Spreadsheet
• Developed application in PowerApps using Common Data Service CDS, Flow, Excel, Forms and SharePoint online.
• Unit tested data that Is loaded from Source databases in order to Test all calculations in Power BI
• Prepared Test scenarios and helped UAT to validate Reporting tool and Performance of the report
• Tested Application with large volumes of data and Validated tool performance with heavy traffic of requests from users
• Enabled Query Caching in Power BI Service to improve performance of the report and to meet SLA.
• Configured Power BI Gateway and Scheduled jobs in Power BI Service to keep reports up to-date with on premise data sources.
• Maintained Power BI Workspace and granted/ revoked permissions for USERS in Power BI Service
• Allowed Service Principle/ Application to Access reports as Admin

Confidential, Kansas

Power BI Developer

Responsibilities:

• Designing, Development and implementation at all levels. (Application frontend and backend as well). Pick huge amount data from client applications through Middleware language (XML) and loaded into current Application.
• Replicated Excel reports in Power BI and Developed Multiple Power BI Dashboards/Reports.
• Created complicated DAX measures in the Power BI reports as per the requirements of the Business Users. Generated Monthly, Yearly, Quarterly and Daily reports in Power BI.
• Assisted in Production OLAP, wrote queries to produce reports using SQL Server 2019, Reporting Service (SSRS)
• Designing current database by adding tables, relationships, creating stored procedures, views and performance tuning of SQL queries and stored procedures.
• Created Datasets using different data sources like Microsoft SQL Server, Microsoft Azure, Excel, and SAP HANA.
• Created Workspace and Apps in Power BI and giving access to End-users to Apps.
• Worked on Power BI, Power Pivot and Power View to visualize reports.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar, and density charts. Created Measures in Power BI depending on the requirement using DAX queries
• Configured Gateway in the Power BI service and Implemented Data security (Row-level security) on Dataset and Reports in Power BI. Worked on Power BI, Power Pivot and Power View to visualize reports.
• Developed Power BI reports and dashboards for multiple data sources using data blending.
• Performed data quality analysis using advanced SQL skills. Performed Count Validation, Dimensional Analysis, statistical Analysis and data quality validation and data migration. Extensive SQL querying on staging, Data warehouse and Data Mart.
• Explored data in a variety of ways and across multiple visualization using Power BI.
• Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models.
• Designed a Power BI Data Model with multiple Fact Tables and Dimensions depending on the business requirements. Generated Monthly, Yearly, Quarterly and Daily reports in Power BI.
• Created Measures in Power BI depending on the requirement using DAX queries.
• Responsible for Scheduling jobs for Weekly, Daily data refresh on different Power BI reports.

Confidential, VA

Power BI Developer

Responsibilities:

• Gathered data from various external sources into a data warehousing system with the help of ETL process.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints. Designed and developed web pages using VBScript.
• Wrote T-SQL (DDL and DML) queries, stored procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.
• Developed various solution driven views and dashboards by developing different chart types includingPie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI.
• Specialized in transforming data into user-friendly visualization to give business users a complete view of their business usingPower BI.
• Used various sources to pull data intoPower BIsuch as SQL Server, oracle.
• Involved in installation ofPower BI Report Server.
• Developed reports to visually explore data and create an interactive reportExcel and Power BI.
• Created reports utilizingSSRS, Excel services, Power BIand deployed them onSharePoint Serveras per business requirements.
• Using a query editor inPower BIperformed certain operations like fetching data from different file.
• Working with import and direct query, creating custom table in thePower BI.
• Merge queries and append queries, remove columns and split columns, choosing required columns in the data.
• By usingPower BI desktopconnected to various data sources, working with different visualizations.
• Developed and published reports and dashboards usingPower BIand written effectiveDAXformulas and expressions.
• UtilizedPower QueryinPower BItoPivot and Un-pivotthe data model for data cleansing and data massaging
• Created severaluser rolesandgroupsto the end - user and providedrow level securityto them.
• CreatedPower BI Reportsusing the Tabular SSAS models as source data in Power BI desktop and publish reports to service.
• Worked withtable and matrix visuals, worked with different level of filters likereport level, visual level filters, page level filters.
• Used various data visualizations withPower BI.
• Designed different types of KPI's for percentage growth in different fields and compared over the period of time and designed aggregations and pre-calculations in SSAS.
• MDXprogramming,DAXexpressions, analysis and business forecasts.
• Implemented OLAP cubes, facts, and dimensions for providing summarized and aggregate views of large database sets.
• Superior involvement in developing reports and dashboards from multiple data sources such as on-premises and cloud usingPower BI desktop.
• Creating reports from importing, direct query and live data from several data sources.
• Expertise in data transformations such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split column, date & time column.
• Experience in combining data from different sources by using ofpower query.
• Experience with, power pivot and dashboard designer.
• Troubleshoot and support reports inPower BI workspaceswhenever there are issues in production.

Confidential, Dallas TX

MSBI / Power BI Developer

Responsibilities:

• Played an active role during the requirements gathering, analyzing, and designing of the system
• Designed, reviewed, and created objects (Views, Indexes, etc.) based on logical design models, user requirements and physical constraints.
• Wrote variousT-SQLqueries,Stored Proceduresand used them to build packages.
• Created Triggers, Tables, Views, and SQL Joins for various applications.
• Analyzed the data using Statistical features in Power BI to develop trend analysis
• Wrote DAX expressions to create new measures, calculations per business requirements.
• Effectively used data blending, filters, actions, and hierarchies feature in Power BI.
• Used various sources to pull data intoPower BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Created indexes, Constraints, and rules on database objects.
• Created views and stored procedures and optimizing them.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Migrated packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL SSIS.
• Used Power BI for developing reports, data marts, KPI's and charts.
• Generated Custom ETL scripts using SSIS, develops and unit test SSIS load processes for performance check.
• Analyzing reporting requirements and develop various Dashboards, using trend lines and reference lines.
• Implemented Conditional Split, Lookup, Merge, Merge Join, Multicast, Union, Row Count, Fuzzy Grouping and Checkpoint, Transactions in SSIS.
• Created linked reports and managed snapshots using SSRS. Generated Sub-Reports, Crosstab, Conditional, Drill down reports, Drill through reports &Parameterized reports using SSRS
• Created no of views, calculated tables, calculated columns, and measures.
• Create and customize simple data visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges, and single-number cards.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile.
• Created Dashboards using Power BI and integrated with UI.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Migrate existing data into the Power BI.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Involved in Creating Complex Store Procedure using T-SQL to evaluate result for the repots to implement using Management studio.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Developed different Scripts for the Data analysts for Verification of reports.

Confidential

SQL BI DEVELOPER

Responsibilities:

• Experience in maintaining the existing system, fixing bugs and enhancements by creating packages using control flow, data flow components.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using For-Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail Task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, CDC Control Task, CDC Splitter, CDC Source, Slowly Changing Dimension and more.
• Experienced in developing data reports in SSRS & Power BI using DAX formulas, expressions, graphs involving multiple slicers, connecting to various sources for consuming data's, establishing connectivity using Power BI Gateway, deploying reports & Troubleshooting.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in writing T-SQL Queries, sub-queries and complex joins for generating Stored Procedures and Views.
• Created the Power BI report on data in ADLS, Tabular model, Azure Data bricks and SQL server.
• Knowledge in Project Management (Planning, Scheduling and Tracking)
• Code review, QA testing and fixing bugs (if any).
• Deployment and scheduling jobs through SQL Agent.
• Resolving technical issues faced by the team during development, deployment and support.