seasoned Data Analyst & Engineer proficient manipulating & normalizing data and writing complex nested, recursive SQL queries with common table expressions
From 1998 to 2016 my main focus was Info Digger client/server applications and Oracle database, function, materialized view, procedure and PL/SQL package development.
During that time I built several Info Digger applications integrated with Oracle Enterprise Resource Planning (ERP) database schemas.
I have vast knowledge of Oracle Applications SQL & DDL standards and package, procedure, function, constraint, schema source code.
PL/SQL, SQL/PSM, PL/pgSQL & T-SQL procedural programming
Database Design
Database normalization
SQL plays a crucial role in application software development for creating and managing database structures, executing business rules, merging data from different origins, analyzing and reporting data.
SQL is helpful for testing and troubleshooting.
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.
Database design, CRUD (create, read, update and delete) & data processes were my initial focus of expertise.