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

Programming Technician and Computer Systems Engineer 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). I specialize primarily in the Blue Team area across two distinct focuses: Data Analytics and Security Analytics, leveraging my foundational knowledge of Red Team tactics to proactively anticipate, detect, and mitigate threats.

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

💻 Areas of Expertise

🛡️ Security Analytics & Blue Team Operations: My primary focus. 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 Knowledge): Web and network pentesting, vulnerability analysis and exploitation (OWASP Top 10), post-exploitation (Metasploit, Burp Suite, Nmap), and development of offensive scripts with Python (Scapy) to better understand and build defensive mechanisms.
📊 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.
⚙️ 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.