PROFESSIONAL SUMMARY:

• Over 6 years of extensive experience in SAS programming/Developer on different platforms - Windows and UNIX, also having worked in updating, data extraction, transformation and loading to data warehouse, data analysis, updating, testing, trending, mapping analysis and business driven data validation
• Experience in Data analysis and Reporting in health care, finance and marketing sectors. SAS experience includes detailed knowledge of statistical analysis of financial, marketing and health care data and in the production of reports, tables, graphs and listing.
• Experience in Base SAS 9.3, SAS/Macros, SAS/SQL, SAS/Assist, SAS/Connect, SAS/STAT, SAS/Access, SAS/GRAPH, SAS/ETS, SAS ETL and SAS/ODS.
• Possess excellent skills wif PROC SQL, SAS DDE, SAS Arrays, SAS Base procedures, summary procedures and especially Data Step programming and reporting.
• Extraction and creation of data tables using SAS/Access, SAS/SQL from large scale databases.
• Expert in using PROC SQL, PROC REPORT, PROC ACCESS, PROC GPLOT, PROC GCHART, PROC FORMAT, PROC TABULATE, DATA MERGE, SORT to generate ad-hoc and customized reports.
• Extensive experience in SAS/STAT procedures such as PROC REG,PROC GLM, PROC FREQ (Chi-Square), PROC MEANS, and PROC UNIVARIATE.
• Developed and executed PRIDECTIVE MODELS SUCH AS REGRESSION, LOGISTIC REGRESSION, TIME SERIES to forecast quarterly revenue, customer retention /loss and volumes of packages transacted under the various products
• Knowledge and experience in using SAS Business Intelligence tools such as SAS Enterprise Guide 4.3 and SAS Enterprise Miner.
• Knowledge of probability and statistics for engineering and sciences
• Experience in modeling linear and non-linear regression and Testing hypotheses and finding confidence intervals for statistical value
• Knowledge of Factor Analysis, Logistic Regression, K-mean Clustering and Generalized Linear Models
• Experience in maximum likelihood estimation, factorial experiments and designs
• Solving ODE and SDE using Matlab
• Strong leadership skills wif ability to work independently

TECHNICAL SKILLS:

SAS: Base, SAS/Macro, SAS/SQL, PL/SQL, SAS/STAT, SAS DI Studio, SAS Web Report Studio, SAS SAS/Access, SAS/Graph, SAS/Enterprise Miner, SAS/Connect, SAS/Grid, SAS/Enterprise Guide, and SAS/ODS.

Programming Languages: SQL, PL/SQL, HTML, Visual Basic, C, Universal Math solver, Matlab, SPSS and Minitab

Databases: SQL-Server, Oracle and Teradata

Software Packages: Microsoft Office Packages, UML, and MS Project 2000

Operating Systems: Windows (PC), Mainframe (JCL) and UNIX

WORK EXPERIENCE:

Confidential, San Antonio, TX

SAS Programmer/Analyst

Responsibilities:

• Actively involved in design and implementation of application software using primarily SAS system and analyzed existing application software and recommended improvements.
• Designed flowcharts indicating the input data sets and the techniques dat would be used (sorting, merging, etc.) to get the desired output.
• Developed SAS macros for data cleaning, reporting and to support routing processing.
• Present numerical information in various formats. Created SAS customized report using the Data null technique.
• Merging, Indexing, appending and sorting the data sets using various SAS procedures and other SAS tools
• Extensively used SAS Data Step functions and descriptive statistical Procedures to process large amounts of customer response and sales data
• Used PROC SQL LIBNAME and PROC SQL Pass-through methods to access data on Oracle database
• Created customer mailing lists for Direct Mailing and Telemarketing using PROC Forms
• Extensively used PROC Import and PROC Export procedures for importing and exporting PC files and Microsoft office files such as Excel Spreadsheet, Access Tables
• Maintained and enhanced existing SAS Reporting programs using Proc Template Styles, PROC Tabulate(Styles), PROC Report(Styles), PROC Print(Styles), ODS RTF, and ODS PDF for marketing campaigns
• Used SAS enterprise Guide to run statistical tests like ANOVA, Chi-square etc.
• Created Ad hoc reports for marketing managers using SAS Enterprise Guide

Environment: SAS 9.3, SAS Enterprise Guide, Base SAS, SAS Macros, SAS DI Studio, SAS Web Report Studio, SAS/Access, SAS/Grid, SAS/STAT, ODS RTF, ETL/Teradata, SQL, PL/SQL, UNIX, MS-Office.

Confidential

SAS Analyst

Responsibilities:

• Collaborate wif physicians, medical writers and data managers to finalize mock tables
• Design; select appropriate SAS procedures for each statistical analysis; test-run SAS program on mock data to ensure smooth analysis implementation.
• Use PROC SQL/IMPORT to import data from mainframe oracle clinical databases and MS excel sheets.
• Perform Data analysis, statistical analysis, generated reports, listings and graphs using SAS Tools SAS/Base, SAS/Macro and SAS/Graph, SAS/SQL, SAS/Access.
• Produce quality customized reports by using PROC TABULATE, PROC RPORT Styles, and ODS RTF and also provide descriptive statistics using PROC MEANS, PROC FREQ, and PROC UNIVARIATE.
• Work wif statistician to analyze the results obtained from various statistical procedures like Chi-Square, PROC ANOVA, GLM, and T-test.
• Develop and debug routine SAS macros to create tables, graphs and listings.
• Provide proper validation, including testing and documentation (e.g., requirements document, program validation), in accordance wif GCP and company standards.
• Contribute to the development of manuscripts, labels, scientific and commercial presentations, and regulatory response documents by generating statistical tables and graphs through SAS programming.

Environment: SAS/BASE, SAS/MACROS, SAS/SQL, PL/SQL, ODS RTF, SAS/STAT, SAS ETL, SAS/Enterprise Guide, SAS/Grid, SAS Data Integration, Excel, Windows, SPSS, Oracle, Teradata.

Confidential, Chicago, IL

SAS Developer

Responsibilities:

• Developed and designed SAS programs/macros to analyze financial data and to create files, tables, listings, and graphs. Developed ad-hoc reports as per business requirements and created various reports like summary reports, tabular reports
• Cleaned existing data and converted them into useful SAS Datasets, merged datasets and created reports based on Ad-hoc requirements
• Developed applications 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 like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE AND PROC REPORT in order to understand and prepare the data
• Performed ETL-Extraction/Transformation/Loading, data migration, sampling, data preparation, graphical presentation, statistical analysis, validation, reporting, and documentation.
• Extracted data from different sources like Oracle and Teradata and text files using SAS/Access, SAS SQL procedures and created SAS datasets

Environment: SAS/Base SAS Enterprise Guide, SAS Enterprise Miner, SAS/Macro, SAS/STAT, SAS/GRAPH, SAS ETL, SAS/ACCESS, SAS/ODS, Oracle, Teradate, PL/SQL, DB2, MS EXCEL, MS ACCESS, SAS DI Studio, SAS Web Report Studio.

Confidential

SQL/SAS ANALYST

Responsibilities:

• Involved in Analysis & Marketing Team to make business decisions
• Interacting extensively wif end users on requirement gathering, analysis and documentation
• 462
• Documented methodology, data reports and model results and communicated wif the Project Team / Manager to share the knowledge
• Analyzed business requirements, transformed data, and mapped source data using the Teradata Financial Services Logical Data Model tool, from the source system to the Teradata Physical Data Model
• Developed complex SAS Macros to simplify SAS code and TEMPeffectively reduce coding time
• Imported Data from relational database into SAS files per detailed specifications
• Imported data using LIBNAME and PROC SQL Pass -Thru facility to reduce processing time
• Performed complex statistical analysis using PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG and PROC ANOVA
• Extensively used SAS procedures such as PRINT, REPORT, TABULATE, FREQ, MEANS, SUMMARY, TRANSPOSE and Data Null for producing ad-hoc and customized reports and external files
• Wrote SAS programs in UNIX platform
• Responsible for generating Financial Business Reports using SAS Business Intelligence tools (SAS/BI) and also developed ad-hoc reports using SAS Enterprise Guide
• Developed Income statements & Balance sheets in MS Excel
• Extensively used SAS ODS facility to create customized reports in HTMLPDF,RTF
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools e.g., SAS Integration Studio, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access
• Performed competitor and customer analysis, risk and pricing analysis and forecasted results for credit card holders on demographical basis
• Created reports in the style format (RTF, PDF and HTML) using ODS statements and PROC TEMPLATE
• Performed Consumer profiling, Sales forecasting and testing of financial and business models
• TEMPEffectively prepared and published various performance reports and presentations

Environment: SAS/BASE, SAS/MACRO, SAS/ETS, SAS/CONNECT, SAS Business Intelligence, SAS Enterprise Guide, SAS Enterprise Miner, SAS Web Report Studio, SAS Management Console, SAS OLAP & EBI Server, ETL/Teradata, DB2, ORACLE, SQL Server, Windows

Confidential

SAS Analyst

Responsibilities:

• Provided SAS programming Support and Maintenance to Statistics and Data Management applications.
• Involved in Extracting, Analyzing and Validating Finance data from Oracle Clinical/Life Science Hub Data using SAS.
• Developed Analysis-ready data sets and Reports using SAS/Macro programming.
• Provided Support and Assistance to Internal Customers, Documented Customer Problems and Resolution, Worked on Change requests for new enhancements or incident.
• Created Ad hoc reports per requests by Statistics and Data Management teams to aid in the analysis or review of clinical data.
• Generated SAS reports in Excel for data analysis.
• Created complex and reusable Macros and extensively used existing macros and Developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.

Environment: Base SAS, SAS/SQL, SAS/Graphs, SAS/Stat, SAS/Access, SAS Enterprise Miner, SAS Enterprise Guide, Oracle, SPSS, MS Access, Windows.