Seeking Remote Data Analytics Roles or Freelance/Contract Work
Introduction
Hello! I'm Roy, an aspiring Data Analyst currently pursuing an MBA focused on Business and Data Analytics. With foundational experience in business and finance, I'm becoming confident in SQL, Python, Excel, data visualisation, and statistical analysis. I aim to leverage data to drive business decisions. Previously, I operated a cleaning business in the UK for 10 years.
Education
- MBA in Business and Data Analytics, Abertay University, 2023 - Present
- Modules Completed: Research Methods, Business Analytics
- One Year in Accounting and Finance, University of Bedfordshire, 2013
- Access to Business Level 3, Central Bedfordshire College, 2012
Certifications
- Data Analyst Track, DataCamp, In Progress
- Introduction to Statistics, DataCamp, Completed, Oct 2023
- Data Science for Business, DataCamp, Completed, Oct 2023
Skills
- SQL: confident in data manipulation and querying. Experienced in handling large datasets.
- Python: Comfortable with libraries like pandas, matplotlib, and scikit-learn for data analysis and visualization.
- Statistical Analysis: Proficient in conducting t-tests, chi-square tests, and ANOVA.
- Predictive Modelling: Familiar with linear regression and decision tree algorithms.
- Data Visualization: Skilled in creating insightful dashboards using PowerBI and Tableau.
- Descriptive Analysis: Experienced in summarizing data sets to identify trends and patterns.
- Diagnosis Analysis: Capable of identifying issues in business processes through data evaluation.
- Tableau: Learning data visualization, used for monthly sales report generation.
Professional Experience
- Founder, Roy's Cleaning Services Ltd., 2013-2021
- Managed all aspects of the business, from finance and HR to marketing.
- Heavily utilised Excel for budget planning and conducted basic predictive analytics to allocate resources effectively.
- Utilised SQL for querying databases to gain useful pricing insights.
- Period of Personal Development and Travel, 2021-2023
- Traveled extensively to broaden horizons and gain a global perspective.
- Acquired soft skills like cross-cultural communication and adaptability.
- Used the time to assess career goals and prepare for an MBA program.
Projects
Frequency Distribution Analysis
Tools: Excel
Objective: To unveil key sales drivers by assessing the frequency of categories in sales data.
Approach: Segmented a dataset comprising a year's worth of sales into diverse product categories.
Impact: Revealed that a small subset of categories disproportionately influenced revenue, informing inventory decisions.
Probability Distribution Modeling
Tools: Excel
Challenge: To mitigate risks from supply chain disruptions.
Methodology: Employed historical data to calculate the probability of delays from different suppliers.
Outcome: Spotted critical suppliers as bottlenecks and diversified partnerships to mitigate risks.
Linear Regression Forecasting
Tools: Excel
Goal: To enhance sales predictions and optimize inventory.
Execution: Designed a linear regression model using past sales data.
Results: Achieved a 95% accuracy rate in forecasts, reducing storage costs by 10%.
Contact
Feel free to contact me at hi@royflyinghigh.com or connect with me on social media above.