SUMMARY

• Over 8 Years of working experience as a SAS Administrator/Analyst in Financial, and Retail industries.
• SAS programmer with extensive knowledge of different financial models, projections, DSS Decision Support Systems and documentation.
• Extensive experience in developing reports for portfolio analysis, delinquency forecasting, originations strategy (integrating loan originations platforms from acquired companies), collections strategy, and repossessions strategy and performance analysis.
• Experience in providing business insights in customer segmentation, market analysis, forecasting, competitor analysis, product development & customer operations.
• Extensive experience with BASE SAS, SAS/Macros, SAS/ODS, SAS/SQL, SAS/Stat, SAS/Access, SAS enterprise guide, SAS Operations Research, SAS Web report studio and SAS Data integration in the Windows and UNIX/LINUX 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 SAS administration activities like monitoring server, administer logging, setting up and securing metadata folder and securing the SAS configuration on each server machine.
• Experience in following the company’s Standard Operating Procedures (SOP’s), BRS and FRS documents while developing the SAS programs to produce the reports.
• Extracting data from different sources (e.g. Oracle, Teradata, db2) using SAS/Access and experience in cleaning and resolving data issues as well as merging data from different sources into a single integrated dataset.
• Experience in creating ad - hoc reports in tight schedules using various SAS Procedures.
• Performed Validation and Verification on developed SAS programs and the Reports.
• Programming experience with SAS functions and SAS procedures such as Sort, Summary, Means, Freq, Import, Export, Contents, Print, Tabulate, Report, SQL, Transpose, Format, GPLOT, Chart, and Univariate.
• Experience in checking the readiness of the server for SAS software installations.
• Experience in installing SAS softwares like Size optimization, merchandise planning, merchandise intelligence and merchandise allocation.
• Applying the Hot Fix to the SAS softwares along with giving Kerberos authentication access.
• Experience in using SAS Management Console for creating users, user group and giving correct access for the specific user.
• Knowledge of Statistical procedures like Anova, Ancova, Covariance and Logistic Regression.
• Researched with risk managers to work on researching and diagnosing issues related to project.
• Created project presentations, documents which include designs, plans, results and some project requirements.
• Ability to work effectively both as an individual and as part of a team.

TECHNICAL SKILLS

Base SAS: Data Step, SAS procedures, Formats, Informats, Macros, Data Null Reports, SAS Functions, Descriptive Statistics, SAS ODS, Arrays.

SAS Procedures: Append Compare, Chart, Contents, Datasets, Copy, Export, Format, Freq, Import, Means, Print, Print to, SQL, Sort, Summary, Tabulate, Transpose and Univariate.

Databases: Oracle 10g, 11i, 11g, MS-Access, SQL Server, DB2

SAS Products: Base SAS, SAS/Access, SAS/Connect, SAS/Share, SAS/Graph, SAS-ODS SAS Add-in for MS-office, SAS Enterprise Guide, SAS Management Console, SAS Size Optimization, SAS Merchandise Intelligence, SAS Merchandise Planning and Allocation, SAS OLAP Cube Studio, SAS Application Servers, SAS Web Report Studio, SAS Information Delivery Portal, Scalable Performance data server (SPDS), SAS Operation Research, SAS Fraud Management.

Operating Systems: Windows 98/2000/XP, Vista, 7, 8/8.1 MS DOS, UNIX, LINUX.

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

SAS System Administrator

Responsibilities:

• Validating the LINUX servers by the doing pre-check like all user ID are created or not, correct python version, correct java version, correct file directories and their spaces requirements.
• Validating the C++ files like gcc, compat gcc, libXp, libXtst, libext are installed or not.
• Validating and changing the ulimits based on the requirement.
• Installing JBOSS on the LINUX mid-tier server.
• Using LINUX shell scripting for doing the validation and changes in the server based on the SAS software requirement.
• Installing and configuring Merchandise Intelligence Planning and allocation on LINUX servers.
• Installing and configuring Size Optimization and its component on LINUX servers.
• Installing the LOADMGR on the size optimization server for the extracting the data from merchandise planning server on the size optimization server and then transforming the data and loading it for size profiling.
• Running post installation scripts for the configuring the servers as per the specific environment design.
• Applying the Hot Fix to the server and rebuilding the web application on the merchandise intelligence mid-tier server.
• Creating the users, user groups and assigning specific access to the user based on the roles provided and maintaining the access control list (ACL’s) for specific region and environment.
• Setting up the kron jobs on servers for daily, weekly and monthly basis script runs.
• Installing client on the user’s machine
• Providing Kerberos authentication to the business users as to sign in using levi network credentials.
• Loading the data into the different server by using non-core scripts and validating it using exceptions files and log.
• Fixing the Control M characters in the shell scripts and debugging the servers log of JBOSS if any issue.

Environment: SAS 9.3 /9.4, Merchandise Intelligence 5.2/5.4, Size Optimization 3.2, SAS Management console, JBOSS, LoadMgr, Java 1.7.0.15/21 , Python 2.6.6, ksh, nmon, oracle 11g, Windows 7, Filezilla, MobaXterm, Linux 2.6.32.

Confidential, Philadelphia, PA

SAS Programmer/Administrator

Responsibilities:

• Retrieving the customer’s data from the Oracle database in to SAS environment using SAS/Access ‘SQL Pass through facility.
• Following business requirement document and communicated with the business user to know the type of reports to be developed and the data that has to be shown in the reports.
• Validating the customer’s data from Oracle and compared it with the sales force application data.
• Using SAS Enterprise guide for manipulating and modifying the data and for creating the datasets showing the customers data.
• Assigning tasks on server to the specific machine using SAS GRID server.
• Analyzed risk by using various risk management methods like time series models, scenario based stress testing, and tracking error volatility.
• Manipulating the data and modified the code wherever necessary using SAS functions and Proc SQL statements, formats, informats using SAS EG.
• Schedule and automating the SAS jobs monthly using SAS EG scheduler task.
• Registering the developed SAS datasets in the SAS Data Integration studio Environment.
• Using SAS EBI for integrating the databases, analyzing the data and reporting purposes.
• Developed various SAS reports for Survey project and involved in code reviews for all the developed reports.
• Involved in migrations, upgrades and performed version upgrades for both server and client components.
• Testing the analysis by using fraud management tool on SAS enterprise guide.
• Using SAS management console for managing different resources on the server.
• Communicating with the Business users promptly to know about the requirements and responsible for validating the reports before sending it to the business.

Environment: SAS 9.3 later upgraded to 9.4, Oracle, SAS Web Report Studio, SAS Forecast studio GUI, SAS Data Integration, SAS Management Console, Risk Management, Excel, GRID server, BI server and SAS Enterprise guide, SAS/SQL, Unix OS, and SAS/Access.

Confidential, Denton, TX

SAS Programmer/Administrator

Responsibilities:

• Extracted the customer data, marketing data related to customers from sources like Oracle, Teradata using SAS/Access ‘SQL pass through facility’ and libname statements.
• Modified and manipulated the data using Data step Programming, SAS functions and Proc SQL statements.
• Used Proc Sort, Set, Update and Merge statements for creating, updating and merging various SAS datasets
• Participated in marketing campaign-planning meetings with Marketing managers, Managers in order to develop and document campaigns specifications.
• Gathered Business Requirement specification, Table Specs and Functional specification documents and communicated with the marketing manager to know the type of reports to be developed.
• Used SAS/ODS to produce the reports in different formatted files.
• Created ad-hoc reports using various SAS Procedures, SAS/Graph and SAS/Stat.
• Developed reports using Proc Report, Proc Tabulate and Data null .
• Analyzed the data using Proc Freq, Proc Means, and Proc Summary.
• Maintained SAS server environment by install, setup, configure, migrate and maintain servers on oracle environment.
• Provided technical and help-desk support.
• Solved many tickets on the spot and fixed issues.
• Monitored the metadata server environment and SAS GRID environment.
• Install SAS 9.2 software on large servers/multi-tier environments.
• Provided end user support for SAS 9.2 GRID Platform.

Environment: SAS 9.2 later updated to 9.3, Oracle, Excel, BI Server and SAS Enterprise guide, SAS/SQL, Unix OS, UNIX Shell Scripting, SAS/ODS, SAS/Graph, SAS/Macro, SAS SPDS and SAS/Access.

Confidential, Dallas, TX

Statistical Programmer

Responsibilities:

• Extracted the customer data from sources like Excel, Oracle using SAS/Access ‘SQL pass through facility’.
• Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS, MS Access and Excel.
• Maintenance of large data sets consisting of millions of records, combining data from various sources in varying formats to create SAS data sets by using Set and Merge, joins for generating Reports and Graphs.
• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions and conditional statements and by writing SQL queries.
• Extensively used existing and newly created macros and developed SAS Programs for Data Cleaning, Validation and Analysis and Report generation. Tested and debugged existing macros.
• Applied Proc SQL debugger for investigating the run-time behavior of the code.
• Extensively used Data null, Proc Freq, Proc Tabulate, Proc Report, Proc Means, Proc Macros, Proc Summary, Proc Contents, Proc Compare, and Proc Univariate to produce the reports.
• Responsible to work on the Adhoc Requests.
• Attended project team meetings, and worked with the Statisticians.
• Created Tables, Listings by calling previous written Macros.
• Creating SAS datasets from tables in Database using SAS/Access. Retrieved the raw data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/Stat procedures.
• Created Transport files in .xpt format and submitted to the testing team.
• Prepared graphs using the modified data for analysis.

Environment: SAS, SAS/Base, SAS/Access, SAS/Macros, SAS/SQL, SAS/Graph, SAS/ODS, SPSS, Oracle 9i, UNIX OS, Enterprise IT system, Windows Vista/7, MS Access, MS Excel.

Confidential

SAS Programmer/Administrator

Responsibilities:

• Responsible for creation of tables and reports according to applicable SOPs as well as project’s Data Management Plan (DMP).
• Maintain portfolio performance monitoring reports for the consumer portfolios that form a part of the business.
• Responsible to integrate the new portfolios data into the reports.
• Developed dynamic SAS programs and produced Reports using Base SAS, SAS/Macros, and SAS/Stat & Graphs.
• Developed new SAS programs and modified existing SAS programs.
• Developed reports using Proc Report, Proc Tabulate and Data null techniques for analysis.
• Called several previous written SAS macros to create tables, and listings.
• Proficient in handling Program files, Log files, Listing files and Data sets.
• Extensive experience in Data Manipulation and Analysis using SQL Queries, Set, Merge and Update techniques.
• Maintained the machines on the server by configuring, updating and solving issues related to SAS.
• Created and maintained secure metadata folder structure.
• Implemented back-up and recovery strategy.
• Performed testing of new SAS releases in test prior to migration to production.
• Checked production jobs, makes corrections and reruns
• Created users and assign them role in the management console
• Performed manual testing on applications and Wrote Test Procedures to validate the key aspects of application.
• Generated reports on adhoc requests and Creation of transport files in .xpt format.

Environment: SAS, SAS/ODS, SAS/SQL, SAS/Macro, Excel, Oracle, UNIX, SAS Enterprise Guide, Window XP, MS Office.