VISHAKHA ORAM
Data Analyst
London
Summary
Process oriented Data Analyst with 3 years of experience as an Application Development Analyst. Having worked with a team of 30 for UK and US based clients to optimise processes by developing automations using Python, Java, MySQL, AWS, and visualizing current and future trends by analysing data using tools like Power BI and Excel. Mentored 5 new members of the team and set up new processes; increasing overall productivity by 13%.
Overview
3
3
years of professional experience
5
5
years of post-secondary education
3
3
Certifications
Work History
Applied Data Science Intern
GeoDesign Hub
Manchester
01.2021 - 05.2021
- Collaborated with an Industry client, GeoDesign Hub and the Swiss Federal Office for Spatial Development, to predict the Urban Sprawl of different cantons of Switzerland using different Global Human Settlement
- Layer (GHSL) datasets for the year 2040
- Using QGIS software to extract, prepare, combine and process datasets (population, land-use, density), verified the predictions using datasets of different resolutions (25m, 30m, 100m and 250m) with an accuracy of 98.7%
- Identified gaps in the existing process, overcame them by altering the calculations and pre-processing the data increasing processing time by 5%.
Application Development Analyst
Accenture
08.2018 - 11.2020
- Developed applications and dashboards in Java and Python to automate the manual ETL processes, thereby saving 20 man-hours per week
- Implemented a process to allocate tickets among team members; reducing root cause analysis time by 30%
- Identified the trends on the client’s e-commerce website for the US and UK region using MySQL, Excel and
- PowerBI; took necessary actions leading to 18% increase in sales
- Interacted closely with clients, stakeholders, and SMEs to understand their processes and requirements and successfully delivered the results
- Worked closely with different teams (Monitoring, Hybris, DevOps and Infra) for better throughput
- Projects:
- Automatic Ticket Classification:
- Implemented a machine learning model to automatically classify tickets into 7 different categories and assigning it to team members
- Used different ML models like Linear regression, Decision Tree, Random Forest; reduced the total root cause analysis time by 30%
- E-commerce Database using MongoDB:
- Teamed up with a group of 5 members to implement a NoSQL (MongoDB) Database using the MongoDB
- Atlas and MongoDB Desktop Application
- Used the pymongo library in Python to create, populate, extract and manipulate the database programmatically.
Education
MSc - Data Science (Social Analytics
The University of Manchester
10.2020 - 09.2021
Bachelor of Engineering - Computer Engineering
University of Mumbai
08.2014 - 06.2018
Skills
undefined
Certification
Certified Cloud Practitioner, AWS
Timeline
Certified Power BI Data Analyst, Microsoft Azure
02-2023
Certified Cloud Practitioner, AWS
08-2022
Applied Data Science Intern
GeoDesign Hub
01.2021 - 05.2021
MSc - Data Science (Social Analytics
The University of Manchester
10.2020 - 09.2021
Application Development Analyst
Accenture
08.2018 - 11.2020
Certified Programming in Python & Modern Application Development, NPTEL
09-2017
Bachelor of Engineering - Computer Engineering
University of Mumbai
08.2014 - 06.2018
Similar Profiles
Charandasi PatelCharandasi Patel
Accounts & Admin Executive at Gujarat Student Startup & Innovation Hub (i-Hub)Accounts & Admin Executive at Gujarat Student Startup & Innovation Hub (i-Hub)
Aphiwe MninziAphiwe Mninzi
Post Basic Pharmacist Assistant Locum at Smab Agency: Harmony Kusasalethu Medical Hub and Doornkop HubPost Basic Pharmacist Assistant Locum at Smab Agency: Harmony Kusasalethu Medical Hub and Doornkop Hub
Dorcas Phelesia AtienoDorcas Phelesia Atieno
Finance, HR & Administration Manager at Women Defenders Hub (The Hub)Finance, HR & Administration Manager at Women Defenders Hub (The Hub)
AYMAN ANWARAYMAN ANWAR
Administrative assistant at Empower TradersAdministrative assistant at Empower Traders
Kavya RalhanKavya Ralhan
Global Lead – Strategic Partnerships at UNIPREPGlobal Lead – Strategic Partnerships at UNIPREP