Amar Sureshrao Paliwal

Dallas, TX ***** 469-***-**** www.linkedin.com/pub/amar-paliwal/23/bb0/5a5/ acpbs3@r.postjobfree.com

CERTIFICATIONS & TECHNICAL SKILLS

Certifications: SAS - UT Dallas Graduate Certificate in Business Intelligence and Data Mining

Statistical & Visualization Packages: SAS Enterprise Miner, MS-Excel, Tableau Desktop

Reporting & Dashboards: MS Office 2010 Suite, Web Intelligence, Crystal Reports, Xcelsius

Database Packages: Oracle, MS Access, MS Visio, MySQL

Programming: SQL, PL/SQL, UNIX, HTML, Java, SAS Base

EXPERIENCE

Jun 2014 – Dec 2014

Shutterfly Inc., Redwood City, CA, USA

Marketing Data Analyst Intern; CRM Analytics & Direct Mail Operations

Performed post campaign analysis, A/B testing and built Tableau reports to assist the marketing team in measuring effectiveness

of campaigns as well as performance of key customer segments

Developed statistical models, customer segmentation and dashboards on key performance metrics through cohort analysis,

lifetime value and product purchase behavior to track KPIs

Assisted CRM marketing team with PL/SQL scripts, cron scheduling and direct mail list generations

Delivered KPIs through standard and ad-hoc reports for the Shutterfly business unit

Worked cross-functionally with Strategy and Data Warehouse team to aggregate data from ecommerce platforms, ESP, and

Omniture to enhance targeting and reporting capabilities

Jan 2014 – May 2014

Gearbox Software & UT Dallas, Plano, TX, USA

Student Data Analyst; Capstone Project: Business Intelligence and Data Analysis

Analyzed real time player data and developed a model for predicting behavior of bots, which enhanced the bot’s performance and

user’s experience in a new gaming project

Proactively communicated and coordinated with IT managers in all stages of project life cycle to ensure business requirements

are successfully implemented

Jun 2010 – July 2013

Tata Consultancy Services Limited (TCS), Pune, MH, India

Systems Engineer; MIS Report Development & Operations

Managed i-reporting based applications on Unix, Java and Oracle platforms, generated weekly and monthly business reports as

per TRAI regulations, which reduced the report generation time by more than 40%

Identified and remedied the root cause of development defects and Severity operational issues; reducing defects by 30%

Resolved critical application issues under challenging deadlines and received appreciation from senior management

Trained new members of development and operations team on project working and pr ocesses, also, consolidated and accurately

documented all processes, created progress and final reports for senior management and clients

ACADEMIC PROJECTS

Customer Analytics: Predicting Customer Churning

Predicted the churning percentage of the customer for the upcoming five years in future, given historical data of last seven years

Built a model based on beta distribution which is able to fit the data and predict the churning percentage with 92% accuracy

Business Intelligence and Analytics

Developed and implemented a model using SAS Enterprise Miner for predicting potential subscribers for a term deposit scheme

Used predictive analytical techniques such as Decision tree, Neural Networks and Regression for identification of a model to

improve the efficiency of Bank’s marketing campaign for future subscription of term deposit

Database Management

Designed and developed a database management application for an ecommerce website using MS Access Database

Created ER diagram in MS Visio and implemented the database application using menu driven Navigation Forms/Switchboards

Data Visualization

Designed charts, dashboards and data visualization in Tableau for a UN dataset relating to trade of arms and ammunitions

EDUCATION

The University of Texas at Dallas, Dallas, TX University of Pune, Pune, India

M.S., Information Technology and Management B.E., Electronics Engineering

GPA: 3.63/4.0, Exp. May 2015 GPA: 7.88/10, May 2010

Contact this candidate