data analyst
Xin Li
Ottawa, ON------------ (H) - ------------
Summary
Data analyst seeking a challenging position in business analytics to help realize short and long term business goals. Proven ability to gather and analyze requirements and translate needs to project teams. Dedicated to continuing professional growth with certifications in SAS base programming and SAS advanced programming.
Skills
• Operating system (Linux and Windows)
• Software testing tools and testing techniques (black box and white box)
• BI Administration skills and Cognos BI software
• Oracle ODI studio
• Relational databases MS SQL server, MySQL,Oracle,IBM DB2
• Statistical analysis and data mining using SAS/BASE, SAS/EM,SAS/EG and SPSS
• Data visualization using Tableau, IBM Watson Analytics and Bluemix
• Web programing languages using HTML/CSS, JavaScript and PHP
• Excellent communication and organizational skills to work with teams and handle multiple tasks
Experience
Neusoft Institute of Information, Northeastern University
Software Tester
Dalian Shi, Liaoning Sheng
• Plan and design test cases using black box testing technique as a team.
• Report the results to the system development team to fix the bugs and optimize the system.
• Record the bug using bugfree and produce bug test cases result form Online bookstore testing project.
• Go through the test cases and perform automation function using QTP software.
• Explored new technologies and tools that the quality assurance team could use for testing purposes.
• Worked closely with clients for the duration of projects.
Algonquin College
Web Designer & Developer
Ottawa, ON
• Reviewed information regularly on websites and pages to ensure that it was accurate.
• Maintained a strong education in the latest technologies, software and hardware products for use in various projects.
• Identified website issues through effective troubleshooting, testing and remedying before deployment.
• Developed web pages using content management systems, including WordPress.
• Created project timelines.
• Created user friendly websites, ensuring users could easily navigate menus and content.
Cheo Hospital
BI Analyst
Ottawa, ON
• Examination of Disease Workflows to find ideal test case scenarios.
• Exploration of the positive data value list examining analysis.
• Create and refine queries for GALT and MSPKU thresholds 1.
• Communicated with customers, employees and other individuals to answer questions and explain information.
Algonquin College
SAS clinical trial programmer
Ottawa, ON
• Using Statistical Procedure (anova, ttest, lifetest, univariate etc.) to produce and analyze clinical data
• Performing edit check on datasets from other database systems (oracle, MS SQL Server)
• Producing various statistical report and figures using proc report, proc tabulate
• Import and Transform data into SAS from various existing database systems
• Review of statistical output and clinical trial reports
Algonquin College
BI administrator
Ottawa, ON
• Configure BI component and physical systems
• Design Diagram logical topology of the BI system
• Attend Weekly team meeting and discuss high level installation and configuration plan
• Basic security configuration
Education and Training
Algonquin College
Ontario College Graduate Certificate: Business Intelligence System Infrastructure
Ottawa, ON
Algonquin College
Ontario College Graduate Certificate: Interactive Media Management
Ottawa, ON
Dalian Neusoft Institute of Information
Bachelor of Computer Science: Software Engineering
Dalian, Liaoning
Certifications
• IBM DB2 9 Database and Application Fundamentals
• SAS Base Programmer for SAS 9
• SAS Advanced Programmer for SAS 9
Xin Li
Ottawa, ON------------ (H) - ------------
Summary
Data analyst seeking a challenging position in business analytics to help realize short and long term business goals. Proven ability to gather and analyze requirements and translate needs to project teams. Dedicated to continuing professional growth with certifications in SAS base programming and SAS advanced programming.
Skills
• Operating system (Linux and Windows)
• Software testing tools and testing techniques (black box and white box)
• BI Administration skills and Cognos BI software
• Oracle ODI studio
• Relational databases MS SQL server, MySQL,Oracle,IBM DB2
• Statistical analysis and data mining using SAS/BASE, SAS/EM,SAS/EG and SPSS
• Data visualization using Tableau, IBM Watson Analytics and Bluemix
• Web programing languages using HTML/CSS, JavaScript and PHP
• Excellent communication and organizational skills to work with teams and handle multiple tasks
Experience
Neusoft Institute of Information, Northeastern University
Software Tester
Dalian Shi, Liaoning Sheng
• Plan and design test cases using black box testing technique as a team.
• Report the results to the system development team to fix the bugs and optimize the system.
• Record the bug using bugfree and produce bug test cases result form Online bookstore testing project.
• Go through the test cases and perform automation function using QTP software.
• Explored new technologies and tools that the quality assurance team could use for testing purposes.
• Worked closely with clients for the duration of projects.
Algonquin College
Web Designer & Developer
Ottawa, ON
• Reviewed information regularly on websites and pages to ensure that it was accurate.
• Maintained a strong education in the latest technologies, software and hardware products for use in various projects.
• Identified website issues through effective troubleshooting, testing and remedying before deployment.
• Developed web pages using content management systems, including WordPress.
• Created project timelines.
• Created user friendly websites, ensuring users could easily navigate menus and content.
Cheo Hospital
BI Analyst
Ottawa, ON
• Examination of Disease Workflows to find ideal test case scenarios.
• Exploration of the positive data value list examining analysis.
• Create and refine queries for GALT and MSPKU thresholds 1.
• Communicated with customers, employees and other individuals to answer questions and explain information.
Algonquin College
SAS clinical trial programmer
Ottawa, ON
• Using Statistical Procedure (anova, ttest, lifetest, univariate etc.) to produce and analyze clinical data
• Performing edit check on datasets from other database systems (oracle, MS SQL Server)
• Producing various statistical report and figures using proc report, proc tabulate
• Import and Transform data into SAS from various existing database systems
• Review of statistical output and clinical trial reports
Algonquin College
BI administrator
Ottawa, ON
• Configure BI component and physical systems
• Design Diagram logical topology of the BI system
• Attend Weekly team meeting and discuss high level installation and configuration plan
• Basic security configuration
Education and Training
Algonquin College
Ontario College Graduate Certificate: Business Intelligence System Infrastructure
Ottawa, ON
Algonquin College
Ontario College Graduate Certificate: Interactive Media Management
Ottawa, ON
Dalian Neusoft Institute of Information
Bachelor of Computer Science: Software Engineering
Dalian, Liaoning
Certifications
• IBM DB2 9 Database and Application Fundamentals
• SAS Base Programmer for SAS 9
• SAS Advanced Programmer for SAS 9