Pedro Lins

Background

About Pedro Lins

Data Analyst with over 2 years of experience in commercial planning involving receivables anticipation, overdrafts, Pix, TED, bank slips, and other payment methods. Skilled in the development and presentation of dashboards, management reports, executive summaries, break-even and payback analysis, setting commercial targets, and commission calculations. Project leader in database development and optimization (ETL) and main point of contact for internal and external audits. Developed and optimized SQL queries for extracting, processing, and analyzing large volumes of CRM data. Created and maintained interactive dashboards and automated reports using Looker Studio, Qlik Sense, and Google Sheets to present key commercial KPIs and projections. Calculated and presented commission data to executives, covering 3 products, 120 managers, and approximately R$ 4 million. Conducted break-even analysis for commercial managers, resulting in headcount reductions. Managed and optimized database procedures, reducing rework and decreasing processing costs by 60%. Collaborated with cross-functional teams to develop and implement projects, translating business needs to IT. Supported internal and external audits by providing management reports.