Senior SAS Specialist

Sreepriya Sundararajan

*** ******* ****

Aurora, IL - 60504

Ph : 630-***-**** (Home)

Email : *******@*****.***

Summary

Experienced in design & implementation of Data warehousing & Data Mining Solution using Dimensional &

ROLAP Models. Skills include ODS Development and Metadata Management

Exposure to Systems Analysis & Design, E-R Modeling, Data Modeling, Client/Server application development, &

Pre-Sales.

W ell experienced with Data warehousing Tools like Informatica, SAS and Business Objects

W as part of Data mining methodology development team in the previous organization

Familiar with Data Modeling tools such as ERWIN and Designer 2000.

Domain Skills include verticals like Healthcare, Banking, Telecommunication and Retail.

Involved in developing generic solution in data mining using SAS E-miner for telecommunication Industry

Technical Skills

Data Warehousing:

SAS V9.1, V8.1, V8.2 and SAS V6.1 - Base SAS and other modules like AF, EIS, STAT, Access, IntrNet,

Warehouse Admin, Stat, Analyst, Insight, SAS Macros, Enterprise Reporter and E-miner

MS SQL DTS and OLAP Manager

Informatica Power Mart 5.1.1

Business Objects 5.1.1.1

Data Mining: SAS E-Miner

Data Quality: Dataflux

Data Modeling: ERWIN, Designer 2000

Database: Oracle 8.0, MS SQL Server 7.0, Sybase 10, DB2

Query Languages: SQL, PL SQL, T-SQL

Languages: C, C++, JCL

Web Related: HTML programming, JAVA 2.0

GUI: Oracle Developer 2000, Visual Basic, And Visual C++

Operating Systems: W indows 95, 98, NT, DOS, UNIX, Sun Solaris

Hardware: IBM Netfinity, E4500 Series

Education

Master Degree (M.Sc.) in Information Technology (Final Year)

Bachelor of Arts in Mathematics (with Statistics and OR as allied) from Madras University, India.

Advance Diploma in Systems Management - NIIT Ltd., India

Certificate Course in Designer2000 from STG.

Microsoft certified course in “Developing and Implementing Data Warehousing Using MS SQL Server 7.0 “

Microsoft Certified Professional in “Developing C++ Applications Using MFC”

Work Experience (In Reverse Chronological Order)

CIGNA, CT (Work at home employee)

HEDIS Application Development Senior Specialist (Technology Solutions Group and Clinical IT)

Jan 2007 – Current

Environment: SAS (v8.2, 9.1 and 9.2) on Mainframe/UNIX/PC, TOAD, JCL scripts, DB2, Oracle, SQL/PL SQL, MS

Access, NDM

Project Brief

HEDIS (Health Employer Data and Information Set) is developed and maintained by the National Committee for

Quality Assurance (NCQA), a private, not-for-profit organization committed to assessing, reporting on and improving

the quality of care provided by managed care organizations. Designed to provide purchasers and consumers with the

information they need to reliably compare the performance of managed health care plans. The HEDIS reports are

used by more than 90 percent of America’s health plans and there are more than 60 different measures in HEDIS.

The process involved in generating the HEDIS reports are (i) collecting all the admissions, claims, clinical lab,

pharmacy and mental health data from various sources on various platforms (ii) analyze and separate the eligible

population with denominator and numerator complaint for a specific measure (iii) compare it with the NCQA

benchmarks and provide a rate comparison reports to publish to NCQA

Contribution

Support the annual HEDIS production process by being an IT owner for assigned measures/processes

IT owner for the evolving Relative Resource Usage (RRU) measures and Disease Management (DM)

measures

Ensure the source codes are updated & complete on a timely basis in accordance to the HEDIS

requirements published by NCQA

Identify barriers such as data quality issues and incomplete data, and investigate, document and

implement actions to address them

Participate/coordinate in workgroup meetings across functional areas to identify improvement

opportunities that will lead to better results and improve the efficiency.

Perform as the subject matter expert for assigned measures and processes, defining expectations with

systems partners and supporting systems development, including specification, code walk-through and

acceptance testing

Participate in the annual HEDIS audit process by supporting the business team with documentation,

analysis findings, and perform as systems expert to ensure a successful audit

Lead/support clinical data-centric initiatives both within the department and in support of other matrix

partners

CIGNA, CT

Application Development Sr Specialist

Oct 2006 – Jan 2007

Environment: SAS v8.2, Mainframe, JCL scripts, DB2, SQL

Project Brief

This Project is to develop a Provider Selection Tool which will be used by the members enrolled with CIGNA and help

them to select their Providers based on their profile/ranking. The process involved are to extract the providers who

had any claims during past 24 months timeframe, scrub and clean the providers by their ids and names and try to

match with the Contracted Provider File (CPF) database. The matched provider data will be sent to MVS/SQL Server

where the providers are profiled and ranked and the final output is sent to a Provider Selection Tool (PST). All

databases like Claims, Providers, CPF are stored in DB2 Database, maintained in mainframe systems. Base SAS

Scripts and JCL scripts are used to extract and manipulate the data from DB2 and outputs (as flat files) are generated

and sent back to MVS/SQL Server for further analysis.

Contribution

Create a set of new SAS jobs for Managed Care Provider matching process and move to Production to

run quarterly

Change the existing SAS jobs based on ADS

Generating Reports/PROC Prints

Send the results to business team to analyze and work closely with the business team for any on-going

changes

Assist QA team in understanding the process and create testing scripts

Co-ordinate with other team members responsible for MVS, UNIX, SQL Server portions and exchange

database/files

Aetna Insurance Company, CT

Business Systems Delivery Specialist

Jul 2003 – Sep 2006

Environment: SAS v9.1, Excel, DB2, JCL scripts, Endeavor, StarTool

Project Brief

This Project is to provide Financial Support for Auto Claims Adjudication System (ACAS). Database for policy holders

insured with Aetna Health Insurance Company are stored in DB2 Database maintained in mainframe systems. Base

SAS Scripts and JCL scripts are used to extract and manipulate the data from DB2 and drill down reports are

generated using SAS and Excel.

Contribution

To process the following type of requests received from Account Managers and Policy Holders insured with

Aetna Health Insurance Company.

Preparing Specification document for specific type of requests received from prior carrier within Aetna

Generating Adhoc Reports/Unloads

Transfer history data from prior carrier systems to Aetna

Provide support for financials stored if any changes happen like plan setup, etc

Freelance IT Consultant

May 2002 to Jun 2003

Contribution

Freelance IT consultant, working through www.elance.com and www.rentacoder.com on various assignments

(DW – OLAP, Web Tools & Database applications). Following are few assignments, related to Data

Warehousing Solution

Poway Unified School District (PUSD): Provided technical consultation for the Data warehousing modules of

Schools Interoperability Framework (SIF) implementation for PENGUIN Project at PUSD.

OLAP Tool Comparison: Built a Case Study using Marketing & Budgeting models of a retail business, to

demonstrate the pitfalls of using excel & similar applications versus using dimensional OLAP tools.

Developed a prototype in COGNOS and a detailed write up on benefits of using OLAP tools, pro’s and

Con’s for each solution

Hewlett Packard, Singapore (Offshore)

Data Modeler & ETL Designer

Apr 2001 - Jul 2001

Environment: SQL Server 7.0, T-SQL Scripts, ERWIN, Windows NT

Project Brief

This Project is to consolidate in-transit and shipment information and facilitate analysis of data sourced from divergent

source systems. The improvement in analysis, in turn, enabled CBO-APDF (CBO - Consumer Business organization

and APDF - Asia Pacific Demand Fulfillment) to enhance customer service through efficient delivery and inventory

management. Development and Implementation of Data Marts in Subject Areas (1) Intransit (2) Shipment

Contribution

Design Logical & Physical Data Model using ERWIN

ETL Design & Development (writing procedures using T-SQL scripts)

Testing of ETL scripts

Offshore and onsite co-ordination

Satyam Computer Services, India

Analyst and Model Designer

Jan 2001 - Mar 2001

Environment: SAS System v8.0 & SAS Enterprise Miner on Windows NT

Project Brief

This project is to develop a model Chums (a churn management product aimed at Telecom segment). This model is

capable of sourcing data from any existing warehouse / relational tables / flat files. Scope for this model includes

modules for data preparation, model generation to generate patterns identifying profitable and fraudulent customers,

characteristics of churned customer’s etc.

Contribution

Problem Analysis and Data preparation

Design and Development of the prototype

Model Generation and testing of the model

GE Capital Bank, Austria (Offshore)

Data Modeler & SAS Developer

Oct 2000 - Dec 2000

Environment: SAS V8e, Base SAS, SAS Macros, SAS Warehouse Administrator, ERWIN, Solaris 2.6, E4500 Series

Project Brief

To implement common data warehouse to be Euro complaint and implement a campaign management solution for

cross border operations (Austria & Germany) of GE Capital bank.

Contribution

Data Study and Gap Analysis

Design of Star Schema and Multi-Dimensional Database for the enterprise wide data warehouse using ERWIN

Creation of Automated Macros for Initial Load and On-going feed

Scripts for metadata management

Design of Data quality procedures

SIFY, India

ETL Designer & JAVA Developer

Aug 2000 - Sep 2000

Environment: Oracle 8 on Sun Solaris, PL-SQL, JAVA 2.0, Weblogic (Web Server)

Project Brief

To give a solution to various cellular providers for tracking and managing their customers based on their call history.

Customer call history data from various cellular providers were collected and extracted and stored in Oracle Database

using PL SQL Scripts. The analysis reports like Airtime Usage, Customer Demography, Cellular usage Pattern, Plan

preference were developed using JAVA Servlets.

Contribution

ETL Design & Development (writing PL-SQL scripts)

Testing of ETL scripts

Report development using JAVA Servlets and JDBC.

India Software Group, India

Responding to RFPs, Technical presentation to Clients on Data warehousing and Data Mining

May 2000 - July 2000

India Software Group, India

Data Modeler and Base SAS developer

Jan 2000 - Apr 2000

Environment: Base SAS, SAS AF, SAS EIS, SAS Insight, SAS Query, SAS Stat, SAS Graph, ERWIN, Windows NT,

Visual Basic, Plato

Project Brief

This is a prototype of an end-to-end solution for Assets and Liability Management for banking industries in India.

Scope of this solution includes module to capture data from fully computerized, partly computerized and manually

operated branches across the country and load the same into data warehouse / Operational Data store and

generation of ALM reports in the format as Reserve Bank of India specified. The sample data has been collected from

Indian Bank, Indian Overseas Bank and Punjab National Bank.

Contribution

Design of physical & logical data model using ERWIN

Development of a Data Capturing System (DCS) for non-computerized branches (using Visual Basic v6)

ETL Development

Development of prototype, which includes the following analysis:

o Structural Liquidity Report

o Interest Rate Sensitivity

o Dynamic Liquidity

o Gap Analysis

o Duration Analysis

Facilitating the tool to Export resultant data into Plato (Credit Risk Management Tool) for further analysis

Spencers India Ltd., India

SAS Developer

Jul 1999 - Dec 1999

Environment: Base SAS, SAS AF, SAS EIS, STAT, SAS Macro on Sun Solaris

Project Brief

Implementation of Point of Sale & marketing data mart and OLAP solution for a chain of leading retail company to

cover its various business locations.

Contribution

Building Data mart and MDDB

Development of Decision Support tools to analyze Sales trends, purchasing patterns, customer clusters, Category

Management, Category Role Matrix, Cross Category Co-relation, Forecasting, What-if analysis, analyzing

promotion schemes, adhoc queries / reports.

Creation of automated macros for data upload, cleaning and transformation of data in Data mart, Creation and

maintenance of metadata layer and Multi dimensional Database.

Fine-tuning the application and data mart schema for Performance and efficiency

Data validation and Testing

Implementation & Production Support

Mahindra Holidays, India

Analysis, Data Modeling, Development, Implementation & Training

Jan 1999 - Apr 1999

Environment: SQL Server, DTS, Seagate, MS Excel, Oracle Designer

Project Brief

This Project was developed to analyze sales and performance trends at various holiday resorts. The analysis include

sales performance, Collection performance, Customer Demography & Preferences, Actual Vs Target

Contribution

Understanding the system

Data modelling and System design using Designer

Creation of data warehouse database

ETL using SQL Server DTS

Designing of OLAP reports using Seagate and MS Excel

Educating IT user in DW concepts, Data modeling and OLAP

Larsen & Toubro – ECC, India

Design, Development, Implementation and Support

Jan 1998 - Nov 1998

Environment: Oracle 7.x, Oracle Developer 2000, Oracle Designer

Project Brief

Development of OLTP system to support HR functions. Functionality includes, Campus Recruitment, General

Recruitment, Employee information System, Skill Inventory, Leave & Training. The tracking cycle starts from

identifying skill till deployment of employees to maintain employee information.

Contribution

Interaction with the clients for requirements and analysis

Analysis and Design of key modules in the system

Managed a team of 3 members for testing and implementation of some modules

Development of user interface using Developer 2000

Akshaya Departmental Store, India

Development, Implementation and Support

Sep 1997 – Dec 1997

Environment: Oracle 7.x, Visual Basic 4.0

Project Brief

This system was developed to automate Billing and Cash management. Functionality include, Customer

Billing, Record of cash transactions, Maintenance of item master, Customer master (for loyalty programs &

rebates).

Contribution

Development of the system.

Implementation and maintenance of the system

Tata Infotech, India

Documentation

Jun 1997 - July 1997

Environment: Cargo System developed using Foxpro

Contribution

Understand the functionality of the system developed to automate the day to day cargo operations

Develop User Manual and report documents

Contact this candidate