Suraj Gupta

Rising Codementor

US$6.00

For every 15 mins

ABOUT ME

Exp. Data scientist |Ex-Deloitte & Ex-EY | 6yo in Python, SQL, Tableau

I am an experience data analyst and data engineer who loves to get challenged by new data problems. A great analytical thinker and ready to take responsibility of the task end to end. I have worked on multiple roles related to data science, analytics & engineering with top class consulting's and has awarded multiple times for the great client service.
I decided to make my career in freelancing & mentoring as I want to take the complete onus of work I do and provide exceptional service to the clients. With this model I feel more incentivised, responsible and independent, resulting in feeling energized & positively motivated to give my 100%.

Technical expertise ->
• 6 years with tools/technologies like Python, SQL, Tableau, Alteryx, Power BI, Knime and Celonis.
• Ability to create complex & scalable Data pipelines, collecting data from multiple sources, performing ETL procedures, analysing the data and creating reports.
• Created easy to understand Data visualizations in Tableau and Power BI on complex problems, I have created more than 100 dashboards in last 5 years.
• Created multiple advance analytical solutions which used different statistical techniques to analyse and compare the data like Price Variance Analysis, Benford Analysis.
• Worked on multiple data science projects and created Machine learning models on real client problems.
• My projects also included web scrapping with Beautiful soup, Selenium and PDF scrapping with the help Tesseract OCR and Python libraries

New Delhi (+05:30)

Joined May 2022

EXPERTISE

5 years experience

5 years experience

5 years experience

5 years experience

5 years experience

5 years experience

KNIME

5 years experience

REVIEWS FROM CLIENTS

Suraj's profile has been carefully vetted and approved as a Codementor. Connect with Suraj now, and leave a review for them once you're done!

EMPLOYMENTS

Manager

EXL

2021-11-01-Present

1. Automation of reports using Python 2. Data engineering using Python 3. Creating probalistic models in Actuarial software

Python

Deputy Manager

Deloitte

2021-02-01-2021-11-01

• Data Science – Used ML Algorithms like Decision Tree & Random Forest to classify the vendors from best to worst, which is used while Ve...

• Data Science – Used ML Algorithms like Decision Tree & Random Forest to classify the vendors from best to worst, which is used while Vendor Evaluation. Along with it used Kmeans & Kprototype for detecting transactions which are outlier and aggregating the results through PCA. • AML – Automated Threshold Tuning - Used Statistical techniques like K -prototype, ZScore Outlier Detection, Log-Log Transformation, ATL-BTL Technique to automatically predict thresholds to identify Suspicious transactions and reporting all such SAR’s with the help of a dashboard. • Process Mining - Analyzing logs in detail and exploring the process in Celonis. The objective is to identify process gaps and monitoring KPI’s essential for the health of the process. Process covered is Procure to Pay, Order to Cash etc. • Advance Analytics - Creating models on Python/SQL/Alteryx/Knime to address fraud, risk & control monitoring and providing business insights by using the power of visualization through Tableau. Models like Vendor Fuzzy Analysis, Price Variance Analysis, Rule Based Analysis, Benford Analysis.

Python

SQL

Tableau

Python

SQL

Tableau

KNIME

Assistant Manager

2017-02-01-2021-02-01

• Data Science – Used RFM clustering along with Return & Discount on historical data to identify customer cluster with high probability o...

• Data Science – Used RFM clustering along with Return & Discount on historical data to identify customer cluster with high probability of Fraud, running Logistic Regression on it to classify Fraud Customers in actual data. Also used KMEANS & Feature Encoding using ZScores in the same project. • Advance Analytics -Created multiple analyzers like the Treasury analyzer, Profit Margin analyzer, Retail Sales analyzer, Vendor/customer fuzzy analyzer, Inventory and other client specific processes using data analysis tools like Python/Alteryx/SQL/ACL and visualization tools like Tableau/Power BI. • Process Mining – Implemented Process Mining Framework (More than 30 Procs) to achieve the complete transformation of Log Data and BI Tables on Procure to Pay process and visualize the Process Explorer on Process Gold. • Automated work papers to bring efficiency in the finance and accounting procedures exclusively working on tools like Alteryx, SQL, Tableau and Power BI

Python

SQL

Tableau

Python

SQL

Tableau

Microsoft Power BI

Alteryx

PROJECTS

Vendor Evaluation Model

2021

Used ML Algorithms like Decision Tree & Random Forest to classify the vendors from best to worst, which is used while Vendor Evaluation. ...

Used ML Algorithms like Decision Tree & Random Forest to classify the vendors from best to worst, which is used while Vendor Evaluation. Along with it used Kmeans & Kprototype for detecting transactions which are outlier and aggregating the results through PCA.

Python

Automated Threshold Tuning

2021

Used Statistical techniques like K -prototype, ZScore Outlier Detection, Log-Log Transformation, ATL-BTL Technique to automatically predi...

Used Statistical techniques like K -prototype, ZScore Outlier Detection, Log-Log Transformation, ATL-BTL Technique to automatically predict thresholds to identify Suspicious transactions and reporting all such SAR’s with the help of a dashboard.

Python