// Felagot Desta — Resume
FelagotDesta.
// Data Analyst · Analytics Project Manager · Business Intelligence
Professional Summary
Data Analyst with 4+ years of cross-functional experience spanning healthcare, real estate, and technology, specialising in R programming, SQL Server, and automated analytics pipelines. Hands-on experience building production-quality data extraction workflows, statistical analyses, and ggplot2 visualisations against Microsoft SQL Server environments. Skilled at translating complex datasets into clear business insights, with a strong foundation in project delivery, stakeholder management, and technical documentation.
Professional Experience
Analytics Project Manager and Data Analyst
// Zoetis Reference Labs
2024 – Present
- Designed and built a semantic layer for LabDaq (SQL Server)that auto-generates panel-to-test mapping documentation in JSON, CSV, and Markdown, replacing tribal knowledge with a self-maintaining knowledge base for veterinary diagnostic tests.
- Developed a production-quality R analysis pipelinefor veterinary test positivity rates and volume trends, using Wilson score confidence intervals, seasonality analysis, and time-series decomposition to identify disease prevalence patterns for heartworm and tick-borne illnesses.
- Built modular R data pipelinesusing DBI/odbc, tidyverse, and ggplot2 to extract, transform, and visualise data from Microsoft SQL Server, applying deduplication patterns with ROW_NUMBER() OVER (PARTITION BY) and CTE-based extraction queries.
- Created production-quality ggplot2 time-series visualisationswith 95% confidence interval ribbons, faceted regional analysis, and matched summary tables to support veterinary diagnostics reporting.
- Established Git-based version control workflowson GitHub Enterprise, including branch-based development, pull request reviews, and reproducible code standards for cross-functional analytical work.
- Architected configuration-driven data modelsusing YAML config files, separating business logic from code to enable non-technical stakeholders to update analytical scope without code changes.
- Set up a local Microsoft SQL Server test environmentwith realistic seed data (1,000+ requisitions, 5,000+ test results across 6 tables) to enable offline development and testing of extraction queries before production deployment.
- Designed AI-agent documentation systemsusing ChatGPT Custom GPTs powered by auto-generated JSON files, enabling stakeholders to query panel-to-test relationships in natural language with source citations.
- Led cross-functional project delivery across data, analytics, operations, and technology initiatives, ensuring alignment between business needs and technical execution.
- Partnered with business users and technical teams to translate ideas and requirements into structured project plans and implemented analytical outcomes.
- Built and standardised PMO documentation including project charters, project plans, SOPs, meeting notes, action logs, and closure documentation.
Project Manager, Data and Analytics
// Greystar
2022 – 2024
- Built and deployed interactive Power BI dashboardswith DAX-based data models, drill-through capabilities, and executive-ready reporting serving stakeholders across leadership and operational teams.
- Led a large-scale database migrationfrom Azure Synapse to Databricks, including SQL query refactoring, data validation across multiple tables, stakeholder-facing risk tracking, and go-live coordination.
- Led the design and implementation of a custom AI agent toolto support accounting workflows, serving as a decision-support partner for reviewing data and answering business questions.
- Developed and analysed real estate and operational datasetsto identify trends, performance gaps, and revenue opportunities across property portfolios.
- Led data validation efforts for a new database environment, ensuring reporting accuracy, data consistency, and stakeholder confidence during transition.
- Owned the collection, cleaning, organisation, and management of departmental survey data, developing reusable reporting logic to support KPI analysis and leadership decision-making.
- Created data models and calculations using DAX to enable dynamic reporting and performance analysis across owned-asset and commercial real estate portfolios.
- Led end-to-end analytics projects within the Owned Asset Analytics team, from requirements gathering and data collection through validation, dashboard development, stakeholder review, and final reporting delivery.
Technical Skills
// Programming Languages
R (tidyverse, ggplot2, DBI/odbc)92%
SQL (CTEs, window functions, SSMS)91%
Python78%
DAX89%
// Data Analysis and Visualisation
ggplot2Power BITableau
DatabricksExcelRStudio
// Databases and Systems
MS SQL ServerSSMS 20
Azure SynapseDatabricks
ODBC connectionsSemantic Layers
// Statistical Methods
Wilson Score CITime Series Analysis
Seasonality DetectionRegression
ANOVA
// Development Tools and Pipeline
VS CodeGit / GitHub Enterprise
YAML configAuto-generating docs (JSON, CSV, MD)
Multi-format reportingConfig-driven pipelines
0+
Years Exp.
0+
Projects
0
Certs
// Delivery Success Rate
Education
BS — Project and Business Management
Unity University
Graduate Certificate — Business Management and Economics
Skyline College
Certifications
PMI
Project Management Professional (PMP)
Project Management Institute
PM
PMI
Certified Associate in PM (CAPM)
Project Management Institute
PM
MS
Azure Power BI Data Analyst Associate (PL-300)
Microsoft
BI
GOO
Data Analytics Professional Certificate
Google
DA
IBM
AI Engineering Professional Certificate
IBM
AI
SCR
Advanced Scrum Certification
Scrum Alliance
AG
SKY
Graduate Certificate — Business Management
Skyline College
BM
PM Tools
AgileScrumWaterfall
SDLCSmartsheetJira
AsanaAzure DevOpsNotion
MS Project
Industries
🏥 Healthcare
🏢 Real Estate
💻 Technology
💰 Finance
🛒 E-Commerce
👥 HR Analytics