SUMMARY

• 6.5 years of strong SAS programming experience in data analysis, data migration, Reporting, Statistical modeling and applications in Banking, Financial and Retail domain.
• And key subject matter expertise in end - to-end SAS programing and development.
• Extensive hands-on experience in using Base SAS, Macro SAS, and SQL in UNIX Environment.
• Advanced skills on data cleaning and manipulation using procedures such as PROC SUMMARY, PROC SORT, PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC FORMAT, PROC TRANSPOSE, PROC PRINT and many SAS data steps such as ARRAY, MERGE, SET, etc.
• Good command in producing tables, listings, and reports employing SAS procedure steps such as SAS ODS, DATA NULL, PROC REPORT, and PROC TABULATE according to the requirement.
• Implemented logical statements such as IF/ELSE, SELECT, WHERE to streamline the data processing and preparing reports quickly.
• Experience in bringing large data from SAS and non-SAS data sources into a SAS environment and performing SAS data manipulations against the resulting sets.
• This includes ability to merge datasets and to write SAS Macros and generate list outputs/reports.
• Good command in importing and exporting complex internal data to and from Microsoft Excel and Microsoft Access using PROC IMPORT and PROC EXPORT.
• Created graphs using PROC GPLOT and GCHART permanent formatted SAS data sets for present and future analysis, infield several data sets and sorted and merged by common variables.
• Worked as an inevitable resource supplying basic raw data for the Regulatory Reporting Team who predominantly focused on Basel III and CCAR Reporting.
• Thorough Knowledge and experience in Microsoft Office tools like MS Access, MS SharePoint, MS word, MS PowerPoint, MS Excel.
• Used MS Office (e.g. Excel - Pivot table, PowerPoint) facility to create effective visualization and presentation to communicate data driven insights to Marketing and Customer Insights team.
• Assisted colleagues and senior management across various geographies around how to leverage and interpret the available data and metrics.
• Extensive experience in generating data driven insights to drive business outcomes.
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
• Excellent project and relationship management, communication and team building skills along with great interpersonal skills, leadership qualities, capable of handling multiple tasks and priorities

TECHNICAL SKILLS

Platforms: Windows, Unix, Macintosh

Programming Languages: C, C++, SAS, Python, SQL, VBA

Statistical Packages: SAS v9.2/v9.3 (Base SAS, SAS/STAT, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/ CONNECT), R-Studio

Databases: Oracle, SQL Server

Other Technologies: ETL, MS-Office, MS-Power point, MS-Excel, MS-Access

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Senior SAS Programmer

Responsibilities:

• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS.
• Read datasets with a lot of missing values using MISSOVER and TRUNCOVER.
• Extensively used the SET, UPDATE and MERGE statements for creating, updating and merging various SAS data sets
• Converted the financial data retrieved from vendors into SAS readable format and executed the datasets to produce necessary financial reports using SAS/STAT procedures such as PROC FREQ, PROC REPORT, PROC UNIVARIATE and PROC ANOVA.
• Developed application for measuring financial performance of newly acquired accounts such as Forecast Vs Actual and developed SAS programs for generating reports on key financials, Income Statements and Balance Sheets.
• Developed complex SAS Macros to simplify SAS code and effectively reduce coding time.
• Performed complex statistical analysis using PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG, and PROC ANOVA.
• Worked with complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT, PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts
• Created reports in the style format (RTF, PDF and HTML) using ODS statements and PROC TEMPLATE. Used DBLOAD procedure to load data into the database effectively prepared and published various performance reports and presentations
• Produced weekly and monthly-customized reports by using PROC REPORT, DATA NULL and PROC REPORT.
• Worked with Regulatory Reporting Team to prepare basic raw data for Basel III and CCAR Reporting.

Environment: SAS 9.29.3/, BASE/SAS, SAS Enterprise Guide, SAS/MACRO, SAS/SQL, SAS/CONNECT, SAS/ACCESS, SAS/ODS, UNIX and Windows XP and SQL SERVER 2005.

Confidential, Norwalk, CT

SAS Programmer

Responsibilities:

• Developed and designed SAS Programs/ Macros to analyze financial data and to generate reports.
• Used SAS/ACCESS to extract data from ORACLE and SQL SERVER.
• Created different datasets by combining individual datasets using various inner, outer, right and left joins using SAS/SQL.
• Created and modified existing SAS datasets using PROC SQL, PROC DATASETS, PROC IMPORT, etc.
• Performed ETL - Extraction/Transformation/Loading, Data Analysis, Data migration, Data preparation, Graphical Presentation, Statistical Analysis, Reporting, Validation and documentation using SAS.
• Extracted and concatenated data from internal and external resources, including demographic and credit variables, payment history and frequently using SAS Macro, data steps and procedures including Proc SQL, Proc Sort, Proc Format, Proc Summary, Proc Export, Proc Transpose, Proc Freq, Proc Contents, Proc Print etc.
• Built summary reports to communicate key findings/performance indicators and articulated strategic implications using PROC PRINT, PROC REPORT, PROC TABULATE, PROC UNIVARIATE, PROC MEAN, PROC GPLOT and DATA NULL .
• Developed SAS programs using SAS/BASE, SAS/SQL, SAS/STAT, and SAS/MACROS for descriptive and inferential statistical analysis and data displays.
• Extensively worked on creating Macro variable and Macro for automated weekly, Monthly report generation and to submit in a batch mode
• Reworked on existing SAS code to make it more optimized using SAS macros and focused on performance enhancement and documentation
• Extensively using SAS data steps and Macros in generating monthly delinquency reports for obligor and obligation account management.
• Generated complex reports in text, HTML, Excel and PDF formats using SAS Output Delivery System (SAS/ODS).
• Used PROC TEMPLATE to customize the reports in spreadsheet with footnotes, titles, and pages numbers along with image logos.
• Performed Data Analysis and implementation of the process while data transition process and frequently changing DB structures.

Environment: SAS v9.2, SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/MACRO, SAS/ACCESS and SAS/CONNECT, Oracle 9i, Windows, HTML.

Confidential - Boston, MA

SAS Analyst

Responsibilities:

• Was involved in developing new or modified SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
• Was involved in extraction of data from Oracle and created datasets.
• Performing data validation, transforming data from RDBMS oracle to SAS datasets.
• Transformations using Base SAS Procedures and Functions.
• Responsible for the cleaning, reformatting, analysis and loading the data into the database.
• Produced RTF, MS WORD and HTML formatted files using SAS/ODS to produce reports for presentation and further analysis.
• Developed SAS Macros for reduction of program length and for faster execution.
• Combined and grouped datasets using concatenation and merging.
• Involved in developing Unix Korn Shell wrappers to run various dependency graphs.
• Creating permanent formatted SAS data sets and developed reports using Proc Report, Proc Tabulate and DATA NULL for analysis.
• Used SAS Proc SQL to extract data from different relational database management (Teradata) systems, used SQL Assistant to analyze and query from the Teradata database.
• Extensively used various Base SAS procedures like Proc SQL, Proc Summary, Proc Format, Proc Print, Proc sort etc. for reporting purposes
• Extensively used the SET, Update and Merge statements for creating, updating and merging various SAS datasets.

Environment: SAS/ Base, SAS/Macros, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, Oracle 9i, PL/SQL, MS Excel and UNIX.

Confidential

SAS Data Analyst

Responsibilities:

• Primary responsibility involved data mining, data preparation for the further analysis and conduct data quality check
• Develop SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Worked with huge datasets to extract customized reports using PROC SQL,, PROC SORT, PROC REPORT, and PROC TABULATE
• Created SAS datasets from Oracle database with random sampling technique and created Oracle tables from SAS datasets by using SAS Macros
• Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset merging techniques of SAS/BASE
• Analyzed data using various statistical procedures like PROC SUMMARY, PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG and PROC ANOVA
• Used SAS/Macro facility to create macros for statistical analysis, reporting results and data extraction
• Performed statistical analysis of financial and operational data using SAS/STAT and other statistical procedures like Proc Means, Proc Freq., Proc Univariate, Proc Summary, Proc Reg., and Proc Anova.
• Generated high quality reports in the form of listing, HTML, RTF, Excel and PDF formats using SAS ODS.

Environment: SAS/Base, SAS/Access, SAS/Macro, SAS/SQL, SAS/Graph, SAS/STAT, SAS/Connect, MS SQL Server, MS-Excel, UNIX and SQL SERVER 2005.