Portfolio - Gopi krishna P

Gopi krishna P

Data Aspirant

Resume

2

Excel Projects

2

PowerBI Projects

1

SQL Project

About Me

I'm an aspiring Data Analyst who loves turning data into useful insights with tools like Excel, Power BI, SQL, and Python. My background is in the pharmaceutical industry, but I’ve found my true passion in data analysis.

Although I haven't worked in a data analyst role yet, I've completed several real-world projects that you can check out in my portfolio. These projects show how I can analyze data, find trends, and help make better decisions.

What makes me a good fit for your team? I'm curious, always eager to learn, and great at solving problems. I enjoy finding ways to improve processes and share insights that can make a difference. I’m excited to bring my skills and passion to a company where I can contribute and grow. Let's connect!

Key Skills

Python

Power Query

DAX

Data cleaning

Machine learning

Advanced Excel

SQL

Power BI

ETL

Data Visualisation

Data Transformation

Data modelling

Problem solving

communication skills

Presenatation skills

Attention to detail

My Projects

Business Insights 360

Domain/Function: FMCG

Electric Vehicles - Market Research Analysis

Domain/Function: Automotive

Consumer Goods AD - HOC Insights

Domain/Function: Consumer Goods

Sales and Finanacial Analysis of AtliQ Motors

Domain/Function: Consumer Goods

Call Center Analysis

Domain/Function: Telecommunications

My Experience

Analytical Scientist, TCG Life Sciences, Kolkata

May 2022 – Present

Analyzed and interpreted chemical data using various instruments, ensuring accuracy in product development processes. Leveraged advanced Excel skills for data analysis, producing detailed reports that improved operational efficiency. Collaborated with cross-functional teams to maintain data integrity and ensure adherence to quality standards.

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Artificial Intelligence and Machine learning

Postgraduate Programme in AIML

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/pampana-gopikrishna12

Call Me

+91 7032083989

GitHub

https://github.com/Yogananda-GopiKrishna

PowerBI Project

Business Insights 360

Domain/Function: FMCG

Developed Power BI dashboards for AtliQ Hardware to replace inefficient Excel analysis, providing executive and financial insights. Enhanced decision-making and operational efficiency by integrating data from various sources and improving forecasting accuracy.

View Project
Engagement

View Project
on GitHUB

Detailed financial metrics like net sales and gross margin for tracking revenue, profitability, and cost efficiency.

High-level KPIs across all departments for strategic decision-making and real-time insights.

Project Details

Problem Statement: AtliQ Hardware, a leading global manufacturer of computer hardware, faced significant losses in Latin America due to limitations in their Excel-based data analysis. To address these inefficiencies and improve business insights, they decided to invest in a comprehensive Power BI dashboard project.

Task: Developed a suite of Power BI dashboards to enhance data analysis across Finance, Sales, Marketing, and Supply Chain. This project aimed to replace Excel's limitations with dynamic, actionable insights, enabling better decision-making and addressing previous losses.

Strategic Impact: Implemented a robust data model using a Snowflake schema and integrated diverse data sources, including MySQL databases and Excel tables. The new dashboards provided real-time insights and actionable analytics, improving forecasting accuracy, operational efficiency, and strategic decision-making.

Project video

Live Interactive Dashboard

PowerBI Project

Electric Vehicles - Market Research Analysis

Domain/Function: Automotive

Designed Power BI dashboards to analyze the electric vehicle market in India as part of a comprehensive market research study for AtliQ Motors’ expansion strategy.

View Project
Engagement

View Project
on GitHUB

Analyzed EV sales trends across India to identify key growth periods and top revenue-generating states for AtliQ Motors' expansion.

Compared two states on EV adoption, infrastructure, and revenue to identify the best growth opportunity for AtliQ Motors.

Project Details

Problem Statement: AtliQ Motors, a leading player in the US EV market with a 25% share, aimed to enter India, where their presence was minimal. They needed an in-depth market analysis to identify key growth areas and refine their expansion strategy.

Task: Spearheaded a comprehensive market study to uncover valuable insights for AtliQ Motors' entry into the Indian EV market. Focused on analyzing sales trends, infrastructure, and competitive dynamics to craft actionable recommendations.

Strategic Impact: Delivered crucial insights that pinpointed the top 3 states with the highest growth potential. Optimized market entry strategy by targeting regions representing 60% of the potential market, enhancing the chances for a successful launch.

Project video

Live Interactive Dashboard

SQL Project

Consumer Goods AD - HOC Insights

Domain/Function: Consumer Goods

Conducted a SQL challenge for Atliq Hardwares to generate insights from 10 ad-hoc queries, showcasing technical skills and the ability to communicate findings effectively. Delivered actionable insights for executive decision-making.

View Project
Engagement

View Project
on GitHUB

Shows monthly gross sales for "Atliq Exclusive," highlighting March as the lowest and November as the highest. Total sales surged from $70.5M in 2020

Highlights products with highest ($240.54) and lowest ($0.89) manufacturing costs, aiding cost efficiency and pricing strategy evaluations.

Project Details

Problem Statement: Atliq Hardwares, a major player in computer hardware production, lacked data-driven insights for quick executive decision-making. To enhance their data analytics capabilities, the company initiated a SQL challenge to assess candidates for its growing analytics team.

Task: I completed a SQL challenge consisting of 10 ad-hoc requests, using SQL queries to generate insights for executive management. This project aimed to evaluate both technical proficiency and the ability to present findings effectively.

Strategic Impact: The insights derived from the SQL challenge helped Atliq Hardwares' executive team make informed, data-driven decisions, supporting their growth strategy and improving operational efficiency.

Project video

Excel Project

Sales and Finanacial Analysis of AtliQ Motors

Domain/Function: Consumer Goods

This project focuses on creating detailed Sales and Profit & Loss (P&L) reports. The Sales Report analyzes customer performance and compares market results with sales targets, while the P&L Report evaluates financial performance by fiscal year and market to support strategic decision-making.

View Project
on GitHUB

A report analyzing customer performance, sales patterns, and market comparison to drive growth.

A report analyzing Profit & Loss by market to evaluate financial performance and support decision-making.

Project Details

Problem Statement/Context:
Businesses struggle to analyze sales patterns, track customer performance, and assess financial outcomes across different markets and time periods. This lack of insight hinders effective planning, budgeting, and decision-making, limiting growth opportunities and strategic alignment.

Task:

Create a Customer Performance Report to track sales, compare market performance against targets, and offer actionable insights for optimizing customer relations and market expansion.
Develop Profit & Loss (P&L) Reports by fiscal year, month, and market to evaluate financial performance, support decision-making, and aid in stakeholder communication.
Strategic Impact:
These reports will enhance sales strategies, optimize customer interactions, improve financial planning, and align business operations with long-term goals, providing timely, data-driven insights for business growth and sustainability.

Excel Project

Call Center Analysis

Domain/Function: Telecommunications

This project for YGK Calling Services uses Excel to create an interactive dashboard analyzing 2023-2024 call center data. It helps management make data-driven decisions, improve efficiency, and enhance customer satisfaction by providing key operational insights.

View Project
Engagement

View Project
on GitHUB

Excel dashboard

Key variables

Project Details

Problem Statement : Despite having extensive data on customer interactions, call handling times, and agent performance, YGK Calling Services had not fully utilized this data to extract meaningful insights. As a result, they faced challenges in Analyzing trends in call volume and handling times.

Goal: Build an interactive Excel dashboard to systematically analyze data and provide key insights into operations, call performance, and customer satisfaction metrics.

Task: The project leverages Excel to build an interactive dashboard that analyzes call center data from 2023 and 2024 to help management make data-driven decisions, improve operational efficiency, and enhance customer satisfaction.

Strategic Impact : Improved Operational Efficiency: Management can now easily track call volumes, agent performance, and identify bottlenecks in real-time.