Travelling
Siddhaant Pahuja
New Delhi
Summary
Business Data Analyst with expertise in data mapping, user acceptance testing, and solving complex problems in dynamic, high-pressure environments. Possess strong analytical skills to uncover trends in large datasets and draw actionable conclusions from findings. Skilled in leveraging data-driven insights to support decision-making and drive business outcomes. Adept at managing and cultivating client relationships to foster long-term engagements and identify new business opportunities.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Data Analyst Intern
Source Code Control Pvt Ltd.
New Delhi
03.2023 - Current
Power Automate
- Utilized Power Automate to streamline the generation of daily, weekly, and monthly project tracking reports, providing key insights into company performance. These reports highlighted metrics such as projects completed vs. forecasted, projects on hold, in progress, and other critical project data, enabling improved decision-making and project management efficiency.
- Developed a tool that automatically collects and analyzes customer survey responses in real-time, delivering dynamic insights such as areas for improvement, strengths, personalized recommendations using the strength of AI, and scores for each section, along with an overall score. The tool generates a comprehensive report in Word format, ready for review and distribution to clients.
PowerBI (Visualization)
- Designed automated reports that track productivity KPIs for multiple departments and regions within the organization, enabling stakeholders to monitor key business metrics in real-time.
Python
- Identified and resolved data quality issues, resulting in a 25% reduction in data errors and improved accuracy of reporting.
- Streamlined data collection processes by leveraging APIs and automation tools, reducing data acquisition time by 30%, and improving data accuracy.
- Reduced the report generation time by 60% and manual work by 80%, through developing a Python script to automate the generation of Excel reports for evaluating issues and errors in a database using the DMA (Data Migration Assessment) tool.
Operations Intern
Nykaa E-Retail Pvt Ltd.
New Delhi
09.2022 - Current
- Responsible for managing the data entry and inventory mapping.
- Conducted extensive research on industry trends by analyzing multiple retail websites, assessing product offerings, and evaluating filter criteria. Identified potential features and improvements to enhance our platform's product selection and user experience, contributing to strategic platform development.
- Proposed process automation to reduce the annual work done by team.
- Auditing size charts for various brands and product types.
- Responsible for connecting with brand executives and correcting errors in the size chart.
Education
B. Tech - Artificial Intelligence And Data Science
Vivekananda Institute of Professional Studies
New Delhi01-2025
High School Diploma -
Nirmal Bhartia School
New Delhi01-2021
Skills
- Decision Making
- Strategy Formation
- Time Management
- Teamwork
- Business Analysis
- Automation
- Data Management
- Data Analysis
- Microsoft Excel
- Python
- HTML/CSS
- JavaScript
- ReactJs
- Microsoft PowerBI
Certification
IBM Data Analyst Professional Certificate
- Completed a comprehensive 9-course program covering key topics in Data Analytics. Gained hands-on experience with tools such as Excel, SQL, Relational Databases, Python, and Cognos Analytics. Developed practical skills in data manipulation, analysis, and visualization, creating interactive dashboards and reports from real-world datasets. Demonstrated proficiency in applying analytical techniques and presenting data insights.
Projects
Data Processing tool(Pandas, Python)
- The Data Cleaning and Preprocess Tool is a Python-based application that allows users to clean and preprocess data stored in an Excel file. It provides a user-friendly graphical interface to load the input Excel file, apply various data cleaning operations, and generate a processed Excel file as the output.
- Excel File Input and Output: Users can easily load their Excel file into the application for data processing.
- Interactive GUI: The graphical user interface (GUI) using Tkinter offers a seamless experience with interactive elements for easy data manipulation.
Unscramble game website(ReactJS,NodeJS)
- Unscramble is an interactive educational game designed for kids, where users unscramble jumbled sentences to win! This game aims to provide fun learning experiences by enhancing problem-solving skills, cognitive abilities, communication and concentration.
- Engaging Gameplay: Unscramble jumbled sentences by dragging and dropping the words in the correct order.
- Multiple Difficulty Levels: Choose from easy, medium, or hard modes for a customized challenge.
- Progress Tracking: Keep track of your move count, win count, and overall score.
Interests
Cooking
Networking
Weight-Lifting
Running
Timeline
Data Analyst Intern
Source Code Control Pvt Ltd.
03.2023 - Current
Operations Intern
Nykaa E-Retail Pvt Ltd.
09.2022 - Current
IBM Data Analyst Professional Certificate
- Completed a comprehensive 9-course program covering key topics in Data Analytics. Gained hands-on experience with tools such as Excel, SQL, Relational Databases, Python, and Cognos Analytics. Developed practical skills in data manipulation, analysis, and visualization, creating interactive dashboards and reports from real-world datasets. Demonstrated proficiency in applying analytical techniques and presenting data insights.
B. Tech - Artificial Intelligence And Data Science
Vivekananda Institute of Professional Studies
High School Diploma -
Nirmal Bhartia School
Similar Profiles
Abraham AkpanAbraham Akpan
SOFWARE ENGINEER at Code-collabo - Open Source (NextJS, NodeJs)SOFWARE ENGINEER at Code-collabo - Open Source (NextJS, NodeJs)
Anisah MohammedAnisah Mohammed
Keyboarding Clerk II at Code Enforcement-Rent ControlKeyboarding Clerk II at Code Enforcement-Rent Control
Hiteshi ChawkeHiteshi Chawke
QA Manual Tester at Code Micro Systems Pvt LtdQA Manual Tester at Code Micro Systems Pvt Ltd