Summary
Overview
Work history
Education
Skills
Websites
Certification
Accomplishments
Education
Custom
Personal Information
Languages
Timeline
Generic
Lalit Anand

Lalit Anand

London,United Kingdom

Summary

Senior Data & BIE Engineer having 10 Years of experience delivering scalable data solutions, optimising business operations, and driving data driven decision-making across healthcare, BFSI, E-commerce, and Retail industries for Product Companies, Adept to Data architecture, governance, quality frameworks, and leveraging advanced analytics and business intelligence tools to design impactful solutions that deliver measurable business outcomes.

Overview

11
11
years of professional experience
1
1
Certification

Work history

Data Engineer2/Business Intelligence Engineer2

AMAZON
London, India
04.2022 - Current
  • Data Architect: Designed and implemented scalable, efficient, and reliable data architecture to support global Identity team data needs. Ensured high performance and accessibility for datasets exceeding 1 PB.
  • Data Subject Matter Expert: Responsible for entire data creation, sharing, and maintenance across global Identity team.
  • Interaction with different businesses & product stakeholders: Responsible for connecting with different Amazon businesses & stakeholders to gather requirements and work on developing meaningful KPIs and metrics.
  • Data Modelling, creating dashboards, creating data pipelines, orchestration, scheduling, data sharing, CI/CD, documentation.
  • Data Governance and Quality: Established data governance policies and implemented quality checks to ensure reliability and accuracy of data shared across teams.
  • Automating MBR, WBR & QBR using Python and AWS quicksight. Creating dashboards for SVPs & VPs to track KPIs as per goals.
  • TOOLS: Databases: Redshift, Dynamo Database
  • Managed end-to-end data pipeline construction for seamless integration of disparate data sources.
  • Visualisation: AWS quicksight, Tableau
  • Developed complex data models to support business decision-making.
  • ETL- AWS EMR, Glue, Cradle, S3
  • Orchestration: MWAA (Airflow)
  • CI/CD: GIT
  • Programming Language: SQL, Python, Python spark

Senior BI & Data Engineer

Cimpress Technology
12.2020 - 04.2022
  • Data Subject Matter Expert: Responsible for entire data creation, share and maintenance across supplier network domain.
  • Interaction with different businesses & fulfiller: Responsible for connecting with different merchants & fulfiller to gather KPIs and metrics.
  • Data Modelling, creating dashboards, creating data pipelines, orchestration, Scheduling, data sharing, CI/CD, documentation.
  • Orders & Items Table data Pipeline: Created orders, items, items history tables data pipelines in snowflake which is later used to create Fulfiller health dashboard.
  • Used DBT to create scripts and materialization.
  • Created GitLab repository and folders to maintain data pipelines code.
  • Used Airflow for creating DAGS, Scheduling and Orchestration.
  • Late Order Detection: Created late order detection dashboard for one of the Cimpress businesses which is used for analysing future late orders.
  • Technologies used: Snowflake, Looker, DBT, Airflow, Git, Docker, Python, SQL.
  • Data Architect: Led design of data architecture framework for supplier network domains, ensuring seamless integration and scalability of data pipelines and dashboards.
  • Dashboard has 6 different tabs for each squad capturing Routing, Integration, onboarding, deliverability, claims & complaints KPIs across different businesses.
  • Technologies used: Looker, Snowflake, HTML.
  • Fulfiller Health Dashboard: Created fulfiller health dashboards to track fulfiller performance across businesses and domain.
  • Embedded dashboard in mix panel UI which is used by merchants & fulfiller to track their operation & performance.

Senior Analyst

JP Morgan Chase & Co
Bengaluru, India
06.2020 - 11.2020
  • Business strategy consulting and analytical solution designing based on data-driven problem solving.
  • Active interactions with business stakeholders throughout engagement journey.
  • Business development and expansion through identification of latent business needs and guidance around latest analytical trends.
  • Project scaling and optimization through process flow enhancements and end to end automation.
  • Organization building through cross learning initiatives and mentor-ship program.
  • P&L Analytics: Working on creating dashboard for P&L activities across different LOBs and product for senior management to make key decisions.
  • Used Tableau & Alteryx for blending data sources, business logics and visualization.
  • Expense & Headcount Dashboard: Created Expense & Headcount dashboards across different LOBs.
  • Automated entire dashboard at server level which refreshes on different business day based on senior management requisite.

Consultant

KPMG, Global Services
05.2018 - 05.2020
  • Pricing Analytics: Helped accounting team of top healthcare company in identifying imbalances in their accounting system for different geographies and tying GL to respective purchase order.
  • Created automated process for comparing the AP & AR data with standard data and creating different Tableau dashboards for monitoring the key metrics.
  • Data Reconciliation & ETL processes: Enabled pharmaceutical giant, retail-based company in migrating accounting data from legacy systems to new system by creating Automated app and workflows in Alteryx & Python.
  • Data Visualisation: Worked on creating Tax & Quality check dashboard for top financial firm using Power BI & Alteryx .

Software Engineer

Cerner (Oracle)
02.2016 - 04.2018
  • Designed and developed reports from scratch by understanding business logic using CCL & Tableau which is totally based on oracle database.
  • Created/Modified/Enhanced schemas, stored procedures, functions & triggers based on business requirements.
  • Performance enhancements of existing interface programs.
  • Maintaining lower environments and migration of code to production.
  • Created automation tools to automate key functionalities of medical reports.
  • Enhancement in medical application forms, medical reports.
  • Creating new discoverer reports.

Associate Software Engineer

Accenture
Bengaluru
07.2014 - 12.2015
  • Financial Crime Monitoring: Worked on creating and testing application for monitoring suspicious Transactions of major financial firm.
  • Created triggers, stored procedures & functions for application using Oracle 11g.
  • Resiliency Database Management System: Worked on designing and developing database for application.
  • Performance tuning of queries.
  • Office of Foreign Asset Control: Worked on creating canned and Ad-hoc report using SAP BO.
  • Designed schema for generating financial report related to expenses & headcount.

Education

Master of Science - Data Science

BITS, Pilani
Work Integrated
04.2024 -

Bachelor of Engineering - Electrical Engineering

RNS Institute Of Technology
Bangalore
06.2010 - 06.2014

Skills

Languages & Scripting:
SQL, Python, Python hSpark
Data Engineering & ETL:
DBT, Alteryx, Talend, Matillion, Apache Airflow (Managed Airflow), Jupyter Notebooks, Reproducible Notebooks, Docker, Git

Databases & Data Warehousing:
PostgreSQL, Snowflake, Oracle, SQL Server, Amazon Redshift, DynamoDB

Business Intelligence & Reporting:
Tableau, Power BI, AWS QuickSight, Looker, PowerPoint

Cloud Platforms:
Amazon Web Services (AWS)

Cloud & Infrastructure (AWS):
S3, EC2, EMR, IAM, Glue, Athena, VPC, Lamda

Data Architecture:
Data Architecture Design, Containerisation, Version Control

Certification

Python Data Structures, Michigan University

Alteryx Advanced Certification

Accomplishments

  • Multiple Spot Awards and Client Appreciations for delivering high quality work and showcasing thought leadership.

Education

Current

Custom

SQL, Python, Pyspark, PostgreSQL, Excellent, SQL, Python, Pyspark, Very Good, Business intelligence, DBT, Alteryx, Talend, Matillion, Python, Very Good, Jupyter Notebooks, Good, Tableau, AWS Quicksight, Looker, Power BI, Python, Powerpoint, Excellent, Snowflake, Oracle, SQL Server, Redshift, Excellent, AWS S3, EC2, EMR, IAM, Glue, Athena, VPC, DynamoDB, Managed Airflow, Excellent

Personal Information

Languages

English
Proficient (C2)
Hindi
Fluent

Timeline

Master of Science - Data Science

BITS, Pilani
04.2024 -

Data Engineer2/Business Intelligence Engineer2

AMAZON
04.2022 - Current

Senior BI & Data Engineer

Cimpress Technology
12.2020 - 04.2022

Senior Analyst

JP Morgan Chase & Co
06.2020 - 11.2020

Consultant

KPMG, Global Services
05.2018 - 05.2020

Software Engineer

Cerner (Oracle)
02.2016 - 04.2018

Associate Software Engineer

Accenture
07.2014 - 12.2015

Bachelor of Engineering - Electrical Engineering

RNS Institute Of Technology
06.2010 - 06.2014

Similar Profiles

Create profile
Lalit Anand