Bernardo Andrey

- Use DataStage ETL Tools and responsible to develop ETL Flow based on design request - Extract new data from database or text file in sharing folder - Modify data from new request - Transform data and load data to Hive or DB2 - Deployment data to production

- Create a Data Warehouse Architecture. - Create Stored Procedure Script in MySQL. - Create Virtual Machine Compute Engine in Google Cloud Platform - Create and maintain data pipeline in Google Cloud Dataflow to ETL process using Python from Data Source to BigQuery - Extract data from MySQL then load data to BigQuery using Apache Beam in Python script. - Create scheduler ETL job using Cron Job. - Extract data from SAP and load to BigQuery using Python and Dataflow

- Provide data that will be used by other teams. - Extract data source from SQL Server then transform data using SAS then load data as SAS Dataset File. - Create datamart in Cloudera using Apache Hive or Apache Impala. - Validate data. Ensure the data is clean, accurate and usable by other teams. - Migration data script from SAS Script to SQL Script because in the next ETL process will use Store Procedure to create table in SQL Server.

- Do project about ETL project and Data Science Project. - Create ETL Job using AB Initio, Talend and SSIS

- Analysis Pole in South District of USA (Anaheim, Los Angeles, San Diego, Vernon Area) - Check the pole that has been made of Calc Specialist based on Ocalc Form, Photo, Aramis, Power Map, Datasheet and Working Drawing. Make sure Capacity Pole < 99.40℅. - Update Pole Data when Data is ready. - If there is Overcapacity Pole , so make recommend Pole - Make a report. Make note pole in Report.