Vivek Kumar

Snr. Tableau Architect & Technical Manager

adxfrf@r.postjobfree.com

Phone: 201-***-****

EDUCATION

Master of Business Administration (MBA) in BI and Analytics (Data Science), Stevens Institute of Technology School of Business, NJ, USA, Grade A

Master of Science (MS) in Information Systems, Concentration: Business Intelligence and Analytics (Data Science), Stevens Institute of Technology, NJ, USA, Grade A

Master of Business Administration (MBA) in Information Systems, Symbiosis International University, Pune, Maharashtra, India, Grade A

Bachelor of Science in Chemistry (Hons.), VBU, India

Specialization: Supply Chain Analytics, Marketing Analytics, Social Media Analytics, Location Analytics, Web Analytics, Consumer Behavioral Analytics

PROFESSIONAL SUMMARY

Vivek Kumar is a technology-savvy, transformational and inspiring Snr. Tableau Architect & Technical Manager with 18+ years of diversified experience in Information Technology, Business Intelligence Application development and Data Analytics by leading major BI projects to resolve business challenges, highlight operational inefficiencies through meaningful BI solution using various market leading tools/technologies e.g. Tableau, Qlik Sense, Python, VBScript, VBA Script, Cognos, Web Scraping, Hadoop, SAP Hana/BW, Oracle, Teradata, SQL Server, and Machine Learning (AI/ML) models for company's critical business operations.

Strong understanding of Data Warehousing/BI concepts to drive overall BI direction and reporting/analytics systems convergence/simplification across company.

Delivered 500+ Analytical Business Intelligence Forward and Reverse Logistic Reporting which assisted in increasing SL by 5-10% for 1700+ Verizon stores, improved inventory demand forecasting by 5-10%, Predicted Sales for Verizon stores with 92% accuracy, automated reporting system using Python and other visual tools leading saving of 20k man hours per year, improved on time shipping by 12% to meet 98% SLA, improved perfect order by 8% to be above 98% SLA.

Migrated 300+ legacy reports developed in Cognos, BO, OBIEE, SAC into Tableau and Qlik reports

Delivered 50+ sourcing integrated reporting using SAP Ariba using python framework by generating saving of $10M per year with SR and Contract completion forecasting with 95% accuracy, scorecard to measure CSE and Supplier performance in real time to choose the best CSE and supplier to reduce contract creation and publishing cycle time, Cycle time reporting to measure the cycle time for SR and Contract while engaging with 15k suppliers, 30+Business Units, 1000+ Sourcing categories.

As a Business Intelligence and Analytics Tableau Architect oversee and administer data management, data analysis, and reporting capabilities and responsible for turning data and analysis into relevant insight and actionable information.

As a Tableau Architect of BI & Analytics team partner with product leaders to use data driven techniques to shape the strategy and direction of new products and services.

Experienced in building a reporting and analytics team from scratch and drive them through to achieve company’s missing and business goals

Experienced in vendor management and hardware procurement process

Consult with and present to the Leadership Team and functional Managers to determine ways to support the strategic plan, improve business processes, and effectively manage business objectives through data analysis and reporting.

Identify critical path decisions, make recommendations & influence program leaders & business process owners to maximize project payback.

Partner with product leaders to translate product vision into quantifiable success through rigorous analysis and data exploration.

Partner with business units, product owners, data expert and development teams to translate potential data driven ideas into fully developed product solutions.

Champion ideas that led to end-to-end visibility of the performance and health of key initiatives.

Experienced in using Python and R for machine learning e.g. web data analysis, web scraping linear regression, multiple regression and other predictive and classification algorithms.

Experienced in Web, Location, Retail, Sales, Marketing, Sourcing & Procurement, Mobile & Supply Chain Analytics.

Streamline processes and look for opportunities to maximize efficiency and effectiveness across the business.

Explore data, identify critical information, analyze, develop hypotheses and make recommendations.

Engaged in various migration projects by leading 10+ developers and DBAs e.g. Oracle super cluster to Oracle, Tableau platform to Qlik Sense platform(500+ dashboards), Cognos reports to QlikSense dashboards(100+) resulting in saving of $5M.

10+ years of strong automation skill using Selenium and other automation tool e.g. UFT, Selenium, Loadrunner, Quality Center, and SoapUI for Java and SAP application automation.

Delivered various test automation framework by increasing testing efficiency by 90% and meeting SLA of 90% features/functions. This resulted in overall 40K hours saving and reducing testing cost by 60% for POS and SAP applications.

Proficiency in Tableau Desktop, Tableau Server, Qlik Sense Desktop, Qlik Sense Server, VBScript, Python, R, VBA, Macros, SQL, C#, Java, Machine learning

Leading a team of 30+ developers, data modelers, analysts from VZ India to deliver Business critical supply chain dashboards insight using Tableau and Qlik Sense to solve business challenges and problems.

Snr. Tableau Architect

Company Name: Verizon

Duration: July 2021- Present

New Jersey, USA

Worked with business to gather requirements through Jira stories.

Participated in agile session to groom Jira stories and document acceptance criteria.

Collaborated with multiple teams for outlining the plan and strategy to deliver the committed BI requirements

Worked as Lead architect to run daily internal and cross functional team meeting to align development timeline, BI Strategy, BI Architecture with all stakeholders by managing user stories in Jira and discussing daily progress and update till delivery.

Designed and architected the Python Framework for extracting data from SAP Ariba DB via API pull and push mechanism.

Led to develop Python script engine to parse JSON format SAP Ariba data to csv files.

Enabled the data ingestion by working with Hadoop team to load csv files to Hadoop Hive tables.

Worked with data modeler to create base and entity tables.

Architected efficient and unified data model by implementing best practices and star schema model for dashboard development and self-service.

Led a team of Tableau/Qlik developers to design and develop various sourcing dashboards using e.g. SR Management, Active Contracts, Expiring Contracts, and CSE Assignment etc.

Introduced best practices to monitor data ingestion and load to base and entity tables by implementing alerting mechanism and data-load monitoring dashboard.

Tableau Architect

Company Name: Verizon

Project Duration: Oct 2015 – June 2021

Location: Warren, New Jersey, USA

Joined the dynamic Global Supply Chain team at Verizon as Visualization and Tableau Architect using various BI software like Tableau, Cognos, Qlikview, and MicroStrategy.

Hired Tableau and Qlik Sense consultants and trained them for company’s system, best practices and process to deliver projects

Managing consulting resources, worker orders, worker contract term’s extension and consultant’s timesheets and other people management jobs.

Leading a team consisting of Tableau and Qlik Sense engineer to design, development and testing of supply chain’s reverse and forward logistics dashboards based on mission critical Verizon Global Supply Chain KPIs using Qlik Sense and Tableau for end to end delivery.

Engaged in requirement gathering process with Global Supply Chain Business team for building executive and operational dashboards

Defined, developed and delivered end-to-end BI Architecture/Strategy/Solutions for Verizon Global Supply Chain reporting platform using visualization tools like Tableau and Qlik Sense.

Designed many operational and executive dashboard using Tableau/Qlik Sense, SAP Hana, Oracle Super Cluster, SAP BW, Teradata.

Designed and developed self-service platform using Tableau and Qlik Sense for Verizon Global Supply Chain Business groups which eliminated the time lag to deliver business critical dashboards in production

Implemented Data Governance, BI Security Implementation, Data Modelling, Data Definitions, Data Management, Data Quality, Data Modelling/Dimensional Modeling using Star Schema concepts for Tableau and Qlik Sense Projects

Applied the solution expertise in handling the performance issues of BI dashboards.

Introduced the best practices, processes and methods for developing the executive dashboards, QVDs, Data Model for faster decision making.

Created the multi-node distributed architecture for Tableau (On Prem) and Qlik Sense (On AWS and On-Prem) Server for better performance, higher availability and scalability in lower and production environments.

Implemented an end to end DR solution for mission critical business applications to provide high availability

Managed the Tableau/Qlik Sense server as Tableau/Qlik Sense Server Administrator for user management, roles creation, user issues resolution, server upgrade and coaching the IT and business team for new features.

Assisted BI team to take the Tableau/Qlik Sense reporting to next level by using Big Data platform, tools and technologies e.g. Hadoop, ML, Web scraping, Advanced Analytics

Led and developed many business critical supply chain KPI based interactive Tableau and Qlik Sense executive dashboards e.g. Weeks/Days of Supply, Inventory Turns, Inventory Valuation/Working Capital, Service Level, Forecast Accuracy, Sales and Operations Planning (S&OP), shipment accuracy, Stock Transfer Orders, Order Dashboard to name a few.

Worked on tech refresh and report migration of mission critical business dashboards from Cognos to Qlik Sense by sizing the application and data and working with various groups/vendors to procure(hardware & software), install, implement and roll out with no impact to end users.

Developed and tested ML model for Sales Prediction across Verizon store for specific SKU and Service Level Prediction for specific SKU or OEM and by using Multiple Regression Model. The SL model predicts the SL% on a given day for specific SKU with 87-90% accuracy range.

Engaged on regular basis with Global Supply Chain Business leaders to evaluate the new requirements and opportunities to assist them in resolving business problems using valuable real time analytics.

Very clear understanding of business needs to develop analytical solution to resolve business issues.

Responsible for providing effective and efficient visualization for Global Supply Chain reporting.

Delivered very critical executive dashboards for GSC business operations e.g. Sales and Forecast Dashboard, Tiered Stockout Dashboard, STO In-Transit Dashboard, ISPU Dashboard, Business Process Monitoring Dashboards for all channel, STO Dashboard, Iconic dashboards for Iconic launch for premium devices like Apple iPhone and Samsung, Service Level Dashboard etc.

Applying the solution expertise in handling the performance issues of developing and developed dashboards.

Working as Tableau Architect for Global Supply Chain and introducing the best practices, processes and methods for developing the executive and other critical dashboards for faster decision making.

Managing the Tableau server as Tableau Server Administrator for user management, roles creation, user issues resolution, server upgrade and coaching the IT and business team for new features.

Assisting the team to take the Tableau reporting to next level using Big Data platform and tools e.g. Hadoop, Kyvos

Leading VDSI offshore team of 10 team members for DevOPS, wSAP and non-SAP application automation using Selenium’s Page Object and Pepper framework

Engaged and led VDSI team for documenting SAP and non-SAP Regression Test Case suite creation for 100% Test coverage

Accomplished 95% Test automation for wSAP and non-SAP application’s test cases to save 10,000+ man hrs.

Migrated 300+ legacy reports from OBIEE, Cognos, BO, SAC and associated metadata to Qlik Sense and Tableau

Implemented of best practices on site creation, load balancing, security on Tableau server

Performed daily monitoring and analysis of Tableau Server health checks to ensure server stability and reliability

Created Tableau security group and row level security group to restrict data and dashboard access by role based profile creation and providing efficient way of user group management

Provided support to end Tableau users(data extract enhancements, inconsistencies, connections, scheduling and, performance tuning)

Resolve problematic dashboards and extract refresh in production

Worked with users to build and provide solution for new extracts for their needs

Automated and monitored Tableau software upgrades and patches and, repository backup and restoration

Developed a Tableau Server Monitoring dashboard for tracking dashboard usage by building data model using Tableau postgres back database.

Tableau Architect

Company Name: Verizon

Project Duration: Apr 2013 – Oct 2015

Location: Warren, New Jersey, USA

Led a team to build Business Intelligence application using Tableau BI software.

Engaged in Big Data analysis, data mining and data modeling discussion.

Performed process automation for data conversion. Transitioned the BI project to Tableau platform by providing insightful POCs.

Engaged and led a team in providing solution for complex business requirement using Tableau.

Led a team to create various user friendly and intuitive BI reports and dashboards using Tableau inbuilt features like parameters, cascading filters, calculated fields, actions, inbuilt maps for various geographies like state, county etc. Engaged in creating custom geographies for on demand and adhoc reports and dashboards for business users.

Created and managed views within BI datamart for new and existing reports and dashboards. Developed POCs using various visualizations using different types of graphs and charts of Tableau for business approval for new requirements.

Generated color coded heat maps over various geographical map for highlighting geographies which needs immediate attention using analytical metrics model.

Created front end GUI design template to present various Tableau reports visualization over the web. Developed, tested and deployed various BI reports/dashboards in production environment on Tableau server.

Responsible for data extract refresh in production environment for daily, monthly reports/dashboards.

Created excel macros for automated data integrity checks and validation for data mart tables. Responsible for delivering high quality release by implementing stringent checks and balances with meticulous test planning and test strategy.

Sr. Tableau and Test Automation Developer

Company Name: Diversant LLC

Client: Verizon

Project Duration: Oct 2012 – Apr 2013

Location: Warren, New Jersey, USA

I was responsible for delivering high quality products for Precision Market Insight which was based on Big Data analytic in agile environment. This involved complex algorithm and extrapolation logic to give marketing insight into data, based on location and mobile data.

I was responsible for preparing complex Test Plan, Test Cases and Test Strategy by leading a highly energetic QA team for successful delivery of Precision products every Sprint in Agile Development process.

Engaged in facilitating and coordinating UAT testing by Business users every Sprint prior to production deployment.

Worked closely with Business and Development team to accommodate latest user requirement change implementation for Precision products.

I was responsible for mentoring and guiding QA team for conducting System, Functional & UI, Regression, Metrics, Data Validation, Performance and ETL testing

Web Services Testing-HP Service Test Lead

Company Name: Diversant LLC

Client: Morgan Stanley Smith Barney

Project Duration: Jun 2011 – Sep 2011

Location: New York City, New York, USA

Engaged into leading a team to perform test planning and execution for testing Morgan Stanley web services and applications.

Provided automation solution using HP Service Test for automated testing of web services.

Worked closely with my team developers for defect fixes and getting update for latest changes on service level.

Managed defects in QC by engaging right people until closure.

Provided quality test solution with detail test planning for Smith Barney's financial applications

Automation Testing -QTP Lead

Company Name: Dow Jones & Company

Dates Employed: Jul 2010 – May 2011

Employment Duration: 11 mos

Location: Monmouth Junction, New Jersey, USA

Led the initiative of laying the foundation of automation solution using QTP/VB Script for Dow Jones ecommerce applications (WSJ and Barons) which were built on ATG ecommerce platform.

Provided end to end automation testing solution for online order processing.

Engaged into drafting testing project plan and preparing test plan, test strategy and test scripts.

Led an offshore test team of 10+ members for OLF migration project. Provided the system understanding to new team in India for initiating testing activities

QTP Automation Lead

Company Name: Verizon Wireless

Dates Employed: Jun 2008 – Jun 2010

Employment Duration: 2 yrs. 1 mo.

Location: Warren, New Jersey, USA

Worked as Sr. Automation QTP Lead for POS group in Verizon Wireless.

Developed and managed complex automation framework and scripts for POS applications eROES, OnePOS, SFAOM and NetACE using VB Script and QTP.

Provided QTP based automation solution for Webservice testing for POS APIs which were used by its end clients like Walmart and BestBuy.

Responsible for drafting and execution of Test Plan, Test Strategy and Test Scripts for POS applications. Performed various types of testing life cycle e.g. System, Regression, and Application for monthly or biweekly releases

QA Lead

Company Name: John Deere

Dates Employed: Sep 2006 – Feb 2008

Employment Duration: 1 yr 6 mos

Location: Magarpatta City, Hadapsar,Pune,Maharashtra, India

Worked as QA Lead for John Deere for one of its pristine embedded application Service Advisor which is used to identify the malfunctioning of Tractors in field.

Led a team of testers to ensure full end to end testing is planned, executed and issues raised have been reported and managed until closure.

Engaged into automation of the application using QTP for faster execution with better accuracy.

Coordinated with onshore end client for briefing them on testing activities on daily level.

Responsible for managing complete testing cycle to meet the deadline and giving high quality deliverables.

Senior Subject Matter Expert

Company Name: Amdocs

Dates Employed: Feb 2005 – Aug 2006

Employment Duration: 1 yr 7 mos

Location: Magarpatta City, Hadapsar, Pune, Maharashtra, India

Worked as Senior Subject Matter Expert for Amdocs and got engaged into Yellow Pages Publishing software A-CRM application testing.

Primarily responsible for leading Test Plan, Test Strategy and Test Case preparation.

Participated in test case execution and defect management.

Improved the quality of the products overall by performing various types of testing e.g. Pre-Installation, System, Regression and UAT testing.

Responsible for creating testing environment and maintaining its stability by coordinating with database and development team.

Worked closely with Business team to understand the business requirement for initiating testing activities for each release.

Major Dashboards Operationalized:

Business Process Monitoring Order Dashboard:

Benefit: Assisted to meet Perfect Order over 98%

BPMon Executive Dashboard assist Verizon Supply Chain Business and IT Leadership to have an oversight of all orders coming from different channels into Supply Chain System and how it is being processed at different system and sub system levels and finally shipped to the end customer. It outlines and gives visibility for all issues when order gets stuck for technical or other reason and assist Business and IT leadership to take quicker action to avoid impact to the end customer and in meeting SLAs.

Iconic Dashboard:

For new phone launch by Apple or Samsung or other major phone companies this dashboard provides end to end visibility for order tracking, issues, and other operational visibility for making decision and faster action to resolve business problems. This assist in keeping the business SLA and improved customer satisfaction.

Benefit: Assisted to meet Perfect Order over 98% and Customer satisfaction of 99%

SAP Pre and Back Order Dashboard

Benefit: Assisted to meet Perfect Order over 98% and Customer satisfaction of 99%

This order tracks all those open orders of customer who gets impacted due to various reasons e.g. stock out, delay in purchase order or other fulfillment reasons which can impact the committed shipment date for the customer. This dashboard improves the customer satisfaction by assisting Verizon team by reaching out to them proactively on time and managing their expectation with revised ship commit date.

Sales and Forecast Demand Waterfall Dashboard

Demand and Forecast is backbone of Supply Chain and within GSC team this dashboard helps to look into the moving trend of Actual Sales against the projected Forecast/Demand for 2 weeks to make business decision to adjust the demand by looking into the sales vs forecast trend historically, by SKU or overall, if we are over forecasting or under forecasting. This dashboard extremely helps the business in managing the shrinking working capital effectively.

Benefit: Assisted to meet Inventory Planning to achieve 98% accuracy and reduce Lead time by 15%

Tiered Stockout Dashboard:

Benefit: Assisted to meet SL to achieve 95+% accuracy and improve SL for 1700+ stores by 5-10%

This dashboard assist business in monitoring by giving visibility of the Stockout and Service Level for important SKUs for all markets covering 1700+ Verizon stores. This enables the business in taking quick action if there are visible anomalies to avoid customer impact.

STS, SDD, SFS Dashboards:

Benefit: Assisted to meet SLA for customer order delivery for STS, SFS and SDD orders to achieve 95+% accuracy

This dashboard assist business in monitoring by giving visibility of the STS, SFS and SDD Orders start to end delivery life cycle. This enables the business in taking quick action if there are visible anomalies to avoid customer impact.

ISPU Dashboard:

This dashboards assist business users to monitor ISPU orders across Verizon’s stores and helps them to make decisions based on critical observation and insight this dashboard provides. It gives visibility to complete end to end order process from the time order is placed, processed by the system, packed by the rep and picked by customer on daily as well as historical timeframe level. This improved the order accuracy and reducing processing error by 15% and improving perfect order by 6%.

Contact this candidate