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 Report Studio

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

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

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

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, San Jose, CA

SAS 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 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.
• Successfully upgraded the SAS maintenance level from SAS 9.2 M2 to SAS 9.2 M3 on the server tier and midtier.
• Involved in the process of planning for the installation of the SAS 9.3
• Created scripts for restarting the server and midtier, which checks the availability of the online SAS Portal and sends in an email to the SAS Admin group if the SAS Portal
• 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.
• Assisted in configuring web report studio and defining and creating SAS information maps for authorized users.
• Managed SASConnect server, Metadata Server, Object Spawner, OLAP server, Stored Process Server on the windows environment.
• 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.
• Experience in working with developers encountering issues while coding and testing existing programs using BASE SAS, SAS/MACRO, SAS/SQL SAS ENTERPRISE GUIDE.

Environment: BASE SAS v 9.2 & 9.3, SAS Enterprise Guide, SAS DI Studio, SAS Management Console, SAS Enterprise Miner, SAS Web Report Studio and SAS Stored Process

Confidential, CA

Sr. SAS Data Analyst

Responsibilities:

• Developed complex SAS Macros to simplify SAS code and effectively reduce coding time
• Performed complex statistical analysis using PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG and PROC ANOVA
• Created High level, low level and detail technical design specifications for the (SASData Flux) Data quality.
• Extensively performed Data Cleansing during the ETL’s Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros
• Carried out data extraction and data manipulation using PROC SQL, PROC SORT, PROC REPORT to create preferred customer list as per business requirements
• Developed programs usingSAS/Base&SAS/Macrosto extract data from oracle tables
• Prepared datasets by mining data from various data sources - SQL Server, DB2 usingSASBase,SASEG,SAS/Access,SAS/SQL procedure.
• Extensively used SAS procedures such as PRINT, REPORT, TABULATE, FREQ, MEANS, SUMMARY, TRANSPOSE and Data Null for producing ad-hoc and customized reports and external files
• Analyzed business requirements, transformed data, and mapped source data using the Teradata Financial Services Logical Data Model tool, from the source system to the Teradata Physical Data Model
• Wrote SAS programs in UNIX platform
• Developed Income statements & Balance sheets in MS Excel
• Extensively used SAS ODS facility to create customized reports in HTMLPDF,RTF
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools e.g., SAS Data Integration Studio, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access
• Created reports in the style format (RTF, PDF and HTML) using ODS statements and PROC TEMPLATE
• Performed Consumer profiling, Sales forecasting and testing of financial and business models
• Effectively prepared and published various performance reports and presentations

Environment: SAS/BASE, SAS/MACRO, SAS/ETS, SAS/CONNECT, SAS Business Intelligence, SAS Enterprise Guide, SAS Enterprise Miner, SAS Web Report Studio, SAS Data Integration Studio, SAS Information Map Studio, SAS Management Console, SAS OLAP & EBI Server, Teradata, DB2, ORACLE, SQL Server Windows XP

Confidential

Sr. SAS Developer

Responsibilities:

• DevelopedSASprograms to create a customer mailing list for Direct Mailing and Telemarketing.
• Extracted data from the database usingSAS/Access,SASSQL procedures and createSASdata sets.
• Experienced inSASBusiness Intelligence area and in-depth knowledge ofSASBI including OLAP Cube Studio, Web Report Studio,SASAdd In for MS Office, stored processes.
• CreatedSASdata sets by extracting data from Oracle tables via an ODBC connection using SQL PASSTHRU facility inSAS/ACCESS (and writing SQL queries).
• Involved in writing code using BaseSAS&SAS/Macros to clean and validate data from oracle tables.
• Conducted data investigation usingSASEnterprise Guide.
• Performed data cleaning by analyzing and eliminating duplicate and inaccurate data using PROC FREQ, PROC COMP, PROC UNIVARIATE, and macros in SAS
• Developed complex SAS macros to simplify SAS code and effectively reduce coding time
• Created reports usingSAS/ODS andSAS/views from oracle database tables into different formats like HTML and RTF.
• Modified Korn-shell scripts on UNIX to schedule the program to run twice in a month
• Worked on advance querying the database using SAS Enterprise guide in calculating and computing columns, using filters, manipulated and prepare the data for reporting and statistical summarization
• Created Pivot tables in Microsoft excel for the SAS DATASETS for further calculations
• Extensively used PROC SQL and SAS procedures such as PRINT, REPORT, TABULATE, FREQ, MEANS, SUMMARY and TRANSPOSE for producing ad-hoc, customized reports and external files
• Generated high quality reports in the form of listing, HTML, RTF and PDF formats using SAS ODS

Environment: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/CONNECT, SAS/GRAPH, SAS/ODS, MS Excel, Teradata, Oracle9i, UNIX, Korn-shell, Enterprise Guide

Confidential

SAS Analyst

Responsibilities:

• DevelopedSAScode to perform ETL (Extraction, transformation and loading) of data to createSAS database.
• Generated summary reports and frequency tables using baseSASprocedures
• Enhanced reports through the use of labels,SASformats, user-defined formats, titles.
• Created complex and reusable Macros. Extensively used existing macros and developedSAS
• Used LIBNAME, PROC IMPORT and SQL PASSTHRU FACILITY to import data from Oracle database into SAS files
• Reviewed the Business Requirement Documents and the Functional Specification.
• Extracting data from the database using SAS/Access, SAS/SQL procedures and to create SAS data sets for statistical analysis, validation and documentation.
• Performed data analysis, created reports with extensive use of BASESAS, macro andSASreports with the help of default procedures.
• Generated Graphical analysis usingSASReport andSAS/GRAPH.
• Modified and developed macros for report generation using SAS/MACROS as per the statistician requirements.
• Involved in modifying Legacy Data Warehouse SAS jobs to run on the MDW platform and execute SQL against the DB2.
• Executed the SAS jobs in batch mode through UNIX shell scripts.
• Involved in designing the project and process flow diagrams using SAS Enterprise Guide.
• Executed design, coding, testing, debugging, and documentation of multiple treatment and payment SAS programs for charge-off card data.
• Analyzed existing SAS scripts based on various platforms such as UNIX, Windows and Mainframe.
• Prepared daily, monthly, and ad hoc reports (by PowerPoint, Excel, pivot tables, and pivot charts, etc.), and present findings and recommendations to all levels of senior management.
• Automated SAS jobs running on a daily, weekly and monthly basis using SAS/BI and Unix Shell Scripting
• Design SQL query to select, create, append, and update database tables and views.

Environment: SAS 9.3, SAS/BASE, SAS/Stat, SAS/SQL, SAS/ODS, Excel, Windows, UNIX, Teradata, DB2, SAS Enterprise Guide.