Power Bi Sql Server

Venkata Lalitha Kodukula Power BI Developer

SUMMARY:

Over 8 years of experience developing Power BI reports and dashboards from multiple data sources through the use of data blending tools in Microsoft BI tools.

Experience with Microsoft Power BI Premium, Power BI Pro, Power Query, Power Pivot, Power BI Service, Power BI Desktop, Microsoft Excel Pivot Tables, and data models to gather information from multiple sources and deliver it to the user.

Ability to gather and deliver information from multiple sources using Power BI Suite (Power Query, Power Pivot, Power BI Pro, Power BI Desktop).

Experience in developing, designing, and supporting interactive Tableau dashboards.

Knowledge of Microsoft SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS), facilitating efficient data integration, reporting, and analysis.

Expertise in writing complex stored procedures, views, data imports and exports, as well as system views.

Knowledge of row transformations, partial blocks, and block transformations, which are essential to optimizing data processing and transformation tasks in SQL Server environments.

Comprehensive working knowledge in SSRS, Crystal Reports, and MS Excel, including drilling-down reports, parameterized reports, charts, dropdowns, and incorporating images to enhance visualization and analysis of data.

Experience building Power BI reports using complex calculated fields, table calculations, filters, parameters, and Excel based on requirements, and publishing them in Power BI Server dashboards in a visualized form such as Bar Charts and Pie Charts.

Expertise in Data Warehousing methodologies and concepts, including star schemas and snowflake schemas, ETL processes, dimensional modeling, and reporting

Profound knowledge of logging and error handling in SSIS packages using Event Handlers.

Effective in gathering Business Requirements, documenting System Requirement specifications, Functional Requirement specifications, and maintaining them.

Expertise in both Waterfall and Agile project methodologies, enabling efficient collaboration and project management.

Capability of setting priorities, scheduling work, and meeting deadlines. Team player and communicator of the highest caliber.

TECHNICAL SKILLS:

Power BI Tools

Power BI Desktop, Power BI Gateway, Power Query, DAX, Power BI App, SSIS, SSRS, SSAS, Tableau Desktop, Tableau Server

ETL Tools

SQL Server Integration Services, Informatica

RDBMS

SQL Server 2019/2016/2014/2012/2008, snowflake

Software Packages

MS - Excel, PowerPoint, Word, TOAD

Application Administration

Oracle WebLogic Server

Methodologies

Agile, Waterfall, RAD

Operating System

Windows Linux.

PROFESSIONAL EXPERIENCE:

Client: Tuft & Needle, Phoenix, AZ May 2024 – Till Date

Role: Power BI Developer

Responsibilities:

Using Power BI's powerful data visualization features, integrated Excel and SQL Server data seamlessly.

Integrated Power BI reports into other applications using embedded analytics, such as Power BI service (SaaS) or APIs.

Developed Power BI Dashboards from the Web and published Power BI Reports.

Supported SSRS, Power BI, and Tableau reporting applications by designing and implementing data extracts.

Improved drill through and hyperlink functionality has been implemented within Power BI reports.

Formulated Calculated Columns and Measures based on the client's requirements using DAX queries.

Generated Power BI computed columns from DAX Queries, as well as DAX calculated measures.

Using Power BI, create visually appealing and interactive dashboards that are easy for stakeholders to understand.

Ensured mobile app and web client accessibility and usability by deploying Power BI dashboards.

Discover trends, patterns, and relationships within datasets using exploratory data analysis (EDA) using Power BI.

Extracted, cleaned, transformed, and loaded data into data warehouses using ETL (SSIS).

Developed a data analysis prototype using Power BI and Power Pivot, and visualized reports using Power View and Power Map.

Managing and monitoring Power BI environment, including active product backlog and ongoing changes.

Environment: Power BI, Power BI Desktop, Power BI Gateway, Power Query, SQL Server 2022, SSIS, SSRS, T-SQL, Tableau, SQL Profiler, Windows

Client: Zions Bank, Salt Lake City, UT Jan 2023 – Apr 2024

Role: Power BI Developer

Responsibilities:

Determined the best solution to provide the results in Power BI reports to support strategic decisions within the organization.

Developed and maintained data models to support reporting and analysis.

Created interactive dashboards and reports in Power BI to visualize data insights and support data-driven decision-making.

Schedule data refreshes and update dashboards automatically using Power BI automation processes.

Participated in the development and execution of complex data transformations using SSIS packages to load data from multiple sources into destination tables while ensuring data accuracy and consistency.

Developed and deployed SSIS packages for data extraction and loading, including Slowly Changing Dimensions, Lookup, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast, and Data Conversion.

Provided support to supply chain analysts in automating reporting through Power BI tools such as Power BI reporting, Dashboards & Scoreboards (KPIs), and MySQL, AWS, and Data Warehouse.

Implemented sub-reports, dynamic sorting, data source definition, and subtotal definition in SSRS reports.

Maintain data history by developing T-SQL queries and stored procedures (DDL and DML).

Created SSIS ETL solutions using SSIS transformations such as lookup, merge, derived columns, data conversion, conditional splits, and aggregations.

Utilized Power BI Gateways to update dashboards and reports.

Utilized Power BI to develop Dashboards and Scorecards for the Finance Department.

Pivoted and unpivoted the data model in Power BI to perform data cleansing and massaging.

Troubleshooted reports in Power BI workspaces whenever issues occurred.

Environment: Microsoft Power BI, Power BI Desktop, Power BI Service, Power Bi pro, SSIS, SSRS, SSAS, SQL Server 2019, ORACLE, SQL Developer, PowerShell, Windows.

Client: Sagarsoft India Limited, Hyderabad, India Jul 2020 – Dec 2021

Role: Power BI Developer

Responsibilities:

Develop reports and dashboards using Power BI desktop from on-premises and cloud data sources.

Connected various data sources to Tableau to create ad-hoc reports for users. Identified existing business requirements in Tableau.

Presented interactive dashboards in Power BI to Business Users, Program Managers, and End Users.

Utilized Power BI to create dashboards and scorecards with business KPIs.

Utilized Control Flow and Data Flow to simplify data processing by implementing a centralized SSIS Master Package.

Implemented variables, breakpoints, checkpoints, logging, package configuration, and event handlers in order to enhance the functionality and performance of SSIS packages.

Utilized SQL Profiler, Execution Plan, and Index Tuning Wizard to ensure efficient retrieval and processing of data from the database, SQL queries, and stored procedures.

Using Microsoft Visual Studio, prepared MDX queries for Analysis Services and Reporting Services.

Using Power BI Power Query, exported data from external sources, modified it in Excel, and created SSIS packages for importing excel sheets to database.

Scheduled daily data refreshes and integration of Power BI with the on-premises data gateway.

Calculated columns and measures in Power BI and Excel using DAX queries based on requirements.

Generating reports and analyzing data for the business using SQL Server Analysis Services (SSAS) through a secure connection.

Using a query editor in Power BI performed certain operations like fetching data from different file.

Built a Tabular Model cube from scratch and linked it to SSRS and Power BI using MDX and DAX queries.

Environment: Power BI, Power Bi Desktop, Power Query, Power BI Data Modeling, DAX, SSAS, SSRS, ETL, Microsoft SQL Server, Share Point, MS Excel, Tableau, MDX, Agile, Windows.

Company: iPrism Technologies, Hyderabad, India Jan 2019 – Jun 2020

Role: Power BI Developer

Responsibilities:

Developed custom calculated measures in Power BI using DAX and migrated existing Ad-hoc reports.

Implement a Power BI dashboard for a B2B company to track their sales team's performance and identify areas for improvement.

Performed Data Folding and Query reduction techniques, and Data Silos have been taken care of while implementing Steps with transformations on Power Query.

Executed comprehensive data transformations and manipulations using SSIS packages, including Derived Columns, Conditional Splits, Lookups, Merges, Row Counts, and Data Transformation.

Developed complex reports using Microsoft Reporting Services, including drill-downs, drill-throughs, and crosstabulations.

Assisted with the migration of data analytics from Tableau to Power BI.

Implemented business requirements-based schedules for data refreshes on-premises.

Implemented Live Connection, performed Direct Query, and imported data.

Contributed to the creation and maintenance of the app's content.

Utilized command line tools to deploy SSIS packages, SSRS reports, and SSAS cubes, including SSRS properties.

Implemented various filters to analyze and validate new SSRS reports.

Constructed MDX queries for Analysis Services and Reporting Services.

Utilized OLAP data and offline sources to create, design, develop, and test PivotTable and PivotChart reports.

Optimised cube performance using multiple partitions and aggregations.

Environment: Power BI Desktop & Service, DAX, Power BI Service, Power BI Data Gateway, SQL Server 2014, SQL Server Integration Services (SSIS), Reporting Services (SSRS), TFS, Pivot Tables, MS Visual Studio.Net, C#, SQL Profiler, Windows.

Company: W3 Soft Tech, Hyderabad, India Apr 2016 – Dec 2018

Role: SQL Server BI Developer

Responsibilities:

Implemented Stored Procedures, functions, and triggers to improve the productivity of the claims processing system by converting data logically.

Developed a number of transformations for all SSIS packages, including Derived Columns, Conditional Splits, Lookups, Merges, Row Counts, and Data Conversions.

Utilized SQL Profiler and the Database Engine Tuning Advisor to troubleshoot SQL Server technical issues.

Created SSIS packages to extract, transform, and load data using a wide range of transformations, including Lookups, Derived Columns, Condition Splits, Aggregates, Pivots, Slowly Changing Dimensions, and Merge Joins and Unions.

Managed packages using SSMS using the SQL Server Agent on a daily, weekly, and monthly basis.

Implemented SSAS cubes to provide aggregate reporting.

Developed pivot table reports using MDX calculations and DAX expressions.

Schedule SSIS packages to run automatically on a nightly basis into the Data marts.

Managing the deployment activities for production.

Responsible for tuning SQL commands' performance and troubleshooting SQL Server technical problems utilizing the SQL Profiler and Database Engine Tuning Advisor.

Design and develop complex reports using MS Reporting Services, including drill down, drill through, and cross tabbed reports.

Used SSRS Report Builder to create ad hoc reports and subscription reports based on parameters, queries, and reports.

Environment: MS SQL Server, TFS, T-SQL, SSIS, SSRS, Excel, Visual Studio, Windows.

Contact this candidate