Client Overview
Our Client uses his skills and talents in engineering, science, consulting, and construction to safeguard water, maintain vital infrastructure and restore habitats to keep our communities thriving. Our Clients have a vision of being 100 percent environmental and is the industry leader for heavy water engineering solutions.
Challenge
The client wanted to develop a platform where users can fetch their expense details like cab service, flight tickets, hotel booking receipt etc which they have submitted for reimbursement via Concur , do a search based on project, task country and generate expense report in a format which is accepted by BST and other similar applications.
In addition to this, the client had few things e.g. Exchange rates, Master employee list available in BST but then were using Concur for expense management as it was quite easy and offered a wide range of services. So one of the challenges was to integrate what we need from BST and synchronize Concur with it.
Finally the last challenge was, even though expenses were entered and calculated in Concur but the last step to release /settle payment was done solely by BST so the client needed a way to pick all information that is available in Concur and create the Vouchers in BST to settle outstanding payments.
Solution
AAITCS Pvt Ltd, worked with the Client with each and every requirement items to understand the problem statement, think of innovative solutions and build solutions that fit into the scenario
We started with listing output files coming out of Concur, ETLing into database, Storing information in RDS and using it as necessary. Next step was to list out input files needed in Concur for master employee listing, exchange rates etc and make it available to Concur.
Once the initial setup was complete, the next step was to use the information available in the database and build the Web/ Mobile application for easy search, filter and retrieve information. The same platform was integrated with Tableau reporting to generate expense reports for clients categorized by project or employee. In addition the application had the option to use dynamics template to generate reports as per requirement specification.
The final step to this solution was to read all information and use available dll (dynamic link libraries) of BST to create expense vouchers into BST so that expenses can be settled. This was done using .Net windows service which was running in background checking for new vouchers from Concur every 15 mins and adding those back to BST.
The entire communication was done using a json file encrypted using pgp – Kleopatra service end to end and public keys were shared with Concur and BST.
Business Highlights
- .Net Web API for Encryption and Decryption
- We have used Kleopatra to encrypt and decrypt json files which were used for communication between BST/Concur and Web Application.
- All files were end-to-end encrypted using pgp.
- ETL for pulling expense details from Concur and pushing BST data into Concur
- SSIS packages were used to pull data out of Concur and store back in the RDS.
- Read from BST and push to Concur
- Feed data from database to Web application and expense reports
- Web / Mobile Application for Expense search
- Platform for end-users to login and search project level, employee level, task level expenses by entered date, expense date, category, country etc.
- Expense reports were integrated within the same application.
- Microsoft SSRS expense report as per dynamic template
- Expense report by Employee OR by project as default option
- Option to dynamically generate template and fetch expense report for custom formatting of fields
- Microsoft SSRS to empower reporting
- BST – Expense voucher creation
- .Net window service to check for incoming vouchers every 15 mins and generate them into BST for settlement
- Integrated with BST using BST’s native dll libraries to access functionality dynamically
Technologies used : .NET, Concur, BST, Microsoft SSRS, Azure Database.
About Us
AAITCS Private Limited is an innovative information technology services firm offering world class software solutions. We are client-centric and relationship-based company with a focus to provide a cost-effective software development and support solutions. We focus on quality and delivering business value.
Incorporated in the year 2018, AAITCS Pvt Ltd, has been actively helping global cooperation to innovate and transform their businesses utilizing IT. Our global delivery and engagement models help us to office affordable long-term software solutions that meet out clients IT challenges and add business value. We combine our capabilities to invent, develop, and deliver innovations for clients to transform legacy models to take their business to the next level and create the future.
AAITCS has a team of expert Data architects and engineers to help you build a robust, secure and scalable architecture for your data warehouse. We are highly experienced in constructing unique architecture and conceptual data model for a variety of domains and segments. We work with cutting edge technology into Data Warehouse Migration, Data Modernization and Data Analytics also application development and empower businesses through automation to help clients attain excellence.