Welcome to Ravi's personal Site 


Ravi R. SoniView Ravi Soni's profile on LinkedIn
Mobile: +91-8128821228
Phone: +91-265-2783880
E mail: rv.soni@yahoo.com, rv.soni@hotmail.com
BDate: 23rd Dec. 1982

A Lead developer with 9+ year of professional experience in Design, Development, Maintenance and Migration of Java & J2EE web and client/server based applications. Perceives strong analytical and problem solving skills. Ability to handle teams of developer and coordinates smooth delivery of projects.

Professional Profile:

  • Expert in developing application Java EE 6 and Spring Framework based enterprise applications

  • Experience in setting up messaging infrastructure in large scale clustered application.

  • Good technical skills on ORM technologies like JPA and Hibernate.

  • Expertise in Database Design, Creation and Management of Schemas, writing Stored Procedures, Functions, DDL, DML SQL queries

  • Expert in Custom BI/Reporting application.

  • Extensive Ecommerce & Point of Sales system customization and implementation on client side.

  • Extensive experience on Kana CRM Product (Response, response Live, Connect, KMA, IQ) customization, Integration, deployment, Upgrade as a Consultant.


Technical Skill:

Operating System Windows 7/8, Centos 6, Solaris

Language Java, C#

Database Oracle 10g, MS SQL, MySql, PostgreSQL, HBase

Web/Internet Servlet, JSP, JDBC, JMS, XML, HTML, Java Script, CSS, ASP.net, AJAX

Framework Hibernate, Spring (Core, MVC, Test, Mock, ORM, Integration), JQuery, YUI, Oracle ADF, JSP, EJB3, JSF 2.2, REST Web Service, HornetQ, Xalan, XStream, Liferay

Web Server Apache Tomcat, Jboss EAP, IIS, Oracle Weblogic 11g

IDE Eclipse, Oracle JDeveloper 11g, Microsoft Visual Studio

Source Control SVN, CVS, Source Safe, Git

Build Tool Maven, Ant

Project Management Jira, Git, Jenkins


Qualification:

  • M. Sc. I.T (Master of Sci. Information Tech.) July 2003- May 2005

Saurashtra University, Rajkot, Gujarat, India

  • B. C. A. (Bachelor of Computer Application) June 2000-Apr. 2003

Saurashtra University, Rajkot, Gujarat, India

Visa Status:

  • 1 Year UK Visitor Visa (Oct 2007 to Oct 2008)

  • 6 Months UK Visitor Visa (Jan 2007 to July 2007)

  • 6 Months UK Visitor Visa (April 2011, Sept 2011)

Foreign Visit:

  • 1 Month UK Onsite Visit (Jun 2007 to July 2007)

Client: Paul Mason Consulting, UK

  • 1 Month UK Onsite Visit (Feb 2007 to March 2007)

Client: Paul Mason Consulting, UK

EMPLOYER:

InfoDesk India Private Limited (Aug 2011 to Present)
3rd Floor, Sitaram Complex, Chhani Road ,Vadodara - 391740
Gujarat, India, Ph. +91 265 276 1500

Supervisor: Mr. Alexey Dets, Sr. Technology Lead / Software Architect, InfoDesk Inc.


Hitachi Consulting India Pvt Ltd. (July 2010 to July 2011)

3rd floor, Tower VII, Magarpatta City SEZ, Hadapsar, Pune – 411 013
India, [P]: +91 20 65 11 10 00 1/2

Supervisor: Mohammed Abid, Offshore Delivery Lead


QuickStart Global Resource Mgmt. Pvt. Ltd (Fab. 07 to July 2010)

1st Floor Vadodara Hyper, Dr. Vikram Sarabhai Marg, Alkapuri, Vadodara – 390 007. India

Position: Sr. Software Engineer.

Supervisor: Bharat Nayak, Delivery Manager


Real Soft (Intl) Pvt. Ltd (Aug. 06 to Jan 07)

ROYAL STONE, THE TECH PARK, No.100, 1st Floor, Benniganahalli, Pai Layout, Old Madras Road, Bangalore - 560 016, Karnataka, INDIA.Phone: +91-80-6666 8500/1/2/3

Position: Sr. Software Engineer.

Supervisor: Vijay Pawar, Team Lead


ITMiracle India Pvt Ltd. (Apr. 05 to Aug. 06)

Supervisor: Jatin Shah, Project Manager


Compushop, Baroda, INDIA (Jan. 05 to Feb.’05)


Sun Infotech, Rajkot, INDIA (Dec. 02 to Dec.04)

Supervisor: Kirti Dhabalia, Project Manager


Professional Experience:


Project: IMDP V6 (Information Management Delivery Platform)

Job title: Module lead

Team Size: 6

Tech Environment: XADisk, Spring, Spring Integration, Java EE 6 (JMS, JPA, CDI), XSLT, EJB, JMS, PostgreSQL 9.3, Jboss EAP 6, HornetQ, Jboss Developer Studio.


Description: IMDP is a news processing and storage system. It processes various news feeds and transforms them in standard format (News ML G2). Other IMDP processing components enhances news message by adding meta-data and links to standard news message. Enhanced news message is delivered to client in real-time and customer systems directly (B2B). News messages are stored in system for 90 days and are searchable by proprietary search API.


IMDP infrastructure and components have in-built support for “High Availability” and “Fault Tolerance”. All IMDP components are designed to be “Scalable” thus supporting parallel processing, to sustain heavy news processing load.


Number of proprietary libraries is developed as a part of IMDP.


Responsibilities:

  • Lead development of “InfoTransfrom”, “InfoLoader”, “EmbargoManager”, ”InfoMailer”, “IReport” and proprietary InfoDesk libraries.

  • Lead development of news feed input components like “Associate Press”, “Thompson Reuters”, “OVID”, “Patbase “, “Factiva”, “Nelson”, “Nexus” etc.

  • Co-coordinating development with Product manager, QA and Team members

  • Configuration of IMDP components for development and QA environment.

  • Setting up configurations of IMDP cluster infrastructure.

  • Managing automated build systems of IMDP components.

  • Release planning schedules for IMDP components.

  • Production and QA environment tuning.

  • Prepare product releases, release notes and QA deployments.




Project: AHMSI SAF (Service Advance Facility)

Client: AHMSI, USA

Job title: Sr. Java Consultant

Team Size: 6 developers

Tech. Environment: ORACL ADF (Faces RC), Spring, JPA, SiteMinder Security, Oracle BPEL, JUnit, Mock Objects, EclipseLink,Plain Java Classes, Oracle ADF BC, Oracle 10g, Pl/SQL, Oracle WebLogic 11g, Microsoft Visio, UML design, JDeveloper, Maven Build


Description: AHMSI is US based company working in Property Mortgage business. SAF is an application to generate Advances against Loan payment to remit to Investor of the company using Contract between Investor and AHMSI. Currently AHSMI does not have any software Automation to calculate Advance to remit to investor on scheduled bases. Our jog was to design and implement solution to automate this process and provide the Interface to see and modify SAF data and Contract information.


As Part of the project team my job to lead the design and development SAF and its sub modules (Loan, Advance, Recovery, Account, Payment, Funding, Indenture, Rule Editor) design, documents and coding using ORACLE 11g Fusion Application development tool.


Responsibilities:

  • Details Requirement Gathering of Business processes and various Modules of the application.

  • Documenting all business Requirements, preparing Various UML diagram to represent system design.

  • Preparing Application Prototype using proposed technology to show capability of design and implement business requirement on defined development time line.

  • Delegating daily the work among other team members, attending daily Project update meeting, Client Coordination to gather business requirements.

  • Designing UI layer for various module (Loan, funding, Payment, Account, Advance Recovery) using Oracle ADF (Faces RC), Oracle BC, JPA components.

  • Writing JUnit Test cases for Service layer implementation and business layer logic validation.





Project: Adsuite

Client: Solbright, USA

Job title: Sr. Software Engineer

Tech. Environment: JSP, XSLT/XML, JQuery, Spring, Struts, Servlets, TagLibs, Hibernate EJB2.0, Plain Java Classes, Oracle 10g, MySQL, JBOSS, Tomcat


Description: Adsuite, a fully-integrated, subscription-based software service that provides online publishers and websites with inventory forecasting and management, contract management, creative management and trafficking, ad validation, billing reconciliation and recognition, and management reporting.


AdReport Manager is a custom build BI/Reporting for showing Reports for AdSuite Reports. It provides the ability to create custom reports to meet your needs. Chose the fields to be included from any in Adsuite™, and set the reports to be scheduled for delivery by email of FTP. Reports can be formatted as HTML, CSV, XML or Excel files, can be shared with other team members and more. AdReport generates all Report from data being ETL each night from AdSuite Oracle Database to AdReport MySql database using automated data loading process.


Responsibilities:

  • Worked as Lead developer on releasing 9 version. (AdReport 1.3 release to 1.12 release)

  • Implementation of new BI/Reporting functionalities in AdSales Manager/AdReport Manager

  • Implementation of AJAX functionality to increases user experience to WEB 2.0

  • Implementation of Single Sign ON with other AdSuite projects.

  • Migration of AdReport Manager from Oracle to MySQL

  • Maintenance & Enhancement of existing functionalities in AdSales Manager/AdReport Manager.

  • Improved ETL process to load data faster from ORACL to MySQL.

  • Debugging and Unit Testing.




Client: Paul Mason Consulting, UK

Project: Dashboard for Retail-J product

Position: Team Member

Tools/Technology: JFreeChart, JSP, Servlet, JDBC, Javascript, Axis2 WebService, Oracle, MS SQL, MySql, Windows, Linux


DESCRIPTION:

Dashboard is a monitoring tool for a Retail-J TPOS product, Retail-J is a industry leading Retail TPOS system widely used in UK and other part of Europe. Dashboard was a product to monitor Internal Issue of Retail-J installation on live environment. Dashboard is divided into two models, one is Server and other is Agent, Agent deployed across all Retail-J POS system and monitors all its internal process and check about different issue of the product. Server gathers all data from all Dashboard Agent and displays it on a screen. All communication done by server and agent on using Axis2 web service.


Responsibilities:

  • To find the way to monitor All Retail-J TPOS device.

  • To design Dashboard product Arch. to monitor more then 1000 Ratail-J system at a time.

  • Developed Dashboard’s First Prototype version, and design and implemented prototype in final product.

  • Done all development of Dashboard 1.0, 1.4, 1.5 versions.




Client: Real Soft, Inc USA

Project: Report Central

Position: Team Member

Tools/Technology: JBoss 4, JFreeChart, JsaperReport, JSP, Servlet, JDBC, JNDI, JMS, EJB, PL/SQL, Pg/PLSQL, C#.net, Oracle 9i, 10g, PostGreSQL 8.1, Windows, Solaris, Linux


DESCRIPTION:

Report Central provides Real time monitoring and analysis report generation of data collected from different data source like IVRs, Servers, Process running in servers, ASR, TTS, Web servers, Trunks, Routing clients, Routers and Peripheral agents etc. The ETL process which summarizes the monitoring data will be running at a configurable interval. Monitoring data is kept until it is summarized by ETL process, System will provide web based user interface designed using JSP/Servlet


Responsibilities:

  • To Improve Performance of ETL Process, on Report Generation, and Graph Display, Agent Communication.

  • To Migrate Oracle database to PostgreSQL Database with all Pl/SQL Code to PgPl/SQL.

  • To Migrate Complete Product to Support Oracle and PostgreSQL on same Java Code




Client: KANA Software Inc. (USA)

Project: Reports Designing for KANA Response Live using JReport

Position: Team Leader

Tools/Technology: Java, JSP, JDBC, Jreport Designer, JReport Ent Server 7, Tomcat 4.1

Oracle, MSSQL, DB2, Windows 2k, Solaris


DESCRIPTION:

This project was to design Reports for KANA Respone Live product using JReport Designer and customization and integration of Jreport Ent. Server 7 Web interface with Tomcat 4.1 on Windows and Solaris platform with ORACLE, MSSQL and DB2 database. Design custom reports and deployed from command like tool design using JReport APIs. Customized JReport User Authentication with Existing Response live Users database.


Responsibilities:

  • Developed complete project on windows and Solaris platform, Development include Report designing in JReport, Coding in Java/Jsp on tomcat 4.1, View Creation on ORACLE, MSSQL, and DB2.

  • Generated the Analysis/design document for the Report design.

  • Unit Testing of Reports and Customized JReport Interface, before submitting to QA.

  • Helped in deploying it on client site by remote control.




Client: Bright-House Networks (USA)

Project: KANA IQ 7.0 Templates Project

Position: Developer

Programming Language: Java 2, JSP, XML/XSL, and JavaScript, Windows 2000


Description:

The Bright-House Network wanted to have their own knowledge base with the help of which they can solve the queries of their clients. With the use of Kana IQ 7.0, the knowledge base for the end users was developed and to display the knowledge base to the end user IQ Templates were being designed. The IQ Templates designed earlier had flaws, which created errors while working with the templates, thus disturbing the normal functioning of the knowledgebase. IQ Template project is to find out the flaws and to remove the errors so that it provides smooth running of the Knowledgebase. Also it is to upgrade the IQ Templates to newer version with the help of XML/XSL and Servlets.


Responsibilities:

  • Understanding the requirements from the client.

  • Finding the flaws in the older templates and providing the solution for the flaw.

  • Understanding the whole template and generating the XML for the template.

  • Using the generated XML rendering the HTML with the Help of XSL Template.

  • Maintaining the flow of the template with the help of JSP.




Client: Bea Systems (USA)

Project: KANA KMA-KFA Upgrade/ Integration

Position: Team Leader

Tools/Technology: Java, XML/XSL, JDBC, Stored Procedure, Triggers and other J2EE technologies, Oracle 9i, MS SQL server, KANA KMA, KANA Foundation server, Windows 2k, Solaris 9.


DESCRIPTION:

The client was using Kana Marketing Automation, KANA Foundation server integration Marketing and Lead generation and processing Since a long time, and they had a complaint in terms of the performance of the product when they were not able to run campaign using KANA Marketing Automation sever. They found the product running to slow, lots of Server crashes, database perforation issue, and other maintenance related issue. Also company wanted to upgrade KMA-KFA setup with latest software. We were supposed to provide solution in terms of increasing the speed of the KMA server for sending outbound mail by running campaign and analysis lead data using KFA on real time for reporting and integrating with other products and reporting tools.


Responsibilities:

  • Done all project related Documentation,

  • Upgraded KMA-KFA software on Solaris/Windows platform.

  • Develop tools for KMA-KFA Database cleaning.

  • Provided Functional/ Technical Training to Bea Employee for KANA KMA-KFA software




Client: Williams-Sonoma (USA)

Project: “KANA Connect” – “StrongMail MTA” Integration

Position: Developer

Tools/Technology: Java, XML/XSL, JDBC, Stored Procedure, Triggers and other J2EE technologies, Oracle 9i, RHES 3 Linux


DESCRIPTION:

The client was using Kana CONNECT since a long time, and they had a complaint in terms of the performance of the product when they tried to send campaigns to 2.5 million customers. They found the product to be slow. Here we were supposed to provide solution in terms of increasing the speed of the Mail Sender. The Mail Sender is a scalable service that receives and compiles the customer list with the message content on the content web server. The solution, which the client approved, was to discard the mail sender of Kana CONNECT and plug the mail sender component of StrongMail.


Responsibilities:

  • Developed the module (LRC) for the reporting section.

  • Generated the Analysis document for the report.

  • Unit Testing the LRC module, before submitting to QA.

  • Helped in deploying it on client site by remote control.




Client : UPromis (USA)

Project: Email Reviewer for Kana Response

Position: Developer

Tools/Technology: ASP 3, J2ee, Kana Response, IIS5, MS SQL server 2000, Windows 2000


Description:

This project was to put a CSRs (Response user) mail in to Audit review process by diverting mail into Audit queue based on percentage decided for each user. CSR id and percentage of review of mail will be stored in text file using UI designed in ASP 3.


Responsibilities:

  • To create UI in ASP 3 for add/edit CSRs in review process and create a rule for putting CSRs mail in review process in J2EE.

  • To do testing of given solution, and finding bugs, in solution for making it perfect.




Project: Link Point 3.5 Payment Gateway implementation

Client: www.saveoninks.com

Position: Developer

Tools/Technology: TomCat 4, J2ee (Jsp, Servlet, JSSA), castor utils, MQSQL 4.1, RHES 3


Description:

This project was to upgrade existing LinkPoint Payment Geteway API, in existing website. In this project I have remove existing problem in LinkPoint API and enabled it to work with SSL certificate over HTTP protocol to communicate LinlPoint Payment Gateway.


Responsibilities:

  • To identify Problem in existing LinkPoint API implementation with URA Framework.

  • To find solution for sending SSL certificate over HTTPS protocol using Jave Code.




Project: Kana Response Content information Migration tools.

Position: Developer

Tools/Technology: JSP, Servlet, Jdbc, Tomcat 4, MySQL, Ant, MSQSL 4.1, Windows 2000


Description:

This project is to provide the facility to take backup, restore and upgradation for Kana Response content Information, using the archive Database (MySql) with powerful web based front end design in Jsp, Servlet, and HTML. This tool provides flexibility on selection diff, entity for taking back up, and restore. That is not available in existing Migration tool. This tool is able to talk with any of MSSQL, ORACLE, and DB2.


Responsibilities:

  • Done common component design and development, requirement gathering, & Analysis of complete project, project document creation.

  • Working on the project as a main Programmer.

  • Done application database design and coding stratagem, and implementation strategy.




Project: Kana Response Mail archive.

Position: Developer

Tools/Technology: Tomcat 4, JSP, Servlet, Jdbc, MQSQL 4.1, Windows 2000


Description:

This project is to provide the facility to take archive old mail from the response database for improve performance of the Kana response system, in Response database is the repository of the all in inbound and outbound, and this tool identify all completed mail in response system and remove it from database and save in to file or backup database (mysql) as per selection.


Responsibilities:

  • Done common component design and development, requirement gathering, & Analysis of complete project, project document creation.

  • Working on the project as a main Programmer.

  • Done application database design.




Project: Generalized Payroll Management Software

Position: Software Programmer/Team Leader.

Tools/Technology used: VB6, Crystal Report 8.5, Wise Install Master 8.1, Access 2000, Windows 98/XP


Description:

This project was to provide complete payroll calculation in companies, according to there rules & regulation, many type of pay structure, Bonus, Over Time calculation, Tax calculation according to Govt. Rules, support many organization in single copy of software with their diff. pay structure.


Responsibilities:

  • Done common component design and development, requirement gathering, & Analysis of complete project

  • Working on the project as a main Programmer.

  • Done application database design.




Project: Generalize Website for School

Position: Team Leader/Developer

Product Name: “Principal”

Tools/Technology used: Core Java, Servlet, JSP, JDBC, Jrun 3, Access 2000, Windows 98.


Description:

This project is a part of complete School/Colleges Management solution; it’s divided into 6 sub modules (Payroll, Account, General Register management, Library, Paper setter, Online Exam) this software is more like a base framework for making the Website for the school, this project development using JSP/ Servlet with jdbc. The project divided into two part, one is Examination UI, and other is Admin UI, using Admin UI Moderator can set Subject of exam, Exam Duration etc..


Responsibilities:

  • Done common component design and development, requirement gathering, & Analysis of complete project

  • Working on the project as a Team Leader.

  • Done application database design, report design, decided Project Implementation Strategy.

  • Done application development using Core Java, Servlet, JSP, Jdbc, Access 2000.





Project: Online Examination

Position: Team Leader/Developer

Product Name: “Principal”

Tools/Technology used: Core Java, Servlet, JSP, JDBC, Jrun 3, Access 2000, Windows 98.


Description:

This project is a part of complete School/Colleges Management solution; it’s divided into 6 sub modules (Payroll, Account, General Register management, Library, Paper setter, Online Exam) this software provide facility to take Online exam in school/ collages, this project development using JSP/Servlet with jdbc. The project divided into two part, one is Examination UI, and other is Admin UI, using Admin UI Moderator can set Subject of exam, Exam Duration etc.


Responsibilities:

  • Done common component design and development, requirement gathering, & Analysis of complete project

  • Working on the project as a Team Leader.

  • Done application database design, report design, decided Project Implementation Strategy.

  • Done application development using Core Java, Servlet, JSP, Jdbc, Access 2000.




Project: Generalized School / College Management Software.

Position: Team Leader/Developer

Product Name: “Principal”

Tools/Technology used: VB6, Crystal Report 8, Access 2000, Wise Install Master 8.1, Robo Help, Access 2000, Windows 98.


Description:

This project was to provide complete School/Colleges Management solution; it’s divided into 5 sub modules (Payroll, Account, General Register management, Library, Paper setter) this software fulfill all requirement of School/Colleges as per Rules of Gujarat Govt. Education Department. Also produce more than 250 dynamic Report used in school/colleges for to submitting it to Education Department. It was to provide 100 % computerization in school/colleges for all daily Activities, report generation and submitting to Govt., doing analysis of student’s progress in study, etc.


Responsibilities:

  • Done common component design and development, requirement gathering, & Analysis of complete project

  • Working on the project as a Team Leader.

  • Done application database design, report design, decided Project Implementation Strategy.

  • Done application development using VB6, Crystal Report 8, and Access 2000.

  • Implemented concept of Data Warehousing in Database Design.