Dan P.

Bi/Etl Developer

500 dollar
16 years

My experience


AmazonJanuary 2019 - Present

- clickstream data quality analysis using Zeppelin/SparkSQL on AWS EMR together with AWS S3, AWS Athena and Redshift queries

Ness Digital EngineeringFebruary 2017 - January 2019

# working for a health insurance company:
- implementing a BI solution having as source Aurora, MongoDB and Oracle, using AWS Glue, S3, Athena  and Jaspersoft

# working for an energy information provider:
- creating SQL Server views and stored procedures for data consolidation and forecasting, and troubleshooting the existing SQL scripts used in the ETL pipeline (PostgreSQL and SQL Server)

Levi9 IT ServicesMarch 2016 - February 2017

# working for a media-advertising company:
- implementing a forecasting dashboard solution using Pentaho PDI together with Impala SQL for Hadoop, FTL Java and R
- providing MySQL queries used in Hadoop pipelines

EndavaOctober 2013 - February 2016

# working for a payment processing company:
- developing end-to-end Oracle SQL queries according to specified data mappings and business rules for testing ETL ODI packages

# working for an online lending company:
- creating tests for ETL micro services written in Java with PostgreSQL as target and Amazon S3 as source file system

SoftVisionApril 2011 - October 2013

# working for an e-learning company:
- creating SQL Server stored procedures, views and tables used to aggregate and consolidate subscription data and generating the related SSRS reports.

Embarcadero TechnologiesMay 2007 - April 2011

- testing ER/Studio features (database reverse engineering, generate/view DDL, schema compare & merge, generate DB alter scripts) for Oracle, IBM DB2, SQL Server, Sybase, Informix etc.

Conex DistributionSeptember 2005 - May 2007

- sales data mart development and data maintenance using SQL Server and MS Access
- preparation and delivery of periodical reports

My stack


Amazon Web Services (AWS), AWS

Business Intelligence


Big Data

Hadoop, Impala


Jaspersoft, Microsoft Access, BI, IBM Hardware, PENTAHO, Redshift, data maintenance, Amazon S3, Oracle SQL, EMR, DDL, Data Modeling, Aurora, Report Design, Data Integration


Troubleshooting, Quality Assurance, Data Report, ER/Studio

Analysis methods and tools

Agile, JIRA, Scrum


Oracle PL/SQL, FTL, R Language, Java, SQL


Informix, MS Access, Sybase, MongoDB, Microsoft SQL Server, SQL Server, DB2, IBM DB2, PostGreSQL, Oracle, MySQL

Environment of Development

SQL Developer