Company Experience 7

📌 Name of Company: SIGTECH LTDA.

💼 Role: Java Software Developer

📜 Duration: October 2005 – March 2006 (6 months)

🎯 Key Projects & Achievements:

📌 Project 1: SIGC (Geographic Information System for Cadastral Management)

✅ Client: Unidad Administrativa Especial de Catastro Distrital (CATASTRO)
✅ Technologies:

  • Database: Oracle 8i/9i, PL/SQL
  • Development: Visual Basic 6.0
  • System Size:
    • 19 Oracle Packages
    • 785 Stored Procedures
    • 154 stored procedures invoked from the VB6 application
    • 395 Tables, 1528 Triggers, 1569 Indexes, 281 Views
    • 170 Visual Basic Forms

✅ Responsibilities & Contributions:

  • Implemented PL/SQL stored procedure calls from Visual Basic 6.0.
  • Designed and coded input/output parameter handling for database interactions.
  • Developed features for:
    • Querying received files and logs
    • Survey registration for real estate experts
    • Home nomenclature & property registry
    • Physical resources & dependencies registry
    • Data rule management & real estate unit registration

📌 Project 2: SAAW (Adjust Administering System)

✅ Client: ETB (Empresa de Telecomunicaciones de Bogotá)
✅ Purpose:

  • Supports correction of billing errors and manages adjustments to invoices based on customer claims.

✅ Technologies:

  • Backend: Java EE (Enterprise Java Beans, Servlets)
  • Frontend: JSP, Struts
  • Database: Oracle 9i, PL/SQL

✅ Responsibilities & Contributions:

  • Developed and maintained the Typology, Adjust, and User Administering modules.
  • Implemented business logic & UI layers for:
    • Typology Management: Defined adjustment reasons for billing corrections.
    • Adjustment Management: Handled modifications to invoices based on user claims.
    • User Management Module: CRUD operations and configuration management.
  • Developed the Phone Consultancy requirement (backend & frontend).
  • Fixed and maintained 16 system defects across business and presentation layers.

🛠️ Technical Skills Acquired:

🔹 Oracle 9i & PL/SQL Development:

  • Creation & optimization of stored procedures, triggers, and indexes.
  • Database integration with Visual Basic 6.0.

🔹 Java EE Web Development:

  • Enterprise Java Beans (EJB), Servlets, JSP, Struts.
  • Business logic implementation in multi-layered applications.

🔹 System Maintenance & Debugging:

  • Identified & resolved 16 software defects in ETB’s invoice adjustment system.

📚 Lessons Learned & Impact:

✔️ Gained hands-on experience with legacy systems using Visual Basic 6.0 and PL/SQL.
✔️ Developed full-stack solutions in Java EE using EJB, Servlets, JSP, and Struts.
✔️ Built critical modules for financial reconciliation systems at ETB.
✔️ Strengthened skills in database design, stored procedures, and SQL performance tuning.

This version keeps things concise while emphasizing key responsibilities, technologies, and impact. Let me know if you need any adjustments! 🚀