SAS Programmer Resume Samples

Description :

1. Working with business analysts in obtaining the business rules and thereby creating and modifying customer lists based on different parameters such as address, loan amounts, and customer loyalty.
2. Generating reports for business users was one of the main responsibilities.
3. Involved in the client interaction, requirements gathering, analysis, and documentation.
4. Participated in design discussions and prepared the required documents.
5. Use SAS eg 9.4 to optimized data collection procedures and generate weekly, the monthly and quarterly basis for pricing and marketing team.
6. Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
7. Independently the pricing schedule produced by the deterministic markdown pricing optimization procedure proc CLPRS.
8. Developed a set of SAS macros to verify independently the output produced by the earned value management analysis macros.
9. Developed SAS programs with the use of base SAS and SAS/Macros to implement new models.

Experience

2-5 Years

Level

Junior

Education

Bachelor Of Technology

Description :

1. Worked on multiples projects with the head of the departments in business banking. Primary responsibility includes performing data processing for the execution of the complex marketing campaigns.
2. Supported the business banking in the monthly statistical report in the quick capital market, cash buffer analysis and different campaigns.
3. Worked with a team of analysis and marketing for generating safety and efficiency tables by leading all projects.
4. Extracted raw data from an Oracle database and used SAS/Access to read it and run statistical analysis.
5. Developed and modified SAS macros for data cleaning, validation, analysis and report generation.
6. Worked with SAS and Proc SQL to extract marketing demographics from a Teradata data warehouse for model testing, segmentation, scoring, and list management purposes.
7. Drew flowcharts indicating the input data sets, sorting and merging techniques.
8. Wrote code using SAS/base and SAS/macros to extract clean and validate data from a flat file, excel file, RDBMS, access database, and Oracle database using SAS ETL and DB load processes.
9. Extensively using do loops, array, and SAS/stat to manipulate numerical data and scientific data.

Experience

5-7 Years

Level

Executive

Education

BS

Description :

1. Interacted with the business users to gather requirements and analyzing the mutual dependencies of their needs by coordinating with the Project Manager.
2. Analysis of Business Requirements Document (BRD) and Functional Business Requirement document (FRD).
3. Developed and maintained data preparation and validation routines to support the reporting of cost information.
4. Reviewed and analyzed trends in current portfolio populations and recommended verification strategies.
5. Provided analytic support for cross-channel fraud and verification, operating losses, verification strategies, fraud risk assessments, and other product strategies to ensure goals and objectives are satisfied.
6. Developed complex programming models to extract data and manipulated databases to support verification strategies for reporting/analysis.
7. Built scorecards for credit risk analysis and regression models for analysis of the relationship among variables.
8. Developed product and cross-product simulations, business logic, and pricing strategies to optimize profitability.
9. Maintained a tracking system for all marketing channels and generated client report in order to make business decisions.

Experience

7-10 Years

Level

Senior

Education

BS

Description :

1. Involved in programmer modifications and report generation for phase iii-iv clinical studies.
2. Generated analysis datasets for interim analysis, final CSRS, and medical team requests.
3. Extensively worked on the creation of analysis datasets like demographics, lab safety and lab efficacy, vital signs safety and efficacy, adverse events, protocol deviations, study drug dosing etc.
4. Generated edit check listings to help clean the data (data cleaning and verification) on a regular basis of data refresh.
5. Involved in creating Dataset Specifications (DSS) for creating analysis datasets.
6. Imported data from excel documents to SAS datasets using Dynamic Data Exchange (DDE) utility.
7. Created SAS macros for generating similar types of tables and listings for demographic, disposition, different types of adverse events, lab shift, vital signs shift, lab marked abnormalities, the extent of exposure, time to an event etc.
8. Validated (QC) and documented the competing codes for datasets and reports.

Experience

7-10 Years

Level

Senior

Education

BS

Description :

1. Prepared new datasets from raw data files using import techniques and modified existing datasets using set, merge, sort, and update, formats, functions and conditional statements.
2. Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/base and SAS/ macro facility.
3. Used Dynamic Data Exchange (DDE) feature of SAS for the importing and exporting of data from and into SAS, ms access, and excel.
4. Automating several SAS reports by using base SAS, Unix shell script, which will drop the reports in the designated location at the scheduled date and time without any human effort.
5. Maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets by using set and merge for generating reports and graphs.
6. Used SAS and SQL to perform ETL from oracle database and created SAS datasets, SAS macros, proc/data steps and SAS formats as required.
7. 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.

Experience

7-10 Years

Level

Senior

Education

Bachelor Of Technology

Description :

1. Performed profiling of segments for demographic information using SAS EM profile node.
2. Assisted in designing marketing strategies for each specific segment to effectively tackle their differentiated needs.
3. Summarized the marketing research findings on the segments in terms of customer share, attrition risk, and satisfaction, etc.
4. Monitored the evolution of each segment through derived KPIs and the design of specialized marketing strategies.
5. Used SAS/SQL pass-through facility for connecting to various data sources.
6. Used base SAS to develop SAS extracts for transformation and loading of data.
7. Developed reusable code using SAS macros to direct the program to look for the table names.
8. Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools such as SAS/base, SAS/Macros, SAS/Graph, SAS/SQL, and SAS/connect.
9. Extensively used set, update and merge statements for creating, updating and merging various SAS datasets.
10. Created and maintained SAS data sets that are extracted from an Oracle database.

Experience

5-7 Years

Level

Executive

Education

MS

Description :

1. Maintaining and managing daily/monthly management reporting in collaboration with the MIS team.
2. Preparing weekly management updates, synthesizing data from multiple reports and sources.
3. Developing models for business drivers to improve portfolio profitability, including targeting and segmentation of new offers and products.
4. Analyzing portfolio performance in all areas, including delinquencies, losses, recoveries, payment rates, portfolio profitability and growth drivers.
5. Assisting with ongoing profitability analysis and the monthly p&l forecast/annual plan process.
6. Integrating results of the marketing mix analysis, consumer risk analysis, price elasticity and other advanced analyses into the business planning process.
7. Assisting in the creation of quantitative and qualitative primary research and present the findings.
8. Working closely with different marketing groups in designing and analyzing the data.

Experience

7-10 Years

Level

Senior

Education

MS

Description :

1. Managing design, loading, and validation of data transfers for clinical trials from quintiles information systems.
2. Coordinating clinical laboratory data transmissions, liaising with biopharmaceutical clients and database programmers, creating data.
3. Transferring agreements, and writing user test plans to test data transfer specifications.
4. Performed advanced querying using SAS enterprise guide, calculating computed columns, using the filter, manipulate and prepare data for reporting, graphing, and summarization, statistical analysis, finally generating SAS datasets.
5. Developed, modified and generated Monthly Business Review (MBR) reports and Quarterly Business Review (QBR) reports summarizing business activity using proc univariate, proc copy, proc transpose, proc report, proc tabulate and proc summary.
6. Created new financial tables and manipulated customer data by using various joins and merges and then appended the data (proc append) from the existing source tables containing millions of records.
7. Developing ad-hoc SAS programming solutions (including proc SQL, reporting, and macro features) to perform rapid, complex, and highly-precise querying and quality control of data transmissions.

Experience

7-10 Years

Level

Senior

Education

BS

Description :

1. Performed databases cleaning and validation using SAS procedures, macros.
2. Involved in clinical trials, data migration/extraction from flat files and SAS datasets.
3. Worked closely with data management, clinical and statistical personnel to clean inbound data from monitoring sites developed and tested programs for safety and efficacy to support the clinical trial management team.
4. Generated ad-hoc reports for analysis datasets using procedures print and.
5. Used SAS/ODS for delivering output in different formats including HTML.
6. Maintained the standards for dates and country along with other CDISC.
7. Involved in designing, implementation, and validation of SAS programs to produce descriptive/categorical statistical analysis for clinical studies.
8. Created SAS analysis datasets from raw data sets while adhering to the guidelines.
9. Created clinical trial data listing and summary tables - demographic, adverse events, serious adverse events, vital, ECG, plasma concentration.

Experience

7-10 Years

Level

Senior

Education

Doctorate

Description :

1. Creating analysis datasets, summary tables, listings and plots according to the specifications of the study for statistical analysis.
2. Data validation and quality control check of the displays and datasets according to the different QC levels.
3. Responsible for providing SAS programming and analysis support for phase ii and phase iii clinical study.
4. Worked extensively to generate SAS analysis datasets, listings, safety reports for cross-functional teams for Phase II to III data.
5. Extensively worked on proc report to produce reports for the purpose of validation.
6. Evaluated and provided input on sap for individual and pooled clinical data sets.
7. Involved in problem-solving, data analysis, and complex report generations.
8. Developed various forms of outputs, RTF, PDF, HTML files using SAS ods facility.
9. Experienced in SAS edit checks with automated quarry generation and validate clinical datasets.

Experience

5-7 Years

Level

Executive

Education

MS