Xu Zhao

419-***-**** (Cell)

ac2ayd@r.postjobfree.com

Rowland Heights, CA, 91748

Summary

7+ years of IT experience focusing on Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business Intelligence in IT industries and health care related sectors.

Expertise in ETL and reporting tools. Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools.

Expertise in working with SQL queries and PL/SQL (Stored Procedures, Triggers, Packages/Functions).

Excellent knowledge of the design and implementation of the Data Warehouse life cycle.

Experience with business requirements gathering, business analysis and documentation.

Experience working in an Agile/Scrum environment.

Proven experience in utilizing databases such as Oracle and Teradata

Excellent Analysis and problem solving and communication skills

Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.

Excellent interpersonal and communication skills, experienced in working with senior level managers, stakeholders and developers across multiple disciplines.

Experienced documentation skills on Business Requirement Document (BRD), Functional Requirement Document (FRD) and Non-functional Requirement Document.

Test Case writing and Conducting Tests (Integration& Regression testing), Black Box/White Box testing, UAT, QA

Excellent knowledge on different modules within health care (Membership, billing, enrollment, claims, providers)

Created maps & layouts as imposed during Electronic Data Interchange (EDI): Benefit Enrollment and Maintenance, Claim Payment, Eligibility Benefit Inquiry and Response, Claim Request for additional Information and Response, Claim Status Request and Response.

Technical Skills

Change Management Tools

TFS

Testing

Integration, QA, UAT

Databases/Tools

SQL, PL/SQL,SSIS, Informatica, MySQL, Oracle, MS Access

Operating Systems

Windows, Mac, UNIX

Programming Languages

C#, .Net, PHP, Python, Java

Web Design

HTML, CSS,JavaScript,JQuery, Bootstrap,Json

Methodologies

Agile, Waterfall

Modeling Tools

Microsoft Visio

Reporting Tools

SSRS, Business Objects

Experience

Otc. 2016- May 2017

Developer(Database, ETL, Testing) – American Healthways Inc. Chandler, AZ

Healthways is a health care related company. The company understands the needs within customer populations. Engaging individuals in sustained behavior change that helps them live longer, happier, more productive lives.

SilverSneakers

Project Description: I was leading the project. This project focuses on the eligibility check for clients based on migration data from health insurance plan benefit and claims.

Prime

Project Description: Project lead. There are two kinds of members in the prime project. One is payment members. The other is prime Eligibility Check members which have the same methodology and functionalities as SilverSneakers.

HCSC Data Migration

Project Description: The main purpose of the project is data migration from HP server to Befit Server. It involves with Web design, E-commerce, data migration and credit card migration.

Analyzed the source system and involved in designing the ETL data load.

Developed/designed mappings by translating the business requirements.

Worked in various transformations like Lookup, Joiner, Sorter, Aggregator, Router, Rank and Source Qualifier to create complex mapping.

Implemented documentation standards and practices to make mappings easier to maintain.

Extensive SQL querying for Data Analysis and wrote, executed, performance SQL Queries for Data Analysis & Profiling. Extracted business rule and implemented business logic to extract and load SQL server using T-SQL.

Created support, maintaining, enhancing and developing pages new interfaces for Claim warehouse application.

Monitor & troubleshoot batches and sessions for weekly and monthly extracts from various data sources across all platforms to the target database.

Tuned the mappings by removing the Source/Target bottlenecks and Expressions to improve the throughput of the data loads.

Environment: Microsoft Visio, MS Office, TFS, SQL, Agile, Informatica, ETL, Teradata, .Net, HTML, CSS, JavaScript, JQuery, Bootstrap, Json

Feb. 2014 – Sep. 2016

Founder--Mellifluous LLC Toledo, OH

Mellifluous LLC is an Asian Market with products of electronic device and accessories and grocery, serving the neighborhood of Toledo.

Management/Procurement/Sales/Transportation

May. 2012 – Feb. 2014

Developer(Database, ETL, Testing)--University of Toledo Toledo, OH

Student Management System

Project Description: The project is focusing on creating, enhancing and maintaining student management system

Working with business users and business analysts for requirements gathering and business analysis.

Converted business requirement into high level and low level design.

Designing and customizing data models for Data warehouse supporting data from multiple sources on real time.

Extracted data from different flat files, MS Excel, MS Access and transformed the data based on user requirement and loaded data into target, by scheduling the sessions.

Created reusable transformations starting concurrent batch process in server and did backup, recovery and tuning of sessions.

Created sequential batches and concurrent batches for sessions.

Developed PL/SQL procedures/packages to kickoff the SQL Loader control files/procedures to load data.

Created SSIS Packages to extract data from Excel Files, MS Access files using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow

Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse

Written SQL Scripts and PL/SQL Scripts to extract data from Database and for Testing Purposes.

Supporting daily loads and work with business users to handle rejected data.

Environment: MS Office, .Net, HTML, CSS, JavaScript, JQuery, Bootstrap, Json, SQL, Agile, ETL

Sep. 2006 – Sep. 2011

Developer(Front-end, ETL) -- CCUST Changchun, China

CCUST is a software design company. It cooperates with Sony and local universities. Projects mainly focus on creating, enhancing and maintaining softwares for medical devices, MRI, CT scan, 3D CT scan, Doppler, USG and other fields.

CT Scan Device UI Re-Design

Project Description: The main purpose of the project is to re-design the UI of the CT Scan device and beautify the interface.

WaterBill Management Software Design

Project Description: The project is involved with local government water department, helping them designing a water bill management system.

Involved in gathering requirements via interviews, company documents analysis and teleconferences.

Worked in both Agile and Waterfall methodologies and attended sprint meetings and reviewed story cards.

Involved in different types of testing including positive scenario, negative scenario, system, regression testing & user acceptance testing.

Developed test scenarios for positive testing, negative testing and for user acceptance testing.

Analyzed the requirements and framed the business logic for the ETL process.

Extracted data from Oracle as one of the source databases.

Involved in JAD sessions for the requirements gathering and understanding.

Involved in the ETL design and its documentation.

Experienced in handling slowly changing dimensions.

Responsible for the development, implementation and support of the databases.

Extensive experience with PL/SQL in designing, developing functions, procedures, triggers and packages.

Used data integrator tool to support batch and for real time integration and worked on staging and integration layer.

Optimized the performance of the mappings by various tests on sources, targets and transformations

Scheduling the sessions to extract, transform and load data in to warehouse database on Business requirements.

Created high level design documents, technical specifications, coding, unit testing

Environment: MS Office, C#, .Net, SQL, Oracle, HTML, Unix, JavaScript, Waterfall, Agile, ETL

Education

Jan. 2012 – Aug. 2015

Master degree of Electrical Engineering at University of Toledo

Aug. 2006 – May 2010

Bachelor degree of Computer Science and Technology at Changchun University of Science and Technology

Certificate

02/14/2017

Front-end web developer nanodegree authorized by Udacity through Google

Contact this candidate