Srikar Vajjiparthi

Working with different stakeholders belonging to different teams within the organization for membership, sales and retention teams. Working on data analysis and dashboards primarily for Membership and sales team.

· Working with different stakeholders within the organization to identify the business opportunities and goals.

· Working on building Membership Retention dashboards, Revenue overview dashboard and sales dashboards.

· Responsible in maintaining the dashboards and creating metrics and KPIs on ad hoc purpose.

· Built executive summary dashboards and drill down dashboards that gives proper insights about the current scenario relating sales and membership

· Built use case dashboards to show case how to leverage the existing data they have.

· Working in analyzing the existing views on tableau online and deciding if they have to be retired/migrated/deprecated based on their usage

· Working in building views on Snowflake using different tables for different use cases.

· Working on building eye catching dashboards using several graphs like donut charts, pie charts, text tables, KPI indicators, Geographical maps.

Used various visualizations like treemap and heatmap to distribute the data in terms of demographics on the dashboard.

· Deployed dashboards in .Twbx format and responsible in setting up the permissions to the business user to actually view and interact with the dashboard

Worked with different clients across the US that covers insurance and retail domains. Worked primarily on providing dashboards to the campaign data for different clients. Worked with several teams to collect the requirement for dashboards and involved in the complete life cycle of the delivery.

· Working with different clients simultaneously to collect the business requirements.

· Worked on building campaign performance dashboards, member profile dashboards and member health dashboards.

· Working in defining metrics and KPIs’ required for each client based on individual requirements.

· Responsible in building executive summaries for different clients with eye catching visualizations and cross functionality on the dashboard.

· Built use case dashboards to show case how to leverage the existing data they have for different clients.

· Responsible in using Tableau data prep builder to create work flows and convert different data sources to a .hyper file and then schedule the respective data extracts to refresh the dashboard.

· Working on MS SQL Server to import data and then create extracts and deploy it on to tableau Online platform.

· Responsible in scheduling refresh to the existing extracts.

· Working on building unique dashboards using several new graphs like racing bar charts, donut charts, pie charts.

· Used various visualizations like tree map, pie chart in order to create data visualizations for different processes like Campaign reporting dashboard, profile dashboard etc.,

· Deployed dashboards in .Twbx format and responsible in setting up the permissions to the business user to actually view and interact with the dashboard

Worked with the EIG team to collect the business requirements for the automation of dashboards that are already being manually operated, which consist of information about different LOBs that are available in the firm.. Worked with PnC organization to provide analytical solution for different experiences related to auto insurance and home rental.

· Worked with Enterprise Information Governance team to collect the business requirements from the users.

· Worked on automation of SDM Dashboards which are being operated manually at present.

· Working on SAS Enterprise guide and MS SQL Server to import data from different big data environments.

· Built visualizations on the basis of several metrics given that are available for all the databases in different LOBs’.

· Worked on providing solution to setup a data warehouse, optimize the existing queries to improve the efficiency of the dashboards.

· Used various visualizations like tree map, pie chart in order to create data visualizations for different processes like CMM metrics, EIRS access management, standards, customer experience analytics.

· Worked in the PnC Organization and was a key team member in the process of data migration from Netezza to Snowflake

· Built Dashboards related to different kinds of insurance and leveraged different kinds of visualizations like racing bar graphs, donut charts, spark lines etc.,

· Deployed dashboards in .Twbx format and made the data accessible and the visualization more interactive to the

business user.

Environment: Tableau Desktop 2020.x/2019.x/2018.x,Tableau Server, MS Office, Aginity for Netezza and Hadoop, Snowflake, Adobe Site cat, SAS Enterprise Guide 8.1, Alteryx (ETL), Dremio (Explorer).

Gathered and analyzed the business requirement data being with the FDE team and worked on large data using the data sets, created dashboards that consists of disclosure reports using simple grid reports.

· Roles and responsibilities include developing, enhancing, re-engineering, maintaining and supporting Tableau applications.

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

· Actively participated in Business Intelligence standardization to create database layers with user friendly views in SQL Server that can be used for development of various Tableau reports/ dashboards.

· Designed and developed a business intelligence data visualization dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.

· Created and modified Interactive Dashboards and Creating guided navigation links within Interactive Dashboards. Make use of filters and making them local and global accordingly.

· Generated stories for Finance team and improved the performance by reducing analysis time.

· Resolved performance issues and worked for better scalability and availability of Tableau desktop.

Environment: Tableau (Desktop, Server) 10.x, SQL Server 2012, Alteryx (ETL), Microsoft Office.

Responsibilities:

Worked under a machine learning project where the data is collected from various sources. An analysis is done on the data and dashboards were customized according to the requirements provided by the remote associates.

· Interaction and coordination with robotics team, data modelers, DBA and managers to achieve better data and requirements for generating visually appealing and accurate reports.

· It is one of the automation projects related to the fulfilment center where 90% of the task is automated and remaining are not sure given to the remote associates.

· Developed dashboard that gives the actual numbers on the automation of the fulfilment centers, total working number analysis and the future trend analysis over the peak time period.

· Building, publishing customized interactive reports and dashboards using Tableau.

· Published SSRS dashboards on to server, administered user groups and provided production support for

SSRS users.

· Ability to work quickly and under tight delivery deadlines with focus on details.

· Tested Dashboards to ensure maximum data accuracy and functionality.

Environment: SQL Server 2012, T-SQL, SSIS, SQL Server Reporting Services (SSRS), Tableau.

Responsibilities:

Concerned with health care system which consists of information about the existing customers.

The information is further classified into categories which are linked to a unique id given to the customer and stored in tables.

· Dealt with Stored Procedure, triggers, User Defined Function, TSQL coding, Performance Tuning and Query Optimization.

· Created, Configured and tuned ETL workflows designed using SSIS of MS SQL Server.

· Performance tuning of ETL Packages.

· Deployed a SSIS package using XML file configuration and Environmental Variable.

· Customized sub reports and defining query for generating drill down reports using MS SQL Server (SSRS).

· Written parameterized queries for generating parameterized reports and sub reports using global variables, expressions, and Functions.

· Maintained positive communications and working relationships at all business levels.

Environment: SQL Server, SSIS, SSRS.