Vikram Peddawad

About Vikram Peddawad

As a skilled Data Analyst with expertise in SQL and Power BI, I thrive on transforming complex data sets into meaningful insights that drive strategic business decisions. My experience spans data extraction, transformation, and loading (ETL) process using SQL, ensuring data integrity and optimization. I adeptly write and optimize complex SQL queries to extract actionable insights from vast datasets, ensuring accuracy and efficiency. In Power BI, Excel at designing and developing interactive and visually compelling dashboards that facilitate data-driven decision-making. My proficiency includes creating data models, performing data analysis, and utilizing DAX functions to enhance report functionality. I am adept at translating business requirements into intuitive visualizations, allowing stakeholders to easily interpret data trends and patterns. One of my key strengths is my ability to collaborate with cross-functional teams to understand their data needs and deliver reports.6+ years of experience in Business Intelligence, Power BI, DAX, SQL Server, and data modeling. Experienced in building enterprise dashboards, KPI frameworks, and executive reports. Strong background in stakeholder management, requirement gathering, and end-to-end BI delivery in large organizations.

Experience

1. Data Analyst

   HSBC

   Dec 2022 — Present · Pune, IN

   Analysed incident data from ServiceNow to develop a comprehensive dashboard that monitors live tickets. Implemented automated reporting using Power Query within Excel for data cleansing. The refined data was subsequently stored in SSMS and integrated into a Power BI dashboard. This dashboard was disseminated to management officials, enabling them to monitor and address software-related issues effectively. Conducted an in-depth analysis of Net Promoter Score (NPS) surveys to gauge satisfaction levels concerning the software and technology utilized. This analysis aids in identifying areas of improvement and gathering feedback from both employees and customers. Managed project documentation on the Confluence platform, collaborating with team members to produce presentations, documents, and videos aimed at enhancing customer experiences.

Education

• Savitribai Phule Pune University

  Diploma in Taxation Law, Tax Law/Taxation

• Savitribai Phule Pune University

  Master of commerce M.Com, Finance and Financial Management Services

• Savitribai Phule Pune University

  Bachelor of Commerce - BCom, Business, Management, Marketing, and Related Support Services

• Indian Institute of Technology, Roorkee

  Postgraduate Degree, Data Modeling/Warehousing and Database Administration