ForgeQuill

Resume

Business Intelligence | SQL Server | Power BI | ETL | Data Analytics

I am a Business Intelligence and Data Analytics professional with experience delivering reporting, database solutions, ETL processes, and analytical systems across research, healthcare, and telecommunications.

Over the past two decades, I have worked on projects involving survey operations, SQL Server databases, production BI support, Power BI dashboards, data warehousing, and business process automation. My work combines technical implementation with business understanding, helping organizations transform complex data into reliable reporting and decision-making systems.

Recently, my focus has been on SQL Server, SSIS, Power BI, ETL monitoring, production BI operations, and documenting enterprise data warehouse pipelines.

Location: Islamabad, Pakistan
Availability: Open to Onsite • Remote • Contract Opportunities


Core Competencies

  • Business Intelligence
  • Power BI Dashboard Development
  • SQL Server Development
  • ETL & SSIS
  • Data Warehousing
  • SQL Query Optimization
  • Production BI Operations
  • Survey Systems & Data Collection
  • Database Design
  • Data Analysis & Reporting
  • Python Automation
  • Research Data Management

Professional Experience

BI & Data Analyst

ESoft Solutions – Islamabad, Pakistan
February 2026 – July 2026

Supported daily Business Intelligence operations for a large telecom environment by monitoring production ETL processes, SQL Server jobs, and Power BI reports.

Key Responsibilities

  • Monitored SQL Server Agent jobs and production ETL workflows.
  • Investigated Power BI refresh failures and production issues.
  • Documented data warehouse pipelines and business logic.
  • Optimized SQL queries to improve Power BI refresh performance.
  • Built operational dashboards for:
    • SQL Job Monitoring
    • Server Storage Monitoring
    • Report Usage Analytics
    • Table Growth Analysis
    • Data Quality Monitoring
  • Managed report access and user permissions.
  • Worked closely with BI developers on production support.

Environment

SQL Server • SSIS • Power BI • Python • Excel


Data Analyst

UAH Technologies LLC – Dallas, Texas, USA
May 2023 – April 2025

Developed reporting solutions and analytical dashboards for healthcare and insurance clients.

Key Responsibilities

  • Gathered reporting requirements from business users.
  • Built Power BI dashboards.
  • Validated ETL outputs before production deployment.
  • Worked with:
    • Healthcare Claims
    • Patient Satisfaction
    • Electronic Health Records
  • Performed SQL validation and reporting analysis.

Environment

Power BI • SQL • Excel


Data Analyst

Gallup Pakistan
January 2018 – December 2022

Worked on national and international research projects involving survey operations, database development, data processing, and analytical systems.

Key Responsibilities

  • Developed a nationwide sampling framework using census data.
  • Introduced digital survey collection using ODK and SurveyCTO.
  • Built databases and automation tools for research operations.
  • Supported projects covering:
    • Elections
    • Telecommunications
    • Trade
    • Taxation
    • Public Opinion Research
  • Digitized and organized historical research archives.
  • Prepared survey datasets for statistical analysis.
  • Worked closely with researchers to produce analytical outputs.

Environment

SPSS • Excel • Microsoft Access • Power BI • Visual Basic


Earlier Experience

Data & Research Projects

2000 – 2017

Worked on numerous projects involving:

  • Survey Processing
  • Database Development
  • Sampling Systems
  • Statistical Reporting
  • Trade Research
  • Telecom Research
  • Data Management
  • Research Automation

Technical Skills

Business Intelligence

  • Power BI
  • SSRS
  • Microsoft Excel

Databases

  • SQL Server
  • Microsoft Access

ETL & Data Engineering

  • SSIS
  • SQL Server Agent
  • Data Warehousing

Programming

  • SQL
  • Python
  • Visual Basic

Analytics

  • SPSS
  • Power Query
  • DBeaver

Education

Master of Science (MS) – Information Technology
Preston University


Certifications

  • IBM – ETL & Data Pipelines
  • DeepLearning.AI – Supervised Machine Learning
  • University of Michigan – Python Programming
  • Google – IT Security Fundamentals

Portfolio

The projects highlighted on this website represent a selection of my work across Business Intelligence, survey systems, data engineering, and analytics.

Featured work includes:

  • Power BI Performance Optimization
  • Nationwide Sampling Framework
  • Digital Survey Transformation
  • Research Archive Modernization
  • International Trade Data Analysis
  • Survey Operations Automation
  • Smart Lead Operations
  • Census-Based Decision Intelligence

Explore the full portfolio in the Case Studies section.


Professional Recognition

My work has also been acknowledged in several published research reports covering survey operations, data processing, and analytical support.

View Professional Recognition


Contact

Email: manzerehsan@gmail.com

Phone: +92 300 5083488

LinkedIn: www.linkedin.com/in/manzer-ehsan-65183822

Scroll to Top