SUMMARY:

• SAS Programmer with over 4 years of experience in Marketing Campaign Analysis, Customer Retention, Financial and Risk Analysis
• Knowledge on SAS efficiency techniques and experience in handling huge volumes of data
• Experience in Base SAS, SAS Enterprise Guide, Macros, SQL, SAS/STAT, SAS/Access, SAS/GRAPH and SAS/ODS
• Experience with PROC SQL, writing queries, using Left Join, Right Join, Outer Join and Union.
• Strong expertise in reporting and summarizing data using PROC REPORT, PROC TABULATE, PROC SUMMARY and PROC FREQ
• Hands - on experience with SAS Model Manager for implementing and tracking of models
• Experience in accessing RDBMS databases such as Oracle, SQL Server and SAS/Access facility
• Thorough hands-on experience in using ODS to generate different files including RTF, MS Excel, PDFs and HTMLs
• Proficient in using Import and Export procedures to handle data in raw text format, ORACLE and Teradata database management systems
• Ability to work in fast paced environment with little or no documentation, able to employ new ideas, concepts, methods, and technologies
• Strong Analytical, Diagnostic skills and ability to work in a fast-paced and Team-oriented environment.
• Strong interpersonal, organizational communication, customer service & presentation skills.

TECHNICAL SKILLS:

Statistical software: Base SAS, SAS/SQL, SAS/Macros, SAS/ODS, SAS/CONNECT, SAS Access to Oracle (SAS/Access), SAS Enterprise Guide (SAS EG), SAS statistical procedures, UNIX, Linux

Languages: SAS, SQL, Visual Basics, VBA

Tools: WinSCP, SSH Tectia Client, Microstrategy, Cognos, PL/SQL, Business Objects, Tableau

Databases: MS Access, MS Excel, Microsoft SQL Server, Oracle

Software Packages: Microsoft Office (Word, Excel, PowerPoint, Outlook)

Domains worked: Finance, Telecom, Healthcare and Insurance

Open Systems: C, C++, UNIX, Linux

Operating Systems: Windows XP, Vista, Windows 7, Mac OS, (OS/MVS,TSO, ISPF)

Graphic Tools: Adobe Photoshop, Adobe Flash

PROFESSIONAL EXPERIENCE

Confidential, Hamilton, NJ

SAS Analyst

Responsibilities:

• Performed model development for estimation of credit risk of clients and automation of the credit analysis process in the firm and implement process to utilize analytical models in business decision making.
• Conducted analysis to resolve business issues and assisted in preparing firm communication materials for internal and external audiences.
• Created JMP scripts in order to describe the analysis process in detail.
• Used JMP scripting to create set a set of analysis process (step wise) to fit the same model to new data which has same but many steps.
• Create scoring and recovery models for mortgage business using SPSS modeler
• Developed Base and Advance SAS Programs for data analysis with large and multiple data sets using tools like SASEnterprise Guide 4.3 and/or 5.1, SAS9.2 and Enterprise Miner, JMP.
• Developed with analyzing large datasets and preparing reports using tools like SAS EG, Miner, Advance Excel options, SAS DI, SPSS, JMP, PL/SQL skills in ORACLE DB2, VBA Excel.
• Used data management experience with includes data warehousing and business intelligence principles for data analysis, checking data quality, data organization, data profiling and understanding the metadata & data relationships among the dimensions.
• Advanced risk assessment process for the underwriting team by developing new financial models and upgrading existing financial risk models, using R and VBA in Excel.
• 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.
• Develop and coordinate analytics and quantitative modeling associated with risk rating system.
• Set methods and procedures for model estimation, validation and data requirements.
• Use SQL skills to perform ETL from data warehouses 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 (using Oracle DB2 and Teradata) which involved organizing, profiling and define the metadata.
• Scripted advance SAS programs with the use of SAS 9 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 using SAS, Tableau and R Programming Software.

Environment: SAS/Base, SAS/Macros, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/ETL, Unix, Oracle DB2, MS SQL Server 2000, and Windows XP.

Confidential, NYC, NY

SAS ANALYST

Responsibilities:

• Single-handedly responsible for designing the process and migration of a new Regulatory Reporting project from North America team from US (3 months migration in US, New York) successfully, testing and deployment of the project in production.
• Imported raw data files and subsequently created SAS datasets and performed data manipulations on the datasets.
• Provided detailed documentation of the process and written SAS code with optimum comments to make SAS process simple and easily understandable.
• Developed SAS Macros and SAS programs (using Base SAS 9.3 and SAS Enterprise Guide (SAS EG)), SAS ETL processes for data validations of new regulatory reports and extracts for North America Regulatory Reporting (HNAH) as per PRA and EBA norms and standards.
• Report generation for regulators, reporting teams and management using PROC UNIVARIATE, PROC MEANS and PROC REPORT.
• Developed predictive models in detecting patterns in credit risk models, decision tree, regression and neural networks.
• Automated report generation in the Windows environment for the efficiency duringProductionand in the Production Environment.
• Provided extended BAU support and activities to support the Regulatory Reporting team to make sure the correct and optimal data for Pillar3 and FSA 004/045 reporting on monthly basis.
• Validated regulatory finance data and created automated adjustments using advance SAS Macros, PROC SQL, UNIX (Korn Shell) and various reporting procedures.
• Implemented and tested various Basel3 reports and worked extensively on COREP/FSA/Pillar3 regulatory reports.
• Responsible for transition of various processes and standardization of the codes for migration.
• Created SAS programs for EDIT CHECKS and performed data validation on raw data sets.
• Query ORACLE databases usingTOAD, querySASdatasets usingSAS that other reporting resources can leverage the data.
• Worked on VBA scripts, Tableau and Business Objects.
• Develop Ad-hoc report using SAS Enterprise Guide.
• Created new datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update, and conditional statements. Involve in Unix Shell programming using Bash and set up CRONTAB jobs for SAS application batch run.
• Wrote Korn-Shell Scripts performing various automation steps like running a SAS code, emailing the output files, removing and copying files, archiving files for historical data and zipping up files to send to external locations as attachments in emails

Environment: SAS/Base, SAS/Macros, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/ETL, Unix, Oracle DB2, MS SQL Server 2000, and Windows XP.

Confidential, TX

SAS Consultant/Analyst

Responsibilities:

• Used SAS/Access facility to connect to Teradata and used SAS SQL procedures to extract and manipulate data
• Developed SAS MACRO scripts to check data quality, generate descriptive statistics for modeling and scoring data sets
• Assisted lead programmer/statistician by creating historical data base for predictive modeling
• Involved in all stages of model development including model data set generation, model building, validation and tracking performance
• Maintained logistic regression and decision tree models using SAS/Base and SAS Enterprise Guide.
• Used SAS/STAT procedures such as Proc Univariate, Proc Means, Proc Surveyselect, Proc Reg and Proc Logistic
• Used SAS Model Manager to score and track existing models and generate quarterly reports
• Developed statistical models for loss forecasting, automated the process to enable auto updates for monthly forecasts using SAS Forecast Studio
• Developed SAS programs to create mail lists for satisfaction survey to eventually estimate their churn likelihood
• Used SAS Enterprise Guide and Teradata extensively for Ad hoc reporting
• Modified existing and new SAS jobs that generate reports, and to send them as PDF or HTML attachments or as body of the email
• Reviewed various documents and source systems schema to improve business understanding and data understanding
• Acted as liaison between on site management and off shore teams and contributed for completing the project with in timeframe

Environment: SAS/ACCESS, SAS/BASE, SAS/STAT, SAS/GRAPH, Teradata, SAS Forecast Studio,MS OFFICE

Confidential, Atlanta, GA

SAS Programmer Analyst

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Attending Client calls for Business understanding and Clarifications.
• Gathered valuable knowledge about the working of stock market, index concepts.
• Extracted raw data from an Oracle database and used SAS/Access to read it and run statistical analysis using SAS/Stat.
• Utilized Web Trends for gathering web analytic traffic for client/server side data, data warehouse, usability testing data, user behavioral data & Marketing Channel Data.
• Worked with Log File Analysis and Page Tagging
• Worked closely with business groups to provide business solutions and to develop adhoc reports by Creating and Updating refresh/incremental MDDBs as per the user’s requirement.
• Done Enhancements for the existing business reports like incorporating new business variables.
• Developed, modified, and generated Monthly Business Review (MBR) reports summarizing business activity.
• Uploading data into the warehouse application on monthly basis.
• Review and modify SAS Programs, created customized ad-hoc reports, process data for publishing business reports; automate and distribute designed business reports on schedule in various format.
• Developing Test Plan and Test Cases.
• Modifying the existing application according to the Customer Service Request.
• Preparation of Analysis document for the given Customer Service Request.
• Developed SAS programs to extract, validate and transform data from different data sources using SAS procedures PROC Format, Proc Means, Proc Freq and Proc Univariate
• Integrating the changes in Common Development Area.
• Testing the application for the new code.
• Developed standard reports on CTQ, SLA and sigma using Base SAS and Macro Language.
• Used to make an algorithm related the Ideal Cost, Weighted Average and Impact Cost of stocks of companies from different sectors.
• Providing up-to-date industry and company specific reports.
• Working with hundred thousand rows of data sets.
• Extensively used Proc SQL for highly advanced matching and merging between large datasets.
• Finding the Weighted Average of the quantity of stocks using proc type, proc freq which are bought and sold at a particular time.
• Designed and developed Unix shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Worked on test data and completed unit testing to check all business rules and requirements are met. Also tested for negative data to check that the job fails on any critical error.

Environment: SAS Base 9.4/9.3, SAS/Macros, Enterprise Guide, SAS/Stat, SAS/ODS, SAS/Access, SAS Data Integration Studio, SAS Management console, SAS Information Map Studio, SAS Web Report Studio, SAS Model Manager, putty and Unix