Professional Summary:

• Over 7 years of IT Industry Experience in Software Development using Windows SAS PC SAS , Mainframes SAS and UNIX SAS.
• Strong experience in new application developments and enhancements of existing applications by following Software Development Life Cycle SDLC i.e. Requirements gathering, design, development, testing and maintenance by following Software Development Life Cycle SDLC to implement software applications using SAS Reporting and SAS Data warehousing ETL - Extraction, Transformation and Loading
• Proficient in SAS/BASE, SAS/SQL, SAS/Macro, SAS/Connect, SAS/Access, SAS/ODS, SAS/STAT and SAS/GRAPH
• Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Good at UNIX Commands and UNIX Schell scripting.
• Experience with Banking, Insurance and Supply Chain domains.
• Proficient in DATA STEP Programming and SAS functions like SUBSTR, INDEX, SCAN, COMPRESS, COMPBL, STRIP, INTNX, INTCK, CAT etc.
• Extensively used SAS procedures such as PROC SORT, PROC MEANS, PROC SUMMARY, PROC FREQ, PROC TABULATE, PROC REPORT, and PROC PRINT for producing customized reports and external files.
• Experience in data manipulation procedures such as formats/informats, merge, proc data sets, proc sort, proc transpose and proc rank.
• Good at understanding of SAS Data warehousing and SAS Business Intelligence concepts
• Good at understanding of SAS data warehousing tool- SAS Data Integration Studio 3.4/4.2
• Good at understanding of SAS Business Intelligence Tools like SAS OLAP Cube Studio 4.2 To create OLAP Cubes , Information Map Studio 4.2 To create information maps on data marts , Web Report Studio WRS 4.2 To create web reports using Information maps , SAS Information Delivery Portal IDP 4.2 To publish reports on web for users
• Experience with database manipulation using SQL commands.
• Ability to work efficiently in both independent and team environments, worked with Project Managers, Team Members / Associates, Statisticians, Business Analysts.
• Strong Problem Analysis Resolution skills and ability to work in Multi Platform Environments like Windows and UNIX.
• Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.
• Excellent written and verbal communication skills.
• Resourceful, able to find solutions when faced with challenges.

Technical Skills:

SAS Tools : Base SAS 9.3/9.2/9.1.3 /8.2/8.1, SAS/SQL, SAS/Macro, SAS/Connect, SAS/Access, SAS/ODS, SAS/STAT and SAS/GRAPH, SAS Enterprise Guide

Other Tools : MS-Excel, MS-Word, MS-VISIO, MS-PowerPoint

Databases : Oracle, SQL Server, DB2, Teradata, Microsoft SQL Server, MySQL and MS- ACCESS

Languages : SAS, SQL, HTML

Operating Systems : Mainframes, Windows 95/98/XP/Vista/Win 7, UNIX, MAC OS, DOS

Batch Server : UNIX, Putty, SSH, Shell Scripting

Professional Experience:

Confidential

Sr.SAS Programmer/Analyst

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Extracted raw data from an Oracle database and used SAS/ACCESS to read it and run statistical analysis using SAS/STAT.
• Worked with SAS and Proc SQL to extract marketing demographics from a Teradata data warehouse for model testing, segmentation, scoring, and list management purposes.
• Performed advanced querying using SAS Enterprise Guide, calculating computed columns, using filter, manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis, finally generating SAS datasets.
• Developed, modified and generated Monthly Business Review MBR reports and Quarterly Business Review QBR reports summarizing business activity using Proc Univariate, Proc Copy, Proc Transpose, Proc Report, Proc Tabulate and Proc Summary.
• Created financial mortgage data sets using Data steps, DDE functions and DATA NULL .
• Created new financial tables and manipulated customer data by using various joins and merges and then appended the data Proc append from the existing source tables containing millions of records.
• Review and modify SAS Programs, created customized ad-hoc reports, process data for publishing business reports automate and distribute designed business reports on schedule in various format.
• Worked on generating ad hoc reports, tables and graphs for presentations and data modeling using SAS Web Report Studio.
• Importing all Reports from web report studio, Stored Process, BI Dashboard and Information Map to Information Delivery Portal.
• Developed loss prediction model using Enterprise miner modeling solutions and SAS procedures.
• Created and delivered reports and presentations with key findings and recommendations.
• Provided technical support on SAS programming related to data manipulation and analysis.
• Wrote macros, developed concise SAS scripting and used SQL to concatenate and join datasets from different database management systems using indexes and loops
• Exported SAS Reports to the Excel Sheet by using ODS/Tagsets/ExcelXP to get the output in multisheets.
• Developed and used scripts to schedule SAS Jobs.
• Customizing the existing Macros according to the need and requirement, testing and debugging the Macros and creating more complex and reusable Macros.

Environment: SAS 9.3, SAS Base, SAS Macros, SAS/Connect, SAS/Access, Oracle 11g, Windows 7, MS Office, HTML, SAS Enterprise Guide , SAS Stored Processes, SQL, and Teradata.

Confidential

SAS Programmer/Analyst

Responsibilities:

• Extracted data from Oracle database warehouse .
• Prepared new datasets and modified existing datasets using Set, Merge, Sort, Update, Formats and Functions and created Tables and Listings for the same.
• Also created and maintained SAS datasets that are extracted from an Oracle Database using SAS/ACCESS for ORACLE and extensively used Proc SQL to manipulate the data.
• Used Proc SQL Pass-Through method and Proc Append methods to write statistical analysis results to the ORACLE database.
• Converted Excel tables and flat text files into SAS datasets for Ad-Hoc analysis.
• Data analysis, reports using SAS procedures and SAS/Macros.
• Used SAS/STAT to create different statistical reports as required.
• Extensively used various SAS Data Step functions, SAS procedures, and SQL to write reports logics for SAS Stored Processes.
• Forecasted monthly, quarterly and annually customers flow and revenue for Direct Mail Marketing and Tele-Marketing campaigns using SAS and Excel.
• Performed market research and segmentation analysis using SAS, SQL and Excel to get the potential target customers and identify the market trend and opportunities
• SAS Enterprise Guide was used to convert existing SAS programs to SAS stored processes using dynamic prompts and produced packaging and streaming outputs as required.
• SAS Management console used to create metadata libraries.
• Developing SAS Stored Processes that can be easily used by end users using SAS Add-in for Microsoft Office and other SAS BI clients from SAS Information Delivery Portal.

Environment: SAS/ Base, SAS/ Macros, SAS/ Stat. SAS/SQL, SAS/ ODS, SAS Enterprise Guide, MS office, Windows, Mainframes Z/OS and UNIX.

Confidential

SAS Programmer

Responsibilities

• Extraction of data from Oracle, created into datasets.
• Performing data validation, transforming data from RDBMS oracle to SAS datasets.
• Transformations using Base SAS Procedures Functions.
• Responsible for the cleaning, reformatting, analysis and loading the data into the database.
• Developed new or modified SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
• Produced RTF, CSV, PDF and HTML formatted files using SAS/ODS to produce reports for presentation and further analysis.
• Developed SAS MACROS for reduction of program length and for faster execution.
• Combined and grouped datasets using concatenation and merging.
• Creating permanent formatted SAS data sets and developed reports using Proc Report, Proc Tabulate and DATA NULL for analysis.
• Extensively used various Base SAS procedures like Proc SQL, Proc Summary, Proc Format, Proc Print, Proc sort etc. for reporting purposes

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

Confidential

SAS Developer

Responsibilities:

• Participated in business requirement walk through, design walk through and analyzed Business requirements.
• Extraction of data from Oracle, created into datasets. Performing data validation, transforming data from RDBMS oracle to SAS datasets.
• Done Enhancements for the existing business reports like incorporating new business variables.
• Developed, modified, and generated Monthly Business Review MBR reports summarizing business activity.
• Uploading data into the warehouse application on monthly basis.
• Worked closely with data modeling team and management like Marketing managers, Campaign managers, financial managers etc., to analyze customer related data, generate custom reports, tables and listings.
• Worked extensively in sorting, merging, concatenating and Dynamic Formatting as optimized technique for SAS data sets.
• Cleaning of data using SAS Procedures like PROC FREQ /PROC UNIVARIATE.
• Extensively used various Base SAS procedures like Proc SQL, Proc Summary, Proc Format, Proc Print, Proc sort etc for reporting purposes. Used SAS procedures for Importing and Exporting data to MS-Excel.
• Transformations using Base SAS Procedures Functions.
• Extensively used ETL to load data from DB2, SQL server, oracle, Flat files and XML as sources to Oracle Data warehouse as target.
• Worked on Source and Target Metadata creation developed many jobs to load data from source into target
• Extensively used various types of transformations such as Expression, Aggregator, Filter, Joiner, Update strategy and Lookup Connected and Unconnected to load the data.
• Extensively involved in designing and developing of Star Schema Model for Data Store.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time with required frequency.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: SAS/Base, SAS/Macros, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/ETL, XML, IBM AIX 5.3, Unix, Shell Scripting, Oracle 8i/9i, DB2, MS SQL Server 2000, Mainframes OS/390 and Windows XP