PROFESSIONAL SUMMARY:

• Over 6 years of extensive experience in SAS programming 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 with 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
• Deep knowledge of stochastic approximation and optimization
• Experience in modeling linear and non-linear regression
• Knowledge of Factor Analysis, Logistic Regression, K-mean Clustering and Generalized Linear Models
• Testing hypotheses and finding confidence intervals for statistical value
• Experience in maximum likelihood estimation, factorial experiments and designs
• Solving ODE and SDE using Matlab
• Knowledgeable with Linear Programming model formulation, computer solution and sensitivity analysis
• Strong leadership skills with ability to work independently

TECHNICAL SKILLS:

WORK EXPERIENCE:

Confidential

SAS Programmer/Analyst

family-owned bank serving communities in San Antonio, Boerne, New Braunfels and the Texas Hill Country.

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 that 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 Tabulate, PROC Report, PROC Print, 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/Access, SAS/STAT, SQL, UNIX, MS-Office.

Confidential

SAS Analyst

Einstein Healthcare Network is a private, not-for-profit organization with several major facilities and many outpatient centers.

Responsibilities:

• Collaborate with 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, REPORT, and SUMMARY and also provide descriptive statistics using PROC MEANS, PROC FREQ, and PROC UNIVARIATE.
• Work with 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 with 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, SAS/STAT, SAS ETL, SAS/Enterprise Guide, SAS BI, SAS Data Integration, Excel, Windows, SPSS, Oracle.

Confidential

SAS Developer

The Progressive Corporation PGR is an American auto insurance company that operates in every state and the District of Columbia. Progressive concentrates on only auto, allowing the company to more accurately assesses the riskiness of their clients and pass on low prices to its clients.

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/ACCESS, SAS/ODS, Oracle, Teradate , PL/SQL, DB2, MS EXCEL, MS ACCESS.

Confidential

SQL/SAS ANALYST

The Bank of Jordan is a bank in Jordan. It's the second largest financial institute in Jordan. It was founded in 1960 and is based in Amman. The Bank of Jordan offers credit cards and internet banking.

Responsibilities:

• Involved in Analysis Marketing Team to make business decisions
• Interacting extensively with end users on requirement gathering, analysis and documentation
• Involved with key departments to analyze areas and discuss the primary model requirements for the project
• Documented methodology, data reports and model results and communicated with 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 effectively 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
• Effectively 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, Teradata, DB2, ORACLE, SQL Server, Windows

Confidential

SAS Analyst

Umniah was granted the third GSM license issued by the Telecommunications Regulatory Commission to operate, manage and own a public digital cellular mobile network.

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, MS Access, Windows.