Summary
Overview
Work History
Education
Skills
Projects
Certification
Other Experience
Links
Timeline
Generic

Sahil Shetty

Digital Transformation Officer
Sharjah,UAE

Summary

A highly motivated professional seeking to expand my skills while contributing my best towards the growth of the organization through innovation and technical knowledge. I have a deep passion for data science, business analytics and emerging technologies in the data and tech space and look forward to working in a challenging environment that is driven with the same passion. I am a quick learner with excellent leadership and communication skills and the ability to handle pressured situations well.

Overview

5
5
Certifications
3
3
years of post-secondary education
1
1
year of professional experience

Work History

Officer - Digital Business Tranformation

Takaful Emarat Insurance (PSC)
Dubai, UAE
02.2021 - Current
  • Responsible for overlooking smooth execution of all organizational processes and ETL automations, Python backend scripts and Kofax RPA bots.
  • Designed and developed automations for several data reporting processes required by Underwriting, Claims and Operations team by transforming large datasets and following best data warehousing practices.
  • Developed interactive Tableau dashboards, by using connectors to Azure SQL Database for monitoring KPIs and hosted them on Tableau Online for near real time analysis and better data visibility by senior management.
  • Performed Exploratory Data Analysis (EDA), interpreted patterns in complex data sets on ad hoc basis and responsible for performing Loss Ratio Analysis for claims data supplied by Third Party Administrators.
  • Liaising with managers of various departments in understanding their operational processes and data requirements, identifying and successfully designed workflow solutions and deployed automations saving an average of around 15-20% of operational time.
  • Integrated multiple third-party, partner and regulatory body APIs with the company's systems ensuring proper data compliance while improving efficiency of business operations.
  • Participated in bi-monthly Scrum sprints and familiar with Agile principles and methodologies and familiar with JIRA for productivity management and collaboration.
  • Working closely with Product Managers for launching of new Life and Medical Insurance products.
  • Collaborated with the marketing team in successfully implementing automated marketing strategies through Email and SMS channels and integrated APIs for analyzing our web portal traffic.
  • Developed front-end user interface using Tkinter (Python) for on-click data reporting and developed browser automations using Selenium largely reducing manual work.
  • Optimized existing code in Python and C#, business workflows (KTA) and data warehousing solutions (in Azure and Oracle DB) effectively reducing organizational cost and resources.
  • Routine bug fixing, production support and database/server management.

Business Operations Intern

Merck, Sharp & Dohme (MSD)
Dubai, UAE
07.2020 - 01.2021
  • Developed monthly in-market dashboard reports, Sales Tracking and Analysis Report (STAR) , MIS Reports and Quarterly Sales Forecasting reports for GCC region.
  • Developed interactive Tableau visualizations for GCC region involving analysis of key metrics at Business Unit Level, Brand level, Customer level, etc. and reported findings to Regional Managers.
  • Identified gaps in the inventory tracking process and implemented an automated process for better error free data gathering and tracking.
  • Liaised with Business Unit heads, Key Account Managers (KAM) and Brand Channel Managers (BCM) in gathering and modeling raw data which was then developed into Tableau Dashboards and Excel Reports delivering key insights.
  • Performed Sales Analysis on data gathered from various Business Units.
  • Automated reporting processes using VBA and Python bringing down process flow run time.
  • Designed STAR schema for implementing data warehousing solution in MS Access by migrating existing data from MySQL.
  • Data wrangling and transformation of complex datasets using Python.
  • Coordinated with distributors in tracking and updating of SKU prices and units in MySQL database.
  • Developed Tableau dashboards that eased the process of Sales Incentive Payout (SIP) by effectively mapping the data and displaying analysis of metrics such as growth rate, brand share, regional analysis, waterfall analysis, etc.

HR Data Analyst Intern

L&T Electrical and Automation FZE
Dubai, UAE
06.2019 - 08.2019
  • Worked directly under the HR Manager in making Quarterly HR Reviews and monthly HR dashboards by performing several statistical and graphical analysis such as Attrition Analysis, Lead time to hire, Training Man days, etc.
  • Analyzed, interpreted and converted raw data into charts and graphical visualizations by identifying and monitoring KPIs.
  • Automated routine excel reporting processes using VBA.
  • Liaised with HR and Finance Departments for preparing Budgeting Analysis Report, Skill Mapping Reports and Mobilization Forecasting reports based on project needs effectively bringing down costs.
  • Worked with the HR Manager in preparing Exit Interview Questionnaire and organizational structure chart documentation
  • Worked under the Procurement department in understanding various CCTV, Automation and Networking Systems procured.

Engineering Intern

StructCon Constructions
Dubai, UAE
01.2018 - 02.2018
  • Worked on-site with the Engineering team in conducting on-site inspections, manpower deployment and monitored bridge construction operations.
  • Preparation of Contracting and Safety reports and PowerPoint Presentations for upcoming projects.
  • Worked on Engineering Drawing Markups using AutoCAD.

Education

Bachelor of Engineering (B.E.) - Electronics And Communication Engineering

BITS Pilani
Dubai, UAE
08.2017 - 01.2021

Skills

    Languages: Python, SQL, C#, HTML

undefined

Projects

Time Series Forecasting of Air Passengers Data

Project on developing an ARIMA model for forecasting number of air passengers for the next 10 years based on existing historical data

Time Series Forecasting of champagne sales using SARIMAX

Project based on forecasting champagne sales using Seasonal ARIMA model.

Customer Segmentation using Python

Performed detailed customer analysis and segmentation using K-means clustering in Python on dataset from a FMCG store.

Web Application using Streamlit

Developed a web application using the Python package- Streamlit for dimensionality reduction by performing Principal Component Analysis (PCA) on the given dataset.

Data Driven Business Intelligence & Analytics

A detailed study project on the various data processing techniques and business analytics.

Whatsapp Chat Data Analysis

Performed and analysis of Whatsapp chat data in Python using Numpy, Pandas, Seaborn and regex expressions.

Nature Inspired Computation

Design Project on the implementation of Cuckoo Search Algorithm in solving NP-hard problems such as the Traveling Salesman Problem.

Certification

Full Stack Data Science Masters Course (iNeuron.ai) (Mar, 2021 - Present)

Other Experience

Emirates Motorsport Organization (EMSO)

(Oct,2019 - Present)

  • Official in EMSO and served as the Post Chief and Marshal for various race events in Yas Marina Circuit and Dubai Autodrome.
  • Involved in risk management, intervention during accidents and scrutineering of race cars to comply with FIA standards.

Hewlett-Packard (GITEX '19)

  • Part of the sales and marketing team that achieved maximum sales for HP's laptop division during GITEX 2019.

Links

Github: https://github.com/shetty13

LinkedIn: www.linkedin.com/in/sahil-13-shetty

Timeline

Full Stack Data Science Masters Course (iNeuron.ai) (Mar, 2021 - Present)

04-2022

Data Warehouse Fundamentals for Beginners (Udemy)

06-2021

Customer Analytics in Python (Udemy)

06-2021

Officer - Digital Business Tranformation

Takaful Emarat Insurance (PSC)
02.2021 - Current

The Business Intelligence Analyst Course (365 Data Science)

02-2021

Data Analysis with Python: Zero to Pandas (Jovian.ai)

12-2020

Business Operations Intern

Merck, Sharp & Dohme (MSD)
07.2020 - 01.2021

HR Data Analyst Intern

L&T Electrical and Automation FZE
06.2019 - 08.2019

Engineering Intern

StructCon Constructions
01.2018 - 02.2018

Bachelor of Engineering (B.E.) - Electronics And Communication Engineering

BITS Pilani
08.2017 - 01.2021

Similar Profiles

CREATE PROFILE
Sahil ShettyDigital Transformation Officer