Business Applications & Automation Developer

Context

Field surveys relied on a largely manual process, with information collected on site and then re-entered into different tools. This resulted in duplicate data entry, increased the risk of errors and made historical tracking more difficult.

Role and responsibilities

Analyzed business needs, designed the solution and developed an application to digitize the collection and tracking of field survey data.

Achievements

• Gathered and analyzed user requirements.
• Translated requirements into User Stories and maintained the project backlog.
• Designed the application’s user experience and interfaces.
• Developed a Canvas application with Power Apps.
• Structured and centralized data using SharePoint Lists.
• Implemented automated workflows with Power Automate.
• Enabled data usage and export to Excel.
• Tested, corrected and enhanced the application based on user feedback.

Results

• Digitized the field survey process, reduced duplicate data entry and improved data centralization, traceability and accessibility.

Skills used

• Requirements Analysis & Specification
• Testing, Debugging & Software Quality
• Low-Code Business Application Development
• Process Automation & Orchestration
• Business Data Modeling

Tools and technologies

• Power Apps
• Power Automate
• SharePoint
• Excel

Context

Requests to create and manage SharePoint resources (including libraries, lists, calendars, groups and access permissions) were handled manually by the digital team. As users were often unfamiliar with SharePoint administration, they relied on the team for these recurring operations. The project aimed to simplify these tasks and enable users to manage their resources independently through an accessible and controlled interface.

Role and responsibilities

Analyzed the existing process and designed and developed a Power Apps application enabling users to independently manage key resources across their SharePoint sites.

Achievements

• Analyzed user needs and identified SharePoint operations that could be simplified.
• Designed the user interface of the Power Apps Canvas application.
• Developed features to create and manage SharePoint document libraries, lists and calendars.
• Automated the creation and management of security groups and access permissions.
• Implemented workflows using Power Automate.
• Integrated with SharePoint through REST APIs and handled JSON data.
• Implemented controls and validation mechanisms to secure user actions.
• Performed functional testing, bug fixes and iterative improvements based on user feedback.

Results

• Increased user autonomy in SharePoint site management, reduced manual intervention and standardized the creation and management of resources and access permissions.

Skills used

• Requirements Analysis & Specification
• Testing, Debugging & Software Quality
• Low-Code Business Application Development
• Process Automation & Orchestration
• Systems & Services Integration
• Governance, Security & Environment Management

Tools and technologies

• Power Apps
• Power Automate
• SharePoint
• Excel

Context

Checking software installed on workstations relied on manual data collection and analysis, making the process time-consuming and difficult to scale. The objective was to automate data collection and simplify analysis in order to identify discrepancies and situations requiring attention more quickly.

Role and responsibilities

Analyzed the existing process, designed the solution and developed the required automations to improve the reliability and efficiency of software checks across workstations.

Achievements

• Analyzed the existing process and identified steps that could be automated.
• Developed PowerShell scripts to automatically collect information about software installed on workstations.
• Structured and prepared collected data for analysis.
• Designed a Power BI dashboard to visualize and analyze results.
• Implemented indicators to help identify discrepancies and software requiring further review.
• Automated the data collection process to reduce manual operations.
• Tested scripts and performed consistency checks on collected data.

Results

• Reduced the time required to analyze 100 workstations from 25 hours to approximately 3 hours and 20 minutes by automating data collection and centralizing analysis in Power BI.

Skills used

• Requirements Analysis & Specification
• Software Development & Integration
• Process Automation & Orchestration
• Automation Monitoring & Error Handling

Tools and technologies

• Power Automate
• Power BI
• SharePoint
• PowerShell