Rajeev
Pandey
Solutions Focused, Proactive and
industrious professional with 8
years of experience in Data
Analytics, Reporting
, Client & Stakeholder
Management.
Contact Information:
-
✓
-linkedin.com/in/rajvivan
1. Only Indian to be featured as
Tableau Zen Master ,Tableau
Ambassador & Tableau
Featured Author
OBJECTIVE
Seeking for a challenging and interesting role of Data Visualization Engineer in a
company that gives me scope to utilize and enhance my knowledge & skill in
accordance with the latest trends and be a part of a team that dynamically works
towards the growth of organization.
TECHNICAL SKILLS
Reporting Tools
: Tableau 2020.2, Data Studio, Cognos, Excel
ETL Tool
: Alteryx, Datameer, Trifacta, KNIME
Database
: Google Cloud Platform , MS SQL Server 2012
Reporting Cloud Server : Tableau Server and Tableau Online C
Data Visualization Tool : Oracle DV 12C, Gephi 9.3,Looker
Configuration Tool
: Terraform
Workflow & Scheduling : Airflow
Container & Platforms : Kubernetes & Docker
Version Control Tool : Gitlab and Bitbucket
Software Methodologies: Waterfall and Agile
•
•
•
•
•
•
•
•
•
•
WORK EXPERIENCE
Company: AirAsia Berhad (Since Feb,20 – Till now)
Department: Airline Tech Data
2. Udacity Nanodegree – Data
Designation: Senior Data Specialist
visualization certified
Professional
Role: Individual Level Contributor / Mid-Level Manager
3. Won a Prestigious Notable
Newbie at Tableau Conference
Tc17⇗
4. My Spiral Heatmap Technique
and got featured on US website –
Paper.li⇗
About Project:
Airline Data Analytics Product will cater to serve Digital Experience across
different business department to drive revenue acceleration and Cost
optimization. To develop a right decision-making tool, we created a
operation product Suites like
•
Ground Ops Work - Dashboard presenting day of ops operation at
Station, include flight, pax load, delay, OTP, NPS, Security, check-in
parameters
•
Manpower Dashboard – To understand crew manpower projection
for 2020 and the estimated cost impact
•
Network Planning - Day of ops flight schedule and Fleet schedule
dashboard
•
Standby utilization and Roster productivity analysis - As a part of
day to day operation activities, Crew controller at NMC uses this
dashboard to capture the operational KPI and makes tactical
decisions.
•
ODIN Dashboard - Daily performance dashboard presenting
gamified version on dispatcher performance
•
Merit/Demerit - Cabin crew department & transformation team
intend to build a digital application which would provide them an
insight and keep a tab on the merit & demerit points allocated to
crew members on certain criteria
•
Airline Santan : To forecast the demand from different channels
(online, outlet, delivery like Grab food).
5. Alteryx Advanced, Datameer
and Cognos certified Professional
6. Won United healthcare –
BizViz Analytics competition by
creating NPS Scorecard
and digital performance view
7. Develop and create original
content on Vizartpandey.com to
engage readers
8. Author and technical
reviewer of multiple Tableau
and Data Visualization books
like Pro Tableau
9. Co-leader of HYD TUG and
KUL TUG (Tableau user Group)
Roles and Responsibilities
WORK EXPERIENCE
✓
✓
Focus heavily on
optimizing existing
products to drive user
engagement against clearly
defined KPIs
Manage the process of
producing proposals,
RFPs and prequalification
documents
✓
Work with business leads to
develop short- and long-range
product roadmaps that are
adaptable and support data
and revenue goals
✓
Establish close working
relationships with
operations and affiliated
businesses for smooth back
end operations
✓
Interact with various
business stakeholders and
gather the business
specifications and
translate into data
visualizations for effective
decision making
✓
✓
Conduct research on
prospective clients; discuss
and collaborate with
partners/managers to
understand the nature of the
opportunity and the business
issues the prospective client is
facing
Act as an advisor, and serve as
primary liaison between
Communications, IT and
SSGA, collaborating on
development of new
technologies and
implementation strategy
Company: State Street (Since Oct,18 – feb,20)
Department: SoW (Share of Wallet) Analytics
Designation: Assistant Manager
Client: SSGA and SSGM CIO
Role: Tableau and Alteryx Developer
About Project:
Share of wallet (SOW) is a revenue-based model that gauges the depth of
customer relationship. It is a part of our profitability measurement
system and acts as a marketing metric which is used to calculate the
percentage of a customer's spending for a type of product or service that goes
to a particular company. We are using Morningstar data and fund-level
prospectuses to determine;
•
•
•
•
•
•
Universe of Client’s Funds
Fund-level AUM, category, domicile, investment type etc.
Funds’ Custodian, administrator, advisors, sub – advisors, etc.
Total expense ratios, custody fees, other fees, reimbursements, etc.
Identify cross sell opportunities or Asset Mix Renegotiation
Identify most attractive pockets of business to win
WORK EXPERIENCE
Company: UnitedHealth Group (Since Feb,17 – Oct,18)
Department: RADA Analytics
Designation: Senior Business Analyst
Client: UHC – OPTUM CIO
Role: Tableau and Alteryx Developer
About Project:
Technology Consumption Management (TCM) is a joint business and IT
enterprise initiative focused on controlling consumption growth while
maintaining discipline through cost reduction & efficiency opportunities.
TCM team assist in analyzing and identifying cost opportunities, change
pathways and expedite decommission activity, monthly IT chargeback
reporting, timely attestation, tracking results, target consumption and MBO
goals.
WORK EXPERIENCE
Company: Deloitte (Since Jan,16 – Feb,17)
Department: CTS – TTRA (Talent Technology Research and Analytics)
Designation: IT- Analyst
✓
✓
✓
✓
Ensured zero escalations
till date with the help of
proactive and timely
communication with the
stakeholders.
Ensured all the reporting
issues are addressed on
time with short term as
well as long term solutions
which helped in
stabilizing the business
process
Developed a core business
customer journey report
which helped the business
to view entire business
performance in a single
portfolio
Demonstrated ability to
partner in creating big
picture strategies and
bring them to
life in day-to-day activities
Client: US Deloitte
Role: Tableau Developer
About Project:
USI Demographics dashboard gives a broad level view of the active personnel’s
in Deloitte India. The dashboard was designed to give a snapshot of the
workforce (Partner Level to Administrative) across Different functions
(Advisory, Audit, Consulting, Tax and Enabling Areas).
It gave an insight related to the Year on Year comparison on the above
parameters which indirectly helped the Top Management in
planning, strategizing and executing the workforce related decisions.
WORK EXPERIENCE
Company: Tata Consultancy Services (Since Jan,13 – Jan,16)
Department: BOA – GWIM (Global Wealth Investment Management)
Designation: Senior Software Engineer
Client: Bank of America
Role: Tableau and Cognos Developer
About Project:
Bank of America CARD Information system (BACARDI) is a card services
data mart hosting card and transaction information for Consumer, Small
Business, Large Commercial. BACARDI is Authorized Data source and we
use DB2, Teradata, Unix and SQL. Bank of America CARD Information
(BACARDI) is a card services data mart hosting card and a central repository
for card specific data. It is a UDB data warehouse. Consumer Credit card
data resides in BACARDI. This information is then utilized to develop
models, assign scores, perform analyses and generate leads. Bacardi data are
mainly used for Marketing, Reporting, querying and statically analysis of the
data.
Education
▪ B.Tech in Computer Science & Engineering from WBUT University in 2012 (2008 -2012) with 8.46/10
▪ XIIth from D.A.V Public School, KoylaNagar ,Dhanbad in 2008 with 85.60%
▪ Xth from D.A.V Public School, KoylaNagar , Dhanbad in 2006 with 86.67%
Personal Details
Date of Birth:3rd June 1991
Marital Status: Married
Passport No: K-
Nationality: Indian
Full Address: Serin Residency, B Block – Unit 18 – 06, Jln Fauna 1, Cyberjaya, Selangor
Pin Code : 63000
I hereby declare that the information furnished is true to the best of my knowledge