Power Bi Sql Server
Resume:
Mounika Gutha
************@*****.***
Sr. Power BI Developer
PROFESSIONAL SUMMARY:
• 6+ years of professional experience as a Power BI Developer, with extensive expertise in Azure cloud services, SQL Server, Business Intelligence tools, database design, data modeling, and data warehousing. Proven experience with SQL Server Management Studio, SQL Server 2017/2016/2014/2012/2008R2, and BI tools such as SSIS, SSRS, SSAS, Power BI, and Tabular Data Modeling.
• Deep proficiency in Microsoft Azure services, including Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI integration with Azure cloud environments for scalable data solutions and seamless BI reporting.
• Specialized in developing, deploying, and optimizing cloud-based BI applications using Power BI (Power BI Pro, Power BI Premium), ensuring real-time data access and business insights.
• Strong experience in data analysis, data modeling, and visualization, importing data from SQL Server, Oracle DB, APIs, and Azure Data sources into Power BI/Tableau for reporting and decision-making.
• Expert in Power BI tools such as Power Query, DAX, and Power Pivot, with advanced knowledge in developing complex data models, visualizations, and interactive dashboards in Power BI.
• Proven expertise in transforming and cleaning data with Power Query Editor, using parameters, query lists, tables, and records for efficient data preparation and transformation.
• Hands-on experience in implementing complex DAX functions, including aggregation, counting, logical, and date functions for enhanced data visualization and analysis in Power BI.
• Skilled in publishing Power BI reports from Power BI Desktop to Power BI Service, configuring dashboards, managing user access, and ensuring data refreshes within Azure-based environments.
• Strong background in designing and developing ETL processes using SSIS, integrating data from diverse sources into centralized data warehouses, leveraging Azure services for cloud-based ETL.
• Experience with optimizing Power BI performance using Power BI Performance Analyzer and applying best practices in DAX and data model optimization for high-performance reporting solutions.
• In-depth experience in Azure Data Factory and Azure SQL Database for data integration, ensuring scalability and efficiency in cloud-based BI solutions.
• Expertise in managing Power BI environments, including Power BI Service administration, tenant settings, audit logs, user permissions, and row-level security for secure and optimized report delivery.
• Extensive knowledge in implementing enterprise-level data pipelines, transforming data from on-premises and cloud sources into unified reporting platforms within the Azure ecosystem.
• Proven ability to develop and implement business solutions using Power Automate (Power Apps) to integrate with Azure-based data models and streamline workflows.
• Strong communication and collaboration skills, with a demonstrated ability to work closely with business stakeholders to gather requirements and deliver high-quality data solutions. TECHNICAL SKILLS:
Reporting Tools Microsoft Power BI, Tableau, SQL Server Reporting Services, Crystal Reports, Excel.
RDBM/Databases MSSQL Server 2016/2014/2012/2008 R2, Oracle 12c, MS Access, Microsoft Azure
Programing
Languages
SQL, C, DAX, Python, T-SQL, PL/SQL, HTML, C#, Java, Java script, CSS, Python, Windows Scripts
EDUCATION DETAILS:
Master’s Degree in Computer Science, TAMUK, Kingsville, USA Bachelor’s Degree in Computer Science, JNTUH, Hyderabad, India PROFESSIONAL EXPERIENCE:
Holland America Line April 2025- Present
Role: Sr. Power BI Developer / Admin
Responsibilities:
• Designed and developed operational reports using MS Power BI Desktop for various regional managers using table, matrix, bar, card, gauge, and slicer visualizations.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports.
• Participated in the Agile methodology's daily scrum and other sprint meetings; developed and prioritized product backlogs and the sprint burnt down charts etc. to meet the daily deliverables and timelines.
• Worked on all types of transformations that are available in Power bi query editor.
• Collaborated with business stakeholders to understand their requirements and translate them into effective data models, reports, and dashboards. Environment: Microsoft Power BI, Power Query, Power BI Service, DAX studio, Share Point, SSIS, SSRS, Power BI Report Builder, SQL Profiler Amazon Redshift, Visual Studio Code 2015, Sql data tools Data Modeling FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema, Relational, Dimensional and multidimensional modeling and De- Normalization Techniques
BI Tools Microsoft Power BI, Power Pivot, Power View, Power Query, Power Map, Power Apps, Power Automation, Microsoft Power BI Desktop, Power BI Service, Visual Studio (SQL Server Integration Services (SSIS), SQL Server Analytical Services
(SSAS), SQL Server Reporting Services (SSRS), SQL Server Reporting Services
(SSRS), SQL Business Intelligence Development Studio (BIDS) 2008, MS Data Tools 2012 / Visual Studio Shell
AZURE Cloud Azure SQL Database, Azure Data Lake, Azure Data Factory (ADF), Azure SQL Data Warehouse, Azure Service Bus, Azure Analysis Service (AAS), Azure Blob Storage. Cache using Pipeline and SSIS, Data Migration Service (DMS), Azure SQL Data.
Tools/Database
Utilities
SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, SQL Search, Import & Export Wizard, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Microsoft Azure, Azure Data Factory, Azure Databricks, Azure Data Lake, AWS
Version Control Team Foundation Server, Git.
Application
Packages
MS Office & tools
Operating Systems Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012/2016 Servers, HP-Unix, Linux, Solaris.
Nextera Energy Resources,FL May 2023 – April 2025
Role: Sr. Power BI Developer / Admin
Responsibilities:
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes & Views using T-SQL in Development and Production environment
• Created various dashboards in Power BI desktop using table, matrix, bar, card, gauge, and slicer visualizations.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Created Stored Procedures to transform the Data & worked extensively in T-SQL for various needs of the transformations while loading the data.
• Participated in performance tuning using indexing (Cluster Index, Non-Cluster index) tables.
• Designed and developed stored procedure, queries and views necessary to support the SSRS reports.
• Created and maintained interactive Power BI reports and dashboards to monitor and analyze KPIs, supporting data-driven strategic decisions.
• Automated reporting workflows by integrating data from SQL Server, Excel, and APIs into Azure data models, streamlining processes and reducing manual effort.
• Optimized data workflows and queries, reducing report generation time by 40% and improving business insights delivery.
• Built a cloud-based data analysis platform using Azure SQL Database and Power BI Service, improving access to real-time business insights.
• Worked with marketing, finance, and operations teams to define reporting requirements and deliver insights that shaped business strategies.
• Created various Drill through, Parameterized, Tabular reports and matrix reports using SSRS and created subscriptions for users.
• Designed and developed Power BI reports, self-service packages and dashboards for a large pool of business associates
• Designed and developed operational reports using MS Power BI Desktop for various regional managers and also created calculated measures and columns with DAX.
• Participated in the Agile methodology's daily scrum and other sprint meetings; developed and prioritized product backlogs and the sprint burnt down charts etc. to meet the daily deliverables and timelines.
• Used Power Apps visuals in power BI desktop.
• Worked with canvas apps in power App.
• Worked on all types of transformations that are available in Power bi query editor.
• Created stored procedures and SQL queries to pull data into power pivot model.
• Deploy and Configure Power BI dataset for Sales and Finance team, implement incremental refresh on Power BI dataset.
• Worked on Tabular Modeling Development and Multidimensional Modelling Development using SSDT.
• Designing and Developing the Dashboard Reports in Power BI using DAX.
• Performed DAX (Data Analysis Expressions) & MDX functions for the creation of calculations and measures in the Tabular Mode & multi-dimensional Cubes.
• Built a Tabular Model cube from scratch data and by MDX and DAX queries fetched data to SSRS and Power BI reports.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities
• Designed, developed and tested various Power BI and Tableau visualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.
• As a Power BI and Tableau SME responsible for the design, development and production support of interactive data visualizations used across the company.
• Solid experience in building interactive reports, dashboards, and/or integrating modeling results and have strong Data Visualization design skills and analytic background by using POWER BI and Tableau desktop. Created Workspace and Apps in Power BI and giving access to End-users to Apps.
• 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.
• Responsible for creating SQL data sets for Tableau recurring and Ad-hoc Reports.
• Created ad-hoc reports to users in Tableau Desktop by connecting various data sources, multiple views and associated reports.
• Developed Power BI reports and dashboards for multiple data sources using data blending.
• Written calculated columns, DAX, MDX, Measures queries in power bi desktop to show good data analysis techniques.
• Developed the reports in Power BI desktop, publish the report and pinned dashboards in the Power BI Service
• Created Drill Down, Drill Through, Book Marking and Hyperlinks features in the Power BI report.
• Extensively worked in analyzing profiling and modeling data in the Power BI Desktop using Query Editor and Relationship view.
• Involved in transforming the data from data sources and loading into the target databases using Informatica and generating reports using Power BI
• Converted various SQL statements into Stored Procedures thereby reducing the number of database accesses (since stored procedures passes the whole block at one time).
• Performed tune to optimize SQL queries using SQL Profiler and Query Analyzer.
• Worked on Creating, Modifying and updating the Views and Functions.
• Used SQL Seach and SQL Prompt tools.
• Created SharePoint workflows and forms using SharePoint Designer and Power Apps, streamlining business processes and improving productivity.
• Participated in code reviews and provided constructive feedback to ensure code quality and adherence to best practices.
• Conducted unit testing, debugging, and troubleshooting to identify and resolve software defects.
• Implemented security measures and followed industry best practices to protect sensitive data.
• Modified the existing stored procedures to get the new functionality depending on the client requirement
• Written Calculated Columns, Measures, and Queries in Power BI desktop and also Tabular model to show good data analysis techniques.
• Worked on creating Power BI Dashboards using tabular model.
• Created and Deployed reports using SSRS and configuring the SQL Server Reporting Server.
• Used Power Query to acquire data and Power BI desktop for designing rich visuals
• Extensive Dashboard design using Power BI
• Developed a Canvas Power Applications and Workflows using Power Automation.
• Publishing Power BI Desktop reports created in Report view to the Power BI service. Environment: Microsoft Power BI, Power Query, Power BI Service, DAX, Microsoft Azure, ADF, Azure Data Factory, Azure Cloud, Azure SQL Database, Azure Data Lake, Azure Blob Windows server, SQL Profiler, SQL Query Analyzer, SQL Search, SQL Server 2012/2016, Oracle Exadata, SQL, PL-SQL, Java Script, Share Point, Microsoft TFS, SSRS, T-SQL, Windows 7, MS Word, MS Excel, C#, Visio, Jira, SQL Profiler InkWall Technologies, Hyderabad, India Jan 2017 – Jan 2021 Role: Power BI Developer / SQL Developer
Responsibilities
• Extensively used joins and subqueries for complex queries involving multiple tables.
• Imported and transformed the data with power query editor by using the features like replace, extract, transform, append, merge, remove blank rows, splitting columns, pivot and load the data into the data Model.
• Created calculated columns and measures using Data Analysis Expression (DAX) language and also made use of the time intelligence functions like date, counting, logical and aggregation functions.
• Created workspaces and content packs to share the insights to business customers and partners.
• Integrated custom visualization according to the business requirements document.
• Migrated existing reports to Power BI.
• Used Bar Chart, Line chart, Area Chart, Pie, Donut, Gauge Chart, slicers and different levels of filters in Power BI reports according to business analysis.
• Analyzed large datasets using Power BI to track sales trends and identify areas for operational improvement.
• Developed automated reports through Power Query, enabling real-time data-driven decision-making across business units.
• Performed data validation, cleaning, and transformation using SQL and Power BI to ensure data consistency and integrity across systems.
• Provided troubleshooting support to business users, resolving complex data issues within Power BI and Azure environments.
• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User defined Data type, Clustered & Non-clustered Indexes
• Installed and configure servers and clients using SQL Server 2008, Upgraded SQL databases
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T- SQL code and SQL joins for applications following SQL code standards
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases
• Query optimizations (T SQL or Query Analyzer) using query analyzer and Index tuning wizards
• Knowledge of Database Performance monitoring tools
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS
• Created ETL SSIS packages both design and code to process data to target databases
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis
• Wrote T- SQL scripts to validate and correct inconsistent data in the staging database before loading data into the database.
• Extensively made use of the T-SQL in creating and altering stored procedures, tables, views and other SQL joins, statements and also created user profiles, relational database models, data dictionaries, and data integrity.
Environment – Power BI Desktop, Power BI Pro, DAX, Transact-SQL, MS SQL Server 2008 R2/2012, SQL Server Management Studio (SSMS), SQL Profiler, MS-Excel, Confluence.
Contact this candidate