PRAGATI DAS

COBRA (Railway Project)

• Developed 30 complex Power Apps solutions for both web and mobile platforms, enabling dynamic data display by integrating with multiple data sources, including SharePoint, SQL Server, Microsoft Dynamics, and Dataverse.
• Collaborated with cross-functional teams and stakeholders to analyze business requirements and translate them into impactful data visualization solutions using Power BI, PowerApps, and other BI tools.
• Created dynamic galleries with advanced filtering and search functionalities using text inputs, dropdown lists, and SharePoint data sources.
• Used Power Automate flows to automate 40% of manual workflows, including comparing datasets, triggering actions from Power BI buttons, and updating SharePoint lists.
• Leveraged DAX formulas to calculate KPIs, trends, and project-based metrics, enabling actionable insights for decision-makers.
• Integrated Power BI with Power Apps for enhanced data visualization, and ensured seamless cross-platform workflows.

ITWO (Siemens Energy Application)

• Directing the development of ad hoc reports and dashboards, utilizing the Fast Reporting tool and other BI tools.
• As a part of the Siemens Digital Technologies Solutions team, I contributed to strategic decision-making by developing tailored POCs, and presenting data-driven insights to stakeholders.
• Creating the reports in a fast reporting tool with SQL queries, finishing the user interface's integration, and migrating the reports from QA to Prod.
• Developed more than 20 reports with BI tools, and proactively monitored and resolved performance issues within Power BI reports, implementing optimization strategies for enhanced reporting efficiency.
• Designed a live BI dashboard, 'Service Ticket Dashboard,' to track service tickets on a daily basis with various charts using a BI tool, and handled such reports in the application independently.
• Developing views in SQL for several modules and integrating them into the user interface of iTWOsite.
• Managed user stories in Jira, and followed Agile methodology to deliver solutions effectively within sprints.
• Completing the user stories in the allotted time by collaborating with cross-functional stakeholders to understand the digital business requirements, providing actionable suggestions for decision-making by leveraging AI-driven insights, and supporting transformation initiatives to enhance processes and achieve project goals effectively within the organization.
• Maintained the user management module in JIRA and designed the customized ticket page using HTML and CSS.
• Support the users in understanding the inside of the application, and provide them with the required business documents for the application on the Confluence page or Wikisphere page.

CMACGM

• I worked as an L2/L3 Analyst in the Logistics application (global application), and handled the ticket management process with the BI report and canvas app development for the application.
• Performed ticket assignment to other resources, with a proper knowledge transfer session, to resolve issues in ServiceNow.
• Completed and monitored all the tickets before the SLA breach, managed the KPI, and solved 15 to 20 tickets per day with immediate ticket resolution independently.
• Proficiently leveraged SQL Server Management Studio (SSMS) to expertly query, manipulate, and optimize data, significantly enhancing reporting and analytics efficiency in conjunction with Tableau and Power BI.
• Conducted ETL processes to extract, transform, and load data from various sources. Demonstrated expertise in crafting intricate DAX queries in PBI.
• Responsible for eliciting business requirements from stakeholders, and preparing a demo approach for clear and insightful BI reports to support decision-making.
• Created a weekly report for the KPI details using Tableau, and modified the existing BI report if required.
• I created a variety of applications using PowerApps, such as survey apps and application knowledge bases, to manage client feedback and requirements.

Apple Odyssey Project

• Developed seven screens of the Odyssey application using Swift language and PL/SQL/MySQL.
• Completed performance testing and unit testing of 50 screens for the Odyssey application.
• I implemented troubleshooting for post-production issues of the Odyssey application and completed the tickets assigned to me within the timeline.
• Performed data analysis using Power BI (basic DAX queries) and transformed raw data into meaningful visualizations for business stakeholders.
• Responsible for managing data sets, ensuring they are clean, accurate, and ready for analysis. This often involves data extraction, transformation, and loading (ETL) processes. Using Power Query Editor as an ETL tool for transforming and cleaning data by using various transformation methods.
• Analyzed and understood user stories and their requirements, and converted them into relevant Power BI reports.

• Trained in python and completed the organization's certification
• Adept in performing research regarding python programming and its uses and efficiency