WPIC Department of Psychiatry Office of Academic Computing

1. WPICDepartment of PsychiatryOffice of Academic Computing “IT Support for the WPIC Research Community” OAC@upmc.edu 6-WOAC

2. OAC Services Shared Applications WebDataXpress, SharePoint, Double-data and “Paperless” data entry, SQL Server Reporting Services, … Custom Applications Database design, Access front-ends, Performance tasks and subject stimuli, signal analyses, web-based applications, … Training and Support Correcting and improving SQL Server views and procedures, tuning Access applications, customizing third-party software, … Operations Support for workstations, web servers, file and applications servers, backup, networks, security, third-party software, …

3. Applications Team • Jack Doman, Director • Eight staff members with over 80 years total experience • Programming experts in SQL Server, Access, C++, shell, ePrime and many others • Team approach provides code review and re-usable, object oriented development • Programmers sharing development work means there’s no single point of failure • If one is unavailable, another assumes development and maintenance • Code is written under shared standards and naming conventions • Support provided throughout the research project’s life and subsequent analyses

4. WebDataXpress • Web-based data entry directly into SQL Server tables • Driver table driven data entry forms automatically created • Customization requires only SQL query skills • Encrypted, fully authenticated, securely behind a firewall • Adapted for “paperless” subject and clinician entry • Custom controls can be developed by OAC staff • Development for tablet and handheld devices

5. SharePoint • Web-based team communication, document management, database system • Integration with existing SQL Server databases • Customization, training and consultation available from OAC staff SQL Server Reporting Services • Web-based reports directly from SQL Server databases • Parameterized, easily designed reports • Encrypted, fully authenticated, securely behind a firewall

6. Custom Applications • Web-based, Windows and LINUX applications • VisualStudio.NET, BASIC, C#, C++, Access, Java, and many others • Utilizing version control • Systems to automatically distribute Access front-end and application updates • Integration with SQL Server and Access databases • Signal analysis and time series data management • Specialized LINUX/UNIX or DOS scripts • Data collection on PDA and other handheld devices

7. SQL Server • Database design and training • Redundant (“double”) data entry system • Assures information accuracy • Monitors data entry staff performance • Data change logs • Custom triggers, procedures, functions, views • Automated e-mail notifications based on customized database events • Convert tables and databases from Access and Excel to SQL Server • Scheduled execution of custom data processes

8. MRI processing and analyses • ePrime and .Net applications for subject stimuli and response • UNIX/LINUX scripts for data processing • Programs for image file conversions, repairs and analyses • Scripts for image file processing and transfers

9. Training and Support • Frontpage, SharePoint, other web design tools • Access applications development and troubleshooting • Microsoft Office • SQL Server and Transact-SQL consultation • Solve SQL errors and performance problems • ODBC to SQL Server and other data sources • Data transfer and re-formatting • Teleform forms design and processing • Implementation of file version control • IT needs and descriptions for grant applications

10. Operations Team • Marty Neidig, Associate Director • Seven system administrators and PC specialists with over 65 years experience • Providing all hardware and software support for research (ISD does not) • Our team approach assures coverage regardless of vacations, turn-over, etc. • Trained in the UPMC operating system and networking standards • Skilled at navigating the UPMC firewall and security systems

11. Workstation Services • Installation of all new computers • Provide equipment from recycled inventory • Hardware troubleshooting and repair • Facilitate software upgrades • Dispose of obsolete equipment (HIPAA compliant) • Research calls to ISD’s Help Desk are sent to OAC • Support of software such as SAS, SPSS, Photoshop • Manage the Department’s Microsoft licensing • Consult and approve IT purchases • Laptop and wireless broadband card are available to lend to traveling faculty

12. Servers • Administer Windows and UNIX/LINUX servers • Servers used for file database, application, web and file transfers • Design and administer high performance clusters for compute intensive tasks • Design and maintain server security • Customized security extensions for databases and file systems • Nightly backup of file shares and databases • “Point in time” database recovery system • Repair and archive Outlook Personal Folders • Performance monitoring and tuning of all servers • Manage disk use, particularly on high-capacity servers

13. Web and FTP services • Public web server: www.wpic.pitt.edu • Secure, encrypted and fully authenticated Intranet web services • Intranet web sites for data entry • SharePoint servers for collaboration with groups outside of UPMC’s network • Automated systems for secure data transfer of image and database files

14. Networking, Security and Accounts • Assist user account usage at UPMC and University • Create security groups, used to define permissions, managed by project leaders • Coordinate virtual networks (VLAN) within University and UPMC infrastructure • Negotiate firewall rules to enable secure connections between UPMC and Pitt • Develop UPMC Security Plans to facilitate collaboration with other institutions • Manage network needs for research facility moves and changes

15. Office of Academic Computing • Highly skilled and experienced IT professionals • Stable staff and team-based philosophy means consistent and long-lasting support • Experts in negotiating the UPMC and University networks, firewalls, security plans, purchasing, … • Workstation, server and Intranet support • Custom and shared applications development and maintenance • SQL Server training and support