Experience

• 

  Gem savings association

  Feb 1983 - Mar 1987

  Accounts payable manager
• 

  Standard oil company

  Mar 1987 - Apr 1990

  Marketing analyst

  Analyzed and reported marketing data on stations in south Dayton district with Lotus 1-2-3 and dBase III.

• 

  Univar

  Jun 1990 - May 1995

  Reports analyst

  Reporting telecom data with DBase IV and Access.

• 

  The polyclinic

  Jun 1995 - May 2001

  Healthcare reporting analyst

  • Built clinical decision support system using SQL Server 7.0. Histograms, trends• Analysis and statistical reporting on reimbursement, RVUs, MS Access, Excel, Monarch• Income Statements for capitated plans

• 

  University of washington medical center

  May 2001 - Jun 2002

  Web developer

  • Creation and maintenance of intuitive, reliable Active Server Pages for MAP using Mindscape schema• Claims analysis for clinical issues: determine hemoglobin AIC status from EPIC; determined mean bed days for homeless individuals versus commercial control group

• 

  Electronic evidence discovery

  Aug 2002 - Jun 2005

  Database analyst

  • Warehouse SQL Server 2000 1.2 terabyte databases for web-based legal review site• Program DTS with VB script or COM interfaces to migrate data from evidence to staging and prod• Automated reports for clients using creation of executable with Visual Basic calling the Excel object model

• 

  Microsoft

  Jun 2005 - May 2006

  Support analyst iii (a-)

  • Data warehousing for MSN.Autos• Scripted archival of images with MS-DOS and VB Script

• 

  Work gap

  May 2006 - Sept 2006

  Work gap

  Short term disability after knee surgery.

• 

  Verisign

  Oct 2006 - Feb 2009

  Data analyst

  • Data warehousing of telecom data. 1.2 TB databases• Created SQL Server db objects, sprocs, UDFs, linked servers, keys, constraints, RI

• 

  Work gap

  Feb 2009 - Oct 2009

  Work gap

  Travel to Virginia to assist mother with health issues.

• 

  Highline medical services org

  Apr 2009 - Jun 2012

  Database admin, database analyst, data analyst

  • Income Statements for capitated plans including RVU and pro forma• Troubleshoot EDI file (837) upon import error; ability to create file per specs with Perl• Configuration and upgrade patches for EZ Cap claims database• Discussed and implements GUI modifications (for NOMNC, etc) with Util Review RNs• Analysis of complex health care data with SQL Server (from EZ Cap db)• Standardization and automation of manual ETL processes (sprocs, NT Shell, SSIS)• Create, maintain and optimize proprietary applications used by 23 users (VBA, Access)• Automate HEDIS reporting, data modeling, ER diagrams• SQL Server 2005 database administration• Creation of SQL Server objects for dimensional reporting• Isolate EZ Cap performance issues with Profiler traces Show less

• 

  Harvey nash, inc

  Oct 2009 - Dec 2009

  Sql/ssis developer

  • Create SSIS packages for CRM data warehouse. • Wrote data cleansing scripts.

• 

  Microsoft

  Jul 2012 - Aug 2014

  Data analyst, bi analyst, reports analyst, (contract v-)

  • Utilized SQL Server and Business Intelligence Stack• Optimized SQL Queries• Reports created using SSRS, Crystal, Access, and Excel (including pivot tables and PowerPivot)• Created and modified SSRS reports using BIDS and Report Builder. Parameterize reports to call a stored procedure.• ETL creation with SSIS, including C# scripting to detect instance of files• Populate data warehouse, including de-normalization• Stored Procedure optimization to add or utilize indexes on session tables, reducing runtimes significantly and speeding up reports• SQL Server job creation and analysis• Reconciled MAS90 data with billing application data• Develop optimized Transact SQL for commercial fraud statistics with SQL Server 2008• Create and maintain weekly reporting of fraud statistics with Excel 2010 and SSRS• Automate processes with VB script and NT shell scripts• Powershell/VBScript/DOS to determine SharePoint status of a file, check-in, date stamp, and move to archive Show less

• 

  Community health plan of washington

  Aug 2014 - Feb 2015

  Sr. reports analyst, (contract)

  • HEDIS/CMS Reporting with SSRS, SSIS• Optimization of SQL (removal of table scans, use of indices)• Adhoc Claims/Utilization Reporting• Reconciliation

• 

  Qualis health

  Mar 2015 - Jul 2015

  Health data analyst, (contract)

  • Develop/maintain applications with Microsoft Access and Excel, including VBA• Report automation of previously manual processes with VB Script, DOS, VBA• Excel dashboards, including KPI reflecting statistical variations• Optimization of existing processes (use of indices, normalization)

• 

  Amazon

  Oct 2015 - Dec 2015

  Etl data analyst (contract)

  • Write PL/SQL scripts for Oracle regarding Supply Chain Capacity Planning• ETL directly to Excel tabs, create pivots, scorecards with VBA