Ying Liu

Experience

• 

  Industrial and Commercial Bank of China

  Jan 2009 - Apr 2009

  Intern

  1. Conducted administrative functions such as the filling of company information and preparation of contracts2. Input monthly company financial reports into computer accounting system

• 

  Shanghai BUNUO Metal Materials Limited Company

  Apr 2009 - Aug 2009

  Sale Representative

  1. Interacted with customers and promoted steel products in an effort to increase sales 2. Completed monthly sale reports and presented findings to Manager3. Prepared contract for a company client, facilitating a $20,000 sale

• 

  University Press of Florida

  Mar 2010 - Jun 2010

  Intern

  1. Researched potential customer information and reviewed consumer feedback to improve areas of the website2. Created the “Frequently Asked Questions” page based upon research findings

• 

  Harn Museum

  Jun 2010 - Dec 2010

  Finance Intern

  1. Assisted in managing daily museum financial operations, including monitoring daily guest revenues2. Created a six-month merchandising plan which included a budget of $88,0003. Developed and analyzed monthly sales and expense reports to perform analysis of gift shop sales performance4. Tabulated daily sales information and updated inventory and customer information system

• 

  International Carbon Bank and Exchange

  Jun 2010 - Aug 2010

  Marketing Intern

  1. Analyzed effect of environmental factors controlling carbon emission2. Performed market research for a total of 246 colleges and organizations in China to generate potential customers and to promote courses

• 

  Benton Engineering Council

  Nov 2010 - Mar 2011

  Student Intern/Technical Director

  1. Analyzed and redesigned Councils website based upon the requirements of several event directors 2. Built and maintained areas of the website including the online registration system and council database 3. Implemented barcode scanner system to collect event attendee information for future event research4. Participated in creating multimedia promotional materials and videos to promote the Council and events

• 

  Best on Travel Network. Inc,

  Apr 2011 - Jul 2011

  Business Analyst (IT) and Developer Intern

  1. Created User Model2. Identified user needs and set up computer databases3. Analyzed current system and website and made the website design4. Set up the step-by- step project plan

• 

  City of Gainesville

  Jul 2011 - Nov 2011

  Intern

  1. Assisted and maintained manager routine schedule and prepared different kinds of reports2. Read and analyzed various financial information and assist to make the work plan3. Built up a new internal financial report searching system which is used by more than 100 people and collect data from AMS Advantage system

• 

  VectorLearning

  Nov 2011 - May 2014

  Software Engineer

  1. Produced business, functional and non-functional requirements documentation for projects that involved the integration of complex enterprise systems. Elicited feedback and reported to project manager on development and testing activities2. Developed software throughout lifecycle, from identifying requirements to QA and debugging. Proven background completing projects on time3. Worked in environments with coworker from India 4. Wrote SQLs and stored procedure for all projects and using Linq in new MVC Shop Cart project5. Presented the new developed software process through PPT to around 200 people bi-weekly6. Worked with project manager for Authorize.Net PCI Compliancy Implementation Project. Identified the requirement of enhancing current credit card process to securely hold payment information of customer and eliminating the need for internal PCI compliance. Wrote functional design and implementation document drew flow chart for credit card payment process for these programs 7. Developed on SAML single sign on project, design the solution to satisfy Chick-fil-a need and documented the business requirement and technical analysis. 8. Communicated with clients and internal employees to help them solve the problems and answer questions of VectorLearning website and rules. And reported to project manager of the requirements and suggestions from clients and other departments employees Show less

• 

  Cummins Inc.

  Jun 2014 - May 2016

  IT Business Analyst

  • Responsible for developing functional requirements, design documentation, knowledge transferring/requirement explanation with development team and quality assurance test plans• Test and monitor Oracle ERP Systems during implementation • Provide effective communication with customer to identify needs and evaluate alternative business solutions • Work with IT leader to create Web-based IT activities log and report system by using SSBI and SharePoint• Work with the Project Manager/Technical Functional Project Leads throughout project life-cycles• Support the identification and assessment of project priorities for material department• Work with international trade manager, shipping manager, financial manager, Oracle support team to identify current and future process flow, gather requirements and analyze current system for implementing SWEK( Shipping With Engine Kits) method in ERP• Support material manager by providing estimated cost and system analysis for setting up Phoenix warehouse project• Perform duty as a secondary reviewer for SOx(Sarbanes-Oxley)• Led the project of creating work order management system used by the product support engineer team• Applied IT project management functionality by facilitating the writing/defining of project charters, identifying the requirement, doing FMEA risk analysis, identifying current/future process flow, gathering detailed user requirements, creating test case and host UAT process for RMEP plants upgrading I2 sequencer project• Led the implementation of 4 new business functions to ERP system• Supported Value Package Introduction team by providing part production quality approval analysis and used 6 sigma method to implement automatic updating process to keep part quality plan approval information update-to-date, which increase accuracy of the quality plan from 40% to 80%• Gathered the requirements with product support engineer team for new tear down lotus note database and provide project planning and timeline Show less

• 

  Columbia University in the City of New York

  May 2016 - now

  • Associate Director of Application Development and Reporting

    Mar 2020 - now

  • Application Integration Manager

    Apr 2018 - Mar 2020

  • Technology Coordinator

    May 2016 - Apr 2018