Kelly Phan Email & Phone Number

San Jose

• Developed reports using MS Access and verified final documentation of Lungmen I/O and Setpoint databases and successfully delivered estimate of 150 reports documents to TPC (Taiwan Power Company) Customer at the customer site.• Developed, improved, and maintained Lungmen Digital Control Information System (DCIS) Input/Output (I/O) Database & Setpoint and Logic Function (SP/FX) Database in MS Access. • Revised and issued Logic Diagrams and Schematics for Lungmen Project using Plant Vision Tool.• Developed MS Access macros and ran automated quality checks for data consistency and coordinated corrections accordingly. Provided consultation and training to engineers in the implementation of the guideline for their system inputs.• Maintained strict design control over the contents of the databases. Performed a variety of checks on the data to confirm its validity and pedigree before incorporating this data into the database. Generated several different output report tables from the databases to be used by the DCIS suppliers in the design of the DCIS equipment.• Created queries to view, manipulate, and analyze data. Included use of good organizational skills to control a large number of input and output data points from these databases and innovative thinking to assure data self-consistency, and ability to coordinate the work of Lungmen engineers.• Integrated multiple data sources, processed data analysis, and built interactive dashboards. Loaded data from SQL Server into Power Pivot; and created Power View dashboards, charts.• Proficient using MS Excel including KPI, VLookup, PivotTable, Power Pivot, Slicers to analyze & manage data

• Managed a SAP ERP application / computing environment including an Informix Database and server on UNIX HP 2000 platform. Supported all security and maintenance functions of SAP ERP application including defining job roles and restricting user’s access to data, backing up, scheduling and executing batches, running system utility check in shutdown mode, generating weekly MRP, month-end and year-end close reports.• Performed routine system maintenance tasks such as audit checks, system backups, and transaction log rolls, using UNIX to manage user accounts, to kill user processes, to cancel print jobs and to reset passwords. Created SQL queries to generate custom reports. Troubleshot and solved system and application related problems.

San Mateo, Ca

• Read and assigned job numbers to hospital data received on tape or CD. Imported data into MS Access database. Prioritized and reported the data in a weekly department meeting. • Performed a QA check on the data using SQL. Cleaned and loaded the data into back-end MS SQL Server database. Launched a Base Query on the data. Recorded data on CD and sent to clients

South San Francisco, Ca

• Managed MS Access database including manipulating, analyzing data using MS Excel, performing queries and creating custom reports. • Maintained, updated, cleaned up and generated customers’ mailing addresses using MS Access.• Interviewed end users, collected end user reports, resolved discrepancies, investigated, analyzed, interpreted, and quantified root causes of data integrity failures. Produced up-to-date reports using MS Access, Crystal Reports.

Certificate, Database And Data Analytics, 3.5

The principles and practices involved in handling business data and analysis, including designs, administers, tunes, and uses shared.

Bachelor'S Degree, Database Management System

Associate Of Arts (Aa), Business Administration And Management, General