Government Project Profiles
» Download all summaries as PDF
State of Michigan: Data Center Operations – Configuration Management
Data center Consolidation and Statewide configuration control specialist for DIT UNIX, Linux, Windows and Storage Area Network data processing systems
OpTech’s role in the project
- Plan for Server room migrations into Tier 3 data centers.
- Approve incoming requests from solution engineering for new deployments, changes, and decommissions. Ensure requirements are complete and proposed solutions meet all hosting center standards.
- Review assigned projects and provide guidance on configuration requirements such as: Unix operating system, security zones, clustering, load-balancing, IP addressing, network port usage, billing, naming conventions, rack location, storage area network connectivity, etc.
- Plan for additional infrastructure as required, such as new server cabinets, power, fiber light guides, network patch panels, network switches to support new deployments.
- Plan for installations of standalone IT equipment within the hosting centers, such as Storage Area Network (SAN) equipment, SUN and HP Enterprise Servers.
Technology Platform
Sun Solaris, Windows 2003, Suse Linux, Content Switches, Cisco Switches,
SAN, NAS, Oracle, Sql Server
Tools Used
BMC Remedy, MS Project, CMDB, Aperture, SMMS (ITIL based tools
Processes)
Awards/Accolades
Project team won the 2007 NASCIO award for the Data center Consolidation project. The project closed more than 30 server rooms and Centralized the IT infrastructure
State of Michigan: Avaya Technology Consulting
Project Summary
- Provide experienced software administrator for Avaya Communications Manager systems.
- Daily programming support forMAC's (moves, adds, changes)
- Daily Administration of Octel voicemail systems.
- Troubleshoot and resolve trouble tickets from Help Desk and communicate
with Help Desk and internal customers. - Experienced in ACD call center environment, VDN's, vectors and use
ofCMS (Call Management System) and CMS supervisor. - Provide project support for consolidation of two Avaya switch’s, and other projects assigned by management.
OpTech's role in the project
- Focus is on daily administration support forMAC's, handling incoming trouble tickets and resolving user problems.
- Provide technical knowledge to Help Desk support team
- Maintain and update data in Telecom share drive, and work on voice projects assigned by management.
Technology Platform
Avaya Voice Platforms (G3r, G3SI, System 85), Octel Voicemail System
Tools Used
- Dell PC / Microsoft Office Suite
- Avaya Site Administration
- VDN and Vector programming (Expert Agent)
- CMS (Call Management System)
Awards / Accolades
Help Desk support team received Best State Service Award by Governor Granholm
Ethical Hacking/Security Initiative
Project Summary
Developed various web applications including waynecounty.com, waynecountylandrecords.com, waynecounty.epurchasing.com, and a Katrina evacuee information intake site. Performed vulnerability assessments and penetration testing of various websites.
Technology Platform
Windows 2000 and XP, Windows Server 2003
Tools Used
Visual Studio .NET, Dreamweaver, Notepad, and other security testing tools.
OpTech’s role in the project
Security Analyst / Software Developer
Java Programming Project
Project Summary
Worked on the MICR (Michigan Incidental Crime Report), which records incidents from counties and sends them to the FBI via various third party interactives such as NIBRS. Converted the existing mainframe/linc programming to a client/server based system. This required rewriting the entire MICR system in Java, with an Oracle backend.
Tools Used
Java, J2ee, EJB, XML, XSLT, Crystal Reports, My Eclipse, Cvs, Pvcs, Jboss, Tomcat, Oracle, Data Bridge.
OpTech’s role in the project
Java programming, design, development, implementation and deployment
Report Writing Project
Project Summary
The CMH Link Reporting System is a reporting application that caters to the reporting needs of various departments of Detroit Wayne County Community Mental Health Agency (DWCCMHA). Reports are written based on the end user's requirements and reports are published through a .Net web application.
Technology Platform
Microsoft Windows 2000 Professional
Tools Used
Crystal Reports, PDF, Asp.Net, Ado.Net, C#, SQL Server, T-SQL
OpTech’s role in the project
Write reports in Crystal Reports for Mental Health Agency
Develop new code and support existing code for CMHLink Reporting System application in ASP.NET, C#, SQL SERVER and ADO.NET.
Geographic Information System Migration
Project Summary
OpTech implemented a countywide Geographic Information System. Major projects included an upgrade of the Emergency 911 GIS system, Ortho Image QC, and a migration of the GIS Application.
Technology Platform
Windows 2000, SQL Server 2000
Tools Used
ArcGIS 9.x, ESRI software, VB/ASP. Net/ VBA
OpTech’s role in the project
Developer / Team lead
Project Management, GDLS
Project Summary
Offshore initiative to include account applications adhering to security/ITAR government regulations for sensitive data.
Technology Platform
UNIX
Tools Used
Various software / development tools
OpTech’s role in the project
Oversee Project Management to ensure deliverables are met on time and within budget.
Oracle ASP Property Tax Administration Project
Project Summary
Provided application enhancement and support of the PTA (Property Tax Administration), an Intranet application used by the county treasury department to monitor delinquent taxes. The application features a user-friendly front end.
Technology Platform
ASP, Oracle 8i
Tools Used
SQL Navigator, SQL Plus, Visual Interdev.
OpTech’s role in the project
Senior Application developer, involved in the enhancement and production support of the application.
Offshore Secure Data Initiative and Defense Re-supply System
Project Summary
Offshore initiative to include account applications adhering to security/ITAR government regulations for sensitive data.
Technology Platform
UNIX
Tools Used
Various security tools (confidential)
OpTech’s role in the project
Project Management
Property Tax Administration System
Project Summary
The Property Tax Administration System (PTA) is a web-based intranet application, which deals with delinquent taxes for the county. The application provides functionality to accept taxes, provide inquiry, handle properties in forfeiture/foreclosure, maintain properties in bankruptcy, and conduct auction of the foreclosed properties.
OpTech was responsible for production support, enhancement, user access and creating ad hoc/standard reports.
Technology Platform
Oracle 8i, Active Server Pages (ASP), Visual Basic 6.0
Tools Used
Microsoft Visual Studio 6.0, SQL, SQL Plus, SQL Navigator, Microsoft Access 2000
OpTech’s role in the project
Lead Developer
Avaya Technology Consulting
Project Summary
- Provide an experienced Telecom administrator for Avaya Communications Manager
- Daily programming support of MAC’s (moves, adds, changes and deletes), setting up new users.
- Administration of Intuity and Octel voicemail systems.
- Troubleshoot and resolve trouble tickets and communicate with internal customers.
Technology Platform
Avaya Voice Platforms (G3r, G3SI, System 85)
Octel Voicemail
Tools Used
Dell PC / Microsoft Office Suite
Avaya Site Administration
VDN and Vector programming (Expert Agent)
CMS (Call Management System)
OpTech’s role in the project
Focus is on daily administration support for MAC’s, handling incoming trouble tickets and resolve user problems.
Provide technical knowledge to Help Desk support team
Maintain data base records and work on voice projects assigned by management.
NetRMS (NetRecordsManagementSystem)
Project Summary
This project involves data migration (SQLServer to Mainframe) from NetRMS to AICS Database.
OpTech’s consultant was involved in writing SQL Scripts, performing data transformations, writing transformation code in Java, and writing AntBuilds and Windows batch scripts.
Technology Platform
MyEclipse5.1, Eclipse 3.2, SQLServer2000, DTS, Ant 1.7, JDK1.4.2
Tools Used
Java/J2EE, SQLServer2000, DTS in SQLServer, AntBuilds, Windows Batch Scripting, VB Client
OpTech’s role in the project
Java Developer
Data & Process Modeling, Requirements Analysis Services
Project Summary
OpTech provides Federal Transit Administration (FTA) a team of experts that deliver Requirements Analysis and Data & Process Modeling services. The OpTech team is preparing an “As- Is State” technical data model of the existing Grants database and related processes. The model is intended to provide a common, consistent way of categorizing and describing data to facilitate data sharing and integration, and aid in describing the types of interaction and exchanges that occur within the FTA and between other Federal, State and local governments accessing the system. Over the previous year’s many changes have been made to the system with incomplete or inaccurate documentation.
Technology Platform
Federal Transportation Administration proprietary Grants database system, utilizing ERWin modeling tools.
Tools Used
The OpTech Team is utilizing ERWin as its primary modeling tool and is active in meeting with SMEs within the FTA and outside contractors and agencies to identify new as well as existing processes.
OpTech’s role in the project
Document existing data and processes, support the definition of new requirements, develop new processes, and feed those outputs into the existing FTA change management processes. Meet with all groups interfacing with this system to gather an up-to-date model of the current processes involved in the Grants System.
Recruiting Specialist – Intel Analysts Joint Intelligence Operations Center
Project Summary
PACOM JIOC at Pearl Harbor, Hawaii provides direct intelligence support for all military forces assigned to CRDUSPACOM. The scope of this project is to provide recruitment management support of all on/off island recruitment initiatives for PACOM JIOC. These recruitment initiatives include job fairs, a Cooperative Education Program and an Intern Program. The team members have Secret and Top Secret Clearances and interact with DIA and DOD on-going programs.
Technical Computer Training Project
SPAWAR InTech Training
OpTech is providing SPAWAR InTech Training with ad hoc training services throughout the Pacific Rim. Certified Instructors provide training services in Microsoft certified courses, UNIX, CompTIA, Cisco Training and PC Applications. The main training center is located in Perl Harbor, Hawaii, but the training may also be provided in Japan, and Okinawa.
In some cases, these Instructors need to have Secret or Top Secret Clearances to allow them access to the systems for which they are providing training.
