SUMMARY

• SAS programmer with 7 years of professional experience in working with SAS and SAS tools with strong emphasis on SAS programming, modeling, and data analysis for risk management, marketing, operations and financial departments of large enterprises.
• Experience in modeling for risk rating and generate results/reports for upper management.
• Experience in performing various business analysis like Market analysis, Customer behavior analysis.
• Worked closely with management like Marketing managers, Product Managers, Financial managers, operations managers etc., to analyze customer related data, generate custom reports, tables, and graphs.
• Experience in generation of various canned periodic and ad-hoc reports for various analyses.
• Experience in UNIX Korn Shell scripting for process automation.
• Followed System Development Life Cycle SDLC methodology for the design, development, implementation, and testing of various SAS modules.
• Experience in Base SAS MACROS, Proc SQL, ODS , SAS/STAT, SAS/ACCESS, SAS/CONNECT and SAS/GRAPH in UNIX, Windows, and Mainframe environment.
• Thorough knowledge in SAS Programming, Merging SAS Data Sets, Macro Facility, Preparing data, SAS Procedures, Producing Reports, SAS Formats, SAS Functions, Storing and Managing data in SAS Files.
• Experience in using SAS to read, import, and export to other data file formats, like XML files, Excel files, and flat files.
• Experience in importing data from Oracle Server, DB2, and MS SQL Server.
• Thorough Knowledge and experience of Microsoft Office tools like MS Access, MS word, MS PowerPoint, and MS Excel.
• Extremely energetic, detail oriented, organized team player with strong analytical abilities, communication skills, interpersonal skills, and problem solving skills.
• Highly persistent and motivated with willingness to assume responsibility.

TECHNICAL SKILLS

• SAS Tools: SAS 8/9, Base SAS MACROS, Proc SQL, ODS , SAS/ACCESS, SAS/GRAPH, SAS/STAT, SAS/CONNECT, SAS EG.
• Database Tools: PL/SQL Developer 7.1.5.
• Operating Systems: UNIX, MS-Windows 7 /XP/2003/2000.
• Databases: TD SQL, Oracle 9i/10g/11i, MS SQL Server and MS Access.
• Programming Languages: SQL, UNIX Korn Shell Scripting.

PROFESSIONAL EXPERIENCE

Confidential

SAS Analyst

CONFIDENTIAL has been a leading provider of traditional and online financial services to credit unions. Confidential represents more than 680 credit unions, making us the nation's leading Credit Confidential

Responsibilities:

• Develop, test, and debug SAS programs to model Attrition rating models for different types of commercial loans.
• Working on Attrition model to not only retain the customers but also boost the usage of the card.
• Developing score cards using Logistic Regression.
• Working on formulating and calculating the profits and other variables at account holder level on a monthly basis
• Working on Segmentation process to categorize the card users based on various factors like usage, profits etc.
• Build logistic regression models using SAS EG for risk scoring on new campaigns and prospective customers
• Develop Model to Predict Customer Response to launch of new products.
• Develop and execute controlled tests to determine the impact of new programs, strategy changes, or procedural changes.
• Worked on Call Center data to analyze the call volumes across different months and also across various Credit Unions.
• Rank ordered the call volumes based on the purpose of the calls using the Call Codes.
• Extract and summarize Call Center data and analyze the trends or patterns in the same.
• Produced statistical reports as per business needs and expertise in data preparation, data cleaning, analysis, and reporting
• Work/co-ordinate with different teams to deliver reports on time
• Extract data from the source database using Proc SQL.
• Used Enterprise Guide EG query builder to run queries and build reports against the tables and sub setting the data.
• Generated Descriptive Statistics, Correlations, Univariate analysis and other statistical analysis for various data sets.
• Worked extensively in sorting, merging, concatenating, and modifying SAS data sets using both data steps and Proc SQL.
• Used SAS/GRAPH to create Pie Charts and Histograms.
• Used ODS to generate results in Excel, PDF, and HTML formats.
• Modify models and programs to reflect any changes in business requirements and input data structure.
• Involved in handling the ad-hoc reporting requirements.

Environment: SAS 9.3, SAS/CONNECT, SAS VA, SAS MA, SAS/STAT, SAS/GRAPH SAS Macros, SAS/ACCESS, Oracle, Windows 7, MS Office, SAS Enterprise Guide 5.1, SQL, Teradata.

Confidential

SAS Consultant

Confidential is a global e-commerce business allowing payments and money transfers to be made through the Internet. Confidential is a subsidiary of Confidential. Confidential operates in 190 markets and manages more than 232 million accounts.

Responsibilities:

• Develop/Modify shell scripts to run/automate SAS programs.
• Worked with Global Risk Case Management team to generate reports on various metrics
• I have been doing variety of tasks including data extraction, manipulation, Analysis using Operations and Transactions Data.
• Built various regressions Logistic, Linear, Non-Linear and Multi and forecasting models using Base SAS.
• Worked on various optimization problems and used Linear Programing in SAS to solve the same.
• Produced statistical reports for various business needs and expertise in data preparation, data cleaning, analysis, and reporting.
• Customizing the existing Macros according to need and requirement, testing and debugging the Macros and creating more complex and reusable Macros.
• Used Enterprise Guide EG query builder to run queries against the tables and sub setting the data.
• Creating excel pivot table reports using Cycle Time data. These reports consist of Benefit level data, operations level data. These reports are very useful to get a greater insight.
• Worked on generating ad hoc reports, tables and graphs for presentations and data modeling using SAS Web Report Studio.
• Importing all Reports from web report studio, Stored Process, BI Dashboard and Information Map to Information Delivery Portal.
• Developed loss prediction model using Enterprise Guide modeling solutions and SAS procedures.
• Created and delivered reports and presentations with key findings and recommendations.
• Provided technical support on SAS programming related to data manipulation and analysis.
• Exported SAS Reports to the Excel Sheet by using ODS/Tagsets/ExcelXP to get the output in multisheets.
• Developed and used scripts to schedule SAS Jobs.

Environment: SAS 9.1.3, SAS/CONNECT, SAS Macros, SAS/ACCESS, Oracle 10g , Windows 7, MS Office, HTML, SAS Enterprise Guide , SAS Stored Processes Web Application, SQL, Teradata.

Confidential

SAS Analyst

Confidential is number one online automobile market place with over 700 Million dollar turnover. Worked on design, development and testing of Canned/Ad-hoc reports for product performance/ utilization and data feeds to Confidential.

Responsibilities:

• Work with Business Analysts, Business, and Product managers to design reports to meet business analysis needs.
• Assist Business Analysts to develop requirements document for site tagging for BI.
• Create Technical specification document from BRD, as documentation for creating reports.
• Work/co-ordinate with various teams to deliver reports/data on time.
• Develop and modify over night SAS read routine to parse web logs ANSI format from site traffic to create daily and MTD SAS datasets.
• Develop, test, and debug SAS programs to collect site traffic data and create reports on product performance.
• Develop, test, and debug SAS programs to summarize site traffic data, to provide summarized daily SAS datasets as data sources to DWH.
• Create Canned MTD and Ad-hoc reports in HTML and downloadable CSV format.
• Develop/Modify shell scripts to run/automate SAS programs.
• Work with large datasets up to 50 million observations and 80 variables.
• Source/Query data from Oracle database.
• Extensive use of match-merge/Proc SQL joins to report site traffic data at various metrics like Page views/Cars/Products.
• Extensive data manipulation using SAS functions.
• Validate web logs/site traffic data for data quality and consistency.
• Use SAS/GRAPH to create Pie Charts and Histograms.
• Develop, Test, and Debug SAS programs to convert business rules into Analysis programs for Needs Analysis Model.
• Reverse engineered existing undocumented code to understand business logic and implement changes/improvements to the logic to reflect changes in business requirements.
• Analyze data/results to improve the effectiveness of the Needs Analysis model.
• Provide ad-hoc programming support for analysis/changes.
• Extract source data from DB2, Oracle server for different functional elements.
• Modify/Summarize data extensively to transform data to a common level across functional elements.
• Extensively used SAS Macros for programming, Hash tables in data step for table lookups
• Program to match merge/joins of data between functional elements.
• Use SAS/STAT, SAS/CONNECT, and SAS/ACCESS for various tasks.
• Use Proc SQL to query source data, and analyze/report data quality.
• Develop reports from the model to report pavement improvements across timelines.
• Develop program flow charts in MS VISIO 2000.

Environment: SAS 9.1.3, Base SAS MACROS, Proc SQL, ODS , SAS/STAT, SAS/CONNECT, SAS/STAT, SAS/ACCESS, DB2, Oracle9i, MS Access2000, MVS, UNIX, MS-Windows XP, MS-Office

Confidential

SAS Programmer

Worked on planning, implementing, deploying, and maintaining commercial loan risk rating application built with SAS programs and UNIX Korn shell scripts.

Responsibilities:

• Extensively interact with business analysts, IT services team, and Statisticians for developing SAS models for risk rating of commercial loans.
• Involved in SDLC of the risk rating application. Documented requirement analysis, version upgrade, and migration across develop, test, and production environment.
• Develop, test, and debug SAS programs to model Risk rating models for different types of commercial loans.
• Modify models to reflect any changes in business requirements and input data structure
• Extensively used SAS Macros for programming.
• Followed an internal program validation and tracking methodology.
• Generate test data for model validation.
• Modify/develop Korn shell scripts to automate report generation and schedule tasks.
• Program for statistical analysis of data for model calibration.
• Work with business analysts to analyze and debug data issues. Use SAS programs and functions for data validation and cleansing.
• Work extensively in sorting, merging, concatenating, and modifying SAS data sets
• Use ODS to generate results in Excel, PDF, and HTML formats.
• Involved in handling the ad-hoc reporting requirements.
• Extensively use Data NULL to create XML files from SAS datasets.
• Develop SAS datasets from Excel files, XML files, Oracle Server, and DB2 database.
• Extract data from the source database using Proc SQL.
• Use XML Mapper for creating SAS datasets from XML files
• Design, document, implement, and maintain monthly ad-hoc financial, marketing and operations analyses using SAS.
• Conduct complex ad-hoc programming and analysis including statistical programming and analysis.
• Develop and produce monthly reports summarizing business activity, delinquency loss
• Analyze business performance and productivity to identify obvious and subtle causes for improvement and deterioration.
• Extract and summarize account and transaction level data for trend analysis and forecasting
• Create application layers for web publishing and dispatching of reports.
• Produce SAS datasets, flat files, and reports.
• Extract data from the source database using Proc SQL.
• Build logistic regression models using Base SAS for risk scoring on new campaigns and prospective customers
• Develop Model to Predict Customer Response to launch of new products.
• Develop and execute controlled tests to determine the impact of new programs, strategy changes, or procedural changes.

Environment: SAS 9, Base SAS MACROS, Proc SQL, ODS , SAS/ACCESS, SAS/STAT, SAS/GRAPH, SAS Enterprise Guide 3.0, DB2, Oracle 9i SQL, PL/SQL , UNIX, UNIX Korn Shell, MS-Windows XP, MS-Office

Confidential

SAS Programmer

Analyzed financial and customer data and developed reports as per the requirement of various clients.

Responsibilities:

• Produce SAS datasets, flat files, and reports for various departments,
• Create SAS data sets from Oracle database.
• Extensively program for statistical analysis of data.
• Develop and execute controlled tests to determine the impact of new programs and strategy changes on existing customers.
• Implement advanced statistical approaches to develop predictive models and profiles.
• Data mining to identify significant relationships among customer behaviors and descriptive characteristics.
• Perform complex ad-hoc programming, analysis, and reporting.
• Design, document, implement, and maintain monthly and ad-hoc financial and marketing analysis.
• Develop and produce monthly reports summarizing business activity, delinquency loss.
• Maintain and enhance loss-forecasting models and delinquency roll rates.
• Modified/developed korn shell scripts to generate periodic reports.

Environment: SAS 8, Base SAS MACROS, Proc SQL, ODS , SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS Enterprise Guide, Oracle 9i SQL, PL/SQL , UNIX, MVS, UNIX Korn Shell, MS-Windows XP, MS-Office