Wei-Jen Teng

Business Analyst and Powerbi Developer @SMS Infocomm

Dallas, TX, US

Developed an automated data pipeline and built Power BI dashboard to track and report key business metrics such as Inventory Turnover, Employee Productivity, and equipment idle time, resulting in an 80% increase in productivity.• Developed Power Apps solutions that enabled non-technical business user to easily edit cloud databased, resulting in a 90% reduction in time spent resolving data quality issues.• Constructed automated ETL pipeline using Python, Power Query, DAX from local flat files, saving 10 hours of manual work each week• Conducted sales analysis reports to monitor performance by integrating ERP database and sales data, using VBA; the report was adopted across all operational teams and sales departments• Collaborated closely with business users to gather their requests and updated over 100 models in Power BI reports to monitor the trend of the business logistics. Ensured accuracy of shipment times, reduced delays, maintained sufficient inventory levels, and increased customer satisfaction by 100%.