Data Sales

Vidya .A

[pic]

239-***-****/***.*****@*******.***

PROFESSIONAL SUMMARY:

. Certified SAS programmer/ Business Analyst with more than 7 years of

experience in Market/Risk Analysis, Financial Analysis and Health

Care Data Analysis

. Excellent knowledge in software development life cycle

. Experience in Base SASv9.1.3/8.0, SAS/Macros, SAS/SQL, SAS/STAT,

SAS/Access, SAS/GRAPH, SAS/ETS and SAS/ODS in Windows, UNIX and

Mainframe environments

. Experience in developing SAS procedures, macros, and applications for

data cleaning, reporting, and documentation

. Extensive experience in developing code for different SAS/STAT

procedures such as PROC REG, PROC GLM, PROC FREQ, PROC MEANS and PROC

UNIVARIATE

. Expertise in using SAS tools such as SAS/Base, SAS/Access,

SAS/Connect, SAS/SQL, SAS/STAT, SAS/GRAPH and SAS Macro

. Experience in design and building of SAS programs to analyze and

generate Files, Tables, Listings, Graphs, Validations, Documentation

. Familiarity with statistical modeling techniques and data mining for

CRM

. Experience in using SAS Enterprise Miner and SAS Enterprise Guide

. Exceptional ability in problem solving, data analysis, complex reports

generation with macro and data transfer between different environments

. Experienced in Relational Database Design and Implementation.

Developed code for the database applications to interact with the

databases in Oracle 10g, SQL Server 2008, DB2 and Teradata

. Thorough hands-on experience in using ODS to generate different files

including RTF, MS Excels, PDFs and HTMLs

. Extensively worked in Design and development of Mainframe applications

using COBOL, CICS, DB2 and IMS technologies

. Using SAS in a Mainframe environment, developed new reports and

modified existing reports in relation to the new system

. Experienced within a MVS/TSO environment to code and test SAS programs

using JCL to execute jobs

. Quality Control, Execution, and Maintenance (Debugging, Enhancements,

Testing) of all delivered Production Code

. Expertise in Health Care Analytics and Fraud Modeling

. Communicate effectively with management; quality oriented and

performance driven nature with strong technical problem solving skills

. Highly motivated, Organized Team player with excellent analytical and

communication skills

. Excellent oral and written communication skills and outstanding

presentation skills

TECHNICAL SKILLS:

Operating System UNIX, Windows, MVS

SAS Tools SAS/BASE, SAS/STAT, SAS/MACRO, SAS/GRAPH, SAS/ODS,

SAS/AF, SAS/ACCESS, SAS/Connect, SAS/Enterprise

Guide, SAS/Enterprise Miner SAS/ETL

Programming Languages SQL, PL/SQL, C, Visual Basic, HTML, TSO/ISPF, COBOL,

VSAM, JCL, EASYTRIEVE, REXX, CLIST

Tools Endeavor, Changeman, Hyperstation, File Aid

RDBMS Oracle, 8i/9i/10 g, SQL Server 2005, DB2, MS Access,

MySQL

Application Software MS Office, Microsoft Visual Studio

PROFESSIONAL EXPERIENCE:

AVEEVA INSURANCE DESMOINES,IA

Aug2009-Till date

Sr.SAS Programmer/Business Analyst

As senior SAS Programmer and business analyst, I Worked with Marketing,

Analytics and Business Intelligence departments.

Responsibilities:

. Performed ETL on Oracle and DB2 data bases to extract and prepare

data for analysis and reporting

. Data processing and validations were done extensively on the SAS

datasets using edit check programs

. Accessed files from a mainframe platform to meet the requirements

. Involved in standardizing reporting procedures for graphical and

tabular reports

. Used advanced SAS tools to automate the reporting systems to

generate daily and monthly reports for advanced premium, policy

risk-in-force count, monthly claim count, claim recovers, claim

outstanding reserves, paid claim reports, outstanding loss, agent

commission etc.

. 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

. Developed Data Entry and Validation Screens using SAS/AF and SAS/SCL

. 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

. Developed and maintained the SAS code for Acquisition models, X-Sell

and Up-Sell marketing models, segmentation and targeting and

campaign optimization

. Analyzed various data formats using SAS Enterprise Guide

. Assisted analytics teams to export SAS Enterprise Miner and

Enterprise Guide code and make necessary changes to work in batch

mode in Mainframes

. Used procedures like PROC Freq, PROC Means, PROC Sort, PROC Print,

PROC Tabulate, PROC UNIVARIATE and PROC Report

. Moved data sets across platforms from PC to Mainframe and Vice Versa

. Data Fixing and Batch monitoring and performing troubleshooting of

various issues ranging from batch programs

Environment: SAS/ODS, SAS/Connect, SAS/Stat, SAS/Access, SAS/AF, SAS/SCL

Enterprise Guide (EG 4.0),Enterprise Miner, UNIX, Windows 2003, Oracle10g,

Access, Excel, MVS/TSO, JCL, VSAM, COBOL, DB2.

Consortium Health Plans, Columbia MD

Aug 2008 -Jul 2009

SAS Programmer

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.1, SAS/MACRO, SAS /STAT, SAS/GRAPH, SAS/ODS, UNIX,

ORACLE 9i, MS Excel, DB2, Visual Basic, Windows NT

DAVIDS BRIDAL Pittsburgh,PA

Apr 2007- July 2008

Business Analyst / Strategy Consultant

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

. 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.

Travelers Auto Insurance, Hartford, CT

May 2006-Mar 2007

SAS Programmer/ Analyst

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.

. Have experience working with SAS Enterprise Guide 4.1 during the

project.

. 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, 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

. 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/STAT, SAS/GRAPH, SAS/MACRO, SAS/ODS Enterprise

Guide 4.1, SAS/SQL, SAS 9.1.3, Oracle 9i, Windows XP, UNIX

PNC BANK, Pittsburgh,PA

Oct 2005 - Apr 2006

SAS programmer/Analyst

I was working for contact management group as a marketing analyst. We were

assigned projects as PDMs (promotional direct marketing campaigns), based

on the campaign type we select the data, perform the analysis and produce

the results.

Responsibilities:

. Creating SAS data set from flat files, excel files and from Oracle

(the main data base)

. Performed QC Checks for output files and loaded them into TCH

(Treatment Contact History Database)

. Generate waterfall report by passing them through suppressions, and

the user requested frequencies

. Development of standard SAS macros to be used throughout out the

marketing campaigns

. Create electronic data sets (i.e. SAS transport files) for electronic

submissions to the marketing vendor

. Created SAS Macros and SAS Graphics, and used PROC Report to generate

reports

. Used PROC SQL for connecting to oracle, used connect to ODBC through

PROC SQL to get the job done

. Preliminary data validation is performed using PROC Compare of Base

SAS

. Loading the results generated into a database called treatment contact

history so that the campaign is tracked of the actual results

. Extensive usage of ODS statement for creating RTF, HTML and Excel

files

Environment: Enterprise Guide, SAS/Stat, SAS/Graph, SAS/ODS, MS Access,

Oracle 8i, UNIX, Windows NT.

Client: VISA International Miami, FL

Apr 2004-Aug 2005

Role : SAS Programmer

The project in Visa International involved design and implementation of a

pilot project for decision tree analysis using several attributes from the

database of cardholder performance. This data, in sync with the credit

bureau data was used for various marketing campaigns and reward programs.

The achieved aim was to reduce delinquencies and increase response rates

amongst various sectors of customers.

Responsibilities:

. Extracted the data from database using SQL queries and created SAS

data sets.

. Used Proc Import to convert delimited files like (.CSV) files into SAS

data files.

. Performed categorical statistical data analysis on sales and marketing

information.

. Performed consumer profiling and sales forecasting, generated customer

lists for various departments to determine retention strategies.

. Determined the impact of direct market campaigns for acquiring and

retaining credit card customers using statistical analysis.

. 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

. Generated HTML, Listings, Excel and RTF reports for presenting the

findings of various statistical procedures using Proc Report and Proc

Print and along with SAS ODS.

. Extensively used PROC MEANS, PROC FREQ, PROC SORT, PROC CONTENTS, PROC

REPORT, PROC PRINT, PROC PRINTTO, PROC SUMMARY, PROC SQL, PROC PLOT

and PROC GCHART procedures to extract and prepare integrated data;

performed analysis on it.

. Created reports from analysis as per the client's requirements.

Environment: UNIX, SAS v9.0, SAS/BASE, SAS/ODS, SAS/MACRO, SAS/STAT,

SAS/SQL, PROCEDURES, ORACLE, Access, Excel, DB2.

PutnamInvestments,Hyderabad,INDIA. Jan

2003-Mar 2004

Software Engineer

NSCC (National securities Clearance Corporation) NSCC, the nation's leading

provider of centralized clearance, settlement and information services to

brokers, dealers, banks, mutual funds, insurance carriers and other

organizations. NSCC develops standardized, automated solutions that promote

connectivity, efficiency and lower risk in the financial services

marketplace.

PUTNAM is one of those clients which take the Services of NSCC. To utilize

those services, we need to follow the process defined by them. As part of

Support activity, our job is to ensure that the transmission to NSCC is

being done properly by handling the service requests. The scope of the work

is coding and testing.

Responsibilities:

. Involved in Coding, Debugging, Unit Testing, System Testing and

Regression Testing of the project

. Supporting Business Analysts, preparing Functional Specs, Technical

Specs

. Interacting with the user and doing enhancements with detailed

analysis as per arising business requirements

. Preparation of unit and system test cases

. Cleaning up of the existing legacy data

. Testing up of the validity of the loaded data

. Preparation of application/technical documents for current system's

functionality

. Modified the existing code with the new change orders

Environment: TSO/ISPF, MVS, COBOL, CICS, SAS, VSAM, DB2, JCL/Utilities,

SQL, FILE-AID, ENDEVOR, XPEDITOR, EASYTRIEVE.

EDUCATION: Bachelor of Technology in Computer Engineering, J.N.T.U

Contact this candidate