Melvin Licaros

Melvin I. Licaros BLK 19 LOT 4 PHASE 2 MAPAGPAUBAYA ST. FIESTA COMMUNITIES TABUN MABALACAT PAMPANGA 2010 MOBILE #:- Email Address:- Professional Summary Dynamic and results-driven Data Analyst with extensive experience in data visualization, predictive modeling, and reporting. Adept at leveraging tools like Power BI, Python, and SQL to deliver actionable insights and drive data-informed decision-making. Proven track record in ETL processes, data cleaning, and dashboard creation across diverse industries. Skilled communicator capable of translating complex data into clear and impactful recommendations. ______________________________________________________________________________________ Core Competencies • Data Analysis: Predictive modeling, statistical analysis, exploratory data analysis (EDA), data wrangling. • Data Visualization: Power BI (DAX, Power BI Paginated Reports), Tableau, Looker (dashboards, reports, data modeling). • Programming & Tools: Python (Pandas, Matplotlib), SQL (MySQL, Microsoft Server, BigQuery), Excel (advanced formulas, Power Query, Power Pivot), Visual Basic. • Data Management: ETL processes, database administration, workflow optimization. • Customer Support Analytics: Zendesk ticketing system and workflow enhancement. Certifications • Microsoft Power BI Desktop for Business Intelligence (Udemy, 2024) • Complete SQL Mastery (Code with Mosh) • 100 Days of Code: The Complete Python Pro Bootcamp (Udemy, 2024) • Microsoft Power BI Desktop: Advanced DAX for Data Analysis (Udemy, 2025) • Hands-On High Performance SQL (Udemy, 2025) Professional Experience Data Analyst Cloudstaff April 2025 – Present • Developed dashboards in Power BI, connected to SQL Server, to monitor KPIs and support data-driven decisions. • Built custom reports and dashboards in Zoho Analytics using SQL and Snowflake for querying and analyze large datasets. • Collaborated with cross-functional teams and used Asana to manage project workflows and task assignments. Data Analyst Paragon Outsourcing July 2023 – March 2025 • Spearhead the development of interactive dashboards using Power BI, improving cross-departmental accessibility to actionable insights. • Execute ETL processes to consolidate data from multiple sources, ensuring datasets remain accurate and comprehensive. • Optimize Zendesk workflows, enhancing ticket management and customer support performance. • Streamline large datasets through advanced data cleaning and processing techniques. • Use the API to request data. Reports Analyst II Majorel June 2016 – July 2023 • Delivered robust data visualizations using Power BI with complex DAX measures to support decision-making. • Refined reporting pipelines utilizing Power Query and Power Pivot. • Regularly prepared and distributed hourly, daily, and month-end reports for key stakeholders. • Ensured dataset accuracy by integrating and updating Zendesk data into operational dashboards. Business Reports Analyst Harte Hanks February 2014 – May 2016 • Analyzed agent productivity metrics, presenting weekly insights and actionable recommendations. • Produced ADHOC reports catering to manager-specific requests with a high degree of accuracy. • Created visual templates and automated workflows to enhance data accessibility. System Developer Specialist Computer Affiliated Services (Xerox) September 2013 – December 2013 • Developed automated reporting systems using VB Macros, enabling non-technical users to execute complex tasks effortlessly. • Conducted data validation and ensured accuracy across reporting systems. • Collaborated with cross-functional teams to implement process improvements in automated reports. Reporting Analyst Transcom October 2012 – September 2013 • Designed templates using Excel VB Macro for sales and productivity reporting. • Managed SQL-based operational databases to ensure seamless data flow and reporting. • Delivered high-quality daily, weekly, and monthly reports to stakeholders. Real-Time Analyst Teletech (Pampanga) June 2011 – October 2012 • Monitored real-time operational performance and created staffing schedules based on forecasted needs. • Delivered hourly and end-of-day reports summarizing key performance metrics. Reports Analyst Sutherland Global Services February 2009 – April 2011 • Designed and implemented report templates incorporating advanced analysis. • Automated recurring reports using Excel VB Macro, saving significant processing time. Customer Service Representative Sutherland Global Services January 2008 – February 2009 • Supported customer retention programs for Amazon.com and United Online. Educational Background Bachelor of Science in Information Technology Holy Angel University, Angeles City 2002 – 2007 Character References Available upon request.