✅ Participated in the design, analysis, programming, testing, and maintenance of the Sistema de Información Comercial, aimed at supporting the Commercial Department and its processes.
✅ Developed two core modules of the system in collaboration with a team of two other developers.
✅ Designed and implemented 480 PCK files, each containing approximately 5 stored procedures/functions, significantly improving the system’s data processing capabilities.
✅ Utilized PL/SQL and Web PL/SQL to optimize commercial data workflows and enhance the performance of sales and customer-related operations.
✅ Developed interactive front-end components using Macromedia DreamWeaver, Java, and JavaScript, ensuring user-friendly interfaces for commercial staff.
🔹 PL/SQL Programming & Web PL/SQL Development
🔹 Oracle Database Development & Optimization
🔹 Stored Procedures, Functions & Packages Creation
🔹 Oracle Designer for Database Modeling & System Design
🔹 Web Development (HTML, JavaScript) for Commercial Applications
✔️ Strengthened expertise in PL/SQL database development and Oracle Designer tools.
✔️ Gained hands-on experience in database-driven web applications.
✔️ Contributed to the successful modernization of commercial operations through database-driven automation.
✔️ Improved team collaboration and full software development lifecycle (SDLC) understanding.
| Category | Details |
|---|---|
| 📌 Company Name | PORVENIR Pensiones y Cesantías S.A. |
| 💼 Role | PL/SQL Developer |
| 📜 Project Name | Sistema de Información Comercial |
| 📍 Duration | June 2002 – March 2003 (9 months) |
| 🛠 Technologies Used | Database & Development Tools: PL/SQL Developer (SQL, PL/SQL, Web PL/SQL) Oracle Tools: Oracle Designer (Design Editor, Database Transformer Editor) IDE & Web Development: Oracle JDeveloper, Macromedia DreamWeaver (HTML, Java, JavaScript) |
| 🎯 Key Contributions & Achievements | ✅ Participated in the design, analysis, programming, testing, and maintenance of the Sistema de Información Comercial, supporting the Commercial Department. ✅ Developed two core modules in collaboration with a team of two other developers. ✅ Designed and implemented 480 PCK files, each containing ~5 stored procedures/functions, enhancing data processing efficiency. ✅ Utilized PL/SQL and Web PL/SQL to optimize commercial data workflows, improving performance in sales and customer operations. ✅ Developed interactive front-end components using Macromedia DreamWeaver, Java, and JavaScript, ensuring user-friendly interfaces for commercial staff. |
| 🔹 Technical Skills Acquired | Database Development: PL/SQL Programming & Web PL/SQL Development Optimization & Efficiency: Oracle Database Optimization, Stored Procedures, Functions & Packages Creation Design & Modeling: Oracle Designer for Database Modeling & System Design Front-end Development: Web Development (HTML, JavaScript) for Commercial Applications |
| 📚 Lessons Learned & Impact | ✔️ Strengthened expertise in PL/SQL database development and Oracle Designer tools. ✔️ Gained hands-on experience in database-driven web applications. ✔️ Contributed to the modernization of commercial operations through database-driven automation. ✔️ Improved team collaboration and full software development lifecycle (SDLC) understanding. |