Ernest Joon Soo Sliter
  • Home
  • Education
    • Leadership & Organizations
    • Study Abroad in Hong Kong
    • Volunteerism
  • Experience
    • Business Analyst Intern at Shell
    • Digital Marketing Intern at OpenSesame
    • CoderDojo NYC Business Volunteer
    • Ye! Marketing Volunteer
  • Resume/Skills
    • Marketing Strategy
    • Business and Data Analysis
    • Business Strategy
  • Projects
    • 2014 UTDallas Business Idea Competition
    • From Developer to Product Manager : A 3 Stage Plan
    • MKT 3300 Final Project : ProtoEdit
    • Web Analytics: Google Online Marketing Challenge
  • Recommendations
  • Contact

Data Analysis

SQL​

Database Fundamentals (UTDallas: MIS4300):  Analyzed the key concepts relevant for the design and construction of basic relational databases. Discussed topics included data models, database operations through the use of SQL, normalization, and database management. 

I also utilized SQL frequently in other courses such as the MIS Capstone course and Business Data Warehousing. 

Excel

  • Shell: I constructed an automated capacity planning document and automated several processes through the use of Excel VBA. 
  • Utilized Excel frequently in coursework through classes such as Quantitative Business Analysis, Managerial Decision Making Under Uncertainty, and Business Finance. 

R

Management Information Systems Capstone (UTDallas: MIS4390): Challenged by AT&T to effectively use mobility data, specifically geospatial data from Foursquare to generate business value. Led brainstorming efforts and my personal idea was selected for the project. Collaborated with teammates to design and build a basic application in R that pinpointed favorable retail locations in NYC based on traffic and location of complementary stores. Learned about R, translating goals into deliverables, and engaging external stakeholders.

Exploratory Data Analysis: Using R (Udacity: In Progress): Learned about exploratory data analysis, which is the process of visualizing and examining the key patterns of a data set. Provided a strong groundwork for exploring data in R using histograms, box plots, and other graphs through ggplot2. 
Picture

Business Intelligence

​
​Business Intelligence Software and Techniques (UTDallas: MIS6324): 
​ Analyzed the ways in which business intelligence and insights could be derived from large volumes of data. Began by examining association rules, market basket analysis, and hierarchical clustering in SAS Enterprise Miner. Following topics included decision trees, neural networks, logistic regression, recommendation systems, and text mining. Gained a better understanding of key methods integral to data mining and the appropriate situations in which to use them. 

Business Data Warehousing (UTDallas: MIS6309): Began by introducing students to basic data analysis in Excel and Tableau, then went into greater depth concerning E-R models, RDBMS fundamentals, Data Warehouse  architecture, data cubes/marts and ROLAP in SQL. During the second half of the course, we went into more advanced topics such as SSAS cubes, MOLAP, the Dimensional Fact Model, and star/snowflake schema. 

Statistics

Managerial Decision Making Under Uncertainty (UTDallas: OPRE 3360): Discussed core probability and statistics concepts to augment managerial decision-making ability. Topics considered included discrete probability distributions, sampling, hypothesis testing, and simple linear regression. Reinforced and reviewed key concepts learned in AP Statistics.

Computer Science​

  • Hackathons: Attended YHack 2015, a hackathon hosted by Yale, and HackUTD 2015. 
  • Familiar with the fundamentals of object-oriented programming/design including the usage of basic algorithms and data structures (stacks, queues, trees) through the completion of Computer Science I, Computer Science II, and Discrete Math I. Primary language used was Java.

Business Analysis​

System Analysis and Design (UTDallas MIS 4330): Provided basic knowledge regarding object-oriented system analysis, design procedures, and project management. Began by talking about the System Development Life Cycle and conducting feasibility analyses and use-case estimations. Progressed to requirements gathering, business process modeling through activity diagrams, sequence diagrams, and use cases. Finally examined data management layer design, physical architecture design, change management, and training
Software Development Processes (Udacity): Began by evaluating the various life cycle models (waterfall, spiral, agile) and version control. Then investigated requirements engineering, UML structural diagrams, software architecture, design patterns, and black/white box testing. Ended by further analyzing agile development methods (XP, refactoring, and paired programming). 

Shell Business Analyst Intern

  • IT Service Delivery & Support Processes: Initiated the deployment of an application support web form. 
  • Business Analysis Techniques: ​Constructed a capacity planning spreadsheet
  • Business Process Improvement: Automated several processes through Excel VBA 
  • Planning and Organization: Created 5 Gantt charts for presentation to management
  • Stakeholder Engagement: Built a model for estimating time needed to fix technical issues based on workstream/category factors.
Powered by Create your own unique website with customizable templates.
  • Home
  • Education
    • Leadership & Organizations
    • Study Abroad in Hong Kong
    • Volunteerism
  • Experience
    • Business Analyst Intern at Shell
    • Digital Marketing Intern at OpenSesame
    • CoderDojo NYC Business Volunteer
    • Ye! Marketing Volunteer
  • Resume/Skills
    • Marketing Strategy
    • Business and Data Analysis
    • Business Strategy
  • Projects
    • 2014 UTDallas Business Idea Competition
    • From Developer to Product Manager : A 3 Stage Plan
    • MKT 3300 Final Project : ProtoEdit
    • Web Analytics: Google Online Marketing Challenge
  • Recommendations
  • Contact