Summary:

• 7 years of extensive experience in the field of SAS in Programming / Business Analysis and Data Analysis projects.
• Processed large datasets with billions of records for data transformation including data cleansing, data scrubbing, data profiling and applying business logic rules to incoming data.
• Expertise in advance SQL programming for joining multiple tables, sorting data, creating SQL views, creating indexes, campaign management and metadata analysis.
• Good command in using SAS/BASE, SAS/MACRO, SQL, SAS/STAT, SAS/ACCESS SAS/CONNECT, SAS/ODS, SAS/GRAPH, Excel, Tagsets, Teradata, MS Office tools with more than 5 years of experience.
• Created SAS Programs to generate new datasets from raw data files imported and modified existing datasets using SQL, Set, Merge, Sort, Update, Formats and Functions.
• Good command in SAS procedures, reporting and Summary procedures, generating reports employing various SAS procedures like PROC PRINT, PROC REPORT, PROC PLOT, PROC CHART, PROC SQL, PROC SUMMARY, PROC FREQ, PROC TABULATE, and PROC MEANS, PROC UNIVARIATE, PROC FORMAT, PROC TRANSPOSE and Data null .
• Working experience with SAS tools, SAS Enterprise Guide, SAS Enterprise Miner.
• Skilled in working with PROC SQL, SAS arrays and SAS Macros to automate SAS tasks and to convert and produce file with different formats as per the requirements..
• Strong skills in Developing SAS Programs for Data Analysis, Data Requirement Analysis and Data Mapping for ETL process and working with Analysis of Variance ANOVA , Regression Analysis, Linear Models, Multivariate Analysis, and Predictive Solution Models including linear, multiple, polynomial, and nonlinear regression models.
• Experienced in handling data with data integrity during extraction, manipulation, processing, analysis and storage.
• Excelled at identifying, developing and using strengths of team members, as well as locating, detecting and resolving problems and weaknesses of each team individual.
• Built data input and designed data collection screens Managed database design and maintenance, administration and security for the company.
• Responsible for leading software testing, troubleshooting, and implementation.
• Support end-users, company-wide to resolve database and software issues utilizing remote desktop tools.
• Database recovery and subsequent problem resolution.
• Meet with customers to determine their needs, gather and document requirements, communicate with customers throughout the development project to manage customer expectations, resolve issues, and provide project status.
• Coordinates project development and implementation activities.
• Strong Knowledge in advanced Analytics and Text and Data mining Techniques.
• Different data mining, query model, processing model, and data collection techniques.
• Query Reports using Access and SQL.
• Design, coding, testing, debugging, and documentation of multiple treatment and payment SAS programs for charge-off card data. Prepare daily, monthly, and ad hoc reports by PowerPoint, Excel, pivot tables, and pivot charts, etc. , and present findings and recommendations to all levels of senior management.
• Develop SAS and VBA macros for automating the analysis, process, and report generation.
• Excellent programming skills in developing programs to increase the performance and efficiency of SAS programs and importing, extracting and loading the data into various servers like Oracle, SQL Server, DB2 with specific bulk load techniques.

Work Experience

Confidential

Role: Sr. SAS Consultant

Responsibilities:

• Coordinated with vital departments to analyze areas such as customer retention, opportunities and customer segmentation. Store and distribute SAS Enterprise Guide results in different formats such as HTML, Tagsets, PDF, WORD based on the user group requirement with SAS/ODS.
• Constructed SAS programs on UNIX platform to clean the data according to the specifications.
• Performed Data Cleansing widely during the ETL's Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros.
• Proficiently used SAS procedures like PROC SQL to extract data from different relational database management systems and used SQL Assistant to analyze and query from the Teradata DB.
• Worked as the primary liaison between the business line, operations, and the technical areas throughout the project cycle. Primarily focused on analyzing and documenting business requirements.
• Created customized reports to help client provide in understanding risk and accordingly perform better customer selection and customer satisfaction.
• Extracted, transformed and loaded data from large Teradata tables using Data stage in data ware house. Passed parameters in shell script to read daily and on request jobs to reduce complexity of business process.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools.
• Maintained large data sets, combined data from various sources in varying formats to create SAS data sets.
• Create partition tables and apply threading techniques using SASTRACE.
• 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.
• 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.
• Performed Data analysis, mainly using Regression and ANOVA Proc REG, Proc GLM, and Proc ANOVA .
• Developed Stored Processes to distribute reports in a secure manner.
• Created reports in the style format RTF, PDF and HTML using SAS/ODS.
• Efficiently prepared and published various performance reports and presentation.

Environment: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/CONNECT, SAS/GRAPH, SAS Management Console, SAS/ODS, MS Excel, MS Visio, MS Project, Teradata, Oracle9i, PLSQL Developer, UNIX.

Confidential

Role: Clinical SAS Programmer

Responsibilities:

• Understanding the requirements of the Application
• Created and edit check programs to find data discrepancies in raw datasets provided by Data Management Group.
• Worked with the Statisticians, Data Managers to provide SAS programming in analyzing Clinical Trial Data.
• Generated final study reports, tables, listings and graphs by using PROC Tabulate, PROC Sql, and PROC GChart.
• Validating the datasets and comparing the results to that of source programmers output.
• Reviewed data from clinical trials and developed a strategy for how to present results to FDA.
• Generated CRT Case Report Tabulation datasets using CDISC standards for FDA regulatory submissions.
• Preparation of Integrated Safety ISS , Integrated Summary Efficacy ISE , Electronic Common Technical Document e-CTD and packages and DEFINE.PDF for the analysis of datasets using the Annotated CRF's.
• Worked on the summary of clinical data like Demographic, Adverse Events, Serious Adverse Events, and Related Adverse Events leading to Discontinuation.
• Developed various forms of outputs like RTF, HTML, PDF files using SAS ODS facility.
• Provided reports with minimum risk and optimum result.
• Participated in project meetings, presentations and updating research findings.

Environment: Base SAS, SAS EG, SAS/Access, SAS/Connect, SAS/Stat, SAS BI Enterprise Server, SAS/Graph, SAS/SQL, SAS/ODS, SAS Macros, MVS, JCL, Oracle 9, DB2, PL/SQL,

Confidential

Role: Informatics Analyst/SAS Programmer

Responsibilities:

• Provided expertise in Statistical programming for the production of high level Reports using SAS procedure.
• Comprehensive skills in working with SAS/BASE, SAS EG, SAS EBI, SAS/MACRO, SAS/ACCESS, compaign management etc. in windows and UNIX environment.
• Prepared detailed summaries and reports for the pharmacy and health claims data by writing commands in SAS Data step and various statistical procedures like proc sql, proc summary, proc report, data null .
• Used JAVA, Tagsets, Teradata and HTML codes and convert them to SAS to create high level html reports on SAS Portal.
• Performed QC and Edit Checks using various procedures and Macro facility. Coded Independent Programs for validation of analysis dataset.
• Broad use of SAS Macros in the creation of new programs as well as modification of existing programs to improve ease and consistency of results.
• Extensively used Data Null techniques for producing highly formatted and customized reports.
• Coordinated in the production of monthly, quarterly, and annual performance reports for senior management along with generating high level summaries using multiple SAS processes with conditional highlighting as per the requirement of senior management.

Environment: SAS EG, SAS IDP, Web report Studio, SAS 9.1.3, SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/SQL, Oracle, oracle clinical 4.0, Windows NT 2000, Unix.

Confidential

Role: Clinical SAS Programmer

Responsibilities:

• SAS programming expertise in producing ADAMS, Tables, Listings and Graphs from SAS/BASE, SAS/MACRO and SAS/GRAPH, SAS/SQL, SAS/ STAT.
• Generate reports, listings and graphs using SAS/BASE, SAS/MACRO, SAS/SQL and SAS/STAT.
• Created tables, listings, graphs for safety reports.
• Created and validated ADAM datasets like ADSL and BDS datasets for the study
• plan SAP .
• Develop, modify and validate SAS programming work according to Statistical Analysis
• Worked on datasets like Demographics, AE, Vitals, Concomitant medication, Physical Examination, Labs.
• etc
• Performed Statistical Analysis using SAS/STAT procedures PROC MEANS PROC FREQ
• Create reports in RTF/pdf format using SAS Output delivery system as per the client requirement.

Environment: SAS 9.1, BASE/SAS, SAS Macro, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/Internet, App Dev Studio 2.0/2.02, SAS/SQL, SAS Warehouse, Microsoft Front Page, EJB, DB2, Unix, WIN NT

Confidential

Statistical Programmer/Analyst

Responsibilities:

• Understanding the requirements of the Application
• Created Analysis Datasets, Summary Tables, Listings and Plots according to the specification of the study for statistical analysis
• Modified the datasets according to the requirements of the statistician.
• Data validation and quality control check of the displays and datasets according to the different QC levels.
• Investigate, prepare, analyze, and validate data for down streaming Modeling and Analysis.
• Trained in Good Clinical Practice GCP , Regulatory Compliance and FDA Guidelines.
• Extracted data from Oracle database using Pass through Facility.
• Extensively worked on PROC REPORT and PROC TABULATE to produce reports for the purpose of validation.
• Involved in writing code using data step programming and macros to extract, clean and validate date from external source.
• Extensively worked with complex and huge datasets, and generated reports in various formats such as PDF, RTF, HTML and list files using SAS ODS facility.
• Validating the datasets and comparing the results to that of source programmers output.
• Attended project team meetings, interacted with Bio Statisticians, Data Managers, and Clinical Research Managers.

Environment: SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/SQL, Oracle, Teradata, Window NT.

Confidential

Role: SAS Data Analyst

Responsibilities:

• Data gap and database anomalies like Insert, Delete and Update were efficiently used.
• Extensively developed programs and performed unit test using SAS, DB2, and SQL for analysis of large datasets and data manipulation.
• Proficient use of SAS/Access, SAS/Connect to connect to various databases such as development, test and production database.
• Statistical Analysis Software SAS Proficiency: PROC SQL against Oracle and SQL Server databases, PROC Report, PROC Tabulate, Excel, Tagsets, Teradata, ODS report output
• Experience using SAS as a data extract, transform, and load ETL tool
• Well versed with importing, Accessing, Integrating and synthesizing data using SAS/STAT to produce statistical analysis such as regression, multivariate, survival, psychometric and cluster analysis. Quarterly and annual sales and profit summary reports were prepared using the Proc Report.
• Developed and maintained Excel Reports for sales data on a need basis.
• Expertise in Microsoft Excel for development, maintain and automate the report using different excel functions, creating crucial reports.
• Implemented data management plans designed to meet project deadlines.

Environment: Base SAS, SAS EG, SAS/Access, SAS/Connect, SAS/Stat, SAS BI Enterprise Server, SAS/Graph, SAS/SQL, SAS/ODS, SAS Macros, MVS, JCL, Oracle 9, DB2, PL/SQL, Teradata, MS Excel.

Confidential

Role: Clinical SAS Programmer

Responsibilities:

• Extract data from Oracle database using SQL pass through facility, MS Access, Tagsets Excel sheets, and Delimited text files. Import and export procedures were applied in these procedures.
• Extracted, merged the data from diverse sources using matching conditions and then upload in to the data warehouse based on user defined Business rules.
• Develop SAS Reports using PROC REPORT, PROC TABULATE and load SAS data sets as tables into Oracle and SQL Server using SQL pass through facility, library reference method.
• Validate data and create reports using different procedures like Freq, Means, Transpose, Datasets, Sort, Compare, SQL, REPORT and SAS/ODS facility.
• Create, enhance and incorporate new systems with existing systems SAS Programs for generating reports, graphs, tables and lists.
• Indexing huge SAS data sets and utilizing those indexes as a part of SQL queries for quick results and write SQL joins to Merge the data sets to find exceptions from different tables.

Environment: SAS9.0, MS SQL, HTML, Windows NT/2000, Teradata, Oracle and Linux.