Daniel Camilo Rojas Arias Email & Phone Number

Colombia

As a Big Data Developer Scotia Bank as client, I am responsible for developing data solutions utilizing SQL, Hadoop, and Diyotta technologies. My role involves enhancing data extraction processes from various sources and providing data solutions to different teams within the bank. Additionally, I excel at fixing SQL and Hadoop code to ensure efficient data workflows. I am also experienced in transferring files between environments using Bash and SFTP applications. Key Responsibilities: Develop innovative solutions on Hadoop and SQL platforms to optimize data extraction and integration from diverse sources. Collaborate with cross-functional teams to understand their data requirements and deliver effective solutions tailored to their needs. Identify and resolve code issues, ensuring accurate and efficient data retrieval by troubleshooting and debugging SQL and Hadoop code. Create comprehensive documentation for code, processes, and workflows to facilitate knowledge sharing and adherence to best practices. Work closely with data architects and data engineers to design and implement robust data models and efficient data pipelines. Keep up-to-date with industry trends and emerging technologies related to big data processing and analytics

Bogotá, D.C., Capital District, Colombia

As a Reports Developer Engineer, I use SQL to monitor daily file generation processes, execute and modify SQL queries. My expertise also extends to creating data solutions in Python to enhance data analysis derived from log and xlsx files.Key Skills:Proficiency in SQL and Python for data retrieval, analysis, and reporting.Experience monitoring daily file generation and ensuring smooth execution of SQL queries.Ability to create data solutions using Python to improve data analysis from log and xlsx files.In this role, I am responsible for monitoring the daily file generation process, ensuring the successful execution of SQL queries, and optimizing them for efficient data retrieval. My work involves collaborating with foreign partners, requiring proficiency in English to effectively communicate and align on requirements and deliverables. Furthermore, I utilize Python to create data solutions that enhance analysis and reporting capabilities, particularly for log and xlsx files.With a keen attention to detail, problem-solving skills, and the ability to manage multiple tasks, I deliver high-quality results within dynamic work environments. By leveraging my technical expertise in SQL and Python, along with my ability to collaborate across diverse teams, I contribute to the development of data-driven insights and solutions.Overall, as a Reports Developer Engineer, my goal is to leverage my skills in SQL, Python, and English communication to effectively monitor and optimize file generation processes, collaborate with foreign partners, and create impactful data solutions for enhanced analysis and reporting.

Bogotá, Colombia

As a Data Architect, my primary responsibility is to design and create efficient ETL processes using SAS Guide. This involves migrating data from Oracle tables to various datamarts on SQL Server, specifically for 80 campaigns of AVAL Group's call center services. I ensure that the ETL processes are automated, minimizing manual effort and improving overall efficiency.Additionally, I focus on filtering the extracted information to enhance performance and optimize the ETL execution. By applying my expertise in SQL, Oracle, and SAS Guide, I implement strategies to improve data quality, validate data integrity, and ensure accurate results.Throughout the data migration and ETL processes, I actively supervise and support the execution to maintain data quality standards. I work closely with cross-functional teams to resolve any issues, provide technical guidance, and ensure smooth data flow.Overall, as a Data Architect, I leverage my proficiency in SQL, Oracle, and SAS Guide to design and implement efficient ETL processes, migrate data between systems, automate execution, optimize performance, and ensure data quality. My focus on detail, problem-solving skills, and commitment to excellence contribute to the successful execution of data-driven initiatives for AVAL Group's call center services.Key Skills:Proficiency in SQL, Oracle, and SAS Guide for ETL process design and implementation.Experience in migrating data from Oracle tables to SQL Server datamarts for multiple campaigns.Expertise in automating ETL execution and optimizing data extraction and filtering for improved performance.Strong attention to detail and focus on data quality assurance.

Silvania, Cundinamarca, Colombia

As a Junior Programmer, I specialize in C#, SQL, and API technologies, with a strong skillset in Scrum and leadership. My primary responsibilities include developing lightweight solutions using C# for a CRM system called SmartHome, making modifications to specific files for individual clients. I also contribute by adding new functions to the CRM system and modifying graphics on Google Data Studio. In addition, I lead a 3-member programming team, applying Scrum methodologies and utilizing Monday as a project management tool. Key Skills: Proficiency in C#, SQL, and API technologies. Knowledge of Scrum methodologies. Strong leadership abilities. Familiarity with Google Data Studio for graphics modifications. As a Junior Programmer, I am adept at utilizing C#, SQL, and API technologies to develop lightweight solutions for the SmartHome CRM system. This includes making modifications to specific files to meet the unique requirements of individual clients. Additionally, I contribute to the ongoing development of the CRM system by adding new functions and features. These enhancements aim to improve user experience and streamline processes within the SmartHome CRM. In my role, I also utilize my leadership skills to guide and oversee a 3-member programming team. I apply Scrum methodologies to ensure efficient project management, task allocation, and timely delivery of results. Monday serves as our project management tool, allowing us to track progress, manage tasks, and collaborate effectively. Overall, as a Junior Programmer, I bring my proficiency in C#, SQL, and API technologies, coupled with my skills in Scrum and leadership, to develop lightweight solutions, modify CRM files, add new functions, and lead a programming team. My focus on delivering high-quality results, fostering effective collaboration, and leveraging technology tools contributes to the success of SmartHome's CRM system.

Ingeniero De Sistemas, Computer Science

Técnico En Programación De Software, Computer Science, Finalizado, No Titulado