SUMMARY

• Over 8 years of experience in IT as a SAS Certified Programmer/Analyst with profound experience in Financial, Retail, Mortgage and Health care industries.
• Expertise in BASE SAS programming, SAS/Macros programming and debugging, experience in the skills in SAS/BASE, SAS/MACRO, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/ODS.
• Utilized Enterprise Guide and its functionality to create project flows which could include aspects of data access, manipulation, summarization, and report generation to a variety of output formats and channels
• Experience in analysis, design, development, testing and implementation of various SAS programs, Macros and report generation tools.
• Strong experience in coding using SQL, SAS/SQL, SAS macros.
• Modification of existing SAS programs and creation of new programs using SAS macros to improve ease and speed of modification as well as consistency of results.
• Experience in using different relational database management systems like DB2, Teradata and Oracle.
• Experience working on different operating systems (Unix, Windows)
• Created and customized Macros for use in data cleaning, initialization, creation of analysis, datasets and report generation for business.
• Followed System Development Life Cycle (SDLC) methodology for the design, development, implementation, and testing of various SAS modules.
• Experience in creating test scenarios to find errors and confirm programs meet specifications. Program Documentation and Review.
• Thorough Knowledge and experience of Microsoft Office tools like MS Access, MS word, MS PowerPoint, MS Excel, MS Visio, MS Project Management, Lotus Notes and MS Outlook.
• Excellent communication, analytical, interpersonal, presentation and problem solving skills.
• Experience in updating and creating documentation of code, guidelines, and high level documentation.
• Writing “Edit Check” programs for data validation. Creation and validation of Analysis Datasets.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels. Ability to work effectively both as an individual and as part of a team.
• Exceptionally well organized. Enthusiastic, innovative and challenge oriented.
• Ability to quickly adapt to new applications and platforms.

TECHNICAL SKILLS

Statistical Packages: SAS 8.x 9.x (Base SAS, SAS/STAT, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, SAS/ODS), SAS Enterprise Guide.

Databases: Oracle, DB2, Teradata, Sybase.

Languages: SAS, SQL, C, C++, Core JAVA.

Platforms: Windows and UNIX.

Others: MS office, MS Visio, MS Project Management, Ultra Editor Studio, VBA macros.

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, IA

SAS Analyst/ Programmer

Responsibilities:

• Make the results actionable for Marketing, Campaign Planning, Strategic Planning, Finance and Sales groups.
• Integrate results of the Marketing Mix Analysis, Price Elasticity and other advanced analyses into business planning process.
• Assist in the creation of quantitative and qualitative primary research and present the findings.
• Ability to dig into raw data to find and evaluate actionable insights that will help the organization.
• Analyze and interpret significant results based on data summaries.
• Work closely with different Marketing Groups in designing and analyzing the data.
• Responsible for providing statistical research analyses and reports in support for mortgage product.
• Analyzing credit report to determine credit worthiness and performing risk evaluations.
• Ensuring loans are structured and priced consistently with bank policy and commensurate with risk.
• Analyzing and calculating debt to income ratio for evaluating mortgagor’s financial risk and provide recommendation to mortgagor to lower debt to income.
• Evaluating and recommending affordable options to mortgagor to help reduce financial loss.
• Run daily report to help determined how many loans are in foreclosure or will be in foreclosure within the next ten days.
• Extract the data from a data warehouse and create ad - hoc reports, tables, and graphs according to Business needs.
• Perform statistical analyses and QC statistical output.
• Results are performed using SAS programming and using techniques such as SAS Macro language, advanced data manipulation, and statistical procedures (e.g., PROC FREQ, PROC REPORT).
• Used various procedures such as Proc Tabulate, Proc Means and Proc Report to generate tables, listings, graphs and reports.
• Provide SAS Programming support and technical assistance in the accurate development and intermediate steps required.
• Present statistical results using the appropriate graphs, charts, tables and written reports.

Environment: Base SAS v9.2, SAS/Macros, SAS/SQL, SAS Enterprise Guide v4.2, SAS/ACCESS, SAS/STAT, Oracle, DB2, Teradata, Project Management, UE Studio, Windows XP, UNIX.

Confidential, Pheonix, AZ

SAS Programmer/Analyst

Responsibilities:

• Converted the weekly, bi-weekly, monthly and quarterly reports from ad-hoc database to new data warehouse using SAS, SQL and Macros with better and accurate values.
• Experience in creating reports in SAS Enterprise Guide v4.2/4.3
• Utilized SAS/ACCESS to extract data from Sybase and other relational databases for analysis.
• Prepared new datasets from raw sets files using Import Techniques and modified existing datasets using data statements such as SET, MERGE, UPDATE and PROC SORT.
• Designed, developed, tested and debugged new MACROS and modified the existing macros according to the enhancements in the business.
• Worked on edit check programs to maintain data consistency and data validation.
• Production Job Scheduling and Monthly Run.
• Worked on ad-hoc requirements and later converted them as monthly and quarterly reports.
• Developed and maintained the regular codes and made some amendments as per the business changes.
• Written effective new codes to get the required analytical summary data.
• Transformed the statistical data in various formats (excel, access) into SAS data sheets. Provided statistical programming expertise in the production of analysis, tabulations, reports and listings.
• Developed programs for cleaning, transforming and modifying the data daily.
• Used base SAS and SAS/SQL to generate tables.
• Generated the production reports and submitted with key observations and recommendations.
• Validated SAS data sets using PROC MEANS, PROC FREQ and PROC UNIVARIATE.
• Formatted HTML, RTF and PDF reports using SAS output delivery system ODS.
• Responsible to write the SAS programs to perform the QA analysis/testing.
• Used PROC compare to compare the data before and after editing
• Developed various SAS reports for Survey project and involved in code reviews for all the developed reports

Environment: Base SAS v9.2, SAS/Macros, SAS/SQL, SAS OLAP Cube Studio 4.2, SAS Enterprise Guide v4.2, SAS/ACCESS, SAS/STAT, Sybase, Windows XP, UNIX, Project Management, UE Studio.

Confidential, Greensboro NC

SAS Programmer/Analyst

Responsibilities:

• Utilized SAS/ACCESS to extract data from Oracle and other relational databases for analysis
• Prepared new datasets from raw sets files using Import Techniques and modified existing datasets using data statements such as SET, MERGE and PROC SORT
• Tested and debugged existing MACROS
• Extensively used PROC REPORT and PROC TABULATE to create reports
• Generated safety tables, which also involved in analyzing data and generating Reports
• Created reports using the DATA NULL and the PROC REPORT for the submission as per the regulations and company standards
• Validated SAS data sets using PROC MEANS, PROC FREQ and PROC UNIVARIATE
• Formatted HTML, RTF and PDF reports using SAS output delivery system ODS
• Worked with automation team to automate the reports using SAS/DDE and VB macros.
• Prepared extensive summary for clinical data research data.
• Performed quality control checks on tables, listing etc generated by other team members.

Environment: SAS/BASE, SAS/MACRO, SAS/Access, Enterprise Guide, SAS/STAT, MS-Excel, Visio, ORACLE, Windows XP

Confidential

SAS Officer

Responsibilities:

• Developed SAS programs for statistical analyses and data displays.
• Took raw data, built input data sets used sorting and merging techniques to get the required output and then wrote code using SAS/Base, Proc SQL and SAS Macro facility.
• Raw data was processed to create datasets in the required format and tabulated so as to easily analyze data. Extensively used Proc Tabulate procedure for the purpose.
• Data Analysis and graphical presentation for various summary reports using Base SAS and SAS/Graph facility.
• Report generation using many SAS proc statements, SAS/MACROS, and data null steps.
• Actively involved in design and implementation of application software using primarily SAS system and analyzed existing application software and recommended improvements.
• Extracted raw data from excel spreadsheets and MS Access. Created input data sets and analyzed the data by creating graphs using the SAS/GRAPH facility.
• SAS was used for pre-processing data, SQL queries, data analysis, generating reports, and statistical analyses.
• Processed data collection to ensure proper quality of data. Maintained the daily error log for cleaning the data.
• Extensively used data export techniques. The data after being analyzed was directed to different output files such as Excel Spreadsheets and DBF files
• Extensively used Proc SQL procedure for working with oracle database for creating and updating the data as and when processed.

Environment: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/ACCESS, MS Excel, Access 2000, Window NT/2000

Confidential

SAS Officer

Responsibilities:

• Modified/developed SAS codes for data cleaning and Reporting and to support routing processing.
• Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/ Base and SAS/ Macro facility.
• Identified problems with the data, if there were any, and also produced derived data sets, tables, listings and figures, which analyzed the data.
• Produced quality customized reports by using PROC TABULATE, REPORT, and SUMMARY and also provided descriptive statistics using PROC Means, Frequency, and Univariate.
• Report generation using many SAS procedural statements, SAS/MACROS, and data null steps.
• SAS was used for pre-processing data, SQL queries, data analysis, generating reports, and statistical analyses.
• Processed data collection to ensure proper quality of data. Maintained the daily error log for cleaning the data.

Environment: SAS/BASE, SAS/SQL, SAS/ACCESS, MS Excel, MS Power Point, Window NT/2000