Bobby Laney Email & Phone Number

- Support reporting and warehouse design efforts using SAS,SQL,SAP, Informatica across DB2, Netezza, and SQL Server environments - Develop, maintain, and support Hedis, NQF and NCQA measures that support the Novant Quality Scorecard- Translate clinical/business specifications into technical specifications for development- Model, create, and load custom data structures and marts to facilitate reporting- Combine Epic EHR data and/or external sources into a common data model to simplify query design for Analytics and Informatics team - Provide recommendations and guidance for new and existing technologies and conversion/retirement of existing processes - Suggest and create development/automation options where none currently exist - Assist other team members as necessary to achieve a positive outcome and eliminate roadblocks

- Support, maintain, and develop source to target mappings from a wide variety of sources- Automate the Informatica ETL process, through scheduling and exception-handling routines- Provide Clarity ETL support, monitoring and SU patch installation - Support the Business Objects batch process for all scheduled report batches- Installed, configured, and monitored the Cogito/Caboodle Epic Data Warehouse during POC phase- Code and test 3rd party survey data loading for the Cogito/Caboodle EDW- Provide support and load the NDW in both DB2 and Netezza - Support the ETL for Siemens Decision Support Software ODS - Act as team lead to train and support new staff - Promote and maintain excellent customer service relationships with existing business partners and Data Warehouse consumers

- Provide application administration support, and maintenance for over 100 applications- Design, code and test system parameters, adaptations and revisions- Coordinate with application vendors to resolve system issues, or enhancements - Create and maintain system documentation and disaster recovery plans- Serve as a liaison between application vendors and business owners- Provide expert information regarding hardware/software requirements for projects

- Develop data extraction, transformation and load programs - Support, maintain, and develop source to target mappings - Automate the ETL process, through scheduling and exception-handling routines- Migrate development ETL processes into production- Work with additional staff to enable data discovery and data validation- Troubleshoot and resolve production problems- Identify and develop processes for integrating data from disparate sources- Provide application administration within Informatica

- Provide clinical / financial reporting from various report writers / BI tools- Extract, transfer, import data from sources to custom applications- Design and support custom front end applications for various departments using Access / SQL Server / DB2- Create / manage applications providing invoicing and billing data- Provide leadership and support for special projects or current business functions such as Disease Management initiatives and Allscripts Touchworks EMR implementation- Responsible for SQL Server group to house, import, and report all external claims data- Work with EMR vendor and project team to meet target deadlines

- Diagnose and repair various hardware related issues- Install software / hardware compliant with corporate standards- Work with vendors and application specialists to achieve call resolution- Troubleshoot software related issues such OS and Application issues - Work with LAN and Infrastructure to deploy devices on the network- Assist managers/employees in project planning to acquire, customize, and place new equipment or applications