PROFESSIONAL SUMMARY:

• SAS Consultant with over 8 years of extensive data - warehouse experience as well as in SAS Programming and Business / Data Analysis using SAS software in WINDOWS, UNIX and MAINFRAME environments. Experience in Data Management, ETL, Data Quality and BI projects. Experience in working with health care and banking domain, and working with claim data.
• Experience in all stages of Software Development Life Cycle (SDLC) including requirements analysis, architectural design, technical design, development, testing and documentation.
• Extensively used SAS macros and SAS scripts as well as joining data set, indexing, data aggregation, record selection, sub-setting, multiple records per case, creation and modification of views, accessing multiple databases.
• Hands on experience with SAS/BASE, SAS/MACRO, SAS/STAT, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/CONNECT and SAS/ODS procedures.
• Strong expertise in RDBS and SQL programming for data management.
• Strong experience with databases like Sybase, DB2, Oracle, Teradata, MS SQL Server and MS Access.
• Hands on experience in SAS programming for extracting data from flat files, Excel spreadsheets and external RDBMS tables using LIBNAME and SQL PASSTHRU facility.
• Extensive experience of Data merging, Data sub setting with the use of PROC SQL, MERGE and SET statements
• Experience in writing CRON jobs for executing SAS files on UNIX to save the execution time and report automation.
• Experience in processing large datasets for data transformation including data cleansing, data scrubbing, data profiling and applying business logic rules to incoming data.
• Experience in performing ad-hoc queries and User Acceptance Tests (UAT) for various application and reports on a daily/weekly or monthly basis.
• Build and executed queries in different SAS Environments using SQL.
• Generated Output files in RTF, HTML and PDF using SAS/ODS.
• Sound experience in using various CDISC standards like SDTM for data mapping and ADaM to create Derived/Analysis datasets.
• Expertise in SAS Procedures like Proc Print, Proc freq, Proc means, Proc summary, Proc sort, Proc Univariate, Proc Transpose, Proc SQL for generating reports.
• Worked as a member of a submission team for submitting the final documents to FDA.
• Involved in creating vital clinical trial data such as demographic data and safety data like Adverse Events (AE), Serious Adverse Events (SAE), Laboratory data (Lab data) and Vital Signs.
• Good Interaction with Clinical Data Management, Statisticians, Medical Writers and Regulatory team members.
• A team player and self-starter possessing excellent analytical, problem solving, communication and Organizational skills.

TECHNICAL SKILLS:

Operating Systems: WINDOWS, Unix, Mainframe

RDBMS: ORACLE, MS ACCESS, DB2, SQL SERVER, Teradata

Languages: KSH, SQL, JCL

SAS: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/ACCESS, SAS/CONNECT, PC SAS, ODS, SAS/ETL, SAS/GRAPH, SAS Web Portal, SAS EG.

Tools: MS OFFICE, TOAD, SQL DEVELOPER, LOTUS NOTES, CRON, PUTTY

PROFESSIONAL EXPERIENCE:

Confidential

SR.SAS DEVELOPER

Responsibilities:

• Prepared customized reports to help client provide a strong competency in understanding risk and accordingly perform better customer selection and customer satisfaction.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle. Worked on gathering, analyzing and documenting business requirements.
• Extensive Experience in writing Korn-shell scripts for executing SAS batch files on UNIX to save the execution time and for automation.
• Created SAS database files, Ad-hoc analyses and graphical reports, developed standard reports and supported SAS users. Involved in extracting, analyzing and clustering marketing data (according to customer demographic profile) from the data warehouse (ETL).
• Conducted meeting with business users and data architects to define metadata for tables to perform ETL process
• Used SAS PROC SQL to extract data from different relational database management (Teradata) systems. Used SQL Assistant to analyze and query from the Teradata DB.
• Extensively performed Data Cleansing during the ETL’s Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros.
• Coordinated with key departments to analyze areas such as customer retention, opportunities and customer segmentation. Store and distribute SAS Enterprise Guide results in different formats (HTML, PDF, RTF) based on the user group requirement.
• Developed macros to validate the preexisting model to be used on any data set for future use, using PROC MEANS, PROC UNIVARIATE, and PROC SUMMARY.
• Generated SAS/MACROS and stored procedures for reusability and to minimize data processing. Developed and maintained data retrieval and analysis tools for reporting and performed complex ad-hoc processes as necessary to develop viable recommendation for improvement. Identified and produced analytical data to support decision-making.
• Worked with complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT and PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts.
• Developed Stored Processes to distribute reports and in a secure manner.
• Created reports in the style format (RTF, PDF and HTML) using SAS/ODS.
• Involved in JAD sessions for gathering business requirements and documentation to reduce the complexity of business process.
• Effectively prepared and published various performance reports and presentation.

Platform: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/CONNECT, SAS/GRAPH, SAS/ODS, MS Excel, MS Project, Teradata, Oracle, UNIX, Enterprise Guide.

Confidential, LA, CA

SAS PROGRAMMER

Responsibilities:

• Created SAS ODS by extracting data from Sybase tables using SAS/CONNECT and SAS/ACCESS. Used SAS/ACCESS to read datasets from, Databases, Flat files, also read and write other PC File formats.
• Used PROC SQL for ad-hoc report programming and creation of the ad-hoc reports.
• Generated SAS/MACROS and stored procedures for reusability and to minimize data processing.
• Extensively used macros as well as joining data set, indexing, data aggregation, record selection, sub-setting, multiple records per case, creation and modification of views.
• Monitored and managed the data feeds into the data warehouse as well as extraction transformation and loading. Created permanent formatted SAS data sets for present and future analysis.
• Coordinated with key departments to analyze areas such as customer retention, opportunities and customer segmentation. Store and distribute SAS Enterprise Guide results in different formats (HTML, PDF, RTF) based on the user group requirement.
• Passed parameters in shell script to read daily and on request jobs to reduce complexity of business process.
• Worked with various data like EBCDIC, ASCII and Binary formats and extensively used different kinds of informats to read Mainframe files.
• Worked on detecting, describing and verifying defects, bug tracking and modifying the existing datasets for the improvement of the existing system.
• Performed Data Cleansing by analyzing and eliminating duplicate and inaccurate data using PROC FREQ, PROC COMP, PROC RANK, and SAS/MACROS.
• Analysis included data reports, generalized reports, SQL queries to Database platforms, variable distribution reports for clients.
• Developed SAS macros for reusability and to minimize data processing.
• Extensively used ODS TAGSETS and DDE technics to generate the output results in the required format.
• Documented existing process and newly generated process for Business Users and also to run the process for future needs.

Platform: SAS/BASE, SAS/STAT, SAS/ODS, SAS/GRAPH, Sybase, SQL server, ETL, MS Office, Windows XP, UNIX.

Confidential, Chattanooga, TN

SAS ANALYST

Responsibilities:

• Utilized SAS BASE and Advanced SAS for Programming and Production support
• Manipulated existing Teradata database by accessing the data using SQL Pass thru facility
• Conducted Requirement Analysis, designed technical specifications and Data mapping sheets to meet the business rules and data extraction ETL process by looking at the metadata to identify dependencies between tables in the warehouse for leveraging the execution time and SQL performance tuning
• Generated reports and performed ETL process (extraction, transforming and loading). Monitored and managed the data feeds into the data warehouse as well as data migration to analytical database
• Operated on large data and joining data set, indexing, data aggregation, record selection, sub-setting, multiple records per case, creation and modification of views, accessing multiple databases. Modified MACRO for report generation using SAS/Macro as per the requirements.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools e.g., SAS/Base, SAS Enterprise Guide, SAS/Macros, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access.
• Generated highly customized reports for claim data using SAS/MACRO facility, PROC REPORT, PROC TABULATE, PROC SUMMARY and PROC SQL. Monitored and managed the execution plan for SQL code using SQL developer
• Understand business rules, translate business requirements into documented technique and data briefs
• Work with Account Services, Business Analysts, Quality Assurance, Application Development and Creative teams to provide a diverse set of data services.

Platform: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/CONNECT, SAS/GRAPH, SAS/ODS, MS Excel, Teradata, Oracle, Enterprise Guide.

Confidential, Phoenix, AZ

SAS PROGRAMMER

Responsibilities:

• Used SAS on UNIX environment and Programming in SAS BASE and Macros.
• Developed application for measuring financial performance of newly acquired accounts: Forecast Vs Actual and developed SAS programs for generating reports on Key financials, Income Statements, and Balance Sheet
• Used SAS procedures and preparing daily, monthly, yearly reports.
• Worked with SAS/ODS, HTML produce dynamic web interfaces from SAS programs
• Used SAS import and Access to import external files. Worked with SAS/Graph to produce graphical reports.
• Responsible for maintenance and enhancements work in reporting system using SAS/Base, SAS/Macro, SAS/Graph, SAS/AF
• Wrote programs in SAS generate reports, creating RTF, HTML listings, tables and reports using SAS ODS for ad-hoc report generation.
• Design, create and execute campaign processes to create data outputs that support personalized marketing campaigns.
• Maintained large data sets, combined data from various sources in varying formats to create SAS data sets.
• Used SAS Data Step logics to Sort, Merge, Stack, Update and Interleave datasets for producing required analysis of data and used SAS Business Intelligence to produce required Reports.
• Used SAS, SAS Macros, Oracle, Procedures like SQL, FREQ, UNIVARIATE, SUMMARY, MEANS, TRANSPOSE, ARRAYS, TABULATE and SORT to extract data, prepare integrated data base and its analysis

Platform: BASE SAS, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/ACCESS, Ms-Excel, SAS/ODS, Oracle, UNIX.

Confidential

SAS Programmer

Responsibilities:

• Performed statistical analyses of clinical trial data, produced and validated TLG’s using SAS for Phase I, II and III Clinical Trials.
• PerformedData Validation and Data Cleaningon Clinical Trial data.
• Generated output files in HTML, RTF and PDF formats using SAS ODS.
• Created Derived datasets for different Safety and Efficacy data like Adverse events, Vitals, Exposure, Disposition, Demographics.
• Created ad-hoc reports, patient profile listings for Data Management Team, Statisticians.
• Extracted Data from ORACLE Clinical using SQL pass through facility.
• Created and maintained Production Programs for tables and listings for final submission to FDA.
• Developed reports on Adverse Events and Serious Adverse Events as part of and reports used PROC REPORT reporting techniques with different style options.
• Creating and validating various validation programs for tables and listings.
• Involved in creating SAS Datasets using various CDISC standards such as SDTM, ADaM.
• Used various procedures such as Proc Means and Proc Univariate for continuous data and Proc freq for analyzing the categorical data.
• Physical verification of results by comparing both Production Output and Validation Output.

Platform: BASE SAS 8.2, SAS/MACROS, SAS/GRAPH, SAS/STAT, SQL, WINDOWS XP/ NT. UNIX.

Confidential

SAS Programmer

Responsibilities:

• Developed and validated statistical Tables, graphs, and data listings.
• Created SAS data sets from different flat files using INPUT, INFILE and PROC IMPORT methods.
• Performed data validation on data sets using different functions and procedures.
• Developed SAS macros for data cleaning and reporting and to support routing processing.
• Performed Data Analysis on the data sets using PROC ANNOVA, PROC MEAN, PROC UNIVARIATE, PROC FREQ and PROC TRANSPOSE.
• Developed reports using PROC REPORT, PROC TABULATE.
• Generated output files in text format, HTML & PDF format using SAS ODS.

Platform: SAS BASE, SAS/STAT, SAS/SQL, SAS Macro, SAS/ACCESS, and UNIX.