Rachel Anthony Email and Phone Number

-Lead the investigation into performance issues with the connection between Databricks and Power BI using Direct Query by identifying and resolving critical bottlenecks through researching and implementing hybrid tables in Power BI to improve performance by 500%-Enforce row-level security while developing a Power BI semantic model by creating a user-defined function in Databricks to ensure users can only view data pertinent to their roles, thereby maintaining confidentiality and compliance with data governance policies-Spearhead the development of converting 104 KPI calculations from a multidimensional database in Oracle’s Hyperion to a relational database in Databricks by developing a dependency system for the calculations, collaborating with the data engineering team for performance optimization, taking charge of writing SQL statements for approximately 70% of KPIs to expedite the total development time, and achieving 100% validation of calculations by reworking failed calculations by learning the underlying data structures and business logic-Present key findings on security and performance in Databricks and Power BI in the Finance Analytics Forum to over 50 individuals, sharing best practices and strategies to be adopted by the wider team in development efforts-Discover errors within the legacy financial database system for multiple KPIs during validation, and collaborate closely with the responsible team to correct the errors to ensure the integrity and reliability of the system-Create comprehensive documentation of calculated KPI validations for all KPIs utilized in the semantic model to provide the business with evidence of compliance of requirements and serves as a reference for future audits-Optimize performance of 7 SQL scripts by redesigning the logic to insert only necessary rows to meet business needs which reduces compute time in Databricks by 85% and improves responsiveness of the Power BI report by 150%

-Oversee the mobile services department with a team of 3 for over 2,000 employees across North America-Resolve common and unknown technical issues under strict time constraints in person, over messaging, and on the phone using knowledge of Android and Apple hardware and software-Negotiate the monthly mobile plans with Verizon as a team to reduce the costs per user by 22%-Build dynamic Power BI dashboards to display mobile services expenses to distribute to the finance team to use in verifying cost allocations as a way to minimize discrepancies between department records

-Transformed 3 IT operation teams’ weekly change management reports into 1 consolidated report after collecting user requirements and increased the use of automation in its creation by 170% using MS Excel, reducing the report’s production time by over 95%-Coded a comparison tool to rapidly identify changes between data exports of over 100 records to increase the accuracy of change management reports and to save time in the reports’ development-Mentored 2 high school intern students for 4 weeks by engaging them in current projects and educating them on the company culture and goals to maximize the quality of their internship-Designed flyers that aligned with the company’s brand to promote events for GM Women+ Technology employee resource group that attracted the maximum number of employees to sign up for each event

-Coordinated decorations, entertainment, and catering at the annual ball for 300 Oakland University students-Organized weekly meetings and facilitated discussions among 15-20 committee members to make decisions about components of the ball, while staying at least 2 weeks ahead of schedule-Researched and communicated with vendors of various specialties along with drafting and processing contracts and invoices for them, while building strong relationships to work together again in future events -Navigated and solved guest problems and discontent effectively to maintain customer satisfaction

-Developed budget and allocated financials carefully to ensure the budget was followed and all transactions were recorded-Cut expenses by 40% by strategically pricing tickets based on the budget’s estimated costs and generated funds to cover 23% of the total costs through fundraising and funding grants-Designed biweekly custom marketing advertisements to publish on Facebook and Instagram to promote the ball and sell all 300 tickets to generate revenue, which increased Instagram followers by 50% and total content interaction by 60% when compared to past years’ data