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, Louisiana07-2025
Bachelor - Information Systems and Decision Sciences
Louisiana State University
Baton Rouge, LA12-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