SUMMARY:

• Over 7 years of broad industry experience in data analysis and statistical inference. Design, development of Statistical models including data extraction and manipulation, writing macros and reporting on various projects for Financial, Banking, Insurance, Investment and Sales industries.
• Proficient in SAS/BASE, SAS/STAT, SAS/ETS, SAS/SQL,SAS/MACROS, SAS/GRAPH, SAS/INSIGHTS, SAS/ASSIST, SAS/EG, SAS/EM, SAS/ODS and SAS/ACCESS.
• Hands on experience in financial/economic modelling and analysis.
• Handled large data sets for data extraction, transformation and applying business logic rules to incoming data.
• Comprehensive skills in working with SAS/BASE, SAS/SQL and SAS/MACRO in Windows environments.
• Skilled in merging SAS datasets, macro facility, preparing data, PROC step, producing reports, SAS formats, storing and managing data in SAS files.
• Expertise in advanced SQL programming for joining multiple tables, sorting data, SQL views and indexes.
• Generate new datasets from raw data files imported or modify existing datasets using SET, SET/SET, MERGE, MODIFY, UPDATE, SQL, APPEND and HASH.
• Experienced in random sampling using SAS functions and PROC SURVEYSELECT.
• Plentiful regression experience in Logit, Probit, Panel and Time - series.
• Experienced in producing RTF, HTML and PDF files using SAS/ODS, well versed with creating HTML Reports for financial data using SAS ODS facility.
• Extensive experience in programming, debugging and report generation in SAS.
• Successfully using SAS Macro variables to improve efficiency and consistency of results.
• Thorough experience in data extraction and sorting from various databases like Oracle, DB2 and MS Access
• Solid understanding of statistical concepts and econometric techniques. Proficient use of various statistical procedures including PROC CONTENTS, PROC FREQ, PROC MEANS,PROC TABULATE,PROC GPLOT,PROC G3D, PROC BOXPLOT,PROC UNIVARIATE,PROC STDIZE, PROC MI, PROC CORR, PROC GLM, PROC ANOVA, PROC FACTOR, PROC PRINCOMP, PROC LOGISTIC, PROC CLUSTER, PROC VARCLUS, PROC TREE and other SAS/STAT or SAS/GRAPH procedures.
• Comfortable with working under deadlines.
• Excellent communication and interpersonal skills for task .

TECHNICAL SKILLS:

• C, C++, Java, COBOL, PL/SQL, VB, Oracle 8i/9i/10g, DB2, MS Access
• Teradata, SQL Server, MVS/JCL, TSO/ISPF, MVS Utilities, Unix, Linux
• Solaris, MS Dos, Windows 95/98/00/NT, HTML, ASP, JavaScript, PERL
• PERL/CGI Unix Shell scripting (Korn, Bourne), IIS 4.0 / 5.0, Apache Web Server
• Macros, Data Null, Display Manager, Data Step, Reports, Array processing, Sort
• Transpose, Tabulate, Print, Contents, Means, Chart, Plot, Univariate, Summary
• Reg, SQL, Format with picture, Copy, gslide, upload, download, Printto, Datasets
• Format, Boxplot, freq, forms, Gfont, G3D,Anova.Means.,GLM, Base SAS
• SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS SHARE, SAS/IntrNet
• SAS/ODS, SAS/Connect, SAS/AF, SAS Enterprise Guide, SAS DI, SAS Enterprise Miner.

PROFESSIONAL EXPERIENCE:

Confidential, New York

SAS Programmer

Responsibilities:

• Involved in writing code using Base SAS & SAS/Macros to extract clean and validate data from oracle tables.
• Created SAS datasets in local SAS directory using SAS DI (Data Integration) through different transformations.
• Extensively used SAS/STAT to perform analysis of variance, multivariate analysis of variance, and repeated analysis of variance.
• Created tabulate reports using Base SAS & SAS/Reports procedures.
• SAS/SQL was used for pre-processing data, SQL queries, data analysis, generating reports.
• Created SAS views from Oracle database tables using SAS/Access and writing SAS programs using Base SAS and SAS/Macros to create SAS reports.
• Designed flowcharts indicating the input data sets and the techniques that would be used (sorting, merging, etc.) to get the desired output..
• Created Different Models using Enterprise Miner (Predictive etc).
• Connect with different databases using SQL Pass Through.
• Creating ad-hoc reports.
• Wrote some scripts using shell scripting.
• Scheduling batch Jobs.
• Used SAS ODS to create HTML, RTF and PDF outputs files in the process of producing reports.
• Used SAS PROC SQL Pass through Facility to work with Oracle database.
• Retrieving Millions of Records Using different Procedures.
• Writing JCL statements (JOB, EXEC, and DD) statements.

Environment: SAS 9.1.3/9.2/Base, SAS/Macro, SAS Enterprise Guide4.0, SAS/CONNECT, SAS/Share, SAS/Access, UNIX, UDB, DB2, ORACLE 10g, SAS DI, SAS Enterprise Miner, Main Frame (MVS).

Confidential

SAS Programmer

Responsibilities:

• Imported Data from relational database into SAS files as per detailed specifications.
• Calculated risk factor for individual clients based on hierarchical demographical information.
• Assisted Structuring the WOE index for categorical variables.
• Extensively used SAS procedures such as PROC REPORT, PROC TABULATE, PROC FREQ, PROC MEANS, PROC SUMMARY and PROC UNIVARIATE for checking missing values/outliers and producing statistical summary report.
• Carried out data extraction and data manipulation using PROC SQL to create preferred tables as per business requirements.
• Developed and analyzed periodic forecasting reports using MATLAB and SAS tools.
• Prepared graphs using the modified tables for analysis.
• Successfully used SAS/STAT to perform ANOVA, MANOVA and Contingency Table analysis.
• Generated Reports, Summary tables, Charts and Graphs for different users using SAS/Graph and SAS/ASSIST component.
• Performed competitor and customer analysis, risk and pricing analysis and forecasted results for credit card holders on demographical basis.

Environment: SAS/BASE 9.2, SAS/BASE 9.1, SAS/MACRO, SAS/STAT, SAS/ACCESS, SAS/ODS, Oracle.

Confidential

SAS Programmer Analyst

Responsibilities:

• Worked on Phase I & Phase II of the Clinical Trials and analyzed.
• Produced Listings, Reports, Tabulations and Summaries of the clinical trial data using procedures such as Freq, Means, Univariate, Summary, Tabulate, Report, Transpose for statistical analysis by other Bio-statisticians.
• Provided input to planning documents such as Validation, Study Protocol and Statistical Analysis Plans.
• Extraction of data from Oracle, DB2, Access and Excel for further analysis using Proc SQL ‘Pass Through Facility’ and DDE.
• Created and implemented statistical analysis plans and specification documents; participated in database design, data collection guidelines, and logic checks.
• Conducted, documented and reported Data Validation inspection in compliance with FDA Regulations (21 CFR) and other regulatory compliance.
• Participated in designing, coding, testing, debugging and documenting SAS Programs and Macros.
• Developed SAS programs using Base SAS for tabulation counts, correlation’s and check for dispersion for normality using PROC Means, PROC Tabulate and PROC Univariate.
• Applied generally accepted Programming Standards and Techniques to assure efficient program logic and data manipulation.
• Created a SAS reports using the Data Null technique and Proc Report for NDA submission as per FDA regulations and company standards.
• Formatted HTML, RTF and PDF reports, using SAS - output delivery system ODS.
• Writing Bourne scripts to load and execute the process.
• Involved in preparing study results as well as ISS and ISE for NDA submissions using SAS.

Environment: BASE SAS V8, SAS/ACCESS, SAS/CONNECT, SAS/GRAPH, SAS/STAT, Excel, Access, Oracle8, Window NT/ 2000 and UNIX.

Confidential

SAS Programmer

Responsibilities:

• Worked on Phase II & Phase III clinical trials for the treatment of psoriatic disorders.
• Responsible for the proper coding, documentation and validation of programs/macros/procedures to produce the standardized data displays
• Establish and maintain libraries of fully documented and validated applications programs/macros/procedures which are used and recycled whenever possible to support the monitoring and reporting of data from clinical trials
• Analyze requests for application programming support and work with other departments to decide upon the appropriate computer tool to use
• Knowledge in creating Transport Format files (.xpt) for the submissions to FDA
• Converted oracle data tables into SAS data files using SAS/SQL and uploaded SAS data files into oracle tables
• Review and analyze source (raw) data and related study documentation.

  Design, develop and or quality check CDISC (Clinical Data Interchange Standards Consortium) SDTM (Study Data Tabulation Model) domains.

  Create CDISC SDTM submission deliverables (CRF {Case Report Form} annotated to SDTM domains, define.xml and define.pdf data definition tables

• Developing compliant and consistent CDISC SDTM datasets assigned in accordance with the SDF Implementation Project Plan
• Creating Validation & Derivation procedures (edit checks) in order to maintain data accuracy and track the results of the drug trail
• Developed SAS programs using Base SAS for tabulation counts, correlations, check for dispersion for normality and data validations using PROC Means, Proc Tabulate and Proc Univariate

Environment: SAS/ Base, SAS/ Macro, SAS/Access, SAS/Connect, SAS/Graph, SAS/Stat, Oracle 8, Excel and Word, Windows NT, UNIX.