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:

Visit the Site→

Previous
Previous

ADT Pulse Smart Home Security Scalable IoT Architecture Design and Operations Support

Next
Next

Social Parent Juggle Labs Social Networking Mobile App Cassandra Architecture