SUMMARY

• Over 7+ years of experience working in various domains as SAS Programmer and Administrator
• 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. Have Health Care Domain Knowledge.
• 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.
• 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.
• Strong knowledge of the operating systems that SAS is installed on like its memory management, file system Architecture, CPU utilization etc.
• Excelled in Change Management procedures, problem management procedures and version control for SAS code
• Experience in Data Analysis, Data Requirement Analysis, and Data Mapping for ETL process
• 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
• 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 CVS, EXECL, and ASCII.

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

SAS Administrator

Responsibilities:

• Successfully upgraded the SAS maintenance level from SAS 9.3 M2 to SAS 9.4 M3 on the server tier and mid-tier.
• Successfully migrated from SAS 9.1.3 to SAS 9.2 including SAS Enterprise Business Intelligence tools likeE-Miner, Enterprise Guide and Web Report Studioon Solaris operating system.
• Created scripts for restarting the server and mid-tier, which checks the availability of the online SAS Portal and sends in an email to the SAS Admin group if the SAS Portal is not responding.
• Installed and tested hot fixes for SAS 9.3 & SAS 9.4 M3.
• 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
• Monitoring of SAS Servers to ensure the performance.
• Excelled in Change Management procedures, problem management procedures and version control for SAS code.
• 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.
• Hands on experience in scheduling software version upgrade task on client servers and license renewing.
• Experience in interacting with SAS Technical support and opening tickets about issues when required.
• 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
• Ensure user's new library requests are considered and create libraries according to their project needs by using SMC and test their libraries from Enterprise Guide with a through test process.
• 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
• Build Knowledge base articles for SAS while troubleshooting on day to day basis and update in share point portal for future s

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 EBI Developer/Analyst

Responsibilities:

• Expertise in dDesign, implementation, testing of Loans, Deposits feeds into Netezza.
• UsedSASDI Studio to extract data from Oracle, Teradata and SQL server.
• Creating Jobs Using multiple transformations like Extract, Append, SQL Joins etc.
• CodingSASprograms with the use of BaseSASandSAS/Macros for ad-hoc jobs.
• Developed web-based reports, scorecards, and dashboards usingSASInformation Delivery Portal, Web Report Studio, BI Dashboard, Stored Processes, andSASServer pages
• Created OLAP cubes usingSASOLAP tools for the creation of dashboards and drill-through web based reporting.
• Developed methods to streamline analysis and present business critical information through a combination ofSASBI dashboards and web-based reporting
• Developed a stored process to selectively import users from MS Active Directory toSASMetadata
• Implemented group based authentication on the newly migrated SAS environment by developing a batch script.
• Developed ETL processes extracted data daily from Mainframe DB2 and ORACLE Databases, and loaded data into aSASbased Decision Support Warehouse
• Data mining process usingSASEM / SEMMA (sample, explore, modify, model and access) scheme, and predictive analytics and report writing usingSASEnterprise Miner,SASEnterprise BI guide,SASBASE 9 andSASreporting tool
• Targeted the completion of SAS application migration from the existing environment within 90 days by working closely with the Project Manager.
• Provide guidance and assistance to SAS Developers on operational and technical issues; interfacing with the SAS Institute for Support on administrative and system issues
• Occasional after hour support when system OS and hardware maintenance and applying SAS hot fixes and upgrades occur.
• Delivered all theSAScode, reports and testing result on time as per the schedule.
• PCSASmigration from 9.1.3 to 9.2 and 9.3 and also to EG 4.3
• Installed SAS 9.2 using site specific plan file Worked very closely with SAS Cary and used Plan file while implementing the new SAS 9.2 installation and achieved success in all SAS components while performing their sub-sequent test analysis both from Server side and SAS Client side by using SAS Enterprise Guide and SAS Base in Unix environment.
• Performed post installation procedures to make sure SASROOT file systems point to the new 9.2 installation by exporting external Database client installations
• Customized implementation of SAS Batch scripts to make jobs run via Auto systems
• Environment: SASAML 5.1, Oracle 11g, Netezza, Secure CRT 5.0,SASEG 6.1,SASE miner 6.2SASVisual Analytics 6.2, UNIX-AIX 5.3/AIX 6.1,SAS9.4/SAS9.3,SASFraud Framework, Modelling using Decision Tree, Regression, Logistic Regression & Neural Network, Ms. Excel EBItools( OLAP cube, Information Map Studio, Information Delivery Portal, AMO,SASManagement Console (MetaData),SASPersonal Login manager, Work flow Manager,SASDashboard, Web report Studio, Stored process and SPDS),SASBase,SASSQL and Macros, SSIS, SSAS

Confidential, CA

SAS BI 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
• 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
• Promoted SAS/Access Interface to Oracle, SQL server and Teradata on the newly built SAS 9.2 setup by reconfiguring SASROOT 's host specific files and tested with the SAS end user community.
• 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 Integration Studio, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access
• Performed competitor and customer analysis, risk and pricing analysis and forecasted results for credit card holders on demographical basis
• 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

SAS Developer/Analyst

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.
• Used LIBNAME, PROC IMPORT and SQL PASSTHRU FACILITY to import data from Oracle database into SAS files
• 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.
• Test modeling methodology and validate models PC/SASv9.1.3, SASv9.1.3 on Windows, AS/CONNECT,SAS/AF w/frames,SAS/ETS, Forecast Studio, and Forecasting Server, Oracle 9i, Enterprise Miner, Enterprise Guide, SQL*Plus, TOAD,SASMacros, Microsoft Windows products, all MS Office Suite products
• 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
• 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.