Rajeev Ranjan Pandey

Rajeev Ranjan Pandey

$50/hr
Data Visualization ,Storytelling and Dashboarding
Reply rate:
-
Availability:
Hourly ($/hour)
Age:
34 years old
Location:
Cyberjaya, Selangor, Malaysia, Selangor, Malaysia
Experience:
8 years
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
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.