TeCh Compiler

1
TeCh Compiler

• Committed to Deliver

2
INTRODUCTION

• TechCompiler Data Systems is a global IT
  consultancy. We deliver a range of IT outsourcing
  services including product development, custom
  software development, testing, support and QA.
  Our strong commitment to delivery help companies
  bring great products to market on-time on-budget
  and with confidence.

3
Expertise
Programming Java/J2EE,Asp.net,C,Python,C,Mana
ged C Mobile Applications Android,
IPhone,IPad, Blackberry Platforms Hadoop,Apche
Solr,Lucene,Nutch Tools Spring, Spring
Roo,Struts,Hibernate,Django,Ajax,JQuery Database
Oracle,MySql,Ms Sql, PostgreSQL ERP/CRM JAllinOne
/Apache ofbiz
4
OUR CLIENTS
Web based CMS for managing stories and news
A product of Firefly e-Ventures Ltd., a 100
subsidiary of HT Media www.shine.com
UK based startup in personal finance management
domain B2B Version of Kublax
Web based shopping solution for Japanese market
www.shopin.tv
connects education seeker with education
provider www.htcampus.com
Interactive Job Portal for US Market www.brainbond
.com
Europes first web based personal finance account
aggregation and budgeting service
Protect Online your Identity
content aggregation distribution system
www.contify.com
Web-based system for saving and borrowing Money
online for UK/Europe market
Airline Travel portal for Indian market
5
WHAT WE DO
6
MANAGEMENT TEAM

• Paul Mayo-Chairman
• Paul Mayo has 17 years experience is Sales, Sales
  Management and Sales Operations. In his
  experience he has managed teams at PTC,
  SoundBite Communications, Empirix and most
  recently CEO at ClickJoy. He has helped companies
  significantly boost new business revenue and
  drive bottom line growth..
• Nishant Srivastava-CEO
• 11 years of Expertise in Software development,
• architecture and leadership. Specializing in
  connecting marketing and business vision to
  products and technologies through innovation,
  process oriented execution and cross-functional
  interfacing.
• An entrepreneur helping companies find their
  route to success through vision, innovation and
  execution.
• Experienced player in IT security/web
  development/Enterprise Applications
• Prior experience with TriCipher, US and NTT Data,
  Japan
• B. Tech. from IIT Delhi (1996-2000)

7
CORE TEAM

• Mazhar Haque - Executive Business Head
• 11 years Account Management experience, Expertise
  negotiating services contract terms, scope, and
  pricing for custom consulting/Development
  engagements.
• Experience recruiting, hiring, and training
  staff. Extensive background teaming with Sales
  Account Managers to develop and drive the
  complete solution sale while ensuring profitable
  services business is scoped and efficiently
  managed for external customers.
• Prior experience with Fidelity, Open
  Solutions(Carlyle Group).
• Rahul Kumar Saxena - VP Engineering
• 11 years Technology and Management experience
• Enterprise Applications in Banking Domain
• Prior experience with Wipro Technologies, Lehman
  Bros.
• B. Tech. from IIT Delhi (1996-2000)
• Somil Asthana -CTO
• 12 years Technology experience
• Experience in Handling large and complex
  Enterprise Applications
• Prior experience with Nokia, Motorola, Qualcomm .
• B. Tech. from ITBHU (1995-1999)
• MS from Univ at Buffalo NY

8
TeCh Compiler

• Yepme Shopping Project

7/9/2013
9
(No Transcript)
10
(No Transcript)
11
Yepme Content Display

• We used a clear approach to display the content
  using tabs and images.
• We developed this unique idea, where images can
  suggest 1000 words.
• By this unique presentation user can see and
  choose the right item.

12
(No Transcript)
13
Shopping Cart

• Yepme never had an ability to purchase more than
  one item at a time.
• We introduced shopping cart so that user can
  purchase more than one item in single order.
• We also modified the backend so that things can
  be shipped together.

14
(No Transcript)
15
Dressing Room Concept

• Introduced an unique concept of Dressing Room,
  where the user can dress Model with shirt and
  trouser combination.
• The users can visualize the combination before
  doing final purchases.

16
(No Transcript)
17
TeCh Compiler

• AirtelSelf Care Project

7/9/2013
18

• CRM
• Services
• SR File Upload
• Reporting
• SR Status Mismatch
• OM
• FX CRM OM
• SIM Uploading
• MIU Rejection
• Special Character removal
• Out of Sync of success notification
• Duplication of Data in Barring and Suspension
• MNP
• UD

• SR-Automation(Metasolv)
• CRM-UGIS-Metasolv-WFM(Telemedia)
• CRM-Metasolv (AES)
• CRM-FX-M6-CPE(DTH)

19

Selfcare 121 Request/Response flow
mo.no./mybill
Result
Result
Result
Result
7/9/2013
20
Selfcare 121 Request/Response Problem
(2)
(1)
Message not delivered to broker
(4) Response to message broker
Fails
(5) Message broker unable to deliver
Response to SMSC
(3) API/DB/WebServ.Call Fails
(6) SMSC unable to deliver Response
7/9/2013
21
Solution - Workflow
Log to check the API response
Log to check the API response
API/ DB/ WEB Ser. Call
7/9/2013
22
Selfcare Problems

• EBill Password
• Selfcare executive currently raises a SR for
  sending password to the end customer through SMS.
• EBill Generation
• Selfcare executive currently raises a SR for
  sending Ebill to the customer through email for a
  specified month.
• Undelivered SMS
• Customer does not receive SMS due to any issue
  related to SMSC, Network, Application or any
  other for the customer requested information
  through SMS to 121 (UNB, OT, Web password and
  Ebill password).

7/9/2013
23
SelfcareSolution GUI

• Error Reporting
• System Node status (up/down)
• Errors for failed messages
• Message status from each node
• Detailed error from failed node
• Search failed request
• Resend failed request

7/9/2013
24
Selfcare Payment Failure
Payment Gateway
7/9/2013
25
Selfcare Solution

• All requests and responses from node to node will
  be tracked.
• Status of nodes (up/down) will be tracked.
• Flexibility of Report generation and export.
• Success/Fail reports.
• Facility to re-send the fail request from web
  interface.
• Payment request failure status/report.
• Interface will be provided for Airtel Customer
  care to resolve the issues at their end itself.

7/9/2013
26
Selfcare Solution - GUI
Payment Gateway
7/9/2013
27
Mediation

• Configuration - Lookup Tables
• Build a UI Interface which can take CSV files as
  input(either via web interface or through a
  scheduler which can be scheduled using web
  interface to pick CSV from ftp/http location, All
  Read and write parameter will be set via web
  interface)
• Data extraction
• Provide web interface to generate report. Table
  setting/Output format and report column will be
  configured using web interface.

7/9/2013
28
MediationProposed Solution

• Web Interface to upload files manually/automatical
  ly
• Report will be searched/export from web interface

7/9/2013
29
Solution GUI

• Error Reporting
• System Node status (up/down)
• Errors for failed messages
• Message status from each node
• Detailed error from failed node
• Search failed request
• Resend failed request

7/9/2013
30
CRMFile Upload Flow
Add to Intermediate Table
Validate
Update Main Table
7/9/2013
31
CRMFile Upload Failure
Add to Intermediate Table
Update Main Table
Validate
7/9/2013
32
CRMServices-Problems

• SR File Upload
• File uploads failure due to validation or system
  failure
• Reporting
• Pre-defined and SQL report
• SR Status mismatch
• Status mismatch of open and closed requests

7/9/2013
33
CRM - ServicesSolution GUI

• Data File Upload
• Error Reporting
• System Node status (up/down)
• Validation Failed data
• Update Failed data

7/9/2013
34
CRMReporting

• Pre-defined Reports
• Pre-defined reports execution
• Customized columns in report
• Filter defined for reports
• SQL Reports
• Select sql execution
• Export reports in Excel format

7/9/2013
35
CRMSR Status Update

• SR Status Report
• Search SR
• Status Update Link against each open SR
• Execution failure report

7/9/2013
36
CRM OMProblems

• SIM Uploading
• Manual upload of data using putty currently
• Order Cancellation
• Sim number removes from CRM but not FX
• MIU Rejection
• Data mismatch in FX tables due to CDR rejection.
• Special character removal
• Special characters not filled in CRM by operation
  team
• Out of sync of success notification
• Status notification update miss leads to manually
  update table to set status flag
• Duplication of Data in Barring suspension
• Data is duplicated at eutil21a_request on
  barring/suspension request

7/9/2013
37
OMProposed solution

• Proposed solution should provide the web
  interface to upload Sim data based on Circle,
  Inventory ID, Location ID, Network Device ID
• Following table need to update-gtinvad_ma,invad_vie
  ws,invad_hub
• And invd_security ( exact spelling of tables
  might be different).
• FX needs to be updated before invad_security
  table is updated.

7/9/2013
38
TeCh Compiler

• DataCom/VideoCon BI Project

7/9/2013
39
BI for Customer Call information DataCom

• We generate cubes based on Customer Database.
• Streaming Solution for BI (IN Raw feeds used for
  the report)
• Account Subscriber Dump (.acs)
• Call History Dump (.cha)
• Diameter History Dump (.dmh)
• Mtr History Dump (.mtr)
• Recharge History (.rha)
• Offer Values (.ofv)

40
BI and Report Generation

• Customer Call Usage Reports
• OPENING_BALANCE
• CLOSING_BALANCE
• INITIAL_TALK_TIME
• CREDIT_AMOUNT
• DEBIT_AMOUNT
• E_RECHARGE
• PAPER_RECHARGE
• VOICE_DECREMENT
• GPRS_DECREMENT
• MMS_DECREMENT
• SMS_DECREMENT

41
Standard ussd architecture
42

• This application enables and provide common
  interface for integration of IMS network for RCS
  1.0 complaint mobile or pc client with various
  Internet social network communities e.g.
  Gtalk,Facebook etc.
• Functionality List
• RCS(Rich communication suite)
• a)Add Face book contacts to RCS address book.
• b)Download Avatar from face book to RCS user
  using XMPP protocol.
• c)Upload image/video from RCS users using Face
  book native API and MSRP protocol.
• d)Propagate status-text update from RCS to Face
  book and vice versa using Face book native API.
• e)Propagate presence status from RCS to Face book
  and vice versa using XMPP protocol.
• f)Session mode chat between RCS user and Face
  book user initiated either from RCS user or Face
  book user using MSRP and XMPP protocol.
• h)RCS client de registration

NSN CSNA(Community and Social network aggregator)
43

• Developed for Tricipher Inc
• Deployed
• Citi National Bank LA,USA
• Abu Dabi Investment Authority,UAE
• SEC Inc,,Philidelphia,USA
• Sumitomo Bank,Tokyo,Japan
• Metavante, Milwake,USA
• Sungaurd,Boston,USA
• Mellon Bank,Pitssburg,USA
• First Marble Head,Boston,USA

Browser 2 Factor Integration
44
Split-Key Technology

• The TACS Appliance uses a patented 3-key RSA
  algorithm to split the users RSA private key
  into two parts.
• First part
• Stored on the Appliance
• Never leaves Appliance
• Second part
• Derived from password (chosen by the user), and
  one or more additional factors which are stored
  on
• Protected areas of the hard disk
• On removable media (encrypted0
• On smart cards
• Re-Created for each session
• Not stored on the users machine between
  sessions.
• The Appliance keeps no record of the users part
  the users machine never sees the part kept on
  the Appliance.
• .

45
Cookie as 2nd Factor Authentication
mYpaword
TACS API
2) Retrieve users marker(s) for presentation to
user
5) User authenticated (option cookie anti-tamper
content updated)
46
Browser Cert as 2nd Factor Clientless

• B2F API issues a device certificate to browser
• Supports all major browsers
• No client download / install
• Very difficult to copy or move the device
  certificate
• Allows C-SSL to be enabled, preventing MITM
  attacks
• From API point of view, everything is the same as
  cookie device identifier
• Depending on browser security settings, warnings
  may be shown when installing the certificate

47
(No Transcript)
48
Customer Bright

• Making sense of your money
• All your accounts in one place
• Connects to more than 3500 financial institutions
  using Ewise /Yodlee
• Automatically categorizes transactions in your
  bank accounts
• Easy Alert and Budgeting tools
• Safe and Secure

49
(No Transcript)
50
(No Transcript)
51
Kubera Money

• A web-based system for saving and borrowing money
  online.
• Electronic k-funds - a savings scheme, in which a
  number of people make a contribution to the fund,
  on a regular basis at fixed intervals (usually,
  one month) for the lifespan of the fund. The
  lifespan is normally equal to the number of
  participants. Every month one person who has not
  received the money before takes the whole fund
  less a discount, which is determined by an
  auction. This discount is split among all
  participants equally. Similar to Chit Funds in
  India.
• Integration with Money Booker for online money
  transfer and Pay-on-demand and recurring
  payments.
• Integration with Equifax Call Credit to acquire
  credit profile.
• Validate report (Identity Check, AML check and
  payment validation).

52
HT Media Limited
53
HT Syndication

• Ht Syndication is in Content Aggregation
  business.
• Various content from various publications, online
  magazine and Govt. Sources are collected
• After value addition sent to various data port
  like Factiva ,Lexis Nexus.
• Online Content aggregation platform
• Input
• Manual
• Third part Feed Xml/Text
• Auto scrapping of Web pages
• Value Addition
• Categorization of Stories using Open Calais web
  service and Hadoop
• Auto enhancement of Stories according to
  Destination Data port
• Out Put
• Out Xml/PDF/Text to Data port(Factiva/Lexis nexus
  etc)

54
News Cluster/Categorization
C-Bayes Classification
Categorize Documents
V1, Vk
XML files/ Documents
Apply CoSine Similarity Between Vectors
News Files
Cluster Algorithm
V1
V2
News Files
Vi, Vj
News Files
VN
Create List of closely related stories
Transformed into Integer Vector. One XML news
file maps to One Vector.
Get the Minimum Distance Pair of Vector
List of XML News Files
MAP Functionality
REDUCE Functionality
HADOOP PLATFORM
55
ITV Inc.
56
Shopin TV

• Business model of ITV is standard Shopping
  portal. However ITV came up with unique idea of
  Television shopping via Internet.
• End user will view a streamed video(Advertisement
  for various product). User shops interactively by
  Clicking on Running video. for ex. A model
  walking with a Goggle, User can click on Goggle
  and will be redirected to Goggle detail page.
• Built a desktop Tool to mark the video. i.e Load
  the video and mark the product (i.e x,y,z
  coordinates x,y being 2 position coordinated z
  being time coordinate ).
• Marked data is saved as per Mpeg7 specification.
• Video and Corresponding Mpeg7 file is uploaded to
  server.
• While streaming video Marked points are read from
  Mpeg7 data and highlighted in running video an
  click action redirect it to corresponding data.

57
(No Transcript)
58
(No Transcript)
59
Search will be done from the Colors embedded in
the Video (mpeg7)
60
(No Transcript)
61
Shine Search

• Semantic search
• Zip download
• Exhaustive clusters of parameters for filtering
• Real time sorting and filtering of results.
• Apache Solr for indexing and search.

62
Brainbond.com is an employment marketplace, a
job portal
Offers a live, interactive environment where
employers and talented professionals seeking
employment can connect
Unlike other employment web sites, though,
brainbond.com is not just a database of job
postings and resumes
For Jobseekers brainbond.com helps to quickly
pinpoint job opportunities, as well as obtain
real-time feedback on the status of a job
application or bid
For Employers brainbond.com helps to quickly
identify qualified candidates for open positions
through an automated tool that matches potential
candidates with job requirements within seconds
63
While the brainbond.com provides the basic
services for jobseekers to search jobs and
employers search jobseeker, it also provides
additional distinctive services where other
portals do not provide. These services include
-Invite jobseeker for bid
-Schedule interviews
-Hire or reject bids or interviews
The most powerful and proprietary feature of the
brainbond is its Rules Engine
Rules engine provides the all core
functionalities of the portal, explicit searches
like jobseeker search, employer search, implicit
searches like Hot Jobs and Hot List and
event based rules like bid qualification checks.
On the other side the jobseeker place the bid for
the job, accept or reject the job interviews.
This will let the jobseeker and employer to
improve the interaction between them unlike
other portals that provide just search
functionality.
64
Interaction
SYSTEM
Submit a Bid
Rules Engine checks, if the bid is qualified as
per the job requirements
Jobseeker receive Interview request
Jobseeker Receive Offer
Jobseeker Accepts Offer
Jobseeker Rejects Offer
Employer rejects the candidate
65
Other Core skills/technologies -

• ERP (Enterprise Resource Planning)
• SAP (ABAP, FICO, SD, MM, PP, OM etc. )
• Oracle (BOM, WIP, INV, WMS, Quality, AP, AR, GL,
  FA, CM etc. )
• Siebel (EAI, EIM, Config, Reports, AD)
• Business Intelligence (BI)
• SCM (Supply chain management)

66
Contact Us

• Office Location
• USA
• 400 Trade Center, Woburn MA 01801
• India
• A-82, Sector 57,
• Noida, UP, 201301
• Japan
• 2-9-17-403,Higashi Tabata
• Kita-ku,Tokyo,Japan
• General Inquiries
• info_at_techcompiler.com
• Sales Inquiries
• sales_at_techcompiler.com