Scott Conrad

Experience

• 

  KBM Software

  Jan 1994 - Jan 2009

  Owner/Developer

  KBM Software provided IT support and development services on a contract basis. SQL database design with secure web integration and handheld software development were some of the projects completed.

• 

  Galaxy Internet

  Jan 1999 - Jan 2001

  Acquisitions Manager

  My primary role with GOLI was to prospect smaller internet providers in order to acquire their client base and connectivity contracts within rural areas of the Midwest.

• 

  T2 Systems

  Jan 2001 - Jan 2002

  Territory Manager

  With T2 I primarily served in an outside technical sales role working with Universities and City government officials. I sold and supported handheld parking permit and citation issuing tools along with Oracle based management software with integrated Web portal's.

• 

  WellPoint

  Jan 2007 - Jan 2010

  Business Analyst Senior

  The Performance Analysis Team holds the primary workload and performance reporting responsibilities for NGS. I helped train and develop staff in unstructured text data extraction, automation and manipulation of large data sets. Sixty percent of my daily routine involved ODBC calls to SQL 05, and Oracle servers then refinement using local access 07 databases to compile operational dashboard reports. Other responsibilities included special project management, testing and validation of system changes, staff mentoring, and quality management. Show less

• 

  KBM Software

  Jun 2010 - Jul 2011

  IT Contractor

  As a consultant I worked projects and contract jobs including website creation, MS Access database development, network troubleshooting, enterprise software upgrade deployment, and technical training.I worked with such companies as: Expertek Inc, Dell Computers Inc, and St Vincent Health.

• 

  Aurora Bank FSB

  Jul 2011 - Jul 2012

  Sr Report Analyst

  With Aurora my duties included database design and maintenance as well as automation projects in support of Attorney Oversight & Quality Assurance. Reporting duties focused on vendor management, performance metrics, predictive analytics, and summarization to senior management. Daily development work utilized Access 10 VBA, SAP Business Objects, Excel, and SQL '08. Approximately thirty percent of work hours were spent managing people and projects.

• 

  Nationstar Mortgage

  Jul 2012 - Mar 2014

  Manager Attorney Oversight and Process Improvement

  Lehman Brothers sold the Aurora mortgage servicing portfolio to Nationstar, at that time I was identified as a key resource and offered a management position. My responsibilities include oversight of the LPS/Black Knight systems administrators, default portfolio automation development projects, attorney performance metrics scorecard, oversight of vendor quality auditors, and performance trending of contracted attorney firms. Due to my extensive SQL & VB background combined with industry knowledge my skills were also utilized for executive ad hoc analysis and limited report/process automation. Show less

• 

  Booz Allen Hamilton

  Apr 2014 - Jun 2015

  Sr Consultant - Staff Technologist

  Sr Consultant - Solutions Architect, Performance Analytics, Automation, Database Developer & Mid-Tier MigrationMy contract to the US Department of Defense addressed executive level financial performance metric aggregation, calculation, and delivery. Historically the high level of security created connectivity struggles therefore business units had disparate communications methodologies making the aggregation of data a very manual effort. Booz Allen Hamilton leveraged my experience with the ETL to overcome the issue's typically related to platform migration into SQL and improved end user delivery systems using SAP and COGNOS. I successfully developed and implemented aggregate automation systems thus greatly reducing manual workload while increasing data integrity and allowing the timely placement of meaningful business data into decision maker’s hands. Show less

• 

  National Government Services

  Jun 2015 - now

  With NGS (primary contacts provide processing services to Medicare claims as a subsidiary of Anthem) I develop workload tracking and analytics using both MicroStrategy and SQL Server Reporting Serivces. Using multiple sources of data (MainFrame flat files, 3rd Party Provided files, T-SQL, PL-SQL, Teradata) I develop automated reporting and analytics tools to drive operational efficiency. I also function as a team lead and enterprise business advisor. In this capacity I help train and coach an assigned staff as well as review submitted innovation ideas. Show less

  • Director of Enterprise Data Services

    Sept 2022 - now

  • Information Technology Infrastructure Architect

    Dec 2020 - Sept 2022

  • Business Information Consultant

    Jun 2015 - Dec 2020