Patricia Stanca

WHAT?

Designed analytics solutions from business needs, including data models, semantic layers, and Power BI reporting in Microsoft Fabric.

WHY?

To enable decision‑ready insights, explain complex impacts, and support scalable self‑service analytics.

MY CONTRIBUTION

• Led needs analysis with business and IT to translate questions into data models.
• Defined entities, relationships, and logic for semantic models and reporting.
• Initiated and supported creation of new tables/views where needed.
• Ensured data quality, consistency, and long‑term usability across initiatives.

TOOLS

• Microsoft Fabric
• SQL
• Power BI
• Data Modeling
• Semantic Models

WHAT?

Implemented Microsoft Fabric as the analytics platform with standardized data models and reporting.

WHY?

To enable scalable self‑service analytics and reduce reporting lead times.

MY CONTRIBUTION

• Initiated and led the Fabric adoption for customer analytics, including executive alignment and funding.
• Owned data and reporting requirements and helped design the customer data model.
• Built core semantic models and structures in Fabric for scalable reporting.
• Enabled standardized self‑service analytics and shorter reporting lead times.

TOOLS

• SQL
• Data Modeling
• Data Warehouse
• Azure Fabric
• Power BI

WHAT?

Behavior and consumption analysis in Azure Fabric notebooks to understand how customers react to price and control signals.

WHY?

To track near‑real‑time customer response, measure the impact of price and communication changes, and support product decisions.

MY CONTRIBUTION

• Analyzed historical consumption to identify customer patterns and reactions to price and control signals.
• Tracked how different customer groups respond in near real‑time after price changes and communications.
• Measured short‑ and long‑term behavior changes following tariff and communication updates.
• Used historical + current data to model future customer behavior and segment impact.

TOOLS

• Python
• Azure Fabric Notebooks
• Time‑Series Analysis
• Behavior Analytics

WHAT?

Prediction of energy consumption and clustering of customer behavior using PySpark in Fabric notebooks.

WHY?

To identify distinct customer behaviors and forecast peaks for tariff impact analysis.

MY CONTRIBUTION

• Prepared and engineered features from hourly consumption data in PySpark.
• Built clustering models and validated separation of customer groups.
• Trained prediction models to identify peaks and abnormal behavior.

TOOLS

• PySpark
• Fabric Notebooks
• Random Forest
• Clustering

WHAT?

Automated marketing reporting and follow‑ups using Power Automate, Microsoft Lists, and reporting templates.

WHY?

To reduce manual admin work and ensure consistent reporting cycles.

MY CONTRIBUTION

• Designed flows connecting Lists, Planner, and reporting artifacts.
• Defined data structure and automation logic for monthly updates.
• Aligned stakeholders on handoffs, ownership, and reporting cadence.

TOOLS

• Power Automate
• Microsoft Lists
• Process Automation
• Reporting Ops

WHAT?

Customer segmentation and information modeling for analytics and communication.

WHY?

To improve targeting, data consistency, and decision‑making across systems.

MY CONTRIBUTION

• Contributed to customer segmentation and information modeling for analytics, communication, and system development.
• Translated business needs into a clear information model for analytics and reporting.

TOOLS

• Customer Insights & Segmentation
• Data Modeling
• SQL
• Stakeholder Engagement

WHAT?

Operational data handling, customer logic, and rule‑based segmentation using Excel, VBA, and supporting tools.

WHY?

To enable correct targeting, reliable communication, and usable data for downstream analytics.

MY CONTRIBUTION

• Built rules for customer selection, de‑duplication, and data quality checks.
• Handled missing data with fallback logic to ensure robust classification.
• Defined B2B contact logic to select correct address/email and avoid mis‑targeting.
• Delivered operational lists for campaigns and stakeholder reporting.

TOOLS

• Excel
• VBA
• SQL
• Data Cleaning
• Customer Logic

WHAT?

Led data quality ownership and migration rules for the upcoming CRM replacement, focused on cleaning, structuring, and validating data.

WHY?

To reduce migration risk, improve 360° customer views, and create better conditions for sales, follow‑up, and analytics.

MY CONTRIBUTION

• Defined core information objects: customer, contact, case, appointment, facility, product links, and business deal.
• Clarified critical distinctions between sales agreements vs billing/KIS agreements.
• Mapped sources, keys, and relationships to support structured migration and quality checks.

TOOLS

• Data Governance
• CRM Data Mapping
• SQL

WHAT?

Designed recurring NKI measurements with segment, product, and audience‑specific questions.

WHY?

To track customer satisfaction over time and identify improvement priorities.

MY CONTRIBUTION

• Defined survey structure and segmentation logic.
• Aligned questions to products and target groups.
• Supported reporting for internal follow‑up and planning.

TOOLS

• Survey Design
• Segmentation
• Power BI
• Netigate
• Hotjar
• Looker Studio
• Piwik PRO

WHAT?

Training sessions on AI chat tools (Copilot) for marketing teams, focused on practical use cases and safe adoption.

WHY?

To make AI a natural part of daily work, save time on routine tasks, and improve creative output.

MY CONTRIBUTION

• Designed the agenda, exercises, and prompt‑writing framework.
• Delivered hands‑on demos for content generation, summarization, and data insights.
• Covered best practices on context, structure, tone, and safe usage.

TOOLS

• Copilot
• Prompt Design
• Workshop Facilitation
• Presentation

WHAT?

Strategic process leadership during organizational change, including governance and IT strategy input.

WHY?

To align strategy, processes, and people during a major transformation.

MY CONTRIBUTION

• Supported organizational design and change initiatives for employees.
• Helped define process governance and follow‑up structures.
• Contributed to IT strategy and decision support for leadership.

TOOLS

• Strategic Planning
• Change Leadership
• Process Governance
• Stakeholder Alignment

WHAT?

Defined the requirements and user perspective for a full replacement of a legacy core business system.

WHY?

To create a clear procurement brief that reflected real user needs and future‑proofed operations.

MY CONTRIBUTION

• Led requirements work from a process leader and customer perspective.
• Delivered 300+ functional and non‑functional requirements.
• Contributed to IT strategy input, decision support, and procurement documentation.

TOOLS

• Requirements Gathering
• User Perspective
• Procurement Support
• IT Strategy

WHAT?

Process change and facilitation across business and IT teams.

WHY?

To improve workflows, alignment, and cross‑team collaboration.

MY CONTRIBUTION

• Facilitated process improvements and change management initiatives.
• Supported cross‑functional teams in mapping workflows and clarifying responsibilities.
• Improved communication between business and IT teams.

TOOLS

• Process Improvement
• Change Management
• Workshop Facilitation
• Stakeholder Engagement

WHAT?

Produced internal and external reporting, statistics, and partner insights for communication and planning.

WHY?

To ensure accurate figures for press, website updates, and partner decision‑making.

MY CONTRIBUTION

• Delivered validated numbers for press, internal updates, and public communication.
• Prepared partner‑ready insights for planning and construction projects.
• Built repeatable reporting outputs for stakeholders and leadership.

TOOLS

• Power BI
• Excel
• SQL
• VBA

WHAT?

Mentored a behavioral science student on a staff well‑being and change‑readiness survey during organizational change.

WHY?

To understand how employees experienced change and identify areas for supportive leadership actions.

MY CONTRIBUTION

• Supported survey design, interview approach, and analysis framing.
• Helped connect findings to leadership and change management needs.
• Provided guidance and feedback throughout the project.

TOOLS

• Change Management
• Survey Design
• Mentorship
• Leadership Support

WHAT?

Supported the implementation of Antura, a project, portfolio, and resource management system.

WHY?

To ensure a structured rollout with realistic budgeting and clear processes for how the tool would be used.

MY CONTRIBUTION

• Helped define implementation structure and timelines.
• Contributed to budget planning and scope alignment.
• Mapped how the system would be used in day‑to‑day processes.

TOOLS

• Antura
• Process Design
• Budget Planning
• Implementation Support

WHAT?

A shared Python package that brings reusable integration and ETL logic together for customer data flows, including Fortnox and student system data.

WHY?

To reduce duplicated logic, make new integrations easier to build and create a more consistent foundation for extraction, validation and loading into Snowflake.

MY CONTRIBUTION

• Developed reusable gateway and pipeline components for customer integrations.
• Worked with authentication, rate limiting, staged files and Snowflake loading.
• Contributed tests, configuration patterns and packaging for Azure Artifacts.

TOOLS

• Python
• Fortnox API
• Snowflake
• Azure Blob Storage
• Azure Key Vault
• Pytest
• Azure Artifacts

WHAT?

A production focused data flow that extracts business data from SAP ByDesign through OData, transforms it in Python and loads structured staging tables in SQL Server.

WHY?

To create a reliable foundation for reporting across customers, invoices, materials, budgets and other business areas, with clear traceability from source to reporting layer.

MY CONTRIBUTION

• Developed extraction and staging flows across seven business domains.
• Implemented validation, audit logging, safe reruns and transactional loading.
• Created test and production pipelines, operational documentation and a runbook for incident handling.

TOOLS

• SAP Business ByDesign
• OData
• Python
• SQL Server
• Azure DevOps
• Pytest
• Power BI