SUMMARY

• Over 7 years of IT Industry Experience in Software Development using SAS.
• Strong experience in new application developments and enhancements of existing applications using SAS by following Software Development Life Cycle (SDLC) i.e. Requirements gathering, design, development, testing and maintenance.
• Strong experience in Reporting and ETL (Extraction, Transformation and Loading) using BASE SAS.
• 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, Microsoft SQL Server, Teradata and IBM DB2.
• Good at Unix Commands and UNIX shell scripting.
• Good at understanding of SAS Data warehousing and SAS Business Intelligence concepts.
• Good exposure on SAS Data warehousing (ETL - Extraction, Transformation and Loading) tool- SAS Data Integration Studio 3.4/4.2.
• Good exposure on 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.
• Experience with database manipulation using SQL commands.
• Extensive experience to handle large amounts of data for Data Cleansing, Data Profiling and Data Scrubbing.
• 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, Unix and Mainframes.
• 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, SAS/STAT, SAS Macros, SAS/SQL, SAS ODS, SAS Enterprise Guide, SAS Access, SAS Connect, Management Console, Data Integration Studio, SAS Information Map Studio, SAS Web Report Studio, SAS OLAP Cube Studio

Programming Languages: SQL, PL/SQL, C++, Java, J2EE

Database: MS Access, SQL Server, Oracle, DB2, Teradata

Platforms: Windows 98/XP/Vista/Win 7, Unix and Linux

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

SAS Programmer

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.
• Involved in code changes for SAS programs and Unix shell scripts and migration of cron jobs to schedule in control-M.
• 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.
• 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, Unix, SQL, Teradata, Control-M .

Confidential, Boston, MA

SAS Programmer

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.
• Building of generic utility processes for large volume sort, sort/summation, and Unix batch SAS execution
• 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, Oracle, SAS/SQL, SAS/ ODS, SAS Enterprise Guide, MS office, Windows, Mainframes Z/OS, Unix

Confidential, SFO, CA

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 and 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.
• Working major enhancements on Unix shell scripts for SAS batch programs
• 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.
• 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.

Environment: SAS/ Base, SAS EG, SAS DI Studio, SAS management console, SAS information map studio, SAS web report studio, SAS stored process, SAS IDP, Oracle, PL/SQL, MS Excel, Unix.

Confidential, Des Moines, IA

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.
• Automated SAS jobs running on a daily, weekly and monthly basis using SAS/BI & Unix Shell Scripting
• Extensively used Base SAS- ETL to load data from SQL server, oracle, Flat files and 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, Unix, Oracle DB2, MS SQL Server 2000, Windows XP.