Allan Romero De Souza Viveiros

- Responsible for the development and maintenance of custom WordPress themes and plugins, ensuring they met diverse client requirements and maintained top-notch functionality - Utilized HTML, CSS, JavaScript, and PHP to create responsive and visually appealing websites, enhancing user experience and engagement - Integrated third-party APIs and advanced functionalities to expand website capabilities and drive user interaction - Employed SEO best practices to optimize website performance, increasing visibility and search engine rankings - Collaborated closely with designers and clients to align project goals with business objectives, delivering tailored web solutions - Troubleshooted and resolved website issues, maintaining seamless and efficient operations - Conducted regular updates and optimizations to improve site speed, usability, and accessibility - Leveraged WordPress as the primary tool for developing and managing websites, ensuring ease of use and scalability.

- Developed a dynamic Excel spreadsheet that was directly connected to the database, providing users with real-time information on products in storage, products moving to other branches, and products reserved for clients. - Conducted data gathering and analysis, merging information from two databases and presenting it in the form of analytical reports to users and the technical team during the system migration process. - Conducted surveys and analyzed data to gain an understanding of workflows and how to utilize technological solutions to support business units, particularly accounts receivable and revenue areas. - Analyzed processes and system impacts, surveyed resources and business rules, and gathered business requirements to develop and implement ERP packages that resolved issues and applied updates. - Provided support to business users during testing and implementation, working closely with technical staff to report and resolve issues and bugs across various business areas. - Developed SQL queries and scripts to further enhance data analysis and reporting capabilities.

- Improved the performance of a database application by expertly fine-tuning database queries, optimizing indexes, and developing a stored procedure. This led to a reduction of more than 70% in response time. - Successfully reduced the amount of phone calls between the main branch and other branches located in different cities by 40% by implementing online processes. - Developed innovative technology solutions to cater to business units' requirements and demands. - Developed effective reports for management and business units, providing comprehensive and relevant data analysis. - Created, maintained, and optimized SQL and PL/SQL queries, procedures, functions, triggers, and scripts for Oracle databases. - Conducted data gathering and analysis to identify opportunities for improving the database performance and maintained it for the development team.

- Receive all electronic orders - Responsible for finish daily sales and all invoices and bills generation - Support sales team - Customer support by phone - Invoice management - Preparation of spreadsheets and reports with the daily and monthly billing statement