Leap

Data Analyst

Rose International

Part of the Operations team. Project managing data labelling operations to train LLM models.

Aston Carter

Part of the New Business Verticals team using data tools like Python, SQL, Mode, AWS S3, Google Colab, Google Sheets, Excel (Power Query) & Snowflake to organize, clean and analyze data for a faster more efficient merchant and customer experience.

dentsu

Part of the Analytics & Measurement team using data tools like Tableau, SQL, Excel, & Google Sheets to report on global performance marketing campaigns across marketing channels like Facebook Ads, Google Ads, Twitter Analytics etc.

Akorbi

Part of the Operations team where I analyzed data and identified issues within software utilizing different internal data analytics and 3D visualization tools such as Xview, Carcraft and Webviz.

COOP

In partnership with Microsoft, Oath (Yahoo!), and Salesforce, a powerful 200-hour selective Data Analytics apprenticeship for first generation college grads to expand hard and soft skills in data.

Delta Analytics

Seattle Against Slavery now called 'The Lantern Project' aims to end sexual exploitation in our communities by changing culture through prevention, intervention, and transformation.

As a Consultant at The Lantern Project, I built Tableau Dashboards to analyze and visualize Microsoft's Freedom Signal Platform's product outreach, effectiveness and response rates using data queried from MongoDB and PostgreSQL.

Nielsen

●	Optimized strategy & growth by monitoring 10+ KPIs to measure success; reported 3 solutions to Sr managers
●	Supported Sr managers in implementing a new reporting platform by developing 2 analytics dashboards using Tableau
●	Tested the impact of a new solution on key metrics & measured potential value by analyzing data on G-Sheets

Coca-Cola CCI

●	Increased customer engagement for Coca-Cola through major product marketing initiatives e.g., ‘Reels-on-Wheels’ 
●	Optimized sales distribution by investigating sales data of 4800+ outlets on SQL & Excel (vlookup & pivot tables)
●	Increased marketing channel effectiveness by analyzing customer behavior & preferences data using Excel

FlatRock Associates

FlatRock is an early & growth stage private investment firm which is not backed by any LPs and that makes it easier to invest in & advise companies and funds.

●	Increased ROI for clients by ~0.5% by advising on investment strategies through 15+ data-driven Tableau reports
●	Reduced research time for investors by 14% through 30+ reports on global outlook by analyzing data in SQL/Excel
●	Trained 2 interns on report writing & global macroeconomic analyses to help executives focus on client relations

Email: alihaidersoni62@gmail.com

I’ve always seen data as a way to sharpen our understanding of the world, and each step in my career has proven that true. Early on, I learned how even a few thousand rows of numbers could uncover hidden efficiencies, reveal subtle market opportunities, and spur strategic growth. Back then, it was just me, a spreadsheet, and a determination to separate meaningful trends from the noise.

As I evolved, so did the scale and complexity of my work. I handled 50+ analytics requests weekly, managed teams to produce client-facing reports in record time, and turned month-long projects into single-week sprints. I streamlined processes, automated repetitive tasks, and cut through redundancies to save entire teams hours of manual effort. My mission? Make data easier to grasp and faster to act on.

I found that data can do more than measure outcomes—it can guide decisions. By collaborating with product, engineering, and marketing teams, I ensured everyone could use insights without needing a crash course in SQL or Python. It wasn’t just about the numbers; it was about telling a story that influenced everything from marketing spend to product improvements. I helped refine KPIs, elevate user experiences, and boost campaign performance—all by looking at the world through a data-driven lens.

At the heart of my work is a belief that data should empower people. I’ve mentored new analysts, showing them how to transform tables into tangible strategies. I’ve built dashboards that cut through complexity, turning thousands of metrics into intuitive visuals that leaders can act on. Over time, I’ve honed a simple yet powerful formula: combine technical skills with creative thinking and clear communication, and you’ll drive meaningful change.

If you need someone who can dive into complex datasets, orchestrate high-impact initiatives, and translate insights into compelling calls to action, I’m ready. Let’s talk about how I can help illuminate the path ahead—one dataset, one insight, one decision at a time. Feel free to send me a DM or an email, and let’s explore how data can become your strategic advantage.

Email: alihaidersoni62@gmail.com

Ali Haider Soni

In2IT Technologies

- As a Business Analyst, conducted research, analyzed business operations, and solved the business 
  problems
- Collaborating with cross-functional teams, including product managers,  and other 
   stakeholders, to gather requirements, analyze data, and define the product roadmap
- Preparing various functional specification documents, facilitating review of the same by development 
   team
- Created detailed user stories, workflows, and acceptance criteria to ensure clear communication of business needs to development teams.
- Currently working on a Dashboard Product for a client.

Business Analyst

Octaculus

- Supported seniors in gathering and documenting requirements for product development initiatives.
- Developed process flow diagrams and use case documentation, streamlining internal processes and 
   reducing redundancies.
- Analyzed data trends and user feedback, providing actionable insights that improved product usability 
   and customer satisfaction.
- Assisted in sprint planning and backlog grooming sessions, maintaining alignment with Agile principles.
- Analyzing data for generating marketing strategies

Associate Business Analyst

DataDice Technologies

- Collect, clean, and preprocess structured and unstructured datasets.
- Conduct exploratory data analysis (EDA) to uncover trends, patterns, and insights.
- Assist in building dashboards and visualizations using tools like Power BI.
- Collaborate with cross-functional teams to understand business requirements and translate them into 
    analytical solutions.
- Support the team in automating data workflows and creating reports.
- Document findings and prepare presentations for stakeholders.

Coaching Institute

- Provided one-on-one & group tutoring sessions in Social Studies(SST) & Mathematics, helping students improve their understanding & performance

-Assisted students in exam preparation, homework, & conceptual learning, leading to improved grades & confidence

- Focused on interactive learning methods, making subjects more engaging & easier to grasp

SST Tutor

• 𝐋𝐚𝐧𝐠𝐮𝐚𝐠𝐞𝐬: SQL
• 𝐃𝐚𝐭𝐚 𝐕𝐢𝐬𝐮𝐚𝐥𝐢𝐳𝐚𝐭𝐢𝐨𝐧: Power BI, Seaborn, Plotly
• 𝐅𝐫𝐚𝐦𝐞𝐰𝐨𝐫𝐤𝐬 & 𝐋𝐢𝐛𝐫𝐚𝐫𝐢𝐞𝐬: Streamlit, Pandas, NumPy, Matplotlib, Plotly, Scikit-learn.

Sachin Kumar

Most SQL beginners think DELETE, DROP, and TRUNCATE mean the same… until they break a production table.

1) DELETE:
is a Data Manipulation Language (DML) command used to remove records from a table.
It deletes specific rows based on conditions specified in WHERE clause.
DELETE does not alter the table structure; it only affects the data.
Use Case: Use DELETE when you want to selectively remove specific rows while keeping the table intact.


2) TRUNCATE:
is also a DDL command, but it focuses on removing data while preserving table structure.
It quickly removes all rows from the table without logging individual deletions.
Use Case: Use TRUNCATE when you want to clear out data efficiently without dropping the table.

3) DROP:
is a Data Definition Language (DDL) command that removes an entire table from the database.
It deletes both the table structure and all the data within it.
Irreversible: Once you DROP a table, it cannot be rolled back.
Use Case: Use DROP when you need to completely eliminate a table.


Day 68 : https://lnkd.in/gSUgzey9

#sql #database #dataanalyst #businessanalyst #productanalyst

𝐄𝐯𝐞𝐧𝐭 𝐥𝐨𝐠𝐬 𝐚𝐫𝐞 𝐧𝐨𝐢𝐬𝐲. 𝐒𝐐𝐋 𝐦𝐚𝐤𝐞𝐬 𝐭𝐡𝐞𝐦 𝐦𝐞𝐚𝐧𝐢𝐧𝐠𝐟𝐮𝐥. 𝐇𝐞𝐫𝐞’𝐬 𝐡𝐨𝐰 𝐲𝐨𝐮 𝐜𝐨𝐧𝐯𝐞𝐫𝐭 𝐥𝐨𝐠𝐬 → 𝐬𝐞𝐬𝐬𝐢𝐨𝐧𝐬 → 𝐰𝐨𝐫𝐤𝐢𝐧𝐠 𝐡𝐨𝐮𝐫𝐬

◾ Problem:
Employees may log in and out multiple times a day.
We must pair each login with its next logout, and then compute total working hours per day.

SQL Logic Explained (In Simple Words)

1️⃣ — Pair each login with its next logout
Using LEAD() window function, we fetch the upcoming event_time

2️⃣ — Filter only login rows
Because the logout time is only meaningful for login events.

3️⃣ — Calculate working hours
We subtract login_time from logout_time:
Converts seconds → hours
Handles multiple login-logout pairs in same day

4️⃣ — Summing total working hours per employee per day
This gives us a daily rolled-up summary.


This query is crucial for:
Payroll systems — exact payable hours
Timesheet automation — actual vs expected productivity
Workforce analytics — time-on-platform, shift performance


Day 70 of SQL: https://lnkd.in/gFQ6UgyB


#SQL #Dataanalyst #productanalyst #businessanalyst #sqlqueries

📕Day 72 of SQL Revision
New vs Repeat Customers — A Classic SQL Pattern Every Analyst Should Know

Understanding customer behavior over time is one of most common (& most important) problems in analytics.

One simple but powerful question businesses often ask is 👇
“On each day, how many customers are new and how many are repeat?”

SQL query:

Step 1: Find each customer’s first-ever order
Step 2: Get one order per customer per day --We care about daily active customers, not order volume.
Step 3: Classify customers as New or Repeat
Step 4: Daily aggregation (final output)



WITH first_order AS (
  SELECT
    cust_id,
    MIN(DATE(order_dt)) AS first_order_date
  FROM Input
  GROUP BY cust_id
),
daily_orders AS (
  SELECT DISTINCT
    cust_id,
    DATE(order_dt) AS order_date
  FROM Input
),
customer_status AS (
  SELECT
    d.cust_id,
    d.order_date,
    CASE
      WHEN d.order_date = f.first_order_date THEN 'New'
      ELSE 'Repeat'
    END AS status
  FROM daily_orders d
  JOIN first_order f
    ON d.cust_id = f.cust_id
)
SELECT
  order_date,
  COUNT(CASE WHEN status = 'New' THEN 1 END) AS new_customers,
  COUNT(CASE WHEN status = 'Repeat' THEN 1 END) AS repeat_customers
FROM customer_status
GROUP BY order_date
ORDER BY order_date;



Day 71 of SQL: https://lnkd.in/gj8SwrHk



#SQL #Database #SQLQueries #Dataanalyst #SQLQuery

𝐃𝐮𝐫𝐢𝐧𝐠 𝐣𝐨𝐛 𝐬𝐞𝐚𝐫𝐜𝐡, 𝐭𝐡𝐞𝐫𝐞 𝐚𝐫𝐞 𝐩𝐡𝐚𝐬𝐞𝐬 𝐰𝐡𝐞𝐧 𝐲𝐨𝐮 𝐚𝐩𝐩𝐥𝐲 𝐝𝐚𝐢𝐥𝐲, 𝐩𝐫𝐚𝐜𝐭𝐢𝐜𝐞 𝐝𝐚𝐢𝐥𝐲, 𝐮𝐩𝐬𝐤𝐢𝐥𝐥 𝐝𝐚𝐢𝐥𝐲… 𝐛𝐮𝐭 𝐬𝐭𝐢𝐥𝐥 𝐧𝐨 𝐜𝐚𝐥𝐥𝐛𝐚𝐜𝐤𝐬, 𝐧𝐨 𝐢𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰𝐬, 𝐧𝐨 𝐫𝐞𝐬𝐮𝐥𝐭𝐬.

It’s frustrating.
It makes you doubt yourself.
It makes you feel incompatible or not good enough.

But here’s the truth most people won’t tell you:

◾ This phase is normal.
- Almost everyone who made it through faced this exact silence.

Job search is not a straight line.
 It’s effort → waiting → rejection → learning → repeat.

Sometimes it’s not about talent.
Sometimes it’s timing.
Sometimes it’s just probability.

What is in your control?
1) Showing up every day
2) Improving one skill at a time
3) Writing better queries, cleaner logic, sharper explanations
4)  Staying consistent even when motivation drops

Hard work doesn’t always give instant results — but it always compounds.
If you keep learning, keep building, keep trying — the result WILL come.
Maybe not today.
Maybe not this week.
But it will come.


So don’t quit just because the journey feels quiet.
Quiet phases are where growth actually happens.
Give your 100% effort.
Future you will thank you for it.


#Jobsearch #Jobs #Dataanalystsjobs

Day 73 of SQL Revision Series

generate_series() is a set-returning function in PostgreSQL.
This means:
It does not return a single value
It returns multiple rows
Those rows behave like a temporary / virtual table

You can use it in:
SELECT
JOIN
WHERE
GROUP BY
Subqueries

Why is it called a “virtual table”?
Because:
You don’t create a table
You don’t store data
PostgreSQL generates rows on the fly
So it’s fast and very useful for analysis.

Syntax (Very Important):
generate_series(start, stop, step)


| `start`  | First value of the series  |
| `stop`  | Last value (inclusive)   |
| `step`  | Increment / Decrement value |

Analysts Use generate_series():
1. Create Data Without Tables (Practice SQL)
2. Finding Missing Dates in Data
3. Daily / Monthly Reports

generate_series() is used to create a sequence of rows (numbers or dates) without creating a physical table, mainly for analysis and reporting.


Day 72 of SQL: https://lnkd.in/gXZEUhay


#SQL #dataanalysts #sqlqueries #database

Sometimes, It's Not Just Hard Work — Luck Also Plays a Role (And That's Okay!)

We often hear:
“Success = Hard Work + Skills.”
But rarely do people talk about the 3rd variable that silently influences every 
interview:

Luck. Yes, luck matters too.
Let me explain this with a small data-story


📊 Imagine an Interview Like a Random Dataset

You prepare SQL, Python, Product Sense, Case Studies, Stats…
 But the interviewer pulls 3 random questions from a pool of 200+ topics.

Sometimes that sample is perfectly in your favor.
 You get questions that you’ve practiced 100 times.
 You feel confident. You solve everything.
 The interviewer smiles. You smile.
 Result: You get selected.

 Other times…
 The random sample goes against you.
 You get topics you barely touched.
 A trick question comes.
 Your brain freezes for a moment.
 Even though you know you're capable, that day doesn’t reflect it.
Result: Rejection.


But the truth is:
 Your skill didn’t change.
 Only the sample of questions changed.
 Just like randomness in a dataset.



So What Should You Learn From This:
✔ Hard work still matters the most
✔ Don’t judge yourself based on one interview
✔ Rejections don’t mean you’re not good



Day 67: https://lnkd.in/gyADUWw7


#Motivation #CareerMotivation #JobSearch #TechInterview #SuccessMindset #LearningEveryday

Expanding Rows Using CROSS JOIN LATERAL + generate_series()

◾ Why do we need LATERAL: Because the function depends on the column t.n.

LATERAL tells PostgreSQL:
Evaluate this function once per row from left-hand table, & allow it to reference that row’s values."
Without LATERAL, the query either errors out or behaves incorrectly


To repeat each number n times, I used CROSS JOIN LATERAL generate_series(1,n).

LATERAL lets the function access columns from the left table, making this the most efficient and idiomatic PostgreSQL pattern for row explosion.”



“To repeat each number n times, I used CROSS JOIN LATERAL generate_series(1,n). LATERAL lets the function access columns from the left table, making this the most efficient and idiomatic PostgreSQL pattern for row explosion.”


Query:
SELECT t.n AS number_output 
FROM numbers_table t 
CROSS JOIN LATERAL generate_series(1, t.n) AS gs(i) 
ORDER BY t.n, gs.i;


This pattern is used when you want to:
1) Expand one row into multiple rows
2) Generate sequences dynamically
3) Create repetitions
4) Simulate time windows
5) Do simulations (e.g., churn per day, cohort expansion)


Day 69 of SQL: https://lnkd.in/gpA8Efaq



#sql #database #dataanalyst #productanalyst #sqlqueries

This SQL problem looks simple, but it tests how well you understand ordered data, edge cases, and real product logic


Q)Problem Statement:
We have a seat allocation table.
Seats are in order, and we want to swap students sitting in adjacent seats.

Rules:
Seat 1 ↔ 2, 3 ↔ 4, 5 ↔ 6 …
If the last seat is odd, it remains unchanged.
Do NOT change seat numbers — only swap students.

Input:
| seat_id | student |
| 1    | A    |
| 2    | B    |
| 3    | C    |
| 4    | D    |
| 5    | E    |


Query
SELECT
 seat_id,
 CASE
  WHEN seat_id % 2 = 1 THEN
   COALESCE(LEAD(student) OVER (ORDER BY seat_id), student)
  ELSE
   LAG(student) OVER (ORDER BY seat_id)
 END AS student
FROM seats;


Explanation:
Why COALESCE() is Needed
COALESCE(LEAD(student), student)
If next student exists → take it
 Else → keep current student


Day 73 of SQL: https://lnkd.in/g3NyvFtR



#SQL #WindowFunctions #ProductAnalytics #ProductAnalyst #DataAnalytics DataLemur 🐵 (Ace the SQL & Data Interview) Nick Singh 📕🐒 StrataScratch Aditya Kalyan

taplio

The Battle

Ali Haider Soni

Sachin Kumar

Followers

Posts

Engagements

Likes

Performance ScoreSachin Kumar's LinkedIn Performance

Ready to grow your LinkedIn presence?

taplio

The Battle

Ali Haider Soni

Sachin Kumar

Followers

Posts

Engagements

Likes

Performance Score.css-goub6s{font-size:var(--chakra-fontSizes-md);font-weight:500;color:var(--chakra-colors-gray-600);display:block;margin-top:var(--chakra-space-1);}Sachin Kumar's LinkedIn Performance

Ready to grow your LinkedIn presence?

Performance ScoreSachin Kumar's LinkedIn Performance