Summary
Overview
Work History
Education
Skills
Websites
Accomplishments
Certification
Timeline
Generic

Pamela Oncale

Denham Springs

Summary

Results-driven data professional with 15+ years of expertise in data analysis, reporting, and SharePoint development. Skilled in SQL, Excel, and Salesforce, with a strong ability to optimize processes and enhance efficiency. Successfully automated reporting workflows, reducing turnaround time from 2–3 days per hospital to a scalable solution covering 30–50 hospitals within 8 weeks.

Overview

19
19
years of professional experience
1
1
Certification

Work History

SalesForce Administrator/Data Analyst and Reporting Specialist

HSLI/LHA Trust Funds
01.2022 - 02.2025
  • Company Overview: Medical Malpractice Insurer that insures Hospitals and Physicians/Physician Offices throughout Louisiana.
  • Managed and optimized Salesforce administration, including ETL processes, Flow development, and reporting to streamline business operations.
  • Automated complex reporting processes using Excel, VBA, and PDF forms, reducing report creation time from 2–3 days per hospital to an automated process covering 30–50 hospitals across three report types (Behavioral Health, Workers’ Compensation, and Professional Liability).
  • Designed and maintained a LearnWorlds-based learning platform for external client training, overseeing content creation, administration, and updates to ensure efficient knowledge sharing.
  • Provided hardware backup support, stepping in to assist IT Networking and Security operations as needed. Serve as backup support for the IT Helpdesk during the absence of the IT Helpdesk Agent. Troubleshoot hardware, software, and network-related issues for end-users to ensure minimal downtime.
  • Lead and participate in project and program management initiatives, ensuring projects are timely and meeting stakeholder requirements.
  • Develop project plans, timelines, and deliverables while coordinating with internal and external stakeholders.
  • Document progress, risks, and outcomes to relevant teams and leadership.

Associate Value Based Operations Analyst

Blue Cross Blue Shield of Louisiana
05.2017 - 10.2021
  • Completed daily duties as needed by the Value Based Operations department, such as monthly reporting, MDi account maintenance, and daily ad hoc data request.
  • Utilized SQL coding to retrieve needed data from EDW using Teradata, QBDD, Facets and other data bases using SSMS.
  • Used Facets to ensure program data for ACO's in the Value Based Programs.

SharePoint Solutions Developer

Blue Cross Blue Shield of Louisiana
  • Maintained the SharePoint site used by Clinical Partnerships as well as created SQL queries and created/published reporting so that department members were able to utilize the resulting reports.
  • Maintained reporting used by Clinical Partnerships as needed, worked with outside departments to provide SharePoint availability to the Clinical Partnerships department.
  • Utilized TFS for team projects as well as SSMS to code SQL queries.

SharePoint Solutions Developer Intern

Blue Cross Blue Shield of Louisiana
  • Worked as an intern in the Clinical Partnerships department as a SharePoint solutions developer.
  • Maintained the SharePoint site used by Clinical Partnerships as well as created SQL queries and created/published reporting so that department members were able to utilize the resulting reports.

Claim Service Assistant

State Farm Insurance Companies
07.2006 - 05.2017
  • Completed work in a customer service role: completed task via State Farm Claims system, answered and assisted external customer phone calls, and completed vendor search request.
  • Delivered training to fellow co-workers on specific procedures/methods of claims task completion.

Forecasting & Scheduling Interim Scheduler

State Farm Insurance Companies
  • Completed daily schedules for assigned department on a daily basis.
  • Maintained Share Point site with updated schedules.
  • Managed group inbox request for time off/away and scheduled learning/development time for department.
  • Maintained upkeep on Excel spreadsheets and repaired errors/issues as needed to preserve usability.

Claim Support Specialist - MCIU/SIU

State Farm Insurance Companies
  • Supported the conduct of investigations regarding claims by leveraging internal and external resources, responsible for maintaining reports, managed databases, and developed data mining tools to support decision makers with fraud decisions.
  • Responsible for maintaining ISYS indexing system for shared servers as well as handled vendor account management, answered customer calls.

Education

MBA - MBA with Data Analytics Concentration

Louisiana State University - Shreveport
Baton Rouge, Louisiana
07-2025

Bachelor - Information Systems and Decision Sciences

Louisiana State University
Baton Rouge, LA
12-2017

Skills

  • Enterprise data warehouse analytics with SQL
  • Expertise in Excel automation and reporting
  • Data visualization expertise in Tableau and Power BI
  • ETL process design and optimization
  • HTML and SharePoint development
  • Experienced with SQL SMS tools
  • Data visualization with SSRS
  • Salesforce administration expertise
  • LearnWorlds platform management
  • Process automation expertise
  • Agile project management
  • IT technical support

Accomplishments

  • Microsoft Access Database Application Development Certification IASIU Web Developer
  • National Society of Leadership & Success Honor Society Member

Certification

  • Microsoft Access Database Application Development Certification 05/2008 - Present
  • IASIU Web Developer 01/2012 - 03/2014
  • International Association of Special Investigative Units – Louisiana Chapter

Timeline

SalesForce Administrator/Data Analyst and Reporting Specialist

HSLI/LHA Trust Funds
01.2022 - 02.2025

Associate Value Based Operations Analyst

Blue Cross Blue Shield of Louisiana
05.2017 - 10.2021

Claim Service Assistant

State Farm Insurance Companies
07.2006 - 05.2017

SharePoint Solutions Developer

Blue Cross Blue Shield of Louisiana

SharePoint Solutions Developer Intern

Blue Cross Blue Shield of Louisiana

Forecasting & Scheduling Interim Scheduler

State Farm Insurance Companies

Claim Support Specialist - MCIU/SIU

State Farm Insurance Companies

MBA - MBA with Data Analytics Concentration

Louisiana State University - Shreveport

Bachelor - Information Systems and Decision Sciences

Louisiana State University
Pamela Oncale