Category: Process Optimization & Automation

28 Nov 2022
Grant Management Solution Smartsheet Consultant

Grant Management Solution, Enabling Visibility and Insight into the Grant Assignment, Renewal, Approval, and Utilization Process

Optimum Developed a Grant Management Solution, Enabling Visibility and Insight into the Grant Assignment, Renewal, Approval, and Utilization Process. Optimum developed an automated and robust solution for a state sponsored Grant Management organization, responsible for managing grants at over 110 institutions, allowing visibility and insight into the grant assignment, renewal, approval, and utilization process. About […]

Continue Reading
27 Nov 2022
BGRA-Smartsheet and Office 365 Integration Construction Engineering

Project Management Information System Development for a Construction-Oriented Engineering Department: Multi-system integration to provide a stepwise management solution

Optimum Developed a Project Management Information System for a Construction-Oriented Engineering Organization: Multi-system integration to provide a stepwise management solution. About the Client The client is a government organization which handles the water conservation and reclamation district. The Engineering department within this organization is responsible for managing the implementation of various projects and ensuring their […]

Continue Reading
12 Apr 2022
Customized Assignment Management Software Solution for a national Commercial Real Estate Firm

Case Study: Customized Assignment Management Software Application for a Commercial Real Estate Firm

Optimum designed and developed a customized Assignment Management Software Application for a national Commercial Real Estate firm, to streamline operations and support future growth and expansions.   Business Challenge and Project Background Prior to the Optimum’s involvement, the Client was using a combination of various 3rd party software applications, Excel, and emails for their Appraisal Assignment […]

Continue Reading
12 Apr 2022
Compliance Management For Global Investment Firm Microsoft and Smartsheet Technologies

Case Study: Compliance Management Solution for Global Investment Firm, Utilizing Microsoft and Smartsheet Technologies.

Optimum developed a Compliance Management Solution for a major Global Investment Firm, in a record two months’ time to save the firm from major regulatory fines.   Business Challenge and Project Background A new government regulation was coming into effect at the beginning of the year and the Global Investment Firm had only a few months […]

Continue Reading
06 Aug 2021
InfoPath to Power Apps Designer Workflow to Power Automate

Case Study: InfoPath Forms and Designer Workflows Migration to Power Platform

Optimum re-designed and migrated client’s SharePoint Designer Workflows and InfoPath Forms to Power Platform to provide a more robust and modern automation solution.     Challenge/Opportunity Client was using SharePoint Designer workflows and InfoPath forms within an old classic SharePoint site to track daily activities for various business teams. Since those old technologies, which were […]

Continue Reading
09 Dec 2020
RPA for Accounting and Finance P.O

Case Study: Import/Export Company Automates Finance and Accounting Processes with RPA

Challenge/Opportunity Client’s Finance and Accounting team spent many hours on administrating time-consuming and manual processes to generate Purchase Orders (P.O) and Invoices in their ERP system as well as email-based and manual approval processes and communications with vendors and customers. These manual processes were also hard to learn and use for new hires within the […]

Continue Reading
27 May 2020
School-Process-Automation-with-Power-App-and-Flow-Office-365

Case Study: Charter School Automates Summer School Process Using Power Platform and Office 365

Download Full Case Study Challenge/Opportunity Having access to Power Platform in Microsoft Office 365, the charter school wanted to convert their existing summer school 3rd party application and workflows to a more automated and integrated solution using Office 365, Power Apps, and Power Automate (Flow).     Optimum’s Involvement Optimum’s team assessed the migration needs […]

Continue Reading
12 Feb 2020
Emergency Response Workflow Automation Power BI Optimum Consulting

Case Study: Emergency Response Company Increases Productivity and Enhances Reporting Using SharePoint Online and Power BI

Download Full Case Study Challenge/Opportunity The client used manual processes and disparate spreadsheets to track and manage their proposals and contracts. The internal teams created KPI reports manually and using Excel, requiring extensive time and data manipulation. These reports had to be customized for different users on a monthly, weekly, and daily basis and the […]

Continue Reading
30 May 2019
TJJD Office 365 and Nintex Optimum

Case Study: State agency engages Optimum to develop their Office 365 and SharePoint Governance Plan and Framework

Download Full Case Study   Migrating an entire organization’s SharePoint environment to the cloud is no small task! Security, user permissions, information architecture and document library structure, departmental content clean-up as well as existing forms and workflows migrations need to be considered and designed into the destination environment. Most migrations to Office 365 usually cover […]

Continue Reading
21 May 2019
Charter School Process Workflow Automaion Nintex Office 365 Optimum

Case Study: Charter School automates the Summer School selection process

Download Full Case Study Classical Charter Schools prepares K-8th grade scholars in the South Bronx to excel in college preparatory high schools. Through a classical curriculum and highly structured setting, students become liberated scholars and citizens of impeccable character who achieve proficiency in and advanced mastery of New York State Performance Standards. The school offers […]

Continue Reading