Sourav Pattanayak

Business Analyst

[email protected] +91 8240329368

Resume

Hello, I am

Sourav Pattanayak.

1

Excel
Project

2

PowerBI
Projects

1

SQL
Project

2

Python
Projects

About Me

Welcome to my data-driven universe!

As an Operations Analyst @ PharmSight Research & Analytics, I transform raw data into actionable insights using Excel, Power BI, SQL, Python, machine learning, and predictive modeling.

With a background in Applied Chemistry with Mathematics, I’ve gained experience as a Business Analyst @ LawSikho and Data Analyst Intern @ Heart it Out, applying my skills in data analysis, visualization, predictive modeling, and automation to HR analytics, financial forecasting, and FMCG projects.

This portfolio highlights my expertise in building dashboards, developing predictive models, and uncovering insights that drive strategic decisions. Explore how I turn data into stories and solutions—let's embark on this journey together!

Key Skills

DAX

SQL

Python

Pandas

Machine Learning

Attention to detail

My Projects

FMCG-Sales & Finance Report

Consumer Goods-Ad hoc Insights

Financial Forecasting & Revenue Analysis

HR Analytics & A Comparative Algorithm Study.

Analyzing the Growth of Telangana State

Data Analytics in Hospitality Domain

My Experience

Operations Analyst | PharmSight Research & Analytics Jan 2025- Present

● Responsibilities & Achievements: Loading... Stay tuned for updates as I embark on this exciting journey!

Consultant Business Analyst | LawSikho & Skill Arbitrage Oct 2024- Jan 2025

Responsibilities & Achievements:

● Utilized SQL and Power BI to uncover and analyze data, enabled the extraction of business insights,and tracked KPIs on transaction completion rates. Achieved a 15% improvement in transaction efficiency through data-driven strategies.

● Work with stakeholders to design project roadmaps, collect client requests (CRs), and create detailed business process roadmaps,integrate business use cases for developers to increase project accuracy.

● Create thorough FRDs and PRDs, making sure that technical deliverables and business needs were in line, and enabling smooth team execution. ● Identify critical business gaps, optimize processes, and translate complex user stories into actionable business flows and foster data-driven decisions across different projects.

Data Analyst Intern | Heart it Out Feb 2024- Jun 2024

Responsibilities & Achievements:

● Analyzed over 15 tables to create the ‘First Responder-Client Details’report using Advanced PostgreSQL queries and tracked form fill-up trends over 6 months to identify top sectors driving engagement.

● Streamlined the ‘Corporate Wellbeing Programme’ dashboard in Google Looker Studio with advanced PostgreSQL queries, enhanced tracking and boosting efficiency by 25%, Developed automation scripts to monitor the daily ETL pipeline.

● Utilized Natural Language Processing (NLP) techniques on 'Client-System conversations', including tokenization, data cleaning, text formatting, and text classification, to process system-generated conversations for model training .

Awards & Certificate

Google Data Analytics Specialization

Microsoft-Extract,Transform and Load Data In PowerBI

Internship-Tata Consultancy Services-Data Visualization: Empowering Business with Effective Insights

Internship-Data Science & Business Analytics-The Sparks Foundation

HackerRank-Certificate of Completion(SQL Basic)

Internship-Power BI Job Simulation

HackerRank-Certificate of Completion(SQL Intermediate)

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.

Mail Me

[email protected]

https://www.linkedin.com/in/souravpattanayak96/

Call Me

+91 8240329368

GitHub

https://github.com/Sourav-Pattanayak

Excel Project

FMCG-Sales & Finance Report

This project focused on analyzing AtliQ Hardware's data using tools like Power Pivot and Pivot Tables. Here I have uncovered valuable insights into the company's sales performance and identified intriguing opportunities across all the business locations, and engaging customers.

View Project
Engagement

View Project
on GitHUB

Customer Performance Report: Presents the net sales performance of individual customers over multiple years.

Market Performance Report: This report facilitates stakeholders in assessing the market's annual performance and comparing it to established target.

Project Details

In this project, I crafted a comprehensive sales analysis utilizing Excel pivot tables. This tool equips businesses to decipher effective customer discounts, negotiate with consumers, and pinpoint expansion prospects in promising countries. The generated reports offer actionable insights, enabling businesses to optimize sales strategies, boost customer satisfaction, and maximize revenue.

Key Learnings:

1. Advanced Pivot Tables
2. Power Query Techniques
3. Intermediate DAX Functions
4. Conditional Formatting Mastery
5. Report Aesthetics Enhancement
6. Deeper Understanding of Sales Metrics

This project is designed to provide businesses with the essential resources to monitor, assess, and elevate their sales endeavors. Through meticulous sales data analysis, companies can unearth untapped opportunities, foster growth, and remain competitive in today's dynamic market environment.

SQL Project

Consumer Goods-Ad hoc Insights

In this project, I used advanced SQL techniques to analyze data for Atliq Hardwares, providing quick, data-driven insights for top management. Presented findings in a visually engaging PowerPoint with charts and graphs.

View Project
Engagement

View Project
on GitHUB

Identified top 5 customers in Indian Market with average pre-invoice discount in Fiscal Year-2021

Quarterly Sales Figure in Fiscal Year 2020

Project Details

Throughout the project, I analyzed and answered ad-hoc requests for Atliq Hardwares using advanced SQL clauses such as Joins, Subqueries, CTEs,Window functions,Unions and Datetime Extractions, enhancing our ability to provide quick, data-driven decisions for top-level management. The insights covered diverse aspects, from market presence and sales growth to product portfolio expansion, all meticulously presented in a visually engaging PowerPoint, spotlighting key findings with charts and graphs for clarity and impact.

PowerBI Project

Financial Forecasting & Revenue Analysis

In this project, I brought data analytics to AtliQ Hardware using Power BI. I used tools like SQL, Excel, and DAX to improve decision-making in finance, sales, marketing, and supply chain. Now, I'm creating dynamic dashboards for this growing tech company.

View Project
Engagement

View Project
on GitHUB

Business Insights-The HomeView

Business Insights- The Executive View

Project Details

In this project, AtliQ Hardware embarked on a data analytics journey with Power BI for a competitive edge. Guided by Codebasics, we mastered SQL, Power BI Desktop, and DAX language. Techniques included dynamic navigation, KPIs, and conditional formatting. Proficiency in finance, sales, marketing, and supply chain, alongside DAX functions, empowered data-driven decisions. Despite challenges in the American market, our analytics team strategically addressed setbacks. The project kick-off session and data exploration paved the way for insightful dashboard design, enhancing our market position.

Project video

Live Interactive Dashboard

Python Project

HR Analytics & A Comparative Algorithm Study.

In this project, we use Python and machine learning to understand employee performance. Analyzing age, gender, and department, Logistic Regression and Random Forest Classifier predict job success, aiding smarter hiring and management decisions.

View Project
Engagement

View Project
on GitHUB

Model Accuracy-Confusion Matrix using Logistic Regression Algorithm .

Visual Representation of Employee Promotions over the years.

Project Details

In this HR data analysis project, we leverage machine learning to inform decisions. HR manages personnel, assesses performance, and fosters growth, but extracting insights from vast data can be challenging. We aim to predict employee performance ratings by analyzing demographics, department, job role, and tenure. Python analysis supplements this, revealing trends and correlations. Comparative analysis of algorithms like Logistic Regression and Random Forest Classifier guides us in providing actionable insights for HR professionals, optimizing processes, and cultivating a thriving workforce.

PowerBI Project

Analyzing the Growth of Telangana State

This project evaluates Telangana's advancements across sectors. Utilizing SQL and Power BI, it equips officials with data-driven insights, aiding informed decision-making for state development.

View Project
Engagement

View Project
on GitHUB

This visual representation showcases Vehicle Type, Vehicle Sales, and Vehicle Distribution Analysis in Telangana State during 2019-2023.

Illustrates investment patterns and stamp revenues across districts, sectors, and fiscal years in the state.

Project Details

The project is all about using Microsoft Power BI and SQL for a detailed study on Telangana's growth. Here's the scoop: Stamp Registration saw a whopping 25% revenue jump, thanks to a surge in E-stamp income in rural areas. Transport-wise, Karimnagar had a 12% rise in vehicle sales, and Hyderabad doubled its numbers. The Ts-Ipass initiative got a hefty 99.13K investment, focusing on hot sectors like plastic and rubber, led by Rangareddy.

Live Interactive Dashboard

Python Project

Data Analytics in Hospitality Domain

Utilized Python along with libraries such as Pandas, Matplotlib, and Seaborn to leverage data insights, effectively tackling challenges and steering business growth at AtliQ Grands, a prominent hospitality company operating across four cities.

View Project
Engagement

View Project
on GitHUB

Visual Representation of Revenue Realized per Hotel Type.

Visual Representation of Revenue Realized per Booking Platform.

Project Details

In this project, I have conducted a strategic analysis for AtliQ Grands, an imaginary hospitality company operating in four cities. Leveraging Python and the Pandas library, alongside visualization tools like Seaborn and Matplotlib, the focus was on addressing market competition through a data-driven approach. In this project, I have meticulously cleaned and transformed data to ensure accuracy and facilitate insightful exploration. Key findings, including the high occupancy of Presidential rooms, the dominance of Delhi in occupancy rates, and revenue trends across cities, were uncovered. This analysis equips AtliQ Grands with valuable insights to overcome challenges and foster business growth in a competitive market.