Kelly Xu

** ***** ***** **. *******, M*W *H*

416-***-**** (Home) 416-***-**** (Cell)

Email: yfy7mj@r.postjobfree.com

OBJECTIVE:

Seeking a position as SAS Data Analyst in a highly reputed and professional organization

HIGHLIGHTS of QUALIFICATIONS:

• Advanced in SAS programming skills, data analytical skills

• Solid hands-on experience in working with SQL, Oracle, MS Access/Excel

• Proficient in data collecting, cleaning, aggregating and reporting

• Certified SAS BASE and SAS ADVANCED programmer

• 5 years SAS working experience of programming and reporting with Base SAS, SAS/STAT, SAS Language, SAS/ODS and Graphs

• Ability to perform programming, debugging, data analysis and system analysis

• Advanced user of Enterprise Guide SAS

• Efficient, highly organized, team player and working independently

• Excellent communication and interpersonal skills

WORKING EXPERIENCE:

Senior Data Analyst 01/2006 to present

Client Insights & Database Marketing Toronto

ICF Group, an international furniture manufacturing, distributing group of companies with dozens of stores and factories worldwide

• Work on varies type Ad-Hoc requirements, span from product to segmentation

• Analyze sales performance, product mix, marketing promotions, location, pricing, new project, supply chain to maximize financial benefits

• Manipulate and prepare data, extract data from database for business analyst using PC/Unix SAS, SQL, Oracle, Excel and Access.

• Conduct data cleaning, manipulation, modification and combination using variety of SAS steps and functions

• Analyze, test, document and maintain SAS programs and macros to generate SAS datasets, spreadsheets, data listing, tables and reports

• Produce Various reports using Proc Report, Proc Tabulate, Data _Null_

• Produce Graphs: Proc gplot, proc gchart, and data annotate

• Modify existing SAS programs for performance enhancement and peer review

Business Analyst 01/2004 to 01/2006

• Client Insights & Database Marketing Toronto Tyco Int’l, Fire&Sesurity Division, an electronic security and fire protection to worldwide customers through its global ADT

• Reviewed historical sales trends and evaluated forecast results

• Analyzed and prepared reporting on inventory levels, inflows, outflows, inventory turns and data analysis required by internal and external stakeholders

• Tracked and monitored budgets including making recommendations for savings and Identifying the drivers of variance in monthly forecasts

• Helped to determine reasons for service loss to improve stock availability

• Utilized existing or custom designed reports to draw conclusions and develop actionable insights

SQL Server DBA 07/1990 to 12/2000

Bank of Construction Haerbin , China

• Developed resiliency plan against infrastructure failures, alerts to monitor the health of the database

• Maintained database design documentation and metadata

• Implemented database security policy (create and maintain users and roles, assign privileges)

• Conducted backup and recovery in keeping organizations policies and procedures

• Planed growth and changes (capacity planning).

Other Experience

Weekend Supply Teacher Dufferin-Peel Catholic School Board

With criminal reference check satisfactory 2006.4-present

EDUCATION:

Bachelor’s Degree in Business Administration York University, Toronto 2001 2003

Honour Bachelor’s Bachelor’s in Computer Science, majored in MIS

Northeast Business University, China 1986 1990

Training

Microsoft Certified Professional, SQL Server certification 2000

REFFRENCES AVAILABLE UPON REQUEST

Contact this candidate