Ideation Blog - Exposing few banks APIs (RESTFul) to the Public

I am planning to share my Ideas on the way we are banking today. Also, how the technology can be used to help our Customers on day to day basics. Again, Banks are not there to Server Customer alone. To Make Profit as well J. Next 4-5 blogs will be more specific to how banks can make money using the new technology and trends.

Banks can follow Project-centric approach to Product-Centric approach. What do i mean by this? Banks should not limit to implement the project. Rather banks should proactively think to convert Projects to Product to make more money out of it. Few points are,

ü  As a bank, we can think of exposing our APIs like Telecoms to generate income by following Product centric approach.

ü  Open/Closed API model to increase the traffic.

ü  APIs are a channel to new customers and markets.

ü  APIs promote innovation & revolution is Banking. Like Savings account deal comparator, all banks branch/ATM locator etc..

ü  APIs are a better way to organize IT.

ü  APIs create a path to apps.

Business Benefits:

ü  API’s will generate indirect income to the bank.

ü  A free API is free advertising.

ü  Free APIs encourage 3rd party developer usage.

Eg: Expedia’s 70% revenue comes from API

Above points are explicit. So i am not going to explain in detail. If you are seeking for more specific details on any of the points above, i am happy to clarify you.

Happy learning!

Nanjundan Chinnasamy

WebSphere Application Server Performance Tuning Toolkit

Do you want to analyze the performance bottlenecks for the applications running under Websphere Application Server? IBM - WebSphere Application Server Performance Tuning Toolkit will help us to spot the issues during development time itself. Its an Eclipse based tool used to identify the performance issue at a code block/layer level.

Here, I don’t want to reinvent the wheel again. IBM developer work article explains with basic step by stem details.

WebSphere Application Server Performance Tuning Toolkit – Developer works article: http://www.ibm.com/developerworks/websphere/downloads/performtuning.html

If you see any difficulties in using this tool, kindly post yiour qns to me. I am happy to help you.

Happy Learning,

Nanjundan Chinnasamy

SchemaSpy to visualise the DB schema design

Are you looking for very simple and lightweight tool that generates ER diagram from commonly used DBs. SchemaSpy tool will help you to understand all the relationships in DB schema. This week blog is about SchemaSpy tool.

About SchemaSpy:

SchemaSpy is a Java-based tool (requires Java 5 or higher) that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships as represented by both HTML links and entity-relationship diagrams. It's also designed to help resolve the obtuse errors that a database sometimes gives related to failures due to constraints. It’s free.

SchemaSpy uses JDBC's database metadata extraction services to gather the majority of its information, but has to make vendor-specific SQL queries to gather some information such as the SQL associated with a view and the details of check constraints. The differences between vendors have been isolated to configuration files and are extremely limited. Almost all of the vendor-specific SQL is optional.

Browse some sample pages generated by SchemaSpy. Note that this was run against an extremely limited schema so it doesn't show the full power of the tool.

SchemaSpy is a command line tool. If you are interested to work with GUI based tools. Try Its GUI tools using http://www.joachim-uhl.de/projekte/schemaspygui/

Running SchemaSpy

You run SchemaSpy from the command line:

java -jar schemaSpy.jar -t dbType -db dbName [-s schema] -u user [-p password] -o outputDir

More details to explore SchemaSpy can be found below:

http://schemaspy.sourceforge.net/

Happy Learning,

Nanjundan Chinnasamy

Apache PDFBox - A Java PDF Library

I wanted to share my recent learning on PDF creation using PDFBox Java API. More technical details about this documented below.

The Apache PDFBox library is an open source Java tool for working with PDF documents. This project allows creation of new PDF documents, manipulation of existing documents and the ability to extract content from documents.

Features:

Create PDFs:

 Create a PDF from scratch, with embedded fonts and images.

Signing Digitally:

 Sign PDF files.

Print:

 Print a PDF file using the standard Java printing API.

Preflight:

 Validate PDF files against the PDF/A-1b standard.

Fill Forms:

 Extract data from PDF forms or fill a PDF form.

Split & Merge:

 Split a single PDF into many files or merge multiple PDF files.

Extract Text:

 Extract Unicode text from PDF files. Save as Image Save PDFs as image files, such as PNG or JPEG.

Other alternative frameworks/tools to generate PDF in java:

• iText: nowadays iText is a commercial library, the latest version is not for free anymore.

• FOP: I worked a lot with FOP. It's fairly resource intensive (Java > XML > XSLT > PDF) and complex PDFs become a nightmare ( may result in XSLTs with 20k+ LoC).

• PDFBox: it seems to be the best alternative although I did not work with it in large project.

More details about this can be found from my previous blog at http://nanjundanonlinedictionary.blogspot.co.uk/2012/06/wanted-to-generate-pdf-and-ms-excel.html

FOP is much performance optimized solution to create a PDF. It also comes with few limitations like digital signing, split&merge etc. iText and PDFBox offers almost same features from its library. Please be aware that iText is much performance optimized solution compare to PDFBox as the parsing techniques used.

Happy Learning,

Nanjundan Chinnasamy

Is the Competency differentiates Hard&Smart Workers?

Simple answer is YES as you all know. But here i want to explain with an example.

I have read through this stories long time back. I think this holds good even today. I though i can share with my readers so that so can understand Indian Managers expectations and work accordingly. In general, to win in a competitive would, only knowledge makes the difference to identify the experienced ones.

Story:

A giant ship engine failed. The ship's owners tried one expert after another, but none of them could figure but how to fix the engine. 

Then they brought in an old man who had been fixing ships since he was a young. He carried a large bag of tools with him, and when he arrived, he immediately went to work. He inspected the engine very carefully, top to bottom. 

Two of the ship's owners were there, watching this man, hoping he would know what to do. After looking things over, the old man reached into his bag and pulled out a small hammer. He gently tapped something. Instantly, the engine lurched into life. He carefully put his hammer away. The engine was fixed! 
A week later, the owners received a bill from the old man for ten thousand dollars. 
"What?!" the owners exclaimed. "He hardly did anything!" 
So they wrote the old man a note saying, "Please send us an itemized bill." 

The man sent a bill that read: 

Tapping with a hammer...... $2.00
Knowing where to tap.......... $9,998.00

Effort is important, but knowing where to make an effort makes all the difference!

I have posted few people management related blogs recently as it is much required to understand and work as a team to win people heart. I am planning to concentrate few core technical blogs in coming days as many personally requested me!

Happy reading.

Nanjundan Chinnasamy

Technology driven business - An Example

Can the technology change the way we live today and transform our lifestyle? Yes, most of you might agree with my point as we are connected with the technology. This is once again proved by the new business model “Ola air”. This is something which I have come across this recently. Thought of sharing with you all.

Ola air - Ola chopper taxi service (https://www.olacabs.com/ola-air) brings the new technology and business in India. I am wondering how the digital technology can transform our live style and create the new business opportunity.

Banks have some specific examples like Mobile app, Apple Pay (TouchId) which changed the way the customer banking. If we change our strategy from Customer centric organization to Customer+Technology centric organization, reaching our goal might be much simpler. What do you think?


I am happy to get your experience/feedback/suggestion on Technology driven business to add more in this context. 

Ola air - Ola Chopper taxi service promo Youtube video..

Thanks,
Nanjundan Chinnasamy

Whatsapp marketing - New way of Higher value of Customer engagement

This is a follow-up blog on my previous Whatsapp Blog (http://nanjundanonlinedictionary.blogspot.in/2015/09/use-whatsapp-to-resolve-customer-queries.html). This blog is about higher degree of Customer engagement using Whatapp and how it can be achieved. 


What & Why?

•          Customers want to interact with brands today. They want to have a continuous connection and products & offers specific to them.

•          Current digital world is perfect opportunity to grow our customer base.

Leveraging interactive ads:

•          Video is very good marketing. This occupies more than 50% mobile data (http://www.entrepreneur.com/article/242393). We can reach them personally and get their meaningful feedback.

•          Native ads, Native format, Geo ads, Location based ads, Behavioral marketing.

How to make Whatsapp marketing?

•          Go with Broadcast message option– broadcast message has Limitation (only 250).

•          There are some areas like BBC (http://www.practicalecommerce.com/articles/79714-WhatsApp-to-Change-Social-Media-Marketing) already engaged with Whatsapp and come-up with the alternatives to send message without any limitation.

•          Firstly, we don't have any API to customize.

•          secondly, this can't be used for commercial purpose. Like BBC, your Organization has to agree with Whatsapp Inc. 

Thanks,

Nanjundan Chinnasamy