Learn Data Skills
Katherine Svistoonoff

Katherine Svistoonoff

Analyst

Consultant | Florida

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

Quantitative detective, solving mysteries and uncovering truths in data.

My Work

Take a look at my latest work.

course

Introduction to Power BI

course

Introduction to SQL

course

Introduction to Python

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Google Data Analytics Certified

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Self | Jan 2000 - Present

Consultant

CORE CAPABILITIES • IT Project Cost Controls & Budget Management • Variance Analysis, Accruals, ETC/EAC Forecasting • Vendor Invoice Review & SOW Alignment • SaaS/Cloud Licensing Cost Tracking • PMO Collaboration, Change Control & CCB Participation • Advanced Excel Modeling & Power BI Dashboards • Financial Documentation & Data Integrity TECHNICAL SKILLS • Excel & Reporting: Excel (Advanced Modeling, Power Query), Power BI, Tableau, SQL, Python (analytics) • SaaS / Cloud Licensing & Cost: Salesforce, Microsoft 365, Google Workspace, Canvas LMS, Zoom (license/spend implications) • Financial Management: Procurement & vendor spend analysis, variance analysis, accruals, ETC/EAC forecasting, invoice validation, budget change approval support (CCB participation) • Data & Systems: ETL & data modeling, documentation standards, data governance practices, institutional finance systems (university environment) PROFESSIONAL EXPERIENCE Senior Analyst / Data & Financial Consultant — 2000–Present • Built cost dashboards and forecasting models (Excel/Power BI) for IT modernization, SaaS deployments, and cloud migration projects. • Performed monthly variance analysis of labor, software licensing, contractor spend, and platform utilization; partnered with PMs to realign budgets. • Reviewed vendor invoices, validated accruals, and ensured SOW compliance for multi-vendor environments. • Developed ETC/EAC models to support long-range planning and capital allocation; enabled early detection of cost drift. • Created automated reporting workflows, reducing reporting cycle times by 30–40%. • Participated in Change Control Board (CCB) and similar change-approval processes by presenting impact data and validating cost implications (support role, not authority to approve budgets). Assistant Director / Data & Cost Analyst — NYU (1999–2005) • Managed multi-year technology initiative budgets and reporting cycles within a regulated academic environment. • Performed variance reviews and delivered automated cost transparency dashboards to senior leadership. • Used SQL and analytics tools to improve integrity and efficiency of institutional reporting. Project Breakdown: CAISO (California Independent System Operator) Project 1: Market Operations & Settlements Process Validation Objective: Ensure accuracy and compliance in market settlement processes and charge code validations. • Validated T+1, T+6, T+7, and Trans-to-Market settlement processes to ensure 100% accuracy and regulatory compliance. • Conducted charge code validations to prevent billing errors and support audit readiness. • Developed and documented validation protocols to streamline repeatable compliance checks. Project 2: Bid Cost Recovery & Security Validation Objective: Implement robust validation processes for bid cost recovery and market security measures. • Designed and executed validation checks for bid cost recovery submissions to ensure accuracy and fairness. • Supported security-related validation to safeguard market integrity and operational reliability. • Created training materials and led workshops on validation best practices for internal teams. Project 3: Training Program Development & Delivery Objective: Enhance team competency in market processes, settlements, and emergency response. • Developed comprehensive training programs covering market operations, settlements, validation practices, and emergency response protocols. • Delivered SQL-based training for settlements processing, enabling analysts to query, validate, and reconcile market data efficiently. • Facilitated foundational and advanced courses for cross-functional teams, improving process accuracy and team preparedness. Project 4: Process Efficiency & Workflow Optimization Objective: Improve operational workflow and data handling within market operations. • Mentored personnel on market operations, settlement processes, and workflow best practices. • Introduced data-driven techniques to streamline workflows and reduce manual intervention. • Collaborated with stakeholders to identify pain points and implement scalable solutions. Project 5: Data Analysis & Reporting for Market Insights Objective: Leverage data analytics to provide actionable insights into market performance and operational trends. • Analyzed large datasets to identify trends, anomalies, and opportunities for process improvement. • Developed dashboards and reports to visualize key performance indicators for leadership. • Supported decision-making with data-driven recommendations on market efficiency and cost optimization. Related Projects 1. Financial Operations & Workforce Optimization – Bank of America Role: Consultant & Data Analyst • Conducted workforce efficiency analysis to identify staffing gaps and workflow bottlenecks. • Developed data-driven recommendations to optimize employee allocation, reducing redundancy and improving service timelines. • Created executive dashboards to track key performance indicators (KPIs) related to employee productivity and operational throughput. 2. Financial Dashboard Automation & IT Integration – Pacific Bell Role: Financial Data Acquisition Manager • Led the Financial Dashboard Project, automating data collection and reporting, which reduced monthly financial report generation time by 30%. • Engineered ETL pipelines to extract, clean, and validate large financial datasets, improving data accuracy for executive decision-making. • Collaborated with IT and finance stakeholders to implement a company-wide system upgrade, ensuring compliance and seamless integration. • Delivered visualizations and trend analyses for statewide leadership forums, supporting strategic budget and labor cost forecasting. 3. Market Operations & Settlements Validation – CAISO Role: Consultant & Process Validation Specialist • Validated T+1, T+6, T+7, and Trans-to-Market settlement processes, achieving 100% accuracy and audit readiness. • Developed and delivered SQL-based training for settlements processing, empowering analysts to perform independent data validation. • Created and facilitated training modules on bid cost recovery, market security, and emergency response protocols. 4. Academic Performance & Curriculum Analytics – New York University Role: Assistant Director & Data Analyst • Spearheaded a department-wide student performance analysis initiative, resulting in a 10% increase in course completion rates for targeted programs. • Built SQL and Tableau dashboards to provide faculty with real-time insights into student engagement and outcomes. • Collaborated with senior leadership on data-driven curriculum revisions, using statistical analysis to evaluate program effectiveness. 5. Institutional Research & Enrollment Analysis – University of Houston Role: Data Analysis Support • Supported academic research through data collection, cleaning, and analysis of student performance trends. • Utilized Python and Excel to analyze enrollment and retention data, providing insights that informed curriculum adjustments and student support strategies. • Prepared benchmark reports and visualizations for accreditation and program review processes. 6. HR Process Optimization – Verizon Role: Consultant & Data Analyst • Analyzed hiring and skills-matching data to revamp the recruitment process, resulting in a 55% improvement in matching qualified candidates to job requirements. • Developed predictive models to forecast hiring needs and reduce time-to-fill for critical roles. 7. Commercial Operations Visualization – NBC International Role: Consultant & Data Analyst • Designed and implemented interactive data visualizations for commercial traffic analysis, improving advertising revenue tracking and operational transparency. • Translated complex datasets into actionable business insights, supporting strategic planning and performance monitoring.
Show More

My Education

Take a look at my formal education

Master's in MusicologyUniversity of Glasgow | 1996

About Me

Katherine Svistoonoff

Senior Data Analyst with 20+ years of experience leveraging data to drive strategic decision-making in finance, consulting, and operations. Comfortable using advanced analytics (SQL, Python, Power BI) and providing compelling data storytelling.

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free