Summary
Overview
Work History
Education
Skills
Timeline
Generic

Aman Kumar Lala

Bengaluru

Summary

Analyst with 2.6 years of experience in data analysis and reporting. Skilled in SQL, Power BI, Excel, and Python for data collection, cleaning, and visualization. Experienced in report automation, API-based email verification, and campaign data management using Ongage, CRM, and BigQuery. Developed Excel automation to simplify team tasks, and contributed to achieving the highest team revenue.

Overview

3
3
years of professional experience

Work History

Analyst, Digital Marketing

Anteriad
03.2024 - Current
  • Developed interactive Power BI dashboards using automated data sources to reduce manual reporting effort.
  • Wrote SQL queries in Big Query to extract and clean data from databases for campaign analysis.
  • Used Postman to execute API requests for bulk email verification, classifying emails as valid, invalid, or unverifiable.
  • Created and tested automated scripts (with ChatGPT assistance) to convert JSON data into CSV format.
  • Managed email campaigns through Ongage and CRM tools to improve deliverability and performance tracking.
  • Performed data formatting, validation, and conditional formatting in Excel for reporting accuracy.
  • Analyzed campaign performance using PivotTables and Excel formulas to monitor spend, results, and target metrics.
  • Created Excel automation that made daily tasks easier for the team.
  • Helped the team achieve the highest revenue and became one of the top contributors to overall performance.

Marketing Automation Specialist

United Prime Publication
04.2023 - 03.2024
  • Managed email list segmentation using Rainloop and Webmail to target specific customer groups, which helped reduce bounce rates and improve open rates.
  • Analyzed key performance metrics and created Power BI dashboards for reporting.
  • Organized raw, comma-separated research data into structured Excel sheets for easier analysis.

Education

Bachelor of Science - Mathematics

BSK College
Dhanbad, India
01.2022

Intermediate -

DAV School
Asansol, India
01.2018

SSC -

Sodepur Colliery High School
Asansol, India
01.2016

Skills

    SQL

    Python

    ETL

    Data Visualization

    Automation

    Email Validation

    A/B Testing

    Macros

    CRM Tools

    VLOOKUP

Timeline

Analyst, Digital Marketing

Anteriad
03.2024 - Current

Marketing Automation Specialist

United Prime Publication
04.2023 - 03.2024

Bachelor of Science - Mathematics

BSK College

Intermediate -

DAV School

SSC -

Sodepur Colliery High School

Similar Profiles

CREATE PROFILE
Aman Kumar Lala