Data Analyst

XIAOFENG YIN

***.********@******.*********:***********@*****.** +1-437-***-****

Data Analyst

Over 10 years experience in database/application development, systems analysis; Involved in Systems Development Life Cycle (SDLC), data modeling, data mining, testing, debugging and documenting programs. Over 6 years experience in data analysis and mining. Highly effective interpersonal skills, personnel management, a hard worker, team player, who works well under pressure. Flexible, Customer Oriented, with strong ability to learn the latest or new technology.

TECHNICAL SKILLS

Languages: SQL,Stored Procedures, XML, HTML,CSS, UML, Java, Python, LightSwitch, others

Databases: SQL Server 2000-2008R2, Oracle, MySQL, SQLite

Tools: IIS,Visio, PowerPoint, Excel,Outlook,VMWare, SVN,CVS, Linux

Skills: ETL (data Extraction, Translation, and Loading), Conceptual/Logical/Physical database modeling in ORM/ER/UML, Data Warehouse, Data Mart,OLAP, Data Mining, Systems Analysis, Troubleshooting, Creative Problem-Solving, Full Life-Cycle System Development(SDLC), Scrum, Agile development, GIT version control system (GitHub)

EMPLOYMENT HISTORY

Data Analyst Canada Home Group, Inc, Canada 2015.09 –

Extracted all kinds of Data set for customized report from database

Created SSIS packages/jobs for daily/monthly extract

Provided support to Data Warehouse

Export data from database to XML file, validate XML against XSD

Design, Develop and Test database objects to run ETL processes that support business

Provides technical assistance to implementation teams on subjects regarding the RDBMS and related environments.

Systems: MLS

Tools: SSIS;SSRS,SQL Server

Database Analyst Pointclickcare, Inc, Canada 2012.12 – 2015.08

Imported Relational Data(resident,census,diagnosis…) /Created Facility /Changed codes

Pharmacy Order Integration /MDS 3 Imports/MDS 2 Imports Omnicare/PCC Integrations

Resident merge /Resident deletion / External facility merge

Provided Help Desk support. Being familiar with PCC Front End

Database Knowledge for solving Help Desk cases

Ran query for all org code to support development

Aptitude for analysis and interpretation of data

implementation to PointClickCare software solutions and other business requirements using SQL Server 2005/2008 SSIS packages or SQL Server 2000 DTS for web-based applications.

Ensure all Data Services SSIS packages, stored procedures, scripts and functions are updated as business logics are upgraded to meet PCC standards.

Work in partnership with clients and the project manager to establish business requirements and solutions.

Work with application developers and other database administration staff to research, define, and correct application performance issues

Work with QA to put together regression tests for all Data Services SSIS Packages, scripts, stored Procedures etc.

Systems: PointClickCare

Tools: Netsuite; SSIS;SSRS,SQL Server

Database Developer Roadpost, Inc, Canada 2012.7 – 2012.11

Developed applications to migrate the account from CostGuard to EngageIP.

Developed SQL scripts to validate the data migration.

Developed ETL applications for financial department.

Data Cleaning and Data analysis for User,Services,Package,Inventary Data migration

Systems: EnageIP Billing System,Geopro,SSIS as ETL tools,Metadata Mapping

Tools: ASP.NET, LightSwitch, XML,HTML,SQL Server 2008;JiRA,SVN

Software Developer co op SS&C Technologies, Inc, Canada 2012.5 – 2012.6

Developed multi-lingual support feature for ePages of Mutual Funds

Tested software applications to fulfill requirements and specifications

Edited Help file for WRpages and ePages of Mutual Funds

Systems: Asset management Pages,ePages,WRPages,XPages,PowerPages;

Tools: VB.NET,JavaScript,XML,HTML, SQL Server,IIS

Software(BI) Developer Chang Feng Company, China 2007.1 – 2012.01

Conducted requirements Real-name RFID ticket check system analysis,UI design, data modeling, database design, stored procedure design, and .NET architecture design.

Designed and developed ticket selling reporting system.

Developed visualization tools and predictive analytics for ticket check system

Developed algorithms for Network Security Risk Assessment System

Systems: Real-name RFID ticket check system for Beijing conference of China Football Association Super League; Network Security Risk Assessment System.

Tools: SQL Server, C#,ASP.NET,IIS,Matlab,Sybase power designer,Java

BI/ETL Developer Chang Feng Company, China 2005.7– 2006.12

Received requests from the IT manager, and then met the end users to understand the nature of the transactions. I then did the required analyses to make the necessary modifications on the interfaces, or created new ones.

Received transactions with problem and checked the data throughout the database for any errors, until the transactions were successful.

Maintenance of the applications and data then debug errors.

Prepared user manuals for the systems for which I was responsible.

Cleaned data and built learning algorithms to analyze data for Security Intelligence System

Systems: Beijing 2008 Olympic Volunteers Recruitment and Management System; 2008 Olympic Security Intelligence System; RFID ticket Real-name check system for Beijing Olympic

Tools: SQL Server, .NET,ATOS system, i2,MicroStrategy,Python

Database Developer China Academy of Railway Sciences, Beijing, China 2002.9 – 2005.7

Translate the book "Debugging by Thinking" to Chinese. ISBN 7-120-00089-6

Designed logical and physical data models

Wrote queries, triggers and stored procedures

Gathered, examined large sets of data from different systems

Built data warehouse and analyzed data for Train running Safety system improvement

Developed algorithms for forecasting Train running Safety system performance

Maintained applications and data, and debugged for errors

Systems: Train running Safety Monitoring and Data Mining System; High-speed Railway’s Integrated Dispatching System

Tools: Oracle & PL/SQL, ASP, IIS 5,SourceSafe, PowerBuilder,Matlab,Linux

EDUCATION

Doctor of Transportation Management — China Academy of Railway Sciences Institute

Of Computing Technology 2005

Master of Information Management — Shanxi University of Finance & Economics 2002

Bachelor of Computer Engineering — North China University of Technology 1999

MCSE Microsoft Certified Systems Engineer) — APTECH Training Center 2006

CPMP China Project Management Professional — CCID Training Group 2008

Publications

1 "The Design of Monitoring and Control System of Train Operation Safety Subsystem of High-speed Railway's Integrated Dispatching System Based on J2EE",YIN Xiao-feng,LIU Chun-huang, Journal of Communication and Transporation Systems Engineering and information,2004.4:95-99

2 "Technology of Grid Computing and Information Sharing",Sun Jian, Yin Xiao-feng,Chen Guang-wei,Railway Computer Application 2004 04 5-8

3 "Finding association rules from Train running Safety monitoring system",YIN Xiao-feng,LIU Chun-huang,Railway Computer Application 2004 01 5-7

4 "JavaPos System and it's Development",YIN Xiao-feng,Computer Application and Development,200*-**-**-**

5 "A study on Ant Colony System for Vehicle Routing Problem". YIN Xiao-feng, LIU Chun-huang. 2005 International Symposium on Intelligence Computation Wu Han Progress in Intelligent Computation and Its Applications 581-586

6 "Application Research on Data Ming Using Ant Colony Algorithm",Zhang Weijiao, Liu Chunhuang, Yin Xiaofeng,Computer Engineering and Application,2004 28:171-173

7 "Hybrid Approach Based on Ant Colony System for Solving Traveling salesman Problem",YIN Xiao-feng,LIU Chun-huang,Journal of Tai Yuan Heavy Machinery Institute,2005

8 "The design and implementation of Intelligence Integration services in OGSA-DAI", YIN Xiao-feng

9 "The UAV Targets Allocation Based on Swarm Intelligence", Chinese Society of Astronautics 2007 conference.

10 "Solving Railway Empty Cars Adjustment Problem by Ant Colony System Algorithm", Du Yanping,Liu Chunhuang, Yin Xiaofeng,CHINA RAILWAY SCIENCE 2006,07:119-122

11 "Ant Colony System for Vehicle Routing Problem by using Matlab",Yin Xiaofeng,Liu Chunhuang, Computer Engineering and Application,2005 12

Contact this candidate