SUMMARY

• Over seven years of extensive industry experience in analysis, design, development of Statistical data models including data extraction and manipulation, writing macros and reporting on various projects, for Financial, Insurance, Pharmaceutical, Medical and Healthcare industries.
• Extensive experience in Base SAS, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/CONNECT, SAS/ACCESS, SAS/ETL, SAS/ETS, SAS/ODS.
• Comprehensive skills in working with Base SAS, SAS/MACRO in UNIX and Windows environments.
• Skilled in SAS Programming, merging SAS Data Sets, Macro Facility, Preparing Data, PROC, Producing Reports, Validating Reports, SAS Formats, Storing and Managing Data in SAS Files.
• Developed statistical data models for sales forecasting, customer business intelligence, customer behavior, promotional analysis, targeting marketing campaigns, etc.
• Experience in preparation of SAS datasets, Tables, Listings, Graphs, Reports and Summaries according to requirements, Statistical Analysis Plan.
• Extensive programming experience with SAS procedures proc datasets, proc format, Proc Tabulate, Proc SQL, Proc Report, Proc Transpose, Proc Print, SAS/STAT Procedures such as Proc Corr, Proc Reg, Proc Freq, Proc Means, proc Univariate, etc.
• Well versed with creating HTML Reports for financial data using SAS ODS facility, Proc Report and SQL pass through facility.
• Successfully increased portability of existing SAS programs and created new programs using SAS Macro variables to improve efficiency and consistency of results.
• Thorough experience in data extraction and sorting from various databases like Oracle, DB2 and MS Access etc., using SQL Pass through facility, library reference statements, etc.
• Experience in handling large volume data.
• Effective team player with excellent Communication & Interpersonal skills and strong leadership qualities.
• Self - motivated individual with strong Technical & Analytical skills. Always keen and eager to face up to challenges by means of novel and innovative ideas.

TECHNICAL SKILLS

Operating Systems: UNIX, WINDOWS 98/2000/NT/XP, MS-DOS

Programming Languages: SQL, PL/SQL

Hardware Platform: Windows 2000/NT Servers

Databases: Oracle 9X/8.x/7.x/6.x, MS SQL Server 2000/7.0/6.5, MS Access 2000

SAS Skills: Enterprise Guide v3.0, v4.1, SAS v9.1.3,v8.0

Others: MS Office, Adobe Photoshop

PROFESSIONAL EXPERIENCE

Confidential, CO

SAS Programmer/Analyst

Responsibilities:

• Developed and designed SAS programs/Macros to analyze financial data.
• Creating permanent formatted SAS data sets and developed reports using PROC REPORT, PROC TABULATE AND DATA NULL for analysis.
• Developed reports as per business requirements and created various reports like summary reports, tabular reports etc.
• Extensively used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE, and PROC REPORT.
• Developed SAS programs for statistical analysis and data displays.
• 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, SAS/GRAPH.
• Using Join to gather data from different tables in Oracle.
• Testing on large raw data file using FIRSTOBS and OBS option, use of Datalines to enter data internally
• Use of Proc Import procedure to import excel file into SAS
• Loop iteration in data step using Do-End statement.
• Built the summary reports after identifying the customers, their occupancy period and the revenue generated using PROC SUMMARY, PROC MEANS and PROC FREQ. Updated the Revenue item table on a daily basis. Generated listings and reports from SAS programs using MACROS, ODS and PROC REPORT/TABULATE and using Word, Excel and Power Point as well.
• Used data step options like KEEP, DROP, and RENAME as a part of storage efficiencies. Data set options IF, where, missover, truncover etc. were used in reading raw data files.

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

Confidential, CO

SAS Analyst / Programmer

Responsibilities:

• Extracted and analyzed data from the database using SAS/Access, SAS/SQL procedures and created SAS datasets.
• Created complex SQL queries to access the database.
• Developed SAS programs using SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS for statistical analysis and data display.
• Performed various statistical works to resolve and develop SAS applications using PROC UNIVARIATE, PROC CORR, PROC MEANS etc.
• Performed data analysis on the data sets using PROC MEANS, PROC FREQ, and PROC UNIVARIATE etc.
• Developed summary reports and graphs using SAS procedures like PROC FREQ, PROC GRAPH, PROC GPLOT, PROC GCHART, PROC UNIVARIATE, PROC SUMMARY, PROC REPORT, PROC MEANS, and PROC TABULATE etc.
• Developed custom reports using Data Null and Dynamic Data Exchange (DDE) technique.
• Used ODS statements and PROC TEMPLATE to create reports in style format.
• Used SAS extensively to create ad hoc reports match merge and created graphs by using SAS/GRAPH base.
• Used SAS Macros, PROC SQL to extract, sort match test accounts and ODS to HTML, PDF and RTF.

Environment: Windows 2000/NT/XP, Oracle 8i, Base SAS v8.2, SAS/MACRO, SAS/STAT, SAS/ETS, SAS/GRAPH

Confidential, Beaumont, TX

SAS Analyst / Programmer

Responsibilities:

• Gathered and transformed data from Excel, Text files using SAS.
• Accessed flat files using SAS/ACCESS and created loaded as well as performed other SQL operations.
• Used SAS extensively for match merge, append data validation, and data correction and cleansing.
• Reports were generated based on requirements using PROC REPORT, PROC TABULATE, PROC PRINT and DATA NULL and outputs presented in PDF files.
• Reports were also generated in HTML formats using ODS techniques.
• Reported statistical outputs using SAS procedures like PROC MEANS, PROC FREQ and PROC UNIVARIATE.
• Produced weekly and monthly-customized reports by using PROC TABULATE, DATA NULL and PROC REPORT.
• Presented work to HR Managers in a very effective manner using SAS GRAPH.

Environment: UNIX, Oracle 9i, PL/SQL, Base SAS v8.2, SAS/SQL, SAS/ETL, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/STAT, MS-EXCEL.

Confidential

SAS Analyst / Programmer

Responsibilities:

• Extract source data from Oracle to SAS data sets by using PROC SQL and taking care of the discrepancies in the data using BASE SAS.
• Extract data, Create new datasets from raw data files using Import Techniques and modify existing datasets using SET, MERGE, SORT, UPDATE, and conditional statements.
• Document and Validate reports in compliance with regulations specified.
• Perform time series analysis, create regression models and generate reports using PROC REPORT, PROC TABULATE for consumer profiling, segmentation and targeting.
• Create reports in Excel spreadsheets using SAS/ODS and implementing them in PowerPoint presentation for the client.
• Access flat files using SAS/ACCESS.
• Use SQL pass through facility to access data, load and perform SQL operations.
• Create reports in PDF and RTF format using SAS/ODS.

Environment: UNIX, Oracle 9i, PL/SQL, Base SAS v8, SAS/SQL, SAS/ETL, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/STAT

Confidential

SAS Programmer

Responsibilities:

• Performed data analysis, completed the projects and presented the analyzed data.
• Transformed mortgage data in various formats (excel, CSV) into SAS data sheets.
• Provided statistical programming expertise in the production of analyses, tabulations, graphs and listings obtained from the excel data using Macros.
• Accompanied statisticians in various consulting sessions and provided support in statistical analysis including choice of experiment design, management of data, statistical procedures for analyzing experiments, interpretation of the results, statistical modeling and statistical computing.
• Developed macros for cleaning, transforming and modifying the data daily.
• Accomplished data manipulation on SAS data sets using techniques such as merging, appending, concatenating and sorting.
• Extensively used statistical procedures like PROC MEANS, PROC SUMMARY, PROC FREQ, PROC IMPORT, PROC UNIVARIATE, and PROC TABULATE.
• Extensively used statistical procedures like PROC FREQ and PROC MEANS to compute elementary statistical measures which include descriptive statistics based on moments, quintiles, confidence intervals, frequency counts, correlations and distribution tests.
• Applied statistical techniques to analyze and validate the model implementations.
• Created queries to generate HTML reports and tables using PROC SQL, PROC TABULATE and PROC REPORT to update the data daily.

Environment: Base SAS v8.2, SAS/Macros, SAS/SQL, SAS/ACCESS, SAS/STAT, SAS/ODS, VB/MS Excel, Windows XP.

Confidential

SAS PROGRAMMER

Responsibilities:

• Developed SAS programs to load data from the source and create study specific datasets, which are used as source data sets for report generations.
• Developed macros for report generation using SAS/Macros as per the statistician’s requirements and programs for statistical analysis and data displays.
• Developed ad-hoc queries on the data accessed from the database using PROC SQL. Designed and customized the style, templates and output layout for tables, reports, listings and graphs in PDF, HTML and RTF using ODS features there by providing greater control on report details such as fonts, size, data justification, order and label to meet the company’s standards.
• Extensively used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE, PROC REPORT, PROC GCHART and PROC GPLOT
• Created conditional logic macros for data-driven programs using CALL SYMPUT.
• Investigated and fixed several issues and suggested new output formats to meet the statistician’s requirements. Developed reports using PROC REPORT and PROC TABULATE.

Environment: Base SAS v8.2, SAS/Macro, SAS/SQL, SAS/STAT, SAS/ODS, SAS/GRAPH, MS Excel, WINDOWS XP, UNIX.