Information Technology Data Analyst

Yi Luo

***** ****** **. *** ****, Dallas, Texas, 75238

469-***-**** **************@*****.***

Technical Skills

Main skills: SQL (4 years), Excel (3 years), Tableau (1 year), VBA (1 years), Python (1 year), XML (1 year), SAS (1 year, certificate by UTD), HTML(1 year), CSS(1 year), Javascript(1 year),

Others: C, C#, ASP.Net, PHP, Mathematica, R, SAP, Photoshop, Sony Vegas, SQL Server, Oracle 11g, Access etc. Work Experience

Information Technology Specialist

C&A Cultural Exchange Center LLC.- Garland, TX 8/2016-5/2017

Engaged in two programs and created two websites individually by implementing HTML, CSS, JavaScript and PHP. Also, created Email Servers for these two programs and admin them. Responsible for the maintenance individually

Designed the pages with organizing and modifying picture and video files by Photoshop and Sony Vegas.

Used some SEO tools to optimize the websites and analyzed the web data.

Hands on experience in data processing automation using Python.

Analyzed the sales data for marketing and sale by SQL, Excel, VBA and Pivot Table, reported the result by Tableau. Business Data Analyst

Vensoft Inc.- Phoenix, AZ 8/2015-7/2016

Involved in two projects PRONTOH.COM and Camp Navigator to handle data. Used Agile methodology and SDLC.

Created data table and manipulate data using SQL server, Visual Studio, Excel/VBA

Worked with Database Adminstrators for relational mapping of data. Responsible for storing and maintaining relational data through tables in SQL servers.

Hands on experience in writing stored procedures in SQL server and data processing automation by Python.

Extensively used TFS for source control and work items tracking. Data Analyst

Ada Adroit L.L.C.- Durham, NC 3/2015-8/2015

Engaged in the project First Dog which was to design a web application. Used Agile methodology and SDLC.

Collected most of the data, handed on the source data and used ETL tools to analyze the data with SAS to extract necessary data and load it into the data warehouse.

Designed the database schema, created tables, wrote SQL query functions and stored procedures to increase data process efficiency with Oracle 11g.

Data Analyst Intern

Founder International Company- Beijing, China 9/2012-7/2013

Involved in CRM System project to record information about hundreds of clients by SQL server and Excel.

Worked closely with Sr. database administrators for migrating database’s data from an older platform to a new one.

Responsible for filling Excel sheets and collecting and analyzing data reports and documents.

Responsible for creating reports by their new CRM system. Other Non-profit Project

Business Analyst

SoundClub ( http://soundclub.io/#/ ) 3/2017-5/2017

Collaborated with five other team members in our spare time to implement an optimized lightweight music distribution platform, which is a hand-styled, single-page app with continuous play audio.

Designed relational database schema and created tables in SQL Server 2010. Maintained a centralized database in AWS S3 to efficiently store data.

Worked as the QA focusing on developing test governance processes, writing test cases, manipulating test data, detecting, reporting and fixing issues with developers in order to minimize the defects in production by Excel.

Evaluated business and software requirements, wrote project main function plan, made ERD and some other process diagrams in Microsoft Visio, closely followed the Agile software development lifecycle model. Education

University of Texas, Dallas, TX 8/2013-12/2014

Master of Information Technology and Management in Naveen Jindal School of Management Beijing University of Posts and Telecommunications, Beijing, China 9/2009-6/2013 Bachelor of Network Engineering in Academy of Computer Sicence University of California, Berkeley, CA 6/2012-8/2012 Summer Session

Research and Rewards

Won Meritorious Award (Top 9%) in 3697 teams all over the world of 2012 American Math Contest in Modeling Aimed at how to arrange the boats on a 225 miles river to have more people take a trip on the river in some specific conditions, we put forward 4 models from special to general. As the team leader, I contributed 3 models . Our work made the problem realistic and practicable. Besides, different models made plans flexible to meet different demands.

Contact this candidate