Ryan Merlo

Ryan Merlo Email and Phone Number

Financial Analysis Lead Analyst - Cigna Pharmacy Finance @ Cigna
Ryan Merlo's Location
South Windsor, Connecticut, United States, United States
About Ryan Merlo

Ryan Merlo is a Financial Analysis Lead Analyst - Cigna Pharmacy Finance at Cigna. He possess expertise in technology, data analysis, program management, team leadership, pharmacy benefit management and 21 more skills.

Ryan Merlo's Current Company Details
Cigna

Cigna

View
Financial Analysis Lead Analyst - Cigna Pharmacy Finance
Ryan Merlo Work Experience Details
  • Cigna
    Financial Analysis Lead Analyst
    Cigna Apr 2014 - Present
    Bloomfield, Connecticut
    • Manage Commercial and Payer segment Pharmacy rebate administration including contract inventory, client sharing statement and branch benefit reporting production, audits, projections, and payments.• Designed and developed multiple MS Access databases for Payer and Commercial Line of Business reporting (Rebate Statements, Branch Benefit Option Reporting, Sharing Inventory, Commercial RFP) resulting in considerable efficiencies.• Collaborate with Pharmacy IT Development & Production Support teams to introduce, test and deploy enhancements to the Rebate Sharing System.• Validate/troubleshoot production anomalies via ad hoc queries in conjunction with underwriting collaboration. • Provide education and guidance of rebate sharing process to Client Managers, Sales Managers, and Underwriters.• Partner with accounting to provide analytic support for monthly/quarter liability projections and variance analysis.
  • Cigna
    Pharmacy Audit Manager
    Cigna Nov 2009 - Apr 2014
    • Managed Third Party Pharmacy Claim Audit Program • Built receivables/collections MS Access database; successfully recovered over $9M for Cigna & Rx clients• Developed “New Pharmacy Activity” report to monitor and analyze potential fraudulent billing activity • Led internal Pharmacy Network Operations meeting to discuss and analyze “suspect” pharmacies• Participated in FBI, HHS, OIG, CMS, MEDIC, State’s Department of Insurance investigations
  • The Hartford
    Sr. Financial Analyst
    The Hartford Sep 2005 - Oct 2009
    • Oversee production and reporting of Employer Group Sales Reporting Process.• Design and developed numerous reporting tools in both Access and Excel. (VIP Producer Modeling, Sales Lag Report, Forecasting, Month over Month activity reporting…)• Lead on Sales projects involving IT, Underwriting and Producer Development.• Analyze monthly sales results at high level for management; main drivers, critical indicators.• Perform quarterly audits based on variance reporting with assistance from UW and Premium administration. • Mentor and train various members of immediate and extended team on technical processes.• Work closely with matrix partners both in the field and home office related to the Sales Reporting process.
  • Cigna
    Sr. Financial Analyst
    Cigna May 1999 - Sep 2005
    • Responsible for technical expertise and financial tool development in the Producer and Sales Reporting area.• Assisted in the design and development of a CIGNA-wide reporting tool called the Producer Scorecard.• Developed and rolled out numerous Producer Business Development reports.• Designed and maintained a Producer Incentive Program database• Provide high-level analysis on monthly analytic package, highlighting market or producer activity.

Ryan Merlo Skills

Technology Data Analysis Program Management Team Leadership Pharmacy Benefit Management Microsoft Technologies Accounts Receivable System Design Data Mining Fraud Detection Mentoring Financial Analysis Customer Service Subject Matter Experts Relationship Management Contract Negotiation Healthcare Analysis Access Management Analytics Insurance Process Improvement Finance Microsoft Excel Leadership

Ryan Merlo Education Details

Frequently Asked Questions about Ryan Merlo

What company does Ryan Merlo work for?

Ryan Merlo works for Cigna

What is Ryan Merlo's role at the current company?

Ryan Merlo's current role is Financial Analysis Lead Analyst - Cigna Pharmacy Finance.

What is Ryan Merlo's email address?

Ryan Merlo's email address is lu****@****.rr.com

What schools did Ryan Merlo attend?

Ryan Merlo attended The University Of Connecticut School Of Business.

What are some of Ryan Merlo's interests?

Ryan Merlo has interest in Photograph, Electronics, Automobiles, Reading.

What skills is Ryan Merlo known for?

Ryan Merlo has skills like Technology, Data Analysis, Program Management, Team Leadership, Pharmacy Benefit Management, Microsoft Technologies, Accounts Receivable, System Design, Data Mining, Fraud Detection, Mentoring, Financial Analysis.

Not the Ryan Merlo you were looking for?

  • Ryan Merlo

    Technical Project Manager At Autodesk
    Detroit Metropolitan Area
    5
    wideopenwest.com, wideopenwest.com, gmail.com, yahoo.com, autodesk.com

    4 +131354XXXXX

  • Ryan Merlo

    Aspiring Computer Hardware Engineer | Student At University Of Scranton
    Scranton, Pa
  • Ryan Merlo

    Router
    Rochester, New York Metropolitan Area
  • Edward-Ryan Merlo

    Greater Sacramento
    2
    gmail.com, jensenprecast.com

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.