Yuly Valderrama
Scranton
Summary
Systems engineering professional an over 10 years of industry experience in software development and project management, data analysis and information systems. Proactive professional, rapid learner easily adapts to multi-cultural environments. Results oriented.
Overview
13
13
years of professional experience
Work History
SOFTWARE ENGINEER II
ROI CONSULTING INC.
08.2022 - 02.2024
- Collaborated with software development and testing teams to design and develop robust solutions for e-commerce platforms and Sage ERP integration.
- Evaluated proposed technical solutions based on customer requirements and provided insights to optimize designs.
- Mentored less-experienced staff members, offering guidance on best practices and coding standards.
- Integrated third-party tools and components into applications, ensuring seamless functionality and compatibility.
- Utilized C#, SQL, PHP, and MySQL programming languages and associated tools to architect, develop, and test software solutions. Conducted performance analysis and optimization to enhance scalability and performance of applications.
SOFTWARE ENGINEER
ROI CONSULTING INC
01.2022 - 08.2022
- Work with a variety of customers and platforms
- E-commerce platforms simultaneously, each with different technology stacks, to deliver improvements
- I independently expanded my knowledge of cloud-based technologies, content management systems, and front-end development and applied it to my workload
- I communicate directly with clients and stakeholders to gather requirements, estimate work effort, and deliver updates.
- Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability, and performance.
- Led the integration of multiple e-commerce platforms, each utilizing different technology stacks, leveraging expertise in Azure, MySQL, SQL, PHP, and C# to develop custom integrations and connectors for seamless data exchange and functionality enhancements.
- Engaged directly with clients and stakeholders to elicit and gather comprehensive requirements, ensuring alignment between project objectives and stakeholder expectations.
FULL STACK DEVELOPER
SIMPLICITY CONSULTING INC
09.2019 - 01.2021
- Worked with back-end developers to design APIs
- Reviewed code, debugged problems, and corrected issues
- Wrote server-side and client-side code for projects using PHP, HTML, CSS and JavaScript
- Tested functional compliance of company products
- Wrote server-side and client-side code for projects using NET,SQL.
- Reviewed code, debugged problems, and corrected issues.
- Refactored legacy codebases to modernize software architecture and improve maintainability.
- Developed unit test cases for testing and automation.
SOFTWARE ENGINEER
Colombian Society of Anesthesiology
10.2019 - 04.2020
- Generate Reports designed with Microsoft SQL Reporting Services and interface with the company's indicator system
- Assist in developing applications using .NET in C# and JavaScript
- Design and code enhancements
- Post-production troubleshooting and support.
SENIOR DATABASE DEVELOPER
Colombian Society of Anesthesiology
07.2017 - 10.2019
- Design and implement complex SSIS package to migrate data from multiple data sources
- Created SSIS package to extract, validate and load data into Data warehouse
- Created Stored procedure, Views, Cursors and functions to support several applications
- Implemented multiple grouping into several reports using multiple views
- Achievements: Automated over 50% of the strategic, tactical and operational indicators
- Built new ETL packages using Microsoft SSIS
- Designed and created custom reports in Microsoft Power BI
- Fixed existing standard scripts to meet updated database structures
- Created migration scripts for new data sources.
DATABASE DEVELOPER
Colombian Society of Anesthesiology
04.2015 - 07.2017
- Develop advanced SQL queries and store procedures in MSSQL
- Design the database architecture and related data processing documentation
- Interaction with software engineers, product team members and business leads in order to understand their database requirements for new products or features
- Post-production troubleshooting and support
- Achievements: Designed and developed ERM for application the International Congress of Anesthesiology and Resuscitation, where more than 1600+ anesthesiologists were registered
- Involving in performance tuning for complex SQL queries using explain plan tables, collections, and table partitions to optimize performance for several projects
- Building physical data structures like tables, views, constraints & indexes for several projects
- Completed hands-on configuration and custom development of reports.
SOFTWARE ENGINEER
MECTRONCIS
11.2013 - 04.2015
- Design and develop web applications .NET and ASPX code writing in C# and VBA
- Support clients in a cross-functional environment; perform analysis based on requirements and technical Build user-friendly client-side interface for projects using JavaScript, CSS, and HTML
- Achievement: Redesigned 60% of the project that made the programming of drivers for vehicles.
SOFTWARE ENGINEER
HANDS BUSSINES SOLUTION
09.2012 - 09.2013
- Develop core functionality for SharePoint 2010 environments, including team sites, content management system (CMS) tools, and web parts
- Provide coding support using popular languages such as VB.NET Microsoft SQL Server
- Analyze existing code to determine functionality
- Achievements: Designed information flows to help allied companies like Bavaria (beer producer).
SOFTWARE ENGINEER
INSOFT
04.2011 - 08.2012
- Programming in ASP.NET, C#, VB, HTML, JavaScript, CSS, and SQL Server 2008
- Analyze call logs and consolidated common trends and underlying problems
- Monitor and respond to potential breakdowns
- Provide technical support to schools using the online academy software systems
- Perform database operations to include backups, restores, script creation, schema alterations, and enhancements, and job creation for automating services
- Achievement: Redesigned 100% of the application to verify uploading notes, calculating notes, downloading bulletins.
Education
MTA: Database Fundamentals - Certified 2021 -
Microsoft
Systems Engineer | Information Technology -
Universidad Piloto De Colombia
Universidad Cooperativa De Colombia -
Skills
- Fluent in C#, Net Core, PHP
- Testing and debugging
- Development environment software Web applications
- Power BI
- Data warehousing and analytics Dashboard creation
- MS SQL Server
- MYSQL
- API Design
- JIRA
- Agile
- Scrum Methodology
- Microsoft ASPNET
Accomplishments
- Developed a platform to register all anesthesiologists in the society: http://registro.scare.org.co/Login
- Developed a platform for re-certification of all anesthesiologists in the society: http://www.academo.co/Login.
Languages
Spanish
Native language
English
Proficient
C2
French
Elementary
A2
Timeline
SOFTWARE ENGINEER II
ROI CONSULTING INC.
08.2022 - 02.2024
SOFTWARE ENGINEER
ROI CONSULTING INC
01.2022 - 08.2022
SOFTWARE ENGINEER
Colombian Society of Anesthesiology
10.2019 - 04.2020
FULL STACK DEVELOPER
SIMPLICITY CONSULTING INC
09.2019 - 01.2021
SENIOR DATABASE DEVELOPER
Colombian Society of Anesthesiology
07.2017 - 10.2019
DATABASE DEVELOPER
Colombian Society of Anesthesiology
04.2015 - 07.2017
SOFTWARE ENGINEER
MECTRONCIS
11.2013 - 04.2015
SOFTWARE ENGINEER
HANDS BUSSINES SOLUTION
09.2012 - 09.2013
SOFTWARE ENGINEER
INSOFT
04.2011 - 08.2012
MTA: Database Fundamentals - Certified 2021 -
Microsoft
Systems Engineer | Information Technology -
Universidad Piloto De Colombia
Universidad Cooperativa De Colombia -
Similar Profiles
Catherine Le RoiCatherine Le Roi
Co-President at Bellroi partners, Le Roi Consulting LLCCo-President at Bellroi partners, Le Roi Consulting LLC
David NeilDavid Neil
Engineering Consultant at ROI MichiganEngineering Consultant at ROI Michigan
Travis GilbertTravis Gilbert
Receiving Clerk/Material Handler at ROIReceiving Clerk/Material Handler at ROI