Juan Pablo Mercado Arizmendi jp-software-dev

Juan Pablo Mercado Arizmendi

Data & Security Analyst Jr. | Full Stack Software Developer
"Building scalable architectures, extracting actionable insights, and defending infrastructure through data-driven security."

🛡️ About Me

Computer Systems Engineer and Programming Technician with a solid 6-year academic track record. I have +2 years of professional experience in Full Stack software development applied to business digitalization, and +1 year of total immersion in Hybrid Cybersecurity (Blue Team & Red Team).

My methodology bridges the gap between software engineering, data intelligence, and corporate security. With an advanced focus on Security Data Analytics, I am an expert in extracting and transforming complex data volumes using SQL and Python, translating technical data into actionable intelligence and high-impact visual assets to mitigate corporate risks.

Backed by elite international credentials: SC-200, PL-300, CySA+, SPLK-1001, and CLF-C02.

💻 Areas of Expertise

📊 Data Intelligence: Database architecture and complex queries using advanced SQL and Python (Pandas, Scikit-Learn). Design of interactive executive dashboards with Microsoft Power BI (DAX) and Advanced Excel for strategic decision-making.
🛡️ Security Analytics & Cyber Defense: Operations in SIEM (Microsoft Sentinel, Splunk), Threat Modeling (MITRE ATT&CK), Detection Engineering (Sigma Rules, YARA), Incident Management (SecurityOnion), and Digital Forensics on Windows systems.
🥷 Offensive Security & Red Team: Web and network pentesting, vulnerability analysis and exploitation (OWASP Top 10), post-exploitation (Metasploit, Burp Suite, Nmap), development of offensive exploits/scripts with Python (Scapy), and OSINT investigations.
⚙️ Infrastructure & Corporate Defense: Security and auditing in Active Directory environments (Kerberos, BloodHound), Containerization (Docker), server administration and automation with PowerShell, Cloud Management (AWS), TCP/IP Network Architecture, and Monitoring (Wireshark, Pfsense).
🌐 Full Stack Software Engineering & AI: Architecture, development, and deployment of solutions adapted to complex business logic. Integration of AI & Deep Learning (CNNs, LangChain). Management of the Software Development Life Cycle (SDLC) under agile methodologies using Python, PHP, JavaScript, TypeScript, and frameworks like Angular, Laravel, and Flask.