Emanuel Oliveira

job title: Snowflake Tech lead/Data Warehouse Architect
roles: Migration tech lead

• Inception project, provided insights of Snowflake features and suggested architecture for snowflake database and data ingestion.

tech: aws s3, Oracle, Snowflake
hands on coding: Snowflake SQL, Oracle SQL, PL/SQL

job title: Senior Data Engineer
roles: tech lead, sql developer

• Fully reversed engineered data warehouse project of inherited 2 years project.
• Created initial backlog of improvements and new features.
• Tech leaded and mentored other developers ensuring homogeneous deliverables quality.

tech: aws s3, aws stepfunctions, aws emr, tableau, goldengate
hands on coding: sql coding, aws glue, aws redshift, oracle database

job title: Senior Snowflake Developer/Data Architect
roles: solution architect, tech lead and developer snowflake;apache NiFi

• Development of a custom cdc engine (data ingestiong + etl) to daily bring deltas from oracle databases into snowflake (configuration driven).

tech: aws s3, tableau, goldengate
hands on coding: sql coding (snowflake, oracle database); etl flows (Apache NiFi)

job title: Senior Snowflake Developer/Data Architect
roles: tech lead and developer snowflake; apache nifi

• Implementation of data ingestion and load of all source of enterprise level communications (email, sharepoint, service now, helpdesk, etc) got pushed into SaaS product that flatten and added metadata tags in plain text files into aws s3 -> aws sqs. One Apache NiFi etl flow would pick aws sqs message, pull, transform file, enrich with some more metadata and export into aws s3 to be loaded into snowflake.

tech: aws s3, aws sqs, comms SaaS
hands on coding: sql coding (snowflake); etl flows (Apache NiFi)

job title: Senior Snowflake Developer/Data Architect
roles: tech lead and developer snowflake; apache nifi

• Development of a custom cdc engine, daily pulling delta changes from Enterprise JIRA into Snowflake.
• Solution become internal use pattern for all data lakes pulling from REST APIs, given the resilience of the ingestion process. Load process into snowflake full automatic based on metadata dynamic sql, meaning nothing is hard coded as all management done sql ddl tables.

tech: aws s3, jira rest api
hands on coding: sql coding (snowflake); etl flows (Apache NiFi)

job title: Senior Oracle Developer
roles: sql & pl/sql developer

• short missions 3 months | Reverse engineered complex financial Levy ETL calculation process, in order to access best way to deal with core tables changes major project.
• Changed the PL/SQL package from using legacy core tables into the new set of core tables/views.
• Debugging data quality issues via SQL analytic functions.

tech: oracle database 12 (SQL and PL/SQL), autosys
hands on coding: oracle database 12 (SQL and PL/SQL), excel

job title: Senior Oracle Developer
roles: oracle sql and pl/sql developer, data architect, business to IT analyst, tech lead in couple of medium and large modernization projects

• Worked on the core Oracle Development team responsible to process all core business functions using multiple oracle databases including data warehouse to support dental claims processing servicing 25 insurers across several USA states.
• 1 year project | downsize mainframe business into oracle database (ETL process).
• 1 year project | architected, tech leaded and developed a new provider search aggregating 4 databases into new set of search serving tables.
• several continuous improvements and/or new features; production support; most work was maintaining the huge batch daily processes to load and export files.
• developed data warehouse loads as well.

tech: oracle database 11/12; sqlplus; batch redwood; unix shell script; git
hands on coding: sql, pl/sql, unix shell script, batch redwood

job title: Senior Oracle Developer

• Joined Accenture Poland data migration development team in the last 8 months prior to GoLive.
• Coded on 2 ETL complex batch processes (PL/SQL & SQL), reconciliation reports on Oracle Flexcube modules DD (Direct Debits), SI (Standing Instructions) and FP(Future Payments).

tech: Oracle Database 11 (sql, pl/sql, linux shell script); Oracle Flexcube
hands on coding: sql, pl/sql, shell script

job title: Data Migration tech lead/Senior Oracle Database Architect/Developer
roles: data migration project manager/architect and tech lead/oracle developer

• Assumed both roles of data migration project manager + technical architect;tech lead and coded myself 90% of all migration code (leaded 3 juinors in the end).
• Liason with IT to understand both business and data; Liason with Oracle Flexcube offshore team to understand how to migrate all types of data + high level by-weekly meetings with Bank of Portugal project manager.

tech: Oracle Database 11; Oracle Flexcube
hands on coding: sql, pl/sql, shell script.

job title: Senior Oracle/SQL Server Database Developer

• sql development on both systems UNIX/Oracle Database and Microsoft/SQL Server/SSIS/SSRS.
• Coded new /maintained ETL jobs on the main system UNIX HP/Oracle Database 11gR2 using Control-M.
• creation/maintenance of control-m batch processes | export/import files; execution of automatic ratings serving Bank APIs.
• ETL development using SSIS, including migration of SQL Server 2000 DTS SSIS packages into new SQL Server 2008 DTX.
• Reports development using SSRS (Consolidated customer view reports, ..)

tech: Oracle database 10; SQL Server 2000/2008; Control-M
hands on coding: sql; pl/sql; unix shell script; javascript/vbscript; IIS

• Technical Project Manager @ Optimus
• Senior Software Engineer @ Solutions Factory
• Windows and Web developer @ Hi Management
• Senior Consultant Developer @ Attachmate Corporation