Project Sales

Shishir Suman

Email - *****.*****@*****.***

Phone - +918*********

Technical Skills

BI Tools MicroStrategy 9.0.X and MicroStrategy 9.X, BO (elementary)

ETL Tools SSIS, Oracle PL-SQL scripts (Procedures, loops, Cursors), kettle

(elementary)

Analytics Tools Content Mining Platform (Clarabridge), R (elementary)

Data Modeling Normalized, De-Normalized, Moderately De-Normalized, Star and

Snow Flake Schema

RDBMS Oracle, MS-SQL Server 2005, MS-Access 97 / 2000, My SQL,

Teradata

Development Tools Oracle SQL developer

Automation Scripts Batch script, Perl script

Internet HTML, JavaScript, CSS, Confirmit (Survey creation and management

Technologies Platform)

Operating Systems Windows

SDLC Requirement Gathering, Analysis, Design, Development, Testing

and Implementation of BI Projects

Domain Knowledge Sales Pipeline, Macroeconomics, Hospitality, Television

Advertisement and Media, Digital Advertisement and Media, Text

analytics

Experience

Total Experience - 3 Years 1 Month

Experience in MicroStrategy and Data warehousing - 3 Years 1 Month

Employer Details

InfoCepts Technologies Pvt. Ltd.

Nagpur

Joined on 28th June 2010 as Associate

Currently Working as Associate Consultant

Project Profiles

Project1 - NBC Universal - BAYOU Dec 2012 - Present

Project2 - NBC Universal - Upfront

Offshore Team lead and MicroStrategy Architect

NBCU is an American media and entertainment company engaged in the production and

marketing of entertainment, news, and information products and services to a global

customer base.

The project is based on upfront market for ad sales, where we are required to

create 6 RSDs which can provide information of complete upfront market.

Responsibilities

MicroStrategy Architect

Gather business requirements

Analyze and provide best solution for the requirements

Design of schema

Provide suggestions for modification in Data warehouse

RSD Development

Create of Release notes and Package for object migration

Team Lead

Provide project estimates

Create project plan and resource allocation plan

Team Management

Task Management

Co-ordinate with onsite lead

Resolve issue faced by team (technical and non-technical)

Daily task allocation to all resources

Monitoring of deliverables and verification of quality of the product

Verification of test cases and other QA deliverables

Create Report Specification documents

Clarabridge Feb 2011 - Dec 2012

BI Consultant

Clarabridge provides text mining solutions to Fortune 1000 customers based on

various sources. Clarabridge content mining platform (CMP) product process

unstructured data through various transformations and convert to structured data

format for further analysis and review results through BI reports.

The projects use various websites, feedbacks and surveys as their source data,

Oracle as database and MicroStrategy 9.0.1/ MicroStrategy 9.2.1 for reporting.

Clarabridge also has dedicated UI for reporting called as Navigator.

Responsibilities

BI Consultant

Learn business understanding of project

Analyze requirements of clients

Design complete ETL process for new projects and enhance processes created earlier

for better performance

Create Project plan and provide estimate of the tasks

Discuss upcoming challenges and issues with Client

Provide long term solutions and short term fixes for major issues

Identify gaps in the process and create POCs for client to adhere new technology

required in the project

Analyze user requests and fix reported issues

Create checklists, best practices document, Project architecture diagram, ETL

process flow document

Identify gaps in the process and create POCs for client to adhere new technology

required in the project

ETL Developer

Analyze Requirements and source Database for feasibility of data warehouse design

Design ETL scripts (Oracle - PL/SQL)

Design Logical data model and Physical data model and Data warehouse

Addition of Alerting and failure monitoring systems in ETL

Convert simple SQL scripts to run through dynamic procedures and cursors

Modify existing SQL scripts for better performance

MSTR Architect

Gather and Analyze reporting requirements

Discuss possibility of fulfilling the requirements, workarounds and better

approaches with the client

Create new project and design schema

Create Schema object, Configuration objects and Application objects for the project

Create mockups for Dashboards/ Reports

Verify IPR standards being followed in every steps

MSTR Administrator

Create single sign on for end users

Create Security Roles and provide different MSTR access to different set of users

Create Security Filter to restrict data access from user

Create subscriptions for end users and automated alerts using subscription

Upgrade MSTR (9.0.1 to 9.2.1)

MSTR Developer

Create application objects using command manager

Analyze new report requirement

Create report and dashboard

Customize baseline reports

QA

Verify data in modified reports and newly created reports using custom SQL

Verify modified or newly created process by test run of processes

Process Monitoring

Monitor daily process by automated alerts

Fix issues occurred in the process

Content Mining Platform

Create new CMP Data flow for new projects

Create lexicon for projects to be applied

Upgrade CMP

Automation

Integrate different aspects of project process by using Batch script, Perl script

and VB script

Add automatic alerting system in the existing scripts as per requirement

Confirmit (Survey Conducting Website)

Create survey for new projects as per questionnaire

Create automated time based tasks (invite, bulk upload and rule executor)

Modify existing survey as per requirement

MicroStrategy Mobile (Pre Sales and Marketting) Jan 2012 - Present

Developer and Lead

iPhone/ iPad Apps for clients and MicroStrategy World conference

Responsibilities

Analyze requirements and provided database

Perform Extract Transform and Load (If required)

Create Mockup

Create Configuration objects, Schema objects and Application objects

Create App and mentor developer team

Apps created -

Gamozone

Sales Pipeline Analysis

Market Performance Analysis

Sales Performance Analysis

Macroeconomics App

Give presentation/ demo to marketing team

Create demo scripts for marketing team

MicroStrategy Product Evaluation(Training and May 2011 - June 2011

Presentation)

Team Member

Product evaluation is a part of activity to be updated with the latest version of

MicroStrategy. What are the new features which came up in new releases, what are

the enhancements and what are the changes being done are listed and assigned to

individual. The product evaluation team manages everything from searching out new

features, assign to the resources and take feedback about the modification from

resources.

Responsibilities

Find new features in new version

Find resources for evaluation

Collect presentation as evaluation output from the resources

Set up presentation of enhancements for others

Verify new features

Boot Camp Project # 1 - Mobile Media Game Project

This application involves collecting information of Game Title, Publisher and

Category of Subscribers which is used to analyze mobile applications for its

customers. The sale and revenue generated for different subscribers at various

levels is analyzed. The aim of the project is to write custom SQLs in SQL server

2005 for reports so as to validate data.

Exercises:

Analyzed the Data Warehouse Model

Analyzed the source data

Studied the Reports Requirements Specifications Document

Wrote custom SQL for 50 reports

Boot Camp Project # 2 - Adventure Works Data 2010

Warehouse Project

The goal of this project was to load data coming from a transactional source system

comprising SQL Server Database and flat files into the Data Warehouse using SQL

Server 2005 Integration Services.

Exercises:

Created the Requirements Analysis Document

Analyzed the source data

Created source to target mapping

Created SSIS package to load data to the target Data Warehouse for both initial and

incremental loads

Boot Camp Project # 3 - Great Outdoor Sales

Project

The Great Outdoors is a manufacturing company which sells its products through

Organizations across different Regions. The project was meant for creating

Dashboard for Sales Analysis aimed for Executives. The Dashboard was developed

using MicroStrategy 9.0 Flash enabled technology, on this data present on SQL

Server Database with enhanced visualizations and complex panel structure. Different

Widgets were used to enhance the visualization of the Dashboard.

Exercises:

Analyzed the Report Specifications

Created the Logical and Physical Data Model

Architected the MicroStrategy project

Wrote Custom SQLs for all the reports

Created all the reports including required MicroStrategy Application Objects and

required Prompt Objects

Gathered requirements for look and feel and data for the Dashboards

Prepared Mockup and Design documents for the Dashboards

Created Dashboards in the Flash mode using MicroStrategy 9.0

Boot Camp Project # 4 - Advanced Utility Systems

QA Project

The goal of the project was about testing ETL and Report QA process along with the

Bugzila issue tracking system. The project has used automation tools like Bad Boy,

monitoring tools like Http Watch and load testing tools like Load Runner.

Exercises

Analyzed the Report Requirements and the Business Understanding

Created the Test Cases for all the reports and data sets in the dashboard and filed

the Bug List in Bugzila

Analyzed the requirements and schema in order to perform the ETL Testing

Prepared the Test Cases for all the Lookup and Fact Tables

Wrote Custom SQLs in order to test the tables and filed the bugs in Bugzila

Report Testing Automation was also done using Bad Boy automation tool

Used the tool Load Runner to test the load.

Educational Details

Bachelor of Engineering in Electronics and Aggregate - 73%

Telecommunication Year of Passing - 2010

Yeshwant rao Chavan College of Engineering

R.T.M.N.U., Nagpur

Personal Details

Father's Name : Mr. Ram Ayodhya Sah

Mother's Name: Mrs. Nirmala Devi

Date of Birth: 23 December 1987

Blood Group : B+

Permanent Address: QTR 24, Type - L3, Babai Road,

Sakchi, Jamshedpur

Alternate contact Number: +919*********

Contact this candidate