YUGESH REDDY KAMASANI
Chittoor
Summary
Dedicated and worked as a data analyst with around 4 years of extensive experienced in PowerBi with a strong background in data analysis, visualization, and business intelligence. Proficient in creating interactive and insightful dashboards and reports that drive data-driven decision-making. Skilled in DAX, Power Query, and SQL, with a proven track record of delivering high-quality solutions in fast-paced environments. Developed and maintained Power BI dashboards for various departments, providing actionable insights and improving business processes. Collaborated with stakeholders to gather requirements and translate them into technical specifications. Optimized data models and queries to enhance performance and efficiency. Excellent analytical and Problem-solving skills and a motivated team player with excellent interpersonal skills.
Overview
4
4
years of professional experience
Work History
Data Analyst
Cognizant Technology Solutions
Bangalore
12.2020 - 11.2024
- Designed and managed team dashboards, providing critical insights that streamlined business operations.
- Developed and altered SQL queries using SQL Server Management Studio (SSMS) for reporting purposes and database management
- Administered stored procedures for SSRS reports and Power BI dashboards to enhance reporting capabilities.
- Imported data from CSV files, Excel, and SharePoint into SQL databases, leveraging SSIS packages for seamless data integration.
- Performed data manipulation through queries and stored procedures in SSMS, enabling advanced data models in Power BI.
- Cleaned data using the Query Editor, created required columns and measures, and developed visuals based on requirements
- Published dashboards in the Power BI web app for broader accessibility and usage
- Developed a comprehensive sales performance dashboard that integrated data from multiple sources, resulting in an increase in sales team productivity
- Charter report was developed by using SSIS, SSMS and Power BI Desktop. Getting the base data from various sources like Excel and using a website. The data is stored in a database and is updated by stakeholders in a URL. This report is used during Monthly review calls with the Leadership team.
- Implemented advanced DAX queries in Power BI desktop, providing detailed insights
- Implemented row-level security within Power BI, protecting sensitive data and complying with global data protection regulations
- Transformed raw data into informative visualizations and reports using Power BI, which played a key role in driving a revenue growth by unveiling key market opportunities
- We developed reports using SQL Server Reporting Services (SSRS) and Power BI
- Data was loaded into our database through an SSIS package
- SQL queries were created in SQL Server Management Studio (SSMS) to generate the reports, and visualizations were built using Power BI
Education
B.Tech - Electronics & Communication Engineering
Madanapalle Institute of Technology and Sciences
01.2020
Intermediate - MPC
Sri Chaitanya Junior College
01.2016
SSC -
Sir C R R High School
01.2014
Skills
- SQL
- Power BI
- SSIS
- SSRS
- SSMS
- ASPNET Basics
Accomplishments
Automated Reporting System, Developed a reporting system that cut manual effort.
Timeline
Data Analyst
Cognizant Technology Solutions
12.2020 - 11.2024
B.Tech - Electronics & Communication Engineering
Madanapalle Institute of Technology and Sciences
Intermediate - MPC
Sri Chaitanya Junior College
SSC -
Sir C R R High School
Similar Profiles
PRAKASH NARAYANA VIGNESH BPRAKASH NARAYANA VIGNESH B
Business Analyst- Technical Lead at Cognizant technology SolutionsBusiness Analyst- Technical Lead at Cognizant technology Solutions
Raja RathinamadasamyRaja Rathinamadasamy
QA Manager at Cognizant Technology SolutionsQA Manager at Cognizant Technology Solutions
Josephine Arockiya Rani SJosephine Arockiya Rani S
Technical Lead -AWS at Cognizant Technology Solutions, CTSTechnical Lead -AWS at Cognizant Technology Solutions, CTS