SUMMARY

• Over 7 years of experience in programming, analyzing and reporting in various Banking, Healthcare, Insurance using SAS on Windows, Mainframe and Unix environments.
• Expertise in SAS/Base, SAS/Macros, SAS/SQL.
• Skilled in SAS programming, merging SAS datasets, preparing data, producing and validating reports, SAS formats, and managing data.
• Expertise in analyzing and coordinating audit data, generating reports and tables.
• Leverage technology and business process skills to generate innovative solutions to address client business problems.
• Created RTF, PDF, and HTML listings, tables and Reports using SAS/ODS.
• Sound knowledge of linear programming, probability, statistics, design of experiments, quality assurance, six sigma quality and optimization techniques.
• Substantial Knowledge of SAS - Business Intelligence, SAS Enterprise Guide 4.1/5.1, SAS Enterprise Miner 7.1, JMP 9, SAS OLAP Cube studio 9.1, SAS Information Map Studio 3.1, SAS Data Integration Studio 3.4 and SAS Management Console 9.1
• Created reports in SAS and exported to Excel spreadsheets, created web reports using Web Report Studio
• Strong experience with databases likeOracle, MS SQL Server, Teradata, DB2 and MS Access
• Profound knowledge and strong experience in Base SAS, SAS/Macro, SAS/ODS, SAS/Graph, SAS/SQL, SAS/Stat, SAS Share, SAS/IntrNet and SAS/Connect, SAS Enterprise Guide, SAS Enterprise BI Server, SAS Management console, Tomcat/ Apache
• Extensive experience in preparation of tables, listings, and graphs.
• Experienced in business terms like Basel compliance, equities, fixed income and risk management.
• Expertise in statistical, quantitative and analytical data in financial sector.
• Good at migrating SAS datasets and SAS applications from Mainframe =>UNIX <=>NT
• Experienced in producing external files and customized reports using various SAS procedures like Proc Print, Proc Report, Proc Tabulate, Proc Means, Proc Summary, Proc SQL, Proc Freq, Proc univariate, Proc transpose, Proc Rank, Proc Access and data Null techniques.
• Skilled at using basic and advanced RDBMS concepts, SQL, PL /SQL and UNIX commands.
• Experience in Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting
• Excellent Communication, Analytical and Interpersonal skills.

PROFESSIONAL SKILLS

SAS Skills: Base SAS, SAS/Macro, SAS/Connect, SAS/SQL, SAS/STAT, SAS/BI, SAS/Graph

Databases: Oracle 10g/11g, MS Access, MS SQL Server, DB2, Teradata

Programming Languages: COBOL, PL/SQL

Mainframe Tools: MVS/JCL, TSO/ISPF, MVS utilities

Web Technologies: HTML, XML, JavaScript, JSP, Cognos

SAS Procedures: Print, Transpose, Contents, Means, Chart, Plot, Tabulate, Univariate, Summary, Sort, Reg

Scripting: Korn, Bourne, Perl, and JavaScript

Operating Systems: Windows 8/795/98/00/NT, MVS, Unix

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

Sr. SAS Programmer

Roles and Responsibilities:

• Understanding the input and output flow, variables, join criteria of the source files for the data to be built.
• Participated in team Meetings and conference calls for Business understanding and knowledge sharing.
• Using Proc SQL to connect to Teradata and pull/derive the required fields.
• Used SAS macro function %SYSFUNC to invoke data step functions in SAS/base and SAS/Macros environment.
• Creating several summarized versions of data using Proc Means.
• Debugging and optimizing the code, making some test runs using FULLSTIMER option to verify the system resources.
• Using SAS Options like DROP, KEEP, COMPRESS=, OBS=, etc for efficient programming and storage space saving when needed.
• Creating new segmentation and add factors to score the data.
• Using Proc SQL to create SAS datasets from in-line views using joins and automate the code by embedding in macros.
• Creating pivot tables in worksheet to compare the data using summarized functions to check for any data discrepancies. Working on manipulating data to be used as input to Microsoft Excel.
• Involved in writing Unix shell scripting to automate the SAS jobs.
• Validation of large volumes of SAS datasets using Proc Freq, Proc Format, and create pivot tables to find any outliers in the data.
• Used Proc Compare to determine the changes occurred in the datasets by optimizing/enhancing the code.
• Using Proc Export to output data in spreadsheets at centralized locations.
• Using Proc Contents to find the metadata of the variables and use PUT and INPUT functions for character to numeric conversions and vice-versa.
• Used CALL SYMPUT with DATA NULL when required to create macro variables.
• Helping understand the calculated fields to the recipients of the data.
• Develop backtest datasets from the historic data for testing purposes.
• Provide the documentation for the developing backtest data.

Environment: SAS 9.2/9.3, Reflection X, WinSCP, Unix, Putty, SAS/ODS, MS Excel, SAS/SQL, Teradata Studio Express, SAS/Base and SAS/Macros.

Confidential, Foster City, CA

Sr. SAS Programmer/Analyst

Roles and Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS data sets for statistical analysis, validation and documentation.
• Used procedures such as Proc Freq, Proc Means, Proc Sort, Proc Print, Proc Tabulate and Proc Report.
• Developed new or modify macros for report generation using SAS / Macros as per the statistician requirements.
• Developed SAS programs for statistical analyses and data displays in SAS/base and SAS/Macros environment.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS.
• Extracted raw data from an Oracle database and used SAS/Access to read it and run statistical analysis using SAS/Stat.
• Involved in modify 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
• 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
• Involved in designing the project and process flow diagrams using SAS Enterprise Guide
• Design, coding, testing, debugging, and documentation of multiple treatment and payment SAS programs for charge-off card data.
• Involved in using Forecast Studio for analyzing forecast models.
• Involved in Physical modeling on Teradata such as creation of tables, indexes and views
• Analyzed existing SAS scripts based of off various platforms such asUnix, Windows and Mainframe.
• Also worked on analysis ofJCL scriptsforIBM MVS Mainframesto understand differentProcs and Jobsexecuted.
• Prepare 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.
• DevelopSASand VBA macros for automating the analysis, process, and report generation.
• Wrote SAS reports to Excel, the SAS content server, HTML, and PDF
• Automated SAS jobs running on a daily, weekly and monthly basis using SAS/BI and Unix Shell Scripting
• Wrote stored processes to be used through the SAS Information Delivery Portal
• Review and modify SAS Programs, created customized ad-hoc reports, process data for publishing business reports; automate and distribute designed business reports on schedule in various format.
• Extensively used Proc SQL for highly advanced matching and merging between large datasets.
• Frequent Use of functions and Proc Format.
• Created reports in the style format using ODS statements and Proc Template.
• Design SQL query to select, create, append, and update database tables and views.
• Developed numerous ad-hoc SAS programs to create summaries and listings.
• Created SAS Macros and SAS Graphics. Customize the existing programs using macros as per the statistician’s requirements
• Generated SAS customized reports using the DATA NULL and Proc Report techniques.

Environment: SAS on Mainframe, SAS 9.3, SAS/BASE, SAS/BI, SAS/Graph, SAS/Stat, SAS/SQL, SAS/ODS, Excel, Oracle 10g/11g, Windows NT, Unix, Teradata, DB2, SAS Enterprise Guide 5.1, Forecast Studio.

Confidential, NYC, NY

Sr. SAS Developer/ Analyst

Roles and Responsibilities:

• Design and develop, efficient tool for data integrity tracking.
• Maintained performance reports, creation of reports (using web report studio) for online and batch application of various server and Involved in preparing executive Dashboards for senior level management
• Used SAS, SAS Macros, Procedures like SQL, Freq, Univariate, Summary, Means, Transpose, Arrays, Tabulate, and Sort to extract data, prepare integrated data base and its analysis
• Extracted data sets from server using Proc Import and created datasets in SAS libraries. Coding SAS programs with the use of SAS/Base and SAS/Macros for ad-hoc jobs
• Developing CDIT and in Unix environment using SAS tools.
• Reporting Scripts and SAS jobs will be modified to connect to DB2.
• Responsible for generating Financial Business Reports using SAS Business Intelligence tools (SAS/BI) and also developed ad-hoc reports using SAS Enterprise Guide.
• Teradata tables and created Logical and Physical Data Models using Erwin design tool.
• Used various Tagsets options in SAS ODS Mark up engine (Excel XP, MS office, MSoffice2k) to deliver the Formatted EG reports as XML /HTML sheets that could be opened with Excel directly.
• Created Custom Stored Compiled Macro’s to help Analysts export ‘formatted’ datasets to MS excel.
• Analysis, programming and creation of reports on existing strategies usingSASand SQL.
• Understanding various data sources to the GRMS (Global Risk Management System).
• Extracting data from Mainframe flat files using SAS Base and Macros.
• Configured SAS BI components and solved BI related issues.
• Revising a series of Oracle PL/SQL programs to SAS for extraction of data from Oracle in Enterprise Miner.
• Validating and profiling the variables using SAS Base / Macros using proc freq, proc means, proc format and proc univariate.
• Provided analysis, development, and testing for SAS programs using Teradata datamart to consumer and small business areas for market analysis.
• Created batch and interactive applications utilizing SAS/Base, SAS/SQL, and SAS/Macros.
• Daily generate consolidated reports and alerts using SAS.
• Sending automatic sigma / control chart based alerts from Unix system to Lotus notes using Base SAS, Macros Language and data null .
• Developed various SAS / AF screens to publish the SAS Datasets and reports / graphs.
• Developed programs to create daily HTML reports using ODS and CSV reports using Proc Export.

Environment: SAS on Mainframe, SAS/Base, Macros, SAS Access, SAS AF/SCL, SAS Enterprise Guide, Enterprise Miner, SAS/BI, SAS/Connect, Teradata, DB2, MS excel, SQL, Web Report Studio and Unix Crontab

Confidential, MN

SAS Developer

Roles and Responsibilities:

• Participated in business requirement walk through, design walk through and analyzed Business requirements.
• Extraction of data from Oracle, created into datasets. Performing data validation, transforming data from RDBMS oracle to SAS datasets.
• Done Enhancements for the existing business reports like incorporating new business variables.
• Developed, modified, and generated Monthly Business Review (MBR) reports summarizing business activity.
• Uploading data into the warehouse application on monthly basis.
• Worked closely with data modeling team and management like Marketing managers, Campaign managers, financial managers etc., to analyze customer related data, generate custom reports, tables and listings.
• Worked extensively in sorting, merging, concatenating and Dynamic Formatting as optimized technique for SAS data sets.
• Automated SAS jobs running on a daily, weekly and monthly basis using SAS/BI and Unix Shell Scripting
• Extensively used Base SAS- ETL to load data from SQL server, oracle, Flat files and sources to Oracle Data warehouse as target.
• Worked on Source and Target Metadata creation and developed many jobs to load data from source into target
• Extensively used various types of transformations such as Expression, Aggregator, Filter, Joiner, Update strategy and Lookup (Connected and Unconnected) to load the data.
• Extensively involved in designing and developing of Star Schema Model for Data Store.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time with required frequency.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: SAS/Base, SAS/Macros, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/ETL, Unix, Oracle DB2, MS SQL Server 2000, Windows XP.

Confidential, Stamford, CT

SAS Programmer

Roles and Responsibilities:

• Involved in migration of data from Informix on SunOS 5.8 to DB2 on AIX 5.3 and validation of mainframe jobs, Unix jobs, SAS Reports, History data, other scripts, and programs from the Legacy Data Warehouse (LDW)
• Using Korn shell scripts execute SAS jobs that move data from Informix to SAS MDDBs or SAS datasets.
• Responsible for migrating the korn shell scripts, which will perform the Extraction Translation and Loading of data.
• Responsible for establishing the connection to data base in the new environment.
• Optimizing the shell scripts according to the EDW requirement.
• Rewriting the SQL quires with the new table structure.
• Generate Multi-dimensional data databases (MDDBs) within SAS OLAP Server
• Created survival graphs in Excel by transporting SAS data sets into Excel spreadsheets.
• Responsible for importing, manipulating and generating weekly and monthly list reports using SAS Enterprise Guide
• Generate reports that are posted on DirectNet where they are accessible by users SAS jobs are categorized as Production.
• Building of generic utility processes for large volume sort, sort/summation, and Unix batch SAS execution
• Created final reports in Excel sheets which were then accessed by the business users.
• Production jobs are built by placing as SAS procedure within a Korn shell script that is then executed via JCL and through CA-7 scheduler.
• SAS jobs are typically written within SAS using Pass-Through SQL that is executed against the database via SAS/Access.
• Developed Daily, Weekly and Quarterly reports for each service.
• DATA NULL was used for developing custom reports.
• ODS is used for generating HTML files.
• Production Support, troubleshooting problem solving.
• Extensively used Proc Means, Proc Freq and Proc Summary.

Environment: SAS/Base, Mainframe, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/IntrNet, SAS/Share, SAS/Connect, SAS Macros, SAS/Access, SAS Enterprise Guide, Sync sort, Oracle 8i, SQL, (IBM AIX V5.2),CVS, Unix, DB2, Excel, Sun Solaris, Windows NT, MS Office, and HTML

Confidential

SAS Programmer

Roles and Responsibilities:

• Service clients in claims, billing, marketing, and sales who submit their projects to our Project Register.
• Develop and maintain applications and databases by evaluating client needs, analyzing requirements, and developing software systems.
• Provide information for statistical analysis by planning data collection, analyzing and interpreting data, and applying statistical methodologies.
• Extract data from DB2, IMS, SAR reports and SAS data sets. Base SAS 8.2, SAS Macro, SQL, and JCL in an IBM mainframe production
• Involved in code changes for SAS programs and Unix shell scripts
• Produced data extracts for various departments and outside vendors
• Imported data into the company SAS data warehouse
• Wrote common macros that are used across multiple applications
• Generated reports in HTML, PDF or RTF formats according to business specifications
• Created ad-hoc reports and tables for information delivery and data management departments
• Worked closely with the development teams to replicate end user issues.

Environment: SAS/Base, SAS Enterprise Guide, SAS /Macros, SAS/SQL, SAS/Access, Mainframe, ES9000/MVS, S/390/OS/390, Oracle, DB2, Windows 2000, MS Access, and Unix Sun Solaris (Korn Shell).