SUMMARY:

• SAS Certified Base SAS Professional with over 7years of experience in data analysis and statistical modeling including data extraction, manipulation and validation techniques, writing macros and reporting on various projects for financial industry using SAS and its tools.
• SAS professional in developing statistical methods routinely used in Financial /Mortgage / Education /Telecom/Sales and Marketing data analysis.
• Data preparation for various statistical modelingwhich includes data cleaning, descriptive analysis, missing data analysis, data validations, data triangulations and preliminary data reporting.
• Expertise in writing large/complex queries using SQL.
• Good Knowledge in UNIX,shell scripting.
• Responsible for evaluating reports in Batch applications. Made temporary coding changes to applications if necessary.
• Experience in design,development and implementation ofBusiness Intelligence solutions and in all phasesof Software Development Life cycle.
• Expertise includes Data Analysis,Data Modeling,Data Cleansing,Integration, Data import, Data export.
• Proficiency in writing maintainable, flexible and well-documented SAS codes using DATA step and PROC step.
• Experience in SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/ODS, SAS/SQL.
• Created complex reports to end users based on the regulatory reporting requirements.
• Sound Skills in developing SQL Scripts, PL/SQL Stored Procedures, functions, packages.
• Understanding and proficient use of various procedures like PROC SQL, PROC report, PROC Freq, PROC means, PROC contents, PROC dataset, PROC append, PROC import, PROC export, PROC print, PROC sort.
• Skilled in SAS programming, merging SAS datasets, SAS formats and Managing data.
• Experience in using report generating procedures like PROC CONTENTS, PROC PRINT, PROC UNIVARIATE, PROC SUMMARY and PROC TRANSPOSE.
• Experience in using the ODS facility to create HTML, RTF, XML and PDF files.
• Experience in dynamic programming and list processing using SAS/MACRO.
• Experience in using SAS/GRAPH procedures like PROC GPLOT, PROC GCHART and PROC BOXPLOT.
• Extensive experience on production support and troubleshoot/test issues with existing reports.
• Good analytical skills pertaining understanding a business domain coupled with excellent teamwork and strong communication skills.
• Hard working, ethical and highly result oriented.
• Ability to quickly grasp and apply new concepts and technologies.
• Strong leadership, interpersonal and oral/written communication skills.
• Ability to work independently as well as collectively.

TECHNICAL SKILLS:

• SAS Tools: SAS 9.1.3 / 9.2 /9.3, SAS/BASE, SAS/SQL, SAS/MACROS, SAS/ODS, SAS/STAT, SAS/ACCESS, SAS Enterprise Guide, BI tools,ETL
• Languages: Minitab, SPSS, C, C , Java, SQL
• Databases: Access, SQL-Server, Teradata,DB2
• Package: MS office 97/2000/2003/ 2010, Word, Excel and PowerPoint
• Operating System: Windows 98/95/2000/XP/Windows 7/ Windows 8 UNIX

PROFESSIONAL EXPERIENCE:

Confidential

SAS Developer

Responsibilities:

• Develop Data Models around Credit Risk and Loss Mitigation utilizing SAS.
• Develop processes using various data analysis tools to measure or analyze various aspects of credit risk and credit operations.
• Used SQL pass through facility to access TERADATA for extracting data from Teradata to SAS Enterprise Guide5.1.
• Develop Data models and designed reports using SAS Enterprise Guide with SAS and SQL Queries. .
• Developed SAS Reports for data models based on Requirement.
• Extract the Data from database using SAS and SQL procedures and created SAS Data sets.
• Used SAS Macros and procedures like PROC SQL, PROC TRANSPOSE, PROC REPORT, PROC MEANS, PROC SORT, PROC APPEND,PROC CONTENTS, PROC SUMMARY
• To produce SAS report tables, graphs used different source files like EXCEL,WORD,TEXT
• Generate Tables, charts, plots based on data models using PROC REPORT, PROC TABULATE, PROC FREQUENCY,PROC GCHART,PROC GPLOT, PROC SGPLOT, PROC GREPLAY
• Developed SAS coding with BASE SAS and SAS macros.
• Used SAS ODS create output HTML, RTF, PDF files for producing Reports.
• Experience working with relevant data analysis packages, reporting platforms.
• Strong technical skills and familiarity with common business and technical issues in the development of credit risk reports.
• Perform the duties and responsibilities as per requirement.
• Resolved the issues created by team and users.
• Developed various SAS reports for project and involved in code reviews for all the developed reports

Environment: SAS, BASE/SAS, SAS/MACRO, SAS/SQL, SAS/ODS, TERADATA SQL,SAS ENTERPRISE GUIDE 5.1, Assistance UNIX and Windows 2003/XP.

Confidential

SAS Developer/Analyst

Responsibilities:

• Created intricate set of SQL tables to hold user login and user access information with constraints and access errors were logged in to error tables.
• Acquired financial raw data from Oracle and DB2 tables and loaded the data into SAS datasets.
• Used Macro routines to convert different types of source file Excel, Word, and Text to produce SAS reports and graphs.
• Used PROC SQL, PROC import, PROC export statements to load SAS data sets from and to DB2 and Oracle 9i.
• Working on SASBusiness Intelligence BI platform to drive the automation of standardize analytics.
• Generating SAS EG stored process with static and dynamic prompts for product specific analyses.
• Strong Experience in SAS Enterprise guide in creating stored processes using the dynamic prompts containing both packaging or streaming output, and prepared reports using ODS.
• Modifying existing codes for improvement in the performance.
• Advanced querying using SAS Enterprise Guide, calculating computed columns, using filter, manipulate and prepare data for Reporting, Graphing, and summarization, statistical analysis, finally generating SAS datasets.
• Developed and scheduled SAS jobs using Shell Scripts / UNIX.
• Enhanced the existing UNIX scripts to achieve better performance and throughput.
• Also cleaned the data using SAS code SAS Macros and develop SAS Code on WINDOWS,UNIX according to the specifications.
• Used SAS Access to ORACLE feature for large data extractions SQL-Pass thru .
• Developed and maintained SAS Reports for sales data based on the requirement.
• Followed SDLC approach to move the code to Production. Performed QC routines and shared results with business to get approvals.
• Implemented data management plans designed to meet project deadlines.

Environment:SAS 9.1 SAS/Access, SAS/Connect, SAS/Stat,SAS Enterprise Guide, SAS/Graph, SAS/SQL, SAS/ODS , UNIX, SAS, Oracle 9i, DB2, MS Excel, Solaris 8, K-Shell.

Confidential

Sr.SAS Analyst

Responsibilities:

• Gathering functional requirements from business customers, analyzing and transforming them into business intelligence reporting specifications.
• Used SAS Macros and procedures like PROC SQL, PROC Transpose, PROC Univariate, PROC Means, PROC Freq.
• Extraction of data from Data Ware housing tables and Data marts.
• Extracting data from the database using SAS SQL procedures and create SAS data sets.
• Extracting useful information from a set of data values called data mining . Using data models created to make predictions.
• Provided end user support for day to day use of the business intelligence reporting platform.
• Provided support in the design and implementation of ad hoc request for credit related portfolio Data.
• Worked effectively with credit, the line and finance and ensured data integrity.
• Wrote many UNIX scripts.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrate those to Teradata.
• Produced ad hoc reports in SAS using .txt files upon request for in-depth analysis.
• Coding SAS programs with the use of BASE SAS and SAS/MACROS for ad hoc jobs.
• Trained end users on simple ad hoc report creation.
• Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
• Maintained SAS statistical analysis for the products purchased every month
• Run reporting programs and download the results into EXCEL and build pivot tables
• Used SQL and PROC SQL Pass through Facility to work with Oracle, DB2
• QA team for validation and verification of the development.
• Exceptionally good and experienced in handling the problem and troubleshooting.

Environment: SAS/BASE 9.2, SAS/Enterprise Guide V3, SAS/MACRO, SAS/ACCESS, SAS ENTERPRISE GUIDE, Oracle9i, MS Office products.

Confidential

SAS Developer/Analyst

Responsibilities:

• Written SAS reports to Excel, the SAS content server, HTML, and PDF
• Developed sophisticated risk strategies, and analyze and mitigate fraud risk by identifying the risks associated with online customer originations, authentication and product usage.
• Worked with Fraud Analytics to develop new and modify existing process documentation and templates in implementation of fraud risk controls and reporting.
• Utilized advanced statistical software to develop Analysis, Strategies, and Reporting Capabilities.
• Utilized database management, reporting, and analysis software to store, organize, and manipulate data from Reporting and Production databases.
• Performed and conducted customer visitation to Review credit documents.
• Created reviewed and modified the Risk Assessment criteria model predicted upon characteristic changes in the industry and the Accounts Receivable portfolio.
• Run the daily jobs in UNIX..
• Conducted daily status and weekly reporting meeting of the group and update the senior management on the progress on timely basis.
• Developed and designed analytics reports using SAS 9.2 and Enterprise Guide 4.2
• Prepared and Delivered Dashboard reports on the basis of analysis of revenue assurance report received from various operations of the company and consolidating the result for management reporting using SAS, Macros, Pivot tables, Charts, Data Validation.
• Created a demographic analysis of the online customers to describe the population and its characteristics, such as average education level, average age, income level, Email Provider, and other characteristics.

Environment: SAS 9.2 version, SAS/Base, SAS/Stat, SAS Macros, SAS/Graph, SAS/SQL, SAS/Reports, SAS Enterprise Guide 4.3, SAS Enterprise Miner, MySQL, MS Excel.

Confidential

SAS Programmer

Responsibilities:

• Performed user acceptance testing.
• Created and modified SAS macros for edit check process.
• Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/ Base and SAS/ Macro facility.
• Analyzing various tables using Data manipulation techniques like merging, appending, concatenating and sorting.
• Improved performance of PROC SQL on SAS Oracle interface using options like insert buff, readbuff, inobs.
• Provided data for use in generating computer reports and statistical analysis.
• Created summary data using various functions, arrays and transpose
• Used SQL pass through facility to process high volumes of data
• Done data validation using regular expressions
• Done table lookup using match merge and SQL joins
• Used new features of SAS 9 like call Symput, new functions and regular expressions.
• Created Functional requirements and design document
• Writing complex SQL Queries using joins,to extract the data from the Teradata Database and Schedule the jobs in UNIX.
• Created many custom functions to be shared and shared and reused by the report designers.
• Understood and gathered the requirements by interacting with business users.
• Design, develop, and implement SAS Extraction Code for data extraction.
• Prepared graphs using the modified data for business analysis.
• Good team player and experience with working offsite.
• Ability to work on multiple projects simultaneously and meet the deadlines as and when required.
• Resolved issues created by testing team and users

Environment: SAS/BASE 9.1.3, SAS/Enterprise Guide V3, SAS/MACRO, SAS/ACCESS, Oracle9i, Teradata.

Confidential

SAS Developer

Responsibilities:

• Involved in functional analysis and gathering the information from client as per the project requisites.
• Develop new macros for report generation using SAS/Macros as per the customer's requirements.
• Used various procedures such as PROC Tabulate, PROC Means and PROC Report to generate tables, listings, graphs and reports.
• Extract the data from a data warehouse and create ad-hoc reports, tables, and graphs according to Business needs.
• Provide insightful analytics, strategy development and reporting to support Risk analysis Operations.
• Analyze and interpret significant results based on data summaries.
• Expertise in statistical modeling and analysis on study data by utilizing appropriate statistical methods.
• Performed tests according to the plan
• Developed test plan to verify correct implementation of user requirements.
• Analyzed the system for providing customer specific requirements.
• Conducted performance Tuning using SQL profiler and windows performance Monitor.
• Analyze and interpret significant results based on data summaries. .
• Extracting and moving data from UNIX.
• Used SAS/ODS to create HTML, RTF and PDF outputs files in the process of producing reports.
• Retrieving Millions of Records Using different Procedures.
• Developed various SAS reports for Survey project and involved in code reviews for all the developed reports

Environment: SAS/BASE, MACRO, SAS/SQL, SAS/ACCESS, Shell-script, MS-Office 2003.