Vamsi Chandra Donga
Data Analyst
Hyderabad
Summary
Experienced Business Intelligence Analyst with around 5 years of proven expertise in data analysis, reporting, and visualization. Skilled in utilizing SQL, BI tools and Python to extract insights from complex datasets and drive informed business decisions. Proficient in designing and developing BI solutions with Strong background in data extraction, data modeling, ETL process, data interpretation and data visualization. Seeking opportunities to leverage analytical skills and contribute to organizational growth through data-driven strategies.
Overview
5
5
years of professional experience
2
2
Certifications
Work History
Power BI Developer
Tata Consultancy Services(TCS)
04.2023 - Current
- Proficiently manipulating and querying data within diverse relational databases to extract meaningful insights and support decision-making processes.
- Proficient in creating and managing database objects including Tables, Constraints, Joins, Sub-Queries, Views, and Indexes.
- Competent in exploratory data analysis (EDA) with expertise in univariate and bivariate analysis to uncover insights and patterns in data using Python.
- Skilled in using clauses to retrieve and filter large datasets, while applying aggregate functions to summarize data.
- Connected to diverse data sources like SQL Server, MySQL, Snowflake, Excel etc. performing data transformation, cleansing, and modeling for accurate reporting.
- Performed data merging, appending, cleaning, and preprocessing operations using Power Query Editor to manage null values, remove duplicates, and ensure data accuracy and reliability.
- Created Parameters and Columns & measures using DAX functions to derive meaningful insights and KPIs, enhancing decision-making process.
- Implemented bookmarks, tooltips and drill-through functionality in Power BI dashboards to enhance user experience.
- Designed and optimized data models for efficient data analysis and visualization, utilizing incremental refresh techniques to improve performance and reduce load times.
- Implemented row level security in Power BI to restrict access ensuring data confidentiality.
Data Analyst
Tata Consultancy Services(TCS)
03.2021 - 04.2023
- Worked in a data migration project, transitioning complex Tableau dashboards to Power BI, achieving performance improvement and enhanced user interactivity.
- Conducted performance tuning for Power BI datasets, report visuals, reducing report load times.
- Partnered with stakeholders to identify gaps in reporting and proposed actionable solutions using Tableau and Power BI.
- Maintained documentation for migration processes, dashboard designs, and data validation procedures for knowledge sharing and future reference.
- Created new DAX measures and calculated columns to enhance dashboard functionality and interactivity.
- Designed interactive dashboards, optimizing SQL queries, and ensuring data integrity through robust validation processes.
- Handled tool differences between Tableau and Power BI to ensure seamless transition during migration.
Network Analyst
Tata Consultancy Services(TCS)
02.2020 - 12.2020
- Conducted thorough assessments and analyses of network availability at customer sites, considering factors such as infrastructure, equipment, connectivity options, and geographical considerations.
- Identified potential network bottlenecks, vulnerabilities, and areas of improvement through data driven analysis and root cause identification.
- Designed and optimized network routes to ensure reliable connectivity, minimize latency, and enhance overall network performance.
- Created clear and actionable documentation, including network diagrams, configurations, procedures, and troubleshooting guides, to facilitate efficient operations and support.
Education
B.Tech - Electronics And Communications Engineering
Vignan's University
Vadlamudi, Guntur 04.2001 -
Intermediate - M.P.C
Sasi Junior College
Velivennu, Tanuku 04.2001 -
S.S.C -
Bhashyam Public School
Velivennu, Tanuku 04.2001 -
Skills
Power BI
Certification
Microsoft certified: PL-300
Accomplishments
- Achieved on the spot award for resolving the complication without business Impact.
- Bagged Best team award of the quarter.
- Led a team initiative to standardize data collection processes.
Timeline
Power BI Developer
Tata Consultancy Services(TCS)
04.2023 - Current
Data Analyst
Tata Consultancy Services(TCS)
03.2021 - 04.2023
Network Analyst
Tata Consultancy Services(TCS)
02.2020 - 12.2020
B.Tech - Electronics And Communications Engineering
Vignan's University
04.2001 -
Intermediate - M.P.C
Sasi Junior College
04.2001 -
S.S.C -
Bhashyam Public School
04.2001 -
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Amol PhansekarAmol Phansekar
Business Analyst at Diligenta (TCS- UK Subsidiary), TATA CONSULTANCY SERVICES(TCS) PVT.LTDBusiness Analyst at Diligenta (TCS- UK Subsidiary), TATA CONSULTANCY SERVICES(TCS) PVT.LTD
Divya KandimallaDivya Kandimalla
SQL Support Engineer at Tata Consultancy Services (TCS)SQL Support Engineer at Tata Consultancy Services (TCS)
ZAMAGCAGA MAMPOFUZAMAGCAGA MAMPOFU
Accounts Receivable Specialist at Tata Consultancy Services (TCS)Accounts Receivable Specialist at Tata Consultancy Services (TCS)
ARAVA ANANTHA RAOARAVA ANANTHA RAO
Information Security Manager at Tata Consultancy ServicesInformation Security Manager at Tata Consultancy Services