Engineering Ops Intern | Synapxe

👨‍💻

My Role

As an Engineering Operations Intern at Synapxe, I supported internal operational workflows during the organisation's transition from on premises systems to the new HEALIX cloud platform. My work focused on reducing manual effort, improving maintainability, and building internal tools that made operational processes easier for users to run and update.

The Challenges

1UAM Generation

The existing UAM generation process was fragmented and difficult to maintain. Standard UAM outputs had to be generated separately for each application, manually merged, and then split again by client. In addition, routine changes such as updating mappings or output fields often required direct edits to macro code, which made the workflow harder for users to manage.

2Onboarding Data Consolidation

Onboarding information for the new cloud platform was submitted through FormSG and delivered through email, with some submissions containing multiple users. Consolidating this information manually into a master user list was repetitive and error prone, especially when email threads also contained replies that were not part of the original onboarding submission.

3AWS S3 File Reorganisation

As part of the cloud transition, files in AWS S3 needed to be reorganised based on client requirements. Handling these moves manually would have been slow and difficult to track at scale, so there was a need for a more reliable bulk transfer workflow with logging.

My Contributions

1HEALIX UAM Workflow Redesign

  • Redesigned the HEALIX UAM process in Excel VBA so that users no longer needed to generate standard UAM outputs separately for each application before merging and splitting them manually.
  • Introduced configurable Excel sheets for Group Name to Project mapping and raw to standard column mapping, so routine updates could be made without editing the macro code.
  • Structured the workflow around four user-facing actions: Run All, Add Project Field, Merge All, and Split by Project, making the tool easier to operate and more flexible for day-to-day use.
  • Improved maintainability and scalability by abstracting application-specific logic away from hardcoded VBA and into configuration-driven sheets.

2Onboarding Email Parser

  • Built an Excel VBA tool to extract structured onboarding data from FormSG submission emails and populate a master Excel user list.
  • Designed the logic to process only the original submission emails while excluding reply noise within the same email threads.
  • Reduced repetitive manual effort involved in consolidating onboarding information for users joining the new cloud platform.

3AWS S3 Bulk Transfer Automation

  • Wrote a Bash script using AWS CLI to automate bulk S3 file transfers by matching source file paths to their destination folders.
  • Added logging so that transfer activity could be monitored during execution and reviewed afterwards for auditability and debugging.
  • Reduced manual effort involved in reorganising cloud storage during platform transition.