Amal Panwar

I am a highly motivated and detail-oriented data professional with a Master's degree in Data Analytics from the University of Strathclyde, and a background in Computer Science and Engineering. I started my journey at Cognizant, where I honed my analytical skills, using SQL, Python, and Power BI to extract valuable insights from complex datasets. This led to improved data quality and streamlined processes. I am passionate about applying data science to real-world challenges, so I furthered my expertise in financial econometrics and data analysis at Caribbean Goods Pvt. Ltd. While working there, I conducted impactful projects such as time series forecasting analysis on coffee futures. I am eager to contribute my skills to impactful projects and seek opportunities in Business Intelligence and Analytics.

Capgemini                                                                                                                                                                  Bengaluru, India

Data Analytics - Consultant                                                                                          March 2022 – Aug2022

• Streamlined ETL testing, boosting efficiency by 30% through Pytest automation.
• Enhanced data analysis and reporting processes through proactive contributions.

Cognizant                                                                                                                                                                    Bengaluru, India

Junior BI/Data Analyst.                                                                                                Nov 2017 – March 2022

• Spearheaded development and implementation of a robust data analysis framework, refining data extraction processes (ETL).
• Leveraged T-SQL, MS Excel,and Power BI touncover valuable insights,detect patterns, and identify trends in complex datasets. 
• Executed data quality analysis, identifying anomalies to enhance overalldata quality by 20% – 30%.
• Utilized machine learning modelling techniques in Python to develop a forecasting model, leading to a 15% reduction in inventory write-offs.
• Improved communication efficiency and streamlined processes resulted in a 20% increase in reliability and security for automated systems.
• Flourished in collaborative team environments, demonstrating a proactive approach, strong multitasking abilities, and a history of autonomous contributions that significantly elevated data analysis and reporting processes.

Caribbean Goods                                                                                                                                     Glasgow, United Kingdom

Data Analyst -intern                                                                                                               May 2023 Sep 2023

• Researched environmental factors affecting coffee sustainability in Brazil, Guatemala, Honduras, and Nicaragua.
• Analysed macroeconomic indicators to assess their influence on the prices of Coffee Future.
• Applied statistical and econometrics modelling techniques to achieve a mean absolute percentage error of less than 7% in predicting Coffee Future.
• Recommended strategies to farmers that can increase sustainable coffee growth in tropical regions by 25%.

University of Strathclyde                                                                                                                           Glasgow, UK

Master of Science in Data Analytics.                                                                                Sep 2022 – Sep 2023

• Award: Distinction
• Relevant coursework: Machine Learning, Data Science and Analytics in R, Big Data, Stochastic Modelling and Financial Econometrics.

Galgotias University                                                                                                                                                  Greater Noida, India

Btech. Computer Science and Engineering.                                                                     Sep 2013 – Sep 2017

• GPA: 8.02/10.
• Relevant coursework: Computer programming and problem-solving, Object-oriented programming, Data structure and algorithm, Database basics, Software development, Data mining and warehousing, Artificial Intelligence.