Business Analyst Intelligence

Name: Harsha B

Phone: +1-331-***-****

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

LinkedIn: https://www.linkedin.com/in/harshab-linkedi/

PROFESSIONAL SUMMARY

• Over 9+ years of experience as a BI Analyst, excelling in SQL, Performance Tuning, Data Warehousing, and Business Intelligence technologies, with a robust background on data visualization.

• Possess strong analytical and problem-solving skills, adept at working independently and collaboratively in team environments, managing multiple projects with competing priorities effectively.

• Managed support for large-scale reporting environments in Tableau, overseeing 5000+ dashboards, and implemented automation solutions to enhance efficiency.

• Demonstrated expertise in advanced Tableau features such as calculated fields, parameters, table calculations, and data blending, utilizing various functionalities like actions, filters, security concepts, and relationships to design customized interactive dashboards.

• Proficient business analyst with expertise in requirements analysis and SDLC documentation, proficient in waterfall, UP, Agile, and Scrum methodologies.

• Proven track record in development, maintenance, and support projects, including managing large reporting environments in Tableau with 4000+ dashboards.

• Skilled in gathering customer requirements, writing test cases, and collaborating with developers to ensure alignment with customer needs.

• Expertise in dimensional modeling, data cleansing, data integration, and ETL processes for data warehousing.

• Proficient in creating different visualizations and reports using Tableau and Excel, with experience in building Confidential Redshift data warehouse solutions.

• Experienced in designing and optimizing connections, schedules, and background tasks for Tableau Server.

• Proactive in diagnosing and problem-solving and debugging production issues using the ServiceNow platform related to data integrity and dashboard issues, ensuring effective troubleshooting and problem resolution Proficient in

• Proficient in creating Tableau dashboards for weekly, monthly, and daily reports, leveraging Tableau Desktop and Server environments.

TECHNICAL SKILLS

BI Tools

Tableau 2022.3.8/2021.4.7/2020.3/2019/9x/ 10x (Desktop, Server, Public), Tableau prep Builder 2022.3.4, Looker. Business

Intelligence Development Studio (SSRS), SSIS, Alteryx, Qlik sense, Sigma, Einstein Analytics and Power BI, Crystal Report, Cognos, Excel

ETL Tools

Airflow, Informatica Power Center 7/8, SQL Server Integration Services (SSIS), OLAP(Cubes), GIT, TFS, Hadoop Ecosystem: Map Reduce, Spark, Nifi, HBase, Impala, Hive, Pig, Sqoop, Kafka, Oozie.

Databases

Snowflake, Teradata, SQL Server, MySQL, SQLite, Hadoop/HBase, Impala, Hive, Smartsheet, SharePoint, MS Access, Oracle 12c, Vertica, Salesforce, DB2.

Applications

Microsoft Office, MS Visio, Visible Analyst, Share point.

Cloud Platform

Amazon Web Services (AWS) - EC2, EMR, S3, Redshift, EMR, Lambda, Athena, Glue, Azure - SQL Database, Cosmos DB, Synapse, Azure Data Lake Storage Gen 2, Azure Data Factory, Blob storage

Big Query, GCS Bucket, G- cloud function, Data flow, pub/sub cloud shell

Web Scripting

XML, XHTML, JavaScript, Ajax, J Query, ASP 3.0, Visual Studio

Methodologies

RAD, JAD, System Development Life Cycle (SDLC), Agile

Version-Control and Containerization tools

GitHub, Bitbucket, Docker, Kubernetes

EDUCATION

Bachelor of Technology in Computer Science at GITAM University - AP, India 2010 – 2014

Master of Science in Computer Science at Northwest Missouri State University - Mo, USA. 2016 – 2018

PROFESSIONAL EXPERIENCE

Client: Applied Materials, Santa Clara, CA July 2023 – Till Date

Role: Tableau Developer

As a Tableau Subject Matter Expert (SME), accountable for the conception, development, and maintenance of interactive data visualizations utilized throughout the organization.

Development Responsibilities:

• Proficient in crafting Tableau scorecards and dashboards, leveraging advanced functions including calculated fields, Level-of-Detail (LOD) expressions, and ad-hoc calculations.

• Designed and implemented various KPIs utilizing Table calculations, LOD expressions, actions, sets, parameters, and ad-hoc reports, manipulating data through string operations, arithmetic calculations, aggregations, and logical functions.

• Developed, prototyped, and iterated on dashboards using Tableau Desktop versions 2021.4.7 and 2022.3.8 focusing on extract creation, layout design, worksheet actions, functions, connectors, color legends, and formatting.

• Generated Tableau reports delivering intuitive visualizations of industry specific KPIs, while also integrating with reporting tools such as SQL Database, Looker, Salesforce dashboards, and data warehouses.

• Contributed to the development of dashboard reports showcasing Key Performance Indicators (KPIs) for executive management, incorporating calculation fields, filters, and various conditions, and conducted gap analyses in collaboration with business users to align solutions with client requirements.

• Implemented performance tuning techniques to optimize report execution, including concurrent query execution and date function optimization.

• Managed support for large-scale reporting environments in Tableau, overseeing 4000+ dashboards, and implemented automation solutions to enhance efficiency.

• Utilized analytical features in Tableau, such as statistical functions, trend lines, and forecasting, to enhance insights within reports.

Production support responsibilities:

Demonstrated analytical skills with a knack for problem-solving and debugging production issues in ServiceNow platform.

Conducted comprehensive Quality Audits and weekend server validation across Tableau QA, Development, and Production servers following weekend server reboot activities, leveraging the ServiceNow tool for documentation and tracking.

Provided extensive support to multiple users in configuring network paths to facilitate the execution of their extracts on the server for workbooks and prep flows, ensuring smooth operations.

Assisted users in the procurement, installation, and activation of Tableau licenses for Tableau Desktop and Tableau Prep Builder, managing the entire process through the ServiceNow platform.

Addressed connectivity issues for both existing and new Tableau connections on servers and locally, spanning various data servers such as Hadoop, Hana, SQL Server, SharePoint, Google Sheets, other ODBC connections, and Salesforce, utilizing ServiceNow for efficient resolution.

Resolved prep flow issues on production servers and provided support for data-related issues by analyzing and rectifying underlying queries, implementing enhancements, and addressing key performance indicators (KPIs) on user dashboards.

Supported users in report migrations, subscription creation, alert setup, extract refresh schedule creations and performing Ad-hoc refreshes to the workbooks within SCLA ensuring seamless operations.

Generated ad hoc reports on Tableau usage and statistics for leadership, providing support for priority incidents (P1 and P2) as required.

Conducted regular housekeeping activities, including checks on unused or low-usage archival workbooks and data sources, live connectivity workbooks, orphan data sources, and high-frequency schedules, maintaining system efficiency.

Assisted users in creating PD/PC chains in Redwood, ensuring seamless integration with Tableau workbooks following the completion of respective table jobs.

Identified dashboards with high memory-spilling queries on the disk and optimized these queries to minimize impacts on other running jobs.

Analyzed vendor and Helpdesk Operational Platform (HOP) tickets, providing timely support and resolution to identified issues.

Client: UnitedHealth Group, Chicago, IL Jan 2021 – June 2023

Role: Tableau Developer

• Spearheaded successful end-to-end data migration initiatives, transferring extensive datasets from on-premises environments to the AWS cloud platform.

• Collaborated closely with mid and senior-level leadership across various management tiers, providing critical insights that informed comprehensive clinical performance reporting.

• Leveraged Alteryx's advanced analytics functionalities to conduct data modeling, predictive analytics, and statistical analysis, including the development of predictive models for patient risk identification and cohort analyses for clinical research.

• Implemented tailored onboarding strategies for new clients, resulting in a notable 20% enhancement in customer satisfaction ratings.

• Demonstrated adeptness in Snowflake development, encompassing Snowpipe, SnowSQL, and Snowpark, while proficiently utilizing Snowflake utilities for data ingestion, querying, and manipulation.

• Established direct connections from Tableau to AWS Redshift for streamlined access to cloud data warehousing and rapid visual analysis.

• Designed and executed data warehousing solutions using Snowflake on AWS, significantly enhancing data processing speed and efficiency.

•Build dashboards using tools such as Data Studio (Looker Studio) and Power BI, usually, connecting with BigQuery and GA4. Market survey focusing on finding trends in the client's area of operation to generate insights and positioning strategy suggestions and analyzed the campaigns considering the client's KPIs and try the best performance and those with the greatest potential.

• Partner with clients to understand desired business outcomes, map business metrics to technical requirements, configure Looker projects, and build LookML models and dashboards.

• Developed Python applications for Google Analytics aggregation and reporting, alongside crafting custom data migration scripts to automate data transfer and transformation leveraging AWS SDKs and APIs.

• Conducted thorough problem research, diagnosing root causes by aggregating data from multiple sources, and developing reports and dashboards using Power BI and Tableau.

• Automated data flow processes in Alteryx Designer from diverse data sources, including flat files and SQL databases, utilizing Python, SQL, and Alteryx's built-in capabilities, thereby facilitating Spotfire reporting requirements.

• Utilized Alteryx for healthcare process automation, designing workflows and automating repetitive tasks to streamline data processing and reporting, resulting in notable time savings and operational efficiency improvements.

• Collaborated with Informatica team to ensure seamless data mapping between Oracle and Vertica databases, facilitating effective data integration.

• Conducted gap analysis between current and future states, contributing to the development and operationalization of future analytic processes.

• Applied Alteryx's data cleansing and transformation capabilities to ensure data quality and consistency, supporting accurate and meaningful analysis.

• Utilized the Gainsight platform to proactively monitor customer health and identify potential risks, leading to a significant 15% reduction in churn rate.

• Leveraged Alteryx to extract and cleanse extensive healthcare datasets, amalgamating data from diverse sources including electronic health records, claims data, and patient satisfaction surveys.

• Integrated Tableau with other BI tools such as Cognos and SAP BO to deliver customized solutions tailored to client requirements.

• Utilized Alteryx to create interactive dashboards and reports, facilitating stakeholders in visualizing and interpreting complex healthcare data, with a focus on Snowflake data sources.

• Designed and deployed Matrix, Grid, Chart, and Gauge Reports using SSS, incorporating parameters and interactive features for enhanced user experience.

• Implemented subscriptions and snapshots in the SSRS Report Manager to facilitate automated report delivery and archival.

• Engineered SSIS packages to extract events and programs data from database servers and SharePoint lists, ensuring efficient data integration.

• Created diverse KPIs using advanced Table calculations, LOD expressions, Actions, Sets, and Parameters to manipulate and analyze data effectively.

• Utilized Power BI to design analytical dashboards with interactive filtering capabilities, empowering end-users to extract actionable insights.

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

• Implemented complex mathematical calculations in Power BI desktop through table calculations, enhancing data analysis capabilities.

• Developed SAS BI Dashboards for monitoring key performance indicators, providing real-time insights into organizational performance.

• Designed Tableau workbooks for YTD, QTD, and MTD analysis, facilitating comprehensive data analysis and trend identification.

• Leveraged Big Data and Cloud data Hub (Amazon Athena) to create Tableau dashboards, enabling comprehensive data visualization.

• Collaborated with cloud infrastructure teams to provision and configure AWS resources for data migration activities, including S3 buckets, EC2 instances, and EMR clusters.

• Conducted requirements gathering, analysis, and creation of multiple Tableau Workbooks, Power BI reports, and Crystal Reports for different divisions within the organization, ensuring alignment with business objectives and user needs.

Client: US Foods, Rosemont, IL March 2018 – Dec 2020

Role: Tableau Developer

Tableau license procurement and reporting across organization (United States, Asia Pacific, Europe, Middle East).

Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.

Created Metric tables, End-user views in Snowflake to feed data for Tableau refresh.

Utilized Azure services such as Azure Data Lake Storage, Azure Databricks, and Azure SQL Database for cloud-based data storage, processing, and analytics.

Involved in gathering requirements from business users and created Multidimensional model using Erwin.

Using Erwin for Logical and Physical database modelling by using Ralph Kimball & Bill Inmon Data Warehouse methodologies.

Created Physical Data Model from the Logical Data Model using Compare and Merge Utility in ER/Studio and worked with the naming standards utility.

Employed Erwin for reverse engineering, facilitating graphical representation of existing databases and ODS through Entity Relationship diagrams to gather comprehensive insights.

As ELT implemented the Jira - Confluence software tool that meets the needs of the Agile development/ Scrum teams, so that they can work more efficiently and report or project-wide stats.

Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Mappings, Trends, Hierarchies, Sets, Groups, Data Blending and Maps etc.

Finalize Data Integration with major responsibilities of informatica defect fix, Unit testing, Informatica mapping, performance tuning, Informatica workflow recreate, combine with UNIX shell script to automate ETL systems.

Created many Dashboard reports for company's decision-making purpose and made them KPI.

Used Proc Template to produce customized report in spreadsheet with footnotes, titles, and pages numbers, eliminating user's work to customize the report.

Deployed recently introduced Power BI to create self-service BI capabilities and use tabular models and tracked usage of reports and dashboards in Power BI services with the help of Usage Metrics.

Developed statistical reports with Charts, Bar Charts, Box plots, Line plots using PROC GPLOT, PROC GCHART and PROC GBARLINE.

Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report. Experienced on Date functions creating, executing test Cases, & documenting test results.

Client: USAA, San Antonio, TX March 2017 – Feb 2018

Role: Tableau Engineer / Admin

Participated in Regulation Project and requirements gathering and translate business requirements into report visualization specifications design documents.

Using Tableau Prep for Data preparation and combine them into single source of data using joins and unions.

Extensive experience in Tableau Administration (TSM) Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.

Work on the automation factory building and Alteryx Server setup to improve the reporting process and enhance the customer experience.

Perform Tableau Server admin duties like add users/groups from Active Directory and schedule instances in Tableau Server including weekly data dump.

Created reports using SAS Enterprise Guide for summarizing portfolio experience, including information about the current business environment, portfolio trends, expected portfolio losses and the forecast assumptions.

Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset sorting and merging techniques using SAS/Base.

Setting up active directory on the tableau server for the effortless password management for the single sign on (SS0) in the Salesforce and to view the embedded dashboards.

Expertise in performance tuning of the Tableau infrastructure including the application configurations and the interaction.

Wrote complex stored procedures, functions, SQL constructs to implement business logics in the OLTP database.

Developed database objects such as tables, views, indexes, stored procedures, and constraints with T-SQL.

Evaluated execution plan for T-SQL queries and stored procedures to improve performance based on which created indexing/partitioning strategy with re-structuring of SQL logics.

Successfully developed standardized procedures for common SQL tasks and troubleshot SQL queries and common database issues.

Connecting to Einstein analytics through Tableau and start performing amazing explorations leveraging power of tableau directly against salesforce CRM data.

Responsible for working with our Enterprise BI Team and Deploying the ThoughtSpot in Cloud (AWS).

Involved in Publishing of various kinds of Live, Interactive data visualizations, Dashboards, reports, and workbooks from Tableau Desktop to Server.

Used SAS ODS, SAS Graph, and procedures Proc Tabulate, proc means to create ad hoc reports and graphs as per the requirements of the users.

Alteryx to changed unstructured to structured data for better Tableau reporting and data analysis.

Experience in integrating Alteryx and Tableau, publishing data extracts from Alteryx to tableau server, Pulling data from Alteryx App on the server though Web data connector into Tableau Desktop.

Client: AIG Insurance, Hyderabad, India Dec 2014 – Nov 2015

Role: Data Analyst

Created worksheets reports and converted into interactive dashboards by using Tableau Desktop and provided to Business Users, Project Managers and End Users.

Experienced in designing and developing multiple analytical reports from multiple data sources by using Alteryx data blending on a single worksheet in Tableau Desktop.

Involved in Interacting with business users and performed Gap Analysis according to Client requirements.

To estimate profit generation by creating calculated fields and calculation across the table on the data from Micro SQL Server and MS Excel.

Extensively working with User stories and user acceptance criteria, release planning, iteration planning and tracking in RALLY tool for the Tableau Report requirements.

Involved in scheduling data refresh on Tableau Server for weekly and monthly basis on business change to ensure that the views and dashboards were displaying the updated data accurately.

Built credit risk PD/LGD models structural risk model and statistical models (regression, logistic regression analysis), Risk Attribution and Performance Analytics for mutual funds, and quantitative risk report.

Contact this candidate