Joann Loiodice Email & Phone Number

Miami, Fl, Us

Atlanta, Georgia, Us

- Lead analyst on project to automate manual multi-source exposure management data flow for our enterprise reinsurance program, resulting in a reduction in manual effort by over 2 weeks each month. - Lead in-house analyst for Guidewire InsuranceSuite datamart implementation. - Worked with key Flood stakeholders to build reporting layer that transformed semi-structured web portal policy data into a structured consumable format. Created data dictionary to help users understand the data and empower self-service analytics/insights for internal business customers and leadership. - Developed and maintained SOX controls for IT dependencies and key reports. Managed requests for both internal and external auditors.- Worked with developers and business stakeholders to pilot an in-house address master data solution.- Provide ongoing training and support to power users for self-service reporting out of the SQL data warehouse.

Atlanta, Georgia, Us

Business / Data Analyst supporting the Assurant Global Lifestyle Data Warehouse. - Promote business self-service / user enablement by organizing and leading training initiatives for business teams for SQL and Data Warehousing data concepts. Train business users on how to leverage the Data Quality reports and data alerts. - Provide guidance, training, and recommendations to developers as the SME for our centralized data quality / audit framework.- Collaborate with cross-functional team to execute on strategic projects, such as the assessment and pilot of a new Customer Data Platform service for advanced analytics and CX teams.

Atlanta, Georgia, Us

- Improved Enterprise Data Warehouse accuracy and reliability by working with SMEs/stakeholders to identify critical data elements and resolving ETL issues. - Designed/developed an interactive enterprise data quality scorecard based on data profiling and business rules using SQL and Python. - Improved usability of audit reporting to make it accessible to non-technical users- Designed/developed Call Center Dashboard in Power BI to enable real-time insights and process improvements. - Automated data alert process for ERP, resulting in improved time-to-market. Reduced redundant manual rework for critical to Mobile Services reports by more than 40% by automating data load validation and alert routing. - Created and maintained Data Governance SharePoint site for program and cross-functional project team members. - Led monthly Data Quality Committee meetings.- Coordinated analysis of contractual and regulatory data rights/restrictions for top strategic client accounts. Consolidated results in a master matrix and provided to management along with recommendations.

Fort Lauderdale, Fl, Us

Sr. Data Management Analyst for the Data Governance Program- Led an ongoing effort to define, implement, and operationalize merge process to reduce historical and net new duplicate accounts across multiple systems. Onboarded, managed, and mentored a team of offshore data stewards. Reduced duplication by 30% in the first 4 months, and created roadmap to merge all historical dupes by end of 2018.- Defined, developed and monitored KPIs and operational metrics related to account data governance and data quality, such as ongoing deduplication efforts and account matching at points of entry; visualized reports in Tableau; provided upper management with KPI reporting and recommendations to make data-driven decisions.- Worked with an agile continuous delivery team to stand up the new data governance program, including scope definition, intake and prioritization processes, documentation of data mgmt. standards and policies, getting buy-in from stakeholders and data champions, performing current state assessments as pertains to cross-functional business needs, and recommending areas for optimization, standardization, and/or simplification.

Fort Lauderdale, Fl, Us

- Developed enhancements for the marketing data quality scorecard in Tableau. - Led effort to enhance MDM Reject reporting tables to provide better visibility into issues, resulting in reduction of MDM rejects by over 40%. - Worked with cross-functional team to define business requirements, data mapping, and technical requirements for the creation of a new networking universe in our marketing automation system - Monitored, performed ETL, aggregated, and processed data using SQL, Excel, and Access; drew conclusions, developed and communicated recommendations.- Consulted on projects related to data privacy (GDPR), data security and integration of Cloud point-of-entry.- Conducted Requirements Analysis and UAT for various projects.

Fort Lauderdale, Fl, Us

- Reduced a long-standing MDM inbound backlog from 90 days to 0 days by learning the end-to-end flow of data across systems, performing RCA, working with IT to resolve issues in data mappings, ETL logic, and bottlenecks- Performed quarterly 3rd party enrichment exercises on account segmentation data to improve automated lead routing (accuracy and velocity). Analyzed and tracked key metrics for the segmentation enrichment program. Improved global segmentation coverage/data availability by 15-20% (varies by attribute).- Improved account and contact data quality (accuracy, availability/completeness, veracity) by monitoring, performing ETL, aggregating, and processing data using SQL, Excel, and Access

Business/data internship with Broward County Environmental Protection and Growth Management Department● Performed data mining in Oracle PL/SQL to analyze ePermits usage trends and developed KPIs. Visualized and presented findings to upper management and Steering Committee.● Conducted business analysis for several divisional automation projects. Met with stakeholders and SMEs to gather requirements, performed current state and gap analysis, developed business case and functional requirements, prepared UAT scripts and assisted with testing, developed budget proposal and cost/benefit analysis● Designed and developed a time management and financial reporting application to track staff time, generate monthly management reports, and automate quarterly invoices in MS Access.● Assisted Sr. PM with project management for a major enterprise permitting application. Assisted with development of the Project Charter, SOW review, contract negotiations, conducted risk assessment and developed the project schedule

Master’S Degree, International Relations And Diplomacy

Bachelor’S Degree, Asian Studies

French Language And Culture