Power Bi Business Intelligence

Pradeep K

Senior BI Developer

Contact: 573-***-****

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

Tableau Public Profile: Profile - lok.pradeep.koripalli Tableau Public

SUMMARY:

Around 10+ years of experience in the state-of-the-art mission critical and scalable end-to-end (Full life cycle) Data Visualization & Analysis, Business Intelligence/Data Warehousing industry solutions with expertise in Tableau, Power BI hands-on experience in analysis, and development for BI project solutions in Finance, insurance and Auto.

Hands-on experience with Tableau suite of products-Server, Desktop, ETL, OLAP analysis and reporting processes using Tableau.

Technically hands-on experience mainly with full range of BI Skills with Tableau 9.x, Tableau 10.x, Tableau 2019.x, Tableau 2020.x, Tableau 2021.x, Tableau 2022.x, Tableau 2023.x Desktop, Tableau Server and Tableau Public.

Expertise in Tableau BI reporting tools & Tableau Dashboards Developments & Server Administration.

Proficient in building Power BI dashboards using DAX functions, connecting to various data sources.

Designing, building and deploying, publishing data analysis reports/dashboards for large volumes of data.

Used action filters extensively and differently in various scenarios which increased the interactivity of the dashboard and fetched cost-effective solutions.

I have started using Tableau prep which is very useful for Data Modelling and manipulations.

Created DAX Queries to generate computed columns within power BI.

Designed Power BI using cross tabs, bars, Scatter Plots and density charts.

Strong skills with Business Intelligence application stack including Tableau Desktop/Tableau Server/Tableau, multi-dimensional cube building, OLAP/MOLAP and have solid experience in data warehousing/BI environments.

I have also worked on SAP SAC Analytics for creating a POC in one of the projects and got good hands-on experience of it.

Used Alteryx for ETL process and learned the process of Data Modelling.

Good knowledge of Business Intelligence/Data Warehousing BIDW Fundamental architecture concepts, dimensional modeling, requirement gathering.

Proven myself as a dedicated, worth full and energetic well-rounded Business Intelligence/DWH background professional in growth oriented reputed organizations that gives me scope to apply my knowledge and skills and be a member of a team that dynamically works towards success and growth of the organization.

Have experience in Tableau Prep for data structuring.

Experience in application development using various advanced features of Oracle like Bulk Collect, Autonomous Transactions, Dynamic SQL, and Collections.

Have good experience in discussing requirements with clients and have analytical skills.

Involved in working with Metrics Insight tool which is integrated with tableau.

TECHNICAL SKILLS:

Database: MS Access, Oracle 9i, MS SQL Server, Oracle, Greenplum and Hive.

BI Tools : Tableau BI Products, Power BI, QlikView, SAP SAC Analytics.

Data Modeling: Erwin, Vision 2003

Reporting Tools : Tableau Desktop, Tableau Server

Scripting Languages: SQL, T-SQL

PROFESSIONAL SUMMARY:

Client: Experian Health Inc, TX March 2022 to Present

Role: Senior BI Developer

Environment: Tableau 2022.x, Tableau 2023.x, QlikView, Power BI, Snowflake, SAP HANA, Oracle Database, Hive, Impala.

Project: Patient Schedule, Authorizations, Collection optimization, Eligibility, Transaction Detail.

Experian Health Inc leads the Way with innovative, results-oriented solutions in the following core areas: Revenue cycle management solutions automate orders, patient access, contract management, claims management, and collections to improve efficiency and increase reimbursement.

Responsibilities:

More than 60 percent of US hospitals count on Experian health solutions as it helps them make smarter business decisions and strengthen patient relationships.

I simplify healthcare by providing clients with great analysis of data in an optimized manner to take critical decisions.

Created interactive dashboards in Power BI to track KPI’s, resulting in the improvement of decision-making speed.

Automated data import and transformation using power query reducing reporting time.

Integrated Snowflake with power BI to create real-time, cloud-based dashboards that monitored operational metrics.

Automated data ingestion from snowflake into power BI using snowflake SQL and Power Query, reducing manual reporting processes.

Optimized data queries in Snowflake for Power BI reports reducing load times.

Created customized dashboards tailored to the unique needs of hospital clients, focusing on improving patient outcomes, resource allocation and operational efficiency.

Actively adopted and integrated new tableau features into existing workflows, enhancing dashboard functionality and user experience.

I have got an opportunity to work on migrating QlikView dashboards to Tableau in a project called Patient Schedule.

I have learned and understood the calculations and visualizations in Qlik and tried to develop the same but more interactive and high-end visualizations in tableau.

Developed dashboards to track KPIs such as Booked Appointments vs Cancelled, Coverages, Active vs Inactive etc.

Worked on Tableau prep in data preparation, cleansing to drive efficiency in reporting and analysis.

Developed Tableau dashboards that effectively visualize and analyze large-scale data stored in Hadoop clusters via Hive and Impala, providing insights into key business metrics.

Develop a standard template of Tableau dashboard for each business process in the medical industry and generalize it across all the clients.

There are almost 300-400 clients for a few business processes where each client has its own individual site on server with the standard template for data security.

There is a unique deployment process of tableau reports to all hundreds of clients at once. We use a separate tool called ‘Tulip’ to publish all the reports at once to the tableau server.

Applied Agile development methodology in development and deployment of tableau dashboards, enabling rapid iteration and continuous improvement in response to user feedback.

Participated in sprint planning sessions to define goals and prioritize tasks, created our own jira tickets depending on the requirement and assigned it to respective developers.

Have Go/No Go meetings to discuss about the deployments going out and ensuring everything looks good.

Worked on writing custom SQL in tableau if required and create required joins and filters in the query to optimize the performance.

Worked on Microsoft SQL to create Tables, views with required filters and calculations and joins to reduce load on tableau dashboard for better performance.

Managed and configured user permissions and roles on tableau server, ensuring appropriate access levels while maintaining data security.

Led the upgrade of tableau server across multiple environments, to have smooth transition to new versions with enhanced features. Extensive testing in UAT with the upgrade to make sure nothing breaks.

Improved the performance of tableau dashboards by optimizing data extracts, implemented best practices in aggregation and filtering to ensure efficient data processing.

Used empty extract for extract optimization which make sit easy for managing tableau extracts.

Provided user training and support to users on developing their dashboards, creating complex calculations and visualizations.

Used Bitbucket to store and track my code and collaborate for software development projects.

Used action parameters and filters for creating highly interactive and dynamic dashboards, enabling users to control visualizations and analyses in real time.

Worked as a QA for Tableau and SQL when required as it is part of our process.

Client: Exxon Mobil, TX March 2016 to February 2022

Role: Tableau SME/Lead Developer

Environment: Tableau 9.x, Tableau 10.x, Tableau 2019.x, Tableau 2020.x, Tableau 2021.x, Tableau 2022.x, Tableau 2023.x,SAP HANA, Oracle Database, Sharepoint, Microsoft Excel, BI Applications.

Project: DAS Analytics, Data Management, M&CI, GCGV, Tableau Doctor Sessions & Safety.

It is one of the world’s largest oil and gas companies which is organized functionally into a number of global operating divisions and I have worked in multiple Business units like Upstream, Downstream & Chemicals. I have worked in different roles in different teams and got an opportunity to work as Tableau doctor across Exxon Mobil globally.

Responsibilities:

Worked across all businesses in Exxon which helped me a lot to increase my business understanding and scenarios to develop innovative analytical solutions.

I have worked in a project called GCGV (Gulf Coast Growth ventures) where a Refinery is being setup, and it is worth of 7 billion $ where I am the only Tableau Developer for the project and created complicated and challenging dashboards which are being used by hundreds of users.

I have created dashboards which are mostly used by the high-level business executives to track the progress of the project and drill down to the details in each part.

I have provided Tableau Training to a set of users in the project and supported them until they are able to create their own dashboards.

I have worked as a Tableau Doctor across Exxon Mobil globally where I set up analytics doctor sessions and users who have issues register and have one to one session with me to get their solution.

I have worked on another project called M&CI (Marketing & Competitive Insights) and have been successful in accomplishing all high visualization dashboards, which are still being used by hundreds of users and high-level executives.

I have started using Tableau prep which is very useful for Data Modelling and manipulations.

Used action filters extensively and differently in various scenarios which increased the interactivity of the dashboard and fetched cost-effective solutions.

I have had a chance to work on Power BI where I have developed a few dashboards for a particular project for a few months.

Created DAX Queries to generate computed columns within power BI.

Designed Power BI using cross tabs, bars, Scatter Plots and density charts.

Provided support for maintenance of existing and old Power BI reports.

I have also worked on SAP SAC Analytics for creating a POC in one of the projects and got good hands-on experience of it.

Successfully created dashboard story in SAC using Responsive pages, Canvas and Digital boardroom.

Implemented stories using different features of SAC.

A few of my dashboards have received lots of appreciation from the users and have taken them as templates for other projects.

I have faced many challenges due to the limitations of the tool but have sorted out the alternative solution for most of them.

Worked on projects which have connectivity to SAP HANA and got used to the environment by analyzing the data from the HANA views created.

I have used Alteryx for one of my projects and have managed to learn the ETL process using it.

Got involved in the discussions to convert SAP BW queries to HANA Views and develop tableau dash boards using them.

Worked on the integration of tableau with ARC GIS and added as background maps to the tableau dashboard.

Created many new kinds of charts like Waterfall, Donut, Lollipop charts for different kinds of business requirements.

Involved in trouble shooting of any performance issues related to Tableau reports.

Involved in administration tasks such as setting different kinds of permissions, managing ownerships and providing access to the users and adding them to the specific group.

Duration: November 2014 to February 2016

Client: General Electricals (GE), CA

Role: Tableau Administrator/ Developer

Tableau 8.x, Hive, Greenplum, Gem fire, Microsoft Excel, BI Applications.

Project: Sourcing, Reliability.

It has different Business Units, where the executive business users need decent & data-rich visualization dashboards, which will provide them with a clear picture of the suppliers for different Business units. Business users are interested in looking at the dashboards which will provide them with accurate numbers generated for selected fiscal year. They want to have exact values for PO's and Invoice amounts. Initially started up with creation of three new projects, later the roles and then the groups. Later solely worked on gathering the requirements from Business users and used to attend daily scrum meetings, once finalized, used to work on Tableau to create extensive reports on all the above requests and provide the required dashboards to the users. Going further, I worked on Transportation related projects which mainly deal with the locomotive with failures and created dashboards for visualizations.

Responsibilities:

Involved in generating proper data in Greenplum database for Tableau Dashboard.

Skillfully Used Link Tables utility to update Access table to reflect the Excel changes.

Skillful at creating multi-level hierarchy in Tableau Dashboard.

Extensively used action filters to navigate from one sheet to another.

Created reports using maps to track the suppliers at different locations.

Skillfully created different kinds of actions for navigation and drill down.

Efficient at using Parameter in calculation field to give flexibility to end user.

Created a global filter for the dashboard that uses different data sources.

Have created data quality reports to make the users check the stitching percentage of the data with different business units.

Have worked on performance tuning by extracting the data and filtering to only the required data.

Worked on giving permissions to specific users and worked on the performance recording on the server side.

Worked on scheduling the extracts to refresh daily and on specific times.

Created reports using different charts according to the requirement.

Worked extensively on table calculations dealing with rolling averages w.r.t to dates and complex calculations.

Worked on different kinds of charts and the functionality for switching between them according to the requirement.

Also got a chance to work on calling the functions in the backend with the help of parameters in tableau by defining them in Custom SQL.

Given permissions to the users to view and interact with the dashboard according to the requirements.

Worked on Metrics Insight tool to integrate with tableau to give daily notifications on specific activity to all the users.

Have worked on performance tuning with both live connection and extracts.

Also got a chance to work on Tableau 9.0 and got to know all the new features like LOD’s added to it which helped me in the project.

Duration: Oct 2013 to Nov 2014

Client: JPMC, TX

Role: Tableau / BI Developer

Environment: Tableau Software 7.0, 8.0, Microsoft office, SQL Server, JAVA, QTP and QC.

Responsibilities:

Interacting with business stakeholders to understand their decision-making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery

Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client briefly, also interact with data as necessary

Embedded live Tableau dashboards on PowerPoint presentations, keeping the slides always updated

Delivered dashboards tracking viewership, HUT and Advertising sales for a Media channel.

Created dashboards for System Services Company to measure performance of their field engineers and manufacturer defects.

Setup stand alone and distributed Tableau Server to publish and distribute dashboards easily

Participated in discussions for Tableau Server architecture design on Cloud, enhancing performance, scalability and high availability

Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project & business stakeholders throughout the project life cycle.

Contact this candidate