SUMMARY

Over 6 years of experience on data analysis particularly for massive and high throughput data statistical modeling.

Extensive knowledge of statistical models including general linear model survival model time-series model and mixed models experimental design categorical data analysis Bayesian techniques for data analysis in finance ARCH/GARCH/Integrated GARCH Models and

Stochastic Volatility Models in financerisk management.

Developed Adhoc queries and Reports using Oracle SQL PL/SQL and UNIX to fulfill business analysis data requests.

6 years of experience in SAS procedures Macros Preparing Data PROCs Producing Reports SAS Functions SAS Formats/Informats Storing and Managing Data in SAS Files.

Experience in SAS/BASE SAS/SQL SAS/MACRO SAS/GRAPH SAS/ACCESS SAS/ODS and SAS/ENTERPRISE GUIDE.

Ability to understand and write SQL and Stored Procedures in Oracle and SQL Server

Experienceincludesdevelopmentand integrationof database.

Proficientwritten and verbal communicationin Englishas well as interpersonalskills.

TECHNICAL SKILLS AND CERTIFICATIONS

RELATED EXPERIENCE

Designed the algorithms for count comparisons and wrote Perl scripts for statistical tests like Fisher s exact test Binomial test and logistic regression analysis to figure out the global warming effects on plants based on the gene sequencing database nearly 20 000 samples .

Installed mathematical and statistical modules in LINUX/UNIX server and carried out the routine maintenance on them.

Wrote certain Shell scripts on Linux server to run corresponding Perl scripts and got the desired results from remote computer by SSH Clients.

Wrote several SAS Macros in the course of performing logistic regression analysis for global warming factors CO2 and higher temperature and their effects on plant.

Performed statistical analysis by SAS PROC TTEST/ ANOVA MANOVA MANCOVA SAS/MACROS and SAS/SQL on the massive and highly complex sets and Tukey s multiple comparisons to get optimal settings.

Independently conducted the experiment design on the project of the effects of Bt and Non-Bt maize on termite by SAS PROC FACTEX.

Made generalized multiple linear regression MLR analysis on the data sets to predict the optimal model for the effects of Bt on termite via SAS PROC GLM SAS/GRAPH.

Reported the results usingSAS/IML.

Wrote R scripts for Marchkov Chain Monte Carlo MCMC simulation study on risk forecasting of Microsoft and S P 500 Index by using GARCH/IGARCH/ARCH Models comparing with Stochastic Volatility Models.

Environment PL/SQL SQL SAS R Perl Shell Scripting Excel Windows NT UNIX.

Designed Algorithms for generating random numbers following desired distributions and Wrote R code for Monte Carlo Simulation analysis of the significance of relationships between two random variables and the covariance of them.

Performed SAS PROC FACTEX for experiment design of the relationship between the dose of Aspirin the temperature of waters and the hours of relief from migraine headache.

Analyzed and manipulated the complicated data sets by SAS /PROC GLM PROC REG PROC UNIVARIATE PROC ANOVA and PROC REPORT.

Conducted the Principal Component Regression and Cluster Analysis PCA of 8 rice production related traits based on a large data sets totally almost 1 000 samples to screen key factors and predicted the general linear regression model by R programming.

CreatedpermanentformattedSASdatasetsusingSAS/SQL SAS/BASE SAS/MACROS

SAS/GRAPH and SAS/STAT.

Extensively used procedures like PROCFREQ PROC MEANS PROC SORT PROC PRINT

PROC COMPAREand PROC EXPORT.

Usedbootstrapandothernon-parametrictechniques particularlyforsmallsamplesizewith

missing value data sets derived from cellular toxic treatment experiments.

Designed Post-hoc Multiple Comparison analysis on Apoptosis related induction factors to screen the potential key factors and Multivariate Regression analysis to predict the general quantitative model of Apoptosis induction by SAS / PROC GLM SAS/GRAPH.

Developed reports using PROC REPORT PROC TABULATE PROC FORMAT for analysis. Performed testing and debugging against the test data and assured quality and standards for the

code changesmade using SASvalidatestatement.

Used SAS extensively for match merge append data validation and data correction and cleansing.

Produced HTML PDF and RTF outputs using ODS.

Writing analysis plans including specifications for table listings and graphs supporting it from the raw data taken using SAS/GRAPH.

Used ODS statements and PROC TEMPLATE to create reports in style format. Ran monthly reports.

Environment SAS PL/SQL SQL Windows NT UNIX.

Designed and developed the ARP employee registration and salary system derived from Oracle database.

Analyzed the salary and wealth distribution data sets of the institutes more than 4 000 people in MS Excel and wrote the monthly report for the analysis result.

Developedthe Interfaces in SQL for data calculationsand data manipulations.

Programs made for the data from the studies and surveys conducted to summarize and analyze complex financial actions using SAS/SQL.

Experience in Power Point presentation Financial data charts .Used the MS Excel MS Access for data pulls and ad hoc reports for analysis.

WorkedwithCampaignsManagerduringrequirementsgathering businessintentcreationand

Campaign execution.

Performed Verification Validation and Transformations on the Input data Text files before loading into target database.

Extracted data from existing data stores developing and executing departmental reports for Performance and response purposes by using oracle SQL MS Access MS Excel.

Extracted data from existing data stores and performed ad-hoc queries. Developed and maintained the MSACCESS database and applications.

Performed in depth analysis in data prepared weekly biweekly monthly reports by using SQL

SAS MS Excel MS Access and UNIX.

Worked with business analysts senior project managers and programmers to gather business requirements and specifications.

Designed developedvariousAd hoc reports for salarysystem OracleSQL MS Access .

AssistedinpreparationandprepareddocumentsandtechnicalspecificationsusingMicrosoft

Word and Visio.

Responsibleforunderstandingbusinessanalysisconceptsforlogicaldatamodeling dataflow

processingand data base design.

Created SQL files indexes and calculated the table spaces for each table tuning the SQL queries based on plan tables . Grant and revoke table access to users.

Designed developedvarious Ad hoc reports for the finance SAS/SQL MS ACCESS and MS

EXCEL .

Environment Oracle 8g PL/SQL SQL R Shell scripting Excel UNIX.