Emily Gianella Dawson Email & Phone Number

• Managed clearinghouse network of 10k payer connections taking into consideration cost and quality of connections, identifying, and saving over $1.5m a year optimizing data flow• Coached team of 5 analysts from entry-level to senior roles instilling mindset for scalability and innovation while insisting on challenging the status quo in striving for continuous improvement and empowering critical thinking • Led a team of analysts in migrating of Cognos reporting suite, developing of Amazon Airflow jobs for populating curated tables and architecting data warehouse solution during platform migration to Amazon Redshift• Implemented an efficient data quality warehousing KPI tracking solution, partnered with data engineering to decrease quality discrepancies to within .001% source to target accuracy• Spearheaded the adoption of Microsoft Power BI, providing senior leadership with data visualization and proactively monitoring for customer subscription plan adoption and churn• Collaborated with product and sales teams to identify key attributes and metrics to enable invoicing and KPIs that improved data-driven decision making and monetizing products• Led cross functional team in sunsetting and transitioning legacy products into modern products, including analyzing, identifying, and managing marketing campaign enabling upgrade to subscription based self-service model

Jacksonville, Florida Area

• Streamlined invoice processing by architecting and building proprietary rules engine that decrease data processing times by 90% and increased volume of contracts by 5000%• Implemented predictive modeling for contract forecasting, increasing contract revenue estimates accuracy by 75%• Led cross functional team collaboration in establishing a clearinghouse analytics specialty, enabling better network monitoring and customer insights• Initiated a comprehensive data governance program, ensuring high data integrity that led to more consistent report outputs and gain customer trust in data

Jacksonville, Florida Area

•Worked with Retail Analysts to understand their current reporting in legacy systems and assisted the development team to understand, design, and develop the final reporting solution in the new Cognos system •Engage clients/leadership at various levels and facilitate meetings when appropriate•Assisted the IT Architect and development team to understand, design and develop final reporting solutions and functional requirements•Conducted Quality Assurance testing and facilitated user acceptance testing period•Provided customer support for existing reports, dashboards, and researched inquiries from end users •Advised the end users of ways to standardize, enhance or automate their current reporting through online client dashboards, standardized Excel templates, and more efficient data pullsCognos Reporting Center of Excellence Support •Reviewed and analyzed data from multiple internal and external data sources then worked with team members to communicate and implement the best way to integrate the data sources into one reporting platform •Researched inquiries from end users of Cognos 10 reporting platform•Validated data coming in the data warehouse using SQL queries to troubleshoot potential defects in the Cognos 10 platform design•Created supplemental materials such as How to Guides, Newsletters, and Tips to add to Wiki site to educate reporting platform end users•Utilized PowerPivot to monitor reporting platform usage to help drive user adoption and find any issues at initial stages to ensure early resolution

Jacksonville, Florida Area

Sharp Decisions Contractor• Extracted and formatted data from MS Access and other databases to support analytics and management reporting• Investigated and researched open cases related to settlements in Treasury, bonds, and money market trades

Memphis, Tn

While enrolled in school full time, I shared the workload of full time employees in a 35-hour work week and met deadlines, initiated independent projects, and assisted different areas of the whole loan trading staff as necessary. • Organized, interpreted loan level data to identify saleable mortgage types and other strategic characteristics• Devised strategies for financial institutions to manage risk in loan portfolios and produced pricing indications on selected loan pools• Consolidated loan level data into presentation format and identified strategies for sales staff• Analyzed prepayment rates to value Mortgage Servicing Rights • Advanced Microsoft Excel Skills• Assisted in programming Excel models based on dynamic business needs• Utilized formulas and assumption tables to create variable business and data models • Created multipage keypunching end user form in Visual Basic to work around development issues with the new database accessing interface• Implemented, tested, and resolved issues dealing with newly developed database system• Trained and supported users in using the new database system• Rewrote pre-existing code on a complex Excel macro to keep up with changing business needs• Microsoft Certified Application Specialist

Greater Memphis Area

Relevant Coursework• Applied Program Development I – Applied basic Visual Basic programming knowledge in creating an interactive program interface• Strategic IT Project Management – Lead a 6 person team through all the deliverables, documentation, and processes to plan and execute the development of an IT application • Database Information Management – Focused on the high level design of programs for business applications

Greater Memphis Area

• Provides assistance, information, historical, and contemporary heritage interpretation to people on organized tours at The University of Memphis• Coordinated data entry daily to update potential student database• Maintained 25 hour work week with full time student status