Sas Analyst Resume Profile
PROFESSIONAL SUMMARY:
- Over 6 years of extensive experience in SAS 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 working on Phase I, II and III of Clinical trials including Statistical Analysis.
- 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
- 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 with ability to work independently
TECHINICAL SKILLS:
|
|
|
|
|
|
|
|
|
|
PROFESSIONAL EXPERIENCE
Client: CONFIDENTIAL
Role :Graduate Research-SAS Analyst
Finance Domain:
- Predictive Modeling Using Decision Trees, Predictive Modeling Using Regression, Predictive Modeling Using Neural Networks and other tools
- Model Evaluation and Implementation, Cluster Analysis: K-Means Cluster Analysis, Self-Organizing Maps, and Association and Sequence Analysis
- 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 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/BASE, SAS/MACROS, SAS/SQL, PL/SQL, ODS RTF, SAS/Enterprise Miner, SAS/STAT, SAS ETL, SAS/Enterprise Guide, Oracle, Teradata , Excel, Windows, SPSS
Clinical Domain:
- Work with statistician to analyze the results obtained from various statistical procedures like Chi-Square, PROC ANOVA, GLM, and T-test.
- 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.
- Perform Data analysis, statistical analysis, generated reports, listings and graphs using SAS Tools SAS/Base, SAS/Macro and SAS/Graph, SAS/SQL, SAS/Access.
- Basic understanding of healthcare clinical terminology CPT, Diagnosis code, and HCPCS and the reporting and analytics correlation to quality measurement concepts be able to translate business thoughts to data-centric solutions.
- Involved in Phase I, Phase II, and Phase III of the clinical trials as a SAS Programmer Of HIV.
- Used SAS data step functions, formats, statements and procedures like PROC FORMAT and to map the variables to the customer's needs.
- 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.
- Data mining and simulation of HIV model by Matlab.
Environment: SAS 9.2, SAS/EG, SAS/SQL, SAS/BASE, SAS/MACROS, SAS/GRAPH, ODS RTF, SAS/Enterprise Guide, Oracle Clinical, SPSS, Windows, UNIX, MS-Office
Role: 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 Enterprise Guide, SAS Enterprise Miner, ORACLE, SQL Server, Windows
Client: CONFIDENTIAL
Role: 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, SPSS, MS Access, Windows.