K. Gopinath

Data Analyst

Trichy, Tamil Nadu, India 0+ yrs exp 81 · Excellent

About

Detail-oriented Data Analyst with an MBA and 6 months of internship experience in Data Analytics and Business Intelligence. Skilled in SQL, Advanced Excel, Power BI, Tableau, Power Query and Python (Pandas, NumPy). Experienced in collecting, cleaning, validating and analyzing data from multiple sources to build interactive dashboards, KPI reports and actionable insights. Strong in trend and pattern identification, anomaly investigation, data accuracy and exploratory data analysis. Works effectively with business, finance, marketing, sales and operations teams, and can work independently in a remote environment, managing multiple assignments and deadlines.

Skills & Expertise (65)

Analytical Thinking Intermediate

6.5/10

Years Exp

Problem Solving Intermediate

6.5/10

Years Exp

Power BI Intermediate

6.0/10

Years Exp

Data Manipulation Intermediate

5.5/10

Years Exp

SQL Intermediate

5.5/10

Years Exp

Data Cleaning Intermediate

5.5/10

Years Exp

Business Intelligence Intermediate

5.0/10

Years Exp

Tableau Beginner

4.5/10

0.5

Years Exp

Python Beginner

4.0/10

Years Exp

Performance Analytics Report Automation Trading Equity Ad Hoc Analysis Confidentiality Data Governance Documentation Reporting Processes Data Pipelines Workflow Streamlining Data Interpretation Machine Learning Data Science Critical thinking Written Communication Verbal Communication Stakeholder Presentation Attention to Detail Time management Meeting Deadlines Independent Work Remote Collaboration Cross-Functional Collaboration Leadership Teamwork Business understanding Formulas relational databases Data Structures Data Extraction Interactive Dashboards Reports KPI Monitoring Performance Reports Microsoft Excel Google Sheets Pivot Tables VLOOKUP XLOOKUP SUMIFS Countifs Matplotlib Reconciliation Power Query Data collection Data Validation Data Transformation Exploratory data analysis Descriptive Analytics Basic Statistics Trend Analysis Pattern Analysis Data Accuracy Pandas NumPy

Work Experience

Data Analyst Intern

Pere Tech Solutions

May 2026 - Oct 2026

Built an interactive Power BI dashboard by cleaning and aggregating revenue, expense and profitability data into a KPI-focused view; monitored KPIs and prepared regular performance reports. Applied data analytics and visualization techniques to identify financial trends and patterns and present them clearly, supporting management decision-making. Collected, cleaned, validated and organized data from multiple sources (spreadsheets, databases) using SQL, Power Query and Excel; investigated inconsistencies to ensure accuracy and integrity across reports. Created and maintained dashboards and reports with documentation of data sources and methodology; prepared summaries and presentations for stakeholders and cross-functional teams.

Finance Department Intern

Ventura Securities

Jan 2025 - Jan 2025

Analyzed financial data and market trends to identify investment opportunities and assess client requirements; worked with finance and client teams. Supported client communications and finance-related tasks, preparing basic investment suggestions and reports. Used Excel (Pivot Tables, VLOOKUP, formulas) for data analysis, reconciliation and interpretation; presented findings clearly to clients and teams.