Venedick Sapongay Email & Phone Number

Central Luzon, Philippines

Makati, National Capital Region, Philippines

SQL Developer - Warehouse Engineer

ETL Developer at UnionBank PH - Enterprise Data Group (Citi Data Migration)-Main ETL developer that develops the required target systems for the migration from CITI to UBP. (Appian systems and UB Online)-Design, develop, manage and implement ETL scripts to properly migrate each files from CITI and create an ETL scripts using STTM provided for each system needed for the project.-Helped to gather, research and analyze data. To develop insightful conclusions and design solutions. (Source to target mapping, CDD, List of Value translations)-Worked closely with CITI BU’s and DL and Tech Leads to properly migrate what’s the expected need for the mobile banking app/online banking website. [Profiles, Accounts (CASA debit/Credit card/Deposits), Saved billers, Scheduled payments, Scheduled transfers, Credit card maintenance dashboard, Consent wallets, Rewards, Dao]

-Design, develop, manage and implement data warehousing using Microsoft Business Intelligence Technology (SSIS, SSRS)-Business intelligence support for various ETL projects and Reports. (SSIS, SSRS)-Develop several functional components of the data warehousing apps ETL, and reports in collaboration with the team and clients.-Knowledgeable to use REST API as source data(JSON,XML).-Knowledegable in SQL-Familiarity with C#, which is used in SSIS scripting-Familiarity with data modeling-Experienced with differencet software development environment (DEV, UAT, PROD)-Test and validate software solutions in order to assure software quality.-Collect and document technical and business meta data, as well as data sources and business rules applied to transactional data.-Data gathering, research and analyze data. To develop insightful conclusions and design solutions to meet user needs.

Ncr - National Capital Region, Philippines