The agency has embarked on a multi-year effort to implement an agency wide BPM solution to include vendor integration, web services, mainframe integration, custom ASP, JAVA and .NET development within the Metastorm Suite of products. TTI’s technical expert is engaged in supporting the Personnel Systems Division (PSD) mission to leverage the Metastorm BPM platform, Cognos 8.0 BI suite, SQL Server 2005 and SSIS. The PSD provides all HR data warehousing, reporting, process development and deployment for Customs and Border Protection (CBP) as well as Immigration and Customs Enforcement (ICE) and Citizenship and Immigration Services (CIS) in a shared services environment. TTI’s deliverables include:

• Mapping and automating workflows using Metastorm BPM Designer (v7)
• Modify existing workflows to support changing mission requirements (v7)
• Creating browser and server scripts (VBScript, JavaScript, .NET) in support of workflows
• Iterate with the end customer for process improvement using agile methodology

Develop complex SQL queries, views and stored procedures on the SQL Server 2005 platform