VIKRANT TRIVEDI

• Write and optimize SQL queries for data collection, cleaning, and validation
• Develop, test and maintain Power BI dashboards including data extraction, transformation, modeling, and final visual presentation
• Utilize Power Query, basic M Coding, calculated columns, DAX measures, and Power BI Dataflows to build dynamic and insightful reports
• Manage PBI Service: publishing reports, configuring user access, permissions, and workspace settings
• Work with tools: SSMS, Power BI Desktop/Service, GitHub, Visual Studio Code, JIRA, and Confluence
• Prepare, validate and distribute daily, weekly, monthly and quarterly BAU reports
• Create, update and manage Jira cards and also Sprint for reporting tasks and projects
• Respond to ad-hoc data/report requests via JIRA and Outlook, ensuring timely follow-up and resolution
• Document project and report details thoroughly using Confluence, word and excel
• Collaborate with cross-functional business teams for requirements, solutions, and issues
• Adhere data security, privacy, compliance and risk management
• Deliver reports both individually and as part of a collaborative team effort
• Provide insights into reporting solutions
• Actively participate in Power BI showcases, training sessions, and internal knowledge sharing

Reporting Analyst

• Developed and maintained monthly Power BI and Excel reports covering IT service requests and Microsoft Defender security issue tracking
• Gathered business and technical data from multiple sources, including SQL Server, SharePoint, and local CSV files
• Loaded, cleaned, and modeled data using Power Query, Excel, and Power BI
• Built data models and configured calculated columns and DAX measures for performance reporting
• Delivered valuable insights through well-structured reports and dashboards, improving visibility for IT and security teams

IT Service Desk

• Provided professional, timely technical support to over 400 staff members across hardware, software, and access issues
• Logged, tracked, and resolved tickets with a customer-focused approach
• Assisted with troubleshooting Microsoft 365, network, and system access requests

IT Service Delivery Analyst
Reporting Projects with BI Team - E-Commerce and CP

• Gathered information
• Query from SQL server and Excel
• Prepared Excel report
• Load, Clean and Analise data in Power BI and Excel
• Prepare efficient Data Model in Power BI
• Configure calculated columns and Measures (DAX)
• Create Filters, Matrix, Guage, Line and Bar Chart Visuals
• Prepare final E-commerce Dashboard for Insights of Sales, Category Revenue, Budget vs Sales, Orders with Yearly, Quarterly, Monthly and Weekly filters and slicers
• Represents Insights to BI Team

IT Service Desk

• Professional and Active IT support to more than 1200 staffs

(Level1 and 2)

• Delivered active and professional IT support to more than 1300 employees (23 offices) Australia wide

Volunteer- IT Support to 39 retail stores and corporate office employees

• Prepared and submitted Validated and Compiled stocktake reports
• Coordinated effectively with on-site/off-site staff and customers to ensure smooth audit execution
• Consistently met reporting deadlines while maintaining a high standard of accuracy and compliance in inventory audit submissions

2017 Professional Development Program - Melbourne Polytechnic

2009 Diploma in Telecommunications