Ivy Nwachukwu-Frank

• Utilized Power BI to build automated reports and dashboards to monitor performance metrics. • Designed, developed, tested, and maintained Tableau functional reports based on user requirements. • Analyzed historical data (including transactional, survey, and behavioral) to identify trends and make predictions. • Developed a set of data validation rules and scorecards to monitor the quality of the source data in the customer and asset domains, which led to a 15% boost in operational efficiency. • Developed and reviewed simultaneous SQL queries with the use of join clauses (inner, left, and right) in Tableau desktop to validate static and dynamic data for data validation. • Led the data governance effort for a $70,000 portfolio of products and services, including master data management (MDM) to ensure that all stakeholders have access to accurate information. • Worked with data quality analysts to develop validation rules and data quality scorecards for the material, customer, and vendor domains using SAP information steward. • Used advanced chart visualizations in Tableau such as dual axis, box plots, bullet graphs, tree maps, bubble charts, and waterfall charts to solve complex problems and create interactive dashboards and visualizations. • Collaborated with the marketing team on A/B testing of email campaigns based on customer preferences. • Created a centralized location for storing project documentation within SharePoint Online so that team members can easily find what they need without having to search through email inboxes or OneDrive folders. • Developed 85% custom Microsoft Power BI dashboards, visualizations, and interfaces with Microsoft SSRS to deliver meaningful and actionable insights. • Built operational reporting in Tableau to find areas of improvement for contractors resulting in $40,000 in annual incremental revenue. • Improved data accuracy, viability, and value by improving and streamlining processes regarding data flow and data quality. • Created and managed master data objects ensuring data integrity and successful execution in SAP within agreed timelines.

• Developed complex SQL queries using 18 procedures, including Common Table expression (CTE), to support Power BI and SSRS reports. • Maintained complete documentation including database libraries, best practices, and performance and capacity metrics. • Conducted business process analysis and identified critical issues, gaps, and needs for an established process center. • Revised purchase ordering algorithm to minimize overstock and reviewed purchase orders compiled by a colleague, achieving savings of 15% per inventory purchase. • Supported the business in terms of interpreting complex datasets, analyzing results using statistical techniques, and providing key business reports. • Developed root cause reports to address problems with customer conversions, successfully revealing insights that boosted conversions by 35%. • Utilized data, technological possibilities, and operational practices to identify and improve business processes. • Identified process gaps and provided recommendations to business process owners. • Performed over 40 data profiling activities to provide statistics and informative summaries for integration of new source system data. • Worked with company management to ensure mission-critical reporting and business intelligence reporting were being developed and delivered. • Developed, documented, and maintained data quality goals, standards, processes, and all data integration of information between internal and external applications. • Conducted professional data mapping, communicated with existing business clients, and participated in weekly team meetings with managers.