Sandra Castaneda Email & Phone Number

Montebello, California, United States

• Provide data support for three health care groups, serving more than 25,000 Medicare members, by ensuring accurate data analysis and reporting to facilitate informed decision-making.• Deliver data assistance to the risk adjustment coding team to ensure that annual wellness measures are met by delivering accurate claims information and conducting thorough data analysis.• Conduct data validation on third-party data integrated into our database using Microsoft SQL Server to ensure accuracy and integrity for enhanced reporting and analysis.• Create and maintain reports using Microsoft SQL Server Reporting Services (SSRS), ensuring accurate data representation and delivering actionable insights to health care groups and their practices.• Perform ETL processes by extracting, loading, and transforming data into the database for reporting purposes, utilizing the bulk insert command for efficient data ingestion.• Generate and deliver Medicare risk adjustment factor score reports for health care groups, ensuring accurate analysis and data representation to support informed decision-making.• Assist in generating annual wellness visit, recaptured, and suspected Hierarchical Condition Categories (HCCs) performance incentive reports to facilitate payouts to healthcare practices, ensuring accurate data analysis and compliance with incentive program requirements.• Assist in maintaining and creating a database to store all data related to the Centers for Medicare and Medicaid Services (MAO, MOR, MMR) files, ensuring data integrity and accessibility for analysis and reporting.• Compile and document Centers for Medicare and Medicaid Services (MAO, MOR, MMR) files from 12 health plans across all three healthcare groups using Secure File Transfer Protocol (SFTP), encrypted email, and health plan websites to facilitate secure ingestion into a centralized database.• Facilitate the submission and review of support data tickets for the program to Business Intelligence (BI) team.

Santa Ana, California, United States

• Developed and implemented robust data quality checks, ensuring the accuracy and consistency of data for two programs, thereby enhancing the reliability of information for informed decision-making. • Utilized statistical and trend analysis techniques to develop insightful key performance indicators (KPI) reports tailored for administrative and staff audiences in two distinct programs. • Produced monthly data visualization for two distinct programs, providing the Orange County Health Care Agency with insightful presentations to aid in strategic decision-making and performance evaluation.• Maintained and created a Microsoft Access SQL database for the drug program. • Implemented ETL processes to prepare large datasets for comprehensive data analysis, contributing valuable insight to enhance the effectiveness of two distinct programs.• Delivered a variety of data reports, including ad hoc requests, fulfilling the Orange County Health Care Agency’s informational needs for two distinct programs. • Attended Orange County Health Care Agency meetings to oversee and ensure program data governance and maintaining data integrity standards.• Trained colleagues within my role, adeptly instructing on Excel sheets and calculations across a spectrum of programs to enhance their skills and streamline workflow. • Managed information entry duties, specializing in system and electronic health records (EHR) tasks, ensuring precise collection and entry of member-served data for comprehensive record-keeping. • Trained by Orange County Health Care Agency in billing services, equipped with the knowledge and skills to efficiently manage and process billing procedures.• Leveraged comprehensive knowledge of Medicare, Medi-Cal, CalAIM, HCPCS, CPT-4, ICD-10, and LPS Conservatorship to ensure understanding for accurate and effective data analysis of two programs.

Orange, California, United States

• Delivered monthly data program report to administrators for review and submission to Orange County Health Care Agency. • Collaborated with a 12-member team to propose enhancements addressing data inaccuracies and eliminating duplications within the Student Information Management System.• Extracted and transformed data from Student Information Management System to generate tailored data reports meeting specific business requirements, ensuring valuable insights for informed decision-making.• Conducted continuous data maintenance, overseeing data integrity and quality to meet standards for external audits, ensuring accuracy and compliance. • Assessed the completeness and validity of data reports to strategically mitigate potential deviations from contract goals, ensuring alignment and success in program outcomes. • Identified and developed technical innovations for routine processes in the Student Information Management System, enhancing workflow efficiency and optimizing operational procedures.• Implemented robust workflow automation and fortified protective measures to safeguard confidential data within the Student Information Management System, ensuring security and operational efficiencies. • Coordinated the collection and analysis of survey data for program contracts, providing valuable insight and reporting to meet Orange County Health Care Agency requirements. • Managed communication with the Student Information Management System vendor, representing administrators to implement user forms, enhance user accessibility, and maintain data integrity standards. • Trained new and existing employees of all processes and updates to Student Information Management System.

Fullerton, California, United States

• Followed all POS system procedures and protocols to secure company sales information.• Handled all financial transactions, including cash and card transactions, in accordance with company policies. • Addressed a 12+ team daily to provide exceptional customer service and proper team support. • Prepared high-quality food items according to standardized recipes and instructions to meet production. • Cleaned kitchen after preparation and serving to maintain standards of safe food-handling procedures. • Contributed to ordering and receiving food and supplies as required to meet daily production needs.

Fullerton, California, United States

• Answered and directed calls on multi-line phone system to provide proper communication to departments.• Managed real-time scheduling support by booking appointments and preventing conflicts.• Executed miscellaneous projects and office tasks as needed to meet administrative goals. • Resolved routine inquiries and requests from internal and external business contacts using knowledge of organization policies and procedures.• Established access to confidential files, logs, and records to secure the safety of information between departments.

Orange, California, United States

• Delivered positive professional guest services in all interactions with guests, vendors, and fellow employees.• Ability to communicate weekly with outsider vendors to assure accurate quality items. • Trained 5+ new staff members monthly in work policies and procedures within all areas of responsibility.• Maintained proper safety protocols in all 25 theaters to guarantee guest safety during and after films. • Sold concessions and merchandise at several locations within the facility to meet individual sale goals. • Delegated manager responsibilities to ensure customer complaints are managed and resolved. • Communicated with a team of 30+ members to provide accurate workflow between departments.

Turlock, California, United States

• Operated cameras and maintain equipment in studios to ensure proper recording and live broadcast of clients. • Utilized windows-based computer software to prepare and edit 30+ video recordings for air.• Interacted daily with over 50+ users to resolve existing issues and problems for proper video viewing. • Demonstrated daily the technical controls associated with camera operations to 12 staff members and 15+ clients. • Assisted a 10-person team with pulling, sorting, and returning of all gear before and after productions.• Correspond with administration daily of all technological software issues to guarantee proper workflow.

Santa Ana, California, United States

• Achieved and exceeded sales goals by utilizing companies daily selling strategies. • Drove sales by leveraging the loyalty and marketing programs to all existing and new customers. • Provided in-depth product knowledge, including current offerings, and overall product value to each customer. • Cross-sell and encourage beneficial product add-ons that relate to each customer’s shopping needs. • Aided monthly with floor set execution, window changes, visual presentation to increase marketing placement.• Engaged with 200+ customers in the service areas and on the sales floor to provide the best customer experience.

Masters Of Science In Information Technology (Msit), Data Science, 3.84

Bachelor Of Arts In Business Administration, Business Analytics, 3.55

Transfer, Business Analytics, 3.47

Activities and Societies: Phi Mu Fraternity – Fraternity Member (2014-2018)