Avipsa Roy

Added geospatial extension to a new Python package called IbmdbPy to build wrappers in Python for spatial functions in DB2 using SQL pushdowns and created a demo use case with large dataset using New Zork city felonies datasets for spatio-temporal analysis and visualising interesting spatial patterns in the data.

Used R, dashDB on IBM Bluemix framework and DB2 to develop a use case for sentiment analysis of big twitter data for descriptive and predictive analytics. Used additional data provided by government census data for market research and integrating it with geospatial data from open source shapefiles.

Thorough understanding of the Data Architecture and flow between source and target systems involving Siebel, Oracle cloud platform and Flexcube for handling large amounts of financial transaction data. Performed data integrity checks and data reconciliation of Big Data.