Lauro Oshiro

Background

About Lauro Oshiro

Hello world! As a Green Belt data-driven professional with Industrial Engineering background and 7 years of experience across multinational, startup and 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 to automate routines, ensuring timely and accurate reporting that reduced operational time by +80%(from hours to minutes)- Created user-oriented online Power BI dashboards that boosted client engagement by over 40%, reducing churn and returning cross-selling of new data products for major client in a B2B company- 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 (aggregation functions, window functions, declaring variables, subqueries and CTEs)- ETL: Integrating data from various sources with DataBricks using medallion data architecture and Power Query for minor changes- Data Quality: Troubleshooting issues as duplicate records, column type mismatches, null values, inconsistent date formats, incorrect aggregations, and missing data entries using Python/PySpark, M language 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, handling with tight deadlines or sudden change of scope, 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.