Swarnam Dash, M.S
Business Data Analyst
* ***** ** ********** ** a multinational corporation with proficiency in using Tableau, SQL, ETL, Python, Data Analysis and Business Intelligence.
ac8jh7@r.postjobfree.com 669-***-**** San Jose, US linkedin.com/in/swarnam-dash-b1422052 WORK EXPERIENCE
01/2012 – 01/2015
Business/Data Analyst
Jumeirah Group
Male',Maldives
Jumeirah, a member of Dubai Holding, operates a world-class portfolio of luxury hotels, resorts, and residences across the Middle East, Europe, Asia. Designed impactful dashboards for management reporting. Experienced with Tableau for Data Acquisition and data visualizations.
Experienced in Tableau calculations and applying complex, compound calculations to large, complex data sets. Pinpointed relations, patterns & performed Data mining operations for complex data.
Performed ETL process as per customer’s requirement & delivered the module with near zero defects
Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
Performed requirements gathering, analyzing User
Requirement& functional specification document.
Performed market research which included a business description, market statistics, and KPI.
Created UI Mockups, wireframes to envision AS IS and TO BE processes by conducting GAP Analysis.
Wrote and optimized Triggers, Stored Procedures, and Queries in T-SQL.
EDUCATION
2017 – 2019
Master of Science: Software Engineering
International Technological University (ITU)
GPA - 3.87
Data Mining Introduction to Data
Science
Python Programming Principle of Database
Systems
Data Visualization &
Interpretation using
Tableau
Oracle Database
2007 – 2011
Bachelor of Engineering in Information
Science & Engineering
Visvesvaraya Technological University (VTU)
Belgaum,India
SKILLS
Tableau Vlookup Pivot Tables MYSQL - SQL
Python Data Mining Data Analysis
Business Intelligence Data Warehousing
Statistical Computing Methods Advanced MS Excel
Google Analytics Hadoop Matlab Numpy
JIRA G - Suite BRDs Data Modeling
ACADEMIC PROJECTS
Sales Trend Analysis of Retail Business
(09/2018 – 12/2018)
Created dashboards of overall sales and gross/profit of products. Created charts and graphs like Choropleth Map, TreeMap, Stacked Graph, and Pie Chart etc.
Figured out the real cause of the downfall in the business and in which sector marketing strategies is lagging.
Developed a complete business report for the sales manager, which will help uncover insights that can have a profound effect on business. Use of the linear regression model (to fit the test and train set). Hotel Recommender System for Travel App
(05/2017 – 08/2017)
Developed a hotel recommendation system using python. Performed statistical algorithm in order to predict the recommendations.
Performed the correlation between the ratings of the hotels for finding similar hotels.
The goal was to provide not just one recommendation but to rank the predictions and return the top five most likely hotel clusters for each user’s particular search query.
Gender recognition based on voice (09/2016 – 12/2016) Engineered the acoustic features of speech such as MFCC and FFT on Kaggle Voice Dataset to classify speech samples by gender. Applied Support Vector Machine and AdaBoost classifiers that achieved 96% accuracy on 10-fold cross-validation evaluation. CERTIFICATION
MySQL-SQL for Data Analytics & BI – Udemy
Data Visualization using Tableau – Udacity
Intro to Python for Data Science – DataCamp
Achievements/Tasks
Courses