Sql Server Data

Huiyao (Karen) Dong

214-***-**** **********@*****.*** www.linkedin.com/in/huiyaodong/

SUMMARY

Fast learner, hard worker and team player who is proficient in multiple scripting languages and databases. 3 years working experience with relational database development and maintenance, and data analysis. MCSA certified. Web development experience with HTML, CSS, JavaScript, Django framework, .Net framework, and deployment. Portfolio: www. huiyaodong.com / github.com/KarenDong EXPERIENCE

Data Analyst II

KT&G USA Jan. 2017 – Present

• Develop the Salesforce system, including database structure design, data migration and integration development, dashboard design

• Designed and developed the relational database for marketing department with MySQL, integrate multiple data sources with database tools (MS Access and MySQL) to generate insights

• Generate scheduled monthly reports for business performance, expenses, and research of market trends and prices

• Develop analytics dashboard and automated reports with business intelligence tool like Power BI and Tableau

• Utilize VBA and Power Pivot to develop finance model and reports for performance appraisal

• Conduct statistics analysis based on raw sales data and forecast future performance and costs with Python Database Analyst

Blue Cross and Blue Shield of Texas Aug. 2016 – Dec.2016

• Developed and maintained queries for reporting, triggers and stored procedures in Oracle

• Processed, organized, coordinated data and generated reports for commissions’ analysis and adjustments

• Established Access Reporting Database System and worked with Visual Basic codes for certain projects

• Designed SQL database with SQL Server, developed ETL packages with SSIS for automatic data transformation Database Analyst Internship

Aberg Center for Literacy Jan. 2016 – July 2016

• Built relational database and Maintained database models stored in SalesForce and MySQL

• Analyzed survey data with descriptive statistics and inferential statistics with Excel, SQL and SOQL

• Generated reports statistical graphs using VBA, Pivot table and SalesForce reporting tools

• Helped with remodeling of the website, designed website testing and web analysis procedure MIS Lab Assistant

The University of Texas at Dallas Jan. 2015 – Dec. 2015

• Built Excel online course for UT Dallas students for self-study and to prepare for Excel certification exam

• Guided approximately 20 students weekly for database and BI project related to Excel, Access and SQL server

• Helped over 900 students in 2 semesters, with Excel knowledge and skills related to MS Excel exam preparation

• Organized Excel and Database development workshops with student organizations Accounting Analyst Internship

Qinhuangdao Qiushi Certified Public Accountants Co., Ltd.(China) Sep. 2012 – Jan. 2013

• Audited and analyzed data of bank accounts and investments with MS Access for 18-20 clients monthly

• Assisted team with tax consultant and reporting by analyzing cost and taxes Cost Analyst Internship

Sinolion Real Estate Group Co., Ltd. (China) July 2010 – Aug. 2010

• Created and maintained documentation for real estate projects to support further quality assurance research

• Analyzed data for investment evaluation using advanced Excel functions like VBA and pivot tables

• Generated cost reports monthly and on an as-needed basis with SAP, Financial Accounting module EDUCATION

Coding Dojo Coding Camp May 2017 – Oct. 2017

Accelerated coding boot camp graduate focused on 3 full stacks (Web Development, Python, and ASP.net) The University of Texas at Dallas Aug. 2014 - Aug. 2016 M.S., Information Technology Management GPA 3.14

Huiyao (Karen) Dong

214-***-**** **********@*****.*** www.linkedin.com/in/huiyaodong/ Yanshan University (China) Sep. 2009 - July 2013

B.S., Accounting GPA 3.3

CERTIFICATION

• MCSA - Microsoft Certified System Administrator: SQL Server (Certification#: G136-5495)

• MTA - Microsoft Technology Associate: Database Fundamentals (Certification number: F730-3159)

• UT Dallas SAS Institute Certificate in Business Intelligence and Data Mining

• Google Analytics Individual Qualification

TECHNICAL SKILL

Programming: SQL, HTML, CSS, jQuery, JavaScript, Python, C#, ASP.Net, .NET Entity framework, SAS, Java Software: SQL Server 2012/2014, Oracle, MySQL, SAS, Git Bash, Atom, Visio Studio, AWS, Azure, Python Shell, CMD, Visio, Eclipse, SalesForce, SAP, Access, Excel, Crystal Reports, Power BI, Tableau, Photoshop Database: SQL Server 2012/2014, Oracle, MySQL, MS Access PROJECTS

Web development – Portfolio Site

• Designed the layout and architecture of my portfolio website to develop my personal brand

• Developed my portfolio using HTML, CSS, and jQuery Web development – “The Wall: A mini forum” (ASP.NET MVC framework)

• Designed a simple forum, designed controllers that allow user to register, login, post and view posts and comments

• Designed the database structure with MySQL

• Developed the website using ASP.NET framework, and deployed the website with MS Azure platform Web development – “Tree hollow” (Django MTV framework)

• Designed a simplified website that allow users to register, add, edit and delete personal posts.

• Designed the database structure with SQLite

• Developed the website using Django framework, and deployed the website with AWS platform Customer Analytics and Real-life Data Analysis with SAS Programming Apr. 2016 – May 2016

• Built Poisson model and Beta model using base SAS

• Performed Customer Analytics such as customer retention, count models and choice models Web Application Design (associated with Petro China Co Ltd.) Dec. 2015 – Jan. 2016

• Designed Java based app. to analyze system reliability of pump wells of oil extractor and predict inspection cycle

• Designed database structure with MySQL Model, loaded data using ETL tools in MySQL

• Developed the web-based interface using HTML, CSS and jQuery Business Intelligence Project for emergency department(ED) Aug. 2015 – Dec. 2015

• Conducted data analysis for cost savings and death rate based on data from U.S. emergency departments in 2012

• Predicted the key elements affecting the cost trend of emergency departments and death rate of patients Java-based Software Design Jan. 2015 – May 2015

• Designed a Java-based Optimized Shopper Application, which contains: Optimized Map system, Queue Status system, Density count system.

• Created blueprint for the system by Designed the class diagram and user case diagram

• Analyzed database, functions covered and system working process using sequence diagram

• Designed software structure, testing methods, etc. Database management system Jan. 2015 – May 2015

• Designed a database system for chained retail stores using SQL Server 2012, based for real world business need

• Drew the blueprint using MS Visio 2013, developing ERD and Relational Model

• Created the interface that give different roles different admin rights with Visual Studio

Contact this candidate