PROFESSIONAL SUMMARY:

• Over 6+ years of experience working in various domains as SAS programmer and Business Intelligence applications.
• Followed System Development Life Cycle (SDLC) methodology for the design, development, implementation, and testing of various SAS modules.
• Proficient in using SAS in Windows, Unix and Linux Environments.
• Extensive knowledge in data management by using SAS DATA step statements including SET, MERGE, Formats, Informants and functions.
• Extensively used SAS/MACRO for creating macro variables and macro programs to modify existing SAS program for ease of modification while maintaining consistency of results.
• Using SASEnterprise Guide build advanced querying, calculating computed columns, using filter, sorting, manipulate and prepare data for Reporting, Graphing, Summarization, statistical analysis and finally generates summarization SAS datasets.
• Proficient in working with multiple databases like Oracle Server, MS SQL Server and MS Access.
• Experienced in creating Data Mart using different transformation in Data Integration Studio.
• DI jobs used to extract, transform and load the physical data structures, scheduled jobs and job flows.
• Extensive knowledge is SQL server Analysis services (SSAS).
• Excellent programming skills in SQL and understanding of data definition principles, joining data sets, data manipulation and subsetting using PROC SQL.
• Ability to work efficiently in both independent and team environments, worked with Project Managers, Team Members / Associates, Statisticians, Business Analysts.
• Capable in using SAS to import/export data to external file formats like CSV, Excel and XML files.
• Superior skills in analyzing and coordinating data, generating tables, listings, graphs and reports.
• Conceptual understanding of various business requirements in financial and met needs by having firm grip over various procedures like proc SQL, proc report, proc tabulate, proc plot, proc chart, proc format, proc import, proc export, proc print, proc sort, proc compare, proc append, proc connect.
• Extensive experience in processing large datasets with millions of records for data transformation including data cleaning, data scrubbing, data profiling and applying business logic rules to incoming data.
• Experience in producing HTML, RTF and PDF formatted files using SAS/ODS.
• SAS products installation and support of Base SAS, SAS Enterprise Guide, SAS Enterprise Miner, add in Microsoft office, Text Miner, SAS Data Integration Studio, SAS Information map studio, SAS Management Console, SAS Visual Analytics, SAS Web Report Studio, Office Analytics, SAS Forecast Studio, SAS OLAP Cube studio as well as other SAS tools may be evaluated.
• Strong experience in SAS/Base, SAS/Graph, SAS/Stat, SAS/Connect, SAS/Access, SAS/ODS, SAS/SQL, SAS/Macros, SAS/Enterprise Guide, SAS/Enterprise Miner, SAS/Share, SAS Enterprise BI Server and SAS Management Console.
• Identifying potential issues, working with vendors and provide research and solution recommendations proactively.
• Imported summarization SAS datasets from SASManagement Console to SAS Information Map Studio.
• Have strong working knowledge on SAS Data integration studio in extracting data.
• Generated various graphs using SAS/GRAPH procedures like PROC GPLOT and PROC GCHART.
• Thorough Knowledge and experience of Microsoft Office tools like MS Access, MS word, MS PowerPoint and MS Excel.

TECHNICAL SKILLS:

SAS Tools: Base SAS 9.4/9.3/9.2/9, SAS/Stat, SAS Macros, SAS/SQL, SAS/ETL, SAS Graph, SAS Enterprise Guide, SAS/DI, SAS/EM, SAS/TM, SAS/SMC, SAS/FS, SAS/WRS, SAS/OLAP, SAS/AMO

Reporting Tools: Base SAS versions 9.3/9.2/9, SAS Enterprise Guide, SAS Enterprise Miner, SAS Graph, MS - Excel, SAS BI Platform, SAS OLAP Cube Studio, SAS Web Report Studio, MS-VISIO, and MS PowerPoint

RDBMS: SAS SQL, DB2, Oracle 7x/8i/9i/10g/11g, Teradata, MS-Access, Microsoft SQL Server, Netezza, Green Plum, SAP Hana and MySQL.

Languages: SAS, SQL, C, C++, C#, Java, Visual Basic, Visual C++, PHP

Operating System: Windows 95/98/XP/Vista/Win 7/Win 8/Win 10, UNIX, MAC OS, Linux and VMS

Batch Server: UNIX, Putty, SSH, and SAS scripting

Web Server: HTML, JSP, Linux, Apache Server

Office Tools: Word, Excel, PowerPoint, MS ACCESS, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, NY

SAS Developer

Responsibilities:

• Analyzed present data warehouse tables data volume, memory space, relationship, columns functionality, and metadata of DW.
• Extracted of data from fact and dimension tables and created SAS repository.
• Installation and implementation of SAS components to fulfill project report requirements.
• Involved in coding and pulling data from various oracle tables using Unions and Joins.
• Created and maintained of automatic scheduled jobs using automatic macro variables.
• Involved in extracting data from the mainframe to UNIX via SAS EG.
• Completed SAS coding using various date and time to perform daily, weekly, monthly and quarterly jobs.
• Used data cleaning techniques such as proc freq, proc print, null, proc means, proc tabulate, proc univariate, no dupkey, proc sql, proc compare and created macro to check data.
• Extensive used of SQL PLUS to DML and data extraction job.
• Developed ETL process and SAS independent repository as source of data transaction.

Environment: Base SAS 9.1, Unix SAS, Enterprise Guide SAS, SAS/Access, SAS/Connect, SAS/Stat, SAS/SQL, SAS/ODS, SAS/Macros, SAS/AF, SAS WRS, EG, SAS/ETL, SAS/MDDB, UNIX SAS, PC SAS, Oracle 9i, RDBMS, OLAP, MS Excel, and MS Access.

Confidential, NY

SAS Developer

Responsibilities:

• Extracted raw data and created SAS data sets that are required for the project analysis.
• Involved in development and enhancements of SAS Programs.
• Analyzed data using SAS/Stat procedures.
• Used ImportandExportfacilities in SAS to exchange data between SAS and Microsoft Office environments (Excel, Access).
• Created reports using SAS/ODS.
• Provided all data analysis, ad-hoc and custom reporting of customer data, involving extracting data from anOracle database, xml files, csv files dataused as input for SAS programs to create Excel, spreadsheets, Access databases, and hard copy reports.
• CreatedMacrosand developed SAS programs forData cleaning, Validation, AnalysisandReportgeneration using newly created as well as existing macros.
• Creating various transformation procedures by using SAS 9.1, SAS Cube Studio, SAS Data Integration Studio, and SAS Enterprise guide.
• Integrated all SAS components, SAS graphs and programs onto one web application software for end users by using SAS IntraNet, SAS information map studio and SAS Information Delivery Portal.
• Created OLAP Views, Maps and OLAP cubes for different modules.
• Developing Reports and Customizing Portal using SAS OLAP Cube Studio, SAS Information Map Studio, SAS Enterprise Guide, SAS Web Report Studio and SAS Information Portal.

Environment: SAS/BASE, SAS EBI/DI Studio, SAS Web Report Studio, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/CONNECT, SAS/GRAPH, SAS/ODS, Windows, MS Office.

Confidential, New York, NY

SAS Programmer

Responsibilities:

• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools- SAS/Base, SAS/Macros, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access.
• Responsible for locating appropriate databases for projects and performing relevant analysis.
• Processed data collection to ensure proper quality of data.
• Maintained the daily error log for cleaning the data.
• Developed SAS macros for data cleaning, reporting and to support routing processing.
• 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.
• Generated graphs using SAS/GRAPH and the SAS Graphics Editor. Used Proc Report to generate reports.
• Prolifically generated SQL queries for the reports.
• Successfully identified problems with the data, produced derived data sets, tables, listings and figures, which analyzed the data to facilitate correction.

Environment: SAS 9.3, SAS/SQL, SAS/BASE, SAS/MACROS, SAS/GRAPH, UNIX, Windows.

Confidential

SAS Programmer

Responsibilities:

• Responsible for identifying, collecting, analyzing and maintaining data to evaluate issues that support business decisions using SQL and SAS.
• Analyzed data sets and generated SASoutput using PROC FREQ, PROC COMPARE, PROC CONTENTS, PROCSORT, PROC SQL and PROC REPORT etc.
• Creating and saving the Macro programming into Macro library and maintaining Macro library to be used by all user in the team.
• Cleaning data files to accommodate missing data, creating variables, use of aggregating commands and various techniques of file merges to create results.
• Performing analysis on survey responses and producing multi-dimensional reports using SAS.
• Work with other departments to design new features and programs in order to effectively mitigate risks Identify AMLcurrent and potential risk.
• Documenting an adverse event, including, describing the event, severity and frequency, treatmentand resolution.
• Work with Enterprise Miner for marketing campaigns doing statistical analysis.
• Using SAS/SQL for extract, transfer and load (ETL) methodology for the data used to deliver the programs direct mail and email contacts.
• Data processing and validations were done extensively on the SAS datasets using edit check programs.
• Quality control and assurance including running datasets/files through programs.

Environment: BASE SAS, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/CONNECT, SAS/ACCESS, SAS/AML, SAS/ENTERPRISE MINER, WINDOWS and Linux.