PRANTIK BORTHAKUR

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

90%

Problem Solving

83%

Presentation

80%

Communication

70%

Visualization

64%

Business Analysis

55.00000000000001%

Domain knowledge

Tools Known

80%

JIRA

75%

Powerpoint

70%

Tableau Desktop

65%

Excel

60%

MySql

Tableau Knowledge areas

90%

Dahsboards

85%

Filters

80%

Calculation fields

75%

Performance

70%

Table calculations

70%

Analytics

60%

Parameters

60%

Presentation

60%

Sets

60%

Charts

55.00000000000001%

Data Blending

40%

LOD

20%

Server

Business Analysis Expertise

95%

Backlog preparation

90%

Backlog management

90%

Backlog planning

85%

Bug vaildation

65%

Knowledge sharing

60%

Requirement gathering

Airline domain knowledge areas

80%

Departure control

70%

Flight scheduling

60%

Inventory management

45%

Immigration

40%

Ticketing

30%

Booking

Language skills

Assamese Native or bilingual proficiency

English Professional working proficiency

Hindi Professional working proficiency

Bengali Professional working proficiency

Interests

90%

Cricket

90%

Internet surfing

85%

Football

85%

Creating random stuffs

75%

Food

60%

Movies

40%

History & Geography

Courses

Two day workshop on SPSS
IISWBM
2014
MySql
Udemy
2019
Tableau
Prathima Infotech
2019

Extra Curricular

Runners Up in Inter College cricket tournament 2009

Number of participating teams were 16.

Winner of college week cricket tournament 2009 and 2010

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

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.

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.

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.

Reach me

Send me your details

Download CV

Table of Contents