Professional Summary

• 9 years of experience in all phases of Software Development Life Cycle (SDLC)
• Performedsystem analysis and design, system development, integration, installation, deployment, and client interaction
• Development of Client/Server applications, Web applications and Windows Services
• Strong programming skills and development experience in VB.Net, ASP.Net, ADO.Net, Visual Basic 6 and WinCC
• Proficient with Web Application Development using HTML, CSS, XML, JavaScript, VBScript, AJAX
• Extensive experience in data modeling and database designing with MSSQL server and MS Access databases
• Experienced in T-SQL programming including complex SQL Queries, Stored Procedures and Triggers
• Design and implementation of Reporting service layer using SQL Server Reporting Service and Crystal Reports
• Experience in customization of Microsoft Dynamic Retail Management System and Microsoft Small Business Financials
• Migration of application from VS2005 to VS2008 and database from SQL 2005 to SQL2008. IIS setup from 6.0 to 7.0
• Implemented and supported Systems at Client's site under extreme deadlines
• Experience managing a project from concept to implementation
• Strong analytical and problem solving, interpersonal, communication and presentation skills

• Tools and Technologies: Visual Studio.Net 2005/2008, VB.Net, ASP.Net 2.0/3.5, ADO.Net, AJAX, C#, Visual Basic 6.0,COM/DCOM, ADO/DAO, CSS, Web Services, Windows Services, IIS 6/7, WSDL, SOAP, SIMATIC WinCC, VB Script, Java Script, HTML, XML, FoxPro 2.5, dotnet framework 2.0/3.0/3.5, SSIS
• Databases: MS SQL Server 2000/2005/2008, Oracle 10g, MS Access
• Reporting Tools: SQL Server Reporting Service 2005/2008, Crystal Report
• Products: SharePoint 2010, Microsoft Small Business Manager 7.5/9, Microsoft Retail Management System 2.0, NitroSell Integrated eCommerce, Point of Sale, Microsoft Exchange Server, Active Directory Services
• Operating Systems: Windowsserver 2008/2003, Windows 7/XP

Project Details:

Project Name: Avanti Dailies
Duration: Sep 2011 - May 2013
Technologies: ASP.Net 3.5, SIMATIC WinCC, Small Business Financials 9, SQL Server 2008, SQL Server Reporting Service 2008, AJAX, JavaScript, HTML, CSS, Outlook 2010, Crystal Report, SharePoint 2010, Microsoft Exchange Server, Active Directory Services, Windows Service, IIS 7.0

Project Description:

Custom web application to achieve functionalities for the production process and accounting.

• Online Price quotes with conversion of various units. Price quote report using SSRS.
• Inventory control with auto email system when item falls below predefined stock levels.
• Process visualization with plant intelligence using WinCC by capturing data from Siemens PLC and save it to SQL using VBScript. Modified forms and Tag as per requirement. Developed trends/graph from captured data log. Various temperature limit modification and screen color changes in Siemens panel & project through WinCC and Step7.
• Contingency PO processor to facilitate order executed in advance.
• Parts Change web formwith picture link of the part replaced to maintain records.
• Auto email notification to purchase officer for resin railcar and resin stock based on resin reading.
• STP break at zone report to assist locating zone break frequently occurred in machine.
• Sales Supplement report with the calculation of price per pound, kg, linear-yard, square-yard, linear-meter, square-meter and production specification for accuracy in each order.
• Setup web server with application server role, IIS and corresponding virtual directories. Migration from windows server 2003 to windows server 2008. IP address setup to RDP for internal and external address.
• Setup SQL linked server to get SQL data from WinCC Siemens to webserver through two network cards.
• Web based (internet) label printing through third party software Bartender. Installation and integration of Seagull Bartender to in house web application to achieve wireless label printing
• Created different SharePoint libraries to receive documents and picture through email. Imported names of the documents through windows service and SharePoint 2010 client object model. Displayed documents into internal website so that accessible to everyone in the office.
• Utility to open and display various training PPT files &Standard Operating Procedure PDFs.
• Gross profit & loss report with comparison of shipment cost, price & freight charges by date, purchase order, invoice#, customer PO and customer.
• Created domain account in Microsoft Active Directory Service.
• Email account created at Microsoft exchange server.

Roles and Responsibilities:

• Requirement gathering and analysis
• System designing based on OOAD
• Development of system based on N-tier architecture in .NET technology (framework 3.5) separating business layer, data access layer and presentation layer
• Supervisory control and data acquisition(SCADA) andhuman-machine interface(HMI) system using SIMATIC WinCC for process visualization with plant intelligence by capturing data log in SQL and providing trends.
• Enabling data capture of Siemens PLC through WinCC to SQL Server to apply data log for process visualization.
• Developed web forms using FormView, GridView and DetailsView in ASP.net
• Database designing in SQLServer2008 based on normalization guidelines
• Leveraging AJAX technology for ease of usage and to improve speed and performance
• Designing web-based reports using SQL Server Reporting Service
• Installation and deployment of application
• System maintenance and production support
• Enabled multi-browser support (IE, Mozilla Firefox, Google Chrome, Safari)
• Enabling application support for mobile devices
• Migration of application from VS2005 to VS2008 and database from SQL 2005 to SQL2008.

Project Name: SBM Add-on System
Duration: Nov 2008 - Aug 2011
Technologies: ASP.Net 3.5/2, Small Business Financials 9, SQL Server 2005/2008, SQL Server Reporting Service 2005/2008, AJAX, JavaScript, HTML, CSS, PDF viewer, Outlook 2007/2010, Crystal Report, SharePoint 2010, IIS 6.0

Project Description:

Integrating SBM business and database layer to custom web application to achieve additional functionalities.

• Tracking arrival notice and original bill of lading for the shipment.
• Generating reports like Importer Security Filing, Custom cover page based on custom duty and email notification for logistic.
• Production re-ordering with drag and drop using AJAX controls
• Auto calculation of balanced jumbo, production time remaining, estimated order completion date based on re-ordering.
• Tensile strength, basic weight and tear test reading report and conversion to multiple units with summary of max, min, stddev. User can select tabbing option within GridView.
• Quality control report with details of raw material used, vendor details, produced by user and machine settings during production of each master roll.
• Auto email notification to user responsible for label error on material.
• Shipment pictures saved to SharePoint and available to website for office and customers with multiple pictures view.
• Web based account receivable, profit and loss, aging and cash flow reports.
• Chart for sales analysis, net-worth, shift production and machine breaks developed in SQL Server Reporting Service with matrix data report.
• Shift notes for every shift developed with GridView and FormView.
• GridView, DetailsView for Master-detail records with data bound control.
• Tracking user activity and log for each webpage access.
• Associates information with timesheet.
• Estimated salary calculation based on timesheet and payroll report.
• Tracking physical receiving of goods and storage information.
• Reports for individual machine operator for next production and machine settings.
• Open order/ Intransit/ Item report for customers with online tracking.
• Railcar unload developed with nested GridView.
• Windows service to download PDF from email, extraction of data to the system.
• Processing attachment with pictures using Outlook API.
• Migration of application and database from VS2005 to VS2008.
• Browsing file listing in GridView for viewing.
• Customizing report template in SBM
• Shutdown task,task achieved for activities required during maintenance and reports.

Roles and Responsibilities:

• Understanding the existing business processes, requirement gathering and analysis
• Process improvements by business process re-engineering
• Developed web forms using FormView, GridView and DetailsView
• Database designing in SQL Server 2005 based on normalization guidelines
• Enhanced webpage functionality using AJAX controls
• Designing web-based reports using SSRS
• Seamless integration with Microsoft Small Business Financials for Purchase and Accounting modules
• Integration with SharePoint for shipment details and logistic reports
• Installation and deployment of application
• User training and production support

Project Name: Multiple Projects
Duration: December 2006- May 2007
Technologies: ASP.Net 1.1, RMS, SQL Server 2005, VB.Net, XML, SQL Server 2000

Project Description:

People Pop-up Add-On: Streamline the check-out process and speed up POS entry with auto-population of customer records.
Connect with internet databases to search for a customer\'s information based on phone number.
Create a new customer record automatically in the database based on search findings and associate the pending sale with the new customer record.

Credit Card Add-On: The requirement was to extract the holder name from the Credit Card magnetic field during the sale tender of the RMS POS and print it on the receipt. This was achieved through RMS customization wherein the hook was configured to notify the Credit Card swipe event.

Integrating web-orders with RMS using NitroSell eCommerce:

Confidential. is a Microsoft Certified partner providing Microsoft Retail Management System. Microsoft RMS is a Retail POS / Inventory Control Application. RMSHelper.com website was designed and maintained using NitroSell eCommerce. When a web-order is received, NSC (NitroSell eCommerce) email generates auto emails for order-status and auto updates to the web customers. An Implementation and synchronization of data between RMS database and Web store is designed with NSC .
NitroSell Integrator integrates online store into RMS and works with eCommerce solution providers. Download orders from the shopping cart database and populate payment information, customer data, transaction items, taxes and shipping charges in RMS. Sync Company's stock levels, descriptions, and pictures automatically.

Roles and Responsibilities:

• Designing the system
• Creation of web store
• Integrating the web store with RMS
• System testing
• User Training

Project Name: Microsoft Dynamics RMS (Retail Management System) 2.0 Customization and software development.
Duration: September 2006 - November 2006
Technologies: RMS 2.0, XML, HTML,SQL server 2000

Project Description:

Confidential is a Microsoft Certified partner providing Microsoft Retail Management System. Diviasoft's Client CH Martin was using the Microsoft RMS software for managing its 15 stores and 2 warehouses and Headquarters system.
The client required customization of RMS application to suit their specific business needs. The project includes creation of a custom Purchasing system that enabled the Purchase order entry for all stores / warehouse through a custom window. The POS thus created were then sent to the stores / warehouse from the Microsoft Headquarters and the worksheets were created. Also was involved in the customization of Receipt templates, Purchase Order templates, Inventory Transfer templates, Work Order templates, Quote templates, as per client requirement. The customization was through modifications in XML and HTML files.

Roles and Responsibilities:

• Requirement gathering and analyses
• Design the component
• Integration of the component with RMS
• Testing and implementation
• Defined SQL queries and Stored Procedure

Project Name: Email Integrator for SBM
Duration: June 2006 - August 2006
Technologies: Microsoft Small Business Manager 7.5, Vb.net

Project Description:

The objective was to create an add-on for the MS Small Business Manager that copies the Quote, Order or Invoice as an email in the MS Outlook.

With this add-on, when a Quote / Order / Invoice is opened in Customer module, it would display an additional "Email Document in HTML format" menu. When clicked on this menu, its event is captured. Based on the document type and document number, its corresponding data is pulled from database, an HTML document with pre-defined format is created in memory, MS Outlook application is invoked and a draft email is created with the HTML document as the body of the email along with party\'s email address.

Roles and Responsibilities:

• Requirement gathering and analyses
• Designing the add-On
• Development of add-on using VB.net
• Testing
• Preparing the implementation guide
• Preparing the user guide

Technologies: VB.net, SQL server 2000, Crystal Reports, Visual Basic 6.0, MS Access

Accounting System: Dentamatix Dental Laboratory is involved in fabricating of dental prosthesis work, making of fixed, implant and cosmetic dentistry work. This system deals with the job work taken from various clients i.e.dentists.Issuing and printing of challans& bills etc.
AMCOS (Activity Management of Co-Operative Housing Society): This software is developed to maintain the overall Activity and Account Management for the Co-operative Society. This package covers the activities of society like Transfer of flats, Split of flats, generation and printing of bills, letters and documentation. And accounts includes the payments and receipts from flat members as well as other parties, issue of vouchers, preparation of ledgers, trial balance, income & expenditure account and balance sheet.
Quotation, Proforma Invoice & Challan Printing: Shree Lalita is a sole distributor for a foreign based company and it deals with safety equipment. This package was developed to prepare the quotations for their products, Proforma invoice linked with quotation, challans linked with Proforma invoice and printing reports for the same.
Financial Accounting with Inventory Control: This package deals with company\'s financial accounts and its Inventories. It has Masters like Group, General, Debtor, Creditor, Product, Unit, Tax etc. Transactions include Purchase, Sales, Purchase Return, Sales Return, Cash & Bank, Contra entries, Journal Vouchers etc. Other House Keeping modules like Create a New Company, Select a Company etc. Package also includes various Reports such as Aging wise Debtor / Creditors Outstanding Report, Detailed / Summary Stock report with rates, Parties ledger account, Trial balance, Profit & loss A/c. & Balance Sheet
Stock Maintenance: Autolink is a dealer & Service station for two-wheelers. This package is used to prepare job card for the vehicles came in for repairs and servicing. It has reports like Inventory, History Card, Yearly Contract Services, Contract Renewal Reminders, Monthly workshop Performance reports.
Inventory Control System: Mira Enterprises is a franchise of Monginis, a well-known Brand in Cakes and other eatable items. This package is made mainly to arrive at the sales figure (Daily Sales Report) through the stock book, purchases and variations.
Order Processing System: This system is developed to capture information about Order booking, order execution and generates outstanding related to order execution for different clients.
Cable Operator System: Orbit Cable is a cable operator located at Santacruz, Mumbai. This package deals with the List of Subscribers, Complaint Register, Attended Complaint, Temporary and Permanent Disconnection, Consumption of Products, Payment Mode and Reminder Letters.
TDS System: This system is developed for a firm engaged in construction activities. The system is aimed to process data and calculate tax and issue Tax Deducted at Source (TDS) certificates. And it covers the different categories of TDS, TDS Entry, and prints Form 16, 16A, 26A, and 26K.
Export Documentation Printing System: Dadda Gems is an award winner diamond company in Mumbai. This system mainly deals with preparation and printing of export documentation such as export invoices, shipping bills, packaging list, bank covering note etc

• Diploma in Electronics Engineering from P.V. Polytechnic, Mumbai, India (4 years course including 1 year of internship).

Microsoft Certified Professional (MCP) in Designing and Implementing Desktop Application with Microsoft Visual Basic 6.0