• Developed a fully automated QA Dock Summary in PowerBI, enhancing QA team efficiency by over 75% in reviewing scorecards. Automated DL team reports, significantly improving the quality of data presentation for executive use.• Led the transformation of reports from Excel to PowerBI, including determining the proper data source, developing SQL queries, building the connection, choosing interactive visualizations and publishing fully automated reports. Automated 3 daily and 4 weekly reports in PowerBI to provide valuable insights for executive team and stakeholders.• Streamlined the Compliance team's reporting process by implementing SQL queries, reducing their manual workload by half a day per month. Collaborated closely with cross-functional teams, setting up regular meetings and meticulously documenting each step in report creation for future reference and consistency.

• Used predictive analytics and regression modeling to examine and determine patterns in data that company can use to predict and understand client’s behavior, such as key demands and purchasing trends. (Excel, Python)• Tracked and analyzed marketing and sales trends from company CRM database, forecasted and prepared weekly and monthly reports to measure the key attributions that affected sales lead profile.• Conducted data cleaning, organization, and descriptive analysis using SQL, Excel, and other tools to identify customer behavior trends and patterns that informed marketing and sales strategies.• Created standardized process for handling data processing of customer cross sells. Involved standardizing entire customer database using data cleaning method, and appending information from several competitors’ information, eliminating multiple data processing steps.• Designed and implemented customer segmentation strategies to improve targeting accuracy from analyzing sales lead profile, social media platform conversion rate, provided customized promotion strategies to enhance ROI.

• Maintained data integrity of product activities by writing queries to clean, de-duplicate and update logisticalrelationships in PostgreSQL, as to manipulate data analysis and align with business goals.• Compiled inventory control report in Excel by reconciling the supply-demand balance, monitoringmultiple product lines, and establishing communications with other departments in a timely manner.• Generated visualized views of progress check, incremental sales, marginal analysis in Tableaudashboards, embedded with automated update and filters to be presented in weekly touch point meetings.• Identified discrepancies in inventory management and invoice timeline to avoid delay and inaccuracy,therefore proposed a solution to add in new feature of tracking manufacture process and facilitated theon-time delivery rate by 15% with backup plans and timely adjustments.