SUMMARY:

• Certified SAS programmer with over 5+ years of professional experience in data extraction, cleansing, validation, analysis and interpretation using various versions of SAS software.
• Developed SAS programs for statistical analysis and data displays working with various SAS products SAS/BASE, SAS/SQL, SAS/STAT, SAS/INTR, SAS/ACCESS, SAS/CONNECT and SAS/MACROS to develop solutions.
• Proficient in Base SAS, SAS/STAT, SAS/CONNECT, SAS/MACROS, SAS/GRAPH, SAS/SQL, SAS/ACCESS, SAS/CONNECT in UNIX and Windows environment.
• Worked on DBMS systems like Access, MS SQL server, Oracle, Db2, Teradata, Netezza.
• Generated reports using SAS reporting procedures such as Proc Report, Proc Tabulate, Proc Summary and Proc SQL.
• Represented data analyses results using graphs and charts and presented them to the management as and when required.
• Proven skills in data cleansing, data archival, data migration, ad - hoc reporting and coding utilizing SAS on UNIX, Windows and IBM Mainframe environment.
• Experience in modeling for risk rating and generate results/reports for upper management.
• Knowledge in using SAS/ACCESS to export, transfer and load (ETL) data from ERP packages.
• Followed System Development Life Cycle (SDLC) methodology for the design, development, implementation, and testing of various SAS modules.
• Hands on skills in Microsoft Word, Excel and PowerPoint.
• Solid knowledge of statistical techniques such as linear regression, logistic regression, forecasting, time series, cluster and basket analysis, RFM, ROI, LTV and NPV analysis.
• Hardworking, Ethical and Effective team player with strong communication & interpersonal skills.

TECHNICAL SKILLS:

Programming Languages: SAS, SQL, UNIX Korn Shell Scripting

SAS Tools: Base SAS, Advanced SAS, SAS/ACCESS, SAS/GRAPH,SAS/CONNECT, SAS/ODS, SAS/STAT, SAS EG

Database Tools: TOAD 9.7.2, PL/SQL Developer 7.1.5, Teradata SQL assistant

Databases: MS Access, Oracle 9i/10g/11i, DB2, MS SQL Server, TD SQL

Operating Systems: MS-Windows XP/2003/2000, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Waltham, MA

SAS Developer/ Analyst

Responsibilities:

• Wrote Korn-Shell Scripts performing various automation steps like running a SAS code, emailing the output files, removing and copying files, archiving files for historical data and zipping up files to send to external locations as attachments in emails.
• Used SAS and SQL skills to perform ETL from Teradata databases and created SAS datasets, SAS macros, Proc/data steps and SAS formats.
• Created and new datasets from raw data files and modified existing datasets using Set, Merge, Sort, Update, and conditional statements.
• Used SAS Enterprise Guide query builder to run queries against the tables and to sub set the data.
• Created preference list of customer as per the requirements of business analysts using various SAS procedures: PROC SQL, PROC MEANS, PROC FREQ, PROC SORT, PROC REPORT.
• Used SAS ODS to prepare reports in various formats like RTF, PDF, HTML etc. as per the business requirements.
• Prepared and effectively presented the reports to the management.
• Developed UNIX shell scripts in order to run the report as a part of daily schedule.

Environment: SAS 9, Base SAS (MACROS, Proc SQL, ODS), SAS/ACCESS, SAS/STAT, SAS/GRAPH, SAS Enterprise Guide 3.0, SAS Enterprise Miner, DB2, Oracle 9i (SQL, PL/SQL), UNIX, UNIX Korn Shell, MS-Windows XP, MS-Office.

Confidential, Pittsburgh, PA

SAS Programmer

Responsibilities:

• Used SAS and SQL to perform ETL from Oracle and Teradata databases and created SAS datasets.
• Used SAS PROC SQL pass through facility to connect to tables and created SAS datasets using various SQL joins such as left join, right join, inner join and full join.
• Developed complex SAS Macros to simplify SAS code and effectively reduce coding time.
• Modified existing macros to report summary/descriptive statistics as well as inferential statistics.
• Validated SAS programs using various sophisticated techniques and communicated findings to the concerned.
• Involved in handling the ad-hoc reporting requirements.
• Worked extensively on creating SAS views, SAS Indexes and SAS tables to reduce bottlenecks and processing time.
• Used advanced techniques to reduce the execution of process times in SAS.
• Report generation on providers such as total amount billed Per-patient average billing amounts etc. for auditors and investigator using Proc UNIVARIATE, Proc MEANS and Proc REPORT.

Environment: SAS/Base, SAS Enterprise Miner, SAS/Macro, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/OLAP, Teradata, MS EXCEL, MS ACCESS

Confidential, Milwaukee, WI

SAS Programmer/ Analyst

Responsibilities:

• Extensively interact with business analysts, IT services team, and Statisticians for developing SAS models for risk rating of commercial loans.
• Involved in SDLC of the risk rating application. Documented requirement analysis, version upgrade, and migration across develop, test, and production environment.
• Develop, test, and debug SAS programs to model Risk rating models for different types of commercial loans.
• Modify models to reflect any changes in business requirements and input data structure.
• Extensively used SAS Macros for programming.
• Followed an internal program validation and tracking methodology.
• Generate test data for model validation.
• Modify/develop Korn shell scripts to automate report generation and schedule tasks.
• Program for statistical analysis of data for model calibration.
• Work with business analysts to analyze and debug data issues. Use SAS programs and functions for data validation and cleansing.
• Work extensively in sorting, merging, concatenating, and modifying SAS data sets
• Use ODS to generate results in Excel, PDF, and HTML formats.
• Involved in handling the ad-hoc reporting requirements.
• Extensively use Data NULL to create XML files from SAS datasets.
• Develop SAS datasets from Excel files, XML files, Oracle Server, and DB2 database.
• Extract data from the source database using Proc SQL.
• Use XML Mapper for creating SAS datasets from XML files.
• Design, document, implement, and maintain monthly & ad-hoc financial, marketing and operations analyses using SAS.
• Conduct complex ad-hoc programming and analysis including statistical programming and analysis.
• Develop and produce monthly reports summarizing business activity, delinquency & loss.
• Analyze business performance and productivity to identify obvious and subtle causes for improvement and deterioration.
• Extract and summarize account and transaction level data for trend analysis and forecasting.
• Create application layers for web publishing and dispatching of reports.
• Produce SAS datasets, flat files, and reports.
• Extract data from the source database using Proc SQL.
• Build logistic regression models using SAS EG for risk scoring on new campaigns and prospective customers.
• Develop Model to Predict Customer Response to launch of new products.
• Develop and execute controlled tests to determine the impact of new programs, strategy changes, or procedural changes.

Environment: SAS 9, Base SAS (MACROS, Proc SQL, ODS), SAS/ACCESS, SAS/STAT, SAS/GRAPH, SAS Enterprise Guide 3.0, SAS Enterprise Miner, DB2, Oracle 9i (SQL, PL/SQL), UNIX, UNIX Korn Shell, MS-Windows XP, MS-Office

Confidential, Morrisville, NC

SAS Programmer

Responsibilities:

• Produce SAS datasets, flat files, and reports for various departments.
• Create SAS data sets from Oracle database.
• Extensively program for statistical analysis of data.
• Develop and execute controlled tests to determine the impact of new programs and strategy changes on existing customers.
• Implement advanced statistical approaches to develop predictive models and profiles.
• Data mining to identify significant relationships among customer behaviors and descriptive characteristics.
• Perform complex ad-hoc programming, analysis, and reporting.
• Design, document, implement, and maintain monthly and ad-hoc financial and marketing analysis.
• Develop and produce monthly reports summarizing business activity, delinquency & loss.
• Maintain and enhance loss-forecasting models and delinquency roll rates.
• Modified/developed korn shell scripts to generate periodic reports.

Environment: SAS 8, Base SAS (MACROS, Proc SQL, ODS), SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS Enterprise Miner, Oracle 9i (SQL, PL/SQL), UNIX, MVS, UNIX Korn Shell, MS-Windows XP, MS-Office