ALLAN CRISPULO R. VALLARTA
Quezon City
Summary
Results-driven Data Analyst with comprehensive experience in data management, business intelligence, and data engineering. Proven track record in developing and implementing data solutions using modern technologies and best practices. Seeking to leverage expertise in data analytics and engineering to contribute to organizational growth and innovation.
Overview
7
7
years of professional experience
Work History
Data Analyst/Data Engineer
UnionBank of the Philippines
08.2023 - Current
- Lead the design and implementation of ETL pipelines using Snowflake and Python for efficient data processing
- Develop and maintain data warehousing solutions supporting critical business operations
- Create automated reporting systems for regulatory compliance and business intelligence
- Collaborate with cross-functional teams to optimize data architecture and improve data quality
- Implement data governance practices and documentation standards
- Build and maintain dashboards for real-time business metrics monitoring
Campaigns Developer
UnionBank of the Philippines
07.2023 - Current
- Developed and implemented targeted marketing campaigns using data-driven approaches
- Created automated workflows for campaign execution and monitoring
- Analyzed campaign performance metrics and provided insights for optimization
- Collaborated with marketing teams to define campaign requirements and success metrics
- Utilized SQL and Python for campaign data analysis and reporting
- Implemented tracking mechanisms for campaign effectiveness measurement
Business Controls Analyst
CITI Bank
01.2022 - 07.2023
- Spearheaded development of automated monitoring tools utilizing Python and Snowflake, resulting in 40% reduction in reporting time
- Architected and maintained data pipelines through Cloudera platform, ensuring seamless data flow and processing
- Implemented robust data warehousing solutions using Hive and Impala for large-scale data analysis
- Enhanced regulatory compliance monitoring systems through advanced data analytics and reporting mechanisms
IT Business Intelligence Analyst
Emerson
01.2018 - 01.2022
- Designed and deployed customized reporting solutions using Oracle, Noetix, and Snowflake
- Managed end-to-end data workflows in Cloudera environment, improving processing efficiency by 30%
- Leveraged Hive and Impala for complex data querying and analysis of large datasets
- Administered user subscriptions and report monitoring systems
- Provided technical support for database operations including Incremental and Full Regeneration
Education
Bachelor of Science - Computer Science
Far Eastern University
Manila01.2018
Skills
- Snowflake
- Cloudera
- Apache Hive
- Apache Impala
- Oracle
- Noetix
- Git version control
- SQL
- Data Analysis
- Data Management
- Web Development
- Financial Reporting
Technicalexpertise
Snowflake, Cloudera, Apache Hive, Apache Impala, Oracle, Noetix, Python, SQL, Data Analysis, Data Management, Web Development, Financial Reporting, Campaign Analytics, Marketing Automation
Professional Development
- UBP Python Training (2022)
- Building Data Analytics Solutions Using Amazon Redshift (2022)
- Workable Workshop on Spark, CML, CDSW, ML-Ops and Model Lifecycle (2022)
- Advanced Snowflake Data Warehousing
- Cloudera Platform Administration
- Big Data Analytics with Hive and Impala
Timeline
Data Analyst/Data Engineer
UnionBank of the Philippines
08.2023 - Current
Campaigns Developer
UnionBank of the Philippines
07.2023 - Current
Business Controls Analyst
CITI Bank
01.2022 - 07.2023
IT Business Intelligence Analyst
Emerson
01.2018 - 01.2022
Bachelor of Science - Computer Science
Far Eastern University
Similar Profiles
Mini Sayson PimpolloMini Sayson Pimpollo
Sales and Service Officer at UnionBank of the PhilippinesSales and Service Officer at UnionBank of the Philippines
ROSE ANNE A. JACOBEROSE ANNE A. JACOBE
Cards Production Officer at Unionbank of the PhilippinesCards Production Officer at Unionbank of the Philippines
Alpie AsiloAlpie Asilo
Network Support and Service Desk Officer (24/7) at UnionBank of the PhilippinesNetwork Support and Service Desk Officer (24/7) at UnionBank of the Philippines