Nilton Pegas

Developed transaction-level analyses (700K+ coupons/month) to detect pricing anomalies and optimize contracts. Implemented market strategies that raised profitability by 11%. Automated mass price updates (400K+ changes/cycle) and Excel routines, reducing manual effort by 76%. Built dashboards for inventory control and dynamic pricing, integrating data from Oracle, MySQL, Protheus, and IQVIA.

Designed dashboards and reports that supported key decisions by municipal leaders. Established methods that boosted routine efficiency by 155%. Developed executive spreadsheets for strategic presentations, standardized procedures, created inventory and deadline controls, and implemented backup routines (on-site and cloud) to ensure data availability.

Implemented test programs recovering 100 batteries and 30 gas sensors, cutting waste and maintenance costs. Created financial controls that eliminated payment errors and rework. Structured cloud-based data sharing for security and availability. Standardized processes, developed financial spreadsheets, implemented quality indicators and 5S methodology, and prepared certification documents to ensure maintenance standards.

Assisted in developing methods for project tracking, improving management efficiency. Created price comparison spreadsheets, reducing costs in improvement projects. Monitored factory projects (ventilation, steam piping), specified materials for process improvements, obtained quotes, purchased materials, and oversaw installations.

- Accountable for the department in internal and external audits. - Compilation of hospital statistics. - Development of quality indicators. - Responsible for training interns. Key Achievements: Through indicator control, identified a flaw in the medical record number generation software and worked towards resolving the issue. Observing and creating additional indicators were instrumental in maintaining accreditation status by the Organização Nacional de Acreditação (ONA).

Participant in the project "Socioeconomic Study of Engineering Students" Engaged in obtaining knowledge about the socioeconomic issues of campus students through data collection, processing, and analysis. The project aimed to provide a foundation for future public policies to prevent student dropout. The data collection involved both physical forms, with project members visiting classrooms, and an online form (Google Forms). The analysis was conducted using Excel.

Final Group Project – Highlighted as the Best Project of the Year 2007