IT Solutions Group, Inc.

Sample Projects

Kaiser Permanente, Corona, CA

Kaiser Foundation Health Plan (Kaiser Permanente) is the largest not-for-profit managed health care company in the U.S. with more than 8.2 million members in 9 states and the District of Columbia. Kaiser Permanente, an integrated health delivery system, organizes and provides or coordinates members' care.  Kaiser serves more than 8.2 million members through its network of 136,000 technical, administrative and clerical employees and 11,000+ physicians.  Kaiser's hallmark has been its ability to integrate the elements of health care, its physicians, hospitals, home health, support functions, and insurance into the countries largest integrated health care delivery system.

My development work was for a new division of Kaiser titled the “Deductible Product Service Team” (DPST) located at Kaiser’s Corona, California Call Center.  My primary responsibility was to review the Business Processes of the DPST and to design and implement IT based solutions to streamline their daily operations.

·         Design, develop, document and train on a MS Access 2000 front-end and SQL 2000 back-end database Application named the “DHMO OutReach” Applications.  Functionality of the Application included:

·         Daily automated imports of Main Frame data extracts.  The Application imports text files, parses them into SQL tables and creates and emails custom reports via Lotus Notes.

·         Payment Plan tracking module that would allow the DPST team to track Member payment plans for DHMO services.

·         Time Adherence tracking for DPST Call Center employee’s to determine incentive bonus on scheduled versus worked hours.

·         Design and development of a .net Application that utilized SQL 2000 Reporting Services for creating web based Management Reports on the productivity level of the DPST.

Carl Karcher Enterprises,  Anaheim, CA

Carl Karcher Enterprises. is a wholly owned subsidiary of CKE Restaurants, Inc, CKR of Carpinteria, California. As of the end of its 2004 fiscal year on January 26, 2004, CKE Restaurants, through its subsidiaries, had a total of 3,250 franchised or company-owned restaurants in 44 states and in 14 countries, including 1,006 Carl's Jr.(R) restaurants, 2,121 Hardee's(R) restaurants and 102 La Salsa Fresh Mexican Grill(R) restaurants.  IT Solutions Group, Inc. was contracted to provide the following development services;

  • Redesign of an existing in-house MS Access 97 front-end and SQL 2000 back-end database for the Franchise Administration Department that was used by both domestic and International users.  The original Application had been developed for both an MS Access front-end and back-end.  The data file was subsequently upsized to SQL 2000 and was no longer functioning.  The project involved a complete re-write of the Application and involved developing a formal Software Requirements Specifications document, Users Manual and Developer Manual.

  • Development of a Hardee’s Remote Data Management System that was a replacement for third party software that was no longer supported.  The purpose of the Application was to automate the download of 100’s of Point Of Sale related text files to the various restaurant locations throughout the United States.  The Application would allow the User to select from dozens of criteria to target the destination stores to upload.

  • Development of a Software Specification Requirements document for the conversion of the CKE Distribution Center payroll application.

 

MCR, Federal Inc.,  El Segundo, CA

MCR, Federal is a division of AT&T and provides Defense Department Contract Management and Administration Services for multi-million dollar defense contracts.  MCR was finalizing the conversion of their in-house “Contract Management Account Reconciliation System” (CMARS) Microsoft Access 2.0 Application into a Web enabled VB/ASP front end with data stored in Microsoft SQL 7.0. All reporting was Web formatted via Crystal Reports Version 8.0.  IT Solutions Group. Inc. was contracted to assist in this conversion by providing development services in the following area's;

  • Conversion of the existing Access 2.0 queries into SQL 7.0 views and stored procedures;

  • Conversion of over 100 Access 2.0 reports into web enabled Crystal Reports 8.0 reports;

  • Designed a workstation based Access 2000 database system for use in tracking contracts for the Strategic Missile Command at the Los Angeles Air Force Base.

  • Designed a Visual Basic 6.0 .dll incorporating Crystal Reports 8.0 forms and designers that was incorporated into their existing Access 2.0 system for interim use during the conversion.

 

Downey Savings & Loan,  Newport Beach, CA

Downy Savings & Loan was upgrading its “ALPS” Automated Loan Processing System.  IT Solutions Group, Inc. was contracted to develop an Automated Regression Test System (ARTS) MS Access 97 Application for both its current ALPS system as well as the upgraded system.  The purpose of ARTS was to test and document all changes in Loan and Loan/Investor Guidelines in ALPS by the User Acceptance Test Group (UAT) of Downey.  Prior to ARTS, all changes had to be tested by hand and could take a significant amount of time prior to implementing changes into actual Production.  In addition, IT Solutions Group, Inc. was responsible for creating a GUI interface for the data porting of the old ACCESS data into the new ORACLE data tables. 

Accomplishments included;

  • Development of ARTS Functional Requirements Document that outlined the basic design and functionality of the proposed system.

  • Designed the logical and physical structure of all tables, fields and relationships required for the ARTS system.

  • Design and programming of the ARTS User Interfaces.

  • Design and programming of all required reports.

  • Installation, training and formal documentation of the ARTS System.

  • Assisted in the development of the data porting User Interface used to transfer the existing Access data into the new ORACLE data tables for implementation of the new ALPS System.

 

Disney,  Anaheim, CA

IT Solutions Group, Inc. was contracted to modify a “Sales Incentive Program” (“SIP”) application that was developed in house by Disney’s Marketing /Finance Department.  The System is used to calculate individual management bonuses for various sales activities within the Disney organization.  The system was developed in MS Access 97 and was originally separated into 7 different databases with dozens of tables and nearly 100 different queries. 

Accomplishments included;

  • Reviewed and normalized the database by eliminating tables with duplicate data and adding unique id fields;

  • Designed SQL stored procedures to reduce network access loads and improve efficiency;

  • Consolidated all 7 databases into a single database;

  • Eliminated over 60% of the queries by consolidating them into more sophisticated SQL statements;

  • Designed a menu driven User Interface that automated the import and updating of the tables;

  • Designed reporting solutions for producing commission and estimated payout reports via Crystal Reports;

  • Reduced data collection and report preparation time by over 60%.

 

“Fore-Golf” Database Management System,  Laguna Hills, CA

IT Solutions Group, Inc. developed the first Microsoft Access Database Management System designed exclusively for the direct marketing golf equipment industry.  The application, named the “Fore-Golf Database Management System”, provided users with sales order entry, inventory management, sales commission calculation and tracking as well as customer service modules.  The application was originally created as a Workstation Application in Microsoft Access 97.  It has since been upgraded to Access 2000 and has been modified to accommodate upgrades to SQL Server “back end” databases with Access User Interface “front ends”.  The application has been successfully marketed, installed and maintained for over a dozen major public and private golf club manufacturers.

Home Page