Xintong Lin

Corona, CA, *****; Phone:951-***-****; email: ac4bj8@r.postjobfree.com;

BI SQL DBA/Developer

Summary

Highly skilled Business Data Integrating and Analyst with 10+ years of experience assisting executives in the finance, retail and technology sectors by providing BI/EDW architecture designing, data analysis, data modeling and result reporting. Background includes use of a variety of data integrating and analytics including SQL, Script, ETL Tools, BI Tools and MS Office Suite among others. Experienced in project management as team leader with additional skills as a technical trainer.

Core Competencies

A.R.T Furniture Inc., USA, Feb 2017 - Present

IT Programmer, DBA, Helpdesk

Used PowerShell and Created Store Procedures for eComm-orders, EDI-orders batch and automatic import into company’s ERP system on Azure SQL server. Calculated SKU Safety-Stock by T-SQL base on history data. Also as DBA role maintained SQL DBs Backup, role permission setting and performant tuning.

Created SSIS packages for integrating Source data, Data Quality Control, Generating Report, Exporting Inventory Feed and Maintenance SQL Server. Created script to send out message, report and data automatic by SQL dbmail, FTP and Web-service, also used Python, PowerShell script and SciTE-Lite script to complete the tasks.

Created program for automatic generating Product SKU ID, Import new orders and export Purchase orders on ERP system. Created program to synchronize data between ERP system, eComm web-site, Dealers and supplier system.

Created Excel VBA programs for data query and collecting. Helped co-worker convert data into unified format report. Used SQL script to load and update data in Database base on Excel file, Text file and DB-linked data source.

Built internal web-site for sharing public information and created web-business reports with SQL, ASP.net, SSRS, SSAS, MS PowerBI

Communicated with company HQ. Transferred and updated new IT technologic, project status and IT system running status.

As helpdesk role, maintaining company IT system and co-worker computer ensure its run well and safely. Include installing, setting and troubleshooting OS, server, Anti-Virus software, System security policy, Office software, Printer, Telephone, SW/HW tools and network.

Recreated company IT architecture. Migrated server into Cloud service (Azure, AWS, Effortless), included SQL Database, Email, Home and business web-site and backup server. Built VMWare vSphere platform for local servers. Built new domain controller and deployed security policy, WSUS and files-share controller.

Huang Xi Books Inc., USA, Jan 2016 - Dec 2016

IT Consultant (Part-Time)

Built a Website on AWS (www.cucelite.com), With HTML5, Asp.net, Java, Perl Script, Mysql.

Wrote an Auto-Collect and Generate Invoice program, With Excel VBA.

Coded a Statistical Analysis tiny-program, With Python

Created a Game APP(IOS) with Xcode8 and Objective-C.

Teradata of China, May 2003 - Dec 2015

BI Technical Consultant/ Data Analyst / Manager

Implemented data loading and transforming with Teradata tools. Built the ETL jobs with Perl language, Teradata SQL and ETL Tools.

Edited SQL statement for inquiring data and analyzing the business requirements (Ad-hoc). Tuned complex SQL and ETL jobs to improve system performance.

Created ETL job with Perl embedded SQL to analysis history data and control data quality.

Developed Key Analysis Requirement with BI Tools: Tableau; Cognos, SSAS/ RS.

Designed data model base on TD-FSLDM to store history data with ERwin.

Designed OLAP data model to support application development base on Cognos and BO BI tools for CUBE and Reporting.

Participated in Teradata DBA work for Data access right control, Space management, Data Backup and Restore.

Built the SQL Coding standard document and used it in various projects.

Trained team members on how to create good performance SQL in Teradata DB.

Presented customer with report project status and development result.

Led team members in completed Shanghai Stock Exchange dual EDW system projects.

Led team members in completed China Industry Bank Data Standard consulting project.

Fu-Liang Hi-Technology China, 1995 – 1998; Shine Technology Fujian China, 1998 - 2003

Senior Software Develop Engineer (7 years)

Created SQL code, store procedures and responsible for MS SQL server deployment, data management and maintenance.

As SQL DBA role, deployed SQL server on windows server, maintained databases backup, performance tuning, role setting and database designing.

Designed data model for MS SQL Server data storage with PowerDesigner

Developed and deployed Securities Broker software products, e.g.: Securities Integrated Management Platform, Securities Management System (supports for automatic operations of data collecting, settlement, clearing, monitoring, report producing, and statistical analysis). IT Technology used: MS SQL Server, Visual Basic.

Completed three projects of paper manufacture on automation field to control the temperature of the boiler and ensure producing high-quality paper by using PC controller (PLC A/D), coding with Visual Basic, BC, MS SQL Server, Excel VBA and Socket Protocol(TCP/IP). The implementation of these projects enhanced the working conditions of workers and improved paper quality.

Work History

IT Programmer, DBA, Helpdesk, ART Furniture Inc. USA, Feb 2017-

IT Consultant (Part-Time), Huang Xi Books Inc., USA, Jan 2016 – Dec 2016

Technical Consultant /Manager, Teradata of China, May 2003 -Dec 2015

Teradata is an American Company. Teradata is a leading provider for enterprise end to end solutions and services in Data Warehousing, Big Data and Analytics, Driven Marketing that enable company to become a data-driven business, positioned to increase revenue, improve efficiency, and create the most compelling experience for your customers.

Awarded “Consulting Excellence” of profession service on 2008

Executive Assistant President, Shine Shanghai China, May 2010 – Aug 2011

Senior Database Developer, Shine Technology Fujian China, 1998 - 2003

Software Develop Engineer, Fu-Liang Hi-Technology China, 1995 - 1998

Projects:

ART Business Rule Controller, ART Inventory Fee Automation, ART Order Automation, ART IT Architecture Upgrade, ART ARTISTE; Cucelite Website, Ting Hsin EDW–Retail, STO Data Mart–Express, Pousheng EDW – Retail, Yunda Data Mart–Express, CEA EDW–Airline, SMIC EDW–Manufacture, Feiliks EDW–Logistics, CIB Data Standard – Bank, CITIC Capital MS- Finance, Investor Bond MS –Finance, CSDC EDW- Finance, SSE Dual/DDS/HDS – Finance, Securities Company Stock &Capital MS – Finance…

Technology Skills

Operating Systems:

Unix, Linux, Windows, DOS

Languages:

SQL, Python, Perl, PowerShell, Unix-Shell, Java /asp/html, Erwin/PowerDesigner, Visual Basic, Excel Macros(VBA), Visual C#, Objective-C

RDBMS:

Teradata Data Warehouse, Microsoft SQL Server, MySQL, Oracle

ETL Tools:

Teradata DW Automation, Informatica, Data Stage, SSIS

BI Tools:

Tableau, Cognos, Microstrategy, SSAS/RS, PowerBI

Other:

XCode8, Adobe Dreamweaver, Windows Server Domain, Exchanger Server, VMWare, FTP, Photoshop, Visio, AutoCAD, XML, JSON, MindManager, Axure, UltraEdit, Teamviewer, GotoMeeting/Assist, Webex,TCP/IP, VPN, Data Governance

Education

CHANGCHUN UNIVERSITY OF SCIENCE, Materials Science, BS, 1991 - 1995

Teradata Certified Professional, Teradata, September 2004

PMP, PMI Orange County Chapter License, August 2009

Program and Analyze Data with Python, coursera.org/MICHIGAN, 2016

Contact this candidate