Power Bi Business Intelligence

Gopinath Kosaraju

Email: ****.**********@*****.***

Mobile: +1-281-***-****

LinkedIn URL: https://www.linkedin.com/in/gopikosaraju Professional Summary

Having 13+ Years of Experience in Data warehousing and Business Intelligence (BI) with expertise in Tableau, Power BI, Alteryx, SQL and Hyperion.

Strong expertise in gathering business requirements and collaborating with stakeholders to translate business needs into actionable BI solutions.

Collaborating closely with the business users to identify KPI’s and designed solutions to enhance business decision-making.

Experienced in data cleaning, and analyzing structured and unstructured data from multiple sources, transforming complex raw data into actionable insights that support data-driven decision-making.

Extensive experience in developing SQL queries, joins, aggregations, and window functions, to efficiently extract, transform, and analyze large datasets.

Designed and implemented comprehensive data models and visualizations using Tableau and Power BI.

Expertise in building insightful data visualizations in Tableau and Power BI, leveraging data blending and multi-source integration.

Proficient in Optimizing Tableau workbooks, Dashboards, Reports, and Tableau Server to enhance performance, reduce load times, and improve user experience.

Developed and automated ETL workflows in Alteryx, streamlining data integration from multiple sources and reducing manual processing through scheduled workflows.

Proficient in developing advanced DAX calculations in Power BI to deliver actionable insights and support strategic, data-driven decision- making.

Skilled in utilizing Power Query features to clean and manipulate raw data, ensuring high accuracy and consistency prior to analysis.

Expertise in developing interactive dashboards and advanced visualizations using Tableau and Power BI to support decision-making process.

Specialized in building interactive dashboards and advanced visualizations with Tableau and Power BI, driving data transparency, performance tracking, and strategic decision-making.

Strong command of Tableau features such as Parameters, LOD’s, Filters, Actions, Hierarchies, Sets and Context filters in Tableau.

Hands-on experience in Tableau Server administration, including installation, configuration, upgrades, backup, performance tuning, and user management.

Performed regular Tableau Server backups, upgrades, and maintenance to ensure system reliability and performance.

Managed publishing, scheduling, permissions, and user roles in Tableau Server to ensure secure and efficient dashboard delivery.

Implemented Row-Level Security (RLS) and managed security roles in Tableau and Power BI to ensure data access was restricted based on user roles.

Managed and optimized Agile project workflows, significantly reducing bottlenecks and enhancing overall team performance and resulting increase in productivity.

Strong Hyperion background with expertise in Essbase cubes (ASO & BSO) development, application migrations (Essbase, Planning, HFM, HPCM, HFR, DRM) using LCM.

Having good Knowledge on AWS, Azure Data Factory. Technical Skills

Data Analysis and Visualization Tableau Desktop, Tableau Server, Tableau Administration, Tableau Online, Power BI Desktop, Power BI Services, Power Query, Excel

Data Warehousing and ETL/ELT

Tools

Alteryx, Azure Data Factory

Data Modelling Star/Snowflake schema

Databases SQL Server, Oracle, My SQL

Languages Linux Script, Python

Cloud database tools Snowflake, BigQuery

Version Control Jira, Microsoft Teams

Operating Systems Windows, Linux

Certifications:

Tableau Desktop Certified Specialist

Microsoft Certified: Azure Fundamentals

Work Experience:

LTIMindtree (Cisco – Austin, TX) Jul 2023 to Present Senior Power BI Developer

Tools and Technologies: Tableau Desktop, Tableau Server, Alteryx, Snowflake, SQL Server

Collaborated with cross-functional teams to gather requirements, analyze business objectives, and translate them into scalable data visualizations and dashboards, improving efficiency and decision-making across departments.

Analyzing data, identifying patterns, and created impactful visualizations.

Enhanced dashboard performance by 40% through advanced optimization techniques and efficient data modeling.

Monitored and fine-tuned dashboard performance to ensure fast loading times and smooth user experience, even with large datasets.

Designed and developed highly interactive Power BI dashboards to visualize key performance indicators (KPIs), enabling actionable insights for leadership and cross functional teams.

Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.

Installed and configured Power BI Gateways to automate dashboard and report updates.

Implemented Row-Level Security (RLS) by leveraging user functions and Tableau Server groups, ensuring that users only accessed data relevant to their roles while maintaining compliance with organizational governance and security policies. Mindtree (Aflac – Columbus, GA) May 2020 to Jun 2023 Senior BI Developer/Admin

Tools and Technologies: Tableau Desktop, Tableau Server, Alteryx, Power BI Desktop, Power BI Service, My SQL, SQL Server

Collaborated with business users to understand both business requirements and existing systems.

Managed the entire Tableau Server environment, including installation, configuration, maintenance, and upgrades.

Automate tasks to prepare data backups regularly using TSM CLI commands.

Created users, groups, projects and sites and assigning the permissions as a tableau administrator.

Designed and developed ETL workflows and datasets using Alteryx to streamline data processing.

Implemented ETL processes in Alteryx to extract data from multiple sources

Optimized existing Alteryx workflows to improve performance and operational efficiency.

Processed data in Alteryx to create Tableau Data Extracts (TDE) for reporting

Worked on migration of the tableau workbooks and data sources from MySQL to SQL Server.

Involving in creating various kinds of Interactive dashboards in Tableau and Power BI as per business needs.

Optimized Tableau dashboards for performance and usability by streamlining data sources, improving load times, and ensuring Visual clarity, Maintained data integrity through rigorous quality checks.

Designed and developed insightful visualizations in Tableau and Power BI to support data-driven decision-making.

Optimized semantic data models to improve performance, enabling faster data retrieval and quicker report load times.

Leveraged Power BI, DAX and SQL to construct dynamic dashboards displaying key business metrics, increasing decision making efficiency by 25%.

Improved Power BI dashboard performance by streamlining visuals and enhancing data load efficiency.

Designed and implemented complex data models in Power BI to support real-time analytics and reporting.

Implemented several DAX functions for various calculation for effective data visualization in power BI.

Developed Power BI reports and dashboard, utilizing features such as DAX and Power Query to manipulate and analyze data. Mindtree (Deloitte – Houston, TX) Dec 2018 to Apr 2020 Senior Tableau/Power BI Developer

Tools and Technologies: Tableau Desktop, Tableau Server, Power BI Desktop, Power BI Service, SQL Server

Converted various Tableau dashboards and cross-tab reports to Power BI, rebuilding them from scratch to enhance functionality and user experience.

Designed and implemented data models in Power BI to support real-time analytics and reporting;

Developed calculated columns and measures in Power BI Desktop to enhance data visualization in reports and dashboards.

Developed diverse visualizations such as tables, charts, maps, slicers, and custom visuals, incorporating tooltips to provide additional context and insights on hover.

Built and manipulated data in Power BI reports using DAX and Power Query to enable robust data analysis.

Created interactive reports with drill-down and drill-through features, allowing users to explore data at multiple levels.

Applied various filters and slicers to improve data exploration and report customization.

Utilized both Direct Query and Import modes in Power BI to create dashboards and reports.

Created and published dashboards and reports using Power BI Desktop, then shared them with end users through Power BI Service.

Schedule the Power BI reports for Daily, Weekly, Monthly to refresh the Datasets with Power BI gateway. Mindtree (MSC – Atlanta, GA) Oct 2016 to Nov 2018

Senior BI Developer

Tools and Technologies: Tableau Desktop, Tableau Server, Alteryx, BigQuery

Understanding the Requirements, Analyzing Systems and Source Databases.

Designed and developed ETL workflow and datasets in alteryx.

Implemented ETL process in Alteryx to extract data from multiple data sources and schedule workflow.

Modified Alteryx workflows based on user requirements to improve data processing.

Created custom SQL in Tableau to extract and transform data from relational databases for advanced visualizations.

Run daily workflows on Alteryx and troubleshoot issues with data flow.

Used apteryx for data preparation and tableau for visualization and reporting.

Created various kinds of Interactive dashboards in Tableau Desktop as per business needs.

Used Parameters, Filters and Actions for developing complex dashboards.

Created complex calculations and table calculations including LOD’s and Date functions

Optimized Tableau workbooks and dashboards for performance by tuning data connections, optimizing queries, and applying Performance optimization technique.

Published workbooks into tableau server and scheduled the tableau data extracts and also automated the reports using alerts and subscriptions.

Mindtree (Lincoln Financial Group – Houston, TX) Dec 2015 to Sep 2016 Senior Power BI Developer

Tools and Technologies: Power BI Desktop, Power BI Service, My SQL

Import data from different data sources to create Power BI reports and Dashboards.

Creating the data models for Power BI reports in Power BI Desktop.

Created detailed reports and interactive dashboards using Power BI, providing actionable insights that supported strategic decision- making.

Created reports and dashboards using Bars Chats, Pie Chart, Donut Chart, Gauge, Maps and utilized Filters, and Slicers.

Developed calculated columns and measures using DAX in Power BI.

Created Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI.

Worked on On-Premises Gateway to refresh the data sources and scheduling the data.

Implemented Row level security (RLS) as per the end user requirement. Mindtree (SITA – Geneva, Switzerland) Jan 2012 to Nov 2015 Senior Developer

Tools and Technologies: Hyperon Essbase, Hyperion Planning, HFR, HPCM, HFM, DRM, Smart View, Oracle 11g

Involved in building and modifying the outline and designing the load rule files for loading data from data files.

Created and maintained ASO/BSO cubes as per user requirements and performed optimization by using appropriate dense/sparse configuration, outline structure strategies such as dynamic calculations, attribute dimensions, partitioning etc. and optimization of calculation scripts and tuning of calculation cache.

Responsible for designing and developing outline using sparse and dense dimensions.

Created Monthly, Quarterly and Yearly reports of Balance Sheet and Income statement using web analysis.

Developed some key reports like income statement, net margin and balance sheet reports using financial reporting studio

Created and provisioned the users with necessary roles on applications using Hyperion Shared Services.

Migrated all applications like Essbase, Planning, HFM, HPCM, HFR,DRM from once environment to other environment by using LCM

Creating Audit report on all Hyperion applications who have access to the applications. Education:

Bachelor of Technology in Computer Science and Information Technology.

Contact this candidate