VIKAS VARMA PETTEM

A skilled data analyst with expertise in data cleaning, transformation, exploratory data analysis, forecasting, and KPI analysis. Proficient in utilising Excel for advanced formulas and macros, Power BI for DAX and data modelling, and SQL Server for database design including joins, stored procedures, triggers, and constraints. Adept at creating interactive dashboards and automating reports to enhance storytelling capabilities. Career goals include leveraging analytical skills to drive strategic decision-making and optimise business performance.

• Microsoft Excel Associate
• Microsoft Certified: SQL Server

Project 1: BLINKIT SALES ANALYTICS DASHBOARD, Client:#

 Academic Project | Technologies Used: Power BI, DAX, Power Query, Excel, Description: Developed an interactive Power BI dashboard for Blinkit to analyse sales performance, product distribution, and outlet performance across multiple years. The goal was to track total sales, item volume, average rating, and outlet performance trends., Responsibilities: Designed KPI visuals for total sales, average sales, and ratings. Connected and transformed data using Power Query for automated refresh. Created calculated columns and measures in DAX to summarize sales data. Built visuals for outlet size, location, and establishment trends. Delivered a report that enabled faster decision-making for regional analysis., 

Project 2: INDIAN BANK DATABASE DESIGN (SQL PROJECT), Client: 

Academic Project | Technologies Used: SQL Server, Description: Designed and implemented a relational database management system for Indian Bank. The system manages customer accounts, transactions, branches, and product data, enforcing integrity and automation through triggers and stored procedures., Responsibilities: Created normalized tables with primary and foreign key relationships. Developed triggers for transaction validations and cheque date checks. Wrote stored procedures for managing transactions and generating reports. Used constraints, joins, and aggregate queries to ensure data accuracy. Implemented business rules to prevent invalid or duplicate transactions.,

 Project 3: MAVEN MARKET SALES DASHBOARD, Client: 

 Power BI, Excel, DAX, Power Query, Description: Created a Power BI dashboard for Maven Market to visualize sales, profit, and transaction trends across countries. The project focused on delivering insights into revenue, profit margins, and return rates., Responsibilities: Developed KPIs for total transactions, monthly profit, and revenue goals. Integrated map visuals for regional performance analysis (USA, Mexico, Canada). Used DAX to calculate metrics like profit margin, return rate, and goal variance. Created charts and cards to highlight weekly trends and revenue targets. Enhanced user interactivity through filters and slicers for product and region.

(VIKAS VARMA PETTEM)