SUMMARY

• Over 7 Years of working experience as a SAS Programmer/Analyst in Financial, Retail, Research and Clinical industries.
• Extensive experience in developing reports for portfolio analysis, originations strategy, collections strategy, and repossessions strategy and performance analysis.
• Experience in providing business insights in customer segmentation, market analysis, forecasting, competitor analysis, product development & customer operations.
• Extensive experience with BASE SAS, SAS/MACROS, SAS/ODS, SAS/ SQL, SAS/STAT, SAS/ACCESS, SAS enterprise guide, and SAS Data integration in Windows environments.
• Proficient in writing and Implementing Macros, functions and SQL statements.
• Experience in developing Excel Pivot Tables and Knowledge of writing VBA macros in Excel.
• Experience in communicating with the Business users and Marketing managers to gather the requirements.
• Experience in following the company’s Standard Operating Procedures (SOP’s), BRS and FRS documents while developing the SAS programs to produce the reports.
• Extracting data from different sources (e.g. Oracle, Teradata) using SAS/ACCESS and Experience in cleaning and resolving data issues as well as merging data from different sources into a single integrated dataset.
• Implemented, created new and modified existing SAS Macros to generate Reports.
• Experience in creating ad - hoc reports in tight schedules using various SAS Procedures.
• Performed Validation and Verification on developed SAS programs and the Reports.
• Programming experience with SAS functions and SAS procedures such as SORT, SUMMARY, MEANS, FREQ, IMPORT, EXPORT, CONTENTS, PRINT, TABULATE, REPORT, SQL, TRANSPOSE, FORMAT, GPLOT, CHART, and UNIVARIATE
• Developed Reports in different Formatted files PDF, RTF, HTML using SAS/ODS.
• Experience in Dataset Creation and Table/Listings Programming for Integrated Summaries of Efficacy (ISE) and Safety (ISS).
• Good knowledge in developing various reports using data null, proc report and SAS ODS for developing desired formats such as.pdf, rtf and other formats.
• Proficient in understanding clinical trials study designs, study protocols, statistical analysis plans, (SAP), case report form (CRF/ eCRF), annotated case report forms and company Standard Operating Procedures (SOP).
• Hands on experience in handling clinical trial data such as demographic data (DM), adverse events (AE), laboratory data (LAB DATA), concomitant medications (CM), subject visits (SV) and vital signs (VS).
• Knowledge of Statistical procedures like Anova, Logistic Regression.
• Attended project team meetings, worked with the Business analysts, Marketing Managers, Statisticians and DBA Team as appropriate and submitted the final reports to the Project manager.
• Experience in handling / working on multiple-projects at one time and willing to take on extra responsibilities to get the work done.
• Ability to work effectively both as an individual and as part of a team.

TECHNICAL SKILLS

SAS skills: SAS 8/9.1/9.1.3, SAS/BASE, SAS/MACRO, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/STAT, SAS/ODS, Web report studio

Databases: Oracle, Teradata, Db2, SQL Server, MS Access 98/2000

Applications: MS-Excel, MS-Word, MS-PowerPoint, MS-Office, Tableau, Cognos

Operating System: Windows XP/2000/98/NT/vista, UNIX

Statistical Applications: SAS, SPSS, R Programming and STATA

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale, CA

SAS Data Analyst

Responsibilities:

• Performed statistical analysis and data management on financial data by utilizing appropriate statistical methods.
• Primarily used SAS and Excel for statistical analysis of Online Activity.
• Consolidated links and analyzed data/metrics from multiple sources such as site analytics, customer sat, order flows, and back-offices.
• Identified out of trend results and data issues and provided resolution to data owners.
• Created presentations and facilitated review meetings with senior leadership, directors and managers to analyze results and action planning.
• Collaborated with delivery team to improve data collection and web-based tracking.
• Performing data validation, transforming data from RDBMS oracle to SASdatasets.
• Transformations using Base SASProcedures and Functions.
• Responsible for the cleaning, reformatting, analysis and loading the data into the database.
• Developed new or modified SASprograms to load data from the source and create study specific datasets.
• Produced RTF, CSV, PDF and HTML formatted files using SAS/ODS to produce reports for presentation and further analysis.
• Worked on generating Ad-Hoc reports, tables and graphs for presentations and data modeling using SASWeb Report Studio.
• Importing all Reports from web report studio, Stored Process, BI Dashboard and Information Map to Information Delivery Portal.
• Developed loss prediction model using Enterprise miner modeling solutions and SASprocedures.
• Converted programs from Teradata SQL to SASto automate the monthly production processes.
• Developed new/modified macros for report generation using SAS /Macros as per business requirements.
• Provided technical support on SASprogramming related to data manipulation and analysis.
• Extracted, performed validation and generated SAS data sets from Teradata; applied SQL Pass through Facility.
• Used SAS DATA NULL and PUT statements to create the customized reports.

Environment: SAS/ Base, SASEG, SASDI Studio, SASmanagement console, SASinformation map studio, SASweb report studio, SASstored process, SASIDP, Oracle, PL/SQL, MS Excel, Unix.

Confidential, Little Falls, NJ

SAS Programmer

Responsibilities:

• Responsible for providing SAS programming and analysis support for several studies in close collaboration with Statisticians.
• Extracted data from Oracle database.
• Design/develop SAS macros and other utilities to expedite SAS programming activities.
• Participate in statistical program validation and quality control activities.
• Develop SDTM mapping documents, complete programming and validation of CDISC SDTM and ADaM datasets.
• Created SAS listings and tables in PDF, RTF formats using SAS ODS.
• Used various procedures like PROC FREQ, PROC MEANS, PROC TABULATE, PROC SUMMARY and PROC REPORT to generate various data tables, patient data listings and reports according to Statistical Analysis Plan (SAP).
• Reviewed CRF's to ensure consistency with protocol and adequacy to collect the data to meet the objectives defined in the statistical section of the protocol.
• Modified the ADaM file specification (Variable Definition) based on Statistical Analysis Document (SAP, DPS and mockups).
• Interact with other departments such as Clinical Operations, Project Management, and Data management to ensure a high level of client satisfaction through successful execution of projects.
• Participate in review process of study documents such as CRF, edit check specifications, and database design specifications written by Data Management.
• Responsible for ensuring consistencies in database structures, programming edit checks and data listings, performing validations of programs and participating in database locking activities.
• Reviewed data from clinical trials and developed plans to presenting results to FDA.
• Used SASand SQL to perform ETL from Oracle and Teradata databases and created SAS datasets, SASmacros, Proc/data steps and SASformats as required.
• Data processing and validations were done extensively on the SASdatasets using edit check programs.
• Developed reports as per business requirements and created various reports like summary reports, tabular reports, excel reports etc.
• Report various health care management metrics such as Number of readmissions, Patient category metrics, Patient demographics, service delivery and drug utilization etc.
• Used procedures such as Proc Freq, Proc Format, Proc Means, Proc Sort, Proc Print, Proc Tabulate and Proc Report.

Environment: SAS/ODS, SAS 9.2, SAS Enterprise Guide, SAS/Macros, SAS/Graph, SAS/Access, SAS/Connect, SAS/Stat, Teradata, MS Excel, MS Access.

Confidential, New York City, NY

SAS Program Analyst

Responsibilities:

• Extracted data from Oracle database (warehouse)
• Prepared new datasets and modified existing datasets using Set, Merge, Sort, Update, Formats and Functions and created Tables and Listings for the same.
• Also created and maintained SAS datasets that are extracted from an Oracle Database using SAS/ACCESS for ORACLE and extensively used Proc SQL to manipulate the data.
• Used Proc SQL (Pass-Through) method and Proc Append methods to write statistical analysis results to the ORACLE database.
• Building of generic utility processes for large volume sort, sort/summation, and Unix batch SAS execution
• Converted Excel tables and flat (text) files into SASdatasets for Ad-Hoc analysis.
• Data analysis, reports using SASprocedures and SAS/Macros.
• Used SAS/STAT to create different statistical reports as required.
• Extensively used various SASData Step functions, SASprocedures, and SQL to write reports logics for SASStored Processes.
• Forecasted monthly, quarterly and annually customers flow and revenue for Direct Mail Marketing and Tele-Marketing campaigns using SASand Excel.
• Performed market research and segmentation analysis using SAS, SQL and Excel to get the potential target customers and identify the market trend and opportunities.
• SAS Enterprise Guide was used to convert existing SASprograms to SASstored processes using dynamic prompts and produced packaging and streaming outputs as required.
• Developing SASStored Processes that can be easily used by end users using SASAdd-in for Microsoft Office and other SASBI clients from SASInformation Delivery Portal.

Environment: SAS/ Base, SAS/ Macros, SAS/ Stat, Oracle, SAS/SQL, SAS/ ODS, SASEnterprise Guide, MS office, Windows, Mainframes Z/OS, Unix.

Confidential, Madison, Wisconsin

Data Analyst

Responsibilities:

• Accessed and analyzed the data based on the requirement using MS SQL, SASand MS Excel.
• Performed ETL tasks in extracting the Sales and Claim data from databases using SASprocedures like SASSQL, SASAccess and creation of datasets.
• Performing data analysis, data migration, data preparation, graphical presentation, statistical analysis, reporting, validation and documentation
• Analyzed big data using PROC SQL, PROC SORT, PROC PRINT, PROC TABULATE procedures.
• Retrieved the original data and convert them into SASformat for analysis.
• Interactively meeting the Actuarial teams for getting the required data to generate the reports.
• Developing and analyzing key performance indicators relevant to emerging business needs using PROC FREQ, PROC TABULATE, PROC MEAN, PROC UNIVARIATE, PROC GLM, PROC TTEST, PROC TRANPOSE, and DATA NULL
• Developing SASprograms using SASBASE, SASSQL, SASSTAT, SASACCESS and SAS MACROS for statistical analysis and data displays
• Documented purpose and methods used in each SASprogram
• Responsible for the timely delivery of all assigned ad hoc reports by meeting the agreed upon threshold for timely measurement.

Environment: SASv9, SASEnterprise Guide, SASMACRO, SASGRAPH, SASSTAT, Teradata, DB2, ORACLE, SQL Server, TOAD, MS Excel, UNIX, Windows

Confidential

SAS Data Analyst

Responsibilities:

• Created and maintained permanent SASData Sets that are extracted from an Oracle Database. Accessed External Excel files, Stored and Retrieved SAS data sets moving data through multi platforms. Prepared list of efficacy data for statistical analysis.
• Generated graphs using SAS /GRAPH. Developed routine SASmacros to create tables, graphs and listings for inclusion in Clinical study reports and regulatory submissions and maintained existing ones.
• Read data from Oracle, Excel and flat files into SASsoftware. Developed SAScode to clean the invalid data from the database.
• Creating Summary Reports and Tabular Reports using Proc Report.
• Used SAS /STAT software for Statistical Analysis, procedures and reports.
• Extensively worked on Proc Report to produce reports for the purpose of validation.
• Involved in problem solving, data analysis and complex report generations.
• Performed Edit Checks for cleaning up the data in data management.
• Worked with presentation and reporting procedures like FORMAT, REPORT, PRINT, SORT, etc. Used SASODS to produce HTML, PDF and RTF format files. Created summary tables, listed outputs and generated reports.
• Developed Programs using SASMACROS and SASBase Procedures. Involved in validation of tables, listings and datasets using procedures like PROC COMPARE and PROC FREQ. Participated in designing, coding, testing, debugging and documenting SASprograms and Macros.
• Used statistical procedures like PROC MEANS, PROC UNIVARIATE and PROC FREQ for analysis.

Environment: SAS/BASE v 9.0, SAS/STAT, SAS/ SQL, SAS/MACROS, SAS/GRAPH in LINUX