Professional Profile:

SAS professional with 6 years of experience in the analysis, design, development of statistical data development including data extraction and manipulation, writing macros and reporting on various projects routinely used in Financial/Health care/Sales and Marketing data analysis. Summary: Experience in SAS/BASE, SAS/SQL, SAS/MACROS, SAS/ODS, SAS/STAT, SAS/ACCESS, SAS/GRAPH, SAS Enterprise Guide Solid understanding and proficient use of various procedures like proc SQL, proc report, procfreq, proc means, proc contents, proc summary, proc rank, proc import, proc export, proc print, proc sort, procunivariate. Have strong knowledge about drop, keep, retain, and date manipulations, formats, informats. Excellent command in writing complex routines for Data Validations, Data Extraction, transformation and loading to target decision support systems using MS Excel and SAS on various environments. Proven skills in Data Cleansing, Data Archival, Data Migration, ad-hoc reporting and coding utilizing SAS on UNIX, Windows Experience in using various MS office tools for analyzing, arranging and presenting data Strong experience in coding using SQL, Procedures/Functions, SAS macros Followed System Development Life Cycle SDLC methodology for the design, development, implementation, and testing of various SAS modules. Experience in creating test scenarios to find errors and confirm programs meet specifications. Program Documentation and Review. Thorough Knowledge and experience of Microsoft Office tools like MS Access, MS word, MS PowerPoint, MS Excel, MS Visio, MS Project Management and MS Outlook. Experience in updating and creating documentation of code, guidelines, and high level documentation. Writing Edit Check programs for data validation. Creation and validation of Analysis Datasets.

Technical Skills: Statistical Packages SAS 8.x 9.x Base SAS, SAS/STAT, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, SAS/ODS , SAS Enterprise Guide. Databases Oracle, DB2, Teradata Languages SAS, SQL, PL/SQL Platforms Windows and UNIX. Others MS office, MS Visio, MS Project Management, Ultra Editor Studio, Confidential Role: SAS Analyst/Programmer Responsibilities: Developed SAS programs for statistical analyses and data displays. Took raw data, built input data sets used sorting and merging techniques to get the required output and then wrote code using SAS/Base, Proc SQL and SAS Macro facility. Data Analysis and graphical presentation for various summary reports using Base SAS and SAS/Graph facility. Raw data was processed to create datasets in the required format and tabulated so as to easily analyze data. Extensively used Proc Tabulate procedure for the purpose. Report generation using many SAS proc statements, SAS/MACROS, and data null steps. Actively involved in design and implementation of application software using primarily SAS system and analyzed existing application software and recommended improvements. Extracted raw data from excel spreadsheets and MS Access. Created input data sets and analyzed the data by creating graphs using the SAS/GRAPH facility. SAS was used for pre-processing data, SQL queries, data analysis, generating reports, and statistical analyses. Processed data collection to ensure proper quality of data. Maintained the daily error log for cleaning the data. Extensively used data export techniques. The data after being analyzed was directed to different output files such as Excel Spreadsheets and DBF files Extensively used Proc SQL procedure for working with oracle database for creating and updating the data as and when processed. Involved in post-Campaign Analysis. Designed, developed, tested and debugged new macros and modified the existing macros according to the enhancements in the business. Environment:SAS/BASE, SAS/MACROS, SAS/SQL, SAS/ACCESS, SAS/GRAPH, MS Excel, Access 2000, Window NT/2000 Confidential Role: SAS Analyst/Programmer Responsibilities: Worked with statisticians in generating SAS analysis datasets, production of data listings, summary tables, and statistical analyses. Used SQL and proc SQL to work with Oracle. Design and code SAS and SQL ETL processes and methodology for the data used to deliver the programs direct mail and email contacts. Implement SAS SQL code for any and all programs according to all client standards. Extracted required data from IBM mainframe to local SAS Environment by SAS FTP and sync sort. Developed and modified programs in SAS under UNIX environment using SAS/BASE. Developed Queries using PROC/SQL to retrieve the data based on the matching columns. Used SAS procedures and preparing daily, monthly, yearly reports. Worked with SAS /ODS, HTML to produce dynamic web interfaces from SAS programs Used SAS import and Access to import external files. Worked with SAS/Graph to produce graphical reports. Maintain and enhance existing SAS reporting programs for test results. Extract the data from a data warehouse and create ad-hoc reports, tables, and graphs according to Business needs. Environment:BASE SAS, SAS/MACRO, SAS/GRAPH, SAS/CONNECT SAS/ACCESS, Ms-Excel, SAS/ODS, IBM Mainframes, Unix. Confidential Role: SAS Programmer/Analyst Responsibilities: Analyzed business workflow and system needs. Extracted the data from DB2 and Oracle using PROC SQL pass through facility. Worked with the Guest browser's data, sales data that consists of more than 2 billion records. Used Common Table Expressions CTEs to improve the resources usage and increase the performance. Converted raw data file into SAS datasets using the SAS INFILE statement. Scheduled SAS jobs using CRON TAB Scheduler. Extensively used proc SQL, proc EXPORT and SAS Macros. Used SAS/MACRO facility to decrease the redundancy of extensively used SAS scripts and to increase the flexibility of the code. Developed SAS code and created ad-hoc reports based on the given requirements. Created dashboard reports and ad-hoc reports on weekly and monthly bases. Used excel and VBA scripts to develop the ad-hoc reports. Extensively used query analyser to check the data in the Database DB2 and run the SQL queries directly in the DB2. Created Indexes to improve the efficiency. Wrote the SAS code from scratch to develop the reports. Used Output Delivery system ODS facility to direct SAS output to RTF, PDF and HTML files. Worked on ad-hoc requirements and later converted them as monthly and quarterly reports. Environment: Windows XP, SAS/BASE, SAS/Macro, SAS/ODS, SAS/SQL, SAS/STAT, Excel, Proc SQL, PC SAS, DB2.

Confidential Role: SAS Programmer/Analyst Responsibilities: Utilized SAS/ACCESS to extract data from Teradata and other relational databases for analysis Prepared new datasets from raw sets files using Import Techniques and modified existing datasets using data statements such as set, merge and proc sort Tested and debugged existing macros Extensively used proc report and proc tabulate to create reports. Generated safety tables, which also involved in analyzing data and generating Reports Created reports using the DATA NULL and the proc report for the submission as per the regulations and company standards Validated SAS data sets using procfreq, proc means and procunivariate. Formatted HTML, RTF and PDF reports using SAS output delivery system ODS Worked with automation team to automate the reports using SAS/DDE and VB macros. Performed quality control checks on tables, listing etc generated by other team members. Presented the results and statistical reports in PowerPoint for marketing staff. Created a customer mailing list for Direct Mailing and Telemarketing. Provide SAS Programming support and technical assistance in the accurate development and intermediate steps required. Environment: SAS/BASE, SAS/MACRO, SAS/Access, Enterprise Guide, SAS/STAT, MS-Excel, Visio, Teradata, Windows XP

Confidential Role: SAS Programmer/Analyst Responsibilities: Modified/developed SAS codes for data cleaning and Reporting and to support routing processing. Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/ Base and SAS/ Macro facility. Identified problems with the data, if there were any, and also produced derived data sets, tables, listings and figures, which analyzed the data. Produced quality customized reports by using proc tabulate, proc report, and proc summary and also provided descriptive statistics using PROC Means, Frequency, and Univar ate. Report generation using many SAS procedural statements, SAS/MACROS, and data null steps. SAS was used for pre-processing data, SQL queries, data analysis, generating reports, and statistical analyses. Processed data collection to ensure proper quality of data. Maintained the daily error log for cleaning the data. Worked on edit check programs to maintain data consistency and data validation. Transformed the statistical data in various formats excel, access into SAS data sheets. Provided statistical programming expertise in the production of analysis, tabulations, reports and listings. Developed various SAS reports for Survey project and involved in code reviews for all the developed reports. Run daily report to help determined how many loans are in foreclosure or will be in foreclosure within the next ten days. Environment:SAS/BASE, SAS/SQL, SAS/ACCESS, MS Excel, MS Power Point, Window NT/2000