Hi! I'm Rumesha
A highly organised and self-motivated Lead Data Analyst who thrives in a fast-paced and challenging work environment. Working as a data analyst in a B2B market research company, I am highly proficient in SQL, MS Excel and Tableau as I produce extensive talent management reports for various multinational companies. Additionally, I have excellent presenting skills and insight experience as my role involves presenting research insights and digital strategies to stakeholders.
Skills
SQL (2 years)
I manage our SQL database usins methodologies; such as VIEWS, STORED PROCEDURES, TRIGGERS, to identify metrics that support reports.
MS Office Suite (6 years)
I am proficient in utilising the Microsoft Office Suite; particularly MS Execel, PowerPoint and Access, for data analysis, presenting findings and streamlining business processes.
Tableau (2 years)
I use Tableau to connect to our SQL servers, clean and transform data, and create dynamic visualizations that effectively communicate trends and patterns in dashboards.
Google Colaboratory (2 years)
I utilise Google Colaboratory for collaborative coding projects to access and thematically classify large datasets of qualitative data into aggregate quantitative measures.
IBM SPSS Statistics (5 years)
I primarily used SPSS in my studies to conduct advanced statistical analyses, including descriptive statistics, ANOVA, regression, factor analysis, etc.
Python (1 year)
I apply Python in data analysis by utilising libraries such as Pandas and NumPy to clean, manipulate, and analyse large datasets.
Experience
• Leading key presentations focussed on providing succinct analysis insights and proposing clear actionable employer branding strategies to key client stakeholders
• Developing high-level project management skills when delegating project deadlines to the analysis team; which involves coordinating the analyst project schedules and assigning the priority level of each project
• Developing high proficiency with Microsoft Excel and Tableau from using it to produce the Employer Brand Index and relevant visualisations for clients
• Writing and running SQL database management queries and Google Colab classifiers to clean and manipulate the data during analysis to identify insights to include in the report, dashboard and stakeholder presentations
Projects
SQL- Creating and Managing Database for a Dog Daycare
In this project, I created a SQL database that consisted of data relevant to the running of a ficitious dog daycare business to help them manage certain business scenarios and data forecasting.
Python- Creating Tic Tac Toe Game
I developed a robust and interactive Tic Tac Toe game with Jupyter Notebooks that implemented the game logic and allowed for two-player interactions.
Python- Demographic Data Analyser
I utilised Pandas to analyse a 1994 Census database to identify relationships and trends between certain demographic groups, particularly regarding occupation, education and economic status.
Tableau- Dashboard for Teens, Social Media & Technology PEW Research Findings 2018
I created a dashboard consisting of various graphs and tables to present the trends and findings from survey research conducted on social media and the types of technology used.