About Me
Data Analyst
With over 2 years of experience working on personal projects in data analysis, SQL, Python, Excel, and data visualization tool like Tableau. Proficient in delivering actionable insights and shaping strategic data-driven solutions.
- Profile: Data Science & Analytics
- BI Tool: Tableau
- Domain: Retail, Ecommerce & Digital Marketing
- Other Skills: Microsoft Excel, SQL, Python & SEO
Resume
Education
Bachelors in Computer Application
2016 - 2019
Kristu Jayanti College, Bangalore
Professional Experience
Web Developer
2021 - 2024
Silk Route Advisors, Bangalore
- Developed and tested over 10 no-code web applications with user-friendly interfaces and robust relational database integrations, enhancing usability and functionality.
- Diagnosed and resolved user-based security vulnerabilities in existing web applications, strengthening system reliability.
- Delivered 3 custom no-code web applications, collaborating with stakeholders and tracking client feedback to ensure alignment with goals and timely delivery.
- Mastered three new software tools within one week, leading to the successful delivery of projects while maintaining rigorous quality standards and enhancing team productivity.
Certifications
-
Tableau Ultimate Course (25 Hours): From Zero to Hero (2024) – Udemy
(2024)
Acquired knowledge in data modeling, filtering, dynamic visualizations, advanced calculations, and dashboard design, with hands-on experience in 60+ chart types and 60+ Tableau functions for data transformation.
-
SQL (Intermediate) Certificate – Hackerrank
(2023)
Developed expertise in intermediate-level SQL, including subqueries, aggregate functions, joins, regex, CTEs, CASE statements, and Boolean operators for effective data analysis and manipulation.
-
Google Data Analytics Specialization – Coursera
(2022)
Gained proficiency in SQL for data querying, applied data cleaning techniques to ensure integrity, and leveraged Tableau and Excel to create impactful visualizations and interactive dashboards for actionable insights.
Skills
Proficient in a diverse set of tools and technologies, I excel at using Python, SQL, Excel, and Tableau to solve complex data challenges. With strong expertise in data cleaning and visualization, I turn raw data into actionable insights, helping drive business strategies and decision-making.
Python
SQL
Excel
Tableau
Data Cleaning
Data Visualization
Portfolio
Here are Data Analytics projects utilizing Python, SQL, Excel, and Tableau.
Optimizing GER: Sales Insights
Developed an analysis using Python, SQL, and Excel to examine revenue, customer demographics, and profit drivers. The findings aim to enhance business strategies and improve overall performance.
Adidas Retail Analytics: Uncovering Sales Dynamics
Analyzed Adidas' sales performance, top retailers, trends, growth, and pricing insights. Performed ETL from Python (Pandas) to SQL Server, extracted data with SQL, and visualized insights in Excel.
Sales & Customer Performance Dashboard
Interactive Tableau dashboards leveraging Tableau for data pre-processing and visualization, designed to provide comprehensive insights into sales performance and customer behavior.
Maven's Pizza Sales Insight
Analyzing Maven Pizza's sales performance and business insights by exploring key metrics, product trends, customer behavior, and peak sales periods, utilizing SQL for querying and Excel for dashboard visualizations.
Coffee Shop Sales Analysis
Comprehensive analysis of coffee shop sales utilizing Pandas for data cleaning and exploratory data analysis (EDA), complemented by Streamlit for creating interactive data visualization dashboards.
HR Dashboard
Developed a comprehensive HR dashboard leveraging Tableau for both data pre-processing and visualization, providing an overview of key HR trends and in-depth insights.
Contact
Below are the details to reach out to me!
Address
Bangalore, India
Call
8105744599
karenfernandes243@gmail.com