Surendra Reddy Somasani
Summary
Highly motivated and detail-oriented Data Analyst with expertise in Power BI, Microsoft Excel, SQL, and Python. Skilled at transforming complex datasets into actionable insights to drive strategic decision-making. Proficient in creating dynamic dashboards and advanced visualizations, utilizing tools like Power Query and DAX for data modeling and transformation. Strong background in data integration, data cleansing, and designing optimized databases for robust analytics. Excellent communication skills enable effective collaboration with cross-functional teams, stakeholders, and clients to understand business requirements and deliver tailored insights. Adept at solving business challenges, automating reporting processes, and delivering impactful solutions in fast-paced environments. Passionate about empowering organizations with meaningful data interpretation and visualization.
Overview
1
1
Certification
Work History
Data Analyst(Placement)
Edinburgh Napier University
10.2023 - 01.2024
- Designed and developed interactive Power BI dashboards and reports, visualizing key performance indicators to drive strategic decision-making.
- Created and optimized data models in Power BI, ensuring seamless and accurate data analysis and reporting.
- Utilized DAX to develop complex measures, calculated columns, and custom aggregations for actionable insights.
- Integrated and consolidated data from diverse sources such as SQL databases, Excel files, and cloud platforms into Power BI for unified reporting.
- Performed data transformation using Power Query, ensuring data cleanliness, consistency, and readiness for analysis.
- Enhanced dashboard performance by optimizing queries and improving data model efficiency, reducing report loading time.
- Collaborated with business stakeholders to gather requirements, translate them into technical solutions, and design tailored dashboards.
- Ensured data accuracy by implementing validation processes and adhering to organizational data governance policies.
- Automated recurring reports and data refresh schedules using Power BI Service, streamlining workflows and delivering real-time insights.
- Trained team members and stakeholders on Power BI functionalities, fostering a culture of data-driven decision-making across the organization.
Education
Master of Science - Computing with Professional Placement
Edinburgh Napier University
Edinburgh, United Kingdom10-2024
Bachelor's degree - undefined
Jawaharlal Nehru Technological University
01.2018
Skills
- Proficient in Power BI for data analytics, dashboard creation, and reporting
- Expertise in data modeling and DAX (Data Analysis Expressions) for advanced calculations
- Skilled in data transformation and cleansing using Power Query
- Experience with connecting and integrating diverse data sources (eg, SQL, Excel, APIs)
- Knowledge of advanced visualization techniques for actionable insights
- Understanding of Power BI service, including publishing and sharing reports
- Familiarity with R and Python integration for advanced analytics
- Basic understanding of database design and SQL queries
- Strong problem-solving and data interpretation skills
- Effective communicator with proven ability to present complex data insights in a clear and concise manner
Certification
Power BI Data Analyst
Hobbies
Reading books
valley ball
Languages
Telugu
Native language
English
Proficient
C2
Timeline
Data Analyst(Placement)
Edinburgh Napier University
10.2023 - 01.2024
Bachelor's degree - undefined
Jawaharlal Nehru Technological University
Power BI Data Analyst
Master of Science - Computing with Professional Placement
Edinburgh Napier University
Similar Profiles
Douglas FoyDouglas Foy
University Open Day Assistant at Edinburgh Napier UniversityUniversity Open Day Assistant at Edinburgh Napier University
Vidit SharmaVidit Sharma
FSI Intern at Edinburgh Napier UniversityFSI Intern at Edinburgh Napier University
SAMUEL TOLORUNTOMISAMUEL TOLORUNTOMI
SDG Dashboard Analyst/Web Developer at Edinburgh Napier UniversitySDG Dashboard Analyst/Web Developer at Edinburgh Napier University