Data Analyst / Database Analyst Resume San Jose, CA - Hire IT People

SUMMARY

Strong knowledge of database technology both relational (Oracle, Mysql) and non - relational (Hadoop).
Design and implement Database using Mysql and Oracle.
Proficient in writing complicated SQL queries.
Programming using VBA, Java, Python
Advanced Excel user.
Analytical thinker that consistently resolves ongoing issues
Progressing from problem statement to well-documented designs.
Meeting new technical challenges and finding solutions to meet the needs.
Utilizing computers to improve office efficiency.
Fluent in both English and Chinese.

TECHNICAL SKILLS

Platforms: UNIX, Linux, Windows98/NT/2000/XP/7/8/.

Programming Languages: JAVA, SQL, PYTHON, VBA, HTML

Applications: Microsoft Word, Excel, Access; TOAD, DB Visualizer

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Data Analyst / Database Analyst

Responsibilities:

Design and implement Mysql database to facilitate the business operations such as usage analysis, billing, demand planning, and inventory control.
Develop applications / scripts in VBA, Python, Java to extract data from various sources such as CSV file, excel sheets, text file, other databases, and various webpages.
Generate loading scripts using VBA and Python to upload the data into database,
Develop various applications and scripts to automate business processes such as bills generation and mass emails sending.
Backend database support for Tableau dashboard
Ad-hoc report generation and automation.

Confidential, Sunnyvale, CA

Measurement Science QA Analyst / Data Analyst

Responsibilities:

Create SQL script to generate weekly panelist usage report for internet domains in various countries.
Conduct data accuracy analysis to ensure data integrity while migrate data across multiple databases.
Design and develop QA process to validate weekly internet domain traffic reports, Identify the root cause of discrepancy.
Develop excel macro to automate the QA process.

Confidential

Production Support Data Analyst

Responsibilities:

Analyze customer’s portfolio data and orders data using Sql and Excel for detecting data anomalies and inconsistencies.
Identify and resolve data conflict, streaming errors, latency issues between two datacenters.
Generate system health check reports, site traffic and order status reports. Provide key performance indicator reports to higher management.
Resolve system failure issues and client-raised incidents; investigate online order failure and payment issues.
Conduct system automation test using QTP and coordinate with software development teams for resolving code issues.
Communicate with India offshore team for shift handover.

Confidential, Milpitas, CA

Production QA Analyst / Database Analyst

Responsibilities:

Developed SQL scripts to conduct logical checks on weekly/monthly internet audience measurement data, maintain and ensure data integrity and quality.
Collecting data from Oracle and Netezza database using Business Object, Dbvisualizer, SQLNavigator to develop analysis reports.
Performed historical trending analysis of key performance indicators (KPI) using SQL, Excel, and VBA scripting.
Utilized clickstream analysis to identify anomalies and communicated data variances and associated analysis/solutions to product management, engineering and upper executive management.
Performed data quality analysis of multiple Nielsen Online products including NetView and MegaView Syndicate Search and Retail reports.
Participated in QA Tool functional testing and user acceptance testing for software enhancements.

Confidential

Data Analyst / Database Analyst

Responsibilities:

Collected raw data from company databases and developed analysis repors using TOAD and EXCEL.
Developed SQL scripts to monitor the validity of data in the data warehouse, fixed, and updated systems accordingly.
Maintained and added features to a customized data reporting system written in VBA
Performed online marketing using Google Adwords and web analytics using Omniture SiteCatalyst
Worked closely with business users and product managers to determine how data collected could help solve their problems.
Collaborated with the data infrastructure team to translate business requirements into technical specifications

Confidential

Consultant / Data Analyst / QA

Responsibilities:

Designed and implemented Excel macro using visual Basic to automate some time consuming tasks such as duplicate data detection and data lookup in multiple files.
Modified and ran SQL scripts in Benthic tool to pull desired data from Oracle Database and generate a report.
Provided client with customer data by relating customer data from multiple internal and external source systems into a central, consolidated company-wide customer database.
Conducted root cause analysis to solve data conflict between Customer Registry (CR) Database and Partner Database (PDB).
Cleaned up Cisco Top500, VIP, and Golden/Silver Partners records by merging duplicate business entities as well as fixing wrong mappings in CR and in PDB.
Researched D&B (Dun & Bradstreet) database and reported company hierarchy issues.