PROFESSIONAL SUMMARY

• Certified BASE SAS Programmer with more than 6 years of experience in design, development, testing and implementation of various data-centric applications in Banking, Financial, Health Care, Market/Risk Analysis and Insurance sectors.
• Expertise in using SAS tools such as Base SASv9.x/8.x, SAS/Macros, SAS/SQL, SAS/STAT, SAS/Access, SAS/Connect, SAS/GRAPH, SAS/ETS and SAS/ODS in Windows and UNIX environments.
• Experience working on SAS BI tools like Enterprise Guide, Web Report Studio, Information Map Studio, OLAP cube studio, Management console.
• Expertise using SAS/ACCESS to Oracle, Teradata, SQL server and DB2.
• Extensively worked on various RDBMS like Oracle, Teradata, DB2 and SQL Server and has good experience in RDBMS development including SQL, PL/SQL programs and stored procedures.
• Experience in developing SAS procedures, Macros and applications for data cleaning, data migration, ad-hoc reporting and documentation.
• Extensive programming experience with different procedures like PROC SQL, PROC REPORT, PROC FREQ, PROC TABULATE, PROC TRANSPOSE and PROC SORT etc.
• Advanced skills on data scrubbing, data cleaning and manipulation using PROC procedures such as PROC SUMMARY, PROC SORT, PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC FORMAT, PROC TRANSPOSE, PROC PRINT and many SAS data steps such as ARRAY, MERGE, SET, etc.
• Experience in designing and building of SAS programs to analyze and generate files, tables, listings, graphs and validations providing SAS ETL, Data Mining, and statistical modeling expertise for key marketing campaigns.
• Experience manipulating multiple inputs from various sources, including legacy systems, external vendors and corporate databases.
• Thorough hands-on experience in using ODS to generate different files including RTF, MS Excels, PDFs and HTMLs.
• Extensive knowledge and experience in Microsoft Office tools like MS Access, MS word, MS PowerPoint and MS Excel.
• Worked in tandem with multiple teams like data analysis team, risk analysis team, marketing team to understand the data relationships.
• Expertise in Health Care Analytics, Fraud Modeling and Risk Management.
• Highly motivated, organized with excellent analytical and communication skills in establishing effective task priorities as a team player with result oriented attitude.

PROFESSIONAL EXPERIENCE

Confidential

Role: SAS Programmer/ Analyst

• Domain: Banking
• Description: Worked in Risk Data Control Management Team within the Consumer Banking.
• My Primary job function is retail products operational risk data control management operational risk testing data analytics. My tasks include preparing data extracts of customer account ownership and transactional behavior. Designed, developed and implemented a SAS automation process for operational risk testing.

Responsibilities:

• Responsible for researching, analyzing and responding to analytical inquiries that impact risk parameters also responsible for performing complex data management, mapping and query development.
• Extracted the data from database using SQL queries and created SAS data sets.
• Extensively used Teradata SQL Assistant, Data Step programming, Automatic variable by group processing, merging modifying and updating SAS data sets, set statements, functions formats, arrays.
• Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset sorting and merging techniques using SAS/Base.
• Extensively used SAS/Macro facility to create macros for statistical analysis, results reporting and data extraction.
• Reviewed and modified SAS Programs, to create customized ad-hoc reports, processed data for publishing business reports.
• Designed and developed code using SAS/EG to support ad hoc requests automated the standard reporting with SAS Web Report Studio and Microsoft Add-in and scheduled jobs via EG.
• Made improvements to production code by replacing generic macros and data steps with proc sql steps, resulting in a 70 reduction of processing time.
• Created flow charts to exhibit the flow of data from source datasets to the final reports.
• Extensively worked on pivot tables for presenting the comparison data.
• Extensively used PROC MEANS, PROC FREQ, PROC SORT, PROC PRINT and PROC PLOT procedures to extract and prepare integrated data, performed analysis on it.
• Generated reports by employing various SAS Procedures like Proc Tabulate, Proc Report ,PROC contents, PROC Summary, PROC download , , Data Null, SAS arrays, Proc SQL, and SAS Macros.
• Imported and Exported data files to and from SAS using Proc Import and Proc Export from Excel and various delimited text based data files such as .TXT tab delimited and .CSV comma delimited files into SAS datasets for analysis
• Generated ad hoc reports in Excel via Dynamic Data Exchange DDE and browser viewable reports in PDF/HTML via SAS ODS Output Delivery System based on client requests.

Environment: UNIX, SAS v9.2, SAS/BASE, SAS/ODS, SAS/MACRO, SAS/EG, DB2, SAS/SQL, TERADATA, Access, Excel.

Confidential

Risk Management - Credit Card Acquisition

Role: SAS/SQL Reporting Analyst

Description: As a SAS/SQL Reporting Analyst for Credit Card Acquisition team, I was responsible for providing analytical support to all risk initiatives within Credit Card Acquisition. Customer's demographic data, transactional and behavior data was extracted from various legacy systems and loaded into database tables based on variables of interest for profiling and segmentation analysis.

Responsibilities:

• Worked with the analysis teams and the risk management teams and supported them by providing variables based on their requirements.
• Developed SAS BI Dashboards which are used to monitor key performance indicators.
• Made transaction data broadly accessible to program teams and worked towards implementing the targeted business strategies.
• Created reports using SAS Enterprise Guide for summarizing portfolio experience, including information about the current business environment, portfolio trends, expected portfolio losses and the forecast assumptions.
• Developed New SAS programs to generate new reports in HTML, RTF and txt format.
• Facilitated the automation process for the Delinquency Report This report was required to run on a monthly basis and was required to show 13 months of data.
• Automated many standard and ad hoc reports generation and also involved in creating New Scorecards and Reporting the changing values.
• Used SAS ODS, SAS Graph, and procedures Proc Tabulate, Proc means to create ad hoc reports and graphs as per the requirements of the users.
• Developed statistical reports with Charts, Bar Charts, Box plots, Line plots using PROC GPLOT, PROC GCHART and PROC GBARLINE.
• Used Proc Template to produce customized report in spreadsheet with footnotes, titles, and pages numbers, eliminating user's work to customize the report.
• Created monthly, quarterly, and annual performance reports for senior management using SAS/EG and PC SAS.
• Developed, validated, updated and documented reporting system.
• Worked closely with other finance group, campaign team and senior management.
• Extensive use of Proc freq, Proc Report, and Proc Tabulate for reporting purposes.
• Participation in strategic initiatives, which includes leading, organizing, and facilitating initiatives and/or meeting from a risk perspective.

Environment: SAS v9.1.3, SAS/BASE, SAS/GRAPH, SAS/SQL, SAS/MACROS, SAS/EG, Oracle, DB2, SAS/ACCESS, Excel.

Confidential

Role: Sr. SAS Programmer/Systems Analyst

Description: As a senior SAS Programmer and business analyst, I worked with marketing, analytics and Business Intelligence departments. Work included acquiring and preparing reports on customer information. This information was then used to calculate premium charges for customers.

Responsibilities:

• Performed ETL on Oracle and DB2 data bases to extract and prepare data for analysis and reporting. Used PL/SQL and PROC SQL Pass through Facility to work with ORACLE and DB2.
• Data processing and validations were done extensively on the SAS datasets using edit check programs.
• Involved in standardizing reporting procedures for graphical and tabular reports.
• Used SAS Web Report Studio and EG to automate the reporting systems to generate daily and monthly reports for advanced premium, policy risk-in-force count, monthly claim count, and claim recovers, claim outstanding reserves, paid claim reports, outstanding loss, agent commission etc.
• Used SAS/EG for data pull, target creation and creation of new variables Transaction data library from raw datasets. Utilized SAS macros, Stored Processes and Information Maps to generate complex reports in Web report studio.
• Involved in data manipulation on SAS datasets techniques such as merging, concatenating and sorting.
• Used SAS Procedures to generate Adhoc reports such as renewal policy count reports by state, agent commission report by agent type based on clients requirements.
• Wrote Output Delivery System SAS Procedures to publish reports as HTML pages to the Web.
• Assisted data mining team to extract data patterns and trends from sales data.
• Involved in developing a SAS code for Acquisition models, X-Sell and Up-Sell marketing models, segmentation and targeting and campaign optimization.
• Created OLAP cubes using SAS OLAP Cube Studio and Information Maps using SAS Information Map Studio to feed data for SAS Web Report Studio.
• Analyzed various data formats using SAS Enterprise Guide Generated Web Based Reports using SAS Web Report Studio.
• Used procedures like PROC Freq, PROC Means, PROC SQL, PROC Sort, PROC Print, PROC Tabulate, PROC UNIVARIATE and PROC Report.
• Automated report generation in the Windows environment for the efficiency during Production and in the Production Environment.
• Data Fixing and Batch monitoring and performing troubleshooting of various issues ranging from batch programs.

Environment: SAS/BASE, SAS/ODS, SAS/SQL, SAS/Connect, SAS/Access, Enterprise Guide EG 4.0/4.2 , SAS Web Report Studio ,UNIX, Windows 2003, Oracle10g, Access, Excel, DB2.

Confidential

Role: SAS Programmer

• Description: Data Management and Reporting System
• Consortium Health Plans, Inc was formed to help its founding Blue Cross Blue Shield BCBS Plans position the Blue System as the carrier of choice for national accounts. I was involved in developing data warehouse to implement a centralized database that collects, organizes and stores data from different operational data sources to provide a single source of integrated and historical data for the purpose of reporting, analysis and decision support.

Responsibilities:

• Extracted patient data from different hospital databases using SAS/Access, SAS/SQL and created data sets.
• Involved in creating, maintaining and running SAS jobs to support specific solicitations and loading of database tables for analysis.
• Performed data cleansing, transformation and data quality as a part of ETL process.
• Identified patients and produced data listings, summary tables and reports using Proc Reports, Proc Mean, Proc Tabulate and Proc Freq for patients who could benefit from talking health care professionals about their conditions.
• Produced reports employing various SAS procedures like Proc Print, Proc Format, Proc Report, Proc tabulate, Proc Summary, and Proc SQL.
• Provided statistical programming expertise in the production of datasets, analyses, tabulations, graphics, and listings from sales data.
• Coded SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs.
• Used Proc Plot to make pictorial representation of the data relationships.
• Developed new macros, data listing, and for report generation as per the customer's requirements.
• Generated the custom reports in DATA step with line sizes, page breaks and Page
• Header Bottom messages. Developed and maintained standardized SAS templates and Macros for regulatory submission reports.
• Written ODS SAS procedures to publish reports as HTML.
• Developed Unix Korn shell scripts to automate recurring processes and routine administration tasks. AutoSys was used as job scheduler.

Environment: SAS/BASEv9.2, SAS/MACRO, SAS/SQL, SAS/GRAPH, UNIX, ORACLE 9i, MS Excel, DB2, Visual Basic, Windows NT

Confidential

Role: Business Analyst / Strategy Consultant

Description: The project involved analyzing sales and inventory data to prepare statistical data models and produce intelligent business reports on consumer behavior patterns.

Responsibilities:

• Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Involved in update and maintenance of data warehouse and generation of various sales and marketing reports.
• Conducted thorough analysis on historical data to generate seasonality of demand index profiles. Automated SAS jobs running on a daily, weekly and monthly basis using SAS/EG.
• Studied store behavior at a high level to gather information and generate reports regarding selling patterns, traffic volumes, geographic divides and seasonal swings.
• Optimized, automated and productionalized daily / weekly / monthly scripts for increased efficiency and intelligence.
• Created reports using SAS /ODS and SAS /views from oracle database tables into different formats like HTML and RTF.
• Developed SAS programs to create a customer mailing list for Direct Mailing and Telemarketing
• Conducted significance tests and study response rates for different offers.
• Worked with large customer response and sales data sets.
• Analyzed response and sale results and write up monthly summary on campaign performance
• Created reports using PROC REPORT, PROC TABULATE, ODS statements and PROC TEMPLATE to generate output formats in HTML.
• Implemented best practices for generating efficient code.
• Generated output using SAS/ODS in CSV, XLS, DOC, PDF and HTML formats.
• Performed extensive regression and statistical data analysis using Proc REG, Proc GLM, Proc ANOVA.
• Reviewed, validated, documented and mentored the team regarding SAS environment.

Environment: Windows XP, SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/CONNECT, SAS/ODS, SAS/SQL, SAS/Enterprise Guide, HTML, Teradata.

Confidential

Role: SAS Programmer/ Analyst

Description: Project involved creating reports and summary analysis of the advertisement campaign based on search engines and response of visitors to the ads

Responsibilities:

• Involved in Requirement Gathering and conducting a JAD session with project team member for accuracy of reporting.
• Documented the requirement and generated Process Flow Diagrams for Reporting according to different mapping specification.
• Created various SUMMARY REPORTS, GRAPHS and HEATED MAPS based on different data retrieved from Call Center and Web for various Analyses.
• Extensively used various statistical Procedures like PROC UNIVARIATE, PROC FREQ, PROC MEANS to understand data quality, produce reports and handle the missing values.
• Created the customized reports based on total costs and sales based on different advertisements.
• Analyzed the data of advertised contents based on people response and created reports based on their demographic information.
• Worked on SAS ETL taken from Flat Files with piped delimiter and converted them to SAS Datasets.
• Extensively used PROC TABULATE, PROC REPORT, PROC GCHART, PROC GPLOT, SAS/GRAPH, PROC SUMMARY and PROC GMAP during the report generation process.
• Delivered Ad-Hoc Reports to the customers based on the fly requirements.
• Extensively used PROC SQL to create Report Datasets and converted PROC SQL Queries into SAS Code to produce respective SAS Datasets.
• Analyzed Mid-Volume, Sub-Sets and Full-Volume data by using PROC FREQ to compare the counts and missing values present in the same.
• Extensive usage of ODS statement for creating RTF, HTML and Excel files.
• Automated report generation in the UNIX System for the efficiency during Production and in the Production Environment.
• Created Batch Process in the UNIX Environment for the SAS System.
• Extensively communicated with the Business Analyst, Systems Analyst, Data Modeler and Testing team during the execution of the project and had semi team meetings for various clarifications.

Environment: SAS/Base, SAS/GRAPH, SAS/MACRO, SAS/ODS, SAS/SQL, Oracle 9i, Windows XP, UNIX, MS-Excel.