Nikhil Pundir
Nahan
Summary
Dynamic data professional with a proven track record at Data Acts, excelling in SQL and Python to drive impactful insights. Expert in crafting data visualizations and dashboards, enhancing decision-making for startups. Adept at managing cloud-based datasets, demonstrating strong analytical skills and a passion for transforming data into actionable strategies.
Overview
1
1
Certification
Work History
Freelancer
Data Acts
Solan
- Collected and cleaned data from various sources including Google Analytics, CRM tools, and ad platforms.
- Developed dashboards in Looker Studio, Zoho Analytics, and Metabase to visualize sales, customer behavior, and ad performance metrics.
- Wrote SQL queries to analyze trends, segment customers, and track overall performance.
- Utilized Python for data cleaning and retrieving information via APIs as necessary.
- Managed large datasets using cloud tools such as BigQuery and GCP.
- Created custom reports to assist startups in understanding ad ROI, sales trends, and customer journeys.
Education
Bachelor of Education (B.Ed.) -
Himalayan Institute of Education
HP, India01.2024
Bachelor of Science (B.Sc) - Physics
PG College Nahan
Nahan, HP, India07-2022
Intermediate -
Career Academy Sen. Sec. School
HP, India01.2019
Matriculation (CBSE) -
Career Academy Sen. Sec. School
HP, India01.2017
Skills
- SQL
- Python
- Google Cloud Platform
- BigQuery
- Google Analytics 4
- Google Tag Manager
- Dataform
- Data Pipelines
- ETL Processes
- Looker Studio
- Data visualization
- Data cleaning
Projects
- AMT - Aminitiri (Bangalore Cake & Cookie Startup), Built a monthly sales, revenue, and advertising insights dashboard. Used GA4, SQL, and Looker Studio to track trends, top-performing products, and ad ROI., https://github.com/nick7hash/Res_AMT_project.git
- SUE - Suri Engineers (Industrial Machinery Startup), Analyzed customer behavior using data from Kylas CRM and ad platforms. Created automated insights dashboards combining ad performance and lead data., https://github.com/nick7hash/Res_Suri
- UNI - Unimig (Australian Welding Supplies Company), Worked on Odoo ERP data to derive shipment, sales, order, and manufacturing insights. Helped automate reporting for faster internal decision-making., https://github.com/nick7hash/Res_Uni_Project.git
- MTT - Maritime Travel (US-Based Travel Company), Processed and visualized booking and travel data to understand seasonal trends and customer behavior. Delivered insights using BigQuery and Looker Studio. https://github.com/nick7hash/MTT-Maritime_Tours.git
- VIN - Vinita (Canadian dating app), developed a full-funnel marketing dashboard with multi-channel ad spend, ROI, and revenue metrics Combined data from Google, Facebook, and Apple Search Ads using BigQuery and Dataform.
Certification
- Qualified State Teacher Eligibility Test - November 2023
- Cleared JOA (IT) State Government Exam twice
Timeline
Freelancer
Data Acts
Bachelor of Education (B.Ed.) -
Himalayan Institute of Education
Bachelor of Science (B.Sc) - Physics
PG College Nahan
Intermediate -
Career Academy Sen. Sec. School
Matriculation (CBSE) -
Career Academy Sen. Sec. School
Similar Profiles
John RezkJohn Rezk
HR Manager at ACTS Advanced Construction Technology Services (ACTS)HR Manager at ACTS Advanced Construction Technology Services (ACTS)
Dylan EnlundDylan Enlund
Volunteer at ACTS Food ShelterVolunteer at ACTS Food Shelter
Sandra VargasSandra Vargas
Wellness Coordinator at ACTS Retirement-Life CommunityWellness Coordinator at ACTS Retirement-Life Community
Ankit JaswalAnkit Jaswal
Sr. Client Support Specialist at Watermark InsightsSr. Client Support Specialist at Watermark Insights
MEENAKSHI KAUSHALMEENAKSHI KAUSHAL
Pharmacist at SHRI SAI MULTISPECIALITY HOSPITAL AND TRUMA CENTREPharmacist at SHRI SAI MULTISPECIALITY HOSPITAL AND TRUMA CENTRE