E-mail: actisk@r.postjobfree.com

Mobile: +917*********

Career Snapshot

Having overall 2.5 years of experience working as SAS Developer.

Having Experience of one End to End design and development.

SAS Expertise

Proficient with SAS/BASE, SAS/ODS, SAS PROCEDURES, SAS MACROS and SQL in Windows Environment.

Optimized performance using Data Validation and Data cleansing using Statistical procedures like PROC FREQ, PROC MEANS, PROC SUMMARY, and PROC UNIVARIATE.

Generate reports using PROC PRINT, PROC REPORT, PROC TABULATE and DATA_NULL_ for customized report writing.

Good programming skills in SQL and understanding of data management principles, such as joining data sets, data aggregation and sub-setting using PROC SQL.

Experienced in data manipulations by using SAS data step statements such as, SAS Formats/In formats, Merge, DATA _NULL_, Set, Update, Functions and conditional statements, and by applying advanced SAS programming techniques, such as PROC SQL (JOIN/ UNION), PROC APPEND, and PROC TRANSPOSE.

Expertise in producing PDF, HTML files using SAS ODS facility.

Designed and developed Extract, Transform, Load (ETL) processes using Base SAS, Data Integration Studio to populate Data Warehouses and Reporting Data Marts

Good knowledge of using SAS Enterprise Guide, SAS Eminer, SAS Model Manager.

Scoring Eminer model in SAS DI by publishing model from model manager.

Retrained model from SAS DI using user written transformations.

Involved in planning, design and build of ETL Jobs and Modelling.

Basic understanding of SAS Macro Language.

Ability to constantly upgrade my skills, quick learner, hard worker, Adaptable.

Ability to work efficiently under stress, High level of commitment and punctuality.

Confident to accept challenging jobs and adaptable to changes.

Components

Components: SAS Base, SAS EG, SAS Eminer, SAS DI, SAS Model Manager

Projects Details

Project: 1

Company : Wipro Technologies.

Project : POC

Designation : Project Engineer

Duration : 1 year 3 Months

Tools : SAS Base, R, Tibco Spotfire

POC Description:

MPAC (Manufacturing, Process Analytics and Compliance) Solution where user can able to visualize the trend and performance of their process from source system to final objective. I was involved in building one of its component LIMS which involves understanding whole system requirements, modelling, ETLs, reporting, etc. LIMS is Laboratory Information Management System which is a collection of computerized methods to acquire, analyze, store, and report laboratory data. It is used in the laboratory for the management of samples, laboratory users, instruments, standards and other laboratory functions such as work flow automation, etc.

The task includes:

Developing a data model for LIMS data warehouse.

Defining various entities involved in it and several possible attributes for each entity.

Define and create dimensions and facts based on these entities outlining all descriptive and measurable information respectively.

Populating the data model from the data provided by the vendors using suitable ETL transformations.

Building KPIs and generating reports for the system.

Creating dashboards for reports to be generated

I was also engaged in text mining of data in R and visualization of generated data and results in TIBCO Spotfire.

Project: 2

Company : Wipro Technologies.

Project : WD_SAS_QLA_ANALYTICS (PEMS: Predictive Event Monitoring System)

Client : Western Digital

Deputation : Client Site (Malayasia)

Designation : SAS ETL Developer

Duration : 1 Year 2 Months

Onsite Duration : 2 Months

Tools : SAS Base, SAS EG, SAS EMiner, SAS DI and SAS Model Manager

Project Description:

Main challenge in this POC is to identify potential failures early in the production process and subsequently avoid yield excursions to ensure both volume and efficiency in the manufacturing and distribution of hard disk drives.

Once a hard drive has reached the assembly process the benefits of intervention are limited so the key business driver for this project is to predict a probability of failure on receipt of the data from the suppliers of heads and media. The purpose of the prediction is not to capture and intervene on every individual hard drive failure but to generate an early detection of an increase in predicted failed components and to be able to trace this back to specific attributes associated with the heads and media.

The task includes –

•Analyzing historical data from WD to create a model to predict failure.

•Building data marts using SAS DI.

•Using predictive model for scoring and identifying defective heads.

•Automation of whole process in SAS DI.

•Retraining of champion model in SAS DI.

Project: 3

Company : Wipro Technologies.

Project : POC (To improve the yield to increase revenue and profits using predictive modelling.)

Client : Sterlite and Sandisk

Designation : SAS Developer

Duration : 1 Months (Contd.)

Tools : SAS Base, SAS EG, SAS EMiner, SAS DI

Educational Qualification

Master’s Degree: MCA

Institute: Silicon Institute of technology, Bhubaneswar

University: Biju Pattnaik University and Technology, Orissa.

Year of passing: 2012

CGPA: 8.99

Bachelor’s Degree: BSC (Computer Science)

Institute: G.M College, Sambalpur

Board: Sambalpur University

Year of Passing: 2009

Percentage: 80%

Additional Information

Date of birth : 4th December 1988

Current Company : Wipro Technologies

Current CTC : 3.98 LPA

Expected CTC : 6.5 LPA

Notice Period : 2 months

Preferred Location : Hyderabad/Any

(Subharanta Ku. Bohidar)

Contact this candidate