SUMMARY

• SAS Institute certified programmer with 7+ yearsof experience workingin SAS, Business Intelligence & Data Warehousing (BIDW) and related suite of tools.
• Experience includes BI applications, Data quality management, Data extraction, Data manipulation, Data validation and Data analytics.
• Has worked on stored processes, SAS Data Integration Studio to build the Warehouse, SAS Web Report Studio, SAS Enterprise Guide, SAS OLAP Cube Studio, SAS Information Map Studio, SAS Information Delivery Portal and SAS Add - In for Microsoft Office with back-end database such as Oracle, MS-Access, SQL Server, and DB2.
• Comprehensive skills in working with Base SAS, SAS/MACRO inUNIX and Windows environments.
• Extensive knowledge in data management like Merging, concatenating, interleaving of SAS datasets.
• Proficient in producing reports employing various SAS procedures, like Proc Print, Proc Report, Proc Summary, Proc Freq, Proc Tabulate, Proc Means, Proc Univariate, Proc Transpose, Proc SQL, etc.
• Generated output files in RTF, HTML, and PDF format using SAS ODS.
• Experience in performing data mining and statistical analysis using T-test, ANOVA, and Logistic regression in SAS.
• Excellent skills in diagnosing and avoiding errors, understanding and enhancing output to furnish reports.
• Exceptional problem solving skills with excellent communication skills, detail oriented, organized, enthusiastic to work in a fast paced and team oriented environment.

TECHNICAL SKILLS

SAS Tools: SAS 8/9, SAS/BASE, SAS/MACRO, SAS/SQL, ODS, SAS/GRAPH, SAS/STAT, SAS/ACCESS, SAS/Connect, SAS Enterprise Guide, SAS Data Integration Studio, SAS OLAP Cube Studio, SAS Web Report Studio, SAS Information Map Studio, and SAS Information Delivery Portal, SAS Add-In for Microsoft Office.

Data base: MS SQL Server, DB2, MS ACESS 2007/2010, Oracle 9i/10g.

Office Tools: MS Excel, MS Word, MS PowerPoint.

Operating System: Windows 98, 2000, NT, XP, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

SAS Data Analyst

Responsibilities:

• Extracted and analyzed data from the database using SAS/Access, SAS/SQL PROCEDURES and created SAS datasets.
• Extensively created stored processes using SAS Enterprise Guide 4.3
• Used Management Console 9.2 for registering the imported tables on the metadata server and for managing the user activity.
• Performed coding, testing, debugging, documentation, and installation tasks for on-line and batch processes reports in accordance with client specific internal procedures and standards.Wrote and modified SAS code in windows Environment
• Created and delivered reports via SAS Web Report Studio, Stored process Web Applications and Information Delivery Portal.
• Used data cleaning techniques such as Proc Freq, Proc Print, null, Proc Means, Proc Tabulate, Proc Univariate, Proc SQL, Proc SortNodupkey, Proc Character, invalid, and discrete data character values.
• Used Microsoft Add-In for delivering reports in word and excel
• Conducted Ad Hoc analysis to support business strategy
• Modified existing SAS programs and created new programs using SAS macro variables to improve ease and speed of modification as well as consistency of results.
• Extracted data from warehouse using SQL procedure and created SAS data sets.
• Extensively used SAS Data Integration Studio to perform several extractions and transformation SAS datasets.

Environment: SAS/ BASE, SAS/MACRO, SAS/STAT, SAS/CONNECT, SAS/ACCESS, SAS/EG, MS-Excel, Oracle 8i, IBM AIX 5.2, Web Application, SAS Web Report Studio, SAS Information Map Studio 4.2, SAS Information Delivery Portal, SAS Enterprise BI Server, SAS Data Integration Studio 4.3.

Confidential, Columbus, OH

SAS Programmer/Analyst

Responsibilities:

• Extracting financial data from the database using SAS/Access, SAS SQL, SAS/Connect, Procedure and create SAS permanent data sets in SAS library.
• Creating SAS Views from tables in Database using SAS/Access, and analyze data.
• Retrieved the financial data from flat files received from the vendors, convert them into SAS readable format. Make the SAS data sets, analyze data as per given requirement.
• Write the SAS code and run those data sets to produce necessary financial reports by using SAS/STAT Procedures such as PROC Freq, PROC Tabulate, Proc Univariate, and PROC ANOVA.
• Created required financial reports using analysis output and export them to other environments or the web using various SAS method like create delimited, text files, ODBC, CEDA, CPORT, ODS having formats such as HTML, RTF, or XML.
• Regular interaction with the financial analysts for the presentation.
• Performed in-depth quantitative data analysis.
• Extensively used procedures like PROC SQL, PROC PRINT, and PROC SORT etc.
• Coded SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs.
• Experience in Advanced SQL to extract data from various databases like Oracle.
• Experience in Transferring and converting data from one platform to another to be used for further analysis. (From Oracle and Excel to SAS both export and import of data)

Environment: Base SAS9, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, PC SAS, Oracle 9i, MS Excel, MS Access

Confidential - Pittsburgh, PA

SAS Programmer

Responsibilities:

• Worked with various data like EBCDIC, ASCII and Binary formats and extensively used different kinds of informats to read these data files.
• Produced reports using PROC GCHART, PROC REG, PROC TTEST for analysis and used UNIVARIATE and MULTIVARIATE ANALYSIS as Forecasting Methodologies also used the SAS Forecast Studio for speedy analysis of Forecast Models.
• Used Datastage for performing change data capture (CDC) on membership data.
• Created Ad - Hoc reports on need basis and publish on Internet usingSASWeb Report Studio.
• Conducted meeting with business users and data architects to define metadata for tables to perform ETL process bySASDI studio.
• Extensively used advancedSASprocedures like FREQ, REPORT and TABULATE to create output files for Ad hoc Reporting.
• Analysis included data reports, generalized reports, SQL queries to DB2 platform, variable distribution reports for clients as well as vendors.

Environment: SAS/BASE,SAS/MACRO,SAS/SQL,SAS/STAT,SAS/CONNECT,SAS/GRAPH,SAS/ODS, Korn Shell, UNIX, Mainframe, Datastage, IMS DBMS,SASEnterprise Guide.

Confidential, Nashville, TN

SAS Programmer/Analyst

Responsibilities:

• Extracting financial data from the database using SAS/Access, SAS SQL, SAS/Connect, Procedure and create SAS permanent data sets in SAS library.
• Creating SAS Views from tables in Database using SAS/Access, and analyze data.
• Retrieved the financial data from flat files received from the vendors, convert them into SAS readable format. Make the SAS data sets, analyze data as per given requirement.
• Write the SAS code and run those data sets to produce necessary financial reports by using SAS/STAT Procedures such as PROC Freq, PROC Tabulate, Proc Univariate, and PROC ANOVA.
• Design of ETL process to meet the requirement of data demand.
• Writing Meta data for important data set before archive into SAS metadata server.
• Used data cleaning techniques such as Procfreq, Proc Print, null, proc means, proc tabulate, Proc Univariate, Proc SQL, nodupkey, Proc character, invalid, and discrete data character values.
• Regular interaction with the financial analysts for the presentation.
• Performed in-depth quantitative data analysis.
• Coded SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs.
• Experience in Advance SQL to extract data from various databases like Oracle.
• Worked with SQLPLUS, and PL/SQL extensively to solve database problems to make database effective and efficient tuning purpose. In PL/SQL Implement of DML, Implicit and Explicit Cursors, function, conditional logic, creating and ODBC connection.
• Experience in Transferring and converting data from one platform to another to be used for further analysis. (From Oracle and Excel to SAS both export and import of data)
• Interfaced programs with Oracle databases to provide accurate reporting, archiving, and error handling.

Environment: Base SAS9, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, SAS/ETL, UNIX SAS, PC SAS, Oracle 9i, DB2, PL/SQL, MS Excel, MS Access .