Professional Summary

• 6 years of experience in database management, data mining, predictive analytics and data analysis.
• Worked with datasets from Finance, Marketing, Health Care and Service Industries.
• Sound statistical knowledge to interpret and diagnose models and make valid conclusions from volumes of data and present it to non-technical teams.
• Experience in working with SAS Enterprise Guide Software 4.1 5.1 versions for reporting and analytical tasks
• Developed and managed market segmentation studies, marketing studies, econometric models and revenue forecasting
• Knowledge of advanced concepts of MS Excel such as pivot tables, graphs and advanced functions VLOOKUP, IFELSE, etc. and Macros.
• High-level experience in Base SAS, SAS/Macros, SAS/SQL, SAS/Stat, SAS/Connect, SAS/Access, SAS/Graph, SAS/ODS, SAS/OLAP, SAS/EBI, SAS/Grid, SAS Visualizer, SAS/ETS and SPSS modeler.
• Built data driven customer strategy in CRM using targeting, segmentation, royalty, RFM and life time value.
• Experienced in data preparation for various statistical modeling, which includes data cleansing, descriptive statistics, missing data analysis, data validation and preliminary data reporting
• Performed predictive Modeling, Pattern Discovery Market Basket Analysis, Segmentation Analysis , Regression Models, and Clustering.
• Proficiency in Time Series and Forecasting techniques using SAS Enterprise Miner.
• Good Knowledge of the mortgage lending lifecycle.
• Strong skills in Data Analysis, Data Requirement Analysis, and Data Mapping for ETL process.
• Extensive experience to handle Large Teradata for Data Cleansing, Data Profiling and Data Scrubbing.
• Experience in utilizing SAS Procedures, Macros, and other SAS application for data extraction using Oracle and Teradata , defining the metadata, checking the data quality, data profiling, data cleansing, data loading and reporting.
• Involved in coding and pulling data from various oracle tables using Unions and Joins.
• Calculate the one-way frequencies, multi-way frequencies for counts of variables and table analysis using PROC FREQ with LIST, OUT, MISSING options.
• Customize the variables to user-defined Formats using PROC FORMAT in printing reports.
• Generate custom reports with line sizes, page breaks, Header message, Bottom message using PROC SORT, PROC PRINT, PROC REPORT.
• Analysis, Decision Tree, Trend and Pattern Analysis, Classification models, Neural Networks.
• Knowledge about Markov-Chain Monte-Carlo MCMC simulations like Gibbs Sampling, HM MCMC simulation of stock price volatilities and general Monte-Carlo simulation and bootstrapping of parameters of financial time series models.
• Good knowledge of Basel 2,2.5,3 CCAR and Dodd-Frank Act.
• Experienced in statistical analytical methods like Correlations analysis, ANOVA, t-tests, market basket analysis, etc.
• Hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS ORACLE, Teradata tables using LIBNAME and SQL PASSTHRU facility.
• Well versed with BI tools like Tableau, SPSS, SAP, SAS, Micro strategy, IBM modeler, Excel, JMP etc.
• Highly motivated, detail oriented, proven ability to work independently.
• Excellent Technical, Analytical and Leadership skills in motivating others.
• Excellent Interpersonal, Presentation and Communication skills with problem abstraction and ability to work effective.

Tools and Technologies

• Programming Languages: Base SAS, C, C , JAVA, Visual Basic, Android Programming, SAS 9.1 Programming , SAS/Stat,SAS Macros
• Web technology languages: HTML, XML ASP.NET, CSS, JavaScript, XHTML
• Project Management: MS project 2010, Base Camp
• Reporting tools: Microstrategy, Cognos, and ESRI.
• Statistical Tools : SPSS IBM Modeler, Rapid-miner, SAS enterprise miner/Enterprise Guide 9.3, JMP 10, SAS Forecast Server, MS Excel, Tableau.
• Operating System: Microsoft Windows 98/2000/XP/2010/7, UNIX, LINUX, MAC OS X
• Database Systems Tools: SQL server, MS Access, DB2.
• Other Softwares: MS Office 2000/XP/2007/2010, MS Project, SAS 9.3, MS VISIO, Visual Studio 2010,Dreamweaver, Gliffy, Photoshop, Macromedia Flash, Open ERP
• Data Mining Tools: SAS Enterprise Miner, Rapid Miner.

Work Experience

SAS Programmer at Fulton Bank of NJ, NJ Jan 2013-current

• Performed model development for estimation of credit risk of customers with respect to finding the PD probability of default of the customers and implement process to utilize analytical models in business decision making. Worked with teams to build models in order to the value of find out EAD Exposure at default , LGD Loss given at default and analyze the results.
• Conducted research and develop financial analytics performed ad hoc model development specific for analysis of credit risk using SAS
• Conducted multivariate segmentation analysis, data modeling, performance analysis and forecasting using RStudio and SAS.
• Utilized SAS Enterprise Miner for market mix modeling, segmentation and market basket analysis and clustering techniques to produce monthly and quarterly reports.
• Conducted analysis to resolve business issues and assisted in preparing firm communication materials for internal and external audiences. Examples include: risk issues, vendor negotiations, and senior management presentations.
• Reviewed market data to verify integrity and consistency for completeness, accuracy and suitability and implemented business logics to solve the performance issues.
• Created data set and utilized SAS data and procedural steps of Base SAS programming codes to import data into SAS and analyzed these data for with various statistical methodologies and manipulation for management.
• Develop and coordinate analytics and quantitative modeling associated with risk rating system.
• Create scoring and recovery models for mortgage business and home loans using SPSS modeler.
• Set methods and procedures for model estimation, validation and data requirements.
• Use SQL skills to perform ETL for Teradata databases and created data sets, perform transformations on variables, model creation, validation and optimization through scoring.
• Extracted data from the database using SAS/Access, SAS/SQL procedures to create datasets.
• Scripted SAS programs with the use of Base SAS and SAS/MACROS for transferring and converting data character to numeric and numeric to character from Excel files to another to be used for further analysis and created global and local variables.
• Created reports using analysis output and exported them to the web to enable the customers to have access through internet using SCL and used tools like tableau.

SAS analyst

Confidential

• Conducted statistical analysis such for clustering the customer database.
• Identified segments and effectively used it for direct marketing campaigns.
• Forecasted impact of direct market campaigns for acquiring, developing and retaining customers.
• Undertook data or record collection, data cleansing and coding, data aggregation and validation, model development and scoring, predictive analysis and postmortem analysis of the model using R, SAS and Excel.
• Integration of Data from MHS Source Systems Claims/Service Lines/ Members
• Used SAS Stored Processes to deliver content to the portal and used SAS Web Report Studio to deliver the same through the SAS Management Console.
• Integration of Data from MHS Source Systems Claims/Service Lines/ Members
• Used SAS Stored Processes to deliver content to the portal and used SAS Web Report Studio to deliver the same through the SAS Management Console.
• Produced reports using PROC GCHART, PROC REG, PROC TTEST for analysis and used UNIVARIATE and MULTIVARIATE ANALYSIS as Forecasting Methodologies also used the SAS Forecast Studio for speedy analysis of Forecast Models.
• Generated customized reports using SAS/MACRO facility, PROC REPORT, PROC TABULATE and PROC SQL.
• Data processing and validations were done extensively on the SAS datasets using edit check programs.
• Performed model validation through k-folds Cross-Validation, Leave-One-Out-Cross Validation LOOCV in SAS environment and partition of data into training and testing data or sets prior to the commencement of model development.
• Developed advanced multivariate statistical methodologies like regularized multinomial logistic regression, discriminant analysis, principal component, cluster analysis etc.
• Retrieved the data from flat files received from the vendors and converted to SAS data sets using DDE functions for analysis using SAS/STAT procedures such as PROC MEANS, PROC SUMMARY, PROC REG, PROC UNIVARIATE and PROC ANOVA.
• Generated plots and used the visualization tools like Tableau.

SAS Analyst

Confidential

• Generated highly customized reports in the form of listing, HTML, RTF and PDF using SAS ODS, PROC REPORT, PROC TABULATE, and PROC SQL.
• Involved in discussions with business users and data architects to define metadata for tables to perform ETL process.
• Extracting data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Worked to increase the client base of the company through market analysis, PCA and logistic regression of existing customer data using SAS Enterprise Miner, which was immensely helpful for the company's sales and marketing campaigns.
• Modifying data using SAS/BASE, SAS/ MACROS.
• Presenting data using graphs, tables, charts with data visualization tools like Tableau.
• Fitting various statistical models such as Generalized Estimating Equations GEE , Generalized Linear Model GLM , Mixed models, Non-linear mixed models, Analysis of Variance ANOVA , Regression models, etc.
• Worked using various SAS report generating procedures such as PROC FREQ, PROC MEANS, PROC TABULATE, PROC ANOVA, PROC SUMMARY, PROC REPORT, PROC SQL, PROC MIXED, PROC GENMOD, PROC NLMIXED, PROC GLIMMIX, PROC UNIVARIATE, PROC TRANSPOSE, and PROC GLM.
• SAS Programmer /Analyst at Symbiosys Technologies, Confidential
• Used the SAS system to design and implement a general analysis system for data entry, statistical analysis, graphical presentation, and report generations.
• Extracted and integrated data from different sources Primary and Secondary , used tools like Oracle and Teradata and text files using SAS/Access, SAS SQL procedures and created SAS datasets.
• Extracted data from the database by SQL PASS THROUGH FACILITY and LIBNAME facility.
• Created reports in RTF, PDF, Excel and HTML formats using ODS statements.
• Conducted research and developed financial analytics performed ad hoc model development specific for high level quantitative analysis using SAS. Created Workflow Diagrams, UML diagrams, Activity Diagrams, Use Cases, Swim Lanes, for incorporating design changes.
• Documented the developed macros explaining the functionality of the macro and the macro parameters defined for future reference.
• Created Summary tables using procedures like PROC TRANSPOSE, SORT, FREQ, MEANS, SUMMARY, UNIVARIATE, AND TABULATE.
• Gave presentations on different courses of statistics such as Introductory Statistics, Probability, and Multivariate Data Analysis to other team members.