Data Sql Server

Jiayi (Kayee) Liu

*** **** **, *********, **, ***02 Cell – 201-***-**** ********.***@*****.***

SUMMARY:

SQL BI developer with more than 2 years of solid Data Analyst experience

Professional experience in different kinds of data source, such as SQL server, DB2, MySQL, Oracle, Teradata, SharePoint Site, HTML script and etc.

Experienced in designing local and physical data model including ER diagram, normalization and use ER Win to make it understandable and synchronize to the database.

Excellent experience in writing T-SQL scripts, creating stored procedures, views, temporary table, CTE (Common Table Expression) and other database objects.

Excellent skill in trouble shooting, find error root cause, and give appropriate solution.

Professional in writing static and dynamic SQL query, joins, CASE statement, If…ELSE statement, nested sub-queries, wild cards and etc…

Experienced working with large size OLTP and OLAP databases.

Worked extensively on the design and implementation of business intelligence integration solutions with Microsoft SQL server integration services (SSIS).

Good experience in designing and implementing advanced and interactive business intelligence reporting solutions with Microsoft SQL server reporting services (SSRS).

Experienced in other Business Intelligence tools such as Tableau, Power BI, Pantaho, excel Pivot table.

Worked on Python help with troubleshooting, data analysis, and data cleaning via Numpy, Pandas, Matplotlib, NLTK.

TECHNICAL SKILL:

Business Intelligence Tools: SQL Server, SSIS, SSRS and SSAS.

Programming Languages: T-SQL. Python, R, HTML/CSS/JavaScript, SAS Enterprise Guide

Development Environment: Visual Studio, ER Win, SSMS, SQL Server Data Tools (BIDS), MS

Visio, MS SharePoint, MS SharePoint Designer, Tableau, MS Power BI

CERTIFICATION:

Microsoft Certified Professional

EDUCATION:

Stevens Institute of Technology Hoboken, NJ

Master of Science in Information System - 05/2016

EXPERIENCE:

10/2016 - Present

Bank of America - Charlotte, NC

Financial Data Analyst

Bank of America is an American multinational banking and financial services corporation headquartered in Charlotte, North Carolina. Bank of America provides its products and services through operating 5,100 banking centers, 16,300 ATMs, call centers, and online and mobile banking platforms.

Responsibility:

Worked on sample development in various work streams provide statistical/non-statistical data samples for compliance tests, and also validated data document consistency and data sufficiency for the tests.

Involved in extracting data from multiple sources such as SQL Server, DB2, and Excel by using SQL in TOAD analysis, and VBA technics to meet business requirements.

Held the meeting with BA and test designee for troubleshooting, such as fix data error, understand business logic, and find error root cause.

Used T-SQL script created dynamic query, meanwhile created automatically monthly, annually and other regularly report.

Apply aggregate function in the T-SQL statement, such as MAX, MIN, RAND, SUM and etc.

Apply other function to change the data format, data type and concatenate data.

Ran the statistical model in Excel file and check the data accuracy based on the model.

Created Materialized Views, temporary tables, CTE (common table expression), and Correlated sub queries, Nested Queries, and various forms of control structures including dynamic SQL query, CASE statement, IF-ELSE statement, FOR loops, WHILE loops for sample development.

Design ETL (Extract, Transform, and Load) Packages with Microsoft SSIS 2012 to pull data from various sources like flat files, excel, Oracle, DB2 and SQL Server to individual Data marts which ultimately go into Enterprise Data Warehouse.

Used Python scripts to update content in the database and manipulate files.

Well used in join/merge, loc, iloc, group by and aggregate/statistical function in Python Pandas for data analysis purposes and solved problems in multiple ways.

Worked on Python Pandas for helping BA and test designee for troubleshooting, data analysis and data cleaning.

03/2016-10/2016

Action Against Hunger ACF-USA - New York, NY Data Analyst

Action Against Hunger is an NGO company focuses on humanity. It builds long-term strategies for self-sufficiency, lifesaving for 45 countries.

Responsibility:

System Administration experience including installation, administration, and maintenance of SharePoint Office365, SharePoint 2013, Open Data Kit (ODK) and Program Information Management System (PIMS).

Managed SharePoint Designer workflow creation and custom workflows using Visual Studio.

Involved in reviewing business requirements and analyzing data sources form Excel, SQL Server, and DB2 for design, development, testing, and production, support existing report and created new report.

Developed Summary reports, Sub-reports, Graphs using SQL Server Reporting Services.

Integrated MS Power BI with MS SharePoint built up SharePoint dashboard.

Used SQL query personal information and check user log in date in database.

Used different Business Intelligence tools for data visualization purposes.

Used T-SQL to create and modify existing script

Implemented data mining classification methods using Python package tweepy and NLTK packages to calculate the company popular rate in the social network.

Used Python Pandas to clean data and manipulated with data.

Environment: SQL server, SSRS, MS SharePoint, MS, SharePoint Designer, Python, MS Power BI, Tableau

05/2015 – 03/2016

Consulate General of the P.R.C in New York - New York, NY

Business Analyst

The Consulate General of the P.R.C belongs to the Ministry of Foreign Affairs, China. The Department of Education is responsible for international scholarship and student management services to promote and improve Chinese and American cooperation in education.

Responsibility:

Initiated a proposal to company reservation business process and collaborated with IT department, which reduced redundancy call rate by 20%.

Extracted data from databases using SQL, collected historical clients application forms.

Participated in reengineered and enhancement ERP for customer online reservation and management system.

Designed and developed USE CASE, DFD (Data flow diagram) and BPMN (Business process map notation) diagram.

Regulations regarding the writing detailed business-IT alignment documentation to satisfy with CRM (Customer relationship management).

Participated in integration testing and UAT (User acceptance test) and functionality testing.

Using Python Pandas, join, merge, statistical function and etc.. for data analysis purpose, such as showing statistical summary, slicing the DataFrame .

Experienced in using python Pandas created DataFrame and series.

PROJECT:

09/2015 – 12/2015

Social Network Analysis - Hoboken, NJ

Analysis regarding iPhone’s marketing share by using social media techniques.

Responsibility:

Retrieved tweets, followers, users and locations from twitter API using Python.

Cleaned data using stop words removal, Ngrams, POS tagging and word count using Python.

Applied and evaluated classification algorithms (KNN, Naïve Bayes, Decision Tree, etc…) by using Python.

Used python pandas for data preparation, data cleaning and data migration.

Built classifier to predict IPhone’s popularity.

Classified each group of the products to analyze iPhone’s marketing strategies and their competitors.

Involved in data visualization by suing Tableau.

Skillset:

SQL, Python, R, SAS, HTML/CSS, data analysis, business analysis, business intelligence, SDLC, pandas, NLTK, Munpy, data management, data remediation, agile environment, TOAD, Banking, Cognos, Tableau, Power BI, EXCEL, VBA, Pentaho, SharePoint, data cleaning, data migration, data organization, QA testing, issue tracking., SSIS/SSRS/SSAS

Contact this candidate