Summary of Experience

• 12 years of Total IT experience in analyzing, design, development, management, maintenance of Web and Client/Server based applications.
• 5 years of experience in developing web / windows based applications on .Net framework 4.0, 3.5 & 2.0 using ASP.NET, C#.Net, VB.Net and SQL Server databases.
• Senior Technical Consultant / Designer for ASP.NET Application Development / SQL Server Database management.
• Application Development and customization, Test Driven Development of Applications, Report Development and customization, Data migration, Functional implementation in Sales, Purchase, Inventory, Manufacturing, Telecom Service, Accounts Receivables, Accounts Payables, General Ledger & Logistics management.
• Skills used: Visual Studio 2010 ,2008 & 2005, ADO.net, SQL Server 2008 & 2005, ASP.net, XML, XSLT, HTML,CSS, JQuery, JavaScript, Team Foundation Server 2010, Crystal Reports, SSIS, SQLServer Import & Export Data utility, MS Excel-Pivot Table , OLAP
• Expertise in implementing web based applications using 3-tier architecture.
• Extensive experience in SQL Database design, maintenance and performance tuning, developing SQL queries/scripts, stored procedures, database views, index, user defined functions and triggers using SQL Server & Oracle databases
• Good knowledge of ASP.NET MVC framework
• Good analysis and problem-solving skills to understand Business information requirements & analysis, General Project Management, Technical support for end-users, Data Analysis. Customer/ Vendor Management. Understanding of SDLC, design and testing
• Good experience in business domains like Inventory/Sales/Purchase, Finance, Telecom Customer service.
• Business Objects (XI-R2) Consultant experience for managing Universes, Crystal Reports, DeskIntelligence & WebIntelligence reports & charts.

Skills Profile

Environment

ASP.net, VB.net, C#, ADO.net, Business Objects-XI-R2, Crystal Reports, jQuery, HTML, CSS, JavaScript, Visual Basic 6.0 ,MS Excel Charts

RDBMS

SQL Server 2008, 2005, ORACLE 8i,9i MS Access

Development Tools

Microsoft Visual Studio 2010 , 2008 & 2005, SQL Server Management Studio 2008 & 2005 , Business Objects-XI-R2

Operating System

Windows 7, Windows XP, Windows 2000

Business Domains

Distribution & Logistics, Manufacturing, IT Service

Professional Experience: Project Highlights

Confidential,GA [July 2011- till date]
Web & Console Applications for drivers’ license customer service using service oriented architecture, interfaces to IBM mainframe system, Document management system, FTP Flat file processing for PDF & images
Project : Online services for Driver\'s License and ID Cards
Public facing web application with UI developed for customer services including current status, reinstatement, renewal, address change, commercial & teen driver license. Development of business & data layers to support multiple applications. Developed & consumed web service to verify customer data from mainframe.
Environment : .NET framework 3.5, VB.net, SQLServer 2008, Microsoft Visual Studio 2008, HTML, CSS, jQuery, WCF Web services, Microsoft Reports
Role : Senior Programmer Analyst

Project : Documentation Checklist Wizard for new Secure IDLicense and Identification Card.
Design & Development of UI pages, created dynamically based on user input & data from the database. Dynamic building of web controls & validating those controls with user input. User is allowed to save their selections as PDF.
Environment : .NET framework 4.0, VB.net, SQLServer 2008, Microsoft Visual Studio 2010, HTML,CSS, JavaScript, MS Excel, Microsoft Reports
Role : Team Leader for a team of 5

Project : Batch processing of Motor Vehicle History Inquiry from Insurance Agencies.
Environment : .NET framework 4.0, VB.net, SQLServer 2008, FTP, XML, Microsoft Visual Studio 2010 , MS Excel.
Role : Senior Programmer Analyst

Project : Batch processing of Certified Mails from USPS FTP server.
Environment :.NET framework 4.0, VB.net, SQLServer 2008, FTP , Microsoft Visual Studio 2010, Crystal Reports for .NET Framework 4.0
Role : Senior Programmer Analyst
Responsibility:

• Design & Development: Involved in page design, dynamic creation of web pages & prototyping using ASP.NET.
• Designed & build application ,business & data layers using VB.NET
• Extensively used GridView, FormView, DetailView controls in all transaction pages.
• Build & consumed WCF WebServices to interface with the mainframe system.
• Implemented Application Security according to the designation level of employees.
• Developed interfaces using VB.net to connect to third party software in the customer service.
• Application configuration using XML
• Data migration using XML files into SQL database.
• Database designing , stored procedure development ,test data creation in SQL 2008
• Testing: IT plans development, Unit Testing, Client site testing.
• Implementation & Support: Involved in application packaging, implementation internal & online servers.

Confidential,Columbus -OH [Sep2010-Feb2011]

• Project Name : Distribution Logistics & Inventory system

Environment : ASP.NET framework 4.0, ADO.net, SQLServer 2008, SQL Server Reporting Services ,Microsoft Visual Web Developer 2010, HTML,CSS, JavaScript, MS Excel, Business Objects-XIR2
Role : Senior Technical Consultant
Responsibility:

• ­Involved in Interface design of web application from Design to Implementation of Online system for Sales, Purchase, Inventory management, Accounts Receivables & Payables using Visual Studio 2008 , ASP.NET & VB.net , Business objects for reports & charts.
• Business analysis: Requirement analysis
• Design & Development: Involved in screen design & prototyping.
• Server-side validations using Vb.net code behind.
• Implemented Master page allow centralize the common functionality of the pages
• Implemented Application Security according to the designation level of employees.
• Extensively used GridView, FormView, DetailView controls in all transaction pages.
• Production support & handled post implementation issues for application developed in C#, ASP.net
• Application Migration from Visual Basic 6 to VB.net for the sales management module with 6 pages and 4 detail & summary reports.
• UI development of product data uploaded by external interfaces, using XML,XSLT,xpath
• Database Design & Data Migration from MS Excel using SQLServer Import Export (SSIS)
• Customize and generate Excel for data export from online reports.
• Product Master Creation with product Type, Category and Brand, Purchase Order Generation, Receipt of New products, Stock transfer receipt Supplier Payments, Finished goods delivery, Returnable products tracking , Customer Master & Supplier Master Creation.
• Generation of Goods Receipt Note, GatePass, Stock statements with weighted average method
• Inward and Outward Data Analysis Reports
• Testing: IT plans development, Client site testing.
• Implementation & Support: Involved in application packaging, implementation in Inventory Department and given 2nd level technical support for application and database.

Confidential,Houston [Jan2010-Aug2010]

• Project Name : Online Logistics & Repair System for mobile & laptop service

Environment : ASP.NET framework 3.5, ADO.net, SQLServer 2008, SQL Server Reporting Services ,Microsoft Visual Web Developer 2008, HTML,CSS, Windows XP,MS Access, MS Excel , Business Objects-XIR2
Role : Senior Programmer Analyst
Responsibility:

• ­Development , Implementation & Rollout of Online system for mobile & laptop service industry (L4 level) with the following modules using Visual Web Developer 2008 tool for ASP.NET:-
• Customer/ASP Call Logging with automatic WorkOrder generation
• Tracking pickup of defective from customer place.
• Receipt of Defective Materials and locating Re-Repair cases against IMEI number
• Assigning Defective to Engineer according to the model received.
• Updating Repair Centre details with components used.
• Automatic Estimated Repair Price calculation with component cost, transportation cost, taxes and margin
• Estimation approval by customer/ASP
• Invoice and GatePass generation
• Dispatching good material to customer/ASP
• Production support & handled post implementation issues for application developed in C#, ASP.net
• ASP, Model, Courier Master Maintenance
• Customize and generate Excel for data export from online reports.
• Requirements gathering by interacting with various departments across branches.
• Designing of database structure in the online SQLServer 2008 database with Master tables
• Customer/ASP Master, Models, Address master , Components
• and transaction tables
• Inputs, Customer Issues, Repair Details, Repair Center Issues
• Data migration of legacy system data from MS Access, MS Excel to online SQL Server 2008 database.
• Routine backup of Data using SQLServer Import & Export Utility

Confidential,GA [Feb2009-Nov2009]

Environment : ASP.NET framework 3.0, ADO.net, SQLServer 2008, SQL Server Reporting Services , Microsoft Visual Web Developer 2008, HTML,CSS, JavaScript, Windows XP,MS Access, MS Excel
Role : Senior Software Engineer
Responsible for:

• Business analysis: Requirement analysis, Use case Development
• Design & Development: Involved in screen design & prototyping for the following modules.
• Product Master Creation with product Type, Category and Brand Purchase Order Generation, Receipt of New products, Stock transfer receipt Supplier Payments, Finished goods delivery, Returnable products tracking
• Next numbering for Goods Receipt Note, Delivery Note, Stock statements with weighted average method
• Inward and Outward Analysis
• Testing: IT plans development, Client site testing.
• Implementation & Support: Involved in application packaging, implementation in Inventory Department

Confidential,NY [May2008-Dec2008]

• Project Name : McNeilus Online Logistics implementation

Environment : ASP.NET framework 3.0, ADO.net, SQLServer 2005, SQL Server Reporting Services, Microsoft Visual Web Developer 2008, HTML,CSS ,JavaScript, MS Access, MS Excel
Role : Senior Technical Consultant
Responsibility:

• Business analysis: Member of the requirements collection team, End user interview, Use case development.
• Design & Development: Involved in screen design & prototyping , development for the following modules.
• Customer Demand forwarding and processing
• Material Planning
• Job Creation and Processing in Test and Repair Center.
• Procurement of components and finished parts.
• Generations of various types of daily and MIS Reports.
• Various Types of Demand Booking Analysis
• Testing: Prepared unit and integration test plans for the modules I developed, Reviewed others test plans against requirements, Team Leader in User acceptance testing.
• Implementation & Support: Involved in application packaging, implementation in various onsite sites, User accounts creation (set up). Team leader in defects tracking and resolution

Confidential,Ashland, MA [July2007-Mar2008]

• Project Name : Inventory Control System

Environment : ASP.NET framework 3.0, ADO.net, SQLServer 2005, SQL Server Reporting Services ,Microsoft Visual Web Developer 2008, Windows XP,MS Access, MS Excel
Role : Senior Technical Consultant
Responsibility:

• Business analysis: Requirement analysis, Use case Development
• Design & Development: Involved in screen design & prototyping for the following modules.
• Product Master Creation with product Type, Category and Brand Purchase Order Generation, Receipt of New products, Stock transfer receipt Supplier Payments, Finished goods delivery, Returnable products tracking
• Next numbering for Goods Receipt Note, GatePass, Stock statements with weighted average method
• Inward and Outward Analysis
• Testing: IT plans development. Client site testing.
• Implementation & Support: : Involved in application packaging, implementation in Inventory Department

Confidential,NJ [Sep2006-May2007]

• Project Name Multi Source Feedback

Environment: ASP.NET framework 3.0, ADO.net, Visual Studio, SQL Server, SQL Server Reporting Services , Crystal Reports, MS Excel, HTML,CSS, JavaScript, Windows XP
Project: Multi Source Feedback is feedback system built for Pfizer® Consumer HealthCare colleagues. Colleagues were asked to get feedback from 8 colleagues every year before the yearly performance review. It could be peers, managers or direct reports. This feedback is consolidated on the cutoff date and the report is sent to the manager and the colleague. The report forms part of the discussion at yearly performance review.
Roles/Responsibilities:

• Designed The Application.
• Extensively involved developing using ASP.net, HTML, VB, SQL
• Developed Stored Procedures and Triggers.
• Created Reports with Crystal Reports and exported the reported to PDF and Excel outputs.