Reliable and driven young IT professional with a record of exceeding expectations on completing projects and analyzing data integration processes.
Strong skills in data analysis, Business Intelligence, data warehousing, ETL and data modeling.
Experience in Qualitative Data Analysis, Atlas.ti.
2 years of previous solid BA experience in: CRM, e-commerce site, mobile application, CMS etc.
Sr. Data Analyst @ From April 2015 to Present (9 months) Greater New York City AreaSQL Data Analyst @ •Own deliverables for data acquisition and hands on report development and troubleshooting with SQL server, Business Objects, Tableau, Excel in an enterprise data warehouse environment. Discuss, analyze and produce new metrics and KPIs for better business insight.
•Serve as primary information/data help desk for relevant business lines and support end-user data requests, troubleshoot defects and perform detailed system analysis with MS SQL server, Business Objects, Informatica etc.
•Develop SQL scripts and work with DBAs on operating procedures like mass cancellation, rate change, billing and other production code change. Daily analyzing, modifying and developing views, stored procedures, functions, DTS/SSIS packages etc.
•Work with finance team on monthly and yearly budgeting process and revenue reporting. From September 2013 to April 2015 (1 year 8 months) Greater New York City AreaBusiness Analyst Consultant @ • Collect and analyze business requirements, business needs and project objectives via meeting and interview
• Collaborate with designers and business owner to establish an unified vision of user experience
• Produce diagrams and technical documentation, communicate with developers to make sure functionalities and project scope are well understood
• Create user stories and manage/monitor issues, organize daily standup/call to remove blocker issues and have latest project update
• Present requirements to QA, review test cases and have QA team involved throughout the development
• Perform data analysis in SQL to understand business trend and make business/design recommendations
• Troubleshoot and debug reported problems of completed application to support end user From April 2012 to September 2013 (1 year 6 months) Business Analyst Intern @ From August 2011 to March 2012 (8 months) Intern @ Website data modeling From November 2010 to April 2011 (6 months) Syracuse, New York Area
Master, Information Management @ Syracuse University From 2009 to 2011 Bachelor, Literature/Finance @ Beijing Foreign Studies University From 2005 to 2009 Will Liu is skilled in: SQL, Business Intelligence, Databases, Microsoft SQL Server, Systems Analysis, Agile Methodologies, Analysis, Visio, CRM, SDLC, Data Warehousing, Scrum, User Stories, Agile Project Management, UML