Diane Lai Email & Phone Number

California, United States

Albany, US

Santa Ana, California, US

• Designed and developed from the ground up the intranet site for Integral Aerospace using SharePoint, SQL Server and ASP.NET. Used Balsamiq wireframe to create layout and interaction design for the intranet site.
• Built the reporting servers (2014 and 2016) and designed, developed, and implemented more than 200 BI reports/sub-reports, visualizations, BI dashboards, navigations aids, predictive analytics tools using BI tools.
• Built webforms using ASP.NET to collect data from various departments and integrated with Integral Aerospace ERP system to produce meaningful reports.
• Managed IIS, SharePoint, SQL servers, ERP and Active Directory. Managed many projects to improve the processes for Aerospace manufacturing.
• Managed multiple projects to improve business efficiencies.
• Used Agile Scrum methodology, apply Six Sigma methodology to improve the process for many departments such as Engineering, Finance, IT, Operations, Program Management, Quality and Supply Chain Management.

Rosemead, CA, US

• Develop innovative solutions /tools to address complex business issues that have major impact throughout company, area of improvement including Resource Planning & Performance Management (RPPM) group of T&D, TS&O.
• Developed, evaluated, analyzed and implement improvements by utilizing Lean Six Sigma methodologies. Created Access database report by extract or link to SQL/Oracle server. Created SSRS reports.
• Cooperated/worked with cross-functional organizations, different levels of management and field workforces while representing RPPM.
• Leaded and conducted SAS (Statistical Analysis System) development team to provide the best solution for business issues. Generated reports, tables, listings and graphs using SAS in accordance with the Statistical.
• Leaded and implemented SAS programs to improve Apparatus, Notification processes.
• Experienced in extracting, manipulating data, and creating SAS Data Sets from various sources like Excel (Apparatus Distribution), flat files, Primavera, Protection Suite, Oracle database (DM/Click databases), Access.

Irvine, California, US

• Created SSRS reports and built dashboard to visualize/improve deferrals process. Created new Access databases with back-end in SQL server to provide tools and real time reports to PTS (Panasonic Technical Support).
• Classified/analyzed around 8000/month FMR (Field Maintenance Report) entries associated to American Airline (AAL) programs against the contractual terms defined in the service agreement. Applied Six Sigma methodology.
• Monitored/updated all FMR entries to ensure accuracy and integrity data. Analyzed and interpreted data by real time charts. Developed presentation and provide strategic recommendations to managers. Created Access/Excel.
• Created better metrics and improved the existing reports for assigned AAL (American Airline) program. Worked with internal teams & SPMs (Service Program Manager) on existing metrics, created new metrics for improving.
• Worked with DART (Data Analysis and Reliability Tool) team to fix errors in the existing 787-900/757-IFS LOPAs (Layout of Passenger Aircraft) and improved BITE (Built-In Test Equipment) auditing/flight matching.
• Prepared materials for internal/customer reconciliation meetings and drive internal stakeholders to explain errors. Worked with Ramco Company on the specification documents of the new system.

Minato-ku, Tokyo, JP

• Senior Software Engineer/Database DeveloperWorked with very large and complex report databases to develop tools and solutions for many departments within the company. Created critical tools and reports to support.
• Collaborated with internal and external customers to analyze and transform non-technical requests and requirements into technical business solutions.
• Analyzed defects / improved processes by using statistical software such as MiniTab, SQC Pack, and Six Sigma methodology - DMAIC.
• Worked close with Finance/Services / Call Center teams to determine best practices and suggests how to improve current process by provide business requirements and functional specifications for each software.
• Collaborated with management teams to provide recommendations on opportunities for process improvements, claims cost savings, and revenue enhancements.
• Performed the roles of a project manager to manage multiple projects and involve in all stages of project development from beginning until deployment stage to ensure projects will be delivered on schedule and meet the.

Minato-ku, Tokyo, JP

• Software Engineer/Quality Engineer/Database DeveloperDesigned and developed database systems for manufacturing. Ensured databases were also integrated with SPC pack and MiniTab software. Displayed real time statistical.
• Designed and developed databases for Manufacturing using Visual Basic 6.0, MS Access 97, SQL server 7.0 and Windows Server NT 4, displaying defects in real time helping management to control processes.
• Provided specific technical solutions, helping engineer-customer interaction.
• Installed and configured database software (servers, tools), performing backup and recovery, administering users, applications, and network services.
• Improved work efficiencies by maintaining and archiving data warehouse.
• Delivered tools and solutions more than 50% faster than expected.

Bachelor'S Degree, Enviromental Engineering

Master'S Degree, Software Engineering