Lauro Oshiro's Linkedin Analytics

Hello world! As a data-driven professional with Green Belt background and 7 years of experience across a multinational, startup and a great consulting companies, I have honed my skills in problem-solving and statistical analysis to deliver accurate, efficient and impactful data solutions. Here's a bit of what I've been doing: - Implemented diagnostic and preventive data analysis that reduced fraud/risk transactions ~$5k monthly losses to zero; - Improved and maintained python routines, ensuring timely and accurate reporting that reduced operational time by +80% (from hours to minutes); - Created user-oriented automated online Power BI dashboards that boosted client engagement by over 40%, reducing churn and returning cross-selling of new data products; - Developed advanced SQL queries to generate a Yearly Retrospective Report, highlighting the most purchased items and quantity per user. Skillset: - SQL: Expertise in writing and optimizing SQL queries; - ETL: Integrating data from various sources with PowerQuery; - Data Quality: Troubleshooting issues such as duplicate records, column type mismatches, null values, inconsistent date formats, incorrect aggregations, and missing data entries using PowerQuery and SQL; - Data Modeling: Developed robust data models using Star Schema best practices; - Performance Metrics: Crafted advanced DAX measures to provide business KPIs, removing time of manually created reports and allowing Business owners to be more present at the production lines; - Stakeholder Engagement: Carried out end-to-end colaboration with stakeholders, defining requirements, delivering data solutions, creating and presenting performance reports. My passion for data comes from the craftsmanship of transforming raw numbers into actionable insights. I thrive in collaborative environments, bringing strong attention to detail, fast-paced learning and a commitment to continuous improvement. Let's talk already!