Prasanna Rani K ad4hfp@r.postjobfree.com BI Developer 732-***-****

Professional Summary

•Certified BI professional with over 10 years of experience in Analysis, design, development, data warehouse, implementation and maintenance of client server applications, providing Business Intelligence and OLAP solutions.

•Extensive 7 years of experience in Tableau Desktop, Tableau Server and Tableau Prep in various versions of Tableau as a Developer.

•Around 2 years of working experience in Power BI.

•Worked on delivering the design, technical cost/resourcing estimates, development, and deployment for all reporting and analytics.

•Have experience to partner with business stakeholders, gathering requirements and translating them into technical specifications and process documentation

•Worked on evaluation of development best practices (including automated impact analysis testing, naming and design standardization).

•Expertise in designing and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Box Plots, Waterfall Charts, Geographic Visualization.

•Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

•Have experience in Designing and implementing data models to support business requirements

•Defined best practices for Tableau report development and effectively used data blending feature in tableau. Worked in creating dataflows in Tableau Prep.

•Proficient in Tableau data visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards.

•Used actions, local and global filters according to the business/client requirement.

•Created different Power BI reports utilizing the desktop and the online service and schedule refresh.

•Proficient in understanding business processes / requirements and translating them into technical requirements.

•Certified as Tableau Desktop Specialist.

•Extensive Working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary Key, Foreign Key, Unique) Indexes.

•Experience in creating Sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters.

•Expert ability to troubleshoot and prioritize issues.

•Excellent interpersonal and communication skills for efficient client interaction.

Skills:

BI Development Tools

Tableau 2020.4/2021.1.x, Tableau server 8.2, Tableau Reader 8.1, Tableau Prep, Power BI Desktop

Databases

Oracle 12c/11g/10g/9i/8i, MS SQL Server, SSRS, Snowflake, AWS Google Cloud

Programming Languages

SQL, PL/SQL, XML, Python, Java

Tools and Utilities

AWS Redshift, SQL Developer, Microsoft Visio

Professional Experience:

Deloitte July 2023 – Current Tableau Developer

Involved in reviewing business requirements and analyzing data sources for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

Work closely with stakeholders to identify and address data-related challenges and bottlenecks.

Conduct business requirement review sessions with IT and Business teams to understand what the outcome should be based on data elements.

Developed the reports with Figma background to enhance the presentation of Tableau reports.

Created views and dashboards based on requirements and published them to Tableau Server for

Business and End User teams to be reviewed.

Created projects, and provide permissions to the users as a site admin.

Blended data from multiple databases into one report by selecting primary keys from each database for data validation.

Develop parameter and dimension-based reports, drill-down reports, and tabular reports using Tableau Desktop.

Created extracts, published data sources to Tableau Server, refreshed extract in Tableau server

Environment: Tableau 2021.3, Salesforce, and Tableau Server

Charles Schwab March 2022 - June 2023

Tableau lead

•Understand analytics requirements from users and build design specifications.

•Interacted with ETL team to gather the requirements for the reporting.

•Provide and explain the requirements to the team and check the status in the development of reports.

•Design & develop rich data visualizations on Tableau using crosstabs, heat maps, pie charts & bar charts, Scatter plots etc.

•Created extracts, published data sources to Tableau Server, refreshed extract in Tableau server.

•Tested dashboards to ensure that data is matching as per the business requirements and if there were any changes in underlying data.

•Created reports using advanced calculations, LODs, window functions.

•Designed multiple dashboards for operational and executive users.

•Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

•Post-production support to Tableau users and follow the best practices, documentation.

•Develop test cases and test scenarios in order to pinpoint the root cause of issues and provide solutions.

•Combined visualizations into Interactive Tableau Dashboards and published them to the web portal.

•Experience on using the Python code to combine the different data sources and use it as data source to create the dashboards.

•Prepare test scenarios, test cases and execution of test cases.

•Backing up, restoring system & other databases as per requirements, and also scheduled those backups.

Environment: Tableau 2021.3, Denodo, and Google Big Query, Google Cloud

Amazon – Arlington, Virginia July 2021 - Feb 2022

BI Developer

•Involved in creating the design, estimating technical resources, gathering business requirements and analyzing data sources for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

•Conduct business requirement review sessions with IT and Business teams to understand what the outcome should be based on data elements.

•Created views and dashboards based on requirements and published them to Tableau Server for Business and End User teams to be reviewed.

•Developed filters, calculations, prompts, conditions, and created various reports, using Tableau for users.

•Created Tableau dashboards using stack bars, bar graphs, scatter plots, geographical maps.

•Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

•Created reports

•Created dashboards with huge volume of data and worked on improving the performance of the dashboard.

•Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

•Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning.

•Created views using SQL Workbench in AWS Red shift.

Environment: Tableau 2021.1., Aws Red shift, Power BI, AWS cloud

LabCorp - North Burlington, NC July 2020 – Sep 2021

Tableau Consultant

•Perform complex business analysis to help drive organization decision making.

•Identify where the business logic should be implemented.

•Worked extensively with advance analysis actions, calculations, parameters, background images.

•Understand the existing reports and implemented the changes as per the user requirements.

•Blended data from multiple data sources into one report.

•Involved in testing the SQL Scripts for report development, Dashboards, Scorecards and handled the performance issues effectively.

•Involved in creating python scripts to build a data source for Tableau Desktop.

•Served as a liaison between the business and the IT department by conducting weekly calls/meetings with stakeholders, developers, QA Team, UAT Team to document any changes and apply them to Tableau reports as needed.

•Used Tabpy extensions to connect to python APIs.

•Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.

•Build advanced analytics by building complex reports and dashboards.

Environment: Tableau 2021.1., SAP HANA, AWS cloud, Python and MS Excel

Marriott International, MD Jan 2020 – June 2020

Tableau Developer

•Involved in requirement gathering, business Analysis, design and development, testing and implementation of business rules.

•Designed and developed mock-up Tableau Dashboards to explore options for visualization of data, presentation, and analysis.

•Created flows by cleansing and prepping the data in Tableau Prep and published the data sources to the server.

•Created different views in workbook to visually analyze the data.

•Designed and developed operational dashboards with parameters, calculated fields, groups and hierarchies.

•Used multiple Measures in Individual Axes, Blended Axes, and Dual Axes.

•Involved in testing and validating the data.

Environment: Tableau 2020.4, Tableau Prep, and Snowflake.

UBS - Weehawken, NJ Dec 2017- Dec 2019

BI Developer

•Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

•Blended data from multiple databases into one report by selecting primary keys from each database for data validation.

•Develop parameter and dimension-based reports, drill-down reports, and tabular reports using Tableau Desktop.

•Designed and developed Tableau graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

•Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

•Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

•Developed the resource management dashboard using JIRA tool data as data source in Tableau Desktop.

•Experience in keeping the technical documentation for the developed dashboards.

Environment: Tableau, Power BI, Oracle.

American Express - New York, NY Dec 2016 - Nov 2017

Tableau Consultant

•Involved in creating dashboards and reports in Tableau.

•Created Heat Map showing current customers by color that were broken into regions allowing business user to understand where we have most users vs. least users.

•Created very complex Dashboards using Tableau using the drill down, drill across, actions for business steering committee.

•Setup Tableau Schedules and assign dashboards to schedules based on users/group security.

•Converted charts into Crosstabs for further underlying data analysis in MS Excel.

•Developed and implemented a suite of custom maintenance and monitoring solutions.

•Enabled Tableau Actions to drill down from Dashboard to worksheet.

•Responsible for Deploying and Maintenance Tableau Dashboards on Server.

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

•Utilized (Power BI, Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper-level management.

Environment: Tableau 2018.x, Power BI, Windows 2012 R2 and Oracle 10g.

Provimi, India Jan 2009 – July 2009

Business Intelligence Analyst

•Involved in interaction with business users in the process of discussing the overall Reporting requirements.

•Analyze user requirements and translated them into front end Tableau visualizations and reporting solutions.

•Developed workbooks with various functionalities and deployed them on server.

•Used functionalities like groups, sets, Actions (hyperlinks), context filters wherever required.

•Responsible for Tableau Infrastructure including Server Security, Troubleshooting and overall system maintenance.

•Scheduling and maintaining the workbooks to synchronize dynamically with run time data.

•Building, publishing customized interactive reports and dashboards, report scheduling using Tableau Server.

•Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.

Environment: Tableau 5.0, Oracle 10.2

NHIF, India Sep 2007 - Dec 2008

Software Developer

•Involved in the Requirement Study phase of the NHIF system.

•Created Presentation catalogs, and Folders in Presentation Layer, and Performed Global Consistency Check in Oracle BI Administration Tool.

•Implemented business rules using stored procedures and triggers.

•Involved in Creation of tables, indexes, sequences, constraints, triggers and procedures.

•Manipulated the data using DDL and DML functions.

•Migrated the data (Import & Export of data) from one server to other servers using tools like Data Transformation Services (DTS).

•Reporting the defects found while testing in DMT.

Environment: SQL Developer & Oracle 9i/10g, SQL & PL/SQL

Educational Qualifications:

•Master’s degree in Computer Applications from SV University, India

•Bachelor's degree in Computer Science from SK University, India

Contact this candidate