PROFESSIONAL SUMMARY

• Around 7 years of experience in administration, developing programs, statistical analysis and reporting in clinical and research, IT and healthcare environments using SAS Software.
• Experience and knowledge 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 knowledge in Data Warehousing concepts.
• Experience in administering SAS Grid environment using SAS Management Console and SAS LSF
• Worked closely with SAS Experts during SAS 9.4 installation and configuration.
• Familiar with FDA regulations, GMP, ICH, GCP and GLP, Knowledge of CDISC models like SDTM mapping and ADAM experience and managed SAS CDI. Hands on DAP
• Has Fine grip on PAM and LDAP servers.
• Worked on TERADATA and utility domains. Optimization of Queries in aTeradatadatabase environment.
• Excellent knowledge 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 with 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) with Knowledge of BO 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 knowledge 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 knowledge on SAS HPA architecture
• Experience in managingHadoopclusters using Cloudera Manager Tool.
• Strong knowledge of the operating systems dat 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 knowledge in using clinical trial data like Demographic data, adverse event data, serious adverse event data, laboratory data and vital signs.
• Converting existing reports programs to stored procedures And Converting existing BO reports to enterprise guide
• Worked with statisticians to analyze clinical data and generated tables, figures and listings (TFL’s) for the same generated output files in RTF, HTML, and PDF format using SAS/ODS, SAS Enterprise Guide and SAS Procedures. Has knowledge to create and use stored process in info maps.
• Has hands on experience in SAS EBI like information map studio, web report studio, information delivery portal.
• Generated various graphs using SAS/GRAPH procedures like PROC GPLOT and PROC GCHART
• Conceptual understanding of various business requirements in healthcare, clinical 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 with security including PAM and LDAP/Active Directory
• Knowledge of EG console management. Knowledge of different modules in HADOOP.

TECHNICAL SKILLS

Statistical Software: SAS 9.4, SAS9.3, SAS9.2, SAS 8, SAS/BASE, SAS/MACRO, SAS/SQL, SAS/ACCESS, SAS/Connect, SAS/ODS, SAS/STAT, SAS/ETL

SAS Platform: SAS Enterprise Guide, SAS Management Console, SAS Enterprise Miner, Dashboard, SAS Studio, SAS information delivery portal, SAS Stored process, SAS?OLAP cube studio

Programming Languages: SQL, PL/SQL

Databases: Oracle, MS Access, MYSQL, Hadoop

PROFESSIONAL EXPERIENCE

Confidential - Plano, Texas

PLATFORM ADMINISTRATOR

Responsibilities:

• Designing, implementing, and maintaining security on SAS Metadata and Linux for users.
• Configured the SAS Environment Manager dashboards, enabled extended monitoring and report center.
• Installation of client applications and troubleshooting technical problems.
• Tracking applicable SAS hot fixes and creating implementation plans for respective SAS modules and applications.
• Created ETL script using SAS DI studio
• Used SAS DI studio to load dimension table into Teradata
• Monitoring SAS Server resources and reporting usage.
• Identifying performance and recommending/implementing tuning of active SAS environment(s) providing
• Task consisted of implementing and optimizing SAS products within existing infrastructures (Windows and AIX). Use Data Integration to develop data warehouse.
• Projected capacity shortfalls.
• Keep daily and weekly Program Management on track so dat tasked jobs for the IT-GIS group are met and followed.
• Designing, implementing, and executing the change control and promotions tasks in SAS.
• Significant MRM reporting improvements, including an updated set of reports.
• Very good knowledge on administering SAS Grid environments.
• Provide guidance and assistance to SAS Developers on operational and technical issues; interfacing with the SAS Institute for Support on administrative and system issues.
• Creating and implementing upgrade plans.
• Designs optimization programs using shell script via Linux and AIX.
• Occasional after hour support when system OS and hardware maintenance and applying SAS hot fixes and upgrades occur.
• Significant content upgrades, including a number of new features in MRM.
• Monitor and log SAS servers and optimize memory usage or tune servers for optimal performance.
• Reviewed, validated, documented and mentored SAS Admin and team regarding SAS environment.
• Worked as single point of contact for all SAS related issues.
• Focus on areas of capability, interoperability, scalability and enterprise class issues (me.e. like failover).
• Act as a liaison to SAS Technical Support for SAS users at the client’s site.
• Played a part of SAS9.4(M3) to 9.4(M4 ) upgrade project

Environment: SAS 9.4 M4, SAS Enterprise Guide 7.1, SAS Management Console 9.4, SAS Enterprise Miner 12.3 SAS Model Manager 12.3, SAS Add -in Microsoft office and SAS DI Studio in WINDOWS 7, XP AND RHEL 7.4, Salford, Data Robot.

Confidential - OHIO, COLUMBUS

Sr. SAS EBI CONTENT DEVELOPER

Responsibilities:

• Installed, configured and maintained CA SiteMinder Policy Server 12.0/12.5, CA IDM r12 and Sun ONE Directory Server 5.2 on Solaris, Windows platforms.
• Hands on experience in SAS Enterprise Business Server Administration with a strong background in UNIX Systems Administration with on-call production support.
• Performing SAS product installations with 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 knowledge on SAS LSF platform
• Creating directory for every individual users in a particular file system to store their datasets and directing them to the path in the assigned server. worked on Ad Hoc programming.
• Good understanding of MPP databases such as Teradata, Greenplum and Netezza.Worked close with admin teams in monitoringHadoopcluster.Working onTeradataManager to monitor and manage resource utilization.
• Performing User Migration and Data migration (datasets and tables) from DSAP 9.3 servers to SAS Grid 9.4 servers and assisting users to fetch migrated data in the grid.
• worked in teradata environment and prepared datasets and libraries along with tables in it.
• Worked on LINUX and SHELL SCIPTING. strong knowledge in Data Warehousing Concepts.
• 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 has no performance impact on the SAS Metadata Server.
• Experience in trouble shooting issues like file system unmounts, space outage issues, MEMSIZE issues, performance issues, service packs, checkouts after releases, hot fixes, monitor services regularly and perform service start, stop and status check when required and PAM and LDAP
• Creating EG projects from multiple SAS programs Building queries using EG Building Graphical reports using existing SAS programs Knowledge of EG console management Create reports using point and click
• Working as first point of contact for science team users in case of any issues with SAS products while connecting to servers, or running code in batch mode or issues with servers while performing grid testing.
• Coordinating with the security team very often and providing servers for the MS patches and rebooting for the, scheduled time. worked on SPDS implementation/supportsidd lambda
• Experience in documenting data mapping from source to target.
• worked on Retail ecommerce experience. Worked on HADOOP and its different modules like HADOOP common and HDFS etc. Worked during weekend maintenance activities orTeradatapatch update
• Responsible for monitoring CPU usage, Disk usage, and system resources.
• Hands on experience in scheduling software version upgrade task on client servers and license renewing.
• FreRegular Monitoring of SAS Servers to ensure the performance.
• Excelled in Change Management procedures, problem management procedures and version control for SAS code. worked on Data Analyzing Platform
• Interacting with different Support teams like UNIX Administration, Database Administration, Production Job Scheduling Team, Middleware Team and others to meet SAS Developer’s access and connectivity requirements.
• Closely worked with SAS Experts at the time of SAS Installation and configuration performed on the SAS Grid Servers. Worked on Data Warehousing for developing dash boards for BA
• Documented various procedure for smooth functioning of project like Physical architecture, Code migration process, code development standards, move sheets needed to deploy code from MW and DB components, access request templates, multi project environment
• Experience in interacting with SAS Technical support and opening tickets about issues when required.
• Attending sessions along with users organized by SAS Experts about various SAS Products and clearing up the user’s queries regarding SAS Grid.

Environment: BASE SAS 9.4, SAS Enterprise Guide 6.1, SAS Management Console 9.4, SAS Enterprise Miner 13 SAS Model Manager 12.3, SAS Add - in Microsoft office and SAS DI Studio in WINDOWS 7, XP AND RHEL 6.4.

Confidential, Tampa, Florida

SAS GRID ADMINISTRATOR

Responsibilities:

• Experience in installing, configuring and administering any issues related to SAS Enterprise guide, SAS Enterprise miner, SAS DI studio and SAS Stored process.
• Experience working in the SAS GRID Environment. ability to configure Queues/Policies in SAS GRID environment. has hands on experience in SAS EBI like information map studio, web report studio, information delivery portal.
• Scheduled servers for the implementations and maintained servers with the client requirements.
• Performed tasks for software installations, windows security patch installations and license renewal on LINUX SERVERS. Worked on Data warehousing. Worked on Analysis, Development, Design, Testing and Reporting of ETL tools
• 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 with third party software such as databases (DB2, SQL SERVER, ORACLE), web application servers, etc. strong knowledge on SAS HPA architecture
• Understanding of how to apply hot patches, service packs and do version upgrades.
• Worked as Server Type Owner (STO) for Linux and windows and driven process of ESR implementations by accessing ESMT and coordinating with TAEs and project team and fixing the dates.
• Monitoring and troubleshooting SAS servers and processes, including error messages by using system logs or server logs or setting logging options as well as options within SAS Management Console (SMC)
• Worked on security issues. Aware of checking logs and resolving issues.
• Dealt with storage issues in windows web server in production. Has capacity to preplan and be prepared with available space before any reports or backup is to be performed.
• Used SAS DI studio for data transformation and has ability to schedule and deploy code from SAS DI.
• Experience in developing service level agreements (SLAS) between the users to address the level of support.
• Improve performance metrics and availability of MOM tool by continuously checking splunk for any errors and resolving and logging and performance issue.
• Worked as Incident and Problem coordinator for short time in service team for incidents, requests and problem tickets raised by business partners and end users related to the marketing work bench, digital asset library, changes in the UI Frame work, process designer and schema designer in marketing operations management system.
• Hands on experience in using HPSM for working on incidents and opening problem records and known errors. Performed root cause analysis to provide solutions to the problems.
• Performed full functional checkout, business checkout and regression testing after releases, implementations and installations.
• Generated weekly and monthly status reports to the project and business team for existing problem records in HPSM and maintained documentation for all processes implemented.
• Extensively used SAS SQL to query and subset data, summarize and present data, combine tables using joins and merges and created and modified tables.
• Created Stored Process in SAS Enterprise Guide and executed stored process for the generation of reports.
• Conceptual understanding of designing and executing marketing campaigns with SAS CI Studio.
• Understanding of working of web applications (web report studio, information delivery portal, sas BI dashboard) on the middle tier.
• Experience in working with client server (Windows and Linux) environments to perform activities after implementations like start, stop and checking status for metadata, object spawner, analytics platform, grid monitor service and process manager for SAS applications like SAS MA, MO &MOM.
• Experience in working with developers encountering issues while coding and testing existing programs using BASE SAS, SAS/MACRO, SAS/SQL SAS ENTERPRISE GUIDE.
• Assisted in configuring web report studio and defining and creating SAS information maps for authorized users.
• Has a working knowledge of relational databases dat are being utilized
• Worked as a lead to the offshore team.

Environment: BASE SAS v 9.2 & 9.3, SAS Enterprise Guide, SAS DI Studio, SAS Management Console, SAS Enterprise Miner, SAS Web Report Studio, SAS Stored Process, SAS MA, MO & MOM in WINDOWS AND LINUX.

Confidential, Kansas

Responsibilities:

• Responsible the SAS EBI 9.1 & 9.2 platforms dat run on Development, QA, and Prod environments including BI security and managing Read/Write privileges of users and supports 24/7, Responsible for production of Risk Model outputs as well as related reports during and after the production cycle.
• Developed and implemented real-time error-capturing code in SAS for production environment Displaying various reports and model results on SAS Web Report Studio via SAS stored process for diverse bank departments.
• Supported a total of 4 departments with 25 people for their needs in terms of data and/or reports.
• Develop and maintain documentation of the system configuration, procedures, and apply hotfixes and maintenance releases to SAS 9.1.3 & 9.2 as well as SPD Server & client SAS products
• Design and develop routines, tools and using SAS EG/Base SAS to support ad hoc reports including automation in the SAS Web Report Studio.
• Make the full implementation of Risk models into DEV, QA, & Prod environments and version them by using Version Control software, Configure and conduct performance-tuning of general SAS programs in SAS BI platform 9.1 & 9.2.
• Communicate and jointly work with IT departments, database administrators and business lines Create data schemas and data models to extract data from various databases across the organization, and Compare the SAS model logics for the business units and support them via Ad Hoc reporting based on their needs.
• Worked on advanced statistical methods of analysis and software packages like Base SAS, SAS/MACROS, SAS/STAT, SASENTERPIRSE GUIDE AND MINER in helping and solving different problems and ad-hoc requests in the Organization.
• Automated the process of reporting which indicated metrics on profitability of different customer groups, profitability of different using SAS/BASE, SAS/MACRO, SAS/STAT, and SAS/GRAPH.
• Assisted in investigating and applying new SAS programming methods and techniques to enhance current systems by using various SAS macros and standard programming procedures.
• Creating permanent formatted SAS data sets and developed reports using PROC REPORT, PROC TABULATE and DATA NULL for analysis
• Extensively used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE, and PROC REPORT.
• Responsible for maintenance and enhancements in reporting systems using SAS/BASE, SAS/MACRO, SAS/STAT, SAS/AF and SAS/GRAPH.
• Worked and interacted through the project with business team on Web Report Studio to develop business reports
• Used SAS DI Studio v 4.6 for data transformations and has ability to schedule and deploy code from SAS DI.
• Generated high quality reports in the form of listing, HTML, XML, RTF and PDF formats using SAS ODS.
• Extensively used SAS SQL to query and subset data, summarize and present data, combine tables using joins and merges and created and modified tables.
• Worked extensively with Data mining using enterprise miner.
• Created Stored Process in SAS Enterprise Guide and executed stored process for the generation of reports.
• Performed Data Cleaning for data attributes by backfilling the historical period data with current existing data.
• Achieved good experience working with massive databases (hundreds of terabytes) validating them with different statistical tests and also experience in marketing related modeling applications, database marketing, and predictive analytics
• Created one way frequency reports, list report and also done summary statistics, table analysis by using SAS Enterprise Guide 4.3.
• Worked on Predictive modeling and managing the models for better view and reporting to ensure the quality of the product designed.
• Worked with the marketing department to develop marketing campaignsfor customer acquisitions dat involved liaising with third party Data Providers, setting up internal IT systems and Campaign data analytics using SAS Management Console.
• Developed and designed different SAS programs to analyze financial data.
• Performed extensive work with business team in developing the project. Involved in decision making for progress of the business.
• Created and maintained the Flows in SAS Management Console v 9.3 and scheduled jobs in it on a
• Weekly/monthly basis.
• Developed forecast reports for further business development using FORECAST SERVER.
• Hands on experience on conducting statistical methodologies on linear regression, logistic regression.
• Performed extraction, transformation and loading from large Oracle tables.
• Also used SAS/ETS in support to the forecast server for better development of the prediction of the business, which gives better impact on the business planning and development.
• Created Pivot tables in Microsoft excel for the SAS DATASETS for further calculations.
• Worked extensively on data cleaning process and data management process.
• Worked on pre-existing macros for data validation by checking data distribution and comparison to standard data.
• Testing on large raw data file using FIRSTOBS and OBS option, use of data lines to enter data internally.
• Use of PROC IMPORT procedure to import excel file into SAS.
• Performed various cluster analysis, using ANOVA, CHAID.
• Excelled in Change Management procedures, problem management procedures and version control for SAS code.

Environment: SAS/BASE v 9.0 & 9.1, SAS Enterprise Guide, SAS/MACROS, SAS/ACCESS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ODS, MS WINDOWS 2000 and ORACLE.

Confidential, San Diego, CA

SAS DEVELOPER/ANALYST

Responsibilities:

• Designing, implementing, and executing the change control and promotions tasks in SAS.
• Participated in generating tables, listings and figures to support submission to FDA.
• Strong understanding of CRT (Case Report Tabulation) data sets based on CDISC SDTM and ADAMS Submission Data Standards.
• Establishing best practices and guidelines for SAS BI usage
• Provide guidance and assistance to SAS Developers on operational and technical issues; interfacing with 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 knowledge of the operating systems dat SAS is installed on, such as memory management, file systemArchitecture, CPU utilization 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.
• Schedule periodic maintenance outages; e.g., combine patch application to minimize downtime
• Update the SAS standard referenced in the documentation section.
• Develop service level agreements between the users to address the level of support
• Host or participate in an internal SAS users group
• Do a dry run installation in the Research and Development environment first
• Review the organization's security model coz this may prevent various components from working
• Do screen shots and if possible, record the installation
• Test connectivity, access and functionality
• Responsible to write, modify, validate and implement SAS programs according to Statistical Analysis Plan.
• Performed data repairing by imputing missing or invalid observations and also elimination of duplicate observations
• 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.
• Performed survival analysis by using Proc Life test, generated Kaplan Meier plots.

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

Confidential

SAS DEVELOPER

Responsibilities:

• Developed and implemented real-time error-capturing code in SAS for production environment Displaying various reports and model results on SAS Web Report Studio via SAS stored process
• Supported a total of 4 departments with 25 people for their needs in terms of data and/or reports.
• Worked on advanced statistical methods of analysis and software packages like Base SAS, SAS/MACROS, SAS/STAT.
• Assisted in investigating and applying new SAS programming methods and techniques to enhance current systems by using various SAS macros and standard programming procedures.
• Extensively used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE, and PROC REPORT.
• Responsible for maintenance and enhancements in reporting systems using SAS/BASE, SAS/MACRO, SAS/STAT, SAS/AF and SAS/GRAPH.
• Generated high quality reports in the form of listing, HTML, XML, RTF and PDF formats using SAS ODS.
• Participate in project discussions and weekly status meetings of the project proceedings with the onsite team.
• Created macro program to create macro variables to pull data from DB2 for monthly data extracting.
• Extracted data from different sources like Oracle and Teradata and text files using SAS/Access.
• Worked on a Unix and Windows platform; in a server application environment.

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