Gowthami Konda
Flushing,USA
Summary
Dedicated and detail-oriented Data Analyst with years of experience in collecting, analyzing, and interpreting large datasets to drive business decisions. Proficient in SQL, Python, and data visualization tools like Tableau and Power BI, with a strong background in identifying trends, optimizing processes, and delivering actionable insights.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Data Visualization Associate Intern | Project Lead
Excelerate
10.2024 - 02.2025
- Performed data cleaning and preprocessing to enhance data accuracy, consistency, and reliability
- Conducted exploratory data analysis (EDA) to uncover trends, patterns, and insights for strategic decision-making
- Designed and maintained interactive dashboards using Power BI to support real-time data visualization
- Developed comprehensive reports and summaries, presenting key insights to stakeholders for data-driven decision-making
- Led cross-functional projects, ensuring seamless collaboration and on-time project delivery
- Worked closely with business and technical teams to align data strategies with organizational objectives
- Kept up to date with industry trends, tools, and best practices to enhance data analytics capabilities
Data Analyst
Vertafore
Hyderabad, India
06.2020 - 08.2022
- Company Overview: Client: Vertafore - Hyderabad, India
- Improved operational efficiency by 15% through detailed data analysis, identifying trends and anomalies
- Automated reports and dashboards, reducing manual effort by 30% and enhancing reporting accuracy
- Executed ETL processes, ensuring data quality and consistency in centralized data warehouses
- Developed Power BI reports and data models, integrating data from SQL Server, CSV, Access, Excel, and Oracle
- Optimized SQL queries and stored procedures, reducing execution time by 20%
- Created advanced DAX measures and interactive Power BI visualizations for actionable insights
- Automated data refresh schedules in Power BI Service, ensuring timely and reliable reporting
- Collaborated on dashboards for operations, staffing forecasts, and financial reporting
- Maintained 99% data accuracy, ensuring consistency across systems
- Client: Vertafore - Hyderabad, India
Education
Master of Science - Information systems
Pace university
New York, USA05.2024
Skills
- Excel
- Power BI
- Python
- Tableau
- SQL
- DAX
- T-SQL
- MS office
- Leadership capabilities
- Adaptability
- Analytical thinking
- Critical Thinking
- Data collection and entry
- Data Quality Management
- Collaboration
- Decision Making
- Problem Solving
- Research Analysis
- Customer and Client Focus
- Innovative Thinking
- Data Collection
- Data management
- Data mining
- Quantitative & Qualitative Analysis
- Data wrangling
- Transformations
- Statistical analysis
- Migrating data from text files
- Access to SQL Server
- Creating pipelines for data transformation and movement
Certification
- Coursera: Introduction to Data Analysis using Microsoft Excel
- Coursera Project Network: Data Cleaning in SQL, Preparing Data for Analysis
- LinkedIn: Preparation for the Power BI Data Analyst Associate Certification
- Alison: Introduction to Data Analytics with Python
- Simplilearn: SQL Completion of Certification
Projects
Data Analytics Portfolio Project / Zep Analytics, 01/01/25, Analyzed historical cryptocurrency data using Python (Pandas) for data cleaning, wrangling, and aggregation, uncovering key insights. Developed interactive Power BI dashboards to visualize price trends, volatility, and performance metrics, improving decision-making. Integrated Python with Power BI to enhance data processing efficiency and streamline visualization for better stakeholder insights.
Technical Skillset
- Excel
- Power BI
- Python
- Tableau
- SQL
- DAX
- T-SQL
- MS office
- Leadership capabilities
- Adaptability
- Analytical thinking
- Critical Thinking
- Data collection and entry
- Data Quality Management
- Collaboration
- Decision Making
- Problem Solving
- Research Analysis
- Customer and Client Focus
- Innovative Thinking
- Data Collection
- Data management
- Data mining
- Quantitative & Qualitative Analysis
- Data wrangling
- Transformations
- Statistical analysis
- Migrating data from text files
- Access to SQL Server
- Creating pipelines for data transformation and movement
Timeline
Data Visualization Associate Intern | Project Lead
Excelerate
10.2024 - 02.2025
Data Analyst
Vertafore
06.2020 - 08.2022
Master of Science - Information systems
Pace university
Similar Profiles
Vinay Kumar BethiVinay Kumar Bethi
Digital Strategy Associate Intern at ExcelerateDigital Strategy Associate Intern at Excelerate
DEBORAH OMECHE MANORTEYDEBORAH OMECHE MANORTEY
Data Analyst Intern at ExcelerateData Analyst Intern at Excelerate
DEBORAH OMECHE MANORTEYDEBORAH OMECHE MANORTEY
Data Analyst Intern at ExcelerateData Analyst Intern at Excelerate