*

PRASENJIT DAS

acqz2m@r.postjobfree.com +91-833-***-****

Associate Consultant

* ***** ** ********** ** Wipro Technologies with involvement in Requirement Gathering, design, development and support experience in Data management, Data Analytics, Data Visualization and Data Mining tools and technologies with exposure in R, SAS, SPSS. Involved in techno functional role on Spend Analytics for Oil & Gas domain and Marketing Analytics for campaign. Actively looking for a data scientist/analytics consultant role in areas related to Marketing/HLS/HSSE/Retail/CPG.

Currently pursuing Data Science (Big Data+SAS) Certification from Calcutta Business School. EDUCATION, CERTIFICATIONS, TRAININGS

EDUCATION PROFILE

Currently pursuing Data Science Certification from Calcutta Business School

B.Tech in Electronics and Communication Engg. (Heritage Institute of Technology, Kolkata)(CGPA – 8.07/10)

Higher Secondary from J.P.B.S., Kolkata (80%)

Secondary from A.K.G.M School., Kolkata (85%)

CERTIFICATION

Oracle certified SQL Expert (Oracle Corp)

Oracle PLSQL developer certified associate (Oracle Corp)

Data Scientist toolbox (Coursera)

R Programming (Coursera)

Getting & Cleaning Data (Coursera)

Applied Regression Analysis (Coursera)

Data Science from Calcutta Business School (Data Mining, Machine Learning, Big Data) PROFESSIONAL TRAININGS

BASE SAS Programming 1 & 2(from SAS Institute Inc)

SAS EGuide, SAS EMiner, Content Categorizer Studio(from SAS Institute Inc)

SAS Data Integrator with Hadoop(Cloudera stack), SAS Visual Analytics (from SAS Institute Inc) Technical Skills

OPERATING SYSTEMS Solaris10, Red Hat Linux 5.1, Windows7 LANGUAGES SQL, PL/SQL, shell scripting

DATABASE MODELLING TOOLS ERWIN 4.1, MS Visio 2010

DATABASE Oracle (Oracle 9i/10g/11g)

REPORTING TOOLS

Oracle Reports 6i, SAP Business Objects XI 3.1

STATISTICAL TOOLS

SAS/BASE, SAS/EG, SAS/EM, R, SPSS, Excel, SAS Content Categorizer Studio

DATA VISUALIZATION TOOLS SAP Web Intelligence 4.1, Tableau 8.2 BIG DATA Apache Hive

2

PRASENJIT DAS

acqz2m@r.postjobfree.com +91-833-***-****

ANALYTICS EXPERIENCE

Data Manipulation

Data Analysis using data mining techniques like Decision Tree, logistic regression and Neural networks

Unstructured Data Analysis including text mining (parsing, filtering and clustering) Analytical Platforms:

SAS Enterprise Guide

SAS Enterprise Miner

SAS Text Miner including content categorization

Projects Done:

Worked on small project in Forensic linguistic for identifying Ted Kaczynski as a Unabomber based on his writing style using SAS Text Miner using Decision Tree modelling.

Building and optimizing predictive model for the person’s donation when the NGO organization incurs cost in sending outbound fulfillments through postal mails by using Decision Tree, Logistic Regression and Artificial Neural network with comparing models in SAS Eminer in collaboration with SAS India.

Worked on case study for building a classification model for an insurance company, if probed, would buy the insurance with Principal Component Analysis and Decision Tree in IBM SPSS.

Worked on a text analytics case study to build rule based and statistical based categorizer on a drug related data usig LITI definition and regular expression with SAS Content Categorization studio.

Participated in a hackathon organized by AnalyticsVidhya.com to predict the survivors on the Titanic Dataset from Kaggle.com.

IT EXPERIENCE

Client #1: Large Healthcare Accounts Marketing platform Location: Kolkata, India

Duration: 1 year (April 2014 – till date)

Role: Offshore Operations Lead

Domain: Healthcare and Life Sciences

Roles and Responsibilities

Leading the Support team for Integrated Relationship marketing architecture. Provide end to end support of the business process flow with respect to data received and sent to multiple vendors across the marketing business of healthcare major. Provide data for the customers marketing insights and loyalty program for analytics program with respect to campaign management.

Designed and developed a middleware job processing system with Java, PLSQL and shell scripts for manual job processor to replace COTS middleware tool.

Worked on a POC to provide campaign management and loyalty account information data extraction and management to optimize brand and campaign management.

Working on a POC to make the transactional database leaner through introduction of a data mart/warehouse for keeping the frozen copy of the data for future reporting purpose as per FDA guidelines. 3

PRASENJIT DAS

acqz2m@r.postjobfree.com +91-833-***-****

Client #2: Oil and Gas Account’s health and safety project for a global super major Location: Houston, TX, USA

Duration: 2 years (Jan 2012 –Mar 2014)

Role: Onsite Subject Matter expert /Technical Lead Domain : Oil & Gas

Roles and Responsibilities

Leading the Support team for multiple enterprise application under HSSE and Remediation Management. Provide data management support of the applications and provide continuous improvement ideas, plan for security audit gaps and identifying risk areas in application.

Elicit new requirements using with business analysis, requirements workshops, use cases documentation and coordinating with the customer manager.

Provided data management and extraction for Spend Analytics Data in terms of hours worked by the refinery employees to optimize costs.

Worked on developing multiple SAP BI reports to provide metrics and KPI details in terms of health and safety across geographies.

Client #3: Electricity Distribution client in UK

Location: Leeds, UK

Duration: 1 year 6 months (July 2010 – Dec 2011)

Role: Programmer Analyst, Build-Deployment and Configuration Management Domain: Energy & Electrcity

Roles and Responsibilities

Supported multiple application related to UK electricity domain under metering, revenue recovery, allocation of Units and knowledge on different market participants.

Worked on different metering applications with products like Service Director and Oracle Resource Schedulers.

Gather requirement from business and prepared use cases for multiple small projects under metering domain

Worked as a deployment engineer for build and deployment process during datacenter migration.

Worked on configuration management for data center migration for application migration and highlighted risks to senior management so that it could be mitigated. Client #4: Shipping Classification society’s health and safety system Location: Kolkata, India (Offshore)

Duration: 3 years (July 2007 – June 2010)

Role: Developer and Support Analyst

Domain: Shipping

Roles and Responsibilities

Worked on multiple projects in PLSQL development and Oracle Reports for data management and visualization.

Followed the requirement document and use cases to develop the modules related to Shipping domain’s Health & safety measures through Incident management system.

Involved in ascertaining low level estimations for different modules and also suggested few optimizations to automate few manual tasks.

Contact this candidate