Professional Summary:

• SAS Base Certified professional with over 8 years of experience in developing software applications for Financial, Health Care and Insurance sectors.
• Experience working in SAS Business Intelligence BI platform with Enterprise Guide, Stored Process, Information Map Studio, Microsoft Add-In and Web Report Studio.
• Proficient in SAS v6.12/v8.2/9.1.3, SAS/BASE, SAS/MACROS, SAS/Connect, SAS/SQL and SAS/ODS.
• Experience in working with SAS on different platforms like UNIX AIX, HP/UX, SunOS , and WINDOWS 9x/2K/NT/XP.
• Extensively worked on various RDBMS like Oracle, Teradata, DB2 and SQL Server.
• Experience in carrying out Marketing Campaigns and evaluating customer information.
• Utilized EPSS scrubbing to comply with regulatory requirements.
• Extensive Experience in arranging and participating in meetings with Business Users and suggesting recommendations for improving system performance.
• Proven skills in data cleansing, data archival, data migration, ad-hoc reporting, and coding using SAS on various environments.
• Involved in all stages of SDLC Software Development Life Cycle .
• Thorough Knowledge and experience in Microsoft Office tools like MS Access, MS SharePoint, MS word, MS PowerPoint, MS Excel.
• Proficient in operating tools like Windows XP/NT, Unix, Linux and MVS
• Experience in handling software development, enhancements, testing and documentation.
• Excellent communication and interpersonal skills.
• Proven abilities in establishing effective task priorities as a team player with result oriented attitude.

Technical Skills:

SAS Tools : SAS/BASE, SAS/MACRO, SAS/SQL, SAS/EG, SAS/STAT, SAS/Access, SAS/CONNECT, SAS/ODS, SAS/Internet, SAS EBI, SAS DI Studio.

SAS BI Tools : SAS Enterprise Guide, SAS Add-In to MS Office, SAS Information

Map Studio, SAS Stored Process, and SAS Web Report Studio.

Database : Oracle, DB2, MS-SQL Server 2000, MS Access. Operating Systems : UNIX, MS Windows 95, 98, 2000, NT, XP , MS-DOS, MVS. Languages : SQL, PL-SQL Development Tools : MS Office Word, Excel, Power Point, Access OOD Suites : Microsoft Visio, UML.

Experience:

Confidential

SAS Developer / Analyst

Responsibilities:

• Worked with business users to design and develop several ad-hoc reports and information maps using PROC REPORT and PROC TABULATE.
• The reports created include Monthly summary reports as well as detailed weekly reports.
• Connected to the DB2 database and extracted the relevant data using LIBNAME or Pass-through facility and then processed the data using business logic to produce reports. Made heavy use of PROC SQL, PROC REPORT and ODS for producing these complex reports.
• Extensively used SAS Data Steps, SAS, Statistical models, and Flowchart Design, Listing, Graphing, Summarizing and Reporting procedures.
• Used SAS/ODS to produce HTML reports.
• SAS Procedures used are Proc Append, Macros, Import and Export, Proc Transpose, Proc Datasets.
• Developed and deployed SAS OLAP cubes for browsing of financial data via the SAS Information Delivery Portal.
• Proficient in sorting, merging and using different table lookup techniques to get the required information to generate the report.
• Handled the tasks of writing reports and manipulating data by using UNIX platforms
• Developed queries on the existing SQL server databases to provide ad-hoc reports using SAS/SQL. Functions used over here are Coalesce, Data part, Datdif. Also used Case When Then statement.
• Produced reports and complex data analyses using SAS, including SAS/stats, extracted data from MVS and Oracle files using SAS/Views, SAS Proc SQL and SQL.
• Debugging SAS programs using data null , Put statements and using datastep debug.
• Generated automated graphs for monthly run using Proc Gplot. Exported these graphs to Pdf File using SAS/ODS.
• Customizing the existing Macros according to need and requirement, testing and debugging the Macros and creating more complex and reusable Macros.
• Used Enterprise Guide EG query builder to run queries against the tables and sub setting the data
• Creating excel pivot table reports using Cycle Time data. These reports consist of Benefit level data, claims level data. These reports are very useful to get a greater insight
• into the further plan design.
• Developing the UNIX shell scripts in order to run the report as a part of daily schedule.
• Exported SAS Reports to the Excel sheet by using ODS/Tagsets/ Excel XP to get output in multisheets. Used several Style Options.
• Dealt with the Off-Shore Team.
• Utilizing PC and MVS platforms for SAS programming.
• I have been doing variety of tasks including data extraction, manipulation, Analysis using Claims Data.
• Produced statistical reports for various business needs and expertise in data preparation, data cleaning, analysis, and reporting.
• Expert in preparing Analysis Datasets, Tables, Listings, and Graphs according to the Business Requirement.

Environment: SAS/EG 4.3, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/GRAPH, SAS/ODS, SAS/STAT, Excel, Access, Windows 2000 Server, SQL Server, MS office.

Confidential

SAS Analyst / Developer

Responsibilities:

• Participated in determining the criteria for Small Business Marketing campaigns and developed SAS codes to meet those criteria.
• Developed SAS programs to create a customer mailing list for Direct Mailing and Telemarketing. Used SAS/ODS to produce RTF and HTML reports.
• Worked with large customer response and sales data sets and presented results to the users. Simultaneously tested the integrity of the mails, addresses in the database.
• Maintained and enhanced existing SAS reporting programs for marketing campaigns. Involved in the code review to make sure the output is as we expected and the efficiency is met.
• Designed standardized and automated ad-hoc, for new product development, on-line marketing, direct mail, reward-based marketing, etc.
• Used proprietary statistics tool to test how the marketing campaigns fared. This included measuring the sales lift attributable to a specific marketing campaign, comparing similar campaigns across multiple tracking windows etc.
• Developed an automated system for Marketing Communications MARCOM . Extracted data from Oracle tables and MVS files
• Created Stored Processes for the business to generate different ad-hoc reports
• Have experience creating information maps which would be utilized by web report studio to generate static reports.
• Moved data set across platforms from PC and Mainframe to UNIX and Vice Versa .
• Designed and developed code with SAS/EG to support ad-hoc requests.
• Automated the standard reporting with SAS BI and Microsoft Add-in.
• Extensively used Proc Print, Proc Report, and Proc Tabulate for reporting and communicated analysis results to the marketing team. Used other SAS functions such as Proc SQL queries , Proc Append, Merge, Macros, and Import and Export. Used SQL Pass through Facility to create and update Teradata and Oracle tables.
• Developed and used Scripts to schedule SAS jobs. Used EPSS scrubbing to comply with customer's requirements and direct mailing requirements.
• Developed queries on the existing Oracle and SQL server databases to provide ad-hoc reports using SAS/SQL for marketing department use. Coordinated analyses involving customer information, campaign response data, and demographics.

Environment: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/GRAPH, SAS/ODS, Excel, Access, UNIX SunOS , Windows, Exceed, PuTTy, WinSCP, Oracle, Teradata, SQL Server, SAS Enterprise Guide, SAS Add-In to MS Office, SAS Information Map Studio, SAS Stored Process, and SAS Web Report Studio.

Confidential

SAS Analyst

Responsibilities:

• Extracted, transformed, and loaded data using SAS.
• Involved in analysis, development, testing, implementation, and provided technical support to business needs using SAS in UNIX environment
• Ensured the validity and accuracy of the analyzed data.
• Created Information Maps to feed Web Report Studio which generated reports.
• Used SAS BI and Microsoft Add-in to automate the standard reporting.
• Created Stored Processes that would generate ad hoc reports based on parameters passed.
• Used SAS/EG to design and develop code to support ad hoc requests.
• SAS on both UNIX and MVS platforms utilizing SAS 6.10. Programming statistical reports and developing SAS/AF FRAME-driven applications.
• Coordinated with the other teams to deliver the data to the clients on time
• Extensively used PROC PRINT, PROC REPORT and PROC TABULATE for reporting.
• Used SAS/ODS to produce RTF and HTML reports.
• Submitted SAS/SQL Queries in UNIX shell to validate data.
• Presented process flow diagrams in MS Visio.
• Raised queries on the existing Oracle and SQL Server databases to provide
• Ad-hoc reports using SAS/SQL.
• Involved in the development of different datasets according to the user specifications for various applications.
• Analyzed the data, future trends and summarized results to generate meaningful recommendations to management.
• Written macros to develop a concise and reusable code.

Environment: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/CONNECT, SAS/ACCESS, MS-Excel, SAS/ODS, Oracle, UNIX, and Windows NT, SAS Enterprise Guide, SAS Add-In to MS Office, SAS Information Map Studio, SAS Stored Process, and SAS Web Report Studio. FC, Confidential

SAS Analyst

Responsibilities:

• Analyzed the claims data, future trends and summarized results to generate meaningful recommendations for management.
• Built complex data marts and queried them for strategic reporting and analysis.
• Designed and delivered on-going and back-end reporting for analysis.
• Created various transformation procedures by using SAS 9.1, SAS ETL and SAS Enterprise guide.
• Developed ETL process and SAS independent repository as source of data transaction.
• Responsible for running of productionalized programs on the weekly, monthly and quarterly reports.
• Used programming tools such as SAS base V9 Windows and UNIX , SAS MACRO, PROC SQL, Microsoft Excel etc.
• Used procedures like Proc Means, Proc Freq and Proc datasets to run metrics on different datasets.
• Designed and developed code with SAS/EG to support ad hoc requests.

Environment: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/STAT, SAS ETL, SAS/EG, Excel, UNIX SOLARIS , Windows, Oracle.

Confidential

SQL / SAS Analyst

Responsibilities:

• Gathered and assimilated data from Oracle and SQL Server and provided quantitative assessments of product and program performance.
• Analyzed the data on customer spending for a period of six months.
• Created datasets to identify the top ten merchants that customers shop with.
• Used statistical models to find the average spending on each merchant and calculated the cumulative percentage.
• Generated reports using PROC Tabulate, PROC Report, SAS arrays, PROC SQL and MACROS.
• Presented statistical results with the help of pie diagrams and bar graphs using SAS/STAT.
• Developed SAS MACROS for data cleaning and reporting and to support routine processes.
• Designed and produced standardized and automated ad-hoc, weekly, monthly, and quarterly reports for account management, on-line marketing, fee-based marketing, direct mail and reward-based marketing.
• Communicated analysis results to the marketing team in a concise, easily understandable format.
• Analyzed volatility changes before and after marketing.

Environment: UNIX SunOS , Windows XP, Base SAS, Oracle, SQL Server 2000, SAS/STAT, MACROS, SAS/SQL, SAS/ACCESS, SAS/CONNECT.