SUMMARY

• Over 8+ years of experience in SAS administration, development, statistical analysis and reporting in clinical and research, IT and healthcare environments using SAS Software.
• Extensive experience in SAS/BASE, SAS/STAT, SAS/MACROS, SAS/SQL, SAS/ODS, SAS/GRAPH, SAS/CONNECT, SAS/ACCESS, SAS/EG.
• Experience in administering SAS Grid environment using SAS Management Console and SAS LSF
• Hands on experience inSASProgramming, MergingSAS DataSets, DevelopingSASprocedures, Macros, Preparing Data, Producing Reports,SASFormats,SASFunctions,SAS Informats, Storing and ManagingDatainSASFiles.
• Thorough hands - on experience in usingSAS/ODS to generate different files including XML, RTF, MS Excel, PDF and HTML.
• Experience working withSASBI tools such asSASEnterprise Guide,SASInformation Map studio, SASManagement Console,SASData Integration Studio,SASWeb Report Studio andSASOLAP Cube Studio
• Extensive noledge in SAS metadata and ETL developer of building and implementing metadata repository and metadata security.
• Experienced in SAS SPDS, SAS Schedule Manager and SAS Visual Analytics LASR Server management.
• Thorough work noledge of using ODBC to connectSASSystem with relational database management systems to retrieve data and createSASdatasets
• Experience in developing routine codes withSASMacro facility
• Worked on TERADATA and utility domains. Optimization of Queries in aTeradatadatabase environment.
• Knowledge of EG console management. Knowledge of different modules in HADOOP.
• Extensively used PROC SQL and MACROS with SELECT sub-queries to generate various reports by connecting to the Teradata DB.
• 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.
• Experience in setting up connections to different Databases like oracle, SQL, DB2, HADOOP and NETEZZA according to users requirement. SPDS implementation. Retail eCommerce experience
• Expertise in SAS 9.4 Grid on Linux, SAS Visual Analytics 7.1, SAS Environment Manager, IBM GPFS
• 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 noledge on LINUX and SHELL SCRIPTING, Worked as BASE SAS programmer.
• Experience in managingHadoopclusters using Cloudera Manager Tool.
• Converting existing reports programs to stored procedures And Converting existing BO reports to enterprise guide
• 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
• 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
• Application ofSASHotfixes, maintenance release and license renewal as required
• SASEnterprise guide,SASEnterprise miner, BaseSAS,SASModel manager, Microsoft Add-in client installation and troubleshooting

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

Operating Systems: UNIX, Win 95/98/NT/ 2000, 2003, 2008

PROFESSIONAL EXPERIENCE

Confidential, ARDEN HILLS, MN

SAS BI ADMINISTRATOR

Responsibilities:

• Responsible for administering any issues related to SAS Enterprise Guide, SAS Stored Process, SAS Enterprise Miner and SAS Visual analytics
• Hands on experience in SAS Enterprise Business Server Administration with a strong background in UNIX Systems Administration with on-call production support
• Installed SAS/Access Interface to Impala and iODBC drivers. Configured the drivers for autantication and connection
• Version upgrade from SAS Microsoft Add-in 7.11 to SAS Microsoft Add-in 7.14
• Applied hotfixes to systems when required or mandated by SAS
• Renewed SAS licenses
• Responsible for renewing SAS SSL certificates and validating SAS Applications for SAS 9.4 M3 on Dev and Prod environments
• Created documentation on the process of renewing SSL Certificates for SAS Environment and Hadoop Clusters
• Performing SAS standalone product installations with SAS Deployment Manager on user’s machines and assisting users in connecting to the SAS servers from the required SAS product for their activities
• Creating and removing User groups, roles and ID’s on the SAS Metadata and giving access using SAS Management Console
• Creating Custom ACTs (Access Control Template) dat manages visibility of content for different user groups
• Performing App Migration (SAS Code) between environments, scheduling the apps, moving datasets needed to deploy code
• Experience in administering the SAS VA Dashboard Issues and guiding users
• Hands on experience in handling the data load Issues with LASR analytic Server via Autoload facility
• Improved system stability by providing solutions to commonly occurring problems
• Maintained thorough documentation for all the issues and maintenance activities
• Automated minor maintenance activities using shell scripting and scheduling using CRON, AT jobs

Confidential, WAYNE, PA

SAS BI ADMINISTRATOR

Responsibilities:

• 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 user’s machines and assisting users in connecting to the SAS Grid servers from the required SAS product for their activities.
• 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
• Performed depot subset for client side tools using SAS 9.4 Depot Sub setting Utility.
• Version upgrade from SAS Visual Analytics 6.4 to 7.3.
• Experience in Installing and configuring of VA 7.1, 7.2 & 7.3
• Experience in designing, developing Visual Analytics and Enterprise Guide reports, graphs, visualizations and dashboards. Involved actively in developing graphs and reports by working on SAS VA 7.1, 7.2 & 7.3.
• Hands on experience in loading data to LASR Analytic Server and experience with Visual Data Builder
• Experience in troubleshooting and fixing issues of Visual Analytics 7.2 & Enterprise Guide
• 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
• 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.
• Worked on HADOOP and its different modules like HADOOP common and HDFS etc. Worked during weekend maintenance activities orTeradatapatch update
• 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.Working with utilities Like BTEQ, MLOAD, FLOAD, TPump etc
• Performing User 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.
• Used SAS data Integration studio to develop various job processes for ETL data warehouse database.
• SAS developer with expertise in design and development of Extract, Transform and Load processes for data integration projects to build data marts.
• Worked with millions of records.
• Worked on LINUX and SHELL SCIPTING.
• 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.
• 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
• 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.

Confidential, San francisco, ca

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.
• Hands on experience in SAS EBI like information map studio, web report studio, Information delivery portal.
• Experience in developing service level agreements (SLAS) between the users to address the level of support.
• 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 with Network File System (NFS), Worked on Data warehousing. Worked on Analysis, Development, Design, Testing and Reporting of 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.
• Worked on security issues. Aware of checking logs and resolving issues.
• 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 noledge on SAS HPA architecture
• Understanding of how to apply hot patches, services 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)
• 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.
• Improve performance metrics and availability of MOM tool by continuously checking splunk for any errors and resolving and logging and performance issue.
• 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.
• 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.
• Assisted in configuring web report studio and defining and creating SAS information maps for authorized users.
• Hands on experience in using HPSM for working on incidents and opening problem records and non 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.
• 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 developers encountering issues while coding and testing existing programs using BASE SAS, SAS/MACRO, SAS/SQL SAS ENTERPRISE GUIDE.
• Extensively used SAS SQL to query and subset data, summarize and present data, combine tables using joins and merges and created and modified tables.
• Has a working noledge of relational databases dat are being utilized

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

SAS EBI DEVELOPER

Responsibilities:

• 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.
• Design and develop routines, tools and using SAS EG/Base SAS to support ad hoc reports including automation in the SAS Web Report Studio.
• Responsible for 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.
• Worked and interacted through the project with business team on Web Report Studio to develop business 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
• 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.
• 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.
• Performed Data Cleaning for data attributes by backfilling the historical period data with current existing data.
• 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
• 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.
• Extensively used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE, and PROC REPORT.
• Used SAS DI Studio v 4.6 for data transformations and has ability to schedule and deploy code from SAS DI.
• 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.
• 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.
• 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.
• 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.
• Performed various cluster analysis, using ANOVA, CHAID.
• Excelled in Change Management procedures, problem management procedures and version control for SAS code.
• Worked with large quantities of data.Developed and designed different SAS programs to analyze financial data.

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.