Neha Jain

Sarjapura road. Bangalore

E-mail: acx439@r.postjobfree.com

Summary of Experience:

With 11+ years of rich international experience in business analytics tool

(SAS Data Integration Studio,Management Console,SAS Web Report

building,OLAP cube Studio and Dashboard )and technology like SAS, SAP

Business Objects, SQL & client facing. Helped global customers to develop &

deploy its business intelligence projects, address their unique business

problems and managing technical and process teams.

With 5+ of expereance in teaching SAS to 100's of national and

international students, who are today successfully working in global MNC's

> Freelance trainer for SAS Base,Advance,clinical SAS and SAS BI

Jun 2013 - till date

> Neovia logistic India Pvt Ltd (acquired Caterpillar wing) Aug 2012

- may 2013

> Caterpillar logistic India Pvt Ltd. Sep 2007 - July 2012

> CAD and software designer, New Delhi Mar 2005 - Aug 2007

Key Skills:

Business Analyst, business intelligence, Data warehousing, SAS

development, SAP Business object, Trainer

Onsite Exposer & Global students from:

> USA

> Canada

> Australia

> UK

> Germany

> Singapore

Key customers worked on (Partial List)

Harley-Davidson,

Land Rover- Brazil,

Emerson,

CAT Reman - Singapore,

Terex, Bucyrus - Australia,

Auto Zone - Brazil,

Honeywell,

Walter energy - USA,

Mazda - USA,

Education Qualification

MCA: Delhi, 61%, 2005.

BSc: Dr. H.G. university Sagar, 65.2%, 2001.

XII Board: Arya Girls H S School, Sagar (MP), 69%, 1998.

X Board: Saraswati Shish Minder Sagar (MP). 73.2%, 1996.

Certification, trainings and awards

Six Sigma Green Belt

Time managements

Stress managements

PMP Preparation training

2 times Remarkable Results Awards for almost 5+ customer

deliveries

IT Skills

Languages: SAS,SQL

Operating Systems: Win 98, XP

Databases: Oracle 8-9i,

DWH Tools: Business Objects, 5.1/6.5/ XI R2, Informatica, SAS

Key Projects Worked on Last 3 projects (Partial List):

As a team Lead, handling following projects for Logistic Accuracy

management solution for Approx. 23 global customers

Statically Test Count (STC)

Ware house Audit

Reconciliation

Contributions: As a Project manager

Requirement analysis and documentation, and providing

information to clients which needs to drive faster and better

decisions

Collaborate with business to define requirements and recommend

optimized solutions

Ability to assimilate the holistic view as well the detailed

dissection of the business processes

Interface with the end users to define and document requirements

for data, reports, analysis, metadata, training, service levels,

data quality, performance and troubleshooting

Data Management Analyst/ Quality Assurance and works closely

with developers and process [partners in the delivery of error-free

data and information to global clients

Managing the entire team to deliver various responsibilities on

the Logistic Accuracy Project for round about 23 global customers.

Technical and Functional project execution responsibilities.

Development Projects:

Project 1:

Project Name: Logistic Accuracy management

Client: For 23 Global Clients

Role: SAS Developer, Business Analyst

Duration: July 2012 to till date

Team Size: 13

Technologies: SAS (http://www.sas.com/)

Project Description

This project was supporting some supply chins activities (STC, WH audit &

Reconciliation) and provides solutions for Logistic domain. 23 clients are

getting support from us.

Contributions: As SAS Development & Admin

> Using SAS BI tool, SAS Data Integration Studio,Management

Console,SAS Web Report building,OLAP cube Studio and Dashboard for

creatining the dataset,report and disply it.

Produce routine reports for internal and external clients

Create SAS program and develop solutions for new clients and

support existing clients to meet their business requirement

Proficiency with SAS macros and procedures

Performing Jack-Of-All-Trades (Development and Admin)

Lead multiple SAS admin process transition and implemented

successfully

Took new process like edit tool transition from clients from US

& Japan

Ability to automate Access reports in SAS

To work extensively with Automotive data, ensuring that the

analysis meet the client expectations as well as client Data

Quality standards.

To Understand full life cycle of data processing, from

acquisition to integration to extraction aggressively identify

potential data quality issues

Maintain quality documents like FMEA, COS, Defect log, PMP,

Internal and external process meeting.

Implemented WH audit process for 11 clients (Bucyrus, AutoZone

brazil, Mazda, Mosaic, Fisher, Walter Energy, Newmont, Emerson,

HD(NA), CDS JDC and Honeywell.)

Active member of TSI interview panel. (CasAT's interview panel)

Responsible for manipulating, transferring and managing data in

SAS

In-depth knowledge of SAS programming, data processing, data

collection, quantitative and qualitative data analysis

Study the existing process as business analyst and recommend the

improvements needed and get the approval from process partners and

customers and finally implement the same

> As a business analyst, I have to identify the need of right reports

and then develop the SAS programs to deliver the same .

Project 2.

Project Name: STC and SAS support

Client: Caterpillar Morton.

Role: SAS Developer

Duration: Feb 2009 to July 2012

Team Size: 7

Technologies: SAS (http://www.sas.com/)

Project Description

This project is basically focused on audit process for logistic domain.

Team supported 23 clients. In this project client require daily audit sheet

to maintain logistic accuracy level. SAS language is used for generate the

daily audit sheet .Audits are 10% location audit, Putaway audit, Setupkill

audit, Zero audit and empty location audit.

Contributions:

As Team Member, was responsible for

Creating the SAS program to generate daily audit sheet for

client.

Maintain existing audit program for ex. If some changes required

the change the code.

Execute the audit program and send the audit sheet to customer.

During new requirement, interaction with the client to gather

the requirement.

Prepared new Datasets from raw data files using Import

Techniques and modified existing datasets using Set, Merge, Sort,

and Update Formats, Functions and conditional statements.

Created complex and reusable Macros and extensively used

existing macros in developing SAS Programs for Data Cleaning,

Validation, Analysis and Report generation. Tested and debugged

existing macros.

Created SAS Customized Reports using the Data _Null_ technique.

Developed routine SAS macros to create tables and listings.

Developed SAS macros for data cleaning and reporting and to

support routing processing.

Used Proc REPORT to generate reports. Developed annual reports

based on existing data.

Imported data from excel sheet for analysis in SAS.

Coded SAS programs for ad hoc jobs using Base SAS and

SAS/Macros.

Maintained large data sets, combined data from various sources

in varying formats to create SAS data sets.

Environment: Base SAS, SAS/Macros, SAS/SQL, SAS/Graphs,

SAS/Reports, SAS/Connect, Windows XP professional, SAS BI.

Project 3.

Project Name: Minestar

Client: Caterpillar Australia.

Role: Business Objects Developer

Duration: Sep 2007 to Jan 2009

Team Size: 15

Technologies: SAP Business Objects, Oracle 9i, SQL, Windows NT

Project Description

This Data Mart is based on the Caterpillar mining machines health. The main

object of this Data Mart is to provide integrated information on heavy

mining machines. The model consists of two Fact tables R_PROPERTY_FACT and

R_CLASS_FACT, with several dimensions namely calendar, cycle, prompts

Shifts etc. . Aggregate tables are built to improve query performance. The

Database Has lots of historical data so data warehouse plays a major role

in making decisions to bring more revenue to company with new policies.

Contributions:

As Team Member, I was responsible for

Creating the reports using Business Object universes as the main

data provider.

Creating the reports using business object functionalities like

Queries, Slice & Dice, Drill Down, @function, Cross Tab, Master

Detail & Formulas etc.

Formatting the reports according to the user requirements by

using Business Objects.

Daily interaction with the users by taking their requirements &

adding them to the reports.

Scheduled and monitored reports using infoview.

Created Drill down reports up to 3 levels of drilling data

Project 4.

Title : Phase II Clinical trials - Safety tables.

Client : Information Resource inc.

Role : SAS Clinical Programmer

Duration : Oct 2006 to July 2007

Project Description

This trail is designed as a Phase I, double-blind, randomized Study,

conducted at single center using a 2:1 study drug-to-placebo Randomization

ratio. Eighteen patients are to be enrolled in the study, to ensure That at

least 15 evaluable patients would complete the study. (Anticipated Dropout

rate of 15 %).The objective of this study is whether the new drug is safe

And to determine Pharmacokinetic studies

Contributions:

As Team Member, I was responsible for

> Retrieved data using libname facility.

> Prepared new datasets from raw data files and modified existing

datasets using Set, Merge, Sort, Update, Format, Functions.

Created Graphs using SAS safety Graph

> Worked with Statisticians in generating SAS analysis datasets,

production of data listings, summary tables, and statistical

analysis.

> Extensively used PROC Report and PROC Tabulate and ODS to create

reports.

> Generate tables, listings including Patient Characteristics.

Project 5.

Project Name: Sales Force Analysis

Client: The Smucker company, USA.

Role: Business Objects Developer

Duration: Feb 2006 to Aug 2006

Team Size: 8

Technologies: Business Objects (6.5), Oracle 9i, SQL

Project Description

Smucker Company is a leading industry in USA involving manufacturing &

sale of different kinds of jams, Jellies, ice-cream & food items it is

having number of stores & it sells various number of products. The

database has lots of historical data so data warehouse plays major role in

making decisions to bring more revenue to company with new policies.

The solution provides a unique framework for all phases of planning,

performance analysis, and rapid decision making required to optimize

brand, sales and operations management.

Contributions:

As Team member I was responsible for

> Creating the documents using Business Object universes as the

main data provider.

> Creating the reports using business object functionalities like

Queries, Slice & Dice, Drill Down, @function, Cross Tab, Master

Detail & Formulas etc.

> Formatting the reports according to the user requirements by

using Business Objects.

> Publishing of reports to their personal mail ID's using

publisher.

> Created alerter using Business objects to highlight columns

based on business criteria.

Project 6.

For CAD and software designer, New Delhi (MCA Project)

Project Name: Complaint management system for Nagar Nigam

Client: Nagar Nigam vidisha(M.P.)

Role: Analyst, Designer, handle database

Duration: May 2005 to Dec 2005

Team Size: 3

Technologies: Oracle 8i, SQL,ASP

Project Description

The objective of our project is to automate the office working. The system

is designed to provide complete online services to the User and fulfill

the Nagar nigum internal requirements.

Contributions:

> As Team member I was responsible for

> Analyze the requirement of nagar nigum.

> Designing of form.

> Creating the Tables using SQL as the main data Structure.

Personal Details:

Contact by email: acx439@r.postjobfree.com

D.O.B: 28/10/1980

Material Status: Married

Passport No.: Yes (Visa valid for USA)

Languages Known: English, Hindi.

Contact this candidate