Amber Jain

About Amber Jain

I am a certified data analyst and data engineer with 9+ years of experience. I have a passion for transforming data into insights and solutions that drive business growth and customer satisfaction.I have extensive knowledge and skills in SQL, Python, Advance Excel, AWS(S3, Lambda, Glue, Athena, Redshift, Quick Sight, etc,), and data visualization tools like Google Data Studio, Google Analytics, Tableau, etc. I have successfully designed, developed, and deployed scalable and robust data pipelines, dashboards, and reports for various projects.Some of my notable achievements include:Led the design and implementation of a comprehensive Data Quality Framework incorporating automated checks including header/trailer validation, record counts, and field-level validations,enhancing trust in data (field level encryption and decryption) across critical financial systems.Led automated archival of Redshift tables via stored procedures, archived Aurora DB records,and implemented S3 file lifecycle movement from source to archive folders, resulting in improvedoperational efficiency and reduced data retention overhead.Designed and developed a feature for the Advertising team which helped them to utilize Advertising budget effectively approximately $600K per month, which helped us in increasing revenue by $800K per month. Increased revenue by 25%(YOY) by optimizing pricing strategies using data analysis, added 25+ selling partner in 1 quarter.Automated the process of fetching data from APIs, which saved $50k per month and helped your clients see accurate data.I am always eager to learn new technologies and tools that can help me deliver better results and value to my clients. I am also a team player who enjoys collaborating and sharing ideas with other data professionals.If you are looking for a data analyst and data engineer who can help you leverage data to achieve your business goals, please feel free to contact me. I would love to hear from you and discuss how we can work together.

Experience

1. Assistant Consultant

   Tata Consultancy Services

   Sep 2024 — Present · Indore, IN

   Led the design and implementation of a comprehensive Data Quality Framework incorporating automated checks including header/trailer validation, record counts, and field-level validations, enhancing trust in data across critical financial systems.Built end-to-end encryption and decryption workflows at file and field level using AWS KMS and Python, ensuring secure data handling in compliance with enterprise and regulatory standards.Led automated archival of Redshift tables via stored procedures, archived Aurora DB records, and implemented S3 file lifecycle movement from source to archive folders, resulting in improved operational efficiency and reduced data retention overhead.Partnered with data stewards, governance teams, and engineering groups to institutionalize data quality best practices, significantly improving auditability, lineage traceability, and compliance for sensitive financial datasets.

Education

• Kendriya Vidyalaya

  10th C.B.S.E Board, Science

  2000 — 2010

• Devi Ahilya Vishwavidyalaya

  Bachelor of Engineering - BE, Information Technology

  2012 — 2016

• St. Theresa H.S School Dhar(M.P)

  12th State Board Exam, PCM

  2011 — 2012

• Accredian

  GCD Certificate in Data Science, Data Science

  2019 — 2020