Data Analyst Resume
0/5 (Submit Your Rating)
Dallas, TX
TECHNICAL SKILLS:
Language/Tools/Operation Systems: Java, JSP, MSSQL, Oracle, XML SAP R/3,SAP BW, Oracle BI,SAS,SSAS,SSRS, SSMS Windows, Linux
PROFESSIONAL EXPERIENCE:
Data Analyst
Confidential, Dallas, TX
Responsibilities:
- Conduct a highly efficient communication with stakeholders and staff from different departments to gather data requirementsprecisely
- Design T - SQL procedures to query the enterprise data mart and validate the data result
- Design, develop report by using Microsoft Visual studio Business Intelligence Development studio
- Participate in a cross functional project team to design the basic cube by SSMS and SSAS
- Design Pivot table reports at Microsoft Excel based on the data in the Team Foundation data warehouse
- Make beneficial suggestions on the query optimization and tuning, let the procedure cost reduce 70%
- Content Management System Specialist
- IT Department, Risk Limited Corporation, Dallas,TX
- Setting up and maintaining company website by using content management software, Joomla
- Research the new feature of Joomla software
- Project Manager Associate
- Office of Diversity & Community Engagement, University of Texas Dallas, Dallas,TX
- Set up a Project Gantt Chart by Microsoft Project 2007 to track the execution of different projects
- CRM associate
- Customer Relationship Department, THUNIP UNION, Beijing, China
- Retrieved Customer profile data by using Teradata SQL assistant
- Built reports by Excel to help the sales manager identify the metrics of customer and improve Marketing ROI
- Account Manager assistant
- Operation Department, China Construction Bank, Beijing, China
- Assist the account manager and application developer to analyze the requirement
- Design query to gather data by
- Using Excel to analyze the online transaction to supply a potential client list to account manager
- Analyze the basic deposit account data and disclose the pattern of the change of deposit
- Assist account manager to conduct the loan analysis based on Logistic Regression Analysis
