Data Analyst Resume Sunnyvale, CA - Hire IT People

SUMMARY:

Dedicated Data Analyst with more than 5 years of experience in the fast - paced software industry.
Excellent in using SQL to ETL data, solid understanding of data warehouse technology, certified MySQL developer, and d SAS programmer.
Track record of achieving exceptional results in managing and analyzing large-scale data and transforming data into meaningful information.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Data Analyst

Confidential, Sunnyvale, CA

Responsibilities:

Work on the user/instructor dashboard design and implementation by conducting data analysis, developing data/database structure, and providing support.
Write SQL scripts to extract and manipulate user/instructor data from MySQL databases to perform quantity analysis and generate reports.
Implement the user/instructor dataflow using Ruby on Rails, HTML, and CSS.

Professional Development

Confidential

Responsibilities:

Completed the Data Analysis Using SAS at ShinShin Center.
Took Unix/Linux, HTML, CSS, PHP/MySQL, Ruby on Rails classes at Foothill College. Completed the Software as a Service class offered by UC Berkeley.
Teaching assistant at RailsBridge teaching women Ruby on Rails.

Data Engineer

Confidential, Menlo Park, CA

Responsibilities:

Engaged in product development by providing developers with well organized business data and answering questions regarding the data.
Loaded the partners rebate information from various sources into the internal databases and maintained the internal databases.
Performed data analysis using MySQL, promptly identified data inconsistency issues, and wrote SQL scripts to fix the data issues.

Data Engineer

Confidential, Redwood City, CA

Responsibilities:

Successfully managed Confidential ’s large-scale data warehouse applications for financial institutions and insurance companies in a SaaS environment.
Gathered business requirements by interviewing clients, reviewing business documents and regulations. Worked with developers to customize the applications to meet customers’ specific business requirements.
Performed daily or weekly data loading, loaded customer data into Confidential data warehouses. Conducted data validation after each data loading. Also resolved data quality issues in the data warehouses.
Provided product support and helped Confidential maintain successful relationships with customers by fixing issues quickly and communicating with customers effectively.

Application Developer

Confidential, Santa Clara, CA

Responsibilities:

Was promoted to Application Developer from Software QA Engineer within the company. Worked on the development of Kana’s commercially successful data warehouse application, CRM Analytics.
As one of the key contributors, developed the data warehouse common adapter by writing complex and efficient SQL queries to ETL data warehouse staging tables into the star schemas. Helped deliver quality products in a tight schedule.
Generated CRM analytical reports using SQL and Kana Workbench.

Software QA Engineer

Confidential, Santa Clara, CA

Responsibilities:

Participated in black and white box testing of Kana data warehouse applications.
Wrote test scripts to verify the analytical reports accuracy.
Clearly tracked issues and worked closely developers to fix the issues.
Performed functional and regression test of Kana database server.
Designed, implemented, and executed test plans, test cases, and test matrices.