Vijay Lonkar Email & Phone Number

Pune, Mh, In

Pune, Maharashtra, India

Pune, Maharashtra

Pune Area, India

Technology:C#, Angular, ASP.NET, RESTful Web Services, SQL Server, JSON, LINQRole Highlights:• Managed mission critical “Organization Sync” utility using ASP.NET, RESTful APIs and SQL Server that allows clients to sync their organization structure with the Sapience product.• Developed Certification test with responsive UI to evaluate users’ knowledge about the product using Angular, Bootstrap, ASP.NET Web APIs, and JSON.• Built end-to-end functionality of “SapienceWorld” retail web site using ASP.NET, RESTful APIs, and SQL Server that allows individual users to use consumer version of the product.• Exposed product functionality to mobile app users for seamless data integration using RESTful Web services.• Integrated PayPal “Pay Now” button and implemented asynchronous Instant Payment Notification (IPN) along with Payment Data Transfer (PDT) to add redundancy to the payment processing.• Implemented sign-in with Facebook, LinkedIn, and Google using oAuth REST APIs for painless user registration that resulted in increased user enrollment.Page

Technology:ASP.NET, VB.NET, ADO.NET, AJAX, LINQ, SQL Server 2008, SSIS, Syncfusion, Paypal Payment GatewayRole Highlights:• Managed end-to-end functionality of “eCerts” retail web site that helps reduce withholding taxes on investment for beneficial owners.• Automated importing of client's monthly transaction files using SSIS and multi threaded .NET application that resulted in increased volume of data processing.• Evaluated multiple third party tools based on techno functional features, cost, usability, ease of implementation and recommended “Syncfusion” for creating PDF tax documents.• Designed a process of implementing bar coding with 16 unique characters for each document with scope for future enhancements.• Integrated Paypal credit card payment module for use in different GlobeTax web sites.• Implemented strategies to enforce standard companywide coding structure by creating centralized libraries for various functions including active directory, database access, email, exception handling, PDF document creation, credit card payment etc.• Accelerated processing of data cached on app server by using LINQ for typed dataset.• Enhanced security of the system by using SQLCLR to encrypt client confidential information.• Improved database availability and recovery capabilities by implementing SQL Mirroring.

Technology:ASP.NET, C#, VB.NET, ADO.NET, XML, XSLT, Oracle 9.2, PL / SQL, Excel-VBA.Role Highlights:• Designed and developed “PAC” system for analyzing point-of-sales data of different J&J products across US.• Developed a system to map vendor’s performance attributes data with J&J’s own performance criteria for presentation to senior management.• Implemented product dashboard system for vendors to view different J&J pharmaceutical products and compare them by various parameters.• Redesigned existing “projection and risk assessment” client server system to multi layer system by adding business layer to improve performance and maintenance.• Enhanced consumption reports by caching frequently used data on web server using XML and XSLT.• Created a centralized library using ADO.NET for efficient data access to Oracle backend.

Technology:ASP.NET, C#, ADO.NET, XML, Visual Basic 6.0, SQL Server 2000, ASP, ADO, COM+, Excel, Crystal Reports 9.0, Obout Tree Control.Role Highlights:• Developed components of Risk Management system that detects conflicts in pursuing business opportunities with prospective clients in accordance to Sarbanes–Oxley Act.• Implemented a process to integrate Dun & Bradstreet monthly accounting partnership data with KPMG data by developing “Inbound process”.• Implemented “Affiliate Tool” that allows business users to view and edit hierarchical structure of their affiliates.• Enhanced user experience by optimizing rendering for tree with more than 2000 nodes using XML.• Created accounting reports and deployed them on Crystal Enterprise Server for faster execution.

Technology:Visual Basic 6.0, SQL Server 2000, ASP, ADO, COM+, MSMQ, Access, Excel, Crystal Reports 8.0 - 9.0, SoftArtisans, Sheridan and Farpoint components, RoboHelp.Role Highlights:• Developed a web site that allows a Kumon franchisee to manage his / her center allowing him / her to enroll a new student, set the progress goal and evaluate their performance. • Managed data sharing among various databases using SQL Server DTS packages, distributed queries, user defined functions and triggers.• Created excel template to facilitate entry of monthly student progress data.• Created region wise month end financial reports for US market.• For enhanced user interface used a few third-party components like SoftArtisans mailing component, Sheridan Active Toolbars, Farpoint Spread Designer, RoboHelp etc.

Technology:Microsoft .NET, VB.NET, ADO.NET, XML Web Services, Visual Basic 6.0, ASP, CSS, SQL Server 7.0, COM, MTS, Erwin, Windows DNA.Role Highlights:• Implemented Iris Scan technology to automate user authentication on the web site.• Migrated classic ASP COM web site to ASP.NET. Used Microsoft .Net interoperability services to communicate between non-compatible components.• Improved the site performance by moving part of the ASP code to business objects.

Technology:Visual Basic 6.0, ASP, MSMQ, XML, SQL Server 2000, ADO, ADO-Ex, COM+, ActiveX Documents, Crystal Reports 7.0, Windows DNA, Windows 2000.Role Highlights:• Designed and developed various modules for enhancement of distribution and fulfillment system of BarnesandNoble.com.• Established asynchronous connection between two database servers by using MSMQ, SQL server’s XML feature, ADO-Ex and COM+ Shared property manager.• Created a link between UPS and BarnesandNoble for ease of order tracking using XML.

Technology:Visual Basic 6.0, ASP, CSS, MTS, SQL Server 7.0, ActiveX DLL, ADO, VBScript, JavaScript, IIS 5.0, Crystal Reports 8.0, Erwin, Windows DNA, Windows 2000.Role Outline:Design, Development and Implementation of NYCTRAC - a messaging system between Mayor’s personnel and company liaisons in the “Emergency Operations Center” of NYC Mayor’s “Office of emergency management”.

Technology:Visual Basic 6.0, SQL Server 7.0, ADO, ActiveX DLL, DCOM, Excel.Role Outline:Design, Development and Implementation of Quote System - a trading system comprising of customer inquiry, vendor selection and quote to the customers.

Technology:Visual C++ 4.0, MFC 4.0, AutoCAD ARX Library, Visual Basic 4.0, Design Post, MS-Access 7.0, Windows NT 3.51.Role Outline:Development and Implementation of a CAD system that automates drawing generation of pipes and accessories in a hydroelectric power station.

Technology:FoxPro, M.S. Dos.Role Outline:Implementation of "MTTR Analysis" system used to calculate mean time to restore an engine.

Bachelor Of Engineering (B.E.), Automobile Engineering

Post Graduate Diploma, Advanced Computing