Alok Kumar

Project : Network International

Environment and Tools : Oracle , WAY 4

Responsibilities:

• Worked closely with other business analysts, development teams and infrastructure specialists to deliver high availability solutions for mission-critical applications.
• Created procedures for system monitoring, recovery, backup and optimization.
• Led software development initiative as subject matter expert and primary point-of-contact for project management staff.

• Project : ICICI Bank Technology Team | Head Quarters India
• Environment and Tools : Oracle , TSYS – Prime/Online/ Channel Payment

Responsibilities:

• Design and construction of PL - SQL Scripts, Procedures, Packages Middleware API and Imobile interfaces API performance and functionality Checks.
• Internet banking API’s handling / UAT Scenario / Multiple Interfaces or channels transactions Verifications.
• Doing Creation and mapping of Scheme code / Global Parameter / Rewards /GL and entire product setup of CTL prime (rewards/ Txn fee/ service fee / service chains / statement etc.).
• Adjusted design parameters to boost performance and incorporate new features.
• Documented software design, detected faults, project planning discrepancies and other vital data.

• Project : Stride Bank (MS SQL Developer)
• Environment & Tools : MSSQL Server, Batch Scripts, Power Shell, Azure, Mainframe API Development
• Responsibilities:
• Development prospective code written related to ADC, Fee Reversal, Multicurrency wallets.  From this project more orientation towards data base performance and feature enhancement both activities perform with DBA Team.
• As per requirement learning Cloud data base implantation (Azure) because part of Project moving to Cloud

Project : WireCard (API Developer )

Environment and Tools : SQL Server 2016, SSIS, Batch Scripts, Power shell, SVN, Soap API

Responsibilities:

• Responsible for handling issues of Core Issue, Self Service, Core Money, Core CMS, Core Admin Portals and new enhancements in Self Service and Core Money API's which takes Leads in Mainframe Systems development using SQL Server and DBBIDE (one of Mainframe System Development IDE).
• Handling Self Service Portal ( Internet Banking Portal ) and their issues like as User level and perform various activities like Money transfers, PIN Change, Balance Enquiry, Statements, Password Policy Mgmt., Card Lock/Unlock, Backup Card related activity and profile update etc.
• Through using web API Code or SQL Server and tested it for correctness.  Enhanced real-world system operation by standardizing production and field installation processes.

Project : Prepaid Processing

Environment and Tools : SQL Server 2016, SSIS, Batch Scripts, Power Shell

Responsibilities:

• Design and construction of SQL Scripts, Stored Procedures, Batch scripts.
• Worked on Transaction processing settlement files and reconciliation files from various Transaction Processor like Visa, Master card, Pulse, Star, Discover.
• Production support for processing data and to resolve production issues and client Tickets causing delays,Involved in daily meetings with clients and onsite/offshore Team members.
• Revised and updated old code bases which includes Stored Procedures, Dynamic Queries and Indexes etc.
• Using T- SQL to boost performance and incorporated new features which reduced operating costs.