Danielle Farmer Email & Phone Number

Scottsdale, Az, Us

Scottsdale, Az, Us

Austin, Tx, Us

Served as consultant for Arizona Department of Economic Security (DES) and played key role in the overhaul of multi-source workload processes. Collaborated with Operations Management and other stakeholders to ensure the inclusion of quality control monitoring and reporting, designed and deployed customized productivity dashboards for a team of 45 to automate performance tracking and reporting. Developed multiple database structures and data updates using advanced SQL scripting and SSIS to feed multiple Tableau reports and dashboards. Documented all project artifacts from inception to deployment.Highlights:★ Implemented daily actionable management of 6M+ annual benefits eligibility documents, automated quality control, and provided visibility to staffing levels, performance, training resulting in 20% increase in departmental productivity.★ Created and deployed productivity scorecard to allow senior leadership to deliver against aggressive 1-day service level agreement (SLA) by providing daily monitoring and reporting, including business and technical requirements.★ Developed an OnBase Document Management Datamart to source BI reporting.★ Managed key project for Refugee Department that enabled outreach to nearly 98% of previously denied clients regarding COVID-19 benefits by designing client identification fuzzy match algorithm across multiple legacy solutions.★ Recognized by senior leadership for service excellence and innovative product development.

Phoenix, Arizona, Us

Directed a team of 8 Business Intelligence and ETL Developers for the largest electric utility in Arizona. Oversaw all aspects of business intelligence and reporting, outlined the scope and resource planning, and collaborated with Analytics, Data Governance, and other stakeholders in support of organizational objectives. Developed and managed process workflows improvements, trained, mentored, and coached staff, and monitored timelines and budgets.Highlights:★ Oversaw the reporting quality review of a major customer billing systems conversion, assuring adherence to deadlines.★ Produced Scope and budget estimates for C-Level Corporate financial scorecard.★ Directed the first-time installation of Tableau Server for the corporate Reporting Team, transitioning from a pure production shop to boutique analytics.

Frisco, Texas, Us

Led team on strategic behavioral and Integrated healthcare initiatives, coached staff in design and development of BI solutions and data models, engaged with executive team, subject matter experts, and other stakeholders to define the requirements for all solutions. Served as the BI Subject Matter Expert for multiple areas, influenced product roadmap for BI and supporting technologies, liaised effectively with cross-functional staff in data modeling, data management, and infrastructure architecture to ensure business needs are met, and assisted in managing vendor relationships. Trained users including executive team and SMEs, established methodologies, and processes to ensure statistical viability of data models, and implemented Recipient Demographics Monitoring System for providers and patients.Highlights:★ Developed an Integrated Healthcare dimensional star schema solution including requirements gathering, traceability, documentation, design, implementation of Cognos Framework, metric scorecard and self-service reporting used by C-Suite Executives and operational management. This included integrated healthcare claims, labs, visits, and prescriptions, provided actionable insights in financial, health care, compliance provider, and regulatory domains. ★ Played key role in pilot program to expand product offerings into integrated healthcare and developed a novel self-serve health risk assessment portal that provided statistical cohort outcome comparisons of SMI population.★ Designed Case Management metric scorecard to monitor compliance with multiple agencies including HEDIS, CMS, showcased by company in bids for multiple state contracts still held by the organization today.★ Developed an Integrated Healthcare financial OLAP Cube for CFO, making it available to C-Suite such as CMO.★ Designed and implemented process improvements to bring behavioral health intake and demographics timeliness into compliance, saving the organization up to $10M in penalties.

Conway, Arkansas, Us

Managed the software development of a prescription information and market data tracking engine for market share analytics for Wolters Kluwer. Served as Technical Lead for Development and QA Team, liaised between IT and business partners, and automated business rules engine documentation.

Atlanta, Georgia, Us

As test Lead and QA Architect, managed and implemented the transition of QA department testers and leads into and accelerated, bi-monthly multi product releases. Developed the Quality Assurance Certification process and artifacts to manage quality performance objectives via dashboard KPIs.★ Increased time to market on all product release cycles by 50%.★ Coordinated testing activities and instituted best practices to promote ‘Quality First’ objectives. ★ Mentored staff on data driven quality assurance focus, and test early test often mindset, resulting in 35% reduction of production defects.

Masters Of Science, Management Information Systems & Business Administration

Bachelor Of Science, Mathematics With Specialization In Probability & Statistics