SUMMARY:

• 7+ years of Extensive hands on SAS development and administration on Windows/Solaris/Linux/AIX environments.
• Expertise in using Teradata, Oracle, SQL and Db2 database systems
• Ability to work on multiple projects simultaneously and meet the deadlines as and when required.
• Experienced SAS Programmer in Analysis, design, development, testing and validating the applications.
• Experienced in Building SAS OLAP cubes, Futrix cubes, creating, and publishing the reports from the cubes using SAS Web Report studio and Futrix Web portal.
• Performed SAS programming on different platforms - Windows and UNIX, also having worked in data extraction, manipulation, transformation and loading for data warehousing, data analysis, testing, trending analysis and business driven data validation.
• Extensive experience in working with mortgage data. Great ability to understand the business needs and write sas programs efficiently based on the business requirements.
• Extensive experience in quantitative data analytics and reporting in financial services industry and Retail industry.
• Excellent installation, configuration and administration experience on FUTRIX 6.2/7.1 and Futrix Cubes.
• Experience in writing high efficient SAS code by using the SAS System options.
• Experience in working with SAS Enterprise Guide and SAS Rsubmit codes.
• Experience in scheduling the production jobs using crontab and shell scripts on Unix environments.
• Experience in using the TOAD for oracle and db2, Teradata Bteq and SQL assistant client tools
• Experience in writing efficient pass through PROC SQL codes in SAS
• Excellent experience in creating Excel pivot tables and reports. Experience in writing the stored process that can be invokes from excel in order to create on the fly reports.

TECHNICAL SKILLS:

Programming: SAS 9.x, SQL,SAS, C, C++

Scripting: Ksh, bash and perl

SAS BI Tools: SAS 9.1.3, 9.2, 9.3, 9.4 Base SAS, SAS Enterprise Guide 4.3/5.1/7.1/7.11, SAS Access to Oracle, SAS Access to DB2, Information Map Studio, SAS Web Report Studio, SAS OLAP Server, SAS OLAP Cube Studio, Data Integration Studio, SAS/Share, SAS Add-in for Microsoft Office & PC file server,Futrix

Operating System: AIX, Solaris, Red Hat Enterprise Linux & Windows Server 2003

Databases: Access, Teradata, Oracle, DB2, Sybase, Netezza. GreenPlum

ETL Tools: BTEQ, Fastload, Multiload, Fastexport, Tpump,TOAD

PROFESSIONAL EXPERIENCE:

Confidential

Technical Advisor

Responsibilities:

• Responsible for end user sas support on all the U.S Census department SAS servers.
• Responsible for building and maintaining all the prod/Dev/test instances that are working in US Census Department of Commerce
• Responsible for migrating all the 257 Linux RHEL 5 machine running sas 9.2 to RHEL 6 sas 9.4 environments.
• Responsible for migration all the 80 instances Window 2008 servers running SAS 9.2 to SAS 9.4 environments.
• Responsible for creating the monthly user remedy tickets reports to the higher management
• Responsible for checking the patch level and maintenance levels of SAS on all the Linux servers and apply the required patches and maintenance levels to the Linux server environments.
• Responsible for working and closing all user issues remedy tickets with in the required SLA
• Responsible for testing the new SAS windows client components on the Windows VDI environment
• Testing the new SID licensefor all SAS versions installed on VDI before deploying them into production.
• Working on SAS Foundation Linux RTM installations and validation the install after RTM deployment
• Testing the compatibility of SAS windows components with the windows servers.
• Working on generating the required plan files and response files for installing the SAS components on windows and Linux machines.
• Checking and applying the new SAS patches that are released from SAS based on the platform.
• Installed and configured SAS BI and non-distributed VA on Security Enabled RHEL 7 on LAB machine to perform the POC
• Configured SAS Environment Manager and enabled audit logging on all the SAS user activity on the server.
• Configured SAS Studio Mid-tier on the RHEL 7 servers.
• Configured SAS Metadata cluster using the Quorum topology in SAS 9.4.
• Implemented 10 node SAS GRID 9.4 on RHEL 6 HP DL 380P blade servers using GFS 2 SAN Storage mounts.
• Configured SAS metadata 3 node clustering using QUORUM topology and NFS storage mounts
• Migrated all the scheduled SAS Jobs from crontab on RHEL 5 servers to Sas Grid nodes and scheduled them using SAS Platform manager.
• Implemented High availability for SAS servers ( Object Spawner and Olap Spawner)
• Configured Grid launched workspace servers on SAS GRID 9.4.

Confidential

Mortgage Risk Analyst

Responsibilities:

• Contact person for the pool level Mortgage Loss Forecast statistical model and performed/responsible for:
• Implementing and executing the model for Baseline scenario and various other economic stress scenarios, including the CCAR scenarios and analyze the trend, summarize the results to different reports to be presented to the senior management.
• Developed a SAS code for the backtesting of the pool level model and responsible for providing and analyzing the Error% between actuals and forecast numbers.
• Calibration of the model. Conducted various tests on the model and compared and analyzed the accuracy of the model for each test.
• Automated the SAS code for the model run.
• Documenting the model run results to be presented to the JPMC Internal Audit team.
• Involved in providing macro-economic variables (HPI, UER, Interest Rates etc) to all the teams across entire Chase including for the CCAR submission.
• Involved in automating and converting the macro economic reports (from MS Excel to SAS) that are used to analyze the trends in the macro economic variables by writing macros in SAS.
• Responsible for the production process of the loan level loss forecasting models for Home Equity Loans and Mortgage loans for various scenarios and summarized the results and attended to various ad-hoc reports from the senior management.
• Developed SAS code for production process to get AVM property values for loans for finance team to estimate property values.
• Responsible for creating the input datasets for CCAR for entire mortgage portfolio.
• Responsible for the data validation and data sanitation check of Prime/Sub-Prime/Option Arm loans for the entire Chase mortgage portfolio.
• Responsible for pulling the mortgage data (loan delinquency data, property evaluation data, repurchase data, bankruptcy data, and foreclosure data) from different data sources in Teradata and Oracle and reconcile them with the mortgage Balance sheet for the entire mortgage portfolio.
• Developed a stored process for Mortgage Banking Decision sciences which will generate all the mortgage statistics for any mortgage property across the United States using SAS stored process which can be accesses by any one on the Chase Intranet
• Developed an automated tool using SAS code and complex macro to add users to metadata repository and have new ideas to enhance and develop a dashboard application to add the users to Metadata repository.
• Familiar with SAS procedures like Proc Means, Proc Freq, Proc Tabulate, Proc Report and Proc SQL.
• Helped the developers in setting up the stored process so that the parameters can be passed from HTML to SAS and vice versa
• Worked with Anti money laundering team to setup a portal and Educated the users on how to setup the hierarchy in the metadata to impose the required security on the application
• Did a class for the EBI users in AML team on SAS BI Dashboard and SAS WRS
• Upgrade Futrix compute servers from Futrix 6.1m 20 to 6.1 m23(CBRM) and 6.2 to 7.1(FARM)
• Install Futrix admin client on Remote admin server and deploy Futrix on the Web-sphere application server and configure Futrix web-tier

Confidential

Sr.SAS Administrator

Responsibilities:

• Responsible for SAS 9.2 Application Server under Window Server 2003.
• Manage SAS Metadata Server and ensure it’s up and running fine without any performance issues
• Responsible for taking regular backups’ of SAS Metadata Server repositories and Scheduled restart of SAS application Servers
• Responsible for managing SAS Connect server, AppServer, MetaServer, Object Spawner, Application Server on the Windows server environment.
• Responsible for maintaining the JBoss on the mid tier on windows server 2003.
• Responsible for day to day external database support for all the internal SAS Programmers/Developers as a SAS Administrator
• Responsible for all the production jobs that are running in Crontab, and Control-M and co-ordinate with Unix System administrators in ensuring all the jobs are running smooth
• Responsible to manage production support/maintenance issues of SAS 9.2 Application with 10 Tera bytes of Data
• Responsible for creating new libraries for upcoming small scaled projects to the end users in SAS Server using SAS Management Console (SMC 9.2)
• Responsible for creating new metadata definitions for the upcoming projects to the end users in SAS Server using SAS Management Console (SMC9.2)
• Responsible for end user’s Work space management and Disk quota
• Responsible for making the web based SAS services like Enterprise Miner Web based and Stored Process Web based connectivity has no performance impact on the Metadata server
• Responsible for implementing the production changes such as applying the patches upgrading the SAS products installation new SAS products on the server and license renewals
• Worked closely with SAS Support at Cary, NC in resolving the SAS server and user issues
• Installed and configured various client components like SAS Enterprise Guide, PC SAS, SAS

Confidential

SAS Consultant

Responsibilities:

• Responsible for card holder master data. This data contains all the information about Account Management. (Like Portfolio, statement, promise to pay, Authorization and data link files).
• Analyzed raw data, drawing conclusions & developing recommendations for Card holder Master data and identified unwanted and unused symbols/data in the Master data.
• Involved in data extraction from ZOOT files. The server will fed by 2 separate files extracts. These are from external data sources known as FD (First Data) which provide Zoot extracts (flat files).
• Responsible for validation of the data at both account level and acquisition level
• Assigned the tasks of designing and developing projects SAS programs like producing analysis datasets, summaries and reports in Account Management.
• Thorough grounding in all phases of data analysis, including definition and analysis of questions with respect to available data and resources, overview of data and assessment of data quality, selection of appropriate models and statistical tests and presentation of results.
• Provided programming and analytical support using UNIX and Window platforms.Handled the tasks of writing reports and manipulating data by using UNIX platforms.
• Wrote stored processes and that can be deployed on SAS stored process web application and generated direct links to storedprocess. When the data gets updated by opening the link generated will summarize the data and produce the reports in IE.
• Scheduled production jobs using the Crontab in solaris.
• Created pivot tables in excel and formatted depending on the report requirements from business managers
• Prepared power point decks from the reports as per the requirements from the business managers.
• SAS Enterprise Application Server 9.1.3 with SP4 to 9.2 Upgrade Experience
• Recently upgraded platform application from 9.1.3 on AIX and HP to 9.2 on Solaris 5.10 operating environment.
• Moved SAS Developers along with their BASE SAS code from 9.1.3 environment to 9.2
• Involved in transitioning application migration projects by separating groups within SAS hosted environments between two different hardware setups
• Involved in promoting SAS/Access Interface to Oracle, DB2, Teradata Servers on the newly build 9.2 setup by re-configuring its SASROOT host specific files and tested with SAS User community by working with separate groups
• Migrated all the Enterprise guide projects from 4.0 to 4.3 and all the Enterprise Miner projects from 5.3 to 6.1
• Worked very closely with SAS Cary and used a Plan file while implementing the new SAS 9.2 installation and achieved success in installing all SAS components while performing their sub-sequent test analysis both from Server side and SAS Client side by using SAS Enterprise Guide SAS Enterprise Miner, PC SAS 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
• Created small depots for each individual SAS clients which can be stored on the network. These are used for installing the SAS clients on the remote users (in SFO, Houston and India).

Confidential

System Administrator

Responsibilities:

• Responsible for managing SAS based tickets through Picasso for all end users (SAS developers/programmers/clinical associates) issues on a day to day basis
• Responsible for quota management from the SAS developers where there is a requirement for additional space allotment on the server side
• Daily account management requests for creating users/password reset activities/modifying the privileges of a user
• Upgrade of SAS patches for the existing deployment SAS version, Involved in Planned downtime for patch management as part of build procedures for SAS application server
• Responsible for Daily Server reboots
• Involved in Change Management activities as part of service deliver operations
• Ensure the Server administration of SAS support documents are updated with version control (IQ checklists, As per JnJ Compliance wire standards)
• Day-to-day users issues like adding users to groups in SMC and giving permissions for accessing libraries through SAS Enterprise Guide
• Responsible for over 40 Linux servers running version 4.x/5.x. Also responsible for an additional 80 Solaris and AIX servers (approx.) in a backup role.
• Configured administration and management of Users and groups and Perform Password reset requests
• Configured and maintained server and client systems with NFS & auto mount services
• Monitored system performance of Virtual memory, system events, swapping, and Disk utilization, CPU Utilization using monitoring like HP Openview, Nagios, and Tivoli
• Implemented ECM's (Enterprise Change Management) for version upgrades and patching servers