SUMMARY

• Over 9 years of IT experience with 5+ years in .NET Technologies.
• Proven years of experience in software design, development, testing and implementation of various client server, intranet and Internet applications.
• Experienced in working on projects using Waterfall, Agile (Scrum, Extreme Programming & Test Driven Development) Methodologies.
• Extensive knowledge in .NET Framework, ASP.NET, VB.NET and C#.
• Expertise in developing Web Services application and XML, XSD handling using .NET Framework
• Worked extensively in SQL Server and Oracle database design.
• Experienced in developing Constraints, Indexes, Views, DTS Packages, Stored Procedures, Cursors, Triggers and User Defined Functions on SQL Server and Oracle databases.
• Worked extensively in developing and implementing Crystal reports.
• Experienced in classic ASP and Visual Basic programming.
• Have excellent interpersonal skills, proactive, well organized, efficient, a team player and foster collaborative work environment.
• Experienced in System Testing, User Acceptance testing UAT, Functionality Testing, Integration Testing and Regression Testing.
• Proven ability to work efficiently in both independent and team work environments.
• Known for his ability to multi-task and work on different applications at the same time.

TECHNICAL SKILLS

Operating System: Windows 2003/2000/XP/NT, Novell
Languages / Software Tools: AP.Net, VB.Net, C#, Visual Basic 6/5, Crystal Reports, Infragistics 6.2 controls, Visio 2000, Video soft Flex Grid 6.0
Framework: Microsoft.Net Framework 2.0,3.0,3.5
Web Technologies / Middleware: ASP.Net 2.0, Web Services, AJAX, SOAP, CSS, XML, XSD, XSLT, COM, DCOM, SOA, VB Script, JavaScript
Back-ends: MS SQL Server 2005/2003/2000,, Oracle 9i/8.0, MS Access 2000
Configuration Mgt System: VSS, Perforce
Business Process Application: INFOR PM 10.0
Tools: Crystal Reports 10/9/8, Infragistics Controls
Control Management Tools: Microsoft Office Sharepoint Server 2007
MS-Office: MS-Word, MS-Excel, MS-PowerPoint

Employer: Confidential, MD
Project: Research Initiative Management System (RIMS)
Duration: Mar 08 – Present
Role: Senior Software Developer
Environment: Windows Server 2003/XP, C#, ASP.NET, .NET Framework 3.0, ADO.NET, SQL Server 2008, XML, XSL, INFOR PM 10.0, JavaScript, Excel VBA, JSON, Web Service

Description: NIAID conducts and supports basic and applied research to better understand, treat, and ultimately prevent infectious, immunologic, and allergic diseases. For this purpose there are 4 program offices, they prepare the research initiatives with mechanism of grants, contracts and critical infrastructure. These research initiatives are developed under three mission areas namely AIDS, Bio-defense and IID. Every initiative prepared is maintained in RIMS. Each initiative will have a scheduling plan of allotment and a funding plan. The funding plan is created in scenarios like -2% increment, 0% increment or +2% increments and the dollar amount against these scenarios are maintained in RIMS Budget module. The scheduling plan of allotment is maintained in RIMS Scheduling module. The application from various Government and non-Government research institutes are verified and reviewed. Based on the report the initiative will be allotted. The user can create, discuss and finalize a project plan in RIMS – Scheduling for each research initiative. The user can generate a resource chart from RIMS – Scheduling.

Responsibilities:

• Developed the RIMS application using ASP.NET and C#.
• Designed and developed views using INFOR PM View Manger for data capturing and designed structure for view manager using INFOR PM Architect.
• Developed XSD schemas and XML files to communicate between different modules.
• Designed SQL Server database and developed Stored procedures, User Defined Functions, Views, Indexes and Triggers.
• Created macros using Excel VBA to import the data as structure into INFOR PM Architect.
• Customized the Export to Excel function in INFOR PM to accommodate the comments added to the data cells using ASP.NET.
• Involved in identifying, Creating/sizing user stories from the requirement documents using agile development methodologies.
• Involved in creating Version Description Document and application deployment.
• Unit Tested the application using TestDriven.NET
• Project was done using Agile methodology.
• Complex reports were generated using Crystal Reports 10.
• Managed project tracking information and Bug Reporting documents using Microsoft Office SharePoint Server 2007.
• Interacted with client to collect user requirements.
• Prepared and updated documentation for user manual.

Employer: Confidential, MD
Project: Clinical Data Entry and Query System – (CDEQ)
Duration: Oct 07 – Feb 08
Role: Senior Software Developer
Environment: Windows Server 2003/XP, C#, ASP.NET, .NET Framework 3.0, ADO.NET, SQL Server 2005, XML, XSL, INFOR PM 10.0, Excel Service, HP Quality Center

Description: CDEQ is based on Infor PM (previously known as Infor MPC), a commercial-off-the-shelf (COTS) software package created by Infor Confidential This technology is being deployed as an enterprise platform at NIAID to provide web-based spreadsheet functionality in web-based applications. This package helps the user in entering data about each animal which they use for their researches. It gives details about their health, CBC and lymphocytes. This system also interacts with another system called Monkey Business through DTS packages and collects data of the animals. The Query Module built in this system helps the users in generating their reports faster. Excel services is used for generating graphs

Responsibilities:

• Developed customized modules in ASP.NET.
• Developed business components with C#.
• Created Stored Procedures, Indexes, Functions and Views in SQL Server database.
• To interact with SQL Server and update data from a different server, created DTS Packages.
• Created views using INFOR PM View Manager to build web pages for data entry.
• Responsible for documenting all the Unit test results and Unit test cases.
• Responsible for writing the SQL queries for back-end testing.
• Unit Tested the application using TestDriven.NET
• Weekly 16 hours of application user support.
• Project was done using Agile methodology.
• Actively participed in enhancement meetings focused at making the application more reliable and also responsible for submitting daily report status.
• Performed manual testing for the execution of large number of test cases and also done the Integration Testing to ensure that every module works together as a whole.

Employer: Confidential, Washington, DC
Project: Trade Automation, Cash and Fund Management System
Duration: Oct 04 – Sept 07
Environment: Windows Server 2003/XP, ASP.NET,C#, .NET Framework 1.0, ADO.NET, SQL Server 2003, Crystal Report 10.0, XML, XSL, Net Advantage Infragistics 6.2 controls, Visual Source Safe

Description: This software is used for uploading trade data from various trading agencies. The system approves the data after verifying with the master data. It uploads data from a remote server and the same is processed for enrichment and checked for data integrity. It throws out an exception for records which does not match with the master data. This software also records all the details of the loan instruments and generates the funds repayment schedule for the loans taken for working capital. The projected funds flow takes into account the funds required for settlement of the trade and the repayment of the loan taken for working capital. Bank Statements are recorded and automatic reconciliation is scheduled by the system. MIS reports like brokerage, turnover, daily trade etc., are generated by this System.

Responsibilities:

• Developed the application using ASP.Net.
• Created .NET Windows Forms, Web Forms and Classes.
• Created Components for Business Blocks in C# and Data Access Blocks.
• Developed Business Blocks which provides interface to the UI Block.
• Created Tables, Stored Procedures, Functions and Views in SQL Server database.
• Created user controls using Net Advantage Infragistics controls.
• Generated Reports/Sub Reports using Crystal Reports 10, XML.
• Interaction with the users in collecting requirements.
• Involved in supporting help-desk and solving all tickets raised.
• Involved in Back-end activities of Scheduling night jobs.

Employer: Confidential, Mumbai, India
Project: Warehouse Management System (WMS)
Duration: Apr 04 – Aug 04
Environment: Windows Server 2003/XP, ASP.NET,C#, NET Framework 1.0, ADO.NET, SQL Server 2003, Oracle Apps, TOAD, CISCO VPN Client, Crystal Report 10.0, XML, XSL Net Advantage Infragistics 6.2 controls, Source Safe

Description: Designed and developed web based WMS application. It is designed for small to medium warehouses. It captures the purchases, receiving, sales order, inventory and shipping. Some of the features were RFID scanning and Barcode / RFID label printing capability to improve inventory control. Maintains and manages vendor and customer contact information, including multiple ship-to address and customizable reports.

Responsibilities:

• Assisted in designing the Sql Server database.
• Created ASP.NET Pages, User Controls and C# Classes.
• Created .NET Components for Business Layer and Data Access Layer.
• Created DTS Packages, Tables and Stored Procedures, Triggers, Functions, Views, users, roles and indexes in SQL Server 2003.
• Developed .NET Assemblies using C# & ADO.NET.
• Developed XML data structures, XSD Schemas & XSL Style sheets.
• Generated Reports/Sub Reports using Crystal Report, XML, XSL and EXCEL.
• Created Backup and Maintenance Plan for SQL server Database.
• Generated Reports/Sub Reports using Crystal Reports 8.5

Employer: Confidential, Mumbai, India
Project: Inventory Management System (IMS)
Duration: Jan 04 – Mar 04
Environment: Windows Server 2003/XP, ASP.NET, C#, .NET Framework, ADO.NET, SQL Server 2003 & Crystal Report 8.5, Net Advantage Infragistics 4.2 controls, Visual Source Safe

Description: The main objective behind developing this system is to provide an integrated system that controls and improves the inventory control. This system is also expected to give costing information of the spares to the finance information. Some of the features of this systems were handling multiple warehouses, RFID support, Labels for UPS, FedEx, Airborne, Inter warehouse transfer, Min/Max Quantity per warehouse, creating your own reports with crystal reports, export any report into excel/RTF/PDF etc.

Responsibilities:

• Assisted in designing the Sql Server database
• Created Tables, Stored Procedures, Triggers, Functions and Views in SQL Server database.
• Created ASP.Net Pages, User controls and Classes.
• Created .Net Components for Business Layer and Data Access Layer with C#.
• Developed .NET Assemblies using C# & ADO.NET.
• Generated Reports/Sub Reports using Crystal Reports 8.5
• Developed Export Utilities which loads data into MS EXCEL & XML.
• Developed Utilities which converts and loads purchase order data from SQL Server to MS WORD.

Employer: Confidential, Mumbai, India
Project: Purchase Requisition & Purchase Order Recording System (PRPO) – Oracle Interface
Duration: Sep 03 – Dec 03
Environment: Windows Server 2000, VB .NET, .NET Framework, ADO.NET, SQL Server 2000, Oracle Apps, TOAD, Crystal Report 10.0, XML, XSL, Net Advantage Infragistics 4.2 controls, VSS

Description: After the implementation of Oracle apps, certain functions, which were performed in standalone PRPO, were transferred to Oracle. This resulted in fractured data storage and impossible to get the reports as they were available earlier. The intention was to integrate PRPO with Oracle apps seamlessly so that all information and reporting requirements are met as they were prior to Oracle apps implementation.

Responsibilities:

• Participated in designing the database for PRPO in SQL Server.
• Created Tables, Stored Procedures, Functions and Views in SQL Server database.
• Created interface between SQL Server 2000 and Oracle Apps using ADO.NET
• Migrated data from SQL Server to Oracle.
• Created Stored Procedures in SQL Server 2000 to import data from Oracle Apps.
• Created User controls, Win Forms and Classes.
• Created .Net Components for Business Layer and Data Access Layer.
• Created Packages in Oracle to validate the data posted onto the temporary tables.
• Generated Reports/Sub Reports using Crystal Reports 10.0.
• Generated XML, Comma Delimited out put files which feeds into another financial application.

Employer: Confidential, Mumbai, India
Duration: Apr 2000 – Aug 03
Projects: Integrated Data of Accounting & Leasing System (IDEALS): Windows NT 4.0, Visual Basic 6.0, SQL Server 7.0 & Crystal Report 7.0
Consumer Durable Information System (CDIS): Visual Basic 6.0, SQL Server 7.0, NT 4.0, ASP, SQL Server 7.0 & Crystal Report 7.0