We provide IT Staff Augmentation Services!

Sas Programmer/analyst Resume

PROFESSIONAL SUMMARY

  • Over 7 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, trending, mapping analysis and business driven 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, tables, graphs and listing.
  • 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
  • Thorough grounding 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, MS SQL Server 2000, DB2 and MS Access
  • 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
  • Strong skills in Data Analysis, Data Requirement Analysis, and Data Mapping for ETL process
  • Extensive experience to handle large amounts of data for Data Cleansing, Data Profiling and Data Scrubbing
  • Extracting multi-million record file, data mining and analysis, creating marketing incentive reports
  • 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 SOFTWARE for reporting and analytical tasks
  • Extensive knowledge of advanced SAS/STAT procedures including UNIVARIATE ANALYSIS, REGRESSION, ANOVA, GRAPH AND PLOT
  • 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
  • Hands on experience working with SAS Enterprise Guide, Information Map Studio, Data Integration Studio and Web Report Studio
  • Possess a strong ability to adapt and learn new technologies and new business lines rapidly
  • Effective team player with strong communication & 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
  • 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

Technical Expertise

Operating Systems: UNIX, Mainframe, MS Windows XP/Vista, MS 2003 server
Language: SAS 9.1.3, SAS 9.2, SQL, C
SAS Tools: SAS/Base, SAS/Macro, SAS/Stat, SAS/Connect, SAS/ODS, SAS/ACCESS, SAS/ETL, SAS /Graph, SAS/OLAP Server, SAS BI platform, SAS EG, SAS EBI, SAS add-in MO, SAS WRS
Business Intelligence: SAS Management Console, SAS Enterprise Guide, SAS Data Integration Studio, SAS Information Map Studio, SAS Web Report Studio
Database: MS-Access, Oracle, Metadata, SQL server, DB2
Other Technologies: Visio, Microsoft Office (Word, Excel, PowerPoint, Outlook)

Education

Bachelor of Science in Biotechnology

Professional Experience

Confidential, CT Jan 2011-Present
SAS Programmer

As a key member of People’s Bank’s statistical modeling 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 & Marketing Team to make business decisions
  • Interacting extensively with end users on requirement gathering, analysis and documentation
  • Involved with key departments to analyze 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
  • Analyzed business requirements, transformed data, and mapped source data using the Teradata Financial Services Logical Data Model tool, from the source system to the Teradata Physical Data Model
  • Involved in credit risk assessment modelto 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 analyzing 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
  • Responsible for generating Financial Business Reports using SAS Business Intelligence tools (SAS/BI) and also developed ad-hoc reports using SAS Enterprise Guide
  • Developed Income statements & Balance sheets in MS Excel
  • 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
  • Performed Consumer profiling, Sales forecasting and testing of financial and business models
  • Effectively prepared and published various performance reports and presentations

Environment: SAS/BASE , SAS/MACRO, SAS/ETS, SAS/CONNECT, SAS Business Intelligence, SAS Enterprise Guide, SAS Enterprise Miner, SAS Web Report Studio, SAS Data Integration Studio, SAS Information Map Studio, SAS Management Console, SAS OLAP & EBI Server, Teradata, DB2, ORACLE, SQL Server Windows XP

Confidential, Hermitage, PA Dec 2009-Dec 2010
SAS Programmer

F.N.B (First National Bank) is a leading provider of banking, wealth management, insurance, merchant banking and consumer finance services. As a SAS programmer I worked with Business people to analyze the demographic credit card customer base and forecast risk associated with each customer segment. This allowed Risk Managers and Analysts to communicate risk measures across the enterprise, made the decision making process easy for the Senior Managers. The goal of the project is maximizing the profitability and efficiency.

Responsibilities:

  • Interacted with Risk Managers and Analysts to define targeted customer segments
  • Extract, transform and load datasets with basic modeling variables for each segment type
  • Used LIBNAME, PROC IMPORT and SQL PASSTHRU FACILITY to import data from Oracle database into SAS files
  • Manipulated and updated the tables as per specifications
  • Performed data cleaning by analyzing and eliminating duplicate and inaccurate data using PROC FREQ, PROC COMP, PROC UNIVARIATE, and macros in SAS
  • Formulated action plans and presented key information regarding profit dynamics to the senior management in the Bank
  • Maintained consistency of SAS variables formats and sorted various datasets using PROC SORT and merged them using MERGE
  • Used regression techniques ANOVA, CORR, PROC MEANS and PROC FREQ to analyze data
  • Prepared ad-hoc reports, documenting SAS work, and directing SAS outputs to RTF and HTML files through SAS ODS facility
  • Developed complex SAS macros to simplify SAS code and effectively reduce coding time
  • Involved in writing the TDR’s and FDR’s for any new change or enhancement
  • Involved in gathering, analyzing and documenting business and technical requirements
  • Performed complex statistical analysis using PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG, and PROC ANOVA
  • Modified Korn-shell scripts on UNIX to schedule the program to run twice in a month
  • Involved in Korn-shell scripts for executing SAS batch files on UNIX to save the execution time and for automation
  • Worked on advance querying the database using SAS Enterprise guide in calculating and computing columns, using filters, manipulated and prepare the data for reporting and statistical summarization
  • Involved in designing the project and process flow diagrams using SAS Enterprise Guide
  • Created Pivot tables in Microsoft excel for the SAS DATASETS for further calculations
  • Used SQL and PROC SQL for ad-hoc report programming and creation of the ad-hoc reports for marketing research data
  • Performed statistical analysis of financial and operational data
  • Extensively used Data _Null_ and SAS procedures such as PRINT, REPORT, TABULATE, FREQ, MEANS, SUMMARY and TRANSPOSE for producing ad-hoc and customized reports and external files
  • Generated high quality reports in the form of listing, HTML, RTF and PDF formats using SAS ODS
  • Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools e.g., SAS/Base, SAS Enterprise Guide, SAS/Macros, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access

Environment: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/CONNECT, SAS/GRAPH, SAS/ODS, MS Excel, Teradata, Oracle9i, UNIX, Korn-shell, Enterprise Guide

Confidential, Hartford, CT May 2008 – Oct 2009
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 analyzing 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.
  • Transferred and Migrated Data from one platform to another to be used for further analysis.
  • Developed, analyzed 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.
  • Involved in the development of a management reporting system which used a web front end to generate user queries.
  • Developed standardized web reports using SAS BI suite oftools
  • Responsible for the development and maintenance of SAS Information Maps for Analytics and Business forecasting Team
  • Generated reports using Web Report Studio on the sales data as per the client requirement
  • Assisted in the design & maintenance of client reporting pages delivered through the SAS Information Delivery Portal
  • Created various transformation procedures by using SAS 9.1, SAS Data Integration Studio, and SAS Enterprise Guide

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

Confidential, Pittsburgh, PA April 2007– April 2008 SAS Programmer

Responsibilities:

  • Integration of Data from MHS Source Systems (Claims/Service Lines/ Members)
  • Connected to various databases such as development and production databases using SAS/ACCESS, SAS/CONNECT
  • Managed communications with software providers, coordinate work with the IT team in regard with proprietary server maintenance and system support
  • Assisted in investigating and applying new SAS programming methods and techniques to enhance current systems by using various SAS macros and standard programming procedures
  • Developed new or modified SAS programs and used SQL Pass Through and LIBNAME methods to extract data from the databases and created study specific SAS datasets, which are used as source datasets for report generating programs
  • Imported raw data files in excel format in SAS and subsequently created SAS datasets and performed data cleaning and data manipulations for further analysis and reporting
  • Extensively used SAS Data Step and PROC SQL to generate various reports as per Ad-hoc requirements
  • Used SAS Data Step logics to Sort, Merge, Stack, Update and Interleave datasets for producing required analysis of data
  • Performed analysis of data using PROC SUMMARY, PROC FREQ, PROC MEANS, PROC ANOVA, PROC SQL, PROC UNIVARIATE and so on
  • Generated customized reports using PROC REPORT, PROC TABULATE and PROC SQL.
  • Generated high quality reports in the form of listing, HTML, RTF and PDF formats using SAS ODS
  • Generated Information Maps using Information Map Studio and created Ad-Hoc reports on need basis using SAS Web Report Studio
  • Responsible for importing, manipulating and generating weekly and monthly list reports using SAS Enterprise Guide
  • Created, executed and monitored data quality assurance processes
  • Served as liaison between sales, compensation and accounting organizations to ensure consistency in reporting standards
  • Supported the development of a management reporting system which used a web front end to generate user queries

Environment: SAS/Base, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, Oracle 9i, DB2, PL/SQL, MS Excel, MS Access

Confidential, India Dec 2005-Jan 2007
SAS Programmer

Access Pharmaceuticals, Inc. is a biopharmaceutical company that focuses on oncology and supportive care of cancer patients. This project has to evaluate ProLindac drug’s effectiveness and decreasing the toxic side-effects on patients with ovarian cancer.

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.
  • 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.

Hire Now