✅ Developed Graphical User Interfaces (GUIs) for a call center application used by Carulla Supermarkets to process customer orders efficiently.
✅ Designed and developed a tracking system for daily employee activities, implemented with Oracle 8.0.5 as the database and Visual Basic 6.0 for the front end.
✅ Enabled report generation to analyze the average time dedicated to each project by engineers.
✅ Led the development of APICE ERP, streamlining inventory management, hardware tracking, and engineering support activities.
✅ Provided functionality to monitor:
✅ Developed user interfaces in VB 6.0 that interacted with MS SQL Server 6.5 and generated reports in Crystal Reports.
✅ Created audit trail functions to track internal processes within the IVR system.
✅ Designed and built an ActiveX control that enabled the IVR system to integrate with an IBM OS 390 using Extra API (Windows-to-IBM terminal emulation).
✅ Developed an IVR system with Oracle database integration, including automated fax functionality to send documents upon user request.
✅ Created multiple administrative software modules, such as:
✅ Assisted the company in transitioning from Windows-based environments to Linux operating systems, contributing to a more stable and cost-effective infrastructure.
🔹 Visual Basic 6.0 for enterprise software development
🔹 Database integration (Oracle, MS SQL Server, MS Access)
🔹 IVR system development & IBM OS 390 integration
🔹 ActiveX control development
🔹 Crystal Reports for business intelligence reporting
🔹 Linux system migration & administration
✔️ Strengthened problem-solving skills by integrating legacy systems with modern databases.
✔️ Gained experience in telecommunications and IVR systems, improving automated customer service operations.
✔️ Led end-to-end software projects, from design to deployment and maintenance.
✔️ Improved enterprise software scalability and performance through optimized database queries and structured development methodologies.
| Category | Details |
|---|---|
| 📌 Company Name | APICE S.A. |
| 💼 Role | Software Developer |
| 📍 Duration | January 1999 – June 1999, December 2000 – August 2001 (1 year and 2 months) |
| 🛠️ Technologies Used | 🔹 Visual Basic 6.0 🔹 MS Access 🔹 Oracle 8.0.5 🔹 MS SQL Server 6.5 🔹 Crystal Reports 🔹 ActiveX Control Development 🔹 IBM OS 390 Integration 🔹 Linux Migration Assistance |
| 🎯 Key Contributions & Achievements | 📌 Project: Call Center Order Management System (Carulla Supermarkets) ✅ Developed Graphical User Interfaces (GUIs) for a call center application used by Carulla Supermarkets to efficiently process customer orders. 📌 Project: Employee Activity Tracking System ✅ Designed and developed a tracking system for daily employee activities, using Oracle 8.0.5 and Visual Basic 6.0. ✅ Implemented report generation to analyze the average time engineers dedicated to each project. 📌 Project: APICE ERP (Engineering Department Management System) ✅ Led the development of APICE ERP, streamlining inventory management, hardware tracking, and engineering support activities. ✅ Provided functionality to monitor: 🔹 Project assignments and engineering tasks 🔹 Warranty policies and maintenance contract deadlines 🔹 Support activities tracking by project 📌 Project: IVR System for Codensa S.A. E.S.P. ✅ Developed user interfaces in VB 6.0 that interacted with MS SQL Server 6.5 and generated reports using Crystal Reports. ✅ Implemented audit trail functions to track internal processes within the IVR system. ✅ Designed and built an ActiveX control to integrate the IVR system with an IBM OS 390 via Extra API. ✅ Developed an IVR system integrated with Oracle database, including automated fax functionality for sending documents upon request. ✅ Created multiple administrative software modules, including: 🔹 ActiveX control for user creation in Oracle 🔹 DataReport-based reports for VB 6.0 🔹 Administrative tools for IVR system management 📌 Linux Migration Assistance ✅ Assisted in transitioning from Windows-based environments to Linux, contributing to a more stable and cost-effective infrastructure. |
| 🛠️ Technical Skills Acquired | 🔹 Visual Basic 6.0 for enterprise software development 🔹 Database integration (Oracle, MS SQL Server, MS Access) 🔹 IVR system development & IBM OS 390 integration 🔹 ActiveX control development 🔹 Crystal Reports for business intelligence reporting 🔹 Linux system migration & administration |
| 📚 Lessons Learned & Impact | ✔️ Strengthened problem-solving skills by integrating legacy systems with modern databases. ✔️ Gained experience in telecommunications and IVR systems, improving automated customer service operations. ✔️ Led end-to-end software projects, from design to deployment and maintenance. ✔️ Improved enterprise software scalability and performance through optimized database queries and structured development methodologies. |