ASHISH AGRAWAL

Coca-Cola Account | Power BI, Power Apps & Power Automate

• Delivered Knowledge Transfer (KT) sessions to stakeholders and team members and supported end-to-end testing to ensure smooth and quality delivery.
• Worked on designing and developing end-to-end Power Apps (Canvas and Model-Driven) solutions integrated with Dataverse for secure and efficient data management.
• Built and implemented 8+ Power Automate flows to automate business and approval processes, with all the data stored and managed in Dataverse tables.
• Contributed to the Coca-Cola Sustainability project, creating automated workflows for data capture, tracking, and reporting.
• Developed automated triggers in Power Automate and connected them with Outlook to handle approval and rejection workflows.
• Managed Level 1 and Level 2 approval processes, ensuring proper tracking and transparency across the system.
• Created a Microsoft Teams workflow bot to send automatic notifications in the Coca-Cola channel whenever a request was rejected by any approver.
• Collaborated with cross-functional teams to improve process efficiency, user experience, and supported deployments across different environments.
• Also worked on Power BI Service, including gateway setup, refresh scheduling, report publishing, and stakeholder reporting.

• Cleaned and analyzed raw data; created Power BI dashboards and reports.
• Connected databases with Python for data cleaning, indexing, and monitoring.
• Used MySQL, MS SQL, and Power BI for data management and visualization.
• Worked with Amazon S3 for data backup and recovery.
• Applied ML and NLP techniques for data analysis.
• Completed AWS Cloud Practitioner (Infosys Certified).
• Created FS document to streamline team workflows.

• Company Overview: Currently employed as a Dashboard Designer at a company serving clients Sleep Number and Cummins
• Utilize Power BI and SQL Server for designing dashboards aimed at data verification
• Engage with client requirements, such as implementing customer feedback programs using Qualtrics surveys
• Analyze survey responses exported from Qualtrics, utilizing Excel and Power BI for comprehensive data insights
• Successfully supported the Sleep Number project through its launch phase and continued to provide ongoing assistance
• Additionally, contributed to the successful deployment of the Cummins project in December 2023 and continue to offer support, including dashboard and SQL-related queries
• Currently employed as a Dashboard Designer at a company serving clients Sleep Number and Cummins

• Engaged in client support roles for Google and Apple, primarily focused on dashboard development and data cleaning
• Assisted in crafting queries, cleaning, and processing data received from clients daily, utilizing Power BI for data extraction and visualization
• Proficiently worked with various data formats such as Excel sheets and CSV files, ensuring data accuracy and integrity
• Utilized SAP ABAP skills for web development and obtained certification in SAP ABAP
• Developed standardized reporting processes for Apple projects based on daily ticket sales data
• Completed the Google project within a year's timeframe
• Employed a wide range of tools including SQL, Oracle, Java, SAP ABAP, Power BI, Excel, Google Sheets, and Tableau for data analysis and visualization
• Conducted a comparative analysis between Power BI and Tableau as per client request
• Successfully deployed all projects and currently providing support