Investor Operation System For Axiom
1. Application Overview The Axiom Investor Operations App is designed to manage the operational lifecycle of investor Certificates within investment Structures. It provides operations users with a centralized application to: • Manage Structures and their associated Certificates. • Prepare and process Certificates for closing. • Import Certificate information from external sources. • Manage scheduled and unscheduled payments. • Submit payments for approval and process approved payments. • Manage Certificate maturity and related payments. Overall, the application manages the journey of a Certificate from onboarding and closing through payment processing and maturity. 2. Structure and Certificate Management Users can view investment Structures and access the Certificates associated with each Structure. Within a Structure, users can: • View, add, and edit Certificate information. • Filter Certificates based on their closing stage. • Identify Certificates that are ready for closing. • Prepare Certificates for processing. Certificates progress through: Draft → Ready to Close → Closed This allows users to clearly track the current stage of each Certificate. 3. Certificate Closing Once Certificates are ready, users can initiate the Close All process to process eligible Certificates together. The relevant Certificate information is sent to IDA for processing, after which the Certificates move to the Closed stage. Prepare Certificates → Ready to Close → Close All → IDA → Closed 4. External Data Import The application supports importing Certificate information through CSV files received from Parvis and Atlas One . Users can: • Upload and preview imported data. • Compare imported data with existing Certificate information. • Match imported records with existing Certificates. • Update existing information or add new records. • Choose whether existing information should be overwritten. This reduces manual data entry when Certificate information is received from external sources. 5. Payment Management The application supports both Scheduled and Unscheduled Payments . For scheduled payments, users can review the current and proposed payment amounts and decide whether to Pay or Cancel the payment. For unscheduled payments, users can select the relevant Structure and payment Class and enter the required payment amount. Payments that proceed are submitted for approval through Microsoft Teams . Once approved, users can launch Zumrails to process the payment and then mark it as Paid in the application. Review/Create Payment → Submit → Approval → Zumrails → Mark as Paid 6. Maturity Management The application manages Certificates reaching maturity. Users can review the Certificate's Principal and Profit information and prepare a Maturity Proposal . For profit-participating Certificates, the required Profit amount can be entered as part of the proposal. The proposal is submitted for approval, and once approved, the maturity payment can be processed through Zumrails and recorded as completed. Review Maturity → Prepare Principal/Profit Proposal → Approval → Zumrails → Complete Payment 7. Overall Application Workflow 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. 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. Overall, the application provides a complete operational workflow covering Certificate management, Certificate closing, external data imports, payment processing, approvals, and Certificate maturity .
Project Summary
1. Application Overview The Axiom Investor Operations App is designed to manage the operational lifecycle of investor Certificates within investment Structures. It provides operations users with a centralized application to: • Manage Structures and their associated Certificates. • Prepare and process Certificates for closing. • Import Certificate information from external sources. • Manage scheduled and unscheduled payments. • Submit payments for approval and process approved payments. • Manage Certificate maturity and related payments. Overall, the application manages the journey of a Certificate from onboarding and closing through payment processing and maturity. 2. Structure and Certificate Management Users can view investment Structures and access the Certificates associated with each Structure. Within a Structure, users can: • View, add, and edit Certificate information. • Filter Certificates based on their closing stage. • Identify Certificates that are ready for closing. • Prepare Certificates for processing. Certificates progress through: Draft → Ready to Close → Closed This allows users to clearly track the current stage of each Certificate. 3. Certificate Closing Once Certificates are ready, users can initiate the Close All process to process eligible Certificates together. The relevant Certificate information is sent to IDA for processing, after which the Certificates move to the Closed stage. Prepare Certificates → Ready to Close → Close All → IDA → Closed 4. External Data Import The application supports importing Certificate information through CSV files received from Parvis and Atlas One . Users can: • Upload and preview imported data. • Compare imported data with existing Certificate information. • Match imported records with existing Certificates. • Update existing information or add new records. • Choose whether existing information should be overwritten. This reduces manual data entry when Certificate information is received from external sources. 5. Payment Management The application supports both Scheduled and Unscheduled Payments . For scheduled payments, users can review the current and proposed payment amounts and decide whether to Pay or Cancel the payment. For unscheduled payments, users can select the relevant Structure and payment Class and enter the required payment amount. Payments that proceed are submitted for approval through Microsoft Teams . Once approved, users can launch Zumrails to process the payment and then mark it as Paid in the application. Review/Create Payment → Submit → Approval → Zumrails → Mark as Paid 6. Maturity Management The application manages Certificates reaching maturity. Users can review the Certificate's Principal and Profit information and prepare a Maturity Proposal . For profit-participating Certificates, the required Profit amount can be entered as part of the proposal. The proposal is submitted for approval, and once approved, the maturity payment can be processed through Zumrails and recorded as completed. Review Maturity → Prepare Principal/Profit Proposal → Approval → Zumrails → Complete Payment 7. Overall Application Workflow 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. 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. Overall, the application provides a complete operational workflow covering Certificate management, Certificate closing, external data imports, payment processing, approvals, and Certificate maturity .
Location: Canada
Industry: Investment Operations / Investor Administration
Challenge and Requirements
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 The application supports importing Certificate information through CSV files received from Parvis and Atlas One . Users can: • Upload and preview imported data. • Compare imported data with existing Certificate information. • Match imported records with existing Certificates. • Update existing information or add new records. • Choose whether existing information should be overwritten. This reduces manual data entry when Certificate information is received from external sources. 5.
Project Screenshots
