Objective:

A challenging position in Software Design and Development that utilizes and reinforces my technical skills and abilities and to apply and gain new cutting edge skills and experience in a rapidly changing field

Background:

8+ years of total experience in the IT as software developer and analyst.
8+ years\' experience in developing and designing Windows application using technologies such as C#.NET and VB.NET
8+ years\' experience in developing and designing Web applications using web-technologies such as ASP.NET with C# and VB
8+ years\' relational databases back-end programming experience (MS SQL Server, Oracle etc.)
5+ years\' experience in developing, maintenance and enhancements of VB6 applications and migrating the application to windows applications in C#.NET and VB.NET and to ASP.NET Web application.
3+ years in developing reports using SSRS
2+ years in developing analysis reports using SSAS on OLAP and loading data into OLTP databases using SSIS.
2+ years of experience of working as an ETL developer on Informatica.
1+ year of experience with MOSS.
Experience in development of applications for Web and Windows Forms.
Experience in developing web and windows services.
Experience in working on Sharepoint portal.
Experience in implementing Agile Software Development methodologies.
Experience with AJAX, WCF, WPF, WF, LINQ.
Good organizational skills and task management abilities.
Excellent logic and decision-making skills.
Capable to work independently with minimal supervision.
Good Team player with analytical and communication skills.

Technical Skills:
Windows Development:
.NET 3.5/2.0/1.1, VB.NET, C#.NET, MVC, C, Visual Basic 6.0, WinServices, MultiThreading

Web Development:
.NET 3.5/2.0/1.1, ASP.NET, HTML,DHTML, XHTML, CSS, XML, XSLT &
XPATH,UML, Web Services, WSDL, JavaScript, WCF, WF, WPF,VB Script,
JScript,Java Script,.Net Remoting, ASP,ADO.NET,ODP.NET,AJAX,OOPs,
SOAP, Enterprise Library(3.5/2.0), XPATH, LINQ,MSMQ, Telerik Controls,
Infragistics

Database:
Microsoft SQL Server 2005/2000(SSRS,SSIS,SSAS,DTS), Oracle 10G/9i/8i
(Creating Stored Procedures, Packages, Triggers, Cursors, OLAP, OLTP)

Web/Application Servers: IIS 6.0

Tools:
Visual Studio 2005/2008, Visual Studio Team Suite 2008, Visual Studio Tools for
office, MS Visual Source Safe (VSS), Toad, PL/SQL Developer,Application
Xtender, Bugzilla, SharePoint, Microsoft Office(Word, Excel, Access,
PowerPoint), Microsoft Exchange - Outlook and Windows Communicator, Usage
of AntiVirus(McAfee and Norton)

OS: Windows 2000/2003/XP

ETL Tools: Informatica

Relevant Skills:
Software Development for Windows.
Software Development for Web.
Client-Server / Multi-Tier Applications Development.
SQL Server Developer

Project : Shared Services
Date: 11/2007 - 08/2009
Company: Confidential, Cincinnati, OH
Position: Sr. Programmer Analyst
Team Size: 6

Development and maintenance of the existing Mercantile Credit Card VB6 applications and migrating them to the Windows application andcreating a new Web application (using C#.NET and VB.NET) and upgrading the SQL Server 2000 to 2005. Designing and developing the significant new functionality that will enhance the system. There are three different applications that are currently being migrated - SmartWorks (Workflow), Credit Decision Workstation and Customer Service Workstation.
SmartWorks application will direct the various customer and merchant disputed transactions and as well as various fraud transactions for example on the amount, billing etc to the customer representative. The representative will resolve the issue with the fixed time limit depending on the type of dispute reported.
Credit Decision Workstation will either approve or reject the credit application of the customer or the merchant based on the Credit report and various other calculated parameters.
Customer Service Workstation is the heart of the system that holds the customer information either account or address or previous address credit repot etc.

Windows application development done in Credit Decision Workstation using C#.NET
Windows application development done in SmartWorks using VB.NET

Web application development on a new interface for the end users using ASP.NET and interfacing the same for the internal users with the Windows application using Windows authentication.
New web application has been designed to be opened from the windows application.

Responsibilities:

• Gathering the requirements from the business based on the business inputs for some of the projects.
• Participating in the business calls and preparing the functional specification document for the current application as well as for various enhancements projects.
• Preparing the technical documentation for the migrating project as well as the existing application for maintenance and enhancement projects.
• Designing and implementing the new features using ASP.NET 2005 by adding the new functionality to this application.
• Providing L0 and L1 estimates for the project.
• Worked on maintenance and enhancements of VB6 projects for the existing apps.
• Designing User Interface for both Windows Forms applications (using VB and C#).
• Designed reusable components in the Windows application development.
• Developed programs utilizing the multithreading concepts when using the Application Xtender third party component assembly for scanning and storing the documents.
• Designed components with multithreading using C# as well as VB in both the projects.
• Started to implement the WF logic flow in the SmartWorks windows application for the approval of disputes at various levels for resolution of it.
• Developing the new Web application using VB.NET (C#.NET for other application) and ASP.NET.
• Developed the Web Application using the AJAX controls along with the ASP.NET controls.
• Used the AJAX control kit and to provide the extender AJAX control properties to the existing ASP.NET controls.
• Developing the web forms and win forms depending on the functionality and developing over 100 forms in SmartWorks application alone.
• Developing business logic components as a middle-tier between database and the presentation logic.
• Developing the application messaging communicator for the business to communicate between them.
• Usage of client side validation controls, regular expressions.
• Implementation of the themes and master pages in developing the web pages.
• Implementation of authorization roles across the application for accessing the various pages.
• Providing estimates for the project based on the enhancement requirement for the business.
• Creating a rich user interface using the Windows Presentation Foundation application and integrating with the existing developed windows forms.
• Creating styles and control templates using the WPF XAML code.
• Creating a training application for the business users by integrating the audio files using WPF.
• Developing the process flow using the Work Flow foundation for the business to operate efficiently.
• Developed 15 different Work flows for the business representative's automated process.
• Developed both sequential and state machine workflows.
• Created 3 different webservices one for pulling the credit bureau report statistics, the other for the account information and lastly the transaction information for each account used for processing by the representatives using Windows Communication Foundation (WCF).
• An Impersonation account has been created on the server by the administrator to call these services from the application.
• Code files versioning is maintained in ClearCase, VSS was used an year before for the same files.
• Developing the new database objects such as tables, triggers and indexes that are necessary for the new requirements.
• Involved in the database up-gradation to SQL Server 2008 from SQL Server 2000.
• Creating triggers and constraints to provide data integrity to the database.
• Extensive coding of stored procedures, views, and triggers in MS-SQL Server.
• Optimizing the existing queries by creating the indexes.
• Developed reports using the SQL Server Reporting Services, created matrix reports and interactive sorting reports using various filters.
• Developed reports using SQL Analysis services by creating DataSourceViews, cubes and measure groups as well as dimensions necessary for the reports and integrated with the SSRS.
• Created a reports using MDX queries.
• Involved in moving the DTS packages to the new SSIS in 2005 Server and setting up of a SQL Server Agent Job that runs every morning.
• Created 2 new flows in the SSIS for loading data into the OLTP database in SQL Server.
• Extensive usage of the T-SQL queries for developing the logic.
• Supporting the nightly batch load process to SQL Server 2005 in the application for reporting purposes.
• Developing the data diagrams for the current 2005 database.
• Provided the Stored procedures and functions to the front developers of the VB for integration with the application database.
• Maintaining the lookup table information for the current Credit Decision Workstation in the MS Access Database and migrating the MS Access data to SQL Server database.
• Usage of Crystal Reports in Credit Decision Workstation.
• Providing the option to the user to pull the reports to the MS Excel.
• Using the SCRUM and the RAD methods (and following TDD in critical phases) and releasing the applications every sprint and getting the inputs from the business and then implementing the changes and the new requirements going forward.
• This is an Onsite - Offshore model with majority of work at onsite.
• Developed an internal Sharepoint website using MOSS 2007 for project activities and departmental activities.
• Providing the production support for the business using the existing applications by following the service center tickets raised.

Environment:
Windows XP, MS.NET (Visual Studio 2008/2005, C#.NET, VB.NET, ASP.NET, Framework 3.5/2.0), Windows Forms, LINQ, WPF, WF, WCF, SOA, TCP/IP, Multithreading, WF, Web Forms, ADO.NET, CSS, JavaScript, SQL Server 2008, T - SQL, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, MS Access, Enterprise Library 3.0 - Logging block, MS Excel, IIS 6.0, HTML, XHTML, DHTML, VB6, Clear Case, XML, XSLT, XSD, AJAX, VBScript,OLTP,OLAP,DB2, MS Exchange Outlook and Windows Communicator, MS Access, VST for Office.

Project : Change Order Application
Date: 01/2006 - 10/2007
Company: Confidential, Schaumburg, IL
Position: Sr. Developer
Team Size: 5

Change Order maintains the information of all Change Order Requests raised in Motorola by various departments. This application is used for create Change Requests on various available products on existing sales orders. This application also facilitates the approval process for each Change Order Request. Smart drop downs, front end validations help the users in minimizing the efforts to complete a COR. User can also generate various reports and export the results to excel spreadsheets which can be used for data analysis.

Responsibilities:

• Gathering the requirements from the business and participating in the business clarification calls.
• Played a key role in architecting the site
• Developing the functional and writing the technical documentation.
• Developed a 3 tire architecture for implementing the business logic.
• Developing front-end parts and the User Interface Web Forms in ASP.NET and C#
• Designing the flow of process for the approval of the change order requests.
• Created a WebService to pull the previous order details of the customer applied for the new change order for verification.
• Developing the Unit test plan and unit testing the application.
• Maintaining the versioning of the code in VSS
• Execution of manual test cases.
• Tracking the test cases using Bugzilla
• Designing normalized data schemas using MS SQL Server 2005.
• Developing the relational data base diagrams.
• Provided technical support to internal developers and external clients
• Creating various data objects - tables, trigger, constraints, stored procedures, user defined functions and special software roles based on the business requirements.
• Involved in Schema Optimization and performance improvement.
• Maintenance of these large databases.
• Implemented the Client/Server Architecture.
• Developing the reports using the SQL Server Reporting Services.
• Maintained all records of project status and followed changes as per control procedures
• Maintaining the messages sent by the customer during the request of the change order in Microsoft Message Queue and processing them using the XML de-serializer.
• Developing the flow diagrams in the Visio.
• Providing on call support using the Remedy ticket system.

Environment:
Windows XP, MS.NET (Visual Studio 2005, C#, VB, ASP.NET), ADO.NET, SQL Server 2005, CSS, VSS,MS Visio, IIS, Java Script, VB Script, SQL Reporting Services, T - SQL, HTML,DHTML, Bugzilla, MS Exchange Outlook and Windows Communicator, WebService

Project : Quality Information Systems
Date: 05/2005 - 02/2006
Company: Confidential, Schaumburg, IL
Position: Lead programmer
Team Size: 4

Confidential, is in its process of continuous Improvement of Quality of its products and evolving Quality Management system, for TL9000 Certification. CHS envisions a Quality Information System (QIS) to facilitate the TL9000 Metrics. This QIS application is entirely Motorola Internal Use. The QIS website is a 3-tier web based application involving User Interface, Business Logic, Data Access. The data warehousing (ETL) tool Informatica is used for loading the data from different databases into the repository (called QIS repository, which is an Oracle database). For every metric to be calculated in measuring the quality for the TL9000 a different flow has to be created. Some of the TL9000 Metrics are NPR, FRT, OF, OTD, FR and SWIM/SWU.

Responsibilities:

• Played a key role in architecting the site.
• Discussing with the business on the various requirement analysis.
• Writing the functional and the technical documentation.
• Involved in a 3 tire architecture development of the client application in the ASP.NET using C#
• Developed a User Interface application in Windows Forms for internal product managers review analysis of the Metrics.
• Designing User Interface (C#, Web Forms), developing front-end parts.
• Developed a WebService to pull the various orders information and the metrics information for the regions.
• Developing unit test plan and unit test cases
• Developed database design basing on the business requirements.
• Designed the normalized data tables for the repository in Oracle.
• Created the data diagrams ERDs for the tables and created the relationships.
• Created the new database objects - tables, views, stored procedures, triggers, packages, user defined functions and user tables to define the roles in the database.
• Creating maps in the Informatica for extracting data from various systems and loading it to repository (Oracle)
• Creating workflows in the Informatica for the schedule loads to the repository
• Wrote and maintained the database documentation.

Environment:
Windows XP, .Net FrameWork 2.0, MS.NET (Visual Studio .NET 2005, C#.NET, ASP.NET), Oracle 9i, IIS, Informatica, HTML, CSS,XML,ODP.NET,DHTML, MS Exchange Outlook and Windows Communicator, WebService

Project : Motorola Online
Date: 05/2003 - 03/2005
Company: Confidential, Schaumburg, IL
Position: Developer
Team Size: 4

This is a shopping cart (eCommerce) application written in VB and ASP and later partially migrated to .net. This is using Commerce Server to manage transactions using the MS SQL Server 2000 database. Being ASP to ASP.net development and migration project, needs to have good understanding of various approaches to achieve this in an efficient way. This n-tier application supports multiple cultures (globalization/localization).

Responsibilities:

• Analyzed the requirements, studied the existing system working closely with the client.
• Designed and developed the "Made Sales" module of MOL.net application based on the prototype using ASP.net and VB.net.
• Designed components with multithreading using VB.NET.
• Played key role in integration with existing ASP pages and reusing COM components.
• Prepared a prototype and data model using ERDs and later implemented them.
• Developed complex SQL queries, stored procedures, views, triggers, user defined functions and packages
• Assisted in troubleshooting and resolution of database issues
• Identified performance bottlenecks, analyzed and improved the performance, using indexing techniques with Index tuning wizard, SQL Trace.

Environment:
Windows XP, .Net FrameWork 1.1, MS.NET (Visual Studio .NET 2003, VB.NET, ASP.NET), ADO.NET, VSS, Oracle 9i, IIS, VB Script,VB6,ASP,ADO,ODP.NET, WebServices, SOAP, XML,HTML, DHTML, MS Exchange Outlook and Windows Communicator,Enterprise Library 2.0 - Data Application Block and Logging block.

Project : Intranet Web AR Redesign
Date: 05/2002 - 04/2003
Company: Confidential, Schaumburg, IL
Position: Developer
Team Size: 6

This is a globalized secure intranet web application (HTTPS - HTTP over TLS/SSL) that aids management in taking decisions based on current Accounts and Receivables. The data for the
Accounts and Receivable are maintained in the SQL Server 2000 database. This is implemented in two phases with first phase consists of the account functionality of the Accounts database and Receivables database. On the client side the application consists of multiple level reports and user maintenance screens.
It provides user-friendly interface for viewing, editing and downloading the report content.

Responsibilities:

• Involved in architecting the site the new site as per the existing one.
• Interacted closely with the client for gathering and analyzing the business requirements, developing prototypes/user interfaces, estimating and planning.
• Designed the tables and the relationships based on the requirements specified.
• Created various database objects and the complex queries.
• Assisted in Integration and Quality Assurance testing.
• Assisted in clarifying and resolving the database related issues.
• Designed and created tables, stored procedures and functions using the ERDs prepared during analysis, identified performance bottlenecks, analyzed and improved the performance using indexing techniques with Index tuning wizard, SQL Trace.
• Implemented basic framework for the tiers and a DataAccess layer and assisting the team in implementing other tiers.
• Implemented VB Script for validations across various forms.
• Created interfaces and class inheritance hierarchy for different types of reports.
• Created and refined reusable components like 'download to Excel'.
• For maintaining the code files VSS has been used.
• Maintenance of the database which is more than 700GB

Environment:
.Net Framework 1.1, Microsoft Visual Studio 2003, C#.NET, ASP.NET, ADO.NET, HTML, VBScript, SQL Server 2000, T - SQL, VSS, Windows 2003 Server, IIS, XHTML, MS Exchange Outlook and Windows Communicator

Project : Shopping Cart
Date: 07/2001 - 04/2002
Company: Confidential, Chennai, India
Position: Developer
Team Size: 3

Computer Shoppe is an online shopping cart application through which one can register and buy various software and hardware products available. Available options and UI differ based on whether the logged in user is an employee or customer.

Responsibilities:

• Analysed the requirements and designed and developed the web pages for user registration, login and shopping cart state management.
• Separated logic into tiers and wrote base interfaces and classes for business logic and error handling components.
• Wrote test cases and tested the modules in all the phases of implementation.

Environment:
.Net framework 1.0, VS.NET IDE (VB.NET, ASP.NET), Oracle 8i, XML, Windows 2000 Server

Education:
BE in Electrical and Electronics Engineering

Certification: Completed IZ0-007 Oracle Certification level 1 in OCA
BrainBench certification in C#