Data Analytics SQL with Pentaho ETL Tool

😊 Hi there!

SQL Developer | Database Designer | Database Developer | Data Extractors 

I am an SQL Developer with 4+ years of corporate experience working Database development and design, especially in MS SQL. Also experienced in designing databases, writing complex business queries, and query optimization in SQL and Data Migration using Pentaho Kettle ETL Tools and  reporting solutions such as the Power BI reporting tool.

The skills you need to be a successful client👇

⚡ Effective Communication

⚡ Quick Learner

⚡ Patient Work Discipline Against Obstacles

⚡ Task & Time Management Under Limited Deadlines

⚡ Ability to Prioritize Tasks

✴️ Database: SQL Server

✴️ ETL : Pentaho Kettle ETL

✴️ Reporting: Power BI

I can provide my expertise in the following.

✅ Database Development and Design;

✅ Knowledge of design patterns and practical experience with them.

✅SQL complex Queries writing;

✅ Queries Optimization;

✅ Entity Relationship Diagrams;

✅ Optimization of database system performance (Engine Tuning, Queries Indexing);

✅ Data Modelling (ERD, Schema Designing, Relationship Defining between Entities);

✅ Logic creation using SQL queries, T-SQL & PL-SQL;

✅ Migration from one Data Source to another Data Source.

Skill Sets:

✅ SQL complex Queries writing

✅ Queries Optimization

✅ Database design

✅ Entity Relationship Diagrams

✅ Database migration through scripting

✅ Stored Procedures

✅ Views

✅ Functions

✅ Triggers

✅ Indexes

✅ T-SQL

✅ Optimization

✅ Advanced SQL server features / CTE (Common table expression)

✅ Data import/Export

✅ Database schema Design

✅ Database Normalization/De Normalization

✅ Database Modeling

IDEs:

✅ SQL Server Management Studio

✅ SQL Server

✅ SQL Developer

⭐ ETL Solutions: Expertise in Extract, Transform, Load the data to design DWH and OLAP system.

⭐ Visualization Tools: Worked extensively in creating powerful Dashboards and Reports in Power BI. I can prepare powerful Models, use Power Query and Dax functions, and play around with Charts and Tables.