Data Cleaning & Quality
Standardizing information, reviewing duplicates and missing values, and applying consistency checks to create reliable datasets.
Turning complex information into better decisions.
Manuel
Estevez
Analysis · Reporting · Data Quality
Risk Analysis · Process Improvement
Analytical professional with 19+ years of experience working across data, audit, risk, reporting, business rules, and operational systems. Strong hands-on experience with Advanced Excel, Oracle SQL, IBM Cognos BI, and large-volume data analysis.
01 / Professional identity
Experienced judgment applied to data, systems, and operations.
I turn complex operational information into reliable analysis, clear reporting, and decisions people can act on.
My background combines high-volume data analysis, reporting, validation, reconciliation, risk assessment, and evidence-based review. I have spent years working with operational data and business rules where accuracy, consistency, and traceability matter.
Advanced Excel, Oracle SQL, and IBM Cognos BI form the core of my professional toolkit. Python, Power BI, and Tableau extend that established analytical foundation with modern approaches to data preparation, visualization, and repeatable workflows.
02 / Core capabilities
Where I create value
Practical capabilities developed through years of analytical, operational, and audit-focused work.
Validation & Reconciliation
Comparing sources, matching records, verifying accuracy, and isolating discrepancies that require attention.
Data Integrity & Exception Analysis
Identifying anomalies, incomplete records, invalid values, and patterns behind data or process problems.
Reporting & Business Intelligence
Turning operational data into structured reports, KPIs, trends, and clear visual information for decision-makers.
Risk, Audit & Controls
Reviewing evidence, applying business rules, prioritizing exceptions, and supporting traceable, risk-based decisions.
Process Improvement & Data Operations
Strengthening repeatable workflows, information quality, operational consistency, and review efficiency.
03 / Business + Technology
Connecting business knowledge with data and systems.
My work has often required translating operational needs, complex business rules, and risk criteria into system parameters, analytical logic, reporting, and data-driven controls.
This combination helps me understand not only how information is processed, but why it matters to the people and operations that depend on it.
Business needs→Data & rules→Operational decisions
04 / Career perspective
A long-standing analytical career built in complex operational environments.
Years of analytical and audit-oriented professional work
Years combining data, risk analysis, reporting, and system controls
Extensive Oracle SQL use for operational analysis and reporting
Established reporting experience with IBM Cognos and Excel
05 / Experience
Selected professional experience
Transferable analytical experience developed within Customs of El Salvador.
2010—2024
Ministry of Finance · Customs Intelligence Unit, Risk Management Department
Customs Risk Analysis & Management Auditor
Analyzed high-volume transactional data and supporting records to identify anomalies and risk indicators. Performed ETL on Oracle data, used Oracle SQL for operational analysis and reporting, produced analytical outputs with IBM Cognos BI and Advanced Excel, and translated business rules into risk-system parameters and data-driven controls.
2005—2010
Ministry of Finance · Customs Audit Department
Customs Tax Auditor
Reconciled transactional, financial, and supporting records across multiple sources; investigated discrepancies; evaluated audit evidence; maintained traceability across reviews; and prepared formal reports and corrective recommendations based on verified information.
06 / Technical strengths
Tools organized by professional use
Technology supports the work: reliable data, clear analysis, and useful reporting.
Data Analysis & Quality
Advanced Excel · Oracle SQL · Python
Power Query, Power Pivot, PivotTables, advanced formulas, cleaning, validation, reconciliation, and large-dataset analysis.
Business Intelligence
IBM Cognos BI · Power BI · Tableau
Professional reporting experience with Cognos, extended by modern dashboard, KPI, visualization, and data-storytelling capabilities.
Databases & Querying
Oracle SQL · SQL · MySQL
Data extraction, complex analysis, ETL, reporting, risk analysis, audit support, and work with transactional data.
Programming & Automation
Python
Data analysis, cleaning, transformation, reporting support, and repeatable workflow development.
07 / Professional foundation
Deep context behind the analytical work.
Risk Analysis
Fourteen years combining transactional data, business rules, reporting, audit judgment, and system controls.
Audit & Accounting
A B.S. in Public Accounting and extensive experience reviewing records, evidence, discrepancies, and formal findings.
Customs & Trade
Domain expertise in complex import/export operations and documentation—the environment where many transferable skills were developed.
08 / Portfolio
Selected Data Projects
Practical case studies demonstrating how I approach data quality, reconciliation, reporting, risk analysis, and process improvement.
These case studies use simulated business scenarios and sample data to demonstrate analytical methods, workflows, and reporting approaches.
Reconciliation overviewPortfolio case study
Sample records reviewed12,480Two simulated source systems
Matched 98.7%Exceptions 159Review output Ready
Data quality & reconciliation
Cross-System Reconciliation & Exception Analysis
Compare records from two operational sources, identify missing or inconsistent values, classify exceptions, and prepare a clear reconciliation report for review.
Migration readinessPortfolio case study
Mapped fields42 / 45Rule checks18ReadinessReview
Migration validation
Data Migration Readiness & Exception Review
Map source and target fields, standardize records, validate conversion rules, and surface issues before migration.
Operational performancePortfolio case study
84%
Reporting & KPI analysis
Operational Reporting & KPI Analysis
Transform operational activity into a focused view of volume, quality, exceptions, trends, and priorities for action.
Portfolio framework
From business problem to visible evidence.
- 01Visual result
- 02Business problem
- 03Data context
- 04Data process
- 05Visual evidence
- 06Tangible result
- 07Technical details
09 / Contact
Let’s start a professional conversation.
Open to opportunities involving data quality, reporting, reconciliation, records operations, risk analysis, and process improvement.
Connect on LinkedIn