PROFESSIONAL SUMMARY:

• Experienced SAS Analyst with 6 years of experience in SAS Programming, Merging SAS Datasets, and Developing SAS procedures, Macros, Preparing Data, Producing Reports, SAS Formats, SAS Functions, SAS Informats, Storing and Managing Data in SAS Files.
• Extensive experience in SAS/Base, SAS/Stat, SAS/Macros, SAS/SQL, SAS/ODS, SAS/Graph, SAS/Connect, SAS/Access, SAS/EG.
• Experienced with Proc Sql, Proc Datasets, Proc Format, Proc Print, Proc Append, Proc Tabulate, Proc Gplot, Proc Gchart, Proc Compare, Proc Import, Proc Export, Proc Transpose, SAS/Stat procedures such as Proc Freq, Proc Means etc.
• Experience in Data extraction from several databases including Oracle, SQL Server and other external files using SAS/Access, SAS/SQL pass through facility, Libname statements, and Proc Import procedure and also via SAS Data steps.
• Good experience in Proc SQL joins and Proc SQL set operators to combine tables horizontally and vertically and proficient in Integration of various Data Sources like MS-Access, Flat and CSV Files.
• Skilled in data manipulation and generating customized reports with SAS data steps and procedures and have experience in handling large amounts of data for Data Cleansing, Data Profiling and Data Scrubbing.
• Extensive experience in SAS/Report generating procedures like Proc Summary, Proc Freq, Proc Means, Proc Univariate, Proc Transpose, Proc Format, Proc Report, Proc Tabulate, Data Null etc.
• Experienced in producing RTF, Excel, PDF, HTML formatted files using SAS ODS facility.
• Expertise in generating Graphs by employing SAS procedures like Proc Gplot, Proc Gchart.
• Proficient in writing, editing and debugging code using SAS/Base and SAS/Macro.
• Proficient in creating new Macros and Updating existing Macros for daily, weekly and Monthly report.
• Good skills in statistical parametric analysis methods such as Correlation, Regression, Analysis of variance and general linear models using SAS/Stat procedures such as Proc ANOVA, Proc GLM, Proc CORR, and Proc REG.
• Experienced in building BI/EIS applications using OLAP tools.
• Good understanding of study related Statistical Analysis Plan SAP and produced Tables, Listings and Graphs based on the specifications in SAP.
• Extensively worked with Business Partners, Statisticians, and key stakeholders to provide SAS programming for analyzing data as well as generating reports, tables and listings.
• Good ability to work on multiple tasks and strong interpersonal, analytical, presentation skills, communication and problem solving skills and work independently as well as in a team.

TECHNICAL SKILLS:

• SAS Tools SAS 9.3/9.2/9.1.3, SAS/BASE, SAS/MACRO, SAS/SQL, SAS/ACCESS,
• SAS/STAT, SAS/ODS, SAS/CONNECT, SAS/GRAPH,
• SAS/ENTERPRISE GUIDE, SAS OLAP CUBE STUDIO,
• SAS/ENTERPRISE MINER, SAS/INFORMATION DELIVERY
• PORTAL Databases Oracle 10g/11g, MS SQL Server 2008/2012, Teradata 12/13, DB2,
• MS Access, Informix
• GUI Tools MS Office, MS Project, MS Visio Commercial Tools Informatica, Expediter, FileAid, Rapid SQL, Crystal Reports, Hyperion,
• ERWin, Roscoe, RCS
• Operating System WINDOWS XP/Vista/7/8, UNIX Reporting tools Crystal Report, Hyperion, MS SQL Server Reporting Services

PROFESSIONAL EXPERIENCE:

Confidential

SAS Data Analyst

Responsibilities:

• Created SAS dataset from tables in Database using SAS/Access and Retrieved the Sales data from flat files, oracle database and converted to SAS datasets for Analysis using SAS/Stat procedures.
• Wrote various queries using SAS/Base, SAS/SQL and SAS/Macro for creating reports according to the Users requirement.
• Effectively worked with users to define business processes and information systems for supporting those processes.
• Performed Data analysis, statistical analysis, generated reports, listings and graphs using SAS Tools SAS/Base, SAS/Macros and SAS/Graph, SAS/SQL, SAS/Connect, SAS/Access.
• Defined and documented business logic and system processes.
• Performed programming of data listings using SAS. Converted MS-Word documents and Excel tables into SAS datasets.
• Involved in development and enhancements of SAS Programs.
• Conducted and generated the Regression, Correlation studies and Analysis of Variance ANOVA using Proc REG, Proc CORR, Proc GLM, Proc ANOVA.
• Successfully generated permanent and temporary SAS datasets.
• Involved in writing code using Base SAS and SAS/Macros to extract clean and validate data from oracle tables.
• Ensured quality of dataset at the protocol level while working to deliver competitive advantage and cost efficiency to the company as a whole and achieved these tasks by serving as member in data management team.
• Created SAS Customized Reports using the Data Null technique, Proc report and proc tabulate.
• Generated graphs using SAS/GRAPH and the SAS Graphics Editor.
• Developed routine SAS Macros to create tables, graphs and listings.
• Created SAS Macros for data cleaning and Reporting and to support routing processing.
• Extensively used the SAS/ Macro facility for automation process and to write weekly and monthly reports.
• Produced RTF, PDF and HTML formatted files using SAS/ODS to produce ADHOC reports for presentation and further analysis.

Project Environment: SAS 9.3, SAS/BASE, SAS/SQL, SAS/ODS, SAS/Graph, SAS/Macro, SAS/Access, SAS/Stat, SAS/Add-in, SAS/EG, Oracle database 11g, SQL server 2012, MS Excel, MS Access etc.

Confidential

SAS Programmer/Analyst

Responsibilities:

• Formatted data using SAS defined and user defined formats using Proc Format. Scheduling daily, weekly and monthly reports using SAS/Macros.
• Worked with large customer response and sales datasets and generated graphs using SAS Report and SAS /GRAPH.
• Performed data analysis, created reports with extensive use of BASE SAS, macro and SAS reports with the help of default procedures.
• Used SAS Enterprise Guide for SAS for data access and Ad hoc reporting.
• Performed Data de-duplication on working with several millions of records and data points.
• Created standalone Macros to check data quality and generate summary statistics for score datasets
• Acted as liaison between various Survey/Research providers to meet specific data needs and providing quick support in the form of data appends and Ad hoc reports.
• Involved in creating mail list for customer satisfaction survey and follow up surveys on retention initiatives
• Maintained and enhanced existing SAS reporting procedures for churn reporting and marketing campaigns
• Extensively used SAS/Base procedures and functions for data manipulation and creating summaries data values
• Reviewed company's churn reports and churn operations procedures for business understanding and reducing ADHOC report delivery time
• Accessed Analytics Data Mart using SAS/Access facility, SAS SQL procedures

Confidential

SAS Data Analyst

Responsibilities:

• Extracted, transformed and loaded ETL datasets with basic modeling variables for each segment type using Proc Import and SQL queries, imported data from Oracle database into SAS files.
• Extracted data from the Oracle database using SAS/Base, SAS/Access, and wrote SQL queries using Proc SQL procedures and created SAS datasets.
• Involved in data manipulations and stored the updated data into corresponding data marts in Oracle warehouse.
• Acquired raw data from Oracle tables and loaded the data into SAS datasets for further analysis and reporting.
• Manipulated and updated the tables as per specifications.
• Performed data cleaning by analyzing and eliminating duplicate and inaccurate data using Proc Freq, Proc Comp, Proc Univariate, and Macros in SAS.
• Formulated action plans and presented key information regarding profit dynamics to the senior management in the Bank.
• Maintained consistency of SAS variables formats and sorted various datasets using Proc Sort and merged them using Merge
• Used regression techniques ANOVA, CORR, Proc Means and Proc Freq to analyze the data.
• Prepared ad-hoc reports, documenting SAS work, and directing SAS outputs to RTF and HTML files through SAS ODS facility.
• Developed complex SAS Macros to simplify SAS code and effectively reduce coding time.

Project Environment: SAS 9.3, SAS/Base, SAS/Connect, SAS/ODS, SAS/Stat, SAS/SQL, SAS/Graph, SAS/Access, Oracle 11g.