Now you can Instantly Chat with Ravi Kishor!
About Me
I have 12+ Years of experience on MS-Technologies and am expertise in the areas of Web/Windows Application development, Database management, Unit Testing, Deployment, Application Support and maintenance. Well versed with Agile/Scrum development metho...
Show MoreSkills
Portfolio Projects
Description
Import Payable Tracking System which will help user in the import payment tracking process including capture, enrichment, reviewing and managing the import payment information for the clients. Bank of America’s Import Payment Tracking System will provide below mention benefits;
- Streamline the payment tracking process
- Web-based portal
- Comprehensive query capability
- Reduction in operating costs especially with regard to manpower
Description
New Web application developed from scratch which implement workflow to allow BOA clients to initiate Trade/Treasury payments & upload supporting documents to justify their payments. The client uploaded documents are then reviewed and approved by the Operations team. Clients can then provide funding detail for approved payments. Then system generates Payment instruction file to do the actual payment on Global Banking system using CashPro channel. This application used in bank’s daily operation.
Show More Show LessDescription
Web application developed from scratch to keep track of the Stock of different packs. The pack is a product that is supplied by the company to customers. This is done through various masters and transactions. This application has been remediated from VB6 Windows application to .NET web application. The following information is maintained using this system.
- The new packs are defined in the system using masters. The price, tax information and discount offered for these packs are also maintained using the masters. The customer information is maintained using customer master. Each customer belongs to some specific rate area, which is managed by Area Sales Manager. The information about Area Sales Manager and Area Sales Officer is also maintained through masters.
- The transaction details are maintained through various transactions like, the details about packs sent to other location is maintained through Dispatch Advice transaction. The invoice transaction is used to keep details of packs sold to customer. The Stock receipt advice transaction is used to keep track of Stocks of different packs received from other location. The stock journal transaction is used to transfer Stock of one pack to same pack but under different promotion or different batch or different sub status.
- Created several analytics-based reports to aid upper management in decision making.
- Production support for application. GST Tax calculation related enhancements.
Description
IPTS help user in the import payment tracking process including capture, enrichment, reviewing and managing the import payment information for provide below mention benefits;o IMPORT Vendor details & Payable transactions.o Enrichment of data for payable transactions and send the data for approval.o Generate the payment batches and other associated letters/ documents.o Edit Payment batch details and mark enriched payable them as Closed.o Generate different reports at day end and send as specified alerts emails.o Generate files which is imported into sub system for client reporting deployed at Client.o Generate payment detail file for Client (Samsung), external system (SAP).o Query/MIS Reports & User & Group ManagementDeveloped Console application (Scheduler Engine)/ Windows Services which is integrated with this web application that send email notification once a payment is initiated/approved/review to email ids specified in Notification master maintenance. Alert Report are also generated by this console application and send to email which is provided on Alert master maintenance module.This application interact with other application to POST/GET data using Web Service, RESTful API .Developed ASP.NET based client interface to schedule the report frequency and custom data filters. Interface for ad hoc report generation is also provided. Reports format is CSV, Excel, PDF.This application has admin module which provide real time role-based user management.This application has Global Module for master data maintenance at customer level which is onboarded on this application.This application used in banks daily operation.
Show More Show LessDescription
This is a windows client server application developed from scratch which implement workflow on Nestle MOGA factory to automate the process of milk reception, consumption and product standardization basis on the recipe/constituent master data maintained in system.
- Automate Milk Reception (Through Tankers and Churns).
- Keep track of opening and closing balance of Milk.
- Provide Automated Standardization solution for FAT/SNF/Protein based recipe.
- Provide an interface between Standardization and Disposition.
- Calculate the Loss/Gain Qty. of the ingredients.
- MIS Reporting for disposition.
- User access to any module in application is provided through real time role-based user management and authorization.
- Production support and enhancements of functionality which is discussed and finalized.
Description
Reco-Flex is one platform that will cater across windows and web application integrated with each other. This system allows user to define various template which would be the blueprint for the type of data being uploaded into the system and the way it is reconciled and aged. The data would be uploaded into the system by applying the Account Type and Data Source templates on them. For exception cases, the user can manually input the data into the system. Once the data has been uploaded into the system, it is now ready for processing. The processing of data consists of Account Reconciliation, Transaction Write-off, Explode Transactions and Implode Transactions, Soft Closure, Final Closure. This System consists of following modules:Data Import/ Export from MS-Excel, CSV, XML, Fixed Length File,Account, Data Source and Recon TemplateMatched Transaction processing, Outstanding Transaction processingAnalyze Outstanding Transaction & Various reconciliation related reports
Show More Show LessDescription
The primary objective of this live web application to help improve Nestlés customer service level while decreasing pipeline inventory levels at the same time. Also, the objective is to align Demand & Supply Planning processes, and avoid stock out situations to ensure further sales growth for all the distributor across India.Efficient Demand Management and improvement in accuracy of the customer service levels - by generating advance orders from the customers.Better control on Inventories - through regular information and monitoring of distributor stock holdings.Effective partner relationship management by providing information on the Company new products, pricing, marketing schemes etc.Ease of ordering – Due to integrating ordering process.
Show More Show LessDescription
The key objective of this live web application to help improve Clients resource planning. Central repository for personnel information, Effective management of employee data from joining to separation and beyond. Better servicing through online MIS and timely/ accurate payroll/ claims disbursal. The System consists of following modules:Recruitment ManagementHuman ResourcesPerformance ManagementLeave ManagementAttendance ManagementPayroll ManagementBRE Management
Show More Show LessDescription
Enables the user to capture monthly Targets/Achievements for SO/ASM/BSM/BM for the various Evaluations parameters applicable.Define Criteria to evaluate sales on different parameters like Evaluation type Cumulative / Non- Cumulative, if Cumulative then Yearly/Quarterly/Monthly.Calculate incentive for all employees based on target / Achievements, weight age & frequency according to level and function of employee.Generate a Monthly Performance sheet that would contain details of Incentive amount which is to be paid to the Employee reports on the bases of dates, person money amount and organization
Show More Show LessDescription
BIAS application is an umbrella/ suite of applications that provides a unified environment for various sub-applications / modules (Central Admin, Global Master, ATM, Check Book Issue, Clearing, Form A, R-Return, Salary Upload, Vault Maintenance, TDS, ITD, eBRC, Retail, FIU, GST & new Client reporting module for OBIEE). A user may launch any of these application modules from his/her workstation provided he/she has access to those modules.Central Admin - The Central Admin sub-application of IAS mainly dealing bank branch, users, rights, etc related masters. Global Master - It mainly dealing various masters that are used in various other sub-applications (e.g. Account, Currency, Holiday, Rate etc)
Show More Show LessDescription
We create SQL procedure to extract data from the SQL/Oracle Database to export them to excel sheet for further report generation and analysis.Developed single form/Page application to generate MIS report.Web Forms Control developmentGot training on Microsoft technologiesDone Testing for Several Web Projects (Mostly User controls & Validation Testing)
Show More Show LessDescription
This application provides a unified environment of modules (Central Admin, Global Master and Client reporting module) cater across windows and web application integrated with each other. This system allows user to capture packet detail using bard code reader and track the Realtime delivery for the same. It also allows his client and customer to track the packet current delivery status.
Show More Show Less