Data Sql Server Marketing Project Sas .Net Oracle

Raghavendra

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

PROFESSIONAL SUMMARY:

SAS Base and Advanced Professional with over 6 years of experience in data

analysis and reporting in Marketing, Educational, and Financial industries

using SAS Software on different RDBMS's and various platforms.

. Extensive experiences in SAS v8.2/v9.1.3/v9.2, SAS/BASE, SAS/MACROS,

SAS/STAT, SAS/SQL, SAS/ACCESS, SAS/GRAPH, SAS/ODS and SAS/CONNECT, SAS

Enterprise Guide, SAS Enterprise BI Server.

. Thorough programming experience with different procedures like PROC

FREQ, PROC TABULATE, PROC TRANSPOSE, PROC SORT, PROC SQL, PROC REPORT

etc.

. Experienced in creating reports for Regulatory submissions in HTML and

RTF format using ODS statements and SAS BI tools such as Web Report

Studio.

. Proficiency in creating SAS Macros for reusability, minimize data

processing and data extraction activities.

. Experienced in developing web and client/server application software

using ASP.NET,C#, Window Services, Web Services and ADO.NET in major

functionalities.

. Extensively worked on various RDBMS like Teradata 12.0, Oracle 9i/10g,

MS SQL Server 2000/2005/2008 and MS ACCESS.

. Experience in different OS Platforms like WINDOWS and UNIX.

. Extensive experience in Microsoft Office (Word, Excel, PowerPoint,

FrontPage.)

. Proven skills in data cleansing, data archival, data migration, ad-hoc

reporting, and coding using SAS on various environments.

. Experience in setting up meeting, and collaborating with technical and

non-technical team-members and clients.

. Experienced with SAS 6.12, SAS v7.0, SAS v8, SAS/BASE, SAS/STAT,

SAS/SQL, SAS/Macros, SAS/GRAPH, SAS/ACCESS, and SAS/ODS.

. Extensive knowledge in data management like Merging, concatenating,

and interleaving of SAS datasets.

. Strong working knowledge with analysis of clinical trial data,

generating reports, tables, listings, graphs and summaries as per

company standards in compliance with 21 CFR Part 11 and other FDA and

GCP Guidelines for Phase(I- IV) Clinical Trial studies.

.

TECHNICAL SKILLS:

Data Analysis SAS/BASE, SAS/MACRO, SAS/SQL, SAS/EG, SAS/STAT,

Software SAS/Access, SAS/CONNECT, SAS/ODS, SAS Enterprise BI

Server

Databases MS-Access-97/2000, SQL Server 2005, Oracle RDBMS 9i/

10g.

Languages SQL, PL-SQL, Visual Basic 6.0, C, ASP, ASP.Net, C#,

Development Skills Transact-SQL (T-SQL), PL/SQL.

Operating system MS Windows (95, 98, 2000, NT, XP, Vista, Windows 7),

MS-DOS.

Software Exposure C, MS.Net Framework 2.0, MS.Net Framework 3.5, C#,

XML, AJAX.

Microsoft Tools MS Office (Word, Excel, Power Point, Access,

FrontPage), Macromedia Dreamweaver, Ms-Visual studio

2005/2008.

PROJECT PROFILE:

1. Enterprise Report Development:

Duration Jan 10 - June 10

Client University of Minnesota, Minneapolis, MN

Role Sr.SAS/Oracle Analyst

Environme SQL-Server 2000/2005/2008, Oracle 10g, TOAD 9.1, Windows XP,

nt PL/SQL, SQL*Plus, Visual Source Safe, .Net Framework,VB.Net,

SQL Server Management Studio, MS Access and MS Excel.

Project Description:

University of Minnesota (U of M) is the second-largest institution of

higher education in the Midwest by enrollment. The University has their own

data-driven reporting website which hosts the academic and financial

reports. The performance of the financial reports which involved

transaction tables is bad in running time. Worked on performance tuning and

generation of financial reports.

Roles and Responsibilities:

. Created SAS data sets by extracting data from Oracle tables using

SAS/CONNECT and SAS/ACCESS.

. Used TOAD 9.1 features to connect to databases for comparing views and

checking syntax errors in the PL/SQL stored procedures for performance

tuning and quality control.

. Developed and modified technical designs for requested reports,

working from functional designs provided by Administrative Application

Systems (AAS) business analysts.

. Followed Office of Information Technology (OIT) development

methodologies and practices.

. Attended project team meetings, worked with Technical Project

Managers, Data Managers

as appropriate. Reviewed and provided feedback for Data Integrity

Plans.

. Developed scripts, procedures and applications to generate

sophisticated ad hoc reports using SAS/EIS and SAS/AF.

. Created custom reports using Data _Null_ and reports generation using

ODS (HTML, CSV, PDF and RTF).

. Developed and modified SAS Procedures, Macros, applications for data

cleaning, reporting and also involved in preparing documentation.

. Generated SAS/ MACROS and several PL/SQL stored procedures for

reusability and to minimize data processing in report generation.

2. Data Processing of Regulated Legal Claim Cases.

Duration Nov 08 - Dec 09

Client Rust Consulting Inc, Minneapolis, MN

Role Sr.SAS/SQL Analyst

Environment Windows XP, Vista, SAS 8.1, SAS 9.1, SQL Server, MS

Access, SAS/ETL, SAS/EG, SAS/ACCESS, SAS/ODS, SAS/SQL,

Oracle.

Project Description:

Rust is a leading company in class action settlement firm and is a Law suit

and Class Action Settlement firm. Rust deals with Employment, Regulated,

Consumer and Security Claim Cases. Some of the Regulated clients include

Bear Stearns Fund Family, Putnam Outreach, Janus Capital, Merrill Lynch

Investments and Prudential Fund Family. This position deals with Claim

Forms Processing. Involves Data Processing of Claim Forms submitted by

Clients. Involved primarily in data manipulation and processing of

Regulated Claim cases.

Roles and Responsibilities:

. Extracted data from the database using SAS/Access, SAS SQL procedures

and create SAS data sets.

. Imported the data simultaneously into source and NAS (Name and Address

Staging) datasets.

. Cleaned, filtered and validated the name and address fields in the NAS

dataset using SAS ETL and SAS Enterprise Guide.

. Developed dynamic websites for Employment Claim Cases using C#.net and

ASP.NET.

. Based on the requirement incorporated message codes for every claim.

. Generated reports to identify the claims to be processed in the

current and next wave, to keep track of BDAT (Bad Data) or rejected

claims, to calculate the amount to be disseminated in the current wave

and reserves to be held for the next wave.

. Used Dynamic Data Exchange (DDE) feature of SAS for importing and

exporting of data from and into SAS, MS Access and Excel.

. Developed and Used User Controls using C#.net and ASP.NET

. Used Macros to design applications for flexible and on-demand

reporting.

. Extensively used PROC PRINT, PROC REPORT and PROC TABULATE for

reporting.

. Use577wd SAS/ODS to produce RTF and HTML reports.

. Wrote some complex PROC scripts to pull Distribution Files from

different staging tables to send the checks to respective persons.

. Submitted SAS/SQL Queries to validate data.

. Worked on projects ranging from a few hundred to several million

claims.

. Disseminated thousands of direct and email notices and processed

hundreds of thousands of claims on a $1.1 billion antitrust

settlement.

3. Profirus Business Solutions

Duration Oct 07 - Sep 08

Client Texas Health Care Information Collection (THCIC), VA.

Role Sr.SAS/SQL Programmer

Environment Windows XP, UNIX (AIX), SQL Server 2008, SAS 9.1.1.3,

SAS/ACCESS, SAS/CONNECT, SAS/STAT

Project Description:

The project aims at producing reports on performance of hospitals in Texas

Medical Center area, Houston. The source for these reports is the

administrative data that hospitals record for billing purposes. This data

contains patient details, diagnosis or procedure information, discharge

status and presiding physician's details. The hospitals are compared based

on volume and mortality indicators. The report includes a database of

hospitals performance from 2003 through 2007, as well as bar charts and

tables for each of the measures.

Roles and Responsibilities:

. Extracted the data from SQL Server database to create a SAS

repository, using SAS/ACCESS.

. Divided the repository into different datasets, one for each year

starting from 2003.

. Used Proc Report to categorize the dataset based on diagnoses and

surgeries performed.

. Calculated the success and failure rates for each diagnosis and

surgery.

. Used SAS/STAT to create pie diagrams and bar charts to show the

hospital performance based on volume and mortality indicators.

. Used Macros to automate the above processes for all datasets.

. Created complex and reusable Macros and extensively used existing

macros and developed SAS Programs for Data Cleaning, Validation,

Analysis and Report generation. Tested and debugged existing macros.

. Used SAS functions like proc sql, proc report, proc print, proc

append, merge, set, macros, import and export, nodupkey and proc

compare.

. Exported data into PDF, XLS, TXT, MDB, XML, and delimited file formats

on UNIX and Windows platforms.

. Executed System, Functional, Regression, Integration and end-to-end

testing.

4. Profirus Business Solutions

Duration Jan 06 - Jun 07

Client K-Mart, VA

Role SAS Analyst

Environment Windows XP, UNIX (AIX), SQL Server 2008, SAS 9.1.1.3,

SAS/ACCESS, SAS/CONNECT, SAS/STAT

Project Description: K-Mart has thousands of retail stores all across the

nation. Their overall success relies on a thorough understanding of the

businesses at these stores and on providing superior service to the retail

customers. However, understanding demand level consumption for each

retailer is a daunting task. The project aims at creating data marts to

answer mission-critical questions. The point-of-sale data (or source data)

from the retailers is in different forms like EDI files and flat files.

These data marts help in identifying stock-outs, tracking sales and

inventory, and forecasting customer demand.

Roles and Responsibilities:

. Built the data mart using dimensional models provided by SAS DI studio.

These models are organized as star-schema made up of fact tables and

dimension tables.

. Created sales fact table and product, store and time dimensional tables.

. Used Source Designer to capture source data from SQL Server database.

. Loaded dimensional tables using Process Designer and fact tables using

lookup transformation techniques.

. Designed the data mart to incorporate various analytical and operational

needs to serve finance, marketing and claims departments.

. The data mart provided a flexible approach to query the data at any time,

in any format and from many angles.

. Used procedures such as proc freq, proc means, proc tabulate, proc sql

and proc compare to check the quality of the data.

. Wrote various SQL queries and developed required report logics.

. Documented code and prepared reports using proc report, proc tabulate and

Web Report Studio.

. Performed Ad-Hoc Reporting.

5.Customer Behavior Analysis

Duration July 04 - Dec 05

Client Guaranty Bank,VA

Role SAS Analyst

Environment Windows XP, UNIX (AIX), SQL Server 2008, SAS 9.1.1.3,

SAS/ACCESS, SAS/CONNECT, SAS/STAT

Project Description:

Assisted the marketing department as a SAS analyst in carrying out Business

Marketing Campaigns. The application analyzes credit card customer behavior

and keeps track of top 10 merchants that customers spend their money with.

This behavioral study helps in improving customer retention count by

providing incentives with the merchants. The goal of this project is to

provide the company with quantitative data and qualitative information

necessary to understand customer's true experience.

Roles and Responsibilities:

. Gathered and assimilated data from Oracle, Teradata, 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.

EDUCATIONAL QUALIFICATIONS:

. Bachelor of Technology in Electronics & Communication Engineering from

Jawaharlal Nehru Technological University.

GPA-3.64/4.0

REFERENCES

Available upon request.

Contact this candidate