Janmejay Patil

LOADER CREATION

• Engineered application to consume the data of excel files, convert it into XML and store it in database tables using stored procedures.
• Using MVC framework for streamlining the application and making use of javascript AJAX calls to call the action methods of respective controllers.
• Achieved encapsulation by creating a unit class which makes all the relative calls to database for database transactions.
• Exercised the functionalities of OpenXML to scale with the data present in excel files.
• One click activity to process multiple records and update master tables, previously being done manually using test scripts.
• Maker-Checker functionalities to maintain the integrity of data being uploaded.

AUTO-MANAUL CROP

• Cropping a signature document by using inbuilt functionalities of .NET framework.
• Retrieving the form document based on either Customer Number or Scan Serial Number, if not providing proper alert.
• Checking if the file exists on te retrieved path, fetching file in local folder for processing.
• If retrieved file is in PDF format, converting it into JPEG for cropping, processing the converted file for cropping, threshold of cropped as to be less than 16 KB, if not compressing the file, creating JSON format to pass processed file to pass it to bank API to save, if it returns Error Code as 0, saving the cropped file on server using FTP and storing path along with flags, customer number, scan serial number, etc into log database.
• If Error Code is other than 0, passing the file for manual cropping.
• Manual crop provides a functionality of Maker-Checker, wherein maker crops signature file manually using JCrop of JavaScript.
• This cropped file is stored into the application hosting environment on temporary basis, when checker retrieves the file to check, the user is being displayed with original form and cropped image to confirm and approve, once approved the cropped file is saved on server using FTP and the path along with flags, customer number, scan serial number, etc are stored into log database.

BSE BOND

• Scaled the application functionalities to make it more bug free by using OOPS coding approach and .NET Frameworks 4.5 and above.
• Provisions on exchange login to update attributes as per the exchange team requirements by creating Stored Procedures in SQL.
• Development and deployment of SEBI requirements in a month of time, which includes adding new pages and providing functionalities using C# or VB code, HTML, CSS, JavaScript, jQuery, etc.
• Development and fixations of the security patches of the application as per the SEBI audit by applying encryption properties provided by .NET framework.

TRADING SYSTEM

• Development on charter using C# and .NET 5 to understand the market movements, development based on historical data.
• Development of indicators or signals using C# code to notify the user on where to enter the market based on historical data captured in excel files.
• Creating a live excel file of the symbols using collections which will run on Pre-Market data by applying certain subsets of filters and using those symbols for trading in Intra-Market.
• The file obtained from the program is being used for trading symbols and on average used to make $100-$150 per day.