Summary:

• Over 9 years of extensive experience in SAS programming on different platforms - Windows and UNIX, also having worked in updating, data extraction, transformation and loading to data warehouse, data analysis, updating, testing and data validation.
• Experience in Data analysis and Reporting in health care, finance and marketing sectors. SAS experience includes detailed knowledge of statistical analysis of financial, marketing and health care data and in the production of reports and tables.
• Experience in SAS/BASE, SAS/MACRO, and SAS/ODS, SAS/SQL, SAS/STAT ,SAS/GRAPH, SAS/ACCESS, and SAS/CONNECT in UNIX and Windows environments.
• Developed new or modified existing SAS programs to load data from the source and create study specific datasets.
• Created reports in SAS and exported to Excel spreadsheets, created web reports using Web Report Studio.
• Strong ability to write SQL queries using PROC SQL.
• Experience in utilizing SAS Procedures, Macros, and other SAS applications for data extraction, data cleansing, data loading and reporting. Involved in the data analysis, DB creation, applying database constraints and make ready to load onto database.
• Involved in coding and pulling data from various oracle tables using Unions and Joins.
• Customize the variables to user-defined formats using PROC FORMAT in printing reports.
• Experience in working with SAS ENTERPRISE GUIDE for reporting and analytical tasks.
• Expertise in using various SAS report generating procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE and PROC PRINT.
• Experience in performing ad hoc queries for various application and reports on a daily/weekly or monthly basis.
• Hands on experience working with SAS Enterprise Guide, Information Map Studio, Data Integration Studio and Web Report Studio.
• 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.
• Experience in using SAS to read , write , import and export to another data file formats including delimited files , spreadsheet , Microsoft excel and access tables.
• Good understanding of software development life cycle concepts.
• Ability to adopt new technologies , and able to communicate and provide support to BI issues.

Technical Skills:

Professional Experience:

Confidential

SAS Programmer

Confidential is a leading retailer and direct marketer of women's classic apparel, shoes and accessories.Involved in extracting information of customer demographics and behaviors from clients database and generating various reports and various adhoc projects intended to provide insight into business trends and supported business in performing analysis of data using SAS code and reported the data to marketing specialists.

Responsibilities:

• Responsible for the extraction, validation, summarizations insights related to such analytical projects from marketing database.
• Involved in assessing analytical projects to determine the required data elements to be utilized for desired end result.
• Assisted in helping to segment the customer file for more productive and effective circulation efforts.
• Collaborated with circulation, loyalty and email marketing teams to undertake customer analytical or testing projects.
• Assisted in the evaluation of appropriate analytical tools to be incorporated for analytical purposes at marketing database host vendor.
• Assisted in the validation of data feeds for new marketing database vendor to meet required dates for going
• Worked with external database host vendor as needed to complete analytical projects.
• Involved in writing code using SAS/ Base SAS/Macros for creation of analysis datasets.
• Developed and executed SAS SQL queries for merging, concatenating and updating large volumes of data.
• Reviewing business requirements for standard reporting.
• Working on SAS business intelligence platform to drive the automation of standardized analytics.
• generating SAS EG stored process with static and dynamic prompts for product specific analyses
• Modifying existing codes for improvement in the performance.
• Advanced querying using SAS EG,Calculating computed columns,using filter, manipulate and prepare data for reporting, graphing, and summarization, statistical analysis, finally generating the data marton weekly basis.
• Importing SAS datasets, OLAP Cubes in SAS information Map Studio. Using instructions on how to access and combine relational data tables, calculating new data items, Created multiple pre-defined filters.
• Building quick reports from Web report studio using information maps, Create filters, graphs, and customize reports.

Environment:SAS 9.1.3, SAS/CONNECT, SAS Macros, SAS/ACCESS, Oracle 10g , Windows 7, MS Office, HTML, SAS Enterprise Guide , SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio , SAS Information Delivery Portal, SAS OLAP Cube Studio, SAS BI Dashboard, SAS Enterprise BI Server.

Confidential

SAS Programmer

Involved in creating efficient method of reviewing information from company data database and generating various reports which is a key parameter related to understanding the status of regional business, supporting business in performing analysis decision making and performed analysis on data using SAS code and reported the data to the Partners, improved client services by preventing errors, providing a real-time data and updating record.

Responsibilities:

• Interacted with business users, business analysts and translated business requirements into technical specifications.
• Responsible for writing SAS programs using Base SAS and SAS/Macros to create SAS reports.
• Extensive study, design, development and testing were carried out in the Oracle Environment
• Extensively involved in getting data from oracle database using SQL pass- through.
• Involved in writing code using SAS/ Base SAS/Macros for creation of analysis datasets.
• Performed data cleansing to eliminating duplicate and inaccurate data.
• Developed and executed SAS SQL queries for merging, concatenating and updating large volumes of data.
• Generated high quality reports and listings in HTML, EXCEL and PDF formats using

SAS /ODS.

• SAS/Enterprise Guide software was used for file and program management purposes.
• Creating various transformation procedures by using SAS 9.1, SAS Cube Studio, SAS Data Integration Studio, and SAS Enterprise guide.
• Using the Enterprise Guide Stored Processes, updating and developing macro programs code.
• Customizing the Business Intelligence Dashboard according to the requirement.
• Knowledge about the SAS Metadata Server and Data Warehousing development
• Complete understanding of SAS OLAP.
• Maintained OLAP cubes using SAS OLAP CUBE Studio to support reporting of information maps and Web

Reporting Studio

• Design of ETL process to meet the requirement of data demand.
• Created and maintained required Data marts and OLAP Cubes using SAS DI Studio and SAS OLAP Cube Studio to fulfill reporting requirements.
• Production Job Scheduling using SAS DI Studio.
• Worked on analyzing the code in Stored Processes and generating reports using WRS.
• Knowledge about the handling of SAS Open Metadata Architecture.

Environment: SAS/Base 9.1, SAS/EG 4.0, SAS Web Reporting Studio, SAS/Macro, SAS/Access, SAS/Connect, SAS/UNIX, SAS/ODS, SAS/Macros, ORACLE 9i, TOAD, SQL, MS Excel, Autosys..

Confidential

SAS Programmer

Confidential care is one of the nation's leader in health care, and disability insurance, and employee benefits I worked on membership and claims data and was involved in the complete software development life cycle of the project. Involved in Developing Enterprise Subject Data warehouse to implement a centralized database that collects, organizes and stores data from different operational data sources and ERP package to provide a single source of integrated and historical data for the purpose of reporting, analysis and decision support and to improve the client services by preventing errors, providing a real-time data and updating records as the transactions are completed.

Responsibilities:

• Extracting and converting data from one platform to another to be used for further analysis. From Oracle and Excel to SAS by using SAS SQL procedures and create SAS data sets.
• Developed new or modified SAS programs and used SQL Pass through facility and Libname methods to extract data from the Teradata DB and created study specific SAS datasets, which are used as source datasets for report generating programs. Extensively used various statistical Procedures like PROC FREQ, PROC MEANS to understand data quality, produce reports and handle the missing values
• Created SAS Datasets with the usage of SAS MACRO, Macro Variables, CALL SYMPUT.
• Created the customized reports based on total costs and sales based on different advertisements.
• Analyzed the data of advertised contents based on people response and created reports based on their demographic information.
• Generated customized reports using SAS/MACRO facility, PROC REPORT, PROC TABULATE and PROC SQL.
• Extensively performed Data Cleansing during the ETL's Extraction and Loading Phase by analyzing the raw data and creating complex reusable Macros
• Extensively used constraints for defining the data, modified the data and wrote queries and sub queries like non related and correlated queries in SQL for the data analysis.
• Created Macros and extensively used for the data analysis and producing the reports.
• Written Korn-shell FTP scripts to FTP files to the specific path in the UNIX environment and to backup SAS files from mainframe.
• Generated queries/reports and other activities like OLAP through the SAS OLAP Cube Studio, Forecasting and Analysis as requested.

Environment:Base SAS, SAS/ACCESS, SAS/CONNECT, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ODS, UNIX, Mainframes, SAS Enterprise Guide, SAS BI

Confidential

SAS Analyst

• Involved in creating SAS metadata objects for uploading the newly created SAS datasets into the data marts Created
• new SAS Base programs for the new requirements like promotions, campaigns etc using the newly acquired data in the
• various forms like flat files, CSV, XML, Excel files and other data sources like Oracle. Create staging datasets for the
• groups using the input data from data acquisition team.

Responsibilities:

• Involved in the building of data marts from enterprise data sources spread across platforms of the SAS DI studio.
• Created metadata objects by creating the data sources, targets and data transformations using the source, target and process designer of the SAS DI Studio also known, SAS ETL Studio .
• Created Lookup, Fact and Dim tables and Identifying the mapping data into specific domains as per the data model using SAS Enterprise Guide by creating the DATA and PROC steps as process tasks
• Involved in the Administration of the user authentications, metadata repositories, job scheduling, stored processes, data cleansing.
• Experience in creating OLAP cubes for reporting of pre-summarized large datasets and decision support systems using SAS Data Integration Studio and publish the same for business users.
• Generated SAS datasets, tables, listings, graphs and reports from analysis datasets using SAS tools like BASE, Macros, GRAPH and STAT.
• Created reports and stored procedures using SAS BI tool.
• Developed the data warehouse system for credit/debit OLTP process.
• Worked on transaction data and CRM data in credit limit increase and in marketing.
• Extracted data from Oracle views using various SAS/Access methods including Libname statements and SQL Pass through facility.
• Created and extracted Oracle tables from SAS and within Oracle by using PL/SQL using SAS/ACCESS and SAS/CONNECT
• Created efficient SA program using SAS Macros and Validated the same to optimize the resource utilization and faster processing .Documented and maintained libraries and catalogues of SAS programs and formats
• Developed SAS programs for quality checks.
• Involved in validating other programmers code.
• Developed utility macros for standard reports and validations.
• Produced multi-dimensional reports and tables using procedures PROC/REPORT, PROC/TABULATE,PROC/SQL and DATA NULL .
• Used in file statement options to control processing when reading raw data files in SAS.
• Used IMPORT and EXPORT procedures for importing and exporting the data to MS/EXCEL files.
• Developed programs in SAS/Base and SAS/SQL pass-through facility which produce the efficiency and to perform complex joins using the Oracle databases
• Enhanced reports through the use of labels, SAS formats, User-defined formats, titles, footnotes and SAS system reporting options
• Generated HTML, RTF, PDF reports using ODS statements.
• Produced high quality graphs through SAS/GRAPH for analysis studies.

Environment:SAS 9.1.3, SAS/Macros, SAS DI Studio 3.4 4.2, SAS Enterprise Guide 3.4 4.2, SAS EBI, SAS Management Console 9.1, SAS OLAP Cube Studio, SAS Enterprise Miner 5.3, SAS Information Map Studio, SAS Web report Studio,SAS Add-in for Microsoft Office, SAS Information Delivery Portal

Confidential

SAS Analyst

As a SAS developer and technical lead for the project, Involved in designing and testing SAS based software package in the UNIX platform by migrating SAS programs to UNIX .This activity include creating the folders in UNIX. Used TERADATA in an HP/UNIX environment for SAS jobs for analysis.Developed the campaign Management system. I handled many projects and worked on testing the new data models and taken care of ICM production job

Responsibilities:

• Helped various team members in setting up SAS Enterprise Guide environment.
• Created automated FTP's, automated Email macros using SAS and UNIX to desktop for analysis.
• Generated HTML, RTF, PDF and text reports using ODS statements and performed data analysis using SAS Base, TERADATA 12. And Microsoft Excel
• and database questions
• Assisted users with SAS Dome migration questions and occasionally with general PC, system
• Capability of resolving data quality issues during the migration of data from SQL Database to TERADATA
• Migrating of data from SQL Database to TERADATA containers to be used for analysis.
• Installed and creating a Scheduling tool PCRONTAB on UNIX platform.
• Designing the tools needed for SAS Dome migration for the Capital One Auto Finance Data analysts.
• Worked on the Credit Bureau Simplification project for campaigning auto loans.
• Creating the shell scripts in UNIX for creating the folder structure in UNIX and creating the .profile for the users.
• Changing of SAS codes from Windows environment pointing SQL to TERADATA and migrate the codes to
• structure in UNIX.
• Designing of UNIX environment and migrating the users from Windows to UNIX and creating the folder
• Acted as a Business Analyst and Gathering the requirements from users and documented.
• Migration project.
• Involved in development and testing of client specific SAS based software package for SAS dome
• Worked on administration and configuration of SAS Web Report Studio and Information delivery portal to create new users and authorizations and configuring the mail servers for the same.
• Experience in handling multiple projects.
• Developed and executed quality control checks on the data loaded in Teradata databaseby comparing the Dep2 and Dep3 data models.
• Developed ,Tested and scheduled codes for automated periodic reporting using SAS Management
• Console and verified its flow using SAS flow manger
• Proficient in working different databases environment such as MS SQL server and Teradata
• Experience in handling large databases and merging tables with millions of rows and creating test cases.
• Excellent organizational, inter-personal and presentation skills along with an ability to work efficiently in both independent and team environment.

Environment:SAS 9.1.3, SAS EG 4.1 4.2,SAS Add-in Microsoft office, Windows SAS, SAS Management Console,

SAS Web Report Studio, UNIX, PCRONTAB Scheduling, MS SQL 2005-2008, SAS/ACCESS, TERADATA 12 13.

Confidential

sas programmer

The company operates health care, group disability and life segments in the US. Managed Payments Commercial Market is a system to process the medical bills resulted from workers comp claims. It will receive the doctor and their pricing information from various venders and try to give the best quote for the claim. Manage payments will re-price the bills and prepare the checks for the eligible bills and disburse the checks to the provider.

Responsibilities

• Involved in Business Analysis and Systems Planning.
• Migration of data from text files and DB2 to SAS data sets.
• Used data step programming to extract the data from raw files sent by the customers and carriers insurance providers .
• Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Played a major role in quick generation of Ad-hoc Business Analysis Reports and resolving data issues upon request.
• Developed SAS programs using SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS for statistical analysis and data display.
• Developed an Automated Quality Control System for Data Validation and data integrity.
• Used ODS statements and PROC TEMPLATE to create reports in style format.
• Involved in various Testing phases Unit, System and Integration .
• Used SAS extensively to create ad hoc reports, match merge and created graphs by using SAS/GRAPH base.
• Used SAS Macros, PROC SQL to extract, sort match test accounts and ODS to HTML, PDF and RTF.
• Issue log maintained to track the Issues/Queries/Clarifications for each of the project.
• Implementation of Quality System Procedures.
• Ensured completion of the projects on schedule and within budget constraints. Monitored the projects from initiation through delivery SDLC that resulted in better control and organization.

Environment:SAS V8.2/9.1.3 , SAS/BASE, SAS/SQL, MVS/TSO using JCL, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/ODS, HTML, DB2, MS-Excel, UNIX

Confidential

sas programmer

Involved in creating efficient method of reviewing information from company data database and generating various reports which is a key parameter related to understanding the status of regional business, supporting business in performing analysis on data using SAS code o high risk patients and reported the data to the health care professionals, improved client services by preventing errors, providing a real time data and updating record

Responsibilities:

• Interacted with business users, business analysts and translated business requirements into technical specifications.
• Responsible for writing SAS programs using Base SAS and SAS/Macros to create SAS reports.
• Extensive study, design, development and testing were carried out in Oracle environment.
• Extensively involved in getting data from Oracle database using SQL pass through.
• Involved in writing code using SAS/Base and SAS/Macros for creation of analysis datasets.
• Performed data cleaning to eliminate duplicate and inaccurate data.
• Developed and executed SAS SQL queries for merging, concatenating and updating large volumes of data.
• Generated high quality reports and listing HTML, EXCEL and PDF formats using SAS/ODS.
• Quality checking, validating and verifying accuracy of reports developed.
• Producing reports by employing various SAS procedures like Proc Print, ProcReport,Proc Summary, ProcFreq, ProcTabulate, ProcMeans and ProcSQL.
• Generated highly customized reports using Data Null , Put statements, Proc Report, Proc Tabulate and Proc print.
• Creating, maintain and running SAS jobs to support specific solicitation and loading of database tables for analysis.
• Utilized korn shell scripting to automate daily tasks such as monitoring, reporting, archiving and error handling.

Environment:SAS/Base 9.1, SAS/EG 4.0, SAS/Macros, SAS/Access, SAS/Connect, SAS/Unix, SAS/ODS, Oracle9i, TOAD, SQL, MS Excel, Autosys.