John Savas

John Savas

Senior Programmer Analyst

Followers of John Savas196 followers
location of John SavasGreater Milwaukee

Connect with John Savas to Send Message

Connect

Connect with John Savas to Send Message

Connect
  • Timeline

  • About me

    Senior Informatics Analyst at Aetna

  • Education

    • University of Wisconsin-Milwaukee

      1985 - 1989
      MS Accounting
    • University of Wisconsin-Whitewater

      1977 - 1982
      BS MCS - Management Computer Systems
  • Experience

    • Fiserv

      Aug 1982 - Aug 1990
      Senior Programmer Analyst

      Designed and maintained software systems to install a bank’s data onto Fiserv’s on-line databases. Communicated with the bank’s prior computer servicers and analyzed their information systems. Managed and trained programmers in the Conversions Department. Coordinated conversions with other internal departments.

    • Crimson Permanent Assurance

      Mar 1983 - Mar 1983
      Staff Accountant

      Staff Accountant & Pirate

    • U.S. Bank

      Aug 1990 - Jun 1995
      Senior IT Auditor

      Audit Work – Developed audit programs and performed audit tests for financial industry computer systems. Performed audits of system development, implementation, and use. Audited in the areas of systems operations, system administration, physical and logical security, backup and recovery, and system implementation test planning and testing. Prepared and presented audit reports to senior management.System Support & Development Work – Provided technical support and network administration for internal audit division. Provided on-demand consulting, support, and troubleshooting for PC, LAN, and other information systems. Developed and maintained procedures for PC and LAN administration. Implemented and administered a Lotus Notes-based audit workpaper system. Trained staff members for systems use. Developed computer programs to provide independent mainframe system reporting. Show less

    • WellPoint

      Mar 1999 - Aug 2008
      System Analyst

      Developed, administered, and supported systems for processing, analyzing, and reporting medical claim, enrollment, sales compensation, and related information for insurance and financial analysis. Developed and supported systems using SQL Server, Microsoft Access, Visual Basic, Business Objects, and other tools.

    • ICare - Independent Care Health Plan

      Aug 2008 - Nov 2012
      Data Analyst

      Develop and support systems for analyzing and reporting medical claim, provider, enrollment, and related information for insurance and managed care processing. Develop and support systems using SQL Server, SQL Server Reporting Services, Microsoft Access, and other tools.

    • Corvisa, LLC

      Nov 2012 - Dec 2015
      Senior Analyst

      Data Analysis and business intelligence (BI) for sister companies in cloud call center, real estate appraisal management, and financial/tax support service businessesDevelop interactive reporting for internal management and for software products; Design & administer reporting systems, including configuration, automation & securityReporting Development Tools: SSRS (SQL Server Reporting Services), Jaspersoft Studio and iReport, Microsoft Access, Excel power pivot / power view / power queryDatabases Used: Microsoft SQL Server, PostgreSQL, Microsoft Access Developed SQL extract queries, stored procedures, & functions Basic reporting on cubes using SSAS (Analysis Services); Basic SSIS (Integration Services) development Show less

    • New Resources Consulting

      Jul 2016 - Mar 2017
      Analytics Consultant

      Data Analytics Consultant for data science and technology solutions consulting company. Develop reporting systems for banking management, fraud/compliance & operations.Development Tools: T-SQL, Reporting ServicesDevelop interactive dashboards for internal manufacturing management. Work with users for requirements definition. Design & administer reporting systems, including configuration & automation.Development Tools: Tableau, PL/SQL, Microsoft Access, Oracle

    • Aetna

      Nov 2017 - now
      Senior Informatics Analyst

      Analyze varied healthcare data to evaluate programs and product solutions

  • Licenses & Certifications

    • Certified Public Accountant

      State of Wisconsin
    • Eagle Scout

      Boy Scouts of America