Developer Sql Server

Yajun Liu

Home: 503-***-**** Cell: 971-***-****

Email: *********@*****.***

Objective

ETL Developer/SQL Developer/Data Analyst/Software Developer Summary

Experience Synopsis:

• Hands on experience designing and developing extract, transform and load solutions with IBM InfoSphere DataStage v8.5 and v11.3

• Integrate with External data sources including Oracle databases, SQL Server databases, DB2 databases, PostgreSQL databases, Flat files (fixed-length and delimited), XML files.

• Hands on experience developing web applications using C#, .Net

• Good communication skills

• Strong Analytical and Programming skills

• Ability to work independently on development projects with minimal direction

• Able to work in a dynamic and fast paced environment

• Flexible and willing to perform tasks as assigned

• Master’s degree in Computer Science

Technical Skills

• Utilities/Tools/Frameworks: IBM Infosphere DataStage, Toad, JIRA, Rally, GIT, TFS, MS Visio, MS Office

• Languages: Shell scripting in UNIX, SQL, T/SQL, C#, Java, R, JavaScript, ReactJS, Redux, KnockoutJS, AngularJS, jQuery, Bootstrap, CSS, HTML, Ajax, Linq, JSON

• Operating Systems/Environments/IDEs: Unix/Linux, Windows, Eclipse, Microsoft Visual Studio, IntelliJ, MS Excel, Microsoft ASP.NET, Entity Framework, Spring, Maven

• Database: Oracle, Microsoft SQL Server, PostgreSQL, DB2 Work Experience

- Standard Insurance Company (thru Volt)

ETL Developer Mar 2017 to May 2017

Project: Core Integration Engineering

Responsibilities:

• Developed a high level DataStage ETL Design for a company’s application to extract data from mainframe, transfer and load into Oracle database

• Estimated the number of hours of development including data mapping, ETL Detail Design and ETL development(code, test, bug fixed, and deployment)

• Identified DataStage jobs that need to be changed before migrating from DataStage v8.5 to DataStage v11.5

- Cambia Health Solutions (thru Nityo Infotech)

ETL Developer Nov 2016 to Feb 2017

Project: Product Applications

Responsibilities:

• As a member of a team, developed, maintained, and analyzed complex ETLs to transfer and manipulate health insurance data from highly incohesive databases such as Oracle, GreenPlum

• Assigned offshore co-worker tasks and provided technical support

• Hands on experience in designing, developing extract, transform and load solutions with DataStage Designer v11.3

• Designed Parallel jobs using various stages in IBM DataStage for ETL.

• Understanding the requirements and then provide an efficient design for the application. Also prepare source to Target Mapping document applying business rules and logics and review the application design documents.

• Writing Kcorn shell scripts, using Putty to run ETL jobs.

• Analyzing data by SQL and Toad, UltraEdit

- Catalyst DevWorks (formerly Catalyst IT Services) Web Developer Jul 2016 to Sep 2016

Project: OverWatch/Innovolan

Responsibilities:

• Using ReactJs and Redux to develop webpage

• Writing postGreSQL scirpts to maintain database

• Helping teammates to fix bugs

- Cambia Health Solutions (thru Catalyst DevWorks (formerly Catalyst IT Services)) ETL Developer Jan 2015 to Jun 2016

Project: AHS Mandates

Responsibilities:

• As a member of a team, developed, maintained, and analyzed complex ETLs to transfer and manipulate health insurance data from highly incohesive databases such as Oracle, SQL Server and DB2

• Hands on experience in designing, developing extract, transform and load solutions with DataStage Designer v8.5

• Designed Parallel jobs using various stages in IBM DataStage for ETL.

• Understanding the requirements and then provide an efficient design for the application. Also prepare source to Target Mapping document applying business rules and logics and review the application design documents.

• Writing Kcorn shell scripts, using Putty to run ETL jobs.

• Analyzing data by SQL and Toad, UltraEdit.

- Catalyst DevWorks (formerly Catalyst IT Services) Associate developer(training) Aug 2014 to DEC 2014 Project: Twitter/ Injury Report Website/ Time Clock/Hobby Responsibilities:

• Used the ASP.Net WebAPI, WebMVC architectures and C#

• Developed frontend using AngularJS and Bootstrap

• Used Spring Framework/Eclipse IDE, Programmed in Java with JSP front-end Education and Certifications

California State University, Hayward Sep 2000 to Mar 2002 MS in Computer Science

Shanxi University, Shanxi, China Sep 1992 to Jul 1996 BS in Mathematics

SAS Base Programmer certificate 11/21/2007

Contact this candidate