Portfolio - Vikas Ram

About Me

I am a passionate and self-driven Data Analyst with expertise in SQL, Power BI, Excel, and Python. Over the past year, I have learn and pratice my skills by completing multiple projects, including analyzing sales data, building interactive dashboards, and conducting detailed financial and performance analyses. My journey into data analytics began with my experience as a Medical Representative, where I leveraged Excel to track and improve sales performance, achieving a 25% increase in secondary sales.

Beyond technical skills, I bring strong problem-solving abilities, persistence, and a keen eye for detail to my work. My portfolio showcases diverse projects, from pharmaceutical sales analytics to government scheme dashboards, demonstrating my adaptability and ability to derive actionable insights from data.

I aspire to transition into a full-time Data Analyst role where I can contribute to data-driven decision-making and continue learning.

Key Skills

SQL

POWER BI

Advance Excel

Data Visualization

ETL(Extract,Transform,Load)

Problem- Solving

Strong Communication Skills

Report Building and Presenation

My Experience

Thank you for pointing that out! I will now revise the experience section based on what I know about your actual experience and skills:

Medical Representative – JB Chemicals, Mumbai
March 2021 – Present

Used Excel to track sales data, including doctor visits, prescription trends, and sales performance, leading to a 25% increase in secondary sales by identifying growth opportunities.
Maintained a database of doctors, chemists, and product prescriptions, enabling better tracking of sales patterns and targeted marketing efforts.
Automated repetitive data entry and reporting tasks using Power Query in Excel, which improved reporting accuracy and saved significant time.
Created insightful reports on customer performance and prescription trends to assist management in making data-driven decisions.
Learned and applied Power BI to develop simple dashboards showcasing key metrics like sales growth, prescription trends, and doctor engagement.
Developed a structured approach to tracking financial data such as revenue, sales margins, and product costs, helping to identify areas for improvement.
Collaborated with team members and managers to analyze sales trends and set achievable targets, ensuring alignment with overall company goals.
Continuously improved data handling and analysis skills by working on SQL queries and learning to visualize data effectively in dashboards.

Vikas Ram

Hello, I am

Vikas Ram.

1

2

1

About Me

Key Skills

My Projects

Atliq Hardware Sales Analysis Using Excel

Diabetes Analysis Dashboard Using Power BI

Pizza Sales Analytics: Using SQL to Boost Business Performance

Sales and Profit Analysis for Global Superstore Using Power BI

My Experience

Awards & Certificate

Let's Connect