Data Sales

[pic]

SUMMARY OF QUALIFICATIONS

. Certified SAS professional with almost 2.5 years work experience in

analysis, design, development, testing, and implementation of Business

Analytics projects using SAS software. Hands on experience and

thorough understanding of SAS Enterprise Business Intelligence toolset

and its configuration on windows platform.

. Worked with Banking, Energy and Educational domains.

. Extensive exposure on every step of entire software development life

cycle (SDLC) including data collection, query, modifying and analysis,

coding statistical models, summarizing the findings, and presenting

the results. Command in importing and exporting complex internal data

to and from Microsoft Excel and Microsoft Access using PROC IMPORT and

PROC EXPORT.

. Proficient in SAS v9.1/9.1.3/9.2 and strong experience in Base SAS,

SAS/Stat, SAS/Graph, SAS/Macro, SAS/ODS, SAS/Access, and SAS/SQL under

Windows environment. Solid understanding of data cleansing, data

management and data processing techniques like merging, concatenating,

interleaving, appending of SAS datasets and data validation using Proc

Compare and Proc Freq.

. Good understanding of SAS functions like Character functions, Date

functions and familiar with Formats and Informats.

. Thorough experience in extracting data from various disparate data

sources like (xls, csv, txt) files, Oracle, SQL Server, MS-Access,

etc. Ability to analyze & process data using various SAS procedures

such as utility procedures, report procedures, statistical procedures.

. Strong experience in SAS Enterprise guide in creating stored processes

using the dynamic prompts containing both packaging or streaming

output, and prepared reports using ODS.

. Well versed with platform for SAS Business Analytics typically client

tier consisting of SAS Enterprise guide, SAS Add-in for Microsoft

Office, SAS Information Map Studio, SAS OLAP Cube Studio and middle

tier consisting of SAS Information Delivery Portal, SAS Web Report

Studio, SAS Stored Process Web Application, SAS Content server and SAS

BI dashboards.

. SAS Management Console used to create the metadata libraries and also

for password administration.

. Ability to work efficiently in both independent and team environments,

worked with Project Managers, Team Members / Associates,

Statisticians, Business Analysts to analyze survey data for generating

Tables, Listing Outputs and Customized Graphs.

. Possess excellent communication, problem solving skills. Reputed for

dedicated teamwork, solid work ethic and Commitment to achieving

various Goals and key objectives as set forth by senior management of

the company.

PROFESSIONAL CERTIFICATES

. SAS Certified

Base Programmer for SAS 9

. Oracle Certified

Introduction to Oracle 9i: SQL

Implementing a Database Design with SQL 7.0

. Microsoft Certified

Microsoft Certified .Net Framework 2.0 - Web-Based Client Development

Microsoft Certified Developing & Implementing Web Applications with Visual

C# .NET and Visual Studio.NET

. Programming Using C++

EDUCATION

. Master's Degree in Management Information Systems, University of

Houston- Clear Lake. December 2009

GPA: 3.83/4.0

. Bachelor's Degree in Electronics & Telecommunication Engineering,

India. August 2006

TECHNICAL SKILLS

Base SAS Data Step, SAS procedures, Formats, Informats, Macros,

Data _Null_ Reports, SAS Functions, Descriptive

Statistics, SAS ODS, Arrays

SAS Procedures Append, Compare, Chart, Contents, Datasets, Copy,

Export, Format, Freq, Import, Means, Print, Print to,

SQL, Sort, Summary, Tabulate, Transpose and Univariate.

Databases Oracle9i/10g, MS-Access, MS-Excel, SQL Server

SAS Products Base SAS, SAS/Access, SAS/Connect, SAS/Share,

SAS/Graph, SAS-ODS SAS Add-in for MS-office, SAS

Enterprise Guide, SAS Enterprise Business Intelligence,

SAS Management Console, SAS Information Map Studio, SAS

Data Integration Studio, SAS OLAP Cube Studio, SAS

Application Servers, SAS Web Report Studio, SAS

Information Delivery Portal, SAS BI Dashboard & JMP.

Operating Windows XP, 2003, Vista and UNIX

Systems

Programming SAS, ASP.NET, C, C++, SQL, Java Script, HTML, XML

Languages

PROFESSIONAL EXPERIENCE

J P Morgan Chase, Columbus, Ohio

05/10-present

Role: SAS Engineer

Responsibilities:

. Extracted data from Oracle database (warehouse).

. Prepared new Datasets and modified existing datasets using Set, Merge,

Sort, Update, Formats and Functions and created Tables and Listings

for the same.

. Also created and maintained SAS Datasets that are extracted from an

Oracle Database using SAS/ACCESS for ORACLE and extensively used Proc

SQL to manipulate the data.

. Used Proc SQL (Pass-Through) method and Proc Append (Bulkcopy) methods

to write statistical analysis results to the ORACLE database.

. Converted Excel tables and flat (text) files into SAS datasets for Ad-

Hoc analysis.

. Data analysis, reports using SAS procedures and SAS/Macros.

. Used SAS/STAT to create different statistical reports as required.

. Extensively used various SAS Data Step functions, SAS procedures, and

SQL to write reports logics for SAS Stored Processes.

. SAS Enterprise Guide was used to convert existing SAS programs to SAS

stored processes using dynamic prompts and produced packaging and

streaming outputs as required.

. SAS Management console used to create metadata libraries.

. Developing SAS Stored Processes that can be easily used by end users

using SAS Add-in for Microsoft Office and other SAS BI clients

from SAS Information Delivery Portal.

Environment: SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/STAT, SAS/SQL, ORACLE,

MS-OFFICE, Windows.

Department of Decision Science (Quantitative Management), University of

Houston-Clear Lake, Houston, TX. 09/08-12/09

Role: Statistical Analyst

I worked on various projects for Department of Decision Science at

University of Houston-Clear Lake. My role was to design and execute

programs to create data sets, perform statistical analysis and assist

research team in interpretation of the results and to produce reports.

Responsibilities:

. Responsible for writing, modifying and maintaining SAS programs to

produce data sets, summary tables, figures and data listings for

research projects.

. Applied experimental design, test of significance, analysis of

variance, multiple comparison techniques and data reduction to various

data sets utilized.

. Extracted data from database in flat files or excel spread sheets and

transformed into SAS data sets for further analysis.

. Utilized SAS for manipulation and statistical analysis of large data

sets to identify trends, relationships and statistical significance.

. Performed data analysis mainly using MS-EXCEL for Regression and ANOVA

. Performed statistical data analysis, generated reports, listings and

graphs using SAS/Base, SAS/Macros, SAS/SQL, SAS/Access and SAS/Graph.

. Worked with procedures such as SQL, FREQ, SORT, REPORT and MEANS as

per the requirements.

. Created reports in the style format (RTF, PDF and HTML) using ODS

statements.

. Developed reports using PROC REPORT, PROC TABULATE and DATA _NULL_.

. Worked extensively with MS-Excel, using pivot tables and creating OLAP

cubes.

. Assisted in creating Stored Processes using SAS Enterprise Guide,

Information Maps using Information Map Studio, Web Reports using Web

Report Studio and Information Delivery Portals.

Environment: SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ACCESS,

SAS/Enterprise Guide, MS EXCEL (data analysis tool), Windows.

Bharat Petroleum Corporation Ltd, Mumbai, India

08/06-04/07

Role: SAS Programmer

Bharat Petroleum Corporation Ltd (BPCL) is a petroleum company, which

distributes petrol all over India. The project aim is to create various MIS

reports such as sales by product, sales by division, sales by year, sales

by sub-unit, sales by managers and sub-unit, for all regional centers of

India. Base SAS is used to import data from raw data files such as EXCEL

and TXT files into SAS datasets and write summarized data to ORACLE

database and there on reports were generated using SAS ODS techniques such

as RTF, PDF, and HTML.

Responsibilities:

. Responsible for data analysis, data cleansing, coding, testing, and ad

hoc reporting.

. Coordinated with the team for various enhancements in the reports.

. Coded programs for generating new reports and did documentation for

the existing code.

. Used PROC IMPORT to read data from raw data files such as xls files,

txt files, csv files and used PROC MEANS to summarize data.

. Created and maintained SAS Datasets that are extracted from an Oracle

Database using SAS/ACCESS for ORACLE and extensively used Proc SQL to

manipulate the data.

. Used Proc SQL (Pass-Through and Libname) methods and Proc Append

(Bulkcopy) methods to write statistical analysis results to the ORACLE

database.

. Extensively used SAS data steps, SAS proc steps, and SAS/SQL for

developing reports.

Environment: Windows, SAS/BASE, SAS/ODS, SAS/ACCESS, SAS/SQL, ORACLE, MS-

OFFICE.

REFERENCES: Furnished upon request.

Contact this candidate