SUMMARY

• Over 7+ years of experience working in various domains as SAS Programmer, Administrator and Architect.
• Expertise inSAS/BASE, SAS/MACRO, and SAS/ODS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ACCESS, and SAS/CONNECTin UNIX and Windows environments
• Strong experience with databases likeOracle, MS SQL Server 2000, DB2 and MS Access
• Good understanding of the SAS Web tier and SAS Server Tier Architecture in GRID environment with excellent troubleshooting skills.
• Experience in administering SAS Grid environment using SAS Management Console and SAS LSF
• 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.
• 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.
• Worked closely with SAS Experts during SAS 9.4 installation and configuration.
• 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 user machines.
• Created Software Development Life Cycle (SDLC) document and excelled in the process of Change Management, Release management and Configuration processes.
• Hands on experience using BI tools like SAS Data Integration Studio and SAS Marketing Operations Management. strong knowledge on SAS HPA architecture
• Excelled in Change Management procedures, problem management procedures and version control for SAS code
• Ability to write SQL queries usingPROC SQL.
• Experience in utilizing SAS Procedures, Macros, and other SAS applications for data extraction, data cleansing, data loading and reporting. Involved in the data analysis, DB creation, applying database constraints and make ready to load onto database
• Customize the variables to user-defined formats usingPROC FORMATin printing reports.
• Experience in working with SASENTERPRISE GUIDE SOFTWAREfor reporting and analytical tasks
• Extensive knowledge of advancedSAS/STATprocedures includingUNIVARIATE ANALYSIS, REGRESSION, ANOVA, GRAPH AND PLOT.
• Experience working in SAS Business Intelligence (BI) platforms with SAS 9.1, 9.2, 9.3 & 9.4 EBI suites. Enterprise Guide 6.1, 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.
• Expertise in using various SAS report generating procedures likePROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE and PROC PRINT
• Perform ad hoc analyses as per user guidelines and reports and transform data into various formats like CSV, EXECL, and ASCII.
• Experience 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.
• Strong Knowledge on LINUX and SHELL SCRIPTING (KORN), worked as BASE SAS programmer.
• Involved in Credit risk analysis, consumer lending and balance sheet.
• Used SAS/ACCESS to read datasets from, Databases, Flat files, also read and write other PC File formats
• Direct the work of own managers /Key individuals in all consumer lending areas to include underwriting loan processing, loan documentation and approval or denial of consumer loans.
• Expertise in handling the consumer’s mailing list as a part of e-mail marketing under SAS change management
• Experience in management Hadoop clusters using Cloudera manager tool.
• 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
• SAS Enterprise guide, SAS Enterprise miner, Base SAS,SAS Model manager,, Microsoft ADD-in client installation and troubleshooting.
• Generated various graphs using SAS/GRAPH procedures like PROC GPLOT and PROC GCHART.

TECHNICAL SKILLS

Operating Systems: UNIX, Mainframe, MS Windows XP/Vista, MS 2003 server

Language: SAS 9.1.3, SAS 9.2, SQL, C

SAS Tools: SAS/Base, SAS/Macro, SAS/Stat, SAS/Connect, SAS/ODSSAS/ACCESS, SAS/ETL, SAS /Graph, SAS/OLAP Server, SAS BI platform, SAS EG, SAS EBI, SAS add-in MO, SAS WRS

Business Intelligence: SAS Management Console, SAS Enterprise Guide, SAS Data Integration Studio, SAS Information Map Studio, SAS Web ReportStudio

Database: MS-Access, Oracle, Metadata, SQL server, DB2

Other Technologies: Visio, Microsoft Office (Word, Excel, PowerPoint, Outlook)

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

SAS GRID Administrator/Analyst

RESPONSIBILITIES:

• Responsible for product installation with SAS deployment manager on user machines and assisting users in connecting to the SAS Grid servers.
• 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
• Installed and configure JBOSS 5.1 to support SAS Web Applications like SASStored Process, Web ReportStudio, SASBi Dashboard and BI Portals for both dev. and prod environment.
• Ensuring proper connectivity for web based SAS services likeEnterprise Miner Web based and SAS Stored Process Web Application and making sure that it does not have any impact on the SAS Metadata Server.
• Monitor the overall performance of SAS platform and data warehouse
• Managed SAS Metadata Server, ensured its availability without any performance issues and took regularbackups of the repositories.
• Managed SASConnect server, Metadata Server, Object Spawner, OLAP server, Stored Process Server on the windows environment.
• Configured SAS Grid Manager Utility to send all SASEG and batch jobs across grid based on grid algorithm.
• Established DB connections like Oracle, SQL server and Netezza connections from the grid.
• Scheduled software version upgrade task on client servers and license renewing.
• Installed and tested hot fixes for SAS 9.3 & SAS 9.4 M3.
• 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
• Responsible for monitoring CPU usage, Disk usage, and system resources.
• Effectively tested and packaged SAS components like JMP 9, SAS ActiveX graph and Enterprise Guide 4.3. These packages are pushed directly to the user's computer minimizing the efforts for a manual installation.
• 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
• Attending sessions along with users organized by SAS Experts about various SAS Products and clearing up the user’s queries regarding SAS Grid.
• On boarding new users on to the SAS platform by requesting for a UNIX ID and setting up the user on the SAS Metadata with security implemented on the directories on the UNIX side.
• Identify peak and non-peak production hours and schedule activities accordingly.
• Analyzed various database containing sales, titles, account, region etc. data of the releases of various titles.
• Extensive usedDATA STEP, PROC MEANS,PROC SQL, MACROS,PROC FREQ,PROC TABULATE,DATA NULL, PROC MEANS,PROC SUMMARY,RETAIN.
• UsedSAS - output delivery system ODS toformat reports in HTML, PDF, CSVandRTF reports.
• Experienced in SAS Visual Analytics 6.4 to 7.3 for various types of data analysis and also preparing the reports.
• Developed new or modifiedSASprograms and usedSQL Pass thruandLibnamemethods to extract data from the Teradata DBand created study specificSASdatasets, which are used as source datasets for report generating programs.
• Experiencedin handling Terabytesof records and manipulating them throughSAS.
• AnalyzedInteractive Marketing / ECRM System dataand produced ad-hoc report details.
• Analysis includedBehavioral model,Customer Profiling,Segmentation,Trend Analysis,Predictive Modeling, Lift modelingandValidation,Optimizing open-ended offers, etc.
• UsedSAS Macrosand procedures likeProc SQL, Proc Transpose, Proc Univariate, Proc Means, Proc Freq.
• Imported raw data files in excel format inSASand subsequently createdSASDatasets and performed data manipulations on the datasets. them into usefulSASDatasets, merged datasets and created reports based onAd-hoc requirements.
• UsedSASData Step logicsto Sort, Merge, Stack, Update and Interleave datasets for producing required analysis of data and usedSAS Business Intelligence (BI)to produce required Reports.
• Created various summary reports ofPOS, Total Sales, Regional Sales and Account Sales of various titles, regions and also presented the various sales reports using theInformation Delivery Portaland theDash Board Portlets.
• UsedEnterprise Minerfor taking data and converting them into requiredSASdatasets. Also used theSAS Forecast Studiofor appropriate analysis of data for different Forecasting models likeTime Series Forecasting.
• Documentation, presentation, data reports and model results to the team/manager.
• Used variousStatistical ProcedureslikePROC FREQ, PROC REG, PROC ANOVA and PROC GLMto analyze data and generate reports.
• ImplementedOLAP cubes, OLAP tools and other report tools like Web Report Studio.

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, Los Angeles, CA

SAS Administrator/ DI Analyst

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 the 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 the 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 knowledge and experience working on Grid Platform.
• 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
• Supported Users on various EBI Clients such as BASESAS, SASEnterprise Guide, OLAP Cubes, Information Maps, and SASPortal.
• Worked closely on User Tickets that 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 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
• 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 Pivot tables in Microsoft excel for the 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

Sr. SAS EBI Developer

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 with 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 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.
• Used SAS /ODS to produce the reports in different formatted files.
• Created ad-hoc reports using various SASProcedures, SAS/Graph and SAS/Stat.
• 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
• Worked on security issues. Aware of checking logs and resolving issues.
• Used SAS DI studio for data transformation and has ability to schedule and deploy code from SAS DI.
• Created Stored Process in SAS Enterprise Guide and executed stored process for the generation of reports.
• 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.
• 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 with 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 the SASWeb tier and SASServer Tier Architecture with excellent troubleshooting skills.

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, SAS/ BASE v 8.1 & 8.2, SAS/MACROS, SAS/SQL, SAS/GRAPH, SAS/ACCESS, MS EXCEL Windows XP.

Confidential

SAS Developer

RESPONSIBILITIES:

• Involved in the complete development, testing and maintenance of the application.
• Performed statistical analysis, and generate reports, listings and graphs usingSAS/Base, SAS/Macros,SAS/Stat,SAS/Graph,SAS/SQL,SAS/ODS andSAS/Access
• Produced high quality graphs through SAS/GRAPH for analysis studies.
• Created automated FTP's, automated Email macros using SAS and UNIX to desktop for analysis.
• Extensively used various BaseSASprocedures like Proc SQL, Proc Summary, Proc Format, Proc Print, Proc sort for reporting purposes. UsedSASprocedures for Importing and Exporting data to MS-Excel
• Modified/developedSAScodes for data cleaning and Reporting and to support routing processing.
• Developed efficient, well-documented, readily comprehensible and modifiableSAScode usingSAS/ Base andSAS/ Macro facility.
• IntegratedSASdatasets into Excel using Direct Data Exchange, usingSASto analyze data, statistical tables, listings and graphs for reports.
• UsedSAS/ ODS to format HTML and RTF reports.
• SASmacros for data cleaning, reporting and to support routing processing.
• Created and maintained ad hocSASprograms/Macros for the validation, Extraction, Presentation, manipulation, analysis, and reporting.
• Console and verified its flow using SAS flow manger
• Proficient in working different databases environment such as MS SQL server and Teradata
• Optimized existing code for efficiency and automation ofSASPrograms to improve reporting efficiency.
• Report generation using manySASprocedural statements,SAS/MACROS, and data null steps.
• SASwas used for pre-processing data, SQL queries, data analysis, generating reports, and statistical analysis.

Environment: BaseSAS, MacroSAS,SAS/Graph,SAS/Stat,SAS/SQL,SAS/Access,SAS/EG, SAS/Connect,SAS/ODS, UNIX (VI Editor, Shell Scripts), Microsoft Excel, Oracle