Customer story
The client needed an automated system to reconcile daily portfolio updates for thousands of accounts — including equity market changes and investment adjustments — ensuring accurate and timely updates in their existing portfolio management system (PMS). We built a custom automation combining Power Automate Desktop, Python, and Power Automate cloud flows that extracts, reconciles, and updates records for roughly 4,000 accounts every day, with reconciled files stored securely in AWS S3.
Engagement facts
Client
US IT service provider, 30+ years
Industry
context implies financial/wealth management
Region
California, New York, Illinois
Service
Cloud migration & infrastructure
Stack
Azure
Site Recovery
Entra ID
Azure DNS
accounts reconciled automatically every day
3
data sources unified — Excel reports, bank APIs, and market feeds
5
solution capabilities delivered, from extraction to reporting
4
business outcomes delivered, from time savings to scalability
The client
The client is not named in the source article. What is stated is that the client operates an existing portfolio management system (PMS) and needed daily reconciliation across approximately 4,000 accounts, incorporating equity market changes and investment adjustments.
The need
The client needed an automated system to reconcile daily portfolio updates for thousands of accounts, including equity market changes and investment adjustments, ensuring accurate and timely updates in their existing portfolio management system.
The challenge
The solution
Star Knowledge developed a custom automation solution combining Power Automate Desktop, Python scripts, and Power Automate cloud flows. The workflow automated extraction, reconciliation, and updating processes, while approvals and validations were integrated where necessary. Data was processed, reconciled, and securely stored in AWS S3 buckets for future reference.
Automated data extraction from Excel reports, bank APIs, and equity market feeds.
Built a reconciliation workflow using Python scripts integrated with Power Automate Desktop.
Delivered daily updates to the client’s PMS system for all accounts.
Stored reconciled files securely in AWS S3 buckets.
Delivered notifications and reporting for reconciled records.
Benefits
Eliminated manual reconciliation for 4,000 accounts every day.
Automation reduced errors and ensured reliable updates.
Streamlined daily PMS updates with minimal human intervention.
Solution easily accommodated increasing portfolio accounts and data volume.
Technology
See how our automation team scopes a reconciliation workflow build.
Your reconciliation
Feel free to contact our expert team — we will help you get your project done.
More migration work