Zana Dulla
New York
Summary
Systems and Business Analyst with 8+ years of experience translating operational workflows and stakeholder needs into technical requirements, system improvements, and reporting solutions. Experienced in requirements gathering, process analysis, documentation, and user acceptance testing across government, public-service, and enterprise environments. Strong background collaborating with cross-functional stakeholders, defining KPIs, validating system outputs using SQL, Advanced Excel and Python and supporting Agile project delivery. Proven ability to act as liaison between business users and technical teams to deliver reliable, user-centered solutions.
Overview
4
4
Languages
13
13
years of professional experience
Work History
Analyst II
Saint Barnabas Hospital
04.2026 - Current
- Configure and support Epic Healthy Planet applications, registries, quality measures, and population health workflows.
- Analyze clinical and operational data using SQL, Advanced Excel, and Power BI to develop dashboards, reports, and actionable insights.
- Utilize Advanced Excel (PivotTables, Power Query, Power Pivot, XLOOKUP, INDEX/MATCH, advanced formulas, and dashboards) to analyze large datasets and automate reporting.
- Collaborate with clinicians, operational teams, and IT to optimize workflows and support value-based care initiatives.
- Perform system testing, troubleshoot production issues, validate data, and document application enhancements while ensuring HIPAA compliance
Data Analyst
Sharp 1 IT
09.2024 - 03.2026
- Gathered business requirements from marketing and account stakeholders and translated needs into reporting specifications and data definitions.
- Defined KPIs and acceptance criteria for client performance tracking systems.
- Collaborated with engineers and product teams to validate system outputs and ensure requirements alignment.
- Developed Advanced Excel dashboards and automated reports using PivotTables, Power Query, XLOOKUP, and advanced formulas to analyze KPIs, monitor client performance, and improve reporting efficiency.
- Documented reporting workflows, data sources, and business logic for ongoing operational support.
- Investigated user issues and identified root causes, recommending system or process improvements.
Web Developer, EUROPEAN PARLIAMENT
European Parliament
05.2021 - 04.2022
- Led a large-scale data and content migration from a legacy platform to a modern architecture, transferring 21 institutional websites across 24 languages, using SQL and Python to validate datasets and ensure zero data loss and uninterrupted public service delivery.
- Analyzed legacy business processes and documented functional requirements for migration of 21 public-service websites.
- Acted as a liaison between content stakeholders, translators, and engineering teams to ensure system functionality met operational needs.
- Developed data validation and testing procedures to verify system outputs and ensure data accuracy.
- Supported system integration testing and coordinated user validation prior to release.
- Standardized metadata structures and documentation to improve system maintainability and compliance.
Database Administrator
Ministry of Internal Affairs
08.2017 - 04.2021
- Led a national data platform initiative consolidating multi-agency government databases into a single, country-wide system, serving as Database Administrator responsible for data integrity, security, access control, and system reliability.
- Managed and analyzed 50M+ enterprise records, enforcing strict data accuracy, integrity, confidentiality, and governance standards across government datasets.
- Served as a technical and data advisor during national procurement, evaluating vendor database architectures, security models, and scalability to help determine which company would operate the country's end-to-end software systems.
- Designed and implemented SQL- and Python-based data collection, validation, and audit tools, supporting regulatory reviews, performance evaluations, and continuous improvement initiatives.
- Leveraged Advanced Excel to analyze millions of government records, create automated audit reports, monitor data quality, and support executive reporting through PivotTables, Power Query, and advanced formulas.
- Identified process inefficiencies and contributed to a 90% reduction in manual administrative work.
IT Instructor / Systems Training Specialist
Kolin Gjoka High School
09.2016 - 05.2017
- Translated technical concepts (databases, programming, and information systems) into clear operational instructions for non-technical users.
- Developed structured training materials, user guides, and documentation for system usage and troubleshooting.
- Led classroom and hands-on workshops, improving user adoption and understanding of software systems and data processes.
- Evaluated user comprehension and gathered feedback to refine instructional approach and improve learning outcomes.
- Supported institutional website maintenance and resolved user-reported issues, acting as first-level support between users and technical systems.
- Designed curriculum aligned to real-world IT workflows, including database usage, data management, and system navigation.
Finance Specialist
Dulla 2001 shpk
01.2015 - 06.2016
- Improved accuracy by 15% in monthly management accounts by ensuring timely reconciliations.
- Manage invoicing and banking operations, optimize cash flow.
- Supported year-end audits and tax preparation, enhance accuracy.
Project Specialist
National Agency Of Natural Resources / Hydropower Energy Directorate
04.2013 - 05.2014
- Supported national hydropower energy operations across all major river basins in Albania, providing analytics for energy production, environmental compliance, and infrastructure performance.
- Analyzed operational and financial data for river-based hydropower concessions, monitoring utilization, downtime, cost efficiency, and regulatory milestones.
- Developed Excel and Tableau dashboards to track hydropower project performance, river-based energy output trends, and compliance with environmental and water-resource regulations.
- Cleaned, validated, and managed large-scale hydropower and river system datasets using SQL and Python, ensuring accuracy, consistency, and audit readiness.
- Prepared analytical reports, charts, and summaries to support energy planning, river resource management, and regulatory decision-making.
- Maintained standardized reporting documentation to support long-term national hydropower programs and multi-year regulatory reporting cycles.
Education
Data Analytics Bootcamp -
Springboard
New York, United States01-2023
Bachelor - Finance & Accounting
University of Tirana
Albania01-2017
Master Of Science - Computer Science
University of New York
Albania01-2013
Bachelor - Telecommunication Engineering
Polytechnic University of Tirana
Albania01-2011
Skills
- Systems & Analysis Tools: SQL
- Excel
- Visualization & Reporting: Power BI
- Tableau
- Programming: Python (Pandas, NumPy)
- Business Analysis & Systems Skills: Requirements Gathering And Documentation
- Process Mapping And Workflow Analysis
- User Acceptance Testing (UAT)
- Stakeholder Interviews
- Product Backlog Prioritization
- Agile / Scrum Collaboration
- Functional Specifications
- System Integration Validation
- MS Excel
- Analytical thinking
- Microsoft office
Languages
English Native
ALBANIAN Native
Italian Intermediate
Spanish Intermediate
Timeline
Analyst II
Saint Barnabas Hospital
04.2026 - Current
Data Analyst
Sharp 1 IT
09.2024 - 03.2026
Web Developer, EUROPEAN PARLIAMENT
European Parliament
05.2021 - 04.2022
Database Administrator
Ministry of Internal Affairs
08.2017 - 04.2021
IT Instructor / Systems Training Specialist
Kolin Gjoka High School
09.2016 - 05.2017
Finance Specialist
Dulla 2001 shpk
01.2015 - 06.2016
Project Specialist
National Agency Of Natural Resources / Hydropower Energy Directorate
04.2013 - 05.2014
Bachelor - Telecommunication Engineering
Polytechnic University of Tirana
Master Of Science - Computer Science
University of New York
Bachelor - Finance & Accounting
University of Tirana
Data Analytics Bootcamp -
Springboard