We integrate ERP systems, develop applications, consult on COTS software. Take advantage of our expertise…
- Responsive Web and Mobile Application Development
- C#.Net based applications development
- Database development, maintenance, reporting
- ERP integration, implementation, customization, and production support
- Java development
- We offer new clients three hours free database development consultation. (425) 641-7252
Examples of Recent Projects:
Mobile Shipping Application
Oak Harbor Frieght Lines
Oak Harbor Freight Lines, based in Auburn, WA is a “less than truck load” (LTL) freight service provider. The company makes direct pickup and deliveries within the five-state region of Washington, Oregon, California, Nevada and Idaho, with 1200 employees and 33 service terminals. They also provided nation-wide and Canada service through their strategic partnership with other carriers.
Oak Harbor Freight wanted to improve their customer experience by creating a new mobile application so customers could track their shipments on-the-go. The goal was to provide an application that was ingestible by all types of mobile devices (iPhone, iPad, Android, and Microsoft products), providing the same experience and ease of use. In working with Oak Harbor’s IT team, MACRO.CCS recommended creating a responsive web application with custom, downloadable, widgets. This approach saved both time and money in the development process, as one cross-platform application was created and merely tweaked vs. developing multiple separate native applications. MACRO.CCS’ mobile expert designed, developed, and implemented the responsive cross-platform application which ingested existing shipping APIs and evoked the stylings and overall feel of a standard Apple application. Following completion of the app, we also created all the publishing packages for the application.
Project was completed, along with marketing & instructional materials, on-time and in-budget.
Tacoma-Pierce County Health Department
Tacoma-Pierce County Health Department (TPCHD) safeguards and improves the health of the people of Pierce County through programs to protect the environment, promote food safety, control communicable diseases, and provide public health services.
In pursuit of the last two goals, TPCHD envisioned a website to manage clinics, vaccines, and various related events and transactions. MACRO.CCS designed, developed and implemented this website with three-tier architecture. The website allows TPCHD and its clinics to respond more rapidly and seamlessly to potential health crises such as flu pandemics.
C#, ASP.Net, ADO.NET, SQL Server, Web Services, HTML.
University of Washington
Serving 42,000 students and over 4000 faculty and staff, the University of Washington developed its own default Web mail program, Pine, for this large internal population.
Recently the University decided the tool needed to be modernized and made much easier to navigate. MACRO.CCS’ UI expert designed and created the next generation web mail application, Web Alpine 2.0, which replaced the antiquated Pine system. This project included competitive research and analysis, screen mockups, prototype design, usability studies, iterative design, and final HTML prototype, all done within the original schedule and budget.
This work won the first Annual Mellon Award for Technology Collaboration.
LAMP Web Development
Pacific Marine Environmental Laboratories (PMEL) division of the National Oceanographic and Atmospheric Administration carries out interdisciplinary scientific investigations in oceanography and atmospheric science. A focus of these investigations is open ocean observations which aide in monitoring and predicting the ocean environment.
To support this effort, MACRO.CCS provided software development and Web server administration, allowing scientists across the world Web access to gridded and observational geoscience data sets.
MACRO.CCS developers, graphic designers and system administrators performed their work using Java, HTML, XML, Apache/PHP, JSP, and UNIX scripting, Unix cron, SQL, and Perl.
Data Warehouse Development
Seattle Public Schools
The Seattle Public Schools (SPS) vision is to deliver the right technology district-wide to advance the quality of education. Towards this end, SPS initiated the migration of applications off an ancient, unsupported Vax VMS system. This required implementing an academic data warehouse to provide insights into student performance and customizing purchased school district administration software to handle district admissions. MACRO.CCS’ team of Project Manager and Sr. Business Analyst managed and developed the specifications for this project based on Microsoft technologies and customization of ESIS software to handle district admissions. Our project manager led teams of 3 to 20 people to migrate 4 key business processes off the legacy VMS system, thus enabling operational efficiencies and avoiding major risks of system failure. C# .Net.
Access Benefits Realization Database
King County initiated an aggressive program to upgrade, integrate, and consolidate its financial, human resource, and budget business processes and systems, forecasting many economies from this effort. But they needed to be able to measure the programӳ effectiveness. MACRO.CCS developed an application to help King County evaluate and demonstrate the effectiveness of the ABT program in attaining the financial benefits expected when the project was proposed. MACRO.CCS completed the database successfully, on time and within budget. Support and enhancements continue. Microsoft Access.
Peoplesoft HCM Functional Specs and Testing
King County ABT Program
King County services the needs of approximately 1,900,000 residents. To create greater efficiencies and more effective services in government, King County created the ABT Program to migrate the county to integrated financial, human resource, and budget business processes and systems. As part of this effort, ABT consolidated the county HR systems around Peoplesoft HR version 9 and the Peoplesoft Time and Labor module. Working with King County and the countyӳ integrator, MACRO.CCS functional analysts developed a set of functional specifications related to PeopleSoft Payroll and Time and Labor effecting conversion, customizations, workflow, interface and reporting; developed test scripts, conducted functional testing in the PeopleSoft Payroll and Time & Labor modules, and developed audit queries to validate test results. The team also validated data conversion results and coordinated with county stakeholders on data cleansing activities. They created system and operational documents and mentored the county staff so the county can maintain PeopleSoft going forward.
Oracle EBS Implementation
King County ABT Program
As part of King County’s Accountable Business Transformation Program (ABT), which migrated the county to integrated financial, human resource, and budget business processes and systems, the Oracle e-Business System was implemented county wide to all agencies. The scope of the project included configuring 17 modules and integrating with over 60 side systems. Working with King County and the county’s integrator, MACRO.CCS developers and reporting specialists developed workflows, interfaces, reports, modifications and data conversions, and delivered technical specifications, code and unit test results; developed functional specifications for custom reports, templates and queries; developed and tested those reports, templates and queries, and documented the results, helped with the normal post implementation issues.