Company Experience 16

📌 Name of Company: Periferia IT

💼 Role: Java, PL/SQL & Transact-SQL Developer/Analyst

📍 Address: Avenida Carrera 9 # 115-06/30, Oficina 604, C.E. Tierra Firme

📜 Duration: July 2016 – August 2016 (2 Months)

🏢 Client Name: Royal Sun Alliance (RSA)

📞 References: Camilo Cabrales (+57 310 6081690) 🔗 LinkedIn

📩 RRHH Contact: Daisy Olaya Medina (Payroll & Hiring Assistant)

📞 Tel: 6000080

🚀 Project Name: Infrastructure & Data Migration RSA-Sura

💻 Technologies & Tools:

🔹 IBM Rapid Application Development
🔹 SQL Server Management Studio 2008
🔹 SQL Server Integration Services (SSIS)
🔹 SQL Server Analysis Services (SSAS)

⚙️ Key Responsibilities & Achievements:

✅ Intranet Enhancement (Joomla):
🔹 Configured RSA’s Joomla-based intranet to display a pop-up invoking a web service for fetching Active Directory user names.

✅ Database Debugging & Optimization:
🔹 Developed SQL scripts to clean and debug data tables sourced from DB2 and Sybase before updates.

✅ ETL Process with SSIS:
🔹 Designed and implemented workflows in SQL Server Integration Services (SSIS) to:

• Extract data from DB2 and Sybase.
• Transform data (e.g., email changes).
• Load processed data into SQL Server.

✅ Advanced Reporting with SSRS:
🔹 Leveraged SQL Server Reporting Services (SSRS) to streamline reporting within RSA, including:

• Designing customized reports tailored to business needs.
• Writing complex SQL queries for accurate and timely data retrieval.
• Implementing dynamic parameters & drill-down functionality for enhanced user experience.

📌 Analytical Table for Periferia IT

💻 Technologies & Tools Used