Open to opportunities

Pranav Soni

@pranavsoni

Message

Aspiring data analyst passionate about transforming data into insights.

India

Message

What I'm looking for

I am looking for a role that fosters growth, encourages innovation, and values data-driven decision-making.

I am an aspiring Data Analyst with a strong foundation in data analysis and visualization. My journey began at JSS Academy of Technical Education, where I pursued a Bachelor of Technology in Information Technology. I have developed a keen interest in turning raw data into clear stories, whether it’s uncovering spending habits through credit card analysis or optimizing revenue streams via sales-trend deep dives.

My technical skills include proficiency in SQL and Python, which I leverage to solve real-world problems and assist teams in making informed decisions. I have successfully developed dynamic Power BI dashboards that analyze millions of transactions, providing actionable insights for stakeholders. My projects, such as the Credit Card Customer Analysis and Music Database Analysis, showcase my ability to handle complex datasets and derive meaningful conclusions that drive strategic decisions.

Experience

Work history, roles, and key accomplishments

Music Database Analysis

JSS Academy of Technical Education

Executed 10+ complex SQL queries to identify top-spending customers resulting in targeted marketing. Optimized database queries to rank 100+ rock bands enhancing promotional efforts and artist engagement.

SQL Database Management Data Optimization Marketing Strategy Data Analysis

Credit Card Customer Analysis

JSS Academy of Technical Education

Developed dynamic Power BI dashboards to analyze 45M+ transactions and 588M+ income data, uncovering revenue trends across customer segments and card usage patterns. Visualized customer demographics including age, education, job type, and marital status to identify top-performing revenue segments and optimize acquisition strategies.

Power BI Data Analysis Customer Segmentation Data Visualization Strategic Planning

Sales Analysis

JSS Academy of Technical Education

Performed data cleaning and preprocessing on 12 months of raw sales data using Python, including handling null values and correcting data types. Merged multiple CSV files into a single consolidated DataFrame to enable complete annual sales analysis using os and pandas.

Python Data Cleaning data preprocessing Pandas Matplotlib

Education

Degrees, certifications, and relevant coursework

JSS Academy of Technical Education Noida

Bachelor of Technology, Information Technology

2021 - 2025

Activities and societies: Relevant Coursework: Data Structures, Statistics, Database Management Systems, Python Programming, Machine Learning

Studied Information Technology, focusing on core concepts such as Data Structures, Statistics, and Database Management Systems. Gained practical experience in Python Programming and Machine Learning.