Senior Data Analyst | Data Engineer | Business Intelligence Analyst
baranalance@gmail.com | LinkedIn | GitHub
I am a Computer Science graduate currently pursuing a Master of Science in Business Analytics. If you have a knack for everything tech like I do, let's connect!
• Designed and maintained 12+ Power BI dashboards with advanced DAX metrics.
• Built end-to-end data pipelines and statistical models using Python and Google BigQuery.
• Managed PostgreSQL databases and validated healthcare-related data for accuracy.
• Conducted analysis on inventory and customer data using Excel, Python, and MySQL.
• Automated reporting and business processes using Python and Zapier.
• Collaborated with cross-functional teams to optimize data-driven decisions.
• Built automation tools for querying MySQL data using Python and Power Automate.
• Created data visualizations and ad-hoc reports using Power BI.
• Defined technical specs and supported UAT for analytics projects.
• Master of Science in Business Analytics – Quantic School of Business and Technology, Washington, USA (August 2025 – October 2026)
• Bachelor of Science in Computer Science – Saint Louis University, Baguio, Philippines (2019–2023)
• Senior High School – Regional Science High School III, Subic Bay Freeport Zone, Philippines
• Junior High School – Regional Science High School III, Subic Bay Freeport Zone, Philippines
• Designed and deployed scalable data infrastructure and ETL pipelines (Python, SQL).
• Used AWS and GCP to build cloud-based data solutions.
• Optimized MySQL and BigQuery performance through query tuning and indexing.
• Power BI Dashboards: Designed cross-industry reports with custom DAX for clients in healthcare, retail, and finance.
• Stock Market ML Analysis: Developed Random Forest model predicting PSE trends (79.7% accuracy).
• LangChain + Ollama Chatbot: Dockerized AI chatbot with local LLM inference and Streamlit frontend.
• Microsoft Power BI Data Analyst Professional – Microsoft
• Google Data Analytics Professional – Google
• Big Data Concentration – University of California, San Diego
• Big Data Integration and Processing – UC San Diego
• Big Data Modeling and Management Systems – UC San Diego
• Machine Learning with Big Data – UC San Diego
• Graph Analytics – UC San Diego
• Introduction to Machine Learning – Quantic School of Business and Technology
• Data Analytics Essentials – Cisco
• English C2 Proficient – EF SET
Databases: MySQL, PostgreSQL, BigQuery
Languages: Python, SQL, Java, JavaScript, C++
Tools: Power BI, Tableau, Excel, Microsoft Office, Jira, Salesforce, Docker, Git, Zapier
Frameworks: Pandas, NumPy, Scikit-learn, Matplotlib, Flask, LangChain, Streamlit
Development: Agile, Waterfall, Scrum, Iterative SDLC