Pankaj Gopnarayan

Detail-oriented professional with expertise in Power BI dashboard development, Power Automate workflow automation, and advanced Excel-based data analysis. Experienced in preparing data-driven reports for leadership, maintaining CRM data accuracy, and improving recurring business processes. Seeking a challenging opportunity in Data-Driven Assessments, Dashboard Development, and Process Improvement that utilizes my analytical and technical skills to deliver measurable results.

• Built end-to-end Power BI reports for Sales, Operations, Finance, HR & Mangmanet teams
• Transformed raw data into clear visual reports and dashboards, enabling senior leadership to quickly interpret key metrics during high-level meetings.
• Developed interactive Power BI reports with DAX measures, drill-through pages, and custom visuals to simplify complex datasets for non-technical stakeholders.
• Designed and deployed Power Automate workflows to streamline approval processes with alerts, reducing turnaround time from days to hours
• Created automated alert and notification flows to keep teams updated on task status, deadlines, and exceptions without manual follow-up.
• Integrated Power Automate with SharePoint and Outlook to trigger approvals, send reminders, and log actions automatically.
• Reduced manual report preparation time by automating reporting through Power BI dashboards connected to live data sources
• Integrated AI capabilities into Data Management System enabling automated defect detection and reducing quality error rate
• Analyzed large datasets in Excel to identify trends and anomalies, providing actionable insights to management for decision-making.
• Integrated Power BI and Power Automate with SharePoint, Teams, and Outlook streamlining quality communication and document management across Microsoft 365
• Conducted statistical analysis using advanced Excel functions Funnel Chart, Combo Chart, Gantt Chart, Waterfall Chart, Gauge Chart and Scatter Plot to support department for decision-making
• Applied data modeling best practices (star schema, normalized relationships) to structure raw data sources into clean, analysis-ready models for dashboard reporting
• Explored and deployed AI-based automation solutions within quality workflows eliminating repetitive manual tasks and improving process efficiency

B.A. – Amravati University (2010)

H.S.C. – Amravati Board (2006)

S.S.C. – Pune Board (2003)