SUMMARY

• Over 6 years of Experience in market/risk analysis, financial analysis, healthcare data analysis, to compile and analyze large data sets including data step processing, data mining, data manipulation, macro creation, data transformation, variable construction & Optimization
• Extensive professional experience in Bank Marketing, Credit Risk Analysis.
• Strong background in statistical techniques such as Correlation and Regression including Multiple regression, Logistic Regression, Multivariate Analysis, ANOVA, Forecasting, Time series Analysis, Factor Analysis.
• Extensive exposure on every steps of entire project life cycle including data collection, query, modifying and analysis, summary of findings, communicating strategic insight and presentation of results and documentation of the processes. Involved in the logical data modeling by oracle data modeler.
• Proficient inSAS v8.2/v 9.2/9.1.3/9.1, SAS/BASE, SAS/MACROS,SAS/Connect, SAS/SQL and SAS/ODS.
• Extensively worked on various RDBMS likeOracle, Teradata, DB2 and SQL Server.
• Experience in carrying out Marketing Campaigns and evaluating customer information
• Extensive Experience in arranging and participating in meetings with Business Users and suggesting recommendations for improving system performance.
• Proven skills in, data archival, data migration, ad - hoc reporting, and coding using SAS on various environments.
• Extensive programming experience with PROC SQL, PROC REPORT, PROC ACCESS, PROC GPLOT, PROC GCHART, PROC FORMAT, PROC TABULATE. Extensive experience in SAS/STAT procedures such as PROC REG, PROC GLM, PROC FREQ, PROC MEANS, PROC MIXED, and PROC UNIVARIATE.
• Involved in all stages ofSDLC(Software Development Life Cycle).
• Thorough Knowledge and experience inMicrosoft Officetools likeMS Access, MS SharePoint, MS word, MS PowerPoint, MS Excel.
• Proficient in operating tools likeWindows XP/NT, UNIX, Linux and MVS.
• Experienced in using SAS ODS to create output data sets and RTF, HTML, PDF, CSV files.
• Excellent communication and interpersonal skills.
• Proven abilities in establishing effective task priorities as a team player with result oriented attitude.

TECHNICAL SKILLS

SAS Programming Tools: BASE/SAS, SAS/STAT, SAS/MACRO, SAS/GRAPH, SAS/ODS, SAS/ACCESS, SAS/SQL, SAS/Enterprise Guide, SAS/ETL

Programming Languages: SQL, C

Databases: Oracle, MySQL, MS-Access

Application Software: MS Office 97/2000/2007/2010

PROFESSIONAL EXPERIENCE

Confidential, Johnstown, PA

SAS Programmer - Credit Risk Analyst

Responsibilities:

• To convert the Teradata SQL code to SAS /SQL code to optimize and automate the process and run monthly production. Used SAS and SQL skills to perform ETL from Oracle and Teradata databases and created SAS datasets, SAS macros, Proc/data steps and SAS formats as required.
• Developed various reports like summary reports, tabular reports, excel reports etc., as per business requirements and created.
• Worked with credit bureau, Acxiom demographics, IXI asset data, etc with internal data to achieve the Credit market intelligence for customers and prospects to better understand the consumer credit market.
• Converted programs from Teradata SQL to SAS to automate the monthly production processes.
• Developed new/modified macros for report generation using SAS / Macros as per business requirements.
• Designed and created SAS datasets from various sources like Excel datasheets, flat files and Oracle, created reports and files from existing SAS datasets.
• Developed SAS programs for statistical analyses and data displays.
• Used procedures such as PROC REGRESION, PROC FREQ, PROC FORMAT, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE AND PROC REPORT.
• Worked on various SAS products SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS to develop solutions.
• Developed programs in SAS to generate reports, creating RTF, HTML listings, tables and reports using SAS ODS for ad-hoc report generation.
• Implemented consumer Credit Risk Analysis reporting system based on Fico Scores and data management principles, such as joining data set, indexing, data aggregation, record selection, sub-setting, multiple records per case, creation and modification of views, accessing multiple databases.

Environment: SAS/ODS, SAS9.2, SAS Enterprise Guide 4.2, SAS/Macros, SAS/Graph, SAS/Access, SAS/Connect, SAS/Stat, Db2,Teradata, MS Excel, MS Access, Windows.

Confidential, Highland Heights, OH

SAS Programmer/analyst

Responsibilities:

• Created SAS data sets by extracting data from Oracle database and flat files using Proc SQL, Proc Import, SAS Data Step, cleaned, validated and manipulated data by SAS and SQL.
• Analysis, programming and creation of reports on existing strategies using SAS and SQL. Merging (large data sets) according to the requirement, generate the reports using SAS/ODS and analyze those results.
• Worked on various SAS products SAS/BASE, SAS/SQL, SAS/STAT to analyze large datasets, SAS/ACCESS and SAS/MACROS to develop business strategies.
• Conducted statistical analyses using linear and nonlinear regressions (ProcReg and Proc NLIN), logistic regression (Proc Logistic), and general linear models (Proc GLM).
• Converted the code in the fast count language (FCL) to the SAS. Explained the marketing team the easy way to convert the FCL code into the SAS
• Created reports including tables, listings, and Graphs by using Proc TABULATE, Proc SUMMARY, Proc FREQ, Proc REPORT, and Proc GPLOT.Standardized on-going reports and created ad hoc reports.
• Perform updating data by weekly and monthly and maintain, manipulating the data for database management. Used the SAS/MACROS for the monthly production.
• Worked on credit risk analysis to figure out the customers to offer the insurance products. Helped the analytics and data services for the development of the new business logic.
• Involved in the logical data modeling by oracle data modeler.
• Extensive use ofDATA NULL, TRANSPOSE, UNIVARIATE, SUMMARY, MEANS, FREQ, SQL and GPLOTprocedures.
• Coordinated and mentored other SAS programmers, technical assistance and trouble shooting and attending project team meetings. Supported Project Teams as assigned during project life cycle.

Environment:, SAS9.2, SAS Enterprise Guide 4.2, SAS/Macros, SAS/Graph, SAS/Access, SAS/STAT, SAS/ODS, SAS/SQL, Oracle, MS Excel, MS Access, Windows, UNIX.

Confidential, Cincinnati, OH

SAS Developer

Responsibilities:

• Extraction of data from Oracle, created into datasets. Performing datavalidation, transformingdata from RDBMS oracle to SAS datasets.
• Transformations using Base SAS Procedures & Functions.
• Responsible for the cleaning, reformatting, analysis and loading the data into the database.
• Developed new or modified SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
• Produced RTF, MSWORD and HTML formatted files using SAS/ODS to produce reports for presentation and further analysis.
• Developed SAS MACROS for reduction of program length and for faster execution.
• Combined and grouped datasets using concatenation and merging.
• Creating permanent formatted SAS data sets and developed reports using Proc Report, Proc Tabulate and DATA NULL for analysis.
• Extensively usedvarious Base SAS procedures like Proc SQL, Proc Summary, Proc Format, Proc Print, Proc sort etc for reporting purposes. Used SAS procedures for Importing and Exporting data to MS-Excel.

Environment: Base SAS 9.2, SAS/Macros, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, Oracle 9i, SQL, MS Excel and UNIX.

Confidential, San Francisco, CA

SAS Programmer

Responsibilities:

• Accessed and analyzed the data based on the requirement.
• Analyzed the data using SAS/STAT procedures
• Analyzed large data sets consisting of million records
• Prepared Ad Hoc reports based on the requirements from risk management team by joining multiple database tables.
• Extracted data from different internal and external resources, including demographic and credit variables along with payment history
• Worked alongside the project manager in making recommendations on model assumptions and construction.
• Responsible for tuning SQL queries to get better performance from time to time.
• Modification of SAS code in windows environment based on the updated specifications for improving the performance.
• Developed SAS programs based on the drafts specification document.
• Modification of existing SAS programs and created new programs using SAS Macros variables to improve ease and speed of modification as well as Consistency of results.

Environment: SAS 9.1.3 (Windows NT), SAS/ Base, SAS/Graph, SAS/STAT, SAS/Macros, SAS/ODS.

Confidential, River woods, IL

SAS Programmer

Responsibilities:

• Performed ETL-Extraction/Transformation/Loading, data migration, sampling, data preparation, graphical presentation, statistical analysis, validation, reporting, and documentation.
• Extracted data from different sources like Oracle and Teradata and text files using SAS/Access, SAS SQL procedures and created SAS datasets.
• Used SAS procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE AND PROC REPORT in order to understand and prepare the data
• Developed and designed SAS programs/macros to analyze financial data and to create files, tables, listings, and graphs. Developed ad-hoc reports as per business requirements and created various reports like summary reports, tabular reports.
• Developed SAS programs for statistical analysis and data displays working with various SAS products SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS etc. to develop solutions.
• Wrote programs in SAS, generate reports, creating RTF, HTML listings, tables and reports using SAS ODS for ad-hoc report generation.
• Implemented credit risk analysis reporting system based on FICO scores and data management principles, such as joining dataset, indexing, data aggregation, record selection, sub-setting, multiple records per case, creation and modification of views, accessing multiple databases.

Environment: SAS/Base, SAS Enterprise Guide, SAS/Macro, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/ODS, Oracle 9i, MS EXCEL, MS ACCESS