Christian Aguirre

Vul Scanning · Nessus Essentials · Network Discovery · Reporting

Built a small lab using Kali and Metasploitable and ran an authenticated Nessus scan to identify vulnerabilities. Reviewed the findings and created a report highlighting key risks and recommended remediation steps.

Skills: Vulnerability Scanning, Host Discovery, Authenticated SSH Scanning, Malware Detection, Remediation Analysis.

ServiceNow ITSM · Incident · Problem · Change · Governance

Configured a full ServiceNow ITSM environment covering Incident, Problem, and Change Management. Set up ticket workflows, assignment rules, and UI policies to ensure consistent routing, proper documentation, and controlled change processes.

Skills: ServiceNow ITSM, Incident Management, Problem Management, Change Management, UI Policies, and Risk Assessment.

Microsoft Entra ID · IAM Simulation · RBAC · Audit & Monitoring

Built a Microsoft Entra ID lab to simulate identity and access management in an enterprise environment. Created users and groups, set up role based access, and performed common helpdesk tasks like password resets and account changes. Also reviewed sign in activity and audit logs to understand user behavior and track changes.

Skills: Entra ID administration, identity lifecycle management, RBAC governance, authentication monitoring, audit investigation, helpdesk IAM workflows.

SOC Lab · Azure VM · Microsoft Sentinel · KQL

Deployed a Windows VM in Azure as a honeypot to capture real world attack activity. Collected event logs in Microsoft Sentinel, used KQL to analyze failed login attempts, and visualized attacker activity from different locations.

Skills: Azure administration, NSG configuration, Windows event logging, KQL analytics, SIEM operations.

Windows Server · AD DS · DNS · IAM · Helpdesk

Built an Active Directory lab using Windows Server 2022. Set up a domain, created users and groups, organized OUs, and managed access through group based permissions. Also performed common helpdesk tasks like password resets and account unlocks.

Skills: AD DS configuration, DNS setup, user lifecycle management, group/OU design, IAM fundamentals, helpdesk operations.

Python · ML · SHAP

Analyzed telecom customer data using Python to predict which customers might leave. Cleaned the data, built machine learning models, and used SHAP to understand the key factors driving churn.

Skills: Pandas, Scikit-Learn, Feature Engineering, Model Evaluation, SHAP Explainability.

Windows 10 · Sysmon · MITRE ATT

Built a Windows 10 lab with Sysmon to monitor and analyze system activity. Simulated attacker behavior and used event logs to track processes, network connections, and changes on the system, mapping findings to MITRE ATT&CK.

Skills: Sysmon, Windows Logging, Threat Detection, MITRE Mapping, Reporting.

Excel · KPI dashboards

Analyzed manufacturing data in Excel to track key performance metrics like delivery, cost, and retention. Built dashboards and used formulas to identify trends and highlight areas for improvement.

Skills: KPI Development, Excel Modeling, Advanced Formulas, Dashboard Design.

R · Tableau

Analyzed bike share data using R to understand how different customer types use the service. Identified usage trends across days and seasons, and built Tableau dashboards to highlight key insights.

Skills: R Programming, Data Manipulation, Cohort Analysis, Tableau Visualization.

Fitbit Data · Story Insights

Analyzed Fitbit data to understand user activity, sleep patterns, and overall engagement. Identified trends across days and behavior types, and provided insights to support product and wellness recommendations.

Skills: Exploratory Data Analysis, Data Cleaning, User Segmentation, Data Storytelling.

SQL Server · ETL

Redesigned a messy database into a clean, structured SQL Server system. Organized tables, set up relationships, and built queries to make the data easier to use for reporting and analysis.

Skills: Relational Schema Design, Data Normalization, SQL Optimization, ETL Development.

SQL pipeline · Standardization

Built a SQL pipeline to clean and standardize global layoffs data. Removed duplicates, fixed inconsistent fields, and prepared the dataset for reliable analysis and reporting.

Skills: SQL, SSMS, Window Functions, Data Quality, Data Standardization.

Excel · Modeling

Used Excel to build models that support decision making under different scenarios. Applied techniques like simulation, optimization, and decision trees to analyze outcomes and recommend the best options.

Skills: Optimization, Simulation, Decision Modeling.