SUMMARY:

• Over 8+ years of experience working with SAS in Financial and Retail clients.
• Experience with SAS 9.1, SAS 9.2, SAS 9.4, EG 4.3, and EG 6.1 for statistical analysis, data mining and building complex reports.
• Expertise in processing large datasets with millions of records for data transformation and data modeling including data cleansing, data scrubbing, data profiling and applying business logic rules to incoming data.
• Expertise using SAS/BASE, SAS/MACRO, SQL, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/GRAPH, Excel, MS Office tools.
• Strong skills in Developing SAS Programs for Data Analysis & Data Requirement Analysis.
• Experience in generating reports employing various SAS procedures like PROC PRINT, PROC REPORT, PROC PLOT, PROC CHART, PROC SUMMARY, PROC FREQ, PROC TABULATE, and PROC MEANS, PROC UNIVARIATE, PROC FORMAT, PROC TRANSPOSE and Data null .
• Expertise with PROC SQL, SAS arrays and SAS Macros.
• Expertise in data transfer between servers and third party vendors using FTPs and SFTPs through SAS program.
• Excellent programming skills in extracting and loading the data into various RDMS like Teradata, Oracle, SQL Server, DB2 with specific bulk load techniques.
• Strong Knowledge in advanced analytics and Data Modeling Techniques.
• Experience in working with Analysis of Variance (ANOVA), Regression Analysis, Linear Models, Multivariate Analysis, and Predictive Solution Models including linear, multiple, polynomial, and nonlinear regression model using SAS Enterprise Miner.
• Experience with SAS Customer Intelligence 6.3 for building Marketing Campaigns for Retail stores.
• Fine - tuned SAS Applications and Queries developed by previous programmers to increase the performance and enhance the efficiency in CPU usage, execution times, control data storage space, and followed efficient strategies.
• Hands on with troubleshooting SAS issues related to programming errors/issues or connectivity errors.
• Proven skills in problem solving, data archival, Ad-hoc reporting, and coding utilizing SAS on windows and UNIX.
• Good verbal and written communication skills. Ability to work collaboratively across project teams having capability to work independently or in groups.

TECHNICAL SKILLS:

Operating Systems: Windows 7, Vista, Unix, Linux

Software: Base SAS, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ODS, SAS/Access, SAS/Assist, SAS Enterprise Guide, SAS E Miner, SAS Customer Intelligence, SAS Information Map. SAS Management Console, SPSS

Programming Languages: SAS, SQL, Unix scripting

RDBMS: Teradata, DB2, Oracle, MS Access, SQL server

Application Software: MS Office (Word, Excel, Power Point, Access), Quality Center 10, Application Lifecycle Management, JIRA, Agile, Waterfall, SQL Assistant, Toad for DB2, Teradata Viewpoint, VBA, Toad Data Point, SFTP, FTP

PROFESSIONAL EXPERIENCE:

Confidential, Framingham, MA

Senior SAS Analyst/Programmer

Responsibilities:

• Conversion of SAS stored procedure from Oracle based RDMS system to the Teradata RDMS.
• Developed SAS Stored Procedure and Macro Program for the SAS Marketing Automation to enhance the data extraction process and create custom reports for the campaign
• Prepared Source to Target Mapping Documents for Field to Field transformation at each level of modification within the SAS scripts.
• Administered the SAS-Support group to provide suggestions for troubleshooting any SAS related issues regarding the SAS Customer Intelligence and SAS Admin issues.
• Developed and tested Marketing Campaigns through SAS CI studio and implemented necessary modification in the Information Map, so that joins were produced accurately.
• Created new Export Definition and Custom Nodes to support the new campaigns in different subject level.
• Developed complex SQLs and SAS program for Scoring Models to analyze customer behavior and segmentation in new MrkDM environment.
• Developed the SSH pairing keys and SAS program for SFTP through SAS to transfer different vendor feeds.
• Conducted Training on Efficient Use of SAS in the newly migrated Teradata Environment.
• Created well-structured documentation on the enhancement and modification done to the SAS Stored Procedure.
• Acted as a liaison between the Business Users and the IT developers to develop application related to the Marketing Team.

Environment: SAS EG 6.1, SAS 9.4, SAS Marketing Automation, SAS/BASE, SAS Add-in for Microsoft Office, Enterprise Miner, SAS Management Console, SAS Information Map Studio, SAS/MACROS, SAS/ACCESS, Teradata, Oracle, SQL Assistant, SAS/LINUX (Red Hat), Studio Express, Toad Data Point, WinSCP, JIRA, SFTP

Confidential, Lewisville, TX

SAS Analyst/Programmer

Responsibilities:

• Conversion of EDW (DB2) queries to function efficiently at ICDW platform by mapping the SQL functions of Teradata.
• Created a high-quality statistical-grade data set from Teradata and DB2, optimized for Data Modeling & Analytics, emphasizing data validation, data mining, data cleansing & data reduction.
• Implementing Physical Data Model change in ICDW structure for PI and PPI change and Stats Collection for the optimization of the query.
• Rebuilt the SAS business application for optimal execution and data manipulation working closely with business users and analysts.
• Built an automated SAS process for data validation between ICDW and EDW views through batch SAS/ACCESS and PROC COMPARE and also develop a program to read the proc compare and sent the results to the excel format.
• Develop SAS and VBA macros for automating the analysis, process, and report generation.
• Created an automated process to test outbound extracts from EDW and ICDW feeding downstream small RDMS.
• Created and used multiple SAS stored processes to generate high level summaries with conditional highlighting through SAS code by using call define statements for data modeling and data mining.
• Worked on Priority One-Peregrine Tickets assigned through JIRA, for critical Business Regulatory Report Reconciliation processes.

Environment: SAS EG 4.3, SAS 9.2, SAS 9.3, SAS/BASE, SAS Add-in for Microsoft Office, VBA, SAS/MACROS, SAS/ACCESS, SAS/SQL, Teradata, DB2, SQL Assistant, Toad for DB2, ALM, SAS/UNIX (AIX), JIRA, SharePoint.

Confidential, Melville, NY

SAS Programmer

Responsibilities:

• Provided statistical programming expertise in production of high level Reports using proc report.
• Data Extraction and enrichment using external data warehouse to provide additional variability and abstraction of risk factors for predictive modeling.
• Comprehensive skills in working with SAS/BASE, SAS EG, SAS EBI, SAS/MACRO, SAS/ACCESS etc. in windows and UNIX environment.
• Extensive use of SAS Macros in the creation of new programs as well as modification of existing programs to improve ease and consistency of results.
• Analysis, programming and creation of reports on existing strategies using SAS and SQL. Design, implementation, tracking performance trend on new strategies in a test vs. control environment.
• Conduct data mining and statistical analysis ( t -test, Chi-Square test, ANOVA, and logistic regression) to improve existing strategies; customizing treatments via appropriate risk/ payment performance based segmentation analysis.
• Design, coding, testing, debugging, and documentation of multiple treatment and payment SAS programs for charge-off card data.
• Prepare daily, monthly, and ad hoc reports (by Excel, pivot tables, and pivot charts, etc.), and present findings and recommendations to all levels of senior management.

Environment: SAS EG, SAS IDP, Web report Studio, SAS 9.1.3, SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/SQL, Oracle, UNIX, Filezilla.

Confidential, Columbus, IN

SAS Programmer

Responsibilities:

• Designing and developing different report templates based on the user conditions.
• Creating reports for lowest granularity (Drill Downs) to generate different output formats like HTML, Word and EXCEL.
• Ad-hoc report programs were developed to let the users select the specified boundaries to create a report.
• Used Macros for validation and cleaning of data
• Microsoft Front Page is used to create the web pages for the project.
• Run report programs and download the results into EXCEL for data analysis.
• Produce SAS Graphical reports showing GPLOT charts as well as PIE and BAR charts for analysis while providing the drill down capabilities.
• Used SAS/Internet tool to fully integrate the SAS program with the web application.
• Used SQL and SAS PROC SQL Pass through Facility to work with Databases.
• Move data sets across platforms from SAS to RDMS and vice versa using MULTILOAD, FASTLOAD, and BULKLOAD Techniques.

Environment: SAS 9.1, BASE/SAS, SAS Macro, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/SQL, DB2, Informatica, UNIX.

Confidential, Bloomfield Hills, MI

SAS Developer

Responsibilities:

• Used SAS and SAS Tools for pre-processing data, data analysis, statistical analysis, and created permanent formatted SAS data sets.
• Performed Data analysis, statistical analysis, generated reports, listings and graphs using SAS Tools SAS/Base, SAS/Macros and SAS/Graph, SAS/SQL, SAS/Connect, SAS/Access.
• Used sorting and merging techniques on the input data sets for Data Preparation, to get the required output and then writing the code using SAS tools.
• Developed routine SAS macros to create tables, graphs and listings for inclusion in reports and maintained existing ones. Prepared data listings and summaries for statistical analysis.
• Developed reports using PROC REPORT, PROC TABULATE and DATA NULL for analysis.
• Designed statistical summary tables, graphs, and patient data listings using base SAS procedures like PROC summary, PROC Tabulate and SAS/Graph.
• Conducted and generated the Regression, Correlation studies and Analysis of Variance (ANOVA) using PROC REG, PROC CORR, PROC GLM, Proc ANOVA.
• Performed data extraction from MS-Excel tables into SAS data sets.
• Analyzed data through problem solving. Performed data archival, Ad-hoc reporting, and coding utilizing SAS on WINDOWS and SAS/UNIX.
• Converted ORACLE data tables into SAS data files using SAS SQL Pass through Facility, and uploaded SAS data files into ORACLE tables using SAS DBLOAD procedure.
• Build reports from the processed data, generated several reports from analyzed data and converted the data into dbf format and sent to the client. Also the reports were sent to web, creating Universes using web intelligence.
• Used Output Delivery System (ODS) facility to write custom safety and efficacy reports directing SAS output to RTF and HTML files.
• Extensively used the SAS/ Macro facility to write weekly and monthly reports.

Environment: SAS 9.1.3, SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/SQL, Oracle, Window NT.