Lovish Bansal

Lovish Bansal Email and Phone Number

Lead Data Engineer @ Optum
Gurugram, HR, IN
Lovish Bansal's Location
Bengaluru, Karnataka, India, India
About Lovish Bansal

👋 Hi there! I’m an experienced data engineer with a passion for turning raw data into actionable insights. Here’s a glimpse into my world:Technical Skills: Proficient in Python, SQL, Snowflake, DataStage, DataBricks, and Azure Data Factory (ADF). I thrive on architecting robust data pipelines and optimizing workflows.Ecosystem Explorer: I navigate the Datalake and Pyspark ecosystem with ease, extracting value from diverse data sources. Whether it’s batch processing or real-time streaming, I’m up for the challenge.Toolbelt: Airflow, GitHub Actions, and Jenkins are my trusty companions. I believe in automating the mundane so that creativity can flourish.Education: I hold a Bachelor of Technology (Electrical Engineering) from Punjab Engineering College (PEC), Chandigarh, complemented by a minor degree in Computer Science and Engineering.Let’s connect! 🌟

Lovish Bansal's Current Company Details
Optum

Optum

View
Lead Data Engineer
Gurugram, HR, IN
Website:
optum.com
Employees:
97827
Lovish Bansal Work Experience Details
  • Optum
    Lead Data Engineer
    Optum
    Gurugram, Hr, In
  • Optum
    Senior Data Engineer
    Optum Jul 2022 - Present
    Gurugram, Haryana, India
    – Skilled in leveraging Databricks Lakehouse for scalable data processing, ETL pipelines, and collaborative analytics.– Successfully transformed over 150+ DataStage ETL processes into Python-based Databricks workflows, resulting in optimized performance, enhanced data processing efficiency, and a remarkable 40% reduction in processing time.– Realized TCO reduction of $4M+ per year in infrastructure cost by migrating a 30TB+ database from Sybase IQ database into Snowflake.– Designed… Show more – Skilled in leveraging Databricks Lakehouse for scalable data processing, ETL pipelines, and collaborative analytics.– Successfully transformed over 150+ DataStage ETL processes into Python-based Databricks workflows, resulting in optimized performance, enhanced data processing efficiency, and a remarkable 40% reduction in processing time.– Realized TCO reduction of $4M+ per year in infrastructure cost by migrating a 30TB+ database from Sybase IQ database into Snowflake.– Designed and implemented Azure Data Factory pipelines, seamlessly orchestrating the loading of 300+ tables from diverse sources directly into Snowflake.– Enabled near real-time data extraction via Confluent Kafka Connect, handling seamless ingestion from over 600+ Kafka topics directly into Snowflake tables.– Proficient in Terraform for Azure, with hands-on experience in designing and creating comprehensive data architecture infrastructure for data teams.– Managed a team of 5 interns in which 2 focused on DataOps solutions, while 3 built an operations dashboard.– Architected & monitored data pipelines with 99.995% availability for 60+ clients, yielding impact $3Mn+.– Guided team to manage and solve 50+ tickets, enhancing data reporting accuracy for 10+ clients.– Executed 15+ team-building initiatives through meets, workshops, and events, enhancing team cohesion.– Led 10+ sprint planning sessions as Scrum Master, ensuring adherence to Scaled Agile methodology. Show less
  • Optum
    Data Engineer
    Optum Aug 2020 - Jun 2022
    Gurugram, Haryana, India
    – Developed and maintained scalable data pipelines through SQL optimization, data quality checks, and the implementation of best practices in data modeling, thus reduction of 2 TB of duplicates and improved overall runtime by 30%.– Reduced cost by $100k+ annually by migrating 1700 job schedules from TWS into a flexible open-source scheduler Airflow.– Achieved a 20% improvement in data quality by Analyzed and provided root cause analysis (RCA) for over 100+ tickets raised by business… Show more – Developed and maintained scalable data pipelines through SQL optimization, data quality checks, and the implementation of best practices in data modeling, thus reduction of 2 TB of duplicates and improved overall runtime by 30%.– Reduced cost by $100k+ annually by migrating 1700 job schedules from TWS into a flexible open-source scheduler Airflow.– Achieved a 20% improvement in data quality by Analyzed and provided root cause analysis (RCA) for over 100+ tickets raised by business users due to incorrect data.– Created and optimized a CDO Rally dashboard using Python’s Flask and MongoDB, reducing data retrieval time by 40% and improving metric accuracy by up to 25%.– Successfully led the migration of DataStage jobs, ensuring seamless transitions and maintaining data quality throughout.– Enhanced Jenkins pipelines, streamlining CI/CD processes for efficient software delivery.– Revamped data extraction design, reducing data footprint by ~2TB, saving cost of $1.5M/year.– Enhanced DevOps to monitor 2000+ workflows, delivering solutions for ~99.995% data availability. Show less
  • Western Digital
    Intern
    Western Digital Jan 2019 - Jun 2019
    Bengaluru, Karnataka, India
  • Atal Tinkering Lab, Chandigarh
    Intern
    Atal Tinkering Lab, Chandigarh Jun 2018 - Jul 2018
    Chandigarh Area, India
     Worked on Arduino and Raspberry Pi 3  Worked on various projects such as Trafficer, Baby Incubator, Home Automation, Obstacle Bot, and Smart water management system  Organised workshop for school students

Lovish Bansal Education Details

Frequently Asked Questions about Lovish Bansal

What company does Lovish Bansal work for?

Lovish Bansal works for Optum

What is Lovish Bansal's role at the current company?

Lovish Bansal's current role is Lead Data Engineer.

What schools did Lovish Bansal attend?

Lovish Bansal attended Punjab Engineering College, Punjab Engineering College, Mount Carmel School, The British School Chandigarh.

Who are Lovish Bansal's colleagues?

Lovish Bansal's colleagues are Pankaj Kumar, Becky Vega, Carmina Eloise Lumio, Shubham Shinde, Lavanya Ashok, Zalina Kazakova, Ms, Rdms, Cecilia Catano.

Not the Lovish Bansal you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.