SUMMARY:

• Overall 6+ years of experience as a SAS Programmer/Analyst in Finance and Healthcare industries. Excellent Extensive experience of data extraction, manipulation, mapping and validation of data. Analytical, methodical and resourceful approach to problem solving, Implementing Corrective Actions to meet short and long term business needs.
• Strong Experience in using SAS/Base, SAS/Macros, SAS/SQL, SAS/ACCESS for data extracting, data cleansing, and reporting.
• Expertise in SAS programming, using BaseSAS, Enterprise Guide for Data Cleansing.
• In - depth knowledge of SAS programming, data processing, data collection, quantitative and qualitative data analysis.
• Experience in using SAS to import/export data to external files like flat, Excel.
• Strong ability to write SQL queries usingPROC SQL.
• Solid Understanding and Proficient use of SASFormats/Informats, Merge, Joins, Proc Datasets, Proc Sort, Proc Transpose and Proc Rank for Data Manipulations.
• Expert in using SAS procedures, SAS functions for producing summary datasets and reports.
• Developed new macros to modify and optimize existing SAS programs. Customize the variables values to user-defined formats usingPROC FORMATin printing reports.
• Experience in creating ad-hoc reports in tight schedules using various SASProcedures.
• Experience in SASReporting Procedures like PROC REPORT, PROC FREQ, PROC MEANS, PROC TABULATE, PROC PRINT.
• Hands on experience in working with SAS Enterprise Guide Software for reporting and analytical tasks.
• Proficient in creating and maintaining many datasets using Array, Merge, Update, Set and Proc SQL.
• Experience in extracting data from external RDBMS (Oracle, Teradata, MS Access) tables using SQL PASS-THROUGH facility,SAS ACCESS by Libname.
• Good Experience in Korn Shell scripting in UNIX.
• Hands on experience working with SAS DI Studio, SAS Enterprise Business Intelligence Server (SAS/EBI) and SAS Web Report Studio.
• Experience in producing AD-HOC reports in RTF, HTML and PDF formats using SAS/ODS.
• Proven ability to work under pressure, prioritize and meet deadlines.
• I have a strong ability to adapt and learn new technologies and new business lines rapidly.
• Effective team player with strong communication & interpersonal skills.

TECHNICAL SKILLS:

SAS Tools: SAS V9.X, SAS/BASE, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/ SQL, SAS/ACCESS, SAS BI, EG, Web Report studio.

Operating systems: Windows 95/98/2000, Windows XP, UNIX

Data bases: MS-SQL Server, MS-Access, Oracle, Teradata, DB2

Office Tools: MS Office, Lotus Notes

WORK EXPERIENCE:

Confidential, Mahwah, NJ

Sr. SAS Programmer/Analyst

Responsibilities:

• Actively participate in the design, development and supporting of clinical data processing systems.
• Work closely with Data Management to assure data quality by providing SAS Ad-hoc reports.
• Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS, MS Access and Excel.
• Extensively worked on data, add & term data and different LOB.
• Perform data cleansing by analyzing and eliminating duplicate and inaccurate data using PROC FREQ, PROC COMP and PROC UNIVARIATE.
• Use Base SAS to analyze various tables using Data manipulation techniques like merging, appending and sorting.
• Provide input and review to statistical analysis plans for clinical studies.
• Identify and program SAS edits checks per Data Management Plan.
• Worked with the Statisticians, Data Managers to provide SAS programming in analyzing Clinical Data.
• Perform data analysis, statistical analysis, generated reports and graphs using SAS tools SAS/Base, SAS Enterprise Guide, SAS/Macros, SAS/Graph, SAS/SQL.
• Extracted Clinical trial data from Oracle database by using SQL pass-through facility.
• Used Business Intelligence reporting tool SAS Web Report Studio.
• Worked with Statisticians and Clinical Data Managers to provide SAS programming in analyzing the Clinical Trials and generating Reports.
• Efficient in creating customized reports using SAS ODS facility.
• Generate and export various reports and tables in different formats like RTF, HTML, and PDF based on different user group requirement using SAS Enterprise Guide.
• Generate reports using DATA NULL and SAS procedure such as PRINT, REPORT, TABULATE, FREQ, MEANS, SUMMARY AND TRANSPOSE.
• Ensure timely delivery of tables, listings, and summaries requested by users.
• Validate the programmed analysis datasets, listings and figures, and create validation documentation.
• Participate in continuous improvement activity and process re-engineering projects in support of Confidential ’ continuous improvement initiative.
• Document methodology, data reports and communicate with the Project Team / Manager to share knowledge.

Environment: SAS Enterprise Guide 4.1, SAS (BASE, STAT, MACRO, ETS, CONNECT), UNIX, Windows NT, Teradata DB, SASStored Processes WebApplication,SASWebPortals.

Confidential, San Francisco, CA

SAS Programmer

Responsibilities:

• DevelopedCredit Risk Analysis Model based on Fico scores.
• Responsible for Anti-money laundering & Fraud Management for security purpose.
• Monitored fraud and customer experience trends to ensure performance.
• Experience with implementing Fraud Management system to detect and prevent fraud.
• Responsible for detecting & preventing network fraud by visualizing customer data networks and analyzing previous hidden connection and relationships.
• Experience in bringing huge amount of data from SAS and non-SAS data sources into a SAS environment and performing SAS data manipulations against the resulting sets. This includes ability to merge datasets and to write SAS Macros and generate list outputs/reports.
• Used SQL pass-through facility to connect to Oracle tables and created datasets using various SQL Joins.
• Worked on pre-existing macros for data validation by checking data distribution and comparison to standard data.
• Performed extraction, transformation and loading from large Oracle tables.
• Stored and distributed SAS Enterprise Guide (BI) results in different formats (HTML, PDF, RTF) using SAS/ODS, based on the user group requirement.
• Performed data cleansing by analyzing and eliminating duplicate and inaccurate data using PROC FREQ, PROC COMP, and PROC RANK in SAS.
• Generated customized reports using PROCREPORT, PROC TABULATE and Proc SQL.
• Cleansed the existing huge datasets with transpose and made one unique record per each customerID.
• Created reports on the fly to know the commitment amount and outstanding balances of the retail and commercial loans for the business executives.
• Good Experience in writing Korn-shell scripts for executing SAS batch files on UNIX
• Automated report generation using Korn-shell script scheduling on UNIX.
• Prepared customized reports to help client provide a strong competency in understanding risk and accordingly perform better customer selection and customer satisfaction.
• Ran ad-hoc queries/reports as needed and analysis is done as requested.

Environment: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/CONNECT, SAS/GRAPH, SAS/ODS, MS Excel, Oracle 9i,UNIX, SAS Enterprise Guide.

Confidential

S AS Programmer

Responsibilities:

• Experienced in generating statistical figures that support analysis and report presentation.
• Interpret data and generate the needed statistic figures for presentations.
• Perform validation on derived datasets and extensively used PROC SQL to perform queries, join tables.
• Managed, designed, and implemented various projects using theTeradatarelational database system.
• Recreated complex reporting mechanisms from Excel application to SAS on the Web.
• Involved in Analysis & Marketing Team to make business decisions.
• Interacting extensively with end users on requirement gathering, analysis and documentation.
• Created SAS datasets using Import Wizard and PROC SQL. Created user defined formats using Proc formats and Informats and data set was sorted using Proc Sort.
• Developed complex SAS Macros to simplify SAS code and effectively reduce coding time.
• Used the PROC CORR to know the relationship between dependent and independent variables.
• Imported Data from relational database (Teradata) into SAS files per detailed specifications.
• Imported data using LIBNAME and PROC SQL Pass -Through facility to reduce processing time.
• Performed complex statistical analysis using PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG, and PROC ANOVA and carried out data extraction using PROC SQL, PROC SORT, PROC REPORT to create preferred customer list as per business requirements.
• Used SAS ODS facility to create customized reports in HTML.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools e.g.SAS Integration Studio, SAS/Graph, SAS/SQL, SAS/Access.
• Created reports in the style format (RTF, PDF and HTML) using ODS statements.
• Effectively prepared and published various performance reports and presentations.
• Developed Ad-hoc reports using SAS Enterprise Guide.

Environment: SAS/BASE, SAS/MACRO, SAS/ETS, SAS/CONNECT, SAS Enterprise Guide 4.3, SAS Web Report Studio, Teradata, Windows XP, UNIX.