Summary
Overview
Work History
Education
Skills
Timeline
Generic

ANKIT LAL

Noida

Summary

Business Intelligence (BI) Analyst with over 6 years of experience in supporting Data Analytics (DA) and Quality Assurance (QA) teams. Expertise in data validation, pipeline optimization, and analytical reporting. Known for proactive data quality ownership, detailed reconciliation processes, and cross-functional collaboration. Demonstrated expertise in BI tools, ETL workflows, data visualization, and debugging data inconsistencies across complex environments.

Overview

6
6
years of professional experience

Work History

Module Lead Business Intelligence, Analyst / QA

BOLD TECHNOLOGIES SYSTEM PVT. LTD.
01.2023 - Current
  • ETL Optimization & Cost Savings: Reduced the runtime of the main ETL pipeline by 80 minutes daily, resulting in annual savings of approximately $60,000
  • FlexJobs Portal Migration & QA: Led QA efforts for FlexJobs migration, ensuring data integrity across all systems, resolving dataset merging issues, and improving job lifecycle tracking
  • Sonara Portal QA – Feed & Job Application: Led QA for Sonara’s job ecosystem, validating data pipelines and ensuring live data accuracy
  • VAT Implementation QA: Designed and validated scalable VAT logic for global revenue calculations across all Facts
  • ODS to EDW Regression Testing: Conducted weekly regression checks and reconciled data integrity for major metrics and reports
  • KPI Anomaly Detection Report: Designed and implemented a report to detect trend anomalies in KPIs, enabling proactive issue resolution.
  • Email Campaign Data Reconciliation (Iterable): Ensured alignment of email campaign data with backend systems for accurate performance reporting
  • Call Center Reconciliation (Five9, Salesforce, Zendesk): Reconciled data from call center platforms to ensure accurate tracking of interactions and resolutions
  • Affiliate Performance Reconciliation (AWIN, Trace, Impact Radius, Commission Junction): Validated affiliate traffic and campaign data, ensuring payout accuracy and campaign attribution
  • SEO & SEM Data Reconciliation (GSC, GA, GAD/BAD): Triangulated SEO and SEM data with backend systems to ensure consistency across acquisition channels
  • Chargeback & Intercept Reconciliation and Reporting: Performed detailed reconciliation and reporting for chargeback and fraud intercept data across platforms like Adyen, Stripe, Verifi, Ethoca, and others.

Associate Test Engineer

Maveric Systems
04.2019 - 12.2022
  • Conducted ETL testing using Informatica PowerCenter for data validation
  • Performed regression testing and wrote SQL queries to verify data quality
  • Supported ETL processes for a data warehouse migrated from legacy systems
  • Tracked defects, executed test cases, and generated reports using HP ALM
  • Worked as Test Engineer to define testing requirements to satisfy the business objectives
  • Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes
  • Analyzing requirements and creating and executing test cases
  • Involved in ETL process testing using Informatica ETL tool
  • Involving in Functional Testing & Regression Testing
  • Involving in writing complex SQL queries to verify data between Source and Target
  • Using JIRA storing, maintaining the test repository, bug tracking and reporting.

Education

B.E - Electrical & Electronics Engineering

RGPV University
Bhopal

Skills

  • BI & Visualization: Sisense Power BI MicroStrategy (MSTR)
  • Databases & Querying: Snowflake SSMS Oracle MongoDB Azure
  • ETL & Scheduler: Apache Airflow Informatica PowerCenter
  • Tools & Analysis: Jira HP ALM Excel Jupyter Notebooks Confluence Bitbucket
  • Languages: SQL
  • Operating Systems: Windows UNIX

Timeline

Module Lead Business Intelligence, Analyst / QA

BOLD TECHNOLOGIES SYSTEM PVT. LTD.
01.2023 - Current

Associate Test Engineer

Maveric Systems
04.2019 - 12.2022

B.E - Electrical & Electronics Engineering

RGPV University

Similar Profiles

CREATE PROFILE
ANKIT LAL