1 / 15

WPIC Department of Psychiatry Office of Academic Computing

Providing comprehensive IT support, including shared applications, database design, training, and operations support for the WPIC research community. Contact us for tailored solutions and assistance.

santanas
Download Presentation

WPIC Department of Psychiatry Office of Academic Computing

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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

More Related