Career Profile:
To obtain a challenging position as SAS Programmer where I can put forth the best of my knowledge and experiences for the growth of the organization.

• SAS programmer with over 7 years of Professional experience in working with SAS with strong emphasis on SAS Programming for Reporting , Modeling, Data analysis , and Data manipulation for Risk Management, Marketing, and Financial departments of large enterprises.
• Experienced in using SAS to read, write, import and export to another data file formats, including Delimited files, Microsoft Excel, PDF, Access Tables and from various other type of servers.
• Expertise in using various SAS report generating procedures like PROC REPORT, PROC FORMAT, PROC GPLOT, PROC COMPARE, PROC EXPORT, PROC SQL, PROC SUMMARY, PROC IMPORT, PROC UNIVARIATE.
• Generated reports using PROC REPORT, DATA_NULL_ AND PROC TABULATE for customized report writing.
• Experience in developing, validating and implementing SAS programs; and produce derived datasets for analysis and generating documenting reports.
• Used ODS to display outputs In HTML, CSV, RTF, PFD or other file formats.
• Experience in Proc SQL joins and Proc SQL set operators to combine tables horizontally and vertically.
• Experience in developing complex SAS Programs, Macros using SAS procedures for data updates, data cleansing, and reporting.
• Extensively worked with various statistical analysis procedures like Analysis of Variance (ANOVA), Correlation and Regression (linear and logistic).
• Experienced in generating Reports, GLM, and ANOVA with other statistical software such as Data Desk, R, S-Plus, and SPSS.
• Extremely energetic, detail oriented, organized, team player with strong analytical abilities, communication skills, and problem solving skills.
• Highly persistent and motivated with willingness to assume responsibility.

Technical skills:

• SAS Skills: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/ACCESS, SAS/ODS, SAS/STAT
• Operating System: Windows 98/2000/XP, Windows Vista, Windows 7
• Statistical Software; Data Desk, R, S-Plus, SPSS
• C, C++, SQL
• Ms-Office Word, Excel, PowerPoint, Ms-Visio 2007

Education:
Master in Statistics
Bachelors in (Mathematics, Statistics, Computer Education)

Professional Experience:
INDUSTRY: Confidential,
CLIENT: Confidential,
DURATION: Dec 09 – current
ROLE: SAS Programmer/Developer
LOCATION: Van Nuys, CA

Confidential,is a privately held entertainment media company which specializes in producing a variety of entertainment programs and putting them on air. I was involved in Data cleaning, Data manipulation, Requirement gathering, Generating Reports, Statistical analysis, Data analysis, worked on Company’s customer details, Profits, Selling, Resellers, Distributors.

Responsibilities:

• Extensively used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE and PROC REPORT.
• Creating permanent formatted SAS data sets and developed reports using PROC REPORT, PROC TABULATE AND DATA_NULL_ for analysis.
• Used the Import and Export facilities in SAS to exchange data between SAS and Microsoft Office environments (Excel, Access)
• Developed reports as per business requirements and created various reports like Summary reports, Tabular reports etc.
• Created Macros and developed SAS programs for Data cleaning, Validation, Analysis and Report generation using newly created as well as existing macros.
• Performed Statistical Analysis with Statistical procedures and Univariate procedures from Base SAS and SAS/STAT.
• Used SAS Data Integration Studio to develop various jobs processes for extracting, cleansing, transforming, integrating, and loading data into Data marts and Data warehouse database.
• Used Data _Null_ and SAS procedures such as Report, Tabulate, Freq, Means, Summary and Transpose for producing customized reports using SAS Web Report Studio.
• Performed Sorting and Merging of data and generated, reports using SAS/Base, SAS/Stat and SAS/Graph, SAS/SQL.
• Used Enterprise guide 4 to write the stored procedures, Generate Reports and also performed Data and Statistical analysis.
• Modified existing SAS programs and created new programs using SAS macros to improve ease and speed of modifications as well as consistency of results.
• Provided all data analysis, ad-hoc and custom reporting of customer data. This involved extracting data from an SQL Server database, XML files, Flat files data used as input for SAS programs to create Excel spreadsheets, Access databases, and hard copy reports.
• Extracted data from SQL Server views using various SAS/Access methods including Libname statements and the SQL Pass Through facility.
• Used data step options like KEEP, DROP, RENAME, IF, WHERE, when reading raw data files.
• Work with business analysts and care managers to validate the business rules

Environment: Base SAS, SAS/SQL, SAS/ACCESS, SAS/GRAPH, SAS/MACROS, SAS/ODS, MS Excel, MS-Access, Enterprise guide 4.

INDUSTRY: Confidential,
CLIENT: Confidential, NJ
DURATION: JUN06-Dec 09
ROLE: SAS PROGRAMMER/Analyst
LOCATION: Newark, NJ

Confidential,NJ offers free and low-cost health insurance plans to eligible adults, children, families, and seniors living in New Jersey State. The project was to complete ad hoc and production analyses in support of major corporate initiatives related to Primary Care Medical Homes, quality of care, provider performance, and clinical outcomes.

Responsibilities:

• Worked in SAS PC for design, development and operations
• Create and implement robust database applications and reporting solutions for the Healthcare Analytics department.
• Assist business analyst and care managers for developing and reviewing the requirements. Develop/build Statistical Predictive models using linear and logistic regression and set up statistical benchmarking for quality measures and ranking.
• Generate daily, weekly and monthly reports using DDE and Excel features.
• Contribute to the continual improvement of the department by developing efficient methods for extracting data from source systems, automating processes, developing neat and accurate end-user reports, and expanding the use of new technologies.
• Generate clear and concise documentation for all projects.
• Expand technical and business knowledge through individual research and on-the-job training.
• Run reporting programs and downloaded the results into EXCEL.
• Carried out profiling analysis for customer data. Used PROC TABULATE and PROC REPORT. Standardized those reporting programs into macros.
• Created Reports using analysis output and export them to the web to enable the customers to have access through Internet.
• Moved data set across platforms.
• Worked extensively on Macros and Macros variables to generate the dynamic and automated code.
• Develop Macros to run the Facility Quality Measure (FQM) reports for the historical time periods using DO-LOOP

Environment: SAS/BASE, SAS/MACRO, SAS/STAT, SAS/SQL, PL/SQL, OS WINDOWS, MS EXCEL, MS-Access

INDUSTRY: Confidential,
CLIENT: Confidential,
DURATION: Nov04 - JUN06
ROLE: DEVELOPER/ANALYST
LOCATION: New York, NY

DESCRIPTION:
Confidential,provides a comprehensive range of financial services; personal financial services; commercial banking; corporate; investment banking and markets, private banking and other activities. I was also involved with the update and maintenance of the Data warehouse and generation of various reports. Data is loaded from database into SAS datasets, and Reports were generated.
Responsibilities:

• Modified data using SAS/BASE and Macros.
• Coding SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs.
• Created complex and reusable Macros and extensively used existing macros in developing SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Worked on pre-existing macros for data validation by checking data distribution and comparison to standard data.
• Created SAS Customized Reports using the Data _Null_ technique.
• Prepared graphs using the modified data for business analysis.
• Applied techniques like sorting and merging on the raw data sets and coded them using Proc SQL and SAS Macro facility to get the required output.
• Formatted HTML, PDF, CSV and RTF reports, using SAS –output delivery system (ODS)
• Extraction of data from data ware housing tables and data marts.
• Used SAS Macros and procedures like Proc SQL, Transpose, Univariate, Means, Freq Performed statistical analysis using One-way ANOVA
• Performed data cleaning and data manipulation for large datasets using data manipulating techniques such as updating, merging, and sorting.
• Creating Customized reports in Enterprise Guide for the users
• Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
• Extracting data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.

Environment: Base SAS, SAS/SQL, MS Excel, SQL Server, Enterprise guide, OS Windows