SUMMARY:

• Solutions - focused, team oriented SAS Professional with over 7 years of experience directing program development and data warehousing, validation and test analysis, and consultancy operations in highly-competitive market environments. Exemplary analytical and documentation abilities with extensive experience in Banking, financial, Retail and Insurance industries. Seeks a challenging career where all skills can be utilized to the fullest.
• Extensive professional experience in Bank Marketing, Credit Risk Analysis.
• Strong experience in SAS/BASE, SAS/MACRO, SAS/CONNECT, SAS/ODS, SAS/GRAPH, SAS/SQL, SAS/ACCESS in WINDOWS and UNIX environments.
• Extensive experience in writing UNIX SAS and PC SAS code.
• Worked extensively on SAS Procedures and Data Step Programming to develop the process flow applications from Data Acquisition to Data Exploitation/Reporting.
• Through experience in data extraction and sorting from various databases like Oracle, DB2, TERADATA and MS Access using PL/SQL and SQL.
• Modified existing/creating new SAS programs by developing SAS Macros to improve ease, speed as well as improving consistency results.
• Advanced skills in data cleaning and manipulation using PROC MEANS, PROC UNIVARITE, PROC APPEND, PROC SORT, PROC TRANSPOSE and PROC RANK.
• Proficiency in importing different types of external files (Excel, CSV, txt, etc.) into SAS library and exporting SAS data sets as external files using Import/Export Wizard, PROC IMPORT, PROC EXPORT, and SAS DATA steps.
• Strong experience in using SAS/ACCESS (LIBNAME, Pass-Through) to extract large volume data from databases including Oracle, SQL Server, DB2 and Teradata.
• Very good command in generating customized reports by using Data NULL, PROC CHART, PROC DATASETS, PROC FORMAT, PROC PLOT, PROC PRINT, PROC REPORT, PROC TRANSPOSE, PROC TABULATE.
• Experienced in using SAS ODS to create output data sets and RTF, HTML, PDF, CSV files.
• Extensive experience in developing routine SAS Macros to create tables and graphs.
• Extensive exposure on every steps of entire project life cycle including data collection, query, modifying and analysis, summary of findings, communicating strategic insight and presentation of results and documentation of the processes.
• Intensive experience with analyzing Credit Bureau data.
• Excellent work experience in extracting customer behavior information from various data sources in Market Segmentation.

TECHNICAL SKILLS:

Statistical Packages: SAS/Base, SAS/SQL, SAS/STAT, SAS/Access, SAS/Macros, SAS Enterprise Guide, SAS/Graph, SAS/ODS, SAS BI, SAS DI, SAS Web Report Studio, SAS/Connect, SAS/Map, SAS Information Map, SAS/ASSIST, SAS Enterprise Miner, SPSS, Minitab.

Database: Oracle, SQL, MySQL

Software Tools: MS Access, MS Visio, MS Excel, Word

Operating Systems: Windows 98, XP, Vista, 7, Mac OS, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Taylor, MI

SAS Programmer/ Analyst

Responsibilities:

• Reviewed existing literature on Medicare, Medicaid and models dealing with Medicaid fraud.
• Attended various seminar presentations on Medicaid fraud such as finding duplicate claims, service after death, multiple service providers etc.
• Used SAS/Assist to extract data from SAS Files and Oracle Data base.
• Involved in writing code using Base SAS & SAS/Macros to clean and validate data from oracle tables.
• Conducted data investigation using SAS Enterprise Guide.
• Prepared the JCL‘s for down loading the files from Mainframe.
• Involved in Data mining using Enterprise Miner for various health care datasets such as Eligibility, In Confidential t, Out Confidential t, Long Term Care and Pharmacy (Rx).
• Involved in developing various fraud algorithms and validated existing algorithms against specification.
• Generated formats using Proc Format for frequently used variables such as CPT (Current procedural terminology), HCPC, DRG (Diagnosis related group), Program type, type of claim, type of service, diagnosis code, Adjustment Indicator etc.
• Used SAS import procedure to generate temporary and permanent SAS data sets from txt, csv and excel data sets.
• Created various Graphs using SAS/Graph, SAS/Gplot.
• Validated data and creating reports using different procedures like PROC FREQ, PROC MEANS, PROC TRANSPOSE, PROC DATASETS, PROC SORT, PROC COMPARE, PROC SQL, PROC REPORT etc. and SAS ODS facility.
• Conducted QA for macros generated by other programmers using Macro options MLOGIC, SYMBOLGEN, MPRINT, MACROGEN etc.
• Performed documentation of the SAS Code for the better understanding of the program

Environment: Base SAS, SAS Macros, SAS Enterprise Guide, SAS BI, SAS/Access, SAS/ASSIST, SAS/STAT, SAS/GRAPH, ORACLE, SAS V9.1.3, SAS V9.2, Main Frames, JCL, COBOL, Excel, Windows XP, UNIX.

Confidential, Cleveland, OH

SAS Programmer/ Marketing Analyst

Responsibilities:

• Involved in merging and summarizing data using SAS to obtain tables, reports and results on account/household values and customer profiles.
• Used SQL/Pass through Facility to access data from data marts.
• Creating SAS data sets from flat files, excel files and from oracle based on the requirement.
• Performed QC Checks for variables and loaded them into History Database.
• Developed SAS Macros to create various daily, weekly and monthly reports.
• Extensively used SAS/ Graph to create graphical reports for sales analysis.
• Created reports using SAS /ODS and SAS /Views from oracle database tables into different formats like HTML and RTF.
• Extensively used SAS Enterprise Guide for adhoc reporting.

Environment: SAS/BASE, SAS BI, SAS Web Reort Studio, SAS BI, SAS/SQL, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS Enterprise Guide, Microsoft Access, Oracle 8i, Windows NT Confidential, Cleveland, OH

SAS Programmer

Responsibilities:

• Coordinate processes related to marketing campaign eligibility.
• Participated in campaign set up team meetings.
• Developed code to scrub population at account and household level for targeting for Marketing campaigns.
• Used SAS and SQL skills to perform ETL from DB2 and Teradata databases and created SAS datasets, SAS macros, Proc/data steps and SAS formats as required.
• Developed reports as per business requirements and created various reports like summary reports, tabular reports, excel reports etc.
• Participated in developing code to create automatic log checks and waterfalls.
• Developed new/modified macros for report generation using SAS / Macros as per business requirements.
• Designed and created SAS datasets from various sources like Excel datasheets, flat files and created reports and files from existing SAS datasets.
• Developed SAS programs for statistical analyses and data displays for business partners.
• Participated in optimizing the code to reduce the processing times.
• Developed SQL code to execute in TERADATA SQL ASSISTANT to check transaction and account level data for audit purposes.
• Used procedures such as PROC FREQ, PROC FORMAT, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE AND PROC REPORT.
• Worked on various SAS products SAS/BASE, SAS/SQL, SAS/ACCESS and SAS/MACROS etc to develop solutions.
• Developed programs in SAS to generate reports, creating RTF, HTML listings, tables and reports using SAS ODS for ad-hoc and weekly report generation.
• Coordinated and mentored other SAS programmers, technical assistance and trouble shooting and attending project team meetings

Environment: SAS/ODS, SAS Enterprise Guide 4.2, SAS/Macros, SAS OLAP, SAS/Graph, SAS/Access, SAS/Connect, SAS/Stat, Db2,Teradata, MS Excel, MS Access, Windows.

Confidential, NY City, NewYork

SAS Programmer

Responsibilities:

• Performed ETL-Extraction/Transformation/Loading, Data Analysis, Data migration, Data preparation, Graphical Presentation, Statistical Analysis, Reporting, Validation and Documentation.
• Developed application for measuring financial performance of newly acquired accounts Forecast Vs Actual and developed SAS programs for generating reports on Key financials, Income Statements, and Balance Sheet.
• Developed and designed SAS Programs/ Macros to analyze financial data. Statistical analysis files, tables, listings, and graphs. ETL / Extract data from warehouse /databases and created SAS statistical analysis reports.
• Developed adhoc-reports as per business requirements and created various reports like summary reports, tabular reports.
• Developed SAS programs for statistical analysis and data displays working with various SAS products SAS/Base, SAS/SQL, SAS/Stat, SAS/Access and SAS/Macros etc to develop solutions.
• Responsible for maintenance and enhancements work in reporting system using SAS/Base, SAS/Macro, SAS/Stat, SAS/Graph..
• Used SAS, SAS Macros, Oracle, Procedures like SQL, FREQ, UNIVARIATE, SUMMARY, MEANS, TRANSPOSE, ARRAYS, Tabulate, and SORT to extract data, prepare integrated data base and its analysis.
• Designed and created SAS datasets from various sources like Excel datasheets, flat files and Oracle, creating reports and files from existing SAS datasets.

Environment: SAS/BASE 9.1.3, SAS/Macro, SAS/STAT, SAS/CONNECT, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS Enterprise Guide 4.0, SAS Enterprise Miner 5.1,Oracle 9i, PL/SQL, DB2, UNIX, MS EXCEL, MS ACCESS

Confidential, Richfield, MN

SAS Programmer

Responsibilities:

• Responsible for providing statistically-based analytical expertise to support and enhance direct-to-consumer initiatives by capitalizing on customer knowledge
• Extracted and analyzed Oracle data using SAS/Access SQL pass through facility to identify/classify customer groups and marketing/sales results. Created RTF, PDF listings, Pivot tables, and reports using SAS ODS
• Performed Data Step manipulation on various data sets of any volume using efficient and advanced SAS programming methods. Designed and built Data Marts for ON-Line Analytical Processing (OLAP)
• Involved in building data mining tools to help business groups find customer insights