Data Analyst with 1+ years in Oracle SQL, Power BI & ETL processes
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Data Analyst with 1+ year of professional experience in Oracle SQL, Power BI, and ETL processes. Adept at transforming raw business data into actionable insights and interactive dashboards to drive strategic decision-making. Proven track record of automating manual reports, optimizing SQL queries, and implementing data modeling concepts to improve business efficiency.
Thiruvalluvar University
B.Sc.
N/A – June 30, 2024
Palamur Biosciences Private Limited
Junior Data Analyst
February 1, 2025 – March 1, 2026
India
E-Commerce Sales & Inventory Performance Dashboard
February 1, 2025 – March 1, 2026
Developed a comprehensive Power BI dashboard analyzing regional sales revenue, profit margins, and dynamic stock levels across multi-channel retail operations. Designed and executed a structured Star Schema data model to optimize query performance, efficiently establishing relationships between multi-million row fact and dimension tables. Implemented advanced DAX (Time Intelligence, CALCULATE, Filter functions) to identify top-performing product segments and predict inventory depletion rates. Provided actionable insights that allowed management to minimize overstocking risks, effectively reducing overall inventory holding costs by 15%.
Credit Cards Business Analytics
February 1, 2025 – March 1, 2026
Translated complex business requirements into interactive Power BI dashboards, tracking key performance indicators (KPIs) for credit card marketing and customer behavior. Converted legacy Excel-based financial reports into automated, insight-driven Power BI solutions, reducing manual reporting effort by 40%. Wrote and optimized complex Oracle SQL queries (Joins, Aggregations) to extract, analyze, and identify customer spending trends and sales performance. Utilized Power Query Editor for ETL processes to clean, transform, and validate multi-source financial data, ensuring 100% data accuracy. Created advanced DAX measures and calculated columns to perform time-based performance analysis (YoY, MoM, QTD) for management review. Implemented Role-Based Access Control (RLS) in Power BI to secure sensitive banking data and managed scheduled report refreshes via Power BI Service.
Customer Churn Analysis using SQL & Python
February 1, 2025 – March 1, 2026
Extracted large-scale telecom customer transactional records, tenure history, and service logs using Oracle SQL (Advanced Joins & Window Functions). Utilized Python (Pandas, NumPy) to handle missing values, format data types, and prepare raw data feeds for programmatic analytical modeling. Leveraged Python visualization libraries (Matplotlib, Seaborn) to graph churn trends, revealing a high correlation between delayed service resolutions and subscriber dropout rates. Empowered proactive customer retention campaigns based on specific risk scores, contributing to an estimated 10% increase in customer retention rate.
Cultural Fit Analysis
The candidate's projects show a focus on diverse business domains (e-commerce, credit cards, telecom), indicating adaptability. The emphasis on automating manual processes and delivering business outcomes aligns with a proactive and value-driven work culture. However, with only 1+ year of experience and a single employer listed, the breadth of exposure to different team dynamics and organizational cultures is limited.
Soft Skills & Operational Fit
The candidate demonstrates a results-oriented approach, evidenced by quantifiable achievements in projects. The ability to translate complex business requirements into technical solutions and automate reporting indicates strong problem-solving and efficiency focus. Experience with Role-Based Access Control (RLS) and scheduled refreshes shows an understanding of operational aspects of BI solutions.