Candidates About

Ryan Chen

SAS Developer / Data Analyst / SAS Data Integration Developer

PROFESSIONAL SUMMARY

·         Over 10 years of experience in data analysis and statistical modeling including data extraction, manipulation and validation techniques, writing macros and reporting on various projects for financial, healthcare, insurance and education industry using SAS and its tools.

·         In-depth knowledge of Statistical programming, data processing, data collection, quantitative and qualitative data analysis

·         Knowledge survey methods such as survey research, sampling, questionnaires, and data collection used to conduct surveys

·         Strong understanding in various Economic, Econometric and statistical concepts such as ANOVA, Correlation, Regression Analysis, Time Series and Multivariate Analysis 

·         Experience in Data Integration/Management Studio, developing sophisticated data flows

·         Solid work experience in data modeling and Data Warehousing

·         Experience in SAS/BASE, SAS/SQL, SAS/MACRO, SAS/ODS, SAS/STAT, SAS/CONNECT, SAS ETL, SAS/ACCESS,SAS BI, SAS/ OLAP and SAS Enterprise Guide

·         Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using SAS DI studio tools

·         Proficient knowledge working on SAS DI studio such as registering sources, creating  targets table, creating and working with jobs, working with transformations and  working with slowly changing dimensions (SCD Type I Loader and SCD Type II Loader ), working with the Loop transformations, and defining new transformations

·         Excellent command in writing complex routines for data validations, data extraction, transformation and loading to target decision support systems using MS Excel, Pivot tables and SAS on various environments

·         Proven skills in data cleaning, data archival, data migration and coding utilizing SAS on UNIX and Windows

·         Experience in using various MS office tools for analyzing, arranging and presenting data

·         Strong experience in coding using MS SQL, Procedures/Functions

·         Extensive experience in preparation of reports, tables, listings and graphs

·         Experience in utilizing SAS Procedures, Macros, and other SAS application for data extraction, data cleansing, data loading and reporting

·         Generate custom reports with line sizes, page breaks, Header message, Bottom message using PROC SORT, PROC PRINT, PROC REPORT and PROC TABULATE

·         Troubleshoots ETL issues, validates result sets, recommends and implements process improvements

·         Good analytical skills pertaining understanding a business domain coupled with excellent teamwork and strong communication skills

·         Hard working, ethical and highly result oriented. Ability to quickly grasp and apply new concepts and technologies

TECHNICAL SKILLS

Analytic Tools                                                SAS, R, SPSS, MS Excel, MS Access

Database                                                        Microsoft SQL Server 2012

Web Technologies                                         HTML

Productivity                                                   MS Office (Access, Excel, Word, PowerPoint, Outlook, Project)

Open Systems                                                C, C++, UNIX, Linux

Operating Systems                                        Windows 98, 2000, XP, Vista, Windows 7, Mac OS

Graphic Tools                                                Adobe Photoshop, Adobe Flash, MATLAB

Statistical Analysis and Models:                     longitudinal data analysis, multivariate data analysis, mixed models, hierarchical modeling, survival data analysis, probability and inference theory, sampling and estimation and etc.

PROFESSIONAL EXPERIENCE

The Rawlings Group, Louisville, KY                                                       October 2015 - Present

SAS Developer / ETL Developer / Data Analyst

The Rawlings Group is the largest and most established insurance claims recovery company in the industry and serves health plan sponsors and self-funded plans throughout the nation with a comprehensive line of paid claims recovery services. I worked on membership and claims data and was involved in the complete software development life cycle of the project. In this project, the first phase was migration of data from client data warehouse servers to application environment, second phase was to transform the required tables and flat files to SAS datasets; the third and final phase was to develop SAS analysis datasets and reports.

Responsibilities

·         Used SAS PROC SQL pass through facility to connect to tables and created SAS datasets using various SQL joins such as left join, right join, inner join and full join

·         Designed and developed Extract, Transform, Load (ETL) processes using Base SAS and Data Integration Studio to populate Data Warehouses and Reporting Data Marts

·         Building and implementing the data flows and loading the data into a SAS Analytical/Reporting data mart

·         Worked on transformations, slowly changing dimensions (SCD Type I Loader and SCD Type II Loader ), Loop transformations and defining new transformations using SAS DI studio

·         Extensively used SQL joins, append, sort, mapping and sub-Queries using SAS DI studio to simplify complex queries involving multiple tables for reporting purpose

·         Creating Stored Processes to provide the users of the Reporting Data Mart easy access to the data

·         Worked in designing and optimizing various T-SQL database objects like tables, views, stored procedures, user defined functions, indexes and triggers

·         Involved in developing, testing and writing programs and reports in SAS according to specification as required

·         Extracted data from different sources like claims data mart and text files using SAS/Access, SAS SQL procedures and created SAS datasets

·         Performed data cleaning by analyzing and elimination duplicate and inaccurate data using PROC FREQ, PROC COMP, PROC UNIVARIATE, PROC RANK and macros in SAS

·         Performed data preparation and transformation using SAS procedures to ensure data quality and consistency

·         Extensively worked on creating SAS views, SAS Indexes and SAS tables to reduce bottlenecks and processing time

·         Used advanced techniques to reduce the execution of process times in SAS

·         Involved in discussion with business user and data architects to define metadata for tables to perform ETL process

·         Prepared Ad-hoc reports through report builders and published through Report Manager

·         Troubleshoots ETL issues, validates result sets, recommends and implements process improvements

Environment:SAS DI studio, SAS/Base, SAS Enterprise Miner, SAS/Macro, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/ODS, MS EXCEL, MS ACCESS, SQL.

Union Bank, Pennsylvania, PA                                                October 2013 - September 2015

SAS Programmer / Data Scientist

The Union Bank is with a mission to support evidence-based policy making. They do this through research and analysis, seminars, policy dialogues and professional training. I conducted data research, analysis, and reporting in response to specific tasks from four project authors.

Responsibilities

·         Retrieved the original data and convert them into SAS readable format and make the SAS  data sets, analyze data as per given requirement

·         Done data mining/statistical data analysis and some involvement in delivering data mining/statistical analyses as part of group research projects, engagements using SAS and SPSS

·         Acquire, cleanse and manipulate data to enable the model building process

·         Build regression and other predictive models in SAS

·         Understand key outputs; interpret and communicate results and outputs so that they are really understood by the research community and subsequently actionable; I also made recommendations, as and when it was necessary

·         Identify other data sources in order to enhance analytics and insights

·         Collaborate with other  IT and Research teams, as needed

·         Analyzed large data sets consisting of million records using PROC SQL, PROC SORT, PROC PRINT, PROC TABULATE procedures

·         Communicated the research outcome and recommendations armed with results of data analysis to the research director

·         Developed programs in SAS to generate reports, creating RTF, HTML listings and reports using SAS ODS for ad-hoc and weekly report generation

·         Worked with complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT, PROC MEANS for creating a preferred list of customers as per the given requirements from researcher

·         Effectively prepared and published various performance reports and presentations

Environment:  SAS/ODS, SAS9.2, SAS Enterprise Guide 4.2, SAS/Macros, SAS/Graph, SAS/Access, SAS/Connect, SAS/Stat, SPSS, MS Excel, MS Access, Windows, UNIX.

Bank of Texas, Dallas, Texas                                                       April 2010 - September 2013

Statistician / Data Scientist

Responsibilities

·         Analysis CPI (consumer price index) and PPI (producer price index) data using SAS

·         Training and supervising census/ survey before and during executing

·         Collecting and disseminating data to various users

·         Organize data collection on the field

·         Routinely used advanced Excel functions to generate spreadsheets and pivot tables

·         Manage Organization reporting systems including the design, analysis, and distribution of reports using SPSS, Access and Excel

·         Performed data entry, data analysis using Excel and Access, including building charts and graphs, authoring text using Word and inserting graphics

·         Data processing and validations were done extensively on the SAS datasets using edit check programs

·         Developed reports as per business requirements and created various reports like summary reports, tabular reports, excel reports etc.

·         Converted programs from Teradata SQL to SAS to automate the monthly production processes

·         Designed and created SAS datasets from various sources like Excel datasheets, flat files, Oracle

·         Performed data preparation and transformation using SAS procedures to ensure data quality and consistency

·         Used SAS PROC SQL pass through facility to connect to tables and created SAS datasets using various SQL joins such as left join, right join, inner join and full join

Environment: SAS/ODS, SAS9.2, SAS Enterprise Guide, SAS/Macros, SAS/Graph, SAS/Access, SAS/Connect, SAS/Stat, Teradata, MS Excel, MS Access.

EDUCATION

Masters in Statistics New York University, NY

TRAINING

Statistical software: SAS, SPSS, MATLAB and R

Microsoft SQL Server 2012

Microsoft Office tools (Word, Excel, Access and PowerPoint)