aditya gaurav

aditya gaurav

Social Media & Marketing Manager

Data Analytics and Business Intelligence
4roles
46skills
2education
3credentials

About

Data Analyst with 12+ months of hands-on experience in data analytics, data cleaning, exploratory data analysis, statistical analysis, dashboard development, and business intelligence using Python, SQL, Excel, and Power BI.

Experience

Social Media & Marketing Manager

Cakeloo

Feb 2026 – Jul 2026

Managed social media presence and content; planned and executed marketing campaigns and promotions; coordinated advertisements and represented the company at multiple events to support brand visibility, sales, and word-of-mouth promotion.

Data Analyst

Tranquil Labs Pvt. Ltd. (Tranquil AI)

Jan 2025 – Dec 2025

Cleaned and standardised 3 large datasets using Python and SQL, reducing data preparation time by approximately 30% and eliminating recurring weekly reporting delays. Built 4 Power BI dashboards for KPI and trend analysis, enabling trends to be identified 2x faster than with prior spreadsheet reports.

Business Analyst

Tranquil Labs Pvt. Ltd.

Sep 2024 – Dec 2024

Analysed 200+ user survey responses to identify the top 5 UX friction points and documented 3 end-to-end operational workflows for process improvement, reducing estimated internal processing time by 20%.

Business Development Executive

Go2Abroad

Dec 2023 – Aug 2024 · Noida

Counselled 50+ students on international university applications over 9 months, achieving an over 80% on-time submission rate. Coordinated with 8 academic institutions to streamline documentation workflows and reduce average application turnaround by 1 week.

Education

Glocal University

B.Tech, Computer Science & Engineering

2019 – 2023

GPA: 6.5

FNS Academy, Gulzarbagh

Intermediate (Class XII)

2017 – 2019

80%

Skills

PythonSQLCPandasNumPyMatplotlibscikit-learnSMOTEHyperparameter TuningClassificationRegressionPower BIMicrosoft ExcelPowerPointAutoCADMATLABMultisimData CleaningData WranglingExploratory Data AnalysisStatistical AnalysisData VisualisationReportingKPI TrackingBusiness IntelligenceData GovernanceA/B TestingPredictive ModelingTrend AnalysisRoot Cause AnalysisProcess ImprovementQuery OptimizationPivot TablesVLOOKUPDAXGenerative AIPrompt EngineeringAutomationChatGPTClaudeMicrosoft CopilotGeminiPerplexityGitHub CopilotSocial Media ManagementCampaign Management

Projects

Credit Card Fraud Detection

Trained a binary classifier on 284,807 transactions using Python, scikit-learn, Pandas, and SMOTE. Achieved 85% accuracy, reduced false positives by 15% through SMOTE resampling and GridSearchCV tuning, and achieved an F1-score of 0.88 on the fraud minority class.