Client: State Public Safety Agency
Challenge: Consolidate three victim compensation applications into a single web-based application.more +Ferguson’s process: Design a new database schema to accommodate data elements from three disparate systems while enforcing consistency. Build data migration scripts to migrate data from the existing AS400 and MS Access data stores. Design and develop the new web application and web service architecture. Design and develop reports to provide business intelligence and mail-merged letters. Develop an online user guide and context-sensitive help for the new application.
Technologies used include: ASP.NET MVC 5, VB.NET, jQuery, Bootstrap, WCF, Entity Framework 6.1, SQL Server 2012, SSRS.
less -Client: National Telecommunications Company
Challenge: Replace two existing accounting WinClient applications to be fully web-based so they can be easily migrated to a remote data center.more +Ferguson’s process: Re-design and develop web applications and web services for managing channel lineups and tracking program expenses. Set up disaster recovery environments for these applications.
Technologies used include: ASP.NET MVC 4, C#, jQuery, Bootstrap, WCF, Entity Framework 6, SQL Server 2012.
less -Client: International Beverage Company
Challenge: Enhance container manufacturing plant’s end-of-line systems to support an additional manufacturing line.more +Ferguson’s process: Update warehouse management system to support the new manufacturing line. Add additional system interfacing with the multiple new PLC’s. Update complaint tracking application to support the new manufacturing line. Update operating plan application to support the new manufacturing line.
Technologies used include: .NET WinClient, .NET Web Forms, RSLinx, SQL Server 2012.
less -Client: Field-Services-Oriented State Agency
Challenge: Alter system workflows, correct ordering system features, and add additional data collection components to an existing vaccine ordering system previously developed by Ferguson.more +Ferguson’s process: Work with agency Subject Matter Experts to identify and document requirements. Design and develop updates in .NET. Design and develop Oracle database updates. Design and develop new and updated Crystal reports. Work with agency to test the updated application, database, and reports. Implement the updated application, database, and reports in production and support transition to agency.
less -Client: Field-Services-Oriented State Agency
Challenge: Perform analysis and recommend a systems solution for the implementation of a new inspection system with mobile capabilities.more +Ferguson’s process: Gather and document business requirements while considering the flexibility necessary to meet the local jurisdiction requirements. Analyze business requirements and document system requirements. Recommend a systems solution focused on data collection with a mobile solution for onsite data collection during an inspection that operates in both an online and offline mode, centralized storage with reporting and analysis services for the agency and their partners.
less -Client: National Telecommunications Company
Challenge: Perform eCommerce integration of sites built on a packaged front-end with back-end processing and connections to both third-party and custom-developed tools and applications. Automate process for front-end deployments.more +Ferguson’s process: Enhance processes and governance for the management of front-end deployments. Migrate data from one environment to another and develop other enhancements. Identify tools and processes for iterative development, continuous integration, and more robust testing. Create an automated process for selective promotion of data from the UAT environment into Production.
Technologies used include: MVP, Bootstrap, SQL Server 2012, Oracle, Entity Framework, TFS, .NET, Java, CVS, Maven, Jenkins, JIRA, GIT, Automic, and Sonar.
less -Client: National Telecommunications Company
Challenge: Enhance accounting data store system (for which Ferguson previously performed a technology refresh) to integrate with multiple financial data providers resulting from mergers and acquisitions.more +Ferguson’s process: Develop interfaces, enhance screens and create new reports.
Technologies used include: Microsoft MVC, jQuery, Bootstrap, SQL Server 2012, SSRS, SSIS, Entity Framework, Ninject, Visual Studio Online / TFS.
less -Client: State Insurance, Financial Institutions & Professional Registration Agency
Challenge: Analyze current systems and processes to create an integrated tax reporting software solution.more +Ferguson’s process: Document current reporting needs as well as needs for improving reporting delivery and service. Develop 14 replacement reports and associated functionality in a new platform. Integrate new solution into VB.NET/SQL Server 2008 R2 tax system. Develop/enhance reports interface to expand the existing tax reporting module. Develop an interface for parameterized queries. Develop an interface for users to run ad hoc queries. Follow Agile Scrum methodology with overlapping three-week Sprints consisting of two weeks development plus one week testing.
Technologies used include: VB.NET, SQL Server 2008 R2, SSRS.
less -Client: State Natural Resources Agency
Challenge: Complete an analysis of hazardous waste program business processes to inform decisions on modernization of program data systems, to advance toward program data standards, and to improve and modernize program business practicesmore +Ferguson’s process: Complete the AS-IS and TO-BE analysis as rapidly as possible while assuring analysis due diligence. Identify and document business processes related to how the progam manages and uses its data. Determine, analyze, and make recommendations for business process improvements. Determine what regulated facility data is managed by program and make recommendations about how to enable program customers to view such data in a comprehensive manner.
less -Client: National Telecommunications Company
Challenge: Develop and implement a new Reporting and Monitoring data store based on prior analysismore +Ferguson’s process: Design the new Reporting and Monitory data store and work with internal resources to develop an approach for replicating data between transactional data stores and the new data store. Review existing transactional data stores to determine changes required to support replication. Develop SSRS reports for the new data store. Configure and test replication between the transactional data stores and the new data store. Implement data store, reports, and replication in production and provide production support.
Technologies used include: SQL Server 2012, SSRS
less -Client: National Telecommunications Company
Challenge: Gather and document functional and non-functional requirements for three phases of development for a Reporting and Monitoring data store/reporting project.more +Ferguson’s process: Document existing automation and online data reports. Identify redundancies and opportunities for consolidation. Design local data store and reports. Design reporting dashboard, including trend analysis. Provide estimates for development.
less -Client: National Telecommunications Company
Challenge: Refresh all the technologies used in a system that automates accounting processesmore +Ferguson’s process: Implement recommendations from previously completed technical analysis/assessment of current technology and system. Follow Scrum methodology with six overlapping three-week Sprints consisting of two weeks development plus one week testing. Leverage design and techniques used for a previous project based on the same technologies. Develop a new client framework for Web front-end applications: Microsoft MVC, jQuery, and Bootstrap.
Technologies used include: Microsoft ASP.NET MVC, jQuery, Bootstrap, SQL Server 2012, SSRS, SSIS
less -Client: State Executive Office
Challenge: Replace existing no-call and consumer complaints system with an integrated systemmore +Ferguson’s process: Build on the information gathered during the previously completed analysis and high-level design to complete the detailed design and development, testing, and deployment of applications, processes and reports for an integrated system. Design and develop framework components that will be used for this project as well as a new case management system. Develop system following modified Scrum methodology that encompasses both development and system testing completed in 3 week Sprints.
Technologies used include: C#, TFS, ASP.NET MVC, SQL Server 2008, SSRS, SSIS, SharePoint 2013
less -Client: State Education Agency
Challenge: Analyze current database structure and systems used by the Agencymore +Ferguson’s process: Interview subject matter experts to document the overall needs and requirements of a new working system used to administer student data, state reporting, staffing needs, service needs, transportation, lunch program, HR functions, billing, etc. Provide recommendations for a new centralized solution. Define requirements, business rules, procedures and reports.
Technologies used include: MS Access
less -Client: Field-Services-Oriented State Agency
Challenge: Provide critical and major support for an inspection systemmore +Ferguson’s process: Respond to user issue requests and develop timely solutions in support of previously developed inspection system used by field personnel.
Technologies used include: Microsoft C# .NET, SQL Server
less -Client: State Executive Office
Challenge: Analyze existing no-call and consumer complaints applications to develop a solution design and specification for an integrated system.more +Ferguson’s process: Analyze and review current systems and processes. Develop design proposal for the replacement system and processes. Provide cost/time estimates for completing development of the proposed replacement system.
Technologies used include: MS Access
less -Client: State Health Agency
Challenge: Design, develop and deploy a new system used to order and manage vaccinesmore +Ferguson’s process: Work with subject matter experts to analyze and design a new vaccine ordering system that communicates through the CDC Vaccine Tracking System automated interface. Leverage and extend an existing Silverlight web application. Develop and test the new system using .NET, update the existing database to support the new system and develop new system reports. Our approach involved a pilot test and then overlapping deployment to users in order to compress the duration of a staged rollout.
Technologies used include: Microsoft .Net, Silverlight, Oracle, Crystal
less -Client: Mental-Health-Services State Agency
Challenge: Integrate a new Learning Management System in to the agency environmentmore +Ferguson’s process: Work with the agency to identify integration points. Design and present detailed technical design describing the integration approach. Develop and test PHP Moodle plug-ins to handle custom authentication workflows and import processes.
Technologies used include: Moodle, PHP, MySQL, Active Directory, SQL Server
less -Client: Information Technology Services Company
Challenge: Update company web site to refresh the site look and feel, leverage newer technology, and simplify maintenance and supportmore +Ferguson’s process: Partner with a design agency to develop the look and feel for the refreshed site. Develop the new web site on the Node.js platform using JavaScript. Develop RESTful services used to accept and expose job postings. Integrate with PostgreSQL for data management. Generate clean and semantic HTML5 using Jade templates. The application was configured and deployed to Heroku, a cloud platform service provider.
Technologies used include: Node.js, JavaScript, Express.js, Jade, Stylus, PostgreSQL, Git, GitHub, Heroku
less -Client: Jobs-Oriented State Agency
Challenge: Design, develop, and test a new web site that provides integrated management and search for jobs, roles, and training programsmore +Ferguson’s process: Build on the information gathered during the analysis and high-level design to complete a plan to complete detailed design, design, and test of a new agency web site that provides integrated management and search for jobs, roles, and training programs. To make the best use of client time and resources, Ferguson Consulting built client interaction into the project schedule, developed the software off-site, then delivered and tested the solution at the client location. The program’s integration with various agency capabilities added functionality and improved service for the public and training providers interacting with the agency.
Technologies used include: Microsoft .NET, Telerik, jQuery, Oracle Database, SQL Server
less -Client: Jobs-Oriented State Agency
Challenge: Complete AS-IS analysis and TO-BE high-level design for a new agency web site that refreshes technology and provides integrated management and search for jobs, roles, and training programsmore +Ferguson’s process: Complete an AS-IS analysis of current agency job seeker systems that provide management and search for jobs, roles, and training programs. Complete a TO-BE design of a single integrated web site that extends the new agency jobs portal, leveraging the technology used to develop the portal, and supporting functionality previously available in several different systems. Document the analysis and design and deliver a summary presentation to agency management.
Technologies used include: Oracle Web Forms, Oracle Database, Microsoft .NET, SQL Server
less -Client: Information Technology Services Company
Challenge: Automate the manual process of posting jobs to reduce effort, increase accuracy, and improve the timeliness of updatesmore +Ferguson’s process: Quickly gather basic requirements for the posting process and develop a prototype of an automated tool to enter job information. Pilot the tool while interfaces were developed to the company internal web site and external posting web site. Convert historical data and provide support during the pilot. Update an interface to support posting to the new company web site.
Technologies used include: Microsoft Access, HTML, XML, SMTP email, MySQL, Node.js, HTTP, JSON
less -Client: Cleaning-Recycling Services Company
Challenge: Assess the use of shop-floor technology and execute a resulting project to design and develop a critical inventory management systemmore +Ferguson’s process: Interview managers and operators who use shop-floor technology, review and evaluate current shop-floor technology, develop requirements for shop-floor technology, identify requirement fits and gaps, develop and document projects to close gaps, and deliver an assessment presentation to company management. As a result of the assessment, proceed with a critical project to quickly design, develop, pilot, and deploy an inventory management system to manage serialized inventory processed by the company for one of their largest clients.
Technologies used include: Microsoft Excel, Hanco TRAFFIC, Maxwell American Contractor, SAP Business One, Microsoft Access
less -Client: Field-Services-Oriented State Agency
Challenge: Design, develop, and deploy a new mobile solution used by agency personnel to gather data during on-site inspectionsmore +Ferguson’s process: Build on the information gathered during the solution assessment through requirements gathering with agency subject matter experts to design a new application used to gather data during on-site inspections by agency personnel. Identify technology that is current, supported by the agency, and integrates with agency direction. Develop the new application in phases with accelerated delivery of initial functionality for early pilot testing by the agency. Support continuous review and knowledge transfer with agency technical personal to ease the support transition.
Technologies used include: Windows Tablets, Microsoft .NET, WPF, Lucene search, WCF web services, MSTest, Crystal Reports, SQL Server
less -Client: Field-Services-Oriented State Agency
Challenge: Assess the technology and functionality provided by a mobile solution used by agency personnel to gather data during on-site inspectionsmore +Ferguson’s process: Review the mobile technology platform and integration with other technology used to gather data during on-site inspections by agency personnel, transfer the data to a central store, and present the data to public users through a web portal. Meet with agency subject matter experts to review issues. Document findings and deliver a presentation to agency management with recommendations on technical and functional direction.
Technologies used include: Windows Tablets, MobileFrame, Oracle, SQL Server, Microsoft .NET
less -Client: International Beverage Company
Challenge: Develop, maintain, and enhance engineering systems across a plant network that relies on a diverse technical platform and routinely uses more than 40 applicationsmore +Ferguson’s process: Our reputation for on-time and on-budget implementation under demanding circumstances was a significant factor in winning this multi-year assignment. Ferguson Consulting was responsible not only for application development and design but also overall project implementation, with deliverables that included building and enhancing interactive websites and tracking systems, converting applications from VB6 to .NET, providing architecture design, reviewing developers’ code for compliance with standards, and helping plant workers understand how to use the new automated tools
Technologies used include: C#, VB.NET, Microsoft Composite UI Application Block, .Net ClickOnce Deployment, Visual Basic, Visual Studio, VB Script, Java Script, Active Server Pages (ASP), ASP.NET, AJAX, HTML, DHTML, Web Services, COM/DCOM, IIS, MTS, C, Oracle, SQL Server, Sybase, Access, SQL, PL/SQL, Stored Procedures, ActiveX Data Objects (ADO), Data Access Objects (DAO), Object Oriented Design, MTS, Crystal Reports 8.5,Visual SourceSafe, Videosoft ActiveX controls, MS Office, Windows XP, Windows NT 4.0, Windows 2000/98/95, Windows CE, Palm OS, Object Oriented Analysis and Design.
less -Client: International Beverage Company
Challenge: Enhance multiple systems to support and coordinate plant-level innovation effortsmore +Ferguson’s process: Provide detailed project requirements assessment, including Fit/Gap analysis and project plans. The client’s business configuration requires that a separate plan be completed for each plant involved in the innovation initiative.
Technologies used include: Mandated use of .NET technology and SAP.
less -Client: National Telecommunications Company
Challenge: Redesign, relaunch, enhance, and maintain a website designed for a targeted customer group.more +Ferguson’s process: Work with the client to enable the website to support weekly marketing promotions to keep it fresh and expand the customer pipeline. Projects include a variety of electronic documents to accommodate customer-oriented quotes, contracts, and service orders and improve sales staff efficiency and productivity. The on-site team includes web developers, web service developers, business analysts and project managers
Technologies used include: Visual Studio.NET 2010, ASP.NET 3.5, VB.NET, C# 3.0, .NET 3.5, LINQ, JavaScript, CSS, ADO.NET, NUnit, Web Services, XPath, XQuery, JQuery, JQuery Plugins, AJAX, XML, XSD, SQL Server 2010, T-SQL, Windows XP, Visual SourceSafe, Silverlight.
less -Client: National Telecommunications Company
Challenge: Update and enhance system used to track programming-related expensesmore +Ferguson’s process: Resolve migration issues by vigorously testing and tweaking an off-the-shelf conversion product used to migrate existing information to the new system. The project’s second phase delivers additional enhancements to the system now in place.
Technologies used include: Visual Studio 2010, .NET Framework 3.5, ComponentOne controls, VB.NET, VB6, Code Architects VB Migration Partner, Microsoft VBScript scripting and control, SQL Server 2005, SQL Server Reporting Services, InstallShield, Visual SourceSafe.
less -Client: On-line Travel Services Company
Challenge: Support was overwhelmed by calls from customers. The solution was to enhance the on-line self-service tools to enable customers to do more for themselvesmore +Ferguson’s process: To develop this high-profile, public-facing website, Ferguson Consulting used Scrum methodology to prioritize work in 2-3 week Sprints that included design, development and testing activities. The customer was able to work with the delivered software by way of a continuous integration process.
Technologies used include: This Java application was implemented using Spring MVC, JSON RESTFul web services, and FreeMarker template engine with support for configurable look and feel and capable of being rendered in over 30 languages.
less -Client: Agency Focused on Energy Assistance for Low-Income Individuals
Challenge: Connect utility providers and users who qualify for energy assistance payments and carry out supporting activities such as applications and payment trackingmore +Ferguson’s process: Work with utility vendors to develop XML messages that handle business transactions and design and develop automated processes to determine benefits, handle customer applications, and support ongoing communications among the administering agencies and utilities. Ferguson designed, developed, and implemented public-facing .NET Web applications and back-end support processes and interfaces.
Technologies used include: Microsoft Visual Studio 2010, Visual Basic .NET; Microsoft MVC; Microsoft SQL Server 2008 R2, SQL Server Reporting Services; Microsoft BizTalk 2010; Telerik UI Controls; Microsoft Team Foundation Server; Microsoft Unity Application Block.
less -