Sierra Circuits PCB Manufacturing Cloud Transformation
Sierra Circuits provides quick-turn printed circuit board (PCB) manufacturing and assembly solutions.
Sierra Circuits runs its manufacturing business on a legacy on-premise relational database architecture, but it has begun creating new custom Cloud-resident applications and using modern SaaS products for critical business processes such as CRM and marketing.
RhinoSource coached Sierra’s executive team on Cloud platforms and SaaS applications and created a Cloud-based custom application architecture for the next generation of Sierra Circuits applications on Amazon Web Service (AWS), including Cassanda NoSQL data storage and customer-facing APIs that provide real-time quotes.
RhinoSource also architected and deployed a Snowflake-based data lake where data from Sierra’s legacy SQL Server databases and data from disparate Cloud services are brought together into a single Snowflake analytical environment using Talend Stitch. Sierra uses tools like SQL, Matillion, Tableau and PowerBI to query Snowflake and transform the data to do enterprise BI reporting that provides critical business insights.
Finally, RhinoSource assisted Sierra with CRM process reengineering and spearheaded the data integration efforts for a new Salesforce.com implementation, as well as designed a Salesforce-centric Net Promoter Score (NPS) process to improve customer loyalty and drive company growth.
Products Serviced
SQL Server Database
Apache Cassandra
Talend Stitch
Snowflake Data Lake
Snowflake JavaScript Stored ETL Procedures
Advanced SQL Analyses
Tableau
PowerBI
Salesforce
Marketo
Outreach
SurveyMonkey
Amazon Web Services (AWS)
Services Performed
System Architecture Design
Data Model Review
Data Security Review
Troubleshooting and Issue Resolution
Proof-of-Concept (POC) Projects
Master Data Modeling
Data Lake Formation and Cloud Data Integration
Cloud Application Data Conversion and Data Integration
ETL Development
Enterprise Analytics and BI Dashboard Development
Cloud API Development
DevOps Scripting and Automation
Software Evaluation and Selection
CXO Advisory and Technology Strategic Planning
More about Sierra Circuits: