BHUSHAN KAPLE

*, ** ****** ******, *******, Wellington – 6021

Mobile: +64-21457407 Email: act8t4@r.postjobfree.com

PERSONAL STATEMENT

A dedicated and energetic professional with 7+ years of experience in SAS technologies along with possessing SAS technical certifications. Recognised for always paying attention to details even when under pressure and for having an approachable, cheerful and friendly attitude. After establishing myself in New Zealand, I’m looking to build on my professional experience and further develop my SAS skills.

PROFESSIONAL SUMMARY

I have 9.5 years of experience in Information Technology field with working experience in various technologies which include SAS, ETL and PLM etc.

I have 4+ years of IT experience in the SAS R&D global delivery model using base/advanced SAS and proven track record of timely and quality deliverables.

I have 2+ years of experience in SAS PSCC global delivery model for large US clients, having worked on deliverables for various projects of varying sizes. I specialize in client interaction and quality deliverables using SAS Data Management Platform.

I have 1 year of experience in Tenzing Limited where I have worked for New Zealand clients mainly on SAS tools and technologies.

TECHNOLOGY EXPERIENCE

SAS Products

1)SAS Base /Macro /SQL

2)SAS Enterprise guide

3)SAS InfoMap

4)SAS BI Dashboard

5)SAS Information Delivery Portal

6)SAS WRS (Web Report Studio)

7)SAS DI

8)SAS Stored Procedure

9)SAS Merchandise Intelligence

Operating Systems

1)Unix

2)Linux

3)Windows

Databases

1)Oracle

2)SQL

INDUSTRY / DOMAIN EXPERIENCE

Tenzing Private Limited (1 Year) Senior SAS Technical Consultant

SAS Professional Services : Retail (2 Years) SAS Technical Consultant

SAS R&D (4 Years) Senior Software Engineer

PTC : PLM (1 Years) Engineer I

MAJOR IMPLEMENTATIONS – TENZING

Domain

Social Housing

Client

MINISTRY OF SOCIAL DEVELOPMENT

Project Name

Social Housing Reporting

Project Details

MSD wanted a contractor to support the IDU team in generating the housing report mainly from the IPV(Integrated Person View) data. I joined the IDU team and quickly grasped the MSD data concepts and operational model. After 4-5 months, all my coworkers moved to a new work area(SCMS) and I am alone handling the housing report requests. I interact with the business folks who require that specific report and deliver the required output in a timely way.

Tools Used

SAS 9.4 on Windows

1.SAS Editor

2.SAS Enterprise Guide

Domain

Insurance

Client

IAG, NEW ZEALAND

Project Name

Combined partnership reporting

Project Details

IAG wanted to completely integrate the Lumley and NZI data to create one single, combined report. They wanted to use SAS as the main tool to generate the reports rather than having to use MS Excel to do so. I implemented the above functionality to have the reports generated in a PDF format and automate this report generation every month. I was alone on this project and had to do the design, coding and testing all alone and yet managed to complete this project before the actual deadline.

Tools Used

SAS 9.4 on Windows

1.SAS Editor

2.SAS Enterprise Guide

MAJOR IMPLEMENTATIONS – PSCC, SAS

Domain

Retail

Client

BELK, USA

Project Name

Demand Forecasting for Retail 5.2

Project Details

Belk had identified some issues and had requested changes to DFR(Demand Forecasting for Retail) which required data management assiatance to extract the hierarchies of the fact data. This extracted data was to be consumed by the analytic folks to implement the requested changes and address the issues. Along with extracting the data hierarchies, I also worked on ETL tasks for transforming, truncation and validation of the data coming from Merchandise Planning Solution using SAS DI Studio. I also improved the efficiency of existing SAS code for better performance.

Tools Used

DFR, SAS 9.2 on Windows

1.Base/Advanced SAS

2.SQL Developer

3.SAS DI Studio

Domain

Retail

Client

Internal

Project Name

STAGE STORES Installation activity

Project Details

Installed 3-tier SO 3.2 (Size Optimization) solution on local PUNE servers as a part of getting hands-on for Install activity. Went through the pre-requisites for install activity and post-install validations as well.

Successfully installed the same configuration on client environment which was managed by RACKSPACE (third party hardware vendor)

Tools Used

SAS 9.3 on UNIX

1.Unix Environment

2.SAS Deployment Manager

3.SAS Management Console

Domain

Retail

Client

STAGE STORES, USA

Project Name

STAGE STORES Assortment Plan Import

Project Details

Implemented a custom-built, SAS-based solution called The Assortment Plan Import FES which will enable Stage Stores’s business users to import the style-color, store level order quantity information from Stage Stores’s Excel based Assortment Planning tool into the Pack Optimization UI. This data will be combined with Stage Stores’s user input pack configuration settings to determine the optimal configuration and quantity of packs to purchase.

Tools Used

SAS 9.3 on UNIX

1.SAS Enterprise Guide

2.SAS Data Management Platform

3.Base/Advanced SAS

Domain

Retail

Client

The Great Atlantic and Pacific Tea Co. USA

Project Name

On-demand Actions for SAS Merchandise Intelligence

Project Details

Implemented a custom-built SAS solution for creation of 3 On-demand actions, to be used by the A&P business users to create and validate promotions. This is a PPO(Promotion Price Optimization) solution which runs in the backend to aid the promotion creation and execution cycle. Was involved in development of sas programs(using base/advanced SAS) for the above On-Demand actions.

Worked on SAS BI Tools (SAS Infomaps, SAS WRS, SAS IDP and BI Dashboard) for presenting the daily and weekly batch results.

Worked on 3 tier architecture of servers and I have a understanding and hands-on of compute/mid/client tier server scripts, logs and locations.

Tools Used

SAS 9.2 on UNIX

1.SAS Enterprise Guide

2.Base/Advanced SAS

3.SAS BI Tools (SAS Infomaps, SAS WRS, SAS IDP and BI Dashboard)

4.SAS Merchandise Intelligence solution

EDUCATION

Master Of Science, Software Systems

BITS PILANI, Rajasthan, India

Bachelor of Engineering, Information Technology

Government College, Pune, India

CERTIFICATIONS

SAS Certified Platform Administrator SAS 9

SAS Certified Data Integration Developer for SAS 9

SAS Certified Base Programmer for SAS 9

SAS Certified Advanced Programmer for SAS 9

ORACLE SQL Fundamentals I for Oracle 11g

ACHIEVEMENTS

SAS VCA Award

Received SAS Valuable Contribution Recognition Award in 2011

MASTER’S Degree

Secured 8.5 CGPA in Master degree for Software Systems

NITAT EXAM

National Merit Holder in NITAT 2008

HSC 12th Degree

Secured 93% in University Exam

SSC 10th Degree

12th University Merit Holder in SSC exam

INTERESTS

Playing Cricket, Football, Table tennis and Chess. I have captained SAS cricket and football team while I was in SAS India.

PERSONAL INFORMATION

Date of Birth

22nd April 1984

Marrital Status

Married

Nationality

Indian

PassportStatus

Valid Indian Passport (M2709599) with NZ work visa

Current Address

Apartment No 8, 26 Rhodes Street, Newtown, Wellington - 6021

Contact this candidate