James Farr Email and Phone Number

Role: Design, build, extend cross-enterprise data lake/warehouse architecture; maintain infrastructure for aggregation+analysis of high-volume enterprise HR/FI/ERP/student data· Crafted >1,000 ETL/ELT data pipelines for batched loads into Oracle, SQL Server data warehouse(s)· Administered >120 concurrent instances of Oracle database (19c EE, 32-core RAC cluster)· Coded >40GB/day ELT pipeline for student clickstream data into 50TB repository (Python+AWS S3)· Orchestrated 9,600-core supercompute cluster LLM analytics of student clickstream data (Python)· Oversaw entire online student learning ecosystem’s daily delta loads into Redshift+GCP BigQuery· Eliminated $1mm/year in fees for on-premises Oracle DB+Partitioning licensing by pitching, planning, initiating data platform migration to Snowflake for primary data warehouse· Propelled UF’s ‘Rise to Five’ college ranking with scalable data models for actionable datamarts· Mentored team of 6+ junior data engineers on operational procedures+development practices· Architected Lambda architecture data lake to democratize data, enable cross-domain sharing· Wrote, reviewed, unit tested complex PL/SQL code in continuous integration DataOps process· Supported data streaming+replication operations via Oracle GoldenGate, Kafka· Kept abreast of emergent ETL/ELT data toolsets (e.g. DataStage, Glue, Informatica)· Collaborated cross-functionally with core office teams to create holistic data services· Assumed complete ITIL/ITSM ownership of data lifecycle, including primary+failover tier 3 support

Role: Extract, transform, load data into enterprise data warehouse (Kimball model); expand data warehousing platform to include new transactional systems’ data; perform data replication tasks· Migrated 2.6mm record, mainframe-based person data to IBM Master Data Management platform· Designed, implemented SOAP API web services for person data cleansing including address, e-mail, and telephone data standardization/verification· Provided 24-hour, on-call support for >700 multi-platform, mission-critical data pipelines· Planned, extended financial data models to create 360° view of enterprise investments

Role: Develop and maintain 12+ hospital systems’ data interchange, business intelligence processes for patient billing, legal collections, and first-party collections divisionsArchitected department’s semantic report layer, automated recurring report generation· Designed interface, logical data architecture for collections, mailer applications· Built Decision Support team’s first SQL Server data warehouse, eliminating spreadmarts· Managed technical communications with vendors, advised on SaaS contract negotiations· Leveraged Equifax consumer credit data to rewrite predictive model for revenue recovery to comply with IRS 501(r) regulatory updates (and to withstand multi-year administrative audits)· Updated system tables, provisioned users, managed Active Directory groups· Performed systems analysis, process monitoring, software technical review and troubleshooting· Prepared audit/confidential reports and reviewed statistical data for accuracy· MS SQL/Oracle database administration· Avaya POM/outbound dialer front-end administration· CSS IMPACT!/collections system administration

Role: Ensure accurate, timely collection, documentation, submission, and retrieval of patient billing, insurance, and financial assistance application data· Screened patients for financial assistance eligibility, wrote-off >$400mm/year in medical debt· Co-developed X12 EDIFACT API integration for automated state Medicaid eligibility checks, billing· Co-implemented digitization of financial assistance screening documentation via OnBase ECM· Answered patient calls concerning billing processes and account balance errors· Reviewed, filed, and resolved insurance/3rd-party claims· Prepared correspondence for accounts and general customer service functions· Assisted in departmental training, process improvement, and workflow maintenance· Scripted and coordinated automated data entry mechanisms

Role: Coordinate, advise, and teach multi-disciplinary student groups to research, draft, and argue policy briefs on a wide range of topics· Compiled, organized, and maintained thousands of pages of electronic briefs· Adjudicated intercollegiate tournament debates, and coached competition teams· Planned and directed graduate-level research groups· Managing team’s $400K budget and coordinated logistics for national travel· Advised undergraduates’ academic research papers in economics and decision theory· 3,000+ hours of public speaking, public advocacy experience · University of Richmond Top Researcher Award & Director’s Award, 2008 & 2010· Cross-Examination Debate Association’s Critic of the Year Award Nominee, 2010