Looking for a job

Sandip Mandal

@sandipmandal1

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

India

Message

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

Work history, roles, and key accomplishments

Current

Data & Reporting Analyst

Current

Lloyds Infrastructure & Cons. Ltd

Oct 2025 - Present (11 months)

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.

Excel SAP Google Sheets MIS Reporting Data Validation Report Automation

Freelance Digital Marketing & Reporting Consultant

Self-employed

Jan 2024 - Oct 2025 (1 year 9 months)

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.

Digital Marketing CTR CPC ROAS Excel Google Sheets Campaign Management Reporting