Synapsis CV_MCG 2025

Company Experience 6

📌 Name of Company: Synapsis Ltda.

💼 Role: Visual Basic Software Developer

📍 Address: Carrera 14, 85-68, Bogotá, Colombia

📧 Email: seleccioncol@synapsis-it.com

📞 Phone: (57-1) 607 6000

📜 Duration:

First period: December 2003 – April 2004
Second period: August 2004 – December 2004
Total: 10 months

🎯 Key Projects & Achievements:

📌 Project 1: Maintenance & Enhancement of Customer 2000 Platform

✅ Client: Codensa, Carulla
✅ Technologies:

Programming Languages: Visual Basic 6.0, Pro C/C++
Database: Oracle 9i, PL/SQL, Informix
Development Tools: Visual Basic 6.0, Visual Age

✅ Responsibilities & Contributions:

Performed maintenance and enhancements for multiple applications built in Visual Basic 6.0, which were part of the Customer 2000 platform.
Developed batch processing scripts in Pro C/C++ to support automated tasks for Visual Basic applications.
Created stored procedures in PL/SQL to manage data processing for a web-based application.

📌 Project 2: Migration of Stored Procedures from Informix to Oracle

✅ Scope: Migrated 952 stored procedures from Informix to Oracle 9i.
✅ Technical Challenges & Approach:

Analysis & Planning: Assessed compatibility issues between Informix and Oracle.
Migration: Rewrote and optimized stored procedures using PL/SQL.
Testing & Validation: Ensured functionality and data integrity post-migration.

✅ Technical Impact:

Worked with 29 large Visual Basic projects.
Handled 19 Oracle modules.
Re-implemented 118 Visual Basic forms that required adjustments post-migration.

🛠️ Technical Skills Acquired:

🔹 Visual Basic 6.0 Development & Maintenance
🔹 Pro C/C++ for Batch Processing & Automation
🔹 PL/SQL & Oracle 9i Stored Procedures Development
🔹 Database Migration: Informix to Oracle
🔹 Testing & Validation of Database Migrations

📚 Lessons Learned & Impact:

✔️ Strengthened experience in legacy system maintenance using Visual Basic 6.0.
✔️ Gained hands-on expertise in Pro C/C++ for automation of batch processes.
✔️ Successfully migrated high-volume stored procedures while ensuring data consistency.
✔️ Developed strong SQL migration and optimization skills for Oracle databases.

This version keeps the focus on your key responsibilities, technologies used, and impact on the project. Let me know if you'd like any refinements! 🚀

Analytical Table of Company Experience 6 (Synapsis Ltda.)

Category	Details
📌 Company Name	Synapsis Ltda.
💼 Role	Visual Basic Software Developer
📍 Address	Carrera 14, 85-68, Bogotá, Colombia
📧 Email	seleccioncol@synapsis-it.com
📞 Phone	(57-1) 607 6000
📜 Duration	First Period: December 2003 – April 2004 Second Period: August 2004 – December 2004 Total: 10 months
🎯 Key Projects	Project 1: Maintenance & Enhancement of Customer 2000 Platform Project 2: Migration of Stored Procedures from Informix to Oracle
✅ Client(s)	Codensa, Carulla
🛠 Technologies Used	Programming Languages: Visual Basic 6.0, Pro C/C++ Databases: Oracle 9i, PL/SQL, Informix Development Tools: Visual Basic 6.0, Visual Age
📌 Project 1: Maintenance & Enhancement of Customer 2000 Platform	Scope: Maintenance and feature enhancement for multiple Visual Basic 6.0 applications. Responsibilities: <ul><li>Performed maintenance and updates for applications in Visual Basic 6.0.</li> <li>Developed batch scripts using Pro C/C++ to support automation.</li> <li>Created PL/SQL stored procedures for backend data processing.</li></ul>
📌 Project 2: Migration of Stored Procedures from Informix to Oracle	Scope: Migrated 952 stored procedures from Informix to Oracle 9i. Challenges & Approach: <ul><li>Assessed compatibility issues between Informix and Oracle.</li> <li>Rewrote and optimized stored procedures using PL/SQL.</li> <li>Validated functionality and data integrity post-migration.</li></ul>
✅ Technical Impact	Project Involvement: <ul><li>Worked with 29 large Visual Basic projects.</li> <li>Handled 19 Oracle modules.</li> <li>Re-implemented 118 Visual Basic forms post-migration.</li></ul>
🔹 Technical Skills Acquired	Software Development: Visual Basic 6.0 Development & Maintenance Database Development: PL/SQL & Oracle 9i Stored Procedures Development Automation & Batch Processing: Pro C/C++ for scripting Migration & Optimization: Database migration from Informix to Oracle Testing & Validation: Ensuring database integrity post-migration
📚 Lessons Learned & Impact	✔️ Strengthened experience in maintaining and upgrading legacy systems in Visual Basic 6.0. ✔️ Gained expertise in Pro C/C++ for batch automation. ✔️ Successfully migrated a large volume of stored procedures while ensuring data integrity. ✔️ Improved SQL migration and database optimization skills for Oracle.