Software Engineer-Data at Technikons (2024-01 – Present)
Clients: XRMedix, LA | Toyota Motors, TX
- Automated ETL pipelines using PL/SQL, boosting efficiency.
- Migrated a data warehouse to OCI, developing PL/SQL scripts that helped cut infrastructure costs by 15%.
- Implemented a data quality framework with PL/SQL, improving data accuracy by 25% and reducing cleansing time by 50%.
- Owned the end-to-end data pipeline, meticulously crafting and optimizing PL/SQL routines for data transformation, ensuring accuracy and integrity from ingestion to final reporting.
- Translated business needs into Oracle SQL and PL/SQL solutions.
- Debugged and resolved complex issues in high-volume Oracle systems, optimizing PL/SQL and SQL code.
- Developed PL/SQL backend logic for a new self-service reporting module in Oracle BI.
- Provided support and maintenance for custom applications, including PL/SQL debugging and performance tuning.
Senior PL/SQL Developer at Stuller Inc. (2012-01 – 2023-12)
- Developed core Oracle database objects and PL/SQL code (procedures, functions, packages) to build and extend system capabilities.
- Created custom Oracle Forms interfaces and PL/SQL APIs for enhanced system functions and image server interactions.
- Translated business needs into Oracle SQL and PL/SQL designs, ensuring effective system development.
- Led PL/SQL development for automated jewelry item creation processes in the Part Automation project.
- Built custom workflows and their PL/SQL components using Oracle Workflow Builder for automation.
- Implemented program logic with a strong PL/SQL focus, performing unit and integration testing.
- Optimized Oracle SQL queries and tuned PL/SQL code for significant database performance improvements.
- Developed dynamic reports and dashboards in Oracle APEX and BI Publisher, using PL/SQL for data handling.
- Led Oracle APEX POC and trained peers on developing APEX applications with PL/SQL.
- Extended Oracle E-Business Suite (EBS) functionality using OAF extensions and integrated PL/SQL.
- Resolved critical Oracle Applications load balancer issues by implementing a WEBUTIL call via PL/SQL.
- Provided after-hours support for shipping operations, involving PL/SQL debugging to ensure timely product delivery.
PL/SQL Developer at Milestone Software Solutions (2010-01 – 2012-12)
- Automated high-volume business processes by developing and optimizing PL/SQL scripts, significantly improving efficiency.
- Engineered and customized critical database objects including tables, triggers, and PL/SQL packages to support core business operations.
- Streamlined business processes for over 20 utility clients by developing and customizing Oracle Forms, Reports, and database programs.
- Delivered effective data management solutions by creating, customizing, and migrating database objects during Oracle 11g and Forms 10g upgrades.
- Ensured high-performing, compliant code by conducting unit testing, peer code reviews, and adhering to SOX standards for data integrity.
- Resolved complex production issues in a 24/7 environment, independently troubleshooting problems to maintain system uptime and client satisfaction.
Data Analyst at General Information Services (2009-01 – 2010-12)