Himalayas logo
Avantika RaniAR
Open to opportunities

Avantika Rani

@avantikarani

Dynamic Lead Data Engineer specializing in automated data solutions.

India
Message

What I'm looking for

I am looking for a role that fosters innovation, collaboration, and continuous learning.

I am a dynamic and results-driven Lead Data Engineer with extensive experience in designing and implementing automated data solutions using AWS Glue, Athena, and Python. My expertise lies in building ETL pipelines that enhance data retrieval and significantly reduce manual processing times. I have a proven track record of integrating various data sources, including Oracle, IBM DB2, PostgreSQL, and JSON, to streamline operations and drive analytical insights.

Throughout my career, I have demonstrated my ability to collaborate effectively with cross-functional teams, ensuring that complex business requirements are met with precision. I take pride in mentoring new team members, fostering a culture of knowledge sharing and continuous improvement. My commitment to operational efficiency is evident in my successful projects, such as automating Tableau Server tasks and developing GUI applications that save valuable time and resources.

Experience

Work history, roles, and key accomplishments

AC
Current

Lead Data Engineer

Accenture

Dec 2024 - Present (9 months)

Crafted an AWS Glue solution that extracts SQL queries from a PostgreSQL table, transforms table-column mappings, and updates the target table. Mentored and supported new team members by providing guidance on project requirements and technical best practices, ensuring their seamless integration and boosting overall team performance.

AC

Senior Data Engineer

Accenture

Sep 2021 - Present (4 years)

Collaborated with clients to capture business requirements and engineered applications that automate operations and reduce processing time. Developed an ETL pipeline using AWS Glue for data ingestion from DB2/JSON files to S3 in Parquet format, improving data retrieval speed and reducing storage costs. Created AWS Glue Jobs to automate daily ETL processes from Oracle and IBM DB2 to PostgreSQL, red

WL

Software Engineer

Wipro Limited

Sep 2016 - Present (9 years)

Developed and implemented a Python Pandas solution to automate hourly Annual Plan calculations for cargos, reducing processing time to less than 30 seconds. Created interactive Power BI dashboards to visualize Annual Plan data, increasing user understanding and utilization by 40%. Collaborated with cross-functional teams to gather requirements and key metrics for Annual Plan calculations, improvin

Education

Degrees, certifications, and relevant coursework

Birla Institute of Technology and Science logoBS

Birla Institute of Technology and Science

MTech, Software Engineering

2021 - 2021

Developed a solution to optimize Truck Wait Time, providing an application for truck drivers to book slots at terminals.

GC

GVM Girls College

BSc, Computer Science

2016 - 2016

Tech stack

Software and tools used professionally

Find your dream job

Sign up now and join over 100,000 remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan
Avantika Rani - Lead Data Engineer - Accenture | Himalayas