SUMMARY:

• SAS Certified programmer/analyst with around 8 years of experience in Analysis, design, development, testing and validating the applications.
• Have good knowledge about financial, health care, Retail industries.
• Extensive experience in working with Base SAS (MACROS, Proc SQL, ODS), SAS Enterprise Guide, SAS/ACCESS and SAS/GRAPH in UNIX, Windows environment.
• Expertise with SQL Server Reporting Services (SSRS) and Integration service (SSIS).
• Solid understanding and proficient use of various Procedures like proc SQL, proc summary, proc report, proc freq, proc means, proc contents, proc dataset and proc append proc import, proc export, proc print, proc print, proc sort.
• Proficient with relational database concepts such as SQL, MS Access and Reporting using SAS.
• Experience in using SAS to Import/Export data to external file formats like flat, Excel, XML files.
• Thorough knowledge in SAS Programming, using Base SAS, Macro Facility, Proc SQL, SAS Procedures, SAS Functions, SAS Formats, and ODS facility in data scrubbing, manipulation, and preparation to produce summary datasets and reports.
• Followed Software Development Life Cycle (SDLC) methodology for the Analysis, Design, Development, Testing and Maintenance of various SAS modules.
• Thorough knowledge and experience of Microsoft Office tools like MS Access, MS word, MS PowerPoint and MS Excel.
• Good knowledge with SSRS and SSIS integration tools with the servers
• Exceptional verbal and written and strong communication skills in particular explain complex technical concepts and applications to both technical and non - technical audience at ease.
• Ability to work independently as well as collectively.

TECHNICAL SKILLS:

SAS Tools: SAS 9.1.3/9.2/9.4, Base SAS, SAS/MACROS, SAS/GRAPH, SAS/SQL, SAS/ODS, SAS/ETL, SAS/Access, SSRS and SSIS integration Tools, SAS/Connect, SAS/PC, SAS/INTRNET, SAS Enterprise Guide, etc.

Languages: C, SQL

Databases: Oracle 10g/9i/8i, MS Access, SQL Server 2000, DB2.

MS Office tools: MS Office - Access, Excel, Power Point, & Word

Operating Systems: MS-DOS, Windows 9x/NT/2000/XP, UNIX, Linux

PROFESSIONAL EXPERIENCE:

Confidential, MA

SAS Programmer/Analyst

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 Datasets.
• Extensive study, design, development and testing were carried out in the UAT 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 eliminate duplicate and inaccurate data.
• Responsible for SSRS Data reporting services and Integration services.
• 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 Formats, Table Look ups, SAS Functions.
• Using the Enterprise Guide Stored Processes, updating and developing macro programs code.
• 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.
• Extensively used SAS procedures like Proc Summary, Reports.
• Export jobs to Production environment and scheduling the jobs by using SAS SMC.
• Knowledge about the handling of SAS Open Metadata Architecture.

Environment: SAS/Base 9.1, SAS/EG, SAS/Macro, SAS/Access, SAS/UNIX, SAS/ODS, SAS/Macros, ORACLE 10g, SSRS and SSIS services, TOAD, SQL, MS Excel, Autosys, SAS/OLAP CUBE Studio, SAS/DI Studio.

Confidential, IL

SAS Programmer

Responsibilities:

• Developed SAS code to perform ETL (Extraction, transformation and loading) of data to create SAS database.
• Responsible for analysis, design, development, testing, implementation and provided technical support to business needs using SAS.
• Interface with business customers and software developers, gathering requirements and delivering complete reporting solutions.
• Hands on experience in SAS programming for extracting data from flat files, Excel spreadsheets and external RDBMS tables using LIBNAME and SQL PASSTHRU facility.
• Extensive experience of Data merging, Data sub setting with the use of PROC SQL, MERGE and SET statements.
• Hands on experience with SAS/BASE, SAS/MACRO, SAS/STAT, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/CONNECT and SAS/ODS procedures.
• Generated highly customized reports for claim data using SAS/MACRO facility, PROC REPORT, PROC TABULATE, PROC SUMMARY and PROC SQL.
• Developed Stored Processes to distribute reports and in a secure manner.
• Depending on the requirements involved developed various information maps, stored process using proc report which are used in further in reporting.
• Generated Web based reports in Web Report Studio and created portal pages and portal content using SAS IDP.
• Involved in deploying and re-deploying the jobs in SAS DI studio and monitoring the jobs.
• Moving application code from development environment to production and conducting commission test plan for the jobs that has been implemented.
• Involved in code review and test case preparation and unit testing.

Environment: SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACRO, SAS/EG, SAS/GRAPH,SSRS and SSIS Integration tools, SAS/ACCES, SAS/ODS.

Confidential, Connecticut

SAS Programmer

Responsibilities:

• 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
• Developed complex SAS Macros to simplify SAS code and effectively reduce coding time
• Imported Data from relational database into SAS files per detailed specifications 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
• Responsible for generating Financial Business Reports using SAS Business Intelligence tools (SAS/BI) and also developed ad-hoc reports using SAS Enterprise Guide
• Extensively used SAS ODS facility to create customized reports in HTML, PDF and RTF.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools e.g., SAS Integration Studio, SAS/Graph, SAS/SQL and SAS/Access
• Effectively prepared and published various performance reports and presentations

Environment: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/ETL, SAS/ODS, SAS/GRAPH, Oracle, SAS/CONNECT, SAS/STAT, SAS/ENTERPRISE GUIDE, Windows, MS Excel.

Confidential, Rhode Island

SAS Programmer

Responsibilities:

• Complex and unstructured data is verified and using PROC and MACROS it is made into a structured format.
• Responsible for monthly surveillance reports tracking deals for Profit and Loss analysis using SAS and Excel.
• Created ETL workflows in SAS/Data Integration Studio to populate the analytical data marts for business reporting.
• Designed, implemented, and maintained the Data Warehouse extracts, transformation and load (ETL) processes (including timeliness, accuracy, completeness. and metadata).
• Involved in developing and maintaining documentation of operational processes and data mappings.
• Developed data load programs using SAS Enterprise Guide to insert data periodically into the SAS server in UNIX.
• Designed and coded ETL processes with varied source systems like Oracle, SQL Server and flat files.
• BASE SAS procedures like FREQ, MEANS, SQL,SORT are used to validate current results with expected results.
• Performed quality control (QC) checks against database to ensure correct data was entered.
• Developing standard reconciliation programs using MACROS.
• Created ETL workflows in SAS DI Studio to populate the analytical data marts for business reporting.
• Enhanced the existing SAS Macros to automate the job.
• Exported large SAS data sets to external files to be sent to external vendors using SAS and SAS/Macro.
• Hands on experience in merging SAS data sets using SAS EG.
• Created process flow diagrams, and data mapping documents.
• Developed an application using Base SAS, Proc SQL and Proc Contents to generate concise data profiling reports.

Environment: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/ETL, SAS/ODS, SAS/GRAPH, Oracle, SAS/CONNECT, SAS/STAT, SAS/ENTERPRISE GUIDE, Windows, MS Excel

Confidential

Statistical Programmer

Responsibilities:

• Understand and update the existing code or create new code by using BASE/SAS, SAS/MACROS and SAS/SQL to implement new requirements.
• Expertise in statistical modeling and analysis on study data by utilizing appropriate statistical methods.
• Get the Production the SAS code and analyze.
• Wrote various format and integrity edit checks on CSV files and on staging SAS datasets.
• Develop SAS code to validate data of different portfolios.
• Modified existing SAS programs and created new programs using SAS macro variables to improve ease and speed of modification as well as consistency of results.
• Generate Reports in user required format by using ODS and PROC Report.
• SAS data sets are validated using SAS procedures like Proc Means, Proc Frequency and Proc UNIVARIATE.
• Performed data integrity checks and data cleaning using SAS MACROS and data steps, created HTML outputs with table of contents using ODS HTML.
• Used SAS PROC SQL Pass through Facility to work with Oracle database.
• Analyzed and implemented the code and table changes to improve performance and enhance data quality.
• Done Code Optimization using SAS macros.
• Creates and revises the common macros.
• Reading data from different sources like .csv, excel, tab delimited files.
• Perform various business checks on the source data to confirm whether data is correct or not.
• Extensively utilized SAS/BASE, SAS/SQL and SAS/MACRO.
• Extensively used procedures such as PROC APPEND, PROC IMPORT, PROC MEANS, PROC SUMMARY, PROC CONTENTS and PROC SQL.

Environment: SAS 9.1.3, BASE/SAS, SAS/MACRO, SAS/SQL, SAS/CONNECT, SAS/ACCESS, SAS/ODS, Oracle 11g, UNIX and Windows XP.