Dan P.

Bi/Etl Developer

500 dollar
Freelancer
16 years
Iasi, ROMANIA

My experience

More

AmazonJanuary 2019 - Present

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

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)
More

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
More

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
More

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.
More

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.
More

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

Technologies

Amazon Web Services (AWS), AWS

Business Intelligence

ETL, SSRS

Big Data

Hadoop, Impala

Other

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

Others

Troubleshooting, Quality Assurance, Data Report, ER/Studio

Analysis methods and tools

Agile, JIRA, Scrum

Languages

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

Databases

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

Environment of Development

SQL Developer