Data Management

Shaw Chang

*** ** **** ****, ***. *A, Forest Hills, NY 11375

******@*****.*** 917-***-****

QUALIFICATIONS

• Experienced Senior Director with extensive capability and success in implementing cost-effective

innovation solutions with project proficiency in R&D, analysis, data-flow, infrastructure, operation,

reporting, maintenance of systems and database, research development and application support.

• Data and System Information technology Expert with an in-depth understanding of major financial

transaction data for credit card, retail bank, risk management, investment, marketing and decision

management; bank data analysis, MVS mainframe data processing, SAS/SQL program reporting,

Business Intelligence (BI) dashboard management and statistical analysis.

• Proven track record of credibility and reputation for effective team collaboration, idea exchange,

technical knowledge mentoring and multi-cultural employee management.

EXPERIENCE

Sr. Director of Research IT / Director of World Trade Center (WTC) Data Management

Mount Sinai Health System, New York

(2008-2014)

• Managed application support, development, data management and reporting teams,

worked with vendors to manage all projects, applications and data warehouse in a timely

manner to support 3,000 users with 900 Principal Investigators in GCO, IRB, IACUC,

Cancer Institute, Clinical Trials, other offices, institutions and 60 departments for yearly

$677 million in grant submissions, $300 million in awards and financial tracking through

Electronic Research Administration System (ERAS) throughout Mount Sinai.

• Managed data analytics and financial reports with company standards using BI dashboard reporting

tools, WebFocus Studio, OBIEE/Oracle, Crystal Report, SQL and Excel to accomplish hundreds of

reporting projects for executives, senior management and business offices every year.

• Managed federal World Trade Center Medical Monitoring and Treatment Program in clinical

web application development, multi-system consolidation and major clinical data

management for over 45,000 patients in 6 Clinical Centers in tri-state area.

Managed Four Teams:

1. Informatics, Operations and Analysis – coordinated all CCs data entry systems and requests.

2. Application & Database Management – developed, maintained and organized trouble-shooting.

3. Data Analysis & Reporting – delivered SAS/SQL reports to CDC/NIOSH and CCs regularly.

4. Infrastructure Support – system design and maintenance, network support and data security.

VP / Sr. Manager of Technical and Data Solutions, Citigroup, New York

(2006-2008)

In charge of data, system and information technology in Integrated Business Solutions of Decision

Management for Retail Distribution North America net income of $2.2 billion through alignment of

business plans, data, program, system control, key analytic development and project efficiency for

CitiBank and CitiFinancial.

• Implemented and developed CitiBank’s new online e-Savings product strategy in a routine monthly

large data process and data quality control using SQL, SAS, macros and Excel to generate monthly

analysis reports on P&L product view, customer view, accounts change, dollar in-flow and out-flow

calculations grouped by all channels, reported to senior executives and Citibank CFO.

• Designed and Accomplished retail transaction data process and ETL method in various systems to

develop a monthly data process and quality control for Funds Destination and Time Series Funds

Flow (including Mantas/AML).

• Provided retail portfolio analysis, stat models, fees, branch locations, call centers for CitiFinancial.

• Instructed and trained analysts in mainframe, Unix, SAS, SQL and other bank used technologies.

Tech Director, JPMorganChase & Co. / SciTech Consulting Corp., New Jersey

(2003-2006)

Tech Lead on Executive Committee Investment project - Remarkable Contribution:

Built an automatic application system in infrastructure design, data extract and ETL (JCL/SAS/SQL) to

process huge-scale daily raw credit card transaction data in batch job and to smartly combine with 7-

10 years historical data, calculated and analyzed with return codes by statistical models in UNIX from

mainframe, Cobol, DB2 and Oracle databases, predicted the Census Bureau retail sales weekly and

monthly (even daily) in order to forecast market trends for millions dollar trading.

Sr. Consultant, JPMorganChase & Co. / Fujitsu Consulting Inc., New York

(1999-2003)

At the highest technical level to support Risk Management, Decision Science,

Marketing and other departments in Credit Card Services (CCS) Organization:

• Defined solutions to process billions data records in MVS mainframe and UNIX; transported

and delivered data marts, cubes, analysis reports from different systems; set up Y2K

compliance rule.

• Designed, executed and delivered data marts, data cubes, reports, simulations, queries

and longitudinal studies to many senior business managers throughout all CCS

departments.

• Analyzed credit card data, produced summary and univariate descriptive statistics,

computed correlation coefficients between variables and fitting linear logistic regression

models, used SAS/STAT statistical analysis procedures to create all reports in pc, UNIX and

MVS platforms.

• Made all technical decisions for Credit Card Policy Department projects and data on

portfolio, segment, CLI, CLD; designed business program architecture to automate routine

data analysis for MIS and P&L reports; set up standard calculations for Dollar Loss rate,

Unit Loss rate, Revenue, Ram, Balance Attrition, Loan Loss, using SQL, SAS, BO in UNIX

and MVS mainframe from DB2.

• Designed credit card data flow and program routine operation procedures for Fraud

Prevention Department projects on Visa, Master and Discovery data as Falcon data and

Rap data using JCL, SAS, Cobol, Syncsort in MVS/TSO mainframe with Extra, Visio and

Excel.

Tech Lead / Consultant, Merck & Co / Charterhouse Systems Group, Inc., New Jersey (1996-1998)

Responsible for highly visible Fosamax Drug all phases clinical study submission to FDA approval

1. Retrieved all phases large-scale raw clinical data from OMNIS system into SAS data sets

2. Created over 500 SAS programs including 2 macro libraries compiled with Merck’s SOPs

3. Delivered all production of clinical safety reports, safety/efficacy tables and listing reports

TECH SKILLS

System: IBM Mainframe, Unix (AIX), MVS/TSO/ISPF, VM/CMS, VAX/VMS, CYBER/FSE, etc.

Language: SAS, SQL, JCL, SyncSort, Basic, Cobol, Fortran, Html, ASP, CSS, Java Script, VB Script

Database: Oracle, RDBMS, SAS, UDB, DB2 and Data Warehouse

Software: WebFocus Studio, OBIEE, Business Objects, Extra, Hummingbird Exceed, Reflection,

FrontPage, Graphics, InterDev, Lab Calc, MS Office, ODBC, SilverStream, Visio, etc.

EDUCATION

Ph. M. Biophysical Chemistry, New York University

M. S. Physical Chemistry, New York University

M. S. Applied Physics, Shanghai Jiao Tong University

B. S. Chemistry, Fudan University

Certificates Six SAS Certificates - SAS Institute

Two BI Reporting - Information Builders

Contact this candidate