SUMMARY

• Over 7 years of experience in IT as a SAS Certified Programmer/Analyst with profound experience in Financial, Retail, Mortgage 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.
• Experience using TERADATA utilities (Queryman, BTEQ, FastLoad, MultiLoad, OleLoad, Fast Export, Tpump, Visual Explain, PMon, Teradata Manager).
• 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, Mainframes) .
• 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: SQL,Teradata.

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, Richmond, VA

SAS/Data Analyst

Responsibilities:

• Involved in credit risk assessment model to calculate risk factor for individual clients based on hierarchy.
• 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.
• Documented methodology, data reports and model results and communicated with the Project Team / Manager to share the knowledge.
• Imported data using LIBNAME and PROC SQL Pass - Thru facility to reduce processing time.
• Wrote SAS programs in UNIX platform.
• Responsible for importing, manipulating and generating weekly and monthly list reports using SAS Enterprise Guide
• Generated customized reports using PROC REPORT, PROC TABULATE and PROC SQL.
• Used SAS Data Step logics to Sort, Merge, Stack, Update and Interleave datasets for producing required analysis of data
• Responsible for developing marketing strategies as a part of a research project using predictive modeling and score cards in SAS Miner environment
• Imported raw data files in excel format in SAS and subsequently created SAS datasets and performed data cleaning and data manipulations for further analysis and reporting.
• Assisted in investigating and applying new SAS programming methods and techniques to enhance current systems by using various SAS macros and standard programming procedures.
• Worked extensively on Teradata, Oracle, SQL Server.
• Used SAS extensively for Match merge, Append data validation, and Data correction and Cleansing.
• Portfolio management, Credit Risk Analytics, Portfolio tracking and reporting, creating and maintaining Credit Policies, Managing Marketing Campaigns, testing out new Champion and Challenger strategies, understanding 3rd party data etc.
• Used data step options like KEEP, DROP, and RENAME as a part of storage efficiencies. Data set options IF, where, missover, truncover etc. were used in reading raw data files.
• Created Macros and developed SAS programs for Data cleaning, Validation, Analysis and Report generation using newly created as well as existing macros.
• Performed validation/quality control check of SAS programs.

Environment: SAS/Macros, SAS/SQL, SAS Enterprise Guide v5.1, SAS/ACCESS, SAS/STAT, LINUX, UNIX, predictive Modeling, MVS, MS Visio.

Confidential, Miami lakes, FL

SAS/Data Analyst

Responsibilities:

• Make the results actionable for Marketing, Campaign Planning, Strategic Planning, Finance and Sales groups.
• Integrate results of the Marketing Mix Analysis, Consumer risk 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.
• Responsible for creating and delivering recurring as well as ad hoc marketing campaign programming within strict timelines while under constantly changing requirements using SAS, SAS SQL, and Teradata SQL in a UNIX environment with Oracle, Informix, and Teradata relational databases.
• 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.
• WroteSAS JCL programs to extract data from DB2 tables and send it to different Mainframes and UNIX servers using FTP.
• Perform statistical analyses and QC statistical output.
• Testing and debugging of all ETL and Teradata objects in order to evaluate the performance and to check whether the code is meeting the business requirement.
• 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 10g, SQL, Pl/SQL, Teradata, DB2, UNICA, IBM Mainframes, ER Win, Windows XP, UNIX.

Confidential, Milwaukee, WI

SAS/ Information 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.
• DevelopedSAS /SQL programs for datapreparation and validation to support model development (Teradata,Oracle,and DB2 databasespowered by IBM Mainframes
• 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, Oracle 9i, SQL, Pl/SQL, MVS, IBM Mainframes, Windows XP, UNIX, Project Management, UE Studio.

Confidential

SAS Analyst

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, Oracle, Pl/SQL, MS Excel, Access 2000,