WORK EXPERIENCE

Data Analyst

RANDSTAD INDIA Private Limited / Bangalore / Jun 2017 - Present

Hubfares/Accessfares is a travel agent which is one of the Global Leader in Premium Airfares which includes planning, pricing, ticketing & after sales services. Roles & Responsibilities

• Acquire data from primary & secondary data sources such as Sabre/Trams/Clientbase and Travcom and maintain individual client databases.

• Operate as the point of contact for assigned clients and Communicate client needs and demands from Dubai and Phillipines.

• Adept in utilizing Advanced Microsoft Excel to create pivot tables, used VLOOKUP and other excel functions while preparing sales analysis reports.

• Proficient in commission tracking, Client-Vendor History and statements, Fare Savings Report.

• Specialised analysis and in publishing creating Weekly and monthly sales reports.

• Preparing and Maintaining the Weekly accounts report of the whole team using Advanced excel. Operations Executive

Paytm (One 97 communications) / Bangalore / Jul 2016 - Jun 2017 Paytm is an Indian E-commerce payment system and financial technology company. Roles & Responsibilities

• Operated as SPOC for different branches of paytm in South India Region

• 'Handling KYC operations (verifying forms, uploading in sales force)-E commerce.

• Providing backend support for the MID team for entire south Region.

• Handling a sales team of 8 people who were into corporate MID in Bangalore.

• Pulling GMV data using production MID’s from HIVE, and creating sales reports for Bangalore, Chennai, and Hyderabad Region.

• Inventory Handling with respect to the merchandising (QR codes, Acceptance stickers etc.)

• Taking care of merchant issues regarding bank settlements, QR codes, Dashboard Queries.

• Communicating with the Noida-Central team for queries regarding Rate configuration, Encrypted codes, Dashboards.

EDUCATION

Business Analytics-Programmer

Study Analytics / Bangalore / 2016

Persued Base SAS certification from Pearson VUE and Advanced excel certification. Bachelor of Technology

Government Engineering College / Kushalnagar / 2015 Earned a Degree in Bachelor of Mechanical Engineering & Technology at G.E.C Kushalnagar. Kodagu.

MILESTONES

Rocking Star

PAYTM (One 97 Communications) / Apr 2017

I Was awarded - Rocking Star of the year in PAYTM in the month of April 2017 for being the best performer in the entire operations team.

Beach Body Classics

International Natural Bodybuilding Association / Oct 2018 I Bagged Bronze medal in the Beach Body Classics held by International Natural Bodybuilding Association - 2018

TVS ARE-2021

TVS Racing Official / Jan 2021

I participated in TVS Apache Racing experience and was Awarded second runner up in the RTR160 Class Fast Lap.

Fashion Show

National Khaadi Festival / Jan 2020

I Have participated in the Fashion show Ramp walk-in the Khaadi formal clothing round and was declared best male of the evening.

PERSONAL DETAILS

Date of birth

12th November 1993

Nationality

INDIAN

Marital status

Single

Ranjan K R

D A T A A N A L Y S T

951-***-****

adoluu@r.postjobfree.com

Koramangala Road, Bengaluru,

560095, India

ABOUT ME

A Solutions driven Analyst having 5

Years of experience in interpreting

and analysing data for driving

business solutions.Upholding Strong

analytical skills with the ability to

collect, organize and analyse

significant amounts of information

with attention to detail and accuracy.

TOOLS

• Advanced MS Excel

• MS Word / PowerPoint

• SQL – Apache Hive

• Sabre Red

• Travcom • Trams

• Client Base

• Amadeus

• Microsoft Power BI

TECHNICAL

SKILLS

* Vendor/Inventory Managaement

* Client account & payments handling

* Data warehousing

* Business analysis

* Sales Reports & Analysis

* Project and Team management

* Agile methodologies

* Client interfacing

* Merchant Cards and Payments

L INKS

https://www.linkedin.com/in/ranjan-

gowda-84476355

Linkedin:

https://www.instagram.com/invites/c

ontact/?i=1rlo1fho6p46n&utm_cont…

Instagram:

HOBBIES

Fitness, Boxing, Brazilian Jiu-Jitsu,

Muay-Thai, Wrestling, Listening To

Music, Acting, Modelling, Books

Reading, Meditation, Bike Riding.

L ANGUAGES

Kannada

English

Hindi

Contact this candidate