SUMMARY

• Certified Base SAS programmer with 7+ years of experience in SAS/BASE, SAS/GRAPH, SAS/STAT SAS/CONNECT, SAS/ACCESS, SAS/ODS, SAS/SQL, SAS/MACRO, SAS/EG, SAS/SHARE, SAS Management Console.
• Good programming experience with PROC SQL, PROC Report, PROC Tabulate, PROC Datasets, PROC Format, PROC Print, SAS/STAT procedures such as PROC Freq, PROC Means, PROC Univariate.
• Experience in developing SAS codes using SQL queries in SAS for creating stored processes using the dynamic prompts containing both packaging and streaming output, and prepared reports using ODS.
• Well versed in SAS procedures such as Freq, report, tabulate, sort, print, summary and means for producing customized reports and external files.
• Experience in data manipulation procedures such as formats/informats, merge, proc data sets, proc sort, proc transpose and proc rank.
• Good command in importing and exporting complex internal data to and from Microsoft Excel and Microsoft Access using Proc Import and Proc Export.
• Proficient experience in different Databases like Oracle, SQL Server
• Experience with database manipulation (ETL) and SQL programming and reporting.
• Responsible for creating test cases to make sure the data originating from source is making it to target properly in the right format.
• Thorough in doing edit checks, validation of Analysis datasets, Tables & Listings.
• Created new programs using SAS macro variables to improve speed of modification as well as consistency of results.
• Expertise in processing large datasets with millions of records for data including data cleansing, data scrubbing and applying business logic rules to incoming data.
• Automated SAS programs and fine - tuned existing SAS codes using SAS Macro, SQL Pass-thru and generated HTML, PDF, RTFreports, listings Graphs/Charts.
• Experienced in data mapping, data profiling of the data models, validate metadata, improve data quality, creating data marts to be used further in data visualization and report generation.
• Regression Model Development for Exposure at Default (EAD) using SAS/STAT and SAS Enterprise Miner.
• Familiar with CCAR and DFAST reporting and regulatory requirements.
• Excellent written and verbal communication skills.
• Resourceful, able to find solutions when faced with challenges.
• A quick learner and hard worker.
• Ability to work on multiple tasks simultaneously while adequately prioritizing tasks to meet project deadlines.

TECHNICAL SKILLS

SAS Tools: Base SAS, SAS/STAT, SAS Macros, SAS/SQL, SAS ODS, SAS GRAPH, SAS/ACCESS SAS/CONNECT, SAS ENTERPRISE GUIDE, SAS DATA INTEGRATION STUDIO, SAS ENTERPRISE MINER.

Reporting Tools: Base SAS, SAS GRAPH, MS-EXCEL, SAS OLAP Cube Studio, SAS Web Report Studio, MS-VISIO, MS-PowerPoint.

RDBMS: SAS SQL, MS-ACCESS, Microsoft SQL Server, MySQL, Oracle, Teradata and DB2.

Languages: SAS, SQL, Python, C, C++, Java, HTML.

Operating System: Windows 95/98/XP/Vista/Win 7, MAC OS, DOS.

PROFESSIONAL EXPERIENCE

Confidential, MI

SAS Programmer/Analyst

Responsibilities:

• Development and analysis of dataset specifications and SAS based utilities. Data capture design review and input into data standards.
• Has a strong understanding of the regulatory process and detailed understanding of the analysis and reporting process and implications on programming
• Ensure analysis data and programming code meet regulatory and company standards and are consistently structured to permit efficient programming and reporting
• Ability to perform advanced level activities using application based reporting environments (including high complexity dataset creation and study specific macros) as per the intended and most efficient use of the application
• Perform comprehensiveexploratory data analyses to identify/quantify trends, correlations, andinteractions within and across data sets.
• Implementation of Credit Risk Analysis reporting system based on credit Scores and data management principles, mainly including joining data set, indexing, data aggregation, record selection, sub-setting, multiple records per case, creation and modification of views.
• Developing and designing SAS Programs/ Macros to analyze financial data. Statistical analysis files, tables, listings, and graphs.
• Generate SAS reports, creating RTF, HTML listings, tables and reports using SAS ODS for ad-hoc report generation.
• Analyzed and interpreted numerical data from various sources organized and summarized data for analysis.
• Presented numerical information in various formats. Created SAS customized reports using the DATA NULL technique.

Environment: SAS/BASE 9.3, SAS/STAT, BI, SAS/SQL, SAS/GRAPH, SAS/MACRO, SAS/EG, SAS/ODS, SAS/ACCESS and MS Access Database, Mainframe, UNIX.

Confidential, Mt. Laurel, NJ

SAS Analyst

Responsibilities:

• Used SAS and SAS Tools for pre-processing data, data analysis, statistical analysis, and created permanent formatted SAS data sets.
• Performed Data analysis, statistical analysis, generated reports, listings and graphs using SAS Tools SAS/Base, SAS/Macros and SAS/Graph, SAS/SQL, SAS/Connect, SAS/Access.
• Used sorting and merging techniques on the input data sets for Data Preparation, to get the required output and then writing the code using SAS tools.
• Developed routine SAS macros to create tables, graphs and listings for inclusion in reports and maintained existing ones. Prepared data listings and summaries for statistical analysis.
• Developed reports using PROC REPORT, PROC TABULATE and DATA NULL for analysis.
• Designed statistical summary tables, graphs, and patient data listings using base SAS procedures like proc summary, proc Tabulate and SAS/Graph.
• Build reports from the processed data, generated several reports from analyzed data and converted the data into dbf format and sent to the client.
• Extensively used the SAS/ Macro facility to write weekly and monthly reports.
• Used Output Delivery System (ODS) to write reports directing SAS output to RTF and HTML files.

Environment: SAS 9.4, BASE/SAS, SAS Macro, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/SQL, DB2, UNIX.

Confidential, Cincinnati, OH

SAS Programmer/Analyst

Responsibilities:

• Produced statistical reports for various business needs and expertise in data preparation, data cleaning, analysis, and reporting.
• Customizing the existing Macros according to need and requirement, testing and debugging the Macros and creating more complex and reusable Macros.
• Used Enterprise Guide (EG) query builder to run queries against the tables and sub-setting the data.
• Importing all Reports from web report studio, Stored Process, BI Dashboard and Information
• Map to Information Delivery Portal.
• Developed SAS programs to create a customer mailing list for direct mailing and telemarketing.
• Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Performed data analysis, created reports with extensive use of BASE SAS, macro and SAS reports with the halp of default procedures. Generated graphs using SAS Report and SAS/Graph.
• Involved in update and maintenance of data warehouse and generation of various sales and Marketing reports.
• Exported SAS Reports to the Excel Sheet by using ODS to get the output in multi-sheets.
• Developed loss prediction model using Enterprise miner modeling solutions and SAS procedures.
• Created and delivered reports and presentations with key findings and recommendations.
• Provided technical support on SAS programming related to data manipulation and analysis.

Environment: SAS/Base, SAS/CONNECT, SAS Macros, SAS/ACCESS, SAS/GRAPH, SAS Enterprise Guide, SAS/STAT, Oracle, Windows XP, MS Office, HTML

Confidential, NYC, NY

SAS Programmer

Responsibilities:

• Programming and analyzing the design and development of the application.
• Use SQL Pass-Through Facility and SAS/CONNECT to extract data from Oracle database.
• Employ Arrays in SAS Data Steps. Merging Datasets and Manipulating Datasets for efficient programming.
• Drawing flowcharts indicating the input data sets, developing sorting and merging techniques to get the required output and documents the codes.
• Analyze the validated data of claims and customers using data using PROC FREQ, PROC COMP, PROC UNIVARIATE, PROC RANK, and macros in SAS.
• Build models for credit scorecards using credit scoring with SAS Enterprise miner.
• Develop SAS macros for reports generation as per the business requirements.
• Produce Graphical reports showing Trend Analysis for the claim data and subtask the jobs to leverage grid computing environment’s resources.
• Perform demographic analysis of the online customers to analyze their purchasing pattern against their characteristics such as education levels, age groups, family income levels, family size, locations, and other characteristics.
• Use SAS/GRAPH for generating various types of graphs and charts for analyzing the customers’ enrolment on the basis of their demography.

Environment: SAS/BASE (V9.1.3, V8.2), SAS/STAT, SAS, SAS/MACRO, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/ETS, SAS/QC, SAS/Connect, SAS Enterprise Guide, SAS Enterprise Miner, SAS Financial Management(FM), SAS 9.3/EBI, SAS 9.3/DB2, SAS9.3 /DI Studio, SAS 9.3 FORECAST SERVER, Tableau, UNIX, SQL, MS Access, EXCEL, SPSS, Windows 98/2000.

Confidential, Chicago, IL

SAS Developer

Responsibilities:

• Developed and designed SAS programs/macros to analyze financial data and to create files, tables, listings, and graphs. Developed ad-hoc reports as per business requirements and created various reports like summary reports, tabular reports
• Cleaned existing data and converted them into useful SAS Datasets, merged datasets and created reports based on Ad-hoc requirements
• Developed applications for measuring financial performance of newly acquired accounts: Forecast vs. Actual and developed SAS programs for generating reports on key financials, income statements, and balance sheet.
• Used SAS procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE AND PROC REPORT in order to understand and prepare the data
• Performed ETL-Extraction/Transformation/Loading, data migration, sampling, data preparation, graphical presentation, statistical analysis, validation, reporting, and documentation.
• Extracted data from different sources like Oracle and Teradata and text files using SAS/Access, SAS SQL procedures and created SAS datasets.

Environment: SAS/Base SAS Enterprise Guide, SAS Enterprise Miner, SAS/Macro, SAS/STAT, SAS/GRAPH, SAS ETL, SAS/ACCESS, SAS/ODS, Oracle, Teradata, PL/SQL, DB2, MS EXCEL, MS ACCESS, SAS DI Studio, SAS Web Report Studio.

Confidential, Atlanta, Georgia

SAS Developer

Responsibilities:

• Worked as a SAS Business Intelligence (BI) platform to drive the automation of standardized analytics. In loan department, assisted in development of statistical models which halped to determine the loan worthiness of individuals seeking the loans.
• Coordinated with marketing department to finalize the list of individuals to whom the loan can be forwarded so that targeted campaign can be launched.
• Extensive exposure on every step of entire software development life cycle (SDLC) including data collection, query, modifying and analysis, coding statistical models, summarizing the findings, and presenting the results. Command in importing and exporting complex internal data to and from Microsoft Excel and Microsoft Access using PROC IMPORT and PROC EXPORT.
• Generating SAS EG stored processes with static and dynamic prompts for product-specific analyses. Modifying existing codes for improvement in the performance.
• Advanced Querying using SAS Enterprise Guide, calculating computed columns, using filter, manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis, finally generating SAS datasets.
• Pulling the data in SAS using Proc SQL and refreshing the data mart on weekly basis.
• Importing SAS datasets, OLAP Cubes in SAS Information Map Studio. Using instructions on how to access and combine relational Data tables, calculating new data items, created multiple pre-defined filters.
• Building Quick Reports from Web Report Studio using Information maps, create filters, graphs, and customize reports.
• Developed Macro programs to clean, validate and update data to perform data analysis and generate reports.
• Modified existing datasets using Set, Merge, and Sort, formats, functions and conditional statements.
• Created customized reports using proc tabulate, proc report and proc print.
• Debugged, created maintained and documented adhoc reports on demands.
• Used options like DROP, KEEP and RENAME to work with some variables.
• Sorted, filtered and joined tables by using SAS EG.
• Provided database support to modeling and production team.
• Extensively created summary reports using SAS PROCEDURES like PROC FREQ, PROC SUMMARY, PROC REPORT, PROC MEANS, and PROC TABULATE.

Environment: SAS AML 5.1, SAS 9.3, SAS/CONNECT, SAS Macros, SAS/ACCESS, Oracle 11g, MS Office 2013, SAS Enterprise Guide 4.2, SAS Marketing Optimization 5.1, SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio, SAS Information Delivery Portal, SAS OLAP Cube Studio, SAS BI Dashboard, SAS Enterprise BI Server, SAS Management Console 9.2.