Xian Shi

adlczl@r.postjobfree.com Portfolio: https://xian-shi.herokuapp.com/ cell: 607-***-****

EDUCATION

Cornell University, Graduate School, Ithaca, NY

Master of Professional Studies in Information Science, GPA 3.339 December 2020 Focus Area: Interactive technologies

Selected Coursework: • Introduction to Database Systems • Visual Data Analytics for the Web • Interactive Information Visualization • Trends in Web Development • Advanced Human-Computer Interaction Design Rutgers University, Rutgers Business School, New Brunswick, NJ Bachelor of Science in Business Analytics and Information Technology, GPA 3.341 May 2017 SPECIALIZED SKILLS

Technical: JavaScript, HTML, CSS, D3, Node.js, Express.js, React, JSON, jQuery, Bootstrap, Figma, SQL, ETL, Tableau Languages: English (fluent); Mandarin (Native)

WORK EXPERIENCE

Front End Engineer Intern, Smart Twigs, Remote February, 2021 – Present

• Collaborated with 4 developers using Git.

• Added features to enhance the user experience using React Native and JavaScript.

• Debugged and troubleshooted errors reported on JIRA tickets.

• Participated in daily stand-up meetings for progress updates and bi-weekly AGILE sprints. IT Analyst, Merck & Co, Rahway, NJ October 2017 - June 2018

• Preserved structured and unstructured data.

• Produced confidential data on request and ensured the correct data set is forwarded to the Legal Department.

• Quickly learned to use in-house software with high proficiency resulting in increased responsibility to train new hires. Data Governance Intern, Independence Blue Cross, Philadelphia, PA June 2016 - 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.

• 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

UX Researcher, Unbroken Promise Initiative, Ithaca, NY Fall 2020

• Collaborated with a team of 6 to provide insights into the needs of West End, a local community living below poverty threshold.

• Conducted open-ended and semi-structured interviews with West End residents.

• Systematically analyzed interview findings using qualitative research methods.

• Developed an educational visualization outlining key insights from user research using Figma.

• Created a written report with actionable insights for future use and strategic decision-making.

• Presented our findings and deliverables to the client and the city council members of Ithaca. YelpCamp Web Application Summer 2020

• Designed a full stack web application and deployed on Heroku

• Implemented back-end services as RESTful APIs using Node.js and Express.js.

• Created login and register authentication and authorization mechanism for users to edit or delete contents.

• Built NoSQL database (MongoDB) and deployed on MongoDB to manage user data.

• Designed and coded user interface using Bootstrap and CSS.

Contact this candidate