Experience

• 

  Lightbeam Health Solutions

  • United States
  • IT Services and IT Consulting
  • 100 - 200 Employee

  • Lead Data Engineer

    • Jun 2022 - Present

    • Documented analytics stored procedures for data dictionary.• Act as mentor and code reviewer for data engineers on the team.• Merged branches in DACPAC environment for team members.

  • Business Intelligence Analyst

    • May 2018 - Present

    • Developed advanced queries and stored procedures for analytics and ETL processes in SQL Server.• Design interfaces for importing and mapping data files into standard tables.• Built custom data analytics modules for clients and supported the backend processes for the user-interface.• Helped implement a large healthcare payor by developing custom analytics and processes.• Reviewed and investigated client issues with data and the user-interface

• 

  Cotiviti Healthcare

  • United States
  • IT Services and IT Consulting
  • 700 & Above Employee

  • Associate Engineer, SQL Developer

    • Aug 2015 - May 2018

    • Develop complex reports using T-SQL in SQL Server Studio across multiple data platforms. • Maintain and enhance Access-based tools• Perform quality assurance testing following data outages and upgrades• Answer ad hoc service request from internal clients in a timely manner

  • Senior Analyst

    • Apr 2013 - Aug 2015

    Provided ad-hoc analysis and metrics in client claims data which required usage and familiarity with Cotiviti and external client tools and data.

• 

  Mercer

  • Dallas/Fort Worth Area

  • Project Manager

    • Dec 2005 - Apr 2013
    • Dallas/Fort Worth Area

    Responsible for day-to-day activities of two client service teams, which included project plan, implementation and milestone management, personnel allocation and development, client management, change orders and SLA adherence. Managed and support the largest client (38,000+ lives) and team within the workgroup. Created a team setting that encouraged both individual and team accomplishments; ability to establish goals and evaluate the performance of team members.

• 

  Neiman Marcus

  • Dallas/Fort Worth Area

  • Benefit Analyst

    • Sep 2004 - Dec 2005
    • Dallas/Fort Worth Area

    Responsible for monitoring and analyzing self-insured and fully-insured benefit plans, including trend analysis of plan experience, future cost projections, and calculating employee contributions to meet cost objectives.

• 

  Watson Wyatt

  • Dallas/Fort Worth Area

  • Group & Healthcare Analyst

    • Sep 2000 - 2004
    • Dallas/Fort Worth Area

    • Automated the process for collecting and analyzing claims audit data by programming and maintaining proprietary software. Also developed databases for use in tracking audit results, clients, and vendors.• Analyzed census and claims experience data for use in projecting clients’ benefit plan costs, verify network discounts, and identify utilization patterns. • Developed RFPs soliciting bids for vendor services and analyzed responses.

• 

  Aetna

  • Dallas/Fort Worth Area

  • Trainer

    • Nov 1989 - Sep 2000
    • Dallas/Fort Worth Area

    Spent almost 11 years in the Arlington, TX service center, working as a customer service representatives and as a trainer.