SUMMARY

• Over 5+years of experience in Statistical Analysis, Reporting.
• Domain knowledge of Insurance, Financial and Banking industries
• Experience in handling complex processes using SAS/BASE, SAS/MACROS, SAS /SQL, SAS/GRAPHSAS/STAT, SAS/ODS, SAS/ACCESS,SAS Enterprise Guide.
• Development and Customization of SAS programs for Extraction, Transformation, Loading (ETL) and Data Analysis.
• Strong SAS/ACCESS experience to import data from various databases like MS - SQL Server, ORACLE tables into SAS using IMPLICIT and EXPLICIT pass-through facilities.
• Technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management experience. Produced Tables, Listings and Graphs (TLG) for the analyzed data.
• Used SAS DIRECT I/O for large datasets to achieve higher read-write speeds on SAS Dataset processing.
• Produced data in various output formats including HTML, RTF, PDF and PS using SAS ODS..
• Strong ANSI SQL experience in tuning code using techniques like Temporary tables and Indexes.
• Experience with Advanced statistical modeling.
• Descriptive statistics experience and understanding of statistical terminology and concepts.
• Experience in writing test cases, conducting testing, Data quality evaluations and verifying results (peer review).
• Experience in updating and creating documentation of code, guidelines, and high level systems documentation.
• Experience with Gathering requirements from end users.
• Mentored other team members by knowledge transfers, conducting one-on-one in SAS and SQL.
• Exceptionally well organized. Ability to quickly adapt to new applications and platforms.
• Strong work ethics, positive attitude, analytical and communication skills.

TECHNICAL SKILLS

• SAS/BASE
• SAS/MACRO
• SAS/ACCESS
• SAS/SQL
• SAS/GRAPH
• SAS/STAT
• SAS/ODS
• SAS Enterprise BI Platform(EBI)
• Enterprise Guide
• C
• JAVA
• ANSI SQL
• PL/ SQL
• Javascript
• Windows
• PHstat
• FactSet
• Toad for Data Analysts
• Active Batch Scheduler.

PROFESSIONAL EXPERIENCE

Confidential, New York

SAS Programmer

Responsibilities:

• Involved in writing code using Base SAS & SAS/Macros to extract clean and validate data from oracle tables.
• Created SAS datasets in local SAS directory using SAS DI (Data Integration) through different transformations.
• Extensively used SAS/STAT to perform analysis of variance, multivariate analysis of variance, and repeated analysis of variance.
• Created tabulate reports using Base SAS & SAS/Reports procedures.
• SAS/SQL was used for pre-processing data, SQL queries, data analysis, generating reports.
• Created SAS views from Oracle database tables using SAS/Access and writing SAS programs using Base SAS and SAS/Macros to create SAS reports.
• Designed flowcharts indicating the input data sets and the techniques that would be used (sorting, merging, etc.) to get the desired output..
• Created Different Models using Enterprise Miner (Predictive etc).
• Connect with different databases using SQL Pass Through.
• Creating ad-hoc reports.
• Scheduling batch Jobs.
• Used SAS ODS to create HTML, RTF and PDF outputs files in the process of producing reports.
• Used SASPROC SQL Pass through Facility to work with Oracle database.
• Retrieving Millions of Records Using different Procedures.
• Writing JCL statements (JOB, EXEC, and DD) statements.

Environment: SAS 9.1.3/9.2/Base, SAS/Macro, SAS Enterprise Guide4.0, SAS/CONNECT, SAS/Share, SAS/Access, UNIX, UDB, DB2, ORACLE 10g, SAS DI, SAS Enterprise Miner, Main Frame (MVS).

Confidential, Watchung, NJ

SAS Programmer

Responsibilities:

• Used PROC/SQL to fetch tables from Teradata warehouse.
• Merged tables by using PROC SORT.
• Random sampling using PROC SURVEYSELECT.
• Performed logistic regression on each variable and then delete the redundant ones.
• Used APPEND to generate the outcome variable table.
• Checked outliers and missing values using PROC UNIVARIATE and PROC FREQ.
• Macros were employed for data transformation and filling up missing values.
• Performed logistic regression on newly selected variables.
• Created LIFT probability table and GAIN chart.
• Model monitoring and verification

Environment: UNIX /Windows, SAS/BASE 9.2, SAS/STAT, SAS/ODS, SAS/GRAPH, SAS/REPORT, MS Excel, Essbase, SQL.

Confidential, Kansas City, MO

SAS Programmer

Responsibilities:

• Used PROC SQL Pass-through facility and Oracle DB Load procedure for data transfer
• Created SAS views from the tables in Oracle database using SAS/ACCESS.
• Involved in the data transfer and data conversion from one platform to the other (SAS to Oracle, Oracle to Excel) and the obtained data was used for further analysis.
• Extensively used statistical procedures like UNIVARIATE, SUMMARY, TABULATE, MEANS.
• Modified existing SAS programs using SAS/MACROS to improve the performance and enhance the data quality and developed numerous decision support reports in a distributive environment for the management department.
• Manipulated data by using MERGE, APPEND, CONCAT, SORT PROCs and generated the reports.
• Generated graphs using PROC GPLOT through SAS/GRAPH and the SAS Graphic Editor.
• Developed efficient, well-documented, comprehensible and modifiable SAS code for ad-hoc jobs using SAS/BASE and SAS/Macro facility.
• Validated data by checking data distribution and by comparing it to a standard data.
• Ran SAS report programs to generate weekly/monthly/annual reports and exported the results to Excel for further analysis.

Environment: SAS V8, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SQL, PL/SQL, Windows 2000

Confidential

SAS Programmer

Responsibilities:

• Extracted data from the company database with PROC SQL and generated new tables with keyword JOIN.
• Modified existing data sets using SET, MERGE, MODIFY, UPDATE and conditional statements.
• Utilized PROC DATASETS to list detail information for all the variables
• Checked outliers and missing values using PROC UNIVARIATE and PROC FREQ.
• Employed macros to improve coding efficiency.
• Designed customized formats for each report with PROC FORMAT.
• Generated market campaign performance reports with PROC REPORT.
• Translated descriptive business language of market campaigns into standard coding language which could be further processed by the technology team.
• Collaborated with the marketing team and technology team to fulfill more than 100 real-time marketing campaigns.

Environment: Windows, SAS/BASE 9.2, SAS/STAT, SAS/ODS, SAS/GRAPH, SAS/REPORT, MS Excel, SQL.