HIMANSHU JEJURIKAR

Providing bug analysis, resolving issues, building and executing SQL scripts for data analysis and generating reports to client. Controlling quality of data. Preparing update scripts for adhoc changes.

Write and optimize in-application SQL statements. Handle common database procedures.

ICICI CHANNEL PAYOUTS

Description:

Process start with raw data received from client side, and according to their requirments

processing is done on that data. Calculation is done basis the business generated, location wise incentives, and other logics for e.g.: Rejects, Hold, Final calculation would have a detailed payment report, TDS calculation Hold, Reject report, SAP accounting entry. All the main functionality is done using Stored Procedure in sql server 2008 R2.

Elite (Electronic lodgment instruction & transaction execution.)

Description:

It is ASP.NET Project mainly divided in 3 parts Operation center, Bank center, Customer center. In Operation center Mandate registration process for multiple mode (NACH, DD & ECS), Batch generation, Dual data entry, Relodge rejected mandate, Mandate scan image insertion, Mandate deactivation and Bill upload after mandate response upload for transaction processing is done. In Bank center Mandate downloading process, send downloaded input file to NPCI, NPCI response file upload in system and Transaction status upload is done. Customer center is given to Merchants for their business logic