Brian Wolfe Email & Phone Number

Systems which are used by Cognos Development. Oversee all and design most ETL and warehousing of data as well as managing Rational Team Concert for 1000 users and Cognos BI for internal use.

Last responsibilities were...MS SQL Server 2005 DBA: Design, build and maintain SQL Server environment including stability and performance of the server as well as work with datawarehouse and querying environments.DB2 DBA: Able to build and maintain DB2 environment.Cognos 10 admin: Build, maintain and troubleshoot server issues as well as manage security, capabilities and permissions for users and the system.Cognos 10 Report Admin: Build, manage and troubleshoot reports with complex queries and layouts. Often building prototypes which are then modified for aesthetic and visual standards.RTC Administrator: Thorough understanding of workings of Jazz framework so that can work with Applications group in maintaining good relationship for technical changes which may be required as well as working with development teams to oversee and recommend process and structural data changes. Thorough understanding of the business usage of RTC in development. Maintaining Agile SelfCheck server for BIData warehousing: Design, deploy and maintain data warehouse for development organization. Work with database tools to optimize warehouse performance based on load from ETL and reporting.ETL: Plan, design and implement SQL Server Integration Services 2005 with complex SQL and transformations across multiple application sources. Business: Work through process issues which cross functional boundaries in development. This can be across development functions(qc, dev, program management, etc), or across product groups and deal with understanding and translating the data questions which people ask in business terms as well as process terms into business requirements.Troubleshooting: Troubleshoot data integrity issues as raised by consumers from reports through originating system to determine and report defects in ETL, reporting, modelling or queries. Not only understanding the problem but also determining the proper long term solution.