aditya gaurav

aditya gaurav

Social Media & Marketing Manager

Patna, IndiaData Analytics and Business Intelligence
7roles
66skills
4education
3credentials

About

Data Analyst with 12+ months of hands-on experience in data analytics, data cleaning, exploratory data analysis, statistical analysis, dashboard development, business analysis, and process improvement.

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, cutting data preparation time by approximately 30%. Built 4 Power BI dashboards for KPI, business intelligence, and trend analysis, enabling trends to be identified 2x faster than with prior static spreadsheet reports.

Business Analyst

Tranquil Labs Pvt. Ltd. (Tranquil AI)

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, reducing estimated internal processing time by 20%.

Business Development Executive

Go2Abroad

Dec 2023 – Aug 2024 · Noida

Counselled 50+ students on international university applications, 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.

Account Manager

Stealth AI Startup

8 mos · Patna

Cakeloo.com

Trainee

Gunvatta Gurukul

3 mos · New Delhi, Delhi, India

Currently undergoing training, focusing on developing essential soft skills such as presentation, problem-solving, and communication to enhance professional effectiveness. Learning through case studies and experiential methods while actively building competencies in teamwork, leadership, and time management , Gaining practical insights through field visits .

Business Analyst

Tranquil AI

4 mos · New Delhi, Delhi, India

Exceptional Performance Strong Analytical and Strategic Skills Data-Driven Impact Effective Communication Product Development Contribution

Education

Glocal University

B.Tech, Computer Science & Engineering

2019 – 2023

GPA: 6.5

FNS Academy, Gulzarbagh

Intermediate (Class XII)

2017 – 2019

80%

FNS high school GULZARBAGH

12th, PCM

May 2017 - Jul 2019

DONY POLO PUBLIC SCHOOL - India

10th CBSE

Skills

PythonSQLCPandasNumPyMatplotlibscikit-learnSMOTEHyperparameter TuningClassificationRegressionPower BIMicrosoft ExcelPowerPointAutoCADMATLABMultisimData CleaningExploratory Data AnalysisStatistical AnalysisData VisualisationReportingKPI TrackingSocial Media ManagementCampaign ManagementBusiness IntelligenceData WranglingData GovernanceA/B TestingPredictive ModelingTrend AnalysisRoot Cause AnalysisProcess ImprovementQuery OptimizationPivot TablesVLOOKUPDAXData-Driven Decision MakingChatGPTClaudeMicrosoft CopilotGeminiPerplexityGitHub CopilotPrompt EngineeringAutomationProblem SolvingCritical ThinkingMicrosoft Power BIPython (Programming Language)Corporate ConsultingEmail Marketing Tools & AutomationList Management & SegmentationAnalytics & Performance TrackingDesign & User Experience (UX)Copywriting & Content CreationTeamworkCustomer Relationship Management (CRM)Sales PresentationsIT Business AnalysisMarketingData AnalysisPresentation SkillsPublic SpeakingPolicy AnalysisCommunication

Projects

Credit Card Fraud Detection

Trained a binary classifier on 284,807 transactions using Python, scikit-learn, Pandas, and SMOTE, achieving 85% accuracy. Reduced false positives by 15% through SMOTE resampling and GridSearchCV tuning, with a final fraud-class F1-score of 0.88.