Juan Carlos R. Email & Phone Number

Bogotá, Bogota, Co

Bogotá, Bogota, Co

Bogotá, Capital District, Colombia

In my role, I focus on establishing practical best practices and strategies for data integration that prioritize efficiency and scalability. My approach involves guiding the team with knowledgeable support to ensure smooth and effective implementation processes.Model and design a Data Warehouse for a financial institution, applying my knowledge of data integration and the best practices in a real-world setting for support the analytical needs of the institution. My work with the stakeholders was focused in understanding their requirements and translating them into a robust data architecture.• Utilization of tools like Oracle APEX, and Oracle Data Modeler, Talend, Alteryx in conjunction with Snowflake, and Alation Data Governance.

Bogota, D.C., Capital District, Colombia

Bogotá, Capital District, Colombia

Design, develop, and deploy the pipeline architecture to process the operational and historical data for a leading IT services and consulting company. Plan, build, and implement best data integration workflow practices and strategies while providing expert support throughout the process.• Utilized Talend Data Studio and Talend Management Console, Google Cloud Console (CLI, VMs GKE Cluster), Azure Data Factory (Blob, and Data Lakes, Azure SQL Databases) to design integration workflows, as well as create and run Jobs, Data Services, and routes while ensuring optimal security.• Efficiently developed 100% of the allocated Extract Transform Loads (ELTs) within the stipulated timeframe.

Bogota, Distrito Capital, Colombia

Responsibilities: Creation of Dataflows for pulling, transforming, and loading or delivering in a different format data from Hadoop (HBase and Hive), SalesForce, SQL Databases, and MongoDB for analytical or reporting purposes.Troubleshooting some workflows diagnosing and solving SQL and java issues leveraging log4j capabilities. Daily basis working with Bitbucket repositories.

Bogota,D.C., Capital District, Colombia

Responsibilities: Design, developing and implementation of Back-end solution in data staging, cleansing, confirming and delivery.Nexidia is an Interaction Analytics solution running on Windows environments with SQL server databases. Implementation of complex logic for solutions based on the different metadata and audio formats provided by the customers.ETL design and deploy for calls, emails, social network, chat and metadata data interactions analytics for Nexidia solutions using SQL and SQL Integration services in Cloud and On-premise environments.

Bogota

Installation and integration of NICE software solutions, while following defined methodology, processes, system requirements, and customer specific needs.Work directly with the project team to assist with any technical questions regarding the solution from the kick-off until the turnover of the Implementation to our support center.Communication and reconciliation of any issues found during the delivery of Nice Solution to the project team.The PSE is expected to manage the customer relationship and expectations, communicate effectively the solution delivery status.

Bogotá-Colombia

Onsite support for functional requirements at 3D Rooms, home automation solutions, operative conceptualization, technical implementation, development of project through its stages of implementation, development and operation.Integration Services DevelopmentsReporting services DevelopmentsSupport as DBA for all SQL Server databases in the company.

Responsibilities: Systems Department manager, as it as functional Support for the Servers, communications and Network of the company. Functional Support to the in-house software developed in Visual.Net and SQL Server. Design and commissioning of WEB strategies and Social networks.

Bogota, D.C., Capital Distrinct, Colombia

Support on Windows server 2003. Support to users, maintenance and repairing for computers and printers. Support in Networking.Generation of procedures and definition of workflows for implementation of countable system SIIGO with SQL 2005 Database Management System.

Bogota,D.C., Capital District, Colombia

Technical support for Schlumberger Oilfield segment to users from all Latin America. Onsite Support and Service Desk support. Training to new staff Service Desk of Schlumberger and Ecopetrol.

Bachelor'S Degree, Enginering

Bachelor's Degree in Systems Engineering UNAD Relevant coursework: Software Development, Database Management, Network Administration.

Diplomado Admón Bases De Datos - Sql Server, Ingeniería Informática