SHRUTHI T R

Data Analyst

0618359007 | ramesh.s[email protected]m

https://www.linkedin.com/in/shruthitr02/

https://github.com/ShruthiRamesh02

https://www.kaggle.com/shruthirt

Bangkok, Thailand

SKILLS

• SQL (SQL Server, MySQL, PostgreSQL)

• Python (Pandas, NumPy, SciPy, Matplotlib,

Seaborn)

• Tableau

• Excel (VLOOKUP, Conditional Formatting, Pivot

Tables)

• Microsoft Azure (Data Bricks, Azure Data

Lake,Azure Data Warehouse)

• PySpark

• Microsoft Power bi

CAPSTONE PROJECTS

DATA SCIENCE_ EDA – Bangkok October 2023

https://github.com/ShruthiRamesh02/Python/blob/main/EDA_World_Population_Data_Pandas_Shruthi_T_R.ipynb

Tools

Used: Python, Pandas, , Matplotlib, Seaborn

● Utilized Python to analyze 7000 data science world population data and gain insights on what it takes to land a job in

analytics

● Implemented Regex techniques to comb through the job descriptions and identified the key requirements

● Aggregated and visualized the data by using pandas, matplotlib and word cloud to compile a professional report

DATA SCIENCE_MACHINE LEARNING – Credit Card Approval Prediction– Bangkok September 2023

https://github.com/ShruthiRamesh02/Python/blob/main/Odin_School_Credit_Card_Capstone_Project_Shruthi_T_R.ipynb

Tools Used: Python, Pandas, Scikit-learn, CatBoost, Random Forest, Linear Regression Analysis, AdaBoost, Matplotlib

● Analyzed data, preprocessed, explored features, evaluated models.

● Employed oversampling techniques, including SMOTETomek, to handle class imbalance in the dataset and

improve model performance.

● Utilized machine learning models such as Random Forest, CatBoost, and AdaBoost for credit card approval

prediction. Evaluated the models using metrics such as precision, recall, F1 score, and accuracy.

● CatBoost excelled in precision, recall, F1 score, accuracy, making it ideal for credit card approval prediction.

● Emphasized robustness, generalization for reliable real-world predictions beyond training data.

● Applied regression and machine learning to produce a final model with an accuracy of 88% and lift of 34%

BUSINESS INTELLIGENCE SOLUTION IMPLEMENTATION– Capstone Project – Bangkok September 2023

https://github.com/ShruthiRamesh02/Python/blob/main/Hospitality%20Domain_Power%20BI%20Project_Shruthi%20T%20R.

pbix

Tools Used: Microsoft PowerBI, Word, My-SQL

● Utilized Python to perform BI analysis on 14,000 customer reviews of six major hotel chains

● Led the design and implementation of a Business Intelligence (BI) solution for Agoda, a classic hospitality chain,

to streamline sales data management and analysis.

● Successfully integrated scattered sales data from diverse sources into Microsoft PowerBI for centralized

management, Implemented comprehensive data cleansing and transformation procedures.

● Designed and developed interactive dashboards and reports in PowerBI, providing the sales team and

management with real-time insights into sales performance, Leveraged SQL to perform advanced analytics on

sales data, extracting actionable insights for potential sales improvements.

● The BI solution facilitated efficient sales data management and analysis, empowering Axon to make data-driven

decisions.

ATLIQ HARDWARE SALES ANALYSIS – Capstone Project – Bangkok August 2023

https://github.com/ShruthiRamesh02/Python/blob/main/Atliq%20Hardware_Sales%20Insights_Project%20Presentation_Sh

ruthi%20T%20R.pdf

Tools Used: Microsoft PowerBI, Word, My-SQL

● Utilized SQL to extract data from 8 different related tables from Atliq sales databases using JOIN and VIEW

● Created a dashboard with Power Bi to help client Atliq hardware to understand the sales insights

● Transformed and processed client’s data by using DAX and Excel to ensure data completeness and validity

● Provided technical insights on how the client can fully utilize their data by introducing different technologies

● Consulted with client to determine the best metrics to be displayed on final product

● Loaded and visualized data with Python to identify key business intelligences that can improve sales performance

WORK EXPERIENCE

BUSINESS DEVELOPMENT CONSULTANT – Aditya Group – Bangkok Sept 2016 – Feb 2017

● Generated business for the company by developing new clients along with working on existing client

business requirements in the IT domain.

● Negotiated contracts and closed the assigned tasks in the given timeline.

● Outreached 1K leads for business that delivered around 47% of target by utilizing my LinkedIn and

cold calling skills.

● Led recruitment process for 7 in-house and 5 client roles with navigating the hiring process sorting using Excel

Pivot and VBA which help reduced processing time by 50%

● Generated three process reports weekly for continuous accounts for financial and developmental analysis

RECRUITMENT CONSULTANT – ADI Resourcing Pvt Ltd – Bangkok May 2016-Aug 2016

● Handled Thai and Indian client requirements with end-to-end recruitment cycle process.

● Pipelined potential clients in the IT business industry and initiated clients in Indian market for

● permanent and contractual staffing and sealed 2 business deals in Indian operations by using

vendor mapping.

● Led recruitment process for 8 new hires in India and 5 in Thailand that filled all the immediate roles by

streaming the hiring process

CERTIFICATE CREDENTIALS

Odin School- Data Science Professional Certificate October 2023

https://github.com/ShruthiRamesh02/Python/blob/main/Data_Science_Bootcamp-Certificate_Shruthi_T_R_page-0001.jpg

Coursera-Data Analytics Certificate August 2023

https://github.com/ShruthiRamesh02/Python/blob/main/Coursera_IBM%20Data%20Analytics_Shruthi%20T%20R.png

Coursera_ Excel Skills for Business: Essentials July 2023

https://github.com/ShruthiRamesh02/Python/blob/main/Shruthi%20T%20R_Excel%20Business.jpg

Research Paper: A Study on Digital Recruitment as a New Normal During and Beyond Covid - 19 Pandemic in Thailand IT

Sector (IIM Shillong-April 2022).

Google Certificate: Negotiate Your Salary (Google Applied Digital Skills -Oct 2022).

Creative Management (Stanford University Jan- 2013)

EDUCATION

MASTER OF BUSINESS ADMINISTRATION – BNMIT University – Bangalore, IN July 2014

Majors: Human Resource Management