Diane Lai Email & Phone Number

California, United States

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, custom objects (derived measures, dimensions, calculations). Designed/modified ETL processes for Integral Aerospace’s data warehouse with data integrity and validation processes.• 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.• Converted Access/Excel/UniData reports to Reporting Services 2014/2016.• Created Bill of materials (BOM) for the Engineering team, labor metric reports.• Used MS Access, Excel, VBA to develop databases for operation.• Maintained Integral Aerospace Intranet site with Webflow.• Acting as a subject matter expert across the organization; assists users with reporting and analysis activities and tools. Converted business requirements into technical specifications and conversely, technical approaches into layman’s terms.

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 substation Construction and Maintenance (SC&M). Provide reporting, analytical, identify and address long term business issues such as data integrity/data collection. • 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 Analysis Plan (SAP); Converted many reports from SAP to SAS to save running time and storages.• 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 database (DPMO) using PROC IMPORT techniques and SQL pass through facility.• Developed many ad-hoc queries/reports and coded utilizing SAS/SQL on Windows Environments.• Had strong knowledge of using SAS Enterprise Guide and SAS Visual Analytics.• Highly influential on senior management decisions about new collect data methods for checker requests and test resource requests.• Built and maintained Checker Request SharePoint site, Substation Facility Inspection SharePoint site and Test Resource request form to improve business processes.• Built and maintained Checker Request forms for all contractors by using VBA in Outlook.

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) management team in making decision associated to all Airline programs. • 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 to improve process.• 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 database for FMR using VBA.• 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 accuracy and effectiveness.• 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 processes. Ensured the new tails are added in the DART system before delivering day.• 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.• Reduced 99% time required to generate fleets performance report for Delta Airline from 3 working days to 5 minutes.

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 Toshiba management team worldwide in making decision regarding product warranties, parts inventories, product development, and financing forecast.• 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 application and project. • 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 intended requirements.• Built Quality Report sites using SharePoint server 2010, integrating SSRS with SharePoint to deploy many important reports for Quality/Finance departments.• Won superior award for OOW (Out of Warranty) claims reduction project, saving $700K.• Saved near $2M in Process Improvement projects (Six Sigma Projects) by leading 3 projects in reducing missing parts, Customer Cause Failure defects, and improving collection data process at ODM (Original Design Manufacture) repair center.• Created very complex global reports (Monthly Field Failure Reports) using Access/Excel VBA, helping top managements in US and Japan in making important decisions.

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 control charts for each assembly lines of MFG floor. Helped Quality team to improve quantity and quality of Toshiba products. • 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.• Created procedures for each database on how to operate systems and conducted many training classes for more than 100 employees.

Bachelor'S Degree, Enviromental Engineering

Master'S Degree, Software Engineering