Summary
Overview
Work History
Education
Skills
Certification
Software
Interests
Reading, Learning new skills and Volunteering
Work Availability
Timeline
Ashwarya Gupta

Ashwarya Gupta

Data Engineer
Jaipur,Rajasthan
The real test is not whether you avoid this failure, because you won’t. It’s whether you let it harden or shame you into inaction, or whether you learn from it; whether you choose to persevere.
Barack Obama

Summary

As a skilled Data Engineer, I have a proven track record of designing, building, and maintaining scalable data infrastructure that enables efficient and accurate data processing, analysis, and reporting. I collaborate closely with data scientists, analysts, and other team members to understand their data needs and develop customized solutions that meet those needs. My expertise includes database design, data modeling, data integration, and ETL (extract, transform, load) processes, and I am proficient in programming languages such as Python, SQL, and Java. I also have experience with big data technologies such as Hadoop, Spark, Salesforce and AWS, allowing me to provide reliable and efficient data solutions that drive business success.

As a forward-thinking team leader, I am skilled at operating departments efficiently to meet goals. I have a successful background in matching employees with roles for maximum performance and am focused on continuous operational improvement. With my strong analytical and problem-solving abilities, excellent communication skills, and the ability to work collaboratively in a team environment, I am confident in my ability to help organizations make sense of their data and achieve their strategic objectives.

Overview

2
2
years of professional experience
4
4
years of post-secondary education
7
7
Certifications
2
2
Languages

Work History

Assistant Manager

Aavas Financiers Ltd
Jaipur, Rajasthan
03.2023 - Current
  • I am currently working on a data migration, integration, and transformation project using Amazon AppFlow. This fully-managed integration service allows for the secure transfer of data between software-as-a-service (SaaS) applications such as Salesforce and AWS services including Amazon S3, Amazon Redshift, and Amazon EMR, among others.
  • With Amazon AppFlow, data flow automation between applications can be achieved without the need for writing any code. The service provides pre-built templates for popular use cases, such as syncing data between Salesforce and Amazon Redshift. Additionally, Amazon AppFlow offers a user-friendly interface for configuring and managing data flows, and provides built-in dashboards and logs for real-time monitoring of data flow operations.
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Developed, implemented and maintained data analytics protocols, standards, and documentation.
  • Designed and developed analytical data structures.

Data Engineer

Aavas Financiers Ltd
Jaipur, Rajasthan
03.2022 - Current
  • As a Data Engineer, I am currently working on a digitization project on Salesforce and have built multiple templates for data migration. AWS offers a range of services and tools to facilitate different types of data migration scenarios, and I am working specifically with the AWS Database Migration Service (DMS). DMS enables the migration of data between different database platforms, such as Oracle, MySQL, Microsoft SQL Server, and Amazon Aurora, among others, and can be used to migrate data from on-premises databases to AWS or between AWS databases.
  • As part of my work in data engineering, I have generated detailed studies on potential third-party data handling solutions to verify compliance with internal needs and other department requirements. I have also designed compliance frameworks for multi-site data warehousing efforts to ensure conformity with state and federal data security guidelines. I have collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • In addition, I have gathered, defined, and refined requirements, led project design, and oversaw implementation. I have planned and installed upgrades of database management system software to enhance database performance and reviewed project requests to estimate time and cost required to accomplish projects.
  • I have prepared written summaries to accompany results and maintained documentation. I have contributed to internal activities for overall process improvements, efficiencies, and innovation, and analyzed complex data to identify anomalies, trends, and risks to provide useful insights to improve internal controls.

Data Engineering Intern

Aavas Financiers Ltd
Jaipur, Rajasthan
09.2021 - 03.2022
  • As a data engineer intern, my previous focus was on data migration from Sprinkle Tool to AWS cloud using AWS Glue and other related services. I was dedicated to utilizing data to derive insights and support informed business decision-making. My responsibilities involved designing, building, and maintaining data pipelines, data warehouses, and data lakes to facilitate data-driven decision-making.
  • Being detail-oriented and analytical, I was confident in my abilities to work with large datasets and apply data modeling techniques to ensure data accuracy and reliability. I possessed proficiency in programming languages such as Python and SQL, as well as tools such as AWS and Hadoop, which I had acquired through my coursework and projects.
  • In this role, I designed and implemented effective database solutions and models to store and retrieve data, collaborated on ETL (Extract, Transform, Load) tasks, and maintained data integrity to ensure pipeline stability.
  • I also analyzed complex data, identified anomalies, trends, and risks, and provided useful insights to improve internal controls. Additionally, I compiled, cleaned, and manipulated data for proper handling, analyzed large datasets to identify customer behaviors, and developed, implemented, and maintained data analytics protocols, standards, and documentation.
  • Overall, I was committed to contributing to internal activities aimed at improving overall process efficiencies and innovation. I prepared written summaries to accompany results and maintained documentation, explained data results, and discussed the best ways to use data to support project objectives.

Campus Ambassador

IIT Bombay
Mumbai
05.2021 - 07.2021
  • As a campus ambassador intern, I am excited to represent IIT Bombay on my college campus and share my passion for their products/services with my peers
  • Through my role, I will be responsible for organizing events, promoting the brand, and creating engaging content to raise awareness about the company and its offerings
  • As an outgoing and enthusiastic individual, I am confident in my ability to communicate the company's mission and values to others
  • Through my leadership experience in clubs and organizations on campus, I have honed my organizational and communication skills and learned how to manage projects and events effectively
  • In addition to promoting the company on campus, I am also eager to learn more about their products/services and how they are making a positive impact Page 3 of 4 in the industry
  • I am excited to work closely with the company's team and other campus ambassadors to brainstorm new ideas and strategies to increase brand awareness and engagement.

Education

Bachelor of Technology - BTech - Computer Science Engineering

Arya College of Engineering & Research Center, Jaipur-Rajasthan
01.2018 - 05.2022

Bachelor of Technology in Computer Science and Engineering, Arya College of Engineering and Research Center, Jaipur(Raj.), India
Graduation Date: June 2022
CGPA: 8.5/10

Relevant Coursework:

  • Data Structures and Algorithms
  • Object-Oriented Programming
  • Computer Networks
  • Database Management Systems
  • Operating Systems
  • Web Development

Skills

MySQLundefined

Certification

Cloud Foundations- Advanced

Software

Database management tools: Proficiency in using database management tools such as MySQL, SQL Server, store, and retrieve data

Data analysis tools: Proficiency in using data analysis software such as Excel, Tableau, or Power BI to collect, analyze, and visualize data

Microsoft Office: Proficiency in using Word, Excel, PowerPoint, and Outlook to create documents, spreadsheets, presentations, and manage email

Interests

I'm proficient in working with large datasets, developing data pipelines, and implementing data-driven solutions In my work, I prioritize accuracy, efficiency, and scalability to ensure that data is processed in a reliable and timely manner I'm also familiar with various data storage and processing technologies, such as Hadoop, Spark, SQL, NoSQL, and cloud-based solutions like AWS, GCP, and Azure Additionally, I continuously seek to learn and stay up-to-date with the latest developments in data engineering and technology

Reading, Learning new skills and Volunteering

  • Reading: Passionate about reading books on entrepreneurship, leadership, and personal development.
  • Learning new skills: Currently learning Data Modeling, data warehouses, Apache Airflow, and more through online courses and personal projects.
  • Volunteering: Regular volunteer at local animal shelter, assisting with animal care and adoption events.

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Assistant Manager - Aavas Financiers Ltd
03.2023 - Current
Data Engineer - Aavas Financiers Ltd
03.2022 - Current
Data Engineering Intern - Aavas Financiers Ltd
09.2021 - 03.2022
Campus Ambassador - IIT Bombay
05.2021 - 07.2021
Arya College of Engineering & Research Center - Bachelor of Technology - BTech, Computer Science Engineering
01.2018 - 05.2022
Ashwarya GuptaData Engineer