Dawn Nelson Email and Phone Number

Product Owner for myEIT dashboards(Enterprise Independent Testing), Process Delegate for Design, Build and Implement Reporting Process and Owner of Cost Allocation Process for EIT. • Lead the delivery team’s priorities in PI planning, sprint planning, and other agile ceremonies; aligned to developing aggregated test results reporting to various business and risk/compliance partners as well as aligning to large platform priorities and vision defined by product management • Work directly with delivery and business partners to design new or enhance existing reports• Author and maintain the team’s backlog of features and user stories and serving as a subject matter expert • Brief leadership on the epic and features delivery schedule, including dependencies impacting deliverables, along with recommended solutions• Attend Sprint demonstrations and provide final acceptance for completed user stories and ensure stories meet acceptance and completion criteria• Develop dashboards and reports in Tableau and Microstrategy• Create data extraction from various source databases; normalization of data and automation of processes using Alteryx

Served as Product Manager for Hiperos platform. Led efforts in the ETL from legacy platform to Hiperos platform. Uploaded clients’ vendors into system for work-order release and payment for services. Ensured accuracy of all vendors’ data, as well as proper functioning of integration between other platform tools used. Assisted in training for clients in use of system, and created reports and scorecards for clients. Developed and led the process in importing and extracting data from the company’s core databases. Performed data manipulation for over a million query lines, cleansing, and standardization to provide a framework for advanced reporting capabilities and descriptive analytics. Analyzed reports for trends and communicated those trends in various formats, including but not limited to, PowerPoint, Excel, PowerPivot, Pivot Tables, PowerView, Vlookups, and Access. Served as the single point of contact to the account team for all systems-related questions, support issues, and requirements. Analyzed and identified the root-cause of issues that may have impacted the service-level agreement targets and proactively reported concerns to appropriate parties. Created KPIs for clients. Served as Tier 2 support for help desk for platform.

Analyzed partner-submitted data and resolved internal inconsistencies and trends. Compiled and analyzed the following compensation data components: FTA cycle reports, New York Inside Limit monitoring report, Manager and Agent compensation monthly reports, and annual bonus program. Constructed and executed simple-to-moderate SQL queries. Reviewed and audited SOX audit reports and Medicare Advantage renewal compensation reports.

Three-year contract position for Allstate Insurance. Analyzed data utilizing available techniques to determine document and communicate existing data. Constructed and executed simple-to-moderate SQL queries. Participated in reviews of physical data model and related technical detail. Created technical requirements for low-to-moderate complexity projects. Assisted with project initiation or planning. Created data definitions that followed established standards and guidelines. Ran and maintained existing reporting infrastructure, analyzed data for possible issues, and implemented changes as required. Created Macros through VBA for reports. Implemented reporting solutions and solved analytical problems. Assisted in developing and implementing analytical and/or statistical methodologies for evaluating processes or problems. Developed analytics “story” and visual presentation strategies to ensure data conveyed in meaningful and interpretive formats for all audience levels. Analyzed structured and unstructured data from variety of sources to identify drivers of trends or anomalies that may have impacted results. Identified data elements needed to support business objectives and improve programs. Evaluated effectiveness of standard reports for metrics analysis and helped to optimize and operationalize solutions