Data Analyst & Systems Administrator with a 10+ years operational background. Specialized in developing custom ETL pipelines, automating data workflows, and managing System of Record architectures for large-scale public and private programs. Proficient in leveraging programming languages, command-line scripting, business visualization software/frameworks, API orchestration/implementation and AI agents/models. With a strong drive to dive deep into data, build scalable reporting frameworks, uncover trends and anomalies, and translate complex operational metrics into clear insights.
Python (Data Analysis & Scripting) | SQL | SQLite | Power Query (M) | DAX | Pow-erShell | Bash BI & Visualization: Power BI | Matplotlib | Seaborn | Plotly | Visio | Mermaid | Marimo | Jupyter Notebooks
SharePoint (Admin) | SalesForce (Admin Configuration & CRM Management) | Mi-crosoft 365 | Azure Notebooks | SmartSheet | Airtable | Google Workspace | ArcGIS (Survey123) Automation & Integration: Power Automate | Zapier | REST API
MS Copilot | Gemini | Local AI Agents & Frameworks (PI Agent, Ollama, llama.cpp)
-
- 🔭 I’m currently a freelance Data Analyst
-
- 📈 I'm addictive to productivity and learning
-
- 😎 I think MS excel is fun, I love list comprehension!
-
- 🌱 I’m advance user of PBI, DAX, Python Pandas
-
- 🌱 I’m currently learning how to work with Local AI Models
-
- 📫 How to reach me: X 📧urena.jose@gmail.com, @linkedin, 🐘Mastodon
Mental Health & Covid-19 aftermath Medium Article
Data Exploration based on National Institute of Mental Health (NIMH) 2019 Report. ML Model | Data Visualization | Statistical Analysis | PCA | Plotly | Matplotlib
- Wrangled, explored, and created Pandas DataFrame with data sets to prepare foundation for project
- Created Plotly & Matplotlib visualizations to easily present data to general public
- Ran statistical analyses of national, regional and state mental health facilities’ data with PCA and T-test
SalesForce\CRM Implementation & management Indeed Assessment
Implemented SalesForce for Sales, Marketing, Customer Service teams
- Salesforce | Excel | SQL | Microsoft Server |
- Implemented Salesforce to build user accounts’ page layouts and dashboards to track clients and deliver reports for sales representatives and management
- Extracted, cleaned, merged data from SQL, Excel, ACT, Outlook, and other databases
- Queried and extracted SQL data & merge with Salesforce Data for UK FTSE 500
https://www.youtube.com/watch?v=a5oeEhTf6_M
https://medium.com/@joseurena/tesseract-ocr-evaluating-handwritten-text-recognition-1c6db85b2e7f
