SUMMARY

• Certified SAS Programmer with 7+ years of experience in Statistical Analysis, Reporting, and BI Data Warehousing.
• Experience in analysis, design, development, testing and implementation of various SAS programs, Macros and report generation tools
• Domain knowledge of Financial, Mortgage, Credit Risk, Retail, Direct - Marketing and Insurance industries.
• Extensive SAS Programming experience with Statistical background and experience.
• Thorough working experience in Base SAS, SAS Macros, SAS SQL, SAS/STAT, SAS/GRAPH, SAS ODS, SAS/ETL, SAS in Windows and Unix environments.
• Thorough knowledge of database warehouses like Teradata, Oracle, SQL Server, Sybase and SAS. Also used corresponding SQL’s to pull the data.
• Good experience with SAS OLAP Cube Studio to report the results into the excel sheets.
• Extracted the data using SAS/ETL to create reports from relational database or multi-dimensional cubes.
• Hands on experience with SAS DI Studio to define the metadata for Source and Target data.
• Creation, modification and maintenance of SAS catalogs. Development, maintenance and documentation of macro libraries.
• Have experience with SAS ENTERPRISE GUIDE to use/modify the stored procedures.
• Proven skills in Data Cleansing, Data Archival, Data Migration, ad-hoc reporting and coding utilizing SAS.
• 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.
• Hands on experience about Quality Checking the data and online web reports.
• 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 Confidential all levels. Ability to work effectively both as an individual and as part of a team.

TECHNICAL SKILLS

SAS Modules: SAS v9.4, v9.3, v9.2, v.9.1, v8.2 (Base, Macro, ODS, ACCESS, CONNECT, GRAPH, STAT, SAS/ETL) SAS Enterprise BI Platform (EBI), Enterprise Guide, SAS Information Map Studio, SAS Web Report Studio (WRS), SAS DI STUDIO, SAS/CUBE STUDIO, SAS Information Delivery Portal.

Operating Systems: Windows, UNIX

Languages: SQL, PL/SQL, C, Java

Databases: Teradata, Oracle, SQL Server, DB2, Sybase, MS ACCESS

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

SAS Database Analyst

Responsibilities:

• Working on Home Mortgage project, responsible for Data extraction, Transformations and Loading process.
• Develop coding for Credit Analytics & Reporting (CAR) and Corporate Credit Analytics & Reporting (CCAR).
• Well experienced in handling and creating large data sets.
• Create Macros and export data into MS Office compatible formats like Excel sheets.
• Excellent coding skills in Base SAS and Proc SQL in creating Data Sets by using all kinds of joining.
• Write the SAS code and run those data sets to produce necessary financial reports by using SAS/STAT Procedures such as PROC Freq, PROC Tabulate, Proc Univariate, PROC ANOVA and PROC Summary.
• Extract Data from Clrty Database and TeraData and SasGrid by using Proc SQL.
• Well experienced in creating and managing all Tables.
• Well knowledge in Validation data and Prepare Monthly Reports.
• Experience in develop code and prepare reports in SAS Enterprise Guide 5.1, Finish allocated tasks earlier than deadlines.
• Responsible for Statistical Analysis of Data and performance issues in Data.
• Using data cleaning techniques such as Proc freq, Proc Print, null, proc means, proc tabulate, Proc Univariate, Proc SQL, nodupkey, Proc character, invalid, and discrete data character values.
• Converts data types by using Put and Input functions and use appropriate format & informants for Date fields.
• Good communication skills with Superiors and colleagues and fast Understanding skills of Project in Business point of view.

Environment: SAS Enterprise Guide 5.1, SAS v9.4, Base SAS, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, SAS/ETL, UNIX SAS, PC SAS, Oracle, DB2, PL/SQL, MS Excel, MS Access.

Confidential, Middle Town, NJ

SAS Programmer Analyst

Responsibilities:

• Currently working on in-house Survey project handling the responsibilities of SAS programming and QA analysis/testing
• Performed data and QA analysis, tested/completed the deliverables and presented the analyzed/output data based on the requirements understanding of business process, the data and the user.
• Experience in creating reports in SAS Enterprise Guide v4.2/4.3
• Built and maintained SAS Stored processes using SAS EG and SAS Programs.
• Create SAS cubes and data sets from data in DB2 data warehouse
• Created Parameter based reports that can be modified according to user Inputs using SAS EG and SAS Web Report Studio.
• Created and maintained various Development repository objects using SAS DI Studio.
• Worked on edit check programs to maintain data consistency and data validation.
• Production Job Scheduling and Monthly Run.
• Transformed the statistical data in various formats (excel, access) into SAS data sheets. Provided statistical programming expertise in the production of QA analyses, tabulations, reports and listings.
• Develop and execute test cases based on the specs provided by the statisticians.
• Derived from specifications of survey regarding editing, coding and reports.
• Accompanied in Phase I various consulting sessions and provided support in statistical analysis including choice of experiment design, management of data, statistical procedures for analyzing experiments, interpretation of the results, statistical modeling and statistical computing.
• Developed programs for cleaning, transforming and modifying the data daily
• Updated documentation during the life cycle of QA testing like design processes, business specs, comments in the code, record the issues/problems and record the inputs/outputs
• Actively participated in internal QA peer reviews and managing the project folders on project shared drive.
• Used base SAS and SAS/SQL to generate tables.
• 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.3, v9.2, SAS/Macros, SAS/SQL, SAS OLAP Cube Studio 4.2, SAS Enterprise Guide v4.2, SAS/ACCESS, SAS/STAT, Teradata, Oracle, SQL, Windows XP, UNIX, SPSS, HummingBird Exceed, Teradata SQL Assistant, TOAD, MS Office.

Confidential, Wilmington, DE

SAS Programmer

Responsibilities:

• Developed many reports, listings based on SOP, using various Procedures in Base SAS and SAS/Stat.
• Wrote macros to streamline the process of development of programs with respect to study related parameters.
• Performed Data analysis, statistical analysis, generated reports, listings and graphs using SAS Tools - SAS/Base, SAS/Macros and SAS/Graph, SAS/SQL.
• Analyzing the task before doing the configuration.
• Maintaining large data sets, i.e. reading in data from various sources in various formats to create SAS data sets and/or ASCII files.
• Documenting the process, i.e. documenting all the possible information about the application like SAS programs, DATA files and source.
• Convert excel data files into SAS data sets.
• Creating SAS datasets by using Base SAS
• Involved in development and enhancement of SAS programs.
• Documentation, Analysis through using SPSS and SAS
• Created plots using PROC GPLOT in SAS.
• Generating graphs using SAS/GRAPH
• Handle with around 150 Millions of Records.
• Created User free reports using SAS BI Technologies.
• Tested whole process (Unit, UAT, Integration, and Regression).
• Validation the data using latest SAS functions.
• Used SAS/SQL to pull data out of a relational database and aggregate to provide detailed reporting based on the user requirements.
• Responsible for providing statistical research analyses and data modeling 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.
• 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.

Environment: SAS/Base, Windows, SAS/ BASE, SAS/MACRO, SAS/SQL, SAS/GRAPH, SAS/Access, SAS/Enterprise Guide, SAS DI (SAS ETL), Enterprise Miner, Web Report Studio, OLAP Cube Studio, DB2.

Confidential, Nashville, TN

SAS Analyst

Responsibilities:

• Extracting financial data from the database using SAS/Access, PROC SQL, SAS/Connect, Procedure and create SAS permanent data sets in SAS library.
• Creating SAS Views from tables in Database using SAS/Access, and analyze data.
• Retrieved the financial data from flat files received from the vendors, convert them into SAS readable format. Make the SAS data sets, analyze data as per given requirement.
• Write the SAS code and run those data sets to produce necessary financial reports by using SAS/STAT Procedures such as PROC Freq, PROC Tabulate, Proc Univariate, and PROC ANOVA.
• Design of ETL process to meet the requirement of data demand.
• Writing Meta data for important data set before archive into SAS metadata server.
• Used data cleaning techniques such as Proc freq, Proc Print, null, proc means, proc tabulate, Proc Univariate, Proc SQL, nodupkey, Proc character, invalid, and discrete data character values.
• Created required financial reports using analysis output and export them to other environments or the web using various SAS method like create delimited, text files, ODBC, CEDA, CPORT, ODS having formats such as HTML, RTF, or XML.
• Regular interaction with the financial analysts for the presentation.
• Performed in-depth quantitative data analysis.
• Extensively used procedures like PROC SQL, PROC PRINT, and PROC SORT etc.
• Coded SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs.
• Experience in Advance SQL to extract data from various databases like Oracle.
• Worked with SQLPLUS, and PL/SQL extensively to solve database problems to make database effective and efficient tuning purpose. In PL/SQL Implement of DML, Implicit and Explicit Cursors, function, conditional logic, creating and ODBC connection.
• Experience in Transferring and converting data from one platform to another to be used for further analysis. (From Oracle and Excel to SAS both export and import of data)
• Interfaced programs with Oracle databases to provide accurate reporting, archiving, and error handling.
• Scheduled and managed jobs with AutoSys job management system to ensure job streams flowed smoothly.

Environment: Base SAS, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, SAS/ETL, UNIX SAS, PC SAS, Oracle, DB2, PL/SQL, MS Excel, MS Access

Confidential

SAS Programmer

Responsibilities:

• Performing data analysis, data migration, data preparation, graphical presentation, Statistical analysis, reporting, validation and Documentation
• Creating and modifying existing SAS datasets using PROC DATASETS, PROC IMPORT, PROC SQL, IMPORT WIZARD, etc
• Retrieved the Actuarial data and convert them into SAS readable format. Make the SAS data sets, analyze data as per given requirement.
• Interactively meeting the Actuarial teams for getting the required data to generate the reports as per business requirements.
• Performed data analysis to identify the fraud claims internally.
• Developing and analyzing key performance indicators relevant to emerging business needs using PROC FREQ, PROC TABULATE, PROC MEAN, PROC UNIVARIATE, PROC GLM, PROC TTEST, PROC TRANPOSE, and DATA NULL
• Good understanding of Health care terminology such as Medicare, Medicaid, HIPPA, CPT, DRG and HCPAC.
• Developing SAS programs using SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS, etc for statistical analysis and data displays
• Generating reports to communicate key findings and articulate strategic implications using PROC PRINT, PROC REPORT, PROC TABULATE, PROC MEAN,
• PROC GPLOT and PROC GCHART
• Built summary reports after identifying customers, occupancy period and revenue generated using PROC SUMMARY, MEANS and FREQ. Updated Revenue item table on a daily basis.
• Participated in Program validation and e-submission (CDISC).
• Generated listings and reports from SAS programs using MACROS, ODS and PROC TEMPLATE/REPORT/TABULATE and using Word, Excel and PowerPoint as well
• Documented purpose and methods used in each SAS program

Environment: UNIX (AIX 5.2), XP, Base SAS v9, VI Editor, SAS Enterprise Guide, SAS/MACRO, SAS/GRAPH, SAS/STAT, MS Excel, DB2, Oracle, Win SCP, TOAD, MS Office.