SUMMARY

• SAS Programmer andAnalyst with Seven years of experience in Market Analysis,Campaign Analytics, Financial Analysis and Health Care Data Analysis.
• Proven skills in Data Mining Techniques, Statistical Analysis and Predictive Modeling using SAS and SAS Enterprise Miner
• Experience in using statistical techniques such as Correlation and Regression including multiple regression, Logistic Regression, Multivariate Analysis and ANOVA.
• Experience in conducting customer segmentation analysis, pre and post campaign analysis and campaign tracking
• Worked under statisticians and predictive modelers while building models for Up - Sell, X-Sell and Retention for increasing response rate
• Strong knowledge in SAS functions and procedures and hands on knowledge in programming Base, STAT, GRAPH, ETS and ODS modules
• Possess good skills in SAS programming language, especially Data Step programming and Report writing.
• Experience in RDBMS development specifically MySQL, Oracle and Teradata using Oracle SQL developer, Toad and Teradata SQL assistant
• Expertise in using advanced techniques including Hash merge, Array and using efficiency techniques to reduce program run time
• Knowledge in data warehousing and business intelligence concepts, design principles and able to interact with technology team on code deployments in production runs
• Expertise in program validation with specification and documentation.
• Good understanding of Health care terminology such as Medicare,Medicaid, HIPPA, CPT, DRG and HCPAC.
• Quality Control, Execution, and Maintenance (Debugging, Enhancements, and Testing) of all delivered Production Code.
• Highly motivated, Organized Team player with excellent analytical and communication skills.
• Strong analytical, diagnostic skills and ability to work in a fast-paced and team-oriented environment.

TECHNICAL SKILLS

SAS Tools: SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/ODS, SAS/ACCESS, SAS/Enterprise Guide, SAS/Enterprise Miner

Statistical Programs: SAS, SPSS, R

RDBMS: Oracle, Teradata, MS Access, MySQL

Application Software: MS Office, Visio

Operating System: UNIX, Windows

PROFESSIONAL EXPERIENCE:

Confidential, CA

SAS Programmer/ Marketing Analyst

Responsibilities:

• Extracted data from the database using SAS/Access, SAS SQL procedures and Teradata SQL assistant to create data for analysis
• Interacted with marketing team to understand campaign objective and success criteria for developing SAS code for campaign analysis
• Used SAS/STAT procedures such as proc t-test and proc anova for testing the performance of test group over control group
• Developed reusable macros for campaign validation andanalysis on every month on reported results excel
• Involved in post campaign analysis by creating customer profiles based on response rates and reported results in power point presentation
• Participated in team meetings on new model initiatives and interacted with modelers on requirements gathering
• Performed data analysis on historical data to profile customers based on response rate of various similar campaigns
• Extensively used SAS procedures and functions to manipulate existing data and to create derived variables
• Used SAS concatenation, merge and match merge methods for combining data sets for modeling and validation
• Used Enterprise Miner to conduct predictive analytics like logistic regression, cluster analysis for identifying potential variables for modeling
• Assisted in exporting Enterprise Miner generated SAS code to production environment
• Extensively used edit check programs for data processing and validations.
• Worked in both UNIX and Windows Environment.

Environment: Base SAS, SAS Macros, SAS/Connect, SAS/Access, SAS DDE, SAS ODS, SAS/GRAPH, Oracle 9i, SAS V9.1.3, SAS Enterprise Guide, Enterprise Miner, Excel, Oracle, Teradata, Windows XP, AIX UNIX .

Confidential, CA 

SAS Programmer/Analyst

Responsibilities:

• Accessed Analytics Data Mart using SAS/Access facility, SAS SQL procedures and Teradata SQL assistant.
• Reviewed company’s churn reports and churn operations procedures for business understanding and reducing adhoc report delivery time
• Extensively used SAS/Base procedures and functions for data manipulation and creating summaries data values
• Maintained and enhanced existing SAS reporting procedures for churn reporting and marketing campaigns
• Involved in creating mail list for customer satisfaction survey and follow up surveys on retention initiatives
• Acted as liaison between various Survey/Research providers to meet specific data needs and providing quick support in the form of data appends and ad hoc reports.
• Created standalone macros to check data quality and generate summary statistics for score data sets
• Performed data analysis, created reports with extensive use of BASE SAS, macro and SAS reports with the help of default procedures.
• Worked with large customer response and sales data sets and generated graphs using SAS Report and SAS /GRAPH.
• Extensively used SAS Enterprise Guide for UNIX SAS for data access and Ad hoc reporting.

Environment: SAS/ACCESS, SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/Enterprise Guide, Teradata, Oracle, MS OFFICE

Confidential, CA 

SAS Programmer/Analyst

Responsibilities: 

• Extracted data from SQL Server and DB2 using SAS/ACCESS in WINDOWS Environment.
• Using BASE SAS manipulated and summarized data
• Conducted Data investigation and cleaning through developing various SAS auto call MACROS
• SQL procedures were extensively used to create analysis data sets for Eligibility, Inpatient, Outpatient, Long Term Care and Pharmacy (Rx).
• Generated Quarterly and Annual Reports by extracting and populating data to create reports with the SAS ADD-IN provided in Microsoft EXCEL.
• Analyzed the data and created graphs on Excel sheet by using Microsoft VBA scripts
• Used SAS/GRAPH and PROC CHART procedures to generate various charts for analysis
• Optimized the current process and developed new programs for automation.
• Generated formats using PROC FORMAT for frequently used variables such as CPT (Current procedural terminology), HCPC, DRG (Diagnosis related group),and program type, type of claim, type of service, diagnosis code and Adjustment Indicator.
• Implemented SAS procedures, MACROS and applications for data cleaning, reporting, and documentation.
• Actively involved in the development of algorithm and investigation tools for identifying fraudulent transaction claims
• Generated macros for fraud modeling to identify duplicate claims and fraudulent claims.
• Developed SAS MACROS for generic coding and reusable modules.
• Debugged inherited programs and documented existing programs.
• Performed documentation for SAS code for better understanding of the code
• Generated monthly, quarterly, and annual performance reports for senior management.

Environment:  SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/SQL, SAS/GGRAPH, Excel/Access, Oracle/SQL, Windows XP and UNIX. 

Confidential, TX

SAS Consultant/Analyst

Responsibilities:

• Used SAS/Access facility and SQL Server Management Studio to connect to SQL server and used SAS SQL procedures to extract and manipulate data.
• Developed SAS MACRO scripts to check data quality, generate descriptive statistics for modeling and scoring data sets
• Assisted lead programmer/statistician by creating historical data base for predictive modeling.
• Involved in all stages of model development including model data set generation, model building, validation and tracking performance
• Maintained logistic regression and decision tree models using SAS/Base and SAS Enterprise Guide 5.1
• Used SAS/STAT procedures such as Proc Univariate, Proc Means, Proc Surveyselect, Proc Reg and Proc Logistic
• Used SAS code to score and track existing models and generate quarterly reports
• Involved in developing models for score every customer on loan defaulting
• Used SAS Enterprise Guide and SQL Server extensively for Ad hoc reporting.
• Modified existing and new SAS jobs that generate reports, and to send them as PDF or HTML attachments or as body of the email.
• Used PROC GMAP Procedure to generate maps for individual states showing two response variables
• Reviewed various documents and source systems schema to improve business understanding and data understanding
• Acted as liaison between on site management and off shore teams and contributed for completing the project with in timeframe.

Environment: SAS/ACCESS, SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/Enterprise Guide 5.1, SAS Model Manager, SQL Server Management Studio, MS OFFICE.

SAS Marketing Analyst

Responsibilities:

• Conducting analysis on client consumer databases looking at profitability, transaction behavior, and demographic characteristics.
• Providing segmentation for database marketing efforts, such as CHAID, cluster analysis, and customer profiling.
• Responsible for statistical applications support and programming primarily in SAS, supporting Marketing team in ACOE.
• Generating Regular, Ad-Hoc Reports using SAS Tools and Oracle.
• Write macros to organize data files to business specifications within standard office applications such as Excel, Access, Word, and PowerPoint.
• Building Statistical Models and Regression Models using SAS Tools.
• Work collaboratively with Data Processing to define data structures and content (i.e., file layout) and validate data integrity using UNIX, PERL.
• Developing Acquisition Models based on demographics data, sales data and internal and external data sources.
• Create and maintain customer models.
• Setting up and scheduling processes using cronjobs in UNIX and Solaris.
• Setting up and scheduling Stored Procedures in SAS BI server and SAS Data Integration Server.

Environment: SAS V 8.2, SAS V 9.1.3, Base SAS, SAS Macros, SAS/Access, SAS/STAT, SAS/ETS, SAS DDE, SAS ODS, VBA for Excel, SAS/GRAPH, ORACLE, TOAD, PL/SQL, SAS V9.1.3, SAS Indexes, SAS Views, SAS MP-Connect, Excel.

SAS Analyst

Responsibilities:

• Gather data from various sources and conduct data manipulation in order to analyze the effectiveness of business strategies.
• Conducting analysis on client consumer databases looking at profitability, transaction behavior, and demographic characteristics.
• Developed SAS code for database marketing efforts, such as CHAID, cluster analysis, and customer profiling.
• Generating Regular, Ad-Hoc Reports using SAS Tools and Oracle and ETL sources.
• Wrote macros to organize data files to business specifications within standard office applications such as Excel, Access, Word, and PowerPoint.
• Worked on Statistical Models, predictive models and Regression Models using SAS Tools.
• Automation of MIS Reporting systems.
• Work collaboratively with Data Processing to define data structures and content (i.e., file layout) and validate data integrity using UNIX, PERL.
• Developed various VBA processes for reporting purposes.
• Setting up and scheduling processes using cron jobs in UNIX.

Environment: Base SAS, SAS Macros, SAS/Access, SAS/STAT, SAS/ETS, SAS ODS, VBA for Excel, SAS/GRAPH, ORACLE, TOAD, SAS Indexes, SAS Views, SAS MP-Connect, Excel.