Gomathi Latha
Open to work0 years experienceJunior Data Analyst
Junior Data Analyst with experience in SQL, PowerBI, Excel and Databricks.
Standing Rank
Rank Not Available
Developer Badges
Skills & Technologies
9 skillsGitHub Activity Evidence
GitHub Footprint Not Connected
Recruiters value verified code contributions. Linking a GitHub account displays live heatmaps, active contribution metrics, repository languages, and push activity tags.
Work Experience
Data Analyst Intern
MVP Studio
- Built and maintained ETL workflows to improve reporting efficiency and data accessibility.
- Designed dimensional data models and optimized SQL queries to enhance reporting performance and ensure data integrity.
- Developed interactive Power BI dashboards to monitor operational and financial KPIs, helping users to identify trends, performance drivers and presented recurring insights to stakeholders.
Projects
Property Market Analysis
- Built an end-to-end data warehouse on Databricks using Medallion Architecture, integrating multiple HDB datasets into an analytics-ready star schema for business intelligence reporting.
- Engineered scalable Spark SQL transformation pipelines to automate data cleansing, transformation, and preparation while improving data consistency.
- Created 8+ business KPIs including Price per Sqm, Rental Yield, Investment Score, Affordability Index, Demand-to- Supply Ratio, and YoY Growth and Designed an executive Power BI dashboard enabling users to evaluate housing demand, pricing trends, rental performance, and investment opportunities through interactive drill-down analysis.
Financial Performance Analytics
- Extracted, transformed from various data sources and analyzed financial performance metrics across business units for an education organization, enabling faster identification of top 10 and bottom performing teams.
- Modeled source data with a star schema and SQL views, integrating revenue, profit, and margin metrics.
- Built interactive PowerBI dashboard for YoY growth, variance analysis, and executive-level insights, improving data reliability and reducing processing time by 25%.
Sales Performance & KPI Dashboard
- Analyzed 2024 mobile sales data across multiple countries to identify regional performance, customer purchasing behavior, and product demand trends using Power BI.
- Designed an interactive executive dashboard with dynamic bookmarks, field parameters, and geospatial analysis, enabling exploration of sales performance by country, city, brand, customer demographics, and product features.
- Delivered actionable insights by evaluating pricing strategies, customer segmentation, and sales channel performance, supporting data-driven decisions for targeted marketing, inventory planning, and regional growth opportunities.
Leaderboard Standings
Leaderboard Position Pending
Global test scores, peer standing percentiles, and algorithm leaderboard ranks are updated dynamically.
Assessment Highlights
Assessments Not Completed
Coding evaluations, system assessment results, and conceptual score badges will appear here after taking a test.
AI Collaboration Score
AI Collaboration Score Pending
Developer coding behavior, assistant cooperation, and AI pair-programming indicators are evaluated during live coding sessions.
Role Compatibility Profile
Role Compatibility Analysis Pending
Custom matching reports, candidate role compatibility percentiles, and core engineer strength profiles are processed once conceptual code screenings are complete.
Achievements
Achievements Not Earned
Special rewards, developer badges, system recognition certificates, and conceptual milestones will display here.
About Details
Professional Bio
Junior Data Analyst with experience building data-driven reporting and analytics solutions using SQL, PowerBI, Excel and Databricks. Background in operations and reporting, with a focus on preparing clean datasets, ETL Workflows, defining KPIs, building dashboards and AI tools.
Bachelor of Engineering
Anna University, India ( - 2009)