SUMMARY

• Over 9 years of extensive experience in SAS programming on different platforms - Windows and Unix.
• Proficient in SAS/BASE, SAS/EG, SAS/Studio, SAS/SQL, SAS/Macro, SAS/Connect, SAS/Access, SAS/ODS, SAS/Stat, SAS/DI Studio, SAS EBI, and SAS/Graph.
• Proficient experience in different Databases like Oracle, Microsoft SQL Server, Teradata, and IBM DB2
• Strong experience in data extraction, manipulation, and Analysis using claims data.
• Good exposure on SAS Business Intelligence Tools like SAS OLAP Cube Studio 4.2 (To create OLAP Cubes), Information Map Studio 4.2 (To create information maps on data marts), Web Report Studio (WRS) 4.2 (To create web reports using Information maps), SAS Information Delivery Portal.
• Experience in analyzing the claims data, future trends, and summarized results to generate recommendations for management.
• Worked in updating, data extraction, transformation and loading to data warehouse, data analysis, updating, testing, trending, mapping analysis and business driven data validation.
• Experience in Data analysis and Reporting in Health care, Insurance, Banking, Finance, and Marketing sectors.
• Developed new or modified existing SAS programs to load data from the source and create study specific datasets.
• Thorough grounding in all phases of data analysis, including definition and analysis of questions with respect to available data and resources, overview of data and assessment of data quality, selection of appropriate models and statistical tests and presentation of results.
• Significant experience in requirement gathering, building, designing, and testing the application to meet the functional Design and Business Process Design.
• Strong experience with databases like Oracle, Teradata, My SQL, MS SQL Server 2000, DB2 and MS Access.
• Strong skills in Data Analysis, Data Requirement Analysis, and Data Mapping for ETL process.
• Extensive experience to handle large amounts of data for Data Cleansing, Data Profiling and Data Scrubbing.
• Experience in working with SAS Enterprise Guide Software for reporting and analytical tasks.
• Extensive knowledge of advanced SAS/STAT procedures.
• Extracting, transforming, and loading data into data warehouse using SAS DI Studio for further analysis and reporting.
• Created complex web reports from SAS data and information maps using SAS Web Report Studio.
• Performed data extraction, analysis and published results using SAS Enterprise Guide.
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
• Effective team player with strong communication and interpersonal skills.

TECHNICAL SKILLS

SAS Tools: Base SAS 9.4/9.3/9.2/9 /8.2/8.1/6 (mainframe), SAS/Stat, SAS Macros, SAS/SQL, SAS ODS, SAS Graph, SAS Enterprise Guide, SAS Enterprise miner, SAS Business Intelligence (BI) platform and SAS EBI.

Reporting Tools: Base SAS versions 9.3/9.2/9/8/6, SAS Enterprise, MS-Excel, SAS BI Platform, MS-Visio, and MS-PowerPoint.

RDBMS: SAS SQL, SAS Enterprise, SAS BI Platform, MS-ACCESS, Microsoft SQL Server, MySQL, Teradata, and Netezza.

Languages: SAS, SQL, Basic, HTML

Platforms: Windows 95/98/XP/Vista/Win 7, Unix, SOLARIS, Linux (Red Hat, Debian, Ubuntu & Xandros), MAC OS, DOS, and Windows

Batch Server: Unix, Putty, SSH, SAS scripting

Web Server: MS-FrontPage, HTML, Linux, Apache Server

Networking: Windows, Unix, Linux, Ubuntu, Mac, and CentOS

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Sr. SAS Programmer and Analyst

Responsibilities:

• Prepared, analyzed, and distributed various monthly and quarterly Loan Portfolio Reports.
• Performed and conducted written analysis outlining key performance indicators and key risk indicators.
• Developed and implemented necessary exception reporting in support of Credit and the line to manage to better manage credit administration risk posed to the Bank.
• Provided support in the design and implementation of ad hoc requests for Credit-Related Portfolio Data.
• Developed complex SAS Macros to simplify SAS code and effectively reduce coding time.
• Carried out data extraction and data manipulation using Proc SQL, Proc Sort, Proc Report to create preferred customer list as per business requirements.
• Extensively used SAS procedures such as Print, Report, Tabulate, Freq, Means, Summary, Transpose and Data Null for producing ad-hoc and customized reports and external files.
• Responsible for generating Financial Business Reports using SAS Business Intelligence tools (SAS/BI) and also developed ad-hoc reports using SAS Enterprise Guide.
• Extensively used SAS ODS facility to create customized reports in HTML, PDF, RTF formats.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools e.g., SAS Integration Studio, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access
• Performed competitor and customer analysis, risk and pricing analysis and forecasted results for credit card holders on demographical basis.
• Performed Consumer profiling, Sales forecasting, and testing of financial and business models visuals using Tableau and SAS.
• Effectively prepared and published various performance reports and presentations.
• Developed and used scripts to schedule SAS Jobs in batch mode.

Environment: SAS EG, Base/SAS, Tableau, SAS Macros, SAS/Access, Oracle, Windows, MS Office, HTML, Unix.

Confidential, Northbrook, IL

Sr. SAS Programmer and Analyst

Responsibilities:

• Reviewed Business Process and Develop Process Flow Diagrams.
• Extensively worked with Health care data which includes various claims, membership details and of the members.
• Gathered and assimilated data from Oracle, SQL Server and reporting requirements from business.
• Extracted data from oracle database using SQL pass- through facility.
• Created complex and reusable Macros and used existing macros for Data Cleansing, Validation analysis and Report generation.
• Sourced and analyzed data from a variety of sources like SAS data sets, MS Access, MS Excel, CSV, XML, and flat files etc.
• Analyzed the claims data, future trends, and summarized results to generate meaningful recommendations for management.
• Built SAS Data sets which consists of Members or Subscribers enrolled for PBM process, letter templates are sent to Members or Subscribers with updates related to prescribed drugs, health plan changes and alternatives via email or hardcopy as enrolled by member.
• Involved in Marketing Campaigns, Marketing automation and Email campaigning using SAS EG to build source datasets which consists of PII and PHI information and outputs are sent to Members in mode they have chosen when enrolled in the PBM programs.
• Dealt with Teradata EDW Asset Datamart from which data is pulled and did necessary modifications as per the requirement and finally loaded into the respective tables.
• Coded, Modified, and automated existing SAS programs to automate process, improve efficiency.
• Extensively used various SAS ODS techniques to generate complex reports.
• Performed quality control (QC) checks on peer developed programs to ensure that the correct source data is used, correct code and logic are used.
• Documented all the programs developed for future reference.
• Creating SAS dataset from tables in Database using SAS/Access. Retrieved the data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/Stat procedures.
• Coding SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs.
• Created many Perl, CGI reports and Extracted, loaded Teradata DBMS tables using SAS/ETL.
• Ample experience on Teradata/ SQL Pass thru facility.
• Maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets and/or ASCII files by using Set and Merge,, Sort, and Update, Formats, Functions and conditional statements for generating Reports.
• Prepared new Datasets from raw data files using Import Techniques modified existing datasets.
• Used Enterprise Guide (EG) for creating, editing and submitting SAS code for stored processes to Application server, for running queries against DB2 to bring the data into the SAS environment.
• Involved in scheduling the existing reports using UNIX and SAS Data Integration Studio.
• Wrote Shell scripts for running batch files; performed validation on transported data and reports.
• Extensively researched for cause of errors in code and modified code according to requirements

Environment: SAS/Enterprise Guide, SAS/Base, SAS/Macros, SAS/SQL, SAS/ODS, SAS/Stat, SAS/ETL, Excel, Access, Windows 2000 Server, SQL Server, Perl, Unix, MS office and Teradata.

Confidential, Chicago, IL

Sr. SAS Programmer and Analyst

Responsibilities:

• Reviewed Business Process and Develop Process Flow Diagrams.
• Extensively worked with Health care data which includes various claims, membership details and of the members.
• Gathered and assimilated data from Oracle, SQL Server and reporting requirements from business.
• Extracted data from oracle database using SQL pass- through facility.
• Created complex and reusable Macros and used existing macros for Data Cleansing, Validation analysis and Report generation.
• Sourced and analyzed data from a variety of sources like SAS data sets, MS Access, MS Excel, CSV, XML, and flat files etc.
• Analyzed the claims data, future trends, and summarized results to generate meaningful recommendations for management.
• Dealt with Teradata EDW Asset Datamart from which data is pulled and did necessary modifications as per the requirement and finally loaded into the respective tables.
• Coded, Modified, and automated existing SAS programs to automate process, improve efficiency.
• Extensively used various SAS ODS techniques to generate complex reports.
• Performed quality control (QC) checks on peer developed programs to ensure that the correct source data is used, correct code and logic are used.
• Documented all the programs developed for future reference.
• Creating SAS dataset from tables in Database using SAS/Access. Retrieved the data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/Stat procedures.
• Coding SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs.
• Created many Perl, CGI reports and Extracted, loaded Teradata DBMS tables using SAS/ETL.
• Ample experience on Teradata/ SQL Pass thru facility.
• Maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets and/or ASCII files by using Set and Merge,, Sort, and Update, Formats, Functions and conditional statements for generating Reports.
• Prepared new Datasets from raw data files using Import Techniques modified existing datasets.
• Used Enterprise Guide (EG) for creating, editing and submitting SAS code for stored processes to Application server, for running queries against DB2 to bring the data into the SAS environment.
• Involved in scheduling the existing reports using UNIX and SAS Data Integration Studio.
• Wrote Shell scripts for running batch files; performed validation on transported data and reports.
• Extensively researched for cause of errors in code and modified code according to requirements

Environment: SAS/Enterprise Guide, SAS/Base, SAS/Macros, SAS/SQL, SAS/ODS, SAS/Stat, SAS/ETL, Excel, Access, Windows 2000 Server, SQL Server, Perl, Unix, MS office and Teradata.

Confidential

SAS Programmer and Analyst

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 & 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.