The healthcare industry provides health care and related employee benefits, most of which are offered through the workplace. These benefits include various health plans (HMO, PSO, PPO), dental, behavioral health, vision, and prescription drug benefit plans. In recent years, the healthcare industry has experienced tremendous changes with focuses on regulation, rising costs and finding ways to provide cost effective coverage to an ever growing number of uninsured people.
Conducted an enterprise wide Cognos current state technical infrastructure/ Cognos Enterise Planning performance assessment. Successfully delivered an executive summary presentation of assessment findings, recommendations, and next steps, a Cognos Enterprise Planning Performance detailed findings and recommendations documentation.
SBS consultants provided business analysis, development, database administration and data modeling support in the development of and migration to a large scale and highly complex data warehouse, which supported claims, admissions, billing and provider data.
Hand Held Integration
Designed and developed the Front End Interface for a handheld device for a large healthcare corporation. The handheld device contained the doctor's dictations, schedule, and prognosis. The project was designed to incorporate the data within the handheld device to that of a database through a web interface. The interface also contained the capabilities for the user to setup practices for each doctor.
Utilities & Energy
The Utilities Industry is a vast segment of the American business landscape, providing electricity, natural gas, water, telephone, cable television and internet services to most of the nation’s residential, commercial, industrial and transportation customers. While all utility segments are uniquely different in many ways, they all share a common charge of delivering the most cost effective and reliable service in a 24/7 environment.
SBS developed a full service EDI gateway solution, capable of integration with existing in-house systems, whose primary goal was to allow successful EDI communication to occur with trading partners in multiple states, utilizing multiple versions of the ANSI standards, while interfacing with the customer billing system. SBS conducted all the EDI Mapping, converted all transactions to/from a common file format, and handled all the error handling and exception processing for all EDI transactions in compliance with the ANSI standards. The final product was an end-to-end EDI solution that operated independently on a scheduled basis and required minimal routine maintenance.
SBS developed a multimedia Systems Operator and Dispatcher Training program for an electric utility company which provided them with selection screening tools to allow employees outside the traditional Substation and Power Delivery groups to apply for and successfully become System Dispatchers, and to provide a more formal training program for new System Dispatchers. SBS capitalized upon the institutional knowledge of the existing Subject Matter Experts and leveraged various existing training materials, and delivered both a “stand and deliver” classroom curriculum, as well as a self-paced, multi-media training platform.
Business Process Redesign and Training
SBS performed JAD facilitation and Business Process Reengineering (BPR) services to redesign the Enterprise-wide Core Process Model, and authored a Process Development Guidebook for an electric utility company. In addition, SBS developed a tiered training schedule and conducted the enterprise-wide Process Overview training for over 600 personnel.
With baby boomers preparing to leave the workforce in droves in the coming years, this utility needed to prepare Knowledge Transfer Plans for 18 core business roles. SBS provided the methodology for developing task analysis and skills assessment using the Job Task Analysis process. Through a series of facilitated focus group sessions, SBS defined and established a methodology to capture data from the sessions that assisted in developing Knowledge Transfer Plans, provided guidance to the existing Knowledge Transfer team, facilitated sessions (Initial and possible follow-up) with Subject Matter Experts (SME’s) for all 18 positions, compiled all findings from sessions and provided overall recommendations for assembling a proto-type Knowledge Transfer Plan that included tracking and validating results.
Smart Grid Initiatives
SBS has supported electric utilities in a number of Smart Grid initiatives. Such engagements include the facilitation of the requirements, RFP development and vendor selection for both a new two-way communications “smart” meter, and a new Meter Data Management solution.
Insurance and Financial Services
The Insurance and Financial Services industry provides products and services that help individuals and businesses mitigate risks associated with various hazards and loss of income through disability and death. The industry consists mainly of insurance product carriers, and agencies and brokerages. The products provided by the Insurance and Financial Services industry include personal and commercial property casualty, disability, life, securities, mutual funds, annuities and other various retirement plan products. The core business functions of this risk mitigation industry are sales, policy underwriting/administration, premium investment and risk management, and claim adjudication. In addition, this industry also includes additional related services, such as claim adjustment and third party administration of insurance and pension funds.
SBS was engaged to perform an analysis of the current document management processes of a Claims Processing Company and make recommendations for a future state enterprise document management solution. This company’s business was highly dependent upon the creation, distribution, receipt, and processing of documents. SBS indentified early on that the efficiency and effectiveness of all business processes and solutions related to document management were critical to the company’s continued success and profitability. SBS’ analysis and final deliverables included documenting the current state environment, making recommendations for a future state model and producing a roadmap for achieving that model.
In order to make effective recommendations for a future state, SBS first had to gain a solid understanding of the current practices, procedures, and systems focused on document management. As a result of that analysis, SBS identified several key challenges that had the potential to hinder and/or prevent the achievement of any future state model. For example, the current business processes were found to be labor intensive and inefficient, which, among other concerns, resulted in the inefficient use of resources, such as labor, paper and postage.
The results of the current state analysis indicated that the appropriate future state model needed to take advantage of the tremendous opportunities to improve processes, increase effectiveness and efficiencies, and drive down costs associated with producing and supporting claim applications.
The future state model that SBS developed included a unified view of the end-to-end process of screening, preparing, and producing claim applications that increased the probability for success. The future state model focused on automating tasks, reducing workforce requirements, eliminating bottlenecks, and improving process and system controls.
SBS developed a holistic approach in developing the roadmap to the proposed future state that was attainable within a 12 to 18 month window. This included “locking down” current business processes and implementing a change management procedure for any future process changes, as well as placing on hold any near term changes to processes and supporting systems until controls were implemented and a clear strategic direction was defined and agreed upon.
Provided Hyperion/Brio Administration and Development for a large, multi-line insurer, including converting existing reports from Crystal to Brio, creating new reports and EISs/Dashboards for existing and new reports, posting reports on OnDemand Server to be accessed and to be run by the users on the web, maintaining Hyperion Reports Repository in creating/deleting items, managing database connections, exporting/importing report objects, and managing the security of repository objects.
As the Data Warehouse ETL/BI Technical Architect, SBS conducted design and implementation, including star schema modeling, data transformation and Cognos 8 BI, developed automation products supporting corporate data security and compliance, installed and configured the Cognos infrastructure, and employed Cognos 8 Advanced Automation Deployments (security, scheduling), while performing Cognos 8 BI Security and SDK work.
Business Process Redesign and Project Management
As the BPR Facilitator, SBS managed a corporate wide process redesign and selection effort for a comprehensive software distribution tool, for Intranet and Internet distribution. SBS Concurrently led a project to streamline server management operations in order to implement enhanced server monitoring and management. SBS successfully completed initial phases of both projects, defining scope, objectives, current environments, bottlenecks, redundancies, requirements, and initiated an elaborate RFP process.