SUMMARY

• SAS programmer with over 7 years of experience in analysis, design, development, and validating the applications.
• Extensive experience in handling complex processes using SAS/BASE, SAS/MACROS, SAS /SQL, SAS/GRAPH, SAS/STAT, SAS/ODS, SAS/ACCESS.
• Expertise in analyzing and coordinating clinical trial data, generating reports, tables, listings and graphs.
• Proven skills in ad - hoc reporting and coding utilizing SAS.
• Strong experience in coding using SQL, Procedures/Functions, SAS macros.
• Experience in creating SAS programs and performed data validation on raw data sets and created data set for analysis.
• Good analytical skills pertaining understanding a business domain coupled with excellent teamwork and strong communication skills.
• Experience in creating test scenarios to find errors and confirm programs meet specifications. Program Documentation and Review.
• Followed System Development Life Cycle (SDLC) methodology for the design, development, implementation, and testing of various SAS modules.
• Capable of utilizing data management techniques like Merging, concatenating, interleaving of SAS datasets using MERGE and SET statements in DATA step.
• Performed PROC SQL joins and worked with PROC SQL set operators to combine tables horizontally and vertically.
• Experience in using various MS office tools for analyzing, arranging and presenting data
• Responsible for accessing and managing data and for performing complex queries and analysis.
• Producing data in various output formats including HTML, RTF, PDF, MS-EXCEL using ODS (output Delivery System).
• Experience in Modifying existing SAS programs and creating new SAS Programs using SAS MACRO to improve ease and speed of modifications as well as consistency of results.
• Proven ability to support multiple projects under deadlines often with competing priorities and complexities.
• Excellent organizational, teamwork, presentation, problem solving, decision making and interpersonal skills.

TECHNICAL SKILLS

SAS tools: SAS/BASE, SAS/GRAPH, SAS/ODS, SAS/MACROSSAS/STAT, SAS/SQL, SAS/ACCESSSAS/CONNECT, SAS/REPORTS

SAS Procedures: Print, Freq, Sort, Means, Univariate, Report, Correlation, SQLTranspose, Import, Export, Summary, Format.

Database: SQL e SQL server,MS Access, velos, oasis

Operating Systems: Windows XP, MS DOS, UNIX

Other Access: MS Office tools like MS Access, MS word, MS PowerPointMS Excel & SQL5p

PROFESSIONAL EXPERIENCE

Confidential, Marietta, GA

SAS Programmer

Responsibilities:

• Accessed multiple databases using SAS and provided ongoing reporting that supported information-based decision making, measured the execution of company strategy, and identified opportunities for improving existing processes.
• Served as data custodian and point of contact for operational data warehouse issues. Prepared data views for analyzers and viewers.
• Converted existing business information report packages to data warehouse platform where feasible.
• Developed and designed SAS Programs / Macros to access and analyze financial data.
• Conducting individual and group level analysis. Conduct significance tests and study response rates for different logical and non-logical exams separately data.Generated Statistical analysis files, tables, listings, and graphs.
• Developed, tested and maintained daily/monthly/quarterly report packages illustrating progress toward the Company’s strategic objectives.
• Involved in writing code using Base SAS & SAS/Macros to extract data from oracle tables. Worked with statisticians in generating SAS analysis datasets, production of data listings, summary tables, and statistical analyses.
• Met regularly with Support Services management and analysts to determine, interpret and program solutions to the information needs of the branches and Contact Center.
• UsingSAS/SQL for extract, transfer and load ("ETL") methodology and processes
• Developed reports according to SOP’s by using PROC TABULATE, Proc REPORT, Proc SUMMARY, Proc SQL and also provided descriptive statistics using PROC Means, Proc Freq.
• Documented policies and procedures required for supporting system enhancements.
• Quality control and assurance including running datasets/files through programs.

Environment: Base SAS, SAS/Macro, SAS/SQL, SAS/Connect, SAS/AF, SAS/Graph, SAS/Access, SAS/Stat, Oracle 9i,Teradata Windows NT and UNIX.

Confidential, Memphis, TN

SAS Programmer /Analyst

Responsibilities:

• Understand and update the existing code or create new code by using BASE/SAS, SAS/MACROS and SAS/SQL to implement new requirements.
• Expertise in statistical modeling and analysis on study data by utilizing appropriate statistical methods.
• Wrote various format and integrity edit checks on CSV files and on staging SAS datasets.
• Develop SAS code to validate data of different portfolios.
• 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.
• Generate Reports in user required format by using ODS and PROC Report.
• SAS data sets are validated using SAS procedures like Proc Means, Proc Frequency and Proc Univariate.
• Performed data integrity checks and data cleaning using SAS MACROS and data steps, created HTML outputs with table of contents using ODS HTML.
• Used SAS PROC SQL Pass through Facility to work with Teradata database.
• Analyzed and implemented the code and table changes to improve performance and enhance data quality.
• Created and revised the common macros.
• Reading data from different sources like .csv, excel, tab delimited files.
• Perform various business checks on the source data to confirm whether data is correct or not.
• Compare the source data with historical data to get some statistical analysis.
• Perform transformations like Merge, Sort and Update etc. to get the data in required format.
• Create the understandable EXCEL template to start dad mapping for each line of business.
• Extensively utilized SAS/BASE, SAS/SQL and SAS/MACRO.
• Extensively used procedures such as PROC APPEND PROC IMPORT, PROC MEANS, PROC SUMMARY, PROC CONTENTS and PROC SQL.
• Involved in project review meetings with respective Business SME’s.
• Generate the genealogy by using EXCEL MACRO to make it better understandable to end user.

Environment: SAS 9.1.3, BASE/SAS, SAS/MACRO, SAS/SQL, SAS/CONNECT, SAS/ACCESS, SAS/ODS, Oracle 11g, UNIX and Windows XP.

Confidential, Birmingham, AL

SAS Programmer

Responsibilities:

• Created reports for online and batch applications for various servers.
• Modified data using SAS/BASE and Macros.
• Prepared graphs using the modified data for business analysis.
• Creation of Data Sets on the Remote Server.
• Decreased the run time of the existing SAS programs by eliminating redundant DATA steps by using WHERE statements instead of IF statements and using PROC FORMAT to format SAS variable values instead of multiple IF statements.
• Coding SAS programs with the use of SAS/BASE and SAS/Macros for ad hoc jobs.
• SAS scripts on MF are run, and the output datasets are exported into SAS.
• Monitored and Analyzed Bank and Cards application usage on MF.
• Maintained and enhanced existing SAS reporting programs for marketing campaigns.
• Maintained SAS statistical analysis for the products purchased every month.
• Used select/when statements wherever possible instead of if/then else statements to increase the efficiency.
• Presented the results and statistical reports in PowerPoint for marketing staff.
• Moved data set across platforms (from PC and Mainframe to UNIX and Vice Versa).

Environment: SAS/MACRO, SAS/SQL, SAS/STAT, SAS/PC, SAS/CONNECT, SAS/ACCESS, DB2, Base SAS, Mainframes.

Confidential, Minneapolis, MN

Clinical SAS Programmer

Responsibilities:

• Worked in Phases of clinical trials for heart diseases and diabetes.
• Designed and implemented statistical reporting processes for clinical data analysis.
• Extensively used SAS/Macro facility to provide reusable programs that can be conveniently used time to time and created tables, listing and graphical reports.
• Generated output files in text format, HTML & PDF format using SAS ODS.
• Created SAS transport (.xpt) files and converted the Transport files into SAS Data Sets.
• Used SAS/ACCESS to extract data from Oracle and other relational databases for analysis.
• Developed reports using PROC REPORT, PROC TABULATE and DATA NULL .
• Designed flow charts indicating the input datasets and the techniques that would be used (sort, merge, append) to get the desired output.
• Data Analysis and graphical presentation for various summary reports using Base SAS and SAS/Graph facility.
• Developed SAS programs for listing of tables for data review and presentation including adhoc reports, CRTs (Case Report Tabulations) as per CDISC, patients listing mapping of safety database and safety tables.
• Developed ADaM datasets as per client requirements based on CDISC standards.
• Created CRT datasets using CDISC standards for submissions to the FDA.
• Performed data validation on the data sets and deleted repeated values using conditional data steps such as @@, if-then statements.
• Good working knowledge of Clinical Trials data like Demographic data, Discrepancy data, Adverse Events (AE), Serious Adverse Events (SAE), Laboratory data (Lab data), Physical and Vital Signs and Audit trials.
• Established and maintained a sound working relationship and effective communication within (worked with) Bio-Statistics and Statistical Reporting and Clinical Research and Database personnel.

Environment: SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS, SAS/GRAPH, SAS/ODS, Windows, Excel, SQL, SPSS.

Confidential

Jr. SAS programmer

Responsibilities:

• Modified/developed SAS codes for data cleaning and Reporting and to support routing processing.
• Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/ Base and SAS/ Macro facility.
• Identified problems with the data, if there were any, and also produced derived data sets, tables, listings and figures, which analyzed the data.
• Produced quality customized reports by using PROC TABULATE, REPORT, and SUMMARY and also provided descriptive statistics using PROC Means, Frequency, and Univariate.
• Report generation using many SAS procedural statements, SAS/MACROS, and data null steps.
• SAS was used for pre-processing data, SQL queries, data analysis, generating reports, and statistical analyses.
• Processed data collection to ensure proper quality of data. Maintained the daily error log for cleaning the data.

Environment: SAS/BASE, SAS/SQL, SAS/ACCESS, MS Excel, MS Power Point, Window NT/2000