# Sandip Mandal

Sandip Mandal is a remote worker on Himalayas, Data & Reporting Analyst at Lloyds Infrastructure & Cons. Ltd, based in India.

Source: https://himalayas.app/@sandipmandal1

```text
Data & Reporting Analyst at Lloyds Infrastructure & Cons. LTD who automated daily reporting from 2 hours to under 10 seconds.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 707k+ INR |
| Job categories | Data Analyst, Business Intelligence Analyst, Reporting Analyst |
| Skills | Data Analysis, Business Intelligence, KPI Reporting, Dashboard Development, SQL, T SQL, SQL Server, Power BI, DAX, Data Modeling, Data Warehouse, Data Visualization, MIS Reporting, Data Cleaning, data transformation |

## About

```text
At Lloyds Infrastructure & Cons. LTD, I automated a Google Sheets reporting system that reduced daily progress reporting time from 2 hours to under 10 seconds. I also validate vendor invoices, prepare MIS reports, and support budget tracking and site progress oversight.

In my e-commerce analysis project, I analyzed 472K+ sessions using T-SQL and uncovered a $282K mobile revenue gap and a 54.84% funnel leak. My other projects include customer and retail analytics, a SQL data warehouse, and interactive Power BI dashboards.
```

## Experience

### Data & Reporting Analyst (current)

Lloyds Infrastructure & Cons. Ltd. Oct 2025 - Present

```text
Validated daily progress reports and built an automated Google Sheets reporting system, reducing manual reporting time from 2 hours to under 10 seconds. Managed vendor billing for 35+ vendors and prepared monthly MIS reports on vendor claims.
```

Skills: Excel, SAP, Google-Sheets, MIS-Reporting, Data-Validation, Report-Automation

### Freelance Digital Marketing & Reporting Consultant

Self-employed. Jan 2024 - Oct 2025

```text
Managed marketing campaigns for 8-9 clients across e-commerce, education, and organizational sectors, tracking CTR, CPC, and ROAS to optimize ad spend. Maintained campaign performance data and prepared monthly client reports on growth metrics and campaign outcomes.
```

Skills: Digital-Marketing, CTR, CPC, ROAS, Excel, Google-Sheets, Campaign-Management, Reporting

## Education

### Dr. Babasaheb Ambedkar Technological University

Bachelor of Computer Science and Engineering, Computer Science and Engineering. 2022 - 2025

```text
Pursued a Bachelor of Computer Science and Engineering, gaining a strong foundation in computing and engineering principles.
```

## Tech stack

- NumPy
- Pandas
- Python
- Google Sheets
- SQL
- SAP
- Matplotlib
- Power BI

To contact Sandip, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Hemant Rawat](https://himalayas.app/@hemantrawat): Data Analytics Professional, Self Employed
- [sirigiri User](https://himalayas.app/@sirigiriuser): Digital Marketing Executive, Roll Home Developers Hybrid
- [Mithil Gundeti](https://himalayas.app/@mithilgundeti): Customer Data Quality Validation, Personal Project
- [sanatan jana](https://himalayas.app/@sanatanjana): Data Analyst, IQOL Technology Pvt. Ltd.
- [Shivanjan Gajjela](https://himalayas.app/@shivanjangajjela): Data Analyst, Self Employed
- [Adithya 08](https://himalayas.app/@adithya08): Data Analyst, Self Employed
- [Abhi M](https://himalayas.app/@abhim1): Data Analyst Intern, Rows and Columns
- [Tanuja Zambre](https://himalayas.app/@tanujazambre): Senior Data Analyst, Verified Market Research
- [Mujahid Ali](https://himalayas.app/@mujahidali4): Freelance Business Intelligence & Reporting Specialist, Self Employed
- [Omprakash Samantray](https://himalayas.app/@omprakashsamantray): MIS Analyst, Sridurga Retail Pvt. Ltd.
