Analyst

PRATEEK TIWARI

+91-983**-***** *****************@*****.*** LinkedIn GitHub

PROFILE

Analytically-minded engineering student (IIT Bhubaneswar) with hands-on experience turning raw data into business insight using SQL, Python, Excel, and Tableau. Comfortable across the analytics workflow — data cleaning, root-cause analysis, dashboarding, and stakeholder- ready reporting — with a track record of quantifying impact in prior internships and independent projects, and a growing interest in how data drives decisions in AdTech and digital advertising. Seeking an Analyst Intern role to apply strong problem-solving and data storytelling skills to real business decisions.

EDUCATION

Indian Institute of Technology Bhubaneswar Nov 2021 – May 2025 B.Tech, Electronics and Communication Engineering CGPA: 6.91 CORE ANALYTICAL SKILLS

Data & Analytics: SQL, Python, Excel, Tableau, Power BI, MATLAB, Exploratory Data Analysis (EDA), Root Cause Analysis (RCA), Firebase

Programming: C/C++, JavaScript, React

Tools: GitHub, Jira, Trello, Notion, N8N Automations Soft Skills: Stakeholder Communication, Problem-Solving, Product Management, Team Collaboration, Adaptability PROJECTS

Shopping Analytics Project (Excel, SQL, Tableau, EDA) GitHub: Online-Shopping-Analytics-Project

• Conducted end-to-end Root Cause Analysis (RCA) on customer behavior, product trends, and regional sales data to inform business strategy recommendations.

• Designed a relational database in SQL Server and built interactive Tableau dashboards to surface key sales and customer insights for stakeholders.

• Identified that office items drove 37% of total sales, with Chicago and California leading in apparel spend — findings used to prioritize regional inventory decisions.

FocusBoard Extension (Chrome Extension, React, Tailwind, Manifest V3) GitHub: FocusBoard

• Built a Chrome Extension combining an Eisenhower Matrix and Pomodoro timer, improving time-management efficiency by 45% and task efficiency by 40%.

• Implemented persistent drag-and-drop task tracking using chrome.storage.local with a clean, Apple-inspired adaptive UI. Teco Customer Churn Analysis (Python, Jupyter Notebook, EDA, Data Visualization)GitHub: Teco-Churn-Analysis

• Performed exploratory data analysis on telecom customer data to identify key churn drivers across contract type, payment method, tenure, and demographics.

• Found month-to-month contracts churned at 42% vs. 3% for two-year contracts, and electronic-check users churned at 45% — the highest of any payment method.

• Built a churn dashboard and translated findings into retention recommendations, including targeted engagement for customers in their first year of tenure.

WORK EXPERIENCE

Web Developer Intern Unified Mentor Jun 2024 – Jul 2024

• Built a dynamic blog platform in React and shipped advanced posting and commenting features, lifting user engagement and content creation by 30%.

• Improved content search performance by 40% through data-driven optimization, ensuring a consistent experience across mobile and desktop.

Project Development Intern Afame Technologies May 2024 – Jun 2024

• Redesigned site navigation and visual layout with intuitive HTML5 & CSS3 design, improving usability and user engagement.

• Integrated a blog and customer review system in JavaScript, contributing to a 25% lift in site credibility metrics. ACHIEVEMENTS & ACTIVITIES

• Qualified GATE 2025 in both Computer Science (CS) and Electronics & Communication (ECE); cleared JEE Main and Advanced.

• Achieved All India Rank 840 in NCAT 2024, a national-level aptitude and reasoning exam.

• Member — DevSquad (Web Dev Club) & UXsphere (UI/UX Club); Sports Coordinator & Vice-Captain, Carrom (Silver Medal, General Championship).

Contact this candidate