SUMMARY

• 7+ years of experience inSAS Development, Architecture & Administration. Extensive noledge in large scale data analytics, using various databases on different platforms.
• 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 wif Base SAS, SAS Metadata Server, SASObject Spawner,SASManagement console 9.1.3, 9.2, 9.3 SASEnterprise Guide 4.1, 4.3, 5.1, PC SAS, SASOLAP Cube Studio, SAS Information Map studio, SAS Performance Data Server and SASWeb Portals.
• Installation of multipleSAS 9.4 instances on grid and clustered environment wif Load balancing optimization on Linux and Window environments.
• Familiar wif FDA regulations, GMP, ICH, GCP and GLP, Knowledge of CDISC models like SDTM mapping and ADAM experience and managed SAS CDI. Hands on DAP
• Worked on TERADATA and utility domains. Optimization of Queries in aTeradatadatabase environment.
• Excellent noledge inHadoopArchitecture and its major components likeHadoopMap Reduce, HDFS Frame work, HIVE, PIG, HBase, Zookeeper, Sqoop, Oozie, Flume and Avro.
• Good understanding of teh SAS Web tier and SAS Server Tier Architecture in GRID environment wif excellent troubleshooting skills.
• Hands on experience in performing client installations of various SAS products like SAS Enterprise Guide, SAS Enterprise Miner, SAS Add - in and SAS Model Manageron users machines.
• Experience in setting up connections to different Databaseslike oracle, SQL, DB2, HADOOP and NETEZZAaccording to users requirement.SPDS implementation.Retail eCommerce experience
• SAS EG 6.1 (Enterprise Guide) wif Knowledge of BO and Architecting SAS environments
• Participated in all phases of Software Development Life Cycle including development, functional and design specification, coding, Unit and Integration testing, bugs fixing and reviewing.
• Experienced in various SASadministration activities like monitoring server, administer logging, setting up and securing metadata folder and securing teh SAS configuration on each server machine.
• Hands on experience using BI tools like SAS Data Integration Studioand SAS Marketing Operations Management.strong noledge on SAS HPA architecture
• Experience in managingHadoopclusters using Cloudera Manager Tool.
• Strong noledge of teh operating systems dat SAS is installed on like its memory management, file systemArchitecture, 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 signsConverting existing reports programs to stored procedures And Converting existing BO reports to enterprise guide
• Experience in creating ad-hoc reports in tight schedules using various SAS Procedures.
• Performed Validation and Verification on developed SAS programs and teh Reports.
• have 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 inhealthcare, 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 wif security including PAM and LDAP/ActiveDirectory.
• Knowledge of EG console management. Knowledge of different modules in HADOOP

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

SAS GRID Administrator

Responsibilities:

• Hands on experience in SAS 9.4 installation on Linux 64 Unix grid environment along wif clustered web tier wif SAS Portal BI reporting.
• Performing SAS product installations wif SAS Deployment Manager on users machines and assisting users in connecting to teh SAS Grid servers from teh required SAS product for their activities.
• Performed depot subset for client side tools using SAS 9.4 Depot Sub setting Utility.
• Creating and removing teh User IDs, user groups, and roles on teh SAS Metadata and giving teh library access by using SAS Management Console. deep noledge on SAS LSF platform
• Managed SAS Metadata Server, ensured its availability wifout any performance issues and took regularbackups of teh repositories.
• Created new metadata objects using SASManagement Console 9.3 for projects to teh end users in SASMetadata Server.
• Creating directory for every individual users in a particular file system to store their datasets and directing them to teh path in teh assigned server. worked on Ad Hoc programming.
• 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 teh grid.
• Installed and configure Jboss 5.1 to support SAS Web Applications like SASStore Process, Web ReportStudio, SASBi Dashboard and BI Portals for both dev. and prod environment.
• Worked on LINUX and SHELL SCIPTING. strong noledge in Data Warehousing Concepts.
• Established DB connections like Oracle, SQL server and Netezza connections from teh grid.
• Responsible for making teh web based SAS services likeEnterprise Miner Web based and SAS Stored Process Web Application connectivity and ensuring it TEMPhas no performance impact on teh SAS Metadata Server.
• Migrated SASdeveloped projects from 9.1.3 to 9.3 along wif their base code.
• Migrated SASMetadata users from SAS9.1.3 to SAS9.3 and created new groups and ACL.
• Coordinated efficiently wif Business Analysts, Application Architects, and Infrastructure teams in handlingsetup and maintaining SASservers.
• Hands on experience in scheduling software version upgrade task on client servers and license renewing.
• Interacting wif 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 wif SAS Experts at teh time of SAS Installation and configuration performed on teh SAS Grid Servers. Worked on Data Warehousing for developing dash boards for BA
• Experience in interacting wif SAS Technical support and opening tickets about issues when required.
• Attending sessions along wif users organized by SAS Experts about various SAS Products and clearing up teh 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

Confidential, Chicago, IL

SAS BI Administrator

Responsibilities:

• Experience in SASGrid 9.3 Server Installation, Configuration, Administration and Managing metadata repositories
• Experience in migrating SAS Servers from 9.1.3 to 9.3 and working in multi-tier applications.
• Experience working in teh SAS GRID Environment. ability to configure Queues/Policies in SAS GRID environment. have hands on experience in SAS EBI like information map studio, web report studio, information delivery portal.
• Managed SASConnect server, Metadata Server, Object Spawner, OLAP server, Stored Process Server on teh windows environment.
• Configured SAS Grid Manager Utility to send all SASEG and batch jobs across grid based on grid algorithm.
• Installed and configured SASAccess to Oracle, SQL and Greenplum database.
• Supported SASEBI Grid Platform on multi tier architecture - Metadata, Compute & Web tier.
• Worked on Platform LSF/PM 9 Version and SAS9.4 Version. Have noledge and experience working on Grid Platform.
• Supported a total of 4 departments wif 25 people for their needs in terms of data and/or reports.
• Develop and maintain documentation of teh 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 teh SAS Web Report Studio
• Supported Users on various EBI Clients such as BASESAS, SASEnterprise Guide, OLAP Cubes, Information Maps, and SASPortal.
• Worked closely on User Tickets dat come in to our queue such as User Access Issues, Adding users to Management console, Creation of Groups in SMC, Creation of Metadata Library, Performance Issues, etc.
• 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 teh Organization.
• Automated teh 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
• Worked and interacted through teh project wif business team on Web Report Studio to develop business reports
• Used SAS DI Studio v 4.6 for data transformations and TEMPhas ability to schedule and deploy code from SAS DI.
• Generated high quality reports in teh 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 wif Data mining using enterprise miner.
• Created Pivot tables in Microsoft excel for teh SAS DATASETS for further calculations.

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, IL

Sr. SAS ANALYST (DI)

Responsibilities:

• Experience in SASGrid 9.3 Server Installation, Configuration, Administration and Managing metadata repositories
• Experience in migrating SAS Servers from 9.1.3 to 9.3 and working in multi-tier applications.
• Experience working in teh SAS GRID Environment. ability to configure Queues/Policies in SAS GRID environment.
• Worked on on-boarding users to a newSASEnvironment and providing permissions to different client applications such as Enterprise Guide, Enterprise Miner,VisualAnalyticswork.
• Installed and configured SASAccess to Oracle, SQL and Greenplum database.
• Supported SASEBI Grid Platform on multi tier architecture - Metadata, Compute & Web tier.
• Prepareddatausing ETL techniques followed bydatamodeling using Decision Tree, Regression & Neural Network
• Develop and maintain documentation of teh 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 teh SAS Web Report Studio
• Supported Users on various EBI Clients such as BASESAS, SASEnterprise Guide, OLAP Cubes, Information Maps, and SASPortal.
• Worked closely on User Tickets dat come in to our queue such as User Access Issues, Adding users to Management console, Creation of Groups in SMC, Creation of Metadata Library, Performance Issues, etc.
• Retrieved thedatafrom flat files received from teh vendors and converted toSASdatasets for Analysis usingSAS/STAT Procedures such as Proc Freq, Proc Tabulate, Proc Univariate, and Proc ANOVA
• Designed and developed Extract, Transform, Load (ETL) processes using BaseSAS,DataIntegrationStudio, andDataFluxDataManagement Studio to populateDataWarehouses and ReportingDataMarts
• Prepared and tested ETL codes as part ofSASprojects
• Manageddataintegrationdevelopment tasks in collaboration wif other technical teams
• Worked and interacted through teh project wif business team on Web Report Studio to develop business reports
• Used SAS DI Studio v 4.6 for data transformations and TEMPhas ability to schedule and deploy code from SAS DI.
• UsedSASDIStudio to develop various jobs processes for extracting, cleansing, transforming, integrating, and loadingdataintoDatamarts andDatawarehouse database.
• Generated high quality reports in teh 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 wif Data mining using enterprise miner.
• Created Pivot tables in Microsoft excel for teh SAS DATASETS for further calculations.

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

Confidential, AL

SAS BI 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.
• Responsible for SAS 9.2 administration in multi-tier environment on AIX Enterprise.
• Responsible for creating different groups in SASManagement Console and incorporating
• Coordinating wif Desktop Support team for installing and Configuring SASsoftware on client machines.
• Responsible for monitoring SASworkspace, running scripts for cleaning temp area.
• 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 teh team and different work groups when needed and provided access to teh agents for various roles and sub roles for performing their activity in marketing operations management.
• Used SAS /ODS to produce teh reports in different formatted files.
• Created ad-hoc reports using various SASProcedures, SAS/Graph and SAS/Stat.
• 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
• Worked on security issues. Aware of checking logs and resolving issues.
• Used SAS DI studio for data transformation and TEMPhas ability to schedule and deploy code from SAS DI.
• Created Stored Process in SAS Enterprise Guide and executed stored process for teh generation of reports.
• Experience in working wif 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 wif 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.

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 Developer

Responsibilities:

• Complete End-To-End SAS9.1.3 Enterprise Support and Server Maintenance/Monitoring on HP UNIX Itanium 64 Bit Servers.
• Gathering, understanding, analyzing and documenting Client requirements for leveraging SAS Enterprise Access.
• Strong understanding of CRT (Case Report Tabulation) data sets based on CDISC SDTM and ADAMS Submission Data Standards.
• Interacting wif different Support teams like UNIX Administration, Database Administration, Desktop Support, Production Job Scheduling Team, Citrix Middleware Team and others to meet SAS
• Occasional after hour support when system OS and hardware maintenance and applying SAS hot fixes and upgrades occur.
• 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.
• Tracking applicable SAShot fixes and creating implementation plans for respective SASmodules and applications.
• Monitoring SASServer resources and reporting usage(s).
• Identifying performance and recommending/implementing tuning of active SASenvironment(s) providing projected capacity shortfalls.
• Good understanding of teh SASWeb tier and SASServer Tier Architecture wif excellent troubleshooting skills.

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

SASProgrammer

Confidential

Responsibilities:

• Functioned as teh primary liaison between teh business line, operations, and teh technical areas throughout teh project cycle. Worked on gathering, analyzing and documenting business requirements.
• Developed statistical models from reading documentation from statisticians converting toSAScode and gathering teh requirements for data from data modelers.
• Experience in bringing huge amount of data fromSASand non - SASdata sources into aSASenvironment and performingSASdata manipulations against teh resulting sets. This includes ability to merge datasets and to writeSASMacros and generate list outputs/reports.
• Worked on Anti money laundering (AML) and performed analysis on generated ALERTS, CASES data on monthly basis.
• UploadSASdata sets across platforms from PC to Unix and Vice Versa.
• Prepared customized reports to help client provide a strong competency in understanding risk and accordingly perform better customer selection and customer satisfaction based on teh credit report.
• Coordinated wif key departments to analyze areas such as customer retention, opportunities and customer segmentation. Store and distributeSASEnterprise Guide results in different formats (HTML, PDF, RTF) based on teh user group requirement.
• Developed application for measuring financial performance of newly acquired accounts: Forecast Vs Actual and developedSASprograms for generating reports on Key financials, Income Statements, and Balance Sheet
• Monthly transaction data and annual balances of teh credit accounts for all types of credit cards are reported in teh month-end reports.

Environment:SAS/BASE,SAS/ACCESS,SAS/SQL,SAS/STAT,SAS/GRAPH, UNIX, SQL, Oracle, UNIX, Windows.