SUMMARY

• Over 7+ years of extensive experience in SAS programming, Data analysis and Management Generating Reports, Tables, Listings and Graphs and Database Design, Development and Implementation and Reporting and Modeling.
• Expertise in SAS/BASE, SAS/MACRO, and SAS/SQL, SAS/GRAPH, SAS/STAT, SAS/ACCESS, and SAS/CONNECT in UNIX and Windows environments.
• Strong working knowledge in SAS and base SAS, SAS/Graph, SAS/Macro, SAS/ODS, SAS/Access, and SAS/SQL under Windows environment.
• Hands on experience in creating extremely interactive reports using SAS Visual Analytics.
• Skilled in working with relational databases (SAS Access to Oracle, MS - SQL Server, Teradata) and their integrations with SAS and R for analytics.
• Extensive use of open source tools such as R and python for statistical data analysis.
• Experience in maintaining a large multi-platform SAS environment it includes SAS Business intelligence tools and SAS application tier.
• Expertise in using various SAS report generating procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE and PROC PRINT
• Worked closely with SAS Experts during SAS 9.4 installation and configuration.
• Proficient with Importing Various External Data Files into SAS Dataset / SAS Library by using SAS/Access, SAS/Infile, SAS/Import, and SAS/SQL.
• Experience in Data Analysis, Data Requirement Analysis, and Data Mapping for ETL process
• Good exposure on SAS Data warehousing (ETL-Extraction, Transformation and Loading) tool- SAS Data Integration Studio.
• Ability to write SQL queries using PROC SQL.
• Experience in utilizing SAS Procedures, Macros, and other SAS applications for data extraction, data cleansing, data loading and reporting. Involved in the data analysis, DB creation, applying database constraints and make ready to load onto database
• Customize the variables to user-defined formats using PROC FORMAT in printing reports.
• Experience in working with SAS ENTERPRISE GUIDE SOFTWARE for reporting and analytical tasks
• Intermediate knowledge of advanced procedures including UNIVARIATE ANALYSIS, REGRESSION, GRAPH AND PLOT
• Perform ad hoc analyses as per user guidelines and reports and transform data into various formats like CSV, EXECL, and ASCII.
• In depth knowledge of Iterative Software Development Life Cycle (SDLC) process, Agile Software Development and Waterfall models.

TECHNICAL SKILLS

SAS Components: SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/GRAPH, SAS/STAT, SAS/SQL, SAS/ODS

Languages: SAS 9.4/9.3, UNIX SCRIPT, SQL

RDBMS: Oracle, DB2, Netezza, Hadoop, Teradata

Office Tools: MS office (Word, Excel and PowerPoint)

OS: Windows NT/XP Prof/2003 Server/2000/98/95, UNIX, (Solaris 9), Linux

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

Senior SAS Programmer

Responsibilities:

• Expertise in DB Design, implementation, testing of Loans, Deposits feeds into Netezza.
• Performed Data analysis, statistical analysis, generated reports, listings and graphs using SAS tools like SAS/GRAPH, SAS/BASE, SAS/SQL, SAS/Connect, SAS/ACCESS.
• Frequent use of SAS function and procedures such as Proc Freq, Proc Means, Proc Sort, Proc Print, Proc Tabulate and Proc Report and created reports in the style format using ODS statements and Proc Template.
• Developed end-to-end reporting based on business requirements.
• Solved complex issues and implemented solutions to enhance productivity, improve quality and customer satisfaction.
• Coding SAS programs with the use of BASE SAS and SAS/MACROS for ad hoc jobs.
• Programmed in SAS for the development of a large reporting System using SAS/ACCESS to accessing DB2 relational tables.
• Creating Jobs Using multiple transformations like Extract, Append and SQL Joins etc.
• Coding SAS programs with the use of Base SAS and SAS/Macros for ad-hoc jobs.
• Developed methods to streamline analysis and present business critical information through a combination of SAS BI dashboards and web-based reporting
• Developed ETL processes extracted data daily from Mainframe DB2 and ORACLE Databases and loaded data into a SAS based Decision Support Warehouse
• I have worked with the data scientist and provided data to build Predictive Logistic Regression, Tree and Neural Network B-to-B Analytic Churn Models with Enterprise Mobility Network Data, Corporate Revenue Data and Corporate Market Research Data.
• Creating Explorations & Reports, as per Business Users requirements by using SAS VA.
• Present All Findings to Client. Model Lift Gains Charts Consistently Exceeded Expectations
• Integrate Millions of Records from Numerous Databases into One Comprehensive Database.
• Used SAS Data Integration Studio to develop various job processes for ETL (Extract, transform and load) data warehouse database.
• Scheduled jobs for SAS User's, installed SAS Server and client components whenever needed.
• Created adhoc reports to users in SASVA by connecting to various data sources.

Environment: Windows 7, UNIX-AIX 5.3/AIX 6.1, Secure CRT 5.0, SAS EG 6.1, SAS 9.4/SAS 9.3, SAS SQL, SAS/Macros, Oracle, DB2, Netezza, SAS Data Integration Studio (ETL tool) 4.902, SAS Visual Analytics.

Confidential, Austin, TX

Senior SAS Programmer

Responsibilities:

• Prepared new Datasets from raw data files using Import techniques and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions and conditional statements.
• Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/Base and SAS/ Macro facility.
• Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS, MS Access and Excel.
• Automating several SAS Reports by using Base SAS, Unix Shell Script, which will drop the reports in designated location at the scheduled date and time without any human effort.
• Maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets by using Set and Merge for generating Reports and Graphs.
• Used SAS and SQL to perform ETL from Oracle database and created SAS datasets, SAS Macros, Proc/data steps and SAS formats as required.
• Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Extracting data from the database using SAS/Access procedures and create SAS data sets.
• Developed SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
• Maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets.
• Performed QC (Quality Check) extensively on tasks performed by other team members.
• Extensively used company standard macros, generating graphs, listings, PDF and RTF files using various Base SAS Procedures.
• Involved in establishing connections to different data sources (SQL Server, Teradata, Azure Cloud, and web site data) and pulling relevant data from these source systems for data modelling.
• Created Data Mart's in SAS and loaded to Oracle.
• Wrote SQL Loader code in SAS using SAS as an interface to load the tables into the Oracle database.
• Developed Financial Monthly and Quarterly summary reports, graphs using SAS procedures like Proc Freq, Proc Graph, Proc Univariate, Proc Summary, and Proc Report etc.
• Used procedures like PROC REPORT, PROC TABULATE, PROC MEANS, PROCFREQ and PROC CONTENTS to generate different reports and run metrics on different data sets.
• Extensively used SAS/ Macro facility to provide reusable programs that can be conveniently used to update reports.
• Participate in statistical program validation and quality control activities.
• Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
• Created documentation, desk levels and process flow documents for all the processes.
• Performed data analysis, statistical analysis, generated dashboards, reports, charts, and graphs using SAS VA.

Environment: s: SAS 9.4/9.3, SAS/BASE, SAS/REPORTS, SQL, SAS/MACROS, EXCEL, SAS/GRAPH, SAS/STAT, SAS/ACCESS, SAS/CONNECT, Oracle, Windows, SAS Visual Analytics.

Confidential, Reston, VA

SAS Programmer

Responsibilities:

• Generated statistical reports. Technologies like Oracle and SAS were used for creating reports.
• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, and Update Formats, Functions and conditional statements.
• Used concepts, practices, and procedures within the BI reporting field.
• Used Web client applications of the SAS Enterprise Business Intelligence Server provide the means to create, share, and personalize SAS BI content while providing a secure framework to aggregate content with custom dashboards and alerting.
• Created reusable Macros and extensively used existing macros in developing SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Created SAS Customized Reports using the Data Null technique.
• Developed routine SAS macros to create tables, graphs and listings.
• Developed SAS macros for data cleaning and reporting and to support routing processing.
• Used Proc REPORT to generate reports. Developed annual reports based on existing data.
• Maintained large data sets, combined data from various sources in varying formats to create SASdata sets and/or ASCII files.
• 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.
• Developed SAS programs using Base SAS for tabulation counts, correlations and check for dispersion for normality using PROC Means, PROC Tabulate and PROC Univariate.
• Created and implemented statistical analysis plans and specification documents, participated in database design, data collection guidelines, and logic checks.

Environment: SAS9.4, SAS/base, SAS/Macro, SAS/SQL, SAS/Graph, SAS/Access, SAS/ODS, MS Office, MS Access, MS-Excel.

Confidential

SAS Programmer

Responsibilities:

• Installation of SQL Server on Development and Production Servers, setting up databases, users, roles and permissions.
• 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
• 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 SUMMARY, PROC SORT, and PROC SQL.
• 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.

Environment: SAS 9.2, (BASE, MACROS, CONNECT, SQL, GRAPH) Oracle, MS Excel, and Windows.