Ying Lu
Phone: 315-***-****
New York, NY 10044 Email:
********@*****.***
Education
M.S. Information Management, Syracuse University, GPA: 3.9 (Syracuse, NY) Aug 2013
Relevant Coursework: Data mining, Data warehouse, Enterprise Technology, Information System Analysis &
Design, Database management, Project Management, Human Computer Interaction, Information Policy,
Strategy Mgmt/Info Resource
B.S. Management Information System, Beijing Jiaotong University, GPA: 3.8 (Beijing, China) Jun 2011
Relevant Coursework: Multidimensional Data Analysis, Data Structures, Management Information Systems,
Object-Oriented Programming, Process &Implementation of Enterprises Informatization, Commercial ERP
System, Database applications, E-Commerce, Financial Management, Applied Statistics, Technical
Economics, Accounting, Advanced Mathematics Modeling
Professional Experience
Faculty Assistant -- Wireless Grid Innovation Test Bed, WiGiT Lab (Syracuse, NY) Jan 2012-May 2013
Role: Business Analyst & Architect
• Designed Wireless Grid Technology Framework based on the commercial stakeholders’ business
requirements
• Created Wireless Grid Use Cases – Workplace as a Service to solve the BYOD challenges
• Co-Authored Open Specification v0.2, v0.3 on migration towards a common architecture for enterprise
level cloud based resource sharing in association with TM Forum members like UBS, Cisco, Microsoft,
Bank of America etc.
Summer Intern -- Scrapsule LLC (Syracuse, NY) May 2012-Sep 2012
Role: Financial Analyst and System Analyst
• Created product road map and updated different versions based on the requirements gathered from trial
users
• Analyzed social media industry and competitors data using pivot table/charts and spreadsheet
• Prepared written reports, summarized findings and made recommendations to confounders
• Created business plan which include marketing strategy and 5-year financial projections
• Interacted with both clients and developers to translate business requirements to technical specs
Academic Project Experience
Data Warehouse: Sales Multidimensional Data Analysis Dec 2012
• Created business requirement document, and description of business process including type of data captured
• Built dimensional model, conducted ETL process using SSIS, and generated custom reports through SSAS
Data Mining: Analysis about factors which affect income based on census data Dec 2012
• Employed different algorithms (Classification, Clustering and Association Rules) in Weka to investigate the
problem
• Generated report of the results and implications by the use of descriptive statistics and visualization
techniques in SPSS
Database Management: Inventory Management Information System Apr 2012
• Gathered database requirements; proposed data management solution; designed a fully-attributed relational
data model
• Implemented database using SQL Server 2008, and wrote queries to answer user’s data questions
Project Management: The Fairmount Community Library Patron Technology Upgrade Project Mar 2012
• Prepared project charter document including scope statement, deliverables, stakeholders’ roles, risks, and
assumptions
• Completed the schedule document consisting WBS, Gantt Chart, Resource Usage Report, Cash Flow
Report, and etc.
System Analysis and Development: Evaluating and Monitoring Material Quality System Jun 2011
• Analyzed existing management problems of SINOPEC Oilfield Co., and streamlined the work flow using
Visio
• Conducted system design using UML with object-oriented methodology, and implemented it in VS 2008
and SQL Server
• Passed the testing phase by SINOPEC Shengli Oilfield Company, after which they implemented this system
for use
2010 Mathematical Contest Modeling, Second Prize, US: The power of geographical profile Feb 2010
• Set up the grey predictive model to deal with small quantity data and uncertain information in serial crimes
• Modified original Bayesian model with consideration of time and location factors; conducted the simulation
Leadership Experience
Project Manager, TEDx Harlem (New York, NY) Mar 2012
• Coordinated students team, and kept track of the preparation work assigned to each individual
• Presented the Wireless Grid Open Specification 0.1 Version to press, social medias and potential
stakeholders
Technical Skills
• Programming languages: SQL, PL/SQL, VB, VB.NET, C, C#, HTML, VBA
• Database: MS Access 2010, SQL Server 2008, Oracle 9i, 11g
• Application: MS Office 2010, Visio, Visual Studio 2008, MS Project 2010, SPSS, Weka, Rapid miner,
Informatics
• Development methodology and tools : Agile, Waterfall, Object-Oriented, UML