• Project: Inventory Management System Tax Deeds Application, Case Management System, Set Court Date over Web, Dissolution of Marriage Data, E Citation Automation, Document Converter Tool, Core Admin Tool, E File Statics, Import and Merging Data from one system to other system, Various SQL Jobs for automation, Data Analysis, Middleware applications Financial Reports. Inventory Management System - User: Systems Management & Recording
• IMS is a Web Application for inventory management, it is used for maintaining inventory and automating check-in and checkout process, Systems use this application to maintain inventory clerk wide and Recording department keeps an inventory of files of evidence, there is functionality to update the inventory from external csv file, along with basic CRUD functionality there is huge Report Repository which provides various reports to the user. Environment: MVC 4.0, C#, ASP.NET, HTML 5 CSS3, Bootstrap 3, JQuery, SQL Server 2012, SSRS, Entity Frame Work, VS 2015 Responsibilities:
• Involved in Requirement gathering.
• Created ASP.Net MVC Models as business objects, controllers to implement the business logic and MVC Razor Views for UI.
• Responsible for design and development of Web User Interface using Bootstrap, JQuery, HTML 5, CSS3, ASP.NET MVC and business objects using C# . Net.
• Worked on Data Repository using Entity Frame Work and LINQ.
• Created database objects in Microsoft SQL Server.
• Tested the system with VS Test Project, wrote several test cases.
• Created SSRS reports and configured at Report Server. Internal Knowledge Base:
• It is web application and is used by clerk wide.
• It is a system to keep SOPs, Manuals, User Case, Release Notes at one place, to generate SOP a template is designed for all departments, which is populated by the fields entered by the user, user is allowed to download the template and work off line, it creates an entry for the SOP in the database, user can come back to upload the SOP document but user will be able to upload the document which is created by the system.
• It is role based application and has security for different departments. Functionality involves CRUD functionality for documents.
• Application has extensive Search functionality implemented with SQL full text search feature which involves to search several combination of key and SQL full text Search functionality to search for key words with OR/AND combinations.
• Environment: ASP.NET, C#, HTML5, JQuery, JavaScript, ASPOSE, GD Picture, SQL Full text search, Signal R, SQL Server2012 Tax Deeds Application- User : Tax Deed Department Tax Deeds application integrates and automate different functionalities of the tax deeds department pre-sale and post-sale process.
• Designed functionality to receive pre-sale data (XML File) from real auction site, imported and verified property and party data, party data encapsulate fee automation which saved user to key in a lot of information and verification process.
• This functionality significantly enhanced the productivity of tax deeds department and brought quarterly sale to a monthly sale.
• Certified Mail: designed a Windows job to generate different notices for a particular sale job generates notices FTP those notices to external Certified Mail agency updates notice's image in the database and emails to Tax Deeds department and agency about the generation of notice.
• To initiate the whole process user just have to select the type of notice and sale date. Auto updating images of notices to the database saves a lot of manual scanning. Another service updates signature files from parties to the database.
• Reports -developed reports, tax deeds documents with auto saving functionality to the database.
• Designed WPF UI, developed WCF service to interact with database in C#.
• Automated fee calculation, payment calculation, disbursement process and surplus process. Environment: Interface designed in WPF, Service WCF, C#, SQL Server 2008/2012/2014, Infragistics Reports 2012.2 and GD Picture 9.0.Aspose for Word, SSRS 2014, and Visual Studio 2012/2013/2015. Set Court Date Over Web - User : Public User
• Web application for public, user is able to set court date for the traffic citation with citation number\ DL number and date of birth. User's request communicates with service and work flow used sets the court date.
• A notice of appearance is generated on the user screen. Wrote a back end process to update the docket line to main database (Show Case). Environment: ASP.NET, C#, HTML 5 and CSS3 Java Script, AJAX, SQL Server 2012, Infragistics UI, ASPOSE WORDS, Visual Studio 2013, SQL Jobs, Reports and Data Analysis.

• Project: National Poison Data System (NPDS) The American Association of Poison Control Centers is a non-profit, national organization.
• The nation's 60 poison centers as well as other poison-related organizations are members of American Association of Poison Control Centers. Whole integrated system is called National Poison Data System (NPDS).
• All poison centers upload their data file 24/7 to AAPCC server, which is processed and monitored continuously .These data files are binary files, there was no system to read or write binary files.
• Files were processed through integrated system with BizTalk. Designed a system to generate binary files which are kind of replica of the binary files sent by poison centers which in turn helped a to the development team test the business logic to consume the data files and polish validation logic which triggers respective alerts and notification.
• Developed the user interface through ASP.NET Web Forms and the code behind files in C#. Developed web user controls
• Built secured Web Services for Authentication of clients and return processed data, which is used by External systems other than AAPCC.
• Designed various Reports using SSRS 2005/2008.
• Wrote stored procedures, including dynamic queries using T-SQL for data retrieval and data manipulation.
• Managed Configuration Management.
• Developed Engines and Notification Alerts for surveillance and sending out email to the subscribed users.

Environment: C#, VB.NET, ASP.NET 2.0/3.5, IIS 6.0/7.0, SQL Server 2005/2008, SQL, Visual Studio .NET 2003/2005/2008 VB Script, Java Script SSIS - Microsoft Reporting Services

• The system has Receipts Module, Product Movement Module, and Shipment Modules etc. Receipts Module handles the creation of P.O (Purchase Order) and Receipts.
• Each shipment is given a unique identification number in the form of Bar Codes. In the Product Movement Module once the shipment is stored in any of the Warehouses its movement from one Warehouse to other is traced.
• Shipment Module handles the final delivery to the customer. System also generates Current Stock, Goods In, Goods Out, Shipment Movement Reports and Day-to-Day Dispatch Reports etc.
• XTRACK takes orders from customers and generates optimized solutions to obtain raw materials from the suppliers and deliver Finished Goods to the customers in fast and cost effective manner.
• Involved in the design and development of Material Planning and the Warehouse Control modules and requirement analysis & requirement gathering
• Designing & Development using ASP.NET, C#, VB Script, Java Script
• Created DLLs to implement business logic and to integrate the application.
• Involved in database implementation, creating tables, stored procedures, views using SQL. Performed Unit & Integration testing plans.
• Generating Reports using Crystal Reports 7.0/8.0 and SSRS Reports.

Environment: C#, VB.NET, ASP.NET 2.0, IIS 6.0, SQL Server 2005, SQL, Visual Studio .NET 2003/2005/2008 VB Script Java Script SSIS - Microsoft Reporting Services 2005/2008.