Professional Summary

• Certified SAS Professional with hands on working experience in Banking, Financial and Healthcare industries.
• Proficient in developing and debugging SAS/MACROS to access, extract, modify, merge, and analyze financial data other SAS application for data updates, data cleansing, and reporting.
• Working experience in SAS Access, SAS Connect, SAS/AF, SAS/ETL, PROC Reports, SAS ENTERPRISE Guide in Windows and Unix environments
• Worked closely with Business in gathering requirements and understanding the metrics required for generation of Reports, List out puts for Marketing teams.
• Experience working with SAS Web Report Studio
• Experience in preparation of reports, listings, tables and graphs using various SAS Tools like SAS/Base, SAS/Graph, and Procedures such as Sort, Means, Summary, Freq, Print, Report.
• Wide-range experience in data manipulation and generating customized reports with SAS data steps and procedures.
• Created views in Oracle with SQL and using TOAD.
• Well versed with creating HTML Reports for financial data using SAS ODS facility, proc report and sql pass thru facility.
• Experience in performing ad hoc queries and User Acceptance Tests UAT for various application and reports on a daily/weekly or monthly basis.
• Worked on Enterprise Miner for developing Predictive Models.
• Possess statistical knowledge of descriptive models including various sorts of mixed models and predictive solution models including linear, multiple, polynomial and non-linear regression model.
• Experience in configuring Data Marts using enterprise BI Administration.
• Extensive experience in RDBMS like Oracle, SQL Server, Db2, MS Access.
• Hands on experience working with OLTP, OLAP Cube Studio, SAS Enterprise Business Intelligence Server SAS/EBI and SAS Information Map Studio
• Used ECM tools Remedy, and CVS to trace development, testing, and production SDLC phases
• Excellent organizational and communication skills.
• Experience in transforming business requirements to Functional Specs and User Stories for Web pages, Reports, Dashboards and Web Analytics.
• Worked with Data Flux to manage data in datawarehouses.
• Extensive preparation of Ad-hoc reports.
• Experience in working with SAS Enterprise Guide Software for reporting and analytical tasks
• Demonstrated high energy, professionalism, strong problem solving, decision-making and interpersonal skills. Possess leadership skills as well as the ability to work independently and on a team. Strong verbal and written communications skills.
• Possess strong ability to quickly adapt to new applications and platforms
• Ability to work in self-directed environment and Very good team player with excellent analytical and problem solving skills.

Skills

• Statistical Software: SAS 8, SAS 9, SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACRO,
• SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/ETL.
• Business Intelligence: SAS DI Studio, SAS OLAP Cube StudioSAS Management Console, SAS Enterprise Guide, SAS Web Report Studio, Add-In to MS Office, SAS Information Map Studio, SAS stored process
• Programming Languages: C, SQL, Java
• Database:MS Access, Oracle 10G/9i/ 8i, Sql Server 2000/2005/2008, UDB, Teradata.
• Word Processors:MS Word, Open Office, Page Maker.
• Other Applications:HTML, FrontPage express, Power Point, Futrix, Spotfire.
• Operating Systems: UNIX, Windows 9x/2000, XP, NT

WORK EXPERIENCE

Confidential

SAS Programmer/ Statistical Analyst

Responsibilities

• Involved in automation of reports in various formats like pdf, html and excel reports.
• Using the EG Stored Processes, updating and developing macro programs code.
• Developed Unix Korn shell scripts to automate recurring processes and routine administration tasks.
• Conducted QA for macros generated by other programmers using Macro options MLOGIC, SYMBOLGEN, MPRINT, MACROGEN etc.
• Validating data and creating reports using different procedures like PROC FREQ, PROC MEANS, PROC TRANSPOSE, PROC DATASETS, PROC SORT, PROC COMPARE, PROC SQL, PROC REPORTetc. and SAS ODS facility.
• Created views in ORACLE using SQL and Tool for Oracle Application Developers TOAD .
• Created UNIXKorn shell scripts to export environment variables and deleted old files.
• Actively monitored software usage on all platforms, keeping them at optimal level for user querying.
• Conducted statistical modeling for both continuous and categorical data, including linear regression, nonlinear regression, ANOVA, GLM model, repeated measure, nonparametric regression, classification tree etc.
• Performed documentation of the SAS Code for the better understanding of the program

Environment: SAS/Connect, SAS/STAT,SAS/Graph,Oracle11g,Base SAS 9.2,SAS Macros, UNIX SAS, PC SAS, Oracle 9i, DB2, PL/SQL, MS Excel,TOAD, MS Access.

Confidential

SAS Programmer/ Statistical Analyst

Responsibilities

• Involved in automation of Excel reports using ExcelXPTagsets and MSOFFICE2k X Tagsets.
• Using the EG Stored Processes, updating and developing macro programs code.
• Design of ETL process to meet the requirement of data demand.
• Creating and maintaining required Data marts and OLAP Cubes using SAS DI
• Studio and SAS OLAP Cube Studio to fulfill reporting requirements.
• Production Job Scheduling using SAS DI Studio.
• Played a key role in data analysis and data modeling model design, development, and model implementation using SAS.
• Used procedures like PROC FREQ, PROC Means, PROC Sort, PROC Print, PROC Tabulate, PROC
• UNIVARIATE and PROC Report
• Conducted analysis of Web report Studio requirements from business community.
• Used SAS Information Map Studio to create logical mappings from reporting data.
• Extracted data from data from different data sources, transformed them through different stages and finally loaded into solution marts using DI studio.
• Scheduled jobs on a weekly and monthly basis using SAS Management Console.
• Created User Permissions using SAS Management Console.
• Migrated data from Development server to Production server using DI Studio,
• Created Efficient Reports and delivered it in the Web Portals using the Information Delivery Portal and SAS Management Console.
• Created various transformation procedures by using, SAS Cube Studio, SAS Data Integration Studio, and SAS Enterprise guide
• Worked with Business/IT Stakeholders to design develop SAS BI solutions including, data acquisition, datamodeling.
• Intensively worked on SAS Information Delivery Portal to create Dashboards.
• Involved in Data Validation, Transforming data from data sources to SAS Datasets using DI Studio.
• Designed and developed Web reports using SAS Web Report Studio.
• Involved in statistical Analysis using Segmentation Analysis, Regression Analysis and Predictive modeling.

Environment: Base SAS, SAS Macros, SAS/Access, SAS DI Studio 4.2, OLAP Cube Studio, Management Console, SAS Web Report Studio, Information Delivery Portal, SAS/ASSIST, SAS/STAT, SAS/GRAPH, SAS/IML, ORACLE, Teradata, SAS V9.3, SAS V9.2, Main Frames, Excel, Windows 7, UNIX.

Confidential

SAS Programmer/ Statistical Analyst

Responsibilities

• Involved in automation of Excel reports using ExcelXPTagsets.
• Attended various seminar presentations on Medicaid fraud such as finding duplicate claims, service after death, multiple service providers etc.
• Designed and developed Dashboards which enable users to monitor key performance indicators that convey the performance of the organization.
• Involved in taking regular backups
• Created Data Models for different level of Marketing based on the reports.
• Used DI Studio to process flat files on a monthly basis which are to be loaded to a SAS dataset for further reporting.
• Involved in writing code using Base SAS SAS/Macros to clean and validate data from oracle tables.
• Involved in developing various fraud algorithms and validated existing algorithms against specification
• Used SAS import procedure to generate temporary and permanent SAS data sets from txt, csv and excel data sets.
• Validating data and creating reports using different procedures like PROC FREQ, PROC MEANS, PROC TRANSPOSE, PROC DATASETS, PROC SORT, PROC COMPARE, PROC SQL, PROC REPORTetc. and SAS ODS facility.
• Involved in creating staging files and Target files for the Clinical Data Mart using SAS DI Studio.
• Extensively used statistical procedures such as ANOVA, Regression Analysis, Trend Analysis, Cluster Analysis and Principle Component Analysis
• Involved in migration from DB2 to Teradata.

Environment: Base SAS, SAS Macros, SAS/Access, SAS/ASSIST, SAS/STAT, SAS/GRAPH, Teradata,

SAS/IML, ORACLE, SAS V9.1.3, SAS V9.2, Main Frames, Excel, Windows XP, UNIX.

Confidential

SAS Developer/Analyst

• Prepared strategic business requirements and used accepted concepts, standards, SDLC methodologies, and toolsets.
• Worked with Data migration from legacy to new systems and worked with resolving all the data related issues.
• Provided support to resolve user account lockup, quota limit, file and directory access control issues and trained users with installation of SASEnterpriseGuide.
• Administered SASEnterpriseGuide, SAS Server and SAS Enterprise Miner, SAS/Connect, SAS/ETS, SAS/IML, and other components.
• Performed mapping operations as a part of project MORE to validate data conversion from FOCUS to SAS and locate the matching fields,records and data.
• Worked with OLAP generated data cubes to verify the analysis from the reporting environment.

Key responsibilities:

• Extensively performed data migration and large transactional data base applications by pulling millions of records from data source using Mainframe SAS application and partitioned the data into partitioned data sets PDS for lesser runtime
• Generated the List outputs for Marketing Teams that have the list of customers to target as part of Campaigning.
• Using understanding of direct marketing to provide segmentation, data mining and response analysis for marketing campaigns.
• Involved in market segmentation and customer profiling
• Redesigned Oracle cursor-based stored procedures to Teradata set-based stored procedures. Worked with Business Objects developers to ensure that generated SQL was optimized for Teradata.
• Involved in the creation of user testing documentation Used Data Flux for Data Integration.
• Ensured and adhered to design and security standards.
• Provided programming support to the Solutions Lending team and other Creditcard team members i.e. a total redesign of all the model monitoring report process for Lending which included development of a more efficient data extraction code and conversion from a manual Excel/Pivot tables to automated html based graphs process of producing the reports .
• Implemented SAS/ETL processes to optimize the code using partitioned datasets.
• Extensively created audit reports which were successfully tested and approved by the production team and also assisted them in UAT sessions to help the users validate the developed queries.
• Effectively integrated the data using SAS DI studio after ETL operation and thus maintained the data on a monthly basis.
• Data Extraction- Extracted data Developed full scale Client/Server SAS/AF systems for international users.
• Supported development of predictive modeling for each marketing campaign product using SAS, Informix and Sybase.
• Wrote queries based on the BRCL and ran the SQL code against the tables in DB2 and effectively utilized joins in PROC SQL including inner joins, left outer joins and right outer joins to optimize the statement.
• Participated in Risk Assessment and Risk Management with regards to the Business requirements for queries with the Business team and also effectively coordinated with the user team to achieve considerable Risk mitigation.
• Prepared datasets for market analysis and model group.
• Installed and configured SAS for Windows on several workstations.
• Enhanced the liquidity of the mortgage market by providing funds from the bank to mortgage bankers and other lenders so that they may lend to home buyers.

Environment: SAS/Connect, SAS/STAT,SAS/Graph,SAS EG 4.2,Oracle10g, UDB, SAS metadata server, SAS Management Console,Base SAS 9.1.3,SAS Macros.

Confidential

SAS Programmer/Analyst

Responsibilities:

• Manage work with Business analyst about present requirements and development plans
• Complete installation of SAS Intelligence Platform and implemented with SAS data integration system on the SAS Information Delivery Portal web application to support PAI client requirements.
• Proficiency in writing Shell Scripts using VI Editor Solaris OS and automation using CRON Jobs.
• Created different types of portlets, such as BI Dashboard Framework,CollectionPortlet, Information Map Viewer,URL ,WebDAV Content Portlet and WebDAV Graph Portlet.
• Develop necessary SAS cubes for data integration and OLAP part.
• Integrate all SAS components, SAS graphs, and programs onto one web application software for end users by using SAS IntrNet, SAS information map studio, and SAS Information Delivery Portal.

Environment: Windows Vista, SAS Add-In for Microsoft Office, SAS server, SAS Cube Studio, SAS EBI/DI Studio, SAS ETL, SAS EG, SAS Web Report Studio, SAS Access, SAS OLAP, CRON, SAS Information Delivery Portal, SQL Analyzer, UDB, RDBMS, and SQL server

Confidential

SAS Programmer/ Analyst

Responsibilities:

• Developed and maintained the Crontab Entries for scheduling the daily, weekly, monthly, quarterly as well as yearly jobs
• Used of SQL server, SQL access, SQLPLUS, TOAD and PL/SQL to solve complex database problems as well tuning purpose
• Extracting financial data from the database using SAS/Access, SAS SQL, SAS/Connect, Procedure and create SAS permanent data sets in SAS library.
• Creating SAS Views from tables in Database using SAS/Access, and analyze data.
• Write the SAS code and run those data sets to produce necessary financial reports by using SAS/STAT Procedures such as PROC Freq, PROC Tabulate, ProcUnivariate, and PROC ANOVA.
• Involved in maintaining and tuning existing JCL scripts
• Extensively used procedures like PROC SQL, PROC PRINT, and PROC SORT etc.
• Coded SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs.
• Analyzed the data using SAS/STAT procedures PROC FREQ, PROC MEANS, PROC SUMMARY
• Used Proc Sort, Set, Update and Merge statements for creating, updating and merging various SAS datasets
• Design of ETL process to meet the requirement of data demand.
• Worked with SQLPLUS, and PL/SQL extensively to solve database problems to make database effective and efficient tuning purpose. In PL/SQL Implement of DML, Implicit and Explicit Cursors, function, conditional logic, creating and ODBC connection.
• Scheduled and managed jobs with AutoSys job management system to ensure job streams flowed smoothly.

Environment: : Base SAS, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, SAS/ETL, UNIX SAS, PC SAS, Oracle 9i, DB2, PL/SQL, MS Excel,TOAD, MS Access