Farzeena P.

I help businesses turn messy operational data into clear dashboards, reliable reports, and actionable decisions. I’m a Data & Decision Analyst with nearly 3 years of experience in operational analytics, KPI reporting, workforce planning, data validation, business-system data, and decision support. My work sits between data analysis and business decision-making. I don't just build charts. I work with the underlying data, validate it, understand the business problem, and build analytical solutions that help teams decide what to do next. ### What I can help you with 📊 Power BI & Business Intelligence * Interactive Power BI dashboards * KPI and performance dashboards * Executive / management reporting * DAX measures * Power Query transformations * Data modelling * Dashboard optimization * Automated recurring reporting 🧮 SQL & Data Analysis * SQL querying and data extraction * Data cleaning and transformation * Data validation and reconciliation * Root-cause analysis * Variance analysis * Trend and performance analysis * Multi-source data analysis * ERP/database reporting ⚙️ Reporting & Automation * Excel reporting automation * Power Automate workflows * Automated recurring reports * Data refresh and reporting processes * Operational reporting pipelines * n8n automation 👥 Workforce & Resource Planning Analytics * Workforce demand analysis * Capacity analysis * Resource allocation * Manpower planning * Workload analysis * Budget vs. actual analysis * Staffing gap analysis * Scenario analysis 📈 Operational & KPI Analytics * KPI framework development * Performance monitoring * Operational backlog analysis * Maintenance / ticket analytics * Regional and departmental performance analysis * Anomaly investigation * Data quality checks 🧮 Optimization & Prescriptive Analytics I also build mathematical optimization models for operational decision-making. Examples include: * Supplier allocation optimization * Workforce allocation * Capacity planning * Resource allocation * Cost vs. capacity optimization * Scenario modelling * Linear programming I use optimization to answer questions such as: “Given our costs, capacity, demand and operational constraints, what should we actually do?” ### Tools I work with Power BI | SQL | Excel | DAX | Power Query | Python | Power Automate | n8n | PostgreSQL | SQL Server | MySQL | Odoo CRM | Microsoft Business Central ### Examples of my work • Reduced a SQL-based reporting process from approximately 45 minutes to under 10 minutes. • Automated recurring Excel reporting using Power Automate, eliminating approximately 25 hours of manual work per month. • Built Power BI reporting solutions from stakeholder requirements and validated reported KPIs against underlying database records. • Analysed workforce demand, expenditure, resource distribution, capacity gaps and workload imbalances. • Built a linear programming model for procurement allocation, balancing cost, supplier capacity and delivery constraints. • Built workforce optimization scenarios to evaluate staffing gaps and alternative resource requirements. If you need someone who can understand the business problem, work with the underlying data, build the analysis, and turn it into something decision-makers can actually use, that's where I can help.