Business Intelligence Power Bi

********.*********@*****.***

Professional Summary 571-***-****

Around 9 years of experience in Software Design, Development, Integration, Implementation, Administration, and Maintenance of Business Intelligence and Database Platforms.

Extensive Techno-Functional experience in Tableau 8.x / 9.x / 10.x, 2018.x, 2019.x, 2020. x and Tableau 2021.x Tableau Desktop and Server, Click View, Power BI, Tableau CRM, SAP BO 4.0/4.1 and Cognos.

End-to-end experience in Requirements Gathering, designing, development, Administration, and deploying data visualizations using BI Applications.

In-depth knowledge of Tableau Desktop and Tableau Server. Mastered the ability to design and deploy rich Graphic visualizations with drill-down and Drop-down menu options and Parameterized using Tableau.

Extensive Tableau and Power BI Applications Experience in Enterprise Development Environment and Tableau Administrator Experience including technical support, troubleshooting, report design, and monitoring of system usage in On-Prem and Cloud environments.

Developed various types of complex reports like List Reports, Cross tab Reports, Chart reports, Drill down reports, Drill Through reports, Conditional formatting, Workspace dashboards, Active reports, Standard templets, Master detail reports, Dimensionally Modelled Relational (RMR) reports, Relationally Model (DMR) reports, Reports from Cubes, Customized prompts using Phyton script.

Highly proficient in the use of SQL for developing complex queries, Procedures and Created DB tables\views using AWS Redshift in both application & distribution clusters.

Created DB tables\views using AWS Redshift, Snowflake and Amazon Athena in both application & distribution clusters.

Extracted data from different data sources like Oracle, SQL Server, Snowflake, Salesforce, Silver pop email campaign and Adobe Marketing Cloud and built a Data model in curated and EDW layers for EDH.

Created a summarized flattened structure of curated fact table in AWS Redshift, Amazon Athena and Presto by pre-Calculating for different periods to handle and make ad-hoc reporting easier in Tableau.

Experience on SCRUM/AGILE development methodologies utilizing a test-driven development approach.

Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.

Knowledge in the ETL (Extract, Transform and Load) of data into a data warehouse/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).

Experience with the creation of users, groups, projects, workbooks, and the appropriate permission sets for Tableau server logons and security checks.

Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including Tableau server installation, upgrades, backup and restore, technical support, troubleshooting, report design, and monitoring of system usage.

Prepared Data Mapping Documents compromising of Source Input Definition, Target/Output Details, Business Transformation Rules, and Data Quality Requirements.

Conducting enterprise-wide training for 500+ users, ranging from developers to EVPs, Directors, Project managers, and SMEs on using BI Tools focusing on best practices, standards, and effective visualizations

Diligent worker with strong analytical and problem-solving skills, capability to prioritize and organize tasks, in-depth understanding of industry concepts.

Integrated Tableau ChatGPT into Tableau dashboards to enable AI-powered, real-time insights through natural language queries, improving data accessibility for business users.

Enabled real-time, AI-powered data querying with Tableau ChatGPT, helping business users make faster, data-driven decisions without advanced technical skills.

Certifications

Tableau Desktop Specialist

Tableau Server Associate

Skills Profile

Technical

Reporting Tools

Tableau Desktop 9.x/10.1/2018.x, 2019.x, 2020.x, 2021.x Tableau Server 10.1/2018.x, 2019.x, 2020.x, 2021.x, 2022.x, 2023.x, Power BI, SAP BO 4.0,4.1, Cognos

ETL & Modeling Tools

Informatics 9, Web Application Designer, WEBI, Dashboard, Analysis, SAP BO Design Studio, SSIS, Pentaho, Informatica, Balsamic, Axure, Alteryx, Tableau Prep

Databases & Tools

Snowflake, Greenplum, Jethro, Koginitio, Hadoop, MapReduce, HDFS, Hive, HBASE Teradata, SQL Server, DB2, Oracle, Google Big Query, AWS Athena, Redshift, Spark, Kafka,Presto, AWS Glue

Operating Systems

Windows NT/XP/2000/11, Linux 8.3+

Operating Systems

Windows NT/XP/2000/11, Linux 8.3+

Documentation

Jira, SharePoint, confluence

Functional

Management and Leadership Skills

Ability to do Business Analysis and development of creative dashboards In Tableau and Power BI and having experience with Tableau server Administration in Linux and Windows

Windows Operating Systems

Training & Development

Technical ability to train new joiners and troubleshoot issues

Professional Experience (In Reverse Chronological Sequence)

project: 1

Client Name

MUFG, AZ

Project Duration

Aug 2024 to till date

Role/Title

Senior BI Consultant

Responsibilities:

Conducted collaborative sessions with business users to define project specifications and gather user requirements.

Designed and developed Tableau dashboards tailored to complex business needs, ensuring optimal functionality and user satisfaction.

Performed performance tuning and aesthetic customization to meet user expectations and improve dashboard efficiency.

Established and enforced best practices for dashboard development, promoting consistent and intuitive user experiences.

Translated complex reporting needs into technical specifications, including calculations, aggregations, filters, and user-defined parameters.

Managed user permissions, performance troubleshooting, and provided general support for Power BI and Tableau users.

Coordinated with Tableau support for ticket resolution, feature requests, and defect tracking.

Provided expert recommendations on BI best practices, both technically and from a process perspective.

Worked with the business on managing Tableau user permissions, performance troubleshooting, and handling general inquiries.

Enabled real-time, AI-driven insights through Tableau GPT and AI Copilot, facilitating quicker access to important trends, outliers, and data relationships, empowering teams to act on insights faster.

Applied AI Copilot to suggest relevant data visualizations and key performance indicators (KPIs) based on business queries, improving the accuracy and effectiveness of dashboards.

Leveraged Tableau GPT to instantly generate YTD, MTD, and FYTD reports by aggregating real-time data, streamlining reporting processes.

Enabled dynamic AI-powered insights by allowing users to ask specific questions and receive real-time visualizations and actionable recommendations.

Combined multiple time-period views (YTD, MTD, FYTD) into a single interactive dashboard, facilitating quick comparisons and comprehensive analysis.

Utilized AI Copilot to suggest relevant visualizations and offer recommendations based on user queries, ensuring intuitive data exploration.

Delivered AI-driven insights based on historical performance, seasonality, and business trends, empowering data-driven decision-making.

Integrated AI-powered suggestions for dashboard creation, optimizing visualizations and enhancing the user experience for non-technical users.

project: 2

Client Name

Vanguard, PA

Project Duration

June 2021 to July 2024

Role/Title

Senior BI Consultant

Responsibilities:

Converts business requirements and specifications into Power BI and Tableau presentation and data layer application solutions through effective design, coding, and testing.

Designed and implemented interactive dashboards and reports to visualize business KPIs and insights.

Developed and deployed Power BI and Tableau dashboards to meet complex user requirements.

Designed and implemented interactive reports visualizing business KPIs and insights.

Optimized Tableau Server installations, upgrades, user permissions, and troubleshooting.

Utilized Snowflake for cloud-based data warehousing, optimizing queries and ETL processes.

Implemented Azure Data Factory pipelines for efficient data integration and workflow automation.

Created Power Apps and Power Automate workflows to streamline processes and automate data updates.

Migrated Tableau reports to Power BI, improving data visualization and accessibility.

Developed Python-based solutions for enhancing report automation and data processing.

Developed and tested Python scripts and custom API workflows to extend BI platform functionalities.

Managed and maintained SQL databases, ensuring data integrity and optimizing performance.

Developed and optimized complex SQL queries for data extraction, transformation, and reporting, enhancing efficiency and accuracy.

Applied role-based security measures to safeguard sensitive business data.

Conducted user training and documentation for self-service analytics adoption.

Ensured data governance and compliance, aligning with best practices in BI development.

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

Worked on Tableau content Migration tool to promote dashboards to another environment.

Worked on Tableau Server Installation, Configuration, and administration of Tableau Server in a multi-server and multi-tier environment (HA).

Operating Systems

Windows 10

Database

Red shift, Athena, Presto, Amazon Athena, Glue

ETL & Modeling tools

Cognos

Software / Special Tools

Tableau Desktop 2022.1.3, Tableau Server 2022.3.1, Power BI, Tableau Online 2024.1.0

Languages

Java, Python Framework

Project: 3

Client Name

VF Corp

Project Duration

Nov 2019– June 2021

Role/Title

Tableau Developer

Responsibilities:

Work with the business users in gathering the project specifications by conducting user requirements gathering sessions.

Contribute to all aspects of software development lifecycle (SDLC) including architecture, development, migrations, installations, upgrades, troubleshooting, Testing and maintenance of the Tableau platform.

Optimize the performance of Tableau applications.

Gather requirements from clients. Analyze requirements and highlight gaps/inconsistencies in the requirements to the client. Presented dashboard to end users to demonstrate features

As a Tableau Analyst, I used Tableau for Data Analysis, Digging the data for source, systems analysis and deeply diving the data for Predictive findings and for various data Analysis. Also, to slice and dice the data, for analyzing the data of patterns, trends, and fashions of various KPIs, Measures using various graphs, charts

Operating Systems

Windows 10

Database

DB2

Software / Special Tools

Tableau 2020.3, Tableau Server 2020.3, DataStage

Project : 4

Client Name

Cisco, CA

Project Duration

April 2015 – July 2017

Role/Title

Tableau Developer

Responsibilities:

Converts business requirements and specifications into Tableau presentation and data layer application solutions through effective design, coding and testing.

Developed Visualizations using Cross tables, Bar Charts, Pie Charts, Line Charts, Scatter Plots and Combination Charts Marking, Drill Down, Hierarchies, Coloring, Calculated Columns and Custom Expressions.

Effectively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc.

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

Extensive use of Marks, Filters and Pages, Add Reference line, Calculation Fields to create a complex Dashboards Deep understanding of key business applications as primary sources of data for Presentation and data layer application solutions.

Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Indicators (KPI) and Measures.

Used Data Blending, groups, combine fields, calculated fields, aggregated fields and spotlighting to compare and analyze data in different perspectives.

Compared the target data with the source data.

Responsible for administration work like database and log Backups, user management, Restoration, Scheduling data loads and Backups.

Operating Systems

Windows XP, Windows 7 Professional

Database

MS SQL Server

Software / Special Tools

Tableau 9.x,10.x, Tableau Server, SQL BI Suite (SSIS, SSRS), SharePoint, MS Visio, MS Excel

Project:5

Client Name

Wellmark, India

Project Duration

June 2010 – Jan 2012

Role/Title

Tableau Developer

Responsibilities:

Worked with business stakeholders, application developers, production teams and functional units to identify business needs and discuss solution options.

Design and develop Universe on top of BEX Queries to extract BI 7.0 information to WEBI reports.

Publish the reports to the user inbox for their ad hoc analysis.

Generated various reports on Weekly, Monthly and Yearly basis.

Design and develop Xcelsius dashboards on top of Bex queries.

Used different Mark types and Mark properties in views to provide better insights into large data sets.

Involved in designing and implementing the Stored Procedures and Triggers for automating tasks.

Daily Database backups and integrity checking

Created various detailed and summary Ad hoc Web reports for the business users.

Scheduled the reports to be emailed to end users daily in PDF/Excel formats in Info view.

Expertise in connecting to Oracle and SQL databases and troubleshoot.

Operating Systems

Windows XP, Windows 7 Professional

Database

Oracle 10g, SQL developer, SQL 2008

Software / Special Tools

SAP BO, SharePoint, MS Visio, MS Excel, MS Visio, MS Excel, Informatica 7.0

Education

Master of Computer Applications (MCA) Form JNTU University

Contact this candidate