SUMMARY:

• 7+ years of IT experience in the Client/Server Technology, Designing and Developing SAS Applications and working with tools like Base SAS, SAS/Macros, SAS/ODS, SAS/Libraries, SAS/Graph, SAS/Access, SAS/Connect, SAS/SQL, Unix, SQL Server, and Oracle.
• Extensive Experience in SAS/Base 9.3/9.2/9, SAS/Macro, SAS/Stat, SAS/Access, SAS/Graph, SAS/SQL, SAS/ETL, SAS/Analyst, SAS/ODS, and SAS/GChart.
• Hands on experience and thorough understanding of SAS EBI (Enterprise Business Intelligence) toolset and its configuration on windows platform.
• Experience with SAS Business Intelligence Platform: SAS add - in for Excel, Information Maps, Web Report studio, Dashboards, OLAP Cubes.
• Have strong working knowledge on SAS Data integration studio in extracting data.
• Firm understanding of SAS Programming and List Processing. Utilize technical skills with SAS, SQL, and Database concepts to develop audits, test and control segmentation, vendor files, customer account updates, and offer tracking. Ability to turn business requirements into Technical Design specifications and documents, SAS Programs, and SQL Queries as appropriate. Capable of working with cross-functional teams to manage projects, determine prioritization, and create appropriate timelines.
• Extensively worked with Health care claims (Medical, Pharmacy) using CPT codes, ICD-9, NDC codes etc.,
• Development and Implementation of Process Improvements. Demonstrate the ability to self manage and multitask in a dynamic, ever-changing environment.
• Proficient in Oracle Database, SQL Server, Microsoft Access Database, PeopleSoft Enterprise, DB2 and Teradata.
• Has strong experience in analysing the reasons for the growth or loss of each Market segment.
• Professional Experience with Import Various External Data Files into SAS Dataset / SAS Library by Using SAS/Access, SAS/Infile, SAS/Import, and SAS/SQL.
• Proficient in using ODBC to Connect SAS System with Relational Database Management Systems, Such as Microsoft SQL and Oracle, to Retrieve Data and Create SAS Datasets.
• Worked with Risk Management team in predictive future risks by analyzing past data.
• Excellent Experience with Export SAS Results to Different Format, Such as XML, Excel Using SAS/Export, SAS/ODS for Reporting and Presentation.
• Experience in Data Analysis in Financial Data Management, Anti Money-Laundering group and Banking.
• Excellent Presentation Skills by Using Microsoft PowerPoint, Data Flow Chart, SAS Table, SAS Graph, SAS Chart.
• Formal Education and Solid Broad Knowledge in Computer Science, Focus on Relational Database Systems and Programming, Worked with BA and Marketing Business owners in understanding requirements, Research and Analysis for a List campaign.
• Extensive Experience in Microsoft Office Suite, Include Microsoft Word, Excel, Access, PowerPoint, Outlook, and Project.
• Excellent Organizational, Teamwork, Presentation and Interpersonal Skills.
• Applying Critical Thinking, Problem Solving, and Decision Making Skills, to Dismantle Complex Problems and Optimize Solutions.

TECHNICAL SKILLS:

SAS Tools: SAS/Base 9.3/9.2/9/8, SAS/Macros, SAS/SQL, SAS/Enterprise Guide, SAS/Stat, SAS/Access,SAS/ODS, SAS/ Enterprise Miner, SAS/Management Console, SAS/Grid, SAS/Connect,SAS/ETL and SAS /Graph

SAS BI Tools: SAS Web Report Studio, SAS Add-In to MS Office, SAS Data Integration Studio, SAS/BRM,SAS Management Console, SAS OLAP Cubes, SAS Information mapping Studio and SAS Dashboards.

Database: Oracle, DB2, MS SQL Server 2000, MS Access, and Teradata.

Operating Systems: Windows 95/98/XP/Vista/Win 7/8, MAC OS, Unix, MS-DOS, MVS, and Linux

Languages: SAS, SQL, HTML and Java

Development Tools: MS Office (Word, Excel, Power Point, Access).

OOD Suites: Microsoft Visio

PROFESSIONAL EXPERIENCE:

Confidential, New Hampshire,NH

Sr. SAS Programmer/Analyst

Responsibilities:

• Involved in design and development of entire life cycle of Revenue Attribution project.
• Prepared Functional Solution Document as part of Revenue Attribution based on the Business requirement document provided.
• Worked on Technical Solution Document, which included ETL designs for the SAS DI development.
• Design job flows using SAS/DI to extract data from source systems, perform required transformations and load back to target.
• Perform Source system analysis on the available source data, which was needed as part of RTE Data Model design.
• Use SAS/BRM to integrate all the business rules and then invoke them back into SAS DI jobs.
• Design base tables structure, which will also be used for reporting purpose as well as in RTE.
• Created ETL jobs in SAS DI based on Technical Solution Document. These jobs included coded algorithm and rules created in SAS BRM.
• Working extensively in sorting, merging, concatenating and modifying SAS data sets in different environments Windows and Unix.
• Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Solid understanding and proficient use of various procedures like proc SQL, proc summary, proc report, proc freq, proc means, proc contents, proc dataset, proc append, proc import, proc export, proc print, proc print, proc sort.
• Responsible for Programming in SAS 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.
• Extracted, performed validation and generated SAS data sets from Teradata applied SQL Pass through Facility.
• Develop new macros for report generation using SAS/Macros as per the customer's requirements.
• Retrieving Millions of Records Using different Procedures.
• Job scheduling using SAS Management Console and monitoring jobs using Process Flow Manager and using commands on Unix.
• Involved in code migration across multiple environments. Maintenance of all the Table scripts needed during Migration.
• Done code and data validations while moving across multiple environments.

Environment: SAS/Base 9.3, SAS/Access, SAS/SQL, SAS/Data Sets, SAS/ETL, SAS DI Studio, SAS/Enterprise Guide, MS office, SAS/ODS, Teradata, Oracle and Unix.

Confidential,Portsmouth,NH

Sr. SAS Programmer/Analyst

Responsibilities:

• Worked extensively with Health care data (hospital, lab and physician), which includes various claims, membership details and demographics of the members.
• Built an analytical data mart for the predictive analysis team for predicting future utilization measures.
• Coded, modified and automated existing programs writing complex Macros for improving efficiency.
• Created reports based on the claims (Medical and Pharmacy) pulled using CPT, ICD-9 and NDC codes for various Diseases.
• Used procedures like Proc Import for getting data into SAS from different formatted files like Excel, CSV file, .txt files etc.,
• Presented statistical results with the help of pie diagrams and bar graphs using SAS/Stat.
• Extensively used SAS Macros, Proc SQL, Proc Transpose, Arrays and Microsoft Excel.
• Worked on creating Membership files writing a logic that brings in only continuously enrolled members.
• Extensive knowledge on Claims processing forms such as CMS-1500 and CMS-1450(UB-04).
• Extracted data from various databases (DB2, Oracle) into SAS using SQL pass-through facility for creating various reports required based on the requirements.
• Coded for Metabolic-Syndrome project for predictive analysis team, where members with different risk factors of the disease were identified with their respective Diagnosis, Procedure and NDC codes.
• Worked with huge data for pre-diabetes project, where based on past data future occurrence of the diabetes is predicted.
• Validated a pre-sales package created by another SAS programmer.
• Ran some reports for compliance rates of the members with particular rules given by the Business user.
• Leveraging the exciting codes that can be used in processing, developing, maintaining and analyzing data more efficiently.
• Produced statistical reports for various business needs and expertise in data preparations, data cleaning and analysis.
• Worked on the post campaign response reports along with other programmer.
• Created summary tables and listed outputs.
• Worked with presentation and reporting procedures like Format, Report, Print, and Sort etc.
• Created reports using Unix Shell scripting for weekly and monthly reports.

Environment: SAS/Macros, SAS/Base 9.3, SAS/SQL, SAS/Stat, SAS/Connect, SAS/Graph, SAS Enterprise Guide, Unix, Windows, Oracle, MS Office and DB2.

Confidential,NYC,NY

SAS Programmer/Analyst

Responsibilities:

• Involved in design and development of the entire modules like Plan and Analyze the Data, Applying Analysis Rules, Developing and Generating the Reports Layouts using SAS Applications, Test Consolidations, Loading the data into the Database and Testing the Data.
• Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Created datasets and generated reports using Proc Tabulate, Report, Data Null, SAS Arrays, Proc SQL and Macros.
• Developed Financial Monthly and Quarterly summary reports, graphs using SAS procedures like Proc Freq, Proc Graph, Proc Univariate, Proc Summary, and Proc Report etc.
• Worked on SAS functions, Proc Stat, Proc Print, Merging, Macros, Proc SQL, SAS Import and Export, SAS Variables, nodupkey, and Proc Compare.
• Worked on creation of reports for business users using SAS web report studio, developed real time SAS BI Dashboards and KPI for business users using SAS Model Manager.
• Used the ETL tool (Extraction Transformation Load Process) to load data in the database using control files.
• Wrote SQL queries using Proc SQL.
• Worked extensively on PC SAS, Unix and Base SAS.
• Loading data by using SQL*Loader to custom tables.
• Teradata tables and created Logical and Physical Data Models using Erwin design tool.
• Used DB2 Utilities and SQL PLUS to unload tables. Used Teradata utilities such as Fastload, BTeq, and Multiload.
• Working extensively in sorting, merging, concatenating and modifying SAS Data sets in different environments like Windows and Unix.
• Worked on the SAS program against raw data of SAS repository to perform various financial operation to get required data fulfill.
• Performed Unit and load testing on the SAS models.
• Designed and created diagrams for the generic efficacy system using Microsoft Visio software.
• Created functional specification, user manual and technical documentation.

Environment: SAS/Base 9.2, SAS/Access, SAS/Connect, SAS/Graph, SAS Macros, SAS Reports, SAS/Stat, Oracle (SQL, PL/SQL), Unix, MS Access, MS Excel, MS Office and Windows XP.

Confidential,Madison,WI

SAS Developer

Responsibilities:

• Responsible for analyzing the claims data, future trends and summarized results to generate meaningful recommendations for management.
• Responsible for working with Health care data which includes various claims, and details of the members.
• Responsible for reviewing Business Process and develop process flow diagrams.
• Was responsible for gathering and assimilating data from Oracle, SQL Server and reporting requirements from business.
• Responsible for extraction of data from oracle database using SQL pass- through facility.
• Created complex and reusable Macros and used existing macros for Data Cleansing, Validation analysis and Report generation.
• Responsible for sourcing and analyzing of data from a various sources like SAS data sets, MS Access, MS Excel, CSV, XML, and flat files etc.
• Dealt with Teradata Asset Datamart from which data is pulled and did necessary modifications as per the requirement and finally loaded into the respective tables.
• Coded, Modified and automated existing SAS programs to automate process, improve efficiency.
• Extensively used various SAS ODS techniques to generate complex reports.
• Performed quality control checks on peer developed programs to ensure that the correct source data is used, correct code and logic are used.
• Documented all the programs developed for future reference.
• Creating SAS dataset from tables in Database using SAS/Access. Retrieved the data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/Stat procedures.
• Coding SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs.
• Created many Perl, Reports and Extracted, loaded Teradata tables using SAS/ETL.
• Ample experience on Teradata/ SQL Pass thru facility.
• Maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets and/or ASCII files by using Set and Merge, Sort, and Update, Formats, Functions and conditional statements for generating Reports.
• Prepared new Datasets from raw data files using Import Techniques modified existing datasets.
• Used Enterprise Guide (EG) for creating, editing and submitting SAS code for stored processes to Application server, for running queries against DB2 to bring the data into the SAS environment.
• Involved in scheduling the existing reports using Unix and SAS Data Integration Studio.
• Wrote Shell scripts for running batch files performed validation on transported data and reports.
• Extensively researched for cause of errors in code and modified code according to requirements.

Environment: SAS/Base, SAS/ Enterprise Guide, SAS/Macros, SAS/SQL, SAS/Stat, SAS DI Studio, SAS/ETL, SAS/ODS, SAS/Graph, MS office, Windows, SQL Server, Perl, Teradata and Unix.

Confidential,Birmingham, AL

SAS Programmer/Analyst

Responsibilities:

• Successfully analyzed business workflow and system needs and defined and documented business logic and system processes.
• Effectively worked with users to define business processes and information systems for supporting those processes.
• Involved in benchmarking the effectiveness of AML data. Identified the potentials for performance improvement.
• Understand and decipher a functional specification document written by the List Business Analyst. Work on complex system modifications or portions of new applications.
• Extensively used SAS Data Steps, SAS, Statistical models, and Flowchart Design, Listing, Graphing, Summarizing and Reporting procedures.
• Extracting data from Mainframe flat files using SAS Base and Macros.
• Involved in coding using SAS through implementation for requests to add new features to the existing functionality to AML.
• Successfully created SAS datasets. Programming of data listings using SAS and programming of data validation using SAS.
• Produced statistical reports for various business needs and expertise in data preparation, data cleaning, analysis, and reporting.
• SAS was used for pre-processing data, SQL queries, data analysis, generating reports, and statistical analyses.
• Created new programs and modified existing programs in the data warehouse.
• Testing & monitoring tasks related to the FDR system. Successfully converted and uploaded FDR data to Oracle databases.
• Compared the sales data for various segments to figure out the top 5 segments of the company.
• Analyzed the reasons for the growth or loss of each market segment.
• Was responsible in extracting customer data from Teradata, Oracle, and SQL Server databases via SAS Enterprise Guide and SAS DI Studio.
• Actively coordinated with marketing department in conducting Business intelligence and market research activities for designing new marketing plans to fight competition, increase customer & dealer satisfaction and achieve greater sales growth.
• Used SAS Enterprise Guide to access data, to manage data, to create reports and to validate data and data mining. Used Enterprise Guide to retrieve data stored in Teradata, PeopleSoft Enterprise.
• Customized the information necessary to improve campaign strategies, field test marketing programs, and improve customer knowledge across all marketing channels.
• Retrieved Oracle tables with Proc SQL. Run weekly and monthly reports using SAS.
• Create and extract Oracle tables from SAS and within Oracle by using SAS/Access, and SAS/SQL.

Environment: SAS/Base, SAS/Macros, SAS/ Stat, SAS/Access, SAS/SQL, MS- Excel, Windows NT/2000, COBOL, JCL, Assembler, DB2, Mainframe, VSAM and Unix.

Confidential

SAS Programmer

Responsibilities:

• Gathering Business Requirements from the users. Converting Business Requirements into Technical Specifications.
• Understand and decipher a functional specification document written by the List Business Analyst. Work on complex system modifications or portions of new applications.
• Worked on both Unix and MVS platforms utilizing SAS. Programming statistical reports and developing SAS/AF Frame-driven applications.
• Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Created datasets and generated reports using Proc Tabulate, Proc Report, Data Null, SAS Arrays, Proc SQL and Macros.
• Analyzed large data sets consisting of million records, created complex SQL queries to access database, as per the business requirements.
• Used SAS extensively for creating ad-hoc reports, match merge, append data validation, and data correction and cleansing.
• Created SAS Data sets from Oracle database and Created Oracle tables from SAS Data sets by using SAS Macros.
• Created the Teradata tables, and loaded the data into the tables and for the Capital Reporting project consisted of receiving data from an Oracle General Ledger System Transforming and Loading (ETL) the data into the Teradata General Ledger data mart.
• Involved in Physical modeling on Teradata such as creation of tables, indexes and views.
• Developed summary reports, graphs using SAS procedures like Proc Freq, Proc Graph, Proc Univariate, Proc Summary, and Proc Report etc.
• Developed Capital Reporting Analysis application, using Base/SAS, SAS/Macros, SAS/SQL and SAS/ODS template.
• Developed CFAR Reports P&L Reports, Assessment Reports, Monthly and Quarterly Reports using PROC Tabulate, Proc Template, Proc Report, Data Null, SAS arrays, Proc SQL and Macros.
• Worked on ad-hoc requirements to clean data using standard procedures, SAS functions and SAS arrays. Also modified standard cleaning macros, arrays and SQL queries to fit requirements.
• Designed and created diagrams for the generic efficacy system using Microsoft Visio software.
• Performed unit/system testing of the application project and coordinated with QA team to proceed with the end-to-end testing. Involved in extracting and segregating and matching data using SAS and loaded back to database.
• Provided analysis, development, and testing for SAS programs using Teradata datamarts to consumer and small business areas for market analysis.
• Worked extensively on PC SAS and Unix base SAS and used software build tools like Clear Case and Clear Quest.

Environment: SAS/Base 8.2, SAS /Access, SAS/Connect, SAS/Graph, SAS/Macros, SAS/Reports, SAS/Stat, Oracle (SQL), MS-Access, MVS, Windows XP 2003, and MS-Office.