SUMMARY:

• 7.3 years of experience in Reporting and analytics by using SAS, SQL and MS Excel.
• Proficient in SAS/BASE, SAS EG, SAS/SQL, SAS/MACRO, SAS/Access, SAS/STAT, SAS/CONNECT, SAS/ODS, SAS/ETS, SAS/GRAPH, and EXCEL.
• Expert in DI Studio, OLAP cubes, stored procedure, Web Report Studio, Dash boards, Visual Analytics, SAS Studio.
• Developed SAS programs generate new datasets from raw data files using Import Techniques and modified existing datasets using SQL, Set, Merge, Sort, Update, Formats and Functions using (HTML, Excel, PDF, Word, and XML) and converting various files types to SAS Datasets.
• Expertise in writing advance SQL programs for joining multiple tables, sorting data, creating SQL views, creating indexes and metadata analysis.
• Good exposure to Banking domain credit cards, Loans (personal loans, vehicle loans, home loans), collections, Retail Banking and Mortgage.
• Expertise in building mathematical and statistical models in Database Marketing, Risk Management, Loss Forecasting, Credit Scoring, Credit Risk Management.
• Time series forecasting, Risk Analytics, Clustering, Decision trees, Affinity Analysis, Text Analysis, Data Mining, Predictive Modelling and survival Analysis.
• Anova, Regression, Linear Regression, Multivariate Regression, Logistic Regression
• Proc Reg, Proc corr, Proc anova, proc risk, Proc Compile, proc means, Proc Report, Proc Tabulate, Proc univariate, proc Format, proc logistic
• Willing to relocate: Anywhere

SAS EXPERTISE:

SAS Tools: Base SAS, SAS Macros, SAS/Connect.

SAS Procedures: Import, Export, Data sets, Content, Sort, Report, sql.

SAS BI: DI STUDIO, Stored Process, Web Report Studio, Information maps, Enterprise - Miner

WORK EXPERINCE:

Confidential, Moline, IL

SAS Programmer/Senior Analyst

Responsibilities:

• Generate EI List for Alerts for the major failures. Developed SAS code to generate Reports.
• Created the stored process for standard Reports and responsible for changes in SAS MACRO code if needed.
• Creating Stored process parameters with static and dynamic input lists.
• SAS BI server Using management console for creating libraries and users and for maintaining the codes.
• Using Web Report Studio for viewing the output of Stored Process, OLAP cubes, SAS data sets and information maps and for designing layouts.
• Creating information maps for giving access of data to different sources SAS Information Delivery Portal (IDP) and dash boards.
• Creating Queries in information maps.
• Using Enterprise-Miner for Text Analytics, to get the text-themes which are useful in Root Cause Analysis of the failure.
• Helped the team to Automate Supplier Analysis Report using Proc Report and PROC SQL to save time and reduce manual errors.
• Created Reports Using SAS Visual Analytics. VA Explorer, VA Data Builder, SAS Visual Analytics Designer.
• SAS Visual Analytics Administrator tasks Dashboard Style Reports working with Interactions, Sections, Containers, and Links add Controls, Parameters, and Prompts.
• SAS Visual Analytics Bar Charts, Bubble Plots, and Tree maps, Use Decision Trees, Word Clouds, and Text Analytics Use Network Diagrams and Geo Maps

Environment: E-Miner, STORED PROCESS, SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACRO, SAS/ACCESS, MS EXCEL, Visual Analytics (VA 7.1, 7.2, 7.3)

Confidential, New York, NY

SAS Analyst/Consultant

Responsibilities:

• Involved in collecting the data from SQL by using SQL-pass through facility.
• Validating, cleaning and imputing missing values.
• Gathering the historical data of applicants from credit bureau and making it useful for the model.
• Interacting with the credit policy team to gather the requirements and policies.
• Using PROC GPLOT for generating graphs.
• PROC RISK and PROC COMPILE for estimating the risk.
• Building the credit card scoring model. Guiding the underwriting team.
• Created dashboards in Tableau extracting data from different sources.
• Tableau Using parameters, sets, groups, calculated fields and hierarchies.
• Tableau Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Tableau Involved in creating data blending in case of merging data from different sources.
• Created a dual-axis bar chart with multiple measures.

Environment: SAS/BASE, SAS/EG (4.1, 4.3, 4.5), SAS/SQL, SAS/MACRO, SAS/ACCESS, MS EXCEL, Stored Process, Tableau, Enterprise Miner, pivot tables

Confidential, New York, NY

SAS Analyst

Responsibilities:

• Connecting to Teradata writing queries to extract data.
• Creating job using DI STUDIO for extraction of data and joins.
• Using Transformations FILEREADER & FILE WRITER, SQL JOIN, LOADER. involved in extracting the data from server and importing the text and csv files
• Developed model for loss forecasting using LGD model.
• Validating the model with the recent data. Scoring the model after validation.
• Proc score for scoring the data.
• Prepared the report using proc report and sending automated emails of report.
• Developed the macros for reducing the manual interaction.

Environment: DI STUDIO, EG (4.1, 4.3, 4.5), SQL, MACRO, MS EXCEL, Tera Data

Confidential

SAS Analyst

Responsibilities:

• Developed the sas code to extract the data from oracle, Excel and CSV files by using Proc sql and Import procedures and by using INFILE statement.
• Advanced statistical methodologies applied in Pharmaceutical and Biotech industries.
• Expertise in analyzing and reporting various phases (Phase I-IV) Of Clinical Trials using tools like BaseSAS, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/MACRO, SAS/ACCESS and SAS/ODS in UNIX and Windows environment.
• Working knowledge ofGeneral linear models, Categorical data analysis, Survival analysis, Multivariate analysis,Design of experiments, longitudinal data analysis, randomized trial designs and survey design and analysis.
• Experience in providing statistical support for clinical studies, includingdesign of studies,selection of appropriate statistical methodologies and tests,sample size and power calculations, randomization,statistical analyses, and interpretation of results.
• Conduct extensive analytical exercises; Deliver daily, monthly, quarterly, ad-hoc reports covering the global data environment.
• Development, validation, enhancement and tracking of MI for risk management.
• Work closely with departments to validate/confirm data for official announcements to risk management committee.
• Used SAS/Macros facility to provide reusable programs to create periodic reports with minimal chance of errors.
• Conduct extensive global portfolio trend overview on new businesses.
• Analyze existing customer's data quality, activities, delinquency performance and loss performance.
• Work with key stakeholders in the business and present solutions/output in a logical and consistent format.
• Working together with Finance, Loss Mitigation, Pricing and Operations to implement various Projects, Analysis, and Reports.
• Implemented project management methodology in daily work activities.
• Experience inreviewing case report forms CRF’s/SDTM/ADaMto ensure that the protocol objectives are met and the project standards are maintained.
• Working knowledge ofmedical terminology in clinical trials, clinical trial methodologies, and software systems development.
• Exposure toCDISC Standards,21 CFR Part 11, GxP guidelines,Bioethics, IRB guidelines,HIPAA guidelinesand Regulatory Submissions(CSR, BLA, NDA, including ISE and ISS).
• Efficient in maintaining working relationships with clients and internal project members, including data managers, research scientists, and other statistical programmers.
• Experience in developing and maintainingstatistical documentation,including description of statistical methods,SAS programs, results and discussion.
• Documented, summarizedand recorded data as per standard operating procedures(SOPs)andFDA regulations.
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
• Effectively developed SAS code for modeling data and implemented SAS/STAT procedures such as Proc Lifetest, Proc lifereg, Proc Phreg, proc reg and Proc Glm for Survival analysis, logistic regression analysis and other statistical analyses.
• Produced Ad hoc reports of various kinds like Listings, Tables, and Figures (TLGs/TLFs) using Proc Report, Proc Tabulate, Data Null technique, Proc Gplot etc.
• Used SAS ODS to report outputs in different formats like RTF, PDF, and HTML
• Validated analysis data sets and SAS outputs with other programmers’ outputs and mockups in SAP using PROC COMPARE, PROC CONTENTS, and PROC FREQ. Created formats for the coded data and used PROC SQL for data validation.
• Documented, summarized and recorded data as per standard operating procedures (SOPs) and FDA regulations.

Environment: SAS 9.1, SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACRO, SAS/ACCESS, SAS/ODS, MS OFFICE