Data Analyst Sales

LIN LU

Denver, CO cell: 551-***-**** Email: *************@*****.***

Data Analyst with 3 years of experience in interpreting and analyzing data for driving business solutions. Excellent understanding of business operations and analytics tools for effective analyses of data. Core competencies lies in MySQL, Python (Pandas, Numpy, Seaborn, Matplotlib, Scikit-learn), MS EXCEL (H/VLOOKUP, pivot tables, macros etc.), R programming, Tableau, Power BI and Machine learning.

PROFESSIONAL EXPERIENCE

MerlinSight LLC Edison, NJ

Data Analyst 04/2017-09/2017

Merlin Sight is a boutique consulting company, center on delivering high-end expertise to mission critical IT and business initiatives.

• Used advanced Excel functions to generate spreadsheets and pivot tables.

• Apply aggregate function in the MySQL statement, such as MAX, MIN, RAND, SUM and etc.

• Knowledge of SDLC with the ability to lead efforts to create new or modify existing data extracts, reports, and applications within the Microsoft BI toolset using SSIS, SSAS, SSRS, etc.

• Apply other function to change the data format, data type and concatenate data. Use Python (Numpy, Pandas, Seaborn, Matplotlib) analyze client’s business requirements and processes through document analysis, workshops, and workflow analysis.

• Integrated Tableau with MS SharePoint built up SharePoint dashboard.

• Managed SharePoint Designer workflow creation and custom workflows using Visual Studio.

J & H International Pine Brook, NJ

Business/Data Analyst 11/2016-02/2017

J & H International is committed to maximizing the success of the home products industry. My position will be key in supporting day to day reporting needs for the sales department.

• Collect data on consumers, competitors and market place and consolidate information into actionable items, reports and presentations.

• Involved in using Excel and Python to analyze large datasets in which to translate into reports for insight and recommendations for the Sales Team.

• Assist the marketing team in build out of Google Analytics with integrations around publishers, spend, and data warehouse data.

• Run SQL queries and output result set to Excel for various analyses.

• Utilized standard Python modules such as csv for development.

• Manage technical aspects of key marketing systems (marketing automation, CRM) used to generate, distribute, and report on leads and customers.

• Performed Data Cleaning, features scaling using pandas and numpy packages in python.

• Try to normalize the data in SQL to remove redundant data and ensure data dependent.

• Create and maintain key metric reports on marketing and sales activities to assess effectiveness and business impact.

• Support customer hierarchy data management team with review, validation, and build activities to support global Sales organization.

• Use Tableau to make visual report to make the engineering and marketing team more easy to understand.

BZM Innovation Technology Inc. New York, NY

Business/Data Analyst 08/2015-05/2016

BZM Innovation Technology is a capital backed investment company focus on Fin-tech projects. My position is using R Studio, Excel and SPSS to collect and analyze economic data sets from the U.S. and China to pinpoint critical market trends and apply that information towards progressive investment plans.

• Develop business architecture using requirement such as scope, process, alternatives, and risks.

• Optimized data collection procedures and generated reports on a weekly, monthly, and quarterly basis

• Used advanced Microsoft Excel to create pivot table, used VLOOKUP, and other Excel functions

• Interfaces with users to determine needs, uses and specifications of data requests and conducts detailed analysis of data requirements.

• Create detailed Data Mappings through all stages of data life cycle.

• Partner with other IT teams in defining and designing target state architecture by combining knowledge of what the business wants with knowledge of how the systems are built.

• Communicate client’s business requirements by constructing easy-to-understand data and process models.

• Developed Summary reports, Sub-reports, Graphs using Power BI. EDUCATION

Stevens Institute of Technology, Hoboken, NJ 08/2014-06/2016 Master of Science in Information Systems GPA:3.75

City Institute, Dalian University of Technology, China 08/2009-05/2013 Bachelor of Management in Information Systems & Management GPA: 3.3

Contact this candidate