Vivek Shankar
Pittsburgh,USA
Overview
9
9
years of professional experience
1
1
Certification
Work History
Lead Decision Support Analyst
Highmark Inc
PA, USA, USA
11.2017 - Current
- Talking to the leadership team (Directors, VPs) on the Analytics needs, prioritizing the needs
- Discovering the data and finding the right sources to fit the needs Designing the data flow using Alteryx, to Extract transform and load the data which are readily consumable Design & build high end tableau visualizations that answers all the business questions Lead the team of developers and help them with designing the optimal BI solutions Train users on how to use the dashboard & what data is being displayed in dashboard
BI Lead
TATA Consultancy Services
NJ, USA, USA
02.2017 - 11.2017
- Actively involved in conducting user interview sessions to analyze and design the best Tableau visualizations that answer all the business questions
- Actively involved in developing the call and shipment dashboard to track the call/shipment trend using Tableau desktop Designed and developed Portfolio Optimization Model analytics dashboards that enables the management to track the product's sales vs profit Working closely with the Data team in designing the Dimensional data model that caters to the need of Tableau visualization, Developed Alteryx workflows to get ready data for Tableau viz
BI Architect
TATA Consultancy Services
NJ, USA, USA
12.2015 - 02.2017
- Conducted user interviews with Sales Representatives, Regional managers, Area Managers and Sales Vice Presidents to identify the business questions that the field Sales group is trying to get answers for
- Developed the wireframes, Developed Complex Dashboards and Scorecards for the mobile devices that cater to the needs of Sales Consultants Designed the data security, object security for tableau Dashboards to secure the data and the dashboard that the users consume
- Designed and Optimized Connections, Tableau Data Extracts, TabCMD Schedules for Background Tasks and Data Refreshes for corporate Tableau Server Worked closely with the ETL team to design the optimum ETL data flow
- Developed the views to cater to the needs of the reporting in Redshift DB
BI Lead
TATA Consultancy Services
Mumbai, Ind, Ind
- 05.2014
- Designed & developed the Meta data models using Information Design Tool, developed the complex interactive dashboards for Travel, Communication Expense analytics using SAP Xcelsius
- Designed Business/Data Security profile to manage security
BI Developer
TATA Consultancy Services
Mumbai, Ind, Ind
- Developed complex dashboard using Cognos Report Studio
- Actively involved in Cognos 8.4 to Cognos 10.1 migration Designed and developed HR analytics dashboards (Headcount, attrition & utilization) using Cognos Active Reports
Education
MS in IT Project Management -
Robert Morris University, Pittsburgh, US
12.2022
BE Instrumentation and Electronics Engineering -
Visvesvaraya Technological University, India
Skills
- SQL
- PL SQl
- Redshift
- Oracle 11g
- MS SQl
- Teradata
- Postgre
- Tableau (ver 9 )
- IBM Cognos (ver 84 )
- SAP BO (40)
- Framework manager
- Information Design tool
- SAP Xcelsius
- SAP Web Intelligence
- Alteryx
- Alteryx server
- PowerBI
Certification
- Certified Tableau Desktop Specialist
- AWS Certified Cloud Practitioner
Leadership Experience
- Data Warehousing concepts
- Project Management
- Portfolio Management
- Strategic Planning
- Quality Assurance in IT projects
- AWS Cloud concepts
- Python
Timeline
Lead Decision Support Analyst
Highmark Inc
11.2017 - Current
BI Lead
TATA Consultancy Services
02.2017 - 11.2017
BI Architect
TATA Consultancy Services
12.2015 - 02.2017
BI Lead
TATA Consultancy Services
- 05.2014
BI Developer
TATA Consultancy Services
MS in IT Project Management -
Robert Morris University, Pittsburgh, US
BE Instrumentation and Electronics Engineering -
Visvesvaraya Technological University, India
- Certified Tableau Desktop Specialist
- AWS Certified Cloud Practitioner
Similar Profiles
Amanda BombichAmanda Bombich
Operations Manager, Utilization Manager at Highmark IncOperations Manager, Utilization Manager at Highmark Inc
Deanne BritoDeanne Brito
Customer Service Representative at HIGHMARK INCCustomer Service Representative at HIGHMARK INC
Adrian DuBoseAdrian DuBose
Associate Claims Implementation Analyst at Highmark IncAssociate Claims Implementation Analyst at Highmark Inc
LUZ E BLANDONLUZ E BLANDON
Assistant Project Manager at Deployed ServicesAssistant Project Manager at Deployed Services
PALAK MEHTAPALAK MEHTA
Patient Care Technician at Allegheny Health NetworkPatient Care Technician at Allegheny Health Network