Andrew Todd

Experience

• 

  Safeco Insurance

  Jun 2005 - Jun 2007

  Underwriter

  WORK DESCRIPTION: * Recognize and analyze insurance risks. * Apply underwriting knowledge, practices, and policies to effectively communicate decisions to customers. * Serve as Agent Resource to effectively explain underwriting guideline changes. * Maintain daily contact with Agency base, producing a monthly tips document, and attending district meetings.ACCOMPLISHMENTS: * Designed and implemented model for calculating effects of underwriting changes to policy premiums. * Developed education program for Agency Services Associates to guide in communication of underwriting changes and guidelines. * Grew agency base and helped expand company book of business through customer service and leadership skills. Show less

• 

  Ketchikan Regional Medical Center

  Jun 2007 - Oct 2010

  CHI Administrator

  WORK DESCRIPTION: * Maintained Peer Review database and reported monthly data for re-credentialing through the Department * Gathering and electronic collation of data used in presentation of all CHI data for the KGH Governing Board. * Developed and Maintained the web sites for the CHI Departments * Maintained the internal Orders Webs for the hospital, following established protocol. * Facilitated workflow of assignments/projects with computer applications that include: Microsoft Word, Excel, PowerPoint, Visio, Front Page, Access and Outlook. * Assisted HIM department by working as temporary Health Information Technician to help with staffing shortages.ACCOMPLISHMENTS: * Optimized CHI inter-office website using Java Script and HTML designs. * Introduced reporting automation through use of advanced Excel formulas and techniques. * Trained department heads on use of Excel to assist with report accuracy and automation. * Assisted Director of Health Information by leading various projects aligned with infection control and hospital data quality Show less

• 

  Allegis Global Solutions

  Aug 2011 - Dec 2014

  Business Intelligence Analyst

  Responsible for report and application design and development, delivering accurate, timely and cutting edge business intelligence solutions.*Served as interim regional manager for six months leading a team of 5 analysts serving 30+ client accounts.* Played pivotal role in development of new Business Intelligence platform and team to meet company information objectives.* Automated 100% of metric calculations for entire business line.High Level of Expertise With--Power BI:*Power Pivot *Power Query *Power View *Power MapMicrosoft Azure:*Virtual Machines *Azure Websites *DatabasesAdvanced ExcelLanguages:*SQL *DAX *MDX *M (PowerQuery Language) *Powershell Script *VBAData and Analytics:*Statistical Modeling*Economic and Financial Analysis *End User Requirements Gathering*Data Governance*SDLC, Agile/SCRUM *Project Management *Sharepoint (Site Collection Administrator, Report Hosting, customization) Show less

• 

  ICF

  Dec 2014 - now

  *Responsible for providing specialized technical and content leadership in Enterprise Business Intelligence, specifically for the Microsoft Power BI platform and related architecture.*Lead the analysis of existing or proposed business applications and designs applications and systems to address requirements.* Design, develop, modify, adapt and implement short- and long-term solutions to information technology (IT) needs through new and existing applications, systems architecture, network systems, and applications infrastructure.*Recommend change in customer’s processes based on results of data discovery*Writes or update reports/software specifications.*Create logical data models based on functional requirements.*Lead quality assurance review of specifications.*Prepare and update reports and instructional documentation for new or existing systems.*Provide high-level technical support and solutions to users.*Coordinate with client to define problem, determine data availability, report requirements, and resolve system design problems.*Maintain current knowledge of Business Intelligence technologies as assigned.*Collaborate with internal customers on enterprise wide projects. *Participate in special projects as required. Show less

  • Senior Business Intelligence Administrator

    Dec 2018 - now

  • Business Intelligence Analyst - BI Technical Specialist

    Dec 2014 - Dec 2018