|
We provide service to all levels of government: local, regional, county, state, and federal. (Foreign could be fun but so far no
offers...)
Whether your issues are risk management, workforce training, compliance with recent regulations, project management, task scheduling,
decision support systems, database management and integration, geographic information systems, or even emergency management and disaster recovery - we can help!
Our systems have helped our clients: streamline processes and procedures, standardize and compartmentalize functions, prevent and detect fraud,
collaborate efforts, tackle research and development, maximize revenue, and (best of all) off-set costs!
NOTE: Our experience also covers insurance/healthcare projects involving: HIPAA, Medi-Care, Medic-Aid, Medi-Cal, CHAMPUS, Share-of-cost (SC), ability-to-pay
(ATP), and Eligibility determination. Please see the related pages for additional information.
Some of our government and government contractor experience includes:
- ViPS Inc. for CMS, Woodlawn/Windsor Mill, MD 2006–2007
Participated in the Drug Data Processing System/Integrated Data Repository & Drug Benefit
Calculator (DDPS/IDR & DBC) for Centers for Medicare & Medicaid Services (CMS) Medicare Part D Prescription Drug Program. Led the ETL/BI Reporting Team. Handled project planning and priority
management.
- Sumaria Systems Inc. for USTRANSCOM, Scott AFB O’Fallon, IL 2004 – 2005
Responsibilities: Participated in the TRANSCOM Financial Management
System (TFMS) project for USTRANSCOM. Achievements: Designed and built the TFMS data warehouse in Teradata. Built consolidated financial reporting of TRANSCOM Working Capital Funds (TWCF) among the transportation
component commands (TCC’s): Air Force – Air Material Command, Army – Surface Deployment and Distribution Command, and Navy – Military Sealift Command. Developed the web-based decision
support system (DSS) for USTRANSCOM. Designed the data transport layer connecting TCC-specific Oracle Federal Financials implementations, assorted legacy systems, and a centralized Teradata Data Warehouse with
a WebFOCUS front-end.
- Fort Benjamin Harrison, Indianapolis, IN 2000-2002
Responsibilities: Participated in the Defense Joint Accounting
System (DJAS) project.
Achievements: Created interfaces to provide standardized and consistent reporting for the United States Army and the Department of Defense (DoD) agencies. Compartmentalized and streamlined
the processes and procedures. Provided training in SQL and PL/SQL for Report Writing to end users and peers. Performed SQL tuning for better system performance. Developed software to enhance project
goals. Performed DBA and QA functions. Performance-tuned/streamlined all reports and processes for end of Fiscal Year Reporting, reducing processing time from 3 days to less than 5 hours.
- Hughes Space and Communications, El Segundo, CA 1996-99
Responsibilities: Provide project management and coordination.
Achievements:
Assigned project level responsibilities, and coordinated task scheduling. Headed failure-analysis/test anomaly investigation teams. Chaired Joint Application Design (JAD) sessions for interdepartmental
projects. Trained peers on the use of design software, and participated in design review sessions. Researched and developed improved satellite control systems. Design re-use was explored for
reduced costs and improved time-to-market goals.
- Community Development Department, Burbank,CA 1997
Responsibilities: Generate statistical reports regarding types and licensing
requirements for business operating in the county, integrated the data into the existing Geographic Information System (GIS).
Achievements: This led to compliance with federal and state regulations
regarding sic codes, zoning, safety, land-use, and enterprise zones.
- City of Burbank Information Systems, Burbank, CA 1996
Responsibilities: Tie the city’s many databases together and provide cost-savings to the
city to fund the project.
Achievements: Created new systems for address validation and standardization. This led to easier portability into Geographic Information Systems (GIS), greater control over property
development and planning, and compliance with federal regulations regarding zip plus4. Cost savings from postage and courier delivery helped off-set the costs.
- Modular Devices, Torrance,CA 1995-96
Responsibilities: Provide systems analysis and systems administration.
Achievements: Set
up the system administrator role and related responsibilities. Trained sysops and users on corresponding aspects of the UNIX, development and production environments. Created role-based
authorities. Monitored LAN security and created password rules. Developed shell scripts for user logins for developers and end-users. Analyzed and documented the existing system. Performed gap analysis
and suggested areas for improvement. Handled requests for ad hoc reports. Oversaw the hardware and software acquisition and installation. Provided troubleshooting when necessary.
- Human Resources, Burbank, CA 1994
Responsibilities: Provide DSS during the negotiations between the city and the employee unions.
Achievements: Surveyed the personnel compensation packages of government agencies in the Los AngelesCounty area, which resulted in new, less-costly, compensation packages closer to fair market values. The
Memorandums of Understanding (MOU) that resulted included continuing surveys in order to keep employee benefits as high as neighboring communities.
- Burbank Housing Authority, Burbank, CA 1994-97
Responsibilities: Provided consulting services on a fixed-bid and fixed-rate basis on
multiple, concurrent projects.
Achievements: Designed an integrated database system for the Burbank Housing Authority. This resulted in better tracking of participants at every level of the program, better
reporting, the detection of fraud, and lower penalties imposed by US Department of Housing and Urban Development (HUD).
- Burbank-Glendale-Pasadena Emergency Response System, CA 1993-97
Responsibilities: Participated in the collaboration of efforts
involving local, state, and federal agencies, to provide a comprehensive emergency response system.
Achievements: Migrated data from various platforms; enforced referential integrity and normalization;
implemented federal and county regulations, and integrated the data from several jurisdictions into the existing Geographic Information System (GIS). This led to more timely emergency response efforts and greater
safety for emergency workers. Performed the data analysis and mapping. Designed and developed the hazmat tracking and permit system. Performed the data extraction, transfer, and loading from multiple
sources on different database systems into oracle. Used Oracle for Unix for the graphical mapping and oracle for the mainframe (MVS) for the data warehousing using embedded Oracle/SQL.
- City Manager, Burbank, CA 1993
Responsibilities: Maximize tax revenues from redevelopment areas; minimize costs without affecting service
levels to the community.
Achievements: Identified and investigated discrepancies between the Los Angeles County Tax Assessors parcel listing of Burbank properties and actual properties, resulting in a 7%
increase in tax revenues and an increase in the city’s operating surplus.
- City Attorney, Burbank, CA 1993
Responsibilities: Provide Decision Support Services (DSS) for the cases and public relations efforts.
Achievements: Analyzed the ethnicity, age, gender, length of employment, and salaries of city employees to comply with the Fair Labor Laws. Handled requests in this area by the American Civil Liberties
Union (ACLU) and the US Department of Labor. Areas requiring further study were identified and presented to the city council. Indexed the attorneys' law library, created tickler system for civil and
criminal cases. This led to better preparation and fewer court rescheduling requests.
|
