SUMMARY:

• 8 years of experience as SAS/SQL Programmer, with experience in programming, analysis, design, development, maintenance, documentation, testing and implementation
• Experience in utilizing SAS Functions, SAS Procedures, Macros, and other SAS application for data updates, data cleansing, and reporting
• Excellent command in analyzing data and producing reports by employing various SAS Procedures and modifying existing SAS programs and creating new SAS programs using SAS techniques
• Extensive experience in producing Financial and Mortgage Reporting in the Banking Environment
• Experience in using and creating UNIX shell scripts to process SAS jobs and other common tasks
• Experience working with large data sets for producing reports using various SAS procedures
• Expertise in Data Cleaning, Data Archival, Data Migration, ad - hoc reporting and coding utilizing SAS/SQL on Windows and UNIX
• Working experience managing very LargeSASDatasets using heterogeneous databases like Oracle, Teradata, DB2 and SQL Server
• Extensive experience in data extraction and sorting from different databases like Oracle, Teradata, SQL and MS Access using SQL pass through facility
• Extensive experience in SAS/BASE, SAS/SQL, SAS/MACRO, SAS/CONNECT, SAS/GRAPH, SAS/ACCESS, SAS/ODS, in Windows and UNIX environment
• Experience working with large database to perform complete data retrieval, manipulation using multiple input files using SAS data steps
• Generated reports using PROC REPORT, AND PROC TABULATE for customized report writing.
• Thorough Experience in creating SAS datasets and developing SAS Procedures, Macros, and application for data updates, cleaning, and reporting.
• Developed UNIX scripts for batch jobs. Connected and accessed other PC File Formats and SQL Server through ODBC
• Experience in Business Intelligence tools such as Cognos and Tableau
• Managed deliverables against aggressive timelines
• Strong Analytical, quantitative and problem solving skills

TECHNICAL SKILLS:

SAS Skills: SAS (Base, ACCESS, STAT, MACROS, ODS, SQL and GRAPH)

Databases: Oracle 11g, Teradata, DB2, SQL Server

Environment: SAS 8.x, SAS 9.0, SAS 9.1.3, SAS 9.2, Tableau, SQL, COGNOS, Base SAS, SAS/CONNECTSAS/SQL, SAS/ACCESS, SAS/Base, SAS/Enterprise Guide, SAS/ DIStudio SAS / ETL, SAS/Macros, SAS/ Portal, SAS/Access, UNIX

Additional Software: MS Office Suite (Word, Excel, PowerPoint,Visio)

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Senior Quantitative Analyst

Responsibilities:

• Responsible for performing data analysis, business requirements gathering, programming, development, validation and implementation of mortgage processes
• Programming in SAS, SQL to generate reports for various reporting needs
• Automated manual, complex, unclear, tedious requirements such as HAMP 60+ Monthly Survey and Troubled Debt Restructured processes (TDR) from operations and produce reports that are clear, concise and easy to analyze using SAS and SQL
• Meet with business users and client to clearly define reporting needs, identify key performance measures, set benchmarks, design and develop reports using SAS and Cognos
• Spearheaded various reports for different lines of business such as Foreclosure, Loss Mitigation, Bankruptcy, Consumer Loans, MERS and Servicing
• Created calculated fields and formula to query for customized data and data analysis. Worked with Quick table calculation to represent right metric for analysis. Knowledge of Operators, Data types to create formula and calculated fields
• Understanding the Business process flow and gathering requirements from Business users and converting them into programming specifications
• Created and automated SAS scripts that run at specific schedule and email the results using Windows Scheduler
• Developed new and modified existing SAS reporting programs and automated them
• Developed several ad-hoc reports to support mortgage with analytics
• Responsible for running daily, weekly, monthly mortgage reports, escalate and fix issues if any failure occurs and identify errors in them
• Involved in developing and maintaining documentation of mortgage operational processes
• Worked closely with the end users for creation of reports in several formats such as HTML, Email, excel, PDF using SAS ODS and Proc Report
• Created several reports summarizing the loan level data using Pivot table created in SAS by invoking VB Scripts
• Implemented best programming practices to meet the industry standards and for easy debugging
• Performed quality control (QC) checks against database to ensure correct data was entered

Environment: SAS 9.4, SQL, Passport, COGNOS, Tableau Data mart, Share point, FTP, Ultra Edit, MS Office

Confidential, Henrico, VA

SAS Analyst

Responsibilities:

• Supported development of regulatory capital models for Basel compliance using SAS EG and UNIX. The purpose of the models are to calculate various risk measures (scores) such as Loss Given Default (LGD), Exposure at Default (EAD), and Probability of Default (PD) for various portfolios
• Developed and optimized U.S. Card Model using the best SAS techniques
• Extracted data from Teradata database using SAS/ACCESS for creating derived SAS datasets. Used SAS/CONNECT to remote submit jobs on different servers
• Developed and optimized codes with different optimizing techniques such as data steps, data step view, proc SQL procedures and proc append
• Implemented various SAS functions, Statements, Procedures and Macros
• Extensively used and created SAS/Macros for the efficiency and accuracy
• Used BASE SAS procedures FREQ, SQL, SORT, MEAN to validate current results with expected results.
• Responsible for installing activities to generate reports, using SAS, DATA NULL, SAS Macros, and SAS Procedures (FREQ, MEANS, SUMMARY) from multiple source files totaling 32 million observations and more than 800 variables
• Created process flow diagrams and data mapping documents
• Prepared documentation for the US Card Model using MS Visio and MS Excel

Environment: SAS Enterprise Guide, SAS/Macros, Teradata SQL Assistant, SAS\UNIX, Ultra Edit, MS Office

Confidential, Warren, NJ

SAS Programmer

Responsibilities:

• Understanding the Business process flow and Gathering the requirements from Business users and converting them into programming specifications for and documenting
• Worked closely with database management team for various output files for various channels like Direct Mail, Phone Channel, email and ATM
• Extracted data from Oracle database using SAS/ACCESS for creating derived SAS datasets. Used using SAS/CONNECT to remote submit jobs on different servers
• Extracting data from the database using Proc SQL pass-through facility and by using SAS/ACCESS Libname engine and created analysis ready SAS data sets
• Analyzed, maintained, designed and generated portfolio reports on monthly and quarterly basis for Loans
• Participated in reviews of portfolio and risk oversight activities
• Debugged existing macro code to find and fix the issues in the current reports. Created new macros to automate the creation of daily, weekly and monthly reports based on the time stamp of the data
• Store and distribute results in different formats HTML, PDF, RTF using SAS ODS, PROC REPORT

Environment: SAS 9.2, SAS/SQL, SAS/GRAPH, MS Excel, Oracle.

Confidential, Hartford, CT

BI Support Specialist

Responsibilities:

• Extracting and converting data from Oracle, Excel, .CSV and raw text files in to SAS datasets by using SAS Input techniques and SQL procedure
• Worked on multiple data bases using SAS and provided reports that supported information-based decision making, and identified opportunities for improving existing processes
• Developed and designed SAS Programs / Macros to access and analyze financial data. Generated Statistical analysis files, tables, listings, and graphs
• Developed new and modified existing SAS reporting programs and automated them
• Extensively used various SAS procedures like SQL, FREQ, MEANS to analyze and understand data quality, produce reports and handle the missing values and out of range values
• Created the customized reports based on total costs and sales based on different advertisements
• Analyzed the data of advertised contents based on people response and created reports based on their demographic information
• Generated customized reports and ad-hoc reports PROC REPORT, PROC PRINT, PROC TABULATE, PROC FREQ and PROC SQL. Automated report generation from UNIX using UNIX Shell scripts
• Extensively performed Data Cleansing and created Edit checks during the ETL’s Extraction and Loading Phase by analyzing the raw data and creating complex reusable Macros
• Extensively used constraints for defining the data, modified the data and wrote queries and sub queries like non related and correlated queries in SQL for the data analysis
• Created Macros and extensively used for the data analysis and producing the reports

Environment: SAS 9.2, SAS/ACCESS, SAS/CONNECT, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ODS, UNIX

Confidential, Davie, FL

SAS Analyst

Responsibilities:

• Adeptly performed Data Management for the Business Unit using SAS
• Created ETL workflows in SAS/Data Integration Studio to populate the analytical data marts for business reporting
• Designed, implemented, and maintained the Data Warehouse extract, transformation and load (ETL) processes (including timeliness, accuracy, completeness. and metadata)
• Responsible for monthly surveillance reports tracking deals for Profit and Loss analysis using SAS and Excel
• Involved in developing and maintaining documentation of operational processes and data mappings
• Developed data load programs using SAS Enterprise Guide to insert data periodically into the SAS server in UNIX
• Designed and coded ETL processes with varied source systems like Oracle, SQL Server and flat files
• Developing standard reconciliation programs using MACROS
• Enhanced the existing SAS Macros to automate the job
• Exported large SAS data sets (more than 300 variables) to external files to be sent to external vendors using SAS and SAS/Macro
• Developed an application using Base SAS, Proc SQL and Proc Contents to generate concise data profiling reports

Environment: SAS EG, Base SAS, SAS/SQL, SAS/GRAPH, MS Excel, Oracle

Confidential, NJ

Programmer Analyst

Responsibilities:

• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools such as SAS/Base, SAS/Macros, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access
• Prepared charts, tables, and diagrams to assist in analyzing problems, utilizing various business and mathematical techniques
• Planned projects, estimated project requirements, communicated well with customers at a level they understand and developed in-depth understanding of business areas where existing or modernized programs could provide solutions
• Have got experience in Data Mining to translate goals such as profit and margin share targets
• Generated all the Safety Tables & Plots for the whole Analysis
• Provided maintenance support for online programs, technical documentation (program specification changes, test plan, test case preparation, test results)
• Provided GUI with SAS Enterprise Guide interface for the data access and the data manipulation associated with SAS mechanism

Environment: SAS, SAS/SQL, SAS/ODS, SAS/ACESS, UNIX

Confidential

SAS/SQL Programmer

Responsibilities:

• Involved in coding analyzing, Report generation and testing programs using with SAS/BASE, SAS/MACRO, PROC REPORT and SAS/SQL according to the client requirement
• Created Reports and listings of the customer data as per guided by the Sr. Programmer and performed it using Proc Sort, Proc Means, Proc Freq
• Writing SAS data sets into a delimited text file and validated data and created HTML reports using different procedures like proc freq, proc means, proc transpose, proc datasets, proc sort, proc compare, proc sql, proc report and SAS ods facility
• Extensively used the Set, Update and Merge statements for creating, updating and merging various SAS datasets
• Presented the output of the program by using SAS/Graph
• Prepared SAS data sets for the customer complaint using Proc Freq, Proc Report and Proc Tabulate
• Provided support in the statistical programming for the generation and validation of summary tables and listings
• Responsible for the generation of key analysis datasets and extraction of the SAS datasets
• Designed, coded, tested and debugged SAS programs to generate listings, Tables
• Recommended portfolio credit indicators to record quality and performance
• Estimated Credit risk and client development, analyzing financial statements and cash flow of customers
• Generated SAS macros as part of the standard programs and validation

Environment: Base SAS, SAS Macros, SQL