PROFESSIONAL SYNOPSIS

• Sr SAS Data Analyst/SAS Programmer with Over 7 years of experience working in direct marketing, credit card services, healthcare and retail Industries.
• Attained Master Degree in Public Health, and Bachelor Degree in Statistics and Information Science.
• Hands on experience in using SAS as data management and statistical analysis tool in bank, medical center, and other financial services.
• Extensive experience in SAS/BASE, SAS/STAT, SAS/MACRO, SAS/GRAPH, SAS/ACCESS, SAS/SQL, SAS/ODS, in Windows and UNIX environments.
• Hands-on experience in creating SAS datasets in large volume data.
• Modified existing SAS programs and created new programs using SAS macro variables to improve ease and as well as consistency of results.
• Worked in group with statisticians and surgeons to provide SAS programming support for analyzing the clinical trial data and generating reports, tables, listings, graphs and summaries.
• Extensive experience with regression analysis, correlation analysis, analysis of variance, survival analysis, multivariate analysis, non-parametric analysis on clinical trial data.
• Experience delivering output in different formats including HTML, RTF, PDF, and creating Custom reports using SAS ODS facility, Proc Report and SQL pass through facility.
• Expertise in using MS Word, MS Excel, PowerPoint and MS Access.
• Having good analytical and problem solving skills.
• Having good communication, Interpersonal and Presentation skills.

TECHNICAL SKILLS:

• Statistical Software: SAS V9.3, SAS V9.2, SAS/Base, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ODS, SAS/Access , SAS Enterprise Guide, SPSS, R, S-Plus
• SAS Procedures: Print, Frequency, Means, Summary, Tabulate, Chart, Gchart, Plot, Gplot, Univariate, Corr, Contents, Compare, Append, Copy, Datasets, Format, Options, Sort, Transpose, Report, SQL, ANOVA, Reg, Lifetest, Phreg, Logistic, Mixed, GLM, Genmod, npar1way, Macro, Univariate, Import/ Export
• Databases: MS Access, SQL queries
• Tools: SAS, MS Office suite 2003/2007/2010, SPSS, R, S-Plus
• Operating Systems: Windows NT/2000/XP/7/8, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Sr. SAS Programmer

Confidential is a private, not-for-profit organization with several major facilities and many outpatient centers. Our primary mission is to provide compassionate, high-quality healthcare to the greater Philadelphia region.

Responsibilities:

• Worked with a team of Statisticians and Data Managers for Generating Safety and Efficiency tables by leading all projects.
• Gathered and transformed data from flat files using SAS/ACCESS.
• Developed and Modified SAS Macros for Data Cleaning, Validation, Analysis and Report generation.
• Drew flowcharts indicating the input data sets, sorting and merging techniques.
• Wrote code using SAS/Base and SAS/Macros to extract clean and validate data from flat file, Excel file, RDBMS, Access Database, and Oracle Database using SAS ETL and dbload processes.
• Extensively using DO LOOPS, ARRAY, and SAS/STAT to manipulate numerical data and scientific data.
• Developed and improved the efficiency of programs through the use of SAS macros and SAS/SQL.
• Write Procedural Language SQL PL/SQL query for data manipulation and data analysis.
• Used variety of Base SAS procedures for analysis, management, presentation and access of the data. Used many of Base SAS functions for data cleaning.
• Build, maintained, and managed SAS OLAP cubes for multidimensional data.
• Introduced new variables with existing variables based on business logics using keep and drop statements.
• Modified standard programs to generate data sets for statistical data analysis, generate listings, summaries, tables, graphs and reports for analyzing data results in compliance with relevant SOPs as per SAP.
• Produced Reports, Listings, Tabulations and Summaries of the data using procedures such as PROC MEANS, PROC SUMMARY, PROC UNIVARIATE, PROC TABULATE, and PROC REG.
• Creating routine and ad-hoc reports using PROC PRINT, PROC FREQ, PROC CHART and PROC REPORT.
• Extensively using PROC GPLOT and PROC GCHART for generating graphs and plots.
• Formatted HTML, RTF and PDF reports, using SAS Output Delivery System ODS .
• Preliminary data validation and data correction of data using PROC COMPARE and PROC CORR.
• Making summary presentations of business highlights to senior management.
• Documenting process flow, improving and updating procedures for existing SAS applications.
• Interacted with other team members to discuss the required development to be implemented in coding to improve the functionality and effectiveness.

Environment: SAS 9.3, SAS 9.2, SAS/Base, SAS/Macro, SAS/Graph, SAS/SQL, SAS/Access, SAS/ODS, SAS/BI, SAS/DI, SAS/OLAP, SAS/Enterprise Guide, SAS/STAT, MS-Excel and Windows 7.

Confidential

Sr.SAS Programmer

Confidential offers a complete line of financial services, insurance products, and investment solutions.

Responsibilities:

• Developed SAS programs to create a customer mailing list for Direct Mailing and Telemarketing.
• Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.

• Worked on updating and maintenance of data warehouse and generation of various sales and marketing reports.

• Worked on creating SAS Data sets from flat files and merging data.
• Maintained and enhanced existing SAS reporting programs for marketing campaigns.
• Performed forecast analysis for campaigns.

• Performed data analysis, created reports with extensive use of BASE SAS, macro and SAS reports with the help of default procedures.

• Generated Graphical analysis using SAS Report and SAS /GRAPH.
• Integrated time series, linear regression and econometric techniques for modeling, forecasting and simulating business processes.

• Created reports using SAS /ODS and SAS /views from oracle database tables into different formats like HTML and RTF.

• Test modeling methodology and validate models PC/SASv9.1.3, SASv9.1.3 on Windows, AS/CONNECT, SAS/AF w/frames, SAS/ETS, and Forecasting Server, Enterprise Guide, SAS/SQL, SAS/Macros, Microsoft Windows products, all MS Office Suite products
• Used PL/SQL and PROC SQL Pass through Facility to work with ORACLE and DB2.

Environment: SAS 8.2, SAS 9.0, SAS/Base, SAS/Macro, SAS/Graph, SAS/SQL, SAS/OLAP, SAS/Enterprise Guide, SAS/STAT, Web Reports Studio, MS-Excel and Windows XP/7.

Confidential

SAS Developer

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 Oracle database.
• Performed various statistical works to resolve and develop SAS applications using PROC REG, PROC UNIVARIATE, PROC CORR, PROC ANOVA, PROC MEANS etc.
• Created new financial tables and manipulated customer data by using various joins and merges and then appended the data proc append from the existing source tables containing millions of records.
• 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.
• 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.
• Data validation was done using SAS Enterprise guide.
• Used several arithmetic, aggregate, character, date time, character sting matching and special mathematical functions in expression builder while mapping the data to output datasets.

Environment: Windows 2003/XP/7, Oracle, Base SAS 8/9, SAS/MACRO, SAS/STAT, SAS/SHARE SAS/ETS, SAS/GRAPH, SAS/ACCESS, SAS ENTERPRISE GUIDE 4.2

ConfidentialSr. SAS Programmer

Confidential is a full service marketing communications agency which provides marketing and sales solutions in consumer segmentation and targeting for the consumer goods industry. The project involved generating forecasting reports to help the client companies to predict future market growth and do strategic planning based on the reports.

Responsibilities:

• Extracted source data from Oracle to SAS data sets by using PROC SQL and taking care of the discrepancies in the data using BASE SAS.
• Created new datasets from raw data files using SAS Import Techniques and modify existing datasets using SET, MERGE, SORT, UPDATE, and conditional statements.
• Document and Validate reports in compliance with regulations specified. Produced quality customized reports by using PROC REPORT, PROC TABULATE and PROC SUMMARY.
• Developed regression models and generate reports using PROC REPORT, PROC TABULATE for consumer profiling, segmentation and targeting.
• Created 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.
• Created reports in PDF and RTF format using SAS/ODS and PROC TEMPLATE.
• Routinely used Base SAS, SAS/Macros, SAS/SQL, SAS/Graph, and SAS/Stat.

Environment: SAS/BASE V9.1.3, V8.2 , SAS/STAT, SAS, SAS/MACRO, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/ETS, SAS/QC, SAS/Connect, UNIX, MS Access, EXCEL, Web Reports Studio, SPSS, Windows 2000/XP

Confidential SAS Developer

Responsibilities:

• Interacting with business users to gather requirements, analyze the requirements and provide estimation on the requirements.
• Preparing Functional specification documents, technical design documents, Impact analysis documents.
• Creating test cases and unit test plans.
• Involved in development and system integration testing.
• Creating SAS programs using Base SAS, SAS Macros and SQL to implement edit checks and integrity check of data files.
• Using FTP to transfer files from server to server.
• Using SAS/CONNECT to interact and manipulate SAS datasets of other servers.
• Involved in creating ad-hoc reports for the business users.
• Coordinating with off shore team for various team requirements.
• Interacting with various support groups and DBA teams.
• Participating in technical discussions and business users meetings.

Environment: SAS 9/8.2 SAS/Base, SAS/STAT, SAS/Graph, SAS/MACRO, SAS/SQL, SAS/Access, SAS/ODS, MS-Excel and Windows XP.

Confidential

SAS Analyst

Responsibilities:

• Actively involved in design and implementation of application software using primarily SAS system and analyzed existing application software and recommended improvements.
• Designed flowcharts indicating the input data sets and the techniques that would be used sorting, merging, etc. to get the desired output.
• Developed SAS macros for data cleaning, reporting and to support routing processing.
• Present numerical information in various formats. Created SAS customized report using the Data null technique.
• Merging, Indexing, appending and sorting the data sets using various SAS procedures and other SAS tools
• Developed and executed SAS SQL queries for merging, concatenating and updating large volumes of data.
• Involved in validation of analysis datasets, tables and listings using Proc compare and code walk-through.
• Generated graphs using SAS/GRAPH and the SAS Graphics Editor
• Used Proc Report to generate reports
• Developed macros to generate customized report using DATA NULL and PROC REPORT, TABULATE AND SUMMARY
• Analyzed and interpreted numerical data from various sources organized and summarized data for analysis.

Environment: SAS 8, SAS/Base, SAS/Graph, SAS/SQL, SAS/MACRO, SAS/STAT, SAS/ODS, MS-Excel and Windows XP.