Siva Kumar
Summary
To serve the organization with appropriate knowledge and skills capable of providing imaginative and technical solutions which leverage my expertise and make a positive contribution to the organization SUMMARY: Overall 12 Years of IT experience in Software Development and Implementation in Tableau 2021X and Informatica, Redshift, Big query, Microsoft SQL, Alteryx. Tableau Expertise 10 years’ experience in Tableau Desktop, Tableau Server, Tableau online in various versions of Tableau 2020X,2021X Have good understanding of Data Warehousing concepts Experience on Tableau (Desktop) and Tableau server Developed various Dashboards, used Context filters, Sets, Hierarchies, Groups and Bins while dealing with huge volume of data Experience in creating interactive dashboards using Actions, formatting and parameters Have good knowledge of using LOD, functions Designed Dashboards with Quick filters and Parameters to handle views more efficiently
Overview
11
11
years of professional experience
Work History
Tableau Consultant
JPMorgan Chase & Co
05.2020 - Current
- Tools: Tableau Desktop 2020.1, Tableau Server
- Data base: Big query
- My contribution:
- Worked as Tableau Consultant for the team
- Responsible for interaction with business stake holders, gathering requirements and managing the delivery
- Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes
- Analyzed the source systems and created Business Requirement Document (BRD)
- Set Up Row level security on Tableau dashboards
- Responsible for creating reports using Tableau desktop and publishing reports to Tableau server
- Configured different data sources using Tableau Desktop
- Blended data using multiple data sources (primary and secondary)
- Enabled tableau Actions to drill down from Dashboard to worksheet
- Extensively involved in supporting user acceptance testing (UAT)
- Created responsive dashboards using Tableau Desktop and prepared user stories
- Involved in data preparation process for Tableau connectivity,
- (NYSE: JPM) is a leading global financial services firm withassets of approximately $2.5 trillion and operations in more than 60 countries.Small business and commercial banking, financial transaction processing, assetthe firm is a leader in investment banking, financial services for consumers,management, and private equity
- My contribution, for the team
- Worked as per Agile methodology and participation in daily scrum on scrum calls
- Worked for a large program like RCDR
- Worked for Issue management dashboard to track the issues while reconciliation
- Worked for RCSA and RCDR and Issue result dashboards
- Responsible for interaction with business stake holders, gathering requirements and managing the delivery
- Extensively involved in supporting user acceptance testing (UAT)
- Created responsive dashboards using Tableau Desktop and prepared user stories
- Involved in data preparation process for Tableau connectivity
- Creation of metrics, attributes, filters, reports, and dashboards
- Created advanced chart types, visualizations
- Blending multiple data sources to allow for different views on application data in a single dashboard
- Generate KPI for growth and spend analysis
- Connected Tableau server to publish dashboard to a central location for portal integration
- Performance tuning and analysis for the developed dashboards
- Also took care of using Tableau dashboard best practices in team
Tech Lead
Tech Mahindra
11.2019 - Current
- Skill Sets:
- BI Tools Tableau Desktop 2020X, 2021X, Tableau Server,
- Qlik View, Qlik Sense, Power Bi, R
- ETL Tools Informatica Power center.Alteryx, Python
- Database Oracle, SQL Server, Big Query, Redshift
- Client: Boral Telematics IOT Support
Tableau Consultant
Morgan Stanley
11.2019 - 03.2020
- Tools: Tableau Desktop 2020.1, Tableau Server
- Data base: Teradata,Hadoop
- My contribution:
- Worked as Tableau Consultant for the team
- Responsible for interaction with business stake holders, gathering requirements and managing the delivery
- Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes
- Analyzed the source systems and created Business Requirement Document (BRD)
- Set Up Row level security on Tableau dashboards
- Responsible for creating reports using Tableau desktop and publishing reports to Tableau server
- Configured different data sources using Tableau Desktop
- Blended data using multiple data sources (primary and secondary)
- Enabled tableau Actions to drill down from Dashboard to worksheet
- Extensively involved in supporting user acceptance testing (UAT)
- Created responsive dashboards using Tableau Desktop and prepared user stories
- Involved in data preparation process for Tableau connectivity
Business Analyst
IVY Comptech
04.2019 - 11.2019
- Tools: Tableau Desktop 2019.1, Tableau Server
- Data base: Teradata
- In the gaming product development industry we are recognized as a company with exceptional technological expertise for our usage of the latest and cutting-edge software systems, innovative tools and technologies following best of the industry practices and implementations
- Our cutting edge enterprise class analytic and business intelligence technologies enable us to get a single, integrated view of our businesses in order to make better, faster decisions that drive growth and profitability
- My contribution:
- Worked as Bi Analyst for the team
- Responsible for interaction with business stake holders, gathering requirements and managing the delivery
- Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes
- Analyzed the source systems and created Business Requirement Document (BRD)
- Set Up Row level security on Tableau dashboards
- Responsible for creating reports using Tableau desktop and publishing reports to Tableau server
- Configured different data sources using Tableau Desktop
- Blended data using multiple data sources (primary and secondary)
- Enabled tableau Actions to drill down from Dashboard to worksheet
- Extensively involved in supporting user acceptance testing (UAT)
- Created responsive dashboards using Tableau Desktop and prepared user stories
- Involved in data preparation process for Tableau connectivity
Tableau Lead Consultant
Papa John’s
10.2018 - 04.2019
- Tools: Tableau Desktop 2018.2, Tableau Server
- Data base: Hadoop Hive, Big Query
- Papa John’s has over 5,000 locations in 44 countries and territories around the world
- Driven to be the best
- Better Ingredients
- Better People
- The main objective of this project is to create sales report and customer feedback and retain on location basis and store wise
- My contribution:
- Worked as Tableau Lead for the team
- Responsible for interaction with business stake holders, gathering requirements and managing the delivery
- Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes
- Analyzed the source systems and created Business Requirement Document (BRD)
- Set Up Row level security on Tableau dashboards
- Responsible for creating reports using Tableau desktop and publishing reports to Tableau server
- Configured different data sources using Tableau Desktop
- Blended data using multiple data sources (primary and secondary)
- Enabled tableau Actions to drill down from Dashboard to worksheet
- Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks
- Extensively involved in supporting user acceptance testing (UAT)
- Created responsive dashboards using Tableau Desktop and prepared user stories
- Involved in data preparation process for Tableau connectivity
Associate
Cognizant Technologies and Solutions
06.2016 - 04.2019
Tableau Consultant
JP Morgan Chase, RCDR
11.2017 - 09.2018
- Tools: Tableau Desktop 10.3, Server, Alteryx
- Data base: Hadoop Hive, Impala
Tableau Consultant
Aetna
01.2017 - 09.2017
- Tools: Tableau Desktop 10.2,Server
- Data base: Hadoop Hive, Impala, Microsoft SQL
- About 46 million people rely on us to help them make decisions about their health care and their health care spending
- Every day, we work to make the system easier and more convenient for our customers
- Aetna Medicare is a PDP, HMO, PPO plan with a Medicare contract
- Our SNPs also have contracts with State Medicaid programs
- Enrollment in our plans depends on contract renewal
- My contribution:
- Worked as Tableau Technical Lead for the team
- Responsible for interaction with business stake holders, gathering requirements and managing the delivery
- Extensively involved in supporting user acceptance testing (UAT)
- Created Rich dashboards using Tableau Desktop and prepared user stories
- Worked as per Agile methodology and participation in daily scrum calls
- Involved in data preparation process for tableau connection
- Creation of metrics, attributes, filters, reports, and dashboards
- Created advanced chart types, visualizations and calculations to Visualize the data
- Blending multiple data sources to allow for different views on application data in a single dashboard
- Generate KPI for customer analytics, product sales distribution and growth and spend analysis
- Connected Tableau server to publish dashboard to a central location for portal integration
- Performance tuning and analysis for the developed dashboards
- Also took care of using Tableau dashboard best practices in team
Tableau Consultant
Anthem
06.2016 - 12.2016
- Tools: Tableau Desktop 10, Server
- Data base: Hadoop Hive, Oracle
- Anthem, Inc
- Is one of the largest health benefits companies in the United States
- Through its affiliated health plans, Anthem companies deliver a number of leading health benefit solutions through a broad portfolio of integrated health care plans and related services, along with a wide range of specialty products such as life and disability insurance benefits, dental, vision, behavioral health benefit services, as well as long term care insurance and flexible spending accounts
- My contribution:
- Designed and developed the Edi Server Performance dashboard
- Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports
- Created Bar chart, scatter plot and pie chart, forecasting and various trend reports
- Created Maps to show locations as per their demand
- Used blending for custom geocoding
- Used parameters, calculated fields and Filters to get various requirements
- Used date and string functions in calculations to get desired fields
- Actions were used to navigate from one dashboard to other
- Attending the weakly Status call with onsite team
- Supported in production deployment.
Tableau Consultant
Webtag It Solutions
05.2012 - 06.2016
Tableau Developer
Honeywell
09.2013 - 05.2016
- Oracle SQL
- Honeywell invents and manufactures technologies to address some of the world’s toughest challenges initiated by revolutionary macrotrends in science, technology and society
- A Fortune 100 company with annual turnover of $ 40bn, Honeywell creates solutions to improve the quality of life of people around the globe generating clean, healthy energy – and using it more efficiently
- The main objective of this project is to create both micro and macro trends of Financial metrics and also to show the financial results of different business of Honeywell and thereby enabling CFO’s to take decisions promptly
- My contribution:
- Understanding the reporting requirements and providing Tableau reporting solutions
- Designing Key financial metrics such as revenue, gross margin, and Operating margins with all variances of AOP and PY
- Designing Census Metrics Dashboard clearly depicting actual and Vs
- AOP, Vs
- PY to analyze variances
- Use data visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their data
- Designing the Reports as per client Requirement and created the reports using Excel file and Oracle database
- Experienced in forecasting and various trend reports
- Experience in creating Bar chart, scatter plot and pie chart
- Created conditional filters to filter the data on dashboard
- Creating Parameters for desired functionality.
Tableau Developer
Universal Bank
06.2012 - 09.2013
- Tools: Tableau Desktop 7x, 8X
- Data base: Microsoft SQL
- Universal Bank is one of the biggest banking corporations in California, USA and providing services throughout USA and having lot of branches throughout CA (West Covina, Rosemead, Monterey Park, Arcadia, Los Angeles, and Orange)
- The main aim of this project is to migrate the project is to migrate the SAS Existing Reports into Tableau
- There reports are like daily,weekly,monthly and quarterly
- Created sheet filters to reduce the number of dashboards for better performance
- Created Maps to show global distribution over the countries of workers
- Created Actions to navigate to various pages
- Created summarized menu options as tabs in homepage where the users easily chose the required option
- Built Dashboards with drill-down capabilities, use of global filters and Parameters
- Created Ses, Groups and Hierarchies
- Publishing and scheduling the reports
- Debugged reports and Dashboards visibility with respect to client’s requirement
Education
B.Tech - E.C.E
JNTU
Additional Information
- Data-blending and Data Source Filters Designed filters, quick filters, parameters on Tableau reports Provide the custom geocoding concept to improve efficiency in Maps. Created Dual Axis / Multiple Measures, Combo Charts with different mark types, Pie Charts and Bar Charts Preparing Ad hoc reports from the given data Worked on labeling& annotations, data blending, data extract, publishing re-using data sources, applying use as filter actions, quick filtering, hierarchies, conditional formatting Good understanding in Data warehousing concepts like Star schema, snowflake schema, facts and dimensions Having good experience in writing queries in SQL and Teradata Good understanding of HDFS,, Hadoop Infrastructure and Spark. Tableau Server Expertise Hands-on experience with Installation, configuration and upgrading the Tableau Server across the environments Performed administrative and support activities across Tableau infrastructure including security administration, installation and configuration of the Tableau Server Actively involved in the creation of users, groups, projects, workbooks and the appropriate permission setup for Tableau Server logons. Monitoring the Tableau Server and giving feedback to the client on managing the environment effectively. Expertise in setting up single node Tableau Server/Tableau Cluster. Created workbooks to display the capacity of the environment, user traffic which connects to the Tableau Postgre SQL DB. Expertise in Server Backup, Restoration and Disaster Recovery Plans.
Timeline
Tableau Consultant
JPMorgan Chase & Co
05.2020 - Current
Tech Lead
Tech Mahindra
11.2019 - Current
Tableau Consultant
Morgan Stanley
11.2019 - 03.2020
Business Analyst
IVY Comptech
04.2019 - 11.2019
Tableau Lead Consultant
Papa John’s
10.2018 - 04.2019
Tableau Consultant
JP Morgan Chase, RCDR
11.2017 - 09.2018
Tableau Consultant
Aetna
01.2017 - 09.2017
Associate
Cognizant Technologies and Solutions
06.2016 - 04.2019
Tableau Consultant
06.2016 - 12.2016
Tableau Developer
Honeywell
09.2013 - 05.2016
Tableau Developer
Universal Bank
06.2012 - 09.2013
Tableau Consultant
Webtag It Solutions
05.2012 - 06.2016
B.Tech - E.C.E
JNTU