PRANTIK BORTHAKUR

Place of birth: Dergaon, Assam

Current location: #93/3, 4th B Cross, Bellandur, Bengaluru

Phone Number: 9739017175

Email: prantik.borthakur1@gmail.com

Education

07/2013 - 05/2015
MBA in Marketing Management
Indian Institute of Social Welfare and Business Management, Kolkata
07/2006 - 08/2010
B.E. in Electronics and Telecommunication Engineering
Assam Engineering College, Guwahati
07/2003 - 05/2005
Higher Secondary
Salt Brooke Academy, Dibrugarh, Assam
01/1997 - 05/2003
Senior Secondary
Kuralguri Higher Secondary School

Work Experience

08/2015 - Present

Business Analyst

Unisys India Pvt. Ltd., Bengaluru

Project: AirCore

Duration: Aug 2015 to Jul 2017

Project Description:

It is an airline passenger service system which core operating areas are reservation, departure control and flight inventory.

It has the capability to communicate with external systems through EDIFACT and Teletype messages.

Accomplishments:

  1. As proxy product owner I ensured successful implementation of the requirements related to depart EDIFACT, baggage functionalities, ticketing multi-host, SAC code and third party ticketing transactions for NDC orders.
  2. Assisted the testing team in regression cycles in flight scheduling and inventory control and brought down the defect counts to below 10%.
  3. Prepared the low level requirements related to updates in PFS ,PNL/ADL message functionalities.
  4. Developed good knowledge on core airline PSS areas in a short period of time.

Project: LineSight

Duration: Jul 2017 to present

Project Description:

It is a risk assessment engine which flags potential threats trying to enter or leave a system (e.g. a country) using boolean

rules, predictive analytics and watch list matches. Currently it is being developed for immigration agencies.

Accomplishments:

  1. As functional Business Analyst I prepared the low level requirements related to predictive analytics, restricted commodities, dashboards for different roles, watch list functionalities and assisted the development team in implementing those.
  2. Did comprehensive analysis on future possibilities and challenges related to the product and presented to the team.
  3. Became part of excel to Tableau migration exercise and designed Tableau dashboards on project KPIs.


06/2015 - 08/2015

Trainee Assistant Store Manager

Madura Fashions & Lifestyle, Bengaluru

Accomplishments:

  1. Managed floor operations of a 7000 sq feet store with 35 sales personnel.
  2. 100% achievement of monthly targets.
  3. Assisted the store manager in sales report preparation by creating excel macros.
  4. Assisted the store manager to bring down the difference between quantity present in the system and the actual quantity present to below 10%.


01/2011 - 07/2012

Engineer Grade-I

YanAir Engineer Pvt. Ltd., Guwahati

Accomplishments:

As field engineer in Ericsson India's Maxis project,

  1. Improved system outage statistics by 25% in less than one year through regular preventive maintenance of network sites and real time outage address.
  2. Improved network health by improving antenna alignment between network sites.
  3. Improved remote visibility of network sites through DCN routing..
  4. Assisted the senior engineers from field in implementing ring network and hybrid links.

Skills

70%

Visualization

64%

Business Analysis

83%

Presentation

80%

Communication

55%

Domain knowledge

90%

Problem Solving

Tools Known

70%

Tableau Desktop

60%

MySql

80%

JIRA

75%

Powerpoint

65%

Excel

Tableau Knowledge areas

60%

Charts

85%

Filters

40%

LOD

60%

Parameters

80%

Calculation fields

90%

Dahsboards

20%

Server

60%

Presentation

75%

Performance

70%

Analytics

70%

Table calculations

60%

Sets

55%

Data Blending

Business Analysis Expertise

60%

Requirement gathering

95%

Backlog preparation

90%

Backlog management

85%

Bug vaildation

65%

Knowledge sharing

90%

Backlog planning

Airline domain knowledge areas

80%

Departure control

40%

Ticketing

30%

Booking

60%

Inventory management

70%

Flight scheduling

45%

Immigration

Languages

Bengali Professional Working

English Professional Working

Hindi Professional Working

Assamese Native or Bilingual

Interests

85%

Football

90%

Cricket

75%

Food

90%

Internet surfing

85%

Creating random stuffs

40%

History & Geography

60%

Movies

Courses

Tableau - Prathima Infotech (2019)

MySql - Udemy (2019)

Two day workshop on SPSS - IISWBM (2014)

Extra Curricular

Third prize in Conjecture'14

It was an inter college Logo & tagline Quiz contest in Genesis, IISWBM MHRM annual fest. Number of team participated were 41.

Third prize winner of Brainfreeze'14

It was an inter college IQ game, conducted department of MPSM ,IIWBM, covering a wide range of challenges like memory test, problem solving, general knowledge, riddles, puzzles etc. Number of teams participated were 27.

Winner of the best short story (Assamese) 2009 and 2010

It was part of the annual wall magazine competition organized during annual college week . Number of entries were 19 in 2009 and 14 in 2010.

Winner of college week cricket tournament 2009 and 2010

Number of participating teams were 8 in 2009 and 10 in 2010.

Runners Up in Inter College cricket tournament 2009

Number of participating teams were 16.

Reach me

Send me your details

Download resume

Table of Contents