Julio Parra Sanchez

Responsibilities:

• Work with Senior IT Programmer / Analyst(s), users and management to assess software needs and system requirements.
• Mentor Entry Level IT Programmer / Analyst(s) to assist them with their tasks and projects.
• Formulate and communicate ideas for software to help solve business problems.
• Design, develop, test, document, implement and support new custom-written software, as well as modify and support existing software.
• Refactor and Maintain EVO ReactJS Application
• Refactored the EVO ReactJS sales dashboard used daily by the sales and operations teams — migrated state management from Redux to Context API, replaced the Semantic UI library with Chakra UI, and rebuilt core GraphQL schemas/resolvers, reducing component complexity and improving load performance for reporting workflows.
• Create and refactor GraphQL schemas, type and resolvers as the company and the users need it or requested
• Create HTML/PDF Templates on Netsuite Oracle
• Create and implementation of suitescript on Netsuite Oracle
• Designed and built an Enterprise Access Management portal in Angular 14 (standalone components, RxJS) integrating Azure MySQL and Firebase Realtime Database, centralizing user permission management across multiple internal applications for the IT department.
• Create and documentation of RestfulAPI(NodeJS, Nodemon, swagger) using Clean Architecture.
• Wrote and optimized complex SQL queries (inner/left/right joins, subqueries) to improve report accuracy and reduce query time for business-critical reporting.
• Built and maintained a scheduled cron job to automate field updates on an Azure-hosted MySQL database, eliminating a manual data-entry step for the team.
• Set-up new users and maintain security rights.
• Develop, run and distribute custom queries and reports, as needed.
• Create and modify customer-specific product label templates.
• Create and maintain manufacturing specification templates.
• Monitor existing software and increase performance, as needed.
• Train users on new and existing software.
• Flexibility to support operational activities, as needed.
• Provide 24 / 7 support by carrying a pager on a rotating schedule with other members of the IT Department.

Responsibilities:

• Translate UI/UX compositions into functional, extensible, and testable components.
• Create and Maintain a reusable components in ReactJS
• Built and maintained a shared library of reusable React and React Native components adopted across multiple product features, reducing duplicate UI code and speeding up new feature delivery.
• Help and Maintain the Web page on WordPress
• Create and refactor python scripts used on AWS
• Create and Manage AWS S3 Bucket
• Help backend team to create AWS EC2 with Ubuntu
• Help backend team to create and maintain AWS DynamoDB database
• Develop readable code from an interface-first approach to deliver features on a timely cadence.
• Provide feedback & review peers' code and refactor code of your own when necessary.
• Contribute to ongoing documentation.
• Mentored 2 mid-level/junior developers on clean code practices and component design, incorporated into regular code review cycles.
• Participate in all faculties of Scrum Methodology.
• React development and Flux implementations.
• Hash-Routing, DOM, ShadowDOM, CSSOM, Box-Model.
• Create and Maintain another MERN app using NodeJS, ReactJS, MongoDB, Express Framework and mongoose to create schemas and using MVC architecture

Responsibilities:

• Follow all Company safety policies and safety procedures in order to maintain a safe work environment.
• Flexibility to support operational activities, as needed.
• Participate in all faculties of Scrum Methodology.
• Designed, developed, tested, documented, implemented, and supported custom web applications using JavaScript, TypeScript, React, Angular, Node.js, and SQL, partnering with users and management to turn business needs into production-ready tools.
• Maintain Web Portal SugarCMS as one of the Admin users
• Create a project for milestone using Python & Django, MongoDB as BE
• Internal Project for Client (Hensel Phelps) application using ReactJS.
• Internal project for Client (Hensel Phelps) use NodeJS using MVC architecture and adding some custom middlewares.
• Create a Python script for create/drop tables and maintain DB(MySQL)
• Create a reusable components on ReactJS

Responsibilities:

• Analyze data sets and software programs.
• Handle a large amount of data. Predefined and custom reports in the IBM Cognos suite.Query / Cubes OLAP (On-Line Analytic Processing).
• Data Mining and Data Modeling.
• Data Collection and Processing.
• Data Cleansing and Processing.Running Queries.
• Statistical analysis.
• ETL Optimization.
• Monitoring BI processes.
• Cron jobs

Responsibilities:

• Identify, compare and resolve data quality problems.
• Evaluate large dataset for quality and accuracy.
• Correct data quality errors (Design and Application Development (Visual Basic 6, Visual Basic, NET, SQL, Server 2005).
• Determine root cause for data quality errors and make recommendations for long-term solutions.
• Maintain a record of original data and corrected data.
• Develop and Execute data cleanup measures.
• Ensure adherence to data quality standards.
• Analyze, query and manipulate data according to defined business rules and procedures.
• Customer Analysis databases (Important Bank) - Mass Remediation of Data.
• Participate in the broader external data communities to keep up with industry best practices and emerging trends Evangelize the value of data throughout the organization.
• Create and maintain shared queries for others to review and use as needed.
• Create an application on VB6 MySQL to keep tracking all open ticket to our department, e.g. every request the manager/director receive an email with all description of the ticket
• Create an application on VB6 MySQL used for more than 10 agents for Credit Telecollections, the source file to add on the DB was a txt files generated every morning by AS400 stored procedured

Responsibilities:

• Worked management plans on land distribution projects.
• Basic operation on different electrical PDVSA's facilities.
• Create reports and technical analysis of electrical systems.
• Involved in electrical maintenance works in the field.
• Ensure compliance with safety regulations in all electrical works.
• Calculation used electrical software such as ETAP and AutoCAD.