Sophie Xing
*** **** **. ****** ****, NY ***** Cell: 917-***-**** Email: *********@*****.***
EDUCATION
Master of Science in Information Systems
Sep. 2016-May. 2018
Frank G. Zarb School of Business, Hofstra University, Hempstead, NY
Honors: Membership in Beta Gamma Sigma
Related Coursework: Advanced Quantitative Analysis, Information Systems for Managers, Database Management Systems, Spreadsheet Modeling & Decision Making, IT Project Management, Data Mining for Business Analysis
Bachelor of Science in Computer Information System, Minor in computer networking
Aug. 2009-Aug 2013
Southeast Missouri State University (SEMO), Cape Girardeau, MO
Honors: College of Science and Mathematics DEAN’S HONOR LIST (2011-2012)
Related Coursework: Application Programming, Data Communications, Visual Basic, C and Unix, Software Engineering, Database, Network Route & Switch, Network Security, Network Management.
TECHNICAL SKILLS
Operating Systems: Windows, Linux/Unix
Languages & Database: C, C++, Java, SQL, PL/SQL (Oracle 10,11g, 12c), Java Script, Python, R, Tableau.
Tools: Advanced Excel Modeling, MS Visual Studio, Eclipse, SQL*PLUS, SQL Developer, PL/SQL Developer, Toad.
Computer Networking Skills: Configuring Routers, WAN Connection, Routing (Static, RIP, ERGRP), Configuring Switches with Cisco Packet Tracer.
Software Development Methodology: Agile, Waterfall
PROFESSIONAL EXPERIENCE
Hofstra University, Hempstead, NY
Oct.2016- May. 2017
Graduate Assistant of Department of IS/BA
Graded homework and lab work and gave feedback to students
Assisted professor to search resource for research paper.
Innovatis Technologies Inc., Jersey City, NJ
Nov. 2013- Jun. 2016
Oracle PL/SQL Developer
(Dec. 2014 – Jun. 2016)
Parsed XML BLOB and created tables and force views to extract useful data and archive currently no useful data under staging database.
Created complex SQL queries with sub-queries, analytical functions, inline views, joins (inner, outer) and START WITH and CONNECT BY hierarchical queries to retrieve data.
Translated data transformation logic from XSLT and Java files into PL/SQL.
Created packages, functions for ETL processes to convert data types, implement transfer logic and load data from multiple operational data sources into Data Warehouse Tables with SQL Developer based mapping documents.
Created and worked with GTT (Global Temporary Table) during the ETL process.
Created stored procedures to receive inputs parameters and return required information based on business requirements with SQL Developer.
Extensively used EXPLAIN PLAN utility to leverage SQL queries.
Utilized advanced technique of bulk binding to improve overall performance of large data processing tasks.
Developed Materialized views and Ref Cursors for reporting purpose.
Database and Data Analyst, Intern
(Nov. 2013 – Nov. 2014)
Analyzed documents and data resources to design UML model with MS Visio and create tables using Oracle SQL statements.
Created SQL*Loader scripts to load data from text files into the temporary staging tables.
Wrote complex SQL queries with multiple - joins and Analytical functions for data retrieval from various database objects including tables and views.
Created functions and procedures with PL/SQL Developer to implement business required calculation with data.
ACADEMIC PROJECTS
Desktop Application Team Project: Designed and developed Desktop Application for digital production company Element 74, with C#, ASP.NET, XML; application communicates with USPS API and generates functional domestic and international shipping labels. Spring 2013
Network Design Proposal: In team project for Polytechnic Building of SEMO analyzed current network environment and new network design requirements, designed both physical and logical with MS Visio, created implementation plan and calculated cost estimate of new network design proposal. Spring 2013
Research Paper on CSTL Consultancy: Research is about to review and assess the Center for Scholarship in Teaching and Learning (CSTL) of SEMO by studying their network, application portfolio, customer service and support service. Spring 2012