KATHRYNA R. O'DONNELL
Port St. Lucie,United States
Summary
Strategic Lead Data Analyst with extensive experience in financial services. Expertise in Tableau, Microsoft Power BI, SQL Server Business Intelligence, Data360 Analyze, and data mining. Holds a Bachelor of Business Administration in Management Information Systems from Florida Atlantic University.
Overview
14
14
years of professional experience
Work History
Lead Analyst
COMCAST
08.2023 - Current
- Lead the team in identifying problem accounts and revenue recovery opportunities based on the audit results
- Built departmental dashboards tracking revenue recoveries and projections
- Translated business rules from Product and Marketing to create revenue recovery audits for Xfinity Mobile Promotions and enhance current business processes
- Developed automated reporting processes for performance tracking and trending analysis
- Worked on complex data pulls using SQL queries across multiple sources with different formats and built an efficient data flow that runs on schedule
- Provided customized ad-hoc reports using Tableau, Excel, and other reporting formats
- Collaborated with Marketing in developing streamlined messaging to customers regarding product offerings and promotions eligibility
- Documented Xfinity mobile updates and rule changes and integrated it to current process audits
- Managed projects within the team, assigned and delegated tasks related to the project to the teams’ junior analysts
Senior Data Analyst
Tracfone Wireless
Miami, FL
08.2021 - 08.2023
- Provided data and analyses for FCC Reporting
- Worked on complex data pulls using SQL queries across multiple sources with different formats
- Coordinated communication among IT, Operations, Marketing, and external parties for migration efforts across carriers, brands, and technology
- Provided customized ad-hoc reports using Tableau and Excel for management.
- Developed processes to automate reports such as performance tracking and trending
- Built Departmental dashboard
- Utilized data cubes in enriching reports and providing information for business cases
- Worked on business cases for promotional purposes and go-to market strategies
- Presented profit and loss analysis from business cases to management and other departments
- Created automated reporting processes for performance tracking and trending analysis
- Managed the communication with IT, Operations, Marketing and other departments and external parties related to migration efforts (across carriers, brands, and technology)
- Delivered profit and loss analysis from business cases to management and departments
Data Analyst/Database Manager
Corcentric, Capital Equipment Solutions
Coral Springs, FL
06.2015 - 08.2021
- Collaborated with business analysts, developers, and testers to build customized web application and data warehouse, enhancing process transformations to meet business needs.
- Developed SQL queries to obtain complex data from tables in remote databases.
- Worked in Microsoft SQL Server platform to develop shell scripts for task automation
- Identified business requirements and devised implementation strategies to solve the business problems.
- Assessed data and issues and directed concerns to business unit leadership.
- Identified business requirements and developed implementation strategies, addressing key business problems effectively.
- Supported company sales and service functions by leveraging fleet analytics expertise.
- Reviewed, analyzed, and recommended software solutions that would be an ideal fit for project specifications.
- Extracted and analyzed data to uncover insights. to uncover insights and identify market trends and inflection points.
Tableau Developer, Tableau Administrator
Citrix
Fort Lauderdale, FL
11.2013 - 06.2015
- Conducted GAP analysis to identify discrepancies between 'As-Is' and 'To-Be' conditions, informing project direction.
- Created database objects like tables, views, procedures, triggers, and functions using SQL to provide definition, structure, and maintain data efficiently.
- Develop Tableau reports that provide clear visualizations of various industry-specific KPIs.
- Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
- Developed Tableau workbooks from multiple data sources using Data Blending.
- Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.
- Created database objects, including tables, views, procedures, triggers, and functions using SQL to define structure and maintain data integrity.
- Transformed large datasets through filtering, grouping, aggregation, and statistical calculations to enable data-driven decision-making.
BI Analyst
Citrix Systems Inc.
Fort Lauderdale, FL
06.2012 - 11.2013
- Updated tracking documents to generate diverse reports and present actionable findings.
- Optimized data gathering processes, analysis procedures and visualization strategies.
- Created and oversaw dashboards for the CIO utilizing Tableau
- Reviewed and enhanced SQL server performance to support data-driven decision making.
- Completed A/B testing and created packages to validate, extract, transform and load multiple forms of data to a centralized SQL server.
- Evaluated software options to identify optimal solutions for project needs. that would be an ideal fit for project specifications.
- Updated tracking documents generated different reports and gave presentations on findings.
- Created and managed dashboards for CIO using Tableau to provide insights into key business metrics.
Education
Bachelor of Business Administration - Management Information System And Marketing
Florida Atlantic University
Boca Raton, FL, United StatesSkills
- Tableau Server Administration
- Tableau Server 8 Certified Professional
- Data Visualization
- Business Intelligence
- Microsoft Power BI
- Data Analysis
- SQL BI stack
- MS SQL Server
- SQL (Oracle, DB2, MS)
- Data Automation
- Data Mining
- Database design
- Precisely Data360 Analyze
- DAX
- Office suite expertise
- Project Collaboration
Timeline
Lead Analyst
COMCAST
08.2023 - Current
Senior Data Analyst
Tracfone Wireless
08.2021 - 08.2023
Data Analyst/Database Manager
Corcentric, Capital Equipment Solutions
06.2015 - 08.2021
Tableau Developer, Tableau Administrator
Citrix
11.2013 - 06.2015
BI Analyst
Citrix Systems Inc.
06.2012 - 11.2013
Bachelor of Business Administration - Management Information System And Marketing
Florida Atlantic University