Business Analytics and Information Technology

XIAN SHI

** ***** ******, *** *********, NJ *****

929-***-**** *******@*****.***

EDUCATION

Rutgers University, Rutgers Business School-New Brunswick, NJ May, 2017

Major: B.S., Business Analytics and Information Technology (BAIT) GPA: 3.358

Awards: Dean’s list (Fall 2014, Spring 2016)

COURSEWORK

Business Data Management Spring, 2016

Worked on large databases such as Facebook user account and IMDb using MySQL and created complex relational databases.

WORK EXPERIENCE

Independence Blue Cross Philadelphia, PA

Operations Planning Intern June-August, 2016

Performed data analysis for the Provider Network Services Department. Wrote a dynamic SQL query that scanned through comment notes of inquiries for specific keywords and aggregated the inquiries into categories. Resulted in the department gaining visibility into key issues from customers enabling immediate actions to be taken.

Granted read and write access to the production database due to outstanding performance.

Modified the customer service database extensively using SQL for reporting purposes.

Collaborated with analysts on developing a new customer service data cube using SSAS and SSIS.

Completed a new hire training document that illustrates how the call center data cube operates.

PROJECTS

SCM Industry Client Project with Mars, Incorporated New Brunswick, NJ Project Leader September, 2016-December, 2016

Acted as the initial point of contact for the professor and the client. Coordinated all activities and interfaces with the team, client, and professor.

Lead a team of four to define project deliverables and ensure consensus.

Partnered with the client in the development of new logistics policies that would enable them to reach small retailers more effectively.

Interviewed small retail stores in New Brunswick area to identify potential customers for Mars.

Supported the team efforts to develop a formal presentation and research paper that presented to the client in December, 2016.

Age Fearless Program Case Competition- Independence Blue Cross Philadelphia, PA

Team Member June-August, 2016

Collaborated with a team of 10 to develop a plan identifying approaches to better engage age 55 or older population in the Philadelphia region.

The plan identified strategies to enable elderly people to maintain an independent life style, reduce the number of missed doctor’s appointments, and increase the brand awareness of Independence Blue Cross.

Won first prize in the competition from among a group of 97 interns.

CERTIFICATION

Rutgers BASE Intermediate Excel Certificate September, 2016

Demonstrated proficiency in text manipulation and summarizing data with vlookups, sum, sum-if(s), count, count-if(s), and representing data through charts, graphs, and pivot tables.

SKILLS

Technical: Advanced in SQL. Proficient in Excel, Access, MS SQL Server, database design, data mining, optimization modeling, regression, and time series. Conservational in accounting, MDX, Java, HTML, and R.

Non Technical: Project Management

Languages: Fluent in English and Mandarin.

Contact this candidate