Experience

MISNet

• Philippines
• IT Services and IT Consulting
• 1 - 100 Employee

• Senior ETL Developer

  • 2017 - Present

  •Handles various ETL tools such as: Talend Talend 7.3, SSIS 2017, Informatica V8, ODI 10g&11g.•Create and Design Data Model in Talend MDM with defining its Process, Triggers, Views, Role and Workflow.•Design cleansing ETL Process like dates, gender, address, etc using Talend.•Deploying/Running ETL Jobs in TAC or Talend Administration Center.•Create test scripts based on the ETL Mapping.•Created scripts is divided into completeness, consistency, and accuracy.•Create automation script for parsing customer full address into Philippine Standard Geographic Code (PSGC) format.•Applying Standardization/transformation format based on given business rules.•Create SSIS package which includes the necessary components, such as the connection manager, tasks, control flow, data flow, parameters, event handlers, and variables, to execute a specific ETL task.



American Data Exchange

• ETL Developer II

  • Jul 2016 - Dec 2017

  Project Name: Data Processing and AutomationRole: ETL Developer IITechnology: Talend Open Studio, JavaScript •Design Development – Create and design Talend Jobs using Talend Open Studio ver. 6.1.1 based from the Data Analyst Instructions. •Design Development – Create modified/additional Talend Routines using Java Scripting. •Design Development – Create standard transformation conversion using Java Scripting. •Design Development – Create complex/multiple lookup values using Java Scripting. •Design Development – Create standard conversion of dates value using Java Scripting. •Handles high priority tasks that coming from data analyst and create a talend jobs base from the given mapping.• Applying changes in ETL Mapping based from the instruction given by the data analyst.• Create data testing of the task assign to be insure that the process is correct and ready/good for quality assurance testing.



Solvento Phils., Inc.

• Software Development
• 1 - 100 Employee

• Consultant

  • Aug 2015 - Aug 2015

  Project Name: ICIF ProjectRole: Consultant/ETL DeveloperTechnology: Informatica Client, Oracle 10g• Installation of Informatica Client v9.5.1• Extract – Create Staging source table in Oracle Database• Transform - Develop ETL mappings based on defined Business Rules• Design Development – Define Database connections and parameters to be used.• Design Development – Create Staging tables and Target Table• Unit Testing• Applying changes (business rules, transformation, etc.) in Informatica Mappings.

• Consultant

  • Jun 2015 - Jul 2015

  Project Name: Project DaylightRole: Consultant/ETL DeveloperTechnology: Microsoft SQL Server Integration Services• Scope – The ETL workflow starts from extracting data from source system, transforming and cleansing it, before loading into the repository and then processing the OLAP cube. It ends with the data being accessed, analyzed and dashboarded using end user tools.• Scope – Data from ODS is being downloaded into BIStaging database using SSIS. Whenever the job is run, a record is inserted in the BIStaging.dbo.Process table.• Design Development – Create views and stored procedures for faster enhancement and data handling strategy• Unit Testing• System Development Life Cycle Validation and Checking in UAT

• Consultant

  • Mar 2014 - Jul 2015

  Project Name: BIR eTIS Data MigrationRole: Consultant/ETL DeveloperTechnology: Oracle 10g• Scope – One time migration and conversion: Nation-wide Taxpayers' registration data (including secondary registration) in ITS CDF database will be migrated to eTIS.• Scope – Data Synchronization: eTIS updates on Large Taxpayers' registration data will be synchronized with ITS CDF database.• Transform - Develop ETL mappings using ODI10g based on defined rules• Design Development – Define Database connections and agent to be use using Topology in ODI 10g• Design Development – Define iKnowledge Module to be use in running the jobs• Design Development – Define Journalizing connections for change data capture data• Design Development – Create views and stored procedures for faster enhancement and data handling strategy• Design Development – Create Packages and scheduler for the jobs completed.• System Development Life Cycle Validation and Checking in System Integration Testing• System Development Life Cycle Validation and Checking in UAT• Applying changes (business rules, transformation, etc.) in ODI10g Mappings.

• Consultant

  • Feb 2014 - Apr 2014

  Project Name: SAS HPA Prepaid Phase 1.1Role: Consultant/ETL DeveloperTechnology: DataStage, Oracle 10g• Scope - The Foundation Data Mart (FDM) will store all data from SMART enterprise data sources (EDW/Tier 1, Tap3, etc.), as required by SMART business analytics. • Transform - Develop ETL mappings using DataStage based on defined rules• Design Development - Mapping of Attributes and Facts• System Development Life Cycle Validation and Checking in System Integration Testing• System Development Life Cycle Validation and Checking in UAT• Applying changes (business rules, transformation, etc.) in Informatica Mappings.

• Consultant

  • Nov 2013 - Jan 2014

  Project Name: CBS Role: ConsultantTechnology: Oracle 10g, ODI 10g• Scope - The purpose of this project is to convert the existing Loading script that uses Unix shell scripting into ODI that extract data from report server to ODS. • Scope - The project activity includes development of custom ETL solution to load data into the Data Warehouse• Transform - Develop ETL mappings using ODI 10g based on defined rules• Design Development - Mapping of Attributes and Facts

• Consultant

  • Dec 2012 - Nov 2013

  Project Name: MCC DatawarehouseRole: ConsultantTechnology: Greenplum, Informatica Client 9.1.5 , Oracle 10g• Installation of Informatica Client v9.5.1• Extract - Create Dimension/ Lookup Tables (copybook) in Greenplum• Extract – Create other source table in Oracle Database• Extract – Handing of copybook source in Cobol Format• Transform - Develop ETL mappings based on defined Business Rules• Design Development - Mapping of Attributes and Facts• System Development Life Cycle Validation and Checking in System Integration Testing• System Development Life Cycle Validation and Checking in UAT• Applying changes (business rules, transformation, etc.) in Informatica Mappings.

• Consultant

  • Mar 2010 - Jul 2013

  Client Name: St. Luke’s Medical CenterProject Name: SLMC - CVDIS BIRole: Project ConsultantTechnology: Talend Open Studio (ETL Tool), MicroStrategy, SQL Developer• Data Cleansing - Profiling - Patient Information (Name, Birthdate, Gender)• De-duplication - Creation of Clusters based on defined weights• To create Oracle Data Warehouse schema• Installation of Talend Open Studio used in the ETL process• Installation of Microstrategy 9 R2 used in BI Reporting• Create physical tables in the Data Warehouse based on the Data Model• Extract - Create CVDIS fact or raw data (Oracle Views)• Extract - Create Dimension/ Lookup Tables (Text file format)• Transform - Develop ETL mappings based on defined rules• Transform - Applying Change Data Capture Mappings• Design Development - Mapping of Attributes and Facts• Report Development - Create report specifications document• MicroStrategy 9 R2 Training - BI Overview• MicroStrategy 9 R2 Training - Project Design for Technical Users• MicroStrategy 9 R2 Training - Reporting Services for Technical Users• Talend Open Studio Training/Hand-on and Turnover to Client

• Consultant

  • Oct 2012 - Dec 2012

  Client Name: BIRProject Name: BIR-DPD InfrastructureRole: ConsultantTechnology: ODI 11g, ODI 10g• Installation of ODI 11g to be used as ETL Tool• Create physical tables in the Data Warehouse based on the Data Model• Extract - Create Dimension based on BIR Forms• Design Development - Mapping of Attributes • Transform - Develop ETL mappings based on defined rules

• Consultant

  • Dec 2010 - Mar 2011

  Client Name: China Bank CorporationProject Name: Data Management – CDI BIRole: Utilized Informatica Tool and completed the CDI-BI Data Management Module Technical DocumentationTechnology: Informatica Power Center• To map the ETL process for banking transaction records using Informatica Power Center• To complete the CDI-BI Data Management Module Technical Documentation



Ayala Land

• Online Website for Ayala Land

  • Aug 2010 - Oct 2010

  Project Name: Online Website for Ayala LandRole: IT ProgrammerTechnology: HTML, CSS and PHP Programming• Creating and designing an online website with higher quality and functionality assurance• To design and create Ayala Land Online Website for Philippine Real Estate• To allow users to view the Ayala Land properties and services Project Name: Online Website for Ayala LandRole: IT ProgrammerTechnology: HTML, CSS and PHP Programming• Creating and designing an online website with higher quality and functionality assurance• To design and create Ayala Land Online Website for Philippine Real Estate• To allow users to view the Ayala Land properties and services