Seasoned data analyst & data engineer proficient manipulating & normalizing data and writing complex nested, recursive SQL queries with common table expressions.
SQL plays a crucial role in software development, being used for creating and managing database structures, executing business rules, merging data from different origins, analyzing and reporting data, as well as for testing and troubleshooting.
Remote software & data application development services
PL/SQL, SQL/PSM, PL/pgSQL & T-SQL procedural programming
Database Design
Database normalization
Database normalization is the process of structuring a relational database in accordance with a series of so-called normal forms in order to reduce data redundancy and improve data integrity.
Since 1998 my primary professional time has been spent developing Oracle databases and PL/SQL Oracle Packages and since 2006 developing Packages, Functions and Procedures for 'Oracle Applications' integration.
My attention is always on database design, CRUD (create, read, update and delete) & data processes.