SUMMARY

• SAS certified professional with around 8+ years of experience in Administration and developing software applications for Health Insurance, Educational, Networking & Pharmaceutical sectors.
• Experience working in SAS EBI platforms with SAS 9.2, 9.3 & 9.4 versions.
• SAS Platform Architect experienced in architect, design, implement and maintenance of latest SAS 9.4 M3 EBI suite in various operating systems.
• Experience on SAS 9.4 Grid Administration including SAS/Connect Server, SAS Metadata Server, SAS Object Spawner and the admin clients SAS Management Console, Environment manager, Platform RTM, SAS Deployment Wizard & SAS Deployment Manager.
• Worked with Enterprise Guide, SAS Web Report Studio, SAS Information Map Studio, SAS Add - In for Microsoft Office, SAS Stored Processes, SAS Data integration Studio, SAS OLAP Cube Studio & JMP PRO for Visual Analytics.
• Experienced in administering the SAS platform in single, multi-servers and in a multi-node grid environment.
• Experienced in upgrade, migrate SAS environment from SAS 9.3 to SAS 9.4
• Experienced in SAS administration for High Availability within GRID environment including Metadata, Mid-Tier and Grid Control Servers.
• Configured SAS Grid HA with EGO for PM and GMS using Platform RTM.
• Experienced with PAM/AD/LDAP/Centrify/Kerberos authentication and Site Minder Single Sign on (SSO).
• Experienced in setting up segregate SAS Intelligence Platform Dev, QA, Prod environments, including promotion of metadata repository, partial promotion of BI objects and associated contents and design BI content SAS folder structure to meet client requirements and implement security and change control process.
• About 3 year of experience in applying various business analytics techniques like Logistic Regression Analysis, Multiple Regression Analysis, cluster analysis, Decision Tree Analysis, Correlation Analysis on various situations by JMP PRO software.
• Experienced in migrating JMP scripts to SAS Environment and good understanding of JMP script.
• Proficient in SAS/BASE, SAS/MACROS, SAS/Connect, SAS/SQL, SAS/Access (Oracle/Teradata) and SAS/ODS.
• Experience in working with SAS on different platforms like (UNIX LINUX, AIX, HP/UX, SOLARIS) and WINDOWS.
• Extensively worked on various RDBMS like Teradata, Oracle, DB2, SQL Server.
• Proven skills in data cleansing, data archival, data migration, ad-hoc reporting, and coding using SAS on various environments.
• Involved in all stages of SDLC (Software Development Life Cycle).
• Experience in SAS EBI installation on Linux, AIX Server’s & windows Server’s, trouble shooting, hot fixes, licenses renewals, handling software development, enhancements, testing and documentation.
• SASVisualanalyticsinstallation and data retrieval optimization from Hadoop toSASLASR Server.
• Implemented efficient data access between Big data andSASpart of Textanalytics.
• And experienced in JBOSS andSASWeb Application Server (WAS) management.
• SASDevelopment experience using baseSASand DI studio along with Dataflux for data quality.
• Solid command on Server manager, user manager, library manager scheduling plug-ins on SAS SMC and complete control on SAS Management Console.
• Solid Experience on modifying and Grid Enabling SAS programs for sequential and parallel processing based on the business needs.
• Used PROC SCAPROC & SASGSUB to Grid enable the SAS jobs and to submit the grid modified code.

TECHNICAL SKILLS

Statistical Software: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/Access, SAS/EG, SAS/STAT, SAS/Access, SAS/CONNECT, SAS/ODS, JMP PRO

Database: Teradata, Oracle, DB2, MS-SQL Server 2005, MS Access.

Operating Systems: UNIX, MS Windows (95, 98, 2000, NT, XP).

OOD Suites: Microsoft Visio, UML.

PROFESSIONAL EXPERIENCE

Confidential, Newtown-PA

Sr. Data Services Consultant/ SAS Platform Architect

Responsibilities:

• Performed SAS 9.4 installation on RHEL Linux platform forgrid environment along with clustered web tier withSAS Portal BI reporting.
• Installed and configured SAS Platform Suite(LSF,PM,GMS) and Platform RTM
• Configured SAS Grid High Availability with EGO for PM and GMS using Platform RTM
• Write SAS code to support the development of an item and test analysis system.
• Extensive Database knowledge with knowledge on statistical software’s including Minitab, Microsoft products, JMP, SAS programming.
• Gathered requirements and performed in depth analysis to start the Development.
• Configured Apache Web Server, Tomcat and SAS Intelligence platform mid-tier Web applications.
• Produce tables and graphical displays of large-scale statistical results.
• Write advanced queries/programs, including the use of macros and generate reports representing a variety of formats.
• Improvise the SAS code by using SAS GRID computing which can be executed on Parallel and Sequential Process.
• Used SAS PROC SCAPROC procedure for grid enabling the programs and analyzing the legacy code for GRID modifications.
• Used SASGSUB commands on the command line to execute and monitor the jobs.
• Work with large databases. Develop more efficient and innovative procedures in the fulfillment of these analyses that may include developing stored procedures/programs and/or database solutions
• Manipulate output from statistical analysis for use in research reports and other statistical analyses.
• Extensively used SAS PROC IML and SAS PROC SGPLOT procedures for generating the ICC charts as per the psychometrician requests.
• Design and implement QC procedures on all statistical analyses.
• Manage daily QC responsibilities including work priority, test accuracy, process efficiency, data communication to assure product quality, timely material release & customer satisfaction.
• Updating the stored process as per the SAS code modification so that the output statistics were pushed back to the Oracle Database.
• 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.
• Responsible for Deployments of complete packages by using E-Commander and SVN into various Environments like Development, UAT & PROD.
• Debugging and troubleshooting the bugs and errors while deploying in to SIT, UAT & PROD Environments.

Environment: SAS/EG, SAS Stored Process, SAS/SQL, SAS/STAT, SAS Grid Components, SAS Management Console, SAS OLAP Cube Studio, SAS Web Report Studio, SAS Dashboards. Excel, UNIX (AIX), Windows, SAS/Access Oracle, SSH clients PUTTY.

Confidential, NJ

Sr.SAS EBI Consultant /Tech lead

Responsibilities:

• Scoping the available 43 reports which fall under Attribution Reports, Care management, Finance, Quality Metrics and performance Reports during the initial period of Phase-1.
• 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.
• Developed the Web Reports and designed the user interface through SAS IDP
• Worked as a Portal Admin for publishing the Reports to different business groups
• 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.
• Maintenance of SAS Admin related activities and supporting to the team of 26 developers and 5 power users and 200+ business users
• Responsible for resolving all technical issues related to the SAS upgrade Migration.
• Requirements gathering, solid documentation skills and good understanding of the data.
• 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.
• Created business documents like high level design documents, Unit Test Cases for the reports which I developed.
• Managed offshore and assigned work based on the priority.
• Analyzed the legacy code and documented the information in order to automate the reports avoiding unwanted hard coding.

Environment: SAS/EG, SAS Stored Process, SAS/SQL, SAS/STAT, SAS Information Map Studio, SAS Management Console, SAS OLAP Cube Studio, SAS Web Report Studio, SAS Dashboards. Excel, UNIX (AIX), Windows, SAS/Access Oracle.

Confidential, CA

Sr.SAS Grid Administrator

Responsibilities:

• Responsible for the implementation of SAS Programming and Statistical Activities in various clinical trials and preparing documentation for submissions to FDA.
• SAS9.4 installation on Linux RHEL 6.8 along with clustered Metadata and web tier.
• InstalledSAS9.4 on Linux 6.8 server in Test & Production Environment.
• Administration of SAS 9.4 GRID Environment and applications for various business groups.
• End to EndSASGridimplementation involving hardware and software compatibility, performance testing and implementation, setting upGridmaster controller, ITRM on 16 node architecture
• Client Installation Enterprise Guide, Enterprise Miner,SASManagement Console, OLAP Cube Studio in Windows 7.
• Installed LSF/GridManager on the Linux server & Platform Computing Client Software.
• Successfully completed migration fromSAS9.3 EBI toSAS9.4 EBI.
• Converted different formats of external data files into SAS datasets, such as Excel, Access, DB2 and Oracle by using Proc format, Proc Import and SAS/Access
• Validating and implementing SAS programming work according to Statistical Analysis Plan (SAP).
• MaintaininedSASServers, Trouble shooting and Logging issues.
• Installation ODBC drivers and creatingSASlibraries for DB2, Oracle, SQL Server & Green plum.
• Designed and developed routines, tools and usingSASEG/BaseSASto support ad hoc reports including automation in theSASWeb Report Studio
• Maintaining allSASconfiguration files, what they do, how are they related and how to modify in all 3 SASEBI environments.
• SASIntegration with LDAP which is already IDM for organizational level access management and control.

Environment: SAS/EG, SAS Macros, SAS/SQL, SAS/STAT,SAS Clinical Data Integration Studio. Excel, SAS/Access Oracle.

Confidential, CA

Sr.SAS EBI Consultant

Responsibilities:

• Created SAS OLAP cubes by summarizing data and delivered to BI applications for on-the-fly processing and reporting.
• Created Information Maps in SAS Information Map Studio to be accessed from SAS Enterprise Guide, CI studio and OLAP cube server.
• Worked in Analytics team by performing various business analytics techniques to support the Marketing team for improving the campaigns.
• Extensively worked with JMP PRO for performing various modeling techniques like Logistic Regression Analysis, Multiple Regression Analysis, cluster analysis, Decision Tree Analysis, Correlation Analysis.
• Created Heat maps, Bubble plots, pareto distribution charts and other various business requirements oriented charts.
• Created SAS datasets in local SAS directory using SAS DI (Data Integration) through different transformations.
• Ensured the validity and accuracy of the analyzed data.
• Created Information Maps to feed Web Report Studio which generated reports.
• Used SAS BI and Microsoft Add-in to automate the standard reporting.
• Analyzed the oracle data warehouse to design the ETL process and implement the business logic required for the business changes.
• Hands on experience working on health care data including revenue, membership, claims and cost of health care data.
• Develop queries on the Customer Marketing Database (CMDB) to provide ad-hoc reports using SAS/SQL for marketing department use.
• Built automated process to pull data from Oracle and load the resulting Flat files into Access and SQL Server.
• Responsible for running of productionalized programs on monthly basis.
• Extensively used SQL Pass thro for pulling data from Oracle and SQL Server
• Designed and developed code using SAS/EG.
• Extensively used Humming bird for FTP purposes.

Environment: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/STAT, SAS/EG, SAS Information Map Studio, SAS Management Console, SAS Customer Intelligence Studio, SAS OLAP Cube Studio, SAS Web Report Studio. Excel, UNIX (SOLARIS), Windows, Oracle, SQL Server, SAS/Access Oracle, SQL Server, Humming Bird Exceed

Confidential, CA

SAS EBI Content Developer

Responsibilities:

• Created SAS Datamart and designed schema for efficient querying and reporting.
• Automated the Monthly and Quarterly Production process using cron jobs and scheduled them on the UNIX box.
• Experience working with different kinds of data like Harte Hanks and Customer registry to do analysis on customers and identifying new opportunities.
• Analyzed different internal data like Bookings, Campaign, Opportunity and supported adhoc request from business.
• Regularly involved in Data preparation, Data manipulations and formatting to support the statisticians with their models.
• Regularly used SQL Pass thro, libname Statements and PROC SQL to interact with different RDBMS like Oracle, Teradata.
• Created Stored Processes for the business to generate different adhoc reports based on the parameters passed.
• Have experience creating information maps which would be utilized by web report studio to generate static reports.
• Designed and developed code with SAS/EG to support ad hoc requests.

Environment: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/Access (Oracle / Teradata), SAS/Connect, Stored Process, SAS/Information Map Studio, SAS/Web Report Studio, SAS Addin for MS Office, SAS/STAT, SAS/EG, Excel, UNIX (SOLARIS), LINUX (UCS), Windows

Confidential 

Sr.SAS Programmer

Responsibilities:

• Involved in the design and development of year-end and quarterly reports.
• Worked with diverse team of business users to enable accurate communication of requirements.
• Extracted Health Care Claims, Products and member data using Proc SQL Pass through Facility.
• Created daily, monthly and Ad-hoc reports for home health care data.
• Performed transformation on the data extracts as required by the business.
• Created Macros on the AIX to generate reports.
• Analyzed the Trouble tickets in the Production environment and provided solution to the support team.
• Utilized Humming Bird for FTP purposes.
• Extensively used SAS/Connect for remote submitting the data extracts

Environment: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/Connect, Humming Bird V9.0, Exceed, Excel, DB2, UNIX (AIX), Windows