Turning Data Into Decisions That Drive Growth

Turning Data Into Decisions That Drive Growth

I’m Abhik Sarkar — a data & business analyst helping companies gain clarity through SQL, Python, and BI tools. I specialize in turning complex data into clear, actionable insights.

Experience

Experience

Data Analyst

Homedrop

Responsibilities:

Responsibilities:

Developed financial data models using SQL and Python, reducing transaction errors by 33%.

Developed financial data models using SQL and Python, reducing transaction errors by 33%.

Created Tableau dashboards for performance monitoring and price trends.

Created Tableau dashboards for performance monitoring and price trends.

Collaborated cross-functionally using Jira/Confluence; improved data accuracy and reporting by 25%.

Collaborated cross-functionally using Jira/Confluence; improved data accuracy and reporting by 25%.

Delivered stakeholder reports with actionable insights.

Delivered stakeholder reports with actionable insights.

Projects

Prediction of Company’s Revenue Growth Rate (Capstone)

For my capstone project, I developed a predictive model aimed at increasing revenue growth rate within the supply chain. By analyzing over 10,000 data points with Python and SAS, the model helped boost revenue growth by 15% while improving forecasting accuracy by 54.38%. This project showcased my ability to leverage data analytics to drive significant revenue gains and optimize supply chain performance..

Accuracy Gain

+54%

Revenue Impact

+15%

Prediction of Company’s Revenue Growth Rate (Capstone)

For my capstone project, I developed a predictive model aimed at increasing revenue growth rate within the supply chain. By analyzing over 10,000 data points with Python and SAS, the model helped boost revenue growth by 15% while improving forecasting accuracy by 54.38%. This project showcased my ability to leverage data analytics to drive significant revenue gains and optimize supply chain performance..

Accuracy Gain

+54%

Revenue Impact

+15%

Prediction of Company’s Revenue Growth Rate (Capstone)

For my capstone project, I developed a predictive model aimed at increasing revenue growth rate within the supply chain. By analyzing over 10,000 data points with Python and SAS, the model helped boost revenue growth by 15% while improving forecasting accuracy by 54.38%. This project showcased my ability to leverage data analytics to drive significant revenue gains and optimize supply chain performance..

Accuracy Gain

+54%

Revenue Impact

+15%

Prediction of bike purchases using SAS Enterprise Miner

Led a data analysis project using SAS Enterprise Miner for bike purchasing pattern analysis, unveiling a 3.261 times higher likelihood for 0–1-mile commuters compared to 5-10 miles. Found patterns such as a 43% drop in bike sales among married people and a 2.967 times higher likelihood for car-less people. Demonstrated adept data-driven decision-making skills, providing key strategic insights for the bicycle industry.

Precision Score

89%

Key Segments

3


Prediction of bike purchases using SAS Enterprise Miner

Led a data analysis project using SAS Enterprise Miner for bike purchasing pattern analysis, unveiling a 3.261 times higher likelihood for 0–1-mile commuters compared to 5-10 miles. Found patterns such as a 43% drop in bike sales among married people and a 2.967 times higher likelihood for car-less people. Demonstrated adept data-driven decision-making skills, providing key strategic insights for the bicycle industry.

Precision Score

89%

Key Segments

3

Prediction of bike purchases using SAS Enterprise Miner

Led a data analysis project using SAS Enterprise Miner for bike purchasing pattern analysis, unveiling a 3.261 times higher likelihood for 0–1-mile commuters compared to 5-10 miles. Found patterns such as a 43% drop in bike sales among married people and a 2.967 times higher likelihood for car-less people. Demonstrated adept data-driven decision-making skills, providing key strategic insights for the bicycle industry.

Precision Score

89%

Key Segments

3


Visualization project using Tableau

Crafted compelling visualizations with Tableau to compare property prices across Seattle neighborhoods, factoring in home types, bed/bath counts, and historical trends. Explored correlations like list prices versus location, offering valuable insights into market dynamics. Demonstrated expertise in data representation for a thorough analysis of the real estate landscape.

Data Points

3.5K+

Efficiency Boost

+18%

Visualization project using Tableau

Crafted compelling visualizations with Tableau to compare property prices across Seattle neighborhoods, factoring in home types, bed/bath counts, and historical trends. Explored correlations like list prices versus location, offering valuable insights into market dynamics. Demonstrated expertise in data representation for a thorough analysis of the real estate landscape.

Data Points

3.5K+

Efficiency Boost

+18%

Visualization project using Tableau

Crafted compelling visualizations with Tableau to compare property prices across Seattle neighborhoods, factoring in home types, bed/bath counts, and historical trends. Explored correlations like list prices versus location, offering valuable insights into market dynamics. Demonstrated expertise in data representation for a thorough analysis of the real estate landscape.

Data Points

3.5K+

Efficiency Boost

+18%

Electric Scooter Sales Analysis Findings Using SQL

Conducted a concise SQL-based sales analysis for the Bat, Bat Limited, and 2013 Lemon scooters, uncovering a 20% pre-order drop for the Bat. Growth fell below 10% on December 6, 2016 (57 days) for Bat, April 29, 2017 (73 days) for Bat Limited, and July 1, 2013 (61 days) for Lemon. The Bat Limited showed stronger sales retention, while Bat and Lemon trends suggest market saturation

Sales Drop Found

-20%

Time Saved

-35%

Electric Scooter Sales Analysis Findings Using SQL

Conducted a concise SQL-based sales analysis for the Bat, Bat Limited, and 2013 Lemon scooters, uncovering a 20% pre-order drop for the Bat. Growth fell below 10% on December 6, 2016 (57 days) for Bat, April 29, 2017 (73 days) for Bat Limited, and July 1, 2013 (61 days) for Lemon. The Bat Limited showed stronger sales retention, while Bat and Lemon trends suggest market saturation

Sales Drop Found

-20%

Time Saved

-35%

Electric Scooter Sales Analysis Findings Using SQL

Conducted a concise SQL-based sales analysis for the Bat, Bat Limited, and 2013 Lemon scooters, uncovering a 20% pre-order drop for the Bat. Growth fell below 10% on December 6, 2016 (57 days) for Bat, April 29, 2017 (73 days) for Bat Limited, and July 1, 2013 (61 days) for Lemon. The Bat Limited showed stronger sales retention, while Bat and Lemon trends suggest market saturation

Sales Drop Found

-20%

Time Saved

-35%

Skills

Python

SQL

Tableau

Microsoft Excel

SAS

ETL Processes

Power BI

Data Modeling

Market Research

JIRA

Confluence

EDA

Statistical Analysis

Mentoring

Adaptability

Critical Thinking

Leadership

Project Management

Agile Methodologies

Passionate about building

data systems

data systems

data systems

data systems

data systems

with over

2 years

2 years

2 years

2 years

2 years

of industry exeperience.

I thrive in

collaborative teams

collaborative teams

collaborative teams

collaborative teams

collaborative teams

where insights drive strategy.

Known for staying

calm

calm

calm

calm

calm

asking the right questions,

and always delivering with

precision

precision

precision

precision

precision

and

purpose

purpose

purpose

purpose

purpose

Passionate about building

data systems

data systems

data systems

data systems

data systems

with over

2 years

2 years

2 years

2 years

2 years

of industry exeperience.

I thrive in

collaborative teams

collaborative teams

collaborative teams

collaborative teams

collaborative teams

where insights drive strategy.

Known for staying

calm

calm

calm

calm

calm

asking the right questions,

and always delivering with

precision

precision

precision

precision

precision

and

purpose

purpose

purpose

purpose

purpose

Passionate about building

data systems

data systems

data systems

data systems

data systems

with over

2 years

2 years

2 years

2 years

2 years

of industry exeperience.

I thrive in

collaborative teams

collaborative teams

collaborative teams

collaborative teams

collaborative teams

where insights drive strategy.

Known for staying

calm

calm

calm

calm

calm

asking the right questions,

and always delivering with

precision

precision

precision

precision

precision

and

purpose

purpose

purpose

purpose

purpose

"Abhik consistently turned complex data into actionable insights. His dashboards and process improvements made a real impact on our day-to-day operations. A reliable and sharp analyst."
- Karan Agarwal

"Abhik has a great mix of analytical skills and business sense. He’s always learning, always improving, and great to collaborate with."
- Nimish Abraham

"Working with Abhik was seamless—he’s organized, technically strong, and always brings smart solutions to the table. Our project was a success because of his leadership and attention to detail."
- Alester D'Costa

"Abhik consistently turned complex data into actionable insights. His dashboards and process improvements made a real impact on our day-to-day operations. A reliable and sharp analyst."
- Karan Agarwal

"Abhik has a great mix of analytical skills and business sense. He’s always learning, always improving, and great to collaborate with."
- Nimish Abraham

"Working with Abhik was seamless—he’s organized, technically strong, and always brings smart solutions to the table. Our project was a success because of his leadership and attention to detail."
- Alester D'Costa

"Abhik consistently turned complex data into actionable insights. His dashboards and process improvements made a real impact on our day-to-day operations. A reliable and sharp analyst."
- Karan Agarwal

"Abhik has a great mix of analytical skills and business sense. He’s always learning, always improving, and great to collaborate with."
- Nimish Abraham

"Working with Abhik was seamless—he’s organized, technically strong, and always brings smart solutions to the table. Our project was a success because of his leadership and attention to detail."
- Alester D'Costa

JP Morgan CADP Virtual Experience

JP Morgan CADP Virtual Experience

JP Morgan CADP Virtual Experience

May 2024

May 2024


SAS - Centennial College Academic Specialization in Business Analytics and Insights


SAS - Centennial College Academic Specialization in Business Analytics and Insights


SAS - Centennial College Academic Specialization in Business Analytics and Insights

March 2024

March 2024


Google Analytics Certification


Google Analytics Certification


Google Analytics Certification

February 2024

February 2024

Business Analysis for Project Managers

Business Analysis for Project Managers

Business Analysis for Project Managers

January 2024

January 2024

Certifications

Frequently asked questions

What roles are you currently looking for?

Can you work in Canada?

What’s your strongest skill?

Can you work in Agile teams?

What roles are you currently looking for?

Can you work in Canada?

What’s your strongest skill?

Can you work in Agile teams?

What roles are you currently looking for?

Can you work in Canada?

What’s your strongest skill?

Can you work in Agile teams?

STATEMENT OF AUTHENTICITY

I confirm that all of the material and content provided in this portfolio are examples of my own work, knowledge, and skills. Please do not copy or distribute any material without my express consent.

Abhik Sarkar - Business & Data Analyst

STATEMENT OF AUTHENTICITY

I confirm that all of the material and content provided in this portfolio are examples of my own work, knowledge, and skills. Please do not copy or distribute any material without my express consent.

Abhik Sarkar - Business & Data Analyst