Administrator Etl

Email: ***************@*****.*** Phone Number: 972-***-****

CAREER OBJECTIVE

Quality-oriented professional with 5+ years of experience and a proven knowledge of database design, real time data, and database development. Aiming to leverage my skills to successfully fill the Database Administrator role at your company. EXPERIENCE

DATABASE ADMINISTRATOR —— FULL-TIME

LGS International Corp, Ontario, CA / Aug 2017 - Jun 2018

• Used SQL Server Management Studio to management data coding and reading: including created tables, Views and Stored Procedures.

• Used SQL Server Management Studio to implement migration from different version of studios, performance improving and setted user rights to different staffs.

• Participated in incident calls and subsequent root cause analysis.

• Cleaned unclean data from different origins and formats by using both SQL Code and SSIS Packages, including migrate data to different environments.

• Used SQL Server Agent to schedule jobs and set steps in every job in SQL Server management studio.

• Debugged error data during execute jobs, checked and cleaned incoming data according to their requirements.

• Created Ad-hoc/ tableau and SSRS weekly/monthly/quarterly/yearly reports for analyzing retail information, staff information and customer information. DATABASE ADMINISTRATOR —— EXPERIENCE CLIENT

Harvard University, Boston, MA / Feb 2017 – Jul 2017

• In charged of all three end clients, all three database servers, used SSIS to create packages loading data to the staging area and cleaning data before load to the staging area.

• Used SQL Server Agent to schedule jobs and set steps in every job by using Stored Procures or ETL Packages and created Stored Procures, Views and create SSIS ETL Packages for these tasks.

• Debugged error data during execute jobs, checked and cleaned monthly incoming data according different requirements.

• Used Jams to deal with jobs as different batches and different functions which end user could directly get useful information by setting work-flows in Jams.

• Incremental load data to data warehouse keep old data and also store the changed data in data warehouse.

• Created monthly/ Semesterly customized SSRS reports. DATABASE ADMINISTRATOR —— EXPERIENCE CLIENT

Baltimore City Public Schools, Baltimore, MD / Jan 2016– Jan 2017

• Analyzed and reviewed business requirements and interacted with Business System Analyst.

• Designed and built process to extract and transform data from operational data to reporting about students' information.

• Performed detailed analysis of source data and reported data to make sure the data quality is not compromised.

• Monitored the core monthly processes required for marketing and regulatory reporting purpose.

• Worked with technical teams to determine data requirements and best practices for advanced data manipulation, and data analysis strategies.

• Understood core systems and data processes for normalization, data validation, data aggregation, and customized reporting.

• Evaluated and designed data collection, data staging, data movement, analytic delivery, data quality and archiving strategies.

• Performed data profiling, source-target mappings, ETL development, SQL tunings and optimization, testing and implementation.

• Implemented Stored Procedures, User defined functions, Indexes, Triggers, Views for on SQL Server 2008/2012.

• For those none IT background manager lever stuff, used Tableau 9.0 to create fancy reports, dashboard reports/ donuts reports /linked reports. PROGRAMMER ANALYST —— FULL-TIME CONTRACTOR

Itlize Global LLC., Cranbury, NJ / May 2015 – Jul 2017

• Installed and configured SQL Server on development server for designing and testing.

• Wrote TSQL statements for retrieval of data and involved in performance tuning of TSQL.

• Performed comprehensive data analysis on the cleaned data and presented insights using data visualization tool such as Tableau.

• Created tables, views, clustered and non-clustered index, user defined data types and user defined functions, created joins and sub-queries for complex queries involving multiple tables.

• Designed, developed and deployed reports in MS SQL Server environment using SSRS Project.

DATABASE DESIGNER —— INTERN

Faithful+Gould Inc., Dallas, TX / May 2014 – Aug 2014

• Gathered the requirements and analysis whether these requirements can be fulfilling, then design UML Diagrams, including class/ use case/ black-box/white-box diagrams.

• Data validation checks during Staging Area (before loading the data into the Data Warehouse), and design ER Diagrams by using MS Visio2010 in Data Warehouse.

• Used Microsoft Access 2013 to create customized reports. EDUCATION

Alliance Computing Solutions, INC.

New York City, NY

ESL North Star Class – Language (Jun 2018 —— Mar 2020) The University of Texas at Dallas

Richardson, TX

M.S. in Software Engineering – Computer Science (Aug 2013 —— May 2015) ADDITIONAL SKILLS

Mandarin

English

Performance SQL

SSIS ETL Packages

SSRS Reports

Information Systems

Database Design

Data Warehousing

Level Design

Troubleshooting

Complex Problems

Communication and

interpersonal

Project Deadlines

Critical Thinking

Problem-solving Good organizational keeping databases up to date

Contact this candidate