Kiplangat Sutter

Phone: 860-***-****

**** ********* **

Email:

Wake Forest, NC 27587 acc9hz@r.postjobfree.com

Highlights:

* ***** ***-****, ***-SQL, SAS-MACROS and SAS stored processes.

* ***** ***king with relational databases [SQL] ( Teradata, Oracle, MySQL,Ms SQL Server).

6 years experience with advanced Excel, R/Rattle, BIG data manipulation and statistical analysis.

6 years of unix command line utilities (sed, awk, sh programming, perl one liners).

3 years in a Barclays bank as a portfolio analyst.

Work Experience

CCAR Model Analyst - Regulatory and Capital adequacy Department, M&T Bank (Novum Partners) Dec’13–

Present

• Run and maintain SAS codes for the many financial forecasting models. For example C&I Loss Given

Default(LGD) model, Commercial Investment Real Estate(CRE) bottom-up model, Originations forecasting

models and many fee-income models. All this statistical models written in SAS are used in the CCAR and

stress testing process.

• Implemented Comprehensive Capital Analysis and Review(CCAR) models in SAS to test the competency of

M&T’s internal capital adequacy.

• I implement and help support a wide range of portfolio forecasting models used in credit risk especially the

commercial C&I, CRE and fee-income models.

• Proficient in various SAS procedures like PROC REPORT, PROC FREQ, PROC PRINT, PROC MEANS, PROC

TABULATE, PROC TRANSPOSE and PROC SQL.

• Extensive use of statistical procedures: PROC ANOVA, PROC CORR, PROC GLM, PROC LOGISTIC, PROC

REG, PROC ARIMA, PROC MIXED, PROC TTEST and PROC UNIVARIATE.

• Performed scenario and attribution analysis to determine portfolio tolerance to adverse changes. This was

done in SAS using PROC REG/AUTOREG/SIMLIN/ARIMA etc with various variables and several test

models.

• Wrote efficient SAS code to iterate over various fee-income prediction models - this is part of end-to-end

process to automate the submission of reports to the Federal Reserve.

• Ensured timely submission of Consumer loan reporting, FDIC/Call-Report, FRY-9C, FRY-14 to the Federal

reserve.

• Designed, developed, and implemented data quality and data governance solutions on M&T banks portfolio.

• Loaded, extracted data from Data Warehouse (Teradata) using SQL. Build a in-house datamart for data

modelling using Microsoft SQL server.

Research data Analyst, Center for Computational Research, SUNY Buffalo, Jan’10–Nov’13

• Advanced SAS programming, optimization skills and sound knowledge in SAS-BASE, SAS-SQL, SAS-

MACROS and SAS stored processes.

• Very good experience of working with very large data sets using R/SAS and Unix shell scripts.

• Good knowledge of DBMS like Teradata, Oracle 8i/9i/10g and DB2, data warehouse architecture and meta-

data

• Implemented Apriori algorithm in python to find frequent item sets in large gene bank data. Results agreed

with a similar implementation in R (apriori).

Kiplangat Sutter 2

• Utilized Hadoop MapReduce software framework to conveniently write applications which process large

volume of biological data of in a computer cluster environment (> 8Tera Bytes of data-sets).

• Run quantum chemistry codes (i.e Quantum espresso, Gaussian, ADF ) to calculate properties of materials on

large compute clusters supported by SUNY high performance computing center of computational research

(CCR).

• Develop algorithms and implement in Amsterdam density functional (ADF) - Fortran / C++ code. Part of

this work was published in peer reviewed journals.

• Build, maintain and query an in house SQL database containing chemical data.

• Modeling accurately nuclear magnetic resonance (NMR) parameters on large and heavy nuclei systems with

biological usefulness using SAS/R.

• Present research data to group and management.

Business Analyst, Barclays Bank Jun’05–Aug’08

• Wrote and executed SAS scripts based on business needs (daily,weekly and monthly reports including adhoc

requests). Extensive use of Proc SQL and SAS MACROS to accomplish tasks.

• Utilized R to cluster customers into segments that enabled bank to have a better control of credit risk.

• Inititiated data mining approaches to improve customer base - by cross-selling to existing customers using a

combination of mainly SQL, Excel and SAS.

• Used statistical softwares R/SAS data mining capabilities to come up with association rules between prod-

ucts and services that Barclays bank offers.

• Processed and analyzed large data sets on Barclays bank emerging markets, monitor portfolio for trends and

report to management (main products home/business/premier/loans, credit cards and OTC derivatives.

• Created models for assessing product profitability, predicting customer behavior, and determining appropri-

ate product pricing.

• Developed spreadsheets, macros, queries for effective monitoring of retail credit portfolio.

• Managed the collection (SQL extraction) and review of Barclays Africa portfolio default data, which involved

the calculation of realized losses and realized exposure at default to support the banks estimation of default,

usage given default and Loss given default (LGD).

• Administered and led discussions, conference calls with management and team.

• Credit EC modeling and BASEL II implementation.

• Obtained enormous experience in using SAS, SQL teradata, MS Excel.

Teaching/Research Assistant, University of Connecticut Aug’08–Dec’09.

• Conducted a masters project on quantum mechanics/molecular mechanics (QM/MM) prediction of the stark

shift in the active site of a protein.

• Experience in molecular modeling; virtual ligand screening; computationally driven lead optimization;

ligand-based drug design; molecular dynamics; homology modeling; quantum mechanics and cheminfor-

matics.

• Teaching assistant for general chemistry and chemistry for engineers.

• Course work in Drug design, Characterization techniques in chemistry and material science, Spectroscopic

techniques, Quantum chemistry etc.

Kiplangat Sutter 3

Journal Articles

• Sutter K. and Autschbach J. Computational study and molecular orbital analysis of NMR shielding, spin-spin

coupling, and electric field gradients of azido platinum complexes. J. Am. Chem. Soc., 2012, 134 (32), pp

133**-***** DOI: 10.1021/ja3040762

• Autschbach J., Sutter K., Truflandier L. A., Brendler E. and Wagler J., Atomic contributions from spin-orbit

coupling to 29 Si NMR chemical shifts in metallasilatrane complexes. Chem. Eur. J. 18 (40), 128**-*****. DOI:

10.1002/chem.201200746

• Sutter K., Truflandier L. A. and Autschbach J. (2011), NMR J-Coupling Constants in Cisplatin Derivatives Studied

by Molecular Dynamics and Relativistic DFT. ChemPhysChem, 12: 1448–1455. DOI: 10.1002/cphc.201000997

• Truflandier L. A., Sutter K. and Autschbach J. Solvent Effects and Dynamic Averaging of 195 Pt NMR Shielding

in Cisplatin Derivatives. Inorganic Chemistry 2011 50 (5), 1723–1732. DOI: 10.1021/ic102174b

Other Experiences

• 2005: National survey with IDS UoN, data entry, coding and analysis.

• 2004: Interned at Pharmaceutical Products limited(K) in the manufacturing line of analgesics and anti-

malarials.

• 2003: Performed a social economical evaluation on HP/SAC project beneficiaries.

• 2002: Attached with Kentainers Ltd making water tanks for safe drinking water.

• 2000-2001: Kapsiliot high school mathematics, chemistry and physics teacher.

Education

• M.S. Computational Chemistry/BioInformatics

University of Connecticut(UConn), CT, USA

Aug’08 – Dec’09, GPA 3.7

• B.Sc. Industrial Chemistry & engineering

University of Nairobi, Kenya

Oct’01 – May’05, First Class Honors

Awards

• University of Connecticut - Outstanding teaching assistant award - 2009

• Barclays Bank Kenya - Colleague of the year award - 2007

• University of Nairobi - Unilever prize for best student in faculty of science - 2004/2005.

• Marakwet District best Mathematics student in the whole district - cash prize - KCPE 1995

Interests

• programming (Python/Java).

• Data science.

• Statistical (SAS/R) and BI tools (EDW, ETL etc).

• Statistical techniques

• Big data technologies (Hadoop, mapreduce)

• High performance computing

• Soccer, biking and marathon.

Contact this candidate