Transcript Projene Inc.

“Nothing is more terrible than activity without insight” - Thomas Carlyle
A Profile
Solution focused Smart tools for SMB (Small Medium Business)
Let’s talk about
“When I get ready to talk to people, I spend two thirds of the time thinking what
they want to hear and one third thinking about what I want to say” ― Abraham
Lincoln
Challenges of SMB
Why we are here
Values we deliver
Tools and techniques
Our work
Samples
Challenges of SMB
“Nothing is particularly hard, as long as you divide it into
small jobs “ - Henry Ford
Countless things demanding attention making it hard to do anything well
Most of the data are fragmented and unorganized
Recognizes “managing and getting better insights out of the data they
already have” as their “top technology challenge.”
Most analytics packages are configured by default to provide mostly
reports on vanity metrics rather than actionable metrics
Availability of affordable, customizable, quick to implement, lean BI and
Analytics tools
What does that mean?
In spite of the difficulties, SMBs are realizing that effective BI and analytics can help
them understand customer preferences, expand their market share, cut down cost,
increase operational efficiency manifold and give them a competitive advantage
even against the big players
Why we are here
“If you don’t have a competitive advantage, don’t
compete” - Jack Welchcan
takes up any business problem as a project and engineers the
right software solution specific to the requirement
A highly qualified team of engineers with complimentary background in
the disciplines of Civil, Mechanical, Management and Data Science
An unique experience of developing software tools in diverse industry
verticals e.g. Retail, Manufacturing, Telecom, Construction from small to
big spanning over 3 decades
Choice of most appropriate tooling for solution
An always on learning competency in technology
What does that mean?
In other words, we recognize the need for bespoke solutions for the SMB
sector and offer our experience and expertise to develop low footprint, quick
and smart solutions using simple tools and modern techniques to deliver result
Values we deliver
“Success has a simple formula: do your best, and
people may like it” - Sam Ewing
Consolidate fragmented information
Extract key figures and summary
Integrate business operations
Provide active business controls
MIS & Dashboard reports
Insights through analytics
Customize as required
Lean solution
Data transparency
Fast turn around
Make your business easy
We
We
are
Keep raising
trustworthy
the bar
We
We
consistently
succeed
deliver
together
Tools & Techniques
“Excel is a beautiful thing—it’s immediate, scales from
simplicity that almost anyone can use to analytics lite that
many business units push to the limits.” - Steve Cormier
MIS & BI
Microsoft Excel
Microsoft Access
User forms
VBA Macros
Integration with 3rd party libraries
Cell level security
Analytics
R & Weka platform
R for Excel
Segmentation & Clustering
Predictive modeling
Integration with 3rd party
packages
Our Work
“It is through accomplishment that man makes his contribution
and contribution is life's greatest reward”
– John Portman
<< Click on the pictures below to see details >>
Dealer
Analytics
Manufacturing
Defect Prediction
Poll Survey Analysis
Recharge
Analytics
Voice of
Customer
Analysis
Telecom
Dashboard
Interior Designers
MIS
Garment
Distributors MIS
Questions from you
“My greatest strength as a consultant is to be ignorant and ask
a few questions” - Peter Drucker
• Now ?
• Later ?
Anindita Maitra
M: 98364 96690
61/25 Moore Avenue
Kolkata – 700 040
www.projene.com
Anindita Maitra
Kajal Das
Debabrata Dutta
Sajal Kumar Das
B.E (Civil), M.B.A, A.M.I.E, Chartered Engineer
B.M.E, PMP
B.Tech (Mechanical)
B.E (Civil), A.M.I.E
Thanks for being with us
“I can no other answer make, but, thanks, and thanks” - William Shakespeare
There are no traffic jams along the extra mile
that we walk…
Dealer Analytics
Customer – Telecom Operator
Dealer sales and trend Analysis
 Find out TopX & BottomX dealers based on net
sales and derive trends
Subscriber spent Analysis
 Analyze subscriber spending pattern based on
recharge amount and derive trends
Top & BottomX Analysis
 Channel performance
 Subscriber values
Summary Dashboard





Monthly sales for all channels
Comparison with last month
Distribution by geography
Average channel performance
Sales vs subscriber summary view for all channels
Business Outcome




Measure dealer performance
Ready sales statistics
Identification of risky dealers
Insight into subscriber behavior
Voice of Customer Analysis
Customer – BPO Call Centre
Repeat Call Analysis
 Find out repeat callers and their call resolution
details
Total Call Analysis
 Analyze call distribution among types-sub typeswrap ups
Top & BottomX Analysis
 Identify performance of operation by the ability
to handle calls against various attributes (e.g. skill,
wrap up etc.)
Detailed Analysis
 Detailed call distribution and analysis across
types-sub types-wrap ups-agent-skill set drilled
down
Business Outcome
 Identification and quantification of customers
who are logging calls repeatedly
 Identification at a granular level of wrap ups that
are involved for the calls from the customer
 Helps deciding on the resolution path for
customer satisfaction
Recharge Analytics
Customer – Large Telecom
Operator
Recharge Analytics
 Design targeted marketing campaigns by
recharge-consumption based segmentation for
Prepaid customers
Methodology
Grouping of subscribers into various segments based
on their behavioral values using K-mean cluster
analysis
 recharge values, call values, SMS
expenditure, Internet expenditure
Business Outcome
 “if you recharge more than Rs.50/- get 10%
immediate bonus and 20% discount on calls to a
relevant destination.”
 Top-up Rs.100/-and get one ringtone for free
 Can target sleeping subscribers , for example:
“recharge more than Rs.200/- and get 10% bonus
on all recharges during the next month.”
Telecom Dashboard
Customer – Telecom Operator
Traffic Analysis
 Data source wise (IN,MSC,SMSC) usage
details
Revenue Analysis
 Revenue source wise
(Prepaid,Postpaid,IN,Tap) revenue details
Reconciliation
 Traffic comparison between any 2 sources
Roaming
 Partner analysis by revenue
Recharge Analysis
 Voucher performance
 Service performance
 Daily growth metric
Dashboard
 Key KPIs and Metrics
Business Outcome
 Complete functional coverage
 Ready visibility
 Ease of further customization
Poll Survey Analysis
Customer – Major political
party
Caste Analysis
 Caste distribution of population across
geography
Issue Analysis
 Analysis of development needs
Candidate Analysis
 Analysis of relative strength of aspirants
Position Analysis
 Analysis of position holders(BDO, Advocate
etc.) and their performances
Business Outcome
 360 degree view of electorate and
candidates
 Identification of development needs
 Aids in formulating poll strategy
Manufacturing Defect Prediction
Customer – Major Automobile
Manufacturer
Defect Analysis
 Identification of casting defects based on
combination of process parameters
Prediction of defects in casting production
 Build prediction models using training data
 Compare models and identify most suited
model
 Identification of defective components
based on predictive models
Business Outcome
 Reduction in inspection costs
 Quality improvement
 Identification of sensitive process
parameters
 Improved control on production process
Garment Distributors MIS
Customer – Distributor
of branded garments












Customer & Supplier Register
Product Catalogue
Order Management
Stock Management
Billing & Invoicing
Payment & Receipts
Integrated Accounting
Returns Management
Ad hoc Query & Reports
Dashboard
Power Features
Security Features
Business Outcome
 Cash flow control &
management
 Sales channel evaluation
 Optimum stock maintenance
 Improved operational efficiency
Interior Designers MIS
Customer – Interior
Designer of Major
Banks
 Estimates
 Powerful BOM item creation
from raw materials
 Estimate vs Actual variance
analysis
 Transaction accounting
 Project Profitability Analysis
 Integrated Accounting
 Ad hoc Query & Reports
 Dashboard
Business Outcome
 Cash flow control &
management
 Vendor evaluation
 Just In time business control
 Improved operational efficiency