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/ODS,SAS/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 Programmer/Analyst

Responsibilities:

• Analyzed various database containing sales, titles, account, region etc. data of the releases of various titles.
• 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.
• Imported raw data files in excel format inSASand subsequently createdSASDatasets and performed data manipulations on the datasets.
• Cleaned existing data and converted them into usefulSASDatasets, merged datasets and created reports based onAd-hoc requirements.
• Extensively usedPROC SQLandSELECT sub-queriesto generate various reports by connecting to the Teradata DB.
• 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.
• UsedSAS EBIsuite for creating, managing reports.
• ImplementedOLAP cubes, OLAP tools and other report tools like Web Report Studio.
• Initially created tables and views inTeradataand used aBI/Querymodel for local users to access the data tables and reports.
• Communicated with various personnel in the forecasting group and the statistical group for various requirement gathering and analysis of the data.

Environment: SAS/Base, SAS/STAT, Teradata, SAS/SQL, SAS 9.1.3, Windows XP Professional, SAS/Macro, SAS/Access, SAS/STAT, SAS ODS, SAS/GRAPH, SAS/IML, SAS/ ETL, SAS BI, Oracle 10g, Teradata, SAS V9.1.3, SAS Views, SAS Enterprise Guide, SAS/DI studio 4.2, Management console, SAS/information mapping, Excel, Windows XP, UNIX.

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
• Developed end-to-end reporting based on business requirements.
• Solved complex issues and implemented solutions to enhance productivity, improve quality and customer satisfaction.
• Developed programs usingBASE SAS, SAS/SQL and SAS MACROSto generate new reports.
• Programmed inSAS for the development of a large reporting System using SAS/ACCESS to accessing DB2 relational tables.
• 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 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.
• Build Predictive Logistic Regression, Tree, and Neural Network B-to-B Analytic Churn Models with Enterprise Mobility Network Data, Corporate Revenue Data, and Corporate Market Research Data.
• Present All Findings to Client. Model Lift Gains Charts Consistently Exceeded Expectations
• Integrate Millions of Records from Numerous Databases into One Comprehensive Database.
• Usage of SAS, UNIX, Korn Shell Scripting, ORACLE 10G, Teradata, SQL, SAS Enterprise Miner, Tibco Spotfire Miner, FTP, R, S, Python, Awk, MS Excel Pivot Tables, PowerPoint, Irfanview.
• Develop, Document, and Train Staff on Computer Programming Algorithms and Business Processes.

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.