T
Tarun Koti
About
Detail
Kentucky, United States
Résumé
Jobs
verified_user
0% verified
Data Analyst InternInfosoft SolutionsAug 2025 - Current (1 year 1 month)Analyzed structured business datasets using SQL and Excel to identify trends, anomalies, and performance gaps. Cleaned and transformed raw data using Python (Pandas) to improve data accuracy and consistency. Built interactive dashboards in Power BI to track KPIs such as revenue, customer behavior, and operational metrics. Automated recurring reports, reducing manual reporting effort and improving turnaround time for stakeholders. Collaborated with business teams to understand requirements and convert them into analytical solutions. Prepared clear insights and presentations for management to support data-driven decision-making.- Data AnalystCapgeminiJul 2021 - Jun 2023 (2 years)Worked on enterprise-level datasets to support business reporting and operational decision-making. Used SQL to extract, join, and analyze data from multiple relational databases. Performed data cleaning, validation, and transformation using Excel and Python to ensure data quality. Developed and maintained Power BI and Tableau dashboards to track KPIs, trends, and performance metrics. Automated recurring reports, reducing manual effort and improving reporting accuracy. Collaborated with business stakeholders to understand requirements and translate them into analytical outputs. Delivered insights through dashboards and presentations that supported management and client decisions.
- AData Analyst InternAcaira Technologies Pvt. Ltd.Oct 2020 - Apr 2021 (7 months)Supported data analysis activities by cleaning, validating, and organizing large datasets using Excel and SQL. Assisted in developing dashboards and standard reports to track business KPIs and operational performance. Performed exploratory data analysis to identify trends, patterns, and data quality issues. Collaborated with senior analysts to prepare insights and documentation for business stakeholders. Improved reporting accuracy and efficiency by streamlining data preparation processes.
Education
verified_user
0% verified
- Master of Science in Computer and Information SciencesSoutheast Missouri State UniversityMay 2025
- KBachelor of Technology in Computer Science & EngineeringKKR & KSR Institute of Technology & SciencesApr 2022
- DData Analytics Job SimulationForage (Quantium)
- TTableau Analyst Certification
- AAWS Certified Cloud Practitioner
- MMicrosoft Power BI Data Analyst (PL-300)
- MMicrosoft Azure Fundamentals
- GGoogle Analytics Certification
- GGoogle Data Analytics Certificate
Projects (professional or personal)
verified_user
0% verified
- OOperations & Financial Reporting DashboardDeveloped an operations and finance reporting dashboard to track expenses, revenue, and operational KPIs. Used Excel (Pivot Tables, Power Query) and SQL for data preparation and validation. Built Power BI reports for profit/loss analysis, cost trends, and operational efficiency. Enabled stakeholders to monitor performance and support data-driven operational decisions.
- CCustomer Behavior & Marketing Insights AnalysisPerformed exploratory data analysis on customer and marketing datasets to understand buying behavior. Analyzed customer segments, repeat purchases, and campaign performance using Python. Created Tableau dashboards to visualize trends, comparisons, and customer segmentation insights. Delivered actionable recommendations to improve customer retention and marketing effectiveness.
- EEnd-to-End Sales & Business Performance AnalyticsDesigned an end-to-end analytics solution using raw sales, customer, and product datasets. Used SQL to extract, join, and aggregate data from multiple relational tables. Cleaned and transformed data using Python (Pandas) and Excel to ensure accuracy and consistency. Built an interactive Power BI dashboard with KPIs such as revenue, growth %, average order value, and region-wise performance. Automated monthly reporting, reducing manual analysis effort and improving business visibility.