SAS Analyst Resume Samples

Description :

1. Created a Data-Mart for various types of further predictive models.
2. Selected and extracted samples from a list of the raw datasets, eliminated duplicates, created a one-subject-per-row dataset with PROC SQL.
3. Established a segmentation for the behavior of customers with PROC FORMAT based on their credit score.
4. Applied this segmentation to all selected samples.
5. Defined new variables and assigned different designated values to them based on campaign matrix using CASE expression in PROC SQL, derived product information for each customer.
6. Performed data quality check with PROC MEANS and PROC FREQ, focusing on minimum, maximum, and missing values.
7. Did correction for errors and marked missing value.

Experience

2-5 Years

Level

Junior

Education

Information Technology

Description :

1. Worked extensively with Business Analysts to create requirement documents.
2. Facilitated and attended numerous detailed chartering sessions with the Risk analysis Business teams in order to enhance the reports being used by them.
3. Formalized Business Requirements into System Requirements for implementation by development groups.
4. Made the results actionable for Marketing, Campaign Planning, Strategic Planning, Finance, and Sales organizations.
5. Performed statistical analysis and data management on study data by utilizing appropriate statistical methods using SAS and SAS tools.
6. Integrated results of the Marketing Mix Analysis, Price Elasticity, and other advanced analyses into the business planning process.
7. Designed the metadata, workflow, models in Excel with great transparency and used SAS macro to process the excel file and generate ETL, model scoring and cash flow analysis SAS code.
8. Assisted in the creation of quantitative and qualitative primary research and present the findings.
9. Able to dig into raw data to find and evaluate actionable insights that will help the organization.

Experience

10+ Years

Level

Senior

Education

Bachelor's In Computers

Description :

1. Converted business rule into SAS code to identify the recovery amount for a claim that is paid already.
2. Developed to identify the recovery amount for Facility claims (i.e. Hospital, Ambulance services, etc.) and Professional claims (i.e. Physician or a doctor) based on the business criteria set forth rule using SAS queries.
3. Used SAS Macros, SAS SQL, BASE SAS for developing an application.
4. Identified the various data sources and performing the data extraction on them Scheduling the job through the Tivoli workload scheduler.
5. Repaired Documentation, Flowcharts for the process.
6. Need to ensure successful completion of all ongoing jobs scheduled for the current day.
7. Created graphs using proc plot and chart permanent formatted SAS data sets for present and future analysis.

Experience

2-5 Years

Level

Junior

Education

Computer Science

Description :

1. Utilized SAS procedures for preparing and Classifying Clinical Trial Data.
2. Imported Relational Databases and Clinical Data Management Systems.
3. Transformed Data and Creating Analysis Data Sets.
4. Created Tables and Listings and Common Clinical Trial Graphs.
5. Performed data processing for the execution of the complex marketing campaign using Unix, SAS, and Teradata Databases.
6. Developed code based on technical specifications to extract and process targeted account data.
7. Validated and tested all code for accuracy and efficiency.
8. Reported and tracked defects in Test Director/Quality Center.

Experience

2-5 Years

Level

Junior

Education

Computer Science

Description :

1. Managed is a system to process the medical bills resulted from worker's comp claims.
2. Received the doctor and their pricing information from various vendors and try to give the best quote for the claim.
3. Managed payments will re-price the bills and prepare the checks for the eligible bills and disburse the checks to the provider.
4. Involved in Business Analysis and Systems Planning.
5. Migrated data from text files and DB2 to SAS data sets Proficient in writing JCL.
6. Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation.
7. Tested and debugged existing macros.

Experience

2-5 Years

Level

Junior

Education

MA In Statistics

Description :

1. Developed the Technical specification and designs from the business requirements.
2. Reviewed and understood business change requests.
3. Involved in major enhancement projects Responsible for analyzing various databases (DB2 & Teradata) containing product, sales, transaction, demographic, loan, account, region, banking, and billing data to create a list of risk and non-risk customers.
4. Used SAS/Enterprise Guide to analyze Banking Habit data (Online Banking, Walk-In Banking, Mobile Banking, Tele Banking, and Drive-In Banking), Loan data (Home Loan, Student Loan, Car Loan, and Business Loan) to identify the risk involved.
5. Worked with commercial customer data using hash objects and joining data set, indexing, data aggregation, sub-setting, creation and modification of views, accessing multiple databases.
6. Modified macros for report generation using SAS/Macros as per the requirements.
7. Performed advance statistics on consumer datasets and create customized reports of a preferred list of customers as per the given requirements from business analysts.
8. Created necessary libraries, datasets, GDG's, control cards, JCLs, Pros, copybooks, VSAM files concerned with the project.

Experience

5-7 Years

Level

Executive

Education

Panvalet

Description :

1. Used ingenuity to save customers money and time, reduce risks, increase efficiency.
2. Prepared, applied, reviewed, and document data, programs (SAS), and analytical techniques, including those generated by other teams.
3. Determined, conducted and interpreted appropriate qualitative and quantitative analyses.
4. Maintained and protected confidential data.
5. Maintained, collecting and analyzing databases, exporting data from other environments mainly Matlab.
6. Worked with Composite material Scientists and mathematicians to get the concepts of basic Thermodynamics.
7. Created new stored procedures and SAS MACROS to enhance the functionality.

Experience

2-5 Years

Level

Executive

Education

Master Of Science

Description :

1. Involved in creating SAS metadata objects for uploading the newly created SAS datasets into the data marts.
2. Created staging datasets for the groups using the input data from the data acquisition team.
3. Involved in the building of data marts from enterprise data sources spread across platforms of the SAS DI studio.
4. Involved in the Administration of the user authentications, metadata repositories, job scheduling, stored processes, data cleansing.
5. Experience in creating OLAP cubes for reporting of pre-summarized large datasets and decision support systems using SAS Data Integration Studio and publish the same for business users.
6. Generated SAS datasets, tables, listings, graphs and reports from analysis datasets using SAS tools like BASE, Macros, GRAPH, and STAT.
7. Created reports and stored procedures using the SAS BI tool.
8. Developed the data warehouse system for the credit/debit OLTP process.
9. Worked on transaction data and CRM data in credit limit increase and in marketing.

Experience

2-5 Years

Level

Executive

Education

Bachelors Of Science

Description :

1. Managed a total of about $2.5 Trillion in assets and were looking for expanding their business.
2. Build a loyal customer base, expand that and cross-sell their products to clients, in a well-organized and informed way.
3. Organized in CRM software and was regularly updated based on their preferences.
4. Performed ETL-Extraction/Transformation/Loading, data migration, sampling, data preparation, graphical presentation, statistical analysis, validation, reporting, and documentation.
5. Extracted data from different sources like Oracle and Teradata and text files using SAS/Access, SAS SQL procedures and created SAS datasets.
6. Developed and designed SAS programs/macros to analyze financial data and to create files, tables, listings, and graphs.
   
7. Developed ad-hoc reports as per business requirements and created various reports like summary reports, tabular reports.

Experience

5-7 Years

Level

Executive

Education

Bachelors

Description :

1. Analyzed the high risk insurers in regards to their suicidal tendencies.
2. Collected from clinical studies, past history of the prescriptions and competitive health analytical studies.
3. Identified the same Humana runs campaigns and workshops at multiple locations.
4. Collected through group discussion, focus groups and through primary surveys.
5. Identified the insurers who are having a high risk towards the suicidal tendencies to decide on executing the insurance policy or not.
6. Connected with business stakeholders on periodical basis and also end users to development segmentation strategies and add efficiencies to the campaign development and execution process.
7. Accomplished Data analysis, statistical analysis, generated reports, listings and graphs using SAS/Base, SAS/Macro and SAS/Graph, SAS/SQL, SAS/Access, SAS/ODS and SAS/connect.
8. Instigated the Test Analysis to understand the potentiality of insurer.
9. Organized cluster analysis (CHAID) to segment the potentially high risk customer.

Experience

7-10 Years

Level

Consultant

Education

Engineering