endorsedCompletedAzure Data Warehouse Migration for Consultancy Practice
Services Covered:
Industry
Business Consulting & Services
Duration
1 month
Budget
Confidential
Start Date
1 March 2019
Team Size
1-5 Employees
Engagement Model
Nearshore
Project Capability Score (PCS)
70/100
Good
Project Capability Score (PCS) estimates how capable Codibly is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS
Client
BIOLAP Limited
United KingdomProject Summary
Codibly migrated a client’s on-premise SQL Server data warehouse to a cloud-based Microsoft Azure environment, implementing programmatic ETL/run-table processes, repointing Oracle source tables, and optimizing performance through repeated testing and scaling. They created scheduled processes for index management and transformations, delivered documentation, and handed over the system to the in-house team. The end client was satisfied and the buyer plans another project with Codibly; the buyer can now effectively manage the platform themselves.
Key Challenges
- Migrate an on-premise SQL Server data warehouse to a cloud-based Microsoft Azure environment.
- Lack of internal IT capacity to perform the migration in-house.
- Need to create scheduling and data-feed processes in Azure because Azure lacked out-of-the-box scheduling facilities.
Project Deliverables
- Integrated programmatic setups and run-tables to orchestrate data loads and transformations to Azure.
- Repointed load tables to source Oracle tables and implemented ETL processes.
- Created scheduled processes to drop/recreate indices and run transformations prior to publishing.
- Performed repeated testing and performance tuning (scaling Azure up/down) to optimize price-performance.
- Conducted a handover and transferred intellectual property to the internal team and delivered documentation.
Project Solution
Codibly designed and implemented programmatic ETL/run-table processes to migrate an on-premise SQL Server data warehouse to Microsoft Azure. They repointed load tables to Oracle source tables, built scheduled processes to manage indices and transformations, performed frequent tests while scaling Azure to find the optimal price-performance balance, and produced documentation. Finally, they conducted a handover session transferring IP and operational knowledge to the internal team.
Project Outcome
- The end client was satisfied and the buyer is planning another project with Codibly.
- The client team can effectively manage and maintain the platform after the handover.
- The team achieved optimized price-performance through iterative testing and Azure scaling.
- Project management (Jira tracking) and the vendor’s project manager ensured smooth delivery and adaptation to scope changes.
Platforms
Cloud
Tech Stack
Azure
Oracle
SQL
Client Endorsement
Overall Review Rating
5
5 out of 5 stars
5 out of 5 starsTimeliness
Cost Rating
Willing to Refer
Quality of Deliverables
“Codibly is reliable and proactive, quickly adjusting to scope changes and speaking up if they think certain project components could be improved. They have excellent project management skills, and the end client was happy with the work.”
Note: This endorsement is based on publicly available client feedback from external review sources.
More Projects by Codibly
Ongoing
Human Resources & Staffing
WorkBuzz Survey Platform Modernization
Services Covered:
+1 more
Agency name:
Codibly
Project capability score:
80/100
Ongoing
Business Consulting & Services
Avatars & WebGL Simulation and Azure Platform Maintenance
Services Covered:
+1 more
Agency name:
Codibly
Project capability score:
80/100
