Patricia A. Virgilio

_______________

Harvesting

_______________

• Utilizes in-house built complex applications to interact with healthcare website directories, employing basic JavaScript to mimic user behavior, regex for pattern matching, SQL stored procedures for authentication/search/pagination sessions, DOM markers, web response actions, and page indicators to trigger automated actions.
• Writes custom SQL stored procedures used by Harvest applications, incorporating complex code and sub-codes to systematically harvest website data based on each site’s unique mechanics and behavior.
• Mentors junior programmers on best practices in harvesting techniques.
• Trains an overseas Data Operations team responsible for inbound and outbound healthcare data harvest across 500+ sources and 20,000+ data deliveries annually.
• Manages 30+ scraping projects monthly with converging deadlines to meet clients’ expedited turnaround times.
• Compiles and parses website provider data to be used for competitive intelligence for clients. Requires SQL, HTML, and RegEx.
  • Manages stored procedures in SSMS databases for efficiency and accuracy.
  • Workes with developers on regression testing for the software development team for in-house tools used for harvesting data.
  • Mentors new Data Analysts, including overseas personnel through recorded training sessions and shadowing meetings.

______________

ETL

______________

• Experienced in the full ETL data lifecycle to support reliable downstream reporting and operational systems. Partners closely with project managers and client support to resolve data quality questions and provide technical data support, ensuring consistent, accurate, and timely data delivery.
• Works with client data files in various formats as well as web-scraped data to develop advanced SQL scripts and regular expressions that cleanse, standardize, and prepare datasets for project execution.

______________

Business

______________

• Member of a global Data Operations team responsible for inbound and outbound healthcare data exchanges across 591+ sources and 20,000+ data deliveries annually.
• Maintains up-to-date documentation in Atlassian Confluence for harvest techniques, ETL procedures, business rules for DBs, and best practices ensuring reference materials were accurate and useful for team members.
• Independently manages high-volume workloads in a fully remote environment.
• Received quarterly “Impact Award” for exemplifying Zelis’ IMPACT values as part of the Data Operations team, driving process improvements that reduced Data Support project processing times by 10%.
• Became trusted subject matter expert for challenging issues, providing advanced troubleshooting support and guidance to team members.
• Utilizes AI (Copilot, ChatGPT) as a practical assistant for data analysis, code input, ZIP-level demographic and geographic analysis to support informed decision-making on the job.

• Gained proficiency in Excel, Python, JavaScript, SQL databases, and Tableau through an intensive data analytics bootcamp.
• Dedicated ~30 hours per week to in-person instruction, homework, group projects, and independent study.
• Presented a final project featuring Tableau visualizations and Python code to build a machine learning prototype for a Wine Recommender System.

• Executed HR data analysis, querying data with advanced excel skills.
• Crafted and Analyzed reports on HR metrics using MS Report Builder and conveyed trends to leadership.
• Audited HRIS to confer data accuracy and integrity.
• Managed position control processes - job and position codes, FLSA, EEO classification, salary grade and titles.
• Spearheaded transition of recognition program from manual to automation in JIRA.
• Collaborated with HR and Technical teams to implement a new HRIS, by testing, reviewing business processes, assisting in stabilization period, and writing documentation.
• Oversaw the recruiting platform management in the new HRIS (routes, functionalities, alerts, communication templates, candidate portal).
• Utilized compensation modeling programs to compose salary analysis.
• Mentored recruiter and interns.

• Partnered with managers to provide full life cycle recruitment.
• Developed recruitment strategies to all positions in our three office locations (KC, NYC, D.C.).
• Forecasted hiring needs and developed a pipeline of talent through network.
• Influenced brand recognition through social media presence and implementing recruiting brand and campaigns.
• Managed recruiting budget of approximately $200k;
• Enhanced candidate experience by reducing drop off rate with an easy to apply platform and communication during hiring process.

• Managed HR policies, leaves of absence, and employee engagement. Oversaw benefits enrollment. Maintained up-to-date knowledge of OSHA regulations. Directed recruiting, screening, and hiring processes for exempt and nonexempt staff.

• Partnered with five HR Managers to administer benefits for 4,000+ employees.
• Analyzed and benchmarked benefits and wellness programs.
• Acted as Manager on Duty when needed to support HR operations.
• Created a benefits manual and delivered onboarding presentations for new staff.