Post a Job Free
0 viewsjobseeker
Alvin P. — Data/Analytics Engineer, PL/SQL Developer from Philippines

Alvin P.

Data/Analytics Engineer, PL/SQL Developer

Philippines 6+ years
Open to offersNew to Platform
Languages
EnglishTagalog
Video Introduction
No video introduction yet
The candidate has not added a video.
Contact information and social networks are private. Connect to unlock.
Hidden

About

Alvin P. is a seasoned Data Engineer with more than 13 years of experience in developing comprehensive data solutions and refining data processes. At IBM Philippines, he has excelled in roles such as Analytics Engineer and Oracle PL/SQL Developer, where he was instrumental in engineering a complete analytics pipeline utilizing Python, dbt, and Snowflake to optimize data flow and analysis. Alvin's proficiency in ETL and ELT technologies has facilitated the transformation of raw e-commerce data into efficient data warehouses, improving accessibility and business insights. His adept use of CI/CD methodologies, particularly through GitHub Actions, minimized manual intervention in dbt runs. Alvin holds advanced capabilities in creating PL/SQL procedures and SQL scripts for efficient data warehousing. His academic credentials include a Master of Science in Statistics from the University of the Philippines, paired with multiple certifications such as DBT Fundamentals and Microsoft Azure Data Fundamentals, underscoring his expertise in modern data engineering platforms.

Experience

  • Analytics Engineer

    IBM PH - Global Delivery Center, Philippines · 2023 — 2025
    Engineered an end-to-end analytics pipeline utilizing Python, dbt, and Snowflake to optimize data flow and analysis. Developed robust ETL workflows for transforming raw e-commerce data into a functional data warehouse, thus enhancing data accessibility. Designed, tested, and documented dbt staging and mart models to ensure data quality and compliance with standards. Implemented CI/CD automation with GitHub Actions to streamline dbt processes, reducing manual intervention. Delivered interactive dashboards for tracking revenue trends and customer insights, aiding stakeholders in making data-driven decisions. Enhanced batch jobs for data warehouse processing to improve ETL efficiency and reliability.

  • Oracle PL/SQL Developer

    IBM PH - Global Delivery Center, Philippines · 2012 — 2024
    Wrote and maintained Oracle PL/SQL procedures and SQL scripts, focusing on optimizing runtime performance and reducing processing times. Conducted SQL tuning in production environments, ensuring stable data movement and job stability. Supported enterprise systems maintenance through scheduled jobs and defect resolution, contributing to improved uptime. Enhanced reporting batch jobs in data warehouse systems to increase data retrieval efficiency and user satisfaction.

  • Oracle PL/SQL Developer

    Archon Consulting Services Inc. · 2012 — 2012
    Created and enhanced PL/SQL packages and database objects to streamline data processing operations. Migrated legacy Sybase stored procedures to Oracle 11g, ensuring system compatibility. Executed thorough end-to-end testing of converted database objects to safeguard data integrity.

  • Oracle PL/SQL Developer

    System Generators Incorporated, Philippines · 2011 — 2012
    Deployed SQL packages and tables using Unix shell scripting, ensuring processes were repeatable and efficient. Developed Oracle PL/SQL code for Forms and Reports components, enhancing application functionality.

  • Application Support Specialist

    Bureau of Internal Revenue, Philippines · 2011 — 2011
    Participated in SDLC activities involving analysis, design, and implementation to ensure project alignment with business requirements. Supported IBM Maximo Asset Management implementation and configuration to enhance operational efficiency.

  • IT Specialist / SME

    I-Konsult Corporation, Philippines · 2009 — 2010
    Developed PL/SQL scripts for data loading and reporting, which enhanced accuracy and accessibility of operational data. Supervised data processing staff and offered support for survey operations, ensuring timely and accurate data collection.

  • Research Engineer

    MWSS, Philippines · 2007 — 2009
    Performed statistical analyses on consumer survey data to derive insights for strategic initiatives.

Skills & Expertise

Data EngineeringData AnalysisData ArchitectData Engineer

Education

  • Master of Science in Statistics
    University of the Philippines
  • Bachelor of Science in Applied Statistics
    Polytechnic University of the Philippines