Open to opportunities

Alvin Paano

@alvinpaano

Message

Analytics engineer and software developer building scalable, auditable data systems.

Philippines

Message

What I'm looking for

I seek a role building end-to-end, auditable analytics systems where I can apply dbt, Snowflake, Python and CI/CD to deliver trusted, production-ready data products.

I am a software developer and analytics engineer who designs modular, auditable data solutions that balance efficiency and fairness across technical and social environments.

With deep roots in Oracle PL/SQL development and extensive experience across databases and cloud platforms, I build end-to-end pipelines from ingestion to deployment using tools such as dbt, Snowflake, Python and Streamlit.

I have delivered production analytics pipelines, implemented CI/CD for dbt, developed interactive dashboards, and performed performance tuning and migrations across multiple enterprise projects.

I bring a pragmatic, test-driven approach to data modeling, ETL/ELT orchestration, and operational support, focused on turning complexity into clarity and enabling smarter, auditable decision-making.

Experience

Work history, roles, and key accomplishments

Current

Analytics Engineer

Current

IBM PH - Global Delivery Center

Sep 2024 - Present (1 year 1 month)

Developed an end-to-end e-commerce analytics pipeline using Python, dbt, and Streamlit; implemented CI/CD with GitHub Actions and delivered dashboards showing revenue trends, retention, and product/seller performance.

Python DBT Streamlit GitHub Actions Snowflake ETL Data Modeling

Current

Oracle PL/SQL Developer

Current

IBM PH - Global Delivery Center

Oct 2012 - Present (13 years)

Developed and enhanced batch jobs for data warehouse environments, performed code walkthroughs and unit testing, and provided Oracle/UNIX production support to improve reliability and operational stability.

Oracle PL SQL Unix)Batch Unit Testing Performance Tuning ETL TKPROF Unix

Software Developer

Bell MSP

Sep 2019 - May 2020 (8 months)

Researched, designed, implemented and tested software programs, identified enhancements in existing systems, and wrote efficient code for production delivery.

Software Development Testing APIs Debugging

Production Support

National Grid - NG

Oct 2015 - Jul 2019 (3 years 9 months)

Provided technical and application management support including code changes, application management, and resolution of service disruptions for production systems.

Application Management SQL Deployment

Oracle PL/SQL Developer

Archon Consulting Services Inc

Jun 2012 - Sep 2012 (3 months)

Developed and enhanced data warehouse reports and batch jobs, conducted code walkthroughs and unit testing, and provided Oracle/UNIX production support for operational systems.

Oracle PL SQL Unix)Data Warehousing Unit Testing ETL Unix

Oracle PL/SQL Developer

System Generators Incorporated

Sep 2011 - Feb 2012 (5 months)

Migrated Sybase stored procedures to Oracle 11g, deployed packages via Unix shell scripts, performed end-to-end testing and SQL/PLSQL performance tuning using TKPROF and explain plan.

Pl SQL Sybase Migration Shell Scripting Testing Performance Tuning TKPROF

Application Support Specialist

Primover Consulting Services Incorporated

May 2011 - Aug 2011 (3 months)

Developed PL/SQL code for Oracle Forms and Reports, maintained stored procedures and packages, and managed full SDLC activities including testing, implementation and documentation.

Oracle PL SQL SDLC Testing Application Support Documentation SQL

Technical Support

Teletech Incorporated

Nov 2010 - Apr 2011 (5 months)

Provided technical support for software and hardware peripherals, troubleshooting user issues and escalating incidents to ensure timely resolution.

Technical Support Troubleshooting Incident Management Customer Support Hardware Software

IT Specialist

Konsult Corporation

Jan 2009 - Nov 2010 (1 year 10 months)

Provided IBM Maximo v6/v7 support and deployment, performed PL/SQL programming for data loading, configured WebSphere/WebLogic and managed database backups and monitoring.

Pl SQL Oracle 10g Websphere Database Administration Configuration

Research Engineer

MWSS

Dec 2007 - Mar 2009 (1 year 3 months)

Performed statistical analysis and regression modeling on consumer survey data, designed sampling and data quality plans, and supervised data processors to produce reports for water service assessments.

Statistical Analysis Data Quality Survey Design SPSS Reporting