Juan Camilo Chafloque Mesia Email & Phone Number

Bogotá, Bogota, Co

Denver, Colorado, United States

Bogotá, Capital District, Colombia

Bogotá, Capital District, Colombia

• Collaborated with 10+ developers and product managers to formulate implementation plans for telecommunications system development, including requirements gathering and project coordination, ensuring seamless coordination among teams and timely project delivery.• Managed the development of comprehensive business requirements document for proprietary software applications, driving requirements gathering sessions, test and user guides, and functional and technical designs.• Spearheaded… Show more • Collaborated with 10+ developers and product managers to formulate implementation plans for telecommunications system development, including requirements gathering and project coordination, ensuring seamless coordination among teams and timely project delivery.• Managed the development of comprehensive business requirements document for proprietary software applications, driving requirements gathering sessions, test and user guides, and functional and technical designs.• Spearheaded redevelopment of internal applications in use by client employees, resulting in 20+ new features.• Developed a trouble ticket front end application with advanced functionalities for module administrators, resulting in a 40% increase in issue reporting efficiency to internal teams.• Led the development and implementation of PL/SQL procedures and triggers, streamlining data validation and automating critical business workflows, which increased data accuracy by 35% and reduced processing time by 15%.• Implemented and optimized new back end features for billing, trouble ticket management, and order/service activation internal applications, resulting in a 30% reduction in customer support issues and a streamlined workflow.• Developed a front end application to facilitate large scale testing, resulting in a 45% reduction in testing time and boosting result accuracy through automated data analysis and visualization.• Collaborated closely with QA team throughout software release cycle, conducting comprehensive code reviews, detecting and reporting defects, deploying product releases into clients’ production environments, achieving 15% reduction in post release defects. Show less

Bogotá, Capital District, Colombia

• Engineered telecommunications applications through full stack development, optimizing B2B/B2C ecosystems, improving response time.• Streamlined and upgraded the applications service fulfillment provider and inventory management system (Oracle MetaSolv) delivering a 50% boost in performance, resulting in faster service delivery and improved customer experience.• Conceptualized use cases and UML diagrams, such as activity, sequence, and class diagrams, in accordance with product… Show more • Engineered telecommunications applications through full stack development, optimizing B2B/B2C ecosystems, improving response time.• Streamlined and upgraded the applications service fulfillment provider and inventory management system (Oracle MetaSolv) delivering a 50% boost in performance, resulting in faster service delivery and improved customer experience.• Conceptualized use cases and UML diagrams, such as activity, sequence, and class diagrams, in accordance with product objectives, enhancing development clarity and efficiency, leading to reductions in bug related issues.• Overhauled obsolete legacy source code of production applications, resulting in increased usability and reduced run time performance.• Conducted code review sessions with cross functional teams to evaluate and analyze system designs, resulting in actionable recommendations that decreased defect creation rate by 35%.• Architected database logic for new applications, including data population, package creation, trigger implementation, function development, and stored procedure design, optimizing database performance, resulting in a 25% increase in application speed.• Upgraded and optimized back end functionalities for existing software applications, reducing system errors by 20% and improved performance, boosting overall user satisfaction and productivity.• Constructed REST and SOAP APIs to enable seamless communication between applications and the service fulfillment provider, leading to a 45% reduction in API response time by streamlining data logic and optimizing SQL queries. Show less

Master Of Science - Ms, Computer Science

Bachelor Of Science - Bs, Computer Science

Bachelor Of Science - Bs, Industrial Engineering