PROFESSIONAL SUMMARY:

• Over 6 years of Professional Experience in Software Development in different environments and platforms including Data Warehousing, Client - Server and Legacy Mainframe applications.
• Strong experience in SAS/BASE, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/SQL, SAS/MACRO, SAS/EG, SAS/SHARE, SAS Enterprise BI Server.
• Experience in the BI Suite in SAS including SAS Enterprise guide, SAS Data Integration Studio and Information Map Studio.
• Experience in developing SAS codes using SAS Enterprise Guide and SQL queries in SAS for creating stored processes using the dynamic prompts containing both packaging and streaming output, and prepared reports using ODS.
• Experience with SAS management Console for scheduling daily and monthly job runs for creating reports.
• Extensively used SAS procedures such as freq, report, tabulate, sort, print, transpose, summary and means 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 command in importing and exporting complex internal data to and from Microsoft Excel and Microsoft Access using Proc Import and Proc Export.
• Extensive knowledge in data management like Merging, concatenating, interleaving of SAS datasets.
• SAS ODS was used to generate output files in required formats like RTF, HTML, and PDF.
• Proficient experience in different Databases like Oracle, SQL Server, and DB2.
• Ability to work efficiently in both independent and team environments, worked with Project Managers, Team Members / Associates, and Business Analysts.
• Strong Problem Analysis & Resolution skills and ability to work in Multi Platform Environments like Windows & UNIX.
• Excellent written & verbal communication skills.
• Resourceful, able to find solutions when faced with challenges.

TECHNICAL SKILLS:

SAS Tools: Base SAS 9/8.2/8.1/6 (mainframe), SAS Macros, SAS/SQL, SAS ODS, SAS Enterprise, SAS Business Intelligence (BI) platform.

Reporting Tools: Base SAS versions 9/8/6, SAS Enterprise, MS-EXCEL, SAS BI Platform, SAS OLAP Cube Studio, SAS Web Report Studio, MS-PowerPoint.

RDBMS: SAS SQL, SAS Enterprise, SAS BI Platform, MS-ACCESS, Microsoft SQL ServerLanguages: SAS, SQL, HTML.

Operating System: Windows 95/98/XP/Vista/Win 7, UNIX.

Batch Server: UNIX, Putty, SSH, SAS scripting.

Web Server: MS-FrontPage, HTML, Linux, Apache Server.

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, Florida

SAS Developer

Responsibilities:

• Used SAS BI tools like DI studio, SAS Management console and SAS EG.
• Gathering the requirements and performing ETL changes in the DI studio.
• Developed SQL queries and various joins for data validation.
• Used various SAS Procedures, SAS functions and Macros extensively for report generation, which helps in quick processing and faster access to the reports.
• Involved in resolving the production issues from the customers.
• Documenting the report changes made according to the requirements provided by the business.
• Updating the report mapping documents if the changes are made to the existing reports.
• Updating the reports with new changes according to the requirements using SAS EG
• Optimized the query performance with modification in SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins.
• Generated reports in HTML, Excel, PDF formats.
• Used SAS ODS for report generation in different formats.
• Followed all processes and procedures for application deployment for new as well as existing.

Confidential, SFO, California

SAS Programmer Analyst

Responsibilities:

• Extracted data from Oracle database (warehouse).
• Extensively used SAS BI tools like DI Studio for building the data ware house. Data Integration Studio is used for registering metadata, to create jobs and use transformations for building the target sas datasets.
• ETL (Extraction, Transformation and Loading) process is used for building data warehouse through SAS DI studio.
• 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.
• Extensively used various SAS Data Step functions, SAS procedures, and SQL to write reports logics for SAS Stored Processes.
• Based on the draft spec document, SAS programs are developed.
• New SAS programs were developed using macro variables to improve ease and efficiency of modifying the existing SAS programs.
• 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.
• Desired financial reports were created using analysis output and export them to other environments or the web using various SAS method like create delimited, text files, ODS having formats such as HTML, RTF, or XML.

Environment: SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/STAT, SAS/SQL, SAS/ODS, MS-OFFICE, SAS Enterprise Guide, Windows, UNIX, MVS/TSO (for inserting and updating the records).

Confidential, New York NY

SAS Programmer

Responsibilities:

• Developed complex SQL queries using various joins and developed various dynamic SQL(Sub queries and Join conditions, correlated sub queries)
• Gathering requirements on ongoing projects
• Developing SAS codes as per the requirement.
• Designing SAS Macros which can be generalized for Organizational Use
• Ensuring Data Quality and Data Integrity
• Preparing QC documents (Test Plan and PRN).
• Created Adhoc reports as per statistician requirements.
• Generated output in various formatted files such as Excel sheets, RTF, and HTML using SAS/ODS
• Documentation of development code and the test cases involved.
• Design, develop, and conduct unit test plans for ensuring application code is functioning correctly.

Confidential, Hartford, CT

Customer Data Mart - EDWH 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, MSWORD 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: Base SAS 8.2, SAS/Macros, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, Oracle 9i, PL/SQL, MS Excel and UNIX.

Confidential

SAS Programmer

Responsibilities:

• Extracted and analyzed data from the database using SAS/Access, SAS/SQL PROCEDURES and created SAS datasets.
• Developed SAS programs using SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS for statistical analysis and data display.
• Performed various statistical works to resolve and develop SAS applications using PROC REG, PROC UNIVARIATE, PROC CORR, PROC ANOVA, PROC MEANS etc.
• Developed custom reports using Data Null and Dynamic Data Exchange (DDE) technique.
• Used ODS statements and PROC TEMPLATE to create reports in style format.
• Used SAS extensively to create ad hoc reports, match merge and created graphs by using SAS/GRAPH base.
• Used SAS Macros, PROC SQL to extract, Sort, match test accounts and ODS to HTML, PDF and RTF.
• Data validation was done using SAS Enterprise guide.

Environment: Base SAS v8.2, SAS/Access, SAS/Connect, SAS/SQL, SAS/ODS, SAS/MACROS, UNIX, MS SQL Server 2000.