SUMMARY:

• SAS Developer with 7 years of experience in programming/analysis experience in SAS on Windows and Unix environment.
• Very good in creating, maintaining existing codes, ad hoc reporting SAS Program.
• Expertise in generating reports employing various SAS procedures like PROC PRINT, PROC REPORT, PROC PLOT, PROC CHART, PROC SUMMARY, PROC FREQ, PROC TABULATE, and PROC MEANS, PROC UNIVARIATE, PROC FORMAT, PROC TRANSPOSE and Data null .
• Generated reports using PROC REPORT, PROC TABULATE and PROC PRINT for customized report writing.
• Experience in using SAS to read, write, import and export to another data file formats, including delimited files, Microsoft Excel, PDF and MS Access tables.
• Expertise in processing large datasets with millions of records for data transformation and data modeling including data cleansing, data scrubbing, data profiling and applying business logic rules to incoming data
• Thorough experience in extracting data from various disparate data sources like (XLS, CSV, TXT) files, Oracle, SQL Server, MS - Access, etc. Ability to analyze & process data using various SAS procedures such as utility procedures, report procedures, statistical procedures.
• Strong experience in SAS Enterprise guide in creating stored processes using the dynamic prompts containing both packaging or streaming output, and prepared reports using ODS.
• Expertise with PROC SQL, SAS arrays and SAS Macros.
• Experience in data transfer between servers and third party vendors using FTPs and SFTPs through SAS program.
• Excellent programming skills in extracting and loading the data into various RDMS like Teradata, Oracle, SQL Server, DB2 with specific bulk load techniques.
• Hands on experience and thorough understanding of Job Scheduler CRON and CA7.
• Very good at using MS Excel to create a Pivot Table, Vlookup and other conditional formatting in a report.
• Intermediate level of expertise in using Excel VBA and Macros.
• Experience with analysis, design, development, testing and deployment of enhancement and new work requests as per Software Development Life Cycle (SDLC)
• Able to work independently as well as good team player and interact with all levels of management.
• Possess good communication skills, self-motivated, proactive, task oriented and quickly adapt to new technologies/ processes/ methodologies.

TECHNICAL SKILLS:

Operating Systems: Windows 7, Vista, Unix.

Software: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS /ODS, SAS/Access, SAS Enterprise GuideProgramming Languages: SAS, SQL and Basic Unix Scripting

RDBMS: Teradata, DB2, Oracle, MS Access, SQL server

Application Software: MS Office (Word, Excel, Power Point, Access), JIRA, Agile, Waterfall, SQL Assistant, Toad Data Point, SFTP, FTP, CRON, CA7

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

SAS Technical Lead

Responsibilities:

• As a member of wholesale Bio department, I am responsible for gathering information, writing codes to generate various reports (almost 110 reports).
• Also, we have three offshore colleagues who worked with me and helped them understand the requirement thoroughly so they can be on the same page.
• Most of the SAS reports used the data from DB2 while some of them are from the SQL server. So, data extraction, manipulation and finally getting the reports done using SAS EG.
• Unit testing the SAS ETL jobs by using SAS Enterprise guide.
• Most of the reports are in Excel and used ODS EXCEL to perform the job.
• Created some ad hoc jobs for the Mortgage and Consumer lending departments.
• Created well-structured documentation of our work for future reference in case if any issues arrived later.

Environment: SAS/BASE, SAS EG 7.1,SAS 9.4, SAS/MACROS, SAS/ACCESS, PDOA SAS Add- in for Microsoft Office, MS Office 2010, VBA Excel and Macros.

Confidential, East Providence, RI

SAS Analyst

• As a member of Auto Securitization Project, I am responsible for writing SAS Codes to generate various reports (Daily and Monthly Summary Report, Fair Market Value Adjustment sheet, Maturity and Delinquency Reporting, Corbydlq and TDR Reporting).
• Preparing and obtaining the approval of system and programming documentation.
• Analyzing existing programs and formulating logic for new systems, devising logic procedures, preparing flowcharting, performing coding and testing or debugs of programs.
• Using SAS 9.4 as the tool for data extraction, manipulating and storage.
• Evaluating and reviewing codes to identify opportunities for consolidation or improvement.
• Schedule and deploy jobs, used custom transformations for data validations.
• Produced Daily, Monthly and Quarterly reports during the UAT cycle and later on used the codes in production for creating those reports.
• Used Monarch Pro 10 for converting text documents and PDF files into usable data tables.
• Download CMOD Reports and further using MS ACCESS 2007 and 2010 to produce pledging reports for financial reporting team.

Environment: SAS/BASE, SAS EG 6.1,SAS 9.4, SAS/MACROS, SAS/ACCESS, SAS Add- in for Microsoft Office, MS Office 2010, VBA Excel and Macros.

Confidential, Dallas, TX

SAS Programmer/Analyst

Responsibilities:

• Analyzed various database containing sales, titles, account, region etc data of the releases of various titles.
• Used SAS Macros and procedures like Proc SQL, Proc Transpose, Proc Univariate, Proc Means, Proc Freq.
• Developed SAS macros for Data cleaning, Data mining and Reporting and to support routing processing.
• Formatted HTML, PDF, CSV and RTF reports, using SAS - output delivery system ODS.
• Extraction of data from Data Ware housing tables and Data marts.
• Modifying data using SAS/BASE and Macros.
• Gathered the requirement business team and analyzed the data.
• 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.
• Creating Customized reports in Enterprise Guide for the users. Trained end users on simple ad hoc report creation.
• Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
• Prepare ad hoc reports, as needed.
• Extracting data from the database using SAS SQL procedures and create SAS data sets.
• Coding SAS programs with the use of BASE SAS and SAS/MACROS for ad hoc jobs.

Environment: SAS/BASE, SAS Macro, SAS/SQL, SAS Enterprise Guide 4.3, Oracle, DB2, SAS ACCESS, SAS ODS, MS office Suites .

Confidential, Dallas, TX

SAS Developer

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.
• Performed data extraction from MS-Excel tables into SAS data sets.
• Analyzed data through problem solving. Performed data archival, Ad-hoc reporting, and coding utilizing SAS on WINDOWS and SAS/UNIX.
• Converted ORACLE data tables into SAS data files using SAS SQL Pass through Facility, and uploaded SAS data files into ORACLE tables using SAS DBLOAD procedure.
• Build reports from the processed data, generated several reports from analyzed data and converted the data into dbf format and sent to the client. Also the reports were sent to web, creating Universes using web intelligence.
• Used Output Delivery System (ODS) facility to write custom safety and efficacy reports directing SAS output to RTF and HTML files.
• Extensively used the SAS/ Macro facility to write weekly and monthly reports.

Environment: SAS/BASE, SAS EG 6.1, SAS/ Macros, SAS SQL, SAS CONNECT,UNIX, SAS Add- in for Microsoft Office.

Confidential, San Francisco, CA

SAS / DATA Analyst

Responsibilities:

• Created, modified/Updates SAS code to in corporate changes in new releases of the product.
• Produced ad hoc reports in SAS using .txt files upon request for in-depth analysis.
• Data manipulation by merging, appending and sorting datasets.
• Extensive use of PROC SQL to create subsets of data for further analysis.
• Extensive use of DATA STEP, PROC MEANS, PROC SQL, MACROS, PROC FREQ, PROC TABULATE, DATA NULL, PROC MEANS, PROC SUMMARY, RETAIN.
• Used SAS - output delivery system ODS to format reports in HTML, PDF, CSV and RTF reports.
• Optimized SAS code to reduce run time and make the process more efficient.
• Generated output files in various formats like text, MS Excel.
• Analyzed demographic data to identify outliers.
• Participated in code reviews.
• Developed SAS code using Macros to run recurring jobs and optimized code.
• Troubleshoot process failures and implemented process improvements.
• Designed and executed data quality and system tests.

Environment: SAS/BASE, SAS Macro, SAS/SQL, Teradata, SQL Assistant, SAS Enterprise Guide 4.3, SAS Management Console 9.1, SAS ACCESS, SAS ODS, UNIX, MS Office Products