SUMMARY

• 7+ years of experience inSAS Development, Architecture & Administration. Extensive knowledge in large scale data analytics, using various databases on different platforms.
• Experience and knowledge 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 knowledge in Data Warehousing concepts.
• Experience with 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 with Load balancing optimization on Linux and Window environments.
• Worked on TERADATA and utility domains. Optimization of Queries in aTeradatadatabase environment.
• Excellent knowledge inHadoopArchitecture and its major components likeHadoopMap Reduce, HDFS Frame work, HIVE, PIG, HBase, Zookeeper, Sqoop, Oozie, Flume and Avro.
• Good understanding of the SAS Web tier and SAS Server Tier Architecture in GRID environment with 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 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
• SAS EG 6.1 (Enterprise Guide) with 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 the SAS configuration on each server machine and SAS integration with tools such as Active Directory
• Hands on experience using BI tools like SAS Data Integration Studio and SAS Marketing Operations Management. strong knowledge on SAS HPA architecture
• Experience in managingHadoopclusters using Cloudera Manager Tool.
• Strong knowledge of the operating systems that SAS is installed on like its memory management, file system
• Architecture, CPU utilization etc. Hands on Ad Hoc. hands on Data Ware Housing
• Strong experience and knowledge in using data like Demographic data, adverse event data, serious adverse event data.
• Converting 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 the 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 in 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 with security including PAM and LDAP/Active

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

SAS BI Administrator

Responsibilities:

• Hands on experience in SAS 9.4 installation on Linux 64 Unix grid environment along with clustered web tier with SAS Portal BI reporting.
• Performing SAS product installations with SAS Deployment Manager on users machines and assisting users in connecting to the SAS Grid servers from the required SAS product for their activities.
• Performed depot subset for client side tools using SAS 9.4 Depot Sub setting Utility.
• 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
• Managed SAS Metadata Server, ensured its availability without any performance issues and took regular backups of the repositories.
• Created new metadata objects using SASManagement Console 9.3 for projects to the end users in SAS Metadata Server.
• Administer and monitor the overall health of the SASplatform and data warehouse.
• Support several Business units with data request from the Analytics Data Modeling Repository.
• Responsible for Coordinating with several Vendors to provide the data for new model development.
• Responsible for Managing the Consultant Resources for Analytics.
• 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 SASStore Process, Web Report Studio, SASBi Dashboard and BI Portals for both dev. and prod environment.
• Worked on LINUX and SHELL SCIPTING. strong knowledge in Data Warehousing Concepts as well a integration with enterprise Control-M scheduling systems
• Established DB connections like Oracle, SQL server and Netezza connections from the grid.
• Responsible for making the web based SAS services likeEnterprise Miner Web based and SAS Stored Process Web Application connectivity and ensuring it has no performance impact on the SAS Metadata Server.
• Migrated SASdeveloped projects from 9.1.3 to 9.3 along with their base code.
• Migrated SASMetadata users from SAS9.1.3 to SAS9.3 and created new groups and ACL.
• Coordinated efficiently with Business Analysts, Application Architects, and Infrastructure teams in handling setup and maintaining SASservers.
• Hands on experience in scheduling software version upgrade task on client servers and license renewing.
• 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.
• Closely worked with SAS Experts at the time of SAS Installation and configuration performed on the SAS Grid Servers. Worked on Data Warehousing for developing dash boards for BA
• Experience in interacting with SAS Technical support and opening tickets about issues when required.
• Attending sessions along with users organized by SAS Experts about various SAS Products and clearing up the 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, San Jose, CA

SAS GRID 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 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.
• Expertise in leveraging SAS Grid Process to reduce run times and optimize the output in Risk assessment sectors
• 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, 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

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.