Summary
Overview
Work History
Education
Skills
Websites
Languages
Accomplishments
Environment
Timeline
Generic

YESWANTH MUCHALA

Glasgow

Summary

Around 4years of experience as a Data Analyst in Software Design, Database Design, Development, Integration Implementation and Maintenance of Business Intelligence and the related Database Platforms. Experienced in Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation. As a Data Analyst responsible for Data Modeling, Enterprise Data Management, Data Presentation, Visualization, Optimization, Risk assessment, predictive analysis, advance Data Analysis, Business Research and Quantitative Analysis. Experience in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop. Gained experience to extract and analyze data using Power Query, PivotTables, MS Excel, Power BI and SSAS Strong experience of Data Warehousing methodologies and concepts including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools. Well-developed skills in SQL Server Integration Services 2005/2008/2012/2014/2016/2017 for data extraction, transformation and loading using different heterogeneous source systems like flat files, Excel, SQL Server. Experience with DAX queries and functions, Data modeling in Power BI with multiple system connections. Experience in Database Design and development with Business Intelligence using SQL Server Integration Services (SSIS), DTS Packages, SQL Server Analysis Services (SSAS), DAX, OLAP Cubes, Star Schema and Snowflake Schema. Proficient in SQL and experience with various Relational Database Management Systems (RDBMS) such as MySQL, Oracle, Microsoft SQL Server, or PostgreSQL. Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests. Have experience of data visualization tools like Tableau or Power BI to create reports and dashboards from data stored in the data warehouse. Collaborated with stakeholders to gather requirements, analyze business needs, and design the data analytics and reporting solution architecture. Implemented Row-Level security(RLS) and Data Governence in Power BI Desktop and Service. Experience in reports deployment automation with Power shell scripts to publish reports to Power BI Service.

Overview

4
4
years of professional experience

Work History

Data Analyst

S & P Global
11.2022 - Current
  • The development and deployment of an online banking system that enables users to conduct financial transactions is part of the project called the Online Banking Platform
  • To give users a seamless and safe online banking experience, a new online banking platform was designed and created.

Data Analyst

EY
04.2020 - 11.2022
  • My role was to provide data and business intelligence (BI) technology solutions to support financial analysis and automate reports
  • Analytics can be used to support business choices and deliver customer service in a variety of enterprise-wide tasks related to finance, operations, provider relations, and insurance costs
  • Make a data pipeline and architecture and oversee it.

Education

MSc, Business Analysis and Consultancy -

University of Strathclyde

B. Tech, computer science -

PVPSIT (JNTUK)
Vijayawada, India

Skills

  • Windows, UNIX, Linux
  • Python, SQL BI Tools
  • My SQL, MS SQL Server, Oracle, PostgreSQL
  • Agile, Waterfall, Scrum
  • MS SQL Server:2017/2016/2014
  • Git, SVN
  • Jira
  • Power BI Desktop, Power BI Gateway, Power Query, DAX, Power BI App, SSIS, SSRS, SSAS, Tableau Desktop/ Server
  • Problem Solving
  • Analytical Reasoning
  • Critical Thinking
  • Adaptability
  • Teamwork
  • Communication
  • Report Writing
  • Attention to Detail
  • Relationship Building
  • Listening
  • Curiosity to Learn

Languages

English
Advanced (C1)
Telugu
Bilingual or Proficient (C2)

Accomplishments

  • Got client appreciation in project management for meeting the deadlines.

Environment

Power BI, Power Pivot, Power View, Power Map, Tableau, SQL Server, Oracle, CSV, Excel, KPI, SSIS, PowerShell, Azure Storage, Azure Data Factory, RLS, SSRS, Spark, Pyspark, Jira, Unix, Linux, Power Query, GIT, DAX, Shell Script, Windows, OLAP, Star, Snowflake.

Timeline

Data Analyst

S & P Global
11.2022 - Current

Data Analyst

EY
04.2020 - 11.2022

MSc, Business Analysis and Consultancy -

University of Strathclyde

B. Tech, computer science -

PVPSIT (JNTUK)
YESWANTH MUCHALA