About

Amber Jain is a Senior Data Analyst Engineer at Amazatic Solutions with 4.70 years of relevant experience in the field. She has previously worked with BNY Mellon and Accenture in the roles of Senior Application Developer and Application Development Senior Analyst, respectively. She holds a Bachelor of Engineering degree in Information Technology from Devi Ahilya Vishwavidyalaya and a GCD Certificate in Data Science from INSAID. Amber's technical skills include Data Analysis, Data Cleaning, Data Visualization, SQL, Python, Pandas, Machine Learning, Excel, Google Data Studio, Tableau, Power BI, Google Analytics, R, Core Java, MySQL, PostgreSQL, Ansible, Documentum, and InfoArchive. She is also proficient in using engineering tools such as ProjectWise, ITSM, and Meridian, and ECM tools like Hummingbird and eRoom. Additionally, she has experience working with ticket tools such as JIRA, ServiceNow, and SNEXT. At Amazatic, Amber is responsible for creating business reports and dashboards on Google Data Studio for Amazon Sellers and providing insights to increase revenue and profits. She also automates fetching missing values and raising API requests for missing values on a daily basis, reducing manual efforts by 2 hours per day. She has written SQL scripts for automating billing processes and commissions, which reduces 96 hours of manual efforts per month. She is also a certified Cricket Analyst and has completed a 7-day training for Cricket Data Analyst using Python. She writes blogs for player's impact, comparisons, etc., on Medium and has more than 100 followers. During her tenure at BNY Mellon, Amber worked on Ansible Playbooks for the installation of software on Windows and Linux servers that helped in migration. She also created Chocolatey packages using Shell script for Windows server and RPM package for the Linux server. She worked on Git and JIRA, MySQL, and applied Git Branching Policy. She was comfortable in creating Templates, Projects, and Inventories in AWX Tower and Git Repository. She provided a solution to add more than 20 hosts in a single Inventory in Ansible Tower. At Accenture, Amber performed Exploratory Data Analysis of Tickets and suggested ideas for automation as well as implemented them. She applied Decision Tree Algorithm to add new questions in the catalog of SNEXT tool for the end-users, which reduced follow-up emails. She created Dashboards for the performance of each team in the project based on