Merck is a large pharmaceutical company and it aspires to improve the health and wellness of people and animals worldwide, and to expand access to medicines and vaccines. I work within Business System Team, participating in ETL, Repositories and Front-End Analytics .Requirements collection and analysis (20%)• Design data cleansing strategies, process data manually and with VBA and MS Access.• Identify different data types, create mappings between the source and target databases.Data Migration (30%)• Build databases for more than 70 pharmacy profiles, test and maintain them.• Set up file type conversions in databases, including lookups, aggregations, separations, etc., through technologies such as Informatica.• Coordinate the raw data from ODS to DW. Ensure stable, complete and continuous data.Data Analysis (50%)• Establish interactive tables for projects, including filters, parameter settings, and more with Tableau, SPSS, etc.• Design, build, and maintain BI reporting platforms for internal teams and external customers, including daily analysis reports, Ad-hoc, and more.• Assist data scientists and analysts in researching and developing new machine algorithms. Use Python or R programming languages to participate in the process of building models, selecting models, and evaluating models.* Language/Tools: SQL, R, Informatica, Tableau, Redshift, SAS, Oracle, IBM-cognos, MS Access *

Liberty Mutual Insurance Chicago offers a wide range of insurance products and services. I worked in General Liability Marketing Team as a Business System Analyst. Roles and Responsibilities:• Write VBA programs to automate raw data and load it into the database.• Use the established ETL process to perform data validation management.• Apply SSIS to develop data import and export capabilities for data integration across systems.• Use SQL queries to create database objects such as tables, stored procedures, triggers, and so on.• Prepare deliverables, including final reports, slide shows, technical memos, and lecture manuscripts.* Language/Tools: SQL, SSIS, Tableau, SAS, SPSS, MS Access, Google Analytics *

IBM China as my first job after Graduation. I worked in Marketing Team as a Data Researcher Analyst.Roles and Responsibilities:• Understand internal team needs, collect, aggregate, and process data and related information.• Participate in model analysis and analyze related industries, users, and competitors.• Promote business report development, interface with technical teams. Use R and SAS coding to perform simulations and calculations.• Complete data surveys, analyze and predict results, and follow up on the project.* Language/Tools: Java, R, SQL, Matlab, SAS, VBA, Exel *