PROFESSIONAL SUMMARY:

• Over 7 years of professional experience working as SAS Administrator/Programmer in Analysis, Design, Development and Validation of applications for Health and Financial departments of large enterprises.
• Experience with Base SAS, SAS Metadata Server, SAS Object Spawner, and SAS Management console 9.1.3, 9.2, 9.3, and 9.4, SAS Enterprise Guide 4.1, 5.1, 6.1, SAS OLAP Cube Studio 4.4, SAS Information Map studio 4.4, SAS Performance Data Server and SAS Web Portals. 
• Installation and configuration of SAS servers and client applications in Grid environment. 
• Migration of users, data and corresponding Metadata from SAS 9.4 stand alone to 9.4 multi - tier Grid. 
• Experience in working with SAS on different platforms like UNIX (LINUX, AIX, HP/UX, SOLARIS) and WINDOWS 9x/2K/NT/XP.
• Experienced with configuring Queues/Policies in SAS GRID environment, usage tracking, RTM monitoring, alerts notification and load balancing.
• Extensive Knowledge in Server/Client Side Installation of SAS 9.2, SAS 9.3 and SAS 9.4. 
• Experience in configuring database connectivity through SAS/Access Interface to ODBC for the databases like Netezza, Oracle, Teradata, Hadoop, Greenplum and SAS In-Database Technologies for Hadoop.
• Experienced in various SAS administration activities like monitoring different servers, administer logging, setting up and securing metadata folder.
• Experienced in validation of Tables, Listings, Graphs and Analysis Datasets using Proc compare and departmental standard macros.
• Extensive hands on experience on SAS Connect, SAS Metadata Server, SAS OLAP Server, SAS Object Spawner, SAS Management Console, Enterprise Guide, OLAP Studio, Data Integration Studio, Web Report Studio, OLAP Viewer, and SAS Share/Connect Server.
• Expertise in using PROC PRINT, PROC SUMMARY, PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC TRANSPOSE, PROC SQL, PROC REPORT, PROC ACCESS, PROC GPLOT, PROC GCHART, PROC FORMAT, PROC TABULATE, DATA MERGE, SORT to generate Ad-hoc and customized reports.
• Experienced in SAS Migration Utility and SAS promotion process by Export-import wizard.
• Proficient in debugging, storing and managing SAS data files, merging SAS data sets, SAS Formats, and SAS Informats.
• Advanced configuration experience with Apache Web Server, Tomcat, JBoss, BEA WebLogic Server, WebSphere and SAS Intelligence platform mid-tier Web applications.
• Acquired financial raw data from Oracle and DB2 tables and loaded the data into SAS datasets. Used Macro routines to convert different types of source file (Excel, Word, and Text) to produce SAS reports and graphs. 
• Thorough hands-on experience in using SAS /ODS to generate different files including XML, RTF, MS Excel, PDF and HTML. 
• Experience on working with E-Miner for Data Mining.
• Provide statistical programming expertise in the production of datasets, analyses, tabulations, graphics, and listings from client's data.
• Experience in programming for generating graphs, data listings and tables using data steps, procedural SQL and SAS macros.
• Modification of existing SAS programs and creation of new programs using SAS Macros to improve ease and speed of modification as well as consistency of results. 

TECHNICAL SKILLS:

SAS Tools: SAS V9.1, 9.2, 9.3 & 9.4 Base SAS, SAS/SQL, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/ODS, ETL, SAS BI Server and SAS Data Integration Platform 4.6 & 4.7, SAS Forecast Studio, SAS Enterprise Guide, SPSS, SAS EB.

Databases: Oracle, DB2, MS SQL Server, and MS Access, Teradata, Netezza

Operating Systems: UNIX (VI EDITOR), MS-Windows XP/2003/2000, and MVS Mainframe

Database Tools: TOAD 9.7.2, PL/SQL Developer 7.1.5

Programming Languages: SQL, UNIX, K-Shell and Perl scripting

WORK EXPERIENCE:

Confidential, Detroit, MI

SAS GRID ADMINISTRATOR / Programmer

Responsibilities:

• Performing SAS product installations with  SAS Deployment Wizard on user’s machines and assisting users in connecting to the  SAS GRID servers from the required  SAS product for their activities.
• Install and deploy additional Application Server Contexts (SASApp) in SAS Grid. 
• Verifying the grid  configuration files (lsf.conf., lsf hosts etc.) 
• Working with users to migrate the processes currently running on 9.3 to 9.4 Grid Platform. 
• Configured SAS Grid High Availability with EGO for PM and GMS using Platform RTM.
• Maintaining SAS   Server health, Installation of hot fixes, configure server tier, migrate and maintaining the metadata in LINUX environment.
• Involved in SAS Grid   Upgrade from Single node to Multi Node with Hadoop Integration. Working Closely with  SAS and IT on gathering requirements to prepare Road Map and Pre-installation document.
• Improved the SAS code by using SAS GRID computing which can be executed on Parallel and Sequential Process.
• Updating the stored process as per the SAS code modification so that the output statistics were pushed back to the Oracle Database.
• 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.
• Maintain  SAS metadata for users, libraries, servers etc.
• Worked on SAS EBI including information map studio, web report studio, and information delivery portal.
• Extensively involved in accessing, managing data, creating reports and to validate data using SAS Enterprise Guide 6.1.
• Performing statistical analysis, generated reports, listings and graphs using SAS/Base, SAS/Macro and SAS/Graph, SAS/SQL, SAS/Report.
• Extracted data from Oracle data base by using SQL Pass through facility.
• Created data marts, OLAP Cubes and reports for Business intelligence reporting in   SAS using   SAS DI Studio and Enterprise Miner .
• Collaborated with circulation, loyalty and email marketing teams to undertake customer analytical or testing projects.
• Design job flows using   SAS DI to extract data from source systems, perform required transformations and load back to target.

Environment: Base SAS, SAS/Macros, SAS/SQL, SAS/Graphs, SAS/Stat, SAS/Reports, SAS/Connect, Windows XP professional, Oracle, SAS BI, SAS Web Report studio, SAS OLAP cube studio, SAS ODS, Shell scripting.

Confidential, Boston, MA

SAS Administrator/ Programmer

Responsibilities:

• Created the Metadata Server definitions and libraries connecting to external databases like Teradata by using SAS Management Console.
• Scheduling the jobs and monitoring for day to day activities, escalating to technical if for any issues arises.
• Responsible for monitoring system resources like CPU usage , memory usage , runtime of jobs by using RTM.
• Monitoring the submitted SAS jobs through the SAS Platform RTM and grid manager plug in in SAS Management Console.
• Updating the file systems and SAS data libraries when there are changes in the Database.
• Installed and configured SAS High-Performance Analytics cluster (Root Node and Worker Nodes).
• Worked as a Portal Admin for publishing the Reports to different business groups.
• Hands on experience in creating user teams , server teams and UNIX access rights. Worked as secondary approver of user teams on  SAS Grid and maintained various distribution list of users.
• Created SAS Information Maps and Stored processes for developing the mock up reports and dashboards to the end users.
• Created SAS OLAP cubes, SAS information Maps & SAS Stored Processes.
• Developed the Web Reports and designed the user interface through SAS IDP.
• Involved in Development, Testing & Support of ETL jobs using SAS DI  Studio.  
• Used SAS Data integration studio for registering the tables and creating the libraries pointing to Teradata database.
• Hands on experience in  SAS Enterprise Business Server Administration with a strong background in UNIX Systems Administration with on-call production support.

Environment: SAS Management Console, SAS/Reports, SAS/Connect, Windows XP professional, Teradata SQL/Assistant, SAS BI, SAS Web Report studio, SAS OLAP cube studio, SAS ODS, Shell scripting.

Confidential, San Jose, CA

SAS Developer/ Analyst

Responsibilities:

• Designed and creating SAS datasets from various sources like Excel datasheets, flat files, creating reports and files from existing SAS datasets.
• Generated SAS datasets, tables, listings, graphs and reports from analysis datasets using SAS tools like BASE, Macros, GRAPH and STAT.
• Used IMPORT and EXPORT procedures for importing and exporting the data to MS/EXCEL files.
• Responsible for providing the consulting team with data preparation, data analysis and statistical modeling using SAS as a primary tool.
• Supported Users on various EBI Clients such as BASE SAS, SAS Enterprise Guide, OLAP Cubes and SAS Portal.
• Installed & Configured SAS   Access to Netezza DB on all the SDLC Environments.
• Experience in creating OLAP cubes for reporting of pre-summarized large datasets and decision.
• Modified and developed  SAS Programs,  SAS Macros for analyzing financial data. Statistical analysis of files, tables, listings, and graphs. 
• Evaluated various tables using data manipulation techniques like Merging, Appending and Sorting. Performed Data Cleansing by analyzing and eliminating duplicate and inaccurate data using PROC SORT, PROC FREQ, PROC COMPARE, PROC UNIVARIATE, and  SAS /MACROS. 
• Created reports and stored procedures using SAS BI tool.
• Created and extracted Oracle tables from SAS and within Oracle by using PL/SQL using SAS /ACCESS and SAS /CONNECT.
• Maintained the daily error log for cleaning the data.
• Creating Pivot tables in Excel for open ended answers.
• Data preparation, cleaning, manipulation, and visualization. Extract data from relational databases and perform complex data manipulations. Conduct extensive data checks to ensure data quality.

Environment: Base SAS, SAS /ACCESS, SAS /CONNECT, SAS /STAT, SAS /GRAPH, SAS /SQL, SAS /ODS, UNIX, Mainframes, SAS Enterprise Guide, SAS BI.

Confidential

SAS Developer

Responsibilities:

• Developed and maintained documentation of the system configuration, procedures, and apply hot fixes and maintenance releases to SAS 9.1.3 & 9.2, as well as SPD & client SAS products. 
• Designed and developed routines using SAS EG/Base SAS to support ad hoc reports including automation in the SAS Web Report Studio. 
• Designed, created and reviewed primary objects such as views, indexes based on logical design models, user requirements and physical constraints.
• Configuring SAS/ACCESS interface to Oracle Databases. 
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Created partition table for very large database for good performance
• Programmed to output RTF reports using  SAS /ODS (output delivery system). 
• Program in  SAS for analyzing data and producing safety and efficacy tables, listings and figures.
• Reading data from Excel, Oracle and Raw data from Text Files and converting them to  SAS datasets and or writing to Flat Files, Oracle Tables and Excel files and generating Reports RTF and HTML formats using Data Null,  SAS /ODS, PROC REPORT. 

Environments: SQL Server 2005/2008 Enterprise Edition, MS SQL Profiler, SQL Query Analyzer, UNIX.

Confidential

SQL Developer

Responsibilities:

• Modified the database object and structures as suggested by developers in both production and development environment.
• Supported Business users for installations & training of new version of SAS 9.2 
• Created database objects such as Stored Procedure, Functions, Tables and Views for the -optimization of Database and to reduce the traffic of database.
• Program standard  SAS macros for validation of data listings and tables which can be used across different studies and protocols.
• Performed Data Cleaning, Sorting, Merging, Data Analysis and Summarization using SQL, SAS (Interactive) on UNIX and PC  SAS .
• Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints.
• Performed daily tasks including backup and restore from disaster recovery by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler. 

Environments: SQL Server 2005/2008 Enterprise Edition, MS SQL Profiler, SQL Query Analyzer, Visual Studio 2008.