Edith Cox Email & Phone Number

Phoenix, Az, Us

Phoenix, Az, Us

Developing robust analytics that drive decisions.

Phoenix, Az, Us

Phoenix, Arizona, Us

Phoenix, Arizona, Us

Using SQL & Power BI to enable data driven decision making. Accomplishments• Developed scalable data structures and processes that enabled the department to support reporting for 50+ health plans, 200+ employer groups, and 35 network providers.• Developed batch claims submission file, eliminating the need for manual claims filing, freeing up three dedicated FTE resources, and reducing claims submission delays by 95%.• Proposed, designed, and lead project to move subscriber ID to payer matching from data cleanup process to web autocomplete, reducing incorrect payer identifications by 90%.• Partnered with engineering to design, architect, and build a detailed claims management system, enabling claims status reporting throughout the organization.• Drove analytical testing process for key business processes, identifying critical defects and building business partner confidence needed to unblock major projects.• Using insights gained from CDC feedback for a wide range of providers, was able to provide expert advice on how to prepare data, understand guidelines, and strategize for improvement.• Designed resilient metrics to minimize impact of low-quality data on decision making. • Provided ongoing reporting to internal and external organizations as well as the CDC using Microsoft SQL Server and Microsoft PowerBI.• Served as Team Lead & Scrum Master for the Data Team• Served in advisory role for data structure decisions across all development projects.• Championed reporting throughout the product development lifecycle.• Identified, diagnosed, and proposed mitigations for data quality issues.• Maintained source-controlled reporting database schema.• Lead the team through internal audits, leading to more robust and auditable design decisions.

Phoenix, Arizona, Us

DutiesHandled user support for networked CRM and ERP applications as well as legacy Office-based applications, using SysAid ticketing system to support triaging and troubleshooting issues. Worked with vendor developers to resolve software issues, providing reproducible error steps and validating and deploying returned solutions. Provided management and government audit reports using T-SQL and Microsoft Business Intelligence. Performed application release testing, installations, and updates. Implemented and trained salespeople on new sales processes in Microsoft CRM.AccomplishmentsSaved the company a major tax liability, using data forensics to reconstruct records of CA sales taxes paid for auditors. Reduced errors and delays in multiple reports by automating previously manual processes. Eliminated redundant data entry task by incorporating features of a legacy Access database into SQL. Resolved and mitigated issues in batch invoicing process where invoiced were incorrectly marked as unprinted, eliminating the need for manual intervention, wasted paper, and customer confusion. Eliminated referential integrity issues in the database that caused the ERP to fail when completing customer orders.

Phoenix, Arizona, Us

ResponsibilitiesHandled user support for networked CRM and ERP applications as well as legacy Office-based applications, using SysAid ticketing system to support triaging and troubleshooting issues. Worked with vendor developers to resolve software issues, providing reproducible error steps and validating and deploying returned solutions. Provided management and government audit reports using T-SQL and Microsoft Business Intelligence. Performed application release testing, installations, and updates. Implemented and trained salespeople on new sales processes in Microsoft CRM.AccomplishmentsSaved the company a major tax liability, using data forensics to reconstruct records of CA sales taxes paid for auditors. Reduced errors and delays in multiple reports by automating previously manual processes. Eliminated redundant data entry task by incorporating features of a legacy Access database into SQL. Resolved and mitigated issues in batch invoicing process where invoiced were incorrectly marked as unprinted, eliminating the need for manual intervention, wasted paper, and customer confusion. Eliminated referential integrity issues in the database that caused the ERP to fail when completing customer orders.

Stafford, Texas, Us

Ensured compliance with government and business-partner requirements through accurate and auditable reporting processes. Addressed gaps in existing tracking and reporting mechanisms through a multi-tiered macro-driven shared Access database environment, driving increased productivity without the cost or delays associated with an outsourced development project. Developed tools and reusable components in Excel for rapid generation of reports, significantly reducing both run time and error potential. Developed large-scale automated reporting capabilities spanning Excel, Access, and TSQL Database Stored Procedures in SQL Server 2008. Worked with development team to define and validate reporting requirements in multi-phase CMS redesign project. Reconciled data definitions across distributed teams to ensure synchronicity and accuracy of information, reducing enterprise risk while building confidence and partnership between the teams.

Worked across several lines of business, applying self-management techniques to drive results in changing work environment. Developed and implemented Microsoft SharePoint WSS solution for lead management, leveraging complex workflows in SharePoint Designer 2007, role specific permissions, and third-party add-ins to provide a secure and scalable replacement for the existing processes. Delivered business critical enhancements to Microsoft Dynamics SL 7.0 financial information system, utilizing Visual Basic for Applications (VBA) and form manipulation to capitalize on previously untapped revenue sources. Customized Dynamics SL using stored procedures and triggers to provide additional functionality. Developed and implemented Crystal Reports across various data sources used by the organization. Published and maintained reports on Microsoft Business Portal. Identified financial risks stemming from improper data management, employed programmatic solution to isolate and correct the invalid information, and deployed a revised process to eliminate the root cause. Developed and facilitated end-user training utilizing user acceptance testing and feedback to ensure adoption of new methodologies.

Designed and delivered operations-critical reports and dashboards to managers and executive officers. Recommended data-supported process improvements. Leveraged SQL and relational database concepts to effectively manage and transform data, using Oracle 9, MS SQL Server 2005, MySQL, Crystal Reports 9, Business Objects, SharePoint (MOSS), VBA, Access 2007, and Excel 2007. Utilized TSQL, stored procedures, triggers, and scripts to automate data collection and report generation. Ensured FERPA compliance; managed student and employee privacy by controlling access to sensitive information. Maintained data integrity by managing and reducing anomalies. Collaborated with other analysts and departments in the development of technical, functional, and business requirements to determine scope and deliver results.

Bs, Mathematics

M. Eng., Systems Engineering, Quality & Reliability