Shikha Sarah Kurien | Certified Data Analyst

Shikha Sarah Kurien

Certified Data Analyst

Based in Sydney, Australia

About

Data Analyst | Consulting & M&A | Data Analysis, Visualization, Market Assessment| SQL, Tableau, PowerBI | I deliver actionable insights and drive business growth through meticulous data evaluation and strategic research

Skills

Projects

Netflix recommendation engine

Created a mathematical model to help predict and recommend the next content/show that the subscriber could watch when they are on netflix to watch a show. In other words, created a Netflix recommendation Engine to help business retain customers.

King Country House Sales Dashboard

A dashboard displaying daily average house sales prices, a price map by state, and distributions of house prices, bedrooms, and bathrooms. It also shows prices by view and condition. Results can be filtered by date, lot size, living area, and year built.

Online Sales Dashboard

The sales dashboard provides a summary of the KPIs like sales, profit , shipping cost, returns, review ratings etc. It also does a trend analysis of monthly sales vs quantity. The dashboard is dynamic with respect to the KPIs, and the KPI split can be further visualized by country, payment type etc.

Marimekko chart

A Marimekko Chart (or mekko chart) is similar to a 2D Stacked Chart. However, in addition to depicting data through varying heights (as in a regular Stacked Chart), they depict an added dimension of data through varying column widths.

HR Analytics Dashboard

This Dashboard helps HR to get an overview of data related to important KPIs of an organization and analyse trends in various aspects such as Employee Attrition Rate, Gender-wise Attrition, Department-wise, Education-wise, Age-wise, Job Satisfaction Rating and Total Employees by Age group

Mergers and acquisitions by global tech companies

Provides a summary of acquisitions made by top global companies by value and volume, the top tech products purchased etc.

Customer Analytics Dashboard

The Customer Analytics Dashboard was designed to provide comprehensive insights into user behavior, demographics, and satisfaction for a SaaS-based AI writing startup.

Experience

June 2024- Present

Data analyst at Dashboardworx, Sydney

-Design and develop advanced analytical components that is part of the DashboardWorx's Tableau beta-version toolkit -Partner with the founder and other freelancers to design Tableau dashboards templates for advanced analysis -Conducting advanced data cleaning, modeling, and transformation using SQL -Currently driving an analytics project to improve the digital marketing effectiveness for a client and provided insights into insights into the types of posts that generate high engagement, detailed demographics of their followers, and characteristics of profile visitors.

Oct 2020 - Dec 2022

Business Analyst at Mannarkkad Rubber Estates (P) Ltd

• Led transition from paper-based book keeping and reporting, to Google cloud-based information system, improving speed and efficiency of data access by over 67%. • Created regression model to estimate the contribution of rainfall to coffee yield in order to make informed capital investment decisions concerning irrigation system. • Developed and implemented data driven strategies for inventory management of rubber sheets and efficient resource allocation of rubber tappers. Analysed historical data and market trends to forecast demand, resulting in 10% reduction in operational costs and improved supply chain efficiency. • Designed interactive dashboards and reports using Excel and Tableau to identify trends, visualise KPIs and provided actionable insights to senior management.

Nov 2013 - Nov 2018

Research Analyst at EY

Performed Investment Research (M&A, IPO, PE) and Industry Research for various sectors, including F&B, Real Estate & Hospitality, and Consumer Products & Retail. • Developed skills in market assessment, competitive intelligence, feasibility studies, benchmarking, and stock market analysis. • Utilized SQL for data manipulation and advanced data visualization tools such as Tableau and Power BI to create interactive dashboards and reports, providing actionable insights to clients and stakeholders. Tableau improved the operational efficiency by 20%, as compared to Excel which was primarily used for data visualization. • Leveraged advanced Excel skills for complex financial modelling, data analysis, and scenario planning, enhancing decision making process