Power Bi Business Intelligence

Location:

Houston, TX

Posted:

March 23, 2025

Contact this candidate

Resume:

Vishnu Vardhan Kondru

Sr Power BI developer

Professional Summary:

Total 10 +Years of IT Experience in performing development and implementation of Applications in Business Intelligence using Power BI, SSAS Attentive collaborator and communicator from project conception to completion. Creative in devising solutions to improve business operations and meet clients' technical needs. Seasoned team leader possessing the technical and interpersonal skills to provide exceptional project deliverables. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy. Technical expertise in detail follows.

·Power Automate flow development to integrate existing and future systems used at the client including Smart Sheets, Microsoft 365 services, etc. Power BI report support.

·API development to integrate existing and future systems used at LIPA.

·Work with project team and business stakeholders to understand requirements, conduct prototype demos, and implement solutions into production.

·Template development repeatable business processes.

·schedule and management activities through clearly defined project tasks, executing according to project schedule, and developing comprehensive project status reports.

·Provide training and support materials to staff on using Power Automate

·Experienced in Data Visualization and Data Modeling and Involved in Mentoring a team of 7 members.

·Created metrics and KPIs for health care, Pharma, retail, and Supply chain clients.

·Use multiple OOTB Connectors with PowerApps and Flow.

·Re-write and re-engineer custom legacy applications to PowerApps solutions.

·Adept at leveraging new approaches to solutions for system design and functionality.

·Interpret and design database models (MYSQL, SQL Server, etc.).

·Create documentation for projects including design, asset inventory, diagrams, and presentations as well as documentation of the environment and deployment for our support and future implementations teams.

·Communicate proposed designs and progress on the work to customers, team leads, and team members.

·Support cross-functional project teams consisting of app development, IT operations, and information security.

·Modelling and developing robotic processes using Microsoft Power Automate during the project development stage.

·Good knowledge of end-to-end automation analysis and feasibility.

·Plan and execute the deployment of O365 solutions, including managing code releases, versioning, and ensuring smooth transition and user adoption.

·Convert business requirements into technical specifications and decide timeline to accomplish.

·Oversee assigned programs (e.g., conduct code review) and provide guidance to team members.

·Experienced Scrum Methodology and Agile .

·Responsible for implementing very large-scale data intelligence solutions around Snowflake Data Warehouse.

·Developing ETL pipelines in and out of data warehouse using combination of Python and Snowflakes Snow SQL

Writing SQL queries against Snowflake.

·Provide production support for Data Warehouse issues such data load problems, transformation problems.

Technical Skills:

Technologies

Office 365, Microsoft Power Platform, Power Apps, Power BI, Power Automate, MS Flow, Share Point, Common Data service, Teams, Dynamics.

RDBMS

MS-SOL Server 2008/2012, Oracle, Data verse

Development Tools

Info-path, Power BI, Power Apps, Microsoft Flow, Power Automate, Azure Logic apps,

Application Tools

MS-Office, Jira, Confluence, MS SQL Server Management Studio. Photo shop

SOFT SKILLS

·Listening actively to a colleague as they talk you through a problem. Brainstorming ideas and benchmarking them against your competition.

·Modeling and predicting potential outcomes and financial impacts.

·Undertaking qualitative, quantitative, and cost analyses.

·Presenting and reporting the results of analysis to a broad audience.

·Identify what process needs to change.

·Analyze the pain points.

·Conduct a root cause analysis.

·Design and evaluate.

PROJECT MANAGEMENT

·Defining and controlling project scope, phased development, and deployment plan.

·Managing project planning, estimating, recruiting, and resource management

·Devising strategy for program execution rollout and release management

·Identifying, highlighting, addressing, and managing risks and issues

PROFESSIONAL EXPERIENCE:

FedEx, Remote Jan 2024 – Present

Sr. Power BI Developer

Responsibilities:

·Proficiently developed automated Power BI Reports, seamlessly integrating SharePoint as a data source, improving report generation efficiency by 40%.

·Gathered data from various external sources (Oracle) into a data warehousing system (Enterprise Cube) 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.

·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 including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI.

·Developed various dashboards to know the school climate, school safety, risk factors, and risk behaviors.

·Created dashboard for school system financial information which includes revenue and expenditure by district.

·Written some Java script plugin that makes the polygons work like hyperlinks.

·Specialized in transforming data into user-friendly visualization to give business users a complete view of their business using Power BI.

·Used various sources to pull data into Power BI such as SQL Server, oracle.

·Involved in installation of Power BI Report Server.

·Developed reports to visually explore data and create an interactive report Excel and Power BI.

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

·Created the KPI to show the difference between actual and forecast data.

·Working with import and direct query, creating custom table in the Power BI.

·Merge queries and append queries, remove columns, and split columns, choosing required columns in the data.

·By using Power BI desktop connected to various data sources, working with different visualizations.

·Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions.

·Implemented versatile filter mechanisms, including Visual Level, Page Level, and Report Level filters, optimizing data interaction and visualization accuracy.

·Implemented PowerShell scripts to automate routine administrative tasks within the Azure and Office 365 environments, enhancing operational efficiency.

·Designed and implemented robust Column-Level Security and Object-Level Security measures in SQL Server and Power BI environments, ensuring data integrity and compliance with regulatory requirements such as General Data Protection Regulation (GDPR) and HIPAA.

·Created Workspaces and Apps within Power BI Service (SaaS), enhancing user accessibility and streamlining data sharing across teams.

·Configured Tenant settings, providing control over Power BI features such as Workspace settings, Export and Sharing settings, publish to web, and Developer settings, ensuring data governance and compliance.

·Expertly managed Premium capacity planning, maintenance, updates, troubleshooting, access control, and performance optimization, maintaining a consistently high-performing Power BI environment.

·Developed custom DAX calculations tailored to business requirements, ensuring accurate and relevant business measures for data analysis.

·Administered report and dashboard permissions, tailoring access for diverse user groups, enhancing data security and user experience.

·Proficiently configured gateways and scheduled data refreshes for dashboards, ensuring data accuracy and timely updates.

·Leveraged the "Get Data" option to seamlessly import data from Excel into Power BI Desktop, simplifying data integration processes.

·Designed and developed impactful visualization reports and dashboards within Power BI, facilitating data-driven decision-making and insights.

·Authored effective reports and successfully published them to Power BI Service, making data readily accessible to stakeholders.

·Expertly handled data management tasks, including data connection, import, data shaping, transformation, and scheduling automated report refreshes.

·Ensured data security by managing read and write access for users and efficiently maintaining job schedules.

Airmaster Australia (VIC), Melbourne July 2022 – Dec 2023

Role: Sr. Power BI Developer

Responsibilities:

Gathered data from various external sources, including Oracle, and integrated it into a data warehousing system (Enterprise Cube) through ETL processes to support business intelligence and reporting needs.

Developed and optimized complex SQL queries in SQL Server and Teradata for data extraction, transformation and analysis, ensuring high performance and efficient data management across platforms.

Utilized SQL Profiler to troubleshoot, monitor, and optimize SQL Server and non-production database code, including T-SQL code written by developers and QA teams.

Designed and implemented Key Performance Indicators (KPIs) to measure and visualize the difference between actual and forecasted data, enabling better business decision-making.

Worked with Power BI to import and directly query data, creating custom tables, merging and appending queries, and performing data transformations such as removing and splitting columns to prepare the data for analysis.

Developed interactive dashboards and reports using Power BI, writing effective DAX formulas and expressions to deliver actionable insights to stakeholders.

Utilized Power Query within Power BI to clean, transform, and massage data, including pivoting and unpivoting data for improved analysis.

Created custom visuals in Power BI and implemented various visualizations, including tables, matrices, and charts, to represent data at different levels (report, visual, and page filters).

Established and managed row-level security (RLS) for Power BI reports, ensuring proper access control and data confidentiality based on user roles and permissions.

Developed and published reports using Tabular SSAS models as the data source in Power BI, and deployed reports to the Power BI service.

Automated routine administrative tasks using PowerShell scripts within Azure and Office 365, enhancing operational efficiency and reducing manual intervention.

Designed and implemented robust security measures, such as Column-Level Security (CLS) and Object-Level Security (OLS), within SQL Server and Power BI environments to ensure data integrity and compliance with regulatory standards like GDPR and HIPAA.

Collaborated with business stakeholders to design data models and visualizations tailored to meet business requirements, ensuring accurate and insightful reporting.

Led user training sessions, providing ongoing support to ensure effective utilization of Power BI tools and resolving any user-related issues promptly.

Monitored and optimized Power BI reports and dashboards to ensure peak performance and improved user experience.

Managed the extraction, transformation, and loading (ETL) processes for data integration into Power BI, ensuring data quality and consistency.

Enforced data governance policies within Power BI to ensure compliance with internal and external standards, including backup and recovery procedures to prevent data loss.

Conducted regular version control of Power BI assets to track changes, ensure stability, and maintain a reliable reporting environment.

Regularly engaged with customers to gather feedback, address concerns, and ensure project milestones and deliverables were met on time.

Continuously improved diagnostic plans and coding to resolve issues quickly and maintain development schedules.

Royal Automobile Club of Victoria, Melbourne Mar 2017 – June 2022

Role: Power BI Developer

Responsibilities:

·Used various sources to pull data into Power BI such as SQL Server and Oracle.

·Involved in the installation of Power BI Report Server.

·Developed reports to visually explore data and create an interactive report in Excel and Power BI.

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

·Created the KPI to show the difference between actual and forecast data.

·Working with import and direct query, creating custom table in the Power BI.

·Merge queries and append queries, remove columns, and split columns, choosing required columns in the data.

·By using Power BI desktop connected to various data sources, working with different visualizations.

·Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions.

·Utilized Power Query in Power BI to Pivot and Unpivot the data model for data cleansing and data massaging.

·Created several user roles and groups for the end-user and provided row-level security to them.

·Created Power BI Reports using the Tabular SSAS models as source data in Power BI Desktop and publish reports to service. O Worked on importing custom visualizations.

·Worked with table and matrix visuals, worked with different level of filters like report level, visual level filters, page level filters.

·Collaborated with domain experts to understand and characterize products and identify problematic issues.

·Discussed project progress with customers, collected feedback on different stages and directly addressed concerns.

·Identify and resolve technical issues, bugs, and errors within O365 solutions, perform debugging, and provide ongoing support to end-users.

·Ensure that O365 solutions adhere to security best practices, data governance policies, and compliance standards, such as GDPR or industry-specific regulations.

·Create technical documentation, user guides, and training materials to support the adoption and ongoing usage of O365 solutions by end-users.

·Continuously learn about new features, updates, and capabilities within the O365 platform, as well as industry trends and best practices, to enhance your development skills and deliver innovative solutions.

·Work collaboratively with cross-functional teams, including business analysts, project managers, IT administrators, and end-users, to gather requirements, develop solutions, and ensure successful implementation.

·Updated diagnostic plans and coding to address unforeseen issues and maintain prescribed development time frames.

·Checked client code for bugs and weaknesses using approved troubleshooting methods.

DXC Technology, India Aug 2014 to Dec 2016

Role: MS BI Developer

Responsibilities:

·Interface supports fast access to drug development results for specific diseases, companies, and countries. These results can appear as graphics-driven analytic dashboards or exportable files.

·Gathered data from various external sources (Oracle) into a data warehousing system (Enterprise Cube) 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.

·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 dashboards to know the school climate, school safety, risk factors, and risk behaviors.

·Created dashboard for school system financial information which includes revenue and expenditure by district.

·Written some Java script plugin that makes the polygons work like hyperlinks.

·Specialised in transforming data into user-friendly visualisation to give business users a complete view of their business using Power BI.

·Used various sources to pull data into Power BI such as SQL Server, oracle.

·Involved in installation of Power BI Report Server.

·Developed reports to visually explore data and create an interactive report Excel and Power BI.

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

·Created the KPI to show the difference between actual and forecast data.

·Working with import and direct query, creating custom table in the Power BI.

·Merge queries and append queries, remove columns, and split columns, choosing required columns in the data.

·By using Power BI desktop connected to various data sources, working with different visualisations.

·Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions.

EDUCATION:

·Bachelors in Electronics and Communication Engineering from JNTU, Kakinada (2010-2014)

Contact this candidate