Ritika Vrindavan Pandey
Edinburgh
Summary
Results-driven professional experienced in data analysis, process automation, and dashboard development using PowerPoint, Visio, Alteryx, and Excel. Skilled in automating manual tracking systems, performing billing reconciliation, and supporting functional and regression testing. Proven ability to streamline workflows and deliver accurate, efficient solutions to enhance decision-making and operational efficiency. Fluent in English, Hindi & Gujarati
Overview
6
6
years of professional experience
4
4
years of post-secondary education
Work History
Mandate Application Product Analyst
JPMorganChase AWM
Edinburgh
12.2024 - Current
- Supported regression testing for tech releases to ensure stability and functionality.
- Conducted functional testing for product releases to verify new features and fixes.
- Assisted in creating and delivering presentations to support team and stakeholder communication.
Portfolio Insights & ESG Analytics Data Analyst
JPMorganChase CIB
Edinburgh
04.2024 - 11.2025
- Analyzed multiple documents for billing reconciliation to identify clients who were undercharged or overcharged, enabling management to take corrective actions.
- Developed an Alteryx workflow to identify new or duplicate funds, supporting fund setup and deletion processes. Created SoP and performed functional testing on the Alteryx.
- Replicated outdated VBA code into an optimized Alteryx workflow, improving accuracy and efficiency of the output.
IPB Client Service Specialist Business Manager
JPMorganChase AWM
Edinburgh
08.2023 - 03.2024
- Designed and proposed a consolidated Tableau dashboard for tracking solved/ unsolved cases, headcount, capacity utilisation, and digital service adoption for senior management.
- Designed a manual tracking process for returned mail items to improve case management and action tracking.
- Created a process flow deck for IPB Client Services leadership, highlighting process complexities to support strategic decisions and eliminate an inefficient process, benefiting multiple teams.
Save the Children Volunteer
Save the Children
Glasgow
06.2022 - 09.2022
- Volunteered at Save the Children charity shop, managing sales, cash flow, and delivering excellent customer service during peak times.
- Assisted the store manager with various tasks including steaming clothes, pricing, and organizing merchandise.
- Replenished stock and created stylish window displays while maintaining the store's aesthetics and cleanliness.
Glasgow University Indian Society President
University of Glasgow Clubs & Societies
Glasgow
03.2020 - 03.2022
- Founded the Indian Society at Glasgow University by proposing a successful business case and securing affiliation with the Student Representative Council, including developing the society's constitution.
- Developed efficient onboarding processes, organized events, and maintained member engagement, growing membership from 15 to 150+ and increasing social media followers to 1000+.
- Led the planning and execution of 10+ successful events, overseeing logistics such as entertainment, guest lists, marketing, music, and ticket sales. Grew the society’s profit from £70 to over £1000 in less than a year.
Education
Bachelor of Science - Neuroscience
University of Glasgow
Glasgow 09.2019 - 06.2023
Skills
- Business intelligence tools
- Advanced excel proficiency
- Visualisation and reporting techniques
- Experience with tableau
- Process Improvement
- Statistic analysis
- Agile methodology
- Microsoft Visio
- Requirement gathering
- User acceptance testing
- Team Leadership
- Interpersonal communication
- Product knowledge
- Public speaking
- Python coding language
- Project Management
- Microsoft Office Suite
Languages
English
Native
Hindi
Native
Gujarati
Intermediate
Sanskrit
Intermediate
Urdu
Intermediate
Affiliations
- Volunteering
- Dancing
- Photography
- Singing
Accomplishments
- Led volunteering initiatives as the Global Philanthropy Week EMEA Lead- October 2024
- assisted in creating materials and delivering Panel discussions and skills sessions at universities, as a member of Academic Engagement Group- November 2023- Current
- Elected as the Current Student Representative in the Queen Margaret Union at the University of Glasgow- March 2020
- Elected as the Student Representative for Biology - October 2019
- Won the Best Photography Award at Gujarat Model United Nations- September 2017
Timeline
Mandate Application Product Analyst
JPMorganChase AWM
12.2024 - Current
Portfolio Insights & ESG Analytics Data Analyst
JPMorganChase CIB
04.2024 - 11.2025
IPB Client Service Specialist Business Manager
JPMorganChase AWM
08.2023 - 03.2024
Save the Children Volunteer
Save the Children
06.2022 - 09.2022
Glasgow University Indian Society President
University of Glasgow Clubs & Societies
03.2020 - 03.2022
Bachelor of Science - Neuroscience
University of Glasgow
09.2019 - 06.2023
Similar Profiles
Kate WellerKate Weller
Intern at AWM CapitalIntern at AWM Capital
Joshua BarhamJoshua Barham
Profit Centre Manager at AWM ElectricalProfit Centre Manager at AWM Electrical
Jared DayJared Day
Foreman at AWM Lawn CareForeman at AWM Lawn Care