Rochester Electronics is the world’s largest continuous source of semiconductors–100% Authorized by over 70 leading semiconductor manufacturers. Rochester's comprehensive semiconductor lifecycle solutions include authorized distribution, licensed manufacturing, and manufacturing services.
The Challenge
Dealing with an ever-increasing number of Bills of Materials from clients, Rochester Electronics decided that it's time to upgrade the BOM maintenance and administration system.
Our team was tasked with system redesign in order to accommodate increasing customer needs. We had to fully grasp how Rochester Electronics operates their business, and also be mindful of their interaction with other clients, because the system would have to communicate with third party API's.
We had to develop a custom tailored web app, which would facilitate easy data manipulation and setup a series of scheduled tasks, which would perform heavy data transactions between the database and large number of BOM's.
The Cape Ann Solution
We created a modern web application, focusing on ease of use, delivering all the requested operations that were to be performed on a BOM, such as entry, edit, deletion, upload and save. App was customized to accept, recognize and be able to modify excel spreadsheets which are commonly used in this scenario. We carefully implemented custom scheduled tasks to perform batch transactions with database, and log if any errors were to happen during transfer. Special care was taken when designing this aspect of the application, because we had to ensure no server clogging would happen at any given time. MEAN stack architecture was used very effectively due to large quantities of data being moved around.
Lu'lu Naturals brand offers all-skin skin care & supplements product line. They were looking to expand their business by creating an E-commerce website which would showcase their products and branding. They approached us to develop this project.
The Challenge
Develop an SEO friendly E-commerce platform with a set of custom functionalities such as custom referrals, custom shipping management and a responsive design.
Customized email notification system with full integration for Amazon, Paypal with payment gateway, integration for Facebook, Twitter, Youtube and Google.
Fully customized account dashboard with various capabilities for management and overview of: orders, personal information, subscription stats, referrals, cart, wishlist, recently ordered items and order history.
The Cape Ann Solution
The first step before starting to work on any project would be investigation. Cape Ann team will identify the project scope, arrange a communication plan with the client, establish how involved the client will be during the project development and then choose the right strategy for development. Considering the number of features client requested to be finished over the six month development duration period, we chose SCRUM Agile to ensure team worked collaboratively with the client and stayed in sync. Along with standard features most webpages would have (login, account management, basic pages like Home, Contact Us, News, Faq, Help, About Us), we developed a custom dashboard, and provided client with fully custom CMS backend system packed with different functionalities like CMS for Information Page and for individual content, ability to view, edit, create and fulfill orders from admin panel; complete invoice management, shipment management, ability to create one or multiple shipments and credit memos per order to allow for split fulfillment, and reporting with ability to print invoices and packing slips. Stack used was ASP.NET 4.5, C#, MS SQL Server 2008 R2, Paypay Rest Api and Amazon payments with Bootstrap, jQuery and Knockout Js on frontend side. The initial production release was completed after 5 months, and the succeeding 2 months were spent refining the product and releasing subsequent iterations.
Schwozny is a company which provides services for data analytics and management to pharmaceutical companies which outsource experimentation to other contract research organizations. Schwozny clients have access to a powerful one-stop, data repository that will increase information content to provide decision making data and ensure timely visibility with potential industry partners.
The Challenge
Analyzing complex data from any pharmaceutical or biology research related business often means you will have to deal with many different picture formats.
Images would have to be modified and enhanced within the tool, so another challenge was developing and implementing such capabilities.
We were given the difficult task of building a tool which would open and display image of any format and size, setting it up for modification and further analysis.
The Cape Ann Solution
Following a period of extensive research during which we focused on the challenge of loading and displaying very large resolution pictures in an quick and effective manner, we came up with a solution which transformed them into a set of lower resolution images with considerably lower size. When user opened any image, an appropriate image from the set was displayed using image tiling techniques based on the zoom he was currently using. This approach was very fast, and images would load seamlessly. Our team then developed a framework within the tool which enabled image enhancement and modification tailored to the users needs. We used breakthrough technologies in cloud storage, computing, and software deployment to deliver the final product. Considering the short time period given for development, agility was a core requirement for our team, and in the end, final product was very well received as it was easy to deploy, very fast, and met the specified requirements.
What Schwozny Analytics said...
Aspects that I have been most impressed with Cape Ann is their dedication to the project, resourcefulness and production of very high quality work. The diligent efforts by Cape Ann have manifest in the production of stellar work product... The work the Cape Ann have performed is exceptional, well-founded mixture of functionality, performance and style.
In 1968 a group of parents established The Wirral Society for Autistic Children, which was the forerunner for our organization today. Autism Together has grown from providing support to people with autism, to providing a wide range of living options, day services and community support to people all over the UK. Autism Together campaigns on behalf of all individuals affected by autism, they encourage all supporters to get involved with fundraising and volunteering. They offer comprehensive training and job development for all their employees.
The Challenge
Autism Together hired us along with another researcher abroad to develop a system which would track and comprehend all the data they record while monitoring individuals with autism. We had to investigate all the data they capture, video feeds, and data collected by third party applications.
We were tasked to develop a tool where all of this data can be presented together in a comprehensible manner and intuitive user interface. This is why the second challenge was designing a tool which would display all this data in a simple and effective manner, where user could easily navigate around the data to discern significant from insignificant or invalid data.
Personnel could then observe and obtain statistics from this data, as well as draw some higher level conclusions supported by this data. Challenge here was to make sure selecting a time slice of data would synchronize between all the recorded data and filter it to that selected time range.
The Cape Ann Solution
We have built a complete application using Angular on frontend and Python on backend side. We developed a full API to handle file upload (video and various data spreadsheets), and also integrated S3 into the app so that files can be downloaded directly from S3 bucket. We gave the client ability to create presentations of data, where they can select which data they want to display on the presentation from all available data. A post-processing filter was added to the tool to validate and differentiate between usable and non-usable data. Video data was displayed in a video player while sensory data was shown on a chart next to the video. Chart was linked to the video so that selecting a point on chart would forward video to that same point in time.
What Lu'lu Naturals said...
Cape Ann delivered an innovative solution for our website to address an issue we had been grappling with for a long time, how to easily and effectively make available the numerous documents we hold on the site to our multiple groups of users. Job done - an excellent result!