SUMMARY

• Over 7 Years of working experience as a SAS Administrator/Programmer in Financial, and Retail industries.
• SAS Administrator/Programmer with extensive knowledge of different financial models, projections, DSS Decision Support Systems and documentation.
• Extensive experience in developing and administrating 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 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.
• Used SAS Operations research to accomplish goals related to research.
• 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.
• Developed Reports in different Formatted files PDF, RTF, HTML… using SAS/ODS.
• Knowledge of Statistical procedures like Anova, Ancova, Covariance and Logistic Regression.
• Knowledge of Metadata servers connecting using SAS/Connect.
• Performing forecasting without writing any codes through Forecasting Server.
• As to use in SAS and oracle database, design new efficient software which applicable to quantitative data sets.
• Analysis the fraud and risk analysis by using SAS Fraud Management.
• Used SAS Scalable Performance Data server (SPDS) to retrieve data from server on to the system for analysis.
• 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 11i, 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 Intelligence Platform, SAS Management Console, 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, Philadelphia, PA

SAS Administrator /Analyst

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.
• Providing technical and help-desk support.
• Solving many tickets on the spot and fixed issues.
• Monitoring the metadata server environment and SAS GRID environment.
• Installing SAS 9.3 software on large servers/multi-tier environments.
• Scheduling and automating the SAS jobs monthly using SAS EG scheduler task.
• Registering the developed SAS datasets in the SAS Data Integration studio Environment.
• Converting the reports into web reports using SAS WRS, published the reports and automated the process.
• Developing reports and summaries for presentation to business users and depict data graphically for inclusion in presentations.
• Developing various SAS reports for Survey project and involved in code reviews for all the developed reports.
• Involving in migrations, upgrades and performed version upgrades for both server and client components.
• Closely working with risk management as to optimize the performance and support by developing SAS Programs.
• Testing the analysis by using fraud management tool on SAS enterprise guide.
• Using Forecast studio as tool for forecasting the parameters.
• 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, Oracle, SAS Web Report Studio, SAS Forecast studio GUI, SAS Data Integration, Risk Management, Excel, BI server and SAS Enterprise guide, SAS/SQL, Unix OS, and SAS/Access.

Confidential, Woodlands, TX

SAS Programmer/ Administrator

Responsibilities:

• Developed and maintained existing SAS programs that were used for creating various reports, lists, etc. for regulatory submissions.
• Created analysis data sets and performed statistical analysis on raw data to achieve safety and efficacy objectives of the study using SAS procedures.
• Generated Tables and Listings using various procedures like Proc Freq, Proc Univariate, Proc Means, Proc Summary, and Proc Report as per table shell.
• Applied different SAS procedures and macros for data cleaning, conversion and integration.
• Generated, modified and used departmental Macros as per requirement.
• Produced Tables, Listings and Graphs for Integrated Summaries of Efficacy (ISE) and Safety (ISS).
• Performed validation on Tables, Listings, and Analysis Datasets through double programming using SAS Procedures like Proc Compare.
• Generated statistical significance values using various statistical procedures like Proc GLM, Proc Phreg.
• The programming, testing, and documentation of statistical programs for use in creating statistical tables and listing summaries.
• The programming of analysis databases (derived datasets) and transfers of data for internal and external clients and the programming of database quality control checks.
• Program the integration of databases from multiple studies or sources.
• Develop and plan programming documentation including plans and specifications, as appropriate.
• Provide advanced technical expertise in conjunction with internal and external clients, and independently bring project solutions to SP teams and the Statistical Programming department.
• Perform and plan the development, implementation and validation of new process technologies, macros and applications.
• Received different SAS transport files from Data managers. Used SAS program to convert SAS transport file to current platform.
• Provided technical and help-desk support.
• Solved many tickets on the spot and fixed issues.
• Installed SAS 9.2 software on large servers/multi-tier environments.

Environment: SAS 9.2, SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/SQL, Oracle9i, Windows 7/8.

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.
• Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
• 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 Administrator /Programmer

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.