SUMMARY

• Over 6+ years of experience in administration, developing programs, statistical analysis and reporting in clinical and research, IT and healthcare environments using SAS Software.
• Experience and noledge in using Base SAS, SAS Enterprise Guide, SAS Enterprise Miner, SAS stored process, SAS/MACROS, SAS/SQL SAS/ODS, SAS/GRAPH, SAS/STAT, SAS/ORACLE, SAS/CONNECT, SAS/ACCESS and SAS/SHARE. Deep noledge in Data Warehousing concepts.
• Experience in administering SAS Grid environment using SMC and SAS LSF.
• Worked closely wif SAS Experts during SAS 9.4 installation and configuration.
• Has Fine grip on PAM and LDAP servers.
• Excellent noledge inHadoopArchitecture and its major components likeHadoopMap Reduce, HDFS Frame work, HIVE, PIG, HBase, Zookeeper, Sqoop, Oozie, Flume and Avro.
• Good understanding of the SAS Web tier and SAS Server Tier Architecture in GRID environment wif excellent troubleshooting skills. Has Health Care Domain Knowledge.
• Hands on experience in performing client installations of various SAS products like SAS Enterprise Guide, SAS Enterprise Miner, SAS Add - in and SAS Model Manager on users machines.
• Experience in setting up connections to different Databases like oracle, SQL, DB2, HADOOP and NETEZZA according to users requirement. SPDS implementation Retail eCommerce experience.
• SAS EG 6.1 (Enterprise Guide) wif Knowledge of BOA and Architecting SAS environments.
• Created Software Development Life Cycle (SDLC) document and excelled in the process of Change Management, Release management and Configuration processes.
• Strong noledge on LINUX and SHELL SCRIPTING, Worked as BASE SAS programmer.
• Hands on experience using BI tools like SAS Data Integration Studio and SAS Marketing Operations Management. strong noledge on SAS HPA architecture.
• Experience in managingHadoopclusters using Cloudera Manager Tool.
• Strong noledge of the operating systems that SAS is installed on like its memory management, file system Architecture, CPU utilization etc. Hands on Ad-hoc hands on Data Ware Housing.
• Strong experience and noledge in using clinical trial data like Demographic data, adverse event data, serious adverse event data, laboratory data and vital signs.
• Generated various graphs using SAS/GRAPH procedures like PROC GPLOT and PROC GCHART.
• Conceptual understanding of various business requirements in healthcare and 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, etc.
• Possesses critical thinking, problem solving and decision making skills to dismantle complex problems and optimize solutions. Experience integratingSAS solutions wif security including PAM and LDAP/Active Directory.
• Knowledge of EG console management. Knowledge of different modules in HADOOP.

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

PROFESSIONAL EXPERIENCE

Confidential, IL

SAS ADMINISTRATOR/PROGRAMMER

Responsibilities:

• Performing SAS product installations wifSAS Deployment Wizard on user’s machines and assisting users in connecting to theSAS GRID servers from the requiredSASproduct for their activities.
• Install and deploy additional ApplicationServerContexts (SASApp) inSASGrid.Performing SAS product installations wif SAS Deployment Manager on users machines and assisting users in connecting to the SAS Grid servers from the required SAS product for their activities.
• Performed depot subset for client side tools using SAS 9.4 Depot Sub setting Utility.
• Creating and removing the User IDs, user groups, and roles on the SAS Metadata and giving the library access by using SAS Management Console. Deep noledge on SAS LSF platform. Established DB connections like Oracle, SQL server and Netezza connections from the grid.
• Responsible for making the web based SAS services likeEnterprise Miner Web based and SAS Stored Process Web Application connectivity and ensuring it TEMPhas no performance impact on the SAS Metadata Server.
• Working wif users to migrate the processes currently running on 9.3 to 9.4GridPlatform.
• Configured SAS Grid High Availability wif EGO for PM and GMS using Platform RTM.
• Maintaining SASServer health, Installation of hot fixes, configure server tier, migrate and maintaining the metadata in LINUX environment.
• Involved in SAS GridUpgrade from Single node to Multi Node wif Hadoop Integration. Working Closely wifSAS 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.
• MaintainSASmetadata for users, libraries, servers etc.
• Worked on SASEBIincluding 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 inSAS usingSASDIStudio and EnterpriseMiner.
• Collaborated wif circulation, loyalty and email marketing teams to undertake customer analytical or testing projects.
• Design job flows usingSAS 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, NJ

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. Attending sessions along wif users organized by SAS Experts about various SAS Products and clearing up the user’s queries regarding SAS Grid. Troubleshooting SAS server issues such as system access and password problems, file system filled issues, enterprise guide or miner throwing errors to users, changing IP address of virtual machines etc.
• Experience in providing access to users to SAS and various SAS products for daily activities. Also provided access to the team and different work groups when needed and provided access to the agents for various roles and sub roles for performing their activity in marketing operations management.
• Perform stop, start and status check of services asp.net and user feed services after installations.
• Strong understanding about how SAS interacts wif third party software such as databases (DB2, SQL SERVER, ORACLE), web application servers, etc. strong noledge on SAS HPA architecture.
• 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 userteams, server teams and UNIX access rights. Worked as secondaryapprover of user teams onSAS 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.
• Designed the metadata, workflow, models in Excel wif great transparency and used SAS macros to process the excel file and generate ETL, model scoring and cash flow analysis SAS code.
• 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 DIStudio.
• Used SAS Data integration studio for registering the tables and creating the libraries pointing to Teradata database.
• Hands on experience inSAS EnterpriseBusinessServerAdministration wif a strong background in UNIXSystems Administration wif 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, NJ

SAS DEVELOPER/ADMINISTRATOR

Responsibilities:

• Designed and creating SAS datasets from various sources like Exceldatasheets, flat files, creating reports and files from existing SAS datasets.
• GeneratedSAS datasets, tables, listings, graphs and reports from analysis datasets usingSAS tools like BASE, Macros, GRAPH and STAT. Configure SAS App Server context, grid-launched, load-balanced workspace server and stored process server, etc
• Establishing data source connectivity to Oracle Exadata and Greenplum usingSAS Access. Building connectivity to MS Sql Server using ODBC driver manager.
• Designed complete End to End business reports from the point of gathering the requirements and understating the logical data model to end user reports.
• 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.
• Used IMPORT and EXPORT procedures for importing and exporting the data to MS/EXCEL files.
• Installed & Configured SASAccess to Netezza DB on all the SDLC Environments.
• Modified and developedSAS 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, andSAS/MACROS.
• Created and extracted Oracle tables fromSAS and wifin Oracle by using PL/SQL using SAS /ACCESS andSAS /CONNECT.
• 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: BaseSAS,SAS /ACCESS,SAS /CONNECT,SAS /STAT,SAS /GRAPH,SAS /SQL, SAS /ODS, UNIX, Mainframes,SAS Enterprise Guide,SASBI.

Confidential

SAS ADMINISTRATOR/DEVELOPER

Responsibilities:

• Developed and maintained documentation of the system configuration, procedures, and apply hot fixes and maintenance releases toSAS9.1.3 & 9.2, as well as SPD &clientSASproducts.
• Designed and developed routines usingSASEG/BaseSASto support ad hoc reports including automation in theSASWebReportStudio.
• Responsible for optimizing all indexes,SQLqueries, storedprocedures to improve the quality of software. Created the Metadata Server definitions and libraries connecting to external databases like Teradata by using SAS Management Console.
• Debugging and troubleshooting the bugs and errors while deploying in to SIT, UAT & PROD Environments.
• Used SAS Data integration studio for registering the tables and creating the libraries pointing to Teradata database.
• Deploying the Code and other code related objects from one environment to another environment.
• Generated database monitoring and data validation reports inSQLServer Reporting Service (SSRS).
• Developed new/modified macros for report generation using SAS/Macros as per business requirements.
• Program inSAS 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 toSASdatasets 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.
• Extensive experience working wif the differentSASServer Log files such as Metadata, Workspace Server, and Object Spawner logs & use them to find out any issues.
• Responsible for creating and delivering recurring as well as ad hoc marketing campaign programming wifin strict timelines while under constantly changing requirements using SAS, PROC SQL, and Teradata SQL in a UNIX environment wif Oracle, Informix, and Teradata relational databases.

Environment: s:SQLServer 2005/2008 Enterprise Edition, MSSQLProfiler,SQLQuery Analyzer, UNIX.

Confidential

SAS DEVELOPER.

Responsibilities:

• Designing, implementing, and executing the change control and promotions tasks in SAS.
• Establishing best practices and guidelines for SAS BI usage.
• Provide guidance and assistance to SAS Developers on operational and technical issues; interfacing wif the SAS Institute for Support on administrative and system issues.
• Creating and implementing upgrade plans.
• Occasional after hour support when system OS and hardware maintenance and applying SAS hot fixes and upgrades occur.
• Strong noledge of the operating systems that SAS is installed on, such as memory management, file system.
• Architecture, CPU utilization etc.
• Developed reports as per business requirements and created various reports like summary reports, tabular reports, excel reports etc.
• Conceptual understanding of SAS Customer Intelligence Studio, SAS Information Map Studio.
• Performed Data Validation and Data Cleaning using procedures like Proc Freq, Proc Means, and Proc Univariate.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools- SAS EG, SAS/Base, SAS/Macros, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access.
• Modifying, Debugging and Creating SAS Macro programs.
• Prolifically generated SQL queries for the reports.
• Successfully identified problems wif the data, produced derived data sets, tables, listings and figures, which analyzed the data to facilitate correction.

Environment: SAS/ BASE v 8.1 & 8.2, SAS/MACROS, SAS/SQL, SAS/GRAPH, SAS/ACCESS, MS EXCEL Windows XP.