SUMMARY:

• Having 7 years of experience as a Senior SAS Programmer and data analysis using BASE SAS and SAS EBI software.
• 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.
• Experience writing advance SQL programs for joining multiple tables, sorting data, creating SQL views, creating indexes and metadata analysis. Experience in performing Ad Hoc Queries for various application and reports on a daily, weekly and monthly basis using complex SQL Queries.
• Extensive experience in DATA merging sub setting with the use of PROC SQL, Merge and SET statements.
• Hands on experience with analysis of Claims Data, Membership Data, and Sales Rep data in healthcare industries.
• Experience in all phases of Software Development Life Cycle SDLC including Requirements, Analysis/Design, Development, Implement, Validation, and Testing. Expert in defining BI Standards, Best Practices, Code Review, DW standards and production support.
• Hands on experience in SAS programming for extracting data from flat files, Excel spreadsheets and external RDBMS ORACLE tables using LIBNAME and SQL Pass-Through facility.
• Good understanding of Data Warehouse concepts including Star Schema and Snow-Flake Schema
• Extensive experience in working on different SAS versions like 8.2, 9.1, 9.2 using SAS/BASE, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/MACRO, SAS/ODS, SAS/GRAPH, SAS/ETL, SAS/SQL.
• Hands on experience in working with SAS Enterprise Guide Software 4.1, 5.1 version for reporting and analytical tasks.
• Very proficient understanding of Data Modeling using Use Case Diagram OOAD/UML , Data Mining, SAS Data Miner, Data Warehousing and Predictive Modeling with expertise in Business Intelligence concepts using the SAS Forecast Studio.
• Extensively worked on SAS SCL to create object-oriented, interactive applications.
• Strong understanding in various Economic/Econometric and statistical concepts such as ANOVA, Correlation, Regression Analysis and Multivariate Analysis.
• Proven skills in Data Mining Techniques, Statistical Regression , Segmentation analysis, missing value pattern Mathematical and Econometric Models using SAS, STATA, etc.
• Knowledge in data warehousing and business intelligence concepts, design principles Experience in RDBMS development including SQL, PL/SQL, languages.
• Proficient in using Import and Export procedures to handle data in raw data files ORACLE, DB2, TERADATA and SYBASE database management systems.

• Thorough Knowledge and experience of Microsoft Office tools like MS Access, MS word, MS PowerPoint, MS Excel, MS Visio, MS Project Management, and MS Outlook.

EXPERIENCE:

Confidential

Sr. SAS Programmer/Analyst

Responsibilities:

• Accountable for production support which includes scheduling the jobs on daily, weekly, monthly, quarterly and yearly basis, setting up the environment variables, troubleshooting the issues, finding the root cause of the issues, and resubmitting the failed jobs in production.
• Responsible for migrating SAS and SQL codes, and data across the servers, within the server and in subversion tool. Also responsible for setting up FTP/AFTP processes to move the data files across the environments.
• Extensively used BASE SAS, Macros, and SAS SQL for advanced programming and production support. Used Unix commands find, grep, search, locate to search FTP directories for failed jobs and created process to automate the failed jobs in production.
• Assisted in setting up a production release process which includes detailed release/install documents, approvals method, primary secondary contacts, data/log/archive files location, details of FTP/AFTP processes, affected business areas/groups information, process for escalating issues to appropriate team leads.
• Actively involved in system integration testing, unit testing, regression testing , performance testing and back testing.
• Extensively used Proc Sort, Proc Freq, Proc Means, Proc Summary, Proc Comp, and Proc Univariate to perform data cleaning and used Proc Sort with nodupkeys and noduprecs options to remove the duplicate records.
• Developed SAS scripts to scan all the logs and sends the error reports to the respective teams
• Scheduled jobs in Cron Tab to automatically kick off the jobs in scheduled time frame.
• Communicated with production management to identify highly impact business areas, and implemented solutions into production workflow.
• Designed, developed and executed UNIX shell scripts to automate production jobs, distribute reports, email job status to responsible teams, zip/unzip/move/archive/FTP/AFTP input and output data files, and reports, and delete old log files.
• Involved in modifying complex SAS and SQL codes, SAS Macros and SQL Stored Processes and applied new SAS programming methods and techniques to make it more efficient and bring them up to the current standards.
• Attended technical meetings daily scrum meeting and worked closely with senior Business Systems Analyst, Architects, DBA's, and other team members to understand the issue, find the root cause and resolve the issues.

Environment: SAS/BASE 9.3, SAS/EG, SAS/STAT, SAS/SQL, SAS/SCL, SAS/GRAPH, SAS/MACRO, PL/SQL, SAS/ODS, SAS/ACCESS, SAS/CONNECT, WinSQL, IPSwitch, Subversion, Toad, Putty, DB2, Oracle 11g, Reflection X, MS SQL Server, Microsoft Access, Shell scripts, MS SharePoint, Sun Solaris 9 10, Windows 7

Confidential

SAS/SQL Developer

Responsibilities:

• Programming and analyzing in guiding with the design and development of the application.
• Performed SAS programming using techniques as SAS Base, SAS Macro, data manipulation techniques, and statistical procedures e.g., Proc Means, Proc Freq, Proc Report .
• Performed Data Validation and Data Cleaning on Clinical Trial data.
• Extensively done SAS/Macro Programming.
• Used SCL for customized method developments and integrating PROCs with components.
• Designed flowcharts indicating the input data sets and the techniques that would be used sorting, merging, etc. to get the desired output.
• Exposure to Data warehouse applications.
• Preliminary data validation clinical data quality checks is done on the clinical trial data using SAS/SQL.
• requirements.
• Produced SAS Graphical reports showing Trend Analysis charts for campaign.
• Used SAS PROC SQL Pass through Facility and SAS/CONNECT to work with Oracle database.
• Used SAS GRAPH for generating various graphs and charts for analyzing the product sales.
• Upload SAS data sets across platforms from PC to UNIX and Vice Versa.
• Involved in clinical trial studies, data migration/extraction of data from Flat files, SQL Tables and SAS datasets.
• Created CRT Case Report Tabulations datasets using CDISC standards for submissions to the FDA.
• Extensively used Dynamic Data Exchange DDE for importing data in Excel sheets into SAS
• Extracted, validated and generated SAS data sets from Oracle applied 'SQL Pass through Facility'.
• Analyzed PhaseI, II and III Clinical Trials.
• Performed statistical analysis, wrote SAS code for Data Management and reporting, and performed validation, including testing SAS code.
• Produced Tables/Listings for Integrated Summaries of Efficacy ISE and Safety ISS .
• Maintained appropriate study application documentation.
• Created and maintained SAS Datasets that are extracted from an Oracle Clinical Database.
• Created SAS Customized Reports using Data Null technique for FDA regulations.

Environment: SAS/BASE V9.1.3, V8.2 , SAS/STAT, SAS, SAS/MACRO, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/ETS, SAS/QC, SAS/Connect, UNIX, SQL, MS Access, EXCEL, SPSS, Windows XP

Confidential

SASProgrammer

Responsibilities:

• Accessed and analyzed the data based on the requirement using SQL, SAS and MS Excel.
• Performed ETL tasks in extracting the Sales data from databases using SAS procedures like SAS/SQL, SAS/Access and creation of datasets.
• Performing data analysis, data migration, data preparation, graphical presentation, Statistical analysis, reporting, validation and Documentation
• Analyzed large data sets consisting of million records using PROC SQL, PROC SORT, PROC PRINT, PROC TABULATE procedures.
• Retrieved the original data and convert them into SAS readable format. Make the SAS data sets, analyze data as per given requirement.
• Interactively meeting the Actuarial teams for getting the required data to generate the reports as per business requirements.
• Performed data analysis to identify the fraud claims internally.
• Performed ETL tasks in extracting the Claims data from databases using SAS procedures like SAS/SQL, SAS/Access and creation of datasets.
• Created UNIXKorn shell scripts to export environment variables and deleted old files.
• Developing and analyzing key performance indicators relevant to emerging business needs using PROC FREQ, PROC TABULATE, PROC MEAN, PROC UNIVARIATE, PROC GLM, PROC TTEST, PROC TRANPOSE, and DATA NULL
• Generated listings and reports from SAS programs using MACROS, ODS and PROC TEMPLATE/REPORT/TABULATE and using Word, Excel and PowerPoint as well
• Built summary reports after identifying customers, occupancy period and revenue generated using PROC SUMMARY, MEANS and FREQ. Updated Revenue item table on a daily basis.
• Cubes are built using the Teradata tables and created some intermediate required data sets which will be joined using the Cube Studio.
• Generating reports to communicate key findings and articulate strategic implications using PROC PRINT, PROC REPORT, PROC TABULATE, PROC MEAN,PROC GPLOT and PROC GCHART.
• Developing SAS programs using SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS, etc for statistical analysis and data displays
• Documented purpose and methods used in each SAS program

Environment: UNIX AIX 5.2 , XP, Base SAS v9, VI Editor, SAS Enterprise Guide, SAS/MACRO, SAS/GRAPH, SAS/STAT, MS Excel.

Confidential

SAS Programmer/Analyst

• Programming and analyzing in guiding with the design and development of the application.
• Drawing flowcharts indicating the input data sets, sorting and merging techniques to get the required output and then writing the code.
• Find top customers for the target lists Look for responsiveness of targets based on sales effort.
• Extensively used Arrays in SAS Data Steps.
• Extensively done SAS/Macro Programming.
• Used SCL for customized method developments and integrating PROCs with components.
• Used SAS DATA NULL and PUT statements to create the customized reports.
• Developed new macros for report generation using SAS/Macro as per the customer's requirements.
• Produced SAS Graphical reports showing Trend Analysis charts for campaign.
• Used SAS PROC SQL Pass through Facility and SAS/CONNECT to work with Oracle database.
• Used SAS GRAPH for generating various graphs and charts for analyzing the product sales.
• Upload SAS data sets across platforms from PC to UNIX and Vice Versa. Environment: SAS/BASE, SAS/STAT, SAS, SAS/MACRO, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/ETS, SAS/QC, SAS/Connect, UNIX, SQL, MS Access, EXCEL, SPSS, Windows XP

Confidential

SAS Analyst

Responsibilities:

• Involved in the administration of the enterprise data warehouse using warehouse administrator.
• Written SAS code for developing data sets from raw data files received in text format. This included cleaning data.
• SAS/ENTERPRISE GUIDE software was used for file and program management purposes.
• Connected to Oracle and pulled data into SAS data sets using SQL pass through facility.
• Wrote different joins and merges to create reports based upon the requirements given.
• Written queries in Teradata SQL assistant to retrieve data from Teradata tables.
• Written macros to automate the code so that they generate reports on the invocation of the macro which helped to save time and manual intervention.
• Extracted, transformed, and loaded data using SAS/ETL.
• Used procedures like PROC REPORT, PROC TABULATE, PROC MEANS, PROC SORT, PROC FREQ, PROC CONTENTS and PROC DATASETS to generate different reports and run metrics on different data sets.
• Created tables, views in Teradata and Oracle as well as indexes and keys on different columns.

Environment: Base SAS, SQL, PL/SQL, Teradata SQL assistant, Mainframes, UNIX, SAS, Visual Basic, SAS/EG, SAS Warehouse.

Confidential

SAS Programmer

Responsibilities:

• Develop, enhance execute complex programs and reports with proper documentation.
• Develop business domain expertise, rudimentary project based business knowledge and good theoretical knowledge of tools like SAS, MS office Independently delivers end to end on complex projects and assist in developing and testing new information infrastructure.
• Manage end-user expectation in the delivery of projects within agreed timelines and as per agreed quality standards.
• Independently executes standard processes, implements predefined algorithms, and corrects identified problems.
• Maintaining large data sets, i.e. reading in data from various sources in various formats to create SAS data sets and/or ASCII files.
• Documenting the process, i.e. documenting all the possible information about the application like SAS programs, DATA files and source.
• Preparing project plan for the execution.
• Technical specifications. Assist in developing and testing new information infrastructure.
• Take ownership and actively manage project timelines. Execute standard reports, processes, files, and implements predefined algorithms
• Sets up QA/QC framework and ensures adherence and constant improvement.

Environment: SAS, BASE/SAS, SAS/MACRO, SAS/SQL, SAS/CONNECT, SAS/ACCESS, SAS/ODS, Oracle, Teradata, DB2, UNIX and Windows 2003/XP.