Post Job Free

Resume

Sign in

Data Analyst

Location:
United States
Posted:
January 27, 2016

Contact this candidate

Resume:

Oanh Lu

Fremont, CA *****

408-***-**** – acs9rl@r.postjobfree.com

CAREER SUMMARY

. Solid Data Analysis experience, handling high volume of data, including summarization and preventive analysis.

. As Test Technician in manufacturing operating mainly PCs, servers and networking devices, and main

components like main boards, CPU, storages, memories and different peripherals and medical devices.

. Extensively created web applications using VB, Coldfusion 8, ASP, VBA, Access, SQL 2008.

. Performing tracking Systems to keep track of employee’s time as daily activity reporting tools.

. Monitored and transferred data between different sources: Excel, DB2, Oracle, MS/SQL.

EDUCATION

BS in Computer Sciences - University Paris 6, Paris, France.

AS in Mathematics - University Paris 7, Paris, France.

TECHNICAL SKILLS

. 10+ years of experience in writing Windows and web based applications with RDB backend.

. Visual Basic, Javascript, ASP, ColdFusion, DHTML, Access, SQL 2008, Oracle, IIS environment.

. Experience in building, testing and troubleshooting electronic devices: PC, network components and devices.

PROFESIONAL EXPERIENCE

Alliance Analytical, Inc (Permanent, part time) - Fremont, CA 08/2013 – Present

IT Specialist, DB Analyst – in parallel with Jabil Circuits, Inc.

Understanding business and support needs, providing data for overall cases of analysis needs from SQL server.

Performed data analysis upon business requirements, at the R&D and marketing level.

Responsible of data and database integrity, mainly in database maintenance and backup.

Helping IT staff in overall help desk tasks: setup new user’s hardware and access.

Install/configure/maintain the networking devices, computers and peripherals.

Environment: Windows Server 2008, Win XP, 7 and 8, VB, Coldfusion, VBscript, HTML, Excel.

Jabil circuits, Inc (Permanent, full time) - San Jose, CA 07/2013 – Present

Hardware Tester

Testing new built electronic devices: computers/servers/medical devices and ensure its reliability before shipping.

Helping hardware staff to solve overall issues with boards, CPUs, storage devices, memories and others.

Working in strict collaboration with engineering staff in diagnostic and fixing overall issues.

Keeping tract, recording all activities concerning the overall manufacturing process on daily basis.

Environment: Linux and Windows servers

Hewlett-Packard (contract) - Cupertino, CA 05/2010 – 02/2013

Quality Program Data Analyst

Working with very large data sets. Understand Business and Support needs for the overall cases of server outage in Linux, Unix and Windows environments

Performed data analysis to satisfy business requirements of various end-users, at the R&D level.

Analyzed outage data discrepancies identified by supporting staff.

Outage database: Oracle on HP servers/Unix, Linux, Windows in various languages: Spanish, French, Chinese, Italian, Japanese, Russian, etc.

Collaborated with the technology teams to proposed data gathering strategy to fix problems.

Environment: HP servers/Unix, Linux, Windows, Oracle

Bell Micro Products (contract) - San Jose, CA 01/2009 – 05/2010

Production Test Operator:

Assembled servers according to Manufacturing Process Instructions (MPI) provided.

Assisted test technicians in repairing defected components resulting in higher quality services.

Helped production staff to assemble electronic units: servers, laptops, monitors.

Environment: servers, laptops, monitors, storage devices.

Catapult Target Profiling - Campbell, CA (Permanent Full time) 2007 – 2008

Data Analyst / Programmer

Developed tools with Pervasive VBScript to clean up, parse data, and database consolidation.

Database designs, data extraction from legacy devices.

Created web applications using Coldfusion 8, ASP, VBA-Excel, Access, SQL 2000/2005:

Performance Tracking Systems to keep track of employee’s time as daily activity reporting tools.

Modules display and update: Allow certain authorized users to edit confidential documents.

These consisted of:

Designed / optimized databases. Login using Windows Authentication.

Transferred data between different sources: Excel, DB2, SQL.

Environment: Excel, DB2, SQL, Coldfusion 8, ASP, VBA, Access, SQL 2000/2005

eCycle, Inc. - Santa Clara, CA (part-time job in parallel with Catapult) 2004 – 2008

Test Technician

Tested web devices (hub, router, server, etc.) and repaired. Loading / upgrading of firmware.

Tests run under Linux. Monitored test results with Linux and uploaded reports to central servers.

Created daily test yield reports with Access, Excel, VBA. Server troubleshooting.

Environment: Access, Excel-VBA, Linux

Taviz Technology, Inc. - Palo Alto, CA (Permanent Full time) 2001 - 2004

Sr. QA Engineer,

Tested eAdapter. In house product used to transfer data from/to different sources (SQL, Access, Oracle 8i, XML, Excel-VBA) and platforms (Win NT/2000, Oracle, Unix).

Wrote/updated shell scripts to report failures to Unix servers. Extracted data to Excel & reports.

Implemented, maintained GUI test cases in VB6. Setup client side environment (SQL7, Oracle), ODBC.

Environment: SQL, Access, Oracle 8i, Cobol, XML, Excel-VBA

Breakaway Solutions, Inc. - Redwood City, CA (Permanent Full time) 2000 – 2001

Sr. Software Engineer

Maintained web applications written in VB.NET, ASP.NET, VBScript, and DHTML, Excel-VBA-XML.

Maintained some financial modules using COBOL, VB: credit letters, exchange rates.

Created COM objects and DLL in Visual Basic.

Enhanced RS-232 applications to monitor external devices from PCs using VB, SQL, RS-232 protocol.

Ennvironment: VB.NET, ASP.NET, VBScript, Cobol, DHTML, XML



Contact this candidate