Jeisson - JR Power BI Analyst

Experiencia demostrada en SQL (MySQL).

Experiencia demostrada en Python.

Experiencia demostrada en Descriptive & inferential statistics.

Experiencia demostrada en hypothesis testing fundamentals.

Experiencia demostrada en linear regression.

Conducted requirements gathering with cross-functional stakeholders to define project scope, KPIs, and data sources across 12+ open-source analytics initiatives, mapping AS IS data availability against TO BE reporting needs.. Designed and published 12+ open-source analytics projects integrating data from multiple institutional sources (IMF, World Bank) for 54 countries, applying conflicting-source reconciliation and heterogeneous dataset normalization.. Built a SQL analysis pipeline on African road infrastructure (FRST dataset), reconciling paved/unpaved distributions, accessibility risk, and regional disparities — demonstrating investigative capacity in complex data environments without clean join keys.. Developed a Power BI solution for Illicit Financial Flows analysis integrating macroeconomic indicators, investment positions, and financial risk KPIs via dimensional modeling, reducing data interpretation time for non-technical analysts.

Led requirements-gathering sessions with clients, documenting AS IS manual processes and designing TO BE automated workflows to translate business needs into technical specifications, KPI definitions, and dashboard scope prior to development.. Automated client workflows using Power Automate (Outlook-to-Excel data extraction) and designed Kanban-based project management systems in Google Sheets, improving process visibility and reducing manual work.. Developed a Python-based options-trading decision dashboard integrating a market-data API, defining KPI granularity and volatility-based decision logic (VIX regime, RSI/SMA 20/50/100) to filter contracts by annualized return and liquidity thresholds.. Delivered automated Power BI and Excel dashboards for e-commerce, sports, nonprofit, and marketing clients, reducing manual reporting cycles by 30–50% per project.. Built SQL (MySQL) and Python (Pandas) data pipelines processing datasets of 50K to 13M+ records; automated 5+ Google Sheets workflows reducing manual effort by 25%.. Developed e-commerce analytics dashboards for Amazon with real-time API integrations and applied funnel/cohort analysis in GA4, and performed multi-source data analysis (MLB/MiLB statistics), reconciling discrepancies across platforms for non-technical audiences.

Facilitated requirements-gathering sessions with organizational leadership, mapping the AS IS state (no consolidated reporting) against a TO BE vision to define reporting priorities across donations, expenses, and supplier data.. Built an interactive Power BI dashboard integrating and normalizing multiple financial datasets (donations, expenses, suppliers, multi-year trends), enabling data-driven decisions by executive leadership for the first time in the organization.. Identified cost-saving opportunities and multi-year trends through consolidated data analysis, communicating findings directly to non-technical executives via decision-oriented presentations.

Gathered case requirements from adjusters and stakeholders to define documentation standards and ensure accurate, complete data collection.. Managed insurance claims processing in English, coordinating with adjusters, collecting case data, and maintaining documentation quality in case management systems, developing detail-oriented data handling skills in regulated environments.

Gathered institutional reporting requirements from stakeholders to guide case documentation standards and compliance data collection.. Documented and analyzed case data in the SIM system; managed institutional correspondence and applied qualitative data skills to support compliance reporting.