Investor Operation System For Axiom
<h2><b>1. Application Overview</b><b><o:p></o:p></b></h2><h3><p>The <b>Axiom Investor Operations App</b> is designed to manage the operational lifecycle of investor Certificates within investment Structures.<o:p></o:p></p><p>It provides operations users with a centralized application to:<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Manage Structures and their associated Certificates.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Prepare and process Certificates for closing.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Import Certificate information from external sources.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Manage scheduled and unscheduled payments.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Submit payments for approval and process approved payments.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Manage Certificate maturity and related payments.<o:p></o:p></p><p>Overall, the application manages the journey of a Certificate from onboarding and closing through payment processing and maturity.<o:p></o:p></p></h3><h2><b>2. Structure and Certificate Management</b><b><o:p></o:p></b></h2><h3><p>Users can view investment <b>Structures</b> and access the Certificates associated with each Structure.<o:p></o:p></p><p>Within a Structure, users can:<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->View, add, and edit Certificate information.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Filter Certificates based on their closing stage.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Identify Certificates that are ready for closing.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Prepare Certificates for processing.<o:p></o:p></p><p>Certificates progress through:<o:p></o:p></p><p><b>Draft → Ready to Close → Closed</b><o:p></o:p></p><p>This allows users to clearly track the current stage of each Certificate.<o:p></o:p></p></h3><h2><b>3. Certificate Closing</b><b><o:p></o:p></b></h2><h3><p>Once Certificates are ready, users can initiate the <b>Close All</b> process to process eligible Certificates together.<o:p></o:p></p><p>The relevant Certificate information is sent to <b>IDA</b> for processing, after which the Certificates move to the Closed stage.<o:p></o:p></p><p><b>Prepare Certificates → Ready to Close → Close All → IDA → Closed</b><o:p></o:p></p></h3><h2><b>4. External Data Import</b><b><o:p></o:p></b></h2><h3><p>The application supports importing Certificate information through <b>CSV files received from Parvis and Atlas One</b>.<o:p></o:p></p><p>Users can:<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Upload and preview imported data.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Compare imported data with existing Certificate information.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Match imported records with existing Certificates.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Update existing information or add new records.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Choose whether existing information should be overwritten.<o:p></o:p></p><p>This reduces manual data entry when Certificate information is received from external sources.<o:p></o:p></p></h3><h2><b>5. Payment Management</b><b><o:p></o:p></b></h2><h3><p>The application supports both <b>Scheduled and Unscheduled Payments</b>.<o:p></o:p></p><p>For scheduled payments, users can review the current and proposed payment amounts and decide whether to <b>Pay or Cancel</b> the payment.<o:p></o:p></p><p>For unscheduled payments, users can select the relevant Structure and payment Class and enter the required payment amount.<o:p></o:p></p><p>Payments that proceed are submitted for approval through <b>Microsoft Teams</b>. Once approved, users can launch <b>Zumrails</b> to process the payment and then mark it as <b>Paid</b> in the application.<o:p></o:p></p><p><b>Review/Create Payment → Submit → Approval → Zumrails → Mark as Paid</b><o:p></o:p></p></h3><h2><b>6. Maturity Management</b><b><o:p></o:p></b></h2><h3><p>The application manages Certificates reaching maturity.<o:p></o:p></p><p>Users can review the Certificate's <b>Principal and Profit</b> information and prepare a <b>Maturity Proposal</b>. For profit-participating Certificates, the required Profit amount can be entered as part of the proposal.<o:p></o:p></p><p>The proposal is submitted for approval, and once approved, the maturity payment can be processed through <b>Zumrails</b> and recorded as completed.<o:p></o:p></p><p><b>Review Maturity → Prepare Principal/Profit Proposal → Approval → Zumrails → Complete Payment</b><o:p></o:p></p></h3><h2><b>7. Overall Application Workflow</b><b><o:p></o:p></b></h2><h3><p>The application workflow begins with the user selecting an investment Structure and reviewing its associated Certificates. Users can add or update Certificate information and prepare completed Certificates for closing. Once Certificates are ready, they are processed through the closing process and sent to IDA, after which they move to the Closed stage. Where required, Certificate information can also be imported from Parvis or Atlas One and matched with existing records.<o:p></o:p></p><p>The application then supports payment activities, where users can review scheduled payments or create unscheduled payments and submit them for approval. Once approved, payments can be processed through Zumrails and subsequently marked as Paid in the application. When a Certificate reaches maturity, users can review its Principal and Profit information, prepare a Maturity Proposal, submit it for approval, and process the approved maturity payment through Zumrails.<o:p></o:p></p><p>Overall, the application provides a complete operational workflow covering <b>Certificate management, Certificate closing, external data imports, payment processing, approvals, and Certificate maturity</b>.<o:p></o:p></p><p> </p></h3>
Project Summary
<h2><b>1. Application Overview</b><b><o:p></o:p></b></h2><h3><p>The <b>Axiom Investor Operations App</b> is designed to manage the operational lifecycle of investor Certificates within investment Structures.<o:p></o:p></p><p>It provides operations users with a centralized application to:<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Manage Structures and their associated Certificates.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Prepare and process Certificates for closing.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Import Certificate information from external sources.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Manage scheduled and unscheduled payments.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Submit payments for approval and process approved payments.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Manage Certificate maturity and related payments.<o:p></o:p></p><p>Overall, the application manages the journey of a Certificate from onboarding and closing through payment processing and maturity.<o:p></o:p></p></h3><h2><b>2. Structure and Certificate Management</b><b><o:p></o:p></b></h2><h3><p>Users can view investment <b>Structures</b> and access the Certificates associated with each Structure.<o:p></o:p></p><p>Within a Structure, users can:<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->View, add, and edit Certificate information.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Filter Certificates based on their closing stage.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Identify Certificates that are ready for closing.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Prepare Certificates for processing.<o:p></o:p></p><p>Certificates progress through:<o:p></o:p></p><p><b>Draft → Ready to Close → Closed</b><o:p></o:p></p><p>This allows users to clearly track the current stage of each Certificate.<o:p></o:p></p></h3><h2><b>3. Certificate Closing</b><b><o:p></o:p></b></h2><h3><p>Once Certificates are ready, users can initiate the <b>Close All</b> process to process eligible Certificates together.<o:p></o:p></p><p>The relevant Certificate information is sent to <b>IDA</b> for processing, after which the Certificates move to the Closed stage.<o:p></o:p></p><p><b>Prepare Certificates → Ready to Close → Close All → IDA → Closed</b><o:p></o:p></p></h3><h2><b>4. External Data Import</b><b><o:p></o:p></b></h2><h3><p>The application supports importing Certificate information through <b>CSV files received from Parvis and Atlas One</b>.<o:p></o:p></p><p>Users can:<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Upload and preview imported data.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Compare imported data with existing Certificate information.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Match imported records with existing Certificates.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Update existing information or add new records.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Choose whether existing information should be overwritten.<o:p></o:p></p><p>This reduces manual data entry when Certificate information is received from external sources.<o:p></o:p></p></h3><h2><b>5. Payment Management</b><b><o:p></o:p></b></h2><h3><p>The application supports both <b>Scheduled and Unscheduled Payments</b>.<o:p></o:p></p><p>For scheduled payments, users can review the current and proposed payment amounts and decide whether to <b>Pay or Cancel</b> the payment.<o:p></o:p></p><p>For unscheduled payments, users can select the relevant Structure and payment Class and enter the required payment amount.<o:p></o:p></p><p>Payments that proceed are submitted for approval through <b>Microsoft Teams</b>. Once approved, users can launch <b>Zumrails</b> to process the payment and then mark it as <b>Paid</b> in the application.<o:p></o:p></p><p><b>Review/Create Payment → Submit → Approval → Zumrails → Mark as Paid</b><o:p></o:p></p></h3><h2><b>6. Maturity Management</b><b><o:p></o:p></b></h2><h3><p>The application manages Certificates reaching maturity.<o:p></o:p></p><p>Users can review the Certificate's <b>Principal and Profit</b> information and prepare a <b>Maturity Proposal</b>. For profit-participating Certificates, the required Profit amount can be entered as part of the proposal.<o:p></o:p></p><p>The proposal is submitted for approval, and once approved, the maturity payment can be processed through <b>Zumrails</b> and recorded as completed.<o:p></o:p></p><p><b>Review Maturity → Prepare Principal/Profit Proposal → Approval → Zumrails → Complete Payment</b><o:p></o:p></p></h3><h2><b>7. Overall Application Workflow</b><b><o:p></o:p></b></h2><h3><p>The application workflow begins with the user selecting an investment Structure and reviewing its associated Certificates. Users can add or update Certificate information and prepare completed Certificates for closing. Once Certificates are ready, they are processed through the closing process and sent to IDA, after which they move to the Closed stage. Where required, Certificate information can also be imported from Parvis or Atlas One and matched with existing records.<o:p></o:p></p><p>The application then supports payment activities, where users can review scheduled payments or create unscheduled payments and submit them for approval. Once approved, payments can be processed through Zumrails and subsequently marked as Paid in the application. When a Certificate reaches maturity, users can review its Principal and Profit information, prepare a Maturity Proposal, submit it for approval, and process the approved maturity payment through Zumrails.<o:p></o:p></p><p>Overall, the application provides a complete operational workflow covering <b>Certificate management, Certificate closing, external data imports, payment processing, approvals, and Certificate maturity</b>.<o:p></o:p></p><p> </p></h3>
Location: Canada
Industry: Investment Operations / Investor Administration
Challenge and Requirements
<h2><b>1.
Solution Delivered
CodeScale delivered a powerapps solution using PowerApps, PowerAutomate, SharePoint for Investment Operations / Investor Administration.
Technology Used
- PowerApps
- PowerAutomate
- SharePoint
Business Outcome and Impact
External Data Import</b><b><o:p></o:p></b></h2><h3><p>The application supports importing Certificate information through <b>CSV files received from Parvis and Atlas One</b>.<o:p></o:p></p><p>Users can:<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Upload and preview imported data.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Compare imported data with existing Certificate information.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Match imported records with existing Certificates.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Update existing information or add new records.<o:p></o:p></p><p><!--[if !supportLists]-->l<span style="font-style: normal; font-variant: normal; font-size-adjust: none; font-language-override: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span><!--[endif]-->Choose whether existing information should be overwritten.<o:p></o:p></p><p>This reduces manual data entry when Certificate information is received from external sources.<o:p></o:p></p></h3><h2><b>5.
Project Screenshots
