# Richard Ampie Chamorro
**Data Engineer**

**Location:** Managua, Nicaragua
**Contact:** Tel: +505 76896537 | rampiechamorro14@gmail.com | [LinkedIn Profile](https://www.linkedin.com/in/richard-ampie-218a07247/)

---

## Profile
**Senior Data Analyst & Data Engineer** (Microsoft Certified Data Engineer & Analytics Engineer Associate) who turns messy financial and sales data into reliable decision systems. I design and ship SQL/Fabric/Power BI solutions that reduce refresh times, cut capacity costs, and standardize governance across IT, Finance, Sales, Logistics, Accounting, and Tax. My focus: measurable impact, clean architectures, and pragmatic best practices.

## Signature Outcomes
* Standardized BI governance (PBIP reports + Azure DevOps (Git Integration) + Deployment Pipelines Dev/Test/Prod), lead time to release cut from 72h to ~30h (-60%) the end-to-end process.
* Migrated 80+ reports hands-on and led ~150 more from Tableau/Excel/PPT to Power BI. Replaced manual ETL process and PDF distribution, bringing post-update incidents down ~90%.
* Built a reliable Microsoft Fabric data warehouse for Finance/Sales/Ops/Marketing, replacing unstable SSIS jobs. Cut ingestion from 3 hours to 1 hour (~67%) and made other pipelines ~50% faster.
* Reduced Fabric compute/capacity usage by ~50% implementing incremental loads; added pre/post-load data checks and monitoring to prevent missed loads.

## Experience

### NowOptics
**SQL & BI Developer Lead** (Apr 2025 - Present)
* Build and optimize semantic models and SQL workloads in Fabric/Power BI focused on reliability and lean refresh cycles.
* Drive cost-aware designs and clean handoffs for business users.
* **Selected impact:**
  * Delivered ~30 Tableau-to-Power BI migrations plus new dashboards with 5-20 min refresh, reducing manual work and stabilizing day-to-day delivery for 350+ users.
  * Implemented Git integration (with Azure DevOps and deployment pipelines) for Power BI (PBIP) to streamline report development, enable safe rollbacks, and keep Dev/Test/Prod workspaces organized and auditable.
  * Partnered with Finance/Sales/Marketing/Ops to standardize KPIs and definitions, reducing daily decision latency and preventing conflicting "versions of truth."
  * Monitored and optimized Microsoft Fabric capacity consumption; identified bottlenecks and tuned refresh (partitioning, concurrency, scheduling, query optimization), reducing throttling incidents by ~50% while meeting daily SLAs.
  * Enforced workspace governance standards (Dev/Test/Prod separation, RBAC least-privilege, naming, certified datasets, and the implementation of best practices in development).
* **Toolbox:** SQL Server/T-SQL, Power BI (DAX/M language), Microsoft Fabric (Lakehouse/Warehouse, Data Factory Pipelines, PySpark/Python Notebooks), Azure DevOps (Git integration).

### Holding Group Echamorro Monisa
*(Jun 2021 - Mar 2025)*
*Subsidiaries: Echamorro Industrial S.A., Droguería Rocha S.A., Farmacity S.A., WAPI Industrial S.A., among others.*

**Senior Data Analyst (IT Department)** (Jan 2023 - Mar 2025)
* Led BI modernization across the group, moving from fragmented reporting to governed analytics by implementing a Microsoft Fabric data warehouse and leading the Tableau-to-Power BI migration.
* **Selected impact:**
  * Led the Tableau → Power BI migration (~50 reports / 60 users), improving accessibility and reducing maintenance.
  * Built the Microsoft Fabric lakehouse/warehouse from scratch, migrating an unstable SSIS-based DWH.
  * Reduced long-running loads from over 2 hours to ~1 hour via incremental loading patterns, partitioning, and query tuning, with pre/post-load validations and monitoring to prevent missed loads.
  * Standardized KPIs and automated refresh/delivery; month-end close now 2.5 days (was 5, 50% faster) and daily reports ship automatically instead of failing or being sent by hand.
  * Administered the Azure/Entra ID tenant for BI: created security groups, provisioned users, and managed M365/Power BI Pro/PPU/Fabric licenses.
  * Managed Power BI workspaces and capacity assignments (roles, access reviews, ownership/naming standards), keeping environments audit-ready and reducing access issues.
* **Toolbox:** Microsoft Fabric (Data Factory, Lakehouse, Warehouse), Azure Portal, Power BI (DAX, Tabular Editor, Power Query), SQL Server/SSIS/SSRS, Excel/Power Pivot.

**Accounting Assistant & Financial Analyst** (Jun 2021 - Dec 2022)
* Responsible for supporting the accounting and financial management of the group, leading key tasks in report preparation, reconciliations, and financial analysis to assist strategic decision-making.
* **Selected impact:**
  * Built Excel templates for withholding tax, fiscal credit, and income/ISC that automated data cleaning and validations.
  * Prepared and filed returns in Nicaragua's tax system (VET), reducing tax-prep time by ~1.5 days per cycle.
  * Recorded expenses, amortizations, and other financial transactions to ensure accurate and up-to-date accounting records.
  * Standardized and automated finance workflows (bank and AR/AP reconciliations; OPEX variance and budget-to-actuals for expenses/costs; financial statement comparatives and cash-flow variance analysis; payroll postings/analysis), replacing manual steps and cutting the month-end close by about 2 days.

## Technical Skills
* **English:** Advanced (C1)
* **Advanced:** Power BI (Microsoft Certified), Microsoft Fabric (Microsoft Certified), SQL Server, MySQL, Excel, Power Query, and Power Pivot
* **Intermediate:** SSRS & SSIS, Python & PySpark for Data Engineering, HTML, CSS, and JavaScript, Git and GitHub/Azure DevOps, Azure/Office Management
* **Basic:** R for Statistical Analysis
* **Other:** Proficient in ERP Softland, Application Development with Power Apps, Process Automation with Power Automate

## Soft Skills
* **Leadership:** Ability to motivate and guide teams toward achieving common goals.
* **Effective Communication:** Excellent skills in conveying ideas and results clearly and concisely.
* **Teaching and Mentorship:** Passion for teaching and mentoring colleagues, helping them develop their skills and reach their full potential.
* **Teamwork:** Strong ability to foster collaboration and cohesion within teams to create a productive work environment.
* **Problem-Solving:** Skilled at identifying and resolving issues efficiently and effectively.
* **Adaptability:** Quick to adjust to new challenges and work environments.

## Technical and University Education
* **2025:** Git and GitHub Certification, Microsoft Data Engineering Certification
* **2024:** Enrolled in Computer Engineering (currently in 2nd year), Microsoft Fabric Certification, and additional certifications in Project Management and Soft Skills
* **2022-Present:** Final-year student in Public Accounting and Finance (4th and last year)
* **2023:** Certificate in Data Analysis, Python for Data Science, and SQL Server Integration Services
* **2022:** Certificate in Power BI, SQL, and Tableau
* **2021:** Certificate in Advanced Excel and Finance for Non-Financial Professionals
* **2019-2021:** Technical High School Diploma in Accounting