Objective:
o Analyze and prevent Global Distribution Systems’ (GDS) cost leakage with Audit &
Intelligence
Project description:
o Our client, a Pune based start-up, had an ETL application which was also developed by us,
for loading airline ticketing data into MS SQL Server. This data is provided by GDS to the
airlines on monthly basis
o Due to abuses such as churning, inactive segments, duplicate segments, and fictitious
bookings, airlines lose valuable sales opportunities and lose 4% extra in its GDS bills
o Our start-up client wanted us to analyse the frauds in the data and provide different repots
and dashboards for its airline customers
Technology
o Tableau Desktop 10.2
o MS SQL Server 2016
Responsibilities
o Analysing different frauds and cost leakages based upon client provided business logic
o Developing detailed reports and dashboards that helped to decipher airline booking costs
and abuses
Accomplishments
o Developed an end-to-end data analytics enterprise product including data cleaning, ETL,
data analysis and data visualization

Responsibilities
o Work with Business analysts and Systems analysts to understand requirements
4
o Development of new Reports / Dashboards using Tableau Desktop and relevant data
source (Excel, SQL Server, flat files, etc.)
o Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots,
geographical maps, Gantt charts using show me functionality
o Worked extensively with Advanced analysis actions, Calculations, Parameters,
Background images, Maps, Trend lines, Statistics and Log axes
o Group hierarchies, sets to create detail level summary report and dashboard
Accomplishments
o Worked on Tableau 9.2 and got an opportunity to explore different features of Tableau

Responsibilities
o Customer interaction, data mapping, database configuration, developing a C#
application called Custom Data Formatter (CDF), UAT support
Accomplishments
o Completed the greenfield implementation with least help from Seattle team
o Completed the greenfield implementation within scope, budget and time

Project description
o A Dubai based start-up had project management web application that had
functionalities like creating schedules, project plans, resource management, document
management, etc. But lacked good reporting and dashboards
o So, client wanted us to analyse the project data, which included spatial data as well,
and provide different repots and dashboards as per his end customer requirements

Responsibilities
o Analysing project management data using Tableau Desktop
o Developing different reports and dashboards based on customer requirements

Online project management system was multi-tenet application which allowed many organizations to create upload and track their project Information right from creating project charter to project closure document.

My role was of fullstack developer