PROFESSIONAL SUMMARY:

• More than seven years’ experience of working as Data Analyst, SAS Programmer, SAS Developer in different industries
• Very good experience in financial Data Analysis, Generating Statistical Analysis datasets, Tables, Listings, Graphs and Validations.
• Extensive expertise in handling and processing programs using SAS BASE, SAS/STAT, SAS/MACROS, SAS /ACCESS,SAS VISUAL ANALYTICS etc.
• Ability to review SAS coding, debug SAS compiling errors and quickly identify areas of concern
• Good knowledge of statistical procedures like ANOVA, Correlation, Logistic Regression, Regression Analysis, Survival Analysis etc.
• Excellent in variousSASprocedures for data manipulation like Proc Summary, Proc Report, Data NULL, Proc Tabulate, Proc Freq, Proc Univariate, Proc Means, Proc SQL,Merge, Proc Sort, SAS Informats /Formats etc.
• Experience in converting SAS datasets to various types of files like RTF (Rich Text Format), HTML and PDF using Output Delivery System (ODS) and hands on experience in ad - hoc reporting.
• Excellent in performing data transfer activities between SAS and various databases and data file formats like XLS,CSV,DBF,MDB etc.
• Expertise in producing graphs in SAS by utilizing procedures in SAS/GRAPH like proc GPLOT and Proc GCHART.
• Excellent communication skills, a very good team player. Ability to work independently under minimum supervision, in a fast paced environment under deadlines.
• Knowledge and experience on R/R-Studio, STATA, SPSS, Python
• Thorough knowledge and experience of Microsoft office tools such as Word, Excel, Access, and PowerPoint.
• Effective team player with excellent analytical ability and problem solving skills.
• Strong communication, leadership and interpersonal skills with ability to interact with individuals at all levels.

TECHNICAL SKILLS:

Operating System: Windows 98/ 2000/ XP/ Vista/ 7/8/8.1,UNIX/LINUX

Office Tools: MS Office 2003/ 2007/ 2010/2013, MS-Word, MS-Excel, MS-Access, MS-

PowerPoint, Outlook, Visio:

SAS Tools: SAS 9.2/9.3/9.4, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/ODS, SAS/ACCESS, SAS/GRAPH, SAS/STAT, SAS Enterprise Guide 4.3/6.1, SAS Enterprise Miner 13.2

SAS Procedures: Proc Print, Means, Univariate, Report, Transpose, Summary, Tabulate, FreqSort, Gplot, Format, REG, IML, Proc Hadoop

Languages: SAS/SQL, HTML, JavaScript, Python, ORACLE, SQL, C, C++

PROFESSIONAL EXPERIENCE

Senior SAS Developer/Analyst

Confidential, New York

Responsibilities:

• Developed and designed different SAS programs to analyze financial data.
• Applied a range of quantitative analytical techniques to rigorously identify and solve client issues
• Developed reports as per business requirements and created various reports like summary reports, tabular reports etc.
• Creating permanent formatted SAS data sets and developed reports using PROC REPORT, PROC TABULATE and DATA NULL for analysis.
• Extensively used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE, and PROC REPORT.
• Used SAS extensively for match merge, append data validation, and data correction and cleansing.
• Responsible for maintenance and enhancements in reporting systems using SAS/BASE, SAS/MACRO, SAS/STAT, and SAS/GRAPH.
• Use of PROC IMPORT procedure to import excel file into SAS
• Built the summary reports after identifying the customers, their occupancy period and the revenue generated using PROC SUMMARY, PROC MEANS and PROC FREQ.
• Used data step options like KEEP, DROP, and RENAME as a part of storage efficiencies. Data set options MISSOVER, TRUNCOVER etc. were used in reading raw data files.
• Submitted reports for different financial services on daily basis.

Environment: SAS/Base, SAS/Access, SAS/Macro, SAS/SQL, SAS/Graph, SAS/STAT, SAS/Connect, MS SQL Server, MS-Excel, and Windows XP

Senior SAS programmer/ Data Analyst

Confidential, New York

Responsibilities:

• Integrated multiple data sources into consolidated analyses and measures
• Identified new opportunities for enhancing product offerings, such as by adding different data sources or additional demographic segments
• Modified data using SAS/BASE and Macros
• Extracting data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Coding SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs
• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using PROC REPORT, PROC SORT, PROC FREQ and PROC MEANS and DATA NULL .
• Involved in extracting, analyzing data from the data-warehouse using SAS.
• Worked with Financial departments to develop required applications for performing complicated analysis
• Prepared new datasets from raw sets files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update, Formats, and Functions.
• Created new datasets from existing data-sets by using concatenation, merging, interleaving and usingconditional statements.
• Worked with cross-functional teams to design, implement and test new consumer and audience measurement methodologies

Environment: Windows 2000, SAS 9.2/ SAS9.3, SAS/ODS, SAS/SQL, MS Excel, BASE SAS, SAS/ MACRO, SAS/ SQL

SAS Developer

Confidential, New York

Responsibilities:

• Maintaining large data sets, combining data from various sources in varying formats to create SAS data sets by using Set and Merge for generating Reports and graphs.
• Extensively using Proc SQL and Macros to extract the data and make reports
• Working closely with the modeling teams and to prepare data for analysis
• Assisting with further processing of the data to aid modelers during the development process
• Performing data analysis tasks at the direction of a modeler
• Translating business requirements into SAS code for use within internal systems and models
• Developing reports to inform management on model performance, and/or tools to facilitate understanding of model results
• Becoming one of the Predictive Analytics teams experts on internal servers and databases
• Developing and/or maintaining a library of commonly used macros and programs for data extraction, transformations, etc.
• Generation of graphical visualization reports and extensive use of SAS enterprise Guide for Ad Hoc reporting.
• Involving in maintenance and updates of data warehouse and generation of dashboard reports.

Environment: SAS 9.4, SAS Enterprise Guide 4.2/5.1, MS Access and Macros, Oracle, DB2, SQL Server, UNIX/LINUX

SAS Programmer

Confidential, North Carolina

Responsibilities:

• Used SAS/BASE, SAS EG, Macros to develop dynamic SAS programs to extract, validate data for Statistical analysis.
• Developed SAS programs using SAS Enterprise Guide for tabulation counts, correlations and check for dispersion for normality using PROC Means, PROC Tabulate and PROC Univariate.
• Used SAS Base procedures FREQ, SQL, SORT, TABULATE, and MEANS to analyze the data.
• Performed statistical data analysis, generated reports and graphs using SAS/Base, SAS/Macros, SAS/SQL, SAS/Access and SAS/Graph.Generated reports using Microsoft Excel Pivot tables.
• Generated web based reports via Web Report Studio to enable users and decision makers across the enterprise with self-sufficient access to consistent, accurate data and the predictive power of SAS analytics.
• Used SAS extensively to create ad hoc reports, match merge and created graphs by using SAS/GRAPH base. Generated output using SAS/ODS in CSV, XLS, DOC, PDF and HTML formats.
• Performed extensive regression and statistical data analysis using Proc REG, Proc GLM, and Proc ANOVA
• Transacted with various formats of data; flat files, CSV, XLS; to create and maintain large datasets.
• Implemented Set, Merge and SAS/SQL to perform suppressions and exclusions on the data.
• Developed reporting procedures using PROC REPORT, PROC TABULATE and DATA NULL .

Environment: Windows, UNIX, SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/CONNECT, SAS/ODS, SAS/SQL, SAS/Enterprise Guide