CAREER SUMMARY

• Over 6 years of extensive experience in SAS programming on different platforms - Windows and UNIX, also having worked in data extraction, data transformation and data analysis
• Experience in Data analysis and Reporting in healthcare, finance, pharmaceutical and marketing sectors. SAS experience includes detailed knowledge of statistical analysis of financial, marketing and healthcare data and in the production of reports, tables, graphs and listing
• Experience in SAS/BASE, SAS/MACRO, 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
• Thorough knowledge in all phases of data analysis, including definition and analysis of questions with respect to available data and resources, overview of data and assessment of data quality, selection of appropriate models and statistical tests and presentation of results
• Significant experience in requirement gathering, building, designing and testing the application to meet the functional Design and Business Process Design
• Strong experience with databases like Oracle, Teradata, MS SQL Server, DB2 and MS Access
• Extracting multi-million record file, data mining and analysis, creating marketing incentive reports
• Created reports in SAS and exported to Excel spreadsheets
• Strong ability to write SQL queries using PROC SQL
• 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 SOFTWARE 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
• Hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS ORACLE tables using LIBNAME and SQL PASSTHRU facility
• Experience in performing ad hoc queries for various application and reports on a daily/weekly or monthly basis
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly
• Effective team player with strong communication and interpersonal skills
• Skilled in using SAS Statistical procedures like PROC REPORT, PROC TABULATE, PROC CORR, PROC GLM, PROC ANOVA, PROC LOGISTIC, PROC TTEST, PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC LIFETEST

TECHNICAL EXPERTISE

Operating Systems: UNIX, Mainframe, MS Windows Language: SAS, SQL SAS Tools: SAS/Base, SAS/Macro, SAS/Stat, SAS/Connect, SAS/ODS, SAS/ACCESS, SAS/ETL, SAS/Graph, SAS EG Database: MS-Access, Oracle, Teradata, SQL server, DB2 Other Technologies: Visio, Microsoft Office Word, Excel, PowerPoint, Outlook

Professional Experience

Confidential

SAS Developer

As a part of SAS Informatics department at Horizon Blue Cross Blue Shield, my responsibilities include accessing data, creating data structures, managing data, generating reports, trouble shooting and reconciliation of errors. The project involves working with clients, both internal and external, to define customer data analysis needs and determine deliverables based upon customer's requirements. Also, in some cases we meet with customers to review business requirements and define parameters of the project and determine if the request requires a new methodology or process or if one currently exists that can be adapted and utilized for this request. Analyze data results from the data pull to ensure deliverables have been met, and provide summary analysis to customer.

Responsibilities:

• Create and use user-defined and automatic macro variables within the SAS Macro Language.
• Automate programs by defining and calling macros using the SAS Macro Language.
• Use various system options that are available for macro debugging and displaying values of user-defined and automatic macro variables in the SAS log.
• Create data-driven programs using SAS Macro Language.
• Generate detail reports by working with a single table, joining tables, or using set operators in the SQL procedure.
• Generate summary reports by working with a single table, joining tables, or using set operators in the SQL procedure.
• Demonstrate the use of advanced data look-up techniques such as array processing, formats, and combining/merging data.
• Reduce I/O by controlling the space required to store SAS data sets using compression techniques, length statements, or eliminating variables and observations.
• Reduce programming time by developing reusable SAS programs which incorporate data step views, DATA steps that write SAS programs, and the FCMP procedure.
• Perform effective benchmarking by using the appropriate SAS System options and interpreting the resulting resource utilization statistics.
• Determine the resources used by the SORT procedure and avoid unnecessary sorts by using appropriate indexes, data set options, BY statement options, and the CLASS statement.
• Also used SAS Statistical procedures like PROC REPORT, PROC TABULATE, PROC FREQ, PROC MEANS and Data steps, LIBNAME and SQL PASSTHRU facility to accomplish the tasks.

Environment: SAS Enterprise Guide, SAS/BASE, SAS/MACRO, SAS/CONNECT, Teradata, DB2, ORACLE, SQL Server

Confidential

Data Analyst

As a key member of People's Bank's statistical modelling team, developed and ran SAS programs to support Marketing and Analysis statisticians. I was responsible for creating new SAS codes, utilizing existing codes, and maintaining data in SAS. The project involved working with end users and analysts to provide analysis of credit card customer base on demographical basis and forecasting risk. The permissions to grant a credit card to an individual were based on the analysis done. The information of the person applying for the credit card is gathered and processed for further approval or rejection.

Responsibilities:

• Involved in Analysis and Marketing Team to make business decisions
• Interacting extensively with end users on requirement gathering, analysis and documentation
• Involved with key departments to analyse areas and discuss the primary model requirements for the project
• Documented methodology, data reports and model results and communicated with the Project Team / Manager to share the knowledge
• Involved in credit risk assessment model to calculate risk factor for individual clients based on hierarchy
• Developed complex SAS Macros to simplify SAS code and effectively reduce coding time
• Imported Data from relational database into SAS files per detailed specifications
• Imported data using LIBNAME and PROC SQL Pass -Thru facility to reduce processing time
• Performed complex statistical analysis using PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG and PROC ANOVA
• Extensively performed Data Cleansing during the ETL's Extraction and Loading Phase by analysing the raw data and writing SAS Program and creating complex reusable Macros
• Carried out data extraction and data manipulation using PROC SQL, PROC SORT, PROC REPORT to create preferred customer list as per business requirements
• Extensively used SAS procedures such as PRINT, REPORT, TABULATE, FREQ, MEANS, SUMMARY, TRANSPOSE and Data Null for producing ad-hoc and customized reports and external files
• Wrote SAS programs in UNIX platform
• Extensively used SAS ODS facility to create customized reports in HTMLPDF,RTF
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools e.g., SAS Integration Studio, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access
• Performed competitor and customer analysis, risk and pricing analysis and forecasted results for credit card holders on demographical basis
• Created reports in the style format RTF, PDF and HTML using ODS statements and PROC TEMPLATE

Environment: SAS/BASE, SAS/MACRO, SAS/ETS, SAS/CONNECT, SAS Enterprise Guide, Teradata, DB2, ORACLE, SQL Server, UNIX

Confidential

SAS Programmer/Analyst

Aetna is one of the nation's leaders in health care, dental, pharmacy, group life, 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. In this project, the first phase was migration of data from client data warehouse servers to application environment, second phase was to transform the required tables and flat files to SAS datasets the third and final phase was to develop SAS analysis datasets and reports.

Responsibilities:

• Involved in developing, testing, and writing programs and reports in SAS according to specifications as required
• Used LIBNAME and SQL PASSTHRU facility to read data from other sources
• Used SAS/ACCESS to read datasets from Databases, Flat files, also read and write other PC File formats
• Performed extraction, transformation and loading from large Oracle tables
• Manipulated existing Oracle database by accessing the data using SQL pass through facility
• Worked on pre-existing macros for data validation by checking data distribution and comparison to standard data
• Performed data cleansing by analysing and eliminating duplicate and inaccurate data using PROC FREQ, PROC COMP, PROC UNIVARIATE, PROC RANK, and macros in SAS
• Created new datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update, and conditional statements
• Validated, documented and tested component programs in an efficient manner for inclusion in integrated reports
• Developed, analysed and designed SAS programs in UNIX platform
• Generated highly customized reports in the form of listing, HTML, RTF and PDF using SAS ODS, PROC REPORT, PROC TABULATE, and PROC SQL
• Involved in discussions with business users and data architects to define metadata for tables to perform ETL process

Environment: Base SAS, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, Oracle, Teradata, DB2, MS Excel, UNIX

Confidential

SAS Programmer

Responsibilities:

• Developed analysis datasets based on the guidelines provided in the SAP Statistical Analysis Plan
• Provide SAS Programming and analysis support for phase II
• Generated reports on AE Adverse Events and SAE Serious Adverse Events Demographics, Laboratory shift tables by referring to the Statistical Analysis Plan and the Mockup Shells
• Validated TLGs by writing competing code and comparing the values produced with the source report values
• Created ad-hoc reports requests
• Extracted data from the database by SQL PASS THROUGH FACILITY and LIBNAME facility
• Created reports in RTF, PDF, Excel and HTML formats using ODS statements
• Developed macro programs defining the macro parameters using different debugging options like MPRINT, MLOGIC, and SYMBOLGEN
• Documented the developed macros explaining the functionality of the macro and the macro parameters defined for future reference
• Created Summary tables using procedures like PROC TRANSPOSE, SORT, FREQ, MEANS, SUMMARY, UNIVARIATE, AND TABULATE
• Created electronic datasets i.e., SAS Transport Files for submission by using PROC EXPORT for FDA submission
• Closely work with the statisticians and data managers to identify common factors across the projects

Environment: SAS 9, Base SAS, SAS/Macro, SAS/Graph, SAS/Stat, SAS/SQL, SAS/Access, oracle clinical, Outlook, MS office tools, Windows.