Executive Summary
About Client
DEEPIQ simplifies industrial analytics and offers the only self-service application for end-to-end (Data + AI) OPs for the industrial world. With this app, your SMEs can digitize their expertise, and your data teams can build and deploy robust analytic pipelines.
Location: Have Offices Globally in USA, India, Canada
Project Background
We help clients to move to the cloud from their existing system landscape. For this particular case study we helped the client DEEPIQ to move to website hosted in WordPress to Azure.
Scope & Requirement
Implementation
Technology and Architecture
Technology
The migration was deployed with the below technological component
• For Azure Dataverse-The underlying technology used was Azure SQL Database
• For Azure Blob Storage- It supported the most popular development frameworks including Java, .NET, Python & Node.js
Security & Compliance:
- Tagging Policies
- Azure config for compliance checks
- NIST compliance
- Guardrails
- Security Hub
Backup and Recovery
Azure Backup provided a simple, secure, cost-effective, and cloud-based backup solution to protect the business or application-critical data stored in Azure Blob in two ways- Continuous backups & Periodic backups
Network Architecture
- Site to Site VPN Architecture using Transit Gateway
- Distributed Azure Network Firewall
- Monitoring with Cloud Watch and VPC flow logs.
Cost Optimization
- Alerts and notifications are configured in the Azure cost
Code Management, Deployment
- Cloudformation scripts for creating stacksets and scripts for generating Azure services was handed over to the client
Challenges
We encountered some issues as below:
- We faced some issues pertaining to system changes not working as per the new standards
- Creating a backup strategy without having proper backup tools in place
- Ensuring this end-to-end migration did not lead to data loss
- Additional security enhancements are to be added to ensure unauthorized users do not modify reports.
Project Completion
Duration
Deliverables
- Migration of data and applications securely without impacting the existing user base
- Using Traffic manager to configure routing to 2 different websites
- Adding Auth0 with Traffic manager routing traffic to different domains
Testimonial
Evania Fernandes
building Manager
ultimate property group
Next Phase
If You Are Looking For Similar Services? Please Get In Touch
Executive Summary
About Client
Since 2015 BAC has been instrumental in evolving and simplifying the customer experiences of forward-thinking organizations across Asia Pacific, Europe, North America, the UK, and Ireland. BAC helps organizations unify their people, processes, and technologies to deliver industry-leading customer and employee experiences. BAC enables you to leverage technology to align your sales, marketing, and success teams, so you can make the most of every interaction, even as you grow. We supported the client with SAP Integration with Hubspot.
Location: Sydney, NSW
Project Background
This case study has details about how we designed and developed the integration of SAP with
HubSpot system. In this case study, we list the APIs we used and how we enabled initial and
delta load, including the configuration we did in HubSpot. Overall, a new DB instance needs to be created (DB-2) that will take data from DB-1 (based on some pre-defined business rules) and feed selective data into the HubSpot CRM instance.
This new database must be created from the client’s existing SAP Central Management System (CMS) instance. The new database needs to comply with the existing pre-defined entity-relationship model. The initial data dump will happen from the CMS to the new database (as shown below).
Also required is syncing batch routines to sync to the said database with SAP post-dump. Finally, this new database needs to be integrated into HubSpot. To list down the objectives:
- Ability to send initial and delta load in the Hubspot system
- Send Contacts, Organizations, and deals data to Hubspot
Scope & Requirement
- SAP Integration with Hubspot APIS
- Integrate solution design to match the requirement
- Make it configurable to run for multiple clients on Hubspot
- Integrate it via a scheduler to run as a Batch Job can be done via Logic Apps, Cron Jobs etc.
- Get the data synced to Hubspot daily for contacts, Companies and Deals
Implementation
Technology and Architecture
Technology
The migration was deployed with the below technological component
• For Azure Dataverse- The underlying technology used was Azure SQL Database
• For Azure Blob Storage- It supported the most popular development frameworks including Java, .NET, Python & Node.js
Security & Compliance:
- Tagging Policies
- Azure config for compliance checks
- NIST compliance
- Guardrails
- Security Hub
Backup and Recovery
Azure Backup provided a simple, secure, cost-effective, and cloud-based backup solution to protect the business or application-critical data stored in Azure Blob in two ways- Continuous backups & Periodic backups
Network Architecture
- Site to Site VPN Architecture using Transit Gateway
- Distributed Azure Network Firewall
- Monitoring with Cloud Watch and VPC flow logs.
Cost Optimization
- Alerts and notifications are configured in the Azure cost
Code Management, Deployment
- Cloudformation scripts for creating stacksets and scripts for generating Azure services was handed over to the client
Challenges
We encountered some issues as below:
- Ensure the data is correct as the Contact, company and deals may have mandatory fields which needs to be filled in to ensure that it does not fail when creating the record via API Example name is mandatory for Person
- Ensure the Daily Quota Limit for the API is within the threshold if there are more records to be created it would need to be spaced out.
- Since the calculated field value was dependent on todays date so even if there was no update on the customer but the last order date remained the same we had to run a delta load as a script to update all Contacts records because days since last sale would have been T+1 each day.
- The integration was placed in VPN so we were not sure if It is going to run unattended or not it initially kept crashing but later we were able to move it to a stable zone within the network so it could run 24*7
Project Completion
Duration
Deliverables
- Integration code base
- SAP system integrated with HubSpot
- Batch scheduled to run daily and real time for some scenarios
- Initial Data Loading
Support
- We helped Customer to get the systems integrated using which they could do better lead management based on analytics in HubSpot
- The integration ran without any issues after Go live and we provided support of 2 weeks
- Same code based was used by the client to integrate multiple other similar customers they had
Testimonial
Awaiting
building Manager
Bacpartners
Next Phase
If You Are Looking For Similar Services? Please Get In Touch
Executive Summary
About Client
COMMANDO has over 20 years of experience working for leading LGBTQ+ dating apps. They help to position your regional, national, and local businesses to succeed in reaching such dating audiences on social and streaming video platforms.
Some of the services that they provide are social media, mobile web, dating apps, video streaming, and designs that convert.
https://www.runwithcommando.com/
Location: California, America
Project Background-Pipedrive Support, Implementation & Customization
Runwithcommando came to Peritos with a requirement for Pipedrive support to manage their leads, and transactions, track communications, and customizable analytics. They wanted to implement the Pipedrive system to customize their business operations and processes.
Scope & Requirement
In the 1st Phase of the pipedrive support and customization, implementation was discussed as follows:
- Automating repetitive tasks to create streamlined sales process for their team
- Get automated behavior based hints on how to boost results
- Crucial KPIs and reports to track team progress
- Integrate sales and customer data
- Technical Consulting
Implementation
Technology and Architecture
Technology
The web app was deployed with the below technological component
- Backend Code: .NET Core, C#, Node.js
- Mobile App code: React Native
- Web App code: ReactJS
- Database: SQL Server, MongoDB
- Cloud: Microsoft Azure
Integrations
- Migration from an on-premise database to Online Student, Teacher, Subject database
- Single Sign-on using Auth0
- Sendgrid
Security:
- Data Encryption
- Multi-Factor Authentication for Admin, Teacher, and students when logging in
- All API endpoints are tokenized
Backup and Recovery
Cloud systems and components used in the attendance management system are secure and 99.99% SLA. We have added HA/DR mechanism to create a replica of the services
Scalability
Application is designed to scale up to 10X times the average load received in the 1st 6 months of its usage and all cloud resources are configured for auto-scaling based on the load
Cost Optimization
Alerts and notifications are configured in the attendance management system to notify if the budget is being exceeded. Peritos being a cloud partner is managing the environment for the client keeping a close watch on the cost and finding ways to optimize the same
Code Management, Deployment
Code for the app is handed over to the client through Microsoft AppCenter.
CI/CD is implemented to automatically add, build and deploy any code changes
Features of Pipedrive Support, Implementation and Customization
- Helps to automate repetitive tasks to create streamlined sales processes.
- Connects Pipedrive to other software and develop custom features with the free API key
- Push real-time updates in Pipedrive to the endpoint
- Offers customizable reports and interactive dashboards
- Helps to create CRM fields for reports and decisions based on your reports
- Track crucial reports and KPIs in one place
- Monitor team progress at a glance
- Integrate sales and customer data with your preferred reporting tool
- Track emails, calls and contact history
- Grow an unlimited database of contacts and organizations
- Leverage full potential of cloud ecosystem with end-to-end management system
Challenges of pipedrive Support, implementation and customization
- Achieving similar results from one camera while the same results in an actual game are received using hawk-eye technique that uses six cameras. Achieving accurate results from the app each time was dependent on the background noise and the position of the camera and device quality.
- We informed user if the camera quality and device was not compatible for 240FPS and slow-mo recording was not available we did not allow them to download the app. A list of supported devices was also released on the Machineroad’s site.
- Ability to process videos recorded in different environments under different lighting conditions and pitches
- We did Machine learning for which we trained the model in different conditions like day and night, Outdoors and indoor etc. But it was difficult for the app to pick a new location and pitch automatically if it was different from the models on which it was trained.
- User needs to align the pitch with the camera and orientation of the camera should also be accurate else the results gets impacted.
- Help screens were implemented to inform user on the orientation and Video tutorials were released by the client as well so users can understand how to get the best results from the app.
Project Completion
Duration
April 2020 – Sep 2020 ~ 6 months
Deliverables
- UX Design of the attendance management system was delivered after which the scope was confirmed
- Web App unit tested with a How to Document Guide and FAQ on some common issues that might be faced in using the app by the Students, Teachers and Admin
- Knowledge transfer with Train the Trainer sessions to train super users who further trained the staff members
Support
As part of the project implementation, we provided 1 month of extended support. This includes any Major / Minor bug fixes.
Testimonial
GROUP CEO RunwithCAmmando
Next Phase
We are now looking at the next phase of the project which involves:
1. Ongoing Support and adding new features every Quarter with minor bug fixes
2. Web based module to have admin be able to mass Upload teacher, students
3. Mobile App for the students and teachers to mark attendance on the mobile phone
